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: c_elm pay_element_types_f.element_name%TYPE;

Line 125: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;

121: l_itax_dpnt_rec per_jp_ctr_utility_pkg.t_itax_dpnt_rec;
122: itax_type_is_null exception;
123: multiple_spouses exception;
124: --
125: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
126: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
127: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
128: --
129: l_is_different boolean := false;

Line 126: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;

122: itax_type_is_null exception;
123: multiple_spouses exception;
124: --
125: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
126: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
127: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
128: --
129: l_is_different boolean := false;
130: l_change_type hr_lookups.lookup_code%type;

Line 127: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;

123: multiple_spouses exception;
124: --
125: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
126: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
127: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
128: --
129: l_is_different boolean := false;
130: l_change_type hr_lookups.lookup_code%type;
131: l_write_all boolean := false;

Line 169: pay_jp_bee_utility_pkg.get_ee(

165: hr_utility.trace('upload_date : ' || to_char(p_upload_date));
166: --
167: -- Derive income tax dependent information from PAY_ELEMENT_ENTRIES_F.
168: --
169: pay_jp_bee_utility_pkg.get_ee(
170: p_assignment_id => p_assignment_id,
171: p_element_type_id => g_element_type_id,
172: p_effective_date => p_upload_date,
173: p_ee_rec => l_ee_rec,

Line 281: pay_jp_bee_utility_pkg.set_eev(

277: --
278: -- Check whether the new_value_tbl is different from eev_rec.entry_value_tbl.
279: -- The following procedure changes new_value_tbl based on eev.
280: --
281: pay_jp_bee_utility_pkg.set_eev(
282: p_ee_rec => l_ee_rec,
283: p_eev_rec => l_eev_rec,
284: p_value_if_null_tbl => c_value_if_null_tbl,
285: p_new_value_tbl => l_new_value_tbl,

Line 313: pay_jp_bee_utility_pkg.out(

309: else
310: l_change_type := 'U';
311: end if;
312: end if;
313: pay_jp_bee_utility_pkg.out(
314: p_full_name => p_full_name,
315: p_assignment_number => p_assignment_number,
316: p_effective_date => p_upload_date,
317: p_change_type => l_change_type,

Line 325: pay_jp_bee_utility_pkg.create_batch_line(

321: --
322: -- Create BEE Line
323: --
324: l_eev_rec.entry_value_tbl := l_new_value_tbl;
325: pay_jp_bee_utility_pkg.create_batch_line(
326: p_batch_id => p_batch_id,
327: p_assignment_id => p_assignment_id,
328: p_assignment_number => p_assignment_number,
329: p_element_type_id => g_element_type_id,

Line 343: pay_jp_bee_utility_pkg.log(

339: --
340: hr_utility.set_location('Leaving : ' || l_proc, 20);
341: exception
342: when itax_type_is_null then
343: pay_jp_bee_utility_pkg.log(
344: p_full_name => p_full_name,
345: p_assignment_number => p_assignment_number,
346: p_application_short_name => 'PAY',
347: p_message_name => 'PAY_JP_ITAX_DPNT_NO_ITAX_TYPE',

Line 354: pay_jp_bee_utility_pkg.log(

350: create_asg_set_amd;
351: --
352: hr_utility.set_location('Leaving : ' || l_proc, 25);
353: when multiple_spouses then
354: pay_jp_bee_utility_pkg.log(
355: p_full_name => p_full_name,
356: p_assignment_number => p_assignment_number,
357: p_application_short_name => 'PAY',
358: p_message_name => 'PAY_JP_ITAX_DPNT_MULTI_SPOUSES',

Line 434: pay_jp_bee_utility_pkg.chk_upload_date(

430: end if;
431: --
432: -- Validate p_time_period_id and p_upload_date
433: --
434: pay_jp_bee_utility_pkg.chk_upload_date(
435: p_time_period_id => p_time_period_id,
436: p_upload_date => l_upload_date,
437: p_period_start_date => l_period_start_date,
438: p_period_end_date => l_period_end_date);

Line 446: pay_jp_bee_utility_pkg.chk_date_effective_changes(

442: -- Batch Reference :
443: --
444: -- Validate Date Effective Changes
445: --
446: pay_jp_bee_utility_pkg.chk_date_effective_changes(
447: p_action_if_exists => p_action_if_exists,
448: p_reject_if_future_changes => p_reject_if_future_changes,
449: p_date_effective_changes => l_date_effective_changes);
450: --

Line 542: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then

538: end if;
539: --
540: -- When no batch lines are created, delete batch header and set message as errbuf.
541: --
542: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then
543: hr_utility.trace('BEE Header deleted');
544: --
545: pay_batch_element_entry_api.delete_batch_header(
546: p_validate => false,

Line 558: if pay_jp_bee_utility_pkg.g_num_of_logs > 0 then

554: end if;
555: --
556: -- If at least 1 assignment failed to process, set concurrent request status "Incomplete".
557: --
558: if pay_jp_bee_utility_pkg.g_num_of_logs > 0 then
559: p_retcode := 1;
560: else
561: p_retcode := 0;
562: end if;