[Home] [Help]
103: -- None.
104: --Modifies:
105: -- Creates funds check entries in the gl_bc_packets table
106: -- Adds distribution-specific transaction information into the
107: -- po_online_report_text table
108: --Locks:
109: -- None.
110: --Function:
111: -- This procedure performs a funds check on a document or doc level of a
142: --x_po_return_code
143: -- Indicates whether PO is classifying this transaction as an
144: -- Error/Warning/Partial Success/Success
145: --x_online_report_id
146: -- Unique id into po_online_report_text rows that store distribution specific
147: -- reporting information for a specific encumbrance transaction
148: --Testing:
149: --
150: --End of Comments
264: -- None.
265: --Modifies:
266: -- Creates funds check entries in the gl_bc_packets table
267: -- Adds distribution-specific transaction information into the
268: -- po_online_report_text table
269: --Locks:
270: -- None.
271: --Function:
272: -- This procedure performs a funds check on a document or doc level of a
299: --x_po_return_code
300: -- Indicates whether PO is classifying this transaction as an
301: -- Error/Warning/Partial Success/Success
302: --x_online_report_id
303: -- Unique id into po_online_report_text rows that store distribution specific
304: -- reporting information for a specific encumbrance transaction
305: --Testing:
306: --
307: --End of Comments
421: -- None.
422: --Modifies:
423: -- Creates encumbrance entries in the gl_bc_packets table
424: -- Adds distribution-specific transaction information into the
425: -- po_online_report_text table
426: --Locks:
427: -- None.
428: --Function:
429: -- This procedure performs funds reservation on all eligible
471: --x_po_return_code
472: -- Indicates whether PO is classifying this transaction as an
473: -- Error/Warning/Partial Success/Success
474: --x_online_report_id
475: -- Unique id into po_online_report_text rows that store distribution specific
476: -- reporting information for a specific encumbrance transaction
477: --Testing:
478: --
479: --End of Comments
598: -- None.
599: --Modifies:
600: -- Creates encumbrance entries in the gl_bc_packets table
601: -- Adds distribution-specific transaction information into the
602: -- po_online_report_text table
603: --Locks:
604: -- None.
605: --Function:
606: -- This procedure unreserves the encumbrance on all eligible distributions of
648: --x_po_return_code
649: -- Indicates whether PO is classifying this transaction as an
650: -- Error/Warning/Partial Success/Success
651: --x_online_report_id
652: -- Unique id into po_online_report_text rows that store distribution specific
653: -- reporting information for a specific encumbrance transaction
654: --Testing:
655: --
656: --End of Comments
778: -- None.
779: --Modifies:
780: -- Creates encumbrance entries in the gl_bc_packets table
781: -- Adds distribution-specific transaction information into the
782: -- po_online_report_text table
783: --Locks:
784: -- None.
785: --Function:
786: -- This procedure unreserves encumbrance on a Requisition that has been
819: --x_po_return_code
820: -- Indicates whether PO is classifying this transaction as an
821: -- Error/Warning/Partial Success/Success
822: --x_online_report_id
823: -- Unique id into po_online_report_text rows that store distribution specific
824: -- reporting information for a specific encumbrance transaction
825: --Testing:
826: --
827: --End of Comments
944: -- None.
945: --Modifies:
946: -- Creates encumbrance entries in the gl_bc_packets table
947: -- Adds distribution-specific transaction information into the
948: -- po_online_report_text table
949: --Locks:
950: -- None.
951: --Function:
952: -- This procedure unreserves encumbrance from unapproved shipments on
988: --x_po_return_code
989: -- Indicates whether PO is classifying this transaction as an
990: -- Error/Warning/Partial Success/Success
991: --x_online_report_id
992: -- Unique id into po_online_report_text rows that store distribution specific
993: -- reporting information for a specific encumbrance transaction
994: --Testing:
995: --
996: --End of Comments
1118: -- (and hence re-encumber) Demand is requested.
1119: --Modifies:
1120: -- Creates encumbrance entries in the gl_bc_packets table
1121: -- Adds distribution-specific transaction information into the
1122: -- po_online_report_text table
1123: --Locks:
1124: -- None.
1125: --Function:
1126: -- This procedure cancels the encumbrance on all eligible distributions of
1162: --x_po_return_code
1163: -- Indicates whether PO is classifying this transaction as an
1164: -- Error/Warning/Partial Success/Success
1165: --x_online_report_id
1166: -- Unique id into po_online_report_text rows that store distribution specific
1167: -- reporting information for a specific encumbrance transaction
1168: --Testing:
1169: --
1170: --End of Comments
1289: -- N/A.
1290: --Modifies:
1291: -- Creates encumbrance entries in the gl_bc_packets table
1292: -- Adds distribution-specific transaction information into the
1293: -- po_online_report_text table
1294: --Locks:
1295: -- None.
1296: --Function:
1297: -- This procedure cancels the encumbrance on all eligible distributions of
1330: --x_po_return_code
1331: -- Indicates whether PO is classifying this transaction as an
1332: -- Error/Warning/Partial Success/Success
1333: --x_online_report_id
1334: -- Unique id into po_online_report_text rows that store distribution specific
1335: -- reporting information for a specific encumbrance transaction
1336: --Testing:
1337: --
1338: --End of Comments
1457: -- None.
1458: --Modifies:
1459: -- Creates encumbrance entries in the gl_bc_packets table.
1460: -- Adds distribution-specific transaction information into the
1461: -- po_online_report_text table.
1462: -- Adds entries to the action history.
1463: -- Manipulates PO_ENCUMBRANCE_GT.
1464: -- Updates the base document tables with encumbrance results.
1465: --Function:
1502: -- PARTIAL
1503: -- FAILURE
1504: -- FATAL
1505: --x_online_report_id
1506: -- Unique id into po_online_report_text rows that store distribution specific
1507: -- reporting information for a specific encumbrance transaction.
1508: --Testing:
1509: --
1510: --End of Comments
1686: -- N/A.
1687: --Modifies:
1688: -- Creates encumbrance entries in the gl_bc_packets table
1689: -- Adds distribution-specific transaction information into the
1690: -- po_online_report_text table
1691: --Locks:
1692: -- None.
1693: --Function:
1694: -- This procedure liquidates the encumbrance on all eligible distributions of
1730: --x_po_return_code
1731: -- Indicates whether PO is classifying this transaction as an
1732: -- Error/Warning/Partial Success/Success
1733: --x_online_report_id
1734: -- Unique id into po_online_report_text rows that store distribution specific
1735: -- reporting information for a specific encumbrance transaction
1736: --Testing:
1737: --
1738: --End of Comments
1863: -- n/a
1864: --Modifies:
1865: -- Creates encumbrance entries in the gl_bc_packets table
1866: -- Adds distribution-specific transaction information into the
1867: -- po_online_report_text table
1868: --Function:
1869: -- This procedure performs funds reservation on all eligible
1870: -- distributions of a finally closed PO Shipment which was
1871: -- finally closed due to AP finally invoice match, now AP cancels
1909: --x_po_return_code
1910: -- Indicates whether Requisition is classifying this transaction as an
1911: -- Error/Warning/Partial Success/Success
1912: --x_online_report_id
1913: -- Unique id into po_online_report_text rows that store distribution specific
1914: -- reporting information for a specific encumbrance transaction
1915: --Testing:
1916: --
1917: --End of Comments
2045: -- None.
2046: --Modifies:
2047: -- Creates encumbrance entries in the gl_bc_packets table
2048: -- Adds distribution-specific transaction information into the
2049: -- po_online_report_text table
2050: --Locks:
2051: -- None.
2052: --Function:
2053: -- This procedure performs funds reservation on all eligible
2083: --x_po_return_code
2084: -- Indicates whether PO is classifying this transaction as an
2085: -- Error/Warning/Partial Success/Success
2086: --x_online_report_id
2087: -- Unique id into po_online_report_text rows that store distribution specific
2088: -- reporting information for a specific encumbrance transaction
2089: --Testing:
2090: --
2091: --End of Comments
2206: -- None.
2207: --Modifies:
2208: -- Creates encumbrance entries in the gl_bc_packets table
2209: -- Adds distribution-specific transaction information into the
2210: -- po_online_report_text table
2211: --Locks:
2212: -- None.
2213: --Function:
2214: -- This procedure unreserves the encumbrance on all eligible distributions of
2249: --x_po_return_code
2250: -- Indicates whether PO is classifying this transaction as an
2251: -- Error/Warning/Partial Success/Success
2252: --x_online_report_id
2253: -- Unique id into po_online_report_text rows that store distribution specific
2254: -- reporting information for a specific encumbrance transaction
2255: --Testing:
2256: --
2257: --End of Comments
2461: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2462: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2463: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
2464: l_po_return_code VARCHAR2(10);
2465: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
2466:
2467: l_amt_based_line_flag VARCHAR2(1); -- Bug 3480949
2468:
2469: BEGIN
2980: --Pre-reqs:
2981: -- org context is set
2982: --Modifies:
2983: -- GL_BC_PACKETS
2984: -- PO_ONLINE_REPORT_TEXT
2985: -- PO_ENC_DISTRIBUTIONS_GT
2986: --Locks:
2987: -- None.
2988: --Function:
2988: --Function:
2989: -- This procedure performs funds action on all eligible distributions of
2990: -- a document. Creates encumbrance entries in the gl_bc_packets table.
2991: -- Adds distribution-specific transaction information into the
2992: -- po_online_report_text table.
2993: --Parameters:
2994: --IN:
2995: --p_action
2996: -- The encumbrance action being performed.
3044: --x_po_return_code
3045: -- Indicates whether PO is classifying this transaction as an
3046: -- Error/Warning/Partial Success/Success
3047: --x_online_report_id
3048: -- Unique id into po_online_report_text rows that store distribution specific
3049: -- reporting information for a specific encumbrance transaction
3050: --Testing:
3051: --
3052: --End of Comments
3940: --Parameters:
3941: --IN:
3942: --p_online_report_id
3943: -- Unique identifier that points to a set of rows in the
3944: -- PO_ONLINE_REPORT_TEXT table. These rows store the detailed results
3945: -- for a particular encumbrance transaction
3946: --p_report_successes
3947: -- Indicates whether to include information about Successful rows.
3948: -- Warning and Error rows are always included.
4012: , x_report_object.distribution_num
4013: , x_report_object.result_code
4014: , x_report_object.msg_type
4015: , x_report_object.error_msg
4016: FROM PO_ONLINE_REPORT_TEXT REPORT
4017: WHERE REPORT.online_report_id = p_online_report_id
4018: AND ((l_report_successes = g_parameter_NO
4019: AND REPORT.message_type <> g_result_SUCCESS)
4020: OR l_report_successes = g_parameter_YES
5107: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5109: END IF;
5110: --
5111: --If events haven't been populated we needto look into po_online_report_text
5112: -- to figure out if any of the rows in it are marked as show in psa.
5113: --This would indicate that there are rows in the report and we
5114: --would have to launch the OA page from the UI.
5115: IF(l_events_populated ='N')
5119: into l_events_populated
5120: from dual
5121: where exists(
5122: select 1
5123: from po_online_report_text
5124: where online_report_id=PO_DOCUMENT_FUNDS_PVT.g_ONLINE_REPORT_ID
5125: and show_in_psa_flag='Y'
5126: );
5127: