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_LTAX_IMP_PKG dependencies on PAY_JP_REPORT_PKG

Line 569: if pay_jp_report_pkg.g_char_set is null then

565: fnd_message.raise_error;
566: --
567: end if;
568: --
569: if pay_jp_report_pkg.g_char_set is null then
570: --
571: pay_jp_report_pkg.set_char_set(c_char_set);
572: --
573: end if;

Line 571: pay_jp_report_pkg.set_char_set(c_char_set);

567: end if;
568: --
569: if pay_jp_report_pkg.g_char_set is null then
570: --
571: pay_jp_report_pkg.set_char_set(c_char_set);
572: --
573: end if;
574: --
575: pay_jp_report_pkg.set_db_char_set;

Line 575: pay_jp_report_pkg.set_db_char_set;

571: pay_jp_report_pkg.set_char_set(c_char_set);
572: --
573: end if;
574: --
575: pay_jp_report_pkg.set_db_char_set;
576: --
577: if pay_jp_ltax_imp_pkg.g_file_prefix is null then
578: --
579: set_file_prefix(c_file_prefix);

Line 682: hr_utility.trace('pay_jp_report_pkg.g_char_set : '||pay_jp_report_pkg.g_char_set);

678: hr_utility.trace('g_action_if_exists : '||g_action_if_exists);
679: hr_utility.trace('g_reject_if_future_changes : '||g_reject_if_future_changes);
680: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
681: hr_utility.trace('g_create_asg_set_for_errored : '||g_create_asg_set_for_errored);
682: hr_utility.trace('pay_jp_report_pkg.g_char_set : '||pay_jp_report_pkg.g_char_set);
683: hr_utility.trace('pay_jp_report_pkg.g_db_char_set : '||pay_jp_report_pkg.g_db_char_set);
684: --
685: end if;
686: --

Line 683: hr_utility.trace('pay_jp_report_pkg.g_db_char_set : '||pay_jp_report_pkg.g_db_char_set);

679: hr_utility.trace('g_reject_if_future_changes : '||g_reject_if_future_changes);
680: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
681: hr_utility.trace('g_create_asg_set_for_errored : '||g_create_asg_set_for_errored);
682: hr_utility.trace('pay_jp_report_pkg.g_char_set : '||pay_jp_report_pkg.g_char_set);
683: hr_utility.trace('pay_jp_report_pkg.g_db_char_set : '||pay_jp_report_pkg.g_db_char_set);
684: --
685: end if;
686: --
687: if g_debug then

Line 736: l_file_data_tbl pay_jp_report_pkg.t_file_data_tbl;

732: l_imp_file_ind_tbl t_imp_file_tbl;
733: --
734: l_file_tbl t_file_tbl;
735: l_file_tbl_cnt number;
736: l_file_data_tbl pay_jp_report_pkg.t_file_data_tbl;
737: --
738: l_cnv_data varchar2(32767);
739: --
740: l_imp_file boolean;

Line 1257: if pay_jp_report_pkg.check_file(

1253: if l_file_tbl.count > 0 then
1254: --
1255: for i in 1..l_file_tbl.count loop
1256: --
1257: if pay_jp_report_pkg.check_file(
1258: l_file_tbl(i).file_name,
1259: g_file_dir) then
1260: --
1261: g_file_tbl_cnt := g_file_tbl_cnt + 1;

Line 1317: pay_jp_report_pkg.open_file(

1313: --
1314: <>
1315: for i in 1..g_file_tbl.count loop
1316: --
1317: pay_jp_report_pkg.open_file(
1318: g_file_tbl(i).file_name,
1319: g_file_dir,
1320: g_file_tbl(i).file_out,
1321: 'r');

Line 1325: pay_jp_report_pkg.read_file(

1321: 'r');
1322: --
1323: l_file_line := 0;
1324: --
1325: pay_jp_report_pkg.read_file(
1326: g_file_tbl(i).file_name,
1327: g_file_tbl(i).file_out,
1328: l_file_data_tbl);
1329: --

Line 1342: l_cnv_data := pay_jp_report_pkg.cnv_db_txt(l_file_data_tbl(j));

1338: --
1339: <>
1340: for j in l_file_data_tbl.first..l_file_data_tbl.last loop
1341: --
1342: l_cnv_data := pay_jp_report_pkg.cnv_db_txt(l_file_data_tbl(j));
1343: --
1344: if g_show_data = 'Y' then
1345: --
1346: pay_jp_report_pkg.show_debug(l_cnv_data);

Line 1346: pay_jp_report_pkg.show_debug(l_cnv_data);

1342: l_cnv_data := pay_jp_report_pkg.cnv_db_txt(l_file_data_tbl(j));
1343: --
1344: if g_show_data = 'Y' then
1345: --
1346: pay_jp_report_pkg.show_debug(l_cnv_data);
1347: --
1348: <>
1349: for k in 1..21 loop
1350: --

Line 1351: hr_utility.trace(to_char(k)||' : '||pay_jp_report_pkg.split_str(l_cnv_data,k));

1347: --
1348: <>
1349: for k in 1..21 loop
1350: --
1351: hr_utility.trace(to_char(k)||' : '||pay_jp_report_pkg.split_str(l_cnv_data,k));
1352: --
1353: end loop loop_split_data;
1354: --
1355: end if;

Line 1362: g_imp_data_tbl(g_imp_data_tbl_cnt).i_swot_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,1),1,15);

1358: l_file_line := l_file_line + 1;
1359: g_imp_data_tbl(g_imp_data_tbl_cnt).file_id := i;
1360: g_imp_data_tbl(g_imp_data_tbl_cnt).line := l_file_line;
1361: --
1362: g_imp_data_tbl(g_imp_data_tbl_cnt).i_swot_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,1),1,15);
1363: g_imp_data_tbl(g_imp_data_tbl_cnt).i_personal_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,2),1,60);
1364: g_imp_data_tbl(g_imp_data_tbl_cnt).i_employee_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,3),1,30);
1365: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address := substrb(pay_jp_report_pkg.split_str(l_cnv_data,4),1,800);
1366: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,5),1,800);

Line 1363: g_imp_data_tbl(g_imp_data_tbl_cnt).i_personal_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,2),1,60);

1359: g_imp_data_tbl(g_imp_data_tbl_cnt).file_id := i;
1360: g_imp_data_tbl(g_imp_data_tbl_cnt).line := l_file_line;
1361: --
1362: g_imp_data_tbl(g_imp_data_tbl_cnt).i_swot_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,1),1,15);
1363: g_imp_data_tbl(g_imp_data_tbl_cnt).i_personal_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,2),1,60);
1364: g_imp_data_tbl(g_imp_data_tbl_cnt).i_employee_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,3),1,30);
1365: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address := substrb(pay_jp_report_pkg.split_str(l_cnv_data,4),1,800);
1366: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,5),1,800);
1367: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name := substrb(pay_jp_report_pkg.split_str(l_cnv_data,6),1,400);

Line 1364: g_imp_data_tbl(g_imp_data_tbl_cnt).i_employee_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,3),1,30);

1360: g_imp_data_tbl(g_imp_data_tbl_cnt).line := l_file_line;
1361: --
1362: g_imp_data_tbl(g_imp_data_tbl_cnt).i_swot_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,1),1,15);
1363: g_imp_data_tbl(g_imp_data_tbl_cnt).i_personal_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,2),1,60);
1364: g_imp_data_tbl(g_imp_data_tbl_cnt).i_employee_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,3),1,30);
1365: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address := substrb(pay_jp_report_pkg.split_str(l_cnv_data,4),1,800);
1366: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,5),1,800);
1367: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name := substrb(pay_jp_report_pkg.split_str(l_cnv_data,6),1,400);
1368: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,7),1,400);

Line 1365: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address := substrb(pay_jp_report_pkg.split_str(l_cnv_data,4),1,800);

1361: --
1362: g_imp_data_tbl(g_imp_data_tbl_cnt).i_swot_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,1),1,15);
1363: g_imp_data_tbl(g_imp_data_tbl_cnt).i_personal_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,2),1,60);
1364: g_imp_data_tbl(g_imp_data_tbl_cnt).i_employee_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,3),1,30);
1365: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address := substrb(pay_jp_report_pkg.split_str(l_cnv_data,4),1,800);
1366: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,5),1,800);
1367: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name := substrb(pay_jp_report_pkg.split_str(l_cnv_data,6),1,400);
1368: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,7),1,400);
1369: g_imp_data_tbl(g_imp_data_tbl_cnt).i_sp_ltax := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,8));

Line 1366: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,5),1,800);

1362: g_imp_data_tbl(g_imp_data_tbl_cnt).i_swot_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,1),1,15);
1363: g_imp_data_tbl(g_imp_data_tbl_cnt).i_personal_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,2),1,60);
1364: g_imp_data_tbl(g_imp_data_tbl_cnt).i_employee_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,3),1,30);
1365: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address := substrb(pay_jp_report_pkg.split_str(l_cnv_data,4),1,800);
1366: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,5),1,800);
1367: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name := substrb(pay_jp_report_pkg.split_str(l_cnv_data,6),1,400);
1368: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,7),1,400);
1369: g_imp_data_tbl(g_imp_data_tbl_cnt).i_sp_ltax := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,8));
1370: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_6 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,9));

Line 1367: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name := substrb(pay_jp_report_pkg.split_str(l_cnv_data,6),1,400);

1363: g_imp_data_tbl(g_imp_data_tbl_cnt).i_personal_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,2),1,60);
1364: g_imp_data_tbl(g_imp_data_tbl_cnt).i_employee_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,3),1,30);
1365: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address := substrb(pay_jp_report_pkg.split_str(l_cnv_data,4),1,800);
1366: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,5),1,800);
1367: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name := substrb(pay_jp_report_pkg.split_str(l_cnv_data,6),1,400);
1368: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,7),1,400);
1369: g_imp_data_tbl(g_imp_data_tbl_cnt).i_sp_ltax := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,8));
1370: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_6 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,9));
1371: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_7 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,10));

Line 1368: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,7),1,400);

1364: g_imp_data_tbl(g_imp_data_tbl_cnt).i_employee_number := substrb(pay_jp_report_pkg.split_str(l_cnv_data,3),1,30);
1365: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address := substrb(pay_jp_report_pkg.split_str(l_cnv_data,4),1,800);
1366: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,5),1,800);
1367: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name := substrb(pay_jp_report_pkg.split_str(l_cnv_data,6),1,400);
1368: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,7),1,400);
1369: g_imp_data_tbl(g_imp_data_tbl_cnt).i_sp_ltax := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,8));
1370: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_6 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,9));
1371: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_7 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,10));
1372: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_8 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,11));

Line 1369: g_imp_data_tbl(g_imp_data_tbl_cnt).i_sp_ltax := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,8));

1365: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address := substrb(pay_jp_report_pkg.split_str(l_cnv_data,4),1,800);
1366: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,5),1,800);
1367: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name := substrb(pay_jp_report_pkg.split_str(l_cnv_data,6),1,400);
1368: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,7),1,400);
1369: g_imp_data_tbl(g_imp_data_tbl_cnt).i_sp_ltax := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,8));
1370: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_6 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,9));
1371: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_7 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,10));
1372: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_8 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,11));
1373: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_9 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,12));

Line 1370: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_6 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,9));

1366: g_imp_data_tbl(g_imp_data_tbl_cnt).i_address_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,5),1,800);
1367: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name := substrb(pay_jp_report_pkg.split_str(l_cnv_data,6),1,400);
1368: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,7),1,400);
1369: g_imp_data_tbl(g_imp_data_tbl_cnt).i_sp_ltax := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,8));
1370: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_6 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,9));
1371: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_7 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,10));
1372: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_8 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,11));
1373: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_9 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,12));
1374: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_10 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,13));

Line 1371: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_7 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,10));

1367: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name := substrb(pay_jp_report_pkg.split_str(l_cnv_data,6),1,400);
1368: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,7),1,400);
1369: g_imp_data_tbl(g_imp_data_tbl_cnt).i_sp_ltax := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,8));
1370: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_6 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,9));
1371: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_7 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,10));
1372: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_8 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,11));
1373: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_9 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,12));
1374: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_10 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,13));
1375: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_11 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,14));

Line 1372: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_8 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,11));

1368: g_imp_data_tbl(g_imp_data_tbl_cnt).i_full_name_kana := substrb(pay_jp_report_pkg.split_str(l_cnv_data,7),1,400);
1369: g_imp_data_tbl(g_imp_data_tbl_cnt).i_sp_ltax := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,8));
1370: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_6 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,9));
1371: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_7 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,10));
1372: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_8 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,11));
1373: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_9 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,12));
1374: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_10 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,13));
1375: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_11 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,14));
1376: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_12 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,15));

Line 1373: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_9 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,12));

1369: g_imp_data_tbl(g_imp_data_tbl_cnt).i_sp_ltax := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,8));
1370: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_6 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,9));
1371: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_7 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,10));
1372: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_8 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,11));
1373: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_9 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,12));
1374: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_10 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,13));
1375: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_11 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,14));
1376: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_12 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,15));
1377: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_1 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,16));

Line 1374: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_10 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,13));

1370: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_6 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,9));
1371: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_7 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,10));
1372: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_8 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,11));
1373: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_9 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,12));
1374: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_10 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,13));
1375: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_11 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,14));
1376: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_12 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,15));
1377: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_1 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,16));
1378: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_2 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,17));

Line 1375: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_11 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,14));

1371: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_7 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,10));
1372: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_8 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,11));
1373: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_9 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,12));
1374: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_10 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,13));
1375: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_11 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,14));
1376: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_12 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,15));
1377: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_1 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,16));
1378: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_2 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,17));
1379: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_3 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,18));

Line 1376: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_12 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,15));

1372: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_8 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,11));
1373: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_9 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,12));
1374: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_10 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,13));
1375: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_11 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,14));
1376: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_12 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,15));
1377: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_1 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,16));
1378: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_2 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,17));
1379: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_3 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,18));
1380: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_4 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,19));

Line 1377: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_1 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,16));

1373: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_9 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,12));
1374: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_10 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,13));
1375: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_11 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,14));
1376: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_12 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,15));
1377: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_1 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,16));
1378: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_2 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,17));
1379: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_3 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,18));
1380: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_4 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,19));
1381: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_5 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,20));

Line 1378: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_2 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,17));

1374: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_10 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,13));
1375: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_11 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,14));
1376: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_12 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,15));
1377: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_1 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,16));
1378: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_2 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,17));
1379: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_3 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,18));
1380: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_4 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,19));
1381: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_5 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,20));
1382: g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code := substrb(pay_jp_report_pkg.split_str(l_cnv_data,21),1,6);

Line 1379: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_3 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,18));

1375: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_11 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,14));
1376: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_12 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,15));
1377: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_1 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,16));
1378: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_2 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,17));
1379: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_3 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,18));
1380: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_4 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,19));
1381: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_5 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,20));
1382: g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code := substrb(pay_jp_report_pkg.split_str(l_cnv_data,21),1,6);
1383: --

Line 1380: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_4 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,19));

1376: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_12 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,15));
1377: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_1 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,16));
1378: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_2 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,17));
1379: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_3 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,18));
1380: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_4 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,19));
1381: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_5 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,20));
1382: g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code := substrb(pay_jp_report_pkg.split_str(l_cnv_data,21),1,6);
1383: --
1384: -- validate date is all numeric

Line 1381: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_5 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,20));

1377: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_1 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,16));
1378: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_2 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,17));
1379: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_3 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,18));
1380: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_4 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,19));
1381: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_5 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,20));
1382: g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code := substrb(pay_jp_report_pkg.split_str(l_cnv_data,21),1,6);
1383: --
1384: -- validate date is all numeric
1385: if lengthb(ltrim(rtrim(g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code))) = 5

Line 1382: g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code := substrb(pay_jp_report_pkg.split_str(l_cnv_data,21),1,6);

1378: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_2 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,17));
1379: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_3 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,18));
1380: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_4 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,19));
1381: g_imp_data_tbl(g_imp_data_tbl_cnt).i_ltax_5 := cnv_num(pay_jp_report_pkg.split_str(l_cnv_data,20));
1382: g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code := substrb(pay_jp_report_pkg.split_str(l_cnv_data,21),1,6);
1383: --
1384: -- validate date is all numeric
1385: if lengthb(ltrim(rtrim(g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code))) = 5
1386: and (lengthb(replace(translate(ltrim(rtrim(g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code)),'0123456789','*'),'*','')) is null

Line 1389: g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code := ltrim(rtrim(substrb(pay_jp_report_pkg.split_str(l_cnv_data,21),1,6)))

1385: if lengthb(ltrim(rtrim(g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code))) = 5
1386: and (lengthb(replace(translate(ltrim(rtrim(g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code)),'0123456789','*'),'*','')) is null
1387: or lengthb(replace(translate(ltrim(rtrim(g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code)),'0123456789','*'),'*','')) = 0) then
1388: --
1389: g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code := ltrim(rtrim(substrb(pay_jp_report_pkg.split_str(l_cnv_data,21),1,6)))
1390: ||per_jp_validations.district_code_check_digit(ltrim(rtrim(substrb(pay_jp_report_pkg.split_str(l_cnv_data,21),1,6))));
1391: --
1392: end if;
1393: --

Line 1390: ||per_jp_validations.district_code_check_digit(ltrim(rtrim(substrb(pay_jp_report_pkg.split_str(l_cnv_data,21),1,6))));

1386: and (lengthb(replace(translate(ltrim(rtrim(g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code)),'0123456789','*'),'*','')) is null
1387: or lengthb(replace(translate(ltrim(rtrim(g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code)),'0123456789','*'),'*','')) = 0) then
1388: --
1389: g_imp_data_tbl(g_imp_data_tbl_cnt).i_district_code := ltrim(rtrim(substrb(pay_jp_report_pkg.split_str(l_cnv_data,21),1,6)))
1390: ||per_jp_validations.district_code_check_digit(ltrim(rtrim(substrb(pay_jp_report_pkg.split_str(l_cnv_data,21),1,6))));
1391: --
1392: end if;
1393: --
1394: end loop loop_data_tbl;

Line 1398: pay_jp_report_pkg.close_file(

1394: end loop loop_data_tbl;
1395: --
1396: end if;
1397: --
1398: pay_jp_report_pkg.close_file(
1399: g_file_tbl(i).file_name,
1400: g_file_tbl(i).file_out,
1401: 'r');
1402: --