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 2169: FROM mtl_category_set_valid_cats

2165: SELECT 'x'
2166: FROM dual
2167: WHERE exists
2168: ( SELECT category_id
2169: FROM mtl_category_set_valid_cats
2170: WHERE category_id = p_category_id
2171: );
2172:
2173:

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

2708: -- Start OF comments
2709: -- API name : Create_Valid_Category
2710: -- TYPE : Public
2711: -- Pre-reqs : None
2712: -- FUNCTION : Create a record in mtl_category_set_valid_cats.
2713: --
2714: -- Version: Current Version 1.0
2715: -- Previous Version : None
2716: -- Notes : Stub Version

Line 2727: l_user_id mtl_category_set_valid_cats.created_by%TYPE;

2723: -- to change i.e. for eg. X.6 to X.7.
2724: l_api_version CONSTANT NUMBER := 1.0;
2725: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2726: -- who column variables
2727: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2728: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2729: l_request_id mtl_category_set_valid_cats.request_id%TYPE;
2730: l_prog_appl_id mtl_category_set_valid_cats.program_application_id%TYPE;
2731: l_program_id mtl_category_set_valid_cats.program_id%TYPE;

Line 2728: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;

2724: l_api_version CONSTANT NUMBER := 1.0;
2725: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2726: -- who column variables
2727: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2728: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2729: l_request_id mtl_category_set_valid_cats.request_id%TYPE;
2730: l_prog_appl_id mtl_category_set_valid_cats.program_application_id%TYPE;
2731: l_program_id mtl_category_set_valid_cats.program_id%TYPE;
2732: BEGIN

Line 2729: l_request_id mtl_category_set_valid_cats.request_id%TYPE;

2725: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2726: -- who column variables
2727: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2728: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2729: l_request_id mtl_category_set_valid_cats.request_id%TYPE;
2730: l_prog_appl_id mtl_category_set_valid_cats.program_application_id%TYPE;
2731: l_program_id mtl_category_set_valid_cats.program_id%TYPE;
2732: BEGIN
2733: IF l_debug = 1 THEN

Line 2730: l_prog_appl_id mtl_category_set_valid_cats.program_application_id%TYPE;

2726: -- who column variables
2727: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2728: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2729: l_request_id mtl_category_set_valid_cats.request_id%TYPE;
2730: l_prog_appl_id mtl_category_set_valid_cats.program_application_id%TYPE;
2731: l_program_id mtl_category_set_valid_cats.program_id%TYPE;
2732: BEGIN
2733: IF l_debug = 1 THEN
2734: mdebug('Create_Valid_Category: Tracing...1');

Line 2731: l_program_id mtl_category_set_valid_cats.program_id%TYPE;

2727: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2728: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2729: l_request_id mtl_category_set_valid_cats.request_id%TYPE;
2730: l_prog_appl_id mtl_category_set_valid_cats.program_application_id%TYPE;
2731: l_program_id mtl_category_set_valid_cats.program_id%TYPE;
2732: BEGIN
2733: IF l_debug = 1 THEN
2734: mdebug('Create_Valid_Category: Tracing...1');
2735: END IF;

Line 2773: INSERT INTO mtl_category_set_valid_cats

2769: END IF;
2770: l_request_id := fnd_global.conc_request_id;
2771: l_prog_appl_id := fnd_global.prog_appl_id;
2772: l_program_id := fnd_global.conc_program_id;
2773: INSERT INTO mtl_category_set_valid_cats
2774: ( category_set_id
2775: , category_id
2776: , parent_category_id
2777: , created_by

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

2888: -- Start OF comments
2889: -- API name : Update_Valid_Category
2890: -- TYPE : Public
2891: -- Pre-reqs : None
2892: -- FUNCTION : Update record in mtl_category_set_valid_cats.
2893: --
2894: -- Version: Current Version 1.0
2895: -- Previous Version : None
2896: -- Notes : Stub Version

Line 2906: l_user_id mtl_category_set_valid_cats.created_by%TYPE;

2902: -- On addition of any Optional parameters the minor version needs
2903: -- to change i.e. for eg. X.6 to X.7.
2904: l_api_version CONSTANT NUMBER := 1.0;
2905: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2906: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2907: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2908: BEGIN
2909: IF l_debug = 1 THEN
2910: mdebug('Update_Valid_Category: Tracing...1');

Line 2907: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;

2903: -- to change i.e. for eg. X.6 to X.7.
2904: l_api_version CONSTANT NUMBER := 1.0;
2905: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2906: l_user_id mtl_category_set_valid_cats.created_by%TYPE;
2907: l_login_id mtl_category_set_valid_cats.last_update_login%TYPE;
2908: BEGIN
2909: IF l_debug = 1 THEN
2910: mdebug('Update_Valid_Category: Tracing...1');
2911: END IF;

Line 2947: UPDATE mtl_category_set_valid_cats

2943: END IF;
2944: IF l_debug = 1 THEN
2945: mdebug('Update_Valid_Category: About to update the category record');
2946: END IF;
2947: UPDATE mtl_category_set_valid_cats
2948: SET parent_category_id = p_parent_category_id
2949: ,last_updated_by = l_user_id
2950: ,last_update_date = SYSDATE
2951: ,last_update_login = l_login_id

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

3047: -- Start OF comments
3048: -- API name : Delete_Valid_Category
3049: -- TYPE : Public
3050: -- Pre-reqs : None
3051: -- FUNCTION : Delete the record from mtl_category_set_valid_cats.
3052: --
3053: -- Version: Current Version 1.0
3054: -- Previous Version : None
3055: -- Notes : Stub Version

Line 3067: l_category_id mtl_category_set_valid_cats.category_id%TYPE;

3063: l_api_version CONSTANT NUMBER := 1.0;
3064: l_count NUMBER;
3065: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3066: l_description mtl_categories_vl.description%TYPE;
3067: l_category_id mtl_category_set_valid_cats.category_id%TYPE;
3068: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;
3069: l_hrchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE;
3070:
3071: CURSOR c_get_cat_desc (cp_category_id IN NUMBER) IS

Line 3088: FROM mtl_category_set_valid_cats valid_cats

3084:
3085: CURSOR c_get_items_in_cat_hrchy (cp_category_id IN NUMBER
3086: ,cp_category_set_id IN NUMBER) IS
3087: SELECT valid_cats.category_id
3088: FROM mtl_category_set_valid_cats valid_cats
3089: WHERE EXISTS
3090: (SELECT 'X'
3091: FROM mtl_item_categories item_cat
3092: WHERE item_cat.category_id = valid_cats.category_id

Line 3119: FROM mtl_category_set_valid_cats check_cats

3115: FROM mtl_category_sets_b cat_sets
3116: WHERE cat_sets.category_set_id = p_category_set_id
3117: AND EXISTS
3118: (SELECT 'X'
3119: FROM mtl_category_set_valid_cats check_cats
3120: WHERE check_cats.category_id = cat_sets.default_category_id
3121: CONNECT BY PRIOR
3122: check_cats.category_id = check_cats.parent_category_id
3123: AND check_cats.category_set_id = cp_category_set_id

Line 3235: DELETE mtl_category_set_valid_cats delete_cats

3231: mdebug('Delete_Valid_Category: No items associated! Delete now');
3232: END IF;
3233:
3234: IF UPPER(l_hrchy_enabled) = 'Y' THEN
3235: DELETE mtl_category_set_valid_cats delete_cats
3236: WHERE category_set_id = p_category_set_id
3237: AND EXISTS
3238: (SELECT 'X'
3239: FROM mtl_category_set_valid_cats

Line 3239: FROM mtl_category_set_valid_cats

3235: DELETE mtl_category_set_valid_cats delete_cats
3236: WHERE category_set_id = p_category_set_id
3237: AND EXISTS
3238: (SELECT 'X'
3239: FROM mtl_category_set_valid_cats
3240: WHERE category_id = delete_cats.category_id
3241: CONNECT BY PRIOR category_id = parent_category_id
3242: AND category_set_id = p_category_set_id
3243: START WITH category_id = p_category_id

Line 3247: DELETE mtl_category_set_valid_cats delete_cats

3243: START WITH category_id = p_category_id
3244: AND category_set_id = p_category_set_id
3245: );
3246: ELSE --Added else part for bug 5219692
3247: DELETE mtl_category_set_valid_cats delete_cats
3248: WHERE category_set_id = p_category_set_id
3249: AND category_id = p_category_id;
3250:
3251: END IF;