[Home] [Help]
PACKAGE: APPS.PORCPTWF
Source
1 PACKAGE PORCPTWF AS
2 /* $Header: PORCPWFS.pls 120.0 2005/06/01 20:47:30 appldev noship $*/
3
4 /*===========================================================================
5 PACKAGE NAME: PORCPTWF
6
7 DESCRIPTION: Confirm Receipts Workflow server procedures
8
9 CLIENT/SERVER: Server
10
11 LIBRARY NAME PORCPTWF
12
13 OWNER: WLAU
14
15 PROCEDURES/FUNCTIONS:
16
17 ===========================================================================*/
18
19
20 /*===========================================================================
21 PROCEDURE NAME: Select_Orders
22
23 DESCRIPTION: See the package body
24
25 PARAMETERS:
26
27 RETURN:
28
29 DESIGN REFERENCES: Oracle Applications for the Web/Oracle Purchasing
30 Confirm Receipts
31
32 ALGORITHM:
33
34 NOTES:
35
36 OPEN ISSUES:
37
38 CLOSED ISSUES:
39
40 CHANGE HISTORY: WLAU 1/15/1997 Created
41 ===========================================================================*/
42
43 PROCEDURE Select_Orders;
44
45 PROCEDURE Select_Internal_Orders;
46
47 procedure purge_orders;
48
49 /*===========================================================================
50 PROCEDURE NAME: Process_Auto_Receive
51
52 DESCRIPTION: See the package body
53
54 PARAMETERS:
55
56 RETURN:
57
58 DESIGN REFERENCES: Web Requisition 4.0 PO Impact Analysis HLD
59
60 ALGORITHM:
61
62 NOTES:
63
64 OPEN ISSUES:
65
66 CLOSED ISSUES:
67
68 CHANGE HISTORY: NWANG 10/07/1997 Created
69 ===========================================================================*/
70
71
72 PROCEDURE Process_Auto_Receive (x_po_header_id IN NUMBER,
73 x_requester_id IN NUMBER,
74 x_exp_receipt_date IN DATE);
75
76
77 PROCEDURE Process_Auto_Receive_Internal (x_header_id IN NUMBER,
78 x_requester_id IN NUMBER,
79 x_exp_receipt_date IN DATE);
80
81
82
83 /*===========================================================================
84 PROCEDURE NAME: Start_Rcpt_Process
85
86 DESCRIPTION: See the package body
87
88 PARAMETERS:
89
90 RETURN:
91
92 DESIGN REFERENCES: Oracle Applications for the Web/Oracle Purchasing
93 Confirm Receipts
94
95 ALGORITHM:
96
97 NOTES:
98
99 OPEN ISSUES:
100
101 CLOSED ISSUES:
102
103 CHANGE HISTORY: WLAU 1/15/1997 Created
104 ===========================================================================*/
105
106 PROCEDURE Start_Rcpt_Process (x_header_id IN NUMBER,
107 x_requester_id IN NUMBER,
108 x_exp_receipt_date IN DATE,
109 x_WF_ItemKey IN VARCHAR2,
110 x_revision_num IN NUMBER,
111 x_is_int_req IN VARCHAR2 default 'N',
112 x_req_header_id IN NUMBER default '-1',
113 x_po_num_rel_num IN VARCHAR2 default null);
114
115
116 /*===========================================================================
117 PROCEDURE NAME: Get_Order_Info
118
119 DESCRIPTION: See the package body
120
121 PARAMETERS:
122
123 RETURN:
124
125 DESIGN REFERENCES: Oracle Applications for the Web/Oracle Purchasing
126 Confirm Receipts
127
128 ALGORITHM:
129
130 NOTES:
131
132 OPEN ISSUES:
133
134 CLOSED ISSUES:
135
136 CHANGE HISTORY: WLAU 1/15/1997 Created
137 ===========================================================================*/
138
139 PROCEDURE Get_Order_Info ( itemtype in varchar2,
140 itemkey in varchar2,
141 actid in number,
142 funmode in varchar2,
143 result out NOCOPY varchar2 );
144
145 PROCEDURE Get_Internal_Order_Info( itemtype in varchar2,
146 itemkey in varchar2,
147 actid in number,
148 funmode in varchar2,
149 result out NOCOPY varchar2 ) ;
150
151
152 /*===========================================================================
153 PROCEDURE NAME: Get_Rcv_Order_URL
154
155 DESCRIPTION: See the package body
156
157 PARAMETERS:
158
159 RETURN:
160
161 DESIGN REFERENCES: Oracle Applications for the Web/Oracle Purchasing
162 Confirm Receipts
163
164 ALGORITHM:
165
166 NOTES:
167
168 OPEN ISSUES:
169
170 CLOSED ISSUES:
171
172 CHANGE HISTORY: WLAU 1/15/1997 Created
173 ===========================================================================*/
174
175 PROCEDURE Get_Rcv_Order_URL ( itemtype in varchar2,
176 itemkey in varchar2,
177 actid in number,
178 funmode in varchar2,
179 result out NOCOPY varchar2 );
180
181 PROCEDURE Get_Rcv_Int_Order_URL ( itemtype in varchar2,
182 itemkey in varchar2,
183 actid in number,
184 funmode in varchar2,
185 result out NOCOPY varchar2 );
186
187 /*===========================================================================
188 PROCEDURE NAME: Process_Rcv_Trans
189
190 DESCRIPTION: See the package body
191
192 PARAMETERS:
193
194 RETURN:
195
196 DESIGN REFERENCES: Oracle Applications for the Web/Oracle Purchasing
197 Confirm Receipts
198
199 ALGORITHM:
200
201 NOTES:
202
203 OPEN ISSUES:
204
205 CLOSED ISSUES:
206
207 CHANGE HISTORY: WLAU 1/15/1997 Created
208 ===========================================================================*/
209
210 PROCEDURE Process_Rcv_Trans ( itemtype in varchar2,
211 itemkey in varchar2,
212 actid in number,
213 funmode in varchar2,
214 result out NOCOPY varchar2 );
215
216 PROCEDURE Process_Rcv_Trans_Int ( itemtype in varchar2,
217 itemkey in varchar2,
218 actid in number,
219 funmode in varchar2,
220 result out NOCOPY varchar2 );
221
222
223 /*===========================================================================
224 PROCEDURE NAME: Get_Requester_Manager
225
226 DESCRIPTION: See the package body
227
228 PARAMETERS:
229
230 RETURN:
231
232 DESIGN REFERENCES: Oracle Applications for the Web/Oracle Purchasing
233 Confirm Receipts
234
235 ALGORITHM:
236
237 NOTES:
238
239 OPEN ISSUES:
240
241 CLOSED ISSUES:
242
243 CHANGE HISTORY: WLAU 1/15/1997 Created
244 ===========================================================================*/
245
246 PROCEDURE Get_Requester_Manager (itemtype in varchar2,
247 itemkey in varchar2,
248 actid in number,
249 funmode in varchar2,
250 result out NOCOPY varchar2 );
251
252
253
254 /*===========================================================================
255 PROCEDURE NAME: Open_RCV_Orders
256
257 DESCRIPTION: See the package body
258
259 PARAMETERS:
260
261 RETURN:
262
263 DESIGN REFERENCES: Oracle Applications for the Web/Oracle Purchasing
264 Confirm Receipts
265
266 ALGORITHM:
267
268 NOTES:
269
270 OPEN ISSUES:
271
272 CLOSED ISSUES:
273
274 CHANGE HISTORY: WLAU 1/15/1997 Created
275 WLAU 4/22/1997 bug 475711- Set p11
276 default value to NULL
277 ===========================================================================*/
278
279 PROCEDURE Open_RCV_Orders (p1 in varchar2,
280 p2 in varchar2,
281 p3 in varchar2,
282 p11 in varchar2 DEFAULT NULL);
283
284
285 /*===========================================================================
286 FUNCTION NAME: findOrgId
287
288 DESCRIPTION: See the package body
289
290 PARAMETERS:
291
292 RETURN:
293
294 DESIGN REFERENCES: Oracle Applications for the Web/Oracle Purchasing
295 Confirm Receipts
296
297 ALGORITHM:
298
299 NOTES:
300
301 OPEN ISSUES:
302
303 CLOSED ISSUES:
304
305 CHANGE HISTORY: WLAU 2/11/1997 Created
306 ===========================================================================*/
307
308 FUNCTION findOrgId(x_header_id IN number,
309 x_is_int_req IN VARCHAR2 default 'N') return number;
310
311 FUNCTION po_revised ( x_po_header_id IN number, x_revision_num IN number ,x_wf_itemtype IN varchar2 ,x_wf_itemkey IN varchar2)
312 return boolean;
313
314
315 PROCEDURE does_item_exist ( itemtype in varchar2,
316 itemkey in varchar2,
317 actid in number,
318 funcmode in varchar2,
319 resultout out NOCOPY varchar2);
320
321 PROCEDURE GET_PO_RCV_NOTIF_MSG( document_id in varchar2,
322 display_type in varchar2,
323 document in out NOCOPY varchar2,
324 document_type in out NOCOPY varchar2);
325
326 PROCEDURE Is_Internal_Requisition( itemtype in varchar2,
327 itemkey in varchar2,
328 actid in number,
329 funmode in varchar2,
330 result out NOCOPY varchar2 ) ;
331
332 procedure setOrgCtx (x_org_id IN NUMBER);
333
334 PROCEDURE Process_rcv_amt_billed(itemtype in varchar2,
335 itemkey in varchar2,
336 actid in number,
337 funmode in varchar2,
338 result out NOCOPY varchar2);
339
340 PROCEDURE Restart_rcpt_process(itemtype in varchar2,
341 itemkey in varchar2,
342 actid in number,
343 funmode in varchar2,
344 result out NOCOPY varchar2);
345
346 PROCEDURE Does_invoice_match_exist(itemtype in varchar2,
347 itemkey in varchar2,
348 actid in number,
349 funmode in varchar2,
350 resultout out NOCOPY varchar2);
351
352 END PORCPTWF;