DBA Data[Home] [Help]

APPS.POR_AME_REQ_WF_PVT dependencies on STANDARD

Line 53: -- Standard workflow IN parameters

49: -- And update workflow attributes.
50: -- If no next approver is found, approval routing will terminate.
51: --Parameters:
52: --IN:
53: -- Standard workflow IN parameters
54: --OUT:
55: -- Standard workflow OUT parameters
56: --Testing:
57: --

Line 55: -- Standard workflow OUT parameters

51: --Parameters:
52: --IN:
53: -- Standard workflow IN parameters
54: --OUT:
55: -- Standard workflow OUT parameters
56: --Testing:
57: --
58: --End of Comments
59: -------------------------------------------------------------------------------

Line 281: -- Standard workflow IN parameters

277: -- retrieved, will be alphabetically sorted using last_name and to the first user notification will be sent.
278: --
279: --Parameters:
280: --IN:
281: -- Standard workflow IN parameters
282: --OUT:
283: -- Standard workflow OUT parameters
284: --Testing:
285: --

Line 283: -- Standard workflow OUT parameters

279: --Parameters:
280: --IN:
281: -- Standard workflow IN parameters
282: --OUT:
283: -- Standard workflow OUT parameters
284: --Testing:
285: --
286: --End of Comments
287: -------------------------------------------------------------------------------

Line 981: -- Standard workflow IN parameters

977: --Function:
978: -- Workflow activity PL/SQL handler. This procedure is used to inform AME about the approvers response.
979: --Parameters:
980: --IN:
981: -- Standard workflow IN parameters
982: --OUT:
983: -- Standard workflow OUT parameters
984: --Testing:
985: --

Line 983: -- Standard workflow OUT parameters

979: --Parameters:
980: --IN:
981: -- Standard workflow IN parameters
982: --OUT:
983: -- Standard workflow OUT parameters
984: --Testing:
985: --
986: --End of Comments
987: -------------------------------------------------------------------------------

Line 1187: -- Standard workflow IN parameters

1183: -- action history table in the case of approvers being beat by first
1184: -- responder.
1185: --Parameters:
1186: --IN:
1187: -- Standard workflow IN parameters
1188: --OUT:
1189: -- Standard workflow OUT parameters
1190: --Testing:
1191: --

Line 1189: -- Standard workflow OUT parameters

1185: --Parameters:
1186: --IN:
1187: -- Standard workflow IN parameters
1188: --OUT:
1189: -- Standard workflow OUT parameters
1190: --Testing:
1191: --
1192: --End of Comments
1193: -------------------------------------------------------------------------------

Line 1608: -- Standard workflow IN parameters

1604: -- Workflow activity PL/SQL handler.
1605: -- This procedure is the wrapper procedure of Process_Response_Internal()
1606: --Parameters:
1607: --IN:
1608: -- Standard workflow IN parameters
1609: --OUT:
1610: -- Standard workflow OUT parameters
1611: --Testing:
1612: --

Line 1610: -- Standard workflow OUT parameters

1606: --Parameters:
1607: --IN:
1608: -- Standard workflow IN parameters
1609: --OUT:
1610: -- Standard workflow OUT parameters
1611: --Testing:
1612: --
1613: --End of Comments
1614: -------------------------------------------------------------------------------

Line 1715: -- Standard workflow IN parameters

1711: -- Workflow activity PL/SQL handler.
1712: -- This procedure is the wrapper procedure of Process_Response_Internal()
1713: --Parameters:
1714: --IN:
1715: -- Standard workflow IN parameters
1716: --OUT:
1717: -- Standard workflow OUT parameters
1718: --Testing:
1719: --

Line 1717: -- Standard workflow OUT parameters

1713: --Parameters:
1714: --IN:
1715: -- Standard workflow IN parameters
1716: --OUT:
1717: -- Standard workflow OUT parameters
1718: --Testing:
1719: --
1720: --End of Comments
1721: -------------------------------------------------------------------------------

Line 1829: -- Standard workflow IN parameters

1825: -- Workflow activity PL/SQL handler.
1826: -- This procedure is the wrapper procedure of Process_Response_Internal()
1827: --Parameters:
1828: --IN:
1829: -- Standard workflow IN parameters
1830: --OUT:
1831: -- Standard workflow OUT parameters
1832: --Testing:
1833: --

Line 1831: -- Standard workflow OUT parameters

1827: --Parameters:
1828: --IN:
1829: -- Standard workflow IN parameters
1830: --OUT:
1831: -- Standard workflow OUT parameters
1832: --Testing:
1833: --
1834: --End of Comments
1835: -------------------------------------------------------------------------------

Line 1949: -- Standard workflow IN parameters

1945: -- Workflow activity PL/SQL handler.
1946: -- This procedure is the wrapper procedure of Process_Response_Internal()
1947: --Parameters:
1948: --IN:
1949: -- Standard workflow IN parameters
1950: --OUT:
1951: -- Standard workflow OUT parameters
1952: --Testing:
1953: --

Line 1951: -- Standard workflow OUT parameters

1947: --Parameters:
1948: --IN:
1949: -- Standard workflow IN parameters
1950: --OUT:
1951: -- Standard workflow OUT parameters
1952: --Testing:
1953: --
1954: --End of Comments
1955: -------------------------------------------------------------------------------

Line 2057: -- Standard workflow IN parameters

2053: -- Workflow activity PL/SQL handler.
2054: -- This procedure is the wrapper procedure of Process_Response_Internal()
2055: --Parameters:
2056: --IN:
2057: -- Standard workflow IN parameters
2058: --OUT:
2059: -- Standard workflow OUT parameters
2060: --Testing:
2061: --

Line 2059: -- Standard workflow OUT parameters

2055: --Parameters:
2056: --IN:
2057: -- Standard workflow IN parameters
2058: --OUT:
2059: -- Standard workflow OUT parameters
2060: --Testing:
2061: --
2062: --End of Comments
2063: -------------------------------------------------------------------------------

Line 2169: -- Standard workflow OUT parameters

2165: -- Requistion Header Id
2166: -- Employee Id
2167: -- Approver Group Id
2168: --OUT:
2169: -- Standard workflow OUT parameters
2170: --Testing:
2171: --
2172: --End of Comments
2173: -------------------------------------------------------------------------------

Line 2250: -- Standard workflow IN parameters

2246: -- Workflow activity PL/SQL handler.
2247: -- This procedure is the wrapper procedure of insertActionHistory()
2248: --Parameters:
2249: --IN:
2250: -- Standard workflow IN parameters
2251: --OUT:
2252: -- Standard workflow OUT parameters
2253: --Testing:
2254: --

Line 2252: -- Standard workflow OUT parameters

2248: --Parameters:
2249: --IN:
2250: -- Standard workflow IN parameters
2251: --OUT:
2252: -- Standard workflow OUT parameters
2253: --Testing:
2254: --
2255: --End of Comments
2256: -------------------------------------------------------------------------------

Line 2405: -- Standard workflow IN parameters

2401: -- Workflow activity PL/SQL handler.
2402: -- This procedure updates the po_action_history table based on the approvers response.
2403: --Parameters:
2404: --IN:
2405: -- Standard workflow IN parameters
2406: --OUT:
2407: -- Standard workflow OUT parameters
2408: --Testing:
2409: --

Line 2407: -- Standard workflow OUT parameters

2403: --Parameters:
2404: --IN:
2405: -- Standard workflow IN parameters
2406: --OUT:
2407: -- Standard workflow OUT parameters
2408: --Testing:
2409: --
2410: --End of Comments
2411: -------------------------------------------------------------------------------

Line 2556: -- Standard workflow IN parameters

2552: -- Workflow activity PL/SQL handler.
2553: -- This procedure updates the po_action_history table based on the approvers response.
2554: --Parameters:
2555: --IN:
2556: -- Standard workflow IN parameters
2557: --OUT:
2558: -- Standard workflow OUT parameters
2559: --Testing:
2560: --

Line 2558: -- Standard workflow OUT parameters

2554: --Parameters:
2555: --IN:
2556: -- Standard workflow IN parameters
2557: --OUT:
2558: -- Standard workflow OUT parameters
2559: --Testing:
2560: --
2561: --End of Comments
2562: -------------------------------------------------------------------------------

Line 2706: -- Standard workflow IN parameters

2702: -- Workflow activity PL/SQL handler.
2703: -- This procedure updates the po_action_history table based on the approvers response.
2704: --Parameters:
2705: --IN:
2706: -- Standard workflow IN parameters
2707: --OUT:
2708: -- Standard workflow OUT parameters
2709: --Testing:
2710: --

Line 2708: -- Standard workflow OUT parameters

2704: --Parameters:
2705: --IN:
2706: -- Standard workflow IN parameters
2707: --OUT:
2708: -- Standard workflow OUT parameters
2709: --Testing:
2710: --
2711: --End of Comments
2712: -------------------------------------------------------------------------------

Line 2849: -- Standard workflow IN parameters

2845: -- Workflow activity PL/SQL handler.
2846: -- This procedure updates the po_action_history table based on the approvers response.
2847: --Parameters:
2848: --IN:
2849: -- Standard workflow IN parameters
2850: --OUT:
2851: -- Standard workflow OUT parameters
2852: --Testing:
2853: --

Line 2851: -- Standard workflow OUT parameters

2847: --Parameters:
2848: --IN:
2849: -- Standard workflow IN parameters
2850: --OUT:
2851: -- Standard workflow OUT parameters
2852: --Testing:
2853: --
2854: --End of Comments
2855: -------------------------------------------------------------------------------

Line 2994: -- Standard workflow IN parameters

2990: -- Workflow activity PL/SQL handler.
2991: -- If it is a first responder wins setup in ame, then once the first reponder wins, others will not be able to take decisions.
2992: --Parameters:
2993: --IN:
2994: -- Standard workflow IN parameters
2995: --OUT:
2996: -- Standard workflow OUT parameters
2997: --Testing:
2998: --

Line 2996: -- Standard workflow OUT parameters

2992: --Parameters:
2993: --IN:
2994: -- Standard workflow IN parameters
2995: --OUT:
2996: -- Standard workflow OUT parameters
2997: --Testing:
2998: --
2999: --End of Comments
3000: -------------------------------------------------------------------------------

Line 3162: -- Standard workflow IN parameters

3158: -- and it returns 'Y'.
3159: -- Else it will return 'N'
3160: --Parameters:
3161: --IN:
3162: -- Standard workflow IN parameters
3163: --OUT:
3164: -- Standard workflow OUT parameters
3165: --Testing:
3166: --

Line 3164: -- Standard workflow OUT parameters

3160: --Parameters:
3161: --IN:
3162: -- Standard workflow IN parameters
3163: --OUT:
3164: -- Standard workflow OUT parameters
3165: --Testing:
3166: --
3167: --End of Comments
3168: -------------------------------------------------------------------------------

Line 3425: -- Standard workflow OUT parameters

3421: -- Requistion Header Id
3422: -- Employee Id
3423: -- Approver Group Id
3424: --OUT:
3425: -- Standard workflow OUT parameters
3426: --Testing:
3427: --
3428: --End of Comments
3429: -------------------------------------------------------------------------------

Line 3464: AND object_sub_type_code = p_document_subtype --'STANDARD'

3460: SELECT max(sequence_num)
3461: INTO l_sequence_num
3462: FROM PO_ACTION_HISTORY
3463: WHERE object_type_code = p_document_type --'PO'
3464: AND object_sub_type_code = p_document_subtype --'STANDARD'
3465: AND object_id = p_document_id;
3466:
3467: --Bug 12944203
3468: /*

Line 3474: AND object_sub_type_code = p_document_subtype --'STANDARD'

3470: SELECT 'Y'
3471: INTO l_record_exists
3472: FROM PO_ACTION_HISTORY
3473: WHERE object_type_code = p_document_type --'PO'
3474: AND object_sub_type_code = p_document_subtype --'STANDARD'
3475: AND object_id = p_document_id
3476: AND action_code is null;
3477: EXCEPTION
3478: WHEN no_data_found THEN

Line 3490: AND object_sub_type_code = p_document_subtype --'STANDARD'

3486: l_object_revision_num, l_approval_path_id, l_request_id,
3487: l_program_application_id, l_program_date, l_program_id
3488: FROM PO_ACTION_HISTORY
3489: WHERE object_type_code = p_document_type --'PO'
3490: AND object_sub_type_code = p_document_subtype --'STANDARD'
3491: AND object_id = p_document_id
3492: AND sequence_num = l_sequence_num;
3493:
3494: else

Line 3510: AND object_sub_type_code = 'MODIFICATION' --'STANDARD'

3506: SELECT 'Y'
3507: INTO l_record_exists
3508: FROM PO_ACTION_HISTORY
3509: WHERE object_type_code = p_document_type --'PO'
3510: AND object_sub_type_code = 'MODIFICATION' --'STANDARD'
3511: AND object_id = p_draft_id
3512: AND action_code is null;
3513: EXCEPTION
3514: WHEN no_data_found THEN

Line 3707: -- Standard workflow IN parameters

3703: -- Workflow activity PL/SQL handler.
3704: -- This procedure is the wrapper procedure of Process_Response_Internal()
3705: --Parameters:
3706: --IN:
3707: -- Standard workflow IN parameters
3708: --OUT:
3709: -- Standard workflow OUT parameters
3710: --Testing:
3711: --

Line 3709: -- Standard workflow OUT parameters

3705: --Parameters:
3706: --IN:
3707: -- Standard workflow IN parameters
3708: --OUT:
3709: -- Standard workflow OUT parameters
3710: --Testing:
3711: --
3712: --End of Comments
3713: -------------------------------------------------------------------------------