APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 244: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;

240: --
241:
242: --
243: l_is_complex_work_po BOOLEAN;
244: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
245: --
246:
247: l_xml_flag PO_HEADERS_all.xml_flag%TYPE; -- Bug 5407459
248:

Line 382: FROM po_line_locations_all poll

378: --Shipment level Cancel action
379:
380: SELECT poll.shipment_type
381: INTO l_shipment_type
382: FROM po_line_locations_all poll
383: WHERE poll.line_location_id = p_doc_line_loc_id
384: ;
385:
386: END IF; --p_doc_line_loc_id is not null

Line 1755: po_line_locations_all poll,

1751: -- SQL Why: Find all allowable shipment level control actions for this doc
1752: SELECT polc.displayed_field,
1753: polc.lookup_code
1754: FROM po_lookup_codes polc,
1755: po_line_locations_all poll,
1756: po_headers_all poh
1757: WHERE poll.line_location_id = p_doc_line_loc_id
1758: AND poll.po_header_id = poh.po_header_id
1759: AND polc.lookup_type = 'CONTROL ACTIONS'

Line 3995: l_dummy PO_LINE_LOCATIONS_ALL.line_location_id%type := 0;

3991: l_timecard_exists BOOLEAN;
3992: l_otl_field_name VARCHAR2(20);
3993: l_otl_field_value NUMBER;
3994: l_current_entity_changed VARCHAR2(1);
3995: l_dummy PO_LINE_LOCATIONS_ALL.line_location_id%type := 0;
3996: d_pos NUMBER;
3997: l_api_name CONSTANT VARCHAR2(30) := 'Val_Cancel_FinalClose_Action';
3998: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.Val_Cancel_FinalClose_Action' ;
3999: BEGIN

Line 4185: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;

4181: ,x_is_encumbrance_error OUT NOCOPY VARCHAR2
4182: ,x_online_report_id OUT NOCOPY NUMBER--bug#5055417
4183: )
4184: IS
4185: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;

Line 4457: from po_line_locations_all

4453: IF (p_doc_level = PO_CORE_S.g_doc_level_SHIPMENT)
4454: THEN
4455: select shipment_type
4456: into l_doc_subtype
4457: from po_line_locations_all
4458: where line_location_id = p_doc_line_loc_id;
4459: ELSE
4460: l_doc_subtype := p_doc_subtype;
4461: END IF;

Line 4859: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE := NULL;

4855: p_doc_level IN VARCHAR2)
4856: RETURN BOOLEAN
4857: IS
4858: l_po_line_id PO_LINES_ALL.po_line_id%TYPE := NULL;
4859: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE := NULL;
4860: l_has_labor_expense_req BOOLEAN := FALSE;
4861: d_pos NUMBER := 0;
4862: l_api_name CONSTANT VARCHAR2(30) := 'is_backing_req_labor_expense';
4863: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.is_backing_req_labor_expense';

Line 5251: FROM po_line_locations_all poll1,

5247: INTO l_ship_invalid_for_ctrl_actn
5248: FROM DUAL
5249: WHERE EXISTS(
5250: SELECT 1
5251: FROM po_line_locations_all poll1,
5252: po_line_locations_all poll2
5253: WHERE poll1.line_location_id = p_doc_level_id
5254: AND poll1.po_line_id = poll2.po_line_id
5255: AND NVL(poll2.cancel_flag,'N') <> 'Y'

Line 5252: po_line_locations_all poll2

5248: FROM DUAL
5249: WHERE EXISTS(
5250: SELECT 1
5251: FROM po_line_locations_all poll1,
5252: po_line_locations_all poll2
5253: WHERE poll1.line_location_id = p_doc_level_id
5254: AND poll1.po_line_id = poll2.po_line_id
5255: AND NVL(poll2.cancel_flag,'N') <> 'Y'
5256: AND NVL(poll2.payment_type, 'NULL') NOT IN ('ADVANCE', 'DELIVERY') --