DBA Data[Home] [Help]

APPS.PO_DOC_UDA_UTIL dependencies on PO_LINES_DRAFT_ALL

Line 157: FROM po_lines_draft_all

153: ELSE
154: BEGIN
155: SELECT CONTRACT_TYPE, CLM_IDC_TYPE
156: INTO l_contract_type ,l_clm_idc_type
157: FROM po_lines_draft_all
158: WHERE po_line_id = p_po_line_id
159: AND draft_id = p_draft_id;
160: EXCEPTION
161: WHEN No_Data_Found THEN

Line 378: FROM po_lines_draft_all

374:
375: -- STARTING WITH LINE MERGE
376: SELECT po_line_id BULK COLLECT
377: INTO l_po_line_ids
378: FROM po_lines_draft_all
379: WHERE po_header_id = p_po_header_id
380: AND draft_id = p_draft_id;
381:
382: FOR i IN 1..l_po_line_ids.Count

Line 396: FROM po_lines_draft_all

392: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', -1));
393:
394: SELECT CONTRACT_TYPE, CLM_IDC_TYPE
395: INTO l_drft_contract_type, l_drft_idc_type
396: FROM po_lines_draft_all
397: WHERE PO_LINE_ID = l_po_line_ids(i)
398: AND DRAFT_ID = p_draft_id;
399:
400: SELECT CONTRACT_TYPE, CLM_IDC_TYPE