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_SET_VALID_CATS

Line 123: -- Supporting method to validate record in mtl_category_set_valid_cats

119:
120: ----------------------------------------------------------------------------
121: -- valid_category_set_record
122: -- Bug: 3093555
123: -- Supporting method to validate record in mtl_category_set_valid_cats
124: ----------------------------------------------------------------------------
125: FUNCTION valid_category_set_record (p_category_set_id IN NUMBER
126: ,p_category_id IN NUMBER)
127: RETURN BOOLEAN IS

Line 134: -- mtl_category_set_valid_cats

130: -- TYPE : Private
131: -- Called From : Delete_Valid_Category, Update_valid_category
132: -- Pre-reqs : None
133: -- FUNCTION : Validates whether the record exists in
134: -- mtl_category_set_valid_cats
135: -- returns TRUE if record exists
136: -- returns FALSE if record does not exist
137: --
138: -- END OF comments

Line 144: FROM mtl_category_set_valid_cats

140:
141: BEGIN
142: SELECT category_id
143: INTO l_category_id
144: FROM mtl_category_set_valid_cats
145: WHERE category_id = p_category_id
146: AND category_set_id = p_category_set_id;
147: IF (SQL%FOUND) THEN
148: RETURN TRUE;

Line 160: -- Supporting method to validate record in mtl_category_set_valid_cats

156:
157: ----------------------------------------------------------------------------
158: -- get_category_set_type
159: -- Bug: 5219692
160: -- Supporting method to validate record in mtl_category_set_valid_cats
161: -- Function is similar to valid_category_set_record
162: -- Returns FALSE if the row does not exist
163: ----------------------------------------------------------------------------
164: FUNCTION get_category_set_type (p_category_set_id IN NUMBER

Line 170: -- mtl_category_set_valid_cats

166: ,x_hrchy_enabled OUT NOCOPY VARCHAR2)
167: RETURN BOOLEAN IS
168: -- Start OF comments
169: -- FUNCTION : Validates whether the record exists in
170: -- mtl_category_set_valid_cats
171: -- returns TRUE if record exists
172: -- returns FALSE if record does not exist
173: -- Also populates the out variable with
174: -- value of column hierarchy_enabled

Line 182: FROM mtl_category_set_valid_cats csv

178:
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;

Line 233: FROM mtl_category_set_valid_cats

229:
230: CURSOR c_check_loops (cp_parent_category_id IN NUMBER
231: ,cp_category_set_id IN NUMBER) IS
232: SELECT category_id
233: FROM mtl_category_set_valid_cats
234: WHERE category_set_id = cp_category_set_id
235: CONNECT BY prior category_id = parent_category_id
236: START WITH parent_category_id = cp_parent_category_id;
237:

Line 315: -- The record must exist in mtl_category_set_valid_cats

311: IF l_debug = 1 THEN
312: mdebug('Validate Params: check for Update ');
313: END IF;
314: --
315: -- The record must exist in mtl_category_set_valid_cats
316: --
317: IF NOT valid_category_set_record (p_category_set_id => p_category_set_id
318: ,p_category_id => p_category_id) THEN
319:

Line 329: mdebug('Validate Params: Record exists in mtl_category_set_valid_cats ');

325: fnd_msg_pub.ADD;
326: RAISE fnd_api.g_EXC_ERROR;
327: END IF;
328: IF l_debug = 1 THEN
329: mdebug('Validate Params: Record exists in mtl_category_set_valid_cats ');
330: END IF;
331: --
332: -- The new parent category should not create any hierarchical loops
333: -- to be validated for Update only

Line 2188: FROM mtl_category_set_valid_cats

2184: SELECT 'x'
2185: FROM dual
2186: WHERE exists
2187: ( SELECT category_id
2188: FROM mtl_category_set_valid_cats
2189: WHERE category_id = p_category_id
2190: );
2191:
2192:

Line 2791: -- FUNCTION : Create a record in mtl_category_set_valid_cats.

2787: -- Start OF comments
2788: -- API name : Create_Valid_Category
2789: -- TYPE : Public
2790: -- Pre-reqs : None
2791: -- FUNCTION : Create a record in mtl_category_set_valid_cats.
2792: --
2793: -- Version: Current Version 1.0
2794: -- Previous Version : None
2795: -- Notes : Stub Version

Line 2806: l_user_id mtl_category_set_valid_cats.created_by%TYPE;

2802: -- to change i.e. for eg. X.6 to X.7.
2803: l_api_version CONSTANT NUMBER := 1.0;
2804: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2805: -- who column variables
2806: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2807: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2808: l_request_id mtl_category_set_valid_cats.request_id%TYPE;
2809: l_prog_appl_id mtl_category_set_valid_cats.program_application_id%TYPE;
2810: l_program_id mtl_category_set_valid_cats.program_id%TYPE;

Line 2807: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;

2803: l_api_version CONSTANT NUMBER := 1.0;
2804: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2805: -- who column variables
2806: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2807: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2808: l_request_id mtl_category_set_valid_cats.request_id%TYPE;
2809: l_prog_appl_id mtl_category_set_valid_cats.program_application_id%TYPE;
2810: l_program_id mtl_category_set_valid_cats.program_id%TYPE;
2811: BEGIN

Line 2808: l_request_id mtl_category_set_valid_cats.request_id%TYPE;

2804: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2805: -- who column variables
2806: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2807: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2808: l_request_id mtl_category_set_valid_cats.request_id%TYPE;
2809: l_prog_appl_id mtl_category_set_valid_cats.program_application_id%TYPE;
2810: l_program_id mtl_category_set_valid_cats.program_id%TYPE;
2811: BEGIN
2812: IF l_debug = 1 THEN

Line 2809: l_prog_appl_id mtl_category_set_valid_cats.program_application_id%TYPE;

2805: -- who column variables
2806: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2807: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2808: l_request_id mtl_category_set_valid_cats.request_id%TYPE;
2809: l_prog_appl_id mtl_category_set_valid_cats.program_application_id%TYPE;
2810: l_program_id mtl_category_set_valid_cats.program_id%TYPE;
2811: BEGIN
2812: IF l_debug = 1 THEN
2813: mdebug('Create_Valid_Category: Tracing...1');

Line 2810: l_program_id mtl_category_set_valid_cats.program_id%TYPE;

2806: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2807: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2808: l_request_id mtl_category_set_valid_cats.request_id%TYPE;
2809: l_prog_appl_id mtl_category_set_valid_cats.program_application_id%TYPE;
2810: l_program_id mtl_category_set_valid_cats.program_id%TYPE;
2811: BEGIN
2812: IF l_debug = 1 THEN
2813: mdebug('Create_Valid_Category: Tracing...1');
2814: END IF;

Line 2852: INSERT INTO mtl_category_set_valid_cats

2848: END IF;
2849: l_request_id := fnd_global.conc_request_id;
2850: l_prog_appl_id := fnd_global.prog_appl_id;
2851: l_program_id := fnd_global.conc_program_id;
2852: INSERT INTO mtl_category_set_valid_cats
2853: ( category_set_id
2854: , category_id
2855: , parent_category_id
2856: , created_by

Line 2971: -- FUNCTION : Update record in mtl_category_set_valid_cats.

2967: -- Start OF comments
2968: -- API name : Update_Valid_Category
2969: -- TYPE : Public
2970: -- Pre-reqs : None
2971: -- FUNCTION : Update record in mtl_category_set_valid_cats.
2972: --
2973: -- Version: Current Version 1.0
2974: -- Previous Version : None
2975: -- Notes : Stub Version

Line 2985: l_user_id mtl_category_set_valid_cats.created_by%TYPE;

2981: -- On addition of any Optional parameters the minor version needs
2982: -- to change i.e. for eg. X.6 to X.7.
2983: l_api_version CONSTANT NUMBER := 1.0;
2984: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2985: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2986: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2987: BEGIN
2988: IF l_debug = 1 THEN
2989: mdebug('Update_Valid_Category: Tracing...1');

Line 2986: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;

2982: -- to change i.e. for eg. X.6 to X.7.
2983: l_api_version CONSTANT NUMBER := 1.0;
2984: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2985: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2986: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2987: BEGIN
2988: IF l_debug = 1 THEN
2989: mdebug('Update_Valid_Category: Tracing...1');
2990: END IF;

Line 3026: UPDATE mtl_category_set_valid_cats

3022: END IF;
3023: IF l_debug = 1 THEN
3024: mdebug('Update_Valid_Category: About to update the category record');
3025: END IF;
3026: UPDATE mtl_category_set_valid_cats
3027: SET parent_category_id = p_parent_category_id
3028: ,last_updated_by = l_user_id
3029: ,last_update_date = SYSDATE
3030: ,last_update_login = l_login_id

Line 3130: -- FUNCTION : Delete the record from mtl_category_set_valid_cats.

3126: -- Start OF comments
3127: -- API name : Delete_Valid_Category
3128: -- TYPE : Public
3129: -- Pre-reqs : None
3130: -- FUNCTION : Delete the record from mtl_category_set_valid_cats.
3131: --
3132: -- Version: Current Version 1.0
3133: -- Previous Version : None
3134: -- Notes : Stub Version

Line 3146: l_category_id mtl_category_set_valid_cats.category_id%TYPE;

3142: l_api_version CONSTANT NUMBER := 1.0;
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

Line 3167: FROM mtl_category_set_valid_cats valid_cats

3163:
3164: CURSOR c_get_items_in_cat_hrchy (cp_category_id IN NUMBER
3165: ,cp_category_set_id IN NUMBER) IS
3166: SELECT valid_cats.category_id
3167: FROM mtl_category_set_valid_cats valid_cats
3168: WHERE EXISTS
3169: (SELECT 'X'
3170: FROM mtl_item_categories item_cat
3171: WHERE item_cat.category_id = valid_cats.category_id

Line 3198: FROM mtl_category_set_valid_cats check_cats

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
3199: WHERE check_cats.category_id = cat_sets.default_category_id
3200: CONNECT BY PRIOR
3201: check_cats.category_id = check_cats.parent_category_id
3202: AND check_cats.category_set_id = cp_category_set_id

Line 3314: DELETE mtl_category_set_valid_cats delete_cats

3310: mdebug('Delete_Valid_Category: No items associated! Delete now');
3311: END IF;
3312:
3313: IF UPPER(l_hrchy_enabled) = 'Y' THEN
3314: DELETE mtl_category_set_valid_cats delete_cats
3315: WHERE category_set_id = p_category_set_id
3316: AND EXISTS
3317: (SELECT 'X'
3318: FROM mtl_category_set_valid_cats

Line 3318: FROM mtl_category_set_valid_cats

3314: DELETE mtl_category_set_valid_cats delete_cats
3315: WHERE category_set_id = p_category_set_id
3316: AND EXISTS
3317: (SELECT 'X'
3318: FROM mtl_category_set_valid_cats
3319: WHERE category_id = delete_cats.category_id
3320: CONNECT BY PRIOR category_id = parent_category_id
3321: AND category_set_id = p_category_set_id
3322: START WITH category_id = p_category_id

Line 3326: DELETE mtl_category_set_valid_cats delete_cats

3322: START WITH category_id = p_category_id
3323: AND category_set_id = p_category_set_id
3324: );
3325: ELSE --Added else part for bug 5219692
3326: DELETE mtl_category_set_valid_cats delete_cats
3327: WHERE category_set_id = p_category_set_id
3328: AND category_id = p_category_id;
3329:
3330: END IF;