DBA Data[Home] [Help]

APPS.BEN_MANAGE_LIFE_EVENTS dependencies on FND_GLOBAL

Line 3226: if fnd_global.conc_request_id = -1 then

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

Line 3240: fnd_global.conc_request_id);

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,

Line 4394: p_program_application_id => fnd_global.prog_appl_id,

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

Line 4395: p_program_id => fnd_global.conc_program_id,

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

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

Line 4411: ,p_program_application_id => fnd_global.prog_appl_id

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

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

Line 4413: ,p_request_id => fnd_global.conc_request_id

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

Line 4486: p_program_application_id => fnd_global.prog_appl_id,

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,

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

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

Line 4718: fnd_global.conc_request_id,

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

Line 4719: fnd_global.prog_appl_id,

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

Line 4720: fnd_global.conc_program_id,

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

Line 4907: p_program_application_id => fnd_global.prog_appl_id,

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

Line 4908: p_program_id => fnd_global.conc_program_id,

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

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

Line 4924: ,p_program_application_id => fnd_global.prog_appl_id

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

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

Line 4926: ,p_request_id => fnd_global.conc_request_id

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

Line 5013: p_program_application_id => fnd_global.prog_appl_id,

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,

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

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

Line 5236: fnd_global.conc_request_id,

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

Line 5237: fnd_global.prog_appl_id,

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

Line 5238: fnd_global.conc_program_id,

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;

Line 6632: where request_id = fnd_global.conc_request_id;

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;

Line 8205: p_request_id => fnd_global.conc_request_id,

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,

Line 8206: p_program_application_id => fnd_global.prog_appl_id,

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,

Line 8207: p_program_id => fnd_global.conc_program_id,

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,

Line 9938: ,p_program_application_id => fnd_global.prog_appl_id

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)

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

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

Line 9982: p_program_application_id => fnd_global.prog_appl_id,

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

Line 9983: p_program_id => fnd_global.conc_program_id,

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

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

Line 11593: -- and fnd_global.conc_request_id > 0 /* Bug 8290746 */

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