APPS.PO_DOCUMENT_CHECKS_PVT dependencies on HR_LOCATIONS_ALL

Line 2289: TYPE CharTab is TABLE of HR_LOCATIONS_ALL_TL.location_code%type INDEX by BINARY_INTEGER;

2285: --
2286:
2287: --bug#3987438
2288: --A new table to hold the invalid ship to location codes
2289: TYPE CharTab is TABLE of HR_LOCATIONS_ALL_TL.location_code%type INDEX by BINARY_INTEGER;
2290: l_ship_to_location_tbl CharTab;
2291: --bug#3987438
2292:
2293: BEGIN

Line 2563: HR_LOCATIONS_ALL HLA,

2559: BULK COLLECT INTO
2560: l_line_num,
2561: l_ship_to_location_tbl
2562: FROM PO_LINE_LOCATIONS_GT POLG,
2563: HR_LOCATIONS_ALL HLA,
2564: HR_LOCATIONS_ALL_TL HLT
2565: WHERE POLG.po_release_id = p_document_id
2566: AND POLG.ship_to_location_id=HLA.location_id
2567: AND nvl(POLG.cancel_flag,'N') = 'N'

Line 2564: HR_LOCATIONS_ALL_TL HLT

2560: l_line_num,
2561: l_ship_to_location_tbl
2562: FROM PO_LINE_LOCATIONS_GT POLG,
2563: HR_LOCATIONS_ALL HLA,
2564: HR_LOCATIONS_ALL_TL HLT
2565: WHERE POLG.po_release_id = p_document_id
2566: AND POLG.ship_to_location_id=HLA.location_id
2567: AND nvl(POLG.cancel_flag,'N') = 'N'
2568: AND nvl(POLG.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 4833: l_invalid_location HR_LOCATIONS_ALL_TL.location_code%type;

4829:
4830: --bug#3987438
4831: --Adding a new variable that would hold the name of the invalid
4832: --ship-to or bill-to location
4833: l_invalid_location HR_LOCATIONS_ALL_TL.location_code%type;
4834: --bug#3987438
4835:
4836: BEGIN
4837:

Line 5086: FROM hr_locations_all hla,

5082: ELSE
5083: BEGIN
5084: SELECT hlt.location_code
5085: INTO l_invalid_location
5086: FROM hr_locations_all hla,
5087: hr_locations_all_tl hlt
5088: WHERE hla.location_id = l_ship_to_location_id
5089: AND NVL(TRUNC(hla.inactive_date), TRUNC(SYSDATE)+1 ) <= TRUNC(SYSDATE)
5090: AND hlt.location_id=hla.location_id

Line 5087: hr_locations_all_tl hlt

5083: BEGIN
5084: SELECT hlt.location_code
5085: INTO l_invalid_location
5086: FROM hr_locations_all hla,
5087: hr_locations_all_tl hlt
5088: WHERE hla.location_id = l_ship_to_location_id
5089: AND NVL(TRUNC(hla.inactive_date), TRUNC(SYSDATE)+1 ) <= TRUNC(SYSDATE)
5090: AND hlt.location_id=hla.location_id
5091: AND hlt.language=USERENV('LANG');

Line 5177: FROM hr_locations_all hla,

5173: ELSE
5174: BEGIN
5175: SELECT hlt.location_code
5176: INTO l_invalid_location
5177: FROM hr_locations_all hla,
5178: hr_locations_all_tl hlt
5179: WHERE hla.location_id = l_bill_to_location_id
5180: AND NVL(TRUNC(hla.inactive_date), TRUNC(SYSDATE)+1 ) <= TRUNC(SYSDATE)
5181: AND hlt.location_id=hla.location_id

Line 5178: hr_locations_all_tl hlt

5174: BEGIN
5175: SELECT hlt.location_code
5176: INTO l_invalid_location
5177: FROM hr_locations_all hla,
5178: hr_locations_all_tl hlt
5179: WHERE hla.location_id = l_bill_to_location_id
5180: AND NVL(TRUNC(hla.inactive_date), TRUNC(SYSDATE)+1 ) <= TRUNC(SYSDATE)
5181: AND hlt.location_id=hla.location_id
5182: AND hlt.language=USERENV('LANG');

Line 5625: TYPE CharTab is TABLE of HR_LOCATIONS_ALL_TL.location_code%type INDEX by BINARY_INTEGER;

5621: l_val_contract_limit NUMBER; -- bug3673292
5622:
5623: --bug#3987438
5624: --A new table to hold the invalid ship to location codes
5625: TYPE CharTab is TABLE of HR_LOCATIONS_ALL_TL.location_code%type INDEX by BINARY_INTEGER;
5626: l_ship_to_location_tbl CharTab;
5627: --bug#3987438
5628:
5629: --

Line 6822: hr_locations_all hla,

6818: l_ship_to_location_tbl
6819: FROM
6820: po_lines_gt pol,
6821: po_line_locations_gt poll,
6822: hr_locations_all hla,
6823: hr_locations_all_tl hlat
6824: WHERE poll.po_header_id=p_document_id
6825: and pol.po_Header_id=p_document_id
6826: and pol.po_line_id = poll.po_line_id

Line 6823: hr_locations_all_tl hlat

6819: FROM
6820: po_lines_gt pol,
6821: po_line_locations_gt poll,
6822: hr_locations_all hla,
6823: hr_locations_all_tl hlat
6824: WHERE poll.po_header_id=p_document_id
6825: and pol.po_Header_id=p_document_id
6826: and pol.po_line_id = poll.po_line_id
6827: and poll.ship_to_location_id = hla.location_id