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