APPS.QP_QP_FORM_MODIFIERS dependencies on QP_PRICING_ATTRIBUTES

Line 2557: FROM QP_PRICING_ATTRIBUTES

2553: , PRODUCT_ATTRIBUTE_DATATYPE
2554: , PRICING_ATTR_VALUE_FROM_NUMBER
2555: , PRICING_ATTR_VALUE_TO_NUMBER
2556: , QUALIFICATION_IND
2557: FROM QP_PRICING_ATTRIBUTES
2558: WHERE LIST_LINE_ID = p_list_line_id
2559: AND (( PRICING_ATTRIBUTE_CONTEXT IS NOT NULL
2560: AND PRICING_ATTRIBUTE_CONTEXT <> 'VOLUME')
2561: OR EXCLUDER_FLAG = 'Y')

Line 2611: FROM QP_PRICING_ATTRIBUTES

2607: , PRODUCT_ATTRIBUTE_DATATYPE
2608: , PRICING_ATTR_VALUE_FROM_NUMBER
2609: , PRICING_ATTR_VALUE_TO_NUMBER
2610: , QUALIFICATION_IND
2611: FROM QP_PRICING_ATTRIBUTES
2612: WHERE LIST_LINE_ID = p_list_line_id
2613: AND LIST_HEADER_ID = p_list_header_id;
2614:
2615: CURSOR l_QUALIFIER_csr(p_list_line_id Number) IS

Line 2682: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id

2678: FOR l_implicit_rec IN l_PRICING_ATTR_csr(p_old_list_line_id) LOOP
2679:
2680: oe_debug_pub.add('Inside pricing attribute cursor of line : '||p_new_list_line_id, 3);
2681:
2682: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id
2683: FROM dual;
2684:
2685: l_PRICING_ATTR_rec.accumulate_flag := l_implicit_rec.ACCUMULATE_FLAG;
2686: l_PRICING_ATTR_rec.attribute1 := l_implicit_rec.ATTRIBUTE1;

Line 2858: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id

2854: FOR l_implicit_attr_rec IN l_PRICING_ATTR_rltd_csr(l_implicit_rec.list_line_id) LOOP
2855:
2856: oe_debug_pub.add('Inside pricing attribute cursor of related modifier line : '||l_new_list_line_id, 3);
2857:
2858: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id
2859: FROM dual;
2860:
2861: l_PRICING_ATTR_rec.accumulate_flag := l_implicit_attr_rec.ACCUMULATE_FLAG;
2862: l_PRICING_ATTR_rec.attribute1 := l_implicit_attr_rec.ATTRIBUTE1;