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_W2_INFO_PKG dependencies on PAY_US_W2_INFO_PKG

Line 1: PACKAGE BODY PAY_US_W2_INFO_PKG as

1: PACKAGE BODY PAY_US_W2_INFO_PKG as
2: /* $Header: pyusw2dt.pkb 120.64.12020000.3 2012/11/16 12:20:17 pkoduri ship $ */
3: g_package CONSTANT VARCHAR2(33) := 'pay_us_w2_info_pkg.';
4: l_w2_fields l_w2_fields_rec;
5: l_state_tab l_state_table;

Line 3: g_package CONSTANT VARCHAR2(33) := 'pay_us_w2_info_pkg.';

1: PACKAGE BODY PAY_US_W2_INFO_PKG as
2: /* $Header: pyusw2dt.pkb 120.64.12020000.3 2012/11/16 12:20:17 pkoduri ship $ */
3: g_package CONSTANT VARCHAR2(33) := 'pay_us_w2_info_pkg.';
4: l_w2_fields l_w2_fields_rec;
5: l_state_tab l_state_table;
6: l_local_tab l_local_table;
7: l_box12_tab l_box12_table;

Line 511: substr(decode(put.address_line_1,null,null,put.address_line_1||pay_us_w2_info_pkg.EOL),1,45)||

507:
508: /* CURSOR c_get_employer_info ( p_tax_unit_id NUMBER, p_year NUMBER) IS
509: select federal_ein federal_ein,
510: tax_unit_name employer_name,
511: substr(decode(put.address_line_1,null,null,put.address_line_1||pay_us_w2_info_pkg.EOL),1,45)||
512: substr(decode(put.address_line_2,null,null,put.address_line_2||pay_us_w2_info_pkg.EOL),1,45)||
513: substr(decode(put.address_line_3,null,null,put.address_line_3||pay_us_w2_info_pkg.EOL),1,45)||
514: decode(put.town_or_city,null,null,put.town_or_city||' ')||
515: decode(state,null,null,state||' ')||put.postal_code

Line 512: substr(decode(put.address_line_2,null,null,put.address_line_2||pay_us_w2_info_pkg.EOL),1,45)||

508: /* CURSOR c_get_employer_info ( p_tax_unit_id NUMBER, p_year NUMBER) IS
509: select federal_ein federal_ein,
510: tax_unit_name employer_name,
511: substr(decode(put.address_line_1,null,null,put.address_line_1||pay_us_w2_info_pkg.EOL),1,45)||
512: substr(decode(put.address_line_2,null,null,put.address_line_2||pay_us_w2_info_pkg.EOL),1,45)||
513: substr(decode(put.address_line_3,null,null,put.address_line_3||pay_us_w2_info_pkg.EOL),1,45)||
514: decode(put.town_or_city,null,null,put.town_or_city||' ')||
515: decode(state,null,null,state||' ')||put.postal_code
516: employer_address

Line 513: substr(decode(put.address_line_3,null,null,put.address_line_3||pay_us_w2_info_pkg.EOL),1,45)||

509: select federal_ein federal_ein,
510: tax_unit_name employer_name,
511: substr(decode(put.address_line_1,null,null,put.address_line_1||pay_us_w2_info_pkg.EOL),1,45)||
512: substr(decode(put.address_line_2,null,null,put.address_line_2||pay_us_w2_info_pkg.EOL),1,45)||
513: substr(decode(put.address_line_3,null,null,put.address_line_3||pay_us_w2_info_pkg.EOL),1,45)||
514: decode(put.town_or_city,null,null,put.town_or_city||' ')||
515: decode(state,null,null,state||' ')||put.postal_code
516: employer_address
517: from pay_us_w2_tax_unit_v put

Line 526: decode(put.address_line_1,null,null,substr(put.address_line_1,1,45)||pay_us_w2_info_pkg.EOL)||

522: /*Bug 5735076 added by vaprakas*/
523: CURSOR c_get_employer_info ( p_tax_unit_id NUMBER, p_year NUMBER) IS
524: select federal_ein federal_ein,
525: tax_unit_name employer_name,
526: decode(put.address_line_1,null,null,substr(put.address_line_1,1,45)||pay_us_w2_info_pkg.EOL)||
527: decode(put.address_line_2,null,null,substr(put.address_line_2,1,45)||pay_us_w2_info_pkg.EOL)||
528: decode(put.address_line_3,null,null,substr(put.address_line_3,1,45)||pay_us_w2_info_pkg.EOL)||
529: decode(put.town_or_city,null,null,put.town_or_city||' ')||
530: decode(state,null,null,state||' ')||put.postal_code

Line 527: decode(put.address_line_2,null,null,substr(put.address_line_2,1,45)||pay_us_w2_info_pkg.EOL)||

523: CURSOR c_get_employer_info ( p_tax_unit_id NUMBER, p_year NUMBER) IS
524: select federal_ein federal_ein,
525: tax_unit_name employer_name,
526: decode(put.address_line_1,null,null,substr(put.address_line_1,1,45)||pay_us_w2_info_pkg.EOL)||
527: decode(put.address_line_2,null,null,substr(put.address_line_2,1,45)||pay_us_w2_info_pkg.EOL)||
528: decode(put.address_line_3,null,null,substr(put.address_line_3,1,45)||pay_us_w2_info_pkg.EOL)||
529: decode(put.town_or_city,null,null,put.town_or_city||' ')||
530: decode(state,null,null,state||' ')||put.postal_code
531: employer_address

Line 528: decode(put.address_line_3,null,null,substr(put.address_line_3,1,45)||pay_us_w2_info_pkg.EOL)||

524: select federal_ein federal_ein,
525: tax_unit_name employer_name,
526: decode(put.address_line_1,null,null,substr(put.address_line_1,1,45)||pay_us_w2_info_pkg.EOL)||
527: decode(put.address_line_2,null,null,substr(put.address_line_2,1,45)||pay_us_w2_info_pkg.EOL)||
528: decode(put.address_line_3,null,null,substr(put.address_line_3,1,45)||pay_us_w2_info_pkg.EOL)||
529: decode(put.town_or_city,null,null,put.town_or_city||' ')||
530: decode(state,null,null,state||' ')||put.postal_code
531: employer_address
532: from pay_us_w2_tax_unit_v put

Line 691: pay_us_w2_info_pkg.EOL ||

687: hr_utility.trace('l_org_address ' ||l_org_address);
688:
689: l_w2_fields.employer_address
690: := 'Agent For ' ||substr(l_org_employer_name,1,44)||
691: pay_us_w2_info_pkg.EOL ||
692: l_w2_fields.employer_address;
693: END IF;
694: /* Bug 5575567 */
695: hr_utility.trace(' sysdate ' || sysdate);

Line 827: PAY_US_W2_INFO_PKG.EOL;

823: 'W2_XML');
824:
825: IF lr_employee_addr.addr_line_1 IS NOT NULL THEN
826: l_w2_fields.employee_address := substr(lr_employee_addr.addr_line_1,1,45) ||
827: PAY_US_W2_INFO_PKG.EOL;
828: END IF;
829:
830: IF lr_employee_addr.addr_line_2 IS NOT NULL THEN
831: l_w2_fields.employee_address := l_w2_fields.employee_address||

Line 833: PAY_US_W2_INFO_PKG.EOL;

829:
830: IF lr_employee_addr.addr_line_2 IS NOT NULL THEN
831: l_w2_fields.employee_address := l_w2_fields.employee_address||
832: substr(lr_employee_addr.addr_line_2,1,45) ||
833: PAY_US_W2_INFO_PKG.EOL;
834: END IF;
835:
836: IF lr_employee_addr.addr_line_3 IS NOT NULL THEN
837: l_w2_fields.employee_address := l_w2_fields.employee_address||

Line 839: PAY_US_W2_INFO_PKG.EOL;

835:
836: IF lr_employee_addr.addr_line_3 IS NOT NULL THEN
837: l_w2_fields.employee_address := l_w2_fields.employee_address||
838: substr(lr_employee_addr.addr_line_3,1,45) ||
839: PAY_US_W2_INFO_PKG.EOL;
840: END IF;
841:
842: l_w2_fields.employee_address :=l_w2_fields.employee_address ||
843: lr_employee_addr.city||' '||

Line 2076: END PAY_US_W2_INFO_PKG;

2072: return null;
2073: when others then
2074: return null;
2075: end get_outfile;
2076: END PAY_US_W2_INFO_PKG;