DBA Data[Home] [Help]

APPS.PAY_JP_LTAX_IMP_PKG dependencies on PAY_JP_BEE_UTILITY_PKG

Line 2043: l_com_ltx_info_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;

2039: l_ltax_end_mth varchar2(6);
2040: l_ltax_ini number;
2041: l_ltax_2nd number;
2042: --
2043: l_com_ltx_info_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
2044: l_com_ltx_info_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
2045: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
2046: --
2047: l_upd_eev boolean;

Line 2044: l_com_ltx_info_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;

2040: l_ltax_ini number;
2041: l_ltax_2nd number;
2042: --
2043: l_com_ltx_info_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
2044: l_com_ltx_info_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
2045: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
2046: --
2047: l_upd_eev boolean;
2048: l_is_different boolean;

Line 2045: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;

2041: l_ltax_2nd number;
2042: --
2043: l_com_ltx_info_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
2044: l_com_ltx_info_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
2045: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
2046: --
2047: l_upd_eev boolean;
2048: l_is_different boolean;
2049: l_change_type hr_lookups.lookup_code%type;

Line 2238: pay_jp_bee_utility_pkg.get_ee(

2234: and g_ee_tbl(i).upload_date <= l_final_process_date))) then
2235: --
2236: l_ltax_start_mth := to_char(g_ee_tbl(i).period_year)||lpad(to_char(g_ee_tbl(i).period_num),2,'0');
2237: --
2238: pay_jp_bee_utility_pkg.get_ee(
2239: p_assignment_id,
2240: c_com_ltx_info_elm_id,
2241: g_ee_tbl(i).upload_date,
2242: l_com_ltx_info_ee_rec,

Line 2423: pay_jp_bee_utility_pkg.set_eev(

2419: end loop;
2420: --
2421: end if;
2422: --
2423: pay_jp_bee_utility_pkg.set_eev(
2424: p_ee_rec => l_com_ltx_info_ee_rec,
2425: p_eev_rec => l_com_ltx_info_eev_rec,
2426: p_value_if_null_tbl => c_value_if_null_tbl,
2427: p_new_value_tbl => l_new_value_tbl,

Line 2453: pay_jp_bee_utility_pkg.out(

2449: hr_utility.set_location(l_proc,60);
2450: hr_utility.trace('l_change_type : '||l_change_type);
2451: end if;
2452: --
2453: pay_jp_bee_utility_pkg.out(
2454: p_full_name => g_ass_data_tbl(p_assignment_id).i_full_name,
2455: p_assignment_number => g_ass_data_tbl(p_assignment_id).assignment_number,
2456: p_effective_date => g_ee_tbl(i).upload_date,
2457: p_change_type => l_change_type,

Line 2464: pay_jp_bee_utility_pkg.create_batch_line(

2460: p_write_all => l_write_all);
2461: --
2462: l_com_ltx_info_eev_rec.entry_value_tbl := l_new_value_tbl;
2463: --
2464: pay_jp_bee_utility_pkg.create_batch_line(
2465: p_batch_id => p_batch_id,
2466: p_assignment_id => p_assignment_id,
2467: p_assignment_number => g_ass_data_tbl(p_assignment_id).assignment_number,
2468: p_element_type_id => c_com_ltx_info_elm_id,

Line 2601: pay_jp_bee_utility_pkg.g_num_of_outs := 0;

2597: if g_debug then
2598: hr_utility.set_location(l_proc,0);
2599: end if;
2600: --
2601: pay_jp_bee_utility_pkg.g_num_of_outs := 0;
2602: --
2603: l_upload_date := fnd_date.canonical_to_date(p_upload_date);
2604: l_date_effective_changes := p_date_effective_changes;
2605: --

Line 2608: hr_utility.trace('pay_jp_bee_utility_pkg.g_num_of_outs : '||to_char(pay_jp_bee_utility_pkg.g_num_of_outs));

2604: l_date_effective_changes := p_date_effective_changes;
2605: --
2606: if g_debug then
2607: hr_utility.set_location(l_proc,10);
2608: hr_utility.trace('pay_jp_bee_utility_pkg.g_num_of_outs : '||to_char(pay_jp_bee_utility_pkg.g_num_of_outs));
2609: hr_utility.trace('l_upload_date : '||to_char(l_upload_date,'YYYY/MM/DD'));
2610: end if;
2611: --
2612: init(

Line 2642: pay_jp_bee_utility_pkg.chk_date_effective_changes(

2638: if g_debug then
2639: hr_utility.set_location(l_proc,20);
2640: end if;
2641: --
2642: pay_jp_bee_utility_pkg.chk_date_effective_changes(
2643: g_action_if_exists,
2644: g_reject_if_future_changes,
2645: l_date_effective_changes);
2646: --

Line 2947: hr_utility.trace('pay_jp_bee_utility_pkg.g_num_of_outs : '||to_char(pay_jp_bee_utility_pkg.g_num_of_outs));

2943: end if;
2944: --
2945: if g_debug then
2946: hr_utility.set_location(l_proc,220);
2947: hr_utility.trace('pay_jp_bee_utility_pkg.g_num_of_outs : '||to_char(pay_jp_bee_utility_pkg.g_num_of_outs));
2948: end if;
2949: --
2950: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then
2951: --

Line 2950: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then

2946: hr_utility.set_location(l_proc,220);
2947: hr_utility.trace('pay_jp_bee_utility_pkg.g_num_of_outs : '||to_char(pay_jp_bee_utility_pkg.g_num_of_outs));
2948: end if;
2949: --
2950: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then
2951: --
2952: pay_batch_element_entry_api.delete_batch_header(
2953: p_validate => false,
2954: p_batch_id => l_batch_id,