eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_MANAGE_CWB_LIFE_EVENTS

Line 1: package body ben_manage_cwb_life_events as

1: package body ben_manage_cwb_life_events as
2: /* $Header: bencwbcm.pkb 120.38.12020000.2 2013/03/13 13:32:26 sgnanama ship $ */
3: --
4: /*
5: +========================================================================+

Line 220: g_package varchar2(80) := 'ben_manage_cwb_life_events';

216: 15-Mar-13 sgnanama 120.31.x.8 16417003 bug fix, introduced sleep time in check_slaves_status procedure
217: */
218: --------------------------------------------------------------------------------
219: --
220: g_package varchar2(80) := 'ben_manage_cwb_life_events';
221: --
222: g_debug boolean := hr_utility.debug_enabled;
223: g_rebuild_pl_id number := null;
224: g_rebuild_lf_evt_ocrd_dt date := null;

Line 270: ,p_cwb_processes_rec in ben_manage_cwb_life_events.g_cwb_processes_table

266:
267: --
268: procedure check_slaves_status
269: (p_num_cwb_processes in number
270: ,p_cwb_processes_rec in ben_manage_cwb_life_events.g_cwb_processes_table
271: -- ,p_master in varchar2
272: ,p_slave_errored out nocopy boolean
273: )
274: is

Line 416: (p_num_cwb_processes => ben_manage_cwb_life_events.g_num_cwb_processes

412: */
413: -- Check slave status
414: --
415: check_slaves_status
416: (p_num_cwb_processes => ben_manage_cwb_life_events.g_num_cwb_processes
417: ,p_cwb_processes_rec => ben_manage_cwb_life_events.g_cwb_processes_rec
418: -- ,p_master => l_master
419: --
420: ,p_slave_errored => l_slave_errored

Line 417: ,p_cwb_processes_rec => ben_manage_cwb_life_events.g_cwb_processes_rec

413: -- Check slave status
414: --
415: check_slaves_status
416: (p_num_cwb_processes => ben_manage_cwb_life_events.g_num_cwb_processes
417: ,p_cwb_processes_rec => ben_manage_cwb_life_events.g_cwb_processes_rec
418: -- ,p_master => l_master
419: --
420: ,p_slave_errored => l_slave_errored
421: );

Line 2092: ben_manage_cwb_life_events.get_group_plan_info(

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,
2094: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
2095: p_business_group_id => p_business_group_id);
2096: --

Line 2098: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,20);

2094: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
2095: p_business_group_id => p_business_group_id);
2096: --
2097: hr_utility.set_location('group_pl_id ' ||
2098: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,20);
2099: if p_pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id
2100: then
2101: --
2102: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := null;

Line 2099: if p_pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id

2095: p_business_group_id => p_business_group_id);
2096: --
2097: hr_utility.set_location('group_pl_id ' ||
2098: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,20);
2099: if p_pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id
2100: then
2101: --
2102: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := null;
2103: --

Line 2102: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := null;

2098: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,20);
2099: if p_pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id
2100: then
2101: --
2102: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := null;
2103: --
2104: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
2105: (p_person_id => p_person_id,
2106: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,

Line 2104: ben_manage_cwb_life_events.get_cwb_manager_and_assignment

2100: then
2101: --
2102: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := null;
2103: --
2104: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
2105: (p_person_id => p_person_id,
2106: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
2107: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
2108: p_effective_date => p_effective_date,

Line 2106: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,

2102: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := null;
2103: --
2104: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
2105: (p_person_id => p_person_id,
2106: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
2107: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
2108: p_effective_date => p_effective_date,
2109: p_manager_id => l_ws_mgr_id,
2110: p_assignment_id => l_assignment_id ) ;

Line 2107: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,

2103: --
2104: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
2105: (p_person_id => p_person_id,
2106: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
2107: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
2108: p_effective_date => p_effective_date,
2109: p_manager_id => l_ws_mgr_id,
2110: p_assignment_id => l_assignment_id ) ;
2111: --

Line 2152: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 30);

2148: */
2149: end if;
2150: --
2151: hr_utility.set_location('group_pl_id = ' ||
2152: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 30);
2153: --
2154: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);
2155: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
2156: ben_Person_Life_Event_api.create_Person_Life_Event_perf

Line 2166: ,p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id

2162: ,p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
2163: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
2164: ,p_business_group_id => p_business_group_id
2165: ,p_ntfn_dt => trunc(sysdate)
2166: ,p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_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

Line 2181: if p_pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then

2177: ,p_voidd_dt => l_voidd_dt);
2178: --
2179: -- Now clone the ben_cwb_person_rates, ben_cwb_group_rates.
2180: --
2181: if p_pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
2182: --
2183: -- Per in ler created is a group per in ler so populate other
2184: -- plan design tables.
2185: --

Line 2186: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := l_curr_per_in_ler_id;

2182: --
2183: -- Per in ler created is a group per in ler so populate other
2184: -- plan design tables.
2185: --
2186: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := l_curr_per_in_ler_id;
2187: --
2188: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);
2189: ben_manage_cwb_life_events.popu_cwb_tables(
2190: p_group_per_in_ler_id => l_curr_per_in_ler_id,

Line 2188: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);

2184: -- plan design tables.
2185: --
2186: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := l_curr_per_in_ler_id;
2187: --
2188: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);
2189: ben_manage_cwb_life_events.popu_cwb_tables(
2190: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2191: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2192: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,

Line 2189: ben_manage_cwb_life_events.popu_cwb_tables(

2185: --
2186: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := l_curr_per_in_ler_id;
2187: --
2188: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);
2189: ben_manage_cwb_life_events.popu_cwb_tables(
2190: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2191: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2192: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
2193: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,

Line 2191: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,

2187: --
2188: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);
2189: ben_manage_cwb_life_events.popu_cwb_tables(
2190: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2191: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2192: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
2193: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
2194: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
2195: p_effective_date => p_effective_date,

Line 2192: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,

2188: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);
2189: ben_manage_cwb_life_events.popu_cwb_tables(
2190: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2191: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2192: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
2193: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
2194: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
2195: p_effective_date => p_effective_date,
2196: p_use_eff_dt_flag => 'Y');

Line 2193: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,

2189: ben_manage_cwb_life_events.popu_cwb_tables(
2190: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2191: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2192: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
2193: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
2194: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
2195: p_effective_date => p_effective_date,
2196: p_use_eff_dt_flag => 'Y');
2197: --

Line 2194: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,

2190: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2191: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2192: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
2193: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
2194: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
2195: p_effective_date => p_effective_date,
2196: p_use_eff_dt_flag => 'Y');
2197: --
2198: -- For each of the group rates rows for a sample person

Line 2201: for l_cpg_rec in c_cpg(ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,

2197: --
2198: -- For each of the group rates rows for a sample person
2199: -- copy data to current person.
2200: --
2201: for l_cpg_rec in c_cpg(ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2202: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt)
2203: loop
2204: --
2205: -- create row in ben_cwb_person_groups

Line 2202: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt)

2198: -- For each of the group rates rows for a sample person
2199: -- copy data to current person.
2200: --
2201: for l_cpg_rec in c_cpg(ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2202: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt)
2203: loop
2204: --
2205: -- create row in ben_cwb_person_groups
2206: --

Line 2826: ben_manage_cwb_life_events.g_num_cwb_processes :=

2822: );
2823: --
2824: commit ;
2825: --
2826: ben_manage_cwb_life_events.g_num_cwb_processes :=
2827: ben_manage_cwb_life_events.g_num_cwb_processes + 1;
2828: ben_manage_cwb_life_events.g_cwb_processes_rec(g_num_cwb_processes) := l_request_id;
2829: --
2830: --

Line 2827: ben_manage_cwb_life_events.g_num_cwb_processes + 1;

2823: --
2824: commit ;
2825: --
2826: ben_manage_cwb_life_events.g_num_cwb_processes :=
2827: ben_manage_cwb_life_events.g_num_cwb_processes + 1;
2828: ben_manage_cwb_life_events.g_cwb_processes_rec(g_num_cwb_processes) := l_request_id;
2829: --
2830: --
2831: fnd_file.put_line(which => fnd_file.log,

Line 2828: ben_manage_cwb_life_events.g_cwb_processes_rec(g_num_cwb_processes) := l_request_id;

2824: commit ;
2825: --
2826: ben_manage_cwb_life_events.g_num_cwb_processes :=
2827: ben_manage_cwb_life_events.g_num_cwb_processes + 1;
2828: ben_manage_cwb_life_events.g_cwb_processes_rec(g_num_cwb_processes) := l_request_id;
2829: --
2830: --
2831: fnd_file.put_line(which => fnd_file.log,
2832: buff => 'Submitted the concurrent request id '||l_request_id||

Line 3004: ben_manage_cwb_life_events.get_group_plan_info(

3000: --
3001: g_error_log_rec.calling_proc := 'get_group_plan_info';
3002: g_error_log_rec.step_number := 1;
3003: --
3004: ben_manage_cwb_life_events.get_group_plan_info(
3005: p_group_pl_id => l_pl_id
3006: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
3007: ,p_pl_id => null
3008: );

Line 3023: ben_manage_cwb_life_events.popu_cwb_group_pil_data (

3019: --
3020: g_error_log_rec.calling_proc := 'popu_cwb_group_pil_data';
3021: g_error_log_rec.step_number := 2;
3022: --
3023: ben_manage_cwb_life_events.popu_cwb_group_pil_data (
3024: p_group_per_in_ler_id => -9999
3025: ,p_group_pl_id => g_cache_group_plan_rec.group_pl_id
3026: ,p_group_lf_evt_ocrd_dt => g_cache_group_plan_rec.group_lf_evt_ocrd_dt
3027: ,p_group_business_group_id => g_cache_group_plan_rec.group_business_group_id

Line 3036: if ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id is null

3032: -- clone ben_cwb_person_group data out side of
3033: -- popu_cwb_group_pil_data for persons outside the group plan's
3034: -- business group. This is to avoid cloning of data for managers.
3035: --
3036: if ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id is null
3037: then
3038: --
3039: g_error_log_rec.calling_proc := 'p_single_per_clone_all_data';
3040: g_error_log_rec.step_number := 3;

Line 3056: ben_manage_cwb_life_events.popu_cwb_group_pil_data (

3052: --
3053: g_error_log_rec.calling_proc := 'popu_cwb_group_pil_data';
3054: g_error_log_rec.step_number := 4;
3055: --
3056: ben_manage_cwb_life_events.popu_cwb_group_pil_data (
3057: p_group_per_in_ler_id => -9999
3058: ,p_group_pl_id => g_cache_group_plan_rec.group_pl_id
3059: ,p_group_lf_evt_ocrd_dt => g_cache_group_plan_rec.group_lf_evt_ocrd_dt
3060: ,p_group_business_group_id => g_cache_group_plan_rec.group_business_group_id

Line 3075: ben_manage_cwb_life_events.popu_group_pil_heir(

3071: --
3072: g_error_log_rec.calling_proc := 'popu_group_pil_heir';
3073: g_error_log_rec.step_number := 4;
3074: --
3075: ben_manage_cwb_life_events.popu_group_pil_heir(
3076: p_group_pl_id => g_cache_group_plan_rec.group_pl_id
3077: ,p_group_lf_evt_ocrd_dt => g_cache_group_plan_rec.group_lf_evt_ocrd_dt
3078: ,p_group_business_group_id => g_cache_group_plan_rec.group_business_group_id
3079: ,p_group_ler_id => g_cache_group_plan_rec.group_ler_id ) ;

Line 3137: ben_manage_cwb_life_events.auto_allocate_budgets (

3133: --
3134: g_error_log_rec.calling_proc := 'auto_allocate_budgets';
3135: g_error_log_rec.step_number := 5;
3136: --
3137: ben_manage_cwb_life_events.auto_allocate_budgets (
3138: p_group_pl_id => g_cache_group_plan_rec.group_pl_id
3139: ,p_lf_evt_ocrd_dt => g_cache_group_plan_rec.group_lf_evt_ocrd_dt);
3140: --
3141: end if;

Line 3245: if nvl(ben_manage_cwb_life_events.g_num_cwb_processes, 0) <> 0

3241: --
3242: --
3243: -- Spawn the reports at the end.
3244: --
3245: if nvl(ben_manage_cwb_life_events.g_num_cwb_processes, 0) <> 0
3246: then
3247: --
3248: fnd_file.put_line(which => fnd_file.log,
3249: buff => 'An error occurred in the rollup routine. After fixing the ' ||

Line 3259: for elenum in 1..ben_manage_cwb_life_events.g_num_cwb_processes

3255: then
3256: --
3257: rollback to cwb_global_process;
3258: --
3259: for elenum in 1..ben_manage_cwb_life_events.g_num_cwb_processes
3260: loop
3261: --
3262: ben_batch_reporting.batch_reports
3263: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),

Line 3263: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),

3259: for elenum in 1..ben_manage_cwb_life_events.g_num_cwb_processes
3260: loop
3261: --
3262: ben_batch_reporting.batch_reports
3263: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),
3264: p_mode => 'W',
3265: p_report_type => 'ACTIVITY_SUMMARY');
3266: --
3267: ben_batch_reporting.batch_reports

Line 3268: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),

3264: p_mode => 'W',
3265: p_report_type => 'ACTIVITY_SUMMARY');
3266: --
3267: ben_batch_reporting.batch_reports
3268: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),
3269: p_report_type => 'ERROR_BY_PERSON');
3270: --
3271: end loop;
3272: --

Line 3289: if nvl(ben_manage_cwb_life_events.g_num_cwb_processes, 0) <> 0

3285: --
3286: g_error_log_rec.calling_proc := 'Before Reports';
3287: g_error_log_rec.step_number := 8;
3288: --
3289: if nvl(ben_manage_cwb_life_events.g_num_cwb_processes, 0) <> 0
3290: then
3291: --
3292: if l_supress_report = 'Y' then
3293: for elenum in 1..ben_manage_cwb_life_events.g_num_cwb_processes

Line 3293: for elenum in 1..ben_manage_cwb_life_events.g_num_cwb_processes

3289: if nvl(ben_manage_cwb_life_events.g_num_cwb_processes, 0) <> 0
3290: then
3291: --
3292: if l_supress_report = 'Y' then
3293: for elenum in 1..ben_manage_cwb_life_events.g_num_cwb_processes
3294: loop
3295: --
3296: ben_batch_reporting.batch_reports
3297: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),

Line 3297: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),

3293: for elenum in 1..ben_manage_cwb_life_events.g_num_cwb_processes
3294: loop
3295: --
3296: ben_batch_reporting.batch_reports
3297: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),
3298: p_mode => 'W',
3299: p_report_type => 'ACTIVITY_SUMMARY');
3300: --
3301: ben_batch_reporting.batch_reports

Line 3302: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),

3298: p_mode => 'W',
3299: p_report_type => 'ACTIVITY_SUMMARY');
3300: --
3301: ben_batch_reporting.batch_reports
3302: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),
3303: p_report_type => 'ERROR_BY_PERSON');
3304: --
3305: end loop;
3306: end if;

Line 3869: ben_manage_cwb_life_events.popu_group_pil_heir(

3865: end if;
3866: --
3867: begin
3868: --
3869: ben_manage_cwb_life_events.popu_group_pil_heir(
3870: g_rebuild_pl_id,
3871: g_rebuild_lf_evt_ocrd_dt,
3872: g_rebuild_business_group_id,
3873: l_ler_id ) ;

Line 4073: ben_manage_cwb_life_events.get_cwb_manager_and_assignment

4069: p_program_update_date => trunc(sysdate));
4070: --
4071: -- Get the manager information.
4072: --
4073: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
4074: (p_person_id => p_person_id,
4075: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
4076: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
4077: p_effective_date => l_effective_date, -- ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,

Line 4075: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,

4071: -- Get the manager information.
4072: --
4073: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
4074: (p_person_id => p_person_id,
4075: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
4076: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
4077: p_effective_date => l_effective_date, -- ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4078: p_manager_id => l_ws_mgr_id,
4079: p_assignment_id => l_assignment_id ) ;

Line 4076: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,

4072: --
4073: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
4074: (p_person_id => p_person_id,
4075: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
4076: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
4077: p_effective_date => l_effective_date, -- ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4078: p_manager_id => l_ws_mgr_id,
4079: p_assignment_id => l_assignment_id ) ;
4080: --

Line 4077: p_effective_date => l_effective_date, -- ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,

4073: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
4074: (p_person_id => p_person_id,
4075: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
4076: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
4077: p_effective_date => l_effective_date, -- ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4078: p_manager_id => l_ws_mgr_id,
4079: p_assignment_id => l_assignment_id ) ;
4080: --
4081: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);

Line 4086: hr_utility.set_location('group_pl_id = ' || ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 1234);

4082: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
4083: --
4084: -- Create the group person life event
4085: --
4086: hr_utility.set_location('group_pl_id = ' || ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 1234);
4087: ben_Person_Life_Event_api.create_Person_Life_Event_perf
4088: (p_validate => false
4089: ,p_per_in_ler_id => l_curr_per_in_ler_id
4090: ,p_ler_id => p_group_ler_id

Line 4113: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);

4109: --
4110: -- Per in ler created is a group per in ler so populate other
4111: -- plan design tables.
4112: --
4113: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);
4114: if p_use_eff_dt_flag = 'Y' then
4115: --
4116: ben_manage_cwb_life_events.popu_cwb_tables(
4117: p_group_per_in_ler_id => l_curr_per_in_ler_id,

Line 4116: ben_manage_cwb_life_events.popu_cwb_tables(

4112: --
4113: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);
4114: if p_use_eff_dt_flag = 'Y' then
4115: --
4116: ben_manage_cwb_life_events.popu_cwb_tables(
4117: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4118: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4119: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4120: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,

Line 4118: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,

4114: if p_use_eff_dt_flag = 'Y' then
4115: --
4116: ben_manage_cwb_life_events.popu_cwb_tables(
4117: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4118: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4119: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4120: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4121: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
4122: p_use_eff_dt_flag => 'Y',

Line 4119: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,

4115: --
4116: ben_manage_cwb_life_events.popu_cwb_tables(
4117: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4118: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4119: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4120: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4121: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
4122: p_use_eff_dt_flag => 'Y',
4123: p_effective_date => p_effective_date);

Line 4120: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,

4116: ben_manage_cwb_life_events.popu_cwb_tables(
4117: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4118: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4119: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4120: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4121: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
4122: p_use_eff_dt_flag => 'Y',
4123: p_effective_date => p_effective_date);
4124: --

Line 4121: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,

4117: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4118: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4119: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4120: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4121: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
4122: p_use_eff_dt_flag => 'Y',
4123: p_effective_date => p_effective_date);
4124: --
4125: else

Line 4127: ben_manage_cwb_life_events.popu_cwb_tables(

4123: p_effective_date => p_effective_date);
4124: --
4125: else
4126: --
4127: ben_manage_cwb_life_events.popu_cwb_tables(
4128: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4129: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4130: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4131: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,

Line 4129: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,

4125: else
4126: --
4127: ben_manage_cwb_life_events.popu_cwb_tables(
4128: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4129: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4130: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4131: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4132: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);
4133: end if;

Line 4130: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,

4126: --
4127: ben_manage_cwb_life_events.popu_cwb_tables(
4128: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4129: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4130: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4131: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4132: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);
4133: end if;
4134: --

Line 4131: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,

4127: ben_manage_cwb_life_events.popu_cwb_tables(
4128: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4129: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4130: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4131: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4132: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);
4133: end if;
4134: --
4135: --

Line 4132: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);

4128: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4129: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4130: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4131: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4132: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);
4133: end if;
4134: --
4135: --
4136: -- Cache the cwb_person_data if not cached already

Line 4705: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;

4701: g_options_exists := null;
4702: g_cache_group_plan_rec := l_cache_group_plan_rec_temp;
4703: g_cache_cpg_rec.delete;
4704: g_cache_copy_person_bdgt_tbl := g_cache_copy_person_bdgt_tbl1;
4705: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
4706: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
4707: --
4708: ben_manage_cwb_life_events.global_process
4709: (Errbuf =>l_errbuf,

Line 4706: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;

4702: g_cache_group_plan_rec := l_cache_group_plan_rec_temp;
4703: g_cache_cpg_rec.delete;
4704: g_cache_copy_person_bdgt_tbl := g_cache_copy_person_bdgt_tbl1;
4705: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
4706: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
4707: --
4708: ben_manage_cwb_life_events.global_process
4709: (Errbuf =>l_errbuf,
4710: retcode =>l_retcode,

Line 4708: ben_manage_cwb_life_events.global_process

4704: g_cache_copy_person_bdgt_tbl := g_cache_copy_person_bdgt_tbl1;
4705: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
4706: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
4707: --
4708: ben_manage_cwb_life_events.global_process
4709: (Errbuf =>l_errbuf,
4710: retcode =>l_retcode,
4711: p_effective_date =>l_effective_date,
4712: p_validate =>p_validate,

Line 5019: end BEN_MANAGE_CWB_LIFE_EVENTS;

5015: end if;
5016: --
5017: end auto_allocate_budgets;
5018: --
5019: end BEN_MANAGE_CWB_LIFE_EVENTS;