DBA Data[Home] [Help]

APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on FND_GLOBAL

Line 394: and bft.request_id = fnd_global.conc_request_id;

390: cursor c_master is
391: select 'Y'
392: from ben_benefit_actions bft
393: where bft.benefit_action_id = p_benefit_action_id
394: and bft.request_id = fnd_global.conc_request_id;
395: */
396: --
397: begin
398: --

Line 1241: if fnd_global.conc_request_id not in ( 0,-1) then

1237: -- Backout already deletes the data, so no need to call again here,
1238: -- but keeping it for now and should be called only called from the
1239: -- concurrent programs.
1240: --
1241: if fnd_global.conc_request_id not in ( 0,-1) then
1242: --
1243: -- CWB 2712602 : Delete all the hrchy data linked to backed out per in ler.
1244: --
1245: delete from ben_cwb_group_hrchy

Line 2087: p_program_application_id => fnd_global.prog_appl_id,

2083: -- p_dtctd_dt => l_dtctd_dt,
2084: p_business_group_id => p_business_group_id,
2085: p_object_version_number => l_object_version_number,
2086: p_effective_date => p_effective_date,
2087: p_program_application_id => fnd_global.prog_appl_id,
2088: p_program_id => fnd_global.conc_program_id,
2089: p_request_id => fnd_global.conc_request_id,
2090: p_program_update_date => sysdate);
2091: --

Line 2088: p_program_id => fnd_global.conc_program_id,

2084: p_business_group_id => p_business_group_id,
2085: p_object_version_number => l_object_version_number,
2086: p_effective_date => p_effective_date,
2087: p_program_application_id => fnd_global.prog_appl_id,
2088: p_program_id => fnd_global.conc_program_id,
2089: p_request_id => fnd_global.conc_request_id,
2090: p_program_update_date => sysdate);
2091: --
2092: ben_manage_cwb_life_events.get_group_plan_info(

Line 2089: p_request_id => fnd_global.conc_request_id,

2085: p_object_version_number => l_object_version_number,
2086: p_effective_date => p_effective_date,
2087: p_program_application_id => fnd_global.prog_appl_id,
2088: p_program_id => fnd_global.conc_program_id,
2089: p_request_id => fnd_global.conc_request_id,
2090: p_program_update_date => sysdate);
2091: --
2092: ben_manage_cwb_life_events.get_group_plan_info(
2093: p_pl_id => p_pl_id,

Line 2171: ,p_program_application_id => fnd_global.prog_appl_id

2167: ,p_ws_mgr_id => l_ws_mgr_id
2168: ,p_assignment_id => l_assignment_id
2169: ,p_object_version_number => l_pil_object_version_number
2170: ,p_effective_date => p_effective_date
2171: ,p_program_application_id => fnd_global.prog_appl_id
2172: ,p_program_id => fnd_global.conc_program_id
2173: ,p_request_id => fnd_global.conc_request_id
2174: ,p_program_update_date => sysdate
2175: ,p_procd_dt => l_procd_dt

Line 2172: ,p_program_id => fnd_global.conc_program_id

2168: ,p_assignment_id => l_assignment_id
2169: ,p_object_version_number => l_pil_object_version_number
2170: ,p_effective_date => p_effective_date
2171: ,p_program_application_id => fnd_global.prog_appl_id
2172: ,p_program_id => fnd_global.conc_program_id
2173: ,p_request_id => fnd_global.conc_request_id
2174: ,p_program_update_date => sysdate
2175: ,p_procd_dt => l_procd_dt
2176: ,p_strtd_dt => l_strtd_dt

Line 2173: ,p_request_id => fnd_global.conc_request_id

2169: ,p_object_version_number => l_pil_object_version_number
2170: ,p_effective_date => p_effective_date
2171: ,p_program_application_id => fnd_global.prog_appl_id
2172: ,p_program_id => fnd_global.conc_program_id
2173: ,p_request_id => fnd_global.conc_request_id
2174: ,p_program_update_date => sysdate
2175: ,p_procd_dt => l_procd_dt
2176: ,p_strtd_dt => l_strtd_dt
2177: ,p_voidd_dt => l_voidd_dt);

Line 3210: ,to_char(fnd_global.conc_request_id)

3206: ,attribute1
3207: ,ATTRIBUTE40)
3208: VALUES (ben_transaction_s.NEXTVAL
3209: ,'CWBRECURHIER'
3210: ,to_char(fnd_global.conc_request_id)
3211: ,g_hrchy_tbl(i).hrchy_cat_string);
3212:
3213: end loop;
3214: end if;

Line 4066: p_program_application_id => fnd_global.prog_appl_id,

4062: p_dtctd_dt => trunc(sysdate),
4063: p_business_group_id => p_group_business_group_id,
4064: p_object_version_number => l_object_version_number,
4065: p_effective_date => p_group_lf_evt_ocrd_dt,
4066: p_program_application_id => fnd_global.prog_appl_id,
4067: p_program_id => fnd_global.conc_program_id,
4068: p_request_id => fnd_global.conc_request_id,
4069: p_program_update_date => trunc(sysdate));
4070: --

Line 4067: p_program_id => fnd_global.conc_program_id,

4063: p_business_group_id => p_group_business_group_id,
4064: p_object_version_number => l_object_version_number,
4065: p_effective_date => p_group_lf_evt_ocrd_dt,
4066: p_program_application_id => fnd_global.prog_appl_id,
4067: p_program_id => fnd_global.conc_program_id,
4068: p_request_id => fnd_global.conc_request_id,
4069: p_program_update_date => trunc(sysdate));
4070: --
4071: -- Get the manager information.

Line 4068: p_request_id => fnd_global.conc_request_id,

4064: p_object_version_number => l_object_version_number,
4065: p_effective_date => p_group_lf_evt_ocrd_dt,
4066: p_program_application_id => fnd_global.prog_appl_id,
4067: p_program_id => fnd_global.conc_program_id,
4068: p_request_id => fnd_global.conc_request_id,
4069: p_program_update_date => trunc(sysdate));
4070: --
4071: -- Get the manager information.
4072: --

Line 4102: ,p_program_application_id => fnd_global.prog_appl_id

4098: ,p_ws_mgr_id => l_ws_mgr_id
4099: ,p_assignment_id => l_assignment_id
4100: ,p_object_version_number => l_object_version_number
4101: ,p_effective_date => l_effective_date -- p_group_lf_evt_ocrd_dt
4102: ,p_program_application_id => fnd_global.prog_appl_id
4103: ,p_program_id => fnd_global.conc_program_id
4104: ,p_request_id => fnd_global.conc_request_id
4105: ,p_program_update_date => sysdate
4106: ,p_procd_dt => l_procd_dt

Line 4103: ,p_program_id => fnd_global.conc_program_id

4099: ,p_assignment_id => l_assignment_id
4100: ,p_object_version_number => l_object_version_number
4101: ,p_effective_date => l_effective_date -- p_group_lf_evt_ocrd_dt
4102: ,p_program_application_id => fnd_global.prog_appl_id
4103: ,p_program_id => fnd_global.conc_program_id
4104: ,p_request_id => fnd_global.conc_request_id
4105: ,p_program_update_date => sysdate
4106: ,p_procd_dt => l_procd_dt
4107: ,p_strtd_dt => l_strtd_dt

Line 4104: ,p_request_id => fnd_global.conc_request_id

4100: ,p_object_version_number => l_object_version_number
4101: ,p_effective_date => l_effective_date -- p_group_lf_evt_ocrd_dt
4102: ,p_program_application_id => fnd_global.prog_appl_id
4103: ,p_program_id => fnd_global.conc_program_id
4104: ,p_request_id => fnd_global.conc_request_id
4105: ,p_program_update_date => sysdate
4106: ,p_procd_dt => l_procd_dt
4107: ,p_strtd_dt => l_strtd_dt
4108: ,p_voidd_dt => l_voidd_dt);