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