eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AP_INVOICE_MATCH_GRP dependencies on PO_DISTRIBUTIONS_ALL

Line 145: UPDATE po_distributions_all pod

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

Line 483: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,

479: --End of Comments
480: ----------------------------------------------------------------------------------------
481:
482: PROCEDURE get_po_dist_amounts (p_api_version IN NUMBER,
483: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
484: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,
485: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,
486: x_ret_status OUT NOCOPY VARCHAR2,
487: x_msg_count OUT NOCOPY NUMBER,

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

480: ----------------------------------------------------------------------------------------
481:
482: PROCEDURE get_po_dist_amounts (p_api_version IN NUMBER,
483: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
484: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,
485: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,
486: x_ret_status OUT NOCOPY VARCHAR2,
487: x_msg_count OUT NOCOPY NUMBER,
488: x_msg_data OUT NOCOPY VARCHAR2) IS

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

481:
482: PROCEDURE get_po_dist_amounts (p_api_version IN NUMBER,
483: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
484: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,
485: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,
486: x_ret_status OUT NOCOPY VARCHAR2,
487: x_msg_count OUT NOCOPY NUMBER,
488: x_msg_data OUT NOCOPY VARCHAR2) IS
489:

Line 596: --Modifies: PO_DISTRIBUTIONS_ALL

592: --Name: update_po_dist_amounts
593: --
594: --Pre-reqs: None
595: --
596: --Modifies: PO_DISTRIBUTIONS_ALL
597: --
598: --Locks: None
599: --
600: --Function: This procedure updates the amount billed on po distributions during amount matching process

Line 627: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,

623: --End of Comments
624: -------------------------------------------------------------------------------------------------------
625:
626: PROCEDURE update_po_dist_amounts (p_api_version IN NUMBER,
627: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
628: p_dist_amt_billed IN PO_DISTRIBUTIONS_ALL.amount_billed%TYPE,
629: x_ret_status OUT NOCOPY VARCHAR2,
630: x_msg_count OUT NOCOPY NUMBER,
631: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 628: p_dist_amt_billed IN PO_DISTRIBUTIONS_ALL.amount_billed%TYPE,

624: -------------------------------------------------------------------------------------------------------
625:
626: PROCEDURE update_po_dist_amounts (p_api_version IN NUMBER,
627: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
628: p_dist_amt_billed IN PO_DISTRIBUTIONS_ALL.amount_billed%TYPE,
629: x_ret_status OUT NOCOPY VARCHAR2,
630: x_msg_count OUT NOCOPY NUMBER,
631: x_msg_data OUT NOCOPY VARCHAR2) IS
632:

Line 650: UPDATE po_distributions_all

646:
647: -- SQL What : Updates the amount billed on the po distribution
648: -- SQL Why : This is the amount that was billed against this distribution
649:
650: UPDATE po_distributions_all
651: SET amount_billed = nvl(amount_billed,0) + nvl(p_dist_amt_billed,0)
652: WHERE po_distribution_id = p_po_distribution_id;
653:
654: EXCEPTION