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 117: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;

113: l_cma_rec per_jp_cma_utility_pkg.cma_rec;
114: -- itax_type_is_null exception;
115: multiple_traffic_tool_rec exception;
116: --
117: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
118: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
119: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
120: --
121: l_is_different boolean := false;

Line 118: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;

114: -- itax_type_is_null exception;
115: multiple_traffic_tool_rec exception;
116: --
117: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
118: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
119: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
120: --
121: l_is_different boolean := false;
122: l_record_exist boolean := false;

Line 119: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;

115: multiple_traffic_tool_rec exception;
116: --
117: l_ee_rec pay_jp_bee_utility_pkg.t_ee_rec;
118: l_eev_rec pay_jp_bee_utility_pkg.t_eev_rec;
119: l_new_value_tbl pay_jp_bee_utility_pkg.t_varchar2_tbl;
120: --
121: l_is_different boolean := false;
122: l_record_exist boolean := false;
123: l_change_type hr_lookups.lookup_code%type;

Line 167: pay_jp_bee_utility_pkg.get_ee(

163: hr_utility.trace('upload_date : ' || to_char(p_upload_date));
164: --
165: -- Derive commutation allowance information from PAY_ELEMENT_ENTRIES_F.
166: --
167: pay_jp_bee_utility_pkg.get_ee(
168: p_assignment_id => p_assignment_id,
169: p_element_type_id => g_element_type_id,
170: p_effective_date => p_upload_date,
171: p_ee_rec => l_ee_rec,

Line 259: pay_jp_bee_utility_pkg.set_eev(

255: --
256: -- bug.5438168. c_value_if_null_tbl is changed to use hr_api.g_varchar2
257: -- because new behavior sets null values for unnecessary input values.
258: --
259: pay_jp_bee_utility_pkg.set_eev(
260: p_ee_rec => l_ee_rec,
261: p_eev_rec => l_eev_rec,
262: p_value_if_null_tbl => c_value_if_null_tbl,
263: p_new_value_tbl => l_new_value_tbl,

Line 286: pay_jp_bee_utility_pkg.out(

282: -- In this case, only the entry values to be changed are shown in output file.
283: --
284: l_change_type := 'C';
285: end if;
286: pay_jp_bee_utility_pkg.out(
287: p_full_name => p_full_name,
288: p_assignment_number => p_assignment_number,
289: p_effective_date => p_upload_date,
290: p_change_type => l_change_type,

Line 310: pay_jp_bee_utility_pkg.create_batch_line(

306: l_index := l_new_value_tbl.next(l_index);
307: end loop;
308: */
309: l_eev_rec.entry_value_tbl := l_new_value_tbl;
310: pay_jp_bee_utility_pkg.create_batch_line(
311: p_batch_id => p_batch_id,
312: p_assignment_id => p_assignment_id,
313: p_assignment_number => p_assignment_number,
314: p_element_type_id => g_element_type_id,

Line 328: pay_jp_bee_utility_pkg.log(

324: --
325: hr_utility.set_location('Leaving : ' || l_proc, 20);
326: exception
327: when multiple_traffic_tool_rec then
328: pay_jp_bee_utility_pkg.log(
329: p_full_name => p_full_name,
330: p_assignment_number => p_assignment_number,
331: p_application_short_name => 'PAY',
332: p_message_name => '',

Line 341: pay_jp_bee_utility_pkg.log(

337: hr_utility.set_location('Leaving : ' || l_proc, 26);
338: --
339: when others then
340: --
341: pay_jp_bee_utility_pkg.log(
342: p_full_name => p_full_name,
343: p_assignment_number => p_assignment_number,
344: p_application_short_name => 'PAY',
345: p_message_name => '',

Line 410: pay_jp_bee_utility_pkg.chk_upload_date(

406: hr_utility.set_location('Entering : ' || l_proc, 10);
407: --
408: -- Validate p_time_period_id and p_upload_date
409: --
410: pay_jp_bee_utility_pkg.chk_upload_date(
411: p_time_period_id => p_time_period_id,
412: p_upload_date => l_upload_date,
413: p_period_start_date => l_period_start_date,
414: p_period_end_date => l_period_end_date);

Line 422: pay_jp_bee_utility_pkg.chk_date_effective_changes(

418: -- Batch Reference :
419: --
420: -- Validate Date Effective Changes
421: --
422: pay_jp_bee_utility_pkg.chk_date_effective_changes(
423: p_action_if_exists => p_action_if_exists,
424: p_reject_if_future_changes => p_reject_if_future_changes,
425: p_date_effective_changes => l_date_effective_changes);
426: --

Line 528: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then

524: end if;
525: --
526: -- When no batch lines are created, delete batch header and set message as errbuf.
527: --
528: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then
529: hr_utility.trace('BEE Header deleted');
530: --
531: pay_batch_element_entry_api.delete_batch_header(
532: p_validate => false,

Line 544: if pay_jp_bee_utility_pkg.g_num_of_logs > 0 then

540: end if;
541: --
542: -- If at least 1 assignment failed to process, set concurrent request status "Incomplete".
543: --
544: if pay_jp_bee_utility_pkg.g_num_of_logs > 0 then
545: p_retcode := 1;
546: else
547: p_retcode := 0;
548: end if;