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.AP_APXVDTIN_XMLP_PKG dependencies on HR_LOCATIONS

Line 6: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;

2: /* $Header: APXVDTINB.pls 120.0 2007/12/27 08:49:12 vjaganat noship $ */
3: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4: BEGIN
5: DECLARE
6: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
7: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
8: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
9: FROM_ADDRESS_LINE4 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
10: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;

Line 7: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;

3: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4: BEGIN
5: DECLARE
6: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
7: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
8: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
9: FROM_ADDRESS_LINE4 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
10: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
11: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;

Line 8: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;

4: BEGIN
5: DECLARE
6: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
7: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
8: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
9: FROM_ADDRESS_LINE4 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
10: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
11: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
12: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;

Line 9: FROM_ADDRESS_LINE4 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;

5: DECLARE
6: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
7: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
8: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
9: FROM_ADDRESS_LINE4 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
10: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
11: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
12: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;
13: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;

Line 10: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;

6: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
7: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
8: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
9: FROM_ADDRESS_LINE4 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
10: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
11: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
12: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;
13: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;
14: DISP_RETURN_DATE VARCHAR2(30);

Line 11: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;

7: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
8: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
9: FROM_ADDRESS_LINE4 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
10: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
11: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
12: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;
13: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;
14: DISP_RETURN_DATE VARCHAR2(30);
15: FROM_ATTENTION_LINE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

Line 12: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;

8: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
9: FROM_ADDRESS_LINE4 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
10: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
11: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
12: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;
13: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;
14: DISP_RETURN_DATE VARCHAR2(30);
15: FROM_ATTENTION_LINE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
16: INIT_FAILURE EXCEPTION;

Line 13: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;

9: FROM_ADDRESS_LINE4 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
10: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
11: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
12: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;
13: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;
14: DISP_RETURN_DATE VARCHAR2(30);
15: FROM_ATTENTION_LINE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
16: INIT_FAILURE EXCEPTION;
17: BEGIN

Line 95: HR_LOCATIONS L,

91: ,'fmMonth DD, YYYY'),
92: APL.DISPLAYED_FIELD
93: INTO FROM_ADDRESS_LINE1,FROM_ADDRESS_LINE2,FROM_ADDRESS_LINE3,FROM_ADDRESS_LINE4,FROM_CITY,FROM_STATE,FROM_ZIP,LOCATION_ID,DISP_RETURN_DATE,FROM_ATTENTION_LINE
94: FROM
95: HR_LOCATIONS L,
96: AP_REPORTING_ENTITIES R,
97: AP_LOOKUP_CODES APL
98: WHERE L.LOCATION_ID = R.LOCATION_ID
99: AND R.TAX_ENTITY_ID = P_TAX_ENTITY_ID