[Home] [Help]
PACKAGE: APPS.OE_PRICING_CONT_PUB
Source
1 PACKAGE OE_Pricing_Cont_PUB AS
2 /* $Header: OEXPPRCS.pls 120.3 2006/02/22 10:35:10 shulin noship $ */
3
4
5 -- Contract record type
6
7 TYPE Contract_Rec_Type IS RECORD
8 ( agreement_id NUMBER := FND_API.G_MISS_NUM
9 , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
10 , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
11 , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
12 , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
13 , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
14 , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
15 , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
16 , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
17 , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
18 , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
19 , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
20 , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
21 , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
22 , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
23 , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
24 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
25 , created_by NUMBER := FND_API.G_MISS_NUM
26 , creation_date DATE := FND_API.G_MISS_DATE
27 , discount_id NUMBER := FND_API.G_MISS_NUM
28 , last_updated_by NUMBER := FND_API.G_MISS_NUM
29 , last_update_date DATE := FND_API.G_MISS_DATE
30 , last_update_login NUMBER := FND_API.G_MISS_NUM
31 , price_list_id NUMBER := FND_API.G_MISS_NUM
32 , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
33 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
34 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
36 );
37
38 TYPE Contract_Tbl_Type IS TABLE OF Contract_Rec_Type
39 INDEX BY BINARY_INTEGER;
40
41 -- Contract value record type
42
43 TYPE Contract_Val_Rec_Type IS RECORD
44 ( agreement VARCHAR2(240) := FND_API.G_MISS_CHAR
45 , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
46 , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
47 );
48
49 TYPE Contract_Val_Tbl_Type IS TABLE OF Contract_Val_Rec_Type
50 INDEX BY BINARY_INTEGER;
51
52 -- Agreement record type
53
54 TYPE Agreement_Rec_Type IS RECORD
55 ( accounting_rule_id NUMBER := FND_API.G_MISS_NUM
56 , agreement_contact_id NUMBER := FND_API.G_MISS_NUM
57 , agreement_id NUMBER := FND_API.G_MISS_NUM
58 , agreement_num VARCHAR2(50) := FND_API.G_MISS_CHAR
59 , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
60 , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61 , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62 , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63 , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64 , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65 , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66 , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67 , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68 , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69 , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70 , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71 , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72 , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73 , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74 , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75 , comments VARCHAR2(30) := FND_API.G_MISS_CHAR
76 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
77 , created_by NUMBER := FND_API.G_MISS_NUM
78 , creation_date DATE := FND_API.G_MISS_DATE
79 , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
80 , end_date_active DATE := FND_API.G_MISS_DATE
81 , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82 , invoice_contact_id NUMBER := FND_API.G_MISS_NUM
83 , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
84 , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
85 , last_updated_by NUMBER := FND_API.G_MISS_NUM
86 , last_update_date DATE := FND_API.G_MISS_DATE
87 , last_update_login NUMBER := FND_API.G_MISS_NUM
88 -- Bug 1815153
89 , name VARCHAR2(240) := FND_API.G_MISS_CHAR
90 , override_arule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91 , override_irule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92 , price_list_id NUMBER := FND_API.G_MISS_NUM
93 , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
94 , purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR
95 , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
96 , revision_date DATE := FND_API.G_MISS_DATE
97 , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
98 , salesrep_id NUMBER := FND_API.G_MISS_NUM
99 , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
100 , signature_date DATE := FND_API.G_MISS_DATE
101 , start_date_active DATE := FND_API.G_MISS_DATE
102 , term_id NUMBER := FND_API.G_MISS_NUM
103 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
104 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
105 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
106 , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
107 , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
108 , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
109 , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
110 , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
111 , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
112 , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
113 , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
114 , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
115 , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
116 , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
117 , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
118 , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
119 , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
120 , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
121 , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
122 , agreement_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
123 --added by rchellam for OKC
124 , orig_system_agr_id NUMBER := FND_API.G_MISS_NUM
125 --added by rchellam for OKC
126 , invoice_to_customer_id NUMBER := FND_API.G_MISS_NUM
127 -- Added for bug#4029589
128 );
129
130 TYPE Agreement_Tbl_Type IS TABLE OF Agreement_Rec_Type
131 INDEX BY BINARY_INTEGER;
132
133 -- Agreement value record type
134
135 TYPE Agreement_Val_Rec_Type IS RECORD
136 ( accounting_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
137 , agreement_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
138 , agreement VARCHAR2(240) := FND_API.G_MISS_CHAR
139 , agreement_type VARCHAR2(240) := FND_API.G_MISS_CHAR
140 , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
141 , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
142 , invoice_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
143 , invoice_to_site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
144 /* , invoice_to_org VARCHAR2(240) := FND_API.G_MISS_CHAR */
145 , invoicing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
146 , override_arule VARCHAR2(240) := FND_API.G_MISS_CHAR
147 , override_irule VARCHAR2(240) := FND_API.G_MISS_CHAR
148 , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
149 , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
150 , salesrep VARCHAR2(240) := FND_API.G_MISS_CHAR
151 , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
152 , term VARCHAR2(240) := FND_API.G_MISS_CHAR
153 , agreement_source VARCHAR2(240) := FND_API.G_MISS_CHAR --added by rchellam for OKC
154 );
155
156 TYPE Agreement_Val_Tbl_Type IS TABLE OF Agreement_Val_Rec_Type
157 INDEX BY BINARY_INTEGER;
158
159 -- Discount_Header record type
160
161 TYPE Discount_Header_Rec_Type IS RECORD
162 ( amount NUMBER := FND_API.G_MISS_NUM
163 , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
164 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
165 , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
166 , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
167 , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
168 , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
169 , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
170 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
171 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
172 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
173 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
174 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
175 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
176 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
177 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
178 , automatic_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
179 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
180 , created_by NUMBER := FND_API.G_MISS_NUM
181 , creation_date DATE := FND_API.G_MISS_DATE
182 , description VARCHAR2(240) := FND_API.G_MISS_CHAR
183 , discount_id NUMBER := FND_API.G_MISS_NUM
184 , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185 , discount_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
186 , end_date_active DATE := FND_API.G_MISS_DATE
187 , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
188 , last_updated_by NUMBER := FND_API.G_MISS_NUM
189 , last_update_date DATE := FND_API.G_MISS_DATE
190 , last_update_login NUMBER := FND_API.G_MISS_NUM
191 , manual_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
192 , name VARCHAR2(240) := FND_API.G_MISS_CHAR
193 , override_allowed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
194 , percent NUMBER := FND_API.G_MISS_NUM
195 , price_list_id NUMBER := FND_API.G_MISS_NUM
196 , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
197 , program_application_id NUMBER := FND_API.G_MISS_NUM
198 , program_id NUMBER := FND_API.G_MISS_NUM
199 , program_update_date DATE := FND_API.G_MISS_DATE
200 , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
201 , request_id NUMBER := FND_API.G_MISS_NUM
202 , start_date_active DATE := FND_API.G_MISS_DATE
203 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
204 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
205 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
206 );
207
208 TYPE Discount_Header_Tbl_Type IS TABLE OF Discount_Header_Rec_Type
209 INDEX BY BINARY_INTEGER;
210
211 -- Discount_Header value record type
212
213 TYPE Discount_Header_Val_Rec_Type IS RECORD
214 ( automatic_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
215 , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
216 , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
217 , discount_type VARCHAR2(240) := FND_API.G_MISS_CHAR
218 , manual_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
219 , override_allowed VARCHAR2(240) := FND_API.G_MISS_CHAR
220 , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
221 , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
222 );
223
224 TYPE Discount_Header_Val_Tbl_Type IS TABLE OF Discount_Header_Val_Rec_Type
225 INDEX BY BINARY_INTEGER;
226
227
228 -- Discount_Cust record type
229
230 TYPE Discount_Cust_Rec_Type IS RECORD
231 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
232 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
233 , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
234 , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
235 , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
236 , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
237 , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
238 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
239 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
240 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
241 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
242 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
243 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
244 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
245 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
246 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
247 , created_by NUMBER := FND_API.G_MISS_NUM
248 , creation_date DATE := FND_API.G_MISS_DATE
249 , customer_class_code VARCHAR2(30) := FND_API.G_MISS_CHAR
250 /* , customer_id NUMBER := FND_API.G_MISS_NUM */
251 , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
252 , discount_customer_id NUMBER := FND_API.G_MISS_NUM
253 , discount_id NUMBER := FND_API.G_MISS_NUM
254 , end_date_active DATE := FND_API.G_MISS_DATE
255 , last_updated_by NUMBER := FND_API.G_MISS_NUM
256 , last_update_date DATE := FND_API.G_MISS_DATE
257 , last_update_login NUMBER := FND_API.G_MISS_NUM
258 , program_application_id NUMBER := FND_API.G_MISS_NUM
259 , program_id NUMBER := FND_API.G_MISS_NUM
260 , program_update_date DATE := FND_API.G_MISS_DATE
261 , request_id NUMBER := FND_API.G_MISS_NUM
262 /*, site_use_id NUMBER := FND_API.G_MISS_NUM */
263 , site_org_id NUMBER := FND_API.G_MISS_NUM
264 , start_date_active DATE := FND_API.G_MISS_DATE
265 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
266 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
267 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
268 );
269
270 TYPE Discount_Cust_Tbl_Type IS TABLE OF Discount_Cust_Rec_Type
271 INDEX BY BINARY_INTEGER;
272
273 -- Discount_Cust value record type
274
278 , discount_customer VARCHAR2(240) := FND_API.G_MISS_CHAR
275 TYPE Discount_Cust_Val_Rec_Type IS RECORD
276 ( customer_class VARCHAR2(240) := FND_API.G_MISS_CHAR
277 , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
279 , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
280 , site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
281 );
282
283 TYPE Discount_Cust_Val_Tbl_Type IS TABLE OF Discount_Cust_Val_Rec_Type
284 INDEX BY BINARY_INTEGER;
285
286 -- Discount_Line record type
287
288 TYPE Discount_Line_Rec_Type IS RECORD
289 ( amount NUMBER := FND_API.G_MISS_NUM
290 , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
291 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
292 , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
293 , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
294 , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
295 , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
296 , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
297 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
298 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
299 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
300 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
301 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
302 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
303 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
304 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
305 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
306 , created_by NUMBER := FND_API.G_MISS_NUM
307 , creation_date DATE := FND_API.G_MISS_DATE
308 , customer_item_id NUMBER := FND_API.G_MISS_NUM
309 , discount_id NUMBER := FND_API.G_MISS_NUM
310 , discount_line_id NUMBER := FND_API.G_MISS_NUM
311 , end_date_active DATE := FND_API.G_MISS_DATE
312 , entity_id NUMBER := FND_API.G_MISS_NUM
313 , entity_value VARCHAR2(240) := FND_API.G_MISS_CHAR
314 , last_updated_by NUMBER := FND_API.G_MISS_NUM
315 , last_update_date DATE := FND_API.G_MISS_DATE
316 , last_update_login NUMBER := FND_API.G_MISS_NUM
317 , percent NUMBER := FND_API.G_MISS_NUM
318 , price NUMBER := FND_API.G_MISS_NUM
319 , program_application_id NUMBER := FND_API.G_MISS_NUM
320 , program_id NUMBER := FND_API.G_MISS_NUM
321 , program_update_date DATE := FND_API.G_MISS_DATE
322 , request_id NUMBER := FND_API.G_MISS_NUM
323 , start_date_active DATE := FND_API.G_MISS_DATE
324 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
325 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
326 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
327 );
328
329 TYPE Discount_Line_Tbl_Type IS TABLE OF Discount_Line_Rec_Type
330 INDEX BY BINARY_INTEGER;
331
332 -- Discount_Line value record type
333
334 TYPE Discount_Line_Val_Rec_Type IS RECORD
335 ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR
336 , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
337 , discount_line VARCHAR2(240) := FND_API.G_MISS_CHAR
338 , entity VARCHAR2(240) := FND_API.G_MISS_CHAR
339 );
340
341 TYPE Discount_Line_Val_Tbl_Type IS TABLE OF Discount_Line_Val_Rec_Type
342 INDEX BY BINARY_INTEGER;
343
344 -- Price_Break record type
345
346 TYPE Price_Break_Rec_Type IS RECORD
347 ( amount NUMBER := FND_API.G_MISS_NUM
348 , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
349 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
350 , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
351 , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
352 , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
353 , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
354 , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
355 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
356 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
357 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
358 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
359 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
360 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
361 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
362 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
363 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
364 , created_by NUMBER := FND_API.G_MISS_NUM
365 , creation_date DATE := FND_API.G_MISS_DATE
366 , discount_line_id NUMBER := FND_API.G_MISS_NUM
367 , end_date_active DATE := FND_API.G_MISS_DATE
371 , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
368 , last_updated_by NUMBER := FND_API.G_MISS_NUM
369 , last_update_date DATE := FND_API.G_MISS_DATE
370 , last_update_login NUMBER := FND_API.G_MISS_NUM
372 , percent NUMBER := FND_API.G_MISS_NUM
373 , price NUMBER := FND_API.G_MISS_NUM
374 , price_break_high NUMBER := FND_API.G_MISS_NUM
375 , price_break_low NUMBER := FND_API.G_MISS_NUM
376 , program_application_id NUMBER := FND_API.G_MISS_NUM
377 , program_id NUMBER := FND_API.G_MISS_NUM
378 , program_update_date DATE := FND_API.G_MISS_DATE
379 , request_id NUMBER := FND_API.G_MISS_NUM
380 , start_date_active DATE := FND_API.G_MISS_DATE
381 , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
382 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
383 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
384 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
385 , Discount_Line_index NUMBER := FND_API.G_MISS_NUM
386 );
387
388 TYPE Price_Break_Tbl_Type IS TABLE OF Price_Break_Rec_Type
389 INDEX BY BINARY_INTEGER;
390
391 -- Price_Break value record type
392
393 TYPE Price_Break_Val_Rec_Type IS RECORD
394 ( discount_line VARCHAR2(240) := FND_API.G_MISS_CHAR
395 , method_type VARCHAR2(240) := FND_API.G_MISS_CHAR
396 , unit VARCHAR2(240) := FND_API.G_MISS_CHAR
397 );
398
399 TYPE Price_Break_Val_Tbl_Type IS TABLE OF Price_Break_Val_Rec_Type
400 INDEX BY BINARY_INTEGER;
401
402 -- Variables representing missing records and tables
403
404 G_MISS_AGREEMENT_REC Agreement_Rec_Type;
405 G_MISS_AGREEMENT_VAL_REC Agreement_Val_Rec_Type;
406 G_MISS_AGREEMENT_TBL Agreement_Tbl_Type;
407 G_MISS_AGREEMENT_VAL_TBL Agreement_Val_Tbl_Type;
408 G_MISS_PRICE_LIST_REC QP_Price_List_PUB.Price_List_Rec_Type;
409 G_MISS_PRICE_LIST_VAL_REC QP_Price_List_PUB.Price_List_Val_Rec_Type;
410 G_MISS_PRICE_LIST_TBL QP_Price_List_PUB.Price_List_Tbl_Type;
411 G_MISS_PRICE_LIST_VAL_TBL QP_Price_List_PUB.Price_List_Val_Tbl_Type;
412 G_MISS_PRICE_LIST_LINE_REC QP_Price_List_PUB.Price_List_Line_Rec_Type;
413 G_MISS_PRICE_LIST_LINE_VAL_REC QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
414 G_MISS_PRICE_LIST_LINE_TBL QP_Price_List_PUB.Price_List_Line_Tbl_Type;
415 G_MISS_PRICE_LIST_LINE_VAL_TBL QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type;
416 G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
417 G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_Pub.Qualifiers_Val_Rec_Type;
418 G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
419 G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
420 G_MISS_PRICING_ATTR_REC QP_Price_List_PUB.Pricing_Attr_Rec_Type;
421 G_MISS_PRICING_ATTR_VAL_REC QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
422 G_MISS_PRICING_ATTR_TBL QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
423 G_MISS_PRICING_ATTR_VAL_TBL QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type;
424
425
426 G_MISS_CONTRACT_REC Contract_Rec_Type;
427 G_MISS_CONTRACT_VAL_REC Contract_Val_Rec_Type;
428 G_MISS_CONTRACT_TBL Contract_Tbl_Type;
429 G_MISS_CONTRACT_VAL_TBL Contract_Val_Tbl_Type;
430
431 G_MISS_DISCOUNT_HEADER_REC Discount_Header_Rec_Type;
432 G_MISS_DISCOUNT_HEADER_VAL_REC Discount_Header_Val_Rec_Type;
433 G_MISS_DISCOUNT_HEADER_TBL Discount_Header_Tbl_Type;
434 G_MISS_DISCOUNT_HEADER_VAL_TBL Discount_Header_Val_Tbl_Type;
435 G_MISS_DISCOUNT_CUST_REC Discount_Cust_Rec_Type;
436 G_MISS_DISCOUNT_CUST_VAL_REC Discount_Cust_Val_Rec_Type;
437 G_MISS_DISCOUNT_CUST_TBL Discount_Cust_Tbl_Type;
438 G_MISS_DISCOUNT_CUST_VAL_TBL Discount_Cust_Val_Tbl_Type;
439 G_MISS_DISCOUNT_LINE_REC Discount_Line_Rec_Type;
440 G_MISS_DISCOUNT_LINE_VAL_REC Discount_Line_Val_Rec_Type;
441 G_MISS_DISCOUNT_LINE_TBL Discount_Line_Tbl_Type;
442 G_MISS_DISCOUNT_LINE_VAL_TBL Discount_Line_Val_Tbl_Type;
443
444 G_MISS_PRICE_BREAK_REC Price_Break_Rec_Type;
445 G_MISS_PRICE_BREAK_VAL_REC Price_Break_Val_Rec_Type;
446 G_MISS_PRICE_BREAK_TBL Price_Break_Tbl_Type;
447 G_MISS_PRICE_BREAK_VAL_TBL Price_Break_Val_Tbl_Type;
448
449
450 -- Start of Comments
451 -- API name Process_Agreement
452 -- Type Public
453 -- Function
454 --
455 -- Pre-reqs
456 --
457 -- Parameters
458 --
459 -- Version Current version = 1.0
460 -- Initial version = 1.0
461 --
462 -- Notes
463 --
464 -- End of Comments
465
466 PROCEDURE Process_Agreement
467 ( p_api_version_number IN NUMBER
468 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
469 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
470 , p_commit IN VARCHAR2 := FND_API.G_FALSE
471 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
472 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
473 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
474 , p_Agreement_rec IN Agreement_Rec_Type :=
475 G_MISS_AGREEMENT_REC
476 , p_Agreement_val_rec IN Agreement_Val_Rec_Type :=
480 , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
477 G_MISS_AGREEMENT_VAL_REC
478 , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
479 G_MISS_PRICE_LIST_REC
481 G_MISS_PRICE_LIST_VAL_REC
482 , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
483 G_MISS_PRICE_LIST_LINE_TBL
484 , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
485 G_MISS_PRICE_LIST_LINE_VAL_TBL
486 , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
487 G_MISS_PRICING_ATTR_TBL
488 , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
489 G_MISS_PRICING_ATTR_VAL_TBL
490 , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
491 , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
492 , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
493 , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
494 , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
495 , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
496 , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
497 , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
498 , p_check_duplicate_lines IN VARCHAR2 DEFAULT NULL --5018856, 5024801, 5024919
499 );
500
501 -- Start of Comments
502 -- API name Lock_Agreement
503 -- Type Public
504 -- Function
505 --
506 -- Pre-reqs
507 --
508 -- Parameters
509 --
510 -- Version Current version = 1.0
511 -- Initial version = 1.0
512 --
513 -- Notes
514 --
515 -- End of Comments
516
517 PROCEDURE Lock_Agreement
518 ( p_api_version_number IN NUMBER
519 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
520 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
521 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
522 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
523 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
524 , p_Agreement_rec IN Agreement_Rec_Type :=
525 G_MISS_AGREEMENT_REC
526 , p_Agreement_val_rec IN Agreement_Val_Rec_Type :=
527 G_MISS_AGREEMENT_VAL_REC
528 , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
529 G_MISS_PRICE_LIST_REC
530 , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
531 G_MISS_PRICE_LIST_VAL_REC
532 , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
533 G_MISS_PRICE_LIST_LINE_TBL
534 , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
535 G_MISS_PRICE_LIST_LINE_VAL_TBL
536 , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
537 G_MISS_PRICING_ATTR_TBL
538 , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
539 G_MISS_PRICING_ATTR_VAL_TBL
540 , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
541 , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
542 , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
543 , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
544 , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
545 , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
546 , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
547 , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
548 );
549
550 -- Start of Comments
551 -- API name Get_Agreement
552 -- Type Public
553 -- Function
554 --
555 -- Pre-reqs
556 --
557 -- Parameters
558 --
559 -- Version Current version = 1.0
560 -- Initial version = 1.0
561 --
562 -- Notes
563 --
564 -- End of Comments
565
566 PROCEDURE Get_Agreement
567 ( p_api_version_number IN NUMBER
568 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
569 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
570 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
571 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
572 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
573 , p_agreement_id IN NUMBER := FND_API.G_MISS_NUM
574 /*, p_agreement IN VARCHAR2 := FND_API.G_MISS_CHAR
578 , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
575 , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */
576 , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
577 , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
579 , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
580 , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
581 , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
582 , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
583 , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
584 );
585
586 END OE_Pricing_Cont_PUB;