Fast Formula - Global Absence Entry Validation - GET_VALUE_SET Formula

Summary

GET_VALUE_SET Formula

Content

Hi,

 

I want to create a fast formula controls that if a worker has an absence type A, this worker shouldn't get any absence. To do so I created this fast formula:

 

 

l_person_id = GET_CONTEXT( PERSON_ID,0)
l_absence_type_id = GET_CONTEXT( ABSENCE_TYPE_ID,0)

 

l_person_id_char =to_char(l_person_id)

L_absence_type_id_char = to_Char(l_absence_type_id)

 

L_PARAM ='|=PERSON_ID='||l_person_id_char||'|=ASSIGNMENT_ID='||L_absence_type_id_char

 

L_RETURN_VALUE = GET_VALUE_SET('