[Home] [Help]
PACKAGE: APPS.OE_BLANKET_PUB
Source
1 PACKAGE OE_Blanket_PUB AUTHID CURRENT_USER AS
2 /* $Header: OEXPBSOS.pls 120.1.12010000.3 2009/01/05 22:40:17 smusanna ship $ */
3 /*#
4 * This public API allows users to create Blanket Agreements Order Management system.
5 * @rep:scope public
6 * @rep:product ONT
7 * @rep:lifecycle active
8 * @rep:displayname Sales Agreement API
9 * @rep:category BUSINESS_ENTITY ONT_SALES_AGREEMENT
10 */
11 G_ENTITY_BLANKET_ALL CONSTANT VARCHAR2(30) := 'BLANKET_ALL';
12 G_ENTITY_BLANKET_LINE CONSTANT VARCHAR2(30) := 'BLANKET_LINE';
13 G_ENTITY_BLANKET_HEADER CONSTANT VARCHAR2(30) := 'BLANKET_HEADER';
14
15 -- Blanket Header record type
16 TYPE header_rec_Type IS RECORD
17 ( accounting_rule_id NUMBER
18 , agreement_id NUMBER
19 , attribute1 VARCHAR2(240)
20 , attribute10 VARCHAR2(240)
21 , attribute11 VARCHAR2(240)
22 , attribute12 VARCHAR2(240)
23 , attribute13 VARCHAR2(240)
24 , attribute14 VARCHAR2(240)
25 , attribute15 VARCHAR2(240)
26 , attribute16 VARCHAR2(240)
27 , attribute17 VARCHAR2(240)
28 , attribute18 VARCHAR2(240)
29 , attribute19 VARCHAR2(240)
30 , attribute20 VARCHAR2(240)
31 , attribute2 VARCHAR2(240)
32 , attribute3 VARCHAR2(240)
33 , attribute4 VARCHAR2(240)
34 , attribute5 VARCHAR2(240)
35 , attribute6 VARCHAR2(240)
36 , attribute7 VARCHAR2(240)
37 , attribute8 VARCHAR2(240)
38 , attribute9 VARCHAR2(240)
39 , context VARCHAR2(30)
40 , created_by NUMBER
41 , creation_date DATE
42 , cust_po_number VARCHAR2(50)
43 , deliver_to_org_id NUMBER
44 , freight_terms_code VARCHAR2(30)
45 , header_id NUMBER
46 , invoice_to_org_id NUMBER
47 , invoicing_rule_id NUMBER
48 , last_updated_by NUMBER
49 , last_update_date DATE
50 , last_update_login NUMBER
51 , order_category_code VARCHAR2(30)
52 , order_number NUMBER
53 , order_type_id NUMBER
54 , org_id NUMBER
55 , price_list_id NUMBER
56 , program_application_id NUMBER
57 , program_id NUMBER
58 , program_update_date DATE
59 , request_id NUMBER
60 , version_number number
61 , salesrep_id NUMBER
62 , shipping_method_code VARCHAR2(30)
63 , ship_from_org_id NUMBER
64 , ship_to_org_id NUMBER
65 , sold_to_contact_id NUMBER
66 , sold_to_org_id NUMBER
67 , transactional_curr_code VARCHAR2(15)
68 , return_status VARCHAR2(1)
69 , db_flag VARCHAR2(1)
70 , operation VARCHAR2(30)
71 , payment_term_id number
72 , shipping_instructions varchar2(2000)
73 , packing_instructions varchar2(2000)
74 , Price_list_Name varchar2(240)
75 , Price_list_description varchar2(2000)
76 , price_list_currency_code varchar2(30)
77 , conversion_type_code varchar2(30)
78 , blanket_max_amount NUMBER
79 , blanket_min_amount NUMBER
80 , released_amount Number
81 , fulfilled_amount Number
82 , returned_amount Number
83 , enforce_price_list_flag varchar2(1)
84 , enforce_ship_to_flag varchar2(1)
85 , enforce_invoice_to_flag varchar2(1)
86 , enforce_freight_term_flag varchar2(1)
87 , enforce_shipping_method_flag varchar2(1)
88 , enforce_payment_term_flag varchar2(1)
89 , enforce_accounting_rule_flag varchar2(1)
90 , enforce_invoicing_rule_flag varchar2(1)
91 , lock_control number
92 , on_hold_flag VARCHAR2(1)
93 , override_amount_flag varchar2(1)
94 , start_date_active DATE
95 , end_date_active DATE
96 , revision_change_comments VARCHAR2(2000)
97 , revision_change_date DATE
98 , revision_change_reason_code VARCHAR2(30)
99 , source_document_type_id NUMBER
100 , source_document_id NUMBER
101 -- hashraf start of pack J
102 , SALES_DOCUMENT_NAME VARCHAR2(240)
103 , TRANSACTION_PHASE_CODE VARCHAR2(30)
104 , USER_STATUS_CODE VARCHAR2(30)
105 , flow_status_code VARCHAR2(30)
106 , SUPPLIER_SIGNATURE VARCHAR2(240)
107 , SUPPLIER_SIGNATURE_DATE DATE
108 , CUSTOMER_SIGNATURE VARCHAR2(240)
109 , CUSTOMER_SIGNATURE_DATE DATE
110 , SOLD_TO_SITE_USE_ID NUMBER
111 , DRAFT_SUBMITTED_FLAG VARCHAR2(1)
112 , SOURCE_DOCUMENT_VERSION_NUMBER NUMBER
113 , contract_template_id NUMBER --abkumar
114 -- 11i10 Pricing Changes
115 , new_price_list_id NUMBER
116 , new_price_list_name VARCHAR2(240)
117 , new_modifier_list_id NUMBER
118 , new_modifier_list_name VARCHAR2(240)
119 , default_discount_percent NUMBER
120 , default_discount_amount NUMBER
121 , open_flag VARCHAR2(1)
122 );
123 -- hashraf end of pack J
124 TYPE Blanket_Hdr_Tbl_Type IS TABLE OF header_rec_type
125 INDEX BY BINARY_INTEGER;
126
127
128 TYPE Header_Val_Rec_Type IS RECORD
129 ( accounting_rule VARCHAR2(240)
130 , agreement VARCHAR2(240)
131 , conversion_type VARCHAR2(240)
132 , deliver_to_address1 VARCHAR2(240)
133 , deliver_to_address2 VARCHAR2(240)
134 , deliver_to_address3 VARCHAR2(240)
135 , deliver_to_address4 VARCHAR2(240)
136 , deliver_to_contact VARCHAR2(360)
137 , deliver_to_location VARCHAR2(240)
138 , deliver_to_org VARCHAR2(240)
139 , deliver_to_state VARCHAR2(240)
140 , deliver_to_city VARCHAR2(240)
141 , deliver_to_zip VARCHAR2(240)
142 , deliver_to_country VARCHAR2(240)
143 , deliver_to_county VARCHAR2(240)
144 , deliver_to_province VARCHAR2(240)
145 , freight_terms VARCHAR2(240)
146 , invoice_to_address1 VARCHAR2(240)
147 , invoice_to_address2 VARCHAR2(240)
148 , invoice_to_address3 VARCHAR2(240)
149 , invoice_to_address4 VARCHAR2(240)
150 , invoice_to_state VARCHAR2(240)
151 , invoice_to_city VARCHAR2(240)
152 , invoice_to_zip VARCHAR2(240)
153 , invoice_to_country VARCHAR2(240)
154 , invoice_to_county VARCHAR2(240)
155 , invoice_to_province VARCHAR2(240)
156 , invoice_to_contact VARCHAR2(360)
157 , invoice_to_contact_first_name VARCHAR2(240)
158 , invoice_to_contact_last_name VARCHAR2(240)
159 , invoice_to_location VARCHAR2(240)
160 , invoice_to_org VARCHAR2(240)
161 , invoicing_rule VARCHAR2(240)
162 , order_source VARCHAR2(240)
163 , order_type VARCHAR2(240)
164 , payment_term VARCHAR2(240)
165 , price_list VARCHAR2(240)
166 , salesrep VARCHAR2(240)
167 , ship_from_address1 VARCHAR2(240)
168 , ship_from_address2 VARCHAR2(240)
169 , ship_from_address3 VARCHAR2(240)
170 , ship_from_address4 VARCHAR2(240)
171 , ship_from_location VARCHAR2(240)
172 , SHIP_FROM_CITY Varchar(60)
173 , SHIP_FROM_POSTAL_CODE Varchar(60)
174 , SHIP_FROM_COUNTRY Varchar(60)
175 , SHIP_FROM_REGION1 Varchar2(240)
176 , SHIP_FROM_REGION2 Varchar2(240)
177 , SHIP_FROM_REGION3 Varchar2(240)
178 , ship_from_org VARCHAR2(240)
179 , sold_to_address1 VARCHAR2(240)
180 , sold_to_address2 VARCHAR2(240)
181 , sold_to_address3 VARCHAR2(240)
182 , sold_to_address4 VARCHAR2(240)
183 , sold_to_state VARCHAR2(240)
184 , sold_to_country VARCHAR2(240)
185 , sold_to_zip VARCHAR2(240)
186 , sold_to_county VARCHAR2(240)
187 , sold_to_province VARCHAR2(240)
188 , sold_to_city VARCHAR2(240)
189 , sold_to_contact_last_name VARCHAR2(240)
190 , sold_to_contact_first_name VARCHAR2(240)
191 , ship_to_address1 VARCHAR2(240)
192 , ship_to_address2 VARCHAR2(240)
193 , ship_to_address3 VARCHAR2(240)
194 , ship_to_address4 VARCHAR2(240)
195 , ship_to_state VARCHAR2(240)
196 , ship_to_country VARCHAR2(240)
197 , ship_to_zip VARCHAR2(240)
198 , ship_to_county VARCHAR2(240)
199 , ship_to_province VARCHAR2(240)
200 , ship_to_city VARCHAR2(240)
201 , ship_to_contact VARCHAR2(360)
202 , ship_to_contact_last_name VARCHAR2(240)
203 , ship_to_contact_first_name VARCHAR2(240)
204 , ship_to_location VARCHAR2(240)
205 , ship_to_org VARCHAR2(240)
206 , sold_to_contact VARCHAR2(360)
207 , sold_to_org VARCHAR2(360)
208 , sold_from_org VARCHAR2(240)
209 , tax_exempt VARCHAR2(240)
210 , tax_exempt_reason VARCHAR2(240)
211 , tax_point VARCHAR2(240)
212 , customer_payment_term VARCHAR2(240)
213 , freight_carrier VARCHAR2(80)
214 , shipping_method VARCHAR2(80)
215 , customer_number VARCHAR2(30)
216 , ship_to_customer_name VARCHAR2(360)
217 , invoice_to_customer_name VARCHAR2(360)
218 , ship_to_customer_number VARCHAR2(50)
219 , invoice_to_customer_number VARCHAR2(50)
220 , deliver_to_customer_number VARCHAR2(50)
221 , deliver_to_customer_name VARCHAR2(360)
222 , blanket_agreement_name VARCHAR2(360)
223 , contract_template VARCHAR2(60)
224 );
225
226 TYPE Blanket_Hdr_Val_Tbl_Type IS TABLE OF header_val_rec_type
227 INDEX BY BINARY_INTEGER;
228
229 -- Blanket Line record type
230
231 TYPE Line_Rec_Type IS RECORD
232 ( accounting_rule_id NUMBER
233 , agreement_id NUMBER
234 , attribute1 VARCHAR2(240)
235 , attribute10 VARCHAR2(240)
236 , attribute11 VARCHAR2(240)
237 , attribute12 VARCHAR2(240)
238 , attribute13 VARCHAR2(240)
239 , attribute14 VARCHAR2(240)
240 , attribute15 VARCHAR2(240)
241 , attribute16 VARCHAR2(240)
242 , attribute17 VARCHAR2(240)
243 , attribute18 VARCHAR2(240)
244 , attribute19 VARCHAR2(240)
245 , attribute20 VARCHAR2(240)
246 , attribute2 VARCHAR2(240)
247 , attribute3 VARCHAR2(240)
248 , attribute4 VARCHAR2(240)
249 , attribute5 VARCHAR2(240)
250 , attribute6 VARCHAR2(240)
251 , attribute7 VARCHAR2(240)
252 , attribute8 VARCHAR2(240)
253 , attribute9 VARCHAR2(240)
254 , context VARCHAR2(30)
255 , created_by NUMBER
256 , creation_date DATE
257 , cust_po_number VARCHAR2(50)
258 , deliver_to_org_id NUMBER
259 , freight_terms_code VARCHAR2(30)
260 , global_attribute_category VARCHAR2(30)
261 , header_id NUMBER
262 , inventory_item_id NUMBER
263 , invoice_to_org_id NUMBER
264 , invoicing_rule_id NUMBER
265 , ordered_item VARCHAR2(2000)
266 , ordered_item_id NUMBER
267 , last_updated_by NUMBER
268 , last_update_date DATE
269 , last_update_login NUMBER
270 , line_type_id NUMBER
271 , line_id NUMBER
272 , line_number NUMBER
273 , order_number VARCHAR2(240)
274 , order_quantity_uom VARCHAR2(30)
275 , org_id NUMBER
276 , payment_term_id NUMBER
277 , preferred_grade VARCHAR2(150) -- INVCONV 4091955
278 , price_list_id NUMBER
279 , request_id NUMBER
280 , program_id NUMBER
281 , program_application_id NUMBER
282 , program_update_date DATE
283 , shipping_method_code VARCHAR2(30)
284 , ship_from_org_id NUMBER
285 , ship_to_org_id NUMBER
286 , sold_to_org_id NUMBER
287 , return_status VARCHAR2(1)
288 , db_flag VARCHAR2(1)
289 , operation VARCHAR2(30)
290 , item_identifier_type VARCHAR2(30)
291 , item_type_code varchar2(30)
292 , shipping_instructions VARCHAR2(2000)
293 , packing_instructions VARCHAR2(2000)
294 , salesrep_id number
295 , unit_list_price number
296 , pricing_uom varchar2(150)
297 , lock_control number
298 , enforce_price_list_flag varchar2(1)
299 , enforce_ship_to_flag varchar2(1)
300 , enforce_invoice_to_flag varchar2(1)
301 , enforce_freight_term_flag varchar2(1)
302 , enforce_shipping_method_flag varchar2(1)
303 , enforce_payment_term_flag varchar2(1)
304 , enforce_accounting_rule_flag varchar2(1)
305 , enforce_invoicing_rule_flag varchar2(1)
306 , override_blanket_controls_flag varchar2(1)
307 , override_release_controls_flag varchar2(1)
308 , qp_list_line_id NUMBER
309 , fulfilled_quantity number
310 , blanket_min_quantity NUMBER
311 , blanket_max_quantity NUMBER
312 , blanket_min_amount number
313 , blanket_max_amount number
314 , min_release_quantity NUMBER
315 , max_release_quantity NUMBER
316 , min_release_amount number
317 , max_release_amount number
318 , released_amount NUMBER
319 , fulfilled_amount NUMBER
320 , released_quantity number
321 , returned_amount number
322 , returned_quantity number
323 , start_date_active date
324 , end_date_active date
325 , source_document_type_id NUMBER
326 , source_document_id NUMBER
327 , source_document_line_id NUMBER
328 -- hashraf start of pack J
329 , transaction_phase_code VARCHAR2(30)
330 , source_document_version_number NUMBER
331 -- 11i10 Pricing Changes
332 , modifier_list_line_id NUMBER
333 , discount_percent NUMBER
334 , discount_amount NUMBER
335 -- 11i10 Versioning/Reasons Changes
336 , revision_change_comments VARCHAR2(2000)
337 , revision_change_date DATE
338 , revision_change_reason_code VARCHAR2(30)
339 );
340 -- hashraf end of Pack J
341 TYPE Control_Rec_Type IS RECORD
342 ( UI_CALL BOOLEAN := TRUE
343 , validate_attributes BOOLEAN := FALSE
344 , validate_entity BOOLEAN := FALSE
345 , default_From_Header BOOLEAN := TRUE
346 , write_to_db BOOLEAN := TRUE
350
347 , ui_commit BOOLEAN := FALSE
348 , check_security BOOLEAN := FALSE
349 );
351
352
353 TYPE line_tbl_Type IS TABLE OF Line_Rec_Type
354 INDEX BY BINARY_INTEGER;
355
356
357 TYPE Line_Val_Rec_Type IS RECORD
358 ( accounting_rule VARCHAR2(240)
359 , agreement VARCHAR2(240)
360 , deliver_to_address1 VARCHAR2(240)
361 , deliver_to_address2 VARCHAR2(240)
362 , deliver_to_address3 VARCHAR2(240)
363 , deliver_to_address4 VARCHAR2(240)
364 , deliver_to_contact VARCHAR2(360)
365 , deliver_to_location VARCHAR2(240)
366 , deliver_to_org VARCHAR2(240)
367 , deliver_to_state VARCHAR2(240)
368 , deliver_to_city VARCHAR2(240)
369 , deliver_to_zip VARCHAR2(240)
370 , deliver_to_country VARCHAR2(240)
371 , deliver_to_county VARCHAR2(240)
372 , deliver_to_province VARCHAR2(240)
373 , freight_terms VARCHAR2(240)
374 , inventory_item VARCHAR2(240)
375 , invoice_to_address1 VARCHAR2(240)
376 , invoice_to_address2 VARCHAR2(240)
377 , invoice_to_address3 VARCHAR2(240)
378 , invoice_to_address4 VARCHAR2(240)
379 , invoice_to_contact VARCHAR2(360)
380 , invoice_to_location VARCHAR2(240)
381 , invoice_to_org VARCHAR2(240)
382 , invoice_to_state VARCHAR2(240)
383 , invoice_to_city VARCHAR2(240)
384 , invoice_to_zip VARCHAR2(240)
385 , invoice_to_country VARCHAR2(240)
386 , invoice_to_county VARCHAR2(240)
387 , invoice_to_province VARCHAR2(240)
388 , invoicing_rule VARCHAR2(240)
389 , line_type VARCHAR2(240)
390 , payment_term VARCHAR2(240)
391 , price_list VARCHAR2(240)
392 , salesrep VARCHAR2(240)
393 , ship_from_address1 VARCHAR2(240)
394 , ship_from_address2 VARCHAR2(240)
395 , ship_from_address3 VARCHAR2(240)
396 , ship_from_address4 VARCHAR2(240)
397 , ship_from_location VARCHAR2(240)
398 , SHIP_FROM_CITY Varchar(60)
399 , SHIP_FROM_POSTAL_CODE Varchar(60)
400 , SHIP_FROM_COUNTRY Varchar(60)
401 , SHIP_FROM_REGION1 Varchar2(240)
402 , SHIP_FROM_REGION2 Varchar2(240)
403 , SHIP_FROM_REGION3 Varchar2(240)
404 , ship_from_org VARCHAR2(240)
405 , ship_to_address1 VARCHAR2(240)
406 , ship_to_address2 VARCHAR2(240)
407 , ship_to_address3 VARCHAR2(240)
408 , ship_to_address4 VARCHAR2(240)
409 , ship_to_state VARCHAR2(240)
410 , ship_to_country VARCHAR2(240)
411 , ship_to_zip VARCHAR2(240)
412 , ship_to_county VARCHAR2(240)
413 , ship_to_province VARCHAR2(240)
414 , ship_to_city VARCHAR2(240)
415 , ship_to_contact VARCHAR2(360)
416 , ship_to_contact_last_name VARCHAR2(240)
417 , ship_to_contact_first_name VARCHAR2(240)
418 , ship_to_location VARCHAR2(240)
419 , ship_to_org VARCHAR2(240)
420 , source_type VARCHAR2(240)
421 , sold_to_org VARCHAR2(360)
422 , sold_from_org VARCHAR2(240)
423 , ship_to_customer_name VARCHAR2(360)
424 , invoice_to_customer_name VARCHAR2(360)
425 , ship_to_customer_number VARCHAR2(50)
426 , invoice_to_customer_number VARCHAR2(50)
427 , deliver_to_customer_number VARCHAR2(50)
428 , deliver_to_customer_name VARCHAR2(360)
429 , blanket_agreement_name VARCHAR2(360)
430 );
431
432 TYPE line_Val_tbl_Type IS TABLE OF Line_Val_Rec_Type
433 INDEX BY BINARY_INTEGER;
434
435 TYPE Request_Rec_Type IS RECORD
436 (
437 -- Object for which the delayed request has been logged
438 -- ie BLANKET LINE, BLANKET HEADER
439 Entity_code Varchar2(30):= NULL,
440
441 -- Primary key for the object as in entity_code
442 Entity_id Number := NULL,
443 request_type Varchar2(30) := NULL,
444 -- Keys to identify a unique request.
445 request_unique_key1 VARCHAR2(30) := NULL,
446 request_unique_key2 VARCHAR2(30) := NULL,
447 request_unique_key3 VARCHAR2(30) := NULL,
448 param1 Varchar2(2000) := NULL,
449 param2 Varchar2(240) := NULL,
450 param3 Varchar2(240) := NULL,
451 paramtext1 Varchar2(2000) := NULL,
452 paramtext2 Varchar2(2000) := NULL,
453 date_param1 DATE := NULL,
454 date_param2 DATE := NULL,
455 date_param3 DATE := NULL
456 );
457
458 TYPE Request_Tbl_Type IS TABLE OF Request_Rec_Type
459 INDEX BY BINARY_INTEGER;
460
461
462 G_MISS_header_rec header_rec_type;
463 G_MISS_header_Val_rec header_val_rec_type;
464 G_MISS_BLANKET_LINE_REC line_rec_type;
465 G_MISS_BLANKET_LINE_VAL_REC line_val_rec_type;
466 G_MISS_line_tbl line_tbl_type;
467 G_MISS_line_Val_tbl line_Val_tbl_Type;
468 G_MISS_CONTROL_REC control_rec_type;
469
470 -- Public Blanket order API
471 /*#
472 * Use this procedure to create Blanket Agreement in the Order Management system.
473 * @param p_org_id Input OU Organization Id
474 * @param p_operating_unit Input Operating Unit Name
475 * @param p_api_version_number API version used to check call compatibility
476 * @param x_return_status Return status of API call
477 * @param x_msg_count Number of stored processing messages
478 * @param x_msg_data Processing message data
479 * @param p_header_rec Input record structure containing current header-level information for an Agreement
480 * @param p_line_tbl Input table containing current line-level information for an Agreement
481 * @param p_control_rec Input record structure containing current control information for the API call
482 * @param x_header_rec Output record structure containing current header-level information for an Agreement
483 * @param x_line_tbl Output table containing current line-level information for an Agreement
484 * @rep:scope public
485 * @rep:lifecycle active
486 * @rep:category BUSINESS_ENTITY ONT_SALES_AGREEMENT
487 * @rep:displayname Sales Agreement API
488 */
489
490 PROCEDURE Process_Blanket
491 ( p_org_id IN NUMBER := NULL --MOAC
492 , p_operating_unit IN VARCHAR2 := NULL -- MOAC
493 , p_api_version_number IN NUMBER := 1.0
494 , x_return_status OUT NOCOPY VARCHAR2
495 , x_msg_count OUT NOCOPY NUMBER
496 , x_msg_data OUT NOCOPY VARCHAR2
497 , p_header_rec IN header_rec_type :=
498 G_MISS_header_rec
499 , p_header_val_rec IN Header_Val_Rec_Type :=
500 G_MISS_header_Val_rec
501 , p_line_tbl IN line_tbl_Type :=
502 G_MISS_line_tbl
503 , p_line_val_tbl IN line_Val_tbl_Type :=
504 G_MISS_line_Val_tbl
505 , p_control_rec IN Control_rec_type :=
506 G_MISS_CONTROL_REC
507 , x_header_rec OUT NOCOPY header_rec_type
508 , x_line_tbl OUT NOCOPY line_tbl_Type
509 );
510
511
512
513 END OE_Blanket_PUB;