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_DOCUMENT_FUNDS_PVT dependencies on STANDARD

Line 124: -- PO: STANDARD, PLANNED

120: -- and the join conditions
121: --p_doc_subtype
122: -- Differentiates between the subtypes of documents
123: -- REQ: NULL
124: -- PO: STANDARD, PLANNED
125: -- PA: CONTRACT, BLANKET
126: -- RELEASE: SCHEDULED, BLANKET
127: --p_doc_level
128: -- Specifies the level of the document that is being checked:

Line 192: -- Standard Start of API savepoint

188: END IF;
189:
190: l_progress := '010';
191:
192: -- Standard Start of API savepoint
193: SAVEPOINT CHECK_RESERVE_SP;
194:
195: l_progress := '020';
196:

Line 210: If (p_doc_type = g_doc_type_PO AND p_doc_subtype = g_doc_subtype_STANDARD) THEN

206: 'Calling Populate_Enc_Gt_With_Draft for Modification');
207: END IF;
208:
209: -- Encumbrance is Not Supported for BPAs in CLM
210: If (p_doc_type = g_doc_type_PO AND p_doc_subtype = g_doc_subtype_STANDARD) THEN
211: Populate_Enc_Gt_With_Draft(x_return_status => x_return_status,
212: p_draft_id => p_draft_id);
213: End If;
214:

Line 288: -- Rollback as per API standards.

284: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
285: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
286: END IF;
287:
288: -- Rollback as per API standards.
289: ROLLBACK TO CHECK_RESERVE_SP;
290:
291: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
292:

Line 323: -- PO: STANDARD, PLANNED

319: -- and the join conditions
320: --p_doc_subtype
321: -- Differentiates between the subtypes of documents
322: -- REQ: NULL
323: -- PO: STANDARD, PLANNED
324: -- PA: CONTRACT, BLANKET
325: -- RELEASE: SCHEDULED, BLANKET
326: --p_override_funds
327: -- Indicates whether funds override capability can be used if needed, to make a

Line 379: -- Standard Start of API savepoint

375: END IF;
376:
377: l_progress := '010';
378:
379: -- Standard Start of API savepoint
380: SAVEPOINT CHECK_ADJUST_SP;
381:
382: l_progress := '020';
383:

Line 443: -- Rollback as per API standards.

439: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
440: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
441: END IF;
442:
443: -- Rollback as per API standards.
444: ROLLBACK TO CHECK_ADJUST_SP;
445:
446: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
447:

Line 480: -- PO: STANDARD, PLANNED

476: -- and the join conditions
477: --p_doc_subtype
478: -- Differentiates between the subtypes of documents
479: -- REQ: NULL
480: -- PO: STANDARD, PLANNED
481: -- PA: CONTRACT, BLANKET
482: -- RELEASE: SCHEDULED, BLANKET
483: --p_doc_level
484: -- Specifies the level of the document that is being checked:

Line 557: -- Standard Start of API savepoint

553: END IF;
554:
555: l_progress := '010';
556:
557: -- Standard Start of API savepoint
558: SAVEPOINT DO_RESERVE_SP;
559:
560: l_progress := '020';
561:

Line 621: -- Rollback as per API standards.

617: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
618: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
619: END IF;
620:
621: -- Rollback as per API standards.
622: ROLLBACK TO DO_RESERVE_SP;
623:
624: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
625:

Line 657: -- PO: STANDARD, PLANNED

653: -- and the join conditions
654: --p_doc_subtype
655: -- Differentiates between the subtypes of documents
656: -- REQ: NULL
657: -- PO: STANDARD, PLANNED
658: -- PA: CONTRACT, BLANKET
659: -- RELEASE: SCHEDULED, BLANKET
660: --p_doc_level
661: -- Specifies the level of the document that is being checked:

Line 738: -- Standard Start of API savepoint

734: END IF;
735:
736: l_progress := '010';
737:
738: -- Standard Start of API savepoint
739: SAVEPOINT DO_UNRESERVE_SP;
740:
741: l_progress := '020';
742:

Line 802: -- Rollback as per API standards.

798: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
799: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
800: END IF;
801:
802: -- Rollback as per API standards.
803: ROLLBACK TO DO_UNRESERVE_SP;
804:
805: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
806:

Line 837: -- PO: STANDARD, PLANNED

833: -- and the join conditions
834: --p_doc_subtype
835: -- Differentiates between the subtypes of documents
836: -- REQ: NULL
837: -- PO: STANDARD, PLANNED
838: -- PA: CONTRACT, BLANKET
839: -- RELEASE: SCHEDULED, BLANKET
840: --p_doc_level
841: -- Specifies the level of the document that is being checked:

Line 903: -- Standard Start of API savepoint

899: END IF;
900:
901: l_progress := '010';
902:
903: -- Standard Start of API savepoint
904: SAVEPOINT DO_RETURN_SP;
905:
906: l_progress := '020';
907:

Line 967: -- Rollback as per API standards.

963: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
964: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
965: END IF;
966:
967: -- Rollback as per API standards.
968: ROLLBACK TO DO_RETURN_SP;
969:
970: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
971:

Line 1003: -- PO: STANDARD, PLANNED

999: -- and the join conditions
1000: --p_doc_subtype
1001: -- Differentiates between the subtypes of documents
1002: -- REQ: NULL
1003: -- PO: STANDARD, PLANNED
1004: -- PA: CONTRACT, BLANKET
1005: -- RELEASE: SCHEDULED, BLANKET
1006: --p_doc_level
1007: -- Specifies the level of the document that is being checked:

Line 1074: -- Standard Start of API savepoint

1070: END IF;
1071:
1072: l_progress := '010';
1073:
1074: -- Standard Start of API savepoint
1075: SAVEPOINT DO_REJECT_SP;
1076:
1077: l_progress := '020';
1078:

Line 1138: -- Rollback as per API standards.

1134: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
1135: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
1136: END IF;
1137:
1138: -- Rollback as per API standards.
1139: ROLLBACK TO DO_REJECT_SP;
1140:
1141: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
1142:

Line 1177: -- PO: STANDARD, PLANNED

1173: -- and the join conditions
1174: --p_doc_subtype
1175: -- Differentiates between the subtypes of documents
1176: -- REQ: NULL
1177: -- PO: STANDARD, PLANNED
1178: -- PA: CONTRACT, BLANKET
1179: -- RELEASE: SCHEDULED, BLANKET
1180: --p_doc_level
1181: -- Specifies the level of the document that is being checked:

Line 1248: -- Standard Start of API savepoint

1244: END IF;
1245:
1246: l_progress := '010';
1247:
1248: -- Standard Start of API savepoint
1249: SAVEPOINT DO_CANCEL_SP;
1250:
1251: l_progress := '020';
1252:

Line 1312: -- Rollback as per API standards.

1308: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
1309: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
1310: END IF;
1311:
1312: -- Rollback as per API standards.
1313: ROLLBACK TO DO_CANCEL_SP;
1314:
1315: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
1316:

Line 1348: -- PO: STANDARD, PLANNED

1344: -- and the join conditions
1345: --p_doc_subtype
1346: -- Differentiates between the subtypes of documents
1347: -- REQ: NULL
1348: -- PO: STANDARD, PLANNED
1349: -- PA: CONTRACT, BLANKET
1350: -- RELEASE: SCHEDULED, BLANKET
1351: --p_use_gl_date
1352: -- Flag that specifies whether to always prefer using the existing distribution

Line 1416: -- Standard Start of API savepoint

1412: END IF;
1413:
1414: l_progress := '010';
1415:
1416: -- Standard Start of API savepoint
1417: SAVEPOINT DO_ADJUST_SP;
1418:
1419: l_progress := '020';
1420:

Line 1480: -- Rollback as per API standards.

1476: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
1477: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
1478: END IF;
1479:
1480: -- Rollback as per API standards.
1481: ROLLBACK TO DO_ADJUST_SP;
1482:
1483: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
1484:

Line 1581: -- Standard Start of API savepoint

1577: END IF;
1578:
1579: l_progress := '010';
1580:
1581: -- Standard Start of API savepoint
1582: SAVEPOINT DO_REQ_SPLIT_SP;
1583: x_po_return_code := NULL;
1584: x_online_report_id := NULL;
1585:

Line 1709: -- Rollback as per API standards.

1705: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
1706: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
1707: END IF;
1708:
1709: -- Rollback as per API standards.
1710: ROLLBACK TO DO_REQ_SPLIT_SP;
1711:
1712: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
1713:

Line 1745: -- PO: STANDARD, PLANNED

1741: -- and the join conditions
1742: --p_doc_subtype
1743: -- Differentiates between the subtypes of documents
1744: -- REQ: NULL
1745: -- PO: STANDARD, PLANNED
1746: -- PA: CONTRACT, BLANKET
1747: -- RELEASE: SCHEDULED, BLANKET
1748: --p_doc_level
1749: -- Specifies the level of the document that is being checked:

Line 1816: -- Standard Start of API savepoint

1812: END IF;
1813:
1814: l_progress := '010';
1815:
1816: -- Standard Start of API savepoint
1817: SAVEPOINT DO_FINAL_CLOSE_SP;
1818:
1819: l_progress := '020';
1820:

Line 1886: -- Rollback as per API standards.

1882: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
1883: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
1884: END IF;
1885:
1886: -- Rollback as per API standards.
1887: ROLLBACK TO DO_FINAL_CLOSE_SP;
1888:
1889: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
1890:

Line 1922: -- PO: STANDARD, PLANNED

1918: -- and the join conditions
1919: --p_doc_subtype
1920: -- Differentiates between the subtypes of documents
1921: -- REQ: NULL
1922: -- PO: STANDARD, PLANNED
1923: -- PA: CONTRACT, BLANKET
1924: -- RELEASE: SCHEDULED, BLANKET
1925: --p_doc_level
1926: -- Specifies the level of the document that is being checked:

Line 1948: -- APPS Standard parameter

1944: -- The id of the invoice that is being cancelled to cause the undo of the
1945: -- final match.
1946: --OUT:
1947: --x_return_status
1948: -- APPS Standard parameter
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

Line 1997: -- Standard Start of API savepoint

1993: END IF;
1994:
1995: l_progress := '010';
1996:
1997: -- Standard Start of API savepoint
1998: SAVEPOINT UNDO_FINAL_CLOSE_SP;
1999:
2000: l_progress := '020';
2001:

Line 2068: -- Rollback as per API standards.

2064: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
2065: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
2066: END IF;
2067:
2068: -- Rollback as per API standards.
2069: ROLLBACK TO UNDO_FINAL_CLOSE_SP;
2070:
2071: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
2072:

Line 2104: -- PO: STANDARD, PLANNED

2100: -- and the join conditions
2101: --p_doc_subtype
2102: -- Differentiates between the subtypes of documents
2103: -- REQ: NULL
2104: -- PO: STANDARD, PLANNED
2105: -- PA: CONTRACT, BLANKET
2106: -- RELEASE: SCHEDULED, BLANKET
2107: --p_doc_level
2108: -- Specifies the level of the document that is being checked:

Line 2165: -- Standard Start of API savepoint

2161: END IF;
2162:
2163: l_progress := '010';
2164:
2165: -- Standard Start of API savepoint
2166: SAVEPOINT DO_CBC_YEAREND_RESERVE_SP;
2167:
2168: l_progress := '020';
2169:

Line 2229: -- Rollback as per API standards.

2225: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
2226: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
2227: END IF;
2228:
2229: -- Rollback as per API standards.
2230: ROLLBACK TO DO_CBC_YEAREND_RESERVE_SP;
2231:
2232: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
2233:

Line 2265: -- PO: STANDARD, PLANNED

2261: -- and the join conditions
2262: --p_doc_subtype
2263: -- Differentiates between the subtypes of documents
2264: -- REQ: NULL
2265: -- PO: STANDARD, PLANNED
2266: -- PA: CONTRACT, BLANKET
2267: -- RELEASE: SCHEDULED, BLANKET
2268: --p_doc_level
2269: -- Specifies the level of the document that is being checked:

Line 2335: -- Standard Start of API savepoint

2331: END IF;
2332:
2333: l_progress := '010';
2334:
2335: -- Standard Start of API savepoint
2336: SAVEPOINT DO_CBC_YEAREND_UNRESERVE_SP;
2337:
2338: l_progress := '020';
2339:

Line 2399: -- Rollback as per API standards.

2395: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
2396: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',x_online_report_id);
2397: END IF;
2398:
2399: -- Rollback as per API standards.
2400: ROLLBACK TO DO_CBC_YEAREND_UNRESERVE_SP;
2401:
2402: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
2403:

Line 2714: -- Rollback as per API standards.

2710: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_return_code',l_po_return_code);
2711: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
2712: END IF;
2713:
2714: -- Rollback as per API standards.
2715: ROLLBACK TO REINSTATE_PO_ENCUMBRANCE_SP;
2716:
2717: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
2718:

Line 2783: -- Standard Start of API savepoint

2779: END IF;
2780:
2781: l_progress := '001';
2782:
2783: -- Standard Start of API savepoint
2784: SAVEPOINT IS_AGREEMENT_ENCUMBERED_SP;
2785:
2786: l_progress := '002';
2787:

Line 2954: -- Standard Start of API savepoint

2950: l_progress VARCHAR2(3) := '000';
2951: l_agreement_encumbered_tbl po_tbl_varchar1;
2952:
2953: BEGIN
2954: -- Standard Start of API savepoint
2955: SAVEPOINT IS_AGREEMENT_ENCUMBERED_SP;
2956:
2957: l_progress := '001';
2958:

Line 3050: -- PO: STANDARD, PLANNED

3046: -- and the join conditions
3047: --p_doc_subtype
3048: -- Differentiates between the subtypes of documents
3049: -- REQ: NULL
3050: -- PO: STANDARD, PLANNED
3051: -- PA: CONTRACT, BLANKET
3052: -- RELEASE: SCHEDULED, BLANKET
3053: --p_doc_level
3054: -- Specifies the level of the document that is being checked:

Line 3632: IF l_distribution_type_tbl(indx) IN ( 'STANDARD','PLANNED', 'SCHEDULED','BLANKET', 'AGREEMENT') THEN

3628:
3629: -- Bug 9980635: Non Reoverable Tax amounts in IL tables are not in sync with the PO tables
3630: IF (p_check_only_flag <> 'Y') THEN
3631: FOR indx IN 1..l_distribution_id_tbl.Count LOOP
3632: IF l_distribution_type_tbl(indx) IN ( 'STANDARD','PLANNED', 'SCHEDULED','BLANKET', 'AGREEMENT') THEN
3633: UPDATE po_distributions_all
3634: SET nonrecoverable_tax = nvl(l_nonrecoverable_tax_tbl(indx),0)
3635: WHERE po_distribution_id = l_distribution_id_tbl(indx);
3636: ELSIF l_distribution_type_tbl(indx) IN ('REQUISITION') THEN

Line 4272: -- PO: STANDARD, PLANNED

4268: -- and the join conditions
4269: --p_doc_subtype
4270: -- Differentiates between the subtypes of documents
4271: -- REQ: NULL
4272: -- PO: STANDARD, PLANNED
4273: -- PA: CONTRACT, BLANKET
4274: -- RELEASE: SCHEDULED, BLANKET
4275: --p_doc_level
4276: -- Specifies the level of the document that is being checked:

Line 4319: -- Standard Start of API savepoint

4315: END IF;
4316:
4317: l_progress := '010';
4318:
4319: -- Standard Start of API savepoint
4320: SAVEPOINT IS_RESERVABLE_SP;
4321:
4322: l_progress := '020';
4323:

Line 4383: -- PO: STANDARD, PLANNED

4379: -- and the join conditions
4380: --p_doc_subtype
4381: -- Differentiates between the subtypes of documents
4382: -- REQ: NULL
4383: -- PO: STANDARD, PLANNED
4384: -- PA: CONTRACT, BLANKET
4385: -- RELEASE: SCHEDULED, BLANKET
4386: --p_doc_level
4387: -- Specifies the level of the document that is being checked:

Line 4430: -- Standard Start of API savepoint

4426: END IF;
4427:
4428: l_progress := '010';
4429:
4430: -- Standard Start of API savepoint
4431: SAVEPOINT IS_UNRESERVABLE_SP;
4432:
4433: l_progress := '020';
4434:

Line 4533: -- Apps standard parameter

4529: -- g_parameter_YES don't lock them
4530: --
4531: --OUT:
4532: --x_return_status
4533: -- Apps standard parameter
4534: -- VARCHAR2(1)
4535: --Testing:
4536: --
4537: --End of Comments

Line 4912: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updating the CLM Doc Flag for Standard PO Distributions.');

4908:
4909: /* <> */
4910: IF p_doc_type = g_doc_type_PO THEN
4911: IF g_debug_stmt THEN
4912: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updating the CLM Doc Flag for Standard PO Distributions.');
4913: END IF;
4914: UPDATE po_encumbrance_gt DISTS
4915: SET DISTS.CLM_DOC_FLAG = PO_PARTIAL_FUNDING_PKG.is_clm_document(g_doc_type_PO, DISTS.HEADER_ID)
4916: WHERE DISTS.distribution_type = 'STANDARD';

Line 4916: WHERE DISTS.distribution_type = 'STANDARD';

4912: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updating the CLM Doc Flag for Standard PO Distributions.');
4913: END IF;
4914: UPDATE po_encumbrance_gt DISTS
4915: SET DISTS.CLM_DOC_FLAG = PO_PARTIAL_FUNDING_PKG.is_clm_document(g_doc_type_PO, DISTS.HEADER_ID)
4916: WHERE DISTS.distribution_type = 'STANDARD';
4917:
4918: l_progress := '270';
4919: IF g_debug_stmt THEN
4920: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updated the CLM Doc Flag for Standard PO Distributions.');

Line 4920: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updated the CLM Doc Flag for Standard PO Distributions.');

4916: WHERE DISTS.distribution_type = 'STANDARD';
4917:
4918: l_progress := '270';
4919: IF g_debug_stmt THEN
4920: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updated the CLM Doc Flag for Standard PO Distributions.');
4921: END IF;
4922: END IF;
4923: /* <> */
4924: END IF; -- p_doc_type

Line 4977: -- STANDARD Standard PO

4973: -- PO
4974: -- RELEASE
4975: --p_doc_subtype
4976: -- The document subtype. Use the g_doc_subtype_<> variables:
4977: -- STANDARD Standard PO
4978: -- PLANNED Planned PO
4979: -- BLANKET Blanket Release, Blanket Agreement, Global Agreement
4980: -- SCHEDULED Scheduled Release
4981: -- This parameter is not checked for requisitions (okay to use NULL).

Line 4994: -- Apps standard parameter

4990: -- action will be taken.
4991: --OUT:
4992: --x_return_status
4993: -- VARCHAR2(1)
4994: -- Apps standard parameter
4995: --Testing:
4996: --
4997: --End of Comments
4998: -------------------------------------------------------------------------------

Line 5016: -- Standard Start of API savepoint

5012: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
5013:
5014: BEGIN
5015:
5016: -- Standard Start of API savepoint
5017: SAVEPOINT POPULATE_ENC_GT_ACTION_IDS_PVT;
5018:
5019: l_progress := '010';
5020:

Line 5127: -- the Apps API standards require is exemplified by bug 3454804.

5123: -- VARCHAR2(10)
5124: -- Will be set to g_return_FATAL.
5125: --Notes:
5126: -- The need for error handling that is more robust than
5127: -- the Apps API standards require is exemplified by bug 3454804.
5128: --Testing:
5129: --
5130: --End of Comments
5131: -------------------------------------------------------------------------------