[Home] [Help]
PACKAGE: APPS.PO_AME_WF_PVT
Source
1 PACKAGE PO_AME_WF_PVT AUTHID CURRENT_USER AS
2 -- $Header: PO_AME_WF_PVT.pls 120.1.12020000.1 2013/02/12 08:03:28 vegajula noship $
3
4 applicationId NUMBER :=201; /* ame is using PO id */
5
6
7 PROCEDURE get_next_approvers(
8 itemtype IN VARCHAR2,
9 itemkey IN VARCHAR2,
10 actid IN NUMBER,
11 funcmode IN VARCHAR2,
12 resultout OUT NOCOPY VARCHAR2);
13
14 PROCEDURE launch_parallel_approval(
15 itemtype IN VARCHAR2,
16 itemkey IN VARCHAR2,
17 actid IN NUMBER,
18 funcmode IN VARCHAR2,
19 resultout OUT NOCOPY VARCHAR2);
20
21 PROCEDURE determine_approver_category(
22 itemtype IN VARCHAR2,
23 itemkey IN VARCHAR2,
24 actid IN NUMBER,
25 funcmode IN VARCHAR2,
26 resultout OUT NOCOPY VARCHAR2);
27
28 PROCEDURE update_action_history_forward(
29 itemtype IN VARCHAR2,
30 itemkey IN VARCHAR2,
31 actid IN NUMBER,
32 funcmode IN VARCHAR2,
33 resultout OUT NOCOPY VARCHAR2);
34
35 PROCEDURE update_action_history_approve(
36 itemtype IN VARCHAR2,
37 itemkey IN VARCHAR2,
38 actid IN NUMBER,
39 funcmode IN VARCHAR2,
40 resultout OUT NOCOPY VARCHAR2);
41
42 PROCEDURE update_action_history_reject(
43 itemtype IN VARCHAR2,
44 itemkey IN VARCHAR2,
45 actid IN NUMBER,
46 funcmode IN VARCHAR2,
47 resultout OUT NOCOPY VARCHAR2);
48
49 PROCEDURE update_action_history_timeout(
50 itemtype IN VARCHAR2,
51 itemkey IN VARCHAR2,
52 actid IN NUMBER,
53 funcmode IN VARCHAR2,
54 resultout OUT NOCOPY VARCHAR2);
55
56 PROCEDURE insert_action_history(
57 itemtype IN VARCHAR2,
58 itemkey IN VARCHAR2,
59 actid IN NUMBER,
60 funcmode IN VARCHAR2,
61 resultout OUT NOCOPY VARCHAR2);
62
63 PROCEDURE process_response_exception(
64 itemtype IN VARCHAR2,
65 itemkey IN VARCHAR2,
66 actid IN NUMBER,
67 funcmode IN VARCHAR2,
68 resultout OUT NOCOPY VARCHAR2);
69
70 PROCEDURE process_response_app_forward(
71 itemtype IN VARCHAR2,
72 itemkey IN VARCHAR2,
73 actid IN NUMBER,
74 funcmode IN VARCHAR2,
75 resultout OUT NOCOPY VARCHAR2);
76
77 PROCEDURE process_response_approve(
78 itemtype IN VARCHAR2,
79 itemkey IN VARCHAR2,
80 actid IN NUMBER,
81 funcmode IN VARCHAR2,
82 resultout OUT NOCOPY VARCHAR2);
83
84 PROCEDURE process_response_timeout(
85 itemtype IN VARCHAR2,
86 itemkey IN VARCHAR2,
87 actid IN NUMBER,
88 funcmode IN VARCHAR2,
89 resultout OUT NOCOPY VARCHAR2);
90
91 PROCEDURE process_response_forward(
92 itemtype IN VARCHAR2,
93 itemkey IN VARCHAR2,
94 actid IN NUMBER,
95 funcmode IN VARCHAR2,
96 resultout OUT NOCOPY VARCHAR2);
97
98 PROCEDURE process_response_reject(
99 itemtype IN VARCHAR2,
100 itemkey IN VARCHAR2,
101 actid IN NUMBER,
102 funcmode IN VARCHAR2,
103 resultout OUT NOCOPY VARCHAR2);
104
105 PROCEDURE increment_no_reminder_attr(
106 itemtype IN VARCHAR2,
107 itemkey IN VARCHAR2,
108 actid IN NUMBER,
109 funcmode IN VARCHAR2,
110 resultout OUT NOCOPY VARCHAR2);
111
112 PROCEDURE post_approval_notif(
113 itemtype IN VARCHAR2,
114 itemkey IN VARCHAR2,
115 actid IN NUMBER,
116 funcmode IN VARCHAR2,
117 resultout OUT NOCOPY VARCHAR2);
118
119 PROCEDURE generate_pdf_ame_supp(
120 itemtype IN VARCHAR2,
121 itemkey IN VARCHAR2,
122 actid IN NUMBER,
123 funcmode IN VARCHAR2,
124 resultout OUT NOCOPY VARCHAR2);
125
126 PROCEDURE generate_pdf_ame_buyer(
127 itemtype IN VARCHAR2,
128 itemkey IN VARCHAR2,
129 actid IN NUMBER,
130 funcmode IN VARCHAR2,
131 resultout OUT NOCOPY VARCHAR2);
132
133 PROCEDURE forward_unable_to_reserve(
134 itemtype IN VARCHAR2,
135 itemkey IN VARCHAR2,
136 actid IN NUMBER,
137 funcmode IN VARCHAR2,
138 resultout OUT NOCOPY VARCHAR2);
139
140 PROCEDURE process_beat_by_first(
141 itemtype IN VARCHAR2,
142 itemkey IN VARCHAR2,
143 actid IN NUMBER,
144 funcmode IN VARCHAR2,
145 resultout OUT NOCOPY VARCHAR2);
146
147 PROCEDURE is_ame_exception(
148 itemtype IN VARCHAR2,
149 itemkey IN VARCHAR2,
150 actid IN NUMBER,
151 funcmode IN VARCHAR2,
152 resultout OUT NOCOPY VARCHAR2);
153
154 PROCEDURE update_resp_verf_failed(
155 itemtype IN VARCHAR2,
156 itemkey IN VARCHAR2,
157 actid IN NUMBER,
158 funcmode IN VARCHAR2,
159 resultout OUT NOCOPY VARCHAR2);
160
161 PROCEDURE update_resp_verf_failed_reject(
162 itemtype IN VARCHAR2,
163 itemkey IN VARCHAR2,
164 actid IN NUMBER,
165 funcmode IN VARCHAR2,
166 resultout OUT NOCOPY VARCHAR2);
167
168 PROCEDURE get_ame_sub_approval_response(
169 itemtype IN VARCHAR2,
170 itemkey IN VARCHAR2,
171 actid IN NUMBER,
172 funcmode IN VARCHAR2,
173 resultout OUT NOCOPY VARCHAR2);
174
175 PROCEDURE update_action_history_reminder(
176 itemtype IN VARCHAR2,
177 itemkey IN VARCHAR2,
178 actid IN NUMBER,
179 funcmode IN VARCHAR2,
180 resultout OUT NOCOPY VARCHAR2);
181
182 PROCEDURE withdraw_document(
183 p_document_id IN NUMBER,
184 p_draft_id IN NUMBER,
185 p_document_type IN VARCHAR2,
186 p_document_sub_type IN VARCHAR2,
187 p_revision_num IN NUMBER,
188 p_current_employee_id IN NUMBER,
189 p_note IN VARCHAR2,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_return_message OUT NOCOPY VARCHAR2);
192
193 PROCEDURE is_fyi_approver(
194 itemtype IN VARCHAR2,
195 itemkey IN VARCHAR2,
196 actid IN NUMBER,
197 funcmode IN VARCHAR2,
198 resultout OUT NOCOPY VARCHAR2 );
199
200 FUNCTION get_current_future_approvers(
201 transactionType IN VARCHAR2,
202 transactionId IN NUMBER)
203 RETURN po_ame_approver_tab;
204
205 PROCEDURE set_esigner_response_rejected(
206 itemtype IN VARCHAR2,
207 itemkey IN VARCHAR2,
208 actid IN NUMBER,
209 funcmode IN VARCHAR2,
210 resultout OUT NOCOPY VARCHAR2 ) ;
211
212 PROCEDURE set_esigner_response_accepted(
213 itemtype IN VARCHAR2,
214 itemkey IN VARCHAR2,
215 actid IN NUMBER,
216 funcmode IN VARCHAR2,
217 resultout OUT NOCOPY VARCHAR2 ) ;
218
219 PROCEDURE create_erecord(
220 itemtype IN VARCHAR2,
221 itemkey IN VARCHAR2,
222 actid IN NUMBER,
223 funcmode IN VARCHAR2,
224 resultout OUT NOCOPY VARCHAR2);
225
226 PROCEDURE check_for_esigner_exists(
227 itemtype IN VARCHAR2,
228 itemkey IN VARCHAR2,
229 actid IN NUMBER,
230 funcmode IN VARCHAR2,
231 resultout OUT NOCOPY VARCHAR2 );
232
233 PROCEDURE update_auth_status_esign(
234 itemtype IN VARCHAR2,
235 itemkey IN VARCHAR2,
236 actid IN NUMBER,
237 funcmode IN VARCHAR2,
238 resultout OUT NOCOPY VARCHAR2);
239
240
241 PROCEDURE trigger_approval_workflow(
242 itemtype IN VARCHAR2,
243 itemkey IN VARCHAR2,
244 actid IN NUMBER,
245 funcmode IN VARCHAR2,
246 resultout OUT NOCOPY VARCHAR2);
247
248 PROCEDURE suppress_existing_esigners(
249 itemtype IN VARCHAR2,
250 itemkey IN VARCHAR2,
251 actid IN NUMBER,
252 funcmode IN VARCHAR2,
253 resultout OUT NOCOPY VARCHAR2);
254
255 PROCEDURE complete_ame_transaction(
256 itemtype IN VARCHAR2,
257 itemkey IN VARCHAR2,
258 actid IN NUMBER,
259 funcmode IN VARCHAR2,
260 resultout OUT NOCOPY VARCHAR2);
261
262 PROCEDURE update_action_history_app_fwd(
263 itemtype IN VARCHAR2,
264 itemkey IN VARCHAR2,
265 actid IN NUMBER,
266 funcmode IN VARCHAR2,
267 resultout OUT NOCOPY VARCHAR2);
268
269 PROCEDURE ame_is_forward_to_valid(
270 itemtype IN VARCHAR2,
271 itemkey IN VARCHAR2,
272 actid IN NUMBER,
273 funcmode IN VARCHAR2,
274 resultout OUT NOCOPY VARCHAR2);
275
276 END PO_AME_WF_PVT;