DBA Data[Home] [Help]

APPS.QP_VIEW_UTIL dependencies on QP_UTIL

Line 44: QP_UTIL.Get_Context_Attribute(1007,l_order_type_context,l_order_type_attribute);

40:
41:
42: BEGIN
43:
44: QP_UTIL.Get_Context_Attribute(1007,l_order_type_context,l_order_type_attribute);
45: QP_UTIL.Get_Context_Attribute(1004,l_customer_po_context,l_customer_po_attribute);
46: QP_UTIL.Get_Context_Attribute(1005,l_agreement_type_context,l_agreement_type_attribute);
47: QP_UTIL.Get_Context_Attribute(1006,l_agreement_name_context,l_agreement_name_attribute);
48:

Line 45: QP_UTIL.Get_Context_Attribute(1004,l_customer_po_context,l_customer_po_attribute);

41:
42: BEGIN
43:
44: QP_UTIL.Get_Context_Attribute(1007,l_order_type_context,l_order_type_attribute);
45: QP_UTIL.Get_Context_Attribute(1004,l_customer_po_context,l_customer_po_attribute);
46: QP_UTIL.Get_Context_Attribute(1005,l_agreement_type_context,l_agreement_type_attribute);
47: QP_UTIL.Get_Context_Attribute(1006,l_agreement_name_context,l_agreement_name_attribute);
48:
49:

Line 46: QP_UTIL.Get_Context_Attribute(1005,l_agreement_type_context,l_agreement_type_attribute);

42: BEGIN
43:
44: QP_UTIL.Get_Context_Attribute(1007,l_order_type_context,l_order_type_attribute);
45: QP_UTIL.Get_Context_Attribute(1004,l_customer_po_context,l_customer_po_attribute);
46: QP_UTIL.Get_Context_Attribute(1005,l_agreement_type_context,l_agreement_type_attribute);
47: QP_UTIL.Get_Context_Attribute(1006,l_agreement_name_context,l_agreement_name_attribute);
48:
49:
50: BEGIN

Line 47: QP_UTIL.Get_Context_Attribute(1006,l_agreement_name_context,l_agreement_name_attribute);

43:
44: QP_UTIL.Get_Context_Attribute(1007,l_order_type_context,l_order_type_attribute);
45: QP_UTIL.Get_Context_Attribute(1004,l_customer_po_context,l_customer_po_attribute);
46: QP_UTIL.Get_Context_Attribute(1005,l_agreement_type_context,l_agreement_type_attribute);
47: QP_UTIL.Get_Context_Attribute(1006,l_agreement_name_context,l_agreement_name_attribute);
48:
49:
50: BEGIN
51:

Line 73: QP_UTIL.Get_Context_Attribute(1001,l_item_no_context,l_item_no_attribute);

69:
70: EXCEPTION
71: when no_data_found then
72:
73: QP_UTIL.Get_Context_Attribute(1001,l_item_no_context,l_item_no_attribute);
74: QP_UTIL.Get_Context_Attribute(1045,l_item_category_context,l_item_category_attribute);
75:
76: BEGIN
77:

Line 74: QP_UTIL.Get_Context_Attribute(1045,l_item_category_context,l_item_category_attribute);

70: EXCEPTION
71: when no_data_found then
72:
73: QP_UTIL.Get_Context_Attribute(1001,l_item_no_context,l_item_no_attribute);
74: QP_UTIL.Get_Context_Attribute(1045,l_item_category_context,l_item_category_attribute);
75:
76: BEGIN
77:
78: select PRODUCT_ATTRIBUTE_CONTEXT, PRODUCT_ATTRIBUTE

Line 129: QP_UTIL.Get_Context_Attribute(1007,l_order_type_context,l_order_type_attribute);

125:
126:
127: BEGIN
128:
129: QP_UTIL.Get_Context_Attribute(1007,l_order_type_context,l_order_type_attribute);
130: QP_UTIL.Get_Context_Attribute(1004,l_customer_po_context,l_customer_po_attribute);
131: QP_UTIL.Get_Context_Attribute(1005,l_agreement_type_context,l_agreement_type_attribute);
132: QP_UTIL.Get_Context_Attribute(1006,l_agreement_name_context,l_agreement_name_attribute);
133:

Line 130: QP_UTIL.Get_Context_Attribute(1004,l_customer_po_context,l_customer_po_attribute);

126:
127: BEGIN
128:
129: QP_UTIL.Get_Context_Attribute(1007,l_order_type_context,l_order_type_attribute);
130: QP_UTIL.Get_Context_Attribute(1004,l_customer_po_context,l_customer_po_attribute);
131: QP_UTIL.Get_Context_Attribute(1005,l_agreement_type_context,l_agreement_type_attribute);
132: QP_UTIL.Get_Context_Attribute(1006,l_agreement_name_context,l_agreement_name_attribute);
133:
134:

Line 131: QP_UTIL.Get_Context_Attribute(1005,l_agreement_type_context,l_agreement_type_attribute);

127: BEGIN
128:
129: QP_UTIL.Get_Context_Attribute(1007,l_order_type_context,l_order_type_attribute);
130: QP_UTIL.Get_Context_Attribute(1004,l_customer_po_context,l_customer_po_attribute);
131: QP_UTIL.Get_Context_Attribute(1005,l_agreement_type_context,l_agreement_type_attribute);
132: QP_UTIL.Get_Context_Attribute(1006,l_agreement_name_context,l_agreement_name_attribute);
133:
134:
135: select QUALIFIER_ATTR_VALUE

Line 132: QP_UTIL.Get_Context_Attribute(1006,l_agreement_name_context,l_agreement_name_attribute);

128:
129: QP_UTIL.Get_Context_Attribute(1007,l_order_type_context,l_order_type_attribute);
130: QP_UTIL.Get_Context_Attribute(1004,l_customer_po_context,l_customer_po_attribute);
131: QP_UTIL.Get_Context_Attribute(1005,l_agreement_type_context,l_agreement_type_attribute);
132: QP_UTIL.Get_Context_Attribute(1006,l_agreement_name_context,l_agreement_name_attribute);
133:
134:
135: select QUALIFIER_ATTR_VALUE
136: into v_qualifier_attr_value

Line 151: QP_UTIL.Get_Context_Attribute(1001,l_item_no_context,l_item_no_attribute);

147:
148:
149: if v_qualifier_attr_value is null then
150:
151: QP_UTIL.Get_Context_Attribute(1001,l_item_no_context,l_item_no_attribute);
152: QP_UTIL.Get_Context_Attribute(1045,l_item_category_context,l_item_category_attribute);
153:
154:
155: select PRODUCT_ATTR_VALUE

Line 152: QP_UTIL.Get_Context_Attribute(1045,l_item_category_context,l_item_category_attribute);

148:
149: if v_qualifier_attr_value is null then
150:
151: QP_UTIL.Get_Context_Attribute(1001,l_item_no_context,l_item_no_attribute);
152: QP_UTIL.Get_Context_Attribute(1045,l_item_category_context,l_item_category_attribute);
153:
154:
155: select PRODUCT_ATTR_VALUE
156: into v_product_attr_value

Line 177: QP_UTIL.Get_Context_Attribute(1001,l_item_no_context,l_item_no_attribute);

173:
174:
175: exception
176: when no_data_found then
177: QP_UTIL.Get_Context_Attribute(1001,l_item_no_context,l_item_no_attribute);
178: QP_UTIL.Get_Context_Attribute(1045,l_item_category_context,l_item_category_attribute);
179:
180:
181: select PRODUCT_ATTR_VALUE

Line 178: QP_UTIL.Get_Context_Attribute(1045,l_item_category_context,l_item_category_attribute);

174:
175: exception
176: when no_data_found then
177: QP_UTIL.Get_Context_Attribute(1001,l_item_no_context,l_item_no_attribute);
178: QP_UTIL.Get_Context_Attribute(1045,l_item_category_context,l_item_category_attribute);
179:
180:
181: select PRODUCT_ATTR_VALUE
182: into v_product_attr_value

Line 236: QP_UTIL.Get_Context_Attribute('PRICE_LIST_ID',l_price_list_context,l_price_list_attribute);

232:
233:
234: BEGIN
235:
236: QP_UTIL.Get_Context_Attribute('PRICE_LIST_ID',l_price_list_context,l_price_list_attribute);
237:
238: x_return:= l_price_list_attribute;
239:
240: return x_return;

Line 254: QP_UTIL.Get_Context_Attribute('PRICE_LIST_ID',l_price_list_context,l_price_list_attribute);

250:
251:
252: BEGIN
253:
254: QP_UTIL.Get_Context_Attribute('PRICE_LIST_ID',l_price_list_context,l_price_list_attribute);
255:
256: x_return:= l_price_list_context;
257:
258: return x_return;

Line 358: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);

354: x_attribute := NULL;
355:
356: IF (p_entity_id = G_PRODUCT_ATTRIBUTE1 OR p_entity_id = G_NEW_PRODUCT_ATTRIBUTE1) THEN
357: -- Get the attribute and context for item
358: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);
359: x_product_flag := TRUE;
360: x_qualifier_flag := FALSE;
361: ELSIF (p_entity_id = G_PRODUCT_ATTRIBUTE2) THEN
362: -- Get the attribute and context for item category

Line 363: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);

359: x_product_flag := TRUE;
360: x_qualifier_flag := FALSE;
361: ELSIF (p_entity_id = G_PRODUCT_ATTRIBUTE2) THEN
362: -- Get the attribute and context for item category
363: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);
364: x_product_flag := TRUE;
365: x_qualifier_flag := FALSE;
366: ELSIF (p_entity_id = G_QUALIFIER_ATTRIBUTE6 OR p_entity_id = G_NEW_QUALIFIER_ATTRIBUTE6) THEN
367: -- Get the attribute and context for customer po

Line 368: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);

364: x_product_flag := TRUE;
365: x_qualifier_flag := FALSE;
366: ELSIF (p_entity_id = G_QUALIFIER_ATTRIBUTE6 OR p_entity_id = G_NEW_QUALIFIER_ATTRIBUTE6) THEN
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

Line 374: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);

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;
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

Line 380: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);

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;
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

Line 386: QP_UTIL.get_context_attribute(p_entity_id,x_context,x_attribute);

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;
388: x_qualifier_flag := TRUE;
389: -- For creating record in qp_pricing_ attributes table with Units or Dollars for these qualifiers
390: ELSE