[Home] [Help]
105: -- None.
106: --Modifies:
107: -- Creates funds check entries in the gl_bc_packets table
108: -- Adds distribution-specific transaction information into the
109: -- po_online_report_text table
110: --Locks:
111: -- None.
112: --Function:
113: -- This procedure performs a funds check on a document or doc level of a
147: --x_po_return_code
148: -- Indicates whether PO is classifying this transaction as an
149: -- Error/Warning/Partial Success/Success
150: --x_online_report_id
151: -- Unique id into po_online_report_text rows that store distribution specific
152: -- reporting information for a specific encumbrance transaction
153: --Testing:
154: --
155: --End of Comments
304: -- None.
305: --Modifies:
306: -- Creates funds check entries in the gl_bc_packets table
307: -- Adds distribution-specific transaction information into the
308: -- po_online_report_text table
309: --Locks:
310: -- None.
311: --Function:
312: -- This procedure performs a funds check on a document or doc level of a
339: --x_po_return_code
340: -- Indicates whether PO is classifying this transaction as an
341: -- Error/Warning/Partial Success/Success
342: --x_online_report_id
343: -- Unique id into po_online_report_text rows that store distribution specific
344: -- reporting information for a specific encumbrance transaction
345: --Testing:
346: --
347: --End of Comments
461: -- None.
462: --Modifies:
463: -- Creates encumbrance entries in the gl_bc_packets table
464: -- Adds distribution-specific transaction information into the
465: -- po_online_report_text table
466: --Locks:
467: -- None.
468: --Function:
469: -- This procedure performs funds reservation on all eligible
511: --x_po_return_code
512: -- Indicates whether PO is classifying this transaction as an
513: -- Error/Warning/Partial Success/Success
514: --x_online_report_id
515: -- Unique id into po_online_report_text rows that store distribution specific
516: -- reporting information for a specific encumbrance transaction
517: --Testing:
518: --
519: --End of Comments
638: -- None.
639: --Modifies:
640: -- Creates encumbrance entries in the gl_bc_packets table
641: -- Adds distribution-specific transaction information into the
642: -- po_online_report_text table
643: --Locks:
644: -- None.
645: --Function:
646: -- This procedure unreserves the encumbrance on all eligible distributions of
688: --x_po_return_code
689: -- Indicates whether PO is classifying this transaction as an
690: -- Error/Warning/Partial Success/Success
691: --x_online_report_id
692: -- Unique id into po_online_report_text rows that store distribution specific
693: -- reporting information for a specific encumbrance transaction
694: --Testing:
695: --
696: --End of Comments
818: -- None.
819: --Modifies:
820: -- Creates encumbrance entries in the gl_bc_packets table
821: -- Adds distribution-specific transaction information into the
822: -- po_online_report_text table
823: --Locks:
824: -- None.
825: --Function:
826: -- This procedure unreserves encumbrance on a Requisition that has been
859: --x_po_return_code
860: -- Indicates whether PO is classifying this transaction as an
861: -- Error/Warning/Partial Success/Success
862: --x_online_report_id
863: -- Unique id into po_online_report_text rows that store distribution specific
864: -- reporting information for a specific encumbrance transaction
865: --Testing:
866: --
867: --End of Comments
984: -- None.
985: --Modifies:
986: -- Creates encumbrance entries in the gl_bc_packets table
987: -- Adds distribution-specific transaction information into the
988: -- po_online_report_text table
989: --Locks:
990: -- None.
991: --Function:
992: -- This procedure unreserves encumbrance from unapproved shipments on
1028: --x_po_return_code
1029: -- Indicates whether PO is classifying this transaction as an
1030: -- Error/Warning/Partial Success/Success
1031: --x_online_report_id
1032: -- Unique id into po_online_report_text rows that store distribution specific
1033: -- reporting information for a specific encumbrance transaction
1034: --Testing:
1035: --
1036: --End of Comments
1158: -- (and hence re-encumber) Demand is requested.
1159: --Modifies:
1160: -- Creates encumbrance entries in the gl_bc_packets table
1161: -- Adds distribution-specific transaction information into the
1162: -- po_online_report_text table
1163: --Locks:
1164: -- None.
1165: --Function:
1166: -- This procedure cancels the encumbrance on all eligible distributions of
1202: --x_po_return_code
1203: -- Indicates whether PO is classifying this transaction as an
1204: -- Error/Warning/Partial Success/Success
1205: --x_online_report_id
1206: -- Unique id into po_online_report_text rows that store distribution specific
1207: -- reporting information for a specific encumbrance transaction
1208: --Testing:
1209: --
1210: --End of Comments
1329: -- N/A.
1330: --Modifies:
1331: -- Creates encumbrance entries in the gl_bc_packets table
1332: -- Adds distribution-specific transaction information into the
1333: -- po_online_report_text table
1334: --Locks:
1335: -- None.
1336: --Function:
1337: -- This procedure cancels the encumbrance on all eligible distributions of
1370: --x_po_return_code
1371: -- Indicates whether PO is classifying this transaction as an
1372: -- Error/Warning/Partial Success/Success
1373: --x_online_report_id
1374: -- Unique id into po_online_report_text rows that store distribution specific
1375: -- reporting information for a specific encumbrance transaction
1376: --Testing:
1377: --
1378: --End of Comments
1497: -- None.
1498: --Modifies:
1499: -- Creates encumbrance entries in the gl_bc_packets table.
1500: -- Adds distribution-specific transaction information into the
1501: -- po_online_report_text table.
1502: -- Adds entries to the action history.
1503: -- Manipulates PO_ENCUMBRANCE_GT.
1504: -- Updates the base document tables with encumbrance results.
1505: --Function:
1542: -- PARTIAL
1543: -- FAILURE
1544: -- FATAL
1545: --x_online_report_id
1546: -- Unique id into po_online_report_text rows that store distribution specific
1547: -- reporting information for a specific encumbrance transaction.
1548: --Testing:
1549: --
1550: --End of Comments
1726: -- N/A.
1727: --Modifies:
1728: -- Creates encumbrance entries in the gl_bc_packets table
1729: -- Adds distribution-specific transaction information into the
1730: -- po_online_report_text table
1731: --Locks:
1732: -- None.
1733: --Function:
1734: -- This procedure liquidates the encumbrance on all eligible distributions of
1770: --x_po_return_code
1771: -- Indicates whether PO is classifying this transaction as an
1772: -- Error/Warning/Partial Success/Success
1773: --x_online_report_id
1774: -- Unique id into po_online_report_text rows that store distribution specific
1775: -- reporting information for a specific encumbrance transaction
1776: --Testing:
1777: --
1778: --End of Comments
1903: -- n/a
1904: --Modifies:
1905: -- Creates encumbrance entries in the gl_bc_packets table
1906: -- Adds distribution-specific transaction information into the
1907: -- po_online_report_text table
1908: --Function:
1909: -- This procedure performs funds reservation on all eligible
1910: -- distributions of a finally closed PO Shipment which was
1911: -- finally closed due to AP finally invoice match, now AP cancels
1949: --x_po_return_code
1950: -- Indicates whether Requisition is classifying this transaction as an
1951: -- Error/Warning/Partial Success/Success
1952: --x_online_report_id
1953: -- Unique id into po_online_report_text rows that store distribution specific
1954: -- reporting information for a specific encumbrance transaction
1955: --Testing:
1956: --
1957: --End of Comments
2085: -- None.
2086: --Modifies:
2087: -- Creates encumbrance entries in the gl_bc_packets table
2088: -- Adds distribution-specific transaction information into the
2089: -- po_online_report_text table
2090: --Locks:
2091: -- None.
2092: --Function:
2093: -- This procedure performs funds reservation on all eligible
2123: --x_po_return_code
2124: -- Indicates whether PO is classifying this transaction as an
2125: -- Error/Warning/Partial Success/Success
2126: --x_online_report_id
2127: -- Unique id into po_online_report_text rows that store distribution specific
2128: -- reporting information for a specific encumbrance transaction
2129: --Testing:
2130: --
2131: --End of Comments
2246: -- None.
2247: --Modifies:
2248: -- Creates encumbrance entries in the gl_bc_packets table
2249: -- Adds distribution-specific transaction information into the
2250: -- po_online_report_text table
2251: --Locks:
2252: -- None.
2253: --Function:
2254: -- This procedure unreserves the encumbrance on all eligible distributions of
2289: --x_po_return_code
2290: -- Indicates whether PO is classifying this transaction as an
2291: -- Error/Warning/Partial Success/Success
2292: --x_online_report_id
2293: -- Unique id into po_online_report_text rows that store distribution specific
2294: -- reporting information for a specific encumbrance transaction
2295: --Testing:
2296: --
2297: --End of Comments
2501: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2502: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2503: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
2504: l_po_return_code VARCHAR2(10);
2505: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
2506:
2507: l_amt_based_line_flag VARCHAR2(1); -- Bug 3480949
2508:
2509: BEGIN
3020: --Pre-reqs:
3021: -- org context is set
3022: --Modifies:
3023: -- GL_BC_PACKETS
3024: -- PO_ONLINE_REPORT_TEXT
3025: -- PO_ENC_DISTRIBUTIONS_GT
3026: --Locks:
3027: -- None.
3028: --Function:
3028: --Function:
3029: -- This procedure performs funds action on all eligible distributions of
3030: -- a document. Creates encumbrance entries in the gl_bc_packets table.
3031: -- Adds distribution-specific transaction information into the
3032: -- po_online_report_text table.
3033: --Parameters:
3034: --IN:
3035: --p_action
3036: -- The encumbrance action being performed.
3084: --x_po_return_code
3085: -- Indicates whether PO is classifying this transaction as an
3086: -- Error/Warning/Partial Success/Success
3087: --x_online_report_id
3088: -- Unique id into po_online_report_text rows that store distribution specific
3089: -- reporting information for a specific encumbrance transaction
3090: --Testing:
3091: --
3092: --End of Comments
4140: --Parameters:
4141: --IN:
4142: --p_online_report_id
4143: -- Unique identifier that points to a set of rows in the
4144: -- PO_ONLINE_REPORT_TEXT table. These rows store the detailed results
4145: -- for a particular encumbrance transaction
4146: --p_report_successes
4147: -- Indicates whether to include information about Successful rows.
4148: -- Warning and Error rows are always included.
4212: , x_report_object.distribution_num
4213: , x_report_object.result_code
4214: , x_report_object.msg_type
4215: , x_report_object.error_msg
4216: FROM PO_ONLINE_REPORT_TEXT REPORT
4217: WHERE REPORT.online_report_id = p_online_report_id
4218: AND ((l_report_successes = g_parameter_NO
4219: AND Nvl(REPORT.message_type,g_result_ERROR) <> g_result_SUCCESS)
4220: OR l_report_successes = g_parameter_YES
5354: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5356: END IF;
5357: --
5358: --If events haven't been populated we needto look into po_online_report_text
5359: -- to figure out if any of the rows in it are marked as show in psa.
5360: --This would indicate that there are rows in the report and we
5361: --would have to launch the OA page from the UI.
5362: IF(l_events_populated ='N')
5366: into l_events_populated
5367: from dual
5368: where exists(
5369: select 1
5370: from po_online_report_text
5371: where online_report_id=PO_DOCUMENT_FUNDS_PVT.g_ONLINE_REPORT_ID
5372: and show_in_psa_flag='Y'
5373: );
5374: