2830: open c_conc_pgm_name;
2831: fetch c_conc_pgm_name into l_source_program;
2832: close c_conc_pgm_name;
2833: --
2834: if fnd_global.conc_request_id = -1 then
2835: return;
2836: end if;
2837: --
2838: benutils.get_batch_parameters
2844: fnd_file.put_line(which => fnd_file.log,
2845: buff => '------------------');
2846: fnd_file.put_line(which => fnd_file.log,
2847: buff => 'Concurrent Request ID :'||
2848: fnd_global.conc_request_id);
2849: fnd_file.put_line(which => fnd_file.log,
2850: buff => 'Run Mode :'||
2851: hr_general.decode_lookup('BEN_BENMNGLE_MD',l_rec.mode_cd));
2852: fnd_file.put_line(which => fnd_file.log,
3998: p_dtctd_dt => p_effective_date,
3999: p_business_group_id => l_curr_pel.per_business_group_id,
4000: p_object_version_number => l_object_version_number,
4001: p_effective_date => l_effective_date,
4002: p_program_application_id => fnd_global.prog_appl_id,
4003: p_program_id => fnd_global.conc_program_id,
4004: p_request_id => fnd_global.conc_request_id,
4005: p_program_update_date => l_effective_date);
4006: --
3999: p_business_group_id => l_curr_pel.per_business_group_id,
4000: p_object_version_number => l_object_version_number,
4001: p_effective_date => l_effective_date,
4002: p_program_application_id => fnd_global.prog_appl_id,
4003: p_program_id => fnd_global.conc_program_id,
4004: p_request_id => fnd_global.conc_request_id,
4005: p_program_update_date => l_effective_date);
4006: --
4007: ben_Person_Life_Event_api.create_Person_Life_Event_perf
4000: p_object_version_number => l_object_version_number,
4001: p_effective_date => l_effective_date,
4002: p_program_application_id => fnd_global.prog_appl_id,
4003: p_program_id => fnd_global.conc_program_id,
4004: p_request_id => fnd_global.conc_request_id,
4005: p_program_update_date => l_effective_date);
4006: --
4007: ben_Person_Life_Event_api.create_Person_Life_Event_perf
4008: (p_validate => false
4015: ,p_business_group_id => l_curr_pel.per_business_group_id
4016: ,p_ntfn_dt => trunc(sysdate)
4017: ,p_object_version_number => l_object_version_number
4018: ,p_effective_date => l_effective_date
4019: ,p_program_application_id => fnd_global.prog_appl_id
4020: ,p_program_id => fnd_global.conc_program_id
4021: ,p_request_id => fnd_global.conc_request_id
4022: ,p_program_update_date => trunc(sysdate)
4023: ,p_procd_dt => l_procd_dt
4016: ,p_ntfn_dt => trunc(sysdate)
4017: ,p_object_version_number => l_object_version_number
4018: ,p_effective_date => l_effective_date
4019: ,p_program_application_id => fnd_global.prog_appl_id
4020: ,p_program_id => fnd_global.conc_program_id
4021: ,p_request_id => fnd_global.conc_request_id
4022: ,p_program_update_date => trunc(sysdate)
4023: ,p_procd_dt => l_procd_dt
4024: ,p_strtd_dt => l_strtd_dt
4017: ,p_object_version_number => l_object_version_number
4018: ,p_effective_date => l_effective_date
4019: ,p_program_application_id => fnd_global.prog_appl_id
4020: ,p_program_id => fnd_global.conc_program_id
4021: ,p_request_id => fnd_global.conc_request_id
4022: ,p_program_update_date => trunc(sysdate)
4023: ,p_procd_dt => l_procd_dt
4024: ,p_strtd_dt => l_strtd_dt
4025: ,p_voidd_dt => l_voidd_dt);
4090: p_ptip_ordr_num => l_curr_epe.ptip_ordr_num,
4091: p_oipl_ordr_num => l_curr_epe.oipl_ordr_num,
4092: p_object_version_number => l_object_version_number,
4093: p_effective_date => l_effective_date,
4094: p_program_application_id => fnd_global.prog_appl_id,
4095: p_program_id => fnd_global.conc_program_id,
4096: p_request_id => fnd_global.conc_request_id,
4097: p_program_update_date => trunc(SYSDATE),
4098: p_enrt_perd_id => l_curr_epe.enrt_perd_id,
4091: p_oipl_ordr_num => l_curr_epe.oipl_ordr_num,
4092: p_object_version_number => l_object_version_number,
4093: p_effective_date => l_effective_date,
4094: p_program_application_id => fnd_global.prog_appl_id,
4095: p_program_id => fnd_global.conc_program_id,
4096: p_request_id => fnd_global.conc_request_id,
4097: p_program_update_date => trunc(SYSDATE),
4098: p_enrt_perd_id => l_curr_epe.enrt_perd_id,
4099: p_lee_rsn_id => l_curr_epe.lee_rsn_id,
4092: p_object_version_number => l_object_version_number,
4093: p_effective_date => l_effective_date,
4094: p_program_application_id => fnd_global.prog_appl_id,
4095: p_program_id => fnd_global.conc_program_id,
4096: p_request_id => fnd_global.conc_request_id,
4097: p_program_update_date => trunc(SYSDATE),
4098: p_enrt_perd_id => l_curr_epe.enrt_perd_id,
4099: p_lee_rsn_id => l_curr_epe.lee_rsn_id,
4100: p_cls_enrt_dt_to_use_cd => l_curr_epe.cls_enrt_dt_to_use_cd,
4322: l_created_by,
4323: l_creation_date,
4324: l_last_updated_by,
4325: trunc(SYSDATE),
4326: fnd_global.conc_request_id,
4327: fnd_global.prog_appl_id,
4328: fnd_global.conc_program_id,
4329: trunc(SYSDATE),
4330: l_object_version_number);
4323: l_creation_date,
4324: l_last_updated_by,
4325: trunc(SYSDATE),
4326: fnd_global.conc_request_id,
4327: fnd_global.prog_appl_id,
4328: fnd_global.conc_program_id,
4329: trunc(SYSDATE),
4330: l_object_version_number);
4331: --
4324: l_last_updated_by,
4325: trunc(SYSDATE),
4326: fnd_global.conc_request_id,
4327: fnd_global.prog_appl_id,
4328: fnd_global.conc_program_id,
4329: trunc(SYSDATE),
4330: l_object_version_number);
4331: --
4332: end loop; -- Rates for loop
4511: p_dtctd_dt => p_effective_date,
4512: p_business_group_id => l_curr_epe.per_business_group_id,
4513: p_object_version_number => l_object_version_number,
4514: p_effective_date => l_effective_date,
4515: p_program_application_id => fnd_global.prog_appl_id,
4516: p_program_id => fnd_global.conc_program_id,
4517: p_request_id => fnd_global.conc_request_id,
4518: p_program_update_date => l_effective_date);
4519: --
4512: p_business_group_id => l_curr_epe.per_business_group_id,
4513: p_object_version_number => l_object_version_number,
4514: p_effective_date => l_effective_date,
4515: p_program_application_id => fnd_global.prog_appl_id,
4516: p_program_id => fnd_global.conc_program_id,
4517: p_request_id => fnd_global.conc_request_id,
4518: p_program_update_date => l_effective_date);
4519: --
4520: ben_Person_Life_Event_api.create_Person_Life_Event_perf
4513: p_object_version_number => l_object_version_number,
4514: p_effective_date => l_effective_date,
4515: p_program_application_id => fnd_global.prog_appl_id,
4516: p_program_id => fnd_global.conc_program_id,
4517: p_request_id => fnd_global.conc_request_id,
4518: p_program_update_date => l_effective_date);
4519: --
4520: ben_Person_Life_Event_api.create_Person_Life_Event_perf
4521: (p_validate => false
4528: ,p_business_group_id => l_curr_epe.per_business_group_id
4529: ,p_ntfn_dt => trunc(sysdate)
4530: ,p_object_version_number => l_object_version_number
4531: ,p_effective_date => l_effective_date
4532: ,p_program_application_id => fnd_global.prog_appl_id
4533: ,p_program_id => fnd_global.conc_program_id
4534: ,p_request_id => fnd_global.conc_request_id
4535: ,p_program_update_date => trunc(sysdate)
4536: ,p_procd_dt => l_procd_dt
4529: ,p_ntfn_dt => trunc(sysdate)
4530: ,p_object_version_number => l_object_version_number
4531: ,p_effective_date => l_effective_date
4532: ,p_program_application_id => fnd_global.prog_appl_id
4533: ,p_program_id => fnd_global.conc_program_id
4534: ,p_request_id => fnd_global.conc_request_id
4535: ,p_program_update_date => trunc(sysdate)
4536: ,p_procd_dt => l_procd_dt
4537: ,p_strtd_dt => l_strtd_dt
4530: ,p_object_version_number => l_object_version_number
4531: ,p_effective_date => l_effective_date
4532: ,p_program_application_id => fnd_global.prog_appl_id
4533: ,p_program_id => fnd_global.conc_program_id
4534: ,p_request_id => fnd_global.conc_request_id
4535: ,p_program_update_date => trunc(sysdate)
4536: ,p_procd_dt => l_procd_dt
4537: ,p_strtd_dt => l_strtd_dt
4538: ,p_voidd_dt => l_voidd_dt);
4617: p_ptip_ordr_num => l_curr_epe.ptip_ordr_num,
4618: p_oipl_ordr_num => l_curr_epe.oipl_ordr_num,
4619: p_object_version_number => l_object_version_number,
4620: p_effective_date => l_effective_date,
4621: p_program_application_id => fnd_global.prog_appl_id,
4622: p_program_id => fnd_global.conc_program_id,
4623: p_request_id => fnd_global.conc_request_id,
4624: p_program_update_date => trunc(SYSDATE),
4625: p_enrt_perd_id => l_curr_epe.enrt_perd_id,
4618: p_oipl_ordr_num => l_curr_epe.oipl_ordr_num,
4619: p_object_version_number => l_object_version_number,
4620: p_effective_date => l_effective_date,
4621: p_program_application_id => fnd_global.prog_appl_id,
4622: p_program_id => fnd_global.conc_program_id,
4623: p_request_id => fnd_global.conc_request_id,
4624: p_program_update_date => trunc(SYSDATE),
4625: p_enrt_perd_id => l_curr_epe.enrt_perd_id,
4626: p_lee_rsn_id => l_curr_epe.lee_rsn_id,
4619: p_object_version_number => l_object_version_number,
4620: p_effective_date => l_effective_date,
4621: p_program_application_id => fnd_global.prog_appl_id,
4622: p_program_id => fnd_global.conc_program_id,
4623: p_request_id => fnd_global.conc_request_id,
4624: p_program_update_date => trunc(SYSDATE),
4625: p_enrt_perd_id => l_curr_epe.enrt_perd_id,
4626: p_lee_rsn_id => l_curr_epe.lee_rsn_id,
4627: p_cls_enrt_dt_to_use_cd => l_curr_epe.cls_enrt_dt_to_use_cd,
4840: l_created_by,
4841: l_creation_date,
4842: l_last_updated_by,
4843: trunc(SYSDATE),
4844: fnd_global.conc_request_id,
4845: fnd_global.prog_appl_id,
4846: fnd_global.conc_program_id,
4847: trunc(SYSDATE),
4848: l_object_version_number);
4841: l_creation_date,
4842: l_last_updated_by,
4843: trunc(SYSDATE),
4844: fnd_global.conc_request_id,
4845: fnd_global.prog_appl_id,
4846: fnd_global.conc_program_id,
4847: trunc(SYSDATE),
4848: l_object_version_number);
4849: --
4842: l_last_updated_by,
4843: trunc(SYSDATE),
4844: fnd_global.conc_request_id,
4845: fnd_global.prog_appl_id,
4846: fnd_global.conc_program_id,
4847: trunc(SYSDATE),
4848: l_object_version_number);
4849: --
4850: end loop;
6225: --
6226: cursor c_get_parent_req_id is
6227: select parent_request_id
6228: from fnd_concurrent_requests
6229: where request_id = fnd_global.conc_request_id;
6230: --
6231: begin
6232: --
6233: g_debug := hr_utility.debug_enabled;
7795: -- We may need to add other grade/step paramters to this table
7796: -- for now just reuse.
7797: --
7798: p_date_from => l_asg_events_to_all_sel_dt,
7799: p_request_id => fnd_global.conc_request_id,
7800: p_program_application_id => fnd_global.prog_appl_id,
7801: p_program_id => fnd_global.conc_program_id,
7802: p_program_update_date => sysdate,
7803: p_object_version_number => l_object_version_number,
7796: -- for now just reuse.
7797: --
7798: p_date_from => l_asg_events_to_all_sel_dt,
7799: p_request_id => fnd_global.conc_request_id,
7800: p_program_application_id => fnd_global.prog_appl_id,
7801: p_program_id => fnd_global.conc_program_id,
7802: p_program_update_date => sysdate,
7803: p_object_version_number => l_object_version_number,
7804: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
7797: --
7798: p_date_from => l_asg_events_to_all_sel_dt,
7799: p_request_id => fnd_global.conc_request_id,
7800: p_program_application_id => fnd_global.prog_appl_id,
7801: p_program_id => fnd_global.conc_program_id,
7802: p_program_update_date => sysdate,
7803: p_object_version_number => l_object_version_number,
7804: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
7805: p_inelg_action_cd => p_abs_historical_mode,
9526: ,p_ler_id => p_ler_id
9527: ,p_person_id => p_person_id
9528: ,p_business_group_id => p_business_group_id
9529: ,p_effective_date => p_effective_date
9530: ,p_program_application_id => fnd_global.prog_appl_id
9531: ,p_program_id => fnd_global.conc_program_id
9532: ,p_request_id => fnd_global.conc_request_id
9533: ,p_program_update_date => sysdate
9534: ,p_ntfn_dt => trunc(sysdate)
9527: ,p_person_id => p_person_id
9528: ,p_business_group_id => p_business_group_id
9529: ,p_effective_date => p_effective_date
9530: ,p_program_application_id => fnd_global.prog_appl_id
9531: ,p_program_id => fnd_global.conc_program_id
9532: ,p_request_id => fnd_global.conc_request_id
9533: ,p_program_update_date => sysdate
9534: ,p_ntfn_dt => trunc(sysdate)
9535: ,p_procd_dt => p_effective_date);
9528: ,p_business_group_id => p_business_group_id
9529: ,p_effective_date => p_effective_date
9530: ,p_program_application_id => fnd_global.prog_appl_id
9531: ,p_program_id => fnd_global.conc_program_id
9532: ,p_request_id => fnd_global.conc_request_id
9533: ,p_program_update_date => sysdate
9534: ,p_ntfn_dt => trunc(sysdate)
9535: ,p_procd_dt => p_effective_date);
9536: --
9570: p_lf_evt_ocrd_dt => p_effective_date,
9571: p_business_group_id => p_business_group_id,
9572: p_object_version_number => l_object_version_number,
9573: p_effective_date => p_effective_date,
9574: p_program_application_id => fnd_global.prog_appl_id,
9575: p_program_id => fnd_global.conc_program_id,
9576: p_request_id => fnd_global.conc_request_id,
9577: p_program_update_date => sysdate
9578: ,p_procd_dt => l_procd_dt
9571: p_business_group_id => p_business_group_id,
9572: p_object_version_number => l_object_version_number,
9573: p_effective_date => p_effective_date,
9574: p_program_application_id => fnd_global.prog_appl_id,
9575: p_program_id => fnd_global.conc_program_id,
9576: p_request_id => fnd_global.conc_request_id,
9577: p_program_update_date => sysdate
9578: ,p_procd_dt => l_procd_dt
9579: ,p_strtd_dt => l_strtd_dt
9572: p_object_version_number => l_object_version_number,
9573: p_effective_date => p_effective_date,
9574: p_program_application_id => fnd_global.prog_appl_id,
9575: p_program_id => fnd_global.conc_program_id,
9576: p_request_id => fnd_global.conc_request_id,
9577: p_program_update_date => sysdate
9578: ,p_procd_dt => l_procd_dt
9579: ,p_strtd_dt => l_strtd_dt
9580: ,p_voidd_dt => l_voidd_dt
11079: --
11080: if l_not_eligible and l_mode = 'W'
11081: and ben_manage_cwb_life_events.g_cache_group_plan_rec.trk_inelig_per_flag = 'N'
11082: and l_oipl_id is null and l_pl_id is not null
11083: and fnd_global.conc_request_id > 0
11084: then
11085: --
11086: -- No need to write the data.
11087: --