eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ITEM_CATEGORY_PUB dependencies on MTL_CATEGORY_SETS_B

Line 47: l_hierarchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE := NULL;

43: -- returns FALSE if the category_set_id is invalid
44: -- returns the hierarchy through the out parameter
45: --
46: -- END OF comments
47: l_hierarchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE := NULL;
48: BEGIN
49: IF p_category_set_id IS NULL THEN
50: RETURN FALSE;
51: END IF;

Line 53: FROM mtl_category_sets_b

49: IF p_category_set_id IS NULL THEN
50: RETURN FALSE;
51: END IF;
52: SELECT hierarchy_enabled INTO l_hierarchy_enabled
53: FROM mtl_category_sets_b
54: WHERE category_set_id = p_category_set_id;
55: IF (SQL%FOUND) THEN
56: x_hierarchy_enabled := l_hierarchy_enabled;
57: END IF;

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 183: ,mtl_category_sets_b cs

179: BEGIN
180: SELECT csv.category_id, cs.hierarchy_enabled
181: INTO l_category_id, x_hrchy_enabled
182: FROM mtl_category_set_valid_cats csv
183: ,mtl_category_sets_b cs
184: WHERE csv.category_id = p_category_id
185: AND csv.category_set_id = p_category_set_id
186: AND cs.category_set_id = csv.category_set_id;
187: IF (SQL%FOUND) THEN

Line 224: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;

220: -- END OF comments
221: l_api_name VARCHAR2(30) := 'Validate Params';
222: l_count NUMBER;
223: l_valid BOOLEAN := TRUE;
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;

Line 226: l_hierarchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE := NULL;

222: l_count NUMBER;
223: l_valid BOOLEAN := TRUE;
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

Line 241: FROM mtl_category_sets_b cat_sets

237:
238: CURSOR c_get_default_category_id (cp_category_set_id IN NUMBER
239: ,cp_category_id IN NUMBER) IS
240: SELECT default_category_id
241: FROM mtl_category_sets_b cat_sets
242: WHERE cat_sets.category_set_id = cp_category_set_id
243: AND cat_sets.default_category_id = cp_category_id;
244:
245: CURSOR c_check_item_assocs (cp_category_set_id IN NUMBER

Line 2178: FROM mtl_category_sets_b

2174: SELECT 'x'
2175: FROM dual
2176: WHERE exists
2177: ( SELECT default_category_id
2178: FROM mtl_category_sets_b
2179: WHERE default_category_id = p_category_id
2180: );
2181:
2182:

Line 3147: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;

3143: l_count NUMBER;
3144: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3145: l_description mtl_categories_vl.description%TYPE;
3146: l_category_id mtl_category_set_valid_cats.category_id%TYPE;
3147: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;
3148: l_hrchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE;
3149:
3150: CURSOR c_get_cat_desc (cp_category_id IN NUMBER) IS
3151: SELECT description

Line 3148: l_hrchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE;

3144: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3145: l_description mtl_categories_vl.description%TYPE;
3146: l_category_id mtl_category_set_valid_cats.category_id%TYPE;
3147: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;
3148: l_hrchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE;
3149:
3150: CURSOR c_get_cat_desc (cp_category_id IN NUMBER) IS
3151: SELECT description
3152: FROM mtl_categories_vl

Line 3186: FROM mtl_category_sets_b cat_sets

3182: --Added for bug 5219692
3183: CURSOR c_check_default_cat (cp_category_id IN NUMBER
3184: ,cp_category_set_id IN NUMBER) IS
3185: SELECT cat_sets.default_category_id
3186: FROM mtl_category_sets_b cat_sets
3187: WHERE cat_sets.category_set_id = p_category_set_id
3188: AND cat_sets.default_category_id = p_category_id
3189: AND NVL(cat_sets.validate_flag,'N') = 'Y';
3190:

Line 3194: FROM mtl_category_sets_b cat_sets

3190:
3191: CURSOR c_check_default_cat_hrchy (cp_category_id IN NUMBER
3192: ,cp_category_set_id IN NUMBER) IS
3193: SELECT cat_sets.default_category_id
3194: FROM mtl_category_sets_b cat_sets
3195: WHERE cat_sets.category_set_id = p_category_set_id
3196: AND EXISTS
3197: (SELECT 'X'
3198: FROM mtl_category_set_valid_cats check_cats