APPS.QP_CROSS_ORDER_VOLUME_LOAD dependencies on QP_UTIL

Line 284: AND qpa.product_attribute = qp_util.get_attribute_name('QP',

280: WHERE qlh.list_header_id = qpl.list_header_id
281: AND qpl.list_line_id = qpa.list_line_id
282: AND qlh.active_flag = 'Y'
283: AND qpa.product_attribute_context = 'ITEM'
284: AND qpa.product_attribute = qp_util.get_attribute_name('QP',
285: 'QP_ATTR_DEFNS_PRICING','ITEM','INVENTORY_ITEM_ID')
286: AND qpa.pricing_attribute_context = 'VOLUME'
287: AND ( qpa.pricing_attribute = l_period1_item_qty_attr
288: OR qpa.pricing_attribute = l_period2_item_qty_attr

Line 333: l_period1_item_qty_attr := qp_util.get_attribute_name ('QP',

329: l_ordr_vol_perd2 := to_number(FND_PROFILE.VALUE('QP_CROSS_ORDER_VOLUME_PERIOD2'));
330: l_ordr_vol_perd3 := to_number(FND_PROFILE.VALUE('QP_CROSS_ORDER_VOLUME_PERIOD3'));
331:
332: -- Get Attribute columns for Cross Order Pricing Attributes
333: l_period1_item_qty_attr := qp_util.get_attribute_name ('QP',
334: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD1_ITEM_QUANTITY');
335: l_period2_item_qty_attr := qp_util.get_attribute_name ('QP',
336: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD2_ITEM_QUANTITY');
337: l_period3_item_qty_attr := qp_util.get_attribute_name ('QP',

Line 335: l_period2_item_qty_attr := qp_util.get_attribute_name ('QP',

331:
332: -- Get Attribute columns for Cross Order Pricing Attributes
333: l_period1_item_qty_attr := qp_util.get_attribute_name ('QP',
334: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD1_ITEM_QUANTITY');
335: l_period2_item_qty_attr := qp_util.get_attribute_name ('QP',
336: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD2_ITEM_QUANTITY');
337: l_period3_item_qty_attr := qp_util.get_attribute_name ('QP',
338: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD3_ITEM_QUANTITY');
339: l_period1_item_amt_attr := qp_util.get_attribute_name ('QP',

Line 337: l_period3_item_qty_attr := qp_util.get_attribute_name ('QP',

333: l_period1_item_qty_attr := qp_util.get_attribute_name ('QP',
334: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD1_ITEM_QUANTITY');
335: l_period2_item_qty_attr := qp_util.get_attribute_name ('QP',
336: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD2_ITEM_QUANTITY');
337: l_period3_item_qty_attr := qp_util.get_attribute_name ('QP',
338: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD3_ITEM_QUANTITY');
339: l_period1_item_amt_attr := qp_util.get_attribute_name ('QP',
340: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD1_ITEM_AMOUNT');
341: l_period2_item_amt_attr := qp_util.get_attribute_name ('QP',

Line 339: l_period1_item_amt_attr := qp_util.get_attribute_name ('QP',

335: l_period2_item_qty_attr := qp_util.get_attribute_name ('QP',
336: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD2_ITEM_QUANTITY');
337: l_period3_item_qty_attr := qp_util.get_attribute_name ('QP',
338: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD3_ITEM_QUANTITY');
339: l_period1_item_amt_attr := qp_util.get_attribute_name ('QP',
340: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD1_ITEM_AMOUNT');
341: l_period2_item_amt_attr := qp_util.get_attribute_name ('QP',
342: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD2_ITEM_AMOUNT');
343: l_period3_item_amt_attr := qp_util.get_attribute_name ('QP',

Line 341: l_period2_item_amt_attr := qp_util.get_attribute_name ('QP',

337: l_period3_item_qty_attr := qp_util.get_attribute_name ('QP',
338: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD3_ITEM_QUANTITY');
339: l_period1_item_amt_attr := qp_util.get_attribute_name ('QP',
340: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD1_ITEM_AMOUNT');
341: l_period2_item_amt_attr := qp_util.get_attribute_name ('QP',
342: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD2_ITEM_AMOUNT');
343: l_period3_item_amt_attr := qp_util.get_attribute_name ('QP',
344: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD3_ITEM_AMOUNT');
345:

Line 343: l_period3_item_amt_attr := qp_util.get_attribute_name ('QP',

339: l_period1_item_amt_attr := qp_util.get_attribute_name ('QP',
340: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD1_ITEM_AMOUNT');
341: l_period2_item_amt_attr := qp_util.get_attribute_name ('QP',
342: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD2_ITEM_AMOUNT');
343: l_period3_item_amt_attr := qp_util.get_attribute_name ('QP',
344: 'QP_ATTR_DEFNS_PRICING','VOLUME','PERIOD3_ITEM_AMOUNT');
345:
346:
347: IF (g_org_id IS NULL) OR (NOT l_multi_org_install)

Line 592: l_period1_order_amt_attr := qp_util.get_attribute_name ('QP',

588:
589: END IF;
590:
591: -- Get Attribute columns for Cross Order Qualifier Attributes
592: l_period1_order_amt_attr := qp_util.get_attribute_name ('QP',
593: 'QP_ATTR_DEFNS_QUALIFIER','VOLUME','PERIOD1_ORDER_AMOUNT');
594: l_period2_order_amt_attr := qp_util.get_attribute_name ('QP',
595: 'QP_ATTR_DEFNS_QUALIFIER','VOLUME','PERIOD2_ORDER_AMOUNT');
596: l_period3_order_amt_attr := qp_util.get_attribute_name ('QP',

Line 594: l_period2_order_amt_attr := qp_util.get_attribute_name ('QP',

590:
591: -- Get Attribute columns for Cross Order Qualifier Attributes
592: l_period1_order_amt_attr := qp_util.get_attribute_name ('QP',
593: 'QP_ATTR_DEFNS_QUALIFIER','VOLUME','PERIOD1_ORDER_AMOUNT');
594: l_period2_order_amt_attr := qp_util.get_attribute_name ('QP',
595: 'QP_ATTR_DEFNS_QUALIFIER','VOLUME','PERIOD2_ORDER_AMOUNT');
596: l_period3_order_amt_attr := qp_util.get_attribute_name ('QP',
597: 'QP_ATTR_DEFNS_QUALIFIER','VOLUME','PERIOD3_ORDER_AMOUNT');
598:

Line 596: l_period3_order_amt_attr := qp_util.get_attribute_name ('QP',

592: l_period1_order_amt_attr := qp_util.get_attribute_name ('QP',
593: 'QP_ATTR_DEFNS_QUALIFIER','VOLUME','PERIOD1_ORDER_AMOUNT');
594: l_period2_order_amt_attr := qp_util.get_attribute_name ('QP',
595: 'QP_ATTR_DEFNS_QUALIFIER','VOLUME','PERIOD2_ORDER_AMOUNT');
596: l_period3_order_amt_attr := qp_util.get_attribute_name ('QP',
597: 'QP_ATTR_DEFNS_QUALIFIER','VOLUME','PERIOD3_ORDER_AMOUNT');
598:
599: -- Check to see if Cross Order Volume Qualifiers have been used on Active Lists
600: