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

Line 62: -- Standard parameter to be used in a workflow procedure

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

Line 64: -- 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

Line 66: -- 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

Line 68: -- Standard parameter to be used in a workflow procedure

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:

Line 71: -- 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:
73: -- Testing to be done based on the test cases in Document Binding DLD
74: --End of Comments
75: -------------------------------------------------------------------------------

Line 201: (l_document_type = 'PO' AND l_document_subtype = 'STANDARD') THEN

197: RAISE l_binding_exception;
198: END;
199:
200: IF (l_document_type = 'PA' AND l_document_subtype IN ('BLANKET','CONTRACT')) OR
201: (l_document_type = 'PO' AND l_document_subtype = 'STANDARD') THEN
202:
203: l_doc_display_name := PO_DOC_STYLE_PVT.GET_STYLE_DISPLAY_NAME(l_document_id);
204:
205: END IF;

Line 354: -- Standard parameter to be used in the procedure for creating PLSQL clob

350: -- Called from the Document Signature Process of the PO Approval workflow
351: --Parameters:
352: --IN:
353: --document_id
354: -- Standard parameter to be used in the procedure for creating PLSQL clob
355: --display_type
356: -- Standard parameter to be used in the procedure for creating PLSQL clob
357: --IN OUT:
358: --document

Line 356: -- Standard parameter to be used in the procedure for creating PLSQL clob

352: --IN:
353: --document_id
354: -- Standard parameter to be used in the procedure for creating PLSQL clob
355: --display_type
356: -- Standard parameter to be used in the procedure for creating PLSQL clob
357: --IN OUT:
358: --document
359: -- Standard parameter to be used in the procedure for creating PLSQL clob
360: --document_type

Line 359: -- Standard parameter to be used in the procedure for creating PLSQL clob

355: --display_type
356: -- Standard parameter to be used in the procedure for creating PLSQL clob
357: --IN OUT:
358: --document
359: -- Standard parameter to be used in the procedure for creating PLSQL clob
360: --document_type
361: -- Standard parameter to be used in the procedure for creating PLSQL clob
362: --Testing:
363: -- Testing to be done based on the test cases in Document Binding DLD

Line 361: -- Standard parameter to be used in the procedure for creating PLSQL clob

357: --IN OUT:
358: --document
359: -- Standard parameter to be used in the procedure for creating PLSQL clob
360: --document_type
361: -- Standard parameter to be used in the procedure for creating PLSQL clob
362: --Testing:
363: -- Testing to be done based on the test cases in Document Binding DLD
364: --End of Comments
365: -------------------------------------------------------------------------------

Line 568: -- Standard parameter to be used in a workflow procedure

564: -- notification as an eRecord
565: --Parameters:
566: --IN:
567: --itemtype
568: -- Standard parameter to be used in a workflow procedure
569: --itemkey
570: -- Standard parameter to be used in a workflow procedure
571: --actid
572: -- Standard parameter to be used in a workflow procedure

Line 570: -- Standard parameter to be used in a workflow procedure

566: --IN:
567: --itemtype
568: -- Standard parameter to be used in a workflow procedure
569: --itemkey
570: -- Standard parameter to be used in a workflow procedure
571: --actid
572: -- Standard parameter to be used in a workflow procedure
573: --funcmode
574: -- Standard parameter to be used in a workflow procedure

Line 572: -- Standard parameter to be used in a workflow procedure

568: -- Standard parameter to be used in a workflow procedure
569: --itemkey
570: -- Standard parameter to be used in a workflow procedure
571: --actid
572: -- Standard parameter to be used in a workflow procedure
573: --funcmode
574: -- Standard parameter to be used in a workflow procedure
575: --OUT:
576: --resultout

Line 574: -- Standard parameter to be used in a workflow procedure

570: -- Standard parameter to be used in a workflow procedure
571: --actid
572: -- Standard parameter to be used in a workflow procedure
573: --funcmode
574: -- Standard parameter to be used in a workflow procedure
575: --OUT:
576: --resultout
577: -- Standard parameter to be used in a workflow procedure
578: --Testing:

Line 577: -- Standard parameter to be used in a workflow procedure

573: --funcmode
574: -- Standard parameter to be used in a workflow procedure
575: --OUT:
576: --resultout
577: -- Standard parameter to be used in a workflow procedure
578: --Testing:
579: -- Testing to be done based on the test cases in Document Binding DLD
580: --End of Comments
581: -------------------------------------------------------------------------------

Line 900: -- Standard parameter to be used in a workflow procedure

896: -- signature response and buyers signature response.
897: --Parameters:
898: --IN:
899: --itemtype
900: -- Standard parameter to be used in a workflow procedure
901: --itemkey
902: -- Standard parameter to be used in a workflow procedure
903: --actid
904: -- Standard parameter to be used in a workflow procedure

Line 902: -- Standard parameter to be used in a workflow procedure

898: --IN:
899: --itemtype
900: -- Standard parameter to be used in a workflow procedure
901: --itemkey
902: -- Standard parameter to be used in a workflow procedure
903: --actid
904: -- Standard parameter to be used in a workflow procedure
905: --funcmode
906: -- Standard parameter to be used in a workflow procedure

Line 904: -- Standard parameter to be used in a workflow procedure

900: -- Standard parameter to be used in a workflow procedure
901: --itemkey
902: -- Standard parameter to be used in a workflow procedure
903: --actid
904: -- Standard parameter to be used in a workflow procedure
905: --funcmode
906: -- Standard parameter to be used in a workflow procedure
907: --OUT:
908: --resultout

Line 906: -- Standard parameter to be used in a workflow procedure

902: -- Standard parameter to be used in a workflow procedure
903: --actid
904: -- Standard parameter to be used in a workflow procedure
905: --funcmode
906: -- Standard parameter to be used in a workflow procedure
907: --OUT:
908: --resultout
909: -- Standard parameter to be used in a workflow procedure
910: --Testing:

Line 909: -- Standard parameter to be used in a workflow procedure

905: --funcmode
906: -- Standard parameter to be used in a workflow procedure
907: --OUT:
908: --resultout
909: -- Standard parameter to be used in a workflow procedure
910: --Testing:
911: -- Testing to be done based on the test cases in Document Binding DLD
912: --End of Comments
913: -------------------------------------------------------------------------------

Line 1397: -- Standard parameter to be used in a workflow procedure

1393: -- Called from PO Approval workflow
1394: --Parameters:
1395: --IN:
1396: --itemtype
1397: -- Standard parameter to be used in a workflow procedure
1398: --itemkey
1399: -- Standard parameter to be used in a workflow procedure
1400: --actid
1401: -- Standard parameter to be used in a workflow procedure

Line 1399: -- Standard parameter to be used in a workflow procedure

1395: --IN:
1396: --itemtype
1397: -- Standard parameter to be used in a workflow procedure
1398: --itemkey
1399: -- Standard parameter to be used in a workflow procedure
1400: --actid
1401: -- Standard parameter to be used in a workflow procedure
1402: --funcmode
1403: -- Standard parameter to be used in a workflow procedure

Line 1401: -- Standard parameter to be used in a workflow procedure

1397: -- Standard parameter to be used in a workflow procedure
1398: --itemkey
1399: -- Standard parameter to be used in a workflow procedure
1400: --actid
1401: -- Standard parameter to be used in a workflow procedure
1402: --funcmode
1403: -- Standard parameter to be used in a workflow procedure
1404: --OUT:
1405: --resultout

Line 1403: -- Standard parameter to be used in a workflow procedure

1399: -- Standard parameter to be used in a workflow procedure
1400: --actid
1401: -- Standard parameter to be used in a workflow procedure
1402: --funcmode
1403: -- Standard parameter to be used in a workflow procedure
1404: --OUT:
1405: --resultout
1406: -- Standard parameter to be used in a workflow procedure
1407: --Testing:

Line 1406: -- Standard parameter to be used in a workflow procedure

1402: --funcmode
1403: -- Standard parameter to be used in a workflow procedure
1404: --OUT:
1405: --resultout
1406: -- Standard parameter to be used in a workflow procedure
1407: --Testing:
1408: -- Testing to be done based on the test cases in Document Binding DLD
1409: --End of Comments
1410: -------------------------------------------------------------------------------

Line 1524: -- Standard parameter to be used in a workflow procedure

1520: -- Called from PO Approval workflow
1521: --Parameters:
1522: --IN:
1523: --itemtype
1524: -- Standard parameter to be used in a workflow procedure
1525: --itemkey
1526: -- Standard parameter to be used in a workflow procedure
1527: --actid
1528: -- Standard parameter to be used in a workflow procedure

Line 1526: -- Standard parameter to be used in a workflow procedure

1522: --IN:
1523: --itemtype
1524: -- Standard parameter to be used in a workflow procedure
1525: --itemkey
1526: -- Standard parameter to be used in a workflow procedure
1527: --actid
1528: -- Standard parameter to be used in a workflow procedure
1529: --funcmode
1530: -- Standard parameter to be used in a workflow procedure

Line 1528: -- Standard parameter to be used in a workflow procedure

1524: -- Standard parameter to be used in a workflow procedure
1525: --itemkey
1526: -- Standard parameter to be used in a workflow procedure
1527: --actid
1528: -- Standard parameter to be used in a workflow procedure
1529: --funcmode
1530: -- Standard parameter to be used in a workflow procedure
1531: --OUT:
1532: --resultout

Line 1530: -- Standard parameter to be used in a workflow procedure

1526: -- Standard parameter to be used in a workflow procedure
1527: --actid
1528: -- Standard parameter to be used in a workflow procedure
1529: --funcmode
1530: -- Standard parameter to be used in a workflow procedure
1531: --OUT:
1532: --resultout
1533: -- Standard parameter to be used in a workflow procedure
1534: --Testing:

Line 1533: -- Standard parameter to be used in a workflow procedure

1529: --funcmode
1530: -- Standard parameter to be used in a workflow procedure
1531: --OUT:
1532: --resultout
1533: -- Standard parameter to be used in a workflow procedure
1534: --Testing:
1535: -- Testing to be done based on the test cases in Document Binding DLD
1536: --End of Comments
1537: -------------------------------------------------------------------------------

Line 1650: -- Standard parameter to be used in the procedure for creating PLSQL clob

1646: -- Called from the Document Signature Process of the PO Approval workflow
1647: --Parameters:
1648: --IN:
1649: --document_id
1650: -- Standard parameter to be used in the procedure for creating PLSQL clob
1651: --display_type
1652: -- Standard parameter to be used in the procedure for creating PLSQL clob
1653: --IN OUT:
1654: --document

Line 1652: -- Standard parameter to be used in the procedure for creating PLSQL clob

1648: --IN:
1649: --document_id
1650: -- Standard parameter to be used in the procedure for creating PLSQL clob
1651: --display_type
1652: -- Standard parameter to be used in the procedure for creating PLSQL clob
1653: --IN OUT:
1654: --document
1655: -- Standard parameter to be used in the procedure for creating PLSQL clob
1656: --document_type

Line 1655: -- Standard parameter to be used in the procedure for creating PLSQL clob

1651: --display_type
1652: -- Standard parameter to be used in the procedure for creating PLSQL clob
1653: --IN OUT:
1654: --document
1655: -- Standard parameter to be used in the procedure for creating PLSQL clob
1656: --document_type
1657: -- Standard parameter to be used in the procedure for creating PLSQL clob
1658: --Testing:
1659: -- Testing to be done based on the test cases in Document Binding DLD

Line 1657: -- Standard parameter to be used in the procedure for creating PLSQL clob

1653: --IN OUT:
1654: --document
1655: -- Standard parameter to be used in the procedure for creating PLSQL clob
1656: --document_type
1657: -- Standard parameter to be used in the procedure for creating PLSQL clob
1658: --Testing:
1659: -- Testing to be done based on the test cases in Document Binding DLD
1660: --End of Comments
1661: -------------------------------------------------------------------------------

Line 1898: -- Standard parameter to be used in a workflow procedure

1894: -- Called from PO Approval workflow.
1895: --Parameters:
1896: --IN:
1897: --itemtype
1898: -- Standard parameter to be used in a workflow procedure
1899: --itemkey
1900: -- Standard parameter to be used in a workflow procedure
1901: --actid
1902: -- Standard parameter to be used in a workflow procedure

Line 1900: -- Standard parameter to be used in a workflow procedure

1896: --IN:
1897: --itemtype
1898: -- Standard parameter to be used in a workflow procedure
1899: --itemkey
1900: -- Standard parameter to be used in a workflow procedure
1901: --actid
1902: -- Standard parameter to be used in a workflow procedure
1903: --funcmode
1904: -- Standard parameter to be used in a workflow procedure

Line 1902: -- Standard parameter to be used in a workflow procedure

1898: -- Standard parameter to be used in a workflow procedure
1899: --itemkey
1900: -- Standard parameter to be used in a workflow procedure
1901: --actid
1902: -- Standard parameter to be used in a workflow procedure
1903: --funcmode
1904: -- Standard parameter to be used in a workflow procedure
1905: --OUT:
1906: --resultout

Line 1904: -- Standard parameter to be used in a workflow procedure

1900: -- Standard parameter to be used in a workflow procedure
1901: --actid
1902: -- Standard parameter to be used in a workflow procedure
1903: --funcmode
1904: -- Standard parameter to be used in a workflow procedure
1905: --OUT:
1906: --resultout
1907: -- Standard parameter to be used in a workflow procedure
1908: --Testing:

Line 1907: -- Standard parameter to be used in a workflow procedure

1903: --funcmode
1904: -- Standard parameter to be used in a workflow procedure
1905: --OUT:
1906: --resultout
1907: -- Standard parameter to be used in a workflow procedure
1908: --Testing:
1909: -- Testing to be done based on the test cases in Document Binding DLD
1910: --End of Comments
1911: -------------------------------------------------------------------------------

Line 2014: -- Standard parameter to be used in the procedure for creating PLSQL clob

2010: -- Called from the Document Signature Process of the PO Approval workflow.
2011: --Parameters:
2012: --IN:
2013: --document_id
2014: -- Standard parameter to be used in the procedure for creating PLSQL clob
2015: --display_type
2016: -- Standard parameter to be used in the procedure for creating PLSQL clob
2017: --IN OUT:
2018: --document

Line 2016: -- Standard parameter to be used in the procedure for creating PLSQL clob

2012: --IN:
2013: --document_id
2014: -- Standard parameter to be used in the procedure for creating PLSQL clob
2015: --display_type
2016: -- Standard parameter to be used in the procedure for creating PLSQL clob
2017: --IN OUT:
2018: --document
2019: -- Standard parameter to be used in the procedure for creating PLSQL clob
2020: --document_type

Line 2019: -- Standard parameter to be used in the procedure for creating PLSQL clob

2015: --display_type
2016: -- Standard parameter to be used in the procedure for creating PLSQL clob
2017: --IN OUT:
2018: --document
2019: -- Standard parameter to be used in the procedure for creating PLSQL clob
2020: --document_type
2021: -- Standard parameter to be used in the procedure for creating PLSQL clob
2022: --Testing:
2023: -- Testing to be done based on the test cases in Document Binding DLD

Line 2021: -- Standard parameter to be used in the procedure for creating PLSQL clob

2017: --IN OUT:
2018: --document
2019: -- Standard parameter to be used in the procedure for creating PLSQL clob
2020: --document_type
2021: -- Standard parameter to be used in the procedure for creating PLSQL clob
2022: --Testing:
2023: -- Testing to be done based on the test cases in Document Binding DLD
2024: --End of Comments
2025: -------------------------------------------------------------------------------

Line 2253: -- Standard parameter to be used in a workflow procedure

2249: -- Called from PO Approval workflow.
2250: --Parameters:
2251: --IN:
2252: --itemtype
2253: -- Standard parameter to be used in a workflow procedure
2254: --itemkey
2255: -- Standard parameter to be used in a workflow procedure
2256: --actid
2257: -- Standard parameter to be used in a workflow procedure

Line 2255: -- Standard parameter to be used in a workflow procedure

2251: --IN:
2252: --itemtype
2253: -- Standard parameter to be used in a workflow procedure
2254: --itemkey
2255: -- Standard parameter to be used in a workflow procedure
2256: --actid
2257: -- Standard parameter to be used in a workflow procedure
2258: --funcmode
2259: -- Standard parameter to be used in a workflow procedure

Line 2257: -- Standard parameter to be used in a workflow procedure

2253: -- Standard parameter to be used in a workflow procedure
2254: --itemkey
2255: -- Standard parameter to be used in a workflow procedure
2256: --actid
2257: -- Standard parameter to be used in a workflow procedure
2258: --funcmode
2259: -- Standard parameter to be used in a workflow procedure
2260: --OUT:
2261: --resultout

Line 2259: -- Standard parameter to be used in a workflow procedure

2255: -- Standard parameter to be used in a workflow procedure
2256: --actid
2257: -- Standard parameter to be used in a workflow procedure
2258: --funcmode
2259: -- Standard parameter to be used in a workflow procedure
2260: --OUT:
2261: --resultout
2262: -- Standard parameter to be used in a workflow procedure
2263: --Testing:

Line 2262: -- Standard parameter to be used in a workflow procedure

2258: --funcmode
2259: -- Standard parameter to be used in a workflow procedure
2260: --OUT:
2261: --resultout
2262: -- Standard parameter to be used in a workflow procedure
2263: --Testing:
2264: -- Testing to be done based on the test cases in Document Binding DLD
2265: --End of Comments
2266: -------------------------------------------------------------------------------

Line 2364: -- Standard parameter to be used in a workflow procedure

2360: -- Called from PO Approval workflow.
2361: --Parameters:
2362: --IN:
2363: --itemtype
2364: -- Standard parameter to be used in a workflow procedure
2365: --itemkey
2366: -- Standard parameter to be used in a workflow procedure
2367: --actid
2368: -- Standard parameter to be used in a workflow procedure

Line 2366: -- Standard parameter to be used in a workflow procedure

2362: --IN:
2363: --itemtype
2364: -- Standard parameter to be used in a workflow procedure
2365: --itemkey
2366: -- Standard parameter to be used in a workflow procedure
2367: --actid
2368: -- Standard parameter to be used in a workflow procedure
2369: --funcmode
2370: -- Standard parameter to be used in a workflow procedure

Line 2368: -- Standard parameter to be used in a workflow procedure

2364: -- Standard parameter to be used in a workflow procedure
2365: --itemkey
2366: -- Standard parameter to be used in a workflow procedure
2367: --actid
2368: -- Standard parameter to be used in a workflow procedure
2369: --funcmode
2370: -- Standard parameter to be used in a workflow procedure
2371: --OUT:
2372: --resultout

Line 2370: -- Standard parameter to be used in a workflow procedure

2366: -- Standard parameter to be used in a workflow procedure
2367: --actid
2368: -- Standard parameter to be used in a workflow procedure
2369: --funcmode
2370: -- Standard parameter to be used in a workflow procedure
2371: --OUT:
2372: --resultout
2373: -- Standard parameter to be used in a workflow procedure
2374: --Testing:

Line 2373: -- Standard parameter to be used in a workflow procedure

2369: --funcmode
2370: -- Standard parameter to be used in a workflow procedure
2371: --OUT:
2372: --resultout
2373: -- Standard parameter to be used in a workflow procedure
2374: --Testing:
2375: -- Testing to be done based on the test cases in Document Binding DLD
2376: --End of Comments
2377: -------------------------------------------------------------------------------

Line 2449: -- Standard parameter to be used in a workflow procedure

2445: -- Checks if the signature is required for the document.
2446: --Parameters:
2447: --IN:
2448: --p_itemtype
2449: -- Standard parameter to be used in a workflow procedure
2450: --p_itemkey
2451: -- Standard parameter to be used in a workflow procedure
2452: --Returns:
2453: -- A BOOLEAN TRUE if document signature is required. FALSE otherwise.

Line 2451: -- Standard parameter to be used in a workflow procedure

2447: --IN:
2448: --p_itemtype
2449: -- Standard parameter to be used in a workflow procedure
2450: --p_itemkey
2451: -- Standard parameter to be used in a workflow procedure
2452: --Returns:
2453: -- A BOOLEAN TRUE if document signature is required. FALSE otherwise.
2454: --Testing:
2455: -- N/A

Line 2627: -- Standard parameter to be used in a workflow procedure

2623: -- Called from PO Approval workflow.
2624: --Parameters:
2625: --IN:
2626: --itemtype
2627: -- Standard parameter to be used in a workflow procedure
2628: --itemkey
2629: -- Standard parameter to be used in a workflow procedure
2630: --actid
2631: -- Standard parameter to be used in a workflow procedure

Line 2629: -- Standard parameter to be used in a workflow procedure

2625: --IN:
2626: --itemtype
2627: -- Standard parameter to be used in a workflow procedure
2628: --itemkey
2629: -- Standard parameter to be used in a workflow procedure
2630: --actid
2631: -- Standard parameter to be used in a workflow procedure
2632: --funcmode
2633: -- Standard parameter to be used in a workflow procedure

Line 2631: -- Standard parameter to be used in a workflow procedure

2627: -- Standard parameter to be used in a workflow procedure
2628: --itemkey
2629: -- Standard parameter to be used in a workflow procedure
2630: --actid
2631: -- Standard parameter to be used in a workflow procedure
2632: --funcmode
2633: -- Standard parameter to be used in a workflow procedure
2634: --OUT:
2635: --resultout

Line 2633: -- Standard parameter to be used in a workflow procedure

2629: -- Standard parameter to be used in a workflow procedure
2630: --actid
2631: -- Standard parameter to be used in a workflow procedure
2632: --funcmode
2633: -- Standard parameter to be used in a workflow procedure
2634: --OUT:
2635: --resultout
2636: -- Standard parameter to be used in a workflow procedure
2637: --Testing:

Line 2636: -- Standard parameter to be used in a workflow procedure

2632: --funcmode
2633: -- Standard parameter to be used in a workflow procedure
2634: --OUT:
2635: --resultout
2636: -- Standard parameter to be used in a workflow procedure
2637: --Testing:
2638: -- Testing to be done based on the test cases in Document Binding DLD
2639: --End of Comments
2640: -------------------------------------------------------------------------------

Line 2686: -- Standard parameter to be used in a workflow procedure

2682: -- Called from PO Approval workflow.
2683: --Parameters:
2684: --IN:
2685: --itemtype
2686: -- Standard parameter to be used in a workflow procedure
2687: --itemkey
2688: -- Standard parameter to be used in a workflow procedure
2689: --actid
2690: -- Standard parameter to be used in a workflow procedure

Line 2688: -- Standard parameter to be used in a workflow procedure

2684: --IN:
2685: --itemtype
2686: -- Standard parameter to be used in a workflow procedure
2687: --itemkey
2688: -- Standard parameter to be used in a workflow procedure
2689: --actid
2690: -- Standard parameter to be used in a workflow procedure
2691: --funcmode
2692: -- Standard parameter to be used in a workflow procedure

Line 2690: -- Standard parameter to be used in a workflow procedure

2686: -- Standard parameter to be used in a workflow procedure
2687: --itemkey
2688: -- Standard parameter to be used in a workflow procedure
2689: --actid
2690: -- Standard parameter to be used in a workflow procedure
2691: --funcmode
2692: -- Standard parameter to be used in a workflow procedure
2693: --OUT:
2694: --resultout

Line 2692: -- Standard parameter to be used in a workflow procedure

2688: -- Standard parameter to be used in a workflow procedure
2689: --actid
2690: -- Standard parameter to be used in a workflow procedure
2691: --funcmode
2692: -- Standard parameter to be used in a workflow procedure
2693: --OUT:
2694: --resultout
2695: -- Standard parameter to be used in a workflow procedure
2696: --Testing:

Line 2695: -- Standard parameter to be used in a workflow procedure

2691: --funcmode
2692: -- Standard parameter to be used in a workflow procedure
2693: --OUT:
2694: --resultout
2695: -- Standard parameter to be used in a workflow procedure
2696: --Testing:
2697: -- Testing to be done based on the test cases in Document Binding DLD
2698: --End of Comments
2699: -------------------------------------------------------------------------------

Line 2798: -- Standard parameter to be used in a workflow procedure

2794: -- Called from PO Approval workflow.
2795: --Parameters:
2796: --IN:
2797: --itemtype
2798: -- Standard parameter to be used in a workflow procedure
2799: --itemkey
2800: -- Standard parameter to be used in a workflow procedure
2801: --actid
2802: -- Standard parameter to be used in a workflow procedure

Line 2800: -- Standard parameter to be used in a workflow procedure

2796: --IN:
2797: --itemtype
2798: -- Standard parameter to be used in a workflow procedure
2799: --itemkey
2800: -- Standard parameter to be used in a workflow procedure
2801: --actid
2802: -- Standard parameter to be used in a workflow procedure
2803: --funcmode
2804: -- Standard parameter to be used in a workflow procedure

Line 2802: -- Standard parameter to be used in a workflow procedure

2798: -- Standard parameter to be used in a workflow procedure
2799: --itemkey
2800: -- Standard parameter to be used in a workflow procedure
2801: --actid
2802: -- Standard parameter to be used in a workflow procedure
2803: --funcmode
2804: -- Standard parameter to be used in a workflow procedure
2805: --OUT:
2806: --resultout

Line 2804: -- Standard parameter to be used in a workflow procedure

2800: -- Standard parameter to be used in a workflow procedure
2801: --actid
2802: -- Standard parameter to be used in a workflow procedure
2803: --funcmode
2804: -- Standard parameter to be used in a workflow procedure
2805: --OUT:
2806: --resultout
2807: -- Standard parameter to be used in a workflow procedure
2808: --Testing:

Line 2807: -- Standard parameter to be used in a workflow procedure

2803: --funcmode
2804: -- Standard parameter to be used in a workflow procedure
2805: --OUT:
2806: --resultout
2807: -- Standard parameter to be used in a workflow procedure
2808: --Testing:
2809: -- Testing to be done based on the test cases in Document Binding DLD
2810: --End of Comments
2811: -------------------------------------------------------------------------------

Line 2917: -- Document Subtype - 'STANDARD', 'CONTRACT', 'BLANKET' etc

2913: -- Valid values 'SIGNED', 'BUYER REJECTED', 'SUPPLIER REJECTED'
2914: --p_object_type_code
2915: -- Document type - 'PO', 'PA' etc
2916: --p_object_subtype_code
2917: -- Document Subtype - 'STANDARD', 'CONTRACT', 'BLANKET' etc
2918: --p_employee_id
2919: -- Employee Id of the Buyer
2920: --p_revision_num
2921: -- Revision Number of the document

Line 2976: AND shipment_type IN ('STANDARD','BLANKET','SCHEDULED','PREPAYMENT')

2972: WHERE po_header_id = p_po_header_id
2973: AND NVL(cancel_flag,'N') = 'N'
2974: AND NVL(closed_code,'OPEN') <> 'FINALLY CLOSED'
2975: -- : Include PREPAYMENT shipment_type
2976: AND shipment_type IN ('STANDARD','BLANKET','SCHEDULED','PREPAYMENT')
2977: AND NVL(approved_flag,'N') <> 'Y';
2978:
2979: -- Bug 7494807 END
2980:

Line 3024: -- If we are setting the standard PO's status to Approved, call the FTE API

3020: , p_employee_id => p_employee_id -- bug3738420
3021: );
3022:
3023: -- Bug 3602512 START
3024: -- If we are setting the standard PO's status to Approved, call the FTE API
3025: -- to update the Inbound Logistics delivery records.
3026:
3027: d_pos := 10;
3028: IF (PO_LOG.d_stmt) THEN

Line 3035: AND (p_object_subtype_code = 'STANDARD')) THEN

3031: END IF;
3032:
3033: IF (p_status = 'APPROVED')
3034: AND ((p_object_type_code = 'PO')
3035: AND (p_object_subtype_code = 'STANDARD')) THEN
3036: -- Note: Signatures are not supported for blanket releases.
3037:
3038: --Start of code changes for the bug 13507482. Inserting MTL_SUPPLY record when the Buyer/Supplier Accepts the PO.
3039: BEGIN

Line 3151: -- Document Subtype - 'STANDARD', 'CONTRACT', 'BLANKET' etc

3147: -- Valid values 'SIGNED', 'BUYER REJECTED', 'SUPPLIER REJECTED'
3148: --p_object_type_code
3149: -- Document type - 'PO', 'PA' etc
3150: --p_object_subtype_code
3151: -- Document Subtype - 'STANDARD', 'CONTRACT', 'BLANKET' etc
3152: --p_employee_id
3153: -- Employee Id of the Buyer
3154: --p_revision_num
3155: -- Revision Number of the document

Line 3769: -- PO for Standard/Planned POs

3765:
3766: -- bug 3568077
3767: -- PO_ACTION_HISTORY.object_type_code is:
3768: -- PA for Contracts and BPAs
3769: -- PO for Standard/Planned POs
3770:
3771: SELECT
3772: Type_Lookup_Code
3773: , DECODE( type_lookup_code

Line 4247: -- Standard parameter to be used in a workflow procedure

4243: -- Called from PO Approval workflow.
4244: --Parameters:
4245: --IN:
4246: --itemtype
4247: -- Standard parameter to be used in a workflow procedure
4248: --itemkey
4249: -- Standard parameter to be used in a workflow procedure
4250: --actid
4251: -- Standard parameter to be used in a workflow procedure

Line 4249: -- Standard parameter to be used in a workflow procedure

4245: --IN:
4246: --itemtype
4247: -- Standard parameter to be used in a workflow procedure
4248: --itemkey
4249: -- Standard parameter to be used in a workflow procedure
4250: --actid
4251: -- Standard parameter to be used in a workflow procedure
4252: --funcmode
4253: -- Standard parameter to be used in a workflow procedure

Line 4251: -- Standard parameter to be used in a workflow procedure

4247: -- Standard parameter to be used in a workflow procedure
4248: --itemkey
4249: -- Standard parameter to be used in a workflow procedure
4250: --actid
4251: -- Standard parameter to be used in a workflow procedure
4252: --funcmode
4253: -- Standard parameter to be used in a workflow procedure
4254: --OUT:
4255: --resultout

Line 4253: -- Standard parameter to be used in a workflow procedure

4249: -- Standard parameter to be used in a workflow procedure
4250: --actid
4251: -- Standard parameter to be used in a workflow procedure
4252: --funcmode
4253: -- Standard parameter to be used in a workflow procedure
4254: --OUT:
4255: --resultout
4256: -- Standard parameter to be used in a workflow procedure
4257:

Line 4256: -- Standard parameter to be used in a workflow procedure

4252: --funcmode
4253: -- Standard parameter to be used in a workflow procedure
4254: --OUT:
4255: --resultout
4256: -- Standard parameter to be used in a workflow procedure
4257:
4258: --End of Comments
4259: -------------------------------------------------------------------------------
4260: PROCEDURE Has_Doc_Been_Signed(itemtype IN VARCHAR2,

Line 4377: -- Standard parameter to be used in a workflow procedure

4373: -- Returns the acceptance mode of the document
4374: --Parameters:
4375: --IN:
4376: --p_itemtype
4377: -- Standard parameter to be used in a workflow procedure
4378: --p_itemkey
4379: -- Standard parameter to be used in a workflow procedure
4380: --Returns:
4381: -- 'SIGNATURE' or 'PROXY_SIGNATURE' as the acceptance mode values

Line 4379: -- Standard parameter to be used in a workflow procedure

4375: --IN:
4376: --p_itemtype
4377: -- Standard parameter to be used in a workflow procedure
4378: --p_itemkey
4379: -- Standard parameter to be used in a workflow procedure
4380: --Returns:
4381: -- 'SIGNATURE' or 'PROXY_SIGNATURE' as the acceptance mode values
4382: --Testing:
4383: -- N/A

Line 4508: -- Standard parameter to be used in a workflow procedure

4504: -- Called from PO Approval workflow.
4505: --Parameters:
4506: --IN:
4507: --itemtype
4508: -- Standard parameter to be used in a workflow procedure
4509: --itemkey
4510: -- Standard parameter to be used in a workflow procedure
4511: --actid
4512: -- Standard parameter to be used in a workflow procedure

Line 4510: -- Standard parameter to be used in a workflow procedure

4506: --IN:
4507: --itemtype
4508: -- Standard parameter to be used in a workflow procedure
4509: --itemkey
4510: -- Standard parameter to be used in a workflow procedure
4511: --actid
4512: -- Standard parameter to be used in a workflow procedure
4513: --funcmode
4514: -- Standard parameter to be used in a workflow procedure

Line 4512: -- Standard parameter to be used in a workflow procedure

4508: -- Standard parameter to be used in a workflow procedure
4509: --itemkey
4510: -- Standard parameter to be used in a workflow procedure
4511: --actid
4512: -- Standard parameter to be used in a workflow procedure
4513: --funcmode
4514: -- Standard parameter to be used in a workflow procedure
4515: --OUT:
4516: --resultout

Line 4514: -- Standard parameter to be used in a workflow procedure

4510: -- Standard parameter to be used in a workflow procedure
4511: --actid
4512: -- Standard parameter to be used in a workflow procedure
4513: --funcmode
4514: -- Standard parameter to be used in a workflow procedure
4515: --OUT:
4516: --resultout
4517: -- Standard parameter to be used in a workflow procedure
4518: --End of Comments

Line 4517: -- Standard parameter to be used in a workflow procedure

4513: --funcmode
4514: -- Standard parameter to be used in a workflow procedure
4515: --OUT:
4516: --resultout
4517: -- Standard parameter to be used in a workflow procedure
4518: --End of Comments
4519: -------------------------------------------------------------------------------
4520: PROCEDURE is_ko_signature_required(itemtype IN VARCHAR2,
4521: itemkey IN VARCHAR2,

Line 4603: -- Standard parameter to be used in a workflow procedure

4599: -- Called from PO Approval workflow.
4600: --Parameters:
4601: --IN:
4602: --itemtype
4603: -- Standard parameter to be used in a workflow procedure
4604: --itemkey
4605: -- Standard parameter to be used in a workflow procedure
4606: --actid
4607: -- Standard parameter to be used in a workflow procedure

Line 4605: -- Standard parameter to be used in a workflow procedure

4601: --IN:
4602: --itemtype
4603: -- Standard parameter to be used in a workflow procedure
4604: --itemkey
4605: -- Standard parameter to be used in a workflow procedure
4606: --actid
4607: -- Standard parameter to be used in a workflow procedure
4608: --funcmode
4609: -- Standard parameter to be used in a workflow procedure

Line 4607: -- Standard parameter to be used in a workflow procedure

4603: -- Standard parameter to be used in a workflow procedure
4604: --itemkey
4605: -- Standard parameter to be used in a workflow procedure
4606: --actid
4607: -- Standard parameter to be used in a workflow procedure
4608: --funcmode
4609: -- Standard parameter to be used in a workflow procedure
4610: --OUT:
4611: --resultout

Line 4609: -- Standard parameter to be used in a workflow procedure

4605: -- Standard parameter to be used in a workflow procedure
4606: --actid
4607: -- Standard parameter to be used in a workflow procedure
4608: --funcmode
4609: -- Standard parameter to be used in a workflow procedure
4610: --OUT:
4611: --resultout
4612: -- Standard parameter to be used in a workflow procedure
4613: --Testing:

Line 4612: -- Standard parameter to be used in a workflow procedure

4608: --funcmode
4609: -- Standard parameter to be used in a workflow procedure
4610: --OUT:
4611: --resultout
4612: -- Standard parameter to be used in a workflow procedure
4613: --Testing:
4614: -- Testing to be done based on the test cases in Document Binding DLD
4615: --End of Comments
4616: -------------------------------------------------------------------------------

Line 4768: -- Standard parameter to be used in a workflow procedure

4764: -- Called from PO Approval workflow.
4765: --Parameters:
4766: --IN:
4767: --itemtype
4768: -- Standard parameter to be used in a workflow procedure
4769: --itemkey
4770: -- Standard parameter to be used in a workflow procedure
4771: --actid
4772: -- Standard parameter to be used in a workflow procedure

Line 4770: -- Standard parameter to be used in a workflow procedure

4766: --IN:
4767: --itemtype
4768: -- Standard parameter to be used in a workflow procedure
4769: --itemkey
4770: -- Standard parameter to be used in a workflow procedure
4771: --actid
4772: -- Standard parameter to be used in a workflow procedure
4773: --funcmode
4774: -- Standard parameter to be used in a workflow procedure

Line 4772: -- Standard parameter to be used in a workflow procedure

4768: -- Standard parameter to be used in a workflow procedure
4769: --itemkey
4770: -- Standard parameter to be used in a workflow procedure
4771: --actid
4772: -- Standard parameter to be used in a workflow procedure
4773: --funcmode
4774: -- Standard parameter to be used in a workflow procedure
4775: --OUT:
4776: --resultout

Line 4774: -- Standard parameter to be used in a workflow procedure

4770: -- Standard parameter to be used in a workflow procedure
4771: --actid
4772: -- Standard parameter to be used in a workflow procedure
4773: --funcmode
4774: -- Standard parameter to be used in a workflow procedure
4775: --OUT:
4776: --resultout
4777: -- Standard parameter to be used in a workflow procedure
4778: --Testing:

Line 4777: -- Standard parameter to be used in a workflow procedure

4773: --funcmode
4774: -- Standard parameter to be used in a workflow procedure
4775: --OUT:
4776: --resultout
4777: -- Standard parameter to be used in a workflow procedure
4778: --Testing:
4779: -- Testing to be done based on the test cases in Document Binding DLD
4780: --End of Comments
4781: -------------------------------------------------------------------------------

Line 4878: -- Standard parameter to be used in a workflow procedure

4874: -- Called from PO Approval workflow.
4875: --Parameters:
4876: --IN:
4877: --itemtype
4878: -- Standard parameter to be used in a workflow procedure
4879: --itemkey
4880: -- Standard parameter to be used in a workflow procedure
4881: --actid
4882: -- Standard parameter to be used in a workflow procedure

Line 4880: -- Standard parameter to be used in a workflow procedure

4876: --IN:
4877: --itemtype
4878: -- Standard parameter to be used in a workflow procedure
4879: --itemkey
4880: -- Standard parameter to be used in a workflow procedure
4881: --actid
4882: -- Standard parameter to be used in a workflow procedure
4883: --funcmode
4884: -- Standard parameter to be used in a workflow procedure

Line 4882: -- Standard parameter to be used in a workflow procedure

4878: -- Standard parameter to be used in a workflow procedure
4879: --itemkey
4880: -- Standard parameter to be used in a workflow procedure
4881: --actid
4882: -- Standard parameter to be used in a workflow procedure
4883: --funcmode
4884: -- Standard parameter to be used in a workflow procedure
4885: --OUT:
4886: --resultout

Line 4884: -- Standard parameter to be used in a workflow procedure

4880: -- Standard parameter to be used in a workflow procedure
4881: --actid
4882: -- Standard parameter to be used in a workflow procedure
4883: --funcmode
4884: -- Standard parameter to be used in a workflow procedure
4885: --OUT:
4886: --resultout
4887: -- Standard parameter to be used in a workflow procedure
4888: --End of Comments

Line 4887: -- Standard parameter to be used in a workflow procedure

4883: --funcmode
4884: -- Standard parameter to be used in a workflow procedure
4885: --OUT:
4886: --resultout
4887: -- Standard parameter to be used in a workflow procedure
4888: --End of Comments
4889: -------------------------------------------------------------------------------
4890: PROCEDURE Check_Warrant_for_KO(itemtype IN VARCHAR2,
4891: itemkey IN VARCHAR2,