DBA Data[Home] [Help]

APPS.HR_LOA_SS dependencies on FND_PROFILE

Line 9: g_usr_date_fmt varchar2(20) := fnd_profile.value('ICX_DATE_FORMAT_MASK');

5: g_data_error exception;
6: g_date_format constant varchar2(10):='RRRR-MM-DD';
7: g_confirm constant varchar2(9):='CONFIRMED';
8: g_planned constant varchar2(7):='PLANNED';
9: g_usr_date_fmt varchar2(20) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
10: g_usr_day_time_fmt varchar(40) := g_usr_date_fmt|| ' HH24:MI:SS';
11:
12: --2793140 change starts
13: --cursor to fetch the absence row from per_absence_attendances

Line 9266: l_sch_based_dur := NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N');

9262:
9263: --
9264: -- Bug 4534572 START
9265: --
9266: l_sch_based_dur := NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N');
9267: l_sch_based_dur_found := FALSE;
9268: --
9269: IF l_sch_based_dur = 'Y' THEN
9270: --