1 PACKAGE INV_PO_THIRD_PARTY_STOCK_MDTR AS
2 -- $Header: INVMPOXS.pls 120.2 2006/03/15 00:42:14 kdevadas noship $ --
3 --+=======================================================================+
4 --| Copyright (c) 2002 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVMPOXS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Consiged Inventory INV/PO dependency wrapper API |
13 --| HISTORY |
14 --| 09/30/2002 pseshadr Created |
15 --| 09-Mar-06 kdevadas get_break_price API changed for Advanced |
16 --| Pricing updtake - bug 5076263 |
17 --+========================================================================
18
19
20 --===================
21 -- PROCEDURES AND FUNCTIONS
22 --===================
23
24 --========================================================================
25 -- PROCEDURE : Get_Blanket_Number PUBLIC
26 -- PARAMETERS: p_inventory_item_id Item
27 -- p_item_revision Item Revision
28 -- p_vendor_site_id Vendor Site
29 -- p_organization_id Inventory Organization
30 -- x_document_header_id PO Header id
31 -- x_document_line_id PO line id
32 -- x_global_flag Flag to indicate if manual numb.
33 -- is set in case of GA
34 -- COMMENT : Return document_id if a valid blanket exists for item,
35 -- supplier site,organization combination.
36 -- This procedure is invoked to get the most recent blanket when
37 -- performing a Transfer to regular stock transaction.
38 --========================================================================
39 PROCEDURE Get_Blanket_Number
40 ( p_inventory_item_id IN NUMBER
41 , p_item_revision IN VARCHAR2
42 , p_vendor_site_id IN NUMBER
43 , p_organization_id IN NUMBER
44 , p_transaction_date IN DATE
45 , x_document_header_id OUT NOCOPY NUMBER
46 , x_document_line_id OUT NOCOPY NUMBER
47 , x_global_flag OUT NOCOPY VARCHAR2
48 );
49
50 --========================================================================
51 -- PROCEDURE : Get_Blanket_Number PUBLIC overloaded
52 -- PARAMETERS: p_inventory_item_id Item
53 -- p_item_revision Item Revision
54 -- p_vendor_site_id Vendor Site
55 -- p_organization_id Inventory Organization
56 -- x_document_header_id PO Header id
57 -- x_document_line_id PO line id
58 -- x_global_flag Flag to indicate if manual numb.
59 -- is set in case of GA
60 -- COMMENT : Return document_id if a valid blanket exists for item,
61 -- supplier site,organization combination.
62 -- This procedure is invoked to get the most recent blanket when
63 -- performing a Transfer to regular stock transaction.
64 --========================================================================
65 PROCEDURE Get_Blanket_Number
66 ( p_inventory_item_id IN NUMBER
67 , p_item_revision IN VARCHAR2
68 , p_vendor_site_id IN NUMBER
69 , p_organization_id IN NUMBER
70 , x_document_header_id OUT NOCOPY NUMBER
71 , x_document_line_id OUT NOCOPY NUMBER
72 , x_global_flag OUT NOCOPY VARCHAR2
73 );
74
75 --========================================================================
76 -- PROCEDURE : Get_Asl_Info PUBLIC
77 -- PARAMETERS: p_item_id Item
78 -- p_vendor_id Vendor Id
79 -- p_vendor_site_id Vendor Site Id
80 -- p_using_organization_id organization
81 -- x_asl_id asl id
82 -- x_vendor_product_num vendor product num
83 -- x_purchasing_uom Purchasing UOM
84 -- COMMENT: Wrapper for get asl info procedure in purchasing
85 --========================================================================
86 PROCEDURE Get_Asl_Info
87 ( p_item_id IN NUMBER
88 , p_vendor_id IN NUMBER
89 , p_vendor_site_id IN NUMBER
90 , p_using_organization_id IN NUMBER
91 , x_asl_id OUT NOCOPY NUMBER
92 , x_vendor_product_num OUT NOCOPY VARCHAR2
93 , x_purchasing_uom OUT NOCOPY VARCHAR2
94 );
95
96 --========================================================================
97 -- PROCEDURE : Get_Elapsed_Info PUBLIC
98 -- PARAMETERS: p_org_id org id
99 -- p_asl_id asl id
100 -- x_bill_date_elapsed indicates if txn can be processed
101 -- COMMENT: Wrapper for get elapsed info sql in purchasing
102 --========================================================================
103 PROCEDURE Get_Elapsed_Info
104 ( p_org_id IN NUMBER
105 , p_asl_id IN NUMBER
106 , x_bill_date_elapsed OUT NOCOPY NUMBER
107 );
108
109 --========================================================================
110 -- PROCEDURE : Update_Asl PUBLIC
111 -- PARAMETERS : p_asl_id Asl Id
112 -- COMMENT : Update the billing date of the current asl
113 --========================================================================
114 PROCEDURE Update_Asl
115 ( p_asl_id IN NUMBER
116 );
117
118 --========================================================================
119 -- PROCEDURE : Generate_Account PUBLIC
120 -- PARAMETERS : p_coa_id Chart of Accounts Id
121 -- p_destination_type_code INVENTORY
122 -- p_type_lookup_code Document type
123 -- p_item_id Item
124 -- p_vendor_id Vendor
125 -- p_vendor_site_id Vendor Site
126 -- p_destination_organization_id Inventory Organization
127 -- p_po_encumberance_flag PO encumberance
128 -- p_accrual_account_id Accrual account
129 -- p_charge_account_id Charge Account
130 -- p_variance_account_id Variance Account
131 -- COMMENT : The above inputs are the only relevent parameters for
132 -- generation of accounts for consigned transaction. All
133 -- the other parameters that are required for the
134 -- procedure are passed in as NULL . This is a wrapper
135 -- to the PO Account generator.
136 --========================================================================
137
138 PROCEDURE Generate_Account
139 ( p_charge_success IN OUT NOCOPY BOOLEAN
140 , p_budget_success IN OUT NOCOPY BOOLEAN
141 , p_accrual_success IN OUT NOCOPY BOOLEAN
142 , p_variance_success IN OUT NOCOPY BOOLEAN
143 , p_code_combination_id IN OUT NOCOPY NUMBER
144 , p_charge_account_id IN OUT NOCOPY NUMBER
145 , p_budget_account_id IN OUT NOCOPY NUMBER
146 , p_accrual_account_id IN OUT NOCOPY NUMBER
147 , p_variance_account_id IN OUT NOCOPY NUMBER
148 , p_charge_account_flex IN OUT NOCOPY VARCHAR2
149 , p_budget_account_flex IN OUT NOCOPY VARCHAR2
150 , p_accrual_account_flex IN OUT NOCOPY VARCHAR2
151 , p_variance_account_flex IN OUT NOCOPY VARCHAR2
152 , p_charge_account_desc IN OUT NOCOPY VARCHAR2
153 , p_budget_account_desc IN OUT NOCOPY VARCHAR2
154 , p_accrual_account_desc IN OUT NOCOPY VARCHAR2
155 , p_variance_account_desc IN OUT NOCOPY VARCHAR2
156 , p_coa_id IN NUMBER
157 , p_bom_resource_id IN NUMBER
158 , p_bom_cost_element_id IN NUMBER
159 , p_category_id IN NUMBER
160 , p_destination_type_code IN VARCHAR2
161 , p_deliver_to_location_id IN NUMBER
162 , p_destination_organization_id IN NUMBER
163 , p_destination_subinventory IN VARCHAR2
164 , p_expenditure_type IN VARCHAR2
165 , p_expenditure_organization_id IN NUMBER
166 , p_expenditure_item_date IN DATE
167 , p_item_id IN NUMBER
168 , p_line_type_id IN NUMBER
169 , p_result_billable_flag IN VARCHAR2
170 , p_agent_id IN NUMBER
171 , p_project_id IN NUMBER
172 , p_from_type_lookup_code IN VARCHAR2
173 , p_from_header_id IN NUMBER
174 , p_from_line_id IN NUMBER
175 , p_task_id IN NUMBER
176 , p_deliver_to_person_id IN NUMBER
177 , p_type_lookup_code IN VARCHAR2
178 , p_vendor_id IN NUMBER
179 , p_wip_entity_id IN NUMBER
180 , p_wip_entity_type IN VARCHAR2
181 , p_wip_line_id IN NUMBER
182 , p_wip_repetitive_schedule_id IN NUMBER
183 , p_wip_operation_seq_num IN NUMBER
184 , p_wip_resource_seq_num IN NUMBER
185 , p_po_encumberance_flag IN VARCHAR2
186 , p_gl_encumbered_date IN DATE
187 , p_wf_itemkey IN OUT NOCOPY VARCHAR2
188 , p_new_combination IN OUT NOCOPY BOOLEAN
189 , p_header_att1 IN VARCHAR2
190 , p_header_att2 IN VARCHAR2
191 , p_header_att3 IN VARCHAR2
192 , p_header_att4 IN VARCHAR2
193 , p_header_att5 IN VARCHAR2
194 , p_header_att6 IN VARCHAR2
195 , p_header_att7 IN VARCHAR2
196 , p_header_att8 IN VARCHAR2
197 , p_header_att9 IN VARCHAR2
198 , p_header_att10 IN VARCHAR2
199 , p_header_att11 IN VARCHAR2
200 , p_header_att12 IN VARCHAR2
201 , p_header_att13 IN VARCHAR2
202 , p_header_att14 IN VARCHAR2
203 , p_header_att15 IN VARCHAR2
204 , p_line_att1 IN VARCHAR2
205 , p_line_att2 IN VARCHAR2
206 , p_line_att3 IN VARCHAR2
207 , p_line_att4 IN VARCHAR2
208 , p_line_att5 IN VARCHAR2
209 , p_line_att6 IN VARCHAR2
210 , p_line_att7 IN VARCHAR2
214 , p_line_att11 IN VARCHAR2
211 , p_line_att8 IN VARCHAR2
212 , p_line_att9 IN VARCHAR2
213 , p_line_att10 IN VARCHAR2
215 , p_line_att12 IN VARCHAR2
216 , p_line_att13 IN VARCHAR2
217 , p_line_att14 IN VARCHAR2
218 , p_line_att15 IN VARCHAR2
219 , p_shipment_att1 IN VARCHAR2
220 , p_shipment_att2 IN VARCHAR2
221 , p_shipment_att3 IN VARCHAR2
222 , p_shipment_att4 IN VARCHAR2
223 , p_shipment_att5 IN VARCHAR2
224 , p_shipment_att6 IN VARCHAR2
225 , p_shipment_att7 IN VARCHAR2
226 , p_shipment_att8 IN VARCHAR2
227 , p_shipment_att9 IN VARCHAR2
228 , p_shipment_att10 IN VARCHAR2
229 , p_shipment_att11 IN VARCHAR2
230 , p_shipment_att12 IN VARCHAR2
231 , p_shipment_att13 IN VARCHAR2
232 , p_shipment_att14 IN VARCHAR2
233 , p_shipment_att15 IN VARCHAR2
234 , p_distribution_att1 IN VARCHAR2
235 , p_distribution_att2 IN VARCHAR2
236 , p_distribution_att3 IN VARCHAR2
237 , p_distribution_att4 IN VARCHAR2
238 , p_distribution_att5 IN VARCHAR2
239 , p_distribution_att6 IN VARCHAR2
240 , p_distribution_att7 IN VARCHAR2
241 , p_distribution_att8 IN VARCHAR2
242 , p_distribution_att9 IN VARCHAR2
243 , p_distribution_att10 IN VARCHAR2
244 , p_distribution_att11 IN VARCHAR2
245 , p_distribution_att12 IN VARCHAR2
246 , p_distribution_att13 IN VARCHAR2
247 , p_distribution_att14 IN VARCHAR2
248 , p_distribution_att15 IN VARCHAR2
249 , p_fb_error_msg IN OUT NOCOPY VARCHAR2
250 , p_Award_id IN NUMBER
251 , p_vendor_site_id IN NUMBER
252 );
253
254 --========================================================================
255 -- PROCEDURE : Create_Documents PUBLIC
256 -- PARAMETERS : p_batch_id Batch Id
257 -- p_document_id Document Id that was created
258 -- p_document_number Document number
259 -- p_line Number of lines created
260 -- x_error_code Return status
261 -- COMMENT : Wrapper to the PO autocreate to create document
262 --========================================================================
263 PROCEDURE create_documents
264 ( p_batch_id IN NUMBER
265 , p_document_id IN OUT NOCOPY NUMBER
266 , p_document_number IN OUT NOCOPY VARCHAR2
267 , p_line IN OUT NOCOPY NUMBER
268 , x_error_code OUT NOCOPY NUMBER
269 );
270
271 --========================================================================
272 -- PROCEDURE : Get_Break_Price PUBLIC
273 -- PARAMETERS: p_order_quantity Quantity
274 -- p_ship_to_org Ship to Org
275 -- p_ship_to_loc Ship to location
276 -- p_po_line_id PO Line Id
277 -- p_cum_flag Cumulative flag
278 -- p_need_by_date Need by Date
279 -- p_line_location_id Line location
280 -- x_po_price PO price without tax
281 -- COMMENT : Wrapper to the PO API to get price breaks
282 --========================================================================
283 /*PROCEDURE get_break_price
284 ( p_order_quantity IN NUMBER
285 , p_ship_to_org IN NUMBER
286 , p_ship_to_loc IN NUMBER
287 , p_po_line_id IN NUMBER
288 , p_cum_flag IN BOOLEAN
289 , p_need_by_date IN DATE
290 , p_line_location_id IN NUMBER
291 , x_po_price OUT NOCOPY NUMBER
292 );*/
293
294 /* get break price api changes for Advanced pricing uptake - Bug 5076263 */
295 PROCEDURE get_break_price(
296 p_api_version IN NUMBER
297 , p_order_quantity IN NUMBER
298 , p_ship_to_org IN NUMBER
299 , p_ship_to_loc IN NUMBER
300 , p_po_line_id IN NUMBER
301 , p_cum_flag IN BOOLEAN
302 , p_need_by_date IN DATE
303 , p_line_location_id IN NUMBER
304 , p_contract_id IN NUMBER
305 , p_org_id IN NUMBER
306 , p_supplier_id IN NUMBER
307 , p_supplier_site_id IN NUMBER
308 , p_creation_date IN DATE
309 , p_order_header_id IN NUMBER
310 , p_order_line_id IN NUMBER
311 , p_line_type_id IN NUMBER
312 , p_item_revision IN VARCHAR2
313 , p_item_id IN NUMBER
314 , p_category_id IN NUMBER
315 , p_supplier_item_num IN VARCHAR2
316 , p_uom IN VARCHAR2
317 , p_in_price IN NUMBER
318 , p_currency_code IN VARCHAR2
319 , x_base_unit_price OUT NOCOPY NUMBER
320 , x_price_break_id OUT NOCOPY NUMBER
321 , x_price OUT NOCOPY NUMBER
322 , x_return_status OUT NOCOPY VARCHAR2 );
323
324
325 --========================================================================
326 -- FUNCTION : Is_Global PUBLIC
327 -- PARAMETERS: p_header_id Blanket header Id
328 -- COMMENT : Wrapper to the PO API to check for Global Agreement
332 ) RETURN BOOLEAN;
329 --========================================================================
330 FUNCTION is_global
331 ( p_header_id IN NUMBER
333
334
335 --========================================================================
336 -- PROCEDURE : archive_po PUBLIC
337 -- PARAMETERS : p_api_version API version
338 -- p_document_id Document Id
339 -- p_document_type Document Type
340 -- p_document_subtype Document subtype
341 -- x_return_status Return status
342 -- x_msg_data Message
343 -- COMMENT : Wrapper to the PO archiving to archive PO
344 --========================================================================
345 PROCEDURE archive_po
346 ( p_api_version IN NUMBER
347 , p_document_id IN NUMBER
348 , p_document_type IN VARCHAR2
349 , p_document_subtype IN VARCHAR2
350 , x_return_status OUT NOCOPY VARCHAR2
351 , x_msg_data OUT NOCOPY VARCHAR2
352 );
353
354 --========================================================================
355 -- PROCEDURE : indicate_global PUBLIC
356 -- PARAMETERS : p_transaction_source_id
357 -- COMMENT : determine if records in mtl_consumption_transactions
358 -- : as belonging to a global or local agreement
359 --========================================================================
360 PROCEDURE indicate_global
361 ( p_transaction_source_id IN NUMBER
362 , x_global_agreement_flag OUT NOCOPY VARCHAR2
363 );
364
365 --========================================================================
366 -- FUNCTION : get_Total PUBLIC
367 -- PARAMETERS: p_object_type Object
368 -- p_header_id Header Id
369 -- COMMENT : Call the PO API to check for total released amt for a blanket
370 --========================================================================
371 FUNCTION get_Total
372 ( p_header_id IN NUMBER
373 , p_object_type IN VARCHAR2
374 ) RETURN NUMBER;
375
376
377 END INV_PO_THIRD_PARTY_STOCK_MDTR;