APPS.QP_QP_FORM_MODIFIERS dependencies on QP_PRICING_ATTRIBUTES

Line 2594: FROM QP_PRICING_ATTRIBUTES

2590: , PRODUCT_ATTRIBUTE_DATATYPE
2591: , PRICING_ATTR_VALUE_FROM_NUMBER
2592: , PRICING_ATTR_VALUE_TO_NUMBER
2593: , QUALIFICATION_IND
2594: FROM QP_PRICING_ATTRIBUTES
2595: WHERE LIST_LINE_ID = p_list_line_id
2596: AND (( PRICING_ATTRIBUTE_CONTEXT IS NOT NULL
2597: AND PRICING_ATTRIBUTE_CONTEXT <> 'VOLUME')
2598: OR EXCLUDER_FLAG = 'Y')

Line 2648: FROM QP_PRICING_ATTRIBUTES

2644: , PRODUCT_ATTRIBUTE_DATATYPE
2645: , PRICING_ATTR_VALUE_FROM_NUMBER
2646: , PRICING_ATTR_VALUE_TO_NUMBER
2647: , QUALIFICATION_IND
2648: FROM QP_PRICING_ATTRIBUTES
2649: WHERE LIST_LINE_ID = p_list_line_id
2650: AND LIST_HEADER_ID = p_list_header_id;
2651:
2652: CURSOR l_QUALIFIER_csr(p_list_line_id Number) IS

Line 2719: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id

2715: FOR l_implicit_rec IN l_PRICING_ATTR_csr(p_old_list_line_id) LOOP
2716:
2717: oe_debug_pub.add('Inside pricing attribute cursor of line : '||p_new_list_line_id, 3);
2718:
2719: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id
2720: FROM dual;
2721:
2722: l_PRICING_ATTR_rec.accumulate_flag := l_implicit_rec.ACCUMULATE_FLAG;
2723: l_PRICING_ATTR_rec.attribute1 := l_implicit_rec.ATTRIBUTE1;

Line 2896: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id

2892: FOR l_implicit_attr_rec IN l_PRICING_ATTR_rltd_csr(l_implicit_rec.list_line_id) LOOP
2893:
2894: oe_debug_pub.add('Inside pricing attribute cursor of related modifier line : '||l_new_list_line_id, 3);
2895:
2896: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id
2897: FROM dual;
2898:
2899: l_PRICING_ATTR_rec.accumulate_flag := l_implicit_attr_rec.ACCUMULATE_FLAG;
2900: l_PRICING_ATTR_rec.attribute1 := l_implicit_attr_rec.ATTRIBUTE1;