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_US_W2C_RPT dependencies on PAY_US_W2C_RPT

Line 1: PACKAGE BODY pay_us_w2c_rpt AS

1: PACKAGE BODY pay_us_w2c_rpt AS
2: /* $Header: pyusw2cr.pkb 120.4.12020000.21 2013/05/24 07:12:35 skchalla ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_us_w2c_rpt

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_us_w2c_rpt
21:
22: Description : This procedure is used by Employee W-2C Report
23:
24: Change List

Line 89: g_package CONSTANT VARCHAR2(33) := 'pay_us_w2c_rpt.';

85: *****************************************************************************/
86:
87: gv_procedure_name VARCHAR2(100);
88: gv_package VARCHAR2(100);
89: g_package CONSTANT VARCHAR2(33) := 'pay_us_w2c_rpt.';
90: l_w2c_fields_o l_w2c_fields_rec;
91: l_state_tab l_state_table;
92: l_local_tab l_local_table;
93: l_box12_tab l_box12_table;

Line 1534: decode(put.address_line_1,null,null,substr(put.address_line_1,1,45)||pay_us_w2c_rpt.EOL)||

1530: /*Bug 5735076 added by vaprakas*/
1531: CURSOR c_get_employer_info ( p_tax_unit_id NUMBER, p_year NUMBER) IS
1532: select federal_ein federal_ein,
1533: tax_unit_name employer_name,
1534: decode(put.address_line_1,null,null,substr(put.address_line_1,1,45)||pay_us_w2c_rpt.EOL)||
1535: decode(put.address_line_2,null,null,substr(put.address_line_2,1,45)||pay_us_w2c_rpt.EOL)||
1536: decode(put.address_line_3,null,null,substr(put.address_line_3,1,45)||pay_us_w2c_rpt.EOL)||
1537: decode(put.town_or_city,null,null,put.town_or_city||' ')||
1538: decode(state,null,null,state||' ')||put.postal_code

Line 1535: decode(put.address_line_2,null,null,substr(put.address_line_2,1,45)||pay_us_w2c_rpt.EOL)||

1531: CURSOR c_get_employer_info ( p_tax_unit_id NUMBER, p_year NUMBER) IS
1532: select federal_ein federal_ein,
1533: tax_unit_name employer_name,
1534: decode(put.address_line_1,null,null,substr(put.address_line_1,1,45)||pay_us_w2c_rpt.EOL)||
1535: decode(put.address_line_2,null,null,substr(put.address_line_2,1,45)||pay_us_w2c_rpt.EOL)||
1536: decode(put.address_line_3,null,null,substr(put.address_line_3,1,45)||pay_us_w2c_rpt.EOL)||
1537: decode(put.town_or_city,null,null,put.town_or_city||' ')||
1538: decode(state,null,null,state||' ')||put.postal_code
1539: employer_address

Line 1536: decode(put.address_line_3,null,null,substr(put.address_line_3,1,45)||pay_us_w2c_rpt.EOL)||

1532: select federal_ein federal_ein,
1533: tax_unit_name employer_name,
1534: decode(put.address_line_1,null,null,substr(put.address_line_1,1,45)||pay_us_w2c_rpt.EOL)||
1535: decode(put.address_line_2,null,null,substr(put.address_line_2,1,45)||pay_us_w2c_rpt.EOL)||
1536: decode(put.address_line_3,null,null,substr(put.address_line_3,1,45)||pay_us_w2c_rpt.EOL)||
1537: decode(put.town_or_city,null,null,put.town_or_city||' ')||
1538: decode(state,null,null,state||' ')||put.postal_code
1539: employer_address
1540: from pay_us_w2_tax_unit_v put

Line 1669: pay_us_w2c_rpt.EOL ||

1665: hr_utility.trace('l_org_address ' ||l_org_address);
1666:
1667: l_w2c_fields_c.employer_address
1668: := 'Agent For ' ||substr(l_org_employer_name,1,44)||
1669: pay_us_w2c_rpt.EOL ||
1670: l_w2c_fields_c.employer_address;
1671:
1672: END IF;
1673: /* Bug 5575567 */

Line 1823: pay_us_w2c_rpt.EOL;

1819: 'W2_XML');
1820:
1821: IF lr_employee_addr.addr_line_1 IS NOT NULL THEN
1822: l_w2c_fields_c.employee_address := substr(lr_employee_addr.addr_line_1,1,45) ||
1823: pay_us_w2c_rpt.EOL;
1824: END IF;
1825:
1826: IF lr_employee_addr.addr_line_2 IS NOT NULL THEN
1827: l_w2c_fields_c.employee_address := l_w2c_fields_c.employee_address||

Line 1829: pay_us_w2c_rpt.EOL;

1825:
1826: IF lr_employee_addr.addr_line_2 IS NOT NULL THEN
1827: l_w2c_fields_c.employee_address := l_w2c_fields_c.employee_address||
1828: substr(lr_employee_addr.addr_line_2,1,45) ||
1829: pay_us_w2c_rpt.EOL;
1830: END IF;
1831:
1832: IF lr_employee_addr.addr_line_3 IS NOT NULL THEN
1833: l_w2c_fields_c.employee_address := l_w2c_fields_c.employee_address||

Line 1835: pay_us_w2c_rpt.EOL;

1831:
1832: IF lr_employee_addr.addr_line_3 IS NOT NULL THEN
1833: l_w2c_fields_c.employee_address := l_w2c_fields_c.employee_address||
1834: substr(lr_employee_addr.addr_line_3,1,45) ||
1835: pay_us_w2c_rpt.EOL;
1836: END IF;
1837:
1838: l_w2c_fields_c.employee_address :=l_w2c_fields_c.employee_address ||
1839: lr_employee_addr.city||' '||

Line 3890: gv_package := 'pay_us_w2c_rpt';

3886: end get_outfile;
3887:
3888: BEGIN
3889: -- hr_utility.trace_on(null,'W2CRPT');
3890: gv_package := 'pay_us_w2c_rpt';
3891:
3892: END pay_us_w2c_rpt;

Line 3892: END pay_us_w2c_rpt;

3888: BEGIN
3889: -- hr_utility.trace_on(null,'W2CRPT');
3890: gv_package := 'pay_us_w2c_rpt';
3891:
3892: END pay_us_w2c_rpt;