DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on PO_PRICE_DIFFERENTIALS

Line 133: DELETE FROM po_price_differentials

129: l_progress := '080';
130:
131: -- delete price differentials
132: FORALL idx IN 1..l_line_ids.COUNT
133: DELETE FROM po_price_differentials
134: WHERE entity_id = l_line_ids(idx)
135: AND entity_type = 'REQ LINE';
136:
137: l_progress := '090';

Line 1331: UPDATE po_price_differentials

1327: l_progress := '130';
1328:
1329: -- flip the line IDs in the price differentials
1330: FORALL idx IN 1..p_tempLineIds.COUNT
1331: UPDATE po_price_differentials
1332: SET entity_id = p_origLineIds(idx)
1333: WHERE entity_id = p_tempLineIds(idx)
1334: AND entity_type = 'REQ LINE';
1335:

Line 1340: UPDATE po_price_differentials

1336: l_progress := '140';
1337:
1338: -- flip the price differential IDs
1339: FORALL idx IN 1..p_tempPriceDiffIds.COUNT
1340: UPDATE po_price_differentials
1341: SET price_differential_id = p_origPriceDiffIds(idx)
1342: WHERE price_differential_id = p_tempPriceDiffIds(idx);
1343:
1344: l_progress := '150';