DBA Data[Home] [Help]

APPS.BEN_MANAGE_LIFE_EVENTS dependencies on FND_GLOBAL

Line 2834: if fnd_global.conc_request_id = -1 then

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

Line 2848: fnd_global.conc_request_id);

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,

Line 4002: p_program_application_id => fnd_global.prog_appl_id,

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: --

Line 4003: p_program_id => fnd_global.conc_program_id,

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

Line 4004: p_request_id => fnd_global.conc_request_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
4008: (p_validate => false

Line 4019: ,p_program_application_id => fnd_global.prog_appl_id

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

Line 4020: ,p_program_id => fnd_global.conc_program_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
4024: ,p_strtd_dt => l_strtd_dt

Line 4021: ,p_request_id => fnd_global.conc_request_id

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);

Line 4094: p_program_application_id => fnd_global.prog_appl_id,

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,

Line 4095: p_program_id => fnd_global.conc_program_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,

Line 4096: p_request_id => fnd_global.conc_request_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,

Line 4326: fnd_global.conc_request_id,

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);

Line 4327: fnd_global.prog_appl_id,

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: --

Line 4328: fnd_global.conc_program_id,

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

Line 4515: p_program_application_id => fnd_global.prog_appl_id,

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: --

Line 4516: p_program_id => fnd_global.conc_program_id,

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

Line 4517: p_request_id => fnd_global.conc_request_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
4521: (p_validate => false

Line 4532: ,p_program_application_id => fnd_global.prog_appl_id

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

Line 4533: ,p_program_id => fnd_global.conc_program_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
4537: ,p_strtd_dt => l_strtd_dt

Line 4534: ,p_request_id => fnd_global.conc_request_id

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);

Line 4621: p_program_application_id => fnd_global.prog_appl_id,

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,

Line 4622: p_program_id => fnd_global.conc_program_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,

Line 4623: p_request_id => fnd_global.conc_request_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,

Line 4844: fnd_global.conc_request_id,

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);

Line 4845: fnd_global.prog_appl_id,

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: --

Line 4846: fnd_global.conc_program_id,

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;

Line 6229: where request_id = fnd_global.conc_request_id;

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;

Line 7799: p_request_id => fnd_global.conc_request_id,

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,

Line 7800: p_program_application_id => fnd_global.prog_appl_id,

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,

Line 7801: p_program_id => fnd_global.conc_program_id,

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,

Line 9530: ,p_program_application_id => fnd_global.prog_appl_id

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)

Line 9531: ,p_program_id => fnd_global.conc_program_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)
9535: ,p_procd_dt => p_effective_date);

Line 9532: ,p_request_id => fnd_global.conc_request_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);
9536: --

Line 9574: p_program_application_id => fnd_global.prog_appl_id,

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

Line 9575: p_program_id => fnd_global.conc_program_id,

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

Line 9576: p_request_id => fnd_global.conc_request_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
9580: ,p_voidd_dt => l_voidd_dt

Line 11083: and fnd_global.conc_request_id > 0

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: --