DBA Data[Home] [Help]

APPS.HR_PERSON_ABSENCE_API dependencies on FND_PROFILE

Line 424: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then

420: --
421: -- Truncate the time portion from all IN date parameters
422: --
423:
424: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
425: hr_utility.set_location(' OTL ABS integration on ',10);
426:
427: open csr_get_abstype;
428: fetch csr_get_abstype into l_hours_or_days,l_elm_entry_id;

Line 1280: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then

1276: '---------------------------------');
1277: hr_utility.trace(' ');
1278:
1279: --
1280: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
1281:
1282:
1283: open csr_get_abstype;
1284: fetch csr_get_abstype into l_hours_or_days,l_elm_entry_id;

Line 2331: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then

2327: OPEN get_person_info;
2328: FETCH get_person_info INTO l_person_id;
2329: CLOSE get_person_info;
2330:
2331: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
2332: hr_utility.set_location(' OTL ABS integration on ',10);
2333:
2334: open csr_get_absdates;
2335: fetch csr_get_absdates into l_chk_datestart,l_chk_dateend ;

Line 2459: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then

2455: );
2456: end;
2457: --
2458: -- to delete all the pending for approval transactions data requested for OTL-HRAbsence.
2459: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
2460:
2461: hr_utility.set_location('OTL HR ABS integration is ON ', 10);
2462: hr_absutil_ss.remove_absence_transaction(p_absence_attendance_id);
2463:

Line 2981: if (NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N')='Y' AND

2977: hr_utility.set_location('p_date_start :'|| p_date_start, 20);
2978: hr_utility.set_location('p_date_end :'|| p_date_end, 20);
2979: hr_utility.set_location('p_scope :'|| p_scope, 20);
2980:
2981: if (NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N')='Y' AND
2982: NVL(FND_PROFILE.Value('PER_ABSENCE_DURATION_AUTO_OVERWRITE'),'N')='Y')
2983:
2984: then
2985:

Line 2982: NVL(FND_PROFILE.Value('PER_ABSENCE_DURATION_AUTO_OVERWRITE'),'N')='Y')

2978: hr_utility.set_location('p_date_end :'|| p_date_end, 20);
2979: hr_utility.set_location('p_scope :'|| p_scope, 20);
2980:
2981: if (NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N')='Y' AND
2982: NVL(FND_PROFILE.Value('PER_ABSENCE_DURATION_AUTO_OVERWRITE'),'N')='Y')
2983:
2984: then
2985:
2986: l_profile :='Y';

Line 2999: --if l_profile = 'Y' and nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then

2995:
2996: if p_person_id is not null and p_date_start is not null and p_date_end is not null then
2997: hr_utility.set_location('passed parameter are not null :', 10);
2998:
2999: --if l_profile = 'Y' and nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
3000: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
3001:
3002: if g_debug then
3003: hr_utility.set_location('OTL HR ABS integration is ON ', 10);

Line 3000: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then

2996: if p_person_id is not null and p_date_start is not null and p_date_end is not null then
2997: hr_utility.set_location('passed parameter are not null :', 10);
2998:
2999: --if l_profile = 'Y' and nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
3000: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' then
3001:
3002: if g_debug then
3003: hr_utility.set_location('OTL HR ABS integration is ON ', 10);
3004: end if;

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

3290: l_assignment_id := hr_person_absence_api.get_primary_assignment
3291: (p_person_id => p_person_id
3292: ,p_effective_date => p_start_date);
3293:
3294: l_sch_based_dur := NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N');
3295:
3296: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' THEN
3297: if g_debug then
3298: hr_utility.set_location(' Profile HR OTL Integ in ON ',10);

Line 3296: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' THEN

3292: ,p_effective_date => p_start_date);
3293:
3294: l_sch_based_dur := NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N');
3295:
3296: if nvl(FND_PROFILE.Value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y' THEN
3297: if g_debug then
3298: hr_utility.set_location(' Profile HR OTL Integ in ON ',10);
3299: end if;
3300: