APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 555: from po_distributions_all pd, po_distributions_draft_all pdd

551: /*124*/ ,pdd.WIP_RESOURCE_SEQ_NUM
552: /*pd.po_distribution_id,
553: pd.quantity_billed,
554: pd.amount_billed*/
555: from po_distributions_all pd, po_distributions_draft_all pdd
556: where pdd.po_distribution_id = pd.po_distribution_id
557: and pdd.draft_id = p_draft_id
558: and (pdd.quantity_billed <> pd.quantity_billed or
559: pdd.amount_billed <> pd.amount_billed);

Line 938: UPDATE po_distributions_draft_all

934: 'Updated '||sql%rowcount||' no of shipments');
935:
936: FORALL I in l_distributions.po_distribution_id.first
937: ..l_distributions.po_distribution_id.last
938: UPDATE po_distributions_draft_all
939: set quantity_billed = l_distributions.quantity_billed(I),
940: amount_billed = l_distributions.amount_billed(I)
941: where draft_id = p_draft_id
942: and po_distribution_id = l_distributions.po_distribution_id(I);

Line 2269: ,po_distributions_draft_all plda

2265: l_draft_old_amount_tbl,
2266: l_po_distribution_tbl,
2267: l_change_status_tbl
2268: FROM po_distributions_all pla
2269: ,po_distributions_draft_all plda
2270: WHERE pla.po_distribution_id = plda.po_distribution_id
2271: AND plda.draft_id = p_draft_id
2272: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
2273: AND NOT EXISTS (SELECT 'F locks'

Line 2301: FROM po_distributions_draft_all plda,

2297: ,'N'
2298: BULK COLLECT INTO l_po_dist_s_no_lck_tbl
2299: ,l_draft_id_tbl
2300: ,l_delete_flag_tbl
2301: FROM po_distributions_draft_all plda,
2302: po_distributions_all pla
2303: WHERE plda.draft_id = p_draft_id
2304: AND pla.po_distribution_id = plda.po_distribution_id
2305: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)

Line 2323: DELETE FROM po_distributions_draft_all plda

2319: END IF;
2320:
2321: -- 3. Delete dist identified in #2 above.
2322: FORALL i in 1..l_po_dist_s_no_lck_tbl.COUNT
2323: DELETE FROM po_distributions_draft_all plda
2324: WHERE plda.po_distribution_id=l_po_dist_s_no_lck_tbl(i)
2325: AND plda.draft_id = p_draft_id;
2326:
2327: d_position := 50;

Line 2347: UPDATE po_distributions_draft_all

2343: END IF;
2344:
2345: -- 5. Sync quantity and amount using the values fetched in #1 above
2346: FORALL i in 1.. l_po_distribution_tbl.COUNT
2347: UPDATE po_distributions_draft_all
2348: SET old_quantity_ordered = l_base_quantity_tbl(i)
2349: ,quantity_ordered = l_base_quantity_tbl(i) + (l_draft_quantity_tbl(i)-l_draft_old_quantity_tbl(i))
2350: ,old_amount_ordered = l_base_amount_tbl(i)
2351: ,amount_ordered = l_base_amount_tbl(i) + (l_draft_amount_tbl(i) - l_draft_old_amount_tbl(i))

Line 2359: PO_LOG.stmt(d_module,d_position ,'update po_distributions_draft_all for all locks excluding F lock');

2355: AND draft_id = p_draft_id;
2356:
2357: d_position := 60;
2358: IF (PO_LOG.d_stmt) THEN
2359: PO_LOG.stmt(d_module,d_position ,'update po_distributions_draft_all for all locks excluding F lock');
2360: PO_LOG.stmt(d_module,d_position,'revision_num',l_header_base_rev_num);
2361: END IF;
2362:
2363: d_position := 80;