DBA Data[Home] [Help]

APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on FND_GLOBAL

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

361: cursor c_master is
362: select 'Y'
363: from ben_benefit_actions bft
364: where bft.benefit_action_id = p_benefit_action_id
365: and bft.request_id = fnd_global.conc_request_id;
366: */
367: --
368: begin
369: --

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

1207: -- Backout already deletes the data, so no need to call again here,
1208: -- but keeping it for now and should be called only called from the
1209: -- concurrent programs.
1210: --
1211: if fnd_global.conc_request_id not in ( 0,-1) then
1212: --
1213: -- CWB 2712602 : Delete all the hrchy data linked to backed out per in ler.
1214: --
1215: delete from ben_cwb_group_hrchy

Line 2042: p_program_application_id => fnd_global.prog_appl_id,

2038: -- p_dtctd_dt => l_dtctd_dt,
2039: p_business_group_id => p_business_group_id,
2040: p_object_version_number => l_object_version_number,
2041: p_effective_date => p_effective_date,
2042: p_program_application_id => fnd_global.prog_appl_id,
2043: p_program_id => fnd_global.conc_program_id,
2044: p_request_id => fnd_global.conc_request_id,
2045: p_program_update_date => sysdate);
2046: --

Line 2043: p_program_id => fnd_global.conc_program_id,

2039: p_business_group_id => p_business_group_id,
2040: p_object_version_number => l_object_version_number,
2041: p_effective_date => p_effective_date,
2042: p_program_application_id => fnd_global.prog_appl_id,
2043: p_program_id => fnd_global.conc_program_id,
2044: p_request_id => fnd_global.conc_request_id,
2045: p_program_update_date => sysdate);
2046: --
2047: ben_manage_cwb_life_events.get_group_plan_info(

Line 2044: p_request_id => fnd_global.conc_request_id,

2040: p_object_version_number => l_object_version_number,
2041: p_effective_date => p_effective_date,
2042: p_program_application_id => fnd_global.prog_appl_id,
2043: p_program_id => fnd_global.conc_program_id,
2044: p_request_id => fnd_global.conc_request_id,
2045: p_program_update_date => sysdate);
2046: --
2047: ben_manage_cwb_life_events.get_group_plan_info(
2048: p_pl_id => p_pl_id,

Line 2126: ,p_program_application_id => fnd_global.prog_appl_id

2122: ,p_ws_mgr_id => l_ws_mgr_id
2123: ,p_assignment_id => l_assignment_id
2124: ,p_object_version_number => l_pil_object_version_number
2125: ,p_effective_date => p_effective_date
2126: ,p_program_application_id => fnd_global.prog_appl_id
2127: ,p_program_id => fnd_global.conc_program_id
2128: ,p_request_id => fnd_global.conc_request_id
2129: ,p_program_update_date => sysdate
2130: ,p_procd_dt => l_procd_dt

Line 2127: ,p_program_id => fnd_global.conc_program_id

2123: ,p_assignment_id => l_assignment_id
2124: ,p_object_version_number => l_pil_object_version_number
2125: ,p_effective_date => p_effective_date
2126: ,p_program_application_id => fnd_global.prog_appl_id
2127: ,p_program_id => fnd_global.conc_program_id
2128: ,p_request_id => fnd_global.conc_request_id
2129: ,p_program_update_date => sysdate
2130: ,p_procd_dt => l_procd_dt
2131: ,p_strtd_dt => l_strtd_dt

Line 2128: ,p_request_id => fnd_global.conc_request_id

2124: ,p_object_version_number => l_pil_object_version_number
2125: ,p_effective_date => p_effective_date
2126: ,p_program_application_id => fnd_global.prog_appl_id
2127: ,p_program_id => fnd_global.conc_program_id
2128: ,p_request_id => fnd_global.conc_request_id
2129: ,p_program_update_date => sysdate
2130: ,p_procd_dt => l_procd_dt
2131: ,p_strtd_dt => l_strtd_dt
2132: ,p_voidd_dt => l_voidd_dt);

Line 3158: ,to_char(fnd_global.conc_request_id)

3154: ,attribute1
3155: ,ATTRIBUTE40)
3156: VALUES (ben_transaction_s.NEXTVAL
3157: ,'CWBRECURHIER'
3158: ,to_char(fnd_global.conc_request_id)
3159: ,g_hrchy_tbl(i).hrchy_cat_string);
3160:
3161: end loop;
3162: end if;

Line 4014: p_program_application_id => fnd_global.prog_appl_id,

4010: p_dtctd_dt => trunc(sysdate),
4011: p_business_group_id => p_group_business_group_id,
4012: p_object_version_number => l_object_version_number,
4013: p_effective_date => p_group_lf_evt_ocrd_dt,
4014: p_program_application_id => fnd_global.prog_appl_id,
4015: p_program_id => fnd_global.conc_program_id,
4016: p_request_id => fnd_global.conc_request_id,
4017: p_program_update_date => trunc(sysdate));
4018: --

Line 4015: p_program_id => fnd_global.conc_program_id,

4011: p_business_group_id => p_group_business_group_id,
4012: p_object_version_number => l_object_version_number,
4013: p_effective_date => p_group_lf_evt_ocrd_dt,
4014: p_program_application_id => fnd_global.prog_appl_id,
4015: p_program_id => fnd_global.conc_program_id,
4016: p_request_id => fnd_global.conc_request_id,
4017: p_program_update_date => trunc(sysdate));
4018: --
4019: -- Get the manager information.

Line 4016: p_request_id => fnd_global.conc_request_id,

4012: p_object_version_number => l_object_version_number,
4013: p_effective_date => p_group_lf_evt_ocrd_dt,
4014: p_program_application_id => fnd_global.prog_appl_id,
4015: p_program_id => fnd_global.conc_program_id,
4016: p_request_id => fnd_global.conc_request_id,
4017: p_program_update_date => trunc(sysdate));
4018: --
4019: -- Get the manager information.
4020: --

Line 4050: ,p_program_application_id => fnd_global.prog_appl_id

4046: ,p_ws_mgr_id => l_ws_mgr_id
4047: ,p_assignment_id => l_assignment_id
4048: ,p_object_version_number => l_object_version_number
4049: ,p_effective_date => l_effective_date -- p_group_lf_evt_ocrd_dt
4050: ,p_program_application_id => fnd_global.prog_appl_id
4051: ,p_program_id => fnd_global.conc_program_id
4052: ,p_request_id => fnd_global.conc_request_id
4053: ,p_program_update_date => sysdate
4054: ,p_procd_dt => l_procd_dt

Line 4051: ,p_program_id => fnd_global.conc_program_id

4047: ,p_assignment_id => l_assignment_id
4048: ,p_object_version_number => l_object_version_number
4049: ,p_effective_date => l_effective_date -- p_group_lf_evt_ocrd_dt
4050: ,p_program_application_id => fnd_global.prog_appl_id
4051: ,p_program_id => fnd_global.conc_program_id
4052: ,p_request_id => fnd_global.conc_request_id
4053: ,p_program_update_date => sysdate
4054: ,p_procd_dt => l_procd_dt
4055: ,p_strtd_dt => l_strtd_dt

Line 4052: ,p_request_id => fnd_global.conc_request_id

4048: ,p_object_version_number => l_object_version_number
4049: ,p_effective_date => l_effective_date -- p_group_lf_evt_ocrd_dt
4050: ,p_program_application_id => fnd_global.prog_appl_id
4051: ,p_program_id => fnd_global.conc_program_id
4052: ,p_request_id => fnd_global.conc_request_id
4053: ,p_program_update_date => sysdate
4054: ,p_procd_dt => l_procd_dt
4055: ,p_strtd_dt => l_strtd_dt
4056: ,p_voidd_dt => l_voidd_dt);