[Home] [Help]
PACKAGE: APPS.PO_AUTOCREATE_DOC
Source
1 PACKAGE PO_AUTOCREATE_DOC AS
2 /* $Header: POXWATCS.pls 120.2 2005/09/14 05:05:18 pchintal noship $ */
3
4 procedure start_wf_process (ItemType VARCHAR2,
5 ItemKey VARCHAR2,
6 workflow_process VARCHAR2,
7 req_header_id NUMBER,
8 po_number VARCHAR2,
9 interface_source_code VARCHAR2,
10 org_id NUMBER);
11
12 procedure should_req_be_autocreated(itemtype IN VARCHAR2,
13 itemkey IN VARCHAR2,
14 actid IN NUMBER,
15 funcmode IN VARCHAR2,
16 resultout OUT NOCOPY VARCHAR2 );
17
18 procedure launch_req_line_processing(itemtype IN VARCHAR2,
19 itemkey IN VARCHAR2,
20 actid IN NUMBER,
21 funcmode IN VARCHAR2,
22 resultout OUT NOCOPY VARCHAR2 );
23
24 procedure start_wf_line_process ( ItemType VARCHAR2,
25 ItemKey VARCHAR2,
26 workflow_process VARCHAR2,
27 group_id NUMBER,
28 req_header_id NUMBER,
29 req_line_id NUMBER,
30 parent_itemtype VARCHAR2,
31 parent_itemkey VARCHAR2);
32
33
34 procedure get_req_info (itemtype IN VARCHAR2,
35 itemkey IN VARCHAR2,
36 actid IN NUMBER,
37 funcmode IN VARCHAR2,
38 resultout OUT NOCOPY VARCHAR2 );
39
40
41 procedure rfq_required_check (itemtype IN VARCHAR2,
42 itemkey IN VARCHAR2,
43 actid IN NUMBER,
44 funcmode IN VARCHAR2,
45 resultout OUT NOCOPY VARCHAR2 );
46
47
48 procedure get_supp_info_for_acrt (itemtype IN VARCHAR2,
49 itemkey IN VARCHAR2,
50 actid IN NUMBER,
51 funcmode IN VARCHAR2,
52 resultout OUT NOCOPY VARCHAR2 );
53
54 procedure is_source_doc_info_ok (itemtype IN VARCHAR2,
55 itemkey IN VARCHAR2,
56 actid IN NUMBER,
57 funcmode IN VARCHAR2,
58 resultout OUT NOCOPY VARCHAR2 );
59
60 procedure does_contract_exist(itemtype IN VARCHAR2,
61 itemkey IN VARCHAR2,
62 actid IN NUMBER,
63 funcmode IN VARCHAR2,
64 resultout OUT NOCOPY VARCHAR2 );
65
66 procedure is_req_pcard_line (itemtype IN VARCHAR2,
67 itemkey IN VARCHAR2,
68 actid IN NUMBER,
69 funcmode IN VARCHAR2,
70 resultout OUT NOCOPY VARCHAR2 );
71
72 procedure get_buyer_from_req_line (itemtype IN VARCHAR2,
73 itemkey IN VARCHAR2,
74 actid IN NUMBER,
75 funcmode IN VARCHAR2,
76 resultout OUT NOCOPY VARCHAR2 );
77
78 procedure get_buyer_from_item (itemtype IN VARCHAR2,
79 itemkey IN VARCHAR2,
80 actid IN NUMBER,
81 funcmode IN VARCHAR2,
82 resultout OUT NOCOPY VARCHAR2 );
83
84 procedure get_buyer_from_category (itemtype IN VARCHAR2,
85 itemkey IN VARCHAR2,
86 actid IN NUMBER,
87 funcmode IN VARCHAR2,
88 resultout OUT NOCOPY VARCHAR2 );
89
90
91 procedure get_buyer_from_source_doc (itemtype IN VARCHAR2,
92 itemkey IN VARCHAR2,
93 actid IN NUMBER,
94 funcmode IN VARCHAR2,
95 resultout OUT NOCOPY VARCHAR2 );
96
97 procedure get_buyer_from_contract (itemtype IN VARCHAR2,
98 itemkey IN VARCHAR2,
99 actid IN NUMBER,
100 funcmode IN VARCHAR2,
101 resultout OUT NOCOPY VARCHAR2 );
102
103 procedure get_source_doc_type (itemtype IN VARCHAR2,
104 itemkey IN VARCHAR2,
105 actid IN NUMBER,
106 funcmode IN VARCHAR2,
107 resultout OUT NOCOPY VARCHAR2 );
108
109 procedure one_time_item_check (itemtype IN VARCHAR2,
110 itemkey IN VARCHAR2,
111 actid IN NUMBER,
112 funcmode IN VARCHAR2,
113 resultout OUT NOCOPY VARCHAR2 );
114
115 procedure get_rel_gen_method (itemtype IN VARCHAR2,
116 itemkey IN VARCHAR2,
117 actid IN NUMBER,
118 funcmode IN VARCHAR2,
119 resultout OUT NOCOPY VARCHAR2 );
120
121 procedure cont_wf_autocreate_rel_gen (itemtype IN VARCHAR2,
122 itemkey IN VARCHAR2,
123 actid IN NUMBER,
124 funcmode IN VARCHAR2,
125 resultout OUT NOCOPY VARCHAR2 );
126
127 procedure insert_cand_req_lines_into_tbl (itemtype IN VARCHAR2,
128 itemkey IN VARCHAR2,
129 actid IN NUMBER,
130 funcmode IN VARCHAR2,
131 resultout OUT NOCOPY VARCHAR2 );
132
133 procedure group_req_lines (itemtype IN VARCHAR2,
134 itemkey IN VARCHAR2,
135 actid IN NUMBER,
136 funcmode IN VARCHAR2,
137 resultout OUT NOCOPY VARCHAR2 );
138
139
140 function insert_into_headers_interface (itemtype IN VARCHAR2,
141 itemkey IN VARCHAR2,
142 x_group_id IN NUMBER,
143 x_suggested_vendor_id IN NUMBER,
144 x_suggested_vendor_site_id IN NUMBER,
145 x_suggested_buyer_id IN NUMBER,
146 x_source_doc_type_code IN VARCHAR2,
147 x_source_doc_id IN NUMBER,
148 x_currency_code IN VARCHAR2,
149 x_rate_type IN VARCHAR2,
150 x_rate_date IN DATE,
151 x_rate IN NUMBER,
152 x_pcard_id IN NUMBER,
153 p_style_id IN NUMBER, --<R12 STYLES PHASE II>
154 x_interface_header_id IN OUT NOCOPY NUMBER)
155 return boolean; --bug 3401653
156
157
158 procedure insert_into_lines_interface (itemtype IN VARCHAR2,
159 itemkey IN VARCHAR2,
160 x_interface_header_id IN NUMBER,
161 x_req_line_id IN NUMBER,
162 x_source_doc_line IN NUMBER,
163 x_source_doc_type_code IN VARCHAR2,
164 x_contract_id IN NUMBER,
165 x_source_doc_id IN NUMBER,
166 x_cons_from_supp_flag IN VARCHAR2); -- CONSIGNED FPI
167
168
169 procedure launch_doc_creation_approval (itemtype IN VARCHAR2,
170 itemkey IN VARCHAR2,
171 actid IN NUMBER,
172 funcmode IN VARCHAR2,
173 resultout OUT NOCOPY VARCHAR2 );
174
175 procedure start_wf_create_apprv_process (ItemType VARCHAR2,
176 ItemKey VARCHAR2,
177 workflow_process VARCHAR2,
178 interface_header_id NUMBER,
179 doc_type_to_create VARCHAR2,
180 agent_id NUMBER,
181 org_id NUMBER,
182 purchasing_org_id NUMBER, --<Shared Proc FPJ>
183 parent_itemtype VARCHAR2,
184 parent_itemkey VARCHAR2);
185
186 procedure create_doc (itemtype IN VARCHAR2,
187 itemkey IN VARCHAR2,
188 actid IN NUMBER,
189 funcmode IN VARCHAR2,
190 resultout OUT NOCOPY VARCHAR2 );
191
192 procedure setup_notification_data (itemtype IN VARCHAR2,
193 itemkey IN VARCHAR2);
194
195
196 procedure should_doc_be_approved (itemtype IN VARCHAR2,
197 itemkey IN VARCHAR2,
198 actid IN NUMBER,
199 funcmode IN VARCHAR2,
200 resultout OUT NOCOPY VARCHAR2 );
201
202 procedure launch_po_approval (itemtype IN VARCHAR2,
203 itemkey IN VARCHAR2,
204 actid IN NUMBER,
205 funcmode IN VARCHAR2,
206 resultout OUT NOCOPY VARCHAR2 );
207
208 procedure purge_rows_from_temp_table (itemtype IN VARCHAR2,
209 itemkey IN VARCHAR2,
210 actid IN NUMBER,
211 funcmode IN VARCHAR2,
212 resultout OUT NOCOPY VARCHAR2 );
213
214 procedure is_this_emergency_req(itemtype IN VARCHAR2,
215 itemkey IN VARCHAR2,
216 actid IN NUMBER,
217 funcmode IN VARCHAR2,
218 resultout OUT NOCOPY VARCHAR2 );
219
220 procedure put_on_one_po(itemtype IN VARCHAR2,
221 itemkey IN VARCHAR2,
222 actid IN NUMBER,
223 funcmode IN VARCHAR2,
224 resultout OUT NOCOPY VARCHAR2 );
225
226 -- dkfchan: This procedure sends a notification to the preparer when
227 -- the requisition is returned.
228
229 procedure send_return_notif(p_req_header_id IN number,
230 p_agent_id IN number,
231 p_reason IN VARCHAR2);
232
233 -- Bug # 1869409
234 -- Created a function get_document_num as an autonomous transaction
235 -- to avoid the COMMIT for the Workflow transactions.
236
237 --<Shared Proc FPJ>
238 -- Adding a new parameter p_purchasing_org.
239 function get_document_num (
240 p_purchasing_org_id IN NUMBER
241 ) RETURN VARCHAR2;
242
243 -- dhli: the following functions are added for contract autosourcing.
244
245 procedure is_contract_required_on_req(itemtype IN VARCHAR2,
246 itemkey IN VARCHAR2,
247 actid IN NUMBER,
248 funcmode IN VARCHAR2,
249 resultout OUT NOCOPY VARCHAR2 );
250
251 procedure should_contract_be_used(itemtype IN VARCHAR2,
252 itemkey IN VARCHAR2,
253 actid IN NUMBER,
254 funcmode IN VARCHAR2,
255 resultout OUT NOCOPY VARCHAR2 );
256 procedure non_catalog_item_check (itemtype IN VARCHAR2,
257 itemkey IN VARCHAR2,
258 actid IN NUMBER,
259 funcmode IN VARCHAR2,
260 resultout OUT NOCOPY VARCHAR2 );
261
262 procedure should_nctlog_src_frm_contract(itemtype IN VARCHAR2,
263 itemkey IN VARCHAR2,
264 actid IN NUMBER,
265 funcmode IN VARCHAR2,
266 resultout OUT NOCOPY VARCHAR2 );
267 procedure is_contract_doc_info_ok(itemtype IN VARCHAR2,
268 itemkey IN VARCHAR2,
269 actid IN NUMBER,
270 funcmode IN VARCHAR2,
271 resultout OUT NOCOPY VARCHAR2 );
272
273 /* FPI GA start */
274 /* New procedure to find out if the GA referenced in the req is from another OU */
275 procedure is_src_doc_ga_frm_other_ou (itemtype IN VARCHAR2,
276 itemkey IN VARCHAR2,
277 actid IN NUMBER,
278 funcmode IN VARCHAR2,
279 resultout OUT NOCOPY VARCHAR2 );
280
281 /* FPI GA end */
282
283 --Bug 2745549
284 PROCEDURE is_ga_still_valid(p_ga_po_header_id IN NUMBER,
285 x_ref_is_valid OUT NOCOPY VARCHAR2);
286
287
288 --<Shared Proc FPJ START>
289
290 PROCEDURE buyer_on_src_doc_ok (itemtype IN VARCHAR2,
291 itemkey IN VARCHAR2,
292 actid IN NUMBER,
293 funcmode IN VARCHAR2,
294 resultout OUT NOCOPY VARCHAR2);
295
296 PROCEDURE buyer_on_contract_ok (itemtype IN VARCHAR2,
297 itemkey IN VARCHAR2,
298 actid IN NUMBER,
299 funcmode IN VARCHAR2,
300 resultout OUT NOCOPY VARCHAR2);
301
302 PROCEDURE purchasing_ou_check (itemtype IN VARCHAR2,
303 itemkey IN VARCHAR2,
304 actid IN NUMBER,
305 funcmode IN VARCHAR2,
306 resultout OUT NOCOPY VARCHAR2);
307
308 PROCEDURE ok_to_create_in_diff_ou (itemtype IN VARCHAR2,
309 itemkey IN VARCHAR2,
310 actid IN NUMBER,
311 funcmode IN VARCHAR2,
312 resultout OUT NOCOPY VARCHAR2);
313
314 --<Shared Proc FPJ END>
315
316 -- <SERVICES FPJ>
317 PROCEDURE is_expense_line(itemtype IN VARCHAR2,
318 itemkey IN VARCHAR2,
319 actid IN NUMBER,
320 funcmode IN VARCHAR2,
321 resultout OUT NOCOPY VARCHAR2);
322
323 -- contract support for temp labor
324 procedure temp_labor_item_check (itemtype IN VARCHAR2,
325 itemkey IN VARCHAR2,
326 actid IN NUMBER,
327 funcmode IN VARCHAR2,
328 resultout OUT NOCOPY VARCHAR2 );
329
330 procedure should_tmplbr_src_frm_contract(itemtype IN VARCHAR2,
331 itemkey IN VARCHAR2,
332 actid IN NUMBER,
333 funcmode IN VARCHAR2,
334 resultout OUT NOCOPY VARCHAR2 );
335
336 END PO_AUTOCREATE_DOC;