APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_LINES_ALL

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

4854: FUNCTION is_backing_req_labor_expense(p_doc_level_id IN NUMBER,
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';

Line 5137: l_item_id PO_LINES_ALL.item_Id%TYPE;

5133: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%type;
5134: l_cons_trans_exist VARCHAR2(1);
5135: l_index NUMBER;
5136: l_agent_id NUMBER;
5137: l_item_id PO_LINES_ALL.item_Id%TYPE;
5138: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
5139: l_current_action PO_LOOKUP_CODES.lookup_code%TYPE;
5140: l_mode VARCHAR2(30);
5141: l_ship_invalid_for_ctrl_actn VARCHAR2(1) := 'N';

Line 5138: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;

5134: l_cons_trans_exist VARCHAR2(1);
5135: l_index NUMBER;
5136: l_agent_id NUMBER;
5137: l_item_id PO_LINES_ALL.item_Id%TYPE;
5138: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
5139: l_current_action PO_LOOKUP_CODES.lookup_code%TYPE;
5140: l_mode VARCHAR2(30);
5141: l_ship_invalid_for_ctrl_actn VARCHAR2(1) := 'N';
5142: d_pos NUMBER;

Line 5191: FROM po_lines_all

5187: d_pos := 40;
5188: --get the itme_id for the consumption transaction existence check
5189: SELECT item_id
5190: INTO l_item_id
5191: FROM po_lines_all
5192: WHERE po_line_id = p_doc_level_id;
5193:
5194: IF (PO_LOG.d_stmt) THEN
5195: PO_LOG.stmt(d_module,d_pos,'l_item_id',l_agent_id);