eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PRICE_BOOK_PVT dependencies on QP_PREQ_GRP

Line 255: l_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

251: order_level_global_struct VARCHAR2(80),
252: line_level_global_struct VARCHAR2(80));
253: l_rec GLOBAL_STRUCT_REC;
254:
255: l_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
256: l_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
257: l_pricing_effective_date_tbl QP_PREQ_GRP.DATE_TYPE;
258: l_active_date_first_tbl QP_PREQ_GRP.DATE_TYPE;
259: l_active_date_first_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 256: l_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

252: line_level_global_struct VARCHAR2(80));
253: l_rec GLOBAL_STRUCT_REC;
254:
255: l_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
256: l_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
257: l_pricing_effective_date_tbl QP_PREQ_GRP.DATE_TYPE;
258: l_active_date_first_tbl QP_PREQ_GRP.DATE_TYPE;
259: l_active_date_first_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
260: l_active_date_second_tbl QP_PREQ_GRP.DATE_TYPE;

Line 257: l_pricing_effective_date_tbl QP_PREQ_GRP.DATE_TYPE;

253: l_rec GLOBAL_STRUCT_REC;
254:
255: l_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
256: l_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
257: l_pricing_effective_date_tbl QP_PREQ_GRP.DATE_TYPE;
258: l_active_date_first_tbl QP_PREQ_GRP.DATE_TYPE;
259: l_active_date_first_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
260: l_active_date_second_tbl QP_PREQ_GRP.DATE_TYPE;
261: l_active_date_second_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 258: l_active_date_first_tbl QP_PREQ_GRP.DATE_TYPE;

254:
255: l_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
256: l_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
257: l_pricing_effective_date_tbl QP_PREQ_GRP.DATE_TYPE;
258: l_active_date_first_tbl QP_PREQ_GRP.DATE_TYPE;
259: l_active_date_first_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
260: l_active_date_second_tbl QP_PREQ_GRP.DATE_TYPE;
261: l_active_date_second_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
262: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 259: l_active_date_first_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;

255: l_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
256: l_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
257: l_pricing_effective_date_tbl QP_PREQ_GRP.DATE_TYPE;
258: l_active_date_first_tbl QP_PREQ_GRP.DATE_TYPE;
259: l_active_date_first_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
260: l_active_date_second_tbl QP_PREQ_GRP.DATE_TYPE;
261: l_active_date_second_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
262: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
263: l_line_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 260: l_active_date_second_tbl QP_PREQ_GRP.DATE_TYPE;

256: l_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
257: l_pricing_effective_date_tbl QP_PREQ_GRP.DATE_TYPE;
258: l_active_date_first_tbl QP_PREQ_GRP.DATE_TYPE;
259: l_active_date_first_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
260: l_active_date_second_tbl QP_PREQ_GRP.DATE_TYPE;
261: l_active_date_second_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
262: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
263: l_line_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
264: l_request_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 261: l_active_date_second_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;

257: l_pricing_effective_date_tbl QP_PREQ_GRP.DATE_TYPE;
258: l_active_date_first_tbl QP_PREQ_GRP.DATE_TYPE;
259: l_active_date_first_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
260: l_active_date_second_tbl QP_PREQ_GRP.DATE_TYPE;
261: l_active_date_second_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
262: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
263: l_line_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
264: l_request_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
265: l_priced_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 262: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

258: l_active_date_first_tbl QP_PREQ_GRP.DATE_TYPE;
259: l_active_date_first_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
260: l_active_date_second_tbl QP_PREQ_GRP.DATE_TYPE;
261: l_active_date_second_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
262: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
263: l_line_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
264: l_request_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
265: l_priced_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
266: l_priced_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 263: l_line_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

259: l_active_date_first_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
260: l_active_date_second_tbl QP_PREQ_GRP.DATE_TYPE;
261: l_active_date_second_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
262: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
263: l_line_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
264: l_request_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
265: l_priced_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
266: l_priced_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
267: l_currency_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 264: l_request_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

260: l_active_date_second_tbl QP_PREQ_GRP.DATE_TYPE;
261: l_active_date_second_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
262: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
263: l_line_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
264: l_request_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
265: l_priced_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
266: l_priced_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
267: l_currency_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
268: l_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 265: l_priced_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

261: l_active_date_second_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
262: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
263: l_line_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
264: l_request_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
265: l_priced_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
266: l_priced_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
267: l_currency_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
268: l_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
269: l_percent_price_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 266: l_priced_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

262: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
263: l_line_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
264: l_request_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
265: l_priced_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
266: l_priced_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
267: l_currency_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
268: l_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
269: l_percent_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
270: l_uom_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 267: l_currency_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

263: l_line_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
264: l_request_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
265: l_priced_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
266: l_priced_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
267: l_currency_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
268: l_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
269: l_percent_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
270: l_uom_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
271: l_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 268: l_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;

264: l_request_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
265: l_priced_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
266: l_priced_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
267: l_currency_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
268: l_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
269: l_percent_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
270: l_uom_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
271: l_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
272: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 269: l_percent_price_tbl QP_PREQ_GRP.NUMBER_TYPE;

265: l_priced_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
266: l_priced_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
267: l_currency_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
268: l_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
269: l_percent_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
270: l_uom_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
271: l_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
272: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
273: l_processed_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 270: l_uom_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

266: l_priced_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
267: l_currency_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
268: l_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
269: l_percent_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
270: l_uom_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
271: l_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
272: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
273: l_processed_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
274: l_price_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 271: l_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;

267: l_currency_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
268: l_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
269: l_percent_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
270: l_uom_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
271: l_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
272: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
273: l_processed_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
274: l_price_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
275: l_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 272: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;

268: l_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
269: l_percent_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
270: l_uom_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
271: l_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
272: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
273: l_processed_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
274: l_price_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
275: l_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
276: l_processing_order_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 273: l_processed_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

269: l_percent_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
270: l_uom_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
271: l_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
272: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
273: l_processed_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
274: l_price_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
275: l_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
276: l_processing_order_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
277: l_pricing_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 274: l_price_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

270: l_uom_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
271: l_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
272: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
273: l_processed_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
274: l_price_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
275: l_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
276: l_processing_order_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
277: l_pricing_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
278: l_pricing_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 275: l_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

271: l_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
272: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
273: l_processed_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
274: l_price_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
275: l_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
276: l_processing_order_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
277: l_pricing_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
278: l_pricing_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
279: l_rounding_flag_tbl QP_PREQ_GRP.FLAG_TYPE;

Line 276: l_processing_order_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

272: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.NUMBER_TYPE;
273: l_processed_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
274: l_price_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
275: l_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
276: l_processing_order_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
277: l_pricing_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
278: l_pricing_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
279: l_rounding_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
280: l_rounding_factor_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 277: l_pricing_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

273: l_processed_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
274: l_price_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
275: l_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
276: l_processing_order_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
277: l_pricing_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
278: l_pricing_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
279: l_rounding_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
280: l_rounding_factor_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
281: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 278: l_pricing_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;

274: l_price_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
275: l_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
276: l_processing_order_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
277: l_pricing_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
278: l_pricing_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
279: l_rounding_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
280: l_rounding_factor_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
281: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
282: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 279: l_rounding_flag_tbl QP_PREQ_GRP.FLAG_TYPE;

275: l_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
276: l_processing_order_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
277: l_pricing_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
278: l_pricing_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
279: l_rounding_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
280: l_rounding_factor_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
281: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
282: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
283: l_price_list_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 280: l_rounding_factor_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

276: l_processing_order_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
277: l_pricing_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
278: l_pricing_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
279: l_rounding_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
280: l_rounding_factor_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
281: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
282: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
283: l_price_list_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
284: l_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 281: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

277: l_pricing_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
278: l_pricing_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
279: l_rounding_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
280: l_rounding_factor_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
281: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
282: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
283: l_price_list_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
284: l_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
285: l_price_request_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 282: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

278: l_pricing_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
279: l_rounding_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
280: l_rounding_factor_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
281: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
282: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
283: l_price_list_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
284: l_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
285: l_price_request_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
286: l_usage_pricing_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 283: l_price_list_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

279: l_rounding_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
280: l_rounding_factor_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
281: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
282: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
283: l_price_list_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
284: l_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
285: l_price_request_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
286: l_usage_pricing_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
287: l_item_number_tbl NUMBER_TYPE;

Line 284: l_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

280: l_rounding_factor_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
281: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
282: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
283: l_price_list_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
284: l_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
285: l_price_request_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
286: l_usage_pricing_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
287: l_item_number_tbl NUMBER_TYPE;
288:

Line 285: l_price_request_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

281: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
282: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
283: l_price_list_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
284: l_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
285: l_price_request_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
286: l_usage_pricing_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
287: l_item_number_tbl NUMBER_TYPE;
288:
289: CURSOR insert_lines2_cur (a_price_book_header_id NUMBER,

Line 286: l_usage_pricing_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;

282: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
283: l_price_list_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
284: l_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
285: l_price_request_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
286: l_usage_pricing_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
287: l_item_number_tbl NUMBER_TYPE;
288:
289: CURSOR insert_lines2_cur (a_price_book_header_id NUMBER,
290: a_effective_date DATE,

Line 307: QP_PREQ_GRP.G_NOT_PROCESSED, --processed_flag

303: null, null, --priced_quantity, priced_uom_code
304: a_currency_code,
305: null, null, null, --unit_price, percent_price, uom_quantity
306: null, null, --adjusted_unit_price, upd_adjusted_unit_price
307: QP_PREQ_GRP.G_NOT_PROCESSED, --processed_flag
308: 'Y', --price_flag
309: price_book_line_id, --line_id
310: null, --processing_order
311: QP_PREQ_GRP.G_STATUS_UNCHANGED, --pricing_status_code

Line 311: QP_PREQ_GRP.G_STATUS_UNCHANGED, --pricing_status_code

307: QP_PREQ_GRP.G_NOT_PROCESSED, --processed_flag
308: 'Y', --price_flag
309: price_book_line_id, --line_id
310: null, --processing_order
311: QP_PREQ_GRP.G_STATUS_UNCHANGED, --pricing_status_code
312: null, --pricing_status_text
313: 'Q', --rounding_flag
314: null, --rounding_factor
315: 'N', --qualifiers_exist_flag

Line 327: l_attrs_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

323: FROM qp_price_book_lines
324: WHERE price_book_header_id = a_price_book_header_id
325: ORDER BY price_book_line_id;
326:
327: l_attrs_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
328: l_attrs_line_detail_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
329: l_attrs_attribute_level_tbl QP_PREQ_GRP.VARCHAR_TYPE;
330: l_attrs_attribute_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
331: l_attrs_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 328: l_attrs_line_detail_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

324: WHERE price_book_header_id = a_price_book_header_id
325: ORDER BY price_book_line_id;
326:
327: l_attrs_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
328: l_attrs_line_detail_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
329: l_attrs_attribute_level_tbl QP_PREQ_GRP.VARCHAR_TYPE;
330: l_attrs_attribute_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
331: l_attrs_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
332: l_attrs_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 329: l_attrs_attribute_level_tbl QP_PREQ_GRP.VARCHAR_TYPE;

325: ORDER BY price_book_line_id;
326:
327: l_attrs_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
328: l_attrs_line_detail_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
329: l_attrs_attribute_level_tbl QP_PREQ_GRP.VARCHAR_TYPE;
330: l_attrs_attribute_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
331: l_attrs_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
332: l_attrs_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
333: l_attrs_context_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 330: l_attrs_attribute_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;

326:
327: l_attrs_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
328: l_attrs_line_detail_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
329: l_attrs_attribute_level_tbl QP_PREQ_GRP.VARCHAR_TYPE;
330: l_attrs_attribute_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
331: l_attrs_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
332: l_attrs_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
333: l_attrs_context_tbl QP_PREQ_GRP.VARCHAR_TYPE;
334: l_attrs_attribute_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 331: l_attrs_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

327: l_attrs_line_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
328: l_attrs_line_detail_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
329: l_attrs_attribute_level_tbl QP_PREQ_GRP.VARCHAR_TYPE;
330: l_attrs_attribute_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
331: l_attrs_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
332: l_attrs_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
333: l_attrs_context_tbl QP_PREQ_GRP.VARCHAR_TYPE;
334: l_attrs_attribute_tbl QP_PREQ_GRP.VARCHAR_TYPE;
335: l_attrs_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 332: l_attrs_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

328: l_attrs_line_detail_index_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
329: l_attrs_attribute_level_tbl QP_PREQ_GRP.VARCHAR_TYPE;
330: l_attrs_attribute_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
331: l_attrs_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
332: l_attrs_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
333: l_attrs_context_tbl QP_PREQ_GRP.VARCHAR_TYPE;
334: l_attrs_attribute_tbl QP_PREQ_GRP.VARCHAR_TYPE;
335: l_attrs_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
336: l_attrs_setup_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 333: l_attrs_context_tbl QP_PREQ_GRP.VARCHAR_TYPE;

329: l_attrs_attribute_level_tbl QP_PREQ_GRP.VARCHAR_TYPE;
330: l_attrs_attribute_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
331: l_attrs_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
332: l_attrs_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
333: l_attrs_context_tbl QP_PREQ_GRP.VARCHAR_TYPE;
334: l_attrs_attribute_tbl QP_PREQ_GRP.VARCHAR_TYPE;
335: l_attrs_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
336: l_attrs_setup_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
337: l_attrs_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 334: l_attrs_attribute_tbl QP_PREQ_GRP.VARCHAR_TYPE;

330: l_attrs_attribute_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
331: l_attrs_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
332: l_attrs_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
333: l_attrs_context_tbl QP_PREQ_GRP.VARCHAR_TYPE;
334: l_attrs_attribute_tbl QP_PREQ_GRP.VARCHAR_TYPE;
335: l_attrs_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
336: l_attrs_setup_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
337: l_attrs_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
338: l_attrs_setup_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 335: l_attrs_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;

331: l_attrs_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
332: l_attrs_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
333: l_attrs_context_tbl QP_PREQ_GRP.VARCHAR_TYPE;
334: l_attrs_attribute_tbl QP_PREQ_GRP.VARCHAR_TYPE;
335: l_attrs_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
336: l_attrs_setup_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
337: l_attrs_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
338: l_attrs_setup_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
339: l_attrs_grouping_number_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 336: l_attrs_setup_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;

332: l_attrs_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
333: l_attrs_context_tbl QP_PREQ_GRP.VARCHAR_TYPE;
334: l_attrs_attribute_tbl QP_PREQ_GRP.VARCHAR_TYPE;
335: l_attrs_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
336: l_attrs_setup_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
337: l_attrs_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
338: l_attrs_setup_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
339: l_attrs_grouping_number_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
340: l_attrs_no_quals_in_grp_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 337: l_attrs_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;

333: l_attrs_context_tbl QP_PREQ_GRP.VARCHAR_TYPE;
334: l_attrs_attribute_tbl QP_PREQ_GRP.VARCHAR_TYPE;
335: l_attrs_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
336: l_attrs_setup_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
337: l_attrs_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
338: l_attrs_setup_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
339: l_attrs_grouping_number_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
340: l_attrs_no_quals_in_grp_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
341: l_attrs_comp_oper_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 338: l_attrs_setup_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;

334: l_attrs_attribute_tbl QP_PREQ_GRP.VARCHAR_TYPE;
335: l_attrs_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
336: l_attrs_setup_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
337: l_attrs_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
338: l_attrs_setup_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
339: l_attrs_grouping_number_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
340: l_attrs_no_quals_in_grp_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
341: l_attrs_comp_oper_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
342: l_attrs_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 339: l_attrs_grouping_number_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

335: l_attrs_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
336: l_attrs_setup_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
337: l_attrs_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
338: l_attrs_setup_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
339: l_attrs_grouping_number_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
340: l_attrs_no_quals_in_grp_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
341: l_attrs_comp_oper_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
342: l_attrs_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
343: l_attrs_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 340: l_attrs_no_quals_in_grp_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

336: l_attrs_setup_value_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
337: l_attrs_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
338: l_attrs_setup_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
339: l_attrs_grouping_number_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
340: l_attrs_no_quals_in_grp_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
341: l_attrs_comp_oper_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
342: l_attrs_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
343: l_attrs_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
344: l_attrs_pri_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 341: l_attrs_comp_oper_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;

337: l_attrs_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
338: l_attrs_setup_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
339: l_attrs_grouping_number_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
340: l_attrs_no_quals_in_grp_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
341: l_attrs_comp_oper_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
342: l_attrs_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
343: l_attrs_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
344: l_attrs_pri_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
345: l_attrs_pri_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 342: l_attrs_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

338: l_attrs_setup_value_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
339: l_attrs_grouping_number_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
340: l_attrs_no_quals_in_grp_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
341: l_attrs_comp_oper_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
342: l_attrs_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
343: l_attrs_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
344: l_attrs_pri_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
345: l_attrs_pri_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
346: l_attrs_qual_precedence_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 343: l_attrs_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

339: l_attrs_grouping_number_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
340: l_attrs_no_quals_in_grp_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
341: l_attrs_comp_oper_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
342: l_attrs_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
343: l_attrs_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
344: l_attrs_pri_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
345: l_attrs_pri_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
346: l_attrs_qual_precedence_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
347: l_attrs_datatype_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 344: l_attrs_pri_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

340: l_attrs_no_quals_in_grp_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
341: l_attrs_comp_oper_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
342: l_attrs_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
343: l_attrs_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
344: l_attrs_pri_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
345: l_attrs_pri_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
346: l_attrs_qual_precedence_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
347: l_attrs_datatype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
348: l_attrs_pricing_attr_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 345: l_attrs_pri_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;

341: l_attrs_comp_oper_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
342: l_attrs_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
343: l_attrs_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
344: l_attrs_pri_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
345: l_attrs_pri_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
346: l_attrs_qual_precedence_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
347: l_attrs_datatype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
348: l_attrs_pricing_attr_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
349: l_attrs_qualifier_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 346: l_attrs_qual_precedence_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

342: l_attrs_validated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
343: l_attrs_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
344: l_attrs_pri_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
345: l_attrs_pri_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
346: l_attrs_qual_precedence_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
347: l_attrs_datatype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
348: l_attrs_pricing_attr_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
349: l_attrs_qualifier_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
350: l_attrs_product_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 347: l_attrs_datatype_tbl QP_PREQ_GRP.VARCHAR_TYPE;

343: l_attrs_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
344: l_attrs_pri_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
345: l_attrs_pri_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
346: l_attrs_qual_precedence_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
347: l_attrs_datatype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
348: l_attrs_pricing_attr_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
349: l_attrs_qualifier_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
350: l_attrs_product_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
351: l_attrs_excluder_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 348: l_attrs_pricing_attr_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

344: l_attrs_pri_status_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
345: l_attrs_pri_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
346: l_attrs_qual_precedence_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
347: l_attrs_datatype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
348: l_attrs_pricing_attr_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
349: l_attrs_qualifier_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
350: l_attrs_product_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
351: l_attrs_excluder_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
352: l_attrs_pricing_phase_id_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 349: l_attrs_qualifier_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;

345: l_attrs_pri_status_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
346: l_attrs_qual_precedence_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
347: l_attrs_datatype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
348: l_attrs_pricing_attr_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
349: l_attrs_qualifier_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
350: l_attrs_product_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
351: l_attrs_excluder_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
352: l_attrs_pricing_phase_id_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
353: l_attrs_incomp_grp_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 350: l_attrs_product_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

346: l_attrs_qual_precedence_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
347: l_attrs_datatype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
348: l_attrs_pricing_attr_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
349: l_attrs_qualifier_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
350: l_attrs_product_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
351: l_attrs_excluder_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
352: l_attrs_pricing_phase_id_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
353: l_attrs_incomp_grp_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
354: l_attrs_line_det_typ_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 351: l_attrs_excluder_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

347: l_attrs_datatype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
348: l_attrs_pricing_attr_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
349: l_attrs_qualifier_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
350: l_attrs_product_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
351: l_attrs_excluder_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
352: l_attrs_pricing_phase_id_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
353: l_attrs_incomp_grp_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
354: l_attrs_line_det_typ_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
355: l_attrs_modif_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 352: l_attrs_pricing_phase_id_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

348: l_attrs_pricing_attr_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
349: l_attrs_qualifier_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
350: l_attrs_product_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
351: l_attrs_excluder_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
352: l_attrs_pricing_phase_id_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
353: l_attrs_incomp_grp_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
354: l_attrs_line_det_typ_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
355: l_attrs_modif_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
356: l_attrs_primary_uom_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 353: l_attrs_incomp_grp_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

349: l_attrs_qualifier_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
350: l_attrs_product_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
351: l_attrs_excluder_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
352: l_attrs_pricing_phase_id_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
353: l_attrs_incomp_grp_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
354: l_attrs_line_det_typ_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
355: l_attrs_modif_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
356: l_attrs_primary_uom_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
357:

Line 354: l_attrs_line_det_typ_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

350: l_attrs_product_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
351: l_attrs_excluder_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
352: l_attrs_pricing_phase_id_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
353: l_attrs_incomp_grp_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
354: l_attrs_line_det_typ_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
355: l_attrs_modif_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
356: l_attrs_primary_uom_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
357:
358:

Line 355: l_attrs_modif_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

351: l_attrs_excluder_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
352: l_attrs_pricing_phase_id_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
353: l_attrs_incomp_grp_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
354: l_attrs_line_det_typ_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
355: l_attrs_modif_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
356: l_attrs_primary_uom_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
357:
358:
359: --Cursor to get 'User Entered' attributes to insert into line_attrs_tmp table

Line 356: l_attrs_primary_uom_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

352: l_attrs_pricing_phase_id_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
353: l_attrs_incomp_grp_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
354: l_attrs_line_det_typ_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
355: l_attrs_modif_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
356: l_attrs_primary_uom_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
357:
358:
359: --Cursor to get 'User Entered' attributes to insert into line_attrs_tmp table
360: CURSOR insert_line_attrs2_cur (a_line_index NUMBER,

Line 365: QP_PREQ_GRP.G_LINE_LEVEL, --attribute_level

361: a_request_type_code VARCHAR2,
362: a_pb_input_header_id NUMBER)
363: IS
364: SELECT a_line_index, null, --line_index, line_detail_index
365: QP_PREQ_GRP.G_LINE_LEVEL, --attribute_level
366: decode(l.attribute_type,
367: 'PRICING_ATTRIBUTE', QP_PREQ_GRP.G_PRICING_TYPE,
368: l.attribute_type), --attribute_type
369: null, null, --list_header_id, list_line_id

Line 367: 'PRICING_ATTRIBUTE', QP_PREQ_GRP.G_PRICING_TYPE,

363: IS
364: SELECT a_line_index, null, --line_index, line_detail_index
365: QP_PREQ_GRP.G_LINE_LEVEL, --attribute_level
366: decode(l.attribute_type,
367: 'PRICING_ATTRIBUTE', QP_PREQ_GRP.G_PRICING_TYPE,
368: l.attribute_type), --attribute_type
369: null, null, --list_header_id, list_line_id
370: l.context, --context
371: l.attribute, --attribute

Line 377: QP_PREQ_GRP.G_LIST_NOT_APPLIED, --applied_flag

373: null, null, null, --setup_value_from, value_to, setup_value_to
374: null, null, --grouping_number, no_qualifiers_in_group
375: null, --comparison_operator_type
376: 'N', --validated_flag
377: QP_PREQ_GRP.G_LIST_NOT_APPLIED, --applied_flag
378: QP_PREQ_GRP.G_STATUS_UNCHANGED, --pricing_status_code
379: null, null, --pricing_status_text, qualifier_precedence
380: null, --datatype
381: QP_PREQ_GRP.G_YES, --pricing_attr_flag

Line 378: QP_PREQ_GRP.G_STATUS_UNCHANGED, --pricing_status_code

374: null, null, --grouping_number, no_qualifiers_in_group
375: null, --comparison_operator_type
376: 'N', --validated_flag
377: QP_PREQ_GRP.G_LIST_NOT_APPLIED, --applied_flag
378: QP_PREQ_GRP.G_STATUS_UNCHANGED, --pricing_status_code
379: null, null, --pricing_status_text, qualifier_precedence
380: null, --datatype
381: QP_PREQ_GRP.G_YES, --pricing_attr_flag
382: null, null, --qualifier_type, product_uom_code

Line 381: QP_PREQ_GRP.G_YES, --pricing_attr_flag

377: QP_PREQ_GRP.G_LIST_NOT_APPLIED, --applied_flag
378: QP_PREQ_GRP.G_STATUS_UNCHANGED, --pricing_status_code
379: null, null, --pricing_status_text, qualifier_precedence
380: null, --datatype
381: QP_PREQ_GRP.G_YES, --pricing_attr_flag
382: null, null, --qualifier_type, product_uom_code
383: null, null, --excluder_flag, pricing_phase_id
384: null, null, --incompatibility_grp_code, line_detail_type_code
385: null, null --modifier_level_code, primary_uom_flag

Line 439: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

435: l_bsa_hdr_price_list_id NUMBER;
436: l_bsa_line_price_list_id NUMBER;
437: l_application_id NUMBER;
438:
439: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
440:
441: CURSOR pb_items_cur(a_price_book_header_id NUMBER)
442: IS
443: SELECT price_book_line_id, item_number --inventory_item_id

Line 485: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

481: a.price_break_type_code, a.line_index, a.line_detail_index,
482: b.line_id
483: FROM qp_preq_ldets_tmp a, qp_preq_lines_tmp b
484: WHERE a.line_index = b.line_index
485: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
486: AND a.line_detail_type_code = 'NULL' --not a child line
487: AND a.applied_flag = 'Y' --automatic and applied discounts
488: AND nvl(a.accrual_flag,'N') = 'N' --exclude accruals
489: ORDER BY a.line_index,

Line 635: QP_PREQ_GRP.INSERT_LINES2(

631:
632: l_count := l_count + insert_lines2_cur%ROWCOUNT; --highest index of the previous loop
633: fnd_file.put_line(FND_FILE.LOG, 'insert_lines2_cur rowcount = '|| l_count);
634:
635: QP_PREQ_GRP.INSERT_LINES2(
636: p_LINE_INDEX => l_line_index_tbl,
637: p_LINE_TYPE_CODE => l_line_type_code_tbl,
638: p_PRICING_EFFECTIVE_DATE => l_pricing_effective_date_tbl,
639: p_ACTIVE_DATE_FIRST => l_active_date_first_tbl,

Line 1019: --table using the qp_preq_grp.insert_line_attrs2 API

1015: p_org_id => p_pb_input_header_rec.org_id);
1016:
1017: --Clear the plsql tables, fetch User-Entered attributes from the
1018: --pricebook input lines table, then insert into the line attrs temp
1019: --table using the qp_preq_grp.insert_line_attrs2 API
1020: OPEN insert_line_attrs2_cur(l_line_index_tbl(ii),
1021: p_pb_input_header_rec.request_type_code,
1022: p_pb_input_header_rec.pb_input_header_id);
1023: LOOP

Line 1074: QP_PREQ_GRP.INSERT_LINE_ATTRS2(

1070: l_attrs_modif_level_code_tbl, l_attrs_primary_uom_flag_tbl
1071: LIMIT rows;
1072:
1073: IF l_attrs_line_index_tbl.count > 0 THEN
1074: QP_PREQ_GRP.INSERT_LINE_ATTRS2(
1075: p_LINE_INDEX_tbl => l_attrs_line_index_tbl,
1076: p_LINE_DETAIL_INDEX_tbl => l_attrs_line_detail_index_tbl,
1077: p_ATTRIBUTE_LEVEL_tbl => l_attrs_attribute_level_tbl,
1078: p_ATTRIBUTE_TYPE_tbl => l_attrs_attribute_type_tbl,

Line 1151: l_control_rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;

1147: p_parameter_code => 'QP_PRICE_BOOK_PRICING_EVENTS');
1148:
1149: fnd_file.put_line(FND_FILE.LOG, 'Pricing Events - '||l_pricing_events);
1150: --Set the l_control_rec field values
1151: l_control_rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
1152: l_control_rec.simulation_flag := 'Y';
1153: l_control_rec.pricing_event := l_pricing_events; --from pricing parameter
1154: l_control_rec.temp_table_insert_flag := 'N';
1155: l_control_rec.check_cust_view_flag := 'N'; --Find out what this is

Line 1377: decode(a.attribute_type, QP_PREQ_GRP.G_PRICING_TYPE,

1373: p_price_book_header_id price_book_header_id,
1374: a.context, a.attribute,
1375: a.comparison_operator_type_code, a.setup_value_from,
1376: a.setup_value_to, a.datatype,
1377: decode(a.attribute_type, QP_PREQ_GRP.G_PRICING_TYPE,
1378: 'PRICING_ATTRIBUTE', a.attribute_type) attribute_type
1379: FROM qp_preq_line_attrs_tmp a, qp_list_headers_vl b
1380: WHERE a.line_index = l_line_index2_tbl(k)
1381: AND a.line_detail_index = l_line_detail_index2_tbl(k)

Line 1384: AND a.attribute_type = QP_PREQ_GRP.G_PRICING_TYPE

1380: WHERE a.line_index = l_line_index2_tbl(k)
1381: AND a.line_detail_index = l_line_detail_index2_tbl(k)
1382: AND a.list_header_id = b.list_header_id
1383: AND b.list_type_code = 'PRL'
1384: AND a.attribute_type = QP_PREQ_GRP.G_PRICING_TYPE
1385: --Only pricing attributes
1386: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW) a;
1387:
1388: -- (08/03/06) Added distinct in the select statement above since the

Line 1386: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW) a;

1382: AND a.list_header_id = b.list_header_id
1383: AND b.list_type_code = 'PRL'
1384: AND a.attribute_type = QP_PREQ_GRP.G_PRICING_TYPE
1385: --Only pricing attributes
1386: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW) a;
1387:
1388: -- (08/03/06) Added distinct in the select statement above since the
1389: -- pricing engine creates multiple records for pricing attributes in
1390: -- the tmp table depending on the number of qualifier attributes

Line 1419: AND r.relationship_type_code = QP_PREQ_GRP.G_PBH_LINE -- just in case db goes to table before first condition

1415: FROM qp_preq_rltd_lines_tmp r, qp_preq_ldets_tmp b, qp_preq_line_attrs_tmp a
1416: WHERE l_list_line_type_code2_tbl(k) = 'PBH'
1417: AND r.line_index = l_line_index2_tbl(k)
1418: AND r.line_detail_index = l_line_detail_index2_tbl(k)
1419: AND r.relationship_type_code = QP_PREQ_GRP.G_PBH_LINE -- just in case db goes to table before first condition
1420: AND b.line_detail_index = r.related_line_detail_index
1421: AND a.line_detail_index = b.line_detail_index;
1422:
1423: fnd_file.put_line(FND_FILE.LOG, 'No of price breaks '||to_char(sql%rowcount));