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 1274: UPDATE po_requisition_suppliers

1270: l_progress := '110';
1271:
1272: -- flip the line IDs in the requisition suppliers
1273: FORALL idx IN 1..p_tempLineIds.COUNT
1274: UPDATE po_requisition_suppliers
1275: SET requisition_line_id = p_origLineIds(idx)
1276: WHERE requisition_line_id = p_tempLineIds(idx);
1277:
1278: l_progress := '120';

Line 1282: UPDATE po_requisition_suppliers

1278: l_progress := '120';
1279:
1280: -- flip the requisition supplier IDs
1281: FORALL idx IN 1..p_tempReqSupplierIds.COUNT
1282: UPDATE po_requisition_suppliers
1283: SET requisition_supplier_id = p_origReqSupplierIds(idx)
1284: WHERE requisition_supplier_id = p_tempReqSupplierIds(idx);
1285:
1286: l_progress := '130';