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 388: UPDATE po_distributions_draft_all

384: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
385: END IF;
386:
387: FORALL i IN 1..p_po_distribution_id_tbl.COUNT
388: UPDATE po_distributions_draft_all
389: SET delete_flag = p_delete_flag_tbl(i)
390: WHERE po_distribution_id = p_po_distribution_id_tbl(i)
391: AND draft_id = p_draft_id_tbl(i)
392: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 537: FROM po_distributions_draft_all PDD

533:
534: DELETE FROM po_distributions_all PD
535: WHERE PD.po_distribution_id IN
536: ( SELECT PDD.po_distribution_id -- Bug 5292573
537: FROM po_distributions_draft_all PDD
538: WHERE PDD.draft_id = p_draft_id
539: AND PDD.delete_flag = 'Y'
540: AND NVL(PDD.change_accepted_flag, 'Y') = 'Y' );
541:

Line 688: FROM po_distributions_draft_all PDD

684: PDD.retainage_withheld_amount,
685: PDD.retainage_released_amount,
686: --
687: PDD.tax_attribute_update_code --
688: FROM po_distributions_draft_all PDD
689: WHERE PDD.draft_id = p_draft_id
690: AND NVL(PDD.change_accepted_flag, 'Y') = 'Y'
691: ) PDDV
692: ON (PD.po_distribution_id = PDDV.po_distribution_id)

Line 1050: FROM po_distributions_draft_all

1046: END IF;
1047:
1048: SELECT 1
1049: INTO l_dummy
1050: FROM po_distributions_draft_all
1051: WHERE po_distribution_id = p_po_distribution_id
1052: AND draft_id = p_draft_id
1053: FOR UPDATE NOWAIT;
1054: