APPS.QP_PRICING_ENGINE_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 34: v_product_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;

30: v_index NUMBER;
31: err_num NUMBER;
32: err_msg VARCHAR2(100);
33:
34: v_product_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
35: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
37: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
38: v_customer_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

Line 35: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;

31: err_num NUMBER;
32: err_msg VARCHAR2(100);
33:
34: v_product_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
35: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
37: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
38: v_customer_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
39: v_customer_class_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

Line 92: FROM QP_LIST_LINES qpl, QP_PRICING_ATTRIBUTES qpbl

88: (p_list_line_id NUMBER,p_product_attribute_context VARCHAR2,p_product_attribute VARCHAR2,
89: p_qualifier_context VARCHAR2 , p_qualifier_attribute VARCHAR2 ) IS
90:
91: SELECT 'X'
92: FROM QP_LIST_LINES qpl, QP_PRICING_ATTRIBUTES qpbl
93: WHERE qpl.LIST_LINE_ID = p_list_line_id
94: AND qpl.LIST_LINE_ID = qpbl.LIST_LINE_ID
95: AND qpbl.PRODUCT_ATTRIBUTE_CONTEXT = p_product_attribute_context
96: AND qpbl.PRODUCT_ATTRIBUTE = p_product_attribute

Line 118: FROM QP_PRICING_ATTRIBUTES qpbl , QP_RLTD_MODIFIERS qprl, QP_LIST_LINES qpl

114: p_qualifier_context VARCHAR2 , p_qualifier_attribute VARCHAR2 ) IS
115:
116: SELECT qpbl.PRICING_ATTRIBUTE_ID,qpbl.LIST_LINE_ID,qpbl.PRICING_ATTRIBUTE_CONTEXT,qpbl.PRICING_ATTRIBUTE,
117: qpbl.PRICING_ATTR_VALUE_FROM, qpbl.PRICING_ATTR_VALUE_TO,qpl.OPERAND , qpl.ARITHMETIC_OPERATOR
118: FROM QP_PRICING_ATTRIBUTES qpbl , QP_RLTD_MODIFIERS qprl, QP_LIST_LINES qpl
119: WHERE qpl.LIST_LINE_ID = qpbl.LIST_LINE_ID
120: AND qpbl.LIST_LINE_ID = qprl.TO_RLTD_MODIFIER_ID
121: AND qpbl.PRODUCT_ATTRIBUTE_CONTEXT = p_product_attribute_context
122: AND qpbl.PRODUCT_ATTRIBUTE = p_product_attribute

Line 131: FROM QP_PRICING_ATTRIBUTES qpbl , QP_LIST_LINES qpl, QP_QUALIFIERS qpq, QP_RLTD_MODIFIERS qprl

127: AND nvl(qpl.END_DATE_ACTIVE,trunc(p_pricing_date))
128: UNION
129: SELECT qpbl.PRICING_ATTRIBUTE_ID,qpbl.LIST_LINE_ID,qpbl.PRICING_ATTRIBUTE_CONTEXT,qpbl.PRICING_ATTRIBUTE,
130: qpbl.PRICING_ATTR_VALUE_FROM, qpbl.PRICING_ATTR_VALUE_TO,qpl.OPERAND , qpl.ARITHMETIC_OPERATOR
131: FROM QP_PRICING_ATTRIBUTES qpbl , QP_LIST_LINES qpl, QP_QUALIFIERS qpq, QP_RLTD_MODIFIERS qprl
132: WHERE qpq.LIST_LINE_ID = p_list_line_id
133: AND qpq.QUALIFIER_CONTEXT = p_qualifier_context
134: AND qpq.QUALIFIER_ATTRIBUTE = p_qualifier_attribute
135: AND qpq.QUALIFIER_ATTR_VALUE = p_attribute_value