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 1290: UPDATE po_price_differentials

1286: l_progress := '130';
1287:
1288: -- flip the line IDs in the price differentials
1289: FORALL idx IN 1..p_tempLineIds.COUNT
1290: UPDATE po_price_differentials
1291: SET entity_id = p_origLineIds(idx)
1292: WHERE entity_id = p_tempLineIds(idx)
1293: AND entity_type = 'REQ LINE';
1294:

Line 1299: UPDATE po_price_differentials

1295: l_progress := '140';
1296:
1297: -- flip the price differential IDs
1298: FORALL idx IN 1..p_tempPriceDiffIds.COUNT
1299: UPDATE po_price_differentials
1300: SET price_differential_id = p_origPriceDiffIds(idx)
1301: WHERE price_differential_id = p_tempPriceDiffIds(idx);
1302:
1303: l_progress := '150';