APPS.PO_DISTRIBUTIONS_DRAFT_PKG dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 47: DELETE FROM po_distributions_draft_all

43: IF (PO_LOG.d_proc) THEN
44: PO_LOG.proc_begin(d_module);
45: END IF;
46:
47: DELETE FROM po_distributions_draft_all
48: WHERE draft_id = p_draft_id
49: AND po_distribution_id = NVL(p_po_distribution_id, po_distribution_id);
50:
51: EXCEPTION

Line 147: INSERT INTO po_distributions_draft_all

143: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
144: END IF;
145:
146: FORALL i IN 1..p_po_distribution_id_tbl.COUNT
147: INSERT INTO po_distributions_draft_all
148: (
149: draft_id,
150: delete_flag,
151: change_accepted_flag,

Line 422: UPDATE po_distributions_draft_all

418: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
419: END IF;
420:
421: FORALL i IN 1..p_po_distribution_id_tbl.COUNT
422: UPDATE po_distributions_draft_all
423: SET delete_flag = p_delete_flag_tbl(i)
424: WHERE po_distribution_id = p_po_distribution_id_tbl(i)
425: AND draft_id = p_draft_id_tbl(i)
426: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 571: FROM po_distributions_draft_all PDD

567:
568: DELETE FROM po_distributions_all PD
569: WHERE PD.po_distribution_id IN
570: ( SELECT PDD.po_distribution_id -- Bug 5292573
571: FROM po_distributions_draft_all PDD
572: WHERE PDD.draft_id = p_draft_id
573: AND PDD.delete_flag = 'Y'
574: AND NVL(PDD.change_accepted_flag, 'Y') = 'Y' );
575:

Line 737: FROM po_distributions_draft_all PDD

733: PDD.change_in_funded_value,
734: PDD.ACRN, -- ACRN proj
735: PDD.clm_payment_sequence_num, -- CLM Phase 4
736: PDD.amount_changed_flag --Bug 13503748 Encumbrance ER
737: FROM po_distributions_draft_all PDD
738: WHERE PDD.draft_id = p_draft_id
739: AND NVL(PDD.change_accepted_flag, 'Y') = 'Y'
740: ) PDDV
741: ON (PD.po_distribution_id = PDDV.po_distribution_id)

Line 1140: FROM po_distributions_draft_all

1136: END IF;
1137:
1138: SELECT 1
1139: INTO l_dummy
1140: FROM po_distributions_draft_all
1141: WHERE po_distribution_id = p_po_distribution_id
1142: AND draft_id = p_draft_id
1143: FOR UPDATE NOWAIT;
1144: