[Home] [Help]
PACKAGE: APPS.OE_APPROVALS_WF
Source
1 PACKAGE OE_APPROVALS_WF AUTHID CURRENT_USER AS
2 /* $Header: OEXWAPRS.pls 120.0.12020000.4 2013/03/25 08:52:07 spothula ship $ */
3
4 -- Start of Comments
5 -- API name OE_APPROVALS_WF
6 -- Type Public
7 -- Version Current version = 1.0
8 -- Initial version = 1.0
9
10
11 Procedure Initiate_Approval
12 (itemtype in varchar2,
13 itemkey in varchar2,
14 actid in number,
15 funcmode in varchar2,
16 resultout in out NOCOPY /* file.sql.39 change */ varchar2);
17
18 Procedure Get_Next_Approver
19 (itemtype in varchar2,
20 itemkey in varchar2,
21 actid in number,
22 funcmode in varchar2,
23 resultout in out NOCOPY /* file.sql.39 change */ varchar2);
24
25 function Get_Next_Approver_internal
26 (
27 p_transaction_id in NUMBER,
28 p_itemtype in VARCHAR2,
29 p_sales_document_type_code in VARCHAR2,
30 p_query_mode in VARCHAR2 default 'N'
31 )
32 return VARCHAR2;
33
34 Procedure Reject_Approval
35 (itemtype in varchar2,
36 itemkey in varchar2,
37 actid in number,
38 funcmode in varchar2,
39 resultout in out NOCOPY /* file.sql.39 change */ varchar2);
40
41 Procedure Approval_Timeout
42 (itemtype in varchar2,
43 itemkey in varchar2,
44 actid in number,
45 funcmode in varchar2,
46 resultout in out NOCOPY /* file.sql.39 change */ varchar2);
47
48 Procedure Approve_Approval
49 (itemtype in varchar2,
50 itemkey in varchar2,
51 actid in number,
52 funcmode in varchar2,
53 resultout in out NOCOPY /* file.sql.39 change */ varchar2);
54
55 Procedure Get_Current_Approver
56 (document_id in varchar2,
57 display_type in varchar2,
58 document in out NOCOPY /* file.sql.39 change */ varchar2,
59 document_type in out NOCOPY /* file.sql.39 change */ varchar2);
60
61 function Get_Current_Approver_internal
62 (
63 p_transaction_id in NUMBER
64 )
65 return VARCHAR2;
66
67
68 Procedure Get_Sales_Document_Type
69 (document_id in varchar2,
70 display_type in varchar2,
71 document in out NOCOPY /* file.sql.39 change */ varchar2,
72 document_type in out NOCOPY /* file.sql.39 change */ varchar2);
73
74 -- Added for AME ER 16084377
75 PROCEDURE get_ame_approvers_launch (
76 itemtype IN VARCHAR2,
77 itemkey IN VARCHAR2,
78 actid IN NUMBER,
79 funcmode IN VARCHAR2,
80 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 );
82 PROCEDURE is_ame_exception (
83 itemtype IN VARCHAR2,
84 itemkey IN VARCHAR2,
85 actid IN NUMBER,
86 funcmode IN VARCHAR2,
87 resultout OUT NOCOPY VARCHAR2
88 );
89 PROCEDURE check_parallel_wf_status (
90 itemtype IN VARCHAR2,
91 itemkey IN VARCHAR2,
92 actid IN NUMBER,
93 funcmode IN VARCHAR2,
94 resultout OUT NOCOPY VARCHAR2
95 );
96 PROCEDURE treat_ame_exception_as (
97 itemtype IN VARCHAR2,
98 itemkey IN VARCHAR2,
99 actid IN NUMBER,
100 funcmode IN VARCHAR2,
101 resultout OUT NOCOPY VARCHAR2
102 );
103 PROCEDURE get_notification_attributes (
104 itemtype IN VARCHAR2,
105 itemkey IN VARCHAR2,
106 actid IN NUMBER,
107 funcmode IN VARCHAR2,
108 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
109 );
110 PROCEDURE process_response_approve (
111 itemtype IN VARCHAR2,
112 itemkey IN VARCHAR2,
113 actid IN NUMBER,
114 funcmode IN VARCHAR2,
115 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
116 );
117 PROCEDURE process_response_reject (
118 itemtype IN VARCHAR2,
119 itemkey IN VARCHAR2,
120 actid IN NUMBER,
121 funcmode IN VARCHAR2,
122 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
123 );
124 PROCEDURE process_beat_by_first (
125 itemtype IN VARCHAR2,
126 itemkey IN VARCHAR2,
127 actid IN NUMBER,
128 funcmode IN VARCHAR2,
129 resultout OUT NOCOPY VARCHAR2
130 );
131 PROCEDURE use_ame_approval (
132 itemtype IN VARCHAR2,
133 itemkey IN VARCHAR2,
134 actid IN NUMBER,
135 funcmode IN VARCHAR2,
136 resultout OUT NOCOPY VARCHAR2
137 );
138 PROCEDURE push_block_activity (
139 itemtype IN VARCHAR2,
140 itemkey IN VARCHAR2,
141 actid IN NUMBER,
142 funcmode IN VARCHAR2,
143 resultout OUT NOCOPY VARCHAR2
144 );
145 PROCEDURE approval_timeout_ame (
146 itemtype IN VARCHAR2,
147 itemkey IN VARCHAR2,
148 actid IN NUMBER,
149 funcmode IN VARCHAR2,
150 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
151 );
152 g_ame_used VARCHAR2(1) :='N';
153 g_current_item_key VARCHAR2(250) ;
154
155 FUNCTION get_order_total(p_header_id IN NUMBER)
156 RETURN NUMBER;
157
158 FUNCTION get_customer_category (p_header_id IN NUMBER,p_ame_type IN VARCHAR2)
159 RETURN VARCHAR2;
160 -- END Added for AME ER 16084377
161
162
163 END OE_APPROVALS_WF;