DBA Data[Home] [Help]

APPS.PO_DOC_UDA_UTIL dependencies on PO_LINES_ALL_EXT_B

Line 406: DELETE FROM PO_LINES_ALL_EXT_TL WHERE extension_id IN (SELECT extension_id FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1);

402: FROM po_lines_all
403: WHERE PO_LINE_ID = l_po_line_ids(i);
404:
405: IF (l_drft_contract_type <> l_base_contract_type) OR (l_drft_idc_type <> l_base_idc_type) THEN
406: DELETE FROM PO_LINES_ALL_EXT_TL WHERE extension_id IN (SELECT extension_id FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1);
407: DELETE FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1;
408: END IF;
409:
410: PO_UDA_DATA_UTIL.AutoCreate_User_Attrs

Line 407: DELETE FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1;

403: WHERE PO_LINE_ID = l_po_line_ids(i);
404:
405: IF (l_drft_contract_type <> l_base_contract_type) OR (l_drft_idc_type <> l_base_idc_type) THEN
406: DELETE FROM PO_LINES_ALL_EXT_TL WHERE extension_id IN (SELECT extension_id FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1);
407: DELETE FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1;
408: END IF;
409:
410: PO_UDA_DATA_UTIL.AutoCreate_User_Attrs
411: (