58: -- Sets the initial attributes required for the Document Signature Process.
59: --Parameters:
60: --IN:
61: --itemtype
62: -- Standard parameter to be used in a workflow procedure
63: --itemkey
64: -- Standard parameter to be used in a workflow procedure
65: --actid
66: -- Standard parameter to be used in a workflow procedure
60: --IN:
61: --itemtype
62: -- Standard parameter to be used in a workflow procedure
63: --itemkey
64: -- Standard parameter to be used in a workflow procedure
65: --actid
66: -- Standard parameter to be used in a workflow procedure
67: --funcmode
68: -- Standard parameter to be used in a workflow procedure
62: -- Standard parameter to be used in a workflow procedure
63: --itemkey
64: -- Standard parameter to be used in a workflow procedure
65: --actid
66: -- Standard parameter to be used in a workflow procedure
67: --funcmode
68: -- Standard parameter to be used in a workflow procedure
69: --OUT:
70: --resultout
64: -- Standard parameter to be used in a workflow procedure
65: --actid
66: -- Standard parameter to be used in a workflow procedure
67: --funcmode
68: -- Standard parameter to be used in a workflow procedure
69: --OUT:
70: --resultout
71: -- Standard parameter to be used in a workflow procedure
72: --Testing:
67: --funcmode
68: -- Standard parameter to be used in a workflow procedure
69: --OUT:
70: --resultout
71: -- Standard parameter to be used in a workflow procedure
72: --Testing:
73: -- Testing to be done based on the test cases in Document Binding DLD
74: --End of Comments
75: -------------------------------------------------------------------------------
173: RAISE l_binding_exception;
174: END;
175:
176: IF (l_document_type = 'PA' AND l_document_subtype IN ('BLANKET','CONTRACT')) OR
177: (l_document_type = 'PO' AND l_document_subtype = 'STANDARD') THEN
178:
179: l_doc_display_name := PO_DOC_STYLE_PVT.GET_STYLE_DISPLAY_NAME(l_document_id);
180:
181: END IF;
277: -- Called from the Document Signature Process of the PO Approval workflow
278: --Parameters:
279: --IN:
280: --document_id
281: -- Standard parameter to be used in the procedure for creating PLSQL clob
282: --display_type
283: -- Standard parameter to be used in the procedure for creating PLSQL clob
284: --IN OUT:
285: --document
279: --IN:
280: --document_id
281: -- Standard parameter to be used in the procedure for creating PLSQL clob
282: --display_type
283: -- Standard parameter to be used in the procedure for creating PLSQL clob
284: --IN OUT:
285: --document
286: -- Standard parameter to be used in the procedure for creating PLSQL clob
287: --document_type
282: --display_type
283: -- Standard parameter to be used in the procedure for creating PLSQL clob
284: --IN OUT:
285: --document
286: -- Standard parameter to be used in the procedure for creating PLSQL clob
287: --document_type
288: -- Standard parameter to be used in the procedure for creating PLSQL clob
289: --Testing:
290: -- Testing to be done based on the test cases in Document Binding DLD
284: --IN OUT:
285: --document
286: -- Standard parameter to be used in the procedure for creating PLSQL clob
287: --document_type
288: -- Standard parameter to be used in the procedure for creating PLSQL clob
289: --Testing:
290: -- Testing to be done based on the test cases in Document Binding DLD
291: --End of Comments
292: -------------------------------------------------------------------------------
477: -- notification as an eRecord
478: --Parameters:
479: --IN:
480: --itemtype
481: -- Standard parameter to be used in a workflow procedure
482: --itemkey
483: -- Standard parameter to be used in a workflow procedure
484: --actid
485: -- Standard parameter to be used in a workflow procedure
479: --IN:
480: --itemtype
481: -- Standard parameter to be used in a workflow procedure
482: --itemkey
483: -- Standard parameter to be used in a workflow procedure
484: --actid
485: -- Standard parameter to be used in a workflow procedure
486: --funcmode
487: -- Standard parameter to be used in a workflow procedure
481: -- Standard parameter to be used in a workflow procedure
482: --itemkey
483: -- Standard parameter to be used in a workflow procedure
484: --actid
485: -- Standard parameter to be used in a workflow procedure
486: --funcmode
487: -- Standard parameter to be used in a workflow procedure
488: --OUT:
489: --resultout
483: -- Standard parameter to be used in a workflow procedure
484: --actid
485: -- Standard parameter to be used in a workflow procedure
486: --funcmode
487: -- Standard parameter to be used in a workflow procedure
488: --OUT:
489: --resultout
490: -- Standard parameter to be used in a workflow procedure
491: --Testing:
486: --funcmode
487: -- Standard parameter to be used in a workflow procedure
488: --OUT:
489: --resultout
490: -- Standard parameter to be used in a workflow procedure
491: --Testing:
492: -- Testing to be done based on the test cases in Document Binding DLD
493: --End of Comments
494: -------------------------------------------------------------------------------
768: -- signature response and buyers signature response.
769: --Parameters:
770: --IN:
771: --itemtype
772: -- Standard parameter to be used in a workflow procedure
773: --itemkey
774: -- Standard parameter to be used in a workflow procedure
775: --actid
776: -- Standard parameter to be used in a workflow procedure
770: --IN:
771: --itemtype
772: -- Standard parameter to be used in a workflow procedure
773: --itemkey
774: -- Standard parameter to be used in a workflow procedure
775: --actid
776: -- Standard parameter to be used in a workflow procedure
777: --funcmode
778: -- Standard parameter to be used in a workflow procedure
772: -- Standard parameter to be used in a workflow procedure
773: --itemkey
774: -- Standard parameter to be used in a workflow procedure
775: --actid
776: -- Standard parameter to be used in a workflow procedure
777: --funcmode
778: -- Standard parameter to be used in a workflow procedure
779: --OUT:
780: --resultout
774: -- Standard parameter to be used in a workflow procedure
775: --actid
776: -- Standard parameter to be used in a workflow procedure
777: --funcmode
778: -- Standard parameter to be used in a workflow procedure
779: --OUT:
780: --resultout
781: -- Standard parameter to be used in a workflow procedure
782: --Testing:
777: --funcmode
778: -- Standard parameter to be used in a workflow procedure
779: --OUT:
780: --resultout
781: -- Standard parameter to be used in a workflow procedure
782: --Testing:
783: -- Testing to be done based on the test cases in Document Binding DLD
784: --End of Comments
785: -------------------------------------------------------------------------------
1089: -- Called from PO Approval workflow
1090: --Parameters:
1091: --IN:
1092: --itemtype
1093: -- Standard parameter to be used in a workflow procedure
1094: --itemkey
1095: -- Standard parameter to be used in a workflow procedure
1096: --actid
1097: -- Standard parameter to be used in a workflow procedure
1091: --IN:
1092: --itemtype
1093: -- Standard parameter to be used in a workflow procedure
1094: --itemkey
1095: -- Standard parameter to be used in a workflow procedure
1096: --actid
1097: -- Standard parameter to be used in a workflow procedure
1098: --funcmode
1099: -- Standard parameter to be used in a workflow procedure
1093: -- Standard parameter to be used in a workflow procedure
1094: --itemkey
1095: -- Standard parameter to be used in a workflow procedure
1096: --actid
1097: -- Standard parameter to be used in a workflow procedure
1098: --funcmode
1099: -- Standard parameter to be used in a workflow procedure
1100: --OUT:
1101: --resultout
1095: -- Standard parameter to be used in a workflow procedure
1096: --actid
1097: -- Standard parameter to be used in a workflow procedure
1098: --funcmode
1099: -- Standard parameter to be used in a workflow procedure
1100: --OUT:
1101: --resultout
1102: -- Standard parameter to be used in a workflow procedure
1103: --Testing:
1098: --funcmode
1099: -- Standard parameter to be used in a workflow procedure
1100: --OUT:
1101: --resultout
1102: -- Standard parameter to be used in a workflow procedure
1103: --Testing:
1104: -- Testing to be done based on the test cases in Document Binding DLD
1105: --End of Comments
1106: -------------------------------------------------------------------------------
1196: -- Called from PO Approval workflow
1197: --Parameters:
1198: --IN:
1199: --itemtype
1200: -- Standard parameter to be used in a workflow procedure
1201: --itemkey
1202: -- Standard parameter to be used in a workflow procedure
1203: --actid
1204: -- Standard parameter to be used in a workflow procedure
1198: --IN:
1199: --itemtype
1200: -- Standard parameter to be used in a workflow procedure
1201: --itemkey
1202: -- Standard parameter to be used in a workflow procedure
1203: --actid
1204: -- Standard parameter to be used in a workflow procedure
1205: --funcmode
1206: -- Standard parameter to be used in a workflow procedure
1200: -- Standard parameter to be used in a workflow procedure
1201: --itemkey
1202: -- Standard parameter to be used in a workflow procedure
1203: --actid
1204: -- Standard parameter to be used in a workflow procedure
1205: --funcmode
1206: -- Standard parameter to be used in a workflow procedure
1207: --OUT:
1208: --resultout
1202: -- Standard parameter to be used in a workflow procedure
1203: --actid
1204: -- Standard parameter to be used in a workflow procedure
1205: --funcmode
1206: -- Standard parameter to be used in a workflow procedure
1207: --OUT:
1208: --resultout
1209: -- Standard parameter to be used in a workflow procedure
1210: --Testing:
1205: --funcmode
1206: -- Standard parameter to be used in a workflow procedure
1207: --OUT:
1208: --resultout
1209: -- Standard parameter to be used in a workflow procedure
1210: --Testing:
1211: -- Testing to be done based on the test cases in Document Binding DLD
1212: --End of Comments
1213: -------------------------------------------------------------------------------
1303: -- Called from the Document Signature Process of the PO Approval workflow
1304: --Parameters:
1305: --IN:
1306: --document_id
1307: -- Standard parameter to be used in the procedure for creating PLSQL clob
1308: --display_type
1309: -- Standard parameter to be used in the procedure for creating PLSQL clob
1310: --IN OUT:
1311: --document
1305: --IN:
1306: --document_id
1307: -- Standard parameter to be used in the procedure for creating PLSQL clob
1308: --display_type
1309: -- Standard parameter to be used in the procedure for creating PLSQL clob
1310: --IN OUT:
1311: --document
1312: -- Standard parameter to be used in the procedure for creating PLSQL clob
1313: --document_type
1308: --display_type
1309: -- Standard parameter to be used in the procedure for creating PLSQL clob
1310: --IN OUT:
1311: --document
1312: -- Standard parameter to be used in the procedure for creating PLSQL clob
1313: --document_type
1314: -- Standard parameter to be used in the procedure for creating PLSQL clob
1315: --Testing:
1316: -- Testing to be done based on the test cases in Document Binding DLD
1310: --IN OUT:
1311: --document
1312: -- Standard parameter to be used in the procedure for creating PLSQL clob
1313: --document_type
1314: -- Standard parameter to be used in the procedure for creating PLSQL clob
1315: --Testing:
1316: -- Testing to be done based on the test cases in Document Binding DLD
1317: --End of Comments
1318: -------------------------------------------------------------------------------
1550: -- Called from PO Approval workflow.
1551: --Parameters:
1552: --IN:
1553: --itemtype
1554: -- Standard parameter to be used in a workflow procedure
1555: --itemkey
1556: -- Standard parameter to be used in a workflow procedure
1557: --actid
1558: -- Standard parameter to be used in a workflow procedure
1552: --IN:
1553: --itemtype
1554: -- Standard parameter to be used in a workflow procedure
1555: --itemkey
1556: -- Standard parameter to be used in a workflow procedure
1557: --actid
1558: -- Standard parameter to be used in a workflow procedure
1559: --funcmode
1560: -- Standard parameter to be used in a workflow procedure
1554: -- Standard parameter to be used in a workflow procedure
1555: --itemkey
1556: -- Standard parameter to be used in a workflow procedure
1557: --actid
1558: -- Standard parameter to be used in a workflow procedure
1559: --funcmode
1560: -- Standard parameter to be used in a workflow procedure
1561: --OUT:
1562: --resultout
1556: -- Standard parameter to be used in a workflow procedure
1557: --actid
1558: -- Standard parameter to be used in a workflow procedure
1559: --funcmode
1560: -- Standard parameter to be used in a workflow procedure
1561: --OUT:
1562: --resultout
1563: -- Standard parameter to be used in a workflow procedure
1564: --Testing:
1559: --funcmode
1560: -- Standard parameter to be used in a workflow procedure
1561: --OUT:
1562: --resultout
1563: -- Standard parameter to be used in a workflow procedure
1564: --Testing:
1565: -- Testing to be done based on the test cases in Document Binding DLD
1566: --End of Comments
1567: -------------------------------------------------------------------------------
1659: -- Called from the Document Signature Process of the PO Approval workflow.
1660: --Parameters:
1661: --IN:
1662: --document_id
1663: -- Standard parameter to be used in the procedure for creating PLSQL clob
1664: --display_type
1665: -- Standard parameter to be used in the procedure for creating PLSQL clob
1666: --IN OUT:
1667: --document
1661: --IN:
1662: --document_id
1663: -- Standard parameter to be used in the procedure for creating PLSQL clob
1664: --display_type
1665: -- Standard parameter to be used in the procedure for creating PLSQL clob
1666: --IN OUT:
1667: --document
1668: -- Standard parameter to be used in the procedure for creating PLSQL clob
1669: --document_type
1664: --display_type
1665: -- Standard parameter to be used in the procedure for creating PLSQL clob
1666: --IN OUT:
1667: --document
1668: -- Standard parameter to be used in the procedure for creating PLSQL clob
1669: --document_type
1670: -- Standard parameter to be used in the procedure for creating PLSQL clob
1671: --Testing:
1672: -- Testing to be done based on the test cases in Document Binding DLD
1666: --IN OUT:
1667: --document
1668: -- Standard parameter to be used in the procedure for creating PLSQL clob
1669: --document_type
1670: -- Standard parameter to be used in the procedure for creating PLSQL clob
1671: --Testing:
1672: -- Testing to be done based on the test cases in Document Binding DLD
1673: --End of Comments
1674: -------------------------------------------------------------------------------
1898: -- Called from PO Approval workflow.
1899: --Parameters:
1900: --IN:
1901: --itemtype
1902: -- Standard parameter to be used in a workflow procedure
1903: --itemkey
1904: -- Standard parameter to be used in a workflow procedure
1905: --actid
1906: -- Standard parameter to be used in a workflow procedure
1900: --IN:
1901: --itemtype
1902: -- Standard parameter to be used in a workflow procedure
1903: --itemkey
1904: -- Standard parameter to be used in a workflow procedure
1905: --actid
1906: -- Standard parameter to be used in a workflow procedure
1907: --funcmode
1908: -- Standard parameter to be used in a workflow procedure
1902: -- Standard parameter to be used in a workflow procedure
1903: --itemkey
1904: -- Standard parameter to be used in a workflow procedure
1905: --actid
1906: -- Standard parameter to be used in a workflow procedure
1907: --funcmode
1908: -- Standard parameter to be used in a workflow procedure
1909: --OUT:
1910: --resultout
1904: -- Standard parameter to be used in a workflow procedure
1905: --actid
1906: -- Standard parameter to be used in a workflow procedure
1907: --funcmode
1908: -- Standard parameter to be used in a workflow procedure
1909: --OUT:
1910: --resultout
1911: -- Standard parameter to be used in a workflow procedure
1912: --Testing:
1907: --funcmode
1908: -- Standard parameter to be used in a workflow procedure
1909: --OUT:
1910: --resultout
1911: -- Standard parameter to be used in a workflow procedure
1912: --Testing:
1913: -- Testing to be done based on the test cases in Document Binding DLD
1914: --End of Comments
1915: -------------------------------------------------------------------------------
2002: -- Called from PO Approval workflow.
2003: --Parameters:
2004: --IN:
2005: --itemtype
2006: -- Standard parameter to be used in a workflow procedure
2007: --itemkey
2008: -- Standard parameter to be used in a workflow procedure
2009: --actid
2010: -- Standard parameter to be used in a workflow procedure
2004: --IN:
2005: --itemtype
2006: -- Standard parameter to be used in a workflow procedure
2007: --itemkey
2008: -- Standard parameter to be used in a workflow procedure
2009: --actid
2010: -- Standard parameter to be used in a workflow procedure
2011: --funcmode
2012: -- Standard parameter to be used in a workflow procedure
2006: -- Standard parameter to be used in a workflow procedure
2007: --itemkey
2008: -- Standard parameter to be used in a workflow procedure
2009: --actid
2010: -- Standard parameter to be used in a workflow procedure
2011: --funcmode
2012: -- Standard parameter to be used in a workflow procedure
2013: --OUT:
2014: --resultout
2008: -- Standard parameter to be used in a workflow procedure
2009: --actid
2010: -- Standard parameter to be used in a workflow procedure
2011: --funcmode
2012: -- Standard parameter to be used in a workflow procedure
2013: --OUT:
2014: --resultout
2015: -- Standard parameter to be used in a workflow procedure
2016: --Testing:
2011: --funcmode
2012: -- Standard parameter to be used in a workflow procedure
2013: --OUT:
2014: --resultout
2015: -- Standard parameter to be used in a workflow procedure
2016: --Testing:
2017: -- Testing to be done based on the test cases in Document Binding DLD
2018: --End of Comments
2019: -------------------------------------------------------------------------------
2087: -- Checks if the signature is required for the document.
2088: --Parameters:
2089: --IN:
2090: --p_itemtype
2091: -- Standard parameter to be used in a workflow procedure
2092: --p_itemkey
2093: -- Standard parameter to be used in a workflow procedure
2094: --Returns:
2095: -- A BOOLEAN TRUE if document signature is required. FALSE otherwise.
2089: --IN:
2090: --p_itemtype
2091: -- Standard parameter to be used in a workflow procedure
2092: --p_itemkey
2093: -- Standard parameter to be used in a workflow procedure
2094: --Returns:
2095: -- A BOOLEAN TRUE if document signature is required. FALSE otherwise.
2096: --Testing:
2097: -- N/A
2236: -- Called from PO Approval workflow.
2237: --Parameters:
2238: --IN:
2239: --itemtype
2240: -- Standard parameter to be used in a workflow procedure
2241: --itemkey
2242: -- Standard parameter to be used in a workflow procedure
2243: --actid
2244: -- Standard parameter to be used in a workflow procedure
2238: --IN:
2239: --itemtype
2240: -- Standard parameter to be used in a workflow procedure
2241: --itemkey
2242: -- Standard parameter to be used in a workflow procedure
2243: --actid
2244: -- Standard parameter to be used in a workflow procedure
2245: --funcmode
2246: -- Standard parameter to be used in a workflow procedure
2240: -- Standard parameter to be used in a workflow procedure
2241: --itemkey
2242: -- Standard parameter to be used in a workflow procedure
2243: --actid
2244: -- Standard parameter to be used in a workflow procedure
2245: --funcmode
2246: -- Standard parameter to be used in a workflow procedure
2247: --OUT:
2248: --resultout
2242: -- Standard parameter to be used in a workflow procedure
2243: --actid
2244: -- Standard parameter to be used in a workflow procedure
2245: --funcmode
2246: -- Standard parameter to be used in a workflow procedure
2247: --OUT:
2248: --resultout
2249: -- Standard parameter to be used in a workflow procedure
2250: --Testing:
2245: --funcmode
2246: -- Standard parameter to be used in a workflow procedure
2247: --OUT:
2248: --resultout
2249: -- Standard parameter to be used in a workflow procedure
2250: --Testing:
2251: -- Testing to be done based on the test cases in Document Binding DLD
2252: --End of Comments
2253: -------------------------------------------------------------------------------
2295: -- Called from PO Approval workflow.
2296: --Parameters:
2297: --IN:
2298: --itemtype
2299: -- Standard parameter to be used in a workflow procedure
2300: --itemkey
2301: -- Standard parameter to be used in a workflow procedure
2302: --actid
2303: -- Standard parameter to be used in a workflow procedure
2297: --IN:
2298: --itemtype
2299: -- Standard parameter to be used in a workflow procedure
2300: --itemkey
2301: -- Standard parameter to be used in a workflow procedure
2302: --actid
2303: -- Standard parameter to be used in a workflow procedure
2304: --funcmode
2305: -- Standard parameter to be used in a workflow procedure
2299: -- Standard parameter to be used in a workflow procedure
2300: --itemkey
2301: -- Standard parameter to be used in a workflow procedure
2302: --actid
2303: -- Standard parameter to be used in a workflow procedure
2304: --funcmode
2305: -- Standard parameter to be used in a workflow procedure
2306: --OUT:
2307: --resultout
2301: -- Standard parameter to be used in a workflow procedure
2302: --actid
2303: -- Standard parameter to be used in a workflow procedure
2304: --funcmode
2305: -- Standard parameter to be used in a workflow procedure
2306: --OUT:
2307: --resultout
2308: -- Standard parameter to be used in a workflow procedure
2309: --Testing:
2304: --funcmode
2305: -- Standard parameter to be used in a workflow procedure
2306: --OUT:
2307: --resultout
2308: -- Standard parameter to be used in a workflow procedure
2309: --Testing:
2310: -- Testing to be done based on the test cases in Document Binding DLD
2311: --End of Comments
2312: -------------------------------------------------------------------------------
2363: -- Valid values 'SIGNED', 'BUYER REJECTED', 'SUPPLIER REJECTED'
2364: --p_object_type_code
2365: -- Document type - 'PO', 'PA' etc
2366: --p_object_subtype_code
2367: -- Document Subtype - 'STANDARD', 'CONTRACT', 'BLANKET' etc
2368: --p_employee_id
2369: -- Employee Id of the Buyer
2370: --p_revision_num
2371: -- Revision Number of the document
2411: WHERE po_header_id = p_po_header_id
2412: AND NVL(cancel_flag,'N') = 'N'
2413: AND NVL(closed_code,'OPEN') <> 'FINALLY CLOSED'
2414: --
2415: AND shipment_type IN ('STANDARD','BLANKET','SCHEDULED','PREPAYMENT')
2416: AND NVL(approved_flag,'N') <> 'Y';
2417:
2418: -- Bug 7494807 END
2419:
2471: , p_employee_id => p_employee_id -- bug3738420
2472: );
2473:
2474: -- Bug 3602512 START
2475: -- If we are setting the standard PO's status to Approved, call the FTE API
2476: -- to update the Inbound Logistics delivery records.
2477: IF (p_status = 'APPROVED')
2478: AND ((p_object_type_code = 'PO')
2479: AND (p_object_subtype_code = 'STANDARD')) THEN
2475: -- If we are setting the standard PO's status to Approved, call the FTE API
2476: -- to update the Inbound Logistics delivery records.
2477: IF (p_status = 'APPROVED')
2478: AND ((p_object_type_code = 'PO')
2479: AND (p_object_subtype_code = 'STANDARD')) THEN
2480: -- Note: Signatures are not supported for blanket releases.
2481:
2482: PO_DELREC_PVT.create_update_delrec (
2483: p_api_version => 1.0,
3022:
3023: -- bug 3568077
3024: -- PO_ACTION_HISTORY.object_type_code is:
3025: -- PA for Contracts and BPAs
3026: -- PO for Standard/Planned POs
3027:
3028: SELECT
3029: Type_Lookup_Code
3030: , DECODE( type_lookup_code