[Home] [Help]
PACKAGE: APPS.ASO_PRICING_INT
Source
1 PACKAGE ASO_PRICING_INT AS
2 /* $Header: asoiprcs.pls 120.2 2005/11/01 14:54:20 skulkarn ship $ */
3 -- Start of Comments
4 -- Package name : ASO_PRICING_INT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 TYPE Index_Link_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
11 G_MISS_Link_Tbl Index_Link_Tbl_Type;
12
13 TYPE PRICING_CONTROL_REC_TYPE IS RECORD
14 (
15 REQUEST_TYPE VARCHAR2(60),
16 PRICING_EVENT VARCHAR2(30),
17 CALCULATE_FLAG VARCHAR2(30) := 'Y',
18 SIMULATION_FLAG VARCHAR2(1) := 'N',
19 PRICE_CONFIG_FLAG VARCHAR2(1) := 'N',
20 PRICE_MODE VARCHAR2(30) := 'ENTIRE_QUOTE',
21 PRG_REPRICE_MODE VARCHAR2(3) := 'A' -- This parameter values are A or F; A for all lines and F for free lines
22 );
23
24 TYPE PRICING_HEADER_REC_TYPE IS RECORD
25 (
26 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
27 CREATION_DATE DATE := FND_API.G_MISS_DATE,
28 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
32 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36 ORG_ID NUMBER := FND_API.G_MISS_NUM,
37 QUOTE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
38 QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
39 QUOTE_VERSION NUMBER := FND_API.G_MISS_NUM,
40 QUOTE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
41 QUOTE_SOURCE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
42 QUOTE_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
43 PRICE_FROZEN_DATE DATE := FND_API.G_MISS_DATE,
44 QUOTE_PASSWORD VARCHAR2(240) := FND_API.G_MISS_CHAR,
45 ORIGINAL_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46 CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
47 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
48 CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
49 ORG_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
50 PHONE_ID NUMBER := FND_API.G_MISS_NUM,
51 INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
52 INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
53 ORIG_MKTG_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
54 MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
55 ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
56 QUOTE_CATEGORY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
57 ORDERED_DATE DATE := FND_API.G_MISS_DATE,
58 ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
59 INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
60 EMPLOYEE_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
61 PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
62 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
63 TOTAL_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
64 TOTAL_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
65 TOTAL_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
66 TOTAL_TAX NUMBER := FND_API.G_MISS_NUM,
67 TOTAL_SHIPPING_CHARGE NUMBER := FND_API.G_MISS_NUM,
68 SURCHARGE NUMBER := FND_API.G_MISS_NUM,
69 TOTAL_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
70 PAYMENT_AMOUNT NUMBER := FND_API.G_MISS_NUM,
71 CONTRACT_ID NUMBER := FND_API.G_MISS_NUM,
72 SALES_CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
73 ORDER_ID NUMBER := FND_API.G_MISS_NUM,
74 RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91 PROMISE_DATE DATE := FND_API.G_MISS_DATE,
92 REQUEST_DATE DATE := FND_API.G_MISS_DATE,
93 SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
94 SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95 SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
96 SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
97 SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
98 SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99 FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
100 FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101 FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102 SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103 PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104 EXCHANGE_TYPE_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
105 EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
106 EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
107 MINISITE_ID NUMBER := FND_API.G_MISS_NUM
108 );
109
110 G_HEADER_REC PRICING_HEADER_REC_TYPE;
111
112
113 TYPE PRICING_LINE_REC_TYPE IS RECORD
114 (
115 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
116 CREATION_DATE DATE := FND_API.G_MISS_DATE,
117 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
118 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
119 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
120 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
121 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
122 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
123 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
124 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
125 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
126 ORG_ID NUMBER := FND_API.G_MISS_NUM,
127 LINE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
128 ITEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
129 LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
130 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
131 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
132 ORDER_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
133 INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
134 INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
135 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
136 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
137 QUANTITY NUMBER := FND_API.G_MISS_NUM,
138 UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
139 MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
140 PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
141 PRICE_LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
142 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
143 LINE_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
144 LINE_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
145 LINE_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
146 LINE_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
147 RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
148 ITEM_RELATIONSHIP_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
149 ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
150 INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
151 MODEL_ID NUMBER := FND_API.G_MISS_NUM,
152 SPLIT_SHIPMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
153 BACKORDER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
154 PRICING_LINE_TYPE_INDICATOR VARCHAR2(3) := FND_API.G_MISS_CHAR,
155 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
156 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
157 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
158 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
159 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
160 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
161 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
162 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
163 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
164 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
165 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
166 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
167 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
168 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
169 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
170 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
171 CONFIG_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
172 CONFIG_REVISION_NUM NUMBER := FND_API.G_MISS_NUM,
173 COMPLETE_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
174 VALID_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
175 COMPONENT_CODE VARCHAR2(1000) := FND_API.G_MISS_CHAR,
176 SERVICE_COTERMINATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
177 SERVICE_DURATION NUMBER := FND_API.G_MISS_NUM,
178 SERVICE_PERIOD VARCHAR2(3) := FND_API.G_MISS_CHAR,
179 SERVICE_UNIT_SELLING_PERCENT NUMBER := FND_API.G_MISS_NUM,
180 SERVICE_UNIT_LIST_PERCENT NUMBER := FND_API.G_MISS_NUM,
181 SERVICE_NUMBER NUMBER := FND_API.G_MISS_NUM,
182 UNIT_PERCENT_BASE_PRICE NUMBER := FND_API.G_MISS_NUM,
183 SERVICE_REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
184 SERVICE_REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
185 SERVICE_REF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
186 SERVICE_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
187 SERVICE_REF_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
188 SERVICE_REF_OPTION_NUMB NUMBER := FND_API.G_MISS_NUM,
189 SERVICE_REF_SHIPMENT_NUMB NUMBER := FND_API.G_MISS_NUM,
190 RETURN_REF_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
191 RETURN_REF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
192 RETURN_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
193 RETURN_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
194 RETURN_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
195 RETURN_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
196 RETURN_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
197 RETURN_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
198 RETURN_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
199 RETURN_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200 RETURN_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
201 RETURN_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
202 RETURN_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
203 RETURN_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
204 RETURN_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
205 RETURN_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
206 RETURN_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
207 RETURN_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
208 RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
209 RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
210 PROMISE_DATE DATE := FND_API.G_MISS_DATE,
211 REQUEST_DATE DATE := FND_API.G_MISS_DATE,
212 SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
213 SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
214 SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
215 SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
216 SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
217 SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
218 FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
219 FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
220 FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
221 SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
222 PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
223 SHIPPING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
224 RESERVED_QUANTITY VARCHAR2(240) := FND_API.G_MISS_NUM,
225 RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
226 SHIPMENT_PRIORITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
227 ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
228 INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
229 SELLING_PRICE_CHANGE VARCHAR2(1) := FND_API.G_MISS_CHAR,
230 RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
231 AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
232 MINISITE_ID NUMBER := FND_API.G_MISS_NUM,
233 CHARGE_PERIODICITY_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
234 PRICING_QUANTITY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
235 PRICING_QUANTITY NUMBER := FND_API.G_MISS_NUM
236 );
237
238 G_LINE_REC PRICING_LINE_REC_TYPE;
239
240 FUNCTION Set_Global_Rec (
241 p_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
242 p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
243 RETURN PRICING_HEADER_REC_TYPE;
244
245 FUNCTION Set_Global_Rec (
246 p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
247 p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
248 p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
249 RETURN PRICING_LINE_REC_TYPE;
250
251
252 --wli_start
253 FUNCTION Get_Customer_Class
254 (p_cust_account_id IN NUMBER)
255 RETURN VARCHAR2;
256
257 FUNCTION Get_Account_Type
258 (p_cust_account_id IN NUMBER)
259 RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
260
261 FUNCTION Get_Sales_Channel
262 (p_cust_account_id IN NUMBER)
263 RETURN VARCHAR2;
264
265 FUNCTION Get_GSA
266 (p_cust_account_id NUMBER)
267 RETURN VARCHAR2;
268
269 FUNCTION Get_quote_Qty
270 (p_qte_header_id IN NUMBER)
271 RETURN VARCHAR2;
272
273 FUNCTION Get_quote_Amount(p_qte_header_id IN NUMBER)
274 RETURN VARCHAR2;
275
276 FUNCTION Get_shippable_flag(p_qte_line_id NUMBER)
277 RETURN VARCHAR2;
278 --wli_end
279
280 -- kchervel start
284 FUNCTION Get_Ship_to_Site_Use (p_quote_header_id NUMBER)
281 FUNCTION Get_Cust_Acct (p_quote_header_id NUMBER)
282 RETURN NUMBER;
283
285 RETURN NUMBER;
286
287 FUNCTION Get_Line_Ship_to_Site_Use (p_quote_line_id NUMBER)
288 RETURN NUMBER;
289
290 FUNCTION Get_Invoice_to_Site_Use (p_quote_header_id NUMBER)
291 RETURN NUMBER;
292
293 FUNCTION Get_Line_Invoice_Site_Use (p_quote_line_id NUMBER)
294 RETURN NUMBER;
295
296 FUNCTION Get_Ship_to_Party_Site (p_quote_header_id NUMBER)
297 RETURN NUMBER;
298
299 FUNCTION Get_Line_Ship_Party_Site (p_quote_line_id NUMBER)
300 RETURN NUMBER;
301
302 FUNCTION Get_Invoice_to_Party_Site (p_quote_header_id NUMBER)
303 RETURN NUMBER;
304
305 FUNCTION Get_Line_Invoice_Party_Site (p_quote_line_id NUMBER)
306 RETURN NUMBER;
307
308 --FUNCTION Get_Party_Id (p_quote_header_id NUMBER)
309 --RETURN NUMBER;
310 -- kchervel end
311
312 PROCEDURE Pricing_Item (
313 P_Api_Version_Number IN NUMBER,
314 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
315 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
316 p_control_rec IN PRICING_CONTROL_REC_TYPE,
317 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
318 p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
319 := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
320 p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
321 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
322 p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
323 p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
324 := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
325 p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
326 := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
327 p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
328 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
329 x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
330 x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
331 x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
332 x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
333 x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
334 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
335 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
336 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
337
338 PROCEDURE Pricing_Order(
339 P_Api_Version_Number IN NUMBER,
340 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
341 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
342 p_control_rec IN PRICING_CONTROL_REC_TYPE,
343 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
344 p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
345 := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
346 p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
347 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
348 p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
349 p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
350 := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
351 p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
352 := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
353 p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
354 := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
355 p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
356 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
357 x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
358 x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
359 x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
360 x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
361 x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
362 x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
363 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
364 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
365 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
366
367 PROCEDURE Pricing_Item (
368 P_Api_Version_Number IN NUMBER,
369 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
370 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
371 p_control_rec IN PRICING_CONTROL_REC_TYPE,
372 p_qte_line_id IN NUMBER,
373 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
374 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
375 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
376
377 PROCEDURE Pricing_Order (
378 P_Api_Version_Number IN NUMBER,
379 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
380 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
381 p_control_rec IN PRICING_CONTROL_REC_TYPE,
382 p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
383 p_qte_header_id IN NUMBER,
384 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
385 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
386 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
387
388 Procedure Delete_Promotion (
389 P_Api_Version_Number IN NUMBER,
390 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
391 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
392 p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
393 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
394 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
395 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
396
397 -- hagrawal_start
398 FUNCTION Get_Cust_Po(
399 p_qte_header_id number
400 ) RETURN VARCHAR2;
401
402 FUNCTION Get_line_Cust_Po(
403 p_qte_line_id number
404 ) RETURN VARCHAR2;
405
406 FUNCTION Get_Request_date(
407 p_qte_header_id number
408 ) RETURN DATE;
409
410 FUNCTION Get_line_Request_date(
411 p_qte_line_id number
412 ) RETURN DATE;
413
414 FUNCTION Get_Freight_term(
415 p_qte_header_id number
416 ) RETURN DATE;
417
418 FUNCTION Get_line_Freight_term(
419 p_qte_line_id number
420 ) RETURN VARCHAR2;
421
422 FUNCTION Get_Payment_term(
423 p_qte_header_id number
424 ) RETURN NUMBER;
425
426 FUNCTION Get_line_Payment_term(
427 p_qte_line_id number
428 ) RETURN NUMBER;
429
430 End ASO_PRICING_INT;