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_AUTO_DIST_PROCESS_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 811: PO_DISTRIBUTIONS_ALL

807: Name: create_payitem_dists
808: Pre-reqs:
809: PO Payitems have all been created.
810: Modifies:
811: PO_DISTRIBUTIONS_ALL
812: Locks:
813: None.
814: Function:
815: Create all distributions for all payitems for a PO Line.

Line 851: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL & PO_DISTRIBUTIONS_ALL has still not been populated

847: poll.price_override ,
848: poll.payment_type ,
849: pod.distribution_type ,
850: pod.rate
851: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL & PO_DISTRIBUTIONS_ALL has still not been populated
852: Hence po_distributions_draft_all & po_line_locations_draft_all needs to be used
853: */
854: FROM po_distributions_draft_all pod,
855: po_line_locations_draft_all poll

Line 1435: Similarly for po_distributions_all*/

1431: PO_AUTOCREATE_PARAMS.g_sys.sob_id ,
1432: nvl2(PO_AUTOCREATE_PARAMS.g_calculate_tax_flag, 'CREATE', NULL) --
1433: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1434: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used
1435: Similarly for po_distributions_all*/
1436: FROM PO_LINE_LOCATIONS_DRAFT_ALL adv,
1437: PO_LINE_LOCATIONS_DRAFT_ALL deliv,
1438: po_distributions_draft_all pod
1439: WHERE adv.po_line_id = p_lines.po_line_id_tbl(i)

Line 1795: -- po_distributions_all table

1791: IF (p_table_type = 'ALL') THEN
1792: l_progress:='010';
1793: --SQL WHAT: For distributions with award_id references, select
1794: -- the columns that Grants needs from the
1795: -- po_distributions_all table
1796: --SQL WHY : Needed to call GMS API to update award distribution
1797: -- lines table.
1798: SELECT pod.po_distribution_id,
1799: pod.distribution_num,

Line 1859: --SQL WHAT: Update po_distributions_all table with the new

1855:
1856: --
1857: IF (p_table_type = 'ALL') THEN
1858: l_progress := '040';
1859: --SQL WHAT: Update po_distributions_all table with the new
1860: -- award_id's
1861: --SQL WHY : award_id's in PO tables need to be synchronized with
1862: -- award_id's in GMS tables.
1863: FORALL i IN 1..l_gms_po_interface_obj.distribution_id.COUNT

Line 1946: l_sum_dist_amounts PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE;

1942:
1943: l_api_name VARCHAR2(30) := 'calibrate_last_dist_amount';
1944: l_log_head VARCHAR2(100) := g_log_head || l_api_name;
1945: l_progress VARCHAR2(3);
1946: l_sum_dist_amounts PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE;
1947: l_last_dist_amount PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE;
1948: l_last_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
1949: l_shipment_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
1950:

Line 1947: l_last_dist_amount PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE;

1943: l_api_name VARCHAR2(30) := 'calibrate_last_dist_amount';
1944: l_log_head VARCHAR2(100) := g_log_head || l_api_name;
1945: l_progress VARCHAR2(3);
1946: l_sum_dist_amounts PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE;
1947: l_last_dist_amount PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE;
1948: l_last_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
1949: l_shipment_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
1950:
1951: BEGIN

Line 1948: l_last_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;

1944: l_log_head VARCHAR2(100) := g_log_head || l_api_name;
1945: l_progress VARCHAR2(3);
1946: l_sum_dist_amounts PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE;
1947: l_last_dist_amount PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE;
1948: l_last_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
1949: l_shipment_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
1950:
1951: BEGIN
1952:

Line 2042: l_sum_dist_quantities PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;

2038: IS
2039:
2040: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.calibrate_last_dist_quantity';
2041: d_progress NUMBER;
2042: l_sum_dist_quantities PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;
2043: l_last_dist_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
2044: l_last_dist_qty PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;
2045: l_shipment_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
2046:

Line 2043: l_last_dist_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;

2039:
2040: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.calibrate_last_dist_quantity';
2041: d_progress NUMBER;
2042: l_sum_dist_quantities PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;
2043: l_last_dist_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
2044: l_last_dist_qty PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;
2045: l_shipment_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
2046:
2047: BEGIN

Line 2044: l_last_dist_qty PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;

2040: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.calibrate_last_dist_quantity';
2041: d_progress NUMBER;
2042: l_sum_dist_quantities PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;
2043: l_last_dist_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
2044: l_last_dist_qty PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;
2045: l_shipment_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
2046:
2047: BEGIN
2048: