DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_DPNT_INTERFACE_PKG dependencies on PAY_JP_BEE_UTILITY_PKG

Line 11: c_value_if_null_tbl constant pay_jp_bee_utility_pkg.t_varchar2_tbl

7: c_element_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
8: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
9: c_itax_type_iv_name constant pay_input_values_f.name%TYPE := 'ITX_TYPE';
10: c_non_res_iv_name constant pay_input_values_f.name%TYPE := 'NRES_FLAG';
11: c_value_if_null_tbl constant pay_jp_bee_utility_pkg.t_varchar2_tbl
12: := pay_jp_bee_utility_pkg.entry_value_tbl('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
13: c_non_res_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
14: c_non_res_date_iv_name constant pay_input_values_f.name%TYPE := 'NRES_START_DATE';
15: c_res_date_iv_name constant pay_input_values_f.name%TYPE := 'PROJECTED_RES_DATE';

Line 12: := pay_jp_bee_utility_pkg.entry_value_tbl('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

8: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
9: c_itax_type_iv_name constant pay_input_values_f.name%TYPE := 'ITX_TYPE';
10: c_non_res_iv_name constant pay_input_values_f.name%TYPE := 'NRES_FLAG';
11: c_value_if_null_tbl constant pay_jp_bee_utility_pkg.t_varchar2_tbl
12: := pay_jp_bee_utility_pkg.entry_value_tbl('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
13: c_non_res_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
14: c_non_res_date_iv_name constant pay_input_values_f.name%TYPE := 'NRES_START_DATE';
15: c_res_date_iv_name constant pay_input_values_f.name%TYPE := 'PROJECTED_RES_DATE';
16: --

Line 83: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;

79: l_itax_dpnt_rec per_jp_ctr_utility_pkg.t_itax_dpnt_rec;
80: itax_type_is_null exception;
81: multiple_spouses exception;
82: --
83: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
84: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
85: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
86: --
87: l_is_different boolean := false;

Line 84: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;

80: itax_type_is_null exception;
81: multiple_spouses exception;
82: --
83: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
84: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
85: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
86: --
87: l_is_different boolean := false;
88: l_change_type hr_lookups.lookup_code%type;

Line 85: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;

81: multiple_spouses exception;
82: --
83: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
84: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
85: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
86: --
87: l_is_different boolean := false;
88: l_change_type hr_lookups.lookup_code%type;
89: l_write_all boolean := false;

Line 127: pay_jp_bee_utility_pkg.get_ee(

123: hr_utility.trace('upload_date : ' || to_char(p_upload_date));
124: --
125: -- Derive income tax dependent information from PAY_ELEMENT_ENTRIES_F.
126: --
127: pay_jp_bee_utility_pkg.get_ee(
128: p_assignment_id => p_assignment_id,
129: p_element_type_id => g_element_type_id,
130: p_effective_date => p_upload_date,
131: p_ee_rec => l_ee_rec,

Line 239: pay_jp_bee_utility_pkg.set_eev(

235: --
236: -- Check whether the new_value_tbl is different from eev_rec.entry_value_tbl.
237: -- The following procedure changes new_value_tbl based on eev.
238: --
239: pay_jp_bee_utility_pkg.set_eev(
240: p_ee_rec => l_ee_rec,
241: p_eev_rec => l_eev_rec,
242: p_value_if_null_tbl => c_value_if_null_tbl,
243: p_new_value_tbl => l_new_value_tbl,

Line 271: pay_jp_bee_utility_pkg.out(

267: else
268: l_change_type := 'U';
269: end if;
270: end if;
271: pay_jp_bee_utility_pkg.out(
272: p_full_name => p_full_name,
273: p_assignment_number => p_assignment_number,
274: p_effective_date => p_upload_date,
275: p_change_type => l_change_type,

Line 283: pay_jp_bee_utility_pkg.create_batch_line(

279: --
280: -- Create BEE Line
281: --
282: l_eev_rec.entry_value_tbl := l_new_value_tbl;
283: pay_jp_bee_utility_pkg.create_batch_line(
284: p_batch_id => p_batch_id,
285: p_assignment_id => p_assignment_id,
286: p_assignment_number => p_assignment_number,
287: p_element_type_id => g_element_type_id,

Line 301: pay_jp_bee_utility_pkg.log(

297: --
298: hr_utility.set_location('Leaving : ' || l_proc, 20);
299: exception
300: when itax_type_is_null then
301: pay_jp_bee_utility_pkg.log(
302: p_full_name => p_full_name,
303: p_assignment_number => p_assignment_number,
304: p_application_short_name => 'PAY',
305: p_message_name => 'PAY_JP_ITAX_DPNT_NO_ITAX_TYPE',

Line 312: pay_jp_bee_utility_pkg.log(

308: create_asg_set_amd;
309: --
310: hr_utility.set_location('Leaving : ' || l_proc, 25);
311: when multiple_spouses then
312: pay_jp_bee_utility_pkg.log(
313: p_full_name => p_full_name,
314: p_assignment_number => p_assignment_number,
315: p_application_short_name => 'PAY',
316: p_message_name => 'PAY_JP_ITAX_DPNT_MULTI_SPOUSES',

Line 392: pay_jp_bee_utility_pkg.chk_upload_date(

388: end if;
389: --
390: -- Validate p_time_period_id and p_upload_date
391: --
392: pay_jp_bee_utility_pkg.chk_upload_date(
393: p_time_period_id => p_time_period_id,
394: p_upload_date => l_upload_date,
395: p_period_start_date => l_period_start_date,
396: p_period_end_date => l_period_end_date);

Line 404: pay_jp_bee_utility_pkg.chk_date_effective_changes(

400: -- Batch Reference :
401: --
402: -- Validate Date Effective Changes
403: --
404: pay_jp_bee_utility_pkg.chk_date_effective_changes(
405: p_action_if_exists => p_action_if_exists,
406: p_reject_if_future_changes => p_reject_if_future_changes,
407: p_date_effective_changes => l_date_effective_changes);
408: --

Line 494: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then

490: end if;
491: --
492: -- When no batch lines are created, delete batch header and set message as errbuf.
493: --
494: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then
495: hr_utility.trace('BEE Header deleted');
496: --
497: pay_batch_element_entry_api.delete_batch_header(
498: p_validate => false,

Line 510: if pay_jp_bee_utility_pkg.g_num_of_logs > 0 then

506: end if;
507: --
508: -- If at least 1 assignment failed to process, set concurrent request status "Incomplete".
509: --
510: if pay_jp_bee_utility_pkg.g_num_of_logs > 0 then
511: p_retcode := 1;
512: else
513: p_retcode := 0;
514: end if;