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_SPR_EFILE_PKG dependencies on PAY_JP_SPR_EFILE_PKG

Line 1: package body pay_jp_spr_efile_pkg as

1: package body pay_jp_spr_efile_pkg as
2: /* $Header: pyjpspre.pkb 120.9.12020000.4 2012/12/27 09:49:32 dduvvuri ship $ */
3: --
4: c_package constant varchar2(30) := 'pay_jp_spr_efile_pkg.';
5: g_debug boolean := hr_utility.debug_enabled;

Line 4: c_package constant varchar2(30) := 'pay_jp_spr_efile_pkg.';

1: package body pay_jp_spr_efile_pkg as
2: /* $Header: pyjpspre.pkb 120.9.12020000.4 2012/12/27 09:49:32 dduvvuri ship $ */
3: --
4: c_package constant varchar2(30) := 'pay_jp_spr_efile_pkg.';
5: g_debug boolean := hr_utility.debug_enabled;
6: --
7: c_eol varchar2(30) := fnd_global.local_chr(10);
8: c_max_file_open number := 50;

Line 555: pay_jp_spr_efile_pkg.default_file_name(nvl(pjsn_v.rep_district_code,wic_v.town_or_city)||

551: wic_v.full_name_kana,
552: wic_v.employee_number,
553: pjsn_v.rep_swot_number swot_number,
554: nvl(pjsn_v.rep_output_file_name,
555: pay_jp_spr_efile_pkg.default_file_name(nvl(pjsn_v.rep_district_code,wic_v.town_or_city)||
556: per_jp_validations.district_code_check_digit(nvl(pjsn_v.rep_district_code,wic_v.town_or_city)))) output_file_name,
557: hoi.org_information6||hoi.org_information7||hoi.org_information8 itax_org_address,
558: hoi.org_information9||hoi.org_information10||hoi.org_information11 itax_org_address_kana,
559: hoi.org_information1 itax_org_name,

Line 774: pay_jp_spr_efile_pkg.default_file_name(nvl(pjsn_v.rep_district_code,pjip.district_code)||

770: pjip.last_name_kana||'' ''||pjip.first_name_kana full_name_kana,
771: pjip.employee_number,
772: pjsn_v.rep_swot_number swot_number,
773: nvl(pjsn_v.rep_output_file_name,
774: pay_jp_spr_efile_pkg.default_file_name(nvl(pjsn_v.rep_district_code,pjip.district_code)||
775: per_jp_validations.district_code_check_digit(nvl(pjsn_v.rep_district_code,pjip.district_code)))) output_file_name,
776: pjia.employer_address itax_org_address,
777: null itax_org_address_kana,
778: pjia.employer_name itax_org_name,

Line 952: pay_jp_spr_efile_pkg.default_file_name(nvl(pjsn_v.rep_district_code,pjip.district_code)||

948: pjip.last_name_kana||'' ''||pjip.first_name_kana full_name_kana,
949: pjip.employee_number,
950: pjsn_v.rep_swot_number swot_number,
951: nvl(pjsn_v.rep_output_file_name,
952: pay_jp_spr_efile_pkg.default_file_name(nvl(pjsn_v.rep_district_code,pjip.district_code)||
953: per_jp_validations.district_code_check_digit(nvl(pjsn_v.rep_district_code,pjip.district_code)))) output_file_name,
954: pjia.employer_address itax_org_address,
955: null itax_org_address_kana,
956: pjia.employer_name itax_org_name,

Line 1127: pay_jp_spr_efile_pkg.default_file_name(nvl(pjsn_v.rep_district_code,pjip.district_code)||

1123: pjip.last_name_kana||'' ''||pjip.first_name_kana full_name_kana,
1124: pjip.employee_number,
1125: pjsn_v.rep_swot_number swot_number,
1126: nvl(pjsn_v.rep_output_file_name,
1127: pay_jp_spr_efile_pkg.default_file_name(nvl(pjsn_v.rep_district_code,pjip.district_code)||
1128: per_jp_validations.district_code_check_digit(nvl(pjsn_v.rep_district_code,pjip.district_code)))) output_file_name,
1129: pjia.employer_address itax_org_address,
1130: null itax_org_address_kana,
1131: pjia.employer_name itax_org_name,

Line 1305: pay_jp_spr_efile_pkg.default_file_name(nvl(pjsn_v.rep_district_code,pjip.district_code)||

1301: pjip.last_name_kana||'' ''||pjip.first_name_kana full_name_kana,
1302: pjip.employee_number,
1303: pjsn_v.rep_swot_number swot_number,
1304: nvl(pjsn_v.rep_output_file_name,
1305: pay_jp_spr_efile_pkg.default_file_name(nvl(pjsn_v.rep_district_code,pjip.district_code)||
1306: per_jp_validations.district_code_check_digit(nvl(pjsn_v.rep_district_code,pjip.district_code)))) output_file_name,
1307: pjia.employer_address itax_org_address,
1308: null itax_org_address_kana,
1309: pjia.employer_name itax_org_name,

Line 1461: pay_jp_spr_efile_pkg.g_file_prefix := p_file_prefix;

1457: p_file_prefix in varchar2)
1458: is
1459: begin
1460: --
1461: pay_jp_spr_efile_pkg.g_file_prefix := p_file_prefix;
1462: --
1463: end set_file_prefix;
1464: --
1465: -- -------------------------------------------------------------------------

Line 1473: pay_jp_spr_efile_pkg.g_file_extension := p_file_extension;

1469: p_file_extension in varchar2)
1470: is
1471: begin
1472: --
1473: pay_jp_spr_efile_pkg.g_file_extension := p_file_extension;
1474: --
1475: end set_file_extension;
1476: --
1477: -- -------------------------------------------------------------------------

Line 1491: l_file_name := pay_jp_spr_efile_pkg.g_file_prefix||

1487: begin
1488: --
1489: if p_district_code is null then
1490: --
1491: l_file_name := pay_jp_spr_efile_pkg.g_file_prefix||
1492: c_file_spliter||
1493: to_char(pay_jp_spr_efile_pkg.g_request_id)||c_file_extension;
1494: --
1495: else

Line 1493: to_char(pay_jp_spr_efile_pkg.g_request_id)||c_file_extension;

1489: if p_district_code is null then
1490: --
1491: l_file_name := pay_jp_spr_efile_pkg.g_file_prefix||
1492: c_file_spliter||
1493: to_char(pay_jp_spr_efile_pkg.g_request_id)||c_file_extension;
1494: --
1495: else
1496: --
1497: l_file_name := pay_jp_spr_efile_pkg.g_file_prefix||

Line 1497: l_file_name := pay_jp_spr_efile_pkg.g_file_prefix||

1493: to_char(pay_jp_spr_efile_pkg.g_request_id)||c_file_extension;
1494: --
1495: else
1496: --
1497: l_file_name := pay_jp_spr_efile_pkg.g_file_prefix||
1498: c_file_spliter||
1499: p_district_code||
1500: c_file_spliter||
1501: to_char(pay_jp_spr_efile_pkg.g_request_id)||c_file_extension;

Line 1501: to_char(pay_jp_spr_efile_pkg.g_request_id)||c_file_extension;

1497: l_file_name := pay_jp_spr_efile_pkg.g_file_prefix||
1498: c_file_spliter||
1499: p_district_code||
1500: c_file_spliter||
1501: to_char(pay_jp_spr_efile_pkg.g_request_id)||c_file_extension;
1502: --
1503: end if;
1504: --
1505: if lengthb(l_file_name) > 80 then

Line 1560: pay_jp_spr_efile_pkg.g_detail_debug := p_yn;

1556: begin
1557: --
1558: if p_yn is not null then
1559: --
1560: pay_jp_spr_efile_pkg.g_detail_debug := p_yn;
1561: --
1562: else
1563: --
1564: open csr_hidden_debug;

Line 1570: pay_jp_spr_efile_pkg.g_detail_debug := l_hidden_debug;

1566: close csr_hidden_debug;
1567: --
1568: if l_hidden_debug = 'Y' then
1569: --
1570: pay_jp_spr_efile_pkg.g_detail_debug := l_hidden_debug;
1571: --
1572: end if;
1573: --
1574: end if;

Line 1601: l_detail_debug varchar2(1) := pay_jp_spr_efile_pkg.g_detail_debug;

1597: is
1598: --
1599: l_proc varchar2(80) := c_package||'init_pact';
1600: --
1601: l_detail_debug varchar2(1) := pay_jp_spr_efile_pkg.g_detail_debug;
1602: --
1603: cursor csr_action
1604: is
1605: select ppa.business_group_id,

Line 1804: if pay_jp_spr_efile_pkg.g_file_prefix is null then

1800: pay_jp_report_pkg.set_char_set(c_char_set);
1801: --
1802: end if;
1803: --
1804: if pay_jp_spr_efile_pkg.g_file_prefix is null then
1805: --
1806: set_file_prefix(c_file_prefix);
1807: --
1808: end if;

Line 1810: if pay_jp_spr_efile_pkg.g_file_extension is null then

1806: set_file_prefix(c_file_prefix);
1807: --
1808: end if;
1809: --
1810: if pay_jp_spr_efile_pkg.g_file_extension is null then
1811: --
1812: set_file_extension(c_file_extension);
1813: --
1814: end if;

Line 1842: hr_utility.trace('pay_jp_spr_efile_pkg.g_file_prefix : '||pay_jp_spr_efile_pkg.g_file_prefix);

1838: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
1839: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
1840: hr_utility.trace('pay_jp_wic_pkg.g_valid_term_taxable_amt : '||to_char(pay_jp_wic_pkg.g_valid_term_taxable_amt));
1841: hr_utility.trace('pay_jp_report_pkg.g_char_set : '||pay_jp_report_pkg.g_char_set);
1842: hr_utility.trace('pay_jp_spr_efile_pkg.g_file_prefix : '||pay_jp_spr_efile_pkg.g_file_prefix);
1843: hr_utility.trace('pay_jp_spr_efile_pkg.g_file_extension : '||pay_jp_spr_efile_pkg.g_file_extension);
1844: end if;
1845: --
1846: if g_debug

Line 1843: hr_utility.trace('pay_jp_spr_efile_pkg.g_file_extension : '||pay_jp_spr_efile_pkg.g_file_extension);

1839: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
1840: hr_utility.trace('pay_jp_wic_pkg.g_valid_term_taxable_amt : '||to_char(pay_jp_wic_pkg.g_valid_term_taxable_amt));
1841: hr_utility.trace('pay_jp_report_pkg.g_char_set : '||pay_jp_report_pkg.g_char_set);
1842: hr_utility.trace('pay_jp_spr_efile_pkg.g_file_prefix : '||pay_jp_spr_efile_pkg.g_file_prefix);
1843: hr_utility.trace('pay_jp_spr_efile_pkg.g_file_extension : '||pay_jp_spr_efile_pkg.g_file_extension);
1844: end if;
1845: --
1846: if g_debug
1847: and g_detail_debug = 'Y' then

Line 2917: pay_jp_spr_efile_pkg.g_file_prefix||

2913: if g_file_split is not null
2914: and g_file_split = 'N' then
2915: --
2916: l_data_tbl(i).output_file_name :=
2917: pay_jp_spr_efile_pkg.g_file_prefix||
2918: c_file_spliter||
2919: to_char(pay_jp_spr_efile_pkg.g_request_id)||c_file_extension;
2920: --
2921: end if;

Line 2919: to_char(pay_jp_spr_efile_pkg.g_request_id)||c_file_extension;

2915: --
2916: l_data_tbl(i).output_file_name :=
2917: pay_jp_spr_efile_pkg.g_file_prefix||
2918: c_file_spliter||
2919: to_char(pay_jp_spr_efile_pkg.g_request_id)||c_file_extension;
2920: --
2921: end if;
2922: --
2923: l_district_code_chg := false;

Line 5094: pay_jp_spr_efile_pkg.g_file_prefix||

5090: if g_file_split is not null
5091: and g_file_split = 'N' then
5092: --
5093: l_file_name :=
5094: pay_jp_spr_efile_pkg.g_file_prefix||
5095: c_file_spliter||
5096: to_char(p_request_id)||c_file_extension;
5097: --
5098: if g_debug

Line 5609: end pay_jp_spr_efile_pkg;

5605: -- end if;
5606: ----
5607: --end sort_code;
5608: --
5609: end pay_jp_spr_efile_pkg;