[Home] [Help]
PACKAGE: APPS.ASO_PRICING_INT
Source
1 PACKAGE ASO_PRICING_INT AUTHID CURRENT_USER AS
2 /* $Header: asoiprcs.pls 120.3 2011/06/28 07:40:13 rassharm 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 -- bug 12696699
109 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
110 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
111 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
112 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
113 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR
114 );
115
116 G_HEADER_REC PRICING_HEADER_REC_TYPE;
117
118
119 TYPE PRICING_LINE_REC_TYPE IS RECORD
120 (
121 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
122 CREATION_DATE DATE := FND_API.G_MISS_DATE,
123 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
124 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
125 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
126 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
127 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
128 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
129 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
130 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
131 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
132 ORG_ID NUMBER := FND_API.G_MISS_NUM,
133 LINE_CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
134 ITEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
135 LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
136 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
137 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
138 ORDER_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
139 INVOICE_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
140 INVOICE_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
141 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
142 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
143 QUANTITY NUMBER := FND_API.G_MISS_NUM,
144 UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
145 MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
146 PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM,
147 PRICE_LIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
148 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
149 LINE_LIST_PRICE NUMBER := FND_API.G_MISS_NUM,
150 LINE_ADJUSTED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
151 LINE_ADJUSTED_PERCENT NUMBER := FND_API.G_MISS_NUM,
152 LINE_QUOTE_PRICE NUMBER := FND_API.G_MISS_NUM,
153 RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
154 ITEM_RELATIONSHIP_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
155 ACCOUNTING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
156 INVOICING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
157 MODEL_ID NUMBER := FND_API.G_MISS_NUM,
158 SPLIT_SHIPMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
159 BACKORDER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
160 PRICING_LINE_TYPE_INDICATOR VARCHAR2(3) := FND_API.G_MISS_CHAR,
161 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
162 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
163 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
164 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
165 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
166 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
167 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
168 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
169 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
170 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
171 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
172 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
173 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
174 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
175 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
176 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
177 CONFIG_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
178 CONFIG_REVISION_NUM NUMBER := FND_API.G_MISS_NUM,
179 COMPLETE_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
180 VALID_CONFIGURATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
181 COMPONENT_CODE VARCHAR2(1000) := FND_API.G_MISS_CHAR,
182 SERVICE_COTERMINATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
183 SERVICE_DURATION NUMBER := FND_API.G_MISS_NUM,
184 SERVICE_PERIOD VARCHAR2(3) := FND_API.G_MISS_CHAR,
185 SERVICE_UNIT_SELLING_PERCENT NUMBER := FND_API.G_MISS_NUM,
186 SERVICE_UNIT_LIST_PERCENT NUMBER := FND_API.G_MISS_NUM,
187 SERVICE_NUMBER NUMBER := FND_API.G_MISS_NUM,
188 UNIT_PERCENT_BASE_PRICE NUMBER := FND_API.G_MISS_NUM,
189 SERVICE_REF_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
193 SERVICE_REF_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
190 SERVICE_REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
191 SERVICE_REF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
192 SERVICE_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
194 SERVICE_REF_OPTION_NUMB NUMBER := FND_API.G_MISS_NUM,
195 SERVICE_REF_SHIPMENT_NUMB NUMBER := FND_API.G_MISS_NUM,
196 RETURN_REF_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
197 RETURN_REF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
198 RETURN_REF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
199 RETURN_ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200 RETURN_ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
201 RETURN_ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
202 RETURN_ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
203 RETURN_ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
204 RETURN_ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
205 RETURN_ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
206 RETURN_ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
207 RETURN_ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
208 RETURN_ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
209 RETURN_ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
210 RETURN_ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
211 RETURN_ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
212 RETURN_ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
213 RETURN_ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
214 RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
215 RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
216 PROMISE_DATE DATE := FND_API.G_MISS_DATE,
217 REQUEST_DATE DATE := FND_API.G_MISS_DATE,
218 SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
219 SHIP_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
220 SHIP_TO_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
221 SHIP_PARTIAL_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
222 SHIP_SET_ID NUMBER := FND_API.G_MISS_NUM,
223 SHIP_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
224 FREIGHT_TERMS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
225 FREIGHT_CARRIER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
226 FOB_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
227 SHIPPING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
228 PACKING_INSTRUCTIONS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
229 SHIPPING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
230 RESERVED_QUANTITY VARCHAR2(240) := FND_API.G_MISS_NUM,
231 RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
232 SHIPMENT_PRIORITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
233 ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
234 INVOICE_TO_CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
235 SELLING_PRICE_CHANGE VARCHAR2(1) := FND_API.G_MISS_CHAR,
236 RECALCULATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
237 AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
238 MINISITE_ID NUMBER := FND_API.G_MISS_NUM,
239 CHARGE_PERIODICITY_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
240 PRICING_QUANTITY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
241 PRICING_QUANTITY NUMBER := FND_API.G_MISS_NUM,
242 -- bug 12696699
243 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
244 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
245 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
246 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
247 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR
248 );
249
250 G_LINE_REC PRICING_LINE_REC_TYPE;
251
252 FUNCTION Set_Global_Rec (
253 p_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
254 p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
255 RETURN PRICING_HEADER_REC_TYPE;
256
257 FUNCTION Set_Global_Rec (
258 p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
259 p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
260 p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
261 RETURN PRICING_LINE_REC_TYPE;
262
263
264 --wli_start
265 FUNCTION Get_Customer_Class
266 (p_cust_account_id IN NUMBER)
267 RETURN VARCHAR2;
268
269 FUNCTION Get_Account_Type
270 (p_cust_account_id IN NUMBER)
271 RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
272
273 FUNCTION Get_Sales_Channel
274 (p_cust_account_id IN NUMBER)
275 RETURN VARCHAR2;
276
277 FUNCTION Get_GSA
278 (p_cust_account_id NUMBER)
279 RETURN VARCHAR2;
280
281 FUNCTION Get_quote_Qty
282 (p_qte_header_id IN NUMBER)
283 RETURN VARCHAR2;
284
285 FUNCTION Get_quote_Amount(p_qte_header_id IN NUMBER)
286 RETURN VARCHAR2;
287
288 FUNCTION Get_shippable_flag(p_qte_line_id NUMBER)
289 RETURN VARCHAR2;
290 --wli_end
291
292 -- kchervel start
293 FUNCTION Get_Cust_Acct (p_quote_header_id NUMBER)
294 RETURN NUMBER;
295
296 FUNCTION Get_Ship_to_Site_Use (p_quote_header_id NUMBER)
297 RETURN NUMBER;
298
299 FUNCTION Get_Line_Ship_to_Site_Use (p_quote_line_id NUMBER)
300 RETURN NUMBER;
301
302 FUNCTION Get_Invoice_to_Site_Use (p_quote_header_id NUMBER)
303 RETURN NUMBER;
304
308 FUNCTION Get_Ship_to_Party_Site (p_quote_header_id NUMBER)
305 FUNCTION Get_Line_Invoice_Site_Use (p_quote_line_id NUMBER)
306 RETURN NUMBER;
307
309 RETURN NUMBER;
310
311 FUNCTION Get_Line_Ship_Party_Site (p_quote_line_id NUMBER)
312 RETURN NUMBER;
313
314 FUNCTION Get_Invoice_to_Party_Site (p_quote_header_id NUMBER)
315 RETURN NUMBER;
316
317 FUNCTION Get_Line_Invoice_Party_Site (p_quote_line_id NUMBER)
318 RETURN NUMBER;
319
320 --FUNCTION Get_Party_Id (p_quote_header_id NUMBER)
321 --RETURN NUMBER;
322 -- kchervel end
323
324 PROCEDURE Pricing_Item (
325 P_Api_Version_Number IN NUMBER,
326 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
327 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
328 p_control_rec IN PRICING_CONTROL_REC_TYPE,
329 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
330 p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
331 := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
332 p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
333 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
334 p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
335 p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
336 := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
337 p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
338 := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
339 p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
340 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
341 x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
342 x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
343 x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
344 x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
345 x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
346 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
347 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
348 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
349
350 PROCEDURE Pricing_Order(
351 P_Api_Version_Number IN NUMBER,
352 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
353 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
354 p_control_rec IN PRICING_CONTROL_REC_TYPE,
355 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
356 p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
357 := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
358 p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
359 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
360 p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
361 p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
362 := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
363 p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
364 := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
365 p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
366 := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
367 p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
368 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
369 x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
370 x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
371 x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
372 x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
373 x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
374 x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
375 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
376 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
377 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
378
379 PROCEDURE Pricing_Item (
380 P_Api_Version_Number IN NUMBER,
381 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
382 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
383 p_control_rec IN PRICING_CONTROL_REC_TYPE,
384 p_qte_line_id IN NUMBER,
385 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
386 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
387 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
388
389 PROCEDURE Pricing_Order (
390 P_Api_Version_Number IN NUMBER,
391 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
392 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
393 p_control_rec IN PRICING_CONTROL_REC_TYPE,
394 p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
395 p_qte_header_id IN NUMBER,
396 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
397 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
398 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
399
400 Procedure Delete_Promotion (
401 P_Api_Version_Number IN NUMBER,
402 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
403 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
404 p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
405 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
406 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
407 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
408
409 -- hagrawal_start
410 FUNCTION Get_Cust_Po(
411 p_qte_header_id number
412 ) RETURN VARCHAR2;
413
414 FUNCTION Get_line_Cust_Po(
415 p_qte_line_id number
416 ) RETURN VARCHAR2;
417
418 FUNCTION Get_Request_date(
419 p_qte_header_id number
420 ) RETURN DATE;
421
422 FUNCTION Get_line_Request_date(
423 p_qte_line_id number
424 ) RETURN DATE;
425
426 FUNCTION Get_Freight_term(
427 p_qte_header_id number
428 ) RETURN DATE;
429
430 FUNCTION Get_line_Freight_term(
431 p_qte_line_id number
432 ) RETURN VARCHAR2;
433
434 FUNCTION Get_Payment_term(
435 p_qte_header_id number
436 ) RETURN NUMBER;
437
438 FUNCTION Get_line_Payment_term(
439 p_qte_line_id number
440 ) RETURN NUMBER;
441
442 End ASO_PRICING_INT;