APPS.QP_CATEGORY_MAPPING_RULE dependencies on QP_ATTR_MAPPING_PUB

Line 5: RETURN QP_Attr_Mapping_PUB.t_MultiRecord

1: PACKAGE BODY QP_CATEGORY_MAPPING_RULE AS
2: /* $Header: QPXPSICB.pls 120.7 2006/10/19 23:14:08 spgopal noship $ */
3:
4: FUNCTION Get_Item_Category (p_inventory_item_id IN NUMBER)
5: RETURN QP_Attr_Mapping_PUB.t_MultiRecord
6: IS
7:
8: --TYPE t_cursor IS REF CURSOR;
9:

Line 10: x_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;

6: IS
7:
8: --TYPE t_cursor IS REF CURSOR;
9:
10: x_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;
11: l_category_id VARCHAR2(30);
12: v_count NUMBER := 1;
13: --l_category_cursor t_cursor;
14: l_appl_id NUMBER;

Line 114: IF QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE = 'ONT' THEN

110: BEGIN
111:
112: l_appl_id := FND_GLOBAL.RESP_APPL_ID;
113:
114: IF QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE = 'ONT' THEN
115: --passing null org_id to OE_Sys_Parameters for moac so that it will return MASTER_ORGANIZATION_ID
116: --for the org_context set -- build_contexts API or calling app would have set 'single' org context
117: --added for moac to call oe_sys_params only when org_id is not null
118: l_ou_org_id := QP_UTIL.get_org_id;

Line 181: OPEN l_category_cursor(l_org_id,QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE);

177: end;
178: */
179: -- new changes for product heirarchy starts here
180: If qp_util.get_qp_status <>'I' THEN -- Basic pricing
181: OPEN l_category_cursor(l_org_id,QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE);
182: LOOP
183: FETCH l_category_cursor INTO l_category_id;
184: EXIT WHEN l_category_cursor%NOTFOUND;
185:

Line 192: OPEN l_exploded_category_cursor(l_org_id, QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE);

188: END LOOP;
189: CLOSE l_category_cursor;
190:
191: ELSE -- Advanced pricing has product heirarchy feature
192: OPEN l_exploded_category_cursor(l_org_id, QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE);
193: LOOP
194: FETCH l_exploded_category_cursor INTO l_category_id;
195: EXIT WHEN l_exploded_category_cursor%NOTFOUND;
196:

Line 201: OPEN l_category_cursor(l_org_id,QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE);

197: x_category_ids(v_count) := l_category_id;
198: v_count := v_count + 1;
199: END LOOP;
200: CLOSE l_exploded_category_cursor;
201: OPEN l_category_cursor(l_org_id,QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE);
202: LOOP
203: FETCH l_category_cursor INTO l_category_id;
204: EXIT WHEN l_category_cursor%NOTFOUND;
205: