APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_LINES_ALL

Line 4683: l_po_line_id PO_LINES_ALL.po_line_id%TYPE := NULL;

4679: FUNCTION is_backing_req_labor_expense(p_doc_level_id IN NUMBER,
4680: p_doc_level IN VARCHAR2)
4681: RETURN BOOLEAN
4682: IS
4683: l_po_line_id PO_LINES_ALL.po_line_id%TYPE := NULL;
4684: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE := NULL;
4685: l_has_labor_expense_req BOOLEAN := FALSE;
4686: d_pos NUMBER := 0;
4687: l_api_name CONSTANT VARCHAR2(30) := 'is_backing_req_labor_expense';

Line 4963: l_item_id PO_LINES_ALL.item_Id%TYPE;

4959: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%type;
4960: l_cons_trans_exist VARCHAR2(1);
4961: l_index NUMBER;
4962: l_agent_id NUMBER;
4963: l_item_id PO_LINES_ALL.item_Id%TYPE;
4964: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
4965: l_current_action PO_LOOKUP_CODES.lookup_code%TYPE;
4966: l_mode VARCHAR2(30);
4967: l_ship_invalid_for_ctrl_actn VARCHAR2(1) := 'N';

Line 4964: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;

4960: l_cons_trans_exist VARCHAR2(1);
4961: l_index NUMBER;
4962: l_agent_id NUMBER;
4963: l_item_id PO_LINES_ALL.item_Id%TYPE;
4964: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
4965: l_current_action PO_LOOKUP_CODES.lookup_code%TYPE;
4966: l_mode VARCHAR2(30);
4967: l_ship_invalid_for_ctrl_actn VARCHAR2(1) := 'N';
4968: d_pos NUMBER;

Line 5017: FROM po_lines_merge_v -- Replaced po_lines_all

5013: d_pos := 40;
5014: --get the itme_id for the consumption transaction existence check
5015: SELECT item_id
5016: INTO l_item_id
5017: FROM po_lines_merge_v -- Replaced po_lines_all
5018: WHERE po_line_id = p_doc_level_id
5019: AND draft_id = p_draft_id;
5020:
5021: IF (PO_LOG.d_stmt) THEN