APPS.PO_LINK_REQ_DIST_PVT dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

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 1675: -- THE ACRN VALUES IN THE PO_DISTRIBUTIONS_DRAFT_ALL..

1671: --LOCKS:
1672: -- NONE.
1673: --FUNCTION:
1674: -- THIS PROCEDURE CALLS THE API PO_ACCOUNT_HELPER.BUILD_ACRN TO POPULATE
1675: -- THE ACRN VALUES IN THE PO_DISTRIBUTIONS_DRAFT_ALL..
1676: --PARAMETERS:
1677: --IN:
1678: -- HEADER ID
1679: -- DRAFT ID

Line 1743: UPDATE PO_DISTRIBUTIONS_DRAFT_ALL

1739:
1740: IF (L_DRAFT_ID <> -1 ) THEN
1741: FOR J IN 1..L_DIST_ID_TBL.COUNT
1742: LOOP
1743: UPDATE PO_DISTRIBUTIONS_DRAFT_ALL
1744: SET ACRN = L_ACRN_TBL(J)
1745: WHERE PO_DISTRIBUTION_ID = L_DIST_ID_TBL(J)
1746: AND L_ACRN_TBL(J) <> 'N/A';
1747:

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 1885: DEBUG(D_MODULE, D_POSITION, 'INSERTING INTO PO_DISTRIBUTIONS_DRAFT_ALL');

1881:
1882: IF (L_DRAFT_ID <> -1 ) THEN
1883:
1884: D_POSITION := 80;
1885: DEBUG(D_MODULE, D_POSITION, 'INSERTING INTO PO_DISTRIBUTIONS_DRAFT_ALL');
1886:
1887: INSERT INTO PO_DISTRIBUTIONS_DRAFT_ALL --
1888: (PO_DISTRIBUTION_ID,
1889: DRAFT_ID,

Line 1887: INSERT INTO PO_DISTRIBUTIONS_DRAFT_ALL --

1883:
1884: D_POSITION := 80;
1885: DEBUG(D_MODULE, D_POSITION, 'INSERTING INTO PO_DISTRIBUTIONS_DRAFT_ALL');
1886:
1887: INSERT INTO PO_DISTRIBUTIONS_DRAFT_ALL --
1888: (PO_DISTRIBUTION_ID,
1889: DRAFT_ID,
1890: --WHO COLUMNS
1891: ---------------------------------------------------------------

Line 2077: --INSERT INTO PO_DISTRIBUTIONS_DRAFT_ALL SELECT * FROM PO_DISTRIBUTIONS_GT;

2073: PAR_DRAFT_ID, -- FOR LINKING PAR
2074: PAR_DISTRIBUTION_ID -- FOR LINKING PAR DISTRIBUTION
2075: FROM PO_DISTRIBUTIONS_GT;
2076:
2077: --INSERT INTO PO_DISTRIBUTIONS_DRAFT_ALL SELECT * FROM PO_DISTRIBUTIONS_GT;
2078:
2079: PO_AUTOCREATE_PARAMS.G_DRAFT_ID := L_DRAFT_ID;
2080:
2081: D_POSITION := 90;

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: