DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on PO_REQUISITION_SUPPLIERS

Line 126: DELETE FROM po_requisition_suppliers

122: l_progress := '070';
123:
124: -- delete line suppliers
125: FORALL idx IN 1..l_line_ids.COUNT
126: DELETE FROM po_requisition_suppliers
127: WHERE requisition_line_id = l_line_ids(idx);
128:
129: l_progress := '080';
130:

Line 1315: UPDATE po_requisition_suppliers

1311: l_progress := '110';
1312:
1313: -- flip the line IDs in the requisition suppliers
1314: FORALL idx IN 1..p_tempLineIds.COUNT
1315: UPDATE po_requisition_suppliers
1316: SET requisition_line_id = p_origLineIds(idx)
1317: WHERE requisition_line_id = p_tempLineIds(idx);
1318:
1319: l_progress := '120';

Line 1323: UPDATE po_requisition_suppliers

1319: l_progress := '120';
1320:
1321: -- flip the requisition supplier IDs
1322: FORALL idx IN 1..p_tempReqSupplierIds.COUNT
1323: UPDATE po_requisition_suppliers
1324: SET requisition_supplier_id = p_origReqSupplierIds(idx)
1325: WHERE requisition_supplier_id = p_tempReqSupplierIds(idx);
1326:
1327: l_progress := '130';