You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Absence type Validation formula

Accepted answer
105
Views
6
Comments
edited Jul 9, 2019 7:18PM in Workforce Management 6 comments

Summary

Absence type Validation formula

Content

Hi All,

When I am making Formula as listed below

CHANGE_CONTEXTS(START_DATE=l_start_date, END_DATE=l_end_date)

(

WHILE ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR.exists(i) LOOP

(

CHANGE_CONTEXTS(ABSENCE_ENTRY_ID=ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR[i])

(

if(l_absence_type_id = ANC_ABS_ENTRS_ABSENCE_TYPE_ID AND ANC_ABS_ENTRS_ABSENCE_STATUS_CD <> 'ORA_WITHDRAWN') then

(

L_Prev_Duration = L_Prev_Duration + ANC_ABS_ENTRS_DURATION

)

)

i=i+1

)

)

L_Total_Duration = L_Prev_Duration + L_Duration

l_log = ESS_LOG_WRITE(TO_CHAR(L_Total_Duration))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!