[Home] [Help]
1: PACKAGE BODY pay_us_get_item_data_pkg AS
2: /* $Header: pyusgitd.pkb 120.3 2007/12/07 10:44:29 vmkulkar noship $ */
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
390: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
391: l_organization_name hr_organization_units.name%TYPE;
392: l_person_id number(10);
393: l_locality_company_id varchar2(50);
394: lr_employee_addr pay_us_get_item_data_pkg.person_name_address;
395: l_effective_date date;
396: l_input_2 varchar2(200);
397: BEGIN
398: hr_utility.trace('In function GET_MMREF_EMPLOYEE_ADDRESS');
411: end if;
412: hr_utility.trace('In function GET_MMREF_EMPLOYEE_ADDRESS');
413: --
414: lr_employee_addr :=
415: pay_us_get_item_data_pkg.GET_PERSON_NAME_ADDRESS(
416: p_report_type,
417: l_person_id,
418: p_assignment_id,
419: p_date_earned,
541: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
542: c_item_name varchar2(40);
543: l_emp_number varchar2(40);
544: l_locality_company_id varchar2(50);
545: lr_employer_addr pay_us_get_item_data_pkg.organization_name_address;
546: BEGIN
547: hr_utility.trace('FUNCTION GET_MMREF_EMPLOYER_ADDRESS for Employer Address');
548: c_tax_unit_id := p_tax_unit_id;
549: c_item_name := 'ER_ADDRESS';
560: hr_utility.trace('ER_ADDRESS Locality_Company_Id ...'||
561: l_locality_company_id );
562: END IF;
563: lr_employer_addr :=
564: pay_us_get_item_data_pkg.get_organization_name_address(
565: c_tax_unit_id,
566: p_effective_date,
567: p_validate,
568: p_record_name);
1019: AND hl.location_id = hou.location_id
1020: AND nvl(hl.inactive_date,end_date)>= c_effective_date
1021: AND hrl.lookup_code (+)=hl.country
1022: AND lookup_type (+)='PQP_US_COUNTRY_TRANSLATE';
1023: lr_org_name_address pay_us_get_item_data_pkg.organization_name_address;
1024: l_addr_count number(10) := 0;
1025: l_valid_address varchar2(3) := 'N';
1026: l_too_many_adr_token3 varchar2(50):='More than one address found';
1027: l_token2 varchar2(50);
1139: --}
1140: --
1141: --BEGIN
1142: --hr_utility.trace_on(null,'GETITEMDATA');
1143: END pay_us_get_item_data_pkg; --End of Package Body