APPS.PO_AP_INVOICE_MATCH_GRP dependencies on PO_DISTRIBUTIONS_ALL

Line 147: UPDATE po_distributions_all pod

143: -- SQL Where: For the distribution rows represented in p_dist_changes_rec
144: -- Also, for Scheduled Releases, update the information on the
145: -- backing Planned PO distribution row as well
146: FORALL i IN 1..p_dist_changes_rec.po_distribution_id_tbl.COUNT
147: UPDATE po_distributions_all pod
148: SET quantity_billed =
149: DECODE(p_dist_changes_rec.quantity_billed_tbl(i)
150: , NULL, quantity_billed
151: , nvl(quantity_billed, 0) + p_dist_changes_rec.quantity_billed_tbl(i)),

Line 539: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,

535: --End of Comments
536: ----------------------------------------------------------------------------------------
537:
538: PROCEDURE get_po_dist_amounts (p_api_version IN NUMBER,
539: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
540: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,
541: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,
542: x_ret_status OUT NOCOPY VARCHAR2,
543: x_msg_count OUT NOCOPY NUMBER,

Line 540: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,

536: ----------------------------------------------------------------------------------------
537:
538: PROCEDURE get_po_dist_amounts (p_api_version IN NUMBER,
539: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
540: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,
541: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,
542: x_ret_status OUT NOCOPY VARCHAR2,
543: x_msg_count OUT NOCOPY NUMBER,
544: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 541: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,

537:
538: PROCEDURE get_po_dist_amounts (p_api_version IN NUMBER,
539: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
540: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,
541: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,
542: x_ret_status OUT NOCOPY VARCHAR2,
543: x_msg_count OUT NOCOPY NUMBER,
544: x_msg_data OUT NOCOPY VARCHAR2) IS
545:

Line 652: --Modifies: PO_DISTRIBUTIONS_ALL

648: --Name: update_po_dist_amounts
649: --
650: --Pre-reqs: None
651: --
652: --Modifies: PO_DISTRIBUTIONS_ALL
653: --
654: --Locks: None
655: --
656: --Function: This procedure updates the amount billed on po distributions during amount matching process

Line 683: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,

679: --End of Comments
680: -------------------------------------------------------------------------------------------------------
681:
682: PROCEDURE update_po_dist_amounts (p_api_version IN NUMBER,
683: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
684: p_dist_amt_billed IN PO_DISTRIBUTIONS_ALL.amount_billed%TYPE,
685: x_ret_status OUT NOCOPY VARCHAR2,
686: x_msg_count OUT NOCOPY NUMBER,
687: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 684: p_dist_amt_billed IN PO_DISTRIBUTIONS_ALL.amount_billed%TYPE,

680: -------------------------------------------------------------------------------------------------------
681:
682: PROCEDURE update_po_dist_amounts (p_api_version IN NUMBER,
683: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
684: p_dist_amt_billed IN PO_DISTRIBUTIONS_ALL.amount_billed%TYPE,
685: x_ret_status OUT NOCOPY VARCHAR2,
686: x_msg_count OUT NOCOPY NUMBER,
687: x_msg_data OUT NOCOPY VARCHAR2) IS
688:

Line 706: UPDATE po_distributions_all

702:
703: -- SQL What : Updates the amount billed on the po distribution
704: -- SQL Why : This is the amount that was billed against this distribution
705:
706: UPDATE po_distributions_all
707: SET amount_billed = nvl(amount_billed,0) + nvl(p_dist_amt_billed,0)
708: WHERE po_distribution_id = p_po_distribution_id;
709:
710: EXCEPTION