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_VIEW_UTIL dependencies on QP_PRICING_ATTRIBUTES

Line 34: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;

30: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
31: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
32: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
33:
34: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
35: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
37: v_product_attribute_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
38: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;

Line 35: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;

31: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
32: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
33:
34: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
35: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
37: v_product_attribute_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
38: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
39: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;

Line 36: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;

32: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
33:
34: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
35: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
37: v_product_attribute_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
38: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
39: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
40:

Line 37: v_product_attribute_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;

33:
34: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
35: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
37: v_product_attribute_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
38: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
39: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
40:
41:

Line 38: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;

34: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
35: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
37: v_product_attribute_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
38: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
39: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
40:
41:
42: BEGIN

Line 39: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;

35: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
37: v_product_attribute_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
38: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
39: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
40:
41:
42: BEGIN
43:

Line 80: from QP_PRICING_ATTRIBUTES

76: BEGIN
77:
78: select PRODUCT_ATTRIBUTE_CONTEXT, PRODUCT_ATTRIBUTE
79: into v_product_attribute_context, v_product_attribute
80: from QP_PRICING_ATTRIBUTES
81: where LIST_LINE_ID = p_list_line_id
82: and ( (PRODUCT_ATTRIBUTE_CONTEXT = l_item_no_context
83: and PRODUCT_ATTRIBUTE = l_item_no_attribute)
84: or (PRODUCT_ATTRIBUTE_CONTEXT = l_item_category_context

Line 118: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;

114: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
115: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
116: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
117:
118: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
119: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
120: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
121: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
122:

Line 119: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;

115: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
116: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
117:
118: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
119: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
120: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
121: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
122:
123: v_qualifier_attr_value QP_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE;

Line 120: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;

116: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
117:
118: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
119: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
120: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
121: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
122:
123: v_qualifier_attr_value QP_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE;
124: v_product_attr_value QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE;

Line 121: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;

117:
118: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
119: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
120: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
121: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
122:
123: v_qualifier_attr_value QP_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE;
124: v_product_attr_value QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE;
125:

Line 124: v_product_attr_value QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE;

120: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
121: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
122:
123: v_qualifier_attr_value QP_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE;
124: v_product_attr_value QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE;
125:
126:
127: BEGIN
128:

Line 157: from QP_PRICING_ATTRIBUTES

153:
154:
155: select PRODUCT_ATTR_VALUE
156: into v_product_attr_value
157: from QP_PRICING_ATTRIBUTES
158: where LIST_LINE_ID = p_list_line_id
159: and ( (PRODUCT_ATTRIBUTE_CONTEXT = l_item_no_context
160: and PRODUCT_ATTRIBUTE = l_item_no_attribute)
161: or (PRODUCT_ATTRIBUTE_CONTEXT = l_item_category_context

Line 183: from QP_PRICING_ATTRIBUTES

179:
180:
181: select PRODUCT_ATTR_VALUE
182: into v_product_attr_value
183: from QP_PRICING_ATTRIBUTES
184: where LIST_LINE_ID = p_list_line_id
185: and ( (PRODUCT_ATTRIBUTE_CONTEXT = l_item_no_context
186: and PRODUCT_ATTRIBUTE = l_item_no_attribute)
187: or (PRODUCT_ATTRIBUTE_CONTEXT = l_item_category_context

Line 199: v_pricing_attr_value_from QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_FROM%TYPE;

195: ) RETURN VARCHAR2 IS
196:
197: x_return VARCHAR2(1) :=FND_API.G_MISS_CHAR;
198:
199: v_pricing_attr_value_from QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_FROM%TYPE;
200: v_pricing_attr_value_to QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_TO%TYPE;
201:
202:
203: BEGIN

Line 200: v_pricing_attr_value_to QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_TO%TYPE;

196:
197: x_return VARCHAR2(1) :=FND_API.G_MISS_CHAR;
198:
199: v_pricing_attr_value_from QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_FROM%TYPE;
200: v_pricing_attr_value_to QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_TO%TYPE;
201:
202:
203: BEGIN
204:

Line 205: select 'X' into v_pricing_attr_value_to from qp_pricing_attributes

201:
202:
203: BEGIN
204:
205: select 'X' into v_pricing_attr_value_to from qp_pricing_attributes
206: where list_line_id = p_list_line_id and pricing_attr_value_to is not null;
207:
208: -- select X
209: -- PRICING_ATTR_VALUE_TO

Line 211: -- from QP_PRICING_ATTRIBUTES

207:
208: -- select X
209: -- PRICING_ATTR_VALUE_TO
210: -- into v_pricing_attr_value_to
211: -- from QP_PRICING_ATTRIBUTES
212: -- where LIST_LINE_ID = p_list_line_id;
213:
214:
215: x_return := 'Y';

Line 271: from QP_PRICING_ATTRIBUTES qpa

267: BEGIN
268:
269: select MIN(qpa.LIST_LINE_ID)
270: into x_return
271: from QP_PRICING_ATTRIBUTES qpa
272: where ATTRIBUTE_GROUPING_NO in ( select qpb.ATTRIBUTE_GROUPING_NO
273: from QP_PRICING_ATTRIBUTES qpb
274: where qpb.LIST_LINE_ID = p_list_line_id) ;
275:

Line 273: from QP_PRICING_ATTRIBUTES qpb

269: select MIN(qpa.LIST_LINE_ID)
270: into x_return
271: from QP_PRICING_ATTRIBUTES qpa
272: where ATTRIBUTE_GROUPING_NO in ( select qpb.ATTRIBUTE_GROUPING_NO
273: from QP_PRICING_ATTRIBUTES qpb
274: where qpb.LIST_LINE_ID = p_list_line_id) ;
275:
276: RETURN x_return;
277:

Line 371: -- For creating record in qp_pricing_attributes table with Units or Dollars for these qualifiers

367: -- Get the attribute and context for customer po
368: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);
369: x_product_flag := FALSE;
370: x_qualifier_flag := TRUE;
371: -- For creating record in qp_pricing_attributes table with Units or Dollars for these qualifiers
372: ELSIF (p_entity_id = G_QUALIFIER_ATTRIBUTE7 OR p_entity_id = G_NEW_QUALIFIER_ATTRIBUTE7) THEN
373: -- Get the attribute and context for order type
374: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);
375: x_product_flag := FALSE;

Line 377: -- For creating record in qp_pricing_attributes table with Units or Dollars for these qualifiers

373: -- Get the attribute and context for order type
374: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);
375: x_product_flag := FALSE;
376: x_qualifier_flag := TRUE;
377: -- For creating record in qp_pricing_attributes table with Units or Dollars for these qualifiers
378: ELSIF (p_entity_id = G_QUALIFIER_ATTRIBUTE8 OR p_entity_id = G_NEW_QUALIFIER_ATTRIBUTE8) THEN
379: -- Get the attribute and context for agreement type
380: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);
381: x_product_flag := FALSE;

Line 383: -- For creating record in qp_pricing_attributes table with Units or Dollars for these qualifiers

379: -- Get the attribute and context for agreement type
380: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);
381: x_product_flag := FALSE;
382: x_qualifier_flag := TRUE;
383: -- For creating record in qp_pricing_attributes table with Units or Dollars for these qualifiers
384: ELSIF (p_entity_id = G_QUALIFIER_ATTRIBUTE9 OR p_entity_id = G_NEW_QUALIFIER_ATTRIBUTE9) THEN
385: -- Get the attribute and context for agreement name
386: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);
387: x_product_flag := FALSE;