183: TYPE budget_tbl_type IS TABLE OF budget_rec_type INDEX BY BINARY_INTEGER;
184:
185: TYPE Modifier_LIST_Rec_Type IS RECORD
186: (
187: offer_id NUMBER := Fnd_Api.g_miss_num
188: ,qp_list_header_id NUMBER := Fnd_Api.g_miss_num
189: ,offer_type VARCHAR2(30) := Fnd_Api.g_miss_char
190: ,offer_code VARCHAR2(100) := Fnd_Api.g_miss_char
191: ,activity_media_id NUMBER := Fnd_Api.g_miss_num
184:
185: TYPE Modifier_LIST_Rec_Type IS RECORD
186: (
187: offer_id NUMBER := Fnd_Api.g_miss_num
188: ,qp_list_header_id NUMBER := Fnd_Api.g_miss_num
189: ,offer_type VARCHAR2(30) := Fnd_Api.g_miss_char
190: ,offer_code VARCHAR2(100) := Fnd_Api.g_miss_char
191: ,activity_media_id NUMBER := Fnd_Api.g_miss_num
192: ,reusable VARCHAR2(1) := Fnd_Api.g_miss_char
185: TYPE Modifier_LIST_Rec_Type IS RECORD
186: (
187: offer_id NUMBER := Fnd_Api.g_miss_num
188: ,qp_list_header_id NUMBER := Fnd_Api.g_miss_num
189: ,offer_type VARCHAR2(30) := Fnd_Api.g_miss_char
190: ,offer_code VARCHAR2(100) := Fnd_Api.g_miss_char
191: ,activity_media_id NUMBER := Fnd_Api.g_miss_num
192: ,reusable VARCHAR2(1) := Fnd_Api.g_miss_char
193: ,user_status_id NUMBER := Fnd_Api.g_miss_num
186: (
187: offer_id NUMBER := Fnd_Api.g_miss_num
188: ,qp_list_header_id NUMBER := Fnd_Api.g_miss_num
189: ,offer_type VARCHAR2(30) := Fnd_Api.g_miss_char
190: ,offer_code VARCHAR2(100) := Fnd_Api.g_miss_char
191: ,activity_media_id NUMBER := Fnd_Api.g_miss_num
192: ,reusable VARCHAR2(1) := Fnd_Api.g_miss_char
193: ,user_status_id NUMBER := Fnd_Api.g_miss_num
194: ,owner_id NUMBER := Fnd_Api.g_miss_num
187: offer_id NUMBER := Fnd_Api.g_miss_num
188: ,qp_list_header_id NUMBER := Fnd_Api.g_miss_num
189: ,offer_type VARCHAR2(30) := Fnd_Api.g_miss_char
190: ,offer_code VARCHAR2(100) := Fnd_Api.g_miss_char
191: ,activity_media_id NUMBER := Fnd_Api.g_miss_num
192: ,reusable VARCHAR2(1) := Fnd_Api.g_miss_char
193: ,user_status_id NUMBER := Fnd_Api.g_miss_num
194: ,owner_id NUMBER := Fnd_Api.g_miss_num
195: ,wf_item_key VARCHAR2(120) := Fnd_Api.g_miss_char
188: ,qp_list_header_id NUMBER := Fnd_Api.g_miss_num
189: ,offer_type VARCHAR2(30) := Fnd_Api.g_miss_char
190: ,offer_code VARCHAR2(100) := Fnd_Api.g_miss_char
191: ,activity_media_id NUMBER := Fnd_Api.g_miss_num
192: ,reusable VARCHAR2(1) := Fnd_Api.g_miss_char
193: ,user_status_id NUMBER := Fnd_Api.g_miss_num
194: ,owner_id NUMBER := Fnd_Api.g_miss_num
195: ,wf_item_key VARCHAR2(120) := Fnd_Api.g_miss_char
196: ,customer_reference VARCHAR2(240) := Fnd_Api.g_miss_char
189: ,offer_type VARCHAR2(30) := Fnd_Api.g_miss_char
190: ,offer_code VARCHAR2(100) := Fnd_Api.g_miss_char
191: ,activity_media_id NUMBER := Fnd_Api.g_miss_num
192: ,reusable VARCHAR2(1) := Fnd_Api.g_miss_char
193: ,user_status_id NUMBER := Fnd_Api.g_miss_num
194: ,owner_id NUMBER := Fnd_Api.g_miss_num
195: ,wf_item_key VARCHAR2(120) := Fnd_Api.g_miss_char
196: ,customer_reference VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,buying_group_contact_id NUMBER := Fnd_Api.g_miss_num
190: ,offer_code VARCHAR2(100) := Fnd_Api.g_miss_char
191: ,activity_media_id NUMBER := Fnd_Api.g_miss_num
192: ,reusable VARCHAR2(1) := Fnd_Api.g_miss_char
193: ,user_status_id NUMBER := Fnd_Api.g_miss_num
194: ,owner_id NUMBER := Fnd_Api.g_miss_num
195: ,wf_item_key VARCHAR2(120) := Fnd_Api.g_miss_char
196: ,customer_reference VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,buying_group_contact_id NUMBER := Fnd_Api.g_miss_num
198: ,object_version_number NUMBER := Fnd_Api.g_miss_num
191: ,activity_media_id NUMBER := Fnd_Api.g_miss_num
192: ,reusable VARCHAR2(1) := Fnd_Api.g_miss_char
193: ,user_status_id NUMBER := Fnd_Api.g_miss_num
194: ,owner_id NUMBER := Fnd_Api.g_miss_num
195: ,wf_item_key VARCHAR2(120) := Fnd_Api.g_miss_char
196: ,customer_reference VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,buying_group_contact_id NUMBER := Fnd_Api.g_miss_num
198: ,object_version_number NUMBER := Fnd_Api.g_miss_num
199: ,perf_date_from DATE := Fnd_Api.g_miss_date
192: ,reusable VARCHAR2(1) := Fnd_Api.g_miss_char
193: ,user_status_id NUMBER := Fnd_Api.g_miss_num
194: ,owner_id NUMBER := Fnd_Api.g_miss_num
195: ,wf_item_key VARCHAR2(120) := Fnd_Api.g_miss_char
196: ,customer_reference VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,buying_group_contact_id NUMBER := Fnd_Api.g_miss_num
198: ,object_version_number NUMBER := Fnd_Api.g_miss_num
199: ,perf_date_from DATE := Fnd_Api.g_miss_date
200: ,perf_date_to DATE := Fnd_Api.g_miss_date
193: ,user_status_id NUMBER := Fnd_Api.g_miss_num
194: ,owner_id NUMBER := Fnd_Api.g_miss_num
195: ,wf_item_key VARCHAR2(120) := Fnd_Api.g_miss_char
196: ,customer_reference VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,buying_group_contact_id NUMBER := Fnd_Api.g_miss_num
198: ,object_version_number NUMBER := Fnd_Api.g_miss_num
199: ,perf_date_from DATE := Fnd_Api.g_miss_date
200: ,perf_date_to DATE := Fnd_Api.g_miss_date
201: ,status_code VARCHAR2(30) := Fnd_Api.g_miss_char
194: ,owner_id NUMBER := Fnd_Api.g_miss_num
195: ,wf_item_key VARCHAR2(120) := Fnd_Api.g_miss_char
196: ,customer_reference VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,buying_group_contact_id NUMBER := Fnd_Api.g_miss_num
198: ,object_version_number NUMBER := Fnd_Api.g_miss_num
199: ,perf_date_from DATE := Fnd_Api.g_miss_date
200: ,perf_date_to DATE := Fnd_Api.g_miss_date
201: ,status_code VARCHAR2(30) := Fnd_Api.g_miss_char
202: ,status_date DATE := Fnd_Api.g_miss_date
195: ,wf_item_key VARCHAR2(120) := Fnd_Api.g_miss_char
196: ,customer_reference VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,buying_group_contact_id NUMBER := Fnd_Api.g_miss_num
198: ,object_version_number NUMBER := Fnd_Api.g_miss_num
199: ,perf_date_from DATE := Fnd_Api.g_miss_date
200: ,perf_date_to DATE := Fnd_Api.g_miss_date
201: ,status_code VARCHAR2(30) := Fnd_Api.g_miss_char
202: ,status_date DATE := Fnd_Api.g_miss_date
203: ,modifier_level_code VARCHAR2(30) := Fnd_Api.g_miss_char
196: ,customer_reference VARCHAR2(240) := Fnd_Api.g_miss_char
197: ,buying_group_contact_id NUMBER := Fnd_Api.g_miss_num
198: ,object_version_number NUMBER := Fnd_Api.g_miss_num
199: ,perf_date_from DATE := Fnd_Api.g_miss_date
200: ,perf_date_to DATE := Fnd_Api.g_miss_date
201: ,status_code VARCHAR2(30) := Fnd_Api.g_miss_char
202: ,status_date DATE := Fnd_Api.g_miss_date
203: ,modifier_level_code VARCHAR2(30) := Fnd_Api.g_miss_char
204: ,order_value_discount_type VARCHAR2(30) := Fnd_Api.g_miss_char
197: ,buying_group_contact_id NUMBER := Fnd_Api.g_miss_num
198: ,object_version_number NUMBER := Fnd_Api.g_miss_num
199: ,perf_date_from DATE := Fnd_Api.g_miss_date
200: ,perf_date_to DATE := Fnd_Api.g_miss_date
201: ,status_code VARCHAR2(30) := Fnd_Api.g_miss_char
202: ,status_date DATE := Fnd_Api.g_miss_date
203: ,modifier_level_code VARCHAR2(30) := Fnd_Api.g_miss_char
204: ,order_value_discount_type VARCHAR2(30) := Fnd_Api.g_miss_char
205: ,lumpsum_amount NUMBER := Fnd_Api.g_miss_num
198: ,object_version_number NUMBER := Fnd_Api.g_miss_num
199: ,perf_date_from DATE := Fnd_Api.g_miss_date
200: ,perf_date_to DATE := Fnd_Api.g_miss_date
201: ,status_code VARCHAR2(30) := Fnd_Api.g_miss_char
202: ,status_date DATE := Fnd_Api.g_miss_date
203: ,modifier_level_code VARCHAR2(30) := Fnd_Api.g_miss_char
204: ,order_value_discount_type VARCHAR2(30) := Fnd_Api.g_miss_char
205: ,lumpsum_amount NUMBER := Fnd_Api.g_miss_num
206: ,lumpsum_payment_type VARCHAR2(30) := Fnd_Api.g_miss_char
199: ,perf_date_from DATE := Fnd_Api.g_miss_date
200: ,perf_date_to DATE := Fnd_Api.g_miss_date
201: ,status_code VARCHAR2(30) := Fnd_Api.g_miss_char
202: ,status_date DATE := Fnd_Api.g_miss_date
203: ,modifier_level_code VARCHAR2(30) := Fnd_Api.g_miss_char
204: ,order_value_discount_type VARCHAR2(30) := Fnd_Api.g_miss_char
205: ,lumpsum_amount NUMBER := Fnd_Api.g_miss_num
206: ,lumpsum_payment_type VARCHAR2(30) := Fnd_Api.g_miss_char
207: ,custom_setup_id NUMBER := Fnd_Api.g_miss_num
200: ,perf_date_to DATE := Fnd_Api.g_miss_date
201: ,status_code VARCHAR2(30) := Fnd_Api.g_miss_char
202: ,status_date DATE := Fnd_Api.g_miss_date
203: ,modifier_level_code VARCHAR2(30) := Fnd_Api.g_miss_char
204: ,order_value_discount_type VARCHAR2(30) := Fnd_Api.g_miss_char
205: ,lumpsum_amount NUMBER := Fnd_Api.g_miss_num
206: ,lumpsum_payment_type VARCHAR2(30) := Fnd_Api.g_miss_char
207: ,custom_setup_id NUMBER := Fnd_Api.g_miss_num
208: ,offer_amount NUMBER := FND_API.g_miss_num
201: ,status_code VARCHAR2(30) := Fnd_Api.g_miss_char
202: ,status_date DATE := Fnd_Api.g_miss_date
203: ,modifier_level_code VARCHAR2(30) := Fnd_Api.g_miss_char
204: ,order_value_discount_type VARCHAR2(30) := Fnd_Api.g_miss_char
205: ,lumpsum_amount NUMBER := Fnd_Api.g_miss_num
206: ,lumpsum_payment_type VARCHAR2(30) := Fnd_Api.g_miss_char
207: ,custom_setup_id NUMBER := Fnd_Api.g_miss_num
208: ,offer_amount NUMBER := FND_API.g_miss_num
209: ,budget_amount_tc NUMBER := Fnd_Api.g_miss_num
202: ,status_date DATE := Fnd_Api.g_miss_date
203: ,modifier_level_code VARCHAR2(30) := Fnd_Api.g_miss_char
204: ,order_value_discount_type VARCHAR2(30) := Fnd_Api.g_miss_char
205: ,lumpsum_amount NUMBER := Fnd_Api.g_miss_num
206: ,lumpsum_payment_type VARCHAR2(30) := Fnd_Api.g_miss_char
207: ,custom_setup_id NUMBER := Fnd_Api.g_miss_num
208: ,offer_amount NUMBER := FND_API.g_miss_num
209: ,budget_amount_tc NUMBER := Fnd_Api.g_miss_num
210: ,budget_amount_fc NUMBER := Fnd_Api.g_miss_num
203: ,modifier_level_code VARCHAR2(30) := Fnd_Api.g_miss_char
204: ,order_value_discount_type VARCHAR2(30) := Fnd_Api.g_miss_char
205: ,lumpsum_amount NUMBER := Fnd_Api.g_miss_num
206: ,lumpsum_payment_type VARCHAR2(30) := Fnd_Api.g_miss_char
207: ,custom_setup_id NUMBER := Fnd_Api.g_miss_num
208: ,offer_amount NUMBER := FND_API.g_miss_num
209: ,budget_amount_tc NUMBER := Fnd_Api.g_miss_num
210: ,budget_amount_fc NUMBER := Fnd_Api.g_miss_num
211: ,transaction_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
204: ,order_value_discount_type VARCHAR2(30) := Fnd_Api.g_miss_char
205: ,lumpsum_amount NUMBER := Fnd_Api.g_miss_num
206: ,lumpsum_payment_type VARCHAR2(30) := Fnd_Api.g_miss_char
207: ,custom_setup_id NUMBER := Fnd_Api.g_miss_num
208: ,offer_amount NUMBER := FND_API.g_miss_num
209: ,budget_amount_tc NUMBER := Fnd_Api.g_miss_num
210: ,budget_amount_fc NUMBER := Fnd_Api.g_miss_num
211: ,transaction_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
212: ,functional_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
205: ,lumpsum_amount NUMBER := Fnd_Api.g_miss_num
206: ,lumpsum_payment_type VARCHAR2(30) := Fnd_Api.g_miss_char
207: ,custom_setup_id NUMBER := Fnd_Api.g_miss_num
208: ,offer_amount NUMBER := FND_API.g_miss_num
209: ,budget_amount_tc NUMBER := Fnd_Api.g_miss_num
210: ,budget_amount_fc NUMBER := Fnd_Api.g_miss_num
211: ,transaction_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
212: ,functional_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
213: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
206: ,lumpsum_payment_type VARCHAR2(30) := Fnd_Api.g_miss_char
207: ,custom_setup_id NUMBER := Fnd_Api.g_miss_num
208: ,offer_amount NUMBER := FND_API.g_miss_num
209: ,budget_amount_tc NUMBER := Fnd_Api.g_miss_num
210: ,budget_amount_fc NUMBER := Fnd_Api.g_miss_num
211: ,transaction_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
212: ,functional_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
213: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
214: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
207: ,custom_setup_id NUMBER := Fnd_Api.g_miss_num
208: ,offer_amount NUMBER := FND_API.g_miss_num
209: ,budget_amount_tc NUMBER := Fnd_Api.g_miss_num
210: ,budget_amount_fc NUMBER := Fnd_Api.g_miss_num
211: ,transaction_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
212: ,functional_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
213: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
214: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
215: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
208: ,offer_amount NUMBER := FND_API.g_miss_num
209: ,budget_amount_tc NUMBER := Fnd_Api.g_miss_num
210: ,budget_amount_fc NUMBER := Fnd_Api.g_miss_num
211: ,transaction_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
212: ,functional_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
213: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
214: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
215: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
216: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
209: ,budget_amount_tc NUMBER := Fnd_Api.g_miss_num
210: ,budget_amount_fc NUMBER := Fnd_Api.g_miss_num
211: ,transaction_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
212: ,functional_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
213: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
214: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
215: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
216: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
217: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
210: ,budget_amount_fc NUMBER := Fnd_Api.g_miss_num
211: ,transaction_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
212: ,functional_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
213: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
214: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
215: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
216: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
217: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
218: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
211: ,transaction_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
212: ,functional_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
213: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
214: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
215: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
216: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
217: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
218: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
219: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
212: ,functional_currency_code VARCHAR2(15) := Fnd_Api.g_miss_char
213: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
214: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
215: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
216: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
217: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
218: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
219: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
220: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
213: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
214: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
215: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
216: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
217: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
218: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
219: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
220: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
221: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
214: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
215: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
216: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
217: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
218: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
219: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
220: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
221: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
215: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
216: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
217: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
218: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
219: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
220: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
221: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
216: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
217: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
218: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
219: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
220: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
221: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
217: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
218: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
219: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
220: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
221: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
218: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
219: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
220: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
221: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
219: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
220: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
221: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
220: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
221: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
221: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
222: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,currency_code VARCHAR2(30) := Fnd_Api.g_miss_char
222: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
223: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,currency_code VARCHAR2(30) := Fnd_Api.g_miss_char
230: ,start_date_active DATE := Fnd_Api.g_miss_date
223: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
224: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,currency_code VARCHAR2(30) := Fnd_Api.g_miss_char
230: ,start_date_active DATE := Fnd_Api.g_miss_date
231: ,end_date_active DATE := Fnd_Api.g_miss_date
224: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
225: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,currency_code VARCHAR2(30) := Fnd_Api.g_miss_char
230: ,start_date_active DATE := Fnd_Api.g_miss_date
231: ,end_date_active DATE := Fnd_Api.g_miss_date
232: ,list_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
225: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
226: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,currency_code VARCHAR2(30) := Fnd_Api.g_miss_char
230: ,start_date_active DATE := Fnd_Api.g_miss_date
231: ,end_date_active DATE := Fnd_Api.g_miss_date
232: ,list_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
233: ,discount_lines_flag VARCHAR2(1) := Fnd_Api.g_miss_char
226: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,currency_code VARCHAR2(30) := Fnd_Api.g_miss_char
230: ,start_date_active DATE := Fnd_Api.g_miss_date
231: ,end_date_active DATE := Fnd_Api.g_miss_date
232: ,list_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
233: ,discount_lines_flag VARCHAR2(1) := Fnd_Api.g_miss_char
234: ,name VARCHAR2(240) := Fnd_Api.g_miss_char
227: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
228: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,currency_code VARCHAR2(30) := Fnd_Api.g_miss_char
230: ,start_date_active DATE := Fnd_Api.g_miss_date
231: ,end_date_active DATE := Fnd_Api.g_miss_date
232: ,list_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
233: ,discount_lines_flag VARCHAR2(1) := Fnd_Api.g_miss_char
234: ,name VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,description VARCHAR2(2000) := Fnd_Api.g_miss_char
228: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
229: ,currency_code VARCHAR2(30) := Fnd_Api.g_miss_char
230: ,start_date_active DATE := Fnd_Api.g_miss_date
231: ,end_date_active DATE := Fnd_Api.g_miss_date
232: ,list_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
233: ,discount_lines_flag VARCHAR2(1) := Fnd_Api.g_miss_char
234: ,name VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,description VARCHAR2(2000) := Fnd_Api.g_miss_char
236: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
229: ,currency_code VARCHAR2(30) := Fnd_Api.g_miss_char
230: ,start_date_active DATE := Fnd_Api.g_miss_date
231: ,end_date_active DATE := Fnd_Api.g_miss_date
232: ,list_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
233: ,discount_lines_flag VARCHAR2(1) := Fnd_Api.g_miss_char
234: ,name VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,description VARCHAR2(2000) := Fnd_Api.g_miss_char
236: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
237: ,ask_for_flag VARCHAR2(1) := Fnd_Api.g_miss_char
230: ,start_date_active DATE := Fnd_Api.g_miss_date
231: ,end_date_active DATE := Fnd_Api.g_miss_date
232: ,list_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
233: ,discount_lines_flag VARCHAR2(1) := Fnd_Api.g_miss_char
234: ,name VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,description VARCHAR2(2000) := Fnd_Api.g_miss_char
236: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
237: ,ask_for_flag VARCHAR2(1) := Fnd_Api.g_miss_char
238: ,start_date_active_first DATE := Fnd_Api.g_miss_date
231: ,end_date_active DATE := Fnd_Api.g_miss_date
232: ,list_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
233: ,discount_lines_flag VARCHAR2(1) := Fnd_Api.g_miss_char
234: ,name VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,description VARCHAR2(2000) := Fnd_Api.g_miss_char
236: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
237: ,ask_for_flag VARCHAR2(1) := Fnd_Api.g_miss_char
238: ,start_date_active_first DATE := Fnd_Api.g_miss_date
239: ,end_date_active_first DATE := Fnd_Api.g_miss_date
232: ,list_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
233: ,discount_lines_flag VARCHAR2(1) := Fnd_Api.g_miss_char
234: ,name VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,description VARCHAR2(2000) := Fnd_Api.g_miss_char
236: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
237: ,ask_for_flag VARCHAR2(1) := Fnd_Api.g_miss_char
238: ,start_date_active_first DATE := Fnd_Api.g_miss_date
239: ,end_date_active_first DATE := Fnd_Api.g_miss_date
240: ,active_date_first_type VARCHAR2(30) := Fnd_Api.g_miss_char
233: ,discount_lines_flag VARCHAR2(1) := Fnd_Api.g_miss_char
234: ,name VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,description VARCHAR2(2000) := Fnd_Api.g_miss_char
236: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
237: ,ask_for_flag VARCHAR2(1) := Fnd_Api.g_miss_char
238: ,start_date_active_first DATE := Fnd_Api.g_miss_date
239: ,end_date_active_first DATE := Fnd_Api.g_miss_date
240: ,active_date_first_type VARCHAR2(30) := Fnd_Api.g_miss_char
241: ,start_date_active_second DATE := Fnd_Api.g_miss_date
234: ,name VARCHAR2(240) := Fnd_Api.g_miss_char
235: ,description VARCHAR2(2000) := Fnd_Api.g_miss_char
236: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
237: ,ask_for_flag VARCHAR2(1) := Fnd_Api.g_miss_char
238: ,start_date_active_first DATE := Fnd_Api.g_miss_date
239: ,end_date_active_first DATE := Fnd_Api.g_miss_date
240: ,active_date_first_type VARCHAR2(30) := Fnd_Api.g_miss_char
241: ,start_date_active_second DATE := Fnd_Api.g_miss_date
242: ,end_date_active_second DATE := Fnd_Api.g_miss_date
235: ,description VARCHAR2(2000) := Fnd_Api.g_miss_char
236: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
237: ,ask_for_flag VARCHAR2(1) := Fnd_Api.g_miss_char
238: ,start_date_active_first DATE := Fnd_Api.g_miss_date
239: ,end_date_active_first DATE := Fnd_Api.g_miss_date
240: ,active_date_first_type VARCHAR2(30) := Fnd_Api.g_miss_char
241: ,start_date_active_second DATE := Fnd_Api.g_miss_date
242: ,end_date_active_second DATE := Fnd_Api.g_miss_date
243: ,active_date_second_type VARCHAR2(30) := Fnd_Api.g_miss_char
236: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
237: ,ask_for_flag VARCHAR2(1) := Fnd_Api.g_miss_char
238: ,start_date_active_first DATE := Fnd_Api.g_miss_date
239: ,end_date_active_first DATE := Fnd_Api.g_miss_date
240: ,active_date_first_type VARCHAR2(30) := Fnd_Api.g_miss_char
241: ,start_date_active_second DATE := Fnd_Api.g_miss_date
242: ,end_date_active_second DATE := Fnd_Api.g_miss_date
243: ,active_date_second_type VARCHAR2(30) := Fnd_Api.g_miss_char
244: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
237: ,ask_for_flag VARCHAR2(1) := Fnd_Api.g_miss_char
238: ,start_date_active_first DATE := Fnd_Api.g_miss_date
239: ,end_date_active_first DATE := Fnd_Api.g_miss_date
240: ,active_date_first_type VARCHAR2(30) := Fnd_Api.g_miss_char
241: ,start_date_active_second DATE := Fnd_Api.g_miss_date
242: ,end_date_active_second DATE := Fnd_Api.g_miss_date
243: ,active_date_second_type VARCHAR2(30) := Fnd_Api.g_miss_char
244: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
245: ,max_no_of_uses NUMBER := Fnd_Api.g_miss_num
238: ,start_date_active_first DATE := Fnd_Api.g_miss_date
239: ,end_date_active_first DATE := Fnd_Api.g_miss_date
240: ,active_date_first_type VARCHAR2(30) := Fnd_Api.g_miss_char
241: ,start_date_active_second DATE := Fnd_Api.g_miss_date
242: ,end_date_active_second DATE := Fnd_Api.g_miss_date
243: ,active_date_second_type VARCHAR2(30) := Fnd_Api.g_miss_char
244: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
245: ,max_no_of_uses NUMBER := Fnd_Api.g_miss_num
246: ,budget_source_id NUMBER := Fnd_Api.g_miss_num
239: ,end_date_active_first DATE := Fnd_Api.g_miss_date
240: ,active_date_first_type VARCHAR2(30) := Fnd_Api.g_miss_char
241: ,start_date_active_second DATE := Fnd_Api.g_miss_date
242: ,end_date_active_second DATE := Fnd_Api.g_miss_date
243: ,active_date_second_type VARCHAR2(30) := Fnd_Api.g_miss_char
244: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
245: ,max_no_of_uses NUMBER := Fnd_Api.g_miss_num
246: ,budget_source_id NUMBER := Fnd_Api.g_miss_num
247: ,budget_source_type VARCHAR2(30) := Fnd_Api.g_miss_char
240: ,active_date_first_type VARCHAR2(30) := Fnd_Api.g_miss_char
241: ,start_date_active_second DATE := Fnd_Api.g_miss_date
242: ,end_date_active_second DATE := Fnd_Api.g_miss_date
243: ,active_date_second_type VARCHAR2(30) := Fnd_Api.g_miss_char
244: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
245: ,max_no_of_uses NUMBER := Fnd_Api.g_miss_num
246: ,budget_source_id NUMBER := Fnd_Api.g_miss_num
247: ,budget_source_type VARCHAR2(30) := Fnd_Api.g_miss_char
248: ,offer_used_by_id NUMBER := Fnd_Api.g_miss_num
241: ,start_date_active_second DATE := Fnd_Api.g_miss_date
242: ,end_date_active_second DATE := Fnd_Api.g_miss_date
243: ,active_date_second_type VARCHAR2(30) := Fnd_Api.g_miss_char
244: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
245: ,max_no_of_uses NUMBER := Fnd_Api.g_miss_num
246: ,budget_source_id NUMBER := Fnd_Api.g_miss_num
247: ,budget_source_type VARCHAR2(30) := Fnd_Api.g_miss_char
248: ,offer_used_by_id NUMBER := Fnd_Api.g_miss_num
249: ,offer_used_by VARCHAR2(30) := Fnd_Api.g_miss_char
242: ,end_date_active_second DATE := Fnd_Api.g_miss_date
243: ,active_date_second_type VARCHAR2(30) := Fnd_Api.g_miss_char
244: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
245: ,max_no_of_uses NUMBER := Fnd_Api.g_miss_num
246: ,budget_source_id NUMBER := Fnd_Api.g_miss_num
247: ,budget_source_type VARCHAR2(30) := Fnd_Api.g_miss_char
248: ,offer_used_by_id NUMBER := Fnd_Api.g_miss_num
249: ,offer_used_by VARCHAR2(30) := Fnd_Api.g_miss_char
250: ,ql_qualifier_type VARCHAR2(30) := Fnd_Api.g_miss_char
243: ,active_date_second_type VARCHAR2(30) := Fnd_Api.g_miss_char
244: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
245: ,max_no_of_uses NUMBER := Fnd_Api.g_miss_num
246: ,budget_source_id NUMBER := Fnd_Api.g_miss_num
247: ,budget_source_type VARCHAR2(30) := Fnd_Api.g_miss_char
248: ,offer_used_by_id NUMBER := Fnd_Api.g_miss_num
249: ,offer_used_by VARCHAR2(30) := Fnd_Api.g_miss_char
250: ,ql_qualifier_type VARCHAR2(30) := Fnd_Api.g_miss_char
251: ,ql_qualifier_id NUMBER := Fnd_Api.g_miss_num
244: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
245: ,max_no_of_uses NUMBER := Fnd_Api.g_miss_num
246: ,budget_source_id NUMBER := Fnd_Api.g_miss_num
247: ,budget_source_type VARCHAR2(30) := Fnd_Api.g_miss_char
248: ,offer_used_by_id NUMBER := Fnd_Api.g_miss_num
249: ,offer_used_by VARCHAR2(30) := Fnd_Api.g_miss_char
250: ,ql_qualifier_type VARCHAR2(30) := Fnd_Api.g_miss_char
251: ,ql_qualifier_id NUMBER := Fnd_Api.g_miss_num
252: ,distribution_type VARCHAR2(30) := FND_API.g_miss_char
245: ,max_no_of_uses NUMBER := Fnd_Api.g_miss_num
246: ,budget_source_id NUMBER := Fnd_Api.g_miss_num
247: ,budget_source_type VARCHAR2(30) := Fnd_Api.g_miss_char
248: ,offer_used_by_id NUMBER := Fnd_Api.g_miss_num
249: ,offer_used_by VARCHAR2(30) := Fnd_Api.g_miss_char
250: ,ql_qualifier_type VARCHAR2(30) := Fnd_Api.g_miss_char
251: ,ql_qualifier_id NUMBER := Fnd_Api.g_miss_num
252: ,distribution_type VARCHAR2(30) := FND_API.g_miss_char
253: ,amount_limit_id NUMBER := FND_API.g_miss_num
246: ,budget_source_id NUMBER := Fnd_Api.g_miss_num
247: ,budget_source_type VARCHAR2(30) := Fnd_Api.g_miss_char
248: ,offer_used_by_id NUMBER := Fnd_Api.g_miss_num
249: ,offer_used_by VARCHAR2(30) := Fnd_Api.g_miss_char
250: ,ql_qualifier_type VARCHAR2(30) := Fnd_Api.g_miss_char
251: ,ql_qualifier_id NUMBER := Fnd_Api.g_miss_num
252: ,distribution_type VARCHAR2(30) := FND_API.g_miss_char
253: ,amount_limit_id NUMBER := FND_API.g_miss_num
254: ,uses_limit_id NUMBER := FND_API.g_miss_num
247: ,budget_source_type VARCHAR2(30) := Fnd_Api.g_miss_char
248: ,offer_used_by_id NUMBER := Fnd_Api.g_miss_num
249: ,offer_used_by VARCHAR2(30) := Fnd_Api.g_miss_char
250: ,ql_qualifier_type VARCHAR2(30) := Fnd_Api.g_miss_char
251: ,ql_qualifier_id NUMBER := Fnd_Api.g_miss_num
252: ,distribution_type VARCHAR2(30) := FND_API.g_miss_char
253: ,amount_limit_id NUMBER := FND_API.g_miss_num
254: ,uses_limit_id NUMBER := FND_API.g_miss_num
255: ,offer_operation VARCHAR2(30) := FND_API.g_miss_char
248: ,offer_used_by_id NUMBER := Fnd_Api.g_miss_num
249: ,offer_used_by VARCHAR2(30) := Fnd_Api.g_miss_char
250: ,ql_qualifier_type VARCHAR2(30) := Fnd_Api.g_miss_char
251: ,ql_qualifier_id NUMBER := Fnd_Api.g_miss_num
252: ,distribution_type VARCHAR2(30) := FND_API.g_miss_char
253: ,amount_limit_id NUMBER := FND_API.g_miss_num
254: ,uses_limit_id NUMBER := FND_API.g_miss_num
255: ,offer_operation VARCHAR2(30) := FND_API.g_miss_char
256: ,modifier_operation VARCHAR2(30) := FND_API.g_miss_char
249: ,offer_used_by VARCHAR2(30) := Fnd_Api.g_miss_char
250: ,ql_qualifier_type VARCHAR2(30) := Fnd_Api.g_miss_char
251: ,ql_qualifier_id NUMBER := Fnd_Api.g_miss_num
252: ,distribution_type VARCHAR2(30) := FND_API.g_miss_char
253: ,amount_limit_id NUMBER := FND_API.g_miss_num
254: ,uses_limit_id NUMBER := FND_API.g_miss_num
255: ,offer_operation VARCHAR2(30) := FND_API.g_miss_char
256: ,modifier_operation VARCHAR2(30) := FND_API.g_miss_char
257: ,budget_offer_yn VARCHAR2(1) := FND_API.g_miss_char
250: ,ql_qualifier_type VARCHAR2(30) := Fnd_Api.g_miss_char
251: ,ql_qualifier_id NUMBER := Fnd_Api.g_miss_num
252: ,distribution_type VARCHAR2(30) := FND_API.g_miss_char
253: ,amount_limit_id NUMBER := FND_API.g_miss_num
254: ,uses_limit_id NUMBER := FND_API.g_miss_num
255: ,offer_operation VARCHAR2(30) := FND_API.g_miss_char
256: ,modifier_operation VARCHAR2(30) := FND_API.g_miss_char
257: ,budget_offer_yn VARCHAR2(1) := FND_API.g_miss_char
258: ,break_type VARCHAR2(30) := FND_API.g_miss_char
251: ,ql_qualifier_id NUMBER := Fnd_Api.g_miss_num
252: ,distribution_type VARCHAR2(30) := FND_API.g_miss_char
253: ,amount_limit_id NUMBER := FND_API.g_miss_num
254: ,uses_limit_id NUMBER := FND_API.g_miss_num
255: ,offer_operation VARCHAR2(30) := FND_API.g_miss_char
256: ,modifier_operation VARCHAR2(30) := FND_API.g_miss_char
257: ,budget_offer_yn VARCHAR2(1) := FND_API.g_miss_char
258: ,break_type VARCHAR2(30) := FND_API.g_miss_char
259: ,retroactive VARCHAR2(1) := FND_API.g_miss_char
252: ,distribution_type VARCHAR2(30) := FND_API.g_miss_char
253: ,amount_limit_id NUMBER := FND_API.g_miss_num
254: ,uses_limit_id NUMBER := FND_API.g_miss_num
255: ,offer_operation VARCHAR2(30) := FND_API.g_miss_char
256: ,modifier_operation VARCHAR2(30) := FND_API.g_miss_char
257: ,budget_offer_yn VARCHAR2(1) := FND_API.g_miss_char
258: ,break_type VARCHAR2(30) := FND_API.g_miss_char
259: ,retroactive VARCHAR2(1) := FND_API.g_miss_char
260: ,volume_offer_type VARCHAR2(30) := FND_API.g_miss_char
253: ,amount_limit_id NUMBER := FND_API.g_miss_num
254: ,uses_limit_id NUMBER := FND_API.g_miss_num
255: ,offer_operation VARCHAR2(30) := FND_API.g_miss_char
256: ,modifier_operation VARCHAR2(30) := FND_API.g_miss_char
257: ,budget_offer_yn VARCHAR2(1) := FND_API.g_miss_char
258: ,break_type VARCHAR2(30) := FND_API.g_miss_char
259: ,retroactive VARCHAR2(1) := FND_API.g_miss_char
260: ,volume_offer_type VARCHAR2(30) := FND_API.g_miss_char
261: ,confidential_flag VARCHAR2(1) := FND_API.g_miss_char
254: ,uses_limit_id NUMBER := FND_API.g_miss_num
255: ,offer_operation VARCHAR2(30) := FND_API.g_miss_char
256: ,modifier_operation VARCHAR2(30) := FND_API.g_miss_char
257: ,budget_offer_yn VARCHAR2(1) := FND_API.g_miss_char
258: ,break_type VARCHAR2(30) := FND_API.g_miss_char
259: ,retroactive VARCHAR2(1) := FND_API.g_miss_char
260: ,volume_offer_type VARCHAR2(30) := FND_API.g_miss_char
261: ,confidential_flag VARCHAR2(1) := FND_API.g_miss_char
262: ,committed_amount_eq_max VARCHAR2(1) := FND_API.g_miss_char
255: ,offer_operation VARCHAR2(30) := FND_API.g_miss_char
256: ,modifier_operation VARCHAR2(30) := FND_API.g_miss_char
257: ,budget_offer_yn VARCHAR2(1) := FND_API.g_miss_char
258: ,break_type VARCHAR2(30) := FND_API.g_miss_char
259: ,retroactive VARCHAR2(1) := FND_API.g_miss_char
260: ,volume_offer_type VARCHAR2(30) := FND_API.g_miss_char
261: ,confidential_flag VARCHAR2(1) := FND_API.g_miss_char
262: ,committed_amount_eq_max VARCHAR2(1) := FND_API.g_miss_char
263: ,source_from_parent VARCHAR2(1) := FND_API.g_miss_char
256: ,modifier_operation VARCHAR2(30) := FND_API.g_miss_char
257: ,budget_offer_yn VARCHAR2(1) := FND_API.g_miss_char
258: ,break_type VARCHAR2(30) := FND_API.g_miss_char
259: ,retroactive VARCHAR2(1) := FND_API.g_miss_char
260: ,volume_offer_type VARCHAR2(30) := FND_API.g_miss_char
261: ,confidential_flag VARCHAR2(1) := FND_API.g_miss_char
262: ,committed_amount_eq_max VARCHAR2(1) := FND_API.g_miss_char
263: ,source_from_parent VARCHAR2(1) := FND_API.g_miss_char
264: ,buyer_name VARCHAR2(240) := FND_API.g_miss_char
257: ,budget_offer_yn VARCHAR2(1) := FND_API.g_miss_char
258: ,break_type VARCHAR2(30) := FND_API.g_miss_char
259: ,retroactive VARCHAR2(1) := FND_API.g_miss_char
260: ,volume_offer_type VARCHAR2(30) := FND_API.g_miss_char
261: ,confidential_flag VARCHAR2(1) := FND_API.g_miss_char
262: ,committed_amount_eq_max VARCHAR2(1) := FND_API.g_miss_char
263: ,source_from_parent VARCHAR2(1) := FND_API.g_miss_char
264: ,buyer_name VARCHAR2(240) := FND_API.g_miss_char
265: ,tier_level VARCHAR2(30) := FND_API.g_miss_char
258: ,break_type VARCHAR2(30) := FND_API.g_miss_char
259: ,retroactive VARCHAR2(1) := FND_API.g_miss_char
260: ,volume_offer_type VARCHAR2(30) := FND_API.g_miss_char
261: ,confidential_flag VARCHAR2(1) := FND_API.g_miss_char
262: ,committed_amount_eq_max VARCHAR2(1) := FND_API.g_miss_char
263: ,source_from_parent VARCHAR2(1) := FND_API.g_miss_char
264: ,buyer_name VARCHAR2(240) := FND_API.g_miss_char
265: ,tier_level VARCHAR2(30) := FND_API.g_miss_char
266: ,na_rule_header_id NUMBER := FND_API.g_miss_num
259: ,retroactive VARCHAR2(1) := FND_API.g_miss_char
260: ,volume_offer_type VARCHAR2(30) := FND_API.g_miss_char
261: ,confidential_flag VARCHAR2(1) := FND_API.g_miss_char
262: ,committed_amount_eq_max VARCHAR2(1) := FND_API.g_miss_char
263: ,source_from_parent VARCHAR2(1) := FND_API.g_miss_char
264: ,buyer_name VARCHAR2(240) := FND_API.g_miss_char
265: ,tier_level VARCHAR2(30) := FND_API.g_miss_char
266: ,na_rule_header_id NUMBER := FND_API.g_miss_num
267: ,sales_method_flag VARCHAR2(1) := FND_API.g_miss_char
260: ,volume_offer_type VARCHAR2(30) := FND_API.g_miss_char
261: ,confidential_flag VARCHAR2(1) := FND_API.g_miss_char
262: ,committed_amount_eq_max VARCHAR2(1) := FND_API.g_miss_char
263: ,source_from_parent VARCHAR2(1) := FND_API.g_miss_char
264: ,buyer_name VARCHAR2(240) := FND_API.g_miss_char
265: ,tier_level VARCHAR2(30) := FND_API.g_miss_char
266: ,na_rule_header_id NUMBER := FND_API.g_miss_num
267: ,sales_method_flag VARCHAR2(1) := FND_API.g_miss_char
268: ,global_flag VARCHAR2(1) := FND_API.g_miss_char
261: ,confidential_flag VARCHAR2(1) := FND_API.g_miss_char
262: ,committed_amount_eq_max VARCHAR2(1) := FND_API.g_miss_char
263: ,source_from_parent VARCHAR2(1) := FND_API.g_miss_char
264: ,buyer_name VARCHAR2(240) := FND_API.g_miss_char
265: ,tier_level VARCHAR2(30) := FND_API.g_miss_char
266: ,na_rule_header_id NUMBER := FND_API.g_miss_num
267: ,sales_method_flag VARCHAR2(1) := FND_API.g_miss_char
268: ,global_flag VARCHAR2(1) := FND_API.g_miss_char
269: ,orig_org_id NUMBER := FND_API.g_miss_num
262: ,committed_amount_eq_max VARCHAR2(1) := FND_API.g_miss_char
263: ,source_from_parent VARCHAR2(1) := FND_API.g_miss_char
264: ,buyer_name VARCHAR2(240) := FND_API.g_miss_char
265: ,tier_level VARCHAR2(30) := FND_API.g_miss_char
266: ,na_rule_header_id NUMBER := FND_API.g_miss_num
267: ,sales_method_flag VARCHAR2(1) := FND_API.g_miss_char
268: ,global_flag VARCHAR2(1) := FND_API.g_miss_char
269: ,orig_org_id NUMBER := FND_API.g_miss_num
270: );
263: ,source_from_parent VARCHAR2(1) := FND_API.g_miss_char
264: ,buyer_name VARCHAR2(240) := FND_API.g_miss_char
265: ,tier_level VARCHAR2(30) := FND_API.g_miss_char
266: ,na_rule_header_id NUMBER := FND_API.g_miss_num
267: ,sales_method_flag VARCHAR2(1) := FND_API.g_miss_char
268: ,global_flag VARCHAR2(1) := FND_API.g_miss_char
269: ,orig_org_id NUMBER := FND_API.g_miss_num
270: );
271:
264: ,buyer_name VARCHAR2(240) := FND_API.g_miss_char
265: ,tier_level VARCHAR2(30) := FND_API.g_miss_char
266: ,na_rule_header_id NUMBER := FND_API.g_miss_num
267: ,sales_method_flag VARCHAR2(1) := FND_API.g_miss_char
268: ,global_flag VARCHAR2(1) := FND_API.g_miss_char
269: ,orig_org_id NUMBER := FND_API.g_miss_num
270: );
271:
272: TYPE Modifier_Line_Rec_Type IS RECORD
265: ,tier_level VARCHAR2(30) := FND_API.g_miss_char
266: ,na_rule_header_id NUMBER := FND_API.g_miss_num
267: ,sales_method_flag VARCHAR2(1) := FND_API.g_miss_char
268: ,global_flag VARCHAR2(1) := FND_API.g_miss_char
269: ,orig_org_id NUMBER := FND_API.g_miss_num
270: );
271:
272: TYPE Modifier_Line_Rec_Type IS RECORD
273: (
270: );
271:
272: TYPE Modifier_Line_Rec_Type IS RECORD
273: (
274: offer_line_type VARCHAR2(30) := Fnd_Api.g_miss_char
275: ,operation VARCHAR2(30) := FND_API.g_miss_char
276: ,list_line_id NUMBER := Fnd_Api.g_miss_num
277: ,list_header_id NUMBER := Fnd_Api.g_miss_num
278: ,list_line_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
271:
272: TYPE Modifier_Line_Rec_Type IS RECORD
273: (
274: offer_line_type VARCHAR2(30) := Fnd_Api.g_miss_char
275: ,operation VARCHAR2(30) := FND_API.g_miss_char
276: ,list_line_id NUMBER := Fnd_Api.g_miss_num
277: ,list_header_id NUMBER := Fnd_Api.g_miss_num
278: ,list_line_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
279: ,operand NUMBER := Fnd_Api.g_miss_num
272: TYPE Modifier_Line_Rec_Type IS RECORD
273: (
274: offer_line_type VARCHAR2(30) := Fnd_Api.g_miss_char
275: ,operation VARCHAR2(30) := FND_API.g_miss_char
276: ,list_line_id NUMBER := Fnd_Api.g_miss_num
277: ,list_header_id NUMBER := Fnd_Api.g_miss_num
278: ,list_line_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
279: ,operand NUMBER := Fnd_Api.g_miss_num
280: ,start_date_active DATE := FND_API.g_miss_date
273: (
274: offer_line_type VARCHAR2(30) := Fnd_Api.g_miss_char
275: ,operation VARCHAR2(30) := FND_API.g_miss_char
276: ,list_line_id NUMBER := Fnd_Api.g_miss_num
277: ,list_header_id NUMBER := Fnd_Api.g_miss_num
278: ,list_line_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
279: ,operand NUMBER := Fnd_Api.g_miss_num
280: ,start_date_active DATE := FND_API.g_miss_date
281: ,end_date_active DATE := FND_API.g_miss_date
274: offer_line_type VARCHAR2(30) := Fnd_Api.g_miss_char
275: ,operation VARCHAR2(30) := FND_API.g_miss_char
276: ,list_line_id NUMBER := Fnd_Api.g_miss_num
277: ,list_header_id NUMBER := Fnd_Api.g_miss_num
278: ,list_line_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
279: ,operand NUMBER := Fnd_Api.g_miss_num
280: ,start_date_active DATE := FND_API.g_miss_date
281: ,end_date_active DATE := FND_API.g_miss_date
282: ,arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
275: ,operation VARCHAR2(30) := FND_API.g_miss_char
276: ,list_line_id NUMBER := Fnd_Api.g_miss_num
277: ,list_header_id NUMBER := Fnd_Api.g_miss_num
278: ,list_line_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
279: ,operand NUMBER := Fnd_Api.g_miss_num
280: ,start_date_active DATE := FND_API.g_miss_date
281: ,end_date_active DATE := FND_API.g_miss_date
282: ,arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
283: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
276: ,list_line_id NUMBER := Fnd_Api.g_miss_num
277: ,list_header_id NUMBER := Fnd_Api.g_miss_num
278: ,list_line_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
279: ,operand NUMBER := Fnd_Api.g_miss_num
280: ,start_date_active DATE := FND_API.g_miss_date
281: ,end_date_active DATE := FND_API.g_miss_date
282: ,arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
283: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
284: ,qd_operand NUMBER := Fnd_Api.g_miss_num
277: ,list_header_id NUMBER := Fnd_Api.g_miss_num
278: ,list_line_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
279: ,operand NUMBER := Fnd_Api.g_miss_num
280: ,start_date_active DATE := FND_API.g_miss_date
281: ,end_date_active DATE := FND_API.g_miss_date
282: ,arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
283: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
284: ,qd_operand NUMBER := Fnd_Api.g_miss_num
285: ,qd_arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
278: ,list_line_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
279: ,operand NUMBER := Fnd_Api.g_miss_num
280: ,start_date_active DATE := FND_API.g_miss_date
281: ,end_date_active DATE := FND_API.g_miss_date
282: ,arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
283: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
284: ,qd_operand NUMBER := Fnd_Api.g_miss_num
285: ,qd_arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
286: ,qd_related_deal_lines_id NUMBER := Fnd_Api.g_miss_num
279: ,operand NUMBER := Fnd_Api.g_miss_num
280: ,start_date_active DATE := FND_API.g_miss_date
281: ,end_date_active DATE := FND_API.g_miss_date
282: ,arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
283: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
284: ,qd_operand NUMBER := Fnd_Api.g_miss_num
285: ,qd_arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
286: ,qd_related_deal_lines_id NUMBER := Fnd_Api.g_miss_num
287: ,qd_object_version_number NUMBER := Fnd_Api.g_miss_num
280: ,start_date_active DATE := FND_API.g_miss_date
281: ,end_date_active DATE := FND_API.g_miss_date
282: ,arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
283: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
284: ,qd_operand NUMBER := Fnd_Api.g_miss_num
285: ,qd_arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
286: ,qd_related_deal_lines_id NUMBER := Fnd_Api.g_miss_num
287: ,qd_object_version_number NUMBER := Fnd_Api.g_miss_num
288: ,qd_estimated_qty_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
281: ,end_date_active DATE := FND_API.g_miss_date
282: ,arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
283: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
284: ,qd_operand NUMBER := Fnd_Api.g_miss_num
285: ,qd_arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
286: ,qd_related_deal_lines_id NUMBER := Fnd_Api.g_miss_num
287: ,qd_object_version_number NUMBER := Fnd_Api.g_miss_num
288: ,qd_estimated_qty_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
289: ,qd_list_line_id NUMBER := Fnd_Api.g_miss_num
282: ,arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
283: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
284: ,qd_operand NUMBER := Fnd_Api.g_miss_num
285: ,qd_arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
286: ,qd_related_deal_lines_id NUMBER := Fnd_Api.g_miss_num
287: ,qd_object_version_number NUMBER := Fnd_Api.g_miss_num
288: ,qd_estimated_qty_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
289: ,qd_list_line_id NUMBER := Fnd_Api.g_miss_num
290: ,qd_estimated_amount_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
283: ,active_flag VARCHAR2(1) := Fnd_Api.g_miss_char
284: ,qd_operand NUMBER := Fnd_Api.g_miss_num
285: ,qd_arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
286: ,qd_related_deal_lines_id NUMBER := Fnd_Api.g_miss_num
287: ,qd_object_version_number NUMBER := Fnd_Api.g_miss_num
288: ,qd_estimated_qty_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
289: ,qd_list_line_id NUMBER := Fnd_Api.g_miss_num
290: ,qd_estimated_amount_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
291: ,estim_gl_value NUMBER := Fnd_Api.g_miss_num
284: ,qd_operand NUMBER := Fnd_Api.g_miss_num
285: ,qd_arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
286: ,qd_related_deal_lines_id NUMBER := Fnd_Api.g_miss_num
287: ,qd_object_version_number NUMBER := Fnd_Api.g_miss_num
288: ,qd_estimated_qty_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
289: ,qd_list_line_id NUMBER := Fnd_Api.g_miss_num
290: ,qd_estimated_amount_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
291: ,estim_gl_value NUMBER := Fnd_Api.g_miss_num
292: ,benefit_price_list_line_id NUMBER := Fnd_Api.g_miss_num
285: ,qd_arithmetic_operator VARCHAR2(30) := Fnd_Api.g_miss_char
286: ,qd_related_deal_lines_id NUMBER := Fnd_Api.g_miss_num
287: ,qd_object_version_number NUMBER := Fnd_Api.g_miss_num
288: ,qd_estimated_qty_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
289: ,qd_list_line_id NUMBER := Fnd_Api.g_miss_num
290: ,qd_estimated_amount_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
291: ,estim_gl_value NUMBER := Fnd_Api.g_miss_num
292: ,benefit_price_list_line_id NUMBER := Fnd_Api.g_miss_num
293: ,benefit_limit NUMBER := Fnd_Api.g_miss_num
286: ,qd_related_deal_lines_id NUMBER := Fnd_Api.g_miss_num
287: ,qd_object_version_number NUMBER := Fnd_Api.g_miss_num
288: ,qd_estimated_qty_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
289: ,qd_list_line_id NUMBER := Fnd_Api.g_miss_num
290: ,qd_estimated_amount_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
291: ,estim_gl_value NUMBER := Fnd_Api.g_miss_num
292: ,benefit_price_list_line_id NUMBER := Fnd_Api.g_miss_num
293: ,benefit_limit NUMBER := Fnd_Api.g_miss_num
294: ,benefit_qty NUMBER := Fnd_Api.g_miss_num
287: ,qd_object_version_number NUMBER := Fnd_Api.g_miss_num
288: ,qd_estimated_qty_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
289: ,qd_list_line_id NUMBER := Fnd_Api.g_miss_num
290: ,qd_estimated_amount_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
291: ,estim_gl_value NUMBER := Fnd_Api.g_miss_num
292: ,benefit_price_list_line_id NUMBER := Fnd_Api.g_miss_num
293: ,benefit_limit NUMBER := Fnd_Api.g_miss_num
294: ,benefit_qty NUMBER := Fnd_Api.g_miss_num
295: ,benefit_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
288: ,qd_estimated_qty_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
289: ,qd_list_line_id NUMBER := Fnd_Api.g_miss_num
290: ,qd_estimated_amount_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
291: ,estim_gl_value NUMBER := Fnd_Api.g_miss_num
292: ,benefit_price_list_line_id NUMBER := Fnd_Api.g_miss_num
293: ,benefit_limit NUMBER := Fnd_Api.g_miss_num
294: ,benefit_qty NUMBER := Fnd_Api.g_miss_num
295: ,benefit_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
296: ,substitution_context VARCHAR2(30) := Fnd_Api.g_miss_char
289: ,qd_list_line_id NUMBER := Fnd_Api.g_miss_num
290: ,qd_estimated_amount_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
291: ,estim_gl_value NUMBER := Fnd_Api.g_miss_num
292: ,benefit_price_list_line_id NUMBER := Fnd_Api.g_miss_num
293: ,benefit_limit NUMBER := Fnd_Api.g_miss_num
294: ,benefit_qty NUMBER := Fnd_Api.g_miss_num
295: ,benefit_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
296: ,substitution_context VARCHAR2(30) := Fnd_Api.g_miss_char
297: ,substitution_attr VARCHAR2(30) := Fnd_Api.g_miss_char
290: ,qd_estimated_amount_is_max VARCHAR2(1) := Fnd_Api.g_miss_char
291: ,estim_gl_value NUMBER := Fnd_Api.g_miss_num
292: ,benefit_price_list_line_id NUMBER := Fnd_Api.g_miss_num
293: ,benefit_limit NUMBER := Fnd_Api.g_miss_num
294: ,benefit_qty NUMBER := Fnd_Api.g_miss_num
295: ,benefit_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
296: ,substitution_context VARCHAR2(30) := Fnd_Api.g_miss_char
297: ,substitution_attr VARCHAR2(30) := Fnd_Api.g_miss_char
298: ,substitution_val VARCHAR2(240) := Fnd_Api.g_miss_char
291: ,estim_gl_value NUMBER := Fnd_Api.g_miss_num
292: ,benefit_price_list_line_id NUMBER := Fnd_Api.g_miss_num
293: ,benefit_limit NUMBER := Fnd_Api.g_miss_num
294: ,benefit_qty NUMBER := Fnd_Api.g_miss_num
295: ,benefit_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
296: ,substitution_context VARCHAR2(30) := Fnd_Api.g_miss_char
297: ,substitution_attr VARCHAR2(30) := Fnd_Api.g_miss_char
298: ,substitution_val VARCHAR2(240) := Fnd_Api.g_miss_char
299: ,price_break_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
292: ,benefit_price_list_line_id NUMBER := Fnd_Api.g_miss_num
293: ,benefit_limit NUMBER := Fnd_Api.g_miss_num
294: ,benefit_qty NUMBER := Fnd_Api.g_miss_num
295: ,benefit_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
296: ,substitution_context VARCHAR2(30) := Fnd_Api.g_miss_char
297: ,substitution_attr VARCHAR2(30) := Fnd_Api.g_miss_char
298: ,substitution_val VARCHAR2(240) := Fnd_Api.g_miss_char
299: ,price_break_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
300: ,pricing_attribute_id NUMBER := Fnd_Api.g_miss_num
293: ,benefit_limit NUMBER := Fnd_Api.g_miss_num
294: ,benefit_qty NUMBER := Fnd_Api.g_miss_num
295: ,benefit_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
296: ,substitution_context VARCHAR2(30) := Fnd_Api.g_miss_char
297: ,substitution_attr VARCHAR2(30) := Fnd_Api.g_miss_char
298: ,substitution_val VARCHAR2(240) := Fnd_Api.g_miss_char
299: ,price_break_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
300: ,pricing_attribute_id NUMBER := Fnd_Api.g_miss_num
301: ,product_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
294: ,benefit_qty NUMBER := Fnd_Api.g_miss_num
295: ,benefit_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
296: ,substitution_context VARCHAR2(30) := Fnd_Api.g_miss_char
297: ,substitution_attr VARCHAR2(30) := Fnd_Api.g_miss_char
298: ,substitution_val VARCHAR2(240) := Fnd_Api.g_miss_char
299: ,price_break_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
300: ,pricing_attribute_id NUMBER := Fnd_Api.g_miss_num
301: ,product_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
302: ,product_attr VARCHAR2(30) := Fnd_Api.g_miss_char
295: ,benefit_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
296: ,substitution_context VARCHAR2(30) := Fnd_Api.g_miss_char
297: ,substitution_attr VARCHAR2(30) := Fnd_Api.g_miss_char
298: ,substitution_val VARCHAR2(240) := Fnd_Api.g_miss_char
299: ,price_break_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
300: ,pricing_attribute_id NUMBER := Fnd_Api.g_miss_num
301: ,product_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
302: ,product_attr VARCHAR2(30) := Fnd_Api.g_miss_char
303: ,product_attr_val VARCHAR2(240) := Fnd_Api.g_miss_char
296: ,substitution_context VARCHAR2(30) := Fnd_Api.g_miss_char
297: ,substitution_attr VARCHAR2(30) := Fnd_Api.g_miss_char
298: ,substitution_val VARCHAR2(240) := Fnd_Api.g_miss_char
299: ,price_break_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
300: ,pricing_attribute_id NUMBER := Fnd_Api.g_miss_num
301: ,product_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
302: ,product_attr VARCHAR2(30) := Fnd_Api.g_miss_char
303: ,product_attr_val VARCHAR2(240) := Fnd_Api.g_miss_char
304: ,product_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
297: ,substitution_attr VARCHAR2(30) := Fnd_Api.g_miss_char
298: ,substitution_val VARCHAR2(240) := Fnd_Api.g_miss_char
299: ,price_break_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
300: ,pricing_attribute_id NUMBER := Fnd_Api.g_miss_num
301: ,product_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
302: ,product_attr VARCHAR2(30) := Fnd_Api.g_miss_char
303: ,product_attr_val VARCHAR2(240) := Fnd_Api.g_miss_char
304: ,product_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
305: ,pricing_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
298: ,substitution_val VARCHAR2(240) := Fnd_Api.g_miss_char
299: ,price_break_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
300: ,pricing_attribute_id NUMBER := Fnd_Api.g_miss_num
301: ,product_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
302: ,product_attr VARCHAR2(30) := Fnd_Api.g_miss_char
303: ,product_attr_val VARCHAR2(240) := Fnd_Api.g_miss_char
304: ,product_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
305: ,pricing_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
306: ,pricing_attr VARCHAR2(30) := Fnd_Api.g_miss_char
299: ,price_break_type_code VARCHAR2(30) := Fnd_Api.g_miss_char
300: ,pricing_attribute_id NUMBER := Fnd_Api.g_miss_num
301: ,product_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
302: ,product_attr VARCHAR2(30) := Fnd_Api.g_miss_char
303: ,product_attr_val VARCHAR2(240) := Fnd_Api.g_miss_char
304: ,product_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
305: ,pricing_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
306: ,pricing_attr VARCHAR2(30) := Fnd_Api.g_miss_char
307: ,pricing_attr_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
300: ,pricing_attribute_id NUMBER := Fnd_Api.g_miss_num
301: ,product_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
302: ,product_attr VARCHAR2(30) := Fnd_Api.g_miss_char
303: ,product_attr_val VARCHAR2(240) := Fnd_Api.g_miss_char
304: ,product_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
305: ,pricing_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
306: ,pricing_attr VARCHAR2(30) := Fnd_Api.g_miss_char
307: ,pricing_attr_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
308: ,pricing_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
301: ,product_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
302: ,product_attr VARCHAR2(30) := Fnd_Api.g_miss_char
303: ,product_attr_val VARCHAR2(240) := Fnd_Api.g_miss_char
304: ,product_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
305: ,pricing_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
306: ,pricing_attr VARCHAR2(30) := Fnd_Api.g_miss_char
307: ,pricing_attr_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
308: ,pricing_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
309: ,excluder_flag VARCHAR2(1) := Fnd_Api.g_miss_char
302: ,product_attr VARCHAR2(30) := Fnd_Api.g_miss_char
303: ,product_attr_val VARCHAR2(240) := Fnd_Api.g_miss_char
304: ,product_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
305: ,pricing_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
306: ,pricing_attr VARCHAR2(30) := Fnd_Api.g_miss_char
307: ,pricing_attr_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
308: ,pricing_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
309: ,excluder_flag VARCHAR2(1) := Fnd_Api.g_miss_char
310: ,order_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
303: ,product_attr_val VARCHAR2(240) := Fnd_Api.g_miss_char
304: ,product_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
305: ,pricing_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
306: ,pricing_attr VARCHAR2(30) := Fnd_Api.g_miss_char
307: ,pricing_attr_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
308: ,pricing_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
309: ,excluder_flag VARCHAR2(1) := Fnd_Api.g_miss_char
310: ,order_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
311: ,order_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
304: ,product_uom_code VARCHAR2(3) := Fnd_Api.g_miss_char
305: ,pricing_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
306: ,pricing_attr VARCHAR2(30) := Fnd_Api.g_miss_char
307: ,pricing_attr_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
308: ,pricing_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
309: ,excluder_flag VARCHAR2(1) := Fnd_Api.g_miss_char
310: ,order_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
311: ,order_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
312: ,qualifier_id NUMBER := FND_API.g_miss_num
305: ,pricing_attribute_context VARCHAR2(30) := Fnd_Api.g_miss_char
306: ,pricing_attr VARCHAR2(30) := Fnd_Api.g_miss_char
307: ,pricing_attr_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
308: ,pricing_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
309: ,excluder_flag VARCHAR2(1) := Fnd_Api.g_miss_char
310: ,order_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
311: ,order_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
312: ,qualifier_id NUMBER := FND_API.g_miss_num
313: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
306: ,pricing_attr VARCHAR2(30) := Fnd_Api.g_miss_char
307: ,pricing_attr_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
308: ,pricing_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
309: ,excluder_flag VARCHAR2(1) := Fnd_Api.g_miss_char
310: ,order_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
311: ,order_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
312: ,qualifier_id NUMBER := FND_API.g_miss_num
313: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
314: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
307: ,pricing_attr_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
308: ,pricing_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
309: ,excluder_flag VARCHAR2(1) := Fnd_Api.g_miss_char
310: ,order_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
311: ,order_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
312: ,qualifier_id NUMBER := FND_API.g_miss_num
313: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
314: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
315: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
308: ,pricing_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
309: ,excluder_flag VARCHAR2(1) := Fnd_Api.g_miss_char
310: ,order_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
311: ,order_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
312: ,qualifier_id NUMBER := FND_API.g_miss_num
313: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
314: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
315: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
316: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
309: ,excluder_flag VARCHAR2(1) := Fnd_Api.g_miss_char
310: ,order_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
311: ,order_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
312: ,qualifier_id NUMBER := FND_API.g_miss_num
313: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
314: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
315: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
316: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
317: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
310: ,order_value_from VARCHAR2(240) := Fnd_Api.g_miss_char
311: ,order_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
312: ,qualifier_id NUMBER := FND_API.g_miss_num
313: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
314: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
315: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
316: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
317: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
318: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
311: ,order_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
312: ,qualifier_id NUMBER := FND_API.g_miss_num
313: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
314: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
315: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
316: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
317: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
318: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
319: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
312: ,qualifier_id NUMBER := FND_API.g_miss_num
313: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
314: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
315: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
316: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
317: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
318: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
319: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
320: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
313: ,comments VARCHAR2(2000) := Fnd_Api.g_miss_char
314: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
315: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
316: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
317: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
318: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
319: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
320: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
321: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
314: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
315: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
316: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
317: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
318: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
319: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
320: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
321: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
322: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
315: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
316: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
317: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
318: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
319: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
320: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
321: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
322: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
323: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
316: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
317: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
318: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
319: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
320: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
321: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
322: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
323: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
324: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
317: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
318: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
319: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
320: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
321: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
322: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
323: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
324: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
325: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
318: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
319: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
320: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
321: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
322: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
323: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
324: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
325: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
326: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
319: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
320: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
321: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
322: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
323: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
324: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
325: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
326: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
327: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
320: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
321: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
322: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
323: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
324: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
325: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
326: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
327: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
328: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
321: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
322: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
323: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
324: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
325: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
326: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
327: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
328: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
329: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
322: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
323: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
324: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
325: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
326: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
327: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
328: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
329: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
330: ,max_qty_per_order NUMBER := Fnd_Api.g_miss_num
323: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
324: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
325: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
326: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
327: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
328: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
329: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
330: ,max_qty_per_order NUMBER := Fnd_Api.g_miss_num
331: ,max_qty_per_order_id NUMBER := Fnd_Api.g_miss_num
324: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
325: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
326: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
327: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
328: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
329: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
330: ,max_qty_per_order NUMBER := Fnd_Api.g_miss_num
331: ,max_qty_per_order_id NUMBER := Fnd_Api.g_miss_num
332: ,max_qty_per_customer NUMBER := Fnd_Api.g_miss_num
325: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
326: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
327: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
328: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
329: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
330: ,max_qty_per_order NUMBER := Fnd_Api.g_miss_num
331: ,max_qty_per_order_id NUMBER := Fnd_Api.g_miss_num
332: ,max_qty_per_customer NUMBER := Fnd_Api.g_miss_num
333: ,max_qty_per_customer_id NUMBER := Fnd_Api.g_miss_num
326: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
327: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
328: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
329: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
330: ,max_qty_per_order NUMBER := Fnd_Api.g_miss_num
331: ,max_qty_per_order_id NUMBER := Fnd_Api.g_miss_num
332: ,max_qty_per_customer NUMBER := Fnd_Api.g_miss_num
333: ,max_qty_per_customer_id NUMBER := Fnd_Api.g_miss_num
334: ,max_qty_per_rule NUMBER := Fnd_Api.g_miss_num
327: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
328: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
329: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
330: ,max_qty_per_order NUMBER := Fnd_Api.g_miss_num
331: ,max_qty_per_order_id NUMBER := Fnd_Api.g_miss_num
332: ,max_qty_per_customer NUMBER := Fnd_Api.g_miss_num
333: ,max_qty_per_customer_id NUMBER := Fnd_Api.g_miss_num
334: ,max_qty_per_rule NUMBER := Fnd_Api.g_miss_num
335: ,max_qty_per_rule_id NUMBER := Fnd_Api.g_miss_num
328: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
329: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
330: ,max_qty_per_order NUMBER := Fnd_Api.g_miss_num
331: ,max_qty_per_order_id NUMBER := Fnd_Api.g_miss_num
332: ,max_qty_per_customer NUMBER := Fnd_Api.g_miss_num
333: ,max_qty_per_customer_id NUMBER := Fnd_Api.g_miss_num
334: ,max_qty_per_rule NUMBER := Fnd_Api.g_miss_num
335: ,max_qty_per_rule_id NUMBER := Fnd_Api.g_miss_num
336: ,max_orders_per_customer NUMBER := Fnd_Api.g_miss_num
329: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
330: ,max_qty_per_order NUMBER := Fnd_Api.g_miss_num
331: ,max_qty_per_order_id NUMBER := Fnd_Api.g_miss_num
332: ,max_qty_per_customer NUMBER := Fnd_Api.g_miss_num
333: ,max_qty_per_customer_id NUMBER := Fnd_Api.g_miss_num
334: ,max_qty_per_rule NUMBER := Fnd_Api.g_miss_num
335: ,max_qty_per_rule_id NUMBER := Fnd_Api.g_miss_num
336: ,max_orders_per_customer NUMBER := Fnd_Api.g_miss_num
337: ,max_orders_per_customer_id NUMBER := Fnd_Api.g_miss_num
330: ,max_qty_per_order NUMBER := Fnd_Api.g_miss_num
331: ,max_qty_per_order_id NUMBER := Fnd_Api.g_miss_num
332: ,max_qty_per_customer NUMBER := Fnd_Api.g_miss_num
333: ,max_qty_per_customer_id NUMBER := Fnd_Api.g_miss_num
334: ,max_qty_per_rule NUMBER := Fnd_Api.g_miss_num
335: ,max_qty_per_rule_id NUMBER := Fnd_Api.g_miss_num
336: ,max_orders_per_customer NUMBER := Fnd_Api.g_miss_num
337: ,max_orders_per_customer_id NUMBER := Fnd_Api.g_miss_num
338: ,max_amount_per_rule NUMBER := Fnd_Api.g_miss_num
331: ,max_qty_per_order_id NUMBER := Fnd_Api.g_miss_num
332: ,max_qty_per_customer NUMBER := Fnd_Api.g_miss_num
333: ,max_qty_per_customer_id NUMBER := Fnd_Api.g_miss_num
334: ,max_qty_per_rule NUMBER := Fnd_Api.g_miss_num
335: ,max_qty_per_rule_id NUMBER := Fnd_Api.g_miss_num
336: ,max_orders_per_customer NUMBER := Fnd_Api.g_miss_num
337: ,max_orders_per_customer_id NUMBER := Fnd_Api.g_miss_num
338: ,max_amount_per_rule NUMBER := Fnd_Api.g_miss_num
339: ,max_amount_per_rule_id NUMBER := Fnd_Api.g_miss_num
332: ,max_qty_per_customer NUMBER := Fnd_Api.g_miss_num
333: ,max_qty_per_customer_id NUMBER := Fnd_Api.g_miss_num
334: ,max_qty_per_rule NUMBER := Fnd_Api.g_miss_num
335: ,max_qty_per_rule_id NUMBER := Fnd_Api.g_miss_num
336: ,max_orders_per_customer NUMBER := Fnd_Api.g_miss_num
337: ,max_orders_per_customer_id NUMBER := Fnd_Api.g_miss_num
338: ,max_amount_per_rule NUMBER := Fnd_Api.g_miss_num
339: ,max_amount_per_rule_id NUMBER := Fnd_Api.g_miss_num
340: ,estimate_qty_uom VARCHAR2(3) := Fnd_Api.g_miss_char
333: ,max_qty_per_customer_id NUMBER := Fnd_Api.g_miss_num
334: ,max_qty_per_rule NUMBER := Fnd_Api.g_miss_num
335: ,max_qty_per_rule_id NUMBER := Fnd_Api.g_miss_num
336: ,max_orders_per_customer NUMBER := Fnd_Api.g_miss_num
337: ,max_orders_per_customer_id NUMBER := Fnd_Api.g_miss_num
338: ,max_amount_per_rule NUMBER := Fnd_Api.g_miss_num
339: ,max_amount_per_rule_id NUMBER := Fnd_Api.g_miss_num
340: ,estimate_qty_uom VARCHAR2(3) := Fnd_Api.g_miss_char
341: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
334: ,max_qty_per_rule NUMBER := Fnd_Api.g_miss_num
335: ,max_qty_per_rule_id NUMBER := Fnd_Api.g_miss_num
336: ,max_orders_per_customer NUMBER := Fnd_Api.g_miss_num
337: ,max_orders_per_customer_id NUMBER := Fnd_Api.g_miss_num
338: ,max_amount_per_rule NUMBER := Fnd_Api.g_miss_num
339: ,max_amount_per_rule_id NUMBER := Fnd_Api.g_miss_num
340: ,estimate_qty_uom VARCHAR2(3) := Fnd_Api.g_miss_char
341: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
342: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
335: ,max_qty_per_rule_id NUMBER := Fnd_Api.g_miss_num
336: ,max_orders_per_customer NUMBER := Fnd_Api.g_miss_num
337: ,max_orders_per_customer_id NUMBER := Fnd_Api.g_miss_num
338: ,max_amount_per_rule NUMBER := Fnd_Api.g_miss_num
339: ,max_amount_per_rule_id NUMBER := Fnd_Api.g_miss_num
340: ,estimate_qty_uom VARCHAR2(3) := Fnd_Api.g_miss_char
341: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
342: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
343: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
336: ,max_orders_per_customer NUMBER := Fnd_Api.g_miss_num
337: ,max_orders_per_customer_id NUMBER := Fnd_Api.g_miss_num
338: ,max_amount_per_rule NUMBER := Fnd_Api.g_miss_num
339: ,max_amount_per_rule_id NUMBER := Fnd_Api.g_miss_num
340: ,estimate_qty_uom VARCHAR2(3) := Fnd_Api.g_miss_char
341: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
342: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
343: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
344: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
337: ,max_orders_per_customer_id NUMBER := Fnd_Api.g_miss_num
338: ,max_amount_per_rule NUMBER := Fnd_Api.g_miss_num
339: ,max_amount_per_rule_id NUMBER := Fnd_Api.g_miss_num
340: ,estimate_qty_uom VARCHAR2(3) := Fnd_Api.g_miss_char
341: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
342: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
343: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
344: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
345: ,list_line_no VARCHAR2(30) := Fnd_Api.g_miss_char
338: ,max_amount_per_rule NUMBER := Fnd_Api.g_miss_num
339: ,max_amount_per_rule_id NUMBER := Fnd_Api.g_miss_num
340: ,estimate_qty_uom VARCHAR2(3) := Fnd_Api.g_miss_char
341: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
342: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
343: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
344: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
345: ,list_line_no VARCHAR2(30) := Fnd_Api.g_miss_char
346: );
339: ,max_amount_per_rule_id NUMBER := Fnd_Api.g_miss_num
340: ,estimate_qty_uom VARCHAR2(3) := Fnd_Api.g_miss_char
341: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
342: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
343: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
344: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
345: ,list_line_no VARCHAR2(30) := Fnd_Api.g_miss_char
346: );
347: TYPE modifier_line_tbl_type IS TABLE OF MODIFIER_LINE_REC_TYPE INDEX BY BINARY_INTEGER;
340: ,estimate_qty_uom VARCHAR2(3) := Fnd_Api.g_miss_char
341: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
342: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
343: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
344: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
345: ,list_line_no VARCHAR2(30) := Fnd_Api.g_miss_char
346: );
347: TYPE modifier_line_tbl_type IS TABLE OF MODIFIER_LINE_REC_TYPE INDEX BY BINARY_INTEGER;
348:
341: ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
342: ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
343: ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
344: ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
345: ,list_line_no VARCHAR2(30) := Fnd_Api.g_miss_char
346: );
347: TYPE modifier_line_tbl_type IS TABLE OF MODIFIER_LINE_REC_TYPE INDEX BY BINARY_INTEGER;
348:
349: TYPE qualifiers_Rec_Type IS RECORD
347: TYPE modifier_line_tbl_type IS TABLE OF MODIFIER_LINE_REC_TYPE INDEX BY BINARY_INTEGER;
348:
349: TYPE qualifiers_Rec_Type IS RECORD
350: (
351: qualifier_context VARCHAR2(30) := Fnd_Api.g_miss_char
352: ,qualifier_attribute VARCHAR2(30) := Fnd_Api.g_miss_char
353: ,qualifier_attr_value VARCHAR2(240) := Fnd_Api.g_miss_char
354: ,qualifier_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
355: ,comparison_operator_code VARCHAR2(30) := Fnd_Api.g_miss_char
348:
349: TYPE qualifiers_Rec_Type IS RECORD
350: (
351: qualifier_context VARCHAR2(30) := Fnd_Api.g_miss_char
352: ,qualifier_attribute VARCHAR2(30) := Fnd_Api.g_miss_char
353: ,qualifier_attr_value VARCHAR2(240) := Fnd_Api.g_miss_char
354: ,qualifier_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
355: ,comparison_operator_code VARCHAR2(30) := Fnd_Api.g_miss_char
356: ,qualifier_grouping_no NUMBER := Fnd_Api.g_miss_num
349: TYPE qualifiers_Rec_Type IS RECORD
350: (
351: qualifier_context VARCHAR2(30) := Fnd_Api.g_miss_char
352: ,qualifier_attribute VARCHAR2(30) := Fnd_Api.g_miss_char
353: ,qualifier_attr_value VARCHAR2(240) := Fnd_Api.g_miss_char
354: ,qualifier_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
355: ,comparison_operator_code VARCHAR2(30) := Fnd_Api.g_miss_char
356: ,qualifier_grouping_no NUMBER := Fnd_Api.g_miss_num
357: ,list_line_id NUMBER := Fnd_Api.g_miss_num
350: (
351: qualifier_context VARCHAR2(30) := Fnd_Api.g_miss_char
352: ,qualifier_attribute VARCHAR2(30) := Fnd_Api.g_miss_char
353: ,qualifier_attr_value VARCHAR2(240) := Fnd_Api.g_miss_char
354: ,qualifier_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
355: ,comparison_operator_code VARCHAR2(30) := Fnd_Api.g_miss_char
356: ,qualifier_grouping_no NUMBER := Fnd_Api.g_miss_num
357: ,list_line_id NUMBER := Fnd_Api.g_miss_num
358: ,list_header_id NUMBER := Fnd_Api.g_miss_num
351: qualifier_context VARCHAR2(30) := Fnd_Api.g_miss_char
352: ,qualifier_attribute VARCHAR2(30) := Fnd_Api.g_miss_char
353: ,qualifier_attr_value VARCHAR2(240) := Fnd_Api.g_miss_char
354: ,qualifier_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
355: ,comparison_operator_code VARCHAR2(30) := Fnd_Api.g_miss_char
356: ,qualifier_grouping_no NUMBER := Fnd_Api.g_miss_num
357: ,list_line_id NUMBER := Fnd_Api.g_miss_num
358: ,list_header_id NUMBER := Fnd_Api.g_miss_num
359: ,qualifier_id NUMBER := Fnd_Api.g_miss_num
352: ,qualifier_attribute VARCHAR2(30) := Fnd_Api.g_miss_char
353: ,qualifier_attr_value VARCHAR2(240) := Fnd_Api.g_miss_char
354: ,qualifier_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
355: ,comparison_operator_code VARCHAR2(30) := Fnd_Api.g_miss_char
356: ,qualifier_grouping_no NUMBER := Fnd_Api.g_miss_num
357: ,list_line_id NUMBER := Fnd_Api.g_miss_num
358: ,list_header_id NUMBER := Fnd_Api.g_miss_num
359: ,qualifier_id NUMBER := Fnd_Api.g_miss_num
360: ,start_date_active DATE := Fnd_Api.g_miss_date
353: ,qualifier_attr_value VARCHAR2(240) := Fnd_Api.g_miss_char
354: ,qualifier_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
355: ,comparison_operator_code VARCHAR2(30) := Fnd_Api.g_miss_char
356: ,qualifier_grouping_no NUMBER := Fnd_Api.g_miss_num
357: ,list_line_id NUMBER := Fnd_Api.g_miss_num
358: ,list_header_id NUMBER := Fnd_Api.g_miss_num
359: ,qualifier_id NUMBER := Fnd_Api.g_miss_num
360: ,start_date_active DATE := Fnd_Api.g_miss_date
361: ,end_date_active DATE := Fnd_Api.g_miss_date
354: ,qualifier_attr_value_to VARCHAR2(240) := Fnd_Api.g_miss_char
355: ,comparison_operator_code VARCHAR2(30) := Fnd_Api.g_miss_char
356: ,qualifier_grouping_no NUMBER := Fnd_Api.g_miss_num
357: ,list_line_id NUMBER := Fnd_Api.g_miss_num
358: ,list_header_id NUMBER := Fnd_Api.g_miss_num
359: ,qualifier_id NUMBER := Fnd_Api.g_miss_num
360: ,start_date_active DATE := Fnd_Api.g_miss_date
361: ,end_date_active DATE := Fnd_Api.g_miss_date
362: ,activity_market_segment_id NUMBER := Fnd_Api.g_miss_num
355: ,comparison_operator_code VARCHAR2(30) := Fnd_Api.g_miss_char
356: ,qualifier_grouping_no NUMBER := Fnd_Api.g_miss_num
357: ,list_line_id NUMBER := Fnd_Api.g_miss_num
358: ,list_header_id NUMBER := Fnd_Api.g_miss_num
359: ,qualifier_id NUMBER := Fnd_Api.g_miss_num
360: ,start_date_active DATE := Fnd_Api.g_miss_date
361: ,end_date_active DATE := Fnd_Api.g_miss_date
362: ,activity_market_segment_id NUMBER := Fnd_Api.g_miss_num
363: ,operation VARCHAR2(30) := Fnd_Api.g_miss_char
356: ,qualifier_grouping_no NUMBER := Fnd_Api.g_miss_num
357: ,list_line_id NUMBER := Fnd_Api.g_miss_num
358: ,list_header_id NUMBER := Fnd_Api.g_miss_num
359: ,qualifier_id NUMBER := Fnd_Api.g_miss_num
360: ,start_date_active DATE := Fnd_Api.g_miss_date
361: ,end_date_active DATE := Fnd_Api.g_miss_date
362: ,activity_market_segment_id NUMBER := Fnd_Api.g_miss_num
363: ,operation VARCHAR2(30) := Fnd_Api.g_miss_char
364: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
357: ,list_line_id NUMBER := Fnd_Api.g_miss_num
358: ,list_header_id NUMBER := Fnd_Api.g_miss_num
359: ,qualifier_id NUMBER := Fnd_Api.g_miss_num
360: ,start_date_active DATE := Fnd_Api.g_miss_date
361: ,end_date_active DATE := Fnd_Api.g_miss_date
362: ,activity_market_segment_id NUMBER := Fnd_Api.g_miss_num
363: ,operation VARCHAR2(30) := Fnd_Api.g_miss_char
364: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
365: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
358: ,list_header_id NUMBER := Fnd_Api.g_miss_num
359: ,qualifier_id NUMBER := Fnd_Api.g_miss_num
360: ,start_date_active DATE := Fnd_Api.g_miss_date
361: ,end_date_active DATE := Fnd_Api.g_miss_date
362: ,activity_market_segment_id NUMBER := Fnd_Api.g_miss_num
363: ,operation VARCHAR2(30) := Fnd_Api.g_miss_char
364: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
365: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
366: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
359: ,qualifier_id NUMBER := Fnd_Api.g_miss_num
360: ,start_date_active DATE := Fnd_Api.g_miss_date
361: ,end_date_active DATE := Fnd_Api.g_miss_date
362: ,activity_market_segment_id NUMBER := Fnd_Api.g_miss_num
363: ,operation VARCHAR2(30) := Fnd_Api.g_miss_char
364: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
365: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
366: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
367: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
360: ,start_date_active DATE := Fnd_Api.g_miss_date
361: ,end_date_active DATE := Fnd_Api.g_miss_date
362: ,activity_market_segment_id NUMBER := Fnd_Api.g_miss_num
363: ,operation VARCHAR2(30) := Fnd_Api.g_miss_char
364: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
365: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
366: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
367: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
368: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
361: ,end_date_active DATE := Fnd_Api.g_miss_date
362: ,activity_market_segment_id NUMBER := Fnd_Api.g_miss_num
363: ,operation VARCHAR2(30) := Fnd_Api.g_miss_char
364: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
365: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
366: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
367: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
368: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
369: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
362: ,activity_market_segment_id NUMBER := Fnd_Api.g_miss_num
363: ,operation VARCHAR2(30) := Fnd_Api.g_miss_char
364: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
365: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
366: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
367: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
368: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
369: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
370: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
363: ,operation VARCHAR2(30) := Fnd_Api.g_miss_char
364: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
365: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
366: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
367: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
368: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
369: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
370: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
371: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
364: ,context VARCHAR2(30) := Fnd_Api.g_miss_char
365: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
366: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
367: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
368: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
369: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
370: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
371: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
372: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
365: ,attribute1 VARCHAR2(240) := Fnd_Api.g_miss_char
366: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
367: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
368: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
369: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
370: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
371: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
372: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
373: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
366: ,attribute2 VARCHAR2(240) := Fnd_Api.g_miss_char
367: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
368: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
369: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
370: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
371: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
372: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
373: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
374: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
367: ,attribute3 VARCHAR2(240) := Fnd_Api.g_miss_char
368: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
369: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
370: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
371: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
372: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
373: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
374: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
375: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
368: ,attribute4 VARCHAR2(240) := Fnd_Api.g_miss_char
369: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
370: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
371: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
372: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
373: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
374: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
375: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
376: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
369: ,attribute5 VARCHAR2(240) := Fnd_Api.g_miss_char
370: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
371: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
372: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
373: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
374: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
375: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
376: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
377: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
370: ,attribute6 VARCHAR2(240) := Fnd_Api.g_miss_char
371: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
372: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
373: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
374: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
375: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
376: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
377: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
378: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
371: ,attribute7 VARCHAR2(240) := Fnd_Api.g_miss_char
372: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
373: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
374: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
375: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
376: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
377: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
378: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
379: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
372: ,attribute8 VARCHAR2(240) := Fnd_Api.g_miss_char
373: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
374: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
375: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
376: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
377: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
378: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
379: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
380: );
373: ,attribute9 VARCHAR2(240) := Fnd_Api.g_miss_char
374: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
375: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
376: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
377: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
378: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
379: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
380: );
381: TYPE qualifiers_tbl_type IS TABLE OF qualifiers_rec_type INDEX BY BINARY_INTEGER;
374: ,attribute10 VARCHAR2(240) := Fnd_Api.g_miss_char
375: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
376: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
377: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
378: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
379: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
380: );
381: TYPE qualifiers_tbl_type IS TABLE OF qualifiers_rec_type INDEX BY BINARY_INTEGER;
382:
375: ,attribute11 VARCHAR2(240) := Fnd_Api.g_miss_char
376: ,attribute12 VARCHAR2(240) := Fnd_Api.g_miss_char
377: ,attribute13 VARCHAR2(240) := Fnd_Api.g_miss_char
378: ,attribute14 VARCHAR2(240) := Fnd_Api.g_miss_char
379: ,attribute15 VARCHAR2(240) := Fnd_Api.g_miss_char
380: );
381: TYPE qualifiers_tbl_type IS TABLE OF qualifiers_rec_type INDEX BY BINARY_INTEGER;
382:
383: TYPE vo_disc_rec_type IS RECORD
624:
625:
626: PROCEDURE process_offer_from_adapter(
627: p_api_version IN NUMBER
628: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
629: ,p_commit IN VARCHAR2 := fnd_api.g_false
630: ,p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL
631: ,x_return_status OUT NOCOPY VARCHAR2
632: ,x_msg_count OUT NOCOPY NUMBER
625:
626: PROCEDURE process_offer_from_adapter(
627: p_api_version IN NUMBER
628: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
629: ,p_commit IN VARCHAR2 := fnd_api.g_false
630: ,p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL
631: ,x_return_status OUT NOCOPY VARCHAR2
632: ,x_msg_count OUT NOCOPY NUMBER
633: ,x_msg_data OUT NOCOPY VARCHAR2
626: PROCEDURE process_offer_from_adapter(
627: p_api_version IN NUMBER
628: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
629: ,p_commit IN VARCHAR2 := fnd_api.g_false
630: ,p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL
631: ,x_return_status OUT NOCOPY VARCHAR2
632: ,x_msg_count OUT NOCOPY NUMBER
633: ,x_msg_data OUT NOCOPY VARCHAR2
634: ,p_source IN VARCHAR2 := 'SIEBEL'