APPS.PO_XML_DELIVERY dependencies on HR_LOCATIONS_ALL

Line 1192: p_COUNTRY := 'US'; --country is not mandatory in hr_locations_all

1188: p_STATE, p_TELEPHONE_NUMBER_1,
1189: p_TELEPHONE_NUMBER_2, p_TELEPHONE_NUMBER_3);
1190:
1191: if (p_COUNTRY is null) then
1192: p_COUNTRY := 'US'; --country is not mandatory in hr_locations_all
1193: end if;
1194: p_iso_country_code := p_COUNTRY;
1195:
1196: end;

Line 1245: from HR_LOCATIONS_ALL HLA

1241: p_ECE_TP_LOCATION_CODE, p_ADDRESS_LINE_1, p_ADDRESS_LINE_2,
1242: p_ADDRESS_LINE_3, p_TOWN_OR_CITY, p_COUNTRY,
1243: p_POSTAL_CODE, p_STATE, p_TELEPHONE_NUMBER_1,
1244: p_TELEPHONE_NUMBER_2, p_TELEPHONE_NUMBER_3
1245: from HR_LOCATIONS_ALL HLA
1246: where HLA.LOCATION_ID = p_ship_to_location_id;
1247:
1248: end if;
1249: exception when others then

Line 1312: from HR_LOCATIONS_ALL HLA

1308: p_ECE_TP_LOCATION_CODE, p_ADDRESS_LINE_1, p_ADDRESS_LINE_2,
1309: p_ADDRESS_LINE_3, p_TOWN_OR_CITY, p_COUNTRY,
1310: p_POSTAL_CODE, p_STATE, p_TELEPHONE_NUMBER_1,
1311: p_TELEPHONE_NUMBER_2, p_TELEPHONE_NUMBER_3
1312: from HR_LOCATIONS_ALL HLA
1313: where HLA.LOCATION_ID = p_ship_to_location_id;
1314:
1315: --- Address details to be mapped depending on address style
1316: -- previous mapping works only for US_GLB

Line 1625: hrloc_rec hr_locations_all%ROWTYPE;

1621: postalcode out NOCOPY VARCHAR2,
1622: region out NOCOPY VARCHAR2,
1623: stateprovn out NOCOPY VARCHAR2)
1624: IS
1625: hrloc_rec hr_locations_all%ROWTYPE;
1626: l_style varchar2(50);
1627: BEGIN
1628:
1629: SELECT *

Line 1631: FROM hr_locations_all

1627: BEGIN
1628:
1629: SELECT *
1630: INTO hrloc_rec
1631: FROM hr_locations_all
1632: WHERE location_id = p_location_id;
1633:
1634: l_style := hrloc_rec.style;
1635:

Line 1838: FROM hr_locations_all hrl,

1834: x_telephone_1,
1835: x_telephone_2,
1836: x_telephone_3,
1837: x_partner_id_x
1838: FROM hr_locations_all hrl,
1839: --fnd_territories_vl ftv,
1840: fnd_lookup_values_vl flv1,
1841: fnd_lookup_values_vl flv2,
1842: fnd_lookup_values_vl flv3