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.31.12010000.3 2008/09/24 09:18:31 sgnanama ship $ */
3: --
4: /*
5: +========================================================================+

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

209: 24-Sep-08 sgnanama 115.81 7393142: process for terminated employee
210: */
211: --------------------------------------------------------------------------------
212: --
213: g_package varchar2(80) := 'ben_manage_cwb_life_events';
214: --
215: g_debug boolean := hr_utility.debug_enabled;
216: g_rebuild_pl_id number := null;
217: g_rebuild_lf_evt_ocrd_dt date := null;

Line 263: ,p_cwb_processes_rec in ben_manage_cwb_life_events.g_cwb_processes_table

259:
260: --
261: procedure check_slaves_status
262: (p_num_cwb_processes in number
263: ,p_cwb_processes_rec in ben_manage_cwb_life_events.g_cwb_processes_table
264: -- ,p_master in varchar2
265: ,p_slave_errored out nocopy boolean
266: )
267: is

Line 387: (p_num_cwb_processes => ben_manage_cwb_life_events.g_num_cwb_processes

383: */
384: -- Check slave status
385: --
386: check_slaves_status
387: (p_num_cwb_processes => ben_manage_cwb_life_events.g_num_cwb_processes
388: ,p_cwb_processes_rec => ben_manage_cwb_life_events.g_cwb_processes_rec
389: -- ,p_master => l_master
390: --
391: ,p_slave_errored => l_slave_errored

Line 388: ,p_cwb_processes_rec => ben_manage_cwb_life_events.g_cwb_processes_rec

384: -- Check slave status
385: --
386: check_slaves_status
387: (p_num_cwb_processes => ben_manage_cwb_life_events.g_num_cwb_processes
388: ,p_cwb_processes_rec => ben_manage_cwb_life_events.g_cwb_processes_rec
389: -- ,p_master => l_master
390: --
391: ,p_slave_errored => l_slave_errored
392: );

Line 2047: ben_manage_cwb_life_events.get_group_plan_info(

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,
2049: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
2050: p_business_group_id => p_business_group_id);
2051: --

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

2049: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
2050: p_business_group_id => p_business_group_id);
2051: --
2052: hr_utility.set_location('group_pl_id ' ||
2053: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,20);
2054: if p_pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id
2055: then
2056: --
2057: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := null;

Line 2054: if p_pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id

2050: p_business_group_id => p_business_group_id);
2051: --
2052: hr_utility.set_location('group_pl_id ' ||
2053: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,20);
2054: if p_pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id
2055: then
2056: --
2057: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := null;
2058: --

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

2053: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,20);
2054: if p_pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id
2055: then
2056: --
2057: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := null;
2058: --
2059: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
2060: (p_person_id => p_person_id,
2061: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,

Line 2059: ben_manage_cwb_life_events.get_cwb_manager_and_assignment

2055: then
2056: --
2057: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := null;
2058: --
2059: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
2060: (p_person_id => p_person_id,
2061: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
2062: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
2063: p_effective_date => p_effective_date,

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

2057: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := null;
2058: --
2059: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
2060: (p_person_id => p_person_id,
2061: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
2062: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
2063: p_effective_date => p_effective_date,
2064: p_manager_id => l_ws_mgr_id,
2065: p_assignment_id => l_assignment_id ) ;

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

2058: --
2059: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
2060: (p_person_id => p_person_id,
2061: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
2062: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
2063: p_effective_date => p_effective_date,
2064: p_manager_id => l_ws_mgr_id,
2065: p_assignment_id => l_assignment_id ) ;
2066: --

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

2103: */
2104: end if;
2105: --
2106: hr_utility.set_location('group_pl_id = ' ||
2107: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 30);
2108: --
2109: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);
2110: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
2111: ben_Person_Life_Event_api.create_Person_Life_Event_perf

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

2117: ,p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
2118: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
2119: ,p_business_group_id => p_business_group_id
2120: ,p_ntfn_dt => trunc(sysdate)
2121: ,p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_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

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

2132: ,p_voidd_dt => l_voidd_dt);
2133: --
2134: -- Now clone the ben_cwb_person_rates, ben_cwb_group_rates.
2135: --
2136: if p_pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
2137: --
2138: -- Per in ler created is a group per in ler so populate other
2139: -- plan design tables.
2140: --

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

2137: --
2138: -- Per in ler created is a group per in ler so populate other
2139: -- plan design tables.
2140: --
2141: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := l_curr_per_in_ler_id;
2142: --
2143: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);
2144: ben_manage_cwb_life_events.popu_cwb_tables(
2145: p_group_per_in_ler_id => l_curr_per_in_ler_id,

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

2139: -- plan design tables.
2140: --
2141: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := l_curr_per_in_ler_id;
2142: --
2143: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);
2144: ben_manage_cwb_life_events.popu_cwb_tables(
2145: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2146: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2147: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,

Line 2144: ben_manage_cwb_life_events.popu_cwb_tables(

2140: --
2141: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := l_curr_per_in_ler_id;
2142: --
2143: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);
2144: ben_manage_cwb_life_events.popu_cwb_tables(
2145: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2146: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2147: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
2148: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,

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

2142: --
2143: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);
2144: ben_manage_cwb_life_events.popu_cwb_tables(
2145: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2146: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2147: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
2148: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
2149: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
2150: p_effective_date => p_effective_date,

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

2143: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);
2144: ben_manage_cwb_life_events.popu_cwb_tables(
2145: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2146: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2147: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
2148: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
2149: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
2150: p_effective_date => p_effective_date,
2151: p_use_eff_dt_flag => 'Y');

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

2144: ben_manage_cwb_life_events.popu_cwb_tables(
2145: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2146: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2147: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
2148: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
2149: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
2150: p_effective_date => p_effective_date,
2151: p_use_eff_dt_flag => 'Y');
2152: --

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

2145: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2146: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2147: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
2148: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
2149: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
2150: p_effective_date => p_effective_date,
2151: p_use_eff_dt_flag => 'Y');
2152: --
2153: -- For each of the group rates rows for a sample person

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

2152: --
2153: -- For each of the group rates rows for a sample person
2154: -- copy data to current person.
2155: --
2156: for l_cpg_rec in c_cpg(ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2157: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt)
2158: loop
2159: --
2160: -- create row in ben_cwb_person_groups

Line 2157: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt)

2153: -- For each of the group rates rows for a sample person
2154: -- copy data to current person.
2155: --
2156: for l_cpg_rec in c_cpg(ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2157: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt)
2158: loop
2159: --
2160: -- create row in ben_cwb_person_groups
2161: --

Line 2781: ben_manage_cwb_life_events.g_num_cwb_processes :=

2777: );
2778: --
2779: commit ;
2780: --
2781: ben_manage_cwb_life_events.g_num_cwb_processes :=
2782: ben_manage_cwb_life_events.g_num_cwb_processes + 1;
2783: ben_manage_cwb_life_events.g_cwb_processes_rec(g_num_cwb_processes) := l_request_id;
2784: --
2785: --

Line 2782: ben_manage_cwb_life_events.g_num_cwb_processes + 1;

2778: --
2779: commit ;
2780: --
2781: ben_manage_cwb_life_events.g_num_cwb_processes :=
2782: ben_manage_cwb_life_events.g_num_cwb_processes + 1;
2783: ben_manage_cwb_life_events.g_cwb_processes_rec(g_num_cwb_processes) := l_request_id;
2784: --
2785: --
2786: fnd_file.put_line(which => fnd_file.log,

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

2779: commit ;
2780: --
2781: ben_manage_cwb_life_events.g_num_cwb_processes :=
2782: ben_manage_cwb_life_events.g_num_cwb_processes + 1;
2783: ben_manage_cwb_life_events.g_cwb_processes_rec(g_num_cwb_processes) := l_request_id;
2784: --
2785: --
2786: fnd_file.put_line(which => fnd_file.log,
2787: buff => 'Submitted the concurrent request id '||l_request_id||

Line 2959: ben_manage_cwb_life_events.get_group_plan_info(

2955: --
2956: g_error_log_rec.calling_proc := 'get_group_plan_info';
2957: g_error_log_rec.step_number := 1;
2958: --
2959: ben_manage_cwb_life_events.get_group_plan_info(
2960: p_group_pl_id => l_pl_id
2961: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
2962: ,p_pl_id => null
2963: );

Line 2978: ben_manage_cwb_life_events.popu_cwb_group_pil_data (

2974: --
2975: g_error_log_rec.calling_proc := 'popu_cwb_group_pil_data';
2976: g_error_log_rec.step_number := 2;
2977: --
2978: ben_manage_cwb_life_events.popu_cwb_group_pil_data (
2979: p_group_per_in_ler_id => -9999
2980: ,p_group_pl_id => g_cache_group_plan_rec.group_pl_id
2981: ,p_group_lf_evt_ocrd_dt => g_cache_group_plan_rec.group_lf_evt_ocrd_dt
2982: ,p_group_business_group_id => g_cache_group_plan_rec.group_business_group_id

Line 2991: if ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id is null

2987: -- clone ben_cwb_person_group data out side of
2988: -- popu_cwb_group_pil_data for persons outside the group plan's
2989: -- business group. This is to avoid cloning of data for managers.
2990: --
2991: if ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id is null
2992: then
2993: --
2994: g_error_log_rec.calling_proc := 'p_single_per_clone_all_data';
2995: g_error_log_rec.step_number := 3;

Line 3011: ben_manage_cwb_life_events.popu_cwb_group_pil_data (

3007: --
3008: g_error_log_rec.calling_proc := 'popu_cwb_group_pil_data';
3009: g_error_log_rec.step_number := 4;
3010: --
3011: ben_manage_cwb_life_events.popu_cwb_group_pil_data (
3012: p_group_per_in_ler_id => -9999
3013: ,p_group_pl_id => g_cache_group_plan_rec.group_pl_id
3014: ,p_group_lf_evt_ocrd_dt => g_cache_group_plan_rec.group_lf_evt_ocrd_dt
3015: ,p_group_business_group_id => g_cache_group_plan_rec.group_business_group_id

Line 3030: ben_manage_cwb_life_events.popu_group_pil_heir(

3026: --
3027: g_error_log_rec.calling_proc := 'popu_group_pil_heir';
3028: g_error_log_rec.step_number := 4;
3029: --
3030: ben_manage_cwb_life_events.popu_group_pil_heir(
3031: p_group_pl_id => g_cache_group_plan_rec.group_pl_id
3032: ,p_group_lf_evt_ocrd_dt => g_cache_group_plan_rec.group_lf_evt_ocrd_dt
3033: ,p_group_business_group_id => g_cache_group_plan_rec.group_business_group_id
3034: ,p_group_ler_id => g_cache_group_plan_rec.group_ler_id ) ;

Line 3085: ben_manage_cwb_life_events.auto_allocate_budgets (

3081: --
3082: g_error_log_rec.calling_proc := 'auto_allocate_budgets';
3083: g_error_log_rec.step_number := 5;
3084: --
3085: ben_manage_cwb_life_events.auto_allocate_budgets (
3086: p_group_pl_id => g_cache_group_plan_rec.group_pl_id
3087: ,p_lf_evt_ocrd_dt => g_cache_group_plan_rec.group_lf_evt_ocrd_dt);
3088: --
3089: end if;

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

3189: --
3190: --
3191: -- Spawn the reports at the end.
3192: --
3193: if nvl(ben_manage_cwb_life_events.g_num_cwb_processes, 0) <> 0
3194: then
3195: --
3196: fnd_file.put_line(which => fnd_file.log,
3197: buff => 'An error occurred in the rollup routine. After fixing the ' ||

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

3203: then
3204: --
3205: rollback to cwb_global_process;
3206: --
3207: for elenum in 1..ben_manage_cwb_life_events.g_num_cwb_processes
3208: loop
3209: --
3210: ben_batch_reporting.batch_reports
3211: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),

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

3207: for elenum in 1..ben_manage_cwb_life_events.g_num_cwb_processes
3208: loop
3209: --
3210: ben_batch_reporting.batch_reports
3211: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),
3212: p_mode => 'W',
3213: p_report_type => 'ACTIVITY_SUMMARY');
3214: --
3215: ben_batch_reporting.batch_reports

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

3212: p_mode => 'W',
3213: p_report_type => 'ACTIVITY_SUMMARY');
3214: --
3215: ben_batch_reporting.batch_reports
3216: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),
3217: p_report_type => 'ERROR_BY_PERSON');
3218: --
3219: end loop;
3220: --

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

3233: --
3234: g_error_log_rec.calling_proc := 'Before Reports';
3235: g_error_log_rec.step_number := 8;
3236: --
3237: if nvl(ben_manage_cwb_life_events.g_num_cwb_processes, 0) <> 0
3238: then
3239: --
3240: if l_supress_report = 'Y' then
3241: for elenum in 1..ben_manage_cwb_life_events.g_num_cwb_processes

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

3237: if nvl(ben_manage_cwb_life_events.g_num_cwb_processes, 0) <> 0
3238: then
3239: --
3240: if l_supress_report = 'Y' then
3241: for elenum in 1..ben_manage_cwb_life_events.g_num_cwb_processes
3242: loop
3243: --
3244: ben_batch_reporting.batch_reports
3245: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),

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

3241: for elenum in 1..ben_manage_cwb_life_events.g_num_cwb_processes
3242: loop
3243: --
3244: ben_batch_reporting.batch_reports
3245: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),
3246: p_mode => 'W',
3247: p_report_type => 'ACTIVITY_SUMMARY');
3248: --
3249: ben_batch_reporting.batch_reports

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

3246: p_mode => 'W',
3247: p_report_type => 'ACTIVITY_SUMMARY');
3248: --
3249: ben_batch_reporting.batch_reports
3250: (p_concurrent_request_id => ben_manage_cwb_life_events.g_cwb_processes_rec(elenum),
3251: p_report_type => 'ERROR_BY_PERSON');
3252: --
3253: end loop;
3254: end if;

Line 3817: ben_manage_cwb_life_events.popu_group_pil_heir(

3813: end if;
3814: --
3815: begin
3816: --
3817: ben_manage_cwb_life_events.popu_group_pil_heir(
3818: g_rebuild_pl_id,
3819: g_rebuild_lf_evt_ocrd_dt,
3820: g_rebuild_business_group_id,
3821: l_ler_id ) ;

Line 4021: ben_manage_cwb_life_events.get_cwb_manager_and_assignment

4017: p_program_update_date => trunc(sysdate));
4018: --
4019: -- Get the manager information.
4020: --
4021: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
4022: (p_person_id => p_person_id,
4023: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
4024: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
4025: p_effective_date => l_effective_date, -- ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,

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

4019: -- Get the manager information.
4020: --
4021: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
4022: (p_person_id => p_person_id,
4023: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
4024: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
4025: p_effective_date => l_effective_date, -- ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4026: p_manager_id => l_ws_mgr_id,
4027: p_assignment_id => l_assignment_id ) ;

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

4020: --
4021: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
4022: (p_person_id => p_person_id,
4023: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
4024: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
4025: p_effective_date => l_effective_date, -- ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4026: p_manager_id => l_ws_mgr_id,
4027: p_assignment_id => l_assignment_id ) ;
4028: --

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

4021: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
4022: (p_person_id => p_person_id,
4023: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
4024: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
4025: p_effective_date => l_effective_date, -- ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4026: p_manager_id => l_ws_mgr_id,
4027: p_assignment_id => l_assignment_id ) ;
4028: --
4029: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);

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

4030: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
4031: --
4032: -- Create the group person life event
4033: --
4034: hr_utility.set_location('group_pl_id = ' || ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 1234);
4035: ben_Person_Life_Event_api.create_Person_Life_Event_perf
4036: (p_validate => false
4037: ,p_per_in_ler_id => l_curr_per_in_ler_id
4038: ,p_ler_id => p_group_ler_id

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

4057: --
4058: -- Per in ler created is a group per in ler so populate other
4059: -- plan design tables.
4060: --
4061: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);
4062: if p_use_eff_dt_flag = 'Y' then
4063: --
4064: ben_manage_cwb_life_events.popu_cwb_tables(
4065: p_group_per_in_ler_id => l_curr_per_in_ler_id,

Line 4064: ben_manage_cwb_life_events.popu_cwb_tables(

4060: --
4061: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);
4062: if p_use_eff_dt_flag = 'Y' then
4063: --
4064: ben_manage_cwb_life_events.popu_cwb_tables(
4065: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4066: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4067: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4068: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,

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

4062: if p_use_eff_dt_flag = 'Y' then
4063: --
4064: ben_manage_cwb_life_events.popu_cwb_tables(
4065: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4066: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4067: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4068: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4069: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
4070: p_use_eff_dt_flag => 'Y',

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

4063: --
4064: ben_manage_cwb_life_events.popu_cwb_tables(
4065: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4066: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4067: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4068: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4069: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
4070: p_use_eff_dt_flag => 'Y',
4071: p_effective_date => p_effective_date);

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

4064: ben_manage_cwb_life_events.popu_cwb_tables(
4065: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4066: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4067: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4068: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4069: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
4070: p_use_eff_dt_flag => 'Y',
4071: p_effective_date => p_effective_date);
4072: --

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

4065: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4066: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4067: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4068: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4069: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id,
4070: p_use_eff_dt_flag => 'Y',
4071: p_effective_date => p_effective_date);
4072: --
4073: else

Line 4075: ben_manage_cwb_life_events.popu_cwb_tables(

4071: p_effective_date => p_effective_date);
4072: --
4073: else
4074: --
4075: ben_manage_cwb_life_events.popu_cwb_tables(
4076: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4077: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4078: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4079: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,

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

4073: else
4074: --
4075: ben_manage_cwb_life_events.popu_cwb_tables(
4076: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4077: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4078: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4079: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4080: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);
4081: end if;

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

4074: --
4075: ben_manage_cwb_life_events.popu_cwb_tables(
4076: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4077: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4078: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4079: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4080: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);
4081: end if;
4082: --

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

4075: ben_manage_cwb_life_events.popu_cwb_tables(
4076: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4077: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4078: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4079: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4080: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);
4081: end if;
4082: --
4083: --

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

4076: p_group_per_in_ler_id => l_curr_per_in_ler_id,
4077: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
4078: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4079: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
4080: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);
4081: end if;
4082: --
4083: --
4084: -- Cache the cwb_person_data if not cached already

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

4649: g_options_exists := null;
4650: g_cache_group_plan_rec := l_cache_group_plan_rec_temp;
4651: g_cache_cpg_rec.delete;
4652: g_cache_copy_person_bdgt_tbl := g_cache_copy_person_bdgt_tbl1;
4653: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
4654: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
4655: --
4656: ben_manage_cwb_life_events.global_process
4657: (Errbuf =>l_errbuf,

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

4650: g_cache_group_plan_rec := l_cache_group_plan_rec_temp;
4651: g_cache_cpg_rec.delete;
4652: g_cache_copy_person_bdgt_tbl := g_cache_copy_person_bdgt_tbl1;
4653: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
4654: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
4655: --
4656: ben_manage_cwb_life_events.global_process
4657: (Errbuf =>l_errbuf,
4658: retcode =>l_retcode,

Line 4656: ben_manage_cwb_life_events.global_process

4652: g_cache_copy_person_bdgt_tbl := g_cache_copy_person_bdgt_tbl1;
4653: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
4654: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
4655: --
4656: ben_manage_cwb_life_events.global_process
4657: (Errbuf =>l_errbuf,
4658: retcode =>l_retcode,
4659: p_effective_date =>l_effective_date,
4660: p_validate =>p_validate,

Line 4965: end BEN_MANAGE_CWB_LIFE_EVENTS;

4961: end if;
4962: --
4963: end auto_allocate_budgets;
4964: --
4965: end BEN_MANAGE_CWB_LIFE_EVENTS;