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.11 2011/03/07 11:31:51 jputta ship $ */
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:
12: --8805312
13: l_int_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;
14:

Line 13: l_int_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;

9:
10: x_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;
11:
12: --8805312
13: l_int_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;
14:
15: l_category_id VARCHAR2(30);
16: v_count NUMBER := 1;
17: --l_category_cursor t_cursor;

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

172: BEGIN
173:
174: l_appl_id := FND_GLOBAL.RESP_APPL_ID;
175:
176: IF QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE = 'ONT' THEN
177: --passing null org_id to OE_Sys_Parameters for moac so that it will return MASTER_ORGANIZATION_ID
178: --for the org_context set -- build_contexts API or calling app would have set 'single' org context
179: --added for moac to call oe_sys_params only when org_id is not null
180: l_ou_org_id := QP_UTIL.get_org_id;

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

239: end;
240: */
241: -- new changes for product heirarchy starts here
242: If qp_util.get_qp_status <>'I' THEN -- Basic pricing
243: OPEN l_category_cursor(l_org_id,QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE);
244: LOOP
245: FETCH l_category_cursor INTO l_category_id;
246: EXIT WHEN l_category_cursor%NOTFOUND;
247:

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

250: END LOOP;
251: CLOSE l_category_cursor;
252:
253: ELSE -- Advanced pricing has product heirarchy feature
254: OPEN l_exploded_category_cursor(l_org_id, QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE);
255: LOOP
256:
257: --bug 8805312
258: -- Commented code to do bulk collect instead of individual fetches.

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

277: --end
278:
279: END LOOP;
280: CLOSE l_exploded_category_cursor;
281: OPEN l_category_cursor(l_org_id,QP_ATTR_MAPPING_PUB.G_REQ_TYPE_CODE);
282: LOOP
283:
284: --bug 8805312
285: -- Commented code to do bulk collect instead of individual fetches.