[Home] [Help]
PACKAGE: APPS.ASO_QUOTE_PUB
Source
1 PACKAGE ASO_QUOTE_PUB AUTHID CURRENT_USER as
2 /* $Header: asopqtes.pls 120.20.12020000.4 2013/05/02 21:18:28 ajosephg ship $ */
3 /*# These public APIs allow users to create new quotes, modify existing quotes and convert quotes into orders.
4 * @rep:scope public
5 * @rep:product ASO
6 * @rep:displayname Order Capture
7 * @rep:lifecycle active
8 * @rep:compatibility S
9 * @rep:category BUSINESS_ENTITY ASO_QUOTE
10 */
11
12
13
14 -- Start of Comments
15 -- Package name : ASO_QUOTE_PUB
16 -- Purpose :
17 -- This package contains specification for pl/sql records and tables and the
18 -- Public API of Order Capture.
19 --
20 -- Record Type:
21 -- Control_Rec_Type
22 -- Submit_Control_Rec_Type
23 -- Qte_Header_Rec_Type
24 -- Qte_Sort_Rec_Type
25 -- Qte_Line_Rec_Type
26 -- Qte_Line_sort_rec_type
27 -- Qte_Line_Dtl_Rec_Type
28 -- Price_Attributes_Rec_Type
29 -- Price_Adj_Rec_Type
30 -- PRICE_ADJ_ATTR_Rec_Type
31 -- Price_Adj_Rltship_Rec_Type
32 -- Payment_Rec_Type
33 -- Shipment_Rec_Type
34 -- Freight_Charge_Rec_Type
35 -- Tax_Detail_Rec_Type
36 -- Header_Rltship_Rec_Type
37 -- Line_Rltship_Rec_Type
38 -- Party_Rltship_Rec_Type
39 -- Related_Object_Rec_Type
40 -- Line_Attribs_Ext_Rec_Type
41 -- Config_Vaild_Rec_Type
42 --
43 -- Procedures:
44 -- Create_Quote
45 -- Update_Quote
46 -- Delete_Quote
47 -- Copy_Quote
48 -- Validate_Quote
49 -- Submit_Quote
50 -- Create_Quote_Line
51 -- Update_Quote_Line
52 -- Delete_Quote_Line
53 -- Get_Quote_Lines
54 -- Create_Line_Relationship
55 -- Update_Line_Relationship
56 -- Delete_Line_Relationship
57 -- Create_Header_Relationship
58 -- Update_Header_Relationship
59 -- Delete_Header_Relationship
60 -- Create_Party_Relationship
61 -- Update_Party_Relationship
62 -- Delete_Party_Relationship
63 -- Create_Object_Relationship
64 -- Update_Object_Relationship
65 -- Delete_Object_Relationship
66 -- Create_Price_Adj_Relationship
67 -- Update_Price_Adj_Relationship
68 -- Delete_Price_Adj_Relationship
69 --
70 -- History :
71 -- NOTE :
72
73 -- End of Comments
74
75 -- Default number of records fetch per call
76 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
77 OC_APPL_ID NUMBER := 697;
78
79 --Define constants for macd
80 G_ADD_TO_CONTAINER CONSTANT VARCHAR2(16) := 'ADD_TO_CONTAINER';
81 G_RECONFIGURE CONSTANT VARCHAR2(11) := 'RECONFIGURE';
82 G_DEACTIVATE CONSTANT VARCHAR2(10) := 'DEACTIVATE';
83
84
85 TYPE Control_Rec_Type IS RECORD
86 (
87 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
88 AUTO_VERSION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
89 pricing_request_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
90 header_pricing_event VARCHAR2(30) := FND_API.G_MISS_CHAR,
91 line_pricing_event VARCHAR2(30) := FND_API.G_MISS_CHAR,
92 CALCULATE_TAX_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
93 CALCULATE_FREIGHT_CHARGE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
94 FUNCTIONALITY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
95 COPY_TASK_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
96 COPY_NOTES_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
97 COPY_ATT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
98 DEACTIVATE_ALL VARCHAR2(1) := FND_API.G_FALSE,
99 PRICE_MODE VARCHAR2(30) := 'ENTIRE_QUOTE',
100 QUOTE_SOURCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101 DEPENDENCY_FLAG VARCHAR2(1) := FND_API.G_TRUE,
102 DEFAULTING_FLAG VARCHAR2(1) := FND_API.G_TRUE,
103 DEFAULTING_FWK_FLAG VARCHAR2(1) := 'N',
104 APPLICATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105 Change_Customer_flag VARCHAR2(1) := FND_API.G_FALSE
106 );
107
108
109
110 G_MISS_Control_Rec Control_Rec_Type;
111
112 TYPE Submit_Control_Rec_Type IS RECORD
113 (
114 BOOK_FLAG VARCHAR2(1) := FND_API.G_FALSE,
115 RESERVE_FLAG VARCHAR2(1) := FND_API.G_FALSE,
116 CALCULATE_PRICE VARCHAR2(1) := FND_API.G_FALSE,
117 SERVER_ID NUMBER := -1,
118 CVV2 VARCHAR2(10) := FND_API.G_MISS_CHAR,
119 CC_BY_FAX VARCHAR2(1) := FND_API.G_FALSE,
120 APPLICATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
121 );
122
123 G_MISS_Submit_Control_Rec Submit_Control_Rec_Type;
124
125
126 TYPE Sales_Alloc_Control_Rec_Type IS RECORD
127 (
128 Submit_Quote_Flag VARCHAR2(1) := FND_API.G_FALSE
129 );
130
131 G_MISS_Sales_Alloc_Control_Rec Sales_Alloc_Control_Rec_Type;
132
133
134 -- *******************************************************
135 -- Start of Comments
136 -- -------------------------------------------------------
137 -- Record name:Qte_Header_Rec_Type
138 -- -------------------------------------------------------
139 -- Parameters:
140
141
142 TYPE Qte_Header_Rec_Type IS RECORD
143 (
144 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
145 CREATION_DATE DATE := FND_API.G_MISS_DATE,
146 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
147 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
148 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
149 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
150 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
151 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
152 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
153 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
154 ORG_ID NUMBER := FND_API.G_MISS_NUM,
155 QUOTE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
156 QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
157 QUOTE_VERSION NUMBER := FND_API.G_MISS_NUM,
158 QUOTE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
159 QUOTE_SOURCE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
160 QUOTE_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
161 PRICE_FROZEN_DATE DATE := FND_API.G_MISS_DATE,
162 QUOTE_PASSWORD VARCHAR2(240) := FND_API.G_MISS_CHAR,
163 ORIGINAL_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
164 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
165 CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
166 INVOICE_TO_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
167 ORG_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
168 PHONE_ID NUMBER := FND_API.G_MISS_NUM,
169 INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
170 INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
171 ORIG_MKTG_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
172 MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
173 ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
174 QUOTE_CATEGORY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
175 ORDERED_DATE DATE := FND_API.G_MISS_DATE,
176 ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
177 INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
178 EMPLOYEE_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
179 PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
180 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
181 TOTAL_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
182 TOTAL_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
183 TOTAL_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
184 TOTAL_TAX NUMBER := FND_API.G_MISS_NUM,
185 TOTAL_SHIPPING_CHARGE NUMBER := FND_API.G_MISS_NUM,
186 SURCHARGE NUMBER := FND_API.G_MISS_NUM,
187 TOTAL_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
188 PAYMENT_AMOUNT NUMBER := FND_API.G_MISS_NUM,
189 EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
190 EXCHANGE_TYPE_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
191 EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
192 CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
193 SALES_CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
194 ORDER_ID NUMBER := FND_API.G_MISS_NUM,
195 ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
196 FFM_REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
197 QTE_CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
198 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
199 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
201 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
202 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
203 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
204 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
205 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
206 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
207 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
208 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
209 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
210 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
211 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
212 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
213 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
214 SALESREP_FIRST_NAME VARCHAR2(255) := FND_API.G_MISS_CHAR,
215 SALESREP_LAST_NAME VARCHAR2(255) := FND_API.G_MISS_CHAR,
216 PRICE_LIST_NAME VARCHAR2(255) := FND_API.G_MISS_CHAR,
217 QUOTE_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
218 QUOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
219 PARTY_NAME VARCHAR2(255) := FND_API.G_MISS_CHAR,
220 PARTY_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
221 PERSON_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
222 PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
223 PERSON_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
224 MARKETING_SOURCE_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
225 MARKETING_SOURCE_CODE VARCHAR2(150) := FND_API.G_MISS_CHAR,
226 ORDER_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
227 INVOICE_TO_PARTY_NAME VARCHAR2(255) := FND_API.G_MISS_CHAR,
228 INVOICE_TO_CONTACT_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
229 INVOICE_TO_CONTACT_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
230 INVOICE_TO_CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
231 INVOICE_TO_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
232 INVOICE_TO_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
233 INVOICE_TO_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
234 INVOICE_TO_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
235 INVOICE_TO_COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,
236 INVOICE_TO_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
237 INVOICE_TO_CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
238 INVOICE_TO_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
239 INVOICE_TO_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
240 INVOICE_TO_PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
241 INVOICE_TO_COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
242 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
243 CONTRACT_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
244 CONTRACT_TEMPLATE_MAJOR_VER NUMBER := FND_API.G_MISS_NUM,
245 CONTRACT_REQUESTER_ID NUMBER := FND_API.G_MISS_NUM,
246 CONTRACT_APPROVAL_LEVEL VARCHAR2(30) := FND_API.G_MISS_CHAR,
247 PUBLISH_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
248 RESOURCE_GRP_ID NUMBER := FND_API.G_MISS_NUM,
249 SOLD_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
250 DISPLAY_ARITHMETIC_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
251 MAX_VERSION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
252 QUOTE_TYPE VARCHAR2(1) := FND_API.G_MISS_CHAR,
253 QUOTE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
254 CALL_BATCH_VALIDATION_FLAG VARCHAR2(1) := FND_API.G_TRUE,
255 CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
256 INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
257 MINISITE_ID NUMBER := FND_API.G_MISS_NUM,
258 PRICING_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
259 TAX_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
260 PRICE_UPDATED_DATE DATE := FND_API.G_MISS_DATE,
261 TAX_UPDATED_DATE DATE := FND_API.G_MISS_DATE,
262 RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
263 BATCH_PRICE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
264 PRICE_REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
268 Customer_Signature_Date DATE := FND_API.G_MISS_DATE,
265 CREDIT_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
266 -- hyang new okc
267 Customer_Name_And_Title VARCHAR2(240) := FND_API.G_MISS_CHAR,
269 Supplier_Name_And_Title VARCHAR2(240) := FND_API.G_MISS_CHAR,
270 Supplier_Signature_Date DATE := FND_API.G_MISS_DATE,
271 -- end of hyang new okc
272 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
273 ASSISTANCE_REQUESTED VARCHAR2(1) := FND_API.G_MISS_CHAR,
274 ASSISTANCE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
275 AUTOMATIC_PRICE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
276 AUTOMATIC_TAX_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
277 END_CUSTOMER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
278 END_CUSTOMER_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
279 END_CUSTOMER_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
280 END_CUSTOMER_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
281 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
282 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
283 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
284 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
285 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
286 HEADER_PAYNOW_CHARGES NUMBER := FND_API.G_MISS_NUM,
287 -- ER 12879412
288 PRODUCT_FISC_CLASSIFICATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
289 TRX_BUSINESS_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
290 );
291
292 G_MISS_QTE_HEADER_REC Qte_Header_Rec_Type;
293 TYPE Qte_Header_Tbl_Type IS TABLE OF Qte_Header_Rec_Type
294 INDEX BY BINARY_INTEGER;
295 G_MISS_QTE_HEADER_TBL Qte_Header_Tbl_Type;
296
297
298 TYPE QTE_sort_rec_type IS RECORD
299 (
300 -- Please define your own sort by record here.
301 QUOTE_HEADER_ID NUMBER := NULL
302 );
303
304 -- *******************************************************
305 -- Start of Comments
306 -- -------------------------------------------------------
307 -- Record name:QTE_LINE_Rec_Type
308 -- -------------------------------------------------------
309 -- Parameters:
310 -- QUOTE_LINE_ID
311 -- CREATION_DATE
312 -- CREATED_BY
313 -- LAST_UPDATE_DATE
314 -- LAST_UPDATED_BY
315 -- LAST_UPDATE_LOGIN
316 -- REQUEST_ID
317 -- PROGRAM_APPLICATION_ID
318 -- PROGRAM_ID
319 -- PROGRAM_UPDATE_DATE
320 -- QUOTE_HEADER_ID
321 -- ORG_ID
322 -- LINE_CATEGORY_CODE
323 -- ITEM_TYPE_CODE
324 -- LINE_NUMBER
325 -- START_DATE_ACTIVE
326 -- END_DATE_ACTIVE
327 -- ORDER_LINE_TYPE_ID
328 -- INVOICE_TO_PARTY_SITE_ID
329 -- INVOICE_TO_PARTY_ID
330 -- ORGANIZATION_ID
331 -- INVENTORY_ITEM_ID
332 -- QUANTITY
333 -- UOM_CODE
334 -- MARKETING_SOURCE_CODE_ID
335 -- PRICE_LIST_ID
336 -- PRICE_LIST_LINE_ID
337 -- CURRENCY_CODE
338 -- LINE_LIST_PRICE
339 -- LINE_ADJUSTED_AMOUNT
340 -- LINE_ADJUSTED_PERCENT
341 -- LINE_QUOTE_PRICE
342 -- RELATED_ITEM_ID
343 -- ITEM_RELATIONSHIP_TYPE
344 -- ACCOUNTING_RULE_ID
345 -- INVOICING_RULE_ID
346 -- SPLIT_SHIPMENT_FLAG
347 -- BACKORDER_FLAG
348 -- MINISITE_ID
349 -- SECTION_ID
350 -- SELLING_PRICE_CHANGE
351 -- RECALCULATE_FLAG
352 -- ATTRIBUTE_CATEGORY
353 -- ATTRIBUTE1
354 -- ATTRIBUTE2
355 -- ATTRIBUTE3
356 -- ATTRIBUTE4
357 -- ATTRIBUTE5
358 -- ATTRIBUTE6
359 -- ATTRIBUTE7
360 -- ATTRIBUTE8
361 -- ATTRIBUTE9
362 -- ATTRIBUTE10
363 -- ATTRIBUTE11
364 -- ATTRIBUTE12
365 -- ATTRIBUTE13
366 -- ATTRIBUTE14
367 -- ATTRIBUTE15
368 -- FFM_CONTENT_NAME
369 -- FFM_DOCUMENT_TYPE
370 -- FFM_MEDIA_TYPE
371 -- FFM_MEDIA_ID
372 -- FFM_CONTENT_TYPE
373 -- FFM_USER_NOTE
374 -- PRICED_PRICE_LIST_ID
375 -- AGREEMENT_ID
376 -- COMMITMENT_ID
377 -- PRICING_QUANTITY_UOM
378 -- PRICING_QUANTITY
379 -- SUBSCRIPTION_ENABLE_FLAG
380 -- PROJECT_ID
381 -- TASK_ID
382 -- OBJECT_VERSION_NUMBER
383 --
384 -- Required:
385 -- Defaults:
386 -- Note: This is automatic generated record definition, it includes all columns
387 -- defined in the table, developer must manually add or delete some of the attributes.
388 --
389 -- End of Comments
390
391 TYPE QTE_LINE_Rec_Type IS RECORD
392 (
393 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
394 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
395 CREATION_DATE DATE := FND_API.G_MISS_DATE,
396 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
397 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
398 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
399 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
400 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
401 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
402 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
403 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
404 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
405 ORG_ID NUMBER := FND_API.G_MISS_NUM,
409 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
406 LINE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
407 ITEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
408 LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
410 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
411 ORDER_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
412 INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
413 INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
414 INVOICE_TO_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
415 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
416 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
417 QUANTITY NUMBER := FND_API.G_MISS_NUM,
418 UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
419 PRICING_QUANTITY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
420 MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
421 PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
422 PRICE_LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
423 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
424 LINE_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
425 LINE_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
426 LINE_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
427 LINE_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
428 RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
429 ITEM_RELATIONSHIP_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
430 ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
431 INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
432 SPLIT_SHIPMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
433 BACKORDER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
434 MINISITE_ID NUMBER := FND_API.G_MISS_NUM,
435 SECTION_ID NUMBER := FND_API.G_MISS_NUM,
436 SELLING_PRICE_CHANGE VARCHAR2(1) := FND_API.G_MISS_CHAR,
437 RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
438 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
439 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
440 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
441 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
442 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
443 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
444 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
445 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
446 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
447 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
448 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
449 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
450 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
451 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
452 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
453 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
454 FFM_CONTENT_NAME VARCHAR2(250) := FND_API.G_MISS_CHAR,
455 FFM_DOCUMENT_TYPE VARCHAR2(250) := FND_API.G_MISS_CHAR,
456 FFM_MEDIA_TYPE VARCHAR2(250) := FND_API.G_MISS_CHAR,
457 FFM_MEDIA_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
458 FFM_CONTENT_TYPE VARCHAR2(250) := FND_API.G_MISS_CHAR,
459 FFM_USER_NOTE VARCHAR2(250) := FND_API.G_MISS_CHAR,
460 PRICED_PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
461 AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
462 COMMITMENT_ID NUMBER := FND_API.G_MISS_NUM,
463 DISPLAY_ARITHMETIC_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
464 PRICING_STATUS_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
465 PRICING_STATUS_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
466 LINE_TYPE_SOURCE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
467 SERVICE_ITEM_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
468 SERVICEABLE_PRODUCT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
469 INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
470 IS_LINE_CHANGED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
471 UI_LINE_NUMBER VARCHAR2(4000) := FND_API.G_MISS_CHAR,
472 PRICING_LINE_TYPE_INDICATOR VARCHAR2(3) := FND_API.G_MISS_CHAR,
473 ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
474 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
475 SHIP_MODEL_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
476 END_CUSTOMER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
477 END_CUSTOMER_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
478 END_CUSTOMER_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
479 END_CUSTOMER_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
480 CHARGE_PERIODICITY_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
481 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
482 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
483 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
484 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
485 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
486 LINE_PAYNOW_CHARGES NUMBER := FND_API.G_MISS_NUM,
487 LINE_PAYNOW_TAX NUMBER := FND_API.G_MISS_NUM,
491 , subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
488 LINE_PAYNOW_SUBTOTAL NUMBER := FND_API.G_MISS_NUM,
489 PRICING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
490 CONFIG_MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
492 -- ER 12879412
493 PRODUCT_FISC_CLASSIFICATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
494 TRX_BUSINESS_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
495 --Bug#16283049
496 SUBSCRIPTION_ENABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
497 --ER 12839824
498 project_id NUMBER := FND_API.G_MISS_NUM,
499 task_id NUMBER := FND_API.G_MISS_NUM
500 );
501
502 G_MISS_QTE_LINE_REC QTE_LINE_Rec_Type;
503 TYPE QTE_LINE_Tbl_Type IS TABLE OF QTE_LINE_Rec_Type
504 INDEX BY BINARY_INTEGER;
505 G_MISS_QTE_LINE_TBL QTE_LINE_Tbl_Type;
506
507
508 TYPE Qte_Line_sort_rec_type IS RECORD
509 (
510 -- Please define your own sort by record here.
511 QUOTE_HEADER_ID NUMBER := NULL
512 );
513
514
515 -- *******************************************************
516 -- Start of Comments
517 -- -------------------------------------------------------
518 -- Record name:Qte_Line_Dtl_Rec_Type
519 -- -------------------------------------------------------
520 -- Parameters:
521 -- QUOTE_LINE_ID
522 -- QUOTE_LINE_DETAIL_ID
523 -- CONFIG_HEADER_ID
524 -- COMPLETE_CONFIGURATION
525 -- CONFIG_REV_NBR
526 -- VALID_CONFIGURATION
527 -- CP_SERVICE_ID
528 -- SERVICE_COTERMINATE_FLAG
529 -- SERVICE_DURATION
530 -- ORG_ID
531 --
532 -- Required:
533 -- Defaults:
534 -- Note: This is automatic generated record definition, it includes all columns
535 -- defined in the table, developer must manually add or delete some of the attributes.
536 --
537 -- End of Comments
538
539 TYPE qte_line_dtl_Rec_Type IS RECORD
540 (
541 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
542 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
543 QUOTE_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
544 CREATION_DATE DATE := FND_API.G_MISS_DATE,
545 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
546 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
547 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
548 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
549 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
550 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
551 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
552 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
553 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
554 CONFIG_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
555 CONFIG_REVISION_NUM NUMBER := FND_API.G_MISS_NUM,
556 CONFIG_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
557 COMPLETE_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
558 VALID_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
559 COMPONENT_CODE VARCHAR2(1200) := FND_API.G_MISS_CHAR,
560 SERVICE_COTERMINATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
561 SERVICE_DURATION NUMBER := FND_API.G_MISS_NUM,
562 SERVICE_PERIOD VARCHAR2(3) := FND_API.G_MISS_CHAR,
563 SERVICE_UNIT_SELLING_PERCENT NUMBER := FND_API.G_MISS_NUM,
564 SERVICE_UNIT_LIST_PERCENT NUMBER := FND_API.G_MISS_NUM,
565 SERVICE_NUMBER NUMBER := FND_API.G_MISS_NUM,
566 UNIT_PERCENT_BASE_PRICE NUMBER := FND_API.G_MISS_NUM,
567 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
568 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
569 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
570 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
571 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
572 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
573 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
574 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
575 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
576 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
577 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
578 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
579 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
580 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
581 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
582 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
583 SERVICE_REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
584 SERVICE_REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
585 SERVICE_REF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
586 SERVICE_REF_QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
587 SERVICE_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
588 SERVICE_REF_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
589 SERVICE_REF_OPTION_NUMB NUMBER := FND_API.G_MISS_NUM,
590 SERVICE_REF_SHIPMENT_NUMB NUMBER := FND_API.G_MISS_NUM,
591 RETURN_REF_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
592 RETURN_REF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
593 RETURN_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
594 RETURN_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
598 RETURN_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
595 RETURN_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
596 RETURN_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
597 RETURN_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
599 RETURN_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
600 RETURN_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
601 RETURN_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
602 RETURN_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
603 RETURN_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
604 RETURN_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
605 RETURN_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
606 RETURN_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
607 RETURN_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
608 RETURN_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
609 RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
610 RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
611 CHANGE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
612 PARENT_CONFIG_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
613 REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
614 REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
615 REF_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
616 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
617 BOM_SORT_ORDER VARCHAR2(480) := FND_API.G_MISS_CHAR,
618 CONFIG_DELTA NUMBER := FND_API.G_MISS_NUM,
619 CONFIG_INSTANCE_NAME VARCHAR2(255) := FND_API.G_MISS_CHAR,
620 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
621 TOP_MODEL_LINE_ID NUMBER := FND_API.G_MISS_NUM,
622 TOP_MODEL_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
623 ATO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
624 ATO_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
625 COMPONENT_SEQUENCE_ID NUMBER := FND_API.G_MISS_NUM,
626 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
627 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
628 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
629 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
630 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR
631 );
632
633 G_MISS_Qte_Line_Dtl_REC Qte_Line_Dtl_Rec_Type;
634 TYPE Qte_Line_Dtl_Tbl_Type IS TABLE OF Qte_Line_Dtl_Rec_Type
635 INDEX BY BINARY_INTEGER;
636 G_MISS_Qte_Line_Dtl_TBL Qte_Line_Dtl_Tbl_Type;
637
638 --bug 11696691
639 TYPE Qte_Line_Dtl_Tbl_Type1 IS TABLE OF Qte_Line_Dtl_Rec_Type
640 INDEX BY VARCHAR2(32767);
641 G_MISS_Qte_Line_Dtl_TBL1 Qte_Line_Dtl_Tbl_Type1;
642 -- end bug 11696691
643
644
645
646 -- *******************************************************
647 -- Start of Comments
648 -- -------------------------------------------------------
649 -- Record name: Price_Attributes_Rec_Type
650 -- -------------------------------------------------------
651 -- Parameters:
652 -- PRICE_ATTRIBUTES_ID
653 -- CREATION_DATE
654 -- CREATED_BY
655 -- LAST_UPDATE_DATE
656 -- LAST_UPDATED_BY
657 -- LAST_UPDATE_LOGIN
658 -- REQUEST_ID
659 -- PROGRAM_APPLICATION_ID
660 -- PROGRAM_ID
661 -- PROGRAM_UPDATE_DATE
662 -- QUOTE_HEADER_ID
663 -- QUOTE_LINE_ID
664 -- ATTRIBUTE_CATEGORY
665 -- ATTRIBUTE1
666 -- ATTRIBUTE2
667 -- ATTRIBUTE3
668 -- ATTRIBUTE4
669 -- ATTRIBUTE5
670 -- ATTRIBUTE6
671 -- ATTRIBUTE7
672 -- ATTRIBUTE8
673 -- ATTRIBUTE9
674 -- ATTRIBUTE10
675 -- ATTRIBUTE11
676 -- ATTRIBUTE12
677 -- ATTRIBUTE13
678 -- ATTRIBUTE14
679 -- ATTRIBUTE15
680 -- OBJECT_VERSION_NUMBER
681 --
682 -- Required:
683 -- Defaults:
684 -- Note: This is automatic generated record definition, it includes all columns
685 -- defined in the table, developer must manually add or delete some of the attributes.
686 --
687 -- End of Comments
688
689 TYPE Price_Attributes_Rec_Type IS RECORD
690 (
691 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
692 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
693 PRICE_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
694 CREATION_DATE DATE := FND_API.G_MISS_DATE,
695 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
696 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
697 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
698 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
699 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
700 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
701 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
702 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
703 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
704 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
705 FLEX_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
706 PRICING_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
707 PRICING_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
711 PRICING_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
708 PRICING_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
709 PRICING_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
710 PRICING_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
712 PRICING_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
713 PRICING_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
714 PRICING_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
715 PRICING_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
716 PRICING_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
717 PRICING_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
718 PRICING_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
719 PRICING_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
720 PRICING_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
721 PRICING_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
722 PRICING_ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
723 PRICING_ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
724 PRICING_ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
725 PRICING_ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
726 PRICING_ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
727 PRICING_ATTRIBUTE21 VARCHAR2(240) := FND_API.G_MISS_CHAR,
728 PRICING_ATTRIBUTE22 VARCHAR2(240) := FND_API.G_MISS_CHAR,
729 PRICING_ATTRIBUTE23 VARCHAR2(240) := FND_API.G_MISS_CHAR,
730 PRICING_ATTRIBUTE24 VARCHAR2(240) := FND_API.G_MISS_CHAR,
731 PRICING_ATTRIBUTE25 VARCHAR2(240) := FND_API.G_MISS_CHAR,
732 PRICING_ATTRIBUTE26 VARCHAR2(240) := FND_API.G_MISS_CHAR,
733 PRICING_ATTRIBUTE27 VARCHAR2(240) := FND_API.G_MISS_CHAR,
734 PRICING_ATTRIBUTE28 VARCHAR2(240) := FND_API.G_MISS_CHAR,
735 PRICING_ATTRIBUTE29 VARCHAR2(240) := FND_API.G_MISS_CHAR,
736 PRICING_ATTRIBUTE30 VARCHAR2(240) := FND_API.G_MISS_CHAR,
737 PRICING_ATTRIBUTE31 VARCHAR2(240) := FND_API.G_MISS_CHAR,
738 PRICING_ATTRIBUTE32 VARCHAR2(240) := FND_API.G_MISS_CHAR,
739 PRICING_ATTRIBUTE33 VARCHAR2(240) := FND_API.G_MISS_CHAR,
740 PRICING_ATTRIBUTE34 VARCHAR2(240) := FND_API.G_MISS_CHAR,
741 PRICING_ATTRIBUTE35 VARCHAR2(240) := FND_API.G_MISS_CHAR,
742 PRICING_ATTRIBUTE36 VARCHAR2(240) := FND_API.G_MISS_CHAR,
743 PRICING_ATTRIBUTE37 VARCHAR2(240) := FND_API.G_MISS_CHAR,
744 PRICING_ATTRIBUTE38 VARCHAR2(240) := FND_API.G_MISS_CHAR,
745 PRICING_ATTRIBUTE39 VARCHAR2(240) := FND_API.G_MISS_CHAR,
746 PRICING_ATTRIBUTE40 VARCHAR2(240) := FND_API.G_MISS_CHAR,
747 PRICING_ATTRIBUTE41 VARCHAR2(240) := FND_API.G_MISS_CHAR,
748 PRICING_ATTRIBUTE42 VARCHAR2(240) := FND_API.G_MISS_CHAR,
749 PRICING_ATTRIBUTE43 VARCHAR2(240) := FND_API.G_MISS_CHAR,
750 PRICING_ATTRIBUTE44 VARCHAR2(240) := FND_API.G_MISS_CHAR,
751 PRICING_ATTRIBUTE45 VARCHAR2(240) := FND_API.G_MISS_CHAR,
752 PRICING_ATTRIBUTE46 VARCHAR2(240) := FND_API.G_MISS_CHAR,
753 PRICING_ATTRIBUTE47 VARCHAR2(240) := FND_API.G_MISS_CHAR,
754 PRICING_ATTRIBUTE48 VARCHAR2(240) := FND_API.G_MISS_CHAR,
755 PRICING_ATTRIBUTE49 VARCHAR2(240) := FND_API.G_MISS_CHAR,
756 PRICING_ATTRIBUTE50 VARCHAR2(240) := FND_API.G_MISS_CHAR,
757 PRICING_ATTRIBUTE51 VARCHAR2(240) := FND_API.G_MISS_CHAR,
758 PRICING_ATTRIBUTE52 VARCHAR2(240) := FND_API.G_MISS_CHAR,
759 PRICING_ATTRIBUTE53 VARCHAR2(240) := FND_API.G_MISS_CHAR,
760 PRICING_ATTRIBUTE54 VARCHAR2(240) := FND_API.G_MISS_CHAR,
761 PRICING_ATTRIBUTE55 VARCHAR2(240) := FND_API.G_MISS_CHAR,
762 PRICING_ATTRIBUTE56 VARCHAR2(240) := FND_API.G_MISS_CHAR,
763 PRICING_ATTRIBUTE57 VARCHAR2(240) := FND_API.G_MISS_CHAR,
764 PRICING_ATTRIBUTE58 VARCHAR2(240) := FND_API.G_MISS_CHAR,
765 PRICING_ATTRIBUTE59 VARCHAR2(240) := FND_API.G_MISS_CHAR,
766 PRICING_ATTRIBUTE60 VARCHAR2(240) := FND_API.G_MISS_CHAR,
767 PRICING_ATTRIBUTE61 VARCHAR2(240) := FND_API.G_MISS_CHAR,
768 PRICING_ATTRIBUTE62 VARCHAR2(240) := FND_API.G_MISS_CHAR,
769 PRICING_ATTRIBUTE63 VARCHAR2(240) := FND_API.G_MISS_CHAR,
770 PRICING_ATTRIBUTE64 VARCHAR2(240) := FND_API.G_MISS_CHAR,
771 PRICING_ATTRIBUTE65 VARCHAR2(240) := FND_API.G_MISS_CHAR,
772 PRICING_ATTRIBUTE66 VARCHAR2(240) := FND_API.G_MISS_CHAR,
773 PRICING_ATTRIBUTE67 VARCHAR2(240) := FND_API.G_MISS_CHAR,
774 PRICING_ATTRIBUTE68 VARCHAR2(240) := FND_API.G_MISS_CHAR,
775 PRICING_ATTRIBUTE69 VARCHAR2(240) := FND_API.G_MISS_CHAR,
776 PRICING_ATTRIBUTE70 VARCHAR2(240) := FND_API.G_MISS_CHAR,
777 PRICING_ATTRIBUTE71 VARCHAR2(240) := FND_API.G_MISS_CHAR,
778 PRICING_ATTRIBUTE72 VARCHAR2(240) := FND_API.G_MISS_CHAR,
779 PRICING_ATTRIBUTE73 VARCHAR2(240) := FND_API.G_MISS_CHAR,
780 PRICING_ATTRIBUTE74 VARCHAR2(240) := FND_API.G_MISS_CHAR,
781 PRICING_ATTRIBUTE75 VARCHAR2(240) := FND_API.G_MISS_CHAR,
782 PRICING_ATTRIBUTE76 VARCHAR2(240) := FND_API.G_MISS_CHAR,
783 PRICING_ATTRIBUTE77 VARCHAR2(240) := FND_API.G_MISS_CHAR,
784 PRICING_ATTRIBUTE78 VARCHAR2(240) := FND_API.G_MISS_CHAR,
785 PRICING_ATTRIBUTE79 VARCHAR2(240) := FND_API.G_MISS_CHAR,
789 PRICING_ATTRIBUTE83 VARCHAR2(240) := FND_API.G_MISS_CHAR,
786 PRICING_ATTRIBUTE80 VARCHAR2(240) := FND_API.G_MISS_CHAR,
787 PRICING_ATTRIBUTE81 VARCHAR2(240) := FND_API.G_MISS_CHAR,
788 PRICING_ATTRIBUTE82 VARCHAR2(240) := FND_API.G_MISS_CHAR,
790 PRICING_ATTRIBUTE84 VARCHAR2(240) := FND_API.G_MISS_CHAR,
791 PRICING_ATTRIBUTE85 VARCHAR2(240) := FND_API.G_MISS_CHAR,
792 PRICING_ATTRIBUTE86 VARCHAR2(240) := FND_API.G_MISS_CHAR,
793 PRICING_ATTRIBUTE87 VARCHAR2(240) := FND_API.G_MISS_CHAR,
794 PRICING_ATTRIBUTE88 VARCHAR2(240) := FND_API.G_MISS_CHAR,
795 PRICING_ATTRIBUTE89 VARCHAR2(240) := FND_API.G_MISS_CHAR,
796 PRICING_ATTRIBUTE90 VARCHAR2(240) := FND_API.G_MISS_CHAR,
797 PRICING_ATTRIBUTE91 VARCHAR2(240) := FND_API.G_MISS_CHAR,
798 PRICING_ATTRIBUTE92 VARCHAR2(240) := FND_API.G_MISS_CHAR,
799 PRICING_ATTRIBUTE93 VARCHAR2(240) := FND_API.G_MISS_CHAR,
800 PRICING_ATTRIBUTE94 VARCHAR2(240) := FND_API.G_MISS_CHAR,
801 PRICING_ATTRIBUTE95 VARCHAR2(240) := FND_API.G_MISS_CHAR,
802 PRICING_ATTRIBUTE96 VARCHAR2(240) := FND_API.G_MISS_CHAR,
803 PRICING_ATTRIBUTE97 VARCHAR2(240) := FND_API.G_MISS_CHAR,
804 PRICING_ATTRIBUTE98 VARCHAR2(240) := FND_API.G_MISS_CHAR,
805 PRICING_ATTRIBUTE99 VARCHAR2(240) := FND_API.G_MISS_CHAR,
806 PRICING_ATTRIBUTE100 VARCHAR2(240) := FND_API.G_MISS_CHAR,
807 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
808 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
809 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
810 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
811 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
812 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
813 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
814 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
815 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
816 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
817 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
818 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
819 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
820 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
821 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
822 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
823 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
824 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
825 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
826 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
827 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
828 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
829 );
830
831 G_MISS_Price_Attributes_REC Price_Attributes_Rec_Type;
832 TYPE Price_Attributes_Tbl_Type IS TABLE OF Price_Attributes_Rec_Type
833 INDEX BY BINARY_INTEGER;
834 G_MISS_Price_Attributes_TBL Price_Attributes_Tbl_Type;
835
836
837 -- *******************************************************
838 -- Start of Comments
839 -- -------------------------------------------------------
840 -- Record name:Price_Adj_Rec_Type
841 -- -------------------------------------------------------
842 -- Parameters:
843 -- PRICE_ADJUSTMENT_ID
844 -- LAST_UPDATE_DATE
845 -- LAST_UPDATED_BY
846 -- CREATION_DATE
847 -- CREATED_BY
848 -- LAST_UPDATE_LOGIN
849 -- PROGRAM_APPLICATION_ID
850 -- PROGRAM_ID
851 -- PROGRAM_UPDATE_DATE
852 -- REQUEST_ID
853 -- HEADER_ID
854 -- LINE_ID
855 -- MODIFIER_HEADER_ID
856 -- MODIFIER_LINE_ID
857 -- MODIFER_LINE_TYPE_CODE
858 -- MODIFIER_MECHANISM_TYPE_CODE
859 -- MODIFIED_FROM
860 -- MODIFIER_TO
861 -- AUTOMATIC_FLAG
862 -- UPDATE_ALLOWABLE_FLAG
863 -- UPDATED_FLAG
864 -- ATTRIBUTE_CATEGORY
865 -- ATTRIBUTE1
866 -- ATTRIBUTE2
867 -- ATTRIBUTE3
868 -- ATTRIBUTE4
869 -- ATTRIBUTE5
870 -- ATTRIBUTE6
871 -- ATTRIBUTE7
872 -- ATTRIBUTE8
873 -- ATTRIBUTE9
874 -- ATTRIBUTE10
875 -- ATTRIBUTE11
876 -- ATTRIBUTE12
877 -- ATTRIBUTE13
878 -- ATTRIBUTE14
879 -- ATTRIBUTE15
880 -- OBJECT_VERSION_NUMBER
881 -- OPERAND_PER_PQTY
882 -- ADJUSTED_AMOUNT_PER_PQTY
883 --
884 -- Required:
885 -- Defaults:
886 -- Note: This is automatic generated record definition, it includes all columns
887 -- defined in the table, developer must manually add or delete some of the attributes.
888 --
889 -- End of Comments
890
891 TYPE Price_Adj_Rec_Type IS RECORD
892 (
893 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
894 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
895 SHIPMENT_INDEX NUMBER := FND_API.G_MISS_NUM,
896 PRICE_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
897 CREATION_DATE DATE := FND_API.G_MISS_DATE,
898 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
899 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
900 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
904 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
901 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
902 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
903 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
905 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
906 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
907 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
908 QUOTE_SHIPMENT_ID NUMBER := FND_API.G_MISS_NUM,
909 MODIFIER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
910 MODIFIER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
911 MODIFIER_LINE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
912 MODIFIER_MECHANISM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
913 MODIFIED_FROM NUMBER := FND_API.G_MISS_NUM,
914 MODIFIED_TO NUMBER := FND_API.G_MISS_NUM,
915 OPERAND NUMBER := FND_API.G_MISS_NUM,
916 ARITHMETIC_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
917 AUTOMATIC_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
918 UPDATE_ALLOWABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
919 UPDATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
920 APPLIED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
921 ON_INVOICE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
922 PRICING_PHASE_ID NUMBER := FND_API.G_MISS_NUM,
923 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
924 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
925 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
926 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
927 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
928 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
929 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
930 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
931 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
932 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
933 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
934 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
935 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
936 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
937 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
938 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
939 ORIG_SYS_DISCOUNT_REF VARCHAR2(50):= FND_API.G_MISS_CHAR ,
940 CHANGE_SEQUENCE VARCHAR2(50) := FND_API.G_MISS_CHAR ,
941 -- LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
942 -- LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
943 -- LIST_LINE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
944 UPDATE_ALLOWED VARCHAR2(1) := FND_API.G_MISS_CHAR,
945 CHANGE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
946 CHANGE_REASON_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
947 COST_ID NUMBER := FND_API.G_MISS_NUM,
948 TAX_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
949 TAX_EXEMPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
950 TAX_EXEMPT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
951 TAX_EXEMPT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
952 PARENT_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
953 INVOICED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
954 ESTIMATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
955 INC_IN_SALES_PERFORMANCE VARCHAR2(1) := FND_API.G_MISS_CHAR,
956 SPLIT_ACTION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
957 ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
958 CHARGE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
959 CHARGE_SUBTYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
960 RANGE_BREAK_QUANTITY NUMBER := FND_API.G_MISS_NUM,
961 ACCRUAL_CONVERSION_RATE NUMBER := FND_API.G_MISS_NUM,
962 PRICING_GROUP_SEQUENCE NUMBER := FND_API.G_MISS_NUM,
963 ACCRUAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
964 LIST_LINE_NO VARCHAR2(240) := FND_API.G_MISS_CHAR,
965 SOURCE_SYSTEM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
966 BENEFIT_QTY NUMBER := FND_API.G_MISS_NUM,
967 BENEFIT_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
968 PRINT_ON_INVOICE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
969 EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
970 REBATE_TRANSACTION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
971 REBATE_TRANSACTION_REFERENCE VARCHAR2(80) := FND_API.G_MISS_CHAR,
972 REBATE_PAYMENT_SYSTEM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
973 REDEEMED_DATE DATE := FND_API.G_MISS_DATE,
974 REDEEMED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
975 MODIFIER_LEVEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
976 PRICE_BREAK_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
977 SUBSTITUTION_ATTRIBUTE VARCHAR2(30) := FND_API.G_MISS_CHAR,
978 PRORATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
979 INCLUDE_ON_RETURNS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
980 CREDIT_OR_CHARGE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
981 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
985 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
982 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
983 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
984 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
986 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
987 OPERAND_PER_PQTY NUMBER := FND_API.G_MISS_NUM,
988 ADJUSTED_AMOUNT_PER_PQTY NUMBER := FND_API.G_MISS_NUM
989 );
990 G_MISS_Price_Adj_REC Price_Adj_Rec_Type;
991 TYPE Price_Adj_Tbl_Type IS TABLE OF Price_Adj_Rec_Type
992 INDEX BY BINARY_INTEGER;
993 G_MISS_Price_Adj_TBL Price_Adj_Tbl_Type;
994
995 -- *******************************************************
996 -- Start of Comments
997 -- -------------------------------------------------------
998 -- Record name:PRICE_ADJ_ATTR_Rec_Type
999 -- -------------------------------------------------------
1000 -- Parameters:
1001 -- PRICE_ADJ_ATTRIB_ID
1002 -- CREATION_DATE
1003 -- CREATED_BY
1004 -- LAST_UPDATE_DATE
1005 -- LAST_UPDATED_BY
1006 -- LAST_UPDATE_LOGIN
1007 -- PROGRAM_APPLICATION_ID
1008 -- PROGRAM_ID
1009 -- PROGRAM_UPDATE_DATE
1010 -- REQUEST_ID
1011 -- PRICE_ADJUSTMENT_ID
1012 -- PRICING_CONTEXT
1013 -- PRICING_ATTRIBUTE
1014 -- PRICING_ATTR_VALUE_FROM
1015 -- PRICING_ATTR_VALUE_TO
1016 -- COMPARISON_OPERATOR
1017 -- FLEX_TITLE
1018 -- OBJECT_VERSION_NUMBER
1019 --
1020 -- Required:
1021 -- Defaults:
1022 -- Note: This is automatic generated record definition, it includes all columns
1023 -- defined in the table, developer must manually add or delete some of the attributes.
1024 --
1025 -- End of Comments
1026
1027 TYPE PRICE_ADJ_ATTR_Rec_Type IS RECORD
1028 (
1029 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1030 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
1031 SHIPMENT_INDEX NUMBER := FND_API.G_MISS_NUM,
1032 PRICE_ADJ_INDEX NUMBER := FND_API.G_MISS_NUM,
1033 PRICE_ADJ_ATTRIB_ID NUMBER := FND_API.G_MISS_NUM,
1034 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1035 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1036 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1037 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1038 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1039 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1040 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1041 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1042 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1043 PRICE_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
1044 PRICING_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
1045 PRICING_ATTRIBUTE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1046 PRICING_ATTR_VALUE_FROM VARCHAR2(240):= FND_API.G_MISS_CHAR,
1047 PRICING_ATTR_VALUE_TO VARCHAR2(240):= FND_API.G_MISS_CHAR,
1048 COMPARISON_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
1049 FLEX_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
1050 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
1051 );
1052
1053 G_MISS_PRICE_ADJ_ATTR_REC PRICE_ADJ_ATTR_Rec_Type;
1054 TYPE PRICE_ADJ_ATTR_Tbl_Type IS TABLE OF PRICE_ADJ_ATTR_Rec_Type
1055 INDEX BY BINARY_INTEGER;
1056 G_MISS_PRICE_ADJ_ATTR_TBL PRICE_ADJ_ATTR_Tbl_Type;
1057
1058
1059 -- *******************************************************
1060 -- Start of Comments
1061 -- -------------------------------------------------------
1062 -- Record name: Price_Adj_Rltship_Rec_Type
1063 -- -------------------------------------------------------
1064 -- Parameters:
1065 -- ADJ_RELATIONSHIP_ID
1066 -- CREATION_DATE
1067 -- CREATED_BY
1068 -- LAST_UPDATE_DATE
1069 -- LAST_UPDATED_BY
1070 -- LAST_UPDATE_LOGIN
1071 -- REQUEST_ID
1072 -- PROGRAM_APPLICATION_ID
1073 -- PROGRAM_ID
1074 -- PROGRAM_UPDATE_DATE
1075 -- QUOTE_LINE_ID
1076 -- OBJECT_VERSION_NUMBER
1077 --
1078 -- Required:
1079 -- Defaults:
1080 -- Note: This is automatic generated record definition, it includes all columns
1081 -- defined in the table, developer must manually add or delete some of the attributes.
1082 --
1083 -- End of Comments
1084
1085 TYPE Price_Adj_Rltship_Rec_Type IS RECORD
1086 (
1087 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1088 ADJ_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
1089 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1090 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1091 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1092 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1093 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1094 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1095 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1096 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1097 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1098 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1099 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
1100 QUOTE_SHIPMENT_ID NUMBER := FND_API.G_MISS_NUM,
1101 SHIPMENT_INDEX NUMBER := FND_API.G_MISS_NUM,
1102 PRICE_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
1106 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
1103 PRICE_ADJ_INDEX NUMBER := FND_API.G_MISS_NUM,
1104 RLTD_PRICE_ADJ_ID NUMBER := FND_API.G_MISS_NUM,
1105 RLTD_PRICE_ADJ_INDEX NUMBER := FND_API.G_MISS_NUM,
1107 );
1108
1109 G_MISS_Price_Adj_Rltship_REC Price_Adj_Rltship_Rec_Type;
1110 TYPE Price_Adj_Rltship_Tbl_Type IS TABLE OF Price_Adj_Rltship_Rec_Type
1111 INDEX BY BINARY_INTEGER;
1112 G_MISS_Price_Adj_Rltship_TBL Price_Adj_Rltship_Tbl_Type;
1113
1114
1115 -- *******************************************************
1116 -- Start of Comments
1117 -- -------------------------------------------------------
1118 -- Record name:Payment_Rec_Type
1119 -- -------------------------------------------------------
1120 -- Parameters:
1121 -- PAYMENT_ID
1122 -- CREATION_DATE
1123 -- CREATED_BY
1124 -- LAST_UPDATE_DATE
1125 -- LAST_UPDATED_BY
1126 -- LAST_UPDATE_LOGIN
1127 -- REQUEST_ID
1128 -- PROGRAM_APPLICATION_ID
1129 -- PROGRAM_ID
1130 -- PROGRAM_UPDATE_DATE
1131 -- QUOTE_HEADER_ID
1132 -- QUOTE_LINE_ID
1133 -- PAYMENT_TYPE_CODE
1134 -- PAYMENT_OPTION
1135 -- INSTALLMENT_SEQUENCE_NUM
1136 -- INSTALLMENT_PAYMENT_DUE_DATE
1137 -- PAYMENT_TERM_ID
1138 -- PO_NUMBER
1139 -- CHECK_NUMBER
1140 -- CREDIT_CARD_CODE
1141 -- CREDIT_CARD_HOLDER_NAME
1142 -- CREDIT_CARD_NUMBER
1143 -- CREDIT_CARD_EXPIRATION_DATE
1144 -- CREDIT_CARD_APPROVAL_CODE
1145 -- CREDIT_CARD_AUTHORIZATION_CODE
1146 -- PAYMENT_AMOUNT
1147 -- ATTRIBUTE_CATEGORY
1148 -- ATTRIBUTE1
1149 -- ATTRIBUTE2
1150 -- ATTRIBUTE3
1151 -- ATTRIBUTE4
1152 -- ATTRIBUTE5
1153 -- ATTRIBUTE6
1154 -- ATTRIBUTE7
1155 -- ATTRIBUTE8
1156 -- ATTRIBUTE9
1157 -- ATTRIBUTE10
1158 -- ATTRIBUTE11
1159 -- ATTRIBUTE12
1160 -- ATTRIBUTE13
1161 -- ATTRIBUTE14
1162 -- ATTRIBUTE15
1163 -- OBJECT_VERSION_NUMBER
1164 -- TRXN_EXTENSION_ID
1165 --
1166 -- Required:
1167 -- Defaults:
1168 -- Note: This is automatic generated record definition, it includes all columns
1169 -- defined in the table, developer must manually add or delete some of the attributes.
1170 --
1171 -- End of Comments
1172
1173 TYPE Payment_Rec_Type IS RECORD
1174 (
1175 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1176 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
1177 SHIPMENT_INDEX NUMBER := FND_API.G_MISS_NUM,
1178 PAYMENT_ID NUMBER := FND_API.G_MISS_NUM,
1179 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1180 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1181 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1182 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1183 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1184 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1185 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1186 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1187 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1188 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
1189 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1190 QUOTE_SHIPMENT_ID NUMBER := FND_API.G_MISS_NUM,
1191 PAYMENT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1192 PAYMENT_REF_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
1193 PAYMENT_OPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
1194 PAYMENT_TERM_ID NUMBER := FND_API.G_MISS_NUM,
1195 CREDIT_CARD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1196 CREDIT_CARD_HOLDER_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
1197 CREDIT_CARD_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
1198 CREDIT_CARD_APPROVAL_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
1199 CREDIT_CARD_APPROVAL_DATE DATE := FND_API.G_MISS_DATE,
1200 PAYMENT_AMOUNT NUMBER := FND_API.G_MISS_NUM,
1201 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
1202 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1203 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1204 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1205 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1206 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1207 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1208 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1209 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1210 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1211 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1212 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1213 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1214 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1215 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1216 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1217 CUST_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
1218 CVV2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
1219 PAYMENT_TERM_ID_FROM NUMBER := FND_API.G_MISS_NUM,
1220 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
1221 CUST_PO_LINE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
1225 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1222 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1223 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1224 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1226 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1227 CARD_ID NUMBER := FND_API.G_MISS_NUM,
1228 INSTR_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
1229 INSTRUMENT_ID NUMBER := FND_API.G_MISS_NUM,
1230 TRXN_EXTENSION_ID NUMBER := FND_API.G_MISS_NUM
1231
1232 );
1233
1234 G_MISS_Payment_REC Payment_Rec_Type;
1235 TYPE Payment_Tbl_Type IS TABLE OF Payment_Rec_Type
1236 INDEX BY BINARY_INTEGER;
1237 G_MISS_Payment_TBL Payment_Tbl_Type;
1238
1239
1240 -- *******************************************************
1241 -- Start of Comments
1242 -- -------------------------------------------------------
1243 -- Record name:Shipment_Rec_Type
1244 -- -------------------------------------------------------
1245 -- Parameters:
1246 -- SHIPMENT_ID
1247 -- QUOTE_HEADER_ID
1248 -- QUOTE_LINE_ID
1249 -- CREATION_DATE
1250 -- CREATED_BY
1251 -- LAST_UPDATE_DATE
1252 -- LAST_UPDATED_BY
1253 -- LAST_UPDATE_LOGIN
1254 -- REQUEST_ID
1255 -- PROGRAM_APPLICATION_ID
1256 -- PROGRAM_ID
1257 -- PROGRAM_UPDATE_DATE
1258 -- PROMISE_DATE
1259 -- NEED_BY_DATE
1260 -- SHIP_TO_SITE_USE_ID
1261 -- SHIP_TO_CONTACT_ID
1262 -- SHIP_SET_ID
1263 -- SHIP_PARTIAL_FLAG
1264 -- SHIP_METHOD_CODE
1265 -- SHIPMENT_PRIORITY_CODE
1266 -- FREIGHT_TERMS_CODE
1267 -- SHIPPING_INSTRUCTIONS
1268 -- PACKING_INSTRUCTIONS
1269 -- QUANTITY
1270 -- RESERVE_QUANTITY
1271 -- OBJECT_VERSION_NUMBER
1272 --
1273 -- Required:
1274 -- Defaults:
1275 -- Note: This is automatic generated record definition, it includes all columns
1276 -- defined in the table, developer must manually add or delete some of the attributes.
1277 --
1278 -- End of Comments
1279
1280 TYPE Shipment_Rec_Type IS RECORD
1281 (
1282 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1283 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
1284 SHIPMENT_ID NUMBER := FND_API.G_MISS_NUM,
1285 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1286 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1287 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1288 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1289 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1290 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1291 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1292 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1293 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1294 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
1295 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1296 PROMISE_DATE DATE := FND_API.G_MISS_DATE,
1297 REQUEST_DATE DATE := FND_API.G_MISS_DATE,
1298 SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
1299 SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
1300 SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1301 SHIP_TO_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
1302 SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
1303 SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
1304 SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1305 FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1306 FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1307 FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1308 SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
1309 PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
1310 SHIP_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
1311 QUANTITY NUMBER := FND_API.G_MISS_NUM,
1312 PRICING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
1313 RESERVED_QUANTITY VARCHAR2(240) := FND_API.G_MISS_CHAR,
1314 RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
1315 ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1316 SHIP_TO_PARTY_NAME VARCHAR2(255) := FND_API.G_MISS_CHAR,
1317 SHIP_TO_CONTACT_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
1318 SHIP_TO_CONTACT_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
1319 SHIP_TO_CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
1320 SHIP_TO_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1321 SHIP_TO_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1322 SHIP_TO_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1323 SHIP_TO_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1324 SHIP_TO_COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,
1325 SHIP_TO_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
1326 SHIP_TO_CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
1327 SHIP_TO_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
1328 SHIP_TO_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
1329 SHIP_TO_PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
1330 SHIP_TO_COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
1331 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
1335 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1332 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1333 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1334 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1336 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1337 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1338 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1339 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1340 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1341 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1342 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1343 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1344 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1345 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1346 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1347 SHIPMENT_PRIORITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1348 SHIP_FROM_ORG_ID NUMBER := FND_API.G_MISS_NUM,
1349 SHIP_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1350 SHIP_METHOD_CODE_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
1351 FREIGHT_TERMS_CODE_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
1352 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
1353 REQUEST_DATE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1354 DEMAND_CLASS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1355 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1356 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1357 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1358 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1359 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR
1360 );
1361
1362 G_MISS_Shipment_REC Shipment_Rec_Type;
1363 TYPE Shipment_Tbl_Type IS TABLE OF Shipment_Rec_Type
1364 INDEX BY BINARY_INTEGER;
1365 G_MISS_Shipment_TBL Shipment_Tbl_Type;
1366
1367 -- *******************************************************
1368 -- Start of Comments
1369 -- -------------------------------------------------------
1370 -- Record name:Freight_Charge_Rec_Type
1371 -- -------------------------------------------------------
1372 -- Parameters:
1373 -- FREIGHT_CHARGE_ID
1374 -- LAST_UPDATE_DATE
1375 -- LAST_UPDATED_BY
1376 -- CREATION_DATE
1377 -- CREATED_BY
1378 -- LAST_UPDATE_LOGIN
1379 -- PROGRAM_APPLICATION_ID
1380 -- PROGRAM_ID
1381 -- PROGRAM_UPDATE_DATE
1382 -- REQUEST_ID
1383 -- QUOTE_SHIPMENT_ID
1384 -- FREIGHT_CHARGE_TYPE_ID
1385 -- CHARGE_AMOUNT
1386 -- ATTRIBUTE_CATEGORY
1387 -- ATTRIBUTE1
1388 -- ATTRIBUTE2
1389 -- ATTRIBUTE3
1390 -- ATTRIBUTE4
1391 -- ATTRIBUTE5
1392 -- ATTRIBUTE6
1393 -- ATTRIBUTE7
1394 -- ATTRIBUTE8
1395 -- ATTRIBUTE9
1396 -- ATTRIBUTE10
1397 -- ATTRIBUTE11
1398 -- ATTRIBUTE12
1399 -- ATTRIBUTE13
1400 -- ATTRIBUTE14
1401 -- ATTRIBUTE15
1402 -- OBJECT_VERSION_NUMBER
1403 --
1404 -- Required:
1405 -- Defaults:
1406 -- Note: This is automatic generated record definition, it includes all columns
1407 -- defined in the table, developer must manually add or delete some of the attributes.
1408 --
1409 -- End of Comments
1410
1411 TYPE Freight_Charge_Rec_Type IS RECORD
1412 (
1413 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1414 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
1415 SHIPMENT_INDEX NUMBER := FND_API.G_MISS_NUM,
1416 FREIGHT_CHARGE_ID NUMBER := FND_API.G_MISS_NUM,
1417 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1418 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1419 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1420 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1421 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1422 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1423 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1424 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1425 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1426 QUOTE_SHIPMENT_ID NUMBER := FND_API.G_MISS_NUM,
1427 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1428 FREIGHT_CHARGE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
1429 CHARGE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
1430 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
1431 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1432 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1433 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1434 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1435 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1436 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1437 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1438 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1439 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1440 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1441 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1445 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1442 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1443 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1444 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1446 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
1447 );
1448
1449 G_MISS_Freight_Charge_Rec Freight_Charge_Rec_Type;
1450 TYPE Freight_Charge_Tbl_Type IS TABLE OF Freight_charge_rec_Type
1451 INDEX BY BINARY_INTEGER;
1452 G_MISS_Freight_Charge_Tbl Freight_Charge_Tbl_Type;
1453
1454
1455 -- *******************************************************
1456 -- Start of Comments
1457 -- -------------------------------------------------------
1458 -- Record name:Tax_Detail_Rec_Type
1459 -- -------------------------------------------------------
1460 -- Record structure changed with addition of TAX_RATE_ID by Anoop Rajan on 30/08/2005
1461 -- Parameters:
1462 -- TAX_DETAIL_ID
1463 -- QUOTE_HEADER_ID
1464 -- QUOTE_LINE_ID
1465 -- QUOTE_SHIPMENT_ID
1466 -- CREATION_DATE
1467 -- CREATED_BY
1468 -- LAST_UPDATE_DATE
1469 -- LAST_UPDATED_BY
1470 -- LAST_UPDATE_LOGIN
1471 -- REQUEST_ID
1472 -- PROGRAM_APPLICATION_ID
1473 -- PROGRAM_ID
1474 -- PROGRAM_UPDATE_DATE
1475 -- ORIG_TAX_CODE
1476 -- TAX_CODE
1477 -- TAX_RATE
1478 -- TAX_DATE
1479 -- TAX_AMOUNT
1480 -- TAX_EXEMPT_FLAG
1481 -- TAX_EXEMPT_NUMBER
1482 -- TAX_EXEMPT_REASON_CODE
1483 -- ATTRIBUTE_CATEGORY
1484 -- ATTRIBUTE1
1485 -- ATTRIBUTE2
1486 -- ATTRIBUTE3
1487 -- ATTRIBUTE4
1488 -- ATTRIBUTE5
1489 -- ATTRIBUTE6
1490 -- ATTRIBUTE7
1491 -- ATTRIBUTE8
1492 -- ATTRIBUTE9
1493 -- ATTRIBUTE10
1494 -- ATTRIBUTE11
1495 -- ATTRIBUTE12
1496 -- ATTRIBUTE13
1497 -- ATTRIBUTE14
1498 -- ATTRIBUTE15
1499 -- OBJECT_VERSION_NUMBER
1500 -- TAX_RATE_ID
1501 --
1502 -- Required:
1503 -- Defaults:
1504 -- Note: This is automatic generated record definition, it includes all columns
1505 -- defined in the table, developer must manually add or delete some of the attributes.
1506 --
1507 -- End of Comments
1508
1509 TYPE Tax_Detail_Rec_Type IS RECORD
1510 (
1511 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1512 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
1513 SHIPMENT_INDEX NUMBER := FND_API.G_MISS_NUM,
1514 TAX_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
1515 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
1516 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1517 QUOTE_SHIPMENT_ID NUMBER := FND_API.G_MISS_NUM,
1518 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1519 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1520 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1521 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1522 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1523 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1524 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1525 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1526 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1527 ORIG_TAX_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
1528 TAX_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
1529 TAX_RATE NUMBER := FND_API.G_MISS_NUM,
1530 TAX_DATE DATE := FND_API.G_MISS_DATE,
1531 TAX_AMOUNT NUMBER := FND_API.G_MISS_NUM,
1532 TAX_EXEMPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1533 TAX_EXEMPT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
1534 TAX_EXEMPT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1535 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
1536 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1537 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1538 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1539 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1540 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1541 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1542 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1543 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1544 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1545 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1546 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1547 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1548 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1549 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1550 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1551 TAX_INCLUSIVE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1552 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
1553 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1554 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1555 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1556 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1557 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1561
1558 TAX_RATE_ID NUMBER := FND_API.G_MISS_NUM
1559
1560 );
1562 G_MISS_Tax_Detail_Rec Tax_Detail_Rec_Type;
1563 TYPE Tax_Detail_Tbl_Type IS TABLE OF Tax_Detail_Rec_Type
1564 INDEX BY BINARY_INTEGER;
1565 G_MISS_Tax_Detail_TBL Tax_Detail_Tbl_Type;
1566
1567
1568
1569 -- *******************************************************
1570 -- Start of Comments
1571 -- -------------------------------------------------------
1572 -- Record name:Header_Rltship_Rec_Type
1573 -- -------------------------------------------------------
1574 -- Parameters:
1575 -- HEADER_RELATIONSHIP_ID
1576 -- CREATION_DATE
1577 -- CREATED_BY
1578 -- LAST_UPDATE_DATE
1579 -- LAST_UPDATED_BY
1580 -- LAST_UPDATE_LOGIN
1581 -- REQUEST_ID
1582 -- PROGRAM_APPLICATION_ID
1583 -- PROGRAM_ID
1584 -- QUOTE_HEADER_ID
1585 -- RELATED_HEADER_ID
1586 -- RELATIONAL_TYPE_CODE
1587 -- RECIPROCAL_FLAG
1588 -- OBJECT_VERSION_NUMBER
1589 --
1590 --
1591 -- Required:
1592 -- Defaults:
1593 -- Note: This is automatic generated record definition, it includes all columns
1594 -- defined in the table, developer must manually add or delete some of the attributes.
1595 --
1596 -- End of Comments
1597
1598 TYPE Header_Rltship_Rec_Type IS RECORD
1599 (
1600 HEADER_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
1601 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1602 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1603 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1604 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1605 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1606 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1607 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1608 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1609 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1610 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
1611 RELATED_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
1612 RELATIONAL_TYPE_CODE VARCHAR2(150) := FND_API.G_MISS_CHAR,
1613 RECIPROCAL_FLAG VARCHAR2(150) := FND_API.G_MISS_CHAR,
1614 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
1615
1616 );
1617
1618 G_MISS_Header_Rltship_REC Header_Rltship_Rec_Type;
1619 TYPE Header_Rltship_Tbl_Type IS TABLE OF Header_Rltship_Rec_Type
1620 INDEX BY BINARY_INTEGER;
1621 G_MISS_Header_Rltship_TBL Header_Rltship_Tbl_Type;
1622
1623
1624
1625 -- *******************************************************
1626 -- Start of Comments
1627 -- -------------------------------------------------------
1628 -- Record name:Line_Rltship_Rec_Type
1629 -- -------------------------------------------------------
1630 -- Parameters:
1631 -- LINE_RELATIONSHIP_ID
1632 -- CREATION_DATE
1633 -- CREATED_BY
1634 -- LAST_UPDATE_DATE
1635 -- LAST_UPDATED_BY
1636 -- LAST_UPDATE_LOGIN
1637 -- REQUEST_ID
1638 -- PROGRAM_APPLICATION_ID
1639 -- PROGRAM_ID
1640 -- QUOTE_LINE_ID
1641 -- RELATED_QUOTE_LINE_ID
1642 -- RELATIONAL_TYPE_CODE
1643 -- RECIPROCAL_FLAG
1644 -- OBJECT_VERSION_NUMBER
1645 --
1646 --
1647 -- Required:
1648 -- Defaults:
1649 --
1650 -- End of Comments
1651
1652 TYPE Line_Rltship_Rec_Type IS RECORD
1653 (
1654 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1655 LINE_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
1656 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1657 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1658 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1659 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1660 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1661 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1662 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1663 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1664 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1665 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1666 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
1667 RELATED_QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1668 RELATED_QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
1669 RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1670 RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1671 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
1672
1673 );
1674
1675 G_MISS_Line_Rltship_REC Line_Rltship_Rec_Type;
1676 TYPE Line_Rltship_Tbl_Type IS TABLE OF Line_Rltship_Rec_Type
1677 INDEX BY BINARY_INTEGER;
1678 G_MISS_Line_Rltship_TBL Line_Rltship_Tbl_Type;
1679
1680
1681
1682
1683
1684 -- *******************************************************
1685 -- Start of Comments
1686 -- -------------------------------------------------------
1687 -- Record name:Party_Rltship_Rec_Type
1688 -- -------------------------------------------------------
1689 -- Parameters:
1690 -- PARTY_RELATIONSHIP_ID
1691 -- CREATION_DATE
1692 -- CREATED_BY
1693 -- LAST_UPDATE_DATE
1694 -- LAST_UPDATED_BY
1695 -- LAST_UPDATE_LOGIN
1696 -- REQUEST_ID
1697 -- PROGRAM_APPLICATION_ID
1698 -- PROGRAM_ID
1699 -- QUOTE_HEADER_ID
1700 -- QUOTE_LINE_ID
1701 -- OBJECT_TYPE_CODE
1702 -- OBJECT_ID
1706 --
1703 -- RELATIONAL_TYPE_CODE
1704 -- OBJECT_VERSION_NUMBER
1705 --
1707 -- Required:
1708 -- Defaults:
1709 -- Note: This is automatic generated record definition, it includes all columns
1710 -- defined in the table, developer must manually add or delete some of the attributes.
1711 --
1712 -- End of Comments
1713
1714 TYPE PARTY_RLTSHIP_Rec_Type IS RECORD
1715 (
1716 PARTY_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
1717 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1718 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1719 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1720 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1721 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1722 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1723 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1724 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1725 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1726 QUOTE_OBJECT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1727 QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
1728 RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1729 RELATED_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1730 RELATED_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
1731 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
1732 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1733 OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1734 OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
1735 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
1736 );
1737
1738 G_MISS_PARTY_RLTSHIP_REC PARTY_RLTSHIP_Rec_Type;
1739 TYPE PARTY_RLTSHIP_Tbl_Type IS TABLE OF PARTY_RLTSHIP_Rec_Type
1740 INDEX BY BINARY_INTEGER;
1741 G_MISS_PARTY_RLTSHIP_TBL PARTY_RLTSHIP_Tbl_Type;
1742
1743 /*
1744 TYPE Party_Rltship_Rec_Type IS RECORD
1745 (
1746 PARTY_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
1747 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1748 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1749 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1750 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1751 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1752 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1753 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1754 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1755 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1756 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
1757 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1758 QUOTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
1759 OBJECT_TYPE_CODE NUMBER := FND_API.G_MISS_NUM,
1760 OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
1761 RELATIONAL_TYPE_CODE VARCHAR2(150) := FND_API.G_MISS_CHAR
1762
1763 );
1764
1765 G_MISS_Party_Rltship_REC Party_Rltship_Rec_Type;
1766 TYPE Party_Rltship_Tbl_Type IS TABLE OF Party_Rltship_Rec_Type
1767 INDEX BY BINARY_INTEGER;
1768 G_MISS_Party_Rltship_TBL Party_Rltship_Tbl_Type;
1769 */
1770
1771 -- *******************************************************
1772 -- Start of Comments
1773 -- -------------------------------------------------------
1774 -- Record name:Related_Object_Rec_Type
1775 -- -------------------------------------------------------
1776 -- Parameters:
1777 -- RELATED_OBJECT_ID
1778 -- CREATION_DATE
1779 -- CREATED_BY
1780 -- LAST_UPDATE_DATE
1781 -- LAST_UPDATED_BY
1782 -- LAST_UPDATE_LOGIN
1783 -- REQUEST_ID
1784 -- PROGRAM_APPLICATION_ID
1785 -- PROGRAM_ID
1786 -- QUOTE_HEADER_ID
1787 -- QUOTE_LINE_ID
1788 -- OBJECT_TYPE_CODE
1789 -- OBJECT_ID
1790 -- RELATIONAL_TYPE_CODE
1791 -- RECIPROCAL_FLAG
1792 -- OBJECT_VERSION_NUMBER
1793 --
1794 -- Required:
1795 -- Defaults:
1796 -- Note: This is automatic generated record definition, it includes all columns
1797 -- defined in the table, developer must manually add or delete some of the attributes.
1798 --
1799 -- End of Comments
1800
1801 TYPE Related_Object_Rec_Type IS RECORD
1802 (
1803 RELATED_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
1804 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1805 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1806 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1807 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1808 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1809 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1810 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1811 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1812 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1813 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
1814 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1815 QUOTE_OBJECT_TYPE_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
1816 QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
1817 QUOTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
1818 OBJECT_TYPE_CODE NUMBER := FND_API.G_MISS_NUM,
1819 OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
1820 RELATIONAL_TYPE_CODE VARCHAR2(150) := FND_API.G_MISS_CHAR,
1821 RECIPROCAL_FLAG VARCHAR2(150) := FND_API.G_MISS_CHAR,
1825 G_MISS_Related_Object_REC Related_Object_Rec_Type;
1822 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
1823 );
1824
1826 TYPE Related_Object_Tbl_Type IS TABLE OF Related_Object_Rec_Type
1827 INDEX BY BINARY_INTEGER;
1828 G_MISS_Related_Object_TBL Related_Object_Tbl_Type;
1829
1830
1831
1832
1833 TYPE RELATED_OBJ_Rec_Type IS RECORD
1834 (
1835 RELATED_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
1836 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1837 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1838 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1839 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1840 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1841 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1842 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1843 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1844 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1845 QUOTE_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1846 QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
1847 OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1848 OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
1849 RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1850 RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1851 QUOTE_OBJECT_CODE NUMBER := FND_API.G_MISS_NUM,
1852 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
1853 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
1854 );
1855
1856 G_MISS_RELATED_OBJ_REC RELATED_OBJ_Rec_Type;
1857 TYPE RELATED_OBJ_Tbl_Type IS TABLE OF RELATED_OBJ_Rec_Type
1858 INDEX BY BINARY_INTEGER;
1859 G_MISS_RELATED_OBJ_TBL RELATED_OBJ_Tbl_Type;
1860
1861
1862
1863 TYPE Line_Attribs_Ext_Rec_Type IS RECORD
1864 (
1865 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
1866 SHIPMENT_INDEX NUMBER := FND_API.G_MISS_NUM,
1867 LINE_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
1868 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1869 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1870 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1871 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1872 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1873 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1874 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1875 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1876 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1877 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
1878 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1879 QUOTE_SHIPMENT_ID NUMBER := FND_API.G_MISS_NUM,
1880 ATTRIBUTE_TYPE_CODE VARCHAR2(150) := FND_API.G_MISS_CHAR,
1881 NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
1882 VALUE VARCHAR2(150) := FND_API.G_MISS_CHAR,
1883 VALUE_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
1884 STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
1885 APPLICATION_ID NUMBER,
1886 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
1887 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
1888 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1889 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
1890 );
1891 G_MISS_Line_Attribs_Ext_REC Line_Attribs_Ext_Rec_Type;
1892 TYPE Line_Attribs_Ext_Tbl_Type IS TABLE OF Line_Attribs_Ext_Rec_Type
1893 INDEX BY BINARY_INTEGER;
1894 G_MISS_Line_Attribs_Ext_TBL Line_Attribs_Ext_Tbl_Type;
1895
1896 -- ER 3177722
1897 TYPE Config_Vaild_Rec_Type IS RECORD
1898 (
1899 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1900 IS_CFG_CHANGED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1901 IS_CFG_VALID VARCHAR2(1) := FND_API.G_MISS_CHAR,
1902 IS_CFG_COMPLETE VARCHAR2(1) := FND_API.G_MISS_CHAR
1903
1904 );
1905
1906 G_MISS_Config_Vaild_Rec_Type Config_Vaild_Rec_Type;
1907 TYPE Config_Vaild_Tbl_Type IS TABLE OF Config_Vaild_Rec_Type INDEX BY BINARY_INTEGER;
1908 G_MISS_QTE_Config_Valid_TBL Config_Vaild_Tbl_Type;
1909
1910
1911 -- *******************************************************
1912 -- Start of Comments
1913 -- -------------------------------------------------------
1914 -- Record name:QUOTE_PARTY_Rec_Type
1915 -- -------------------------------------------------------
1916 -- Parameters:
1917 -- QUOTE_PARTY_ID
1918 -- CREATION_DATE
1919 -- CREATED_BY
1920 -- LAST_UPDATE_DATE
1921 -- LAST_UPDATE_LOGIN
1922 -- LAST_UPDATED_BY
1923 -- REQUEST_ID
1924 -- PROGRAM_APPLICATION_ID
1925 -- PROGRAM_ID
1926 -- PROGRAM_UPDATE_DATE
1927 -- QUOTE_HEADER_ID
1928 -- QUOTE_LINE_ID
1929 -- QUOTE_SHIPMENT_ID
1930 -- PARTY_TYPE
1931 -- PARTY_ID
1932 -- PARTY_OBJECT_TYPE
1933 -- PARTY_OBJECT_ID
1934 -- ATTRIBUTE_CATEGORY
1935 -- ATTRIBUTE1
1936 -- ATTRIBUTE2
1937 -- ATTRIBUTE3
1938 -- ATTRIBUTE4
1939 -- ATTRIBUTE5
1940 -- ATTRIBUTE6
1941 -- ATTRIBUTE7
1942 -- ATTRIBUTE8
1943 -- ATTRIBUTE9
1944 -- ATTRIBUTE10
1945 -- ATTRIBUTE11
1946 -- ATTRIBUTE12
1947 -- ATTRIBUTE13
1948 -- ATTRIBUTE14
1949 -- ATTRIBUTE15
1950 --
1951 -- Required:
1952 -- Defaults:
1956 -- End of Comments
1953 -- Note: This is automatic generated record definition, it includes all columns
1954 -- defined in the table, developer must manually add or delete some of the attributes.
1955 --
1957
1958 TYPE QUOTE_PARTY_Rec_Type IS RECORD
1959 (
1960 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
1961 SHIPMENT_INDEX NUMBER := FND_API.G_MISS_NUM,
1962 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1963 QUOTE_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1964 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1965 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1966 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1967 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1968 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1969 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1970 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1971 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1972 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1973 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
1974 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1975 QUOTE_SHIPMENT_ID NUMBER := FND_API.G_MISS_NUM,
1976 PARTY_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
1977 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1978 PARTY_OBJECT_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
1979 PARTY_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
1980 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
1981 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1982 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1983 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1984 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1985 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1986 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1987 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1988 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1989 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1990 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1991 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1992 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1993 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1994 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1995 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1996 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
1997 );
1998
1999 G_MISS_QUOTE_PARTY_REC QUOTE_PARTY_Rec_Type;
2000 TYPE QUOTE_PARTY_Tbl_Type IS TABLE OF QUOTE_PARTY_Rec_Type
2001 INDEX BY BINARY_INTEGER;
2002 G_MISS_QUOTE_PARTY_TBL QUOTE_PARTY_Tbl_Type;
2003
2004
2005
2006 -- *******************************************************
2007 -- Start of Comments
2008 -- -------------------------------------------------------
2009 -- Record name:SALES_CREDIT_Rec_Type
2010 -- -------------------------------------------------------
2011 -- Parameters:
2012 -- SALES_CREDIT_ID
2013 -- CREATION_DATE
2014 -- CREATED_BY
2015 -- LAST_UPDATED_BY
2016 -- LAST_UPDATE_DATE
2017 -- LAST_UPDATE_LOGIN
2018 -- REQUEST_ID
2019 -- PROGRAM_APPLICATION_ID
2020 -- PROGRAM_ID
2021 -- PROGRAM_UPDATE_DATE
2022 -- QUOTE_HEADER_ID
2023 -- QUOTE_LINE_ID
2024 -- PERCENT
2025 -- RESOURCE_ID
2026 -- RESOURCE_GROUP_ID
2027 -- EMPLOYEE_PERSON_ID
2028 -- SALES_CREDIT_TYPE_ID
2029 -- ATTRIBUTE_CATEGORY_CODE
2030 -- ATTRIBUTE1
2031 -- ATTRIBUTE2
2032 -- ATTRIBUTE3
2033 -- ATTRIBUTE4
2034 -- ATTRIBUTE5
2035 -- ATTRIBUTE6
2036 -- ATTRIBUTE7
2037 -- ATTRIBUTE8
2038 -- ATTRIBUTE9
2039 -- ATTRIBUTE10
2040 -- ATTRIBUTE11
2041 -- ATTRIBUTE12
2042 -- ATTRIBUTE13
2043 -- ATTRIBUTE14
2044 -- ATTRIBUTE15
2045 --
2046 -- Required:
2047 -- Defaults:
2048 -- Note: This is automatic generated record definition, it includes all columns
2049 -- defined in the table, developer must manually add or delete some of the attributes.
2050 --
2051 -- End of Comments
2052
2053 TYPE SALES_CREDIT_Rec_Type IS RECORD
2054 (
2055 QTE_LINE_INDEX NUMBER := FND_API.G_MISS_NUM,
2056 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2057 SALES_CREDIT_ID NUMBER := FND_API.G_MISS_NUM,
2058 CREATION_DATE DATE := FND_API.G_MISS_DATE,
2059 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
2060 LAST_UPDATED_BY VARCHAR2(240) := FND_API.G_MISS_CHAR,
2061 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
2062 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
2063 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
2064 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
2065 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
2066 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
2067 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
2068 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
2069 PERCENT NUMBER := FND_API.G_MISS_NUM,
2070 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
2074 RESOURCE_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
2071 FIRST_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
2072 LAST_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
2073 SALES_CREDIT_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
2075 EMPLOYEE_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
2076 SALES_CREDIT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
2077 ATTRIBUTE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2078 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2079 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2080 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2081 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2082 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2083 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2084 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2085 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2086 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2087 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2088 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2089 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2090 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2091 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2092 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2093 CREDIT_RULE_ID NUMBER := FND_API.G_MISS_NUM,
2094 SYSTEM_ASSIGNED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2095 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
2096 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2097 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2098 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2099 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2100 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR
2101
2102 );
2103
2104 G_MISS_SALES_CREDIT_REC SALES_CREDIT_Rec_Type;
2105 TYPE SALES_CREDIT_Tbl_Type IS TABLE OF SALES_CREDIT_Rec_Type
2106 INDEX BY BINARY_INTEGER;
2107 G_MISS_SALES_CREDIT_TBL SALES_CREDIT_Tbl_Type;
2108
2109
2110 TYPE Order_Header_Rec_Type IS RECORD
2111 (
2112 ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
2113 ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
2114 ORDER_REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
2115 CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
2116 STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR
2117 );
2118
2119
2120 TYPE Lot_Serial_Rec_Type IS RECORD
2121 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
2122 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
2123 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
2124 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
2125 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
2126 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
2127 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
2128 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
2129 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
2130 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
2131 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
2132 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
2133 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
2134 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
2135 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
2136 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
2137 , created_by NUMBER := FND_API.G_MISS_NUM
2138 , creation_date DATE := FND_API.G_MISS_DATE
2139 , from_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
2140 , last_updated_by NUMBER := FND_API.G_MISS_NUM
2141 , last_update_date DATE := FND_API.G_MISS_DATE
2142 , last_update_login NUMBER := FND_API.G_MISS_NUM
2143 , line_id NUMBER := FND_API.G_MISS_NUM
2144 , lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
2145 , lot_serial_id NUMBER := FND_API.G_MISS_NUM
2146 , quantity NUMBER := FND_API.G_MISS_NUM
2147 , to_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
2148 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
2149 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
2150 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
2151 , line_index NUMBER := FND_API.G_MISS_NUM
2152 , orig_sys_lotserial_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
2153 , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
2154 , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
2155 , line_set_id NUMBER := FND_API.G_MISS_NUM
2156 );
2157
2158 TYPE Lot_Serial_Tbl_Type IS TABLE OF Lot_Serial_Rec_Type
2159 INDEX BY BINARY_INTEGER;
2160
2161 G_MISS_Lot_Serial_Tbl Lot_Serial_Tbl_Type ;
2162
2163 -- this record type is used for flexfield validation
2164 TYPE attribute_rec_type IS RECORD(
2165 attribute_category VARCHAR2(30) DEFAULT NULL,
2166 attribute1 VARCHAR2(150) DEFAULT NULL,
2167 attribute2 VARCHAR2(150) DEFAULT NULL,
2171 attribute6 VARCHAR2(150) DEFAULT NULL,
2168 attribute3 VARCHAR2(150) DEFAULT NULL,
2169 attribute4 VARCHAR2(150) DEFAULT NULL,
2170 attribute5 VARCHAR2(150) DEFAULT NULL,
2172 attribute7 VARCHAR2(150) DEFAULT NULL,
2173 attribute8 VARCHAR2(150) DEFAULT NULL,
2174 attribute9 VARCHAR2(150) DEFAULT NULL,
2175 attribute10 VARCHAR2(150) DEFAULT NULL,
2176 attribute11 VARCHAR2(150) DEFAULT NULL,
2177 attribute12 VARCHAR2(150) DEFAULT NULL,
2178 attribute13 VARCHAR2(150) DEFAULT NULL,
2179 attribute14 VARCHAR2(150) DEFAULT NULL,
2180 attribute15 VARCHAR2(150) DEFAULT NULL);
2181
2182
2183 /* Quote Access or Sales Team record structure */
2184
2185 TYPE Qte_Access_Rec_Type IS RECORD
2186 (
2187 ACCESS_ID NUMBER := FND_API.G_MISS_NUM,
2188 QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
2189 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
2190 RESOURCE_GRP_ID NUMBER := FND_API.G_MISS_NUM,
2191 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
2192 CREATION_DATE DATE := FND_API.G_MISS_DATE,
2193 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
2194 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
2195 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
2196 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
2197 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
2198 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
2199 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
2200 KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2201 UPDATE_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2202 CREATED_BY_TAP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2203 TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
2204 TERRITORY_SOURCE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2205 ROLE_ID NUMBER := FND_API.G_MISS_NUM,
2206 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
2207 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2208 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2209 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2210 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2211 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2212 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2213 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2214 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2215 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2216 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2217 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2218 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2219 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2220 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2221 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2222 BATCH_PRICE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2223 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
2224 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2225 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2226 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2227 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2228 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2229 OPERATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
2230 );
2231
2232 G_MISS_QTE_ACCESS_REC Qte_Access_Rec_Type;
2233
2234
2235 TYPE Qte_Access_Tbl_Type IS TABLE OF Qte_Access_Rec_Type INDEX BY BINARY_INTEGER;
2236
2237 G_MISS_QTE_ACCESS_TBL Qte_Access_Tbl_Type;
2238
2239
2240 /* Template record structure */
2241
2242 TYPE Template_Rec_Type IS RECORD
2243 (
2244 TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM
2245 );
2246
2247 G_MISS_TEMPLATE_REC Template_Rec_Type;
2248
2249 TYPE Template_Tbl_Type IS TABLE OF Template_Rec_Type INDEX BY BINARY_INTEGER;
2250
2251 G_MISS_TEMPLATE_TBL Template_Tbl_Type;
2252
2253
2254
2255
2256 -- *******************************************************
2257 -- Start of Comments
2258 -- *******************************************************
2259 -- API Name: Create_quote
2260 -- Type : Public
2261 -- Pre-Req :
2262 -- Parameters:
2263 -- IN
2264 -- p_api_version_number IN NUMBER Required
2265 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2266 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2267 -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
2268 --
2269 -- OUT NOCOPY /* file.sql.39 change */ :
2270 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2271 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2272 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2273 -- Version : Current version 2.0
2274 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
2275 -- and basic operation, developer must manually add parameters and business logic as necessary.
2276 --
2277 -- End of Comments
2278 --
2282 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2279 PROCEDURE Create_quote(
2280 P_Api_Version_Number IN NUMBER,
2281 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2283 P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
2284 P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
2285 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2286 := G_Miss_Price_Attributes_Tbl,
2287 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2288 := G_MISS_PAYMENT_TBL,
2289 P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
2290 := G_MISS_SHIPMENT_REC,
2291 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
2292 := G_Miss_Freight_Charge_Tbl,
2293 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
2294 := G_Miss_Tax_Detail_Tbl,
2295 P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
2296 P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type
2297 := G_MISS_QTE_LINE_DTL_TBL,
2298 P_Line_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type
2299 := G_MISS_Line_Attribs_Ext_TBL,
2300 P_line_rltship_tbl IN Line_Rltship_Tbl_Type
2301 := G_MISS_Line_Rltship_Tbl,
2302 P_Price_Adjustment_Tbl IN Price_Adj_Tbl_Type
2303 := G_Miss_Price_Adj_Tbl,
2304 P_Price_Adj_Attr_Tbl IN Price_Adj_Attr_Tbl_Type
2305 := G_Miss_PRICE_ADJ_ATTR_Tbl,
2306 P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type
2307 := G_Miss_Price_Adj_Rltship_Tbl,
2308 P_Ln_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
2309 := G_Miss_Price_Attributes_Tbl,
2310 P_Ln_Payment_Tbl IN Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
2311 P_Ln_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
2312 P_Ln_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type
2313 := G_Miss_Freight_Charge_Tbl,
2314 P_Ln_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type
2315 := G_Miss_Tax_Detail_Tbl,
2316
2317 x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Header_Rec_Type,
2318
2319 X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Tbl_Type,
2320 X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_Tbl_Type,
2321 X_Hd_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
2322 X_Hd_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
2323 X_Hd_Shipment_Rec OUT NOCOPY /* file.sql.39 change */ Shipment_Rec_Type,
2324 X_Hd_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
2325 X_Hd_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
2326 x_Line_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_Type,
2327 X_line_rltship_tbl OUT NOCOPY /* file.sql.39 change */ Line_Rltship_Tbl_Type,
2328 X_Price_Adjustment_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Tbl_Type,
2329 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Attr_Tbl_Type,
2330 X_Price_Adj_Rltship_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Rltship_Tbl_Type,
2331 X_Ln_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
2332 X_Ln_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
2333 X_Ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
2334 X_Ln_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
2335 X_Ln_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
2336 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2337 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2338 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2339 );
2340
2341 -- *******************************************************
2342 -- Start of Comments
2343 -- *******************************************************
2344 -- API Name: Update_quote
2345 -- Type : Public
2346 -- Pre-Req :
2347 -- Parameters:
2348 -- IN
2349 -- p_api_version_number IN NUMBER Required
2350 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2351 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2352 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
2353 -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
2354 --
2355 -- OUT NOCOPY /* file.sql.39 change */ :
2356 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2357 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2358 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2359 -- Version : Current version 2.0
2360 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
2361 -- and basic operation, developer must manually add parameters and business logic as necessary.
2362 --
2363 -- End of Comments
2364 --
2365 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
2366
2367 PROCEDURE Update_quote(
2368 P_Api_Version_Number IN NUMBER,
2369 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2370 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2371 P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
2372 P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
2373 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2374 := G_Miss_Price_Attributes_Tbl,
2375 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2376 := G_MISS_PAYMENT_TBL,
2377 P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2378 := G_MISS_SHIPMENT_TBL,
2379 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
2380 := G_Miss_Freight_Charge_Tbl,
2381 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
2385 := G_MISS_QTE_LINE_DTL_TBL,
2382 := G_Miss_Tax_Detail_Tbl,
2383 P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
2384 P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type
2386 P_Line_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type
2387 := G_MISS_Line_Attribs_Ext_TBL,
2388 P_line_rltship_tbl IN Line_Rltship_Tbl_Type
2389 := G_MISS_Line_Rltship_Tbl,
2390 P_Price_Adjustment_Tbl IN Price_Adj_Tbl_Type
2391 := G_Miss_Price_Adj_Tbl,
2392 P_Price_Adj_Attr_Tbl IN Price_Adj_Attr_Tbl_Type
2393 := G_Miss_PRICE_ADJ_ATTR_Tbl,
2394 P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type
2395 := G_Miss_Price_Adj_Rltship_Tbl,
2396 P_Ln_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
2397 := G_Miss_Price_Attributes_Tbl,
2398 P_Ln_Payment_Tbl IN Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
2399 P_Ln_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
2400 P_Ln_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type
2401 := G_Miss_Freight_Charge_Tbl,
2402 P_Ln_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type
2403 := G_Miss_Tax_Detail_Tbl,
2404 x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Header_Rec_Type,
2405
2406 X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Tbl_Type,
2407 X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_Tbl_Type,
2408 X_Hd_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
2409 X_Hd_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
2410 X_Hd_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
2411 X_Hd_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
2412 X_Hd_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
2413 x_Line_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_Type,
2414 X_line_rltship_tbl OUT NOCOPY /* file.sql.39 change */ Line_Rltship_Tbl_Type,
2415 X_Price_Adjustment_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Tbl_Type,
2416 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Attr_Tbl_Type,
2417 X_Price_Adj_Rltship_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Rltship_Tbl_Type,
2418 X_Ln_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
2419 X_Ln_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
2420 X_Ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
2421 X_Ln_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
2422 X_Ln_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
2423 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2424 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2425 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2426 );
2427
2428 -- *******************************************************
2429 -- Start of Comments
2430 -- *******************************************************
2431 -- API Name: Delete_quote
2432 -- Type : Public
2433 -- Pre-Req :
2434 -- Parameters:
2435 -- IN
2436 -- p_api_version_number IN NUMBER Required
2437 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2438 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2439 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
2440 -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
2441 --
2442 -- OUT NOCOPY /* file.sql.39 change */ :
2443 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2444 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2445 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2446 -- Version : Current version 2.0
2447 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
2448 -- and basic operation, developer must manually add parameters and business logic as necessary.
2449 --
2450 -- End of Comments
2451 --
2452 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
2453 -- The Master delete procedure may not be needed depends on different business requirements.
2454 PROCEDURE Delete_quote(
2455 P_Api_Version_Number IN NUMBER,
2456 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2457 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2458 P_Qte_Header_Id IN NUMBER,
2459 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2460 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2461 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2462 );
2463
2464 -- *******************************************************
2465 -- Start of Comments
2466 -- *******************************************************
2467 -- API Name: Copy_quote
2468 -- Type : Public
2469 -- Pre-Req :
2470 -- Parameters:
2471 -- IN
2472 -- p_api_version_number IN NUMBER Required
2473 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2474 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2475 --
2476 -- OUT NOCOPY /* file.sql.39 change */ :
2477 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2478 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2479 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2480 -- Version : Current version 2.0
2481 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
2482 -- and basic operation, developer must manually add parameters and business logic as necessary.
2483 --
2484 -- End of Comments
2485 --
2489 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2486 PROCEDURE Copy_quote(
2487 P_Api_Version_Number IN NUMBER,
2488 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2490 P_Qte_Header_Id IN NUMBER,
2491 P_Last_Update_Date IN DATE,
2492 P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,
2493 P_New_Version IN VARCHAR2 := FND_API.G_FALSE,
2494 P_Qte_Status_Id IN NUMBER := NULL,
2495 P_Qte_Number IN NUMBER := NULL,
2496 X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
2497 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2498 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2499 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2500 );
2501
2502
2503 -- *******************************************************
2504 -- Start of Comments
2505 -- *******************************************************
2506 -- API Name: Copy_quote
2507 -- Type : Public
2508 -- Pre-Req :
2509 -- Parameters:This is the Overloaded Version of Copy_quote Which
2510 -- Takes P_control_rec as input parameter.This p_control_rec can
2511 -- be used to copy notes and task.
2512 -- IN
2513 -- p_api_version_number IN NUMBER Required
2514 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2515 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2516 --
2517 -- OUT NOCOPY /* file.sql.39 change */ :
2518 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2519 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2520 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2521 -- Version : Current version 2.0
2522 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
2523 -- and basic operation, developer must manually add parameters and business logic as necessary.
2524 --
2525 -- End of Comments
2526 --
2527 PROCEDURE Copy_quote(
2528 P_Api_Version_Number IN NUMBER,
2529 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2530 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2531 P_control_rec IN Control_Rec_Type,
2532 P_Qte_Header_Id IN NUMBER,
2533 P_Last_Update_Date IN DATE,
2534 P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,
2535 P_New_Version IN VARCHAR2 := FND_API.G_FALSE,
2536 P_Qte_Status_Id IN NUMBER := NULL,
2537 P_Qte_Number IN NUMBER := NULL,
2538 X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
2539 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2540 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2541 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2542 );
2543
2544
2545
2546 -- *******************************************************
2547 -- Start of Comments
2548 -- *******************************************************
2549 -- API Name: Validate_Quote
2550 -- Type : Public
2551 -- Pre-Req :
2552 -- Parameters:
2553 -- IN
2554 -- p_api_version_number IN NUMBER Required
2555 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2556 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2557 -- OUT NOCOPY /* file.sql.39 change */ :
2558 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2559 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2560 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2561 -- Version : Current version 2.0
2562 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
2563 -- and basic operation, developer must manually add parameters and business logic as necessary.
2564 --
2565 -- End of Comments
2566 --
2567 PROCEDURE Validate_quote(
2568 P_Api_Version_Number IN NUMBER,
2569 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2570 P_Qte_Header_Id IN NUMBER,
2571 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2572 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2573 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2574 );
2575
2576 -- *******************************************************
2577 -- Start of Comments
2578 -- *******************************************************
2579 -- API Name: Submit_Quote
2580 -- Type : Public
2581 -- Pre-Req :
2582 -- Parameters:
2583 -- IN
2584 -- p_api_version_number IN NUMBER Required
2585 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2586 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2587 -- OUT NOCOPY /* file.sql.39 change */ :
2588 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2589 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2590 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2591 -- Version : Current version 2.0
2592 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
2593 -- and basic operation, developer must manually add parameters and business logic as necessary.
2594 --
2595 -- End of Comments
2596 --
2597 PROCEDURE Submit_quote(
2598 P_Api_Version_Number IN NUMBER,
2599 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2600 -- P_commit IN VARCHAR2 := FND_API.G_FALSE,
2604 x_order_header_rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
2601 p_control_rec IN Submit_Control_Rec_Type
2602 := G_MISS_Submit_Control_Rec,
2603 P_Qte_Header_Id IN NUMBER,
2605 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2606 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2607 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2608 );
2609
2610 -- *******************************************************
2611 -- Start of Comments
2612 -- *******************************************************
2613 -- API Name: Get_quote
2614 -- Type : Public
2615 -- Pre-Req :
2616 -- Parameters:
2617 -- IN
2618 -- p_api_version_number IN NUMBER Required
2619 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2620 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
2621 -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
2622 -- Hint: Add List of bind variables here
2623 -- p_rec_requested IN NUMBER Optional Default = 30
2624 -- p_start_rec_ptr IN NUMBER Optional Default = 1
2625 --
2626 -- Return Total Records Count Flag. This flag controls whether the total record count
2627 -- and total record amount is returned.
2628 --
2629 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
2630 -- Hint: User defined record type
2631 -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
2632 --
2633 -- OUT NOCOPY /* file.sql.39 change */ :
2634 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2635 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2636 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2637 -- X_Qte_Header_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Header_Rec_Type
2638 -- x_returned_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2639 -- x_next_rec_ptr OUT NOCOPY /* file.sql.39 change */ NUMBER
2640 -- x_tot_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2641 -- other optional OUT NOCOPY /* file.sql.39 change */ parameters
2642 -- x_tot_rec_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
2643 -- Version : Current version 2.0
2644 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
2645 -- and basic operation, developer must manually add parameters and business logic as necessary.
2646 --
2647 -- End of Comments
2648 --
2649 PROCEDURE Get_quote(
2650 P_Api_Version_Number IN NUMBER,
2651 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2652 P_Qte_Header_Rec IN Qte_Header_Rec_Type,
2653 -- Hint: Add list of bind variables here
2654 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
2655 p_start_rec_prt IN NUMBER := 1,
2656 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
2657 -- Hint: user defined record type
2658 p_order_by_rec IN QTE_sort_rec_type,
2659 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2660 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2661 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2662 X_Qte_Header_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Header_Tbl_Type,
2663 x_returned_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2664 x_next_rec_ptr OUT NOCOPY /* file.sql.39 change */ NUMBER,
2665 x_tot_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2666 -- other optional parameters
2667 -- x_tot_rec_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
2668 );
2669
2670
2671 -- *******************************************************
2672 -- Start of Comments
2673 -- *******************************************************
2674 -- API Name: Create_Quote_Line
2675 -- Type : Public
2676 -- Pre-Req :
2677 -- Parameters:
2678 -- IN
2679 -- p_api_version_number IN NUMBER Required
2680 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2681 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2682 -- P_qte_lines_Rec IN qte_line_Rec_Type Required
2683 -- P_quote_header_id IN NUMBER Required
2684 -- P_header_last_update_date IN DATE Required
2685 -- P_Payment_Tbl IN Payment_Tbl_Type
2686 -- P_Price_Adj_Tbl IN Price_Adj_Tbl_Type
2687 -- P_Qte_Line_Dtl_Rec IN Qte_Line_Dtl_Rec_Type
2688 -- P_Shipment_Tbl IN Shipment_Tbl_Type
2689 -- P_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type
2690 -- P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type
2691 -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
2692 -- P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
2693 -- P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type
2694 -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE
2695
2696 -- OUT NOCOPY /* file.sql.39 change */ :
2697 -- X_quote_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
2698 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2699 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2700 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2701 -- Version : Current version 2.0
2702 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
2703 -- and basic operation, developer must manually add parameters and business logic as necessary.
2704 --
2705 -- End of Comments
2706 --
2707 PROCEDURE Create_Quote_Line(
2708
2712 P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,
2709 P_Api_Version_Number IN NUMBER,
2710 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2711 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2713 P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
2714 P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type:= G_MISS_qte_line_dtl_TBL,
2715 P_Line_Attribs_Ext_Tbl IN Line_Attribs_Ext_Tbl_type
2716 := G_Miss_Line_Attribs_Ext_Tbl,
2717 P_Payment_Tbl IN Payment_Tbl_Type := G_MISS_Payment_TBL,
2718 P_Price_Adj_Tbl IN Price_Adj_Tbl_Type := G_MISS_Price_Adj_TBL,
2719 P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type := G_MISS_Price_attributes_TBL,
2720 P_Price_Adj_Attr_Tbl IN Price_Adj_Attr_Tbl_Type
2721 := G_Miss_PRICE_ADJ_ATTR_Tbl,
2722 P_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_shipment_TBL,
2723 P_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type:= G_MISS_tax_detail_TBL,
2724 P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type := G_MISS_freight_charge_TBL,
2725 P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,
2726 X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Line_Rec_Type,
2727 X_Qte_Line_Dtl_TBL OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_TBL_Type,
2728 X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_type,
2729 X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
2730 X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Tbl_Type,
2731 X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type ,
2732 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Attr_Tbl_Type,
2733 X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
2734 X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
2735 X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type ,
2736 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2737 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2738 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2739 );
2740
2741 -- *******************************************************
2742 -- Start of Comments
2743 -- *******************************************************
2744 -- API Name: Update_Quote_Line
2745 -- Type : Public
2746 -- Pre-Req :
2747 -- Parameters:
2748 -- IN
2749
2750 PROCEDURE Update_Quote_Line(
2751 P_Api_Version_Number IN NUMBER,
2752 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2753 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2754 P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,
2755 P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
2756 P_Qte_Line_Dtl_TBL IN Qte_Line_Dtl_tbl_Type:= G_MISS_qte_line_dtl_TBL,
2757 P_Line_Attribs_Ext_Tbl IN Line_Attribs_Ext_Tbl_type
2758 := G_Miss_Line_Attribs_Ext_Tbl,
2759 P_Payment_Tbl IN Payment_Tbl_Type := G_MISS_Payment_TBL,
2760 P_Price_Adj_Tbl IN Price_Adj_Tbl_Type := G_MISS_Price_Adj_TBL,
2761 P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type := G_MISS_Price_attributes_TBL,
2762 P_Price_Adj_Attr_Tbl IN Price_Adj_Attr_Tbl_Type
2763 := G_Miss_PRICE_ADJ_ATTR_Tbl,
2764 P_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_shipment_TBL,
2765 P_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type:= G_MISS_tax_detail_TBL,
2766 P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type := G_MISS_freight_charge_TBL,
2767 P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,
2768 X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Line_Rec_Type,
2769 X_Qte_Line_Dtl_TBL OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_TBL_Type,
2770 X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_type,
2771 X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
2772 X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Tbl_Type,
2773 X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type ,
2774 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Attr_Tbl_Type,
2775 X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
2776 X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
2777 X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type ,
2778 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2779 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2780 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2781 );
2782
2783
2784
2785 -- *******************************************************
2786 -- Start of Comments
2787 -- *******************************************************
2788 -- API Name: Delete_Quote_Line
2789 -- Type : Public
2790 -- Pre-Req :
2791 -- Parameters:
2792 -- IN
2793 -- p_api_version_number IN NUMBER Required
2794 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2795 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2796 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
2797 -- P_qte_line_Rec IN qte_line_Rec_Type Required
2798 -- P_quote_header_id IN NUMBER Required
2799 -- P_header_last_update_date IN DATE Required
2800 --
2801 -- OUT NOCOPY /* file.sql.39 change */ :
2802 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2803 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2807 -- and basic operation, developer must manually add parameters and business logic as necessary.
2804 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2805 -- Version : Current version 2.0
2806 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
2808 --
2809 -- End of Comments
2810 --
2811 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
2812 -- The Master delete procedure may not be needed depends on different business requirements.
2813
2814 PROCEDURE Delete_Quote_Line(
2815 P_Api_Version_Number IN NUMBER,
2816 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2817 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2818 P_qte_line_Rec IN qte_line_Rec_Type,
2819 P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
2820 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2821 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2822 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2823 );
2824
2825
2826
2827 -- *******************************************************
2828 -- Start of Comments
2829 -- *******************************************************
2830 -- API Name: Create_quote
2831 -- Type : Public
2832 -- Pre-Req :
2833 -- Parameters:
2834
2835 -- Version : Current version 2.0
2836 -- Note: This is an overloaded procedure. It takes additional attributes
2837 -- which include the hd_attributes, sales credits and quote party record
2838 -- types
2839 --
2840 -- End of Comments
2841 --
2842
2843 /*#
2844 * Use this procedure to create new quotes.
2845 * This API allows users to create a quote and enter price adjustments, pricing attributes, sales credits, shipping, tax, payment information for the quote.
2846 * @param p_api_version_number API version used to check the compatibility of a call.
2847 * @param p_init_msg_list Boolean parameter which determines whether internal message table should be initialized.
2848 * @param P_Validation_Level Number parameter to determine which validation steps to execute and which steps to skip.
2849 * @param p_commit Boolean parameter which is used by API callers to ask the API to commit on their behalf after performing its function.
2850 * @param x_return_status Return status of API call
2851 * @param x_msg_count Number of stored processing messages
2852 * @param x_msg_data Processing message data
2853 * @param p_control_rec Input control record structure containing information about the actions (Price,Tax, and so on) that can be performed on a quote.
2854 * @param P_Qte_Header_Rec Input record structure containing current header level information to create a quote.
2855 * @param P_hd_Price_Attributes_Tbl Input table structure containing current header level information for pricing attributes.
2856 * @param P_hd_Payment_Tbl Input table structure containing current header level Payment information for a quote.
2857 * @param P_hd_Shipment_Rec Input record structure containing current header level Shipment information for a quote.
2858 * @param P_hd_Freight_Charge_Tbl Not Used (Obsolete).
2859 * @param P_hd_Tax_Detail_Tbl Input table structure containing current header level Tax information for a quote.
2860 * @param P_hd_Attr_Ext_Tbl Not Used (Obsolete).
2861 * @param P_hd_Sales_Credit_Tbl Input table structure containing current header level Sales Credit information for a quote.
2862 * @param P_hd_Quote_Party_Tbl Not Used (Obsolete).
2863 * @param P_Qte_Line_Tbl Input table structure containing quote lines information to create a quote.
2864 * @param P_Qte_Line_Dtl_Tbl Input table structure containing line details (Configuration Lines,Service Lines) information to create a quote.
2865 * @param P_Line_Attr_Ext_Tbl Not Used (Obsolete).
2866 * @param P_line_rltship_tbl Input table structure containing relationships at the line level in a quote.
2867 * @param P_Price_Adjustment_Tbl Input table structure containing Price Adjustments (Header and Lines) information to create a quote.
2868 * @param P_Price_Adj_Attr_Tbl Input table structure containing Price Adjustments Attributes (Header and Lines) information to create a quote.
2869 * @param P_Price_Adj_Rltship_Tbl Input table structure containing relationships at Price Adjustment level.
2870 * @param P_Ln_Price_Attributes_Tbl Input table structure containing quote line level information for pricing attributes.
2871 * @param P_Ln_Payment_Tbl Input table structure containing quote line level payment information for a quote.
2872 * @param P_Ln_Shipment_Tbl Input record structure containing Quote Line level Shipment information for a quote.
2873 * @param P_Ln_Freight_Charge_Tbl Not Used (Obsolete).
2874 * @param P_Ln_Tax_Detail_Tbl Input table structure containing quote line level Tax information for a quote.
2875 * @param P_Ln_Sales_Credit_Tbl Input table structure containing quote line level Sales Credit information for a quote.
2876 * @param P_Ln_Quote_Party_Tbl Not Used (Obsolete).
2877 * @param X_Qte_Header_Rec Output record structure containing quote header level information with a Quote Header Id. This is a unique identifier generated for the newly created quote.
2878 * @param X_hd_Price_Attributes_Tbl Output table structure containing header level information for pricing attributes with a Price Attribute Id. This is a unique identifier generated for the newly created price attribute records.
2879 * @param X_hd_Payment_Tbl Output table structure containing header level Payment information for a quote with a Payment Id. This is a unique identifier generated for the newly created payment records.
2883 * @param X_hd_Attr_Ext_Tbl Not Used (Obsolete).
2880 * @param X_hd_Shipment_Rec Output record structure containing header level Shipment information for a quote with a Shipment Id. This is a unique identifier generated for the newly created shipment records.
2881 * @param X_Hd_Freight_Charge_Tbl Not Used (Obsolete).
2882 * @param X_hd_Tax_Detail_Tbl Output table structure containing header level Tax information for a quote with a Tax Detail Id. This is a unique identifier generated for the newly created tax detail records
2884 * @param X_hd_Sales_Credit_Tbl Output table structure containing header level Sales Credit information for a quote with a Sales Credit Id. This is a unique identifier generated for the newly created sales credit records.
2885 * @param X_hd_Quote_Party_Tbl Not Used (Obsolete).
2886 * @param X_Qte_Line_Tbl Output table structure containing quote lines information for a quote with a Quote Line Id. This is a unique identifier generated for the newly created quote lines.
2887 * @param X_Qte_Line_Dtl_Tbl Output table structure containing line details (Configurator,Service Lines)information for a quote with a Line Detail Id. This is a unique identifier generated for the newly created line detail records.
2888 * @param X_Line_Attr_Ext_Tbl Not Used (Obsolete)
2889 * @param X_line_rltship_tbl Output table structure containing relationships at line level with a Line Relationship Id.
2890 * @param X_Price_Adjustment_Tbl Output table structure containing Price Adjustments(Header and Lines)information for a quote with a Price Adjustment Id. This is a unique identifier generated for the newly created price adjustment records.
2891 * @param X_Price_Adj_Attr_Tbl Output table structure containing Price Adjustment Attributes(Header, Lines) information for a quote. Price_adj_attribute_id is a unique identifier generated for the price adjustment attributes records.
2892 * @param X_Price_Adj_Rltship_Tbl Output table structure containing relationships at Price Adjustment level with a Adjustment Relationship Id. This is a unique identifier generated for the price adjustment relationship records.
2893 * @param X_Ln_Price_Attributes_Tbl Output table structure containing quote line level information for pricing attributes with a Price Attribute Id. This is a unique identifier generated for the newly created price attribute records.
2894 * @param X_Ln_Payment_Tbl Output table structure containing quote line level Payment information for a quote with a Payment Id. This is a unique identifier generated for the newly created payment records.
2895 * @param X_Ln_Shipment_Tbl Output record structure containing line level Shipment information for a quote with a Shipment Id. This is a unique identifier generated for the newly created shipment records.
2896 * @param X_Ln_Freight_Charge_Tbl Not Used (Obsolete).
2897 * @param X_Ln_Tax_Detail_Tbl Output table structure containing line level Tax information for a quote with a Tax Detail Id. This is a unique identifier generated for the newly created tax detail records.
2898 * @param X_Ln_Sales_Credit_Tbl Output table structure containing line level Sales Credit information for a quote with a Sales Credit Id. This is a unique identifier generated for the newly created sales credit records.
2899 * @param X_Ln_Quote_Party_Tbl Not Used (Obsolete).
2900 * @rep:scope public
2901 * @rep:lifecycle active
2902 * @rep:category BUSINESS_ENTITY ASO_QUOTE
2903 * @rep:displayname Create Quote
2904 *
2905 */
2906
2907 PROCEDURE Create_quote(
2908 P_Api_Version_Number IN NUMBER,
2909 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2910 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2911 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2912 P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
2913 P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
2914 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2915 := G_Miss_Price_Attributes_Tbl,
2916 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2917 := G_MISS_PAYMENT_TBL,
2918 P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
2919 := G_MISS_SHIPMENT_REC,
2920 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
2921 := G_Miss_Freight_Charge_Tbl,
2922 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
2923 := G_Miss_Tax_Detail_Tbl,
2924 P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type
2925 := G_MISS_Line_Attribs_Ext_TBL,
2926 P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type
2927 := G_MISS_Sales_Credit_Tbl,
2928 P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type
2929 := G_MISS_Quote_Party_Tbl,
2930 P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
2931 P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type
2932 := G_MISS_QTE_LINE_DTL_TBL,
2933 P_Line_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type
2934 := G_MISS_Line_Attribs_Ext_TBL,
2935 P_line_rltship_tbl IN Line_Rltship_Tbl_Type
2936 := G_MISS_Line_Rltship_Tbl,
2937 P_Price_Adjustment_Tbl IN Price_Adj_Tbl_Type
2938 := G_Miss_Price_Adj_Tbl,
2939 P_Price_Adj_Attr_Tbl IN Price_Adj_Attr_Tbl_Type
2940 := G_Miss_PRICE_ADJ_ATTR_Tbl,
2941 P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type
2942 := G_Miss_Price_Adj_Rltship_Tbl,
2943 P_Ln_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
2944 := G_Miss_Price_Attributes_Tbl,
2945 P_Ln_Payment_Tbl IN Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
2946 P_Ln_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
2947 P_Ln_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type
2948 := G_Miss_Freight_Charge_Tbl,
2949 P_Ln_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type
2950 := G_Miss_Tax_Detail_Tbl,
2951 P_ln_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type
2952 := G_MISS_Sales_Credit_Tbl,
2956
2953 P_ln_Quote_Party_Tbl IN Quote_Party_Tbl_Type
2954 := G_MISS_Quote_Party_Tbl,
2955 x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Header_Rec_Type,
2957 X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Tbl_Type,
2958 X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_Tbl_Type,
2959 X_Hd_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
2960 X_Hd_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
2961 X_Hd_Shipment_Rec OUT NOCOPY /* file.sql.39 change */ Shipment_Rec_Type,
2962 X_Hd_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
2963 X_Hd_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
2964 X_hd_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_Type,
2965 X_hd_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ Sales_Credit_Tbl_Type,
2966 X_hd_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ Quote_Party_Tbl_Type,
2967 x_Line_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_Type,
2968 X_line_rltship_tbl OUT NOCOPY /* file.sql.39 change */ Line_Rltship_Tbl_Type,
2969 X_Price_Adjustment_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Tbl_Type,
2970 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Attr_Tbl_Type,
2971 X_Price_Adj_Rltship_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Rltship_Tbl_Type,
2972 X_Ln_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
2973 X_Ln_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
2974 X_Ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
2975 X_Ln_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
2976 X_Ln_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
2977 X_Ln_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ Sales_Credit_Tbl_Type,
2978 X_Ln_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ Quote_Party_Tbl_Type,
2979 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2980 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2981 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2982 );
2983
2984 -- *******************************************************
2985 -- Start of Comments
2986 -- *******************************************************
2987 -- API Name: Update_quote
2988 -- Type : Public
2989 -- Pre-Req :
2990 -- Parameters:
2991
2992 -- This is an overloaded procedure. It takes additional attributes
2993 -- which include the hd_attributes, sales credits and quote party record
2994 -- types
2995 /*#
2996 * Use this procedure to modify existing quotes.
2997 * This API allows users to modify the quote header, create and modify quote lines, enter and modify price adjustments, pricing attributes, sales credits, shipping information, tax handling information and payment information.
2998 * @param p_api_version_number API version used to check the compatibility of a call.
2999 * @param p_init_msg_list Boolean parameter which determines whether internal message tables should be initialized.
3000 * @param P_Validation_Level Number parameter to determine which validation steps to be executed and which steps to skip.
3001 * @param p_commit Boolean parameter which is used by API callers to ask the API to commit on their behalf after performing its function.
3002 * @param x_return_status Return status of the API call.
3003 * @param x_msg_count Number of stored processing messages.
3004 * @param x_msg_data Processing message data.
3005 * @param p_control_rec Input control record structure containing information about the actions (Price,Tax and so on) that can be performed on a quote.
3006 * @param P_Qte_Header_Rec Input record structure containing current header level information for a quote to be updated.
3007 * @param P_hd_Price_Attributes_Tbl Input table structure containing current header level information for pricing attributes.
3008 * @param P_hd_Payment_Tbl Input table structure containing current header level Payment information for a quote.
3009 * @param P_hd_Shipment_Tbl Input table structure containing current header level Shipment information for a quote.
3010 * @param P_hd_Freight_Charge_Tbl Not Used (Obsolete).
3011 * @param P_hd_Tax_Detail_Tbl Input table structure containing current header level Tax information for a quote.
3012 * @param P_hd_Attr_Ext_Tbl Not Used (Obsolete).
3013 * @param P_hd_Sales_Credit_Tbl Input table structure containing current header level Sales Credit information for a quote.
3014 * @param P_hd_Quote_Party_Tbl Not Used (Obsolete).
3015 * @param P_Qte_Line_Tbl Input table structure containing quote lines information for a quote.
3016 * @param P_Qte_Line_Dtl_Tbl Input table structure containing line details(Configuration Lines,Service Lines) information for a quote.
3017 * @param P_Line_Attr_Ext_Tbl Not Used (Obsolete).
3018 * @param P_line_rltship_tbl Input table structure containing relationships at line level.
3019 * @param P_Price_Adjustment_Tbl Input table structure containing Price Adjustments(Header and Lines) information for a quote.
3020 * @param P_Price_Adj_Attr_Tbl Input table structure containing Price Adjustments Attributes(Header and Lines) information for a quote.
3021 * @param P_Price_Adj_Rltship_Tbl Input table structure containing relationships at Price Adjustment level.
3022 * @param P_Ln_Price_Attributes_Tbl Input table structure containing quote line level information for pricing attributes.
3023 * @param P_Ln_Payment_Tbl Input table structure containing quote line level Payment information for a quote.
3027 * @param P_Ln_Sales_Credit_Tbl Input table structure containing quote line level Sales Credit information for a quote.
3024 * @param P_Ln_Shipment_Tbl Input record structure containing quote line level Shipment information for a quote.
3025 * @param P_Ln_Freight_Charge_Tbl Not Used (Obsolete).
3026 * @param P_Ln_Tax_Detail_Tbl Input table structure containing quote line level Tax information for a quote.
3028 * @param P_Ln_Quote_Party_Tbl Not Used (Obsolete).
3029 * @param X_Qte_Header_Rec Output record structure containing quote header level information with a Quote Header Id. This is a unique identifier generated for the quote.
3030 * @param X_hd_Price_Attributes_Tbl Output table structure containing header level information for pricing attributes with Price Attribute Id. This is a unique identifier generated for the price attribute records.
3031 * @param X_hd_Payment_Tbl Output table structure containing header level Payment information for a quote with Payment Id. This is a unique identifier generated for the payment records.
3032 * @param X_hd_Shipment_Tbl Output table structure containing header level Shipment information for a quote with a Shipment Id. This is a unique identifier generated for the shipment records.
3033 * @param X_Hd_Freight_Charge_Tbl Not Used (Obsolete).
3034 * @param X_hd_Tax_Detail_Tbl Output table structure containing header level Tax information for a quote with a Tax Detail Id. This is a unique identifier generated for the tax detail records.
3035 * @param X_hd_Attr_Ext_Tbl Not Used (Obsolete).
3036 * @param X_hd_Sales_Credit_Tbl Output table structure containing header level Sales Credit information for a quote with a Sales Credit Id. This is a unique identifier generated for the sales credit records.
3037 * @param X_hd_Quote_Party_Tbl Not Used (Obsolete).
3038 * @param X_Qte_Line_Tbl Output table structure containing quote lines information for a quote with a Quote Line Id. This is a unique identifier generated for the quote lines.
3039 * @param X_Qte_Line_Dtl_Tbl Output table structure containing line details(Configuration Lines,Service Lines) information for a quote with a Line Detail Id. This is a unique identifier generated for the line detail records.
3040 * @param X_Line_Attr_Ext_Tbl Not Used (Obsolete).
3041 * @param X_line_rltship_tbl Output table structure containing relationships at line level with Line Relationship Id.
3042 * @param X_Price_Adjustment_Tbl Output table structure containing Price Adjustments(Header and Lines) information for quote with a Price Adjustment Id. This is a unique identifier generated for the price adjustment records.
3043 * @param X_Price_Adj_Attr_Tbl Output table structure containing Price Adjustment Attributes(Header, Lines) information for a quote. Price Adjustment Attribute Id is a unique identifier generated for the price adjustment attributes records.
3044 * @param X_Price_Adj_Rltship_Tbl Output table structure containing relationships at Price Adjustment level with a Adjustment Relationship Id. This is a unique identifier generated for the price adjustment relationship.
3045 * @param X_Ln_Price_Attributes_Tbl Output table structure containing quote line level information for pricing attributes with a Price Attribute Id. This is a unique identifier generated for the price attribute records.
3046 * @param X_Ln_Payment_Tbl Output table structure containing quote line level Payment information for a quote with a Payment Id. This is a unique identifier generated for the payment records.
3047 * @param X_Ln_Shipment_Tbl Output record structure containing line level Shipment information for a quote with a Shipment Id. This is a unique identifier generated for the shipment records.
3048 * @param X_Ln_Freight_Charge_Tbl Not Used (Obsolete).
3049 * @param X_Ln_Tax_Detail_Tbl Output table structure containing line level Tax information for a quote with a Tax Detail Id. This is a unique identifier generated for the tax detail records.
3050 * @param X_Ln_Sales_Credit_Tbl Output table structure containing line level Sales Credit information for a quote with Sales Credit Id. This is a unique identifier generated for the sales credit records.
3051 * @param X_Ln_Quote_Party_Tbl Not Used (Obsolete).
3052 * @rep:scope public
3053 * @rep:lifecycle active
3054 * @rep:category BUSINESS_ENTITY ASO_QUOTE
3055 * @rep:displayname Update Quote
3056 */
3057
3058 PROCEDURE Update_quote(
3059 P_Api_Version_Number IN NUMBER,
3060 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3061 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3062 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3063 P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
3064 P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
3065 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
3066 := G_Miss_Price_Attributes_Tbl,
3067 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
3068 := G_MISS_PAYMENT_TBL,
3069 P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
3070 := G_MISS_SHIPMENT_TBL,
3071 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
3072 := G_Miss_Freight_Charge_Tbl,
3073 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
3074 := G_Miss_Tax_Detail_Tbl,
3075 P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type
3076 := G_MISS_Line_Attribs_Ext_TBL,
3077 P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type
3078 := G_MISS_Sales_Credit_Tbl,
3079 P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type
3080 := G_MISS_Quote_Party_Tbl,
3081 P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
3082 P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type
3083 := G_MISS_QTE_LINE_DTL_TBL,
3084 P_Line_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type
3085 := G_MISS_Line_Attribs_Ext_TBL,
3086 P_line_rltship_tbl IN Line_Rltship_Tbl_Type
3090 P_Price_Adj_Attr_Tbl IN Price_Adj_Attr_Tbl_Type
3087 := G_MISS_Line_Rltship_Tbl,
3088 P_Price_Adjustment_Tbl IN Price_Adj_Tbl_Type
3089 := G_Miss_Price_Adj_Tbl,
3091 := G_Miss_PRICE_ADJ_ATTR_Tbl,
3092 P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type
3093 := G_Miss_Price_Adj_Rltship_Tbl,
3094 P_Ln_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
3095 := G_Miss_Price_Attributes_Tbl,
3096 P_Ln_Payment_Tbl IN Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
3097 P_Ln_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
3098 P_Ln_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type
3099 := G_Miss_Freight_Charge_Tbl,
3100 P_Ln_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type
3101 := G_Miss_Tax_Detail_Tbl,
3102 P_ln_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type
3103 := G_MISS_Sales_Credit_Tbl,
3104 P_ln_Quote_Party_Tbl IN Quote_Party_Tbl_Type
3105 := G_MISS_Quote_Party_Tbl,
3106 x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Header_Rec_Type,
3107
3108 X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Tbl_Type,
3109 X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_Tbl_Type,
3110 X_Hd_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
3111 X_Hd_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
3112 X_Hd_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
3113 X_Hd_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
3114 X_Hd_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
3115 X_hd_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_Type,
3116 X_hd_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ Sales_Credit_Tbl_Type,
3117 X_hd_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ Quote_Party_Tbl_Type,
3118 x_Line_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_Type,
3119 X_line_rltship_tbl OUT NOCOPY /* file.sql.39 change */ Line_Rltship_Tbl_Type,
3120 X_Price_Adjustment_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Tbl_Type,
3121 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Attr_Tbl_Type,
3122 X_Price_Adj_Rltship_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Rltship_Tbl_Type,
3123 X_Ln_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
3124 X_Ln_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
3125 X_Ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
3126 X_Ln_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
3127 X_Ln_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
3128 X_Ln_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ Sales_Credit_Tbl_Type,
3129 X_Ln_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ Quote_Party_Tbl_Type,
3130 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3131 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3132 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3133 );
3134
3135
3136 -- *******************************************************
3137 -- Start of Comments
3138 -- *******************************************************
3139 -- API Name: Submit_Quote
3140 -- Type : Public
3141 -- Pre-Req :
3142 -- Parameters:
3143 -- overloaded function includes the p_commit flag
3144 --
3145 -- End of Comments
3146 --
3147 PROCEDURE Submit_quote(
3148 P_Api_Version_Number IN NUMBER,
3149 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3150 P_commit IN VARCHAR2 ,
3151 p_control_rec IN Submit_Control_Rec_Type
3152 := G_MISS_Submit_Control_Rec,
3153 P_Qte_Header_Id IN NUMBER,
3154 x_order_header_rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
3155 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3156 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3157 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3158 );
3159
3160
3161 -- *******************************************************
3162 -- Start of Comments
3163 -- *******************************************************
3164 -- API Name: Create_Quote_Line
3165 -- Type : Public
3166 -- Pre-Req :
3167 -- Parameters:
3168
3169
3170 --
3171 -- End of Comments
3172 --
3173 PROCEDURE Create_Quote_Line(
3174
3175 P_Api_Version_Number IN NUMBER,
3176 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3177 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3178 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3179 P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
3180 P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,
3181 P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
3182 P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type:= G_MISS_qte_line_dtl_TBL,
3183 P_Line_Attribs_Ext_Tbl IN Line_Attribs_Ext_Tbl_type
3184 := G_Miss_Line_Attribs_Ext_Tbl,
3185 P_Payment_Tbl IN Payment_Tbl_Type := G_MISS_Payment_TBL,
3186 P_Price_Adj_Tbl IN Price_Adj_Tbl_Type := G_MISS_Price_Adj_TBL,
3187 P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type := G_MISS_Price_attributes_TBL,
3188 P_Price_Adj_Attr_Tbl IN Price_Adj_Attr_Tbl_Type
3189 := G_Miss_PRICE_ADJ_ATTR_Tbl,
3190 P_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_shipment_TBL,
3191 P_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type:= G_MISS_tax_detail_TBL,
3195 P_Quote_Party_Tbl IN Quote_Party_Tbl_Type
3192 P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type := G_MISS_freight_charge_TBL,
3193 P_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type
3194 := G_MISS_Sales_Credit_Tbl,
3196 := G_MISS_Quote_Party_Tbl,
3197 P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,
3198 X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Line_Rec_Type,
3199 X_Qte_Line_Dtl_TBL OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_TBL_Type,
3200 X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_type,
3201 X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
3202 X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Tbl_Type,
3203 X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type ,
3204 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Attr_Tbl_Type,
3205 X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
3206 X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
3207 X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type ,
3208 X_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ Sales_Credit_Tbl_Type,
3209 X_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ Quote_Party_Tbl_Type,
3210 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3211 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3212 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3213 );
3214
3215 -- *******************************************************
3216 -- Start of Comments
3217 -- *******************************************************
3218 -- API Name: Update_Quote_Line
3219 -- Type : Public
3220 -- Pre-Req :
3221 -- Parameters:
3222 -- IN
3223
3224 PROCEDURE Update_Quote_Line(
3225 P_Api_Version_Number IN NUMBER,
3226 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3227 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3228 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3229 P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
3230 P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,
3231 P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
3232 P_Qte_Line_Dtl_TBL IN Qte_Line_Dtl_tbl_Type:= G_MISS_qte_line_dtl_TBL,
3233 P_Line_Attribs_Ext_Tbl IN Line_Attribs_Ext_Tbl_type
3234 := G_Miss_Line_Attribs_Ext_Tbl,
3235 P_Payment_Tbl IN Payment_Tbl_Type := G_MISS_Payment_TBL,
3236 P_Price_Adj_Tbl IN Price_Adj_Tbl_Type := G_MISS_Price_Adj_TBL,
3237 P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type := G_MISS_Price_attributes_TBL,
3238 P_Price_Adj_Attr_Tbl IN Price_Adj_Attr_Tbl_Type
3239 := G_Miss_PRICE_ADJ_ATTR_Tbl,
3240 P_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_shipment_TBL,
3241 P_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type:= G_MISS_tax_detail_TBL,
3242 P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type := G_MISS_freight_charge_TBL,
3243 P_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type
3244 := G_MISS_Sales_Credit_Tbl,
3245 P_Quote_Party_Tbl IN Quote_Party_Tbl_Type
3246 := G_MISS_Quote_Party_Tbl,
3247 P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,
3248 X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Line_Rec_Type,
3249 X_Qte_Line_Dtl_TBL OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_TBL_Type,
3250 X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_type,
3251 X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
3252 X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Tbl_Type,
3253 X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type ,
3254 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Attr_Tbl_Type,
3255 X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
3256 X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
3257 X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type ,
3258 X_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ Sales_Credit_Tbl_Type,
3259 X_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ Quote_Party_Tbl_Type,
3260 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3261 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3262 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3263 );
3264
3265 PROCEDURE Delete_Quote_Line(
3266 P_Api_Version_Number IN NUMBER,
3267 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3268 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3269 P_qte_line_Rec IN qte_line_Rec_Type,
3270 P_Control_REC IN Control_Rec_Type := G_MISS_Control_Rec,
3271 P_Update_Header_Flag IN VARCHAR2,
3272 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3273 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3274 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3275 );
3276
3277 PROCEDURE Quote_Security_Check(
3278 P_Api_Version_Number IN NUMBER,
3279 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3280 P_User_Id IN NUMBER,
3281 X_Resource_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3282 X_Security_Flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3283 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3287
3284 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3285 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3286 );
3288
3289 -- *******************************************************
3290 -- Start of Comments
3291 -- *******************************************************
3292 -- API Name: Submit_Quote
3293 -- Type : Public
3294 -- Pre-Req :
3295 -- Parameters: Overloaded to include P_Qte_Header_Rec
3296 --
3297 -- End of Comments
3298 --
3299
3300 /*# Use this procedure to convert quotes into orders.
3301
3302 * @param p_api_version_number API version used to check the compatibility of a call.
3303 * @param p_init_msg_list Boolean parameter which determines whether internal message tables should be initialized.
3304 * @param p_commit Boolean parameter which is used by API callers to ask the API to commit on their behalf after performing its function.
3305 * @param p_control_rec Input control record structure containing information about the actions (Price,Tax and so on.) that can be performed on a quote.
3306 * @param P_Qte_Header_Rec Input record structure containing current header level information of a quote to be converted into an order.
3307 * @param X_Order_Header_Rec Output record structure containing order header level information containing Order Id which is the unique identifier for an order.
3308 * @param x_return_status Return status of an API call
3309 * @param x_msg_count Number of stored processing messages.
3310 * @param x_msg_data Processing message data.
3311 * @rep:scope public
3312 * @rep:lifecycle active
3313 * @rep:category BUSINESS_ENTITY ASO_QUOTE
3314 * @rep:displayname Submit Quote
3315 */
3316 PROCEDURE Submit_Quote
3317 (
3318 P_Api_Version_Number IN NUMBER,
3319 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3320 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3321 p_control_rec IN ASO_QUOTE_PUB.SUBMIT_CONTROL_REC_TYPE
3322 := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
3323 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3324 X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
3325 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3326 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3327 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
3328
3329
3330 -- vtariker: Sales Credit Allocation Public API
3331 PROCEDURE Allocate_Sales_Credits
3332 (
3333 P_Api_Version_Number IN NUMBER,
3334 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3335 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3336 p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
3337 := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC,
3338 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3339 X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3340 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3341 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3342 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
3343
3344
3345 PROCEDURE Sales_Credit_Event_Pre (
3346 P_Qte_Header_Id IN NUMBER,
3347 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
3348
3349 PROCEDURE Sales_Credit_Event_Post (
3350 P_Qte_Header_Id IN NUMBER,
3351 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
3352
3353 -- *******************************************************
3354 -- Start of Comments
3355 -- *******************************************************
3356 -- API Name: Create_quote
3357 -- Type : Public
3358 -- Pre-Req :
3359 -- Parameters:
3360
3361 -- Version : Current version 2.0
3362 -- Note: This is an overloaded procedure. It takes additional attributes
3363 -- which include the p_template_tbl, P_Qte_Access_Tbl and P_Related_Obj_Tbl record
3364 -- types
3365 --
3366 -- End of Comments
3367 --
3368 PROCEDURE Create_quote(
3369 P_Api_Version_Number IN NUMBER,
3370 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3371 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3372 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3373 P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
3374 P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
3375 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
3376 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
3377 P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
3378 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
3379 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
3380 P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
3381 P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
3382 P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,
3383 P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
3384 P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type := G_MISS_QTE_LINE_DTL_TBL,
3388 P_Price_Adj_Attr_Tbl IN Price_Adj_Attr_Tbl_Type := G_Miss_PRICE_ADJ_ATTR_Tbl,
3385 P_Line_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
3386 P_line_rltship_tbl IN Line_Rltship_Tbl_Type := G_MISS_Line_Rltship_Tbl,
3387 P_Price_Adjustment_Tbl IN Price_Adj_Tbl_Type := G_Miss_Price_Adj_Tbl,
3389 P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type := G_Miss_Price_Adj_Rltship_Tbl,
3390 P_Ln_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
3391 P_Ln_Payment_Tbl IN Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
3392 P_Ln_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
3393 P_Ln_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
3394 P_Ln_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
3395 P_ln_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
3396 P_ln_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,
3397 P_Qte_Access_Tbl IN Qte_Access_Tbl_Type := G_MISS_QTE_ACCESS_TBL,
3398 P_Template_Tbl IN Template_Tbl_Type := G_MISS_TEMPLATE_TBL,
3399 P_Related_Obj_Tbl IN Related_Obj_Tbl_Type := G_MISS_RELATED_OBJ_TBL,
3400 x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Header_Rec_Type,
3401 X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Tbl_Type,
3402 X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_Tbl_Type,
3403 X_Hd_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
3404 X_Hd_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
3405 X_Hd_Shipment_Rec OUT NOCOPY /* file.sql.39 change */ Shipment_Rec_Type,
3406 X_Hd_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
3407 X_Hd_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
3408 X_hd_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_Type,
3409 X_hd_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ Sales_Credit_Tbl_Type,
3410 X_hd_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ Quote_Party_Tbl_Type,
3411 x_Line_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_Type,
3412 X_line_rltship_tbl OUT NOCOPY /* file.sql.39 change */ Line_Rltship_Tbl_Type,
3413 X_Price_Adjustment_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Tbl_Type,
3414 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Attr_Tbl_Type,
3415 X_Price_Adj_Rltship_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Rltship_Tbl_Type,
3416 X_Ln_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
3417 X_Ln_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
3418 X_Ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
3419 X_Ln_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
3420 X_Ln_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
3421 X_Ln_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ Sales_Credit_Tbl_Type,
3422 X_Ln_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ Quote_Party_Tbl_Type,
3423 X_Qte_Access_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Access_Tbl_Type,
3424 X_Template_Tbl OUT NOCOPY /* file.sql.39 change */ Template_Tbl_Type,
3425 X_Related_Obj_Tbl OUT NOCOPY /* file.sql.39 change */ Related_Obj_Tbl_Type,
3426 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3427 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3428 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3429 );
3430
3431 -- *******************************************************
3432 -- Start of Comments
3433 -- *******************************************************
3434 -- API Name: Create_quote_Service
3435 -- Type : Public
3436 -- Pre-Req :
3437 -- Parameters:
3438
3439 -- Version : Current version 1.0
3440 -- End of Comments
3441
3442 PROCEDURE Create_quote_Service(
3443 P_Api_Version_Number IN NUMBER,
3444 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3445 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3446 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3447 P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
3448 P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
3449 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
3450 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
3451 P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
3452 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
3453 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
3454 P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
3455 P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
3456 P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,
3457 P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
3458 P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type := G_MISS_QTE_LINE_DTL_TBL,
3459 P_Line_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
3463 P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type := G_Miss_Price_Adj_Rltship_Tbl,
3460 P_line_rltship_tbl IN Line_Rltship_Tbl_Type := G_MISS_Line_Rltship_Tbl,
3461 P_Price_Adjustment_Tbl IN Price_Adj_Tbl_Type := G_Miss_Price_Adj_Tbl,
3462 P_Price_Adj_Attr_Tbl IN Price_Adj_Attr_Tbl_Type := G_Miss_PRICE_ADJ_ATTR_Tbl,
3464 P_Ln_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
3465 P_Ln_Payment_Tbl IN Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
3466 P_Ln_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
3467 P_Ln_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
3468 P_Ln_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
3469 P_ln_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
3470 P_ln_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,
3471 P_Qte_Access_Tbl IN Qte_Access_Tbl_Type := G_MISS_QTE_ACCESS_TBL,
3472 P_Template_Tbl IN Template_Tbl_Type := G_MISS_TEMPLATE_TBL,
3473 P_Related_Obj_Tbl IN Related_Obj_Tbl_Type := G_MISS_RELATED_OBJ_TBL,
3474 x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Header_Rec_Type,
3475 X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Tbl_Type,
3476 X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_Tbl_Type,
3477 X_Hd_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
3478 X_Hd_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
3479 X_Hd_Shipment_Rec OUT NOCOPY /* file.sql.39 change */ Shipment_Rec_Type,
3480 X_Hd_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
3481 X_Hd_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
3482 X_hd_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_Type,
3483 X_hd_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ Sales_Credit_Tbl_Type,
3484 X_hd_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ Quote_Party_Tbl_Type,
3485 x_Line_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_Type,
3486 X_line_rltship_tbl OUT NOCOPY /* file.sql.39 change */ Line_Rltship_Tbl_Type,
3487 X_Price_Adjustment_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Tbl_Type,
3488 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Attr_Tbl_Type,
3489 X_Price_Adj_Rltship_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Rltship_Tbl_Type,
3490 X_Ln_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
3491 X_Ln_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
3492 X_Ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
3493 X_Ln_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
3494 X_Ln_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
3495 X_Ln_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ Sales_Credit_Tbl_Type,
3496 X_Ln_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ Quote_Party_Tbl_Type,
3497 X_Qte_Access_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Access_Tbl_Type,
3498 X_Template_Tbl OUT NOCOPY /* file.sql.39 change */ Template_Tbl_Type,
3499 X_Related_Obj_Tbl OUT NOCOPY /* file.sql.39 change */ Related_Obj_Tbl_Type,
3500 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3501 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3502 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3503 );
3504 -- *******************************************************
3505 -- Start of Comments
3506 -- *******************************************************
3507 -- API Name: Update_quote
3508 -- Type : Public
3509 -- Pre-Req :
3510 -- Parameters:
3511
3512 -- This is an overloaded procedure. It takes additional parameters
3513 -- which include the p_template_tbl, P_Qte_Access_Tbl and P_Related_Obj_Tbl record
3514 -- types
3515
3516
3517 PROCEDURE Update_quote(
3518 P_Api_Version_Number IN NUMBER,
3519 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3520 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3521 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3522 P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
3523 P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
3524 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
3525 := G_Miss_Price_Attributes_Tbl,
3526 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
3527 := G_MISS_PAYMENT_TBL,
3528 P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
3529 := G_MISS_SHIPMENT_TBL,
3530 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
3531 := G_Miss_Freight_Charge_Tbl,
3532 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
3533 := G_Miss_Tax_Detail_Tbl,
3534 P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type
3535 := G_MISS_Line_Attribs_Ext_TBL,
3536 P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type
3537 := G_MISS_Sales_Credit_Tbl,
3538 P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type
3539 := G_MISS_Quote_Party_Tbl,
3540 P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
3541 P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type
3542 := G_MISS_QTE_LINE_DTL_TBL,
3543 P_Line_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type
3544 := G_MISS_Line_Attribs_Ext_TBL,
3545 P_line_rltship_tbl IN Line_Rltship_Tbl_Type
3546 := G_MISS_Line_Rltship_Tbl,
3550 := G_Miss_PRICE_ADJ_ATTR_Tbl,
3547 P_Price_Adjustment_Tbl IN Price_Adj_Tbl_Type
3548 := G_Miss_Price_Adj_Tbl,
3549 P_Price_Adj_Attr_Tbl IN Price_Adj_Attr_Tbl_Type
3551 P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type
3552 := G_Miss_Price_Adj_Rltship_Tbl,
3553 P_Ln_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
3554 := G_Miss_Price_Attributes_Tbl,
3555 P_Ln_Payment_Tbl IN Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
3556 P_Ln_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
3557 P_Ln_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type
3558 := G_Miss_Freight_Charge_Tbl,
3559 P_Ln_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type
3560 := G_Miss_Tax_Detail_Tbl,
3561 P_ln_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type
3562 := G_MISS_Sales_Credit_Tbl,
3563 P_ln_Quote_Party_Tbl IN Quote_Party_Tbl_Type
3564 := G_MISS_Quote_Party_Tbl,
3565 P_Qte_Access_Tbl IN Qte_Access_Tbl_Type := G_MISS_QTE_ACCESS_TBL,
3566 P_Template_Tbl IN Template_Tbl_Type := G_MISS_TEMPLATE_TBL,
3567 P_Related_Obj_Tbl IN Related_Obj_Tbl_Type := G_MISS_RELATED_OBJ_TBL,
3568 x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Header_Rec_Type,
3569
3570 X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Tbl_Type,
3571 X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_Tbl_Type,
3572 X_Hd_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
3573 X_Hd_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
3574 X_Hd_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
3575 X_Hd_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
3576 X_Hd_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
3577 X_hd_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_Type,
3578 X_hd_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ Sales_Credit_Tbl_Type,
3579 X_hd_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ Quote_Party_Tbl_Type,
3580 x_Line_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_Type,
3581 X_line_rltship_tbl OUT NOCOPY /* file.sql.39 change */ Line_Rltship_Tbl_Type,
3582 X_Price_Adjustment_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Tbl_Type,
3583 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Attr_Tbl_Type,
3584 X_Price_Adj_Rltship_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Rltship_Tbl_Type,
3585 X_Ln_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type,
3586 X_Ln_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,
3587 X_Ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type,
3588 X_Ln_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charge_Tbl_Type,
3589 X_Ln_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Detail_Tbl_Type,
3590 X_Ln_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ Sales_Credit_Tbl_Type,
3591 X_Ln_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ Quote_Party_Tbl_Type,
3592 X_Qte_Access_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Access_Tbl_Type,
3593 X_Template_Tbl OUT NOCOPY /* file.sql.39 change */ Template_Tbl_Type,
3594 X_Related_Obj_Tbl OUT NOCOPY /* file.sql.39 change */ Related_Obj_Tbl_Type,
3595 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3596 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3597 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3598 );
3599
3600 -- *******************************************************
3601 -- Start of Comments
3602 -- *******************************************************
3603 -- API Name: validate_model_configuration
3604 -- Type : Public
3605 -- Pre-Req :
3606 -- Parameters:
3607
3608
3609 /*#
3610 * Use this procedure to validate the model configurations.
3611 * @param p_api_version_number API version used to check the compatibility of a call.
3612 * @param p_init_msg_list Boolean parameter which determines whether internal message tables should be initialized.
3613 * @param p_commit Boolean parameter which is used by API callers to ask the API to commit on their behalf after performing its function.
3614 * @param P_QUOTE_HEADER_ID Quote header id for the quote.
3615 * @param P_QUOTE_LINE_ID Quote line id for the top level model item in the quote. If this parameter is not passed, then all the configurations in the quote should be validated.
3616 * @param P_UPDATE_QUOTE If set to 'Yes', then the results of the validation will be applied. Default is 'Yes'. If set to No, then the quote will not be updated.
3617 * @param P_CONFIG_EFFECTIVE_DATE Date parameter and default value is FND_API.G_MISS_DATE. If no specific date value is passed then derives the date based on the profile ASO: Configuration Effective Date.
3618 * @param P_CONFIG_MODEL_LOOKUP_DATE Date parameter and default value is FND_API.G_MISS_DATE. If no specific date value is passed then derives the date based on the profile ASO: Configuration Effective Date.
3619 * @param X_Config_tbl Output table structure containing configuration details.
3620 * @param x_return_status Return status of an API call.
3621 * @param x_msg_count Number of stored processing messages.
3622 * @param x_msg_data Processing message data.
3623 * @rep:scope public
3624 * @rep:lifecycle active
3625 * @rep:category BUSINESS_ENTITY ASO_QUOTE
3626 * @rep:displayname Validate model configuration
3627 */
3628
3629 procedure validate_model_configuration
3630 (
3631 P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
3632 P_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE,
3636 P_UPDATE_QUOTE IN VARCHAR2 := FND_API.G_FALSE,
3633 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3634 P_Quote_header_id IN NUMBER,
3635 p_Quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
3637 P_Config_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,
3638 P_Config_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,
3639 X_Config_tbl OUT NOCOPY /* file.sql.39 change */ Config_Vaild_Tbl_Type,
3640 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3641 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3642 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3643 );
3644
3645 End ASO_QUOTE_PUB;
3646