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.PAY_JP_CREATE_CMA_PKG dependencies on PAY_JP_BEE_UTILITY_PKG

Line 12: c_value_if_null_tbl constant pay_jp_bee_utility_pkg.t_varchar2_tbl

8: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
9: c_non_res_iv_name constant pay_input_values_f.name%TYPE := 'NRES_FLAG';
10: -- need to set irregular def val except hr_api.g_varchar2 (entry_value_tbl exclude setting default value of parameter)
11: c_def_val varchar2(1000) := to_char(hr_api.g_number);
12: c_value_if_null_tbl constant pay_jp_bee_utility_pkg.t_varchar2_tbl
13: := pay_jp_bee_utility_pkg.entry_value_tbl(c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val);
14: c_non_taxable_GlbVal_name constant varchar2(80) := 'G_SAL_CMA_PUBLIC_TRANSPORT_NTXBL_ERN_MAX';
15: c_non_res_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
16: c_non_res_date_iv_name constant pay_input_values_f.name%TYPE := 'NRES_START_DATE';

Line 13: := pay_jp_bee_utility_pkg.entry_value_tbl(c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val);

9: c_non_res_iv_name constant pay_input_values_f.name%TYPE := 'NRES_FLAG';
10: -- need to set irregular def val except hr_api.g_varchar2 (entry_value_tbl exclude setting default value of parameter)
11: c_def_val varchar2(1000) := to_char(hr_api.g_number);
12: c_value_if_null_tbl constant pay_jp_bee_utility_pkg.t_varchar2_tbl
13: := pay_jp_bee_utility_pkg.entry_value_tbl(c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val);
14: c_non_taxable_GlbVal_name constant varchar2(80) := 'G_SAL_CMA_PUBLIC_TRANSPORT_NTXBL_ERN_MAX';
15: c_non_res_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
16: c_non_res_date_iv_name constant pay_input_values_f.name%TYPE := 'NRES_START_DATE';
17: c_res_date_iv_name constant pay_input_values_f.name%TYPE := 'PROJECTED_RES_DATE';

Line 75: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;

71: l_cma_rec per_jp_cma_utility_pkg.cma_rec;
72: -- itax_type_is_null exception;
73: multiple_traffic_tool_rec exception;
74: --
75: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
76: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
77: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
78: --
79: l_is_different boolean := false;

Line 76: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;

72: -- itax_type_is_null exception;
73: multiple_traffic_tool_rec exception;
74: --
75: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
76: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
77: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
78: --
79: l_is_different boolean := false;
80: l_record_exist boolean := false;

Line 77: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;

73: multiple_traffic_tool_rec exception;
74: --
75: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
76: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
77: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
78: --
79: l_is_different boolean := false;
80: l_record_exist boolean := false;
81: l_change_type hr_lookups.lookup_code%type;

Line 125: pay_jp_bee_utility_pkg.get_ee(

121: hr_utility.trace('upload_date : ' || to_char(p_upload_date));
122: --
123: -- Derive commutation allowance information from PAY_ELEMENT_ENTRIES_F.
124: --
125: pay_jp_bee_utility_pkg.get_ee(
126: p_assignment_id => p_assignment_id,
127: p_element_type_id => g_element_type_id,
128: p_effective_date => p_upload_date,
129: p_ee_rec => l_ee_rec,

Line 217: pay_jp_bee_utility_pkg.set_eev(

213: --
214: -- bug.5438168. c_value_if_null_tbl is changed to use hr_api.g_varchar2
215: -- because new behavior sets null values for unnecessary input values.
216: --
217: pay_jp_bee_utility_pkg.set_eev(
218: p_ee_rec => l_ee_rec,
219: p_eev_rec => l_eev_rec,
220: p_value_if_null_tbl => c_value_if_null_tbl,
221: p_new_value_tbl => l_new_value_tbl,

Line 244: pay_jp_bee_utility_pkg.out(

240: -- In this case, only the entry values to be changed are shown in output file.
241: --
242: l_change_type := 'C';
243: end if;
244: pay_jp_bee_utility_pkg.out(
245: p_full_name => p_full_name,
246: p_assignment_number => p_assignment_number,
247: p_effective_date => p_upload_date,
248: p_change_type => l_change_type,

Line 268: pay_jp_bee_utility_pkg.create_batch_line(

264: l_index := l_new_value_tbl.next(l_index);
265: end loop;
266: */
267: l_eev_rec.entry_value_tbl := l_new_value_tbl;
268: pay_jp_bee_utility_pkg.create_batch_line(
269: p_batch_id => p_batch_id,
270: p_assignment_id => p_assignment_id,
271: p_assignment_number => p_assignment_number,
272: p_element_type_id => g_element_type_id,

Line 286: pay_jp_bee_utility_pkg.log(

282: --
283: hr_utility.set_location('Leaving : ' || l_proc, 20);
284: exception
285: when multiple_traffic_tool_rec then
286: pay_jp_bee_utility_pkg.log(
287: p_full_name => p_full_name,
288: p_assignment_number => p_assignment_number,
289: p_application_short_name => 'PAY',
290: p_message_name => '',

Line 299: pay_jp_bee_utility_pkg.log(

295: hr_utility.set_location('Leaving : ' || l_proc, 26);
296: --
297: when others then
298: --
299: pay_jp_bee_utility_pkg.log(
300: p_full_name => p_full_name,
301: p_assignment_number => p_assignment_number,
302: p_application_short_name => 'PAY',
303: p_message_name => '',

Line 368: pay_jp_bee_utility_pkg.chk_upload_date(

364: hr_utility.set_location('Entering : ' || l_proc, 10);
365: --
366: -- Validate p_time_period_id and p_upload_date
367: --
368: pay_jp_bee_utility_pkg.chk_upload_date(
369: p_time_period_id => p_time_period_id,
370: p_upload_date => l_upload_date,
371: p_period_start_date => l_period_start_date,
372: p_period_end_date => l_period_end_date);

Line 380: pay_jp_bee_utility_pkg.chk_date_effective_changes(

376: -- Batch Reference :
377: --
378: -- Validate Date Effective Changes
379: --
380: pay_jp_bee_utility_pkg.chk_date_effective_changes(
381: p_action_if_exists => p_action_if_exists,
382: p_reject_if_future_changes => p_reject_if_future_changes,
383: p_date_effective_changes => l_date_effective_changes);
384: --

Line 480: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then

476: end if;
477: --
478: -- When no batch lines are created, delete batch header and set message as errbuf.
479: --
480: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then
481: hr_utility.trace('BEE Header deleted');
482: --
483: pay_batch_element_entry_api.delete_batch_header(
484: p_validate => false,

Line 496: if pay_jp_bee_utility_pkg.g_num_of_logs > 0 then

492: end if;
493: --
494: -- If at least 1 assignment failed to process, set concurrent request status "Incomplete".
495: --
496: if pay_jp_bee_utility_pkg.g_num_of_logs > 0 then
497: p_retcode := 1;
498: else
499: p_retcode := 0;
500: end if;