APPS.QP_MASS_MAINTAIN_UTIL dependencies on QP_UTIL

Line 62: l_org_id := QP_UTIL.Get_Item_Validation_Org;

58: begin
59: if p_product_attr_context = 'ITEM' THEN
60: IF p_product_attr = 'PRICING_ATTRIBUTE1' THEN
61: l_Inventory_Item_Id := p_product_attr_val;
62: l_org_id := QP_UTIL.Get_Item_Validation_Org;
63:
64: select Description
65: into l_product_desc
66: From Mtl_System_Items_Vl

Line 77: QP_UTIL.Get_Attribute_Code('QP_ATTR_DEFNS_PRICING',

73: Into l_product_desc
74: From Mtl_categories_vl
75: Where category_id = l_category_id;
76: ELSE
77: QP_UTIL.Get_Attribute_Code('QP_ATTR_DEFNS_PRICING',
78: p_product_attr_context,
79: p_product_attr,
80: l_attribute_name,
81: l_segment_name);

Line 84: l_product_desc := QP_UTIL.Get_Attribute_Value_Meaning('QP_ATTR_DEFNS_PRICING',

80: l_attribute_name,
81: l_segment_name);
82: --dbms_output.put_line('l_segment_name = ' || l_segment_name);
83:
84: l_product_desc := QP_UTIL.Get_Attribute_Value_Meaning('QP_ATTR_DEFNS_PRICING',
85: p_product_attr_context,
86: l_segment_name,
87: p_product_attr_val,
88: '=');

Line 145: /* v_select_clause := 'select INVENTORY_ITEM_ID attribute_id, SEGMENT1 attribute_name, nvl(DESCRIPTION, SEGMENT1) attribute_meaning from MTL_SYSTEM_ITEMS_B where ORGANIZATION_ID = QP_UTIL.Get_Item_Validation_Org';*/

141: l_appl_id NUMBER;
142:
143: begin
144: if p_context_code = 'ITEM' AND p_segment_code = 'INVENTORY_ITEM_ID' then
145: /* v_select_clause := 'select INVENTORY_ITEM_ID attribute_id, SEGMENT1 attribute_name, nvl(DESCRIPTION, SEGMENT1) attribute_meaning from MTL_SYSTEM_ITEMS_B where ORGANIZATION_ID = QP_UTIL.Get_Item_Validation_Org';*/
146: -- fix for bug 6850999
147: v_select_clause := 'select INVENTORY_ITEM_ID attribute_id,concatenated_segments attribute_name,nvl(DESCRIPTION, concatenated_segments) attribute_meaning from MTL_SYSTEM_ITEMS_B_KFV where ORGANIZATION_ID = QP_UTIL.Get_Item_Validation_Org';
148: if p_pte = 'PO' then
149: v_select_clause := v_select_clause||' '||'AND PURCHASING_ITEM_FLAG = '||'''Y''';

Line 147: v_select_clause := 'select INVENTORY_ITEM_ID attribute_id,concatenated_segments attribute_name,nvl(DESCRIPTION, concatenated_segments) attribute_meaning from MTL_SYSTEM_ITEMS_B_KFV where ORGANIZATION_ID = QP_UTIL.Get_Item_Validation_Org';

143: begin
144: if p_context_code = 'ITEM' AND p_segment_code = 'INVENTORY_ITEM_ID' then
145: /* v_select_clause := 'select INVENTORY_ITEM_ID attribute_id, SEGMENT1 attribute_name, nvl(DESCRIPTION, SEGMENT1) attribute_meaning from MTL_SYSTEM_ITEMS_B where ORGANIZATION_ID = QP_UTIL.Get_Item_Validation_Org';*/
146: -- fix for bug 6850999
147: v_select_clause := 'select INVENTORY_ITEM_ID attribute_id,concatenated_segments attribute_name,nvl(DESCRIPTION, concatenated_segments) attribute_meaning from MTL_SYSTEM_ITEMS_B_KFV where ORGANIZATION_ID = QP_UTIL.Get_Item_Validation_Org';
148: if p_pte = 'PO' then
149: v_select_clause := v_select_clause||' '||'AND PURCHASING_ITEM_FLAG = '||'''Y''';
150: end if;
151: x_select_stmt := 'Select * from (' || v_select_clause || ') AVVO';

Line 206: v_select_clause := v_select_clause || ' ' || QP_UTIL.merge_fnarea_where_clause(v_table_r.WHERE_CLAUSE, p_pte, p_ss);

202:
203: if v_table_r.WHERE_CLAUSE is not null then
204: -- Hierarchical Categories where clause addition (sfiresto)
205: if p_context_code = 'ITEM' AND p_segment_code = 'ITEM_CATEGORY' then
206: v_select_clause := v_select_clause || ' ' || QP_UTIL.merge_fnarea_where_clause(v_table_r.WHERE_CLAUSE, p_pte, p_ss);
207: else
208: v_select_clause := v_select_clause || ' ' || v_table_r.WHERE_CLAUSE;
209: end if;
210: end if;