APPS.BEN_EFC_ADJUSTMENTS dependencies on HR_API

Line 237: if nvl(p_creation_date,hr_api.g_sot)

233: p_who_counts.multtransmod_count := 0;
234: --
235: end if;
236: --
237: if nvl(p_creation_date,hr_api.g_sot)
238: <> nvl(p_last_update_date,hr_api.g_sot)
239: then
240: --
241: p_who_counts.mod_count := p_who_counts.mod_count+1;

Line 238: <> nvl(p_last_update_date,hr_api.g_sot)

234: --
235: end if;
236: --
237: if nvl(p_creation_date,hr_api.g_sot)
238: <> nvl(p_last_update_date,hr_api.g_sot)
239: then
240: --
241: p_who_counts.mod_count := p_who_counts.mod_count+1;
242: --

Line 854: if l_vpfdets.last_update_date > nvl(p_last_update_date,hr_api.g_eot)

850: p_vpfdets := l_vpfdets;
851: --
852: -- Check for modified VAPRO since LUD
853: --
854: if l_vpfdets.last_update_date > nvl(p_last_update_date,hr_api.g_eot)
855: then
856: --
857: p_faterr_code := 'VPFCORR';
858: p_faterr_type := 'CORRECTEDINFO';

Line 1370: l_esd := hr_api.g_sot;

1366: l_eed := p_val_set(ele_num).eed;
1367: --
1368: if p_val_set(ele_num).esd is null then
1369: --
1370: l_esd := hr_api.g_sot;
1371: --
1372: end if;
1373: --
1374: if p_val_set(ele_num).eed is null then

Line 1376: l_eed := hr_api.g_eot;

1372: end if;
1373: --
1374: if p_val_set(ele_num).eed is null then
1375: --
1376: l_eed := hr_api.g_eot;
1377: --
1378: end if;
1379: --
1380: insert into ben_efc_exclusions

Line 2559: if row.effective_end_date <> hr_api.g_eot

2555: end if;
2556: --
2557: -- Check for a end dated PBB
2558: --
2559: if row.effective_end_date <> hr_api.g_eot
2560: then
2561: --
2562: l_fatal_error := TRUE;
2563: l_faterr_code := 'PBBENDDATE';

Line 3676: if nvl(l_ccm_dets.last_update_date,hr_api.g_sot)

3672: then
3673: --
3674: -- Check if the CCM has been modified since the ENB was created
3675: --
3676: if nvl(l_ccm_dets.last_update_date,hr_api.g_sot)
3677: > nvl(l_efc_row.creation_date,hr_api.g_sot)
3678: then
3679: --
3680: l_faterr_code := 'CCMDTCORR';

Line 3677: > nvl(l_efc_row.creation_date,hr_api.g_sot)

3673: --
3674: -- Check if the CCM has been modified since the ENB was created
3675: --
3676: if nvl(l_ccm_dets.last_update_date,hr_api.g_sot)
3677: > nvl(l_efc_row.creation_date,hr_api.g_sot)
3678: then
3679: --
3680: l_faterr_code := 'CCMDTCORR';
3681: l_faterr_type := 'CORRECTEDINFO';

Line 4346: if nvl(l_apr.last_update_date,hr_api.g_sot)

4342: end if;
4343: --
4344: -- Check for apr mods since the actual premium was created
4345: --
4346: if nvl(l_apr.last_update_date,hr_api.g_sot)
4347: > nvl(l_efc_row.last_update_date,hr_api.g_eot)
4348: and l_faterr_code is null
4349: then
4350: --

Line 4347: > nvl(l_efc_row.last_update_date,hr_api.g_eot)

4343: --
4344: -- Check for apr mods since the actual premium was created
4345: --
4346: if nvl(l_apr.last_update_date,hr_api.g_sot)
4347: > nvl(l_efc_row.last_update_date,hr_api.g_eot)
4348: and l_faterr_code is null
4349: then
4350: --
4351: l_faterr_code := 'APREPRCORR';

Line 5532: if (nvl(l_abrdets.last_update_date,hr_api.g_sot)

5528: ,p_faterr_code => l_faterr_code
5529: ,p_faterr_type => l_faterr_type
5530: );
5531: --
5532: if (nvl(l_abrdets.last_update_date,hr_api.g_sot)
5533: > nvl(l_efc_row.last_update_date,hr_api.g_eot))
5534: and l_faterr_code is null
5535: then
5536: --

Line 5533: > nvl(l_efc_row.last_update_date,hr_api.g_eot))

5529: ,p_faterr_type => l_faterr_type
5530: );
5531: --
5532: if (nvl(l_abrdets.last_update_date,hr_api.g_sot)
5533: > nvl(l_efc_row.last_update_date,hr_api.g_eot))
5534: and l_faterr_code is null
5535: then
5536: --
5537: l_faterr_code := 'ABRCORR';