DBA Data[Home] [Help]

APPS.PO_DRAFTS_PVT dependencies on PO_LINE_UCAS

Line 9429: DELETE FROM po_line_ucas

9425:
9426: IF l_isucaenabled = 'Y' THEN
9427: -- revert the changes for undefinitizing mods
9428: forall ucaindex IN 1 .. po_line_ids_tbl.Count()
9429: DELETE FROM po_line_ucas
9430: WHERE po_line_id = Po_line_ids_tbl(ucaindex)
9431: AND undef_draft_id = p_po_draft_id;
9432: --revert the values for definitizing mods
9433: forall ucaindex IN 1 .. po_line_ids_tbl.Count()

Line 9434: UPDATE po_line_ucas

9430: WHERE po_line_id = Po_line_ids_tbl(ucaindex)
9431: AND undef_draft_id = p_po_draft_id;
9432: --revert the values for definitizing mods
9433: forall ucaindex IN 1 .. po_line_ids_tbl.Count()
9434: UPDATE po_line_ucas
9435: SET def_draft_id = NULL,
9436: def_description = NULL,
9437: def_par_draft_id = NULL
9438: WHERE po_line_id = Po_line_ids_tbl(ucaindex)