3222: open c_conc_pgm_name;
3223: fetch c_conc_pgm_name into l_source_program;
3224: close c_conc_pgm_name;
3225: --
3226: if fnd_global.conc_request_id = -1 then
3227: return;
3228: end if;
3229: --
3230: benutils.get_batch_parameters
3236: fnd_file.put_line(which => fnd_file.log,
3237: buff => '------------------');
3238: fnd_file.put_line(which => fnd_file.log,
3239: buff => 'Concurrent Request ID :'||
3240: fnd_global.conc_request_id);
3241: fnd_file.put_line(which => fnd_file.log,
3242: buff => 'Run Mode :'||
3243: hr_general.decode_lookup('BEN_BENMNGLE_MD',l_rec.mode_cd));
3244: fnd_file.put_line(which => fnd_file.log,
4390: p_dtctd_dt => p_effective_date,
4391: p_business_group_id => l_curr_pel.per_business_group_id,
4392: p_object_version_number => l_object_version_number,
4393: p_effective_date => l_effective_date,
4394: p_program_application_id => fnd_global.prog_appl_id,
4395: p_program_id => fnd_global.conc_program_id,
4396: p_request_id => fnd_global.conc_request_id,
4397: p_program_update_date => l_effective_date);
4398: --
4391: p_business_group_id => l_curr_pel.per_business_group_id,
4392: p_object_version_number => l_object_version_number,
4393: p_effective_date => l_effective_date,
4394: p_program_application_id => fnd_global.prog_appl_id,
4395: p_program_id => fnd_global.conc_program_id,
4396: p_request_id => fnd_global.conc_request_id,
4397: p_program_update_date => l_effective_date);
4398: --
4399: ben_Person_Life_Event_api.create_Person_Life_Event_perf
4392: p_object_version_number => l_object_version_number,
4393: p_effective_date => l_effective_date,
4394: p_program_application_id => fnd_global.prog_appl_id,
4395: p_program_id => fnd_global.conc_program_id,
4396: p_request_id => fnd_global.conc_request_id,
4397: p_program_update_date => l_effective_date);
4398: --
4399: ben_Person_Life_Event_api.create_Person_Life_Event_perf
4400: (p_validate => false
4407: ,p_business_group_id => l_curr_pel.per_business_group_id
4408: ,p_ntfn_dt => trunc(sysdate)
4409: ,p_object_version_number => l_object_version_number
4410: ,p_effective_date => l_effective_date
4411: ,p_program_application_id => fnd_global.prog_appl_id
4412: ,p_program_id => fnd_global.conc_program_id
4413: ,p_request_id => fnd_global.conc_request_id
4414: ,p_program_update_date => trunc(sysdate)
4415: ,p_procd_dt => l_procd_dt
4408: ,p_ntfn_dt => trunc(sysdate)
4409: ,p_object_version_number => l_object_version_number
4410: ,p_effective_date => l_effective_date
4411: ,p_program_application_id => fnd_global.prog_appl_id
4412: ,p_program_id => fnd_global.conc_program_id
4413: ,p_request_id => fnd_global.conc_request_id
4414: ,p_program_update_date => trunc(sysdate)
4415: ,p_procd_dt => l_procd_dt
4416: ,p_strtd_dt => l_strtd_dt
4409: ,p_object_version_number => l_object_version_number
4410: ,p_effective_date => l_effective_date
4411: ,p_program_application_id => fnd_global.prog_appl_id
4412: ,p_program_id => fnd_global.conc_program_id
4413: ,p_request_id => fnd_global.conc_request_id
4414: ,p_program_update_date => trunc(sysdate)
4415: ,p_procd_dt => l_procd_dt
4416: ,p_strtd_dt => l_strtd_dt
4417: ,p_voidd_dt => l_voidd_dt);
4482: p_ptip_ordr_num => l_curr_epe.ptip_ordr_num,
4483: p_oipl_ordr_num => l_curr_epe.oipl_ordr_num,
4484: p_object_version_number => l_object_version_number,
4485: p_effective_date => l_effective_date,
4486: p_program_application_id => fnd_global.prog_appl_id,
4487: p_program_id => fnd_global.conc_program_id,
4488: p_request_id => fnd_global.conc_request_id,
4489: p_program_update_date => trunc(SYSDATE),
4490: p_enrt_perd_id => l_curr_epe.enrt_perd_id,
4483: p_oipl_ordr_num => l_curr_epe.oipl_ordr_num,
4484: p_object_version_number => l_object_version_number,
4485: p_effective_date => l_effective_date,
4486: p_program_application_id => fnd_global.prog_appl_id,
4487: p_program_id => fnd_global.conc_program_id,
4488: p_request_id => fnd_global.conc_request_id,
4489: p_program_update_date => trunc(SYSDATE),
4490: p_enrt_perd_id => l_curr_epe.enrt_perd_id,
4491: p_lee_rsn_id => l_curr_epe.lee_rsn_id,
4484: p_object_version_number => l_object_version_number,
4485: p_effective_date => l_effective_date,
4486: p_program_application_id => fnd_global.prog_appl_id,
4487: p_program_id => fnd_global.conc_program_id,
4488: p_request_id => fnd_global.conc_request_id,
4489: p_program_update_date => trunc(SYSDATE),
4490: p_enrt_perd_id => l_curr_epe.enrt_perd_id,
4491: p_lee_rsn_id => l_curr_epe.lee_rsn_id,
4492: p_cls_enrt_dt_to_use_cd => l_curr_epe.cls_enrt_dt_to_use_cd,
4714: l_created_by,
4715: l_creation_date,
4716: l_last_updated_by,
4717: trunc(SYSDATE),
4718: fnd_global.conc_request_id,
4719: fnd_global.prog_appl_id,
4720: fnd_global.conc_program_id,
4721: trunc(SYSDATE),
4722: l_object_version_number);
4715: l_creation_date,
4716: l_last_updated_by,
4717: trunc(SYSDATE),
4718: fnd_global.conc_request_id,
4719: fnd_global.prog_appl_id,
4720: fnd_global.conc_program_id,
4721: trunc(SYSDATE),
4722: l_object_version_number);
4723: --
4716: l_last_updated_by,
4717: trunc(SYSDATE),
4718: fnd_global.conc_request_id,
4719: fnd_global.prog_appl_id,
4720: fnd_global.conc_program_id,
4721: trunc(SYSDATE),
4722: l_object_version_number);
4723: --
4724: end loop; -- Rates for loop
4903: p_dtctd_dt => p_effective_date,
4904: p_business_group_id => l_curr_epe.per_business_group_id,
4905: p_object_version_number => l_object_version_number,
4906: p_effective_date => l_effective_date,
4907: p_program_application_id => fnd_global.prog_appl_id,
4908: p_program_id => fnd_global.conc_program_id,
4909: p_request_id => fnd_global.conc_request_id,
4910: p_program_update_date => l_effective_date);
4911: --
4904: p_business_group_id => l_curr_epe.per_business_group_id,
4905: p_object_version_number => l_object_version_number,
4906: p_effective_date => l_effective_date,
4907: p_program_application_id => fnd_global.prog_appl_id,
4908: p_program_id => fnd_global.conc_program_id,
4909: p_request_id => fnd_global.conc_request_id,
4910: p_program_update_date => l_effective_date);
4911: --
4912: ben_Person_Life_Event_api.create_Person_Life_Event_perf
4905: p_object_version_number => l_object_version_number,
4906: p_effective_date => l_effective_date,
4907: p_program_application_id => fnd_global.prog_appl_id,
4908: p_program_id => fnd_global.conc_program_id,
4909: p_request_id => fnd_global.conc_request_id,
4910: p_program_update_date => l_effective_date);
4911: --
4912: ben_Person_Life_Event_api.create_Person_Life_Event_perf
4913: (p_validate => false
4920: ,p_business_group_id => l_curr_epe.per_business_group_id
4921: ,p_ntfn_dt => trunc(sysdate)
4922: ,p_object_version_number => l_object_version_number
4923: ,p_effective_date => l_effective_date
4924: ,p_program_application_id => fnd_global.prog_appl_id
4925: ,p_program_id => fnd_global.conc_program_id
4926: ,p_request_id => fnd_global.conc_request_id
4927: ,p_program_update_date => trunc(sysdate)
4928: ,p_procd_dt => l_procd_dt
4921: ,p_ntfn_dt => trunc(sysdate)
4922: ,p_object_version_number => l_object_version_number
4923: ,p_effective_date => l_effective_date
4924: ,p_program_application_id => fnd_global.prog_appl_id
4925: ,p_program_id => fnd_global.conc_program_id
4926: ,p_request_id => fnd_global.conc_request_id
4927: ,p_program_update_date => trunc(sysdate)
4928: ,p_procd_dt => l_procd_dt
4929: ,p_strtd_dt => l_strtd_dt
4922: ,p_object_version_number => l_object_version_number
4923: ,p_effective_date => l_effective_date
4924: ,p_program_application_id => fnd_global.prog_appl_id
4925: ,p_program_id => fnd_global.conc_program_id
4926: ,p_request_id => fnd_global.conc_request_id
4927: ,p_program_update_date => trunc(sysdate)
4928: ,p_procd_dt => l_procd_dt
4929: ,p_strtd_dt => l_strtd_dt
4930: ,p_voidd_dt => l_voidd_dt);
5009: p_ptip_ordr_num => l_curr_epe.ptip_ordr_num,
5010: p_oipl_ordr_num => l_curr_epe.oipl_ordr_num,
5011: p_object_version_number => l_object_version_number,
5012: p_effective_date => l_effective_date,
5013: p_program_application_id => fnd_global.prog_appl_id,
5014: p_program_id => fnd_global.conc_program_id,
5015: p_request_id => fnd_global.conc_request_id,
5016: p_program_update_date => trunc(SYSDATE),
5017: p_enrt_perd_id => l_curr_epe.enrt_perd_id,
5010: p_oipl_ordr_num => l_curr_epe.oipl_ordr_num,
5011: p_object_version_number => l_object_version_number,
5012: p_effective_date => l_effective_date,
5013: p_program_application_id => fnd_global.prog_appl_id,
5014: p_program_id => fnd_global.conc_program_id,
5015: p_request_id => fnd_global.conc_request_id,
5016: p_program_update_date => trunc(SYSDATE),
5017: p_enrt_perd_id => l_curr_epe.enrt_perd_id,
5018: p_lee_rsn_id => l_curr_epe.lee_rsn_id,
5011: p_object_version_number => l_object_version_number,
5012: p_effective_date => l_effective_date,
5013: p_program_application_id => fnd_global.prog_appl_id,
5014: p_program_id => fnd_global.conc_program_id,
5015: p_request_id => fnd_global.conc_request_id,
5016: p_program_update_date => trunc(SYSDATE),
5017: p_enrt_perd_id => l_curr_epe.enrt_perd_id,
5018: p_lee_rsn_id => l_curr_epe.lee_rsn_id,
5019: p_cls_enrt_dt_to_use_cd => l_curr_epe.cls_enrt_dt_to_use_cd,
5232: l_created_by,
5233: l_creation_date,
5234: l_last_updated_by,
5235: trunc(SYSDATE),
5236: fnd_global.conc_request_id,
5237: fnd_global.prog_appl_id,
5238: fnd_global.conc_program_id,
5239: trunc(SYSDATE),
5240: l_object_version_number);
5233: l_creation_date,
5234: l_last_updated_by,
5235: trunc(SYSDATE),
5236: fnd_global.conc_request_id,
5237: fnd_global.prog_appl_id,
5238: fnd_global.conc_program_id,
5239: trunc(SYSDATE),
5240: l_object_version_number);
5241: --
5234: l_last_updated_by,
5235: trunc(SYSDATE),
5236: fnd_global.conc_request_id,
5237: fnd_global.prog_appl_id,
5238: fnd_global.conc_program_id,
5239: trunc(SYSDATE),
5240: l_object_version_number);
5241: --
5242: end loop;
6628: --
6629: cursor c_get_parent_req_id is
6630: select parent_request_id
6631: from fnd_concurrent_requests
6632: where request_id = fnd_global.conc_request_id;
6633: --
6634: begin
6635: --
6636: g_debug := hr_utility.debug_enabled;
8201: -- We may need to add other grade/step paramters to this table
8202: -- for now just reuse.
8203: --
8204: p_date_from => l_asg_events_to_all_sel_dt,
8205: p_request_id => fnd_global.conc_request_id,
8206: p_program_application_id => fnd_global.prog_appl_id,
8207: p_program_id => fnd_global.conc_program_id,
8208: p_program_update_date => sysdate,
8209: p_object_version_number => l_object_version_number,
8202: -- for now just reuse.
8203: --
8204: p_date_from => l_asg_events_to_all_sel_dt,
8205: p_request_id => fnd_global.conc_request_id,
8206: p_program_application_id => fnd_global.prog_appl_id,
8207: p_program_id => fnd_global.conc_program_id,
8208: p_program_update_date => sysdate,
8209: p_object_version_number => l_object_version_number,
8210: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
8203: --
8204: p_date_from => l_asg_events_to_all_sel_dt,
8205: p_request_id => fnd_global.conc_request_id,
8206: p_program_application_id => fnd_global.prog_appl_id,
8207: p_program_id => fnd_global.conc_program_id,
8208: p_program_update_date => sysdate,
8209: p_object_version_number => l_object_version_number,
8210: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
8211: p_inelg_action_cd => p_abs_historical_mode,
9934: ,p_ler_id => p_ler_id
9935: ,p_person_id => p_person_id
9936: ,p_business_group_id => p_business_group_id
9937: ,p_effective_date => p_effective_date
9938: ,p_program_application_id => fnd_global.prog_appl_id
9939: ,p_program_id => fnd_global.conc_program_id
9940: ,p_request_id => fnd_global.conc_request_id
9941: ,p_program_update_date => sysdate
9942: ,p_ntfn_dt => trunc(sysdate)
9935: ,p_person_id => p_person_id
9936: ,p_business_group_id => p_business_group_id
9937: ,p_effective_date => p_effective_date
9938: ,p_program_application_id => fnd_global.prog_appl_id
9939: ,p_program_id => fnd_global.conc_program_id
9940: ,p_request_id => fnd_global.conc_request_id
9941: ,p_program_update_date => sysdate
9942: ,p_ntfn_dt => trunc(sysdate)
9943: ,p_procd_dt => p_effective_date);
9936: ,p_business_group_id => p_business_group_id
9937: ,p_effective_date => p_effective_date
9938: ,p_program_application_id => fnd_global.prog_appl_id
9939: ,p_program_id => fnd_global.conc_program_id
9940: ,p_request_id => fnd_global.conc_request_id
9941: ,p_program_update_date => sysdate
9942: ,p_ntfn_dt => trunc(sysdate)
9943: ,p_procd_dt => p_effective_date);
9944: --
9978: p_lf_evt_ocrd_dt => p_effective_date,
9979: p_business_group_id => p_business_group_id,
9980: p_object_version_number => l_object_version_number,
9981: p_effective_date => p_effective_date,
9982: p_program_application_id => fnd_global.prog_appl_id,
9983: p_program_id => fnd_global.conc_program_id,
9984: p_request_id => fnd_global.conc_request_id,
9985: p_program_update_date => sysdate
9986: ,p_procd_dt => l_procd_dt
9979: p_business_group_id => p_business_group_id,
9980: p_object_version_number => l_object_version_number,
9981: p_effective_date => p_effective_date,
9982: p_program_application_id => fnd_global.prog_appl_id,
9983: p_program_id => fnd_global.conc_program_id,
9984: p_request_id => fnd_global.conc_request_id,
9985: p_program_update_date => sysdate
9986: ,p_procd_dt => l_procd_dt
9987: ,p_strtd_dt => l_strtd_dt
9980: p_object_version_number => l_object_version_number,
9981: p_effective_date => p_effective_date,
9982: p_program_application_id => fnd_global.prog_appl_id,
9983: p_program_id => fnd_global.conc_program_id,
9984: p_request_id => fnd_global.conc_request_id,
9985: p_program_update_date => sysdate
9986: ,p_procd_dt => l_procd_dt
9987: ,p_strtd_dt => l_strtd_dt
9988: ,p_voidd_dt => l_voidd_dt
11589: --
11590: if l_not_eligible and l_mode = 'W'
11591: and ben_manage_cwb_life_events.g_cache_group_plan_rec.trk_inelig_per_flag = 'N'
11592: and l_oipl_id is null and l_pl_id is not null
11593: -- and fnd_global.conc_request_id > 0 /* Bug 8290746 */
11594: then
11595: --
11596: -- No need to write the data.
11597: --