1853: ,p_pen_attribute27 => p_pen_attribute27
1854: ,p_pen_attribute28 => p_pen_attribute28
1855: ,p_pen_attribute29 => p_pen_attribute29
1856: ,p_pen_attribute30 => p_pen_attribute30
1857: ,p_request_id => fnd_global.conc_request_id
1858: ,p_program_application_id => fnd_global.prog_appl_id
1859: ,p_program_id => fnd_global.conc_program_id
1860: ,p_program_update_date => sysdate
1861: ,p_object_version_number => l_object_version_number
1854: ,p_pen_attribute28 => p_pen_attribute28
1855: ,p_pen_attribute29 => p_pen_attribute29
1856: ,p_pen_attribute30 => p_pen_attribute30
1857: ,p_request_id => fnd_global.conc_request_id
1858: ,p_program_application_id => fnd_global.prog_appl_id
1859: ,p_program_id => fnd_global.conc_program_id
1860: ,p_program_update_date => sysdate
1861: ,p_object_version_number => l_object_version_number
1862: ,p_per_in_ler_id => p_per_in_ler_id
1855: ,p_pen_attribute29 => p_pen_attribute29
1856: ,p_pen_attribute30 => p_pen_attribute30
1857: ,p_request_id => fnd_global.conc_request_id
1858: ,p_program_application_id => fnd_global.prog_appl_id
1859: ,p_program_id => fnd_global.conc_program_id
1860: ,p_program_update_date => sysdate
1861: ,p_object_version_number => l_object_version_number
1862: ,p_per_in_ler_id => p_per_in_ler_id
1863: ,p_bnft_typ_cd => p_bnft_typ_cd
1893: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id
1894: ,p_object_version_number =>
1895: l_global_epe_rec.object_version_number
1896: ,p_effective_date => p_effective_date
1897: ,p_request_id => fnd_global.conc_request_id
1898: ,p_program_application_id => fnd_global.prog_appl_id
1899: ,p_program_id => fnd_global.conc_program_id
1900: ,p_program_update_date => sysdate
1901: );
1894: ,p_object_version_number =>
1895: l_global_epe_rec.object_version_number
1896: ,p_effective_date => p_effective_date
1897: ,p_request_id => fnd_global.conc_request_id
1898: ,p_program_application_id => fnd_global.prog_appl_id
1899: ,p_program_id => fnd_global.conc_program_id
1900: ,p_program_update_date => sysdate
1901: );
1902:
1895: l_global_epe_rec.object_version_number
1896: ,p_effective_date => p_effective_date
1897: ,p_request_id => fnd_global.conc_request_id
1898: ,p_program_application_id => fnd_global.prog_appl_id
1899: ,p_program_id => fnd_global.conc_program_id
1900: ,p_program_update_date => sysdate
1901: );
1902:
1903: ben_global_enrt.reload_epe -- chc globals re-loaded after update.
2030: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id
2031: ,p_per_in_ler_id => p_per_in_ler_id
2032: ,p_business_group_id => p_business_group_id
2033: ,p_object_version_number => l_ppe.object_version_number
2034: ,p_request_id => fnd_global.conc_request_id
2035: ,p_program_application_id => fnd_global.prog_appl_id
2036: ,p_program_id => fnd_global.conc_program_id
2037: ,p_program_update_date => sysdate
2038: /* CODE PRIOR TO WWBUG: 1646442
2031: ,p_per_in_ler_id => p_per_in_ler_id
2032: ,p_business_group_id => p_business_group_id
2033: ,p_object_version_number => l_ppe.object_version_number
2034: ,p_request_id => fnd_global.conc_request_id
2035: ,p_program_application_id => fnd_global.prog_appl_id
2036: ,p_program_id => fnd_global.conc_program_id
2037: ,p_program_update_date => sysdate
2038: /* CODE PRIOR TO WWBUG: 1646442
2039: ,p_effective_date => p_effective_date
2032: ,p_business_group_id => p_business_group_id
2033: ,p_object_version_number => l_ppe.object_version_number
2034: ,p_request_id => fnd_global.conc_request_id
2035: ,p_program_application_id => fnd_global.prog_appl_id
2036: ,p_program_id => fnd_global.conc_program_id
2037: ,p_program_update_date => sysdate
2038: /* CODE PRIOR TO WWBUG: 1646442
2039: ,p_effective_date => p_effective_date
2040: ,p_datetrack_mode => l_datetrack_mode
2080: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id
2081: ,p_per_in_ler_id => p_per_in_ler_id
2082: ,p_business_group_id => p_business_group_id
2083: ,p_object_version_number => l_object_version_number
2084: ,p_request_id => fnd_global.conc_request_id
2085: ,p_program_application_id => fnd_global.prog_appl_id
2086: ,p_program_id => fnd_global.conc_program_id
2087: ,p_program_update_date => sysdate
2088: /*
2081: ,p_per_in_ler_id => p_per_in_ler_id
2082: ,p_business_group_id => p_business_group_id
2083: ,p_object_version_number => l_object_version_number
2084: ,p_request_id => fnd_global.conc_request_id
2085: ,p_program_application_id => fnd_global.prog_appl_id
2086: ,p_program_id => fnd_global.conc_program_id
2087: ,p_program_update_date => sysdate
2088: /*
2089: CODE PRIOR TO WWBUG: 1646442
2082: ,p_business_group_id => p_business_group_id
2083: ,p_object_version_number => l_object_version_number
2084: ,p_request_id => fnd_global.conc_request_id
2085: ,p_program_application_id => fnd_global.prog_appl_id
2086: ,p_program_id => fnd_global.conc_program_id
2087: ,p_program_update_date => sysdate
2088: /*
2089: CODE PRIOR TO WWBUG: 1646442
2090: ,p_effective_date => p_effective_date
2493: -- Issue a savepoint if operating in validation only mode
2494: --
2495: savepoint create_PRTT_ENRT_RESULT;
2496: --
2497: if fnd_global.conc_request_id in (0,-1) then
2498: --
2499: --
2500: ben_env_object.init(p_business_group_id => p_business_group_id,
2501: p_effective_date => p_effective_date,
3586: ,p_pen_attribute27 => p_pen_attribute27
3587: ,p_pen_attribute28 => p_pen_attribute28
3588: ,p_pen_attribute29 => p_pen_attribute29
3589: ,p_pen_attribute30 => p_pen_attribute30
3590: ,p_request_id => fnd_global.conc_request_id
3591: ,p_program_application_id => fnd_global.prog_appl_id
3592: ,p_program_id => fnd_global.conc_program_id
3593: ,p_program_update_date => sysdate
3594: ,p_object_version_number => l_object_version_number
3587: ,p_pen_attribute28 => p_pen_attribute28
3588: ,p_pen_attribute29 => p_pen_attribute29
3589: ,p_pen_attribute30 => p_pen_attribute30
3590: ,p_request_id => fnd_global.conc_request_id
3591: ,p_program_application_id => fnd_global.prog_appl_id
3592: ,p_program_id => fnd_global.conc_program_id
3593: ,p_program_update_date => sysdate
3594: ,p_object_version_number => l_object_version_number
3595: ,p_per_in_ler_id => p_per_in_ler_id
3588: ,p_pen_attribute29 => p_pen_attribute29
3589: ,p_pen_attribute30 => p_pen_attribute30
3590: ,p_request_id => fnd_global.conc_request_id
3591: ,p_program_application_id => fnd_global.prog_appl_id
3592: ,p_program_id => fnd_global.conc_program_id
3593: ,p_program_update_date => sysdate
3594: ,p_object_version_number => l_object_version_number
3595: ,p_per_in_ler_id => p_per_in_ler_id
3596: ,p_bnft_typ_cd => p_bnft_typ_cd
3889: ,p_per_in_ler_id => p_per_in_ler_id
3890: ,p_business_group_id => p_business_group_id
3891: ,p_prtt_enrt_rslt_id => l_ppe1.prtt_enrt_rslt_id
3892: ,p_object_version_number => l_ppe1.object_version_number
3893: ,p_request_id => fnd_global.conc_request_id
3894: ,p_program_application_id => fnd_global.prog_appl_id
3895: ,p_program_id => fnd_global.conc_program_id
3896: ,p_program_update_date => sysdate
3897: ,p_effective_date => l_ppe1.effective_start_date
3890: ,p_business_group_id => p_business_group_id
3891: ,p_prtt_enrt_rslt_id => l_ppe1.prtt_enrt_rslt_id
3892: ,p_object_version_number => l_ppe1.object_version_number
3893: ,p_request_id => fnd_global.conc_request_id
3894: ,p_program_application_id => fnd_global.prog_appl_id
3895: ,p_program_id => fnd_global.conc_program_id
3896: ,p_program_update_date => sysdate
3897: ,p_effective_date => l_ppe1.effective_start_date
3898: ,p_datetrack_mode => 'CORRECTION'
3891: ,p_prtt_enrt_rslt_id => l_ppe1.prtt_enrt_rslt_id
3892: ,p_object_version_number => l_ppe1.object_version_number
3893: ,p_request_id => fnd_global.conc_request_id
3894: ,p_program_application_id => fnd_global.prog_appl_id
3895: ,p_program_id => fnd_global.conc_program_id
3896: ,p_program_update_date => sysdate
3897: ,p_effective_date => l_ppe1.effective_start_date
3898: ,p_datetrack_mode => 'CORRECTION'
3899:
3943: ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
3944: ,p_per_in_ler_id => p_per_in_ler_id
3945: ,p_business_group_id => p_business_group_id
3946: ,p_object_version_number => l_ppe.object_version_number
3947: ,p_request_id => fnd_global.conc_request_id
3948: ,p_program_application_id => fnd_global.prog_appl_id
3949: ,p_program_id => fnd_global.conc_program_id
3950: ,p_program_update_date => sysdate
3951: /*
3944: ,p_per_in_ler_id => p_per_in_ler_id
3945: ,p_business_group_id => p_business_group_id
3946: ,p_object_version_number => l_ppe.object_version_number
3947: ,p_request_id => fnd_global.conc_request_id
3948: ,p_program_application_id => fnd_global.prog_appl_id
3949: ,p_program_id => fnd_global.conc_program_id
3950: ,p_program_update_date => sysdate
3951: /*
3952: CODE PRIOR TO WWBUG: 1646442
3945: ,p_business_group_id => p_business_group_id
3946: ,p_object_version_number => l_ppe.object_version_number
3947: ,p_request_id => fnd_global.conc_request_id
3948: ,p_program_application_id => fnd_global.prog_appl_id
3949: ,p_program_id => fnd_global.conc_program_id
3950: ,p_program_update_date => sysdate
3951: /*
3952: CODE PRIOR TO WWBUG: 1646442
3953: ,p_effective_date => p_effective_date
3989: ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
3990: ,p_per_in_ler_id => p_per_in_ler_id
3991: ,p_business_group_id => p_business_group_id
3992: ,p_object_version_number => l_ppe.object_version_number
3993: ,p_request_id => fnd_global.conc_request_id
3994: ,p_program_application_id => fnd_global.prog_appl_id
3995: ,p_program_id => fnd_global.conc_program_id
3996: ,p_program_update_date => sysdate
3997: /*
3990: ,p_per_in_ler_id => p_per_in_ler_id
3991: ,p_business_group_id => p_business_group_id
3992: ,p_object_version_number => l_ppe.object_version_number
3993: ,p_request_id => fnd_global.conc_request_id
3994: ,p_program_application_id => fnd_global.prog_appl_id
3995: ,p_program_id => fnd_global.conc_program_id
3996: ,p_program_update_date => sysdate
3997: /*
3998: CODE PRIOR TO WWBUG: 1646442
3991: ,p_business_group_id => p_business_group_id
3992: ,p_object_version_number => l_ppe.object_version_number
3993: ,p_request_id => fnd_global.conc_request_id
3994: ,p_program_application_id => fnd_global.prog_appl_id
3995: ,p_program_id => fnd_global.conc_program_id
3996: ,p_program_update_date => sysdate
3997: /*
3998: CODE PRIOR TO WWBUG: 1646442
3999: ,p_effective_date => p_effective_date
4037: p_per_in_ler_id => p_per_in_ler_id,
4038: p_cvg_thru_dt => hr_api.g_eot,
4039: p_object_version_number => l_egd.object_version_number,
4040: p_datetrack_mode => l_egd_datetrack_mode,
4041: p_request_id => fnd_global.conc_request_id,
4042: p_program_application_id => fnd_global.prog_appl_id,
4043: p_program_id => fnd_global.conc_program_id,
4044: p_program_update_date => sysdate,
4045: p_effective_date => p_effective_date,
4038: p_cvg_thru_dt => hr_api.g_eot,
4039: p_object_version_number => l_egd.object_version_number,
4040: p_datetrack_mode => l_egd_datetrack_mode,
4041: p_request_id => fnd_global.conc_request_id,
4042: p_program_application_id => fnd_global.prog_appl_id,
4043: p_program_id => fnd_global.conc_program_id,
4044: p_program_update_date => sysdate,
4045: p_effective_date => p_effective_date,
4046: p_multi_row_actn => FALSE);
4039: p_object_version_number => l_egd.object_version_number,
4040: p_datetrack_mode => l_egd_datetrack_mode,
4041: p_request_id => fnd_global.conc_request_id,
4042: p_program_application_id => fnd_global.prog_appl_id,
4043: p_program_id => fnd_global.conc_program_id,
4044: p_program_update_date => sysdate,
4045: p_effective_date => p_effective_date,
4046: p_multi_row_actn => FALSE);
4047: --
4346: -- Issue a savepoint if operating in validation only mode
4347: --
4348: savepoint update_PRTT_ENRT_RESULT;
4349: --
4350: if fnd_global.conc_request_id in (0,-1) and
4351: p_business_group_id <> hr_api.g_number then
4352: --
4353: --bug#3568529
4354: ben_env_object.get(p_rec => l_env_rec);
5256: l_proc := 'determine_dpnt_cvg_dt_cd';
5257: hr_utility.set_location ('Entering '||l_proc,10);
5258: end if;
5259: l_step := 10;
5260: if fnd_global.conc_request_id in (0,-1) then
5261: --
5262: --bug#3568529
5263: ben_env_object.get(p_rec => l_env_rec);
5264: if l_env_rec.benefit_action_id is null then
6848: -- Work out if we are being called from a concurrent program
6849: -- otherwise we need to initialize the environment
6850: --
6851: ben_env_object.get(p_rec => l_env_rec);
6852: if fnd_global.conc_request_id in (0,-1) then
6853: --bug#3568529
6854: -- ben_env_object.get(p_rec => l_env_rec);
6855: if l_env_rec.benefit_action_id is null then
6856: --
7857: if l_prv4.prtt_rt_val_id <> prev_prtt_rt_val_id then
7858: --
7859: prev_prtt_rt_val_id := l_prv4.prtt_rt_val_id;
7860: --
7861: if fnd_global.conc_request_id in ( 0,-1) then
7862: -- Issue a warning to the user. These will display on the enrt forms.
7863: ben_warnings.load_warning
7864: (p_application_short_name => 'BEN',
7865: p_message_name => 'BEN_93369_DEL_FUT_RATE',
8390: -- 2739965 In case of unrestricted enrollment, this happens only when there are future rates
8391: -- and they got deleted as part of c_prv2 process above. Lets us throw this error
8392: -- here warning the user about the deletion of the future rate.
8393: --
8394: if fnd_global.conc_request_id in ( 0,-1) then
8395: -- Issue a warning to the user. These will display on the enrt forms.
8396: ben_warnings.load_warning
8397: (p_application_short_name => 'BEN',
8398: p_message_name => 'BEN_93369_DEL_FUT_RATE',
10369: hr_utility.set_location('Leaving- called from CFW action items',15);
10370: return;
10371: end if;
10372: --
10373: if fnd_global.conc_request_id in (0,-1) then
10374: --
10375: --bug#3568529
10376: ben_env_object.get(p_rec => l_env_rec);
10377: if l_env_rec.benefit_action_id is null then