APPS.PO_LINK_REQ_DIST_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 775: FROM PO_DISTRIBUTIONS_ALL POD

771: , ((POD.QUANTITY_ORDERED-NVL(POD.QUANTITY_CANCELLED,0))*POLL.PRICE_OVERRIDE)
772: )
773: )
774:
775: FROM PO_DISTRIBUTIONS_ALL POD
776: WHERE POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID),0)
777: )DAR
778: FROM PO_LINE_LOCATIONS_ALL POLL
779: WHERE EXISTS

Line 864: FROM PO_DISTRIBUTIONS_ALL POD

860: , ((POD.QUANTITY_ORDERED-NVL(POD.QUANTITY_CANCELLED,0))*POLL.PRICE_OVERRIDE)
861: )
862: )
863:
864: FROM PO_DISTRIBUTIONS_ALL POD
865: WHERE POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID),0)
866: ) DAR
867: FROM PO_LINE_LOCATIONS_ALL POLL, PO_DISTRIBUTIONS_GT GT
868: WHERE GT.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID

Line 1351: PO_DISTRIBUTIONS_ALL PLD

1347: FROM
1348: PO_DISTRIBUTIONS_GT GT,
1349: PO_LINES_ALL POL,
1350: PO_LINE_LOCATIONS_ALL PLL,
1351: PO_DISTRIBUTIONS_ALL PLD
1352: WHERE GT.LINE_LOCATION_ID = PLD.LINE_LOCATION_ID AND
1353: PLD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1354: PLL.PO_LINE_ID = POL.PO_LINE_ID AND
1355: PLD.DISTRIBUTION_NUM = GT.DISTRIBUTION_NUM;

Line 1670: -- PO_DISTRIBUTIONS_ALL OR PO_DISTRIBUTIONS_DRAFT_ALL.

1666: --NAME: DEFAULT_ACRN_VALUES
1667: --PRE-REQS:
1668: -- NONE.
1669: --MODIFIES:
1670: -- PO_DISTRIBUTIONS_ALL OR PO_DISTRIBUTIONS_DRAFT_ALL.
1671: --LOCKS:
1672: -- NONE.
1673: --FUNCTION:
1674: -- THIS PROCEDURE CALLS THE API PO_ACCOUNT_HELPER.BUILD_ACRN TO POPULATE

Line 1752: UPDATE PO_DISTRIBUTIONS_ALL

1748: END LOOP;
1749: ELSE
1750: FOR J IN 1..L_DIST_ID_TBL.COUNT
1751: LOOP
1752: UPDATE PO_DISTRIBUTIONS_ALL
1753: SET ACRN = L_ACRN_TBL(J)
1754: WHERE PO_DISTRIBUTION_ID = L_DIST_ID_TBL(J)
1755: AND L_ACRN_TBL(J) <> 'N/A';
1756:

Line 1782: -- PO_DISTRIBUTIONS_ALL OR PO_DISTRIBUTIONS_DRAFT_ALL BASED ON THE DRAFT ID.

1778: --LOCKS:
1779: -- NONE.
1780: --FUNCTION:
1781: -- IT WILL MERGER(MOVE) THE NEWLY CREATED DISTRIBUTIONS INTO
1782: -- PO_DISTRIBUTIONS_ALL OR PO_DISTRIBUTIONS_DRAFT_ALL BASED ON THE DRAFT ID.
1783: -- THEN UPDATES THE VALUES BY CALLING METHODS, DEFAULT_ACRN_VALUES,
1784: -- UPDATE_AWARD_DISTRIBUTIONS, CALIBRATE_LAST_DIST_AMOUNT, CALIBRATE_LAST_DIST_QUANTITY AND CALCULATE_LOCAL
1785: -- AND DEFAULTS ACRN VALUES.
1786: --PARAMETERS:

Line 2129: DEBUG(D_MODULE, D_POSITION, 'INSERTING INTO PO_DISTRIBUTIONS_ALL');

2125:
2126: ELSE
2127:
2128: D_POSITION := 110;
2129: DEBUG(D_MODULE, D_POSITION, 'INSERTING INTO PO_DISTRIBUTIONS_ALL');
2130:
2131: INSERT INTO PO_DISTRIBUTIONS_ALL (
2132: PO_DISTRIBUTION_ID ,
2133: LAST_UPDATE_DATE ,

Line 2131: INSERT INTO PO_DISTRIBUTIONS_ALL (

2127:
2128: D_POSITION := 110;
2129: DEBUG(D_MODULE, D_POSITION, 'INSERTING INTO PO_DISTRIBUTIONS_ALL');
2130:
2131: INSERT INTO PO_DISTRIBUTIONS_ALL (
2132: PO_DISTRIBUTION_ID ,
2133: LAST_UPDATE_DATE ,
2134: LAST_UPDATED_BY ,
2135: PO_HEADER_ID ,

Line 2690: -- PO_DISTRIBUTIONS_ALL OR PO_DISTRIBUTIONS_DRAFT_ALL BASED ON THE DRAFT ID. THEN UPDATES THE

2686: -- IT VALIDATES THE NEW DISTRIBUTIONS FOR CALCULATED VALUES, QUANTITY,
2687: -- DISTRIBUTION AMOUNT, FUNDED VALUE,
2688: -- WITH THE SPECIFIC SOURCE REQUISITION IT WAS CREATED. ON SUCCESSFULL VALIDATION IT WILL
2689: -- MERGER(MOVE) THE NEWLY CREATED DISTRIBUTIONS INTO
2690: -- PO_DISTRIBUTIONS_ALL OR PO_DISTRIBUTIONS_DRAFT_ALL BASED ON THE DRAFT ID. THEN UPDATES THE
2691: -- VALUES, LIKE AWARD, CALIBRATE QUANTITY/AMOUNT, CALCULATE LOCAL
2692: -- AND DEFAULTS ACRN VALUES.
2693: --PARAMETERS:
2694: --IN: