APPS.INV_ITEM_CATEGORY_PUB dependencies on MTL_CATEGORIES_B

Line 87: FROM mtl_categories_b cat, mtl_category_sets_b cat_set

83:
84: CURSOR c_validate_category_id (cp_category_id IN NUMBER
85: ,cp_cat_set_id IN NUMBER) IS
86: SELECT cat.category_id
87: FROM mtl_categories_b cat, mtl_category_sets_b cat_set
88: WHERE cat_set.category_set_id = cp_cat_set_id
89: AND cat_set.structure_id = cat.structure_id
90: AND cat.category_id = cp_category_id
91: AND ((cat.enabled_flag = 'Y'

Line 99: l_category_id mtl_categories_b.category_id%TYPE;

95: OR NVL(g_eni_upgarde_flag,'N') = 'Y' --Added for ENI 11.5.10 Upgrade
96: )
97: ;
98:
99: l_category_id mtl_categories_b.category_id%TYPE;
100:
101: BEGIN
102: OPEN c_validate_category_id (cp_category_id => p_category_id
103: ,cp_cat_set_id => p_category_set_id);

Line 139: l_category_id mtl_categories_b.category_id%TYPE;

135: -- returns TRUE if record exists
136: -- returns FALSE if record does not exist
137: --
138: -- END OF comments
139: l_category_id mtl_categories_b.category_id%TYPE;
140:
141: BEGIN
142: SELECT category_id
143: INTO l_category_id

Line 177: l_category_id mtl_categories_b.category_id%TYPE;

173: -- Also populates the out variable with
174: -- value of column hierarchy_enabled
175: --
176: -- END OF comments
177: l_category_id mtl_categories_b.category_id%TYPE;
178:
179: BEGIN
180: SELECT csv.category_id, cs.hierarchy_enabled
181: INTO l_category_id, x_hrchy_enabled

Line 228: l_category_id mtl_categories_b.category_id%TYPE;

224: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;
225: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
226: l_hierarchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE := NULL;
227: l_loop_may_occur BOOLEAN := FALSE;
228: l_category_id mtl_categories_b.category_id%TYPE;
229:
230: CURSOR c_check_loops (cp_parent_category_id IN NUMBER
231: ,cp_category_set_id IN NUMBER) IS
232: SELECT category_id

Line 395: mdebug('Validate Params: Parent category id is valid in mtl_categories_b ');

391: fnd_msg_pub.ADD;
392: RAISE fnd_api.g_EXC_ERROR;
393: END IF;
394: IF l_debug = 1 THEN
395: mdebug('Validate Params: Parent category id is valid in mtl_categories_b ');
396: END IF;
397: --
398: -- the parent category cannot be the default category
399: --

Line 567: FROM mtl_categories_b

563: AND enabled_flag = 'Y';
564:
565: CURSOR get_category_structure_id(p_category_id NUMBER) IS
566: SELECT structure_id
567: FROM mtl_categories_b
568: WHERE category_id = p_category_id;
569:
570: CURSOR validate_structure_id(p_structure_id VARCHAR) IS
571: SELECT 'x'

Line 2256: delete from mtl_categories_b

2252: END IF;
2253: RAISE NO_DATA_FOUND;
2254: end if;
2255:
2256: delete from mtl_categories_b
2257: where category_id = p_category_id ;
2258:
2259: if (sql%notfound) then
2260: fnd_message.set_name('INV','INV_VALID_CAT');

Line 2263: mdebug('Trying to delete non-existant Category Id from MTL_CATEGORIES_B.');

2259: if (sql%notfound) then
2260: fnd_message.set_name('INV','INV_VALID_CAT');
2261: fnd_msg_pub.ADD;
2262: IF (l_debug = 1) THEN
2263: mdebug('Trying to delete non-existant Category Id from MTL_CATEGORIES_B.');
2264: END IF;
2265: RAISE NO_DATA_FOUND;
2266: end if;
2267: