APPS.PO_XML_DELIVERY dependencies on HR_LOCATIONS_ALL

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

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

Line 1248: from HR_LOCATIONS_ALL HLA

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

Line 1315: from HR_LOCATIONS_ALL HLA

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

Line 1629: hrloc_rec hr_locations_all%ROWTYPE;

1625: postalcode out NOCOPY VARCHAR2,
1626: region out NOCOPY VARCHAR2,
1627: stateprovn out NOCOPY VARCHAR2)
1628: IS
1629: hrloc_rec hr_locations_all%ROWTYPE;
1630: l_style varchar2(50);
1631: BEGIN
1632:
1633: SELECT *

Line 1635: FROM hr_locations_all

1631: BEGIN
1632:
1633: SELECT *
1634: INTO hrloc_rec
1635: FROM hr_locations_all
1636: WHERE location_id = p_location_id;
1637:
1638: l_style := hrloc_rec.style;
1639:

Line 1842: FROM hr_locations_all hrl,

1838: x_telephone_1,
1839: x_telephone_2,
1840: x_telephone_3,
1841: x_partner_id_x
1842: FROM hr_locations_all hrl,
1843: --fnd_territories_vl ftv,
1844: fnd_lookup_values_vl flv1,
1845: fnd_lookup_values_vl flv2,
1846: fnd_lookup_values_vl flv3