[Home] [Help]
PACKAGE: APPS.AP_IAW_PKG
Source
1 PACKAGE AP_IAW_PKG AUTHID CURRENT_USER AS
2 /* $Header: apiawles.pls 120.9 2006/01/26 00:05:53 mrjiang noship $ */
3
4 --Global Variables
5
6 TYPE r_inv_aprvl_hist IS RECORD(
7 APPROVAL_HISTORY_ID ap_inv_aprvl_hist_all.approval_history_id%TYPE,
8 INVOICE_ID ap_inv_aprvl_hist_all.invoice_id%TYPE,
9 ITERATION ap_inv_aprvl_hist_all.iteration%TYPE,
10 RESPONSE ap_inv_aprvl_hist_all.response%TYPE,
11 APPROVER_ID ap_inv_aprvl_hist_all.approver_id%TYPE,
12 AMOUNT_APPROVED ap_inv_aprvl_hist_all.amount_approved%TYPE,
13 APPROVER_COMMENTS ap_inv_aprvl_hist_all.approver_comments%TYPE,
14 CREATED_BY ap_inv_aprvl_hist_all.created_by%TYPE,
15 CREATION_DATE ap_inv_aprvl_hist_all.creation_date%TYPE,
16 LAST_UPDATE_DATE ap_inv_aprvl_hist_all.last_update_date%TYPE,
17 LAST_UPDATED_BY ap_inv_aprvl_hist_all.last_updated_by%TYPE,
18 LAST_UPDATE_LOGIN ap_inv_aprvl_hist_all.last_update_login%TYPE,
19 ORG_ID ap_inv_aprvl_hist_all.org_id%TYPE);
20
21 TYPE r_line_aprvl_hist IS RECORD(
22 LINE_APRVL_HISTORY_ID ap_line_aprvl_hist_all.line_aprvl_history_id%TYPE,
23 LINE_NUMBER ap_line_aprvl_hist_all.line_number%TYPE,
24 INVOICE_ID ap_line_aprvl_hist_all.invoice_id%TYPE,
25 ITERATION ap_line_aprvl_hist_all.iteration%TYPE,
26 RESPONSE ap_line_aprvl_hist_all.response%TYPE,
27 APPROVER_ID ap_line_aprvl_hist_all.approver_id%TYPE,
28 LINE_AMOUNT_APPROVED ap_line_aprvl_hist_all.line_amount_approved%TYPE,
29 TAX_AMOUNT_APPROVED ap_line_aprvl_hist_all.tax_amount_approved%TYPE,
30 FREIGHT_AMOUNT_APPROVED ap_line_aprvl_hist_all.freight_amount_approved%TYPE,
31 MISC_AMOUNT_APPROVED ap_line_aprvl_hist_all.misc_amount_approved%TYPE,
32 APPROVER_COMMENTS ap_line_aprvl_hist_all.approver_comments%TYPE,
33 ORG_ID ap_line_aprvl_hist_all.org_id%TYPE,
34 CREATED_BY ap_line_aprvl_hist_all.created_by%TYPE,
35 CREATION_DATE ap_line_aprvl_hist_all.creation_date%TYPE,
36 LAST_UPDATED_BY ap_line_aprvl_hist_all.last_updated_by%TYPE,
37 LAST_UPDATE_DATE ap_line_aprvl_hist_all.last_update_date%TYPE,
38 LAST_UPDATE_LOGIN ap_line_aprvl_hist_all.last_update_login%TYPE,
39 ITEM_CLASS ap_line_aprvl_hist_all.item_class%TYPE,
40 ITEM_ID ap_line_aprvl_hist_all.item_id%TYPE);
41
42
43 -- Public Procedures Specifications called from WF process
44
45 PROCEDURE Check_Header_Requirements(itemtype IN VARCHAR2,
46 itemkey IN VARCHAR2,
47 actid IN NUMBER,
48 funcmode IN VARCHAR2,
49 resultout OUT NOCOPY VARCHAR2);
50
51 PROCEDURE Check_Line_Requirements(itemtype IN VARCHAR2,
52 itemkey IN VARCHAR2,
53 actid IN NUMBER,
54 funcmode IN VARCHAR2,
55 resultout OUT NOCOPY VARCHAR2);
56
57 PROCEDURE Identify_Approver(itemtype IN VARCHAR2,
58 itemkey IN VARCHAR2,
59 actid IN NUMBER,
60 funcmode IN VARCHAR2,
61 resultout OUT NOCOPY VARCHAR2);
62
63 PROCEDURE Get_Approvers(itemtype IN VARCHAR2,
64 itemkey IN VARCHAR2,
65 actid IN NUMBER,
66 funcmode IN VARCHAR2,
67 resultout OUT NOCOPY VARCHAR2);
68
69 PROCEDURE Set_Approver(itemtype IN VARCHAR2,
70 itemkey IN VARCHAR2,
71 actid IN NUMBER,
72 funcmode IN VARCHAR2,
73 resultout OUT NOCOPY VARCHAR2);
74
75 PROCEDURE Escalate_Header_Request(itemtype IN VARCHAR2,
76 itemkey IN VARCHAR2,
77 actid IN NUMBER,
78 funcmode IN VARCHAR2,
79 resultout OUT NOCOPY VARCHAR2 );
80
81 PROCEDURE Escalate_Line_Request(itemtype IN VARCHAR2,
82 itemkey IN VARCHAR2,
83 actid IN NUMBER,
84 funcmode IN VARCHAR2,
85 resultout OUT NOCOPY VARCHAR2 );
86
87 PROCEDURE Response_Handler(itemtype IN VARCHAR2,
88 itemkey IN VARCHAR2,
89 actid IN NUMBER,
90 funcmode IN VARCHAR2,
91 resultout OUT NOCOPY VARCHAR2 );
92
93 PROCEDURE Response_Handler(p_invoice_id IN NUMBER,
94 p_line_num IN NUMBER,
95 p_not_key IN VARCHAR2,
96 p_response IN VARCHAR2,
97 p_comments IN VARCHAR2 );
98
99 PROCEDURE Notification_Handler(itemtype IN VARCHAR2,
100 itemkey IN VARCHAR2,
101 actid IN NUMBER,
102 funcmode IN VARCHAR2,
103 resultout OUT NOCOPY VARCHAR2 );
104
105 --Public Procedures called from other procedures
106
107 PROCEDURE IAW_Raise_Event(p_eventname IN VARCHAR2,
108 p_invoice_id IN VARCHAR2,
109 p_org_id IN NUMBER,
110 p_calling_sequence IN VARCHAR2);
111
112 PROCEDURE Set_Attribute_Values(itemtype IN VARCHAR2,
113 itemkey IN VARCHAR2 );
114
115 PROCEDURE Insert_Header_History(
116 p_inv_aprvl_hist IN ap_iaw_pkg.r_inv_aprvl_hist);
117
118 PROCEDURE Insert_Line_History(
119 p_line_aprvl_hist IN ap_iaw_pkg.r_line_aprvl_hist);
120
121
122 PROCEDURE Insert_Header_History(itemtype IN VARCHAR2,
123 itemkey IN VARCHAR2,
124 p_type IN VARCHAR2 );
125
126 PROCEDURE Insert_Line_History(itemtype IN VARCHAR2,
127 itemkey IN VARCHAR2,
128 P_type IN VARCHAR2) ;
129
130 /*PROCEDURE Update_Header_History(
131 p_invoice_id IN NUMBER,
132 p_inv_iteration IN NUMBER,
133 p_who_id IN NUMBER);
134 */
135
136 PROCEDURE Update_Header_History(itemtype IN VARCHAR2,
137 actid IN NUMBER,
138 itemkey IN VARCHAR2);
139
140 PROCEDURE Update_Line_History(
141 p_invoice_id IN NUMBER,
142 p_line_num IN NUMBER,
143 p_response IN VARCHAR2,
144 p_comments IN VARCHAR2);
145
146 PROCEDURE Update_Line_History(itemtype IN VARCHAR2,
147 actid IN NUMBER,
148 itemkey IN VARCHAR2);
149
150 PROCEDURE Get_All_Approvers(p_invoice_id IN NUMBER,
151 p_calling_sequence IN VARCHAR2);
152
153 PROCEDURE Terminate_Approval(
154 errbuf OUT NOCOPY VARCHAR2,
155 retcode OUT NOCOPY NUMBER);
156
157 --Public Functions called from other procedures
158
159 FUNCTION Clear_AME_History_Header(
160 p_invoice_id IN NUMBER,
161 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
162
163 FUNCTION Clear_AME_History_Line(
164 p_invoice_id IN NUMBER,
165 p_line_num IN NUMBER,
166 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
167
168 FUNCTION Stop_Approval(p_invoice_id IN NUMBER,
169 p_line_number IN NUMBER,
170 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
171
172 FUNCTION AP_Dist_Accounting_Flex(p_seg_name IN VARCHAR2,
173 p_dist_id IN NUMBER) RETURN VARCHAR2;
174
175 FUNCTION Get_Attribute_Value( p_invoice_id IN NUMBER,
176 p_sub_class_id IN NUMBER DEFAULT NULL,
177 p_attribute_name IN VARCHAR2,
178 p_context IN VARCHAR2 DEFAULT NULL)
179 RETURN VARCHAR2;
180
181
182 /*********************************************************************
183 *********************************************************************
184 *********************************************************************
185 ** **
186 ** Methods for Dispute Main Flow and Dispute Notification Flow **
187 ** **
188 *********************************************************************
189 *********************************************************************
190 *********************************************************************/
191
192 PROCEDURE apply_matching_hold( p_invoice_id in number);
193
194
195 PROCEDURE is_disputable( itemtype IN VARCHAR2,
196 itemkey IN VARCHAR2,
197 actid IN NUMBER,
198 funcmode IN VARCHAR2,
199 resultout OUT NOCOPY VARCHAR2);
200
201 PROCEDURE assign_internal_rep( itemtype IN VARCHAR2,
202 itemkey IN VARCHAR2,
203 actid IN NUMBER,
204 funcmode IN VARCHAR2,
205 resultout OUT NOCOPY VARCHAR2);
206
207 PROCEDURE create_approver_rec( itemtype IN VARCHAR2,
208 itemkey IN VARCHAR2,
209 actid IN NUMBER,
210 funcmode IN VARCHAR2,
211 resultout OUT NOCOPY VARCHAR2);
212
213 PROCEDURE exist_internal_rep( itemtype IN VARCHAR2,
214 itemkey IN VARCHAR2,
215 actid IN NUMBER,
216 funcmode IN VARCHAR2,
217 resultout OUT NOCOPY VARCHAR2);
218
219 PROCEDURE set_access_control( itemtype IN VARCHAR2,
220 itemkey IN VARCHAR2,
221 actid IN NUMBER,
222 funcmode IN VARCHAR2,
223 resultout OUT NOCOPY VARCHAR2);
224
225 PROCEDURE clear_approver_rec( itemtype IN VARCHAR2,
226 itemkey IN VARCHAR2,
227 actid IN NUMBER,
228 funcmode IN VARCHAR2,
229 resultout OUT NOCOPY VARCHAR2);
230
231 PROCEDURE set_dispute_notif_reciever(
232 itemtype IN VARCHAR2,
233 itemkey IN VARCHAR2,
234 actid IN NUMBER,
235 funcmode IN VARCHAR2,
236 resultout OUT NOCOPY VARCHAR2);
237
238 PROCEDURE cancel_invoice( itemtype IN VARCHAR2,
239 itemkey IN VARCHAR2,
240 actid IN NUMBER,
241 funcmode IN VARCHAR2,
242 resultout OUT NOCOPY VARCHAR2);
243
244 PROCEDURE accept_invoice( itemtype IN VARCHAR2,
245 itemkey IN VARCHAR2,
246 actid IN NUMBER,
247 funcmode IN VARCHAR2,
248 resultout OUT NOCOPY VARCHAR2);
249
250 PROCEDURE unwait_main_flow( itemtype IN VARCHAR2,
251 itemkey IN VARCHAR2,
252 actid IN NUMBER,
253 funcmode IN VARCHAR2,
254 resultout OUT NOCOPY VARCHAR2);
255
256 PROCEDURE is_all_accepted( itemtype IN VARCHAR2,
257 itemkey IN VARCHAR2,
258 actid IN NUMBER,
259 funcmode IN VARCHAR2,
260 resultout OUT NOCOPY VARCHAR2);
261
262 PROCEDURE is_invoice_updated( itemtype IN VARCHAR2,
263 itemkey IN VARCHAR2,
264 actid IN NUMBER,
265 funcmode IN VARCHAR2,
266 resultout OUT NOCOPY VARCHAR2);
267
268 PROCEDURE is_internal( itemtype IN VARCHAR2,
269 itemkey IN VARCHAR2,
270 actid IN NUMBER,
271 funcmode IN VARCHAR2,
272 resultout OUT NOCOPY VARCHAR2);
273
274 PROCEDURE exist_null_int_rep( itemtype IN VARCHAR2,
275 itemkey IN VARCHAR2,
276 actid IN NUMBER,
277 funcmode IN VARCHAR2,
278 resultout OUT NOCOPY VARCHAR2);
279
280 PROCEDURE asgn_fallback_int_rep(itemtype IN VARCHAR2,
281 itemkey IN VARCHAR2,
282 actid IN NUMBER,
283 funcmode IN VARCHAR2,
284 resultout OUT NOCOPY VARCHAR2);
285
286 PROCEDURE launch_disp_notif_flow(itemtype IN VARCHAR2,
287 itemkey IN VARCHAR2,
288 actid IN NUMBER,
289 funcmode IN VARCHAR2,
290 resultout OUT NOCOPY VARCHAR2);
291
292
293 PROCEDURE is_rejected( itemtype IN VARCHAR2,
294 itemkey IN VARCHAR2,
295 actid IN NUMBER,
296 funcmode IN VARCHAR2,
297 resultout OUT NOCOPY VARCHAR2);
298
299 PROCEDURE is_invoice_request( itemtype IN VARCHAR2,
300 itemkey IN VARCHAR2,
301 actid IN NUMBER,
302 funcmode IN VARCHAR2,
303 resultout OUT NOCOPY VARCHAR2);
304
305 PROCEDURE update_to_invoice( itemtype IN VARCHAR2,
306 itemkey IN VARCHAR2,
307 actid IN NUMBER,
308 funcmode IN VARCHAR2,
309 resultout OUT NOCOPY VARCHAR2);
310
311 PROCEDURE is_isp_enabled( itemtype IN VARCHAR2,
312 itemkey IN VARCHAR2,
313 actid IN NUMBER,
314 funcmode IN VARCHAR2,
315 resultout OUT NOCOPY VARCHAR2);
316
317 FUNCTION getRoleEmailAddress( p_role in varchar2) return varchar2;
318
319 PROCEDURE launch_approval_notif_flow(itemtype IN VARCHAR2,
320 itemkey IN VARCHAR2,
321 actid IN NUMBER,
322 funcmode IN VARCHAR2,
323 resultout OUT NOCOPY VARCHAR2);
324
325 PROCEDURE exists_receiving_hold(itemtype IN VARCHAR2,
326 itemkey IN VARCHAR2,
327 actid IN NUMBER,
328 funcmode IN VARCHAR2,
329 resultout OUT NOCOPY VARCHAR2);
330
331 PROCEDURE delay_dispute( itemtype IN VARCHAR2,
332 itemkey IN VARCHAR2,
333 actid IN NUMBER,
334 funcmode IN VARCHAR2,
335 resultout OUT NOCOPY VARCHAR2);
336
337 PROCEDURE revalidate_invoice( itemtype IN VARCHAR2,
338 itemkey IN VARCHAR2,
339 actid IN NUMBER,
340 funcmode IN VARCHAR2,
341 resultout OUT NOCOPY VARCHAR2);
342
343 PROCEDURE release_holds( itemtype IN VARCHAR2,
344 itemkey IN VARCHAR2,
345 actid IN NUMBER,
346 funcmode IN VARCHAR2,
347 resultout OUT NOCOPY VARCHAR2);
348
349 END AP_IAW_PKG;
350