[Home] [Help]
1: PACKAGE BODY pay_us_get_item_data_pkg AS
2: /* $Header: pyusgitd.pkb 120.8.12020000.4 2012/11/26 09:16:13 pkoduri ship $ */
3:
4: /*===========================================================================+
5: | Copyright (c) 2001 Oracle Corporation |
7: | All rights reserved. |
8: +============================================================================+
9:
10: Name
11: pay_us_get_item_data_pkg
12:
13: Purpose
14: The purpose of this package is to derive data and Validate data to support
15: the generation of magnetic tape W2 / SQWL reports for US legilsative
463: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
464: l_organization_name hr_organization_units.name%TYPE;
465: l_person_id number(10);
466: l_locality_company_id varchar2(50);
467: lr_employee_addr pay_us_get_item_data_pkg.person_name_address;
468: l_effective_date date;
469: l_input_2 varchar2(200);
470: BEGIN
471: hr_utility.trace('In function GET_MMREF_EMPLOYEE_ADDRESS');
484: end if;
485: hr_utility.trace('In function GET_MMREF_EMPLOYEE_ADDRESS');
486: --
487: lr_employee_addr :=
488: pay_us_get_item_data_pkg.GET_PERSON_NAME_ADDRESS(
489: p_report_type,
490: l_person_id,
491: p_assignment_id,
492: p_date_earned,
614: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
615: c_item_name varchar2(40);
616: l_emp_number varchar2(40);
617: l_locality_company_id varchar2(50);
618: lr_employer_addr pay_us_get_item_data_pkg.organization_name_address;
619: BEGIN
620: hr_utility.trace('FUNCTION GET_MMREF_EMPLOYER_ADDRESS for Employer Address');
621: c_tax_unit_id := p_tax_unit_id;
622: c_item_name := 'ER_ADDRESS';
633: hr_utility.trace('ER_ADDRESS Locality_Company_Id ...'||
634: l_locality_company_id );
635: END IF;
636: lr_employer_addr :=
637: pay_us_get_item_data_pkg.get_organization_name_address(
638: c_tax_unit_id,
639: p_effective_date,
640: p_validate,
641: p_record_name);
1137: AND hl.location_id = hou.location_id
1138: AND nvl(hl.inactive_date,end_date)>= c_effective_date
1139: AND hrl.lookup_code (+)=hl.country
1140: AND lookup_type (+)='PQP_US_COUNTRY_TRANSLATE';
1141: lr_org_name_address pay_us_get_item_data_pkg.organization_name_address;
1142: l_addr_count number(10) := 0;
1143: l_valid_address varchar2(3) := 'N';
1144: l_too_many_adr_token3 varchar2(50):='More than one address found';
1145: l_token2 varchar2(50);
1257: --}
1258: --
1259: --BEGIN
1260: --hr_utility.trace_on(null,'GETITEMDATA');
1261: END pay_us_get_item_data_pkg; --End of Package Body