APPS.AP_VENDOR_PUB_PKG dependencies on HR_LOCATIONS_ALL

Line 1303: l_ship_locn_id HR_LOCATIONS_ALL.ship_to_location_id%TYPE;

1299: p_default_ship_to_loc_id IN NUMBER,
1300: x_valid OUT NOCOPY BOOLEAN
1301: ) IS
1302:
1303: l_ship_locn_id HR_LOCATIONS_ALL.ship_to_location_id%TYPE;
1304: l_ship_locn_code HR_LOCATIONS_ALL.location_code%TYPE;
1305:
1306: BEGIN
1307: x_valid := TRUE;

Line 1304: l_ship_locn_code HR_LOCATIONS_ALL.location_code%TYPE;

1300: x_valid OUT NOCOPY BOOLEAN
1301: ) IS
1302:
1303: l_ship_locn_id HR_LOCATIONS_ALL.ship_to_location_id%TYPE;
1304: l_ship_locn_code HR_LOCATIONS_ALL.location_code%TYPE;
1305:
1306: BEGIN
1307: x_valid := TRUE;
1308:

Line 1318: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1314:
1315: BEGIN
1316: SELECT lot.location_code
1317: INTO l_ship_locn_code
1318: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1319: WHERE loc.location_id = p_ship_location_id
1320: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1321: AND loc.location_id = lot.location_id
1322: AND lot.language = userenv('LANG')

Line 1341: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1337: ELSIF (p_ship_location_id is NOT NULL and p_ship_location_code is NOT NULL) THEN
1338: BEGIN
1339: SELECT loc.location_id
1340: INTO l_ship_locn_id
1341: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1342: WHERE lot.location_code = p_ship_location_code
1343: AND loc.location_id = p_ship_location_id
1344: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1345: AND loc.location_id = lot.location_id

Line 1366: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1362: ELSIF (p_ship_location_id is NULL and p_ship_location_code is NOT NULL) THEN
1363: BEGIN
1364: SELECT loc.location_id
1365: INTO p_ship_location_id
1366: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1367: WHERE lot.location_code = p_ship_location_code
1368: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1369: AND loc.location_id = lot.location_id
1370: AND lot.language = userenv('LANG')

Line 1399: l_bill_locn_id HR_LOCATIONS_ALL.location_id%TYPE;

1395: p_default_bill_to_loc_id IN NUMBER,
1396: x_valid OUT NOCOPY BOOLEAN
1397: ) IS
1398:
1399: l_bill_locn_id HR_LOCATIONS_ALL.location_id%TYPE;
1400: l_bill_locn_code HR_LOCATIONS_ALL.location_code%TYPE;
1401:
1402: BEGIN
1403: x_valid := TRUE;

Line 1400: l_bill_locn_code HR_LOCATIONS_ALL.location_code%TYPE;

1396: x_valid OUT NOCOPY BOOLEAN
1397: ) IS
1398:
1399: l_bill_locn_id HR_LOCATIONS_ALL.location_id%TYPE;
1400: l_bill_locn_code HR_LOCATIONS_ALL.location_code%TYPE;
1401:
1402: BEGIN
1403: x_valid := TRUE;
1404:

Line 1412: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1408: ELSIF (p_bill_location_id is NOT NULL and p_bill_location_code is NULL) THEN
1409: BEGIN
1410: SELECT lot.location_code
1411: INTO l_bill_locn_code
1412: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1413: WHERE loc.location_id = p_bill_location_id
1414: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1415: AND loc.location_id = lot.location_id
1416: AND lot.language = userenv('LANG')

Line 1436: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1432:
1433: BEGIN
1434: SELECT loc.location_id
1435: INTO l_bill_locn_id
1436: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1437: WHERE loc.location_id = p_bill_location_id
1438: AND lot.location_code = p_bill_location_code
1439: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1440: AND loc.location_id = lot.location_id

Line 1462: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1458:
1459: BEGIN
1460: SELECT loc.location_id
1461: INTO p_bill_location_id
1462: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1463: WHERE lot.location_code = p_bill_location_code
1464: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1465: AND loc.location_id = lot.location_id
1466: AND lot.language = userenv('LANG')