173: -- then the language code will be updated to NULL.
174: IF p_language_code IS NOT NULL THEN
175: BEGIN
176: SELECT 1 INTO l_count
177: FROM MTL_CATEGORIES_TL
178: WHERE CATEGORY_ID = p_child_id
179: AND SOURCE_LANG = p_language_code;
180:
181: l_language_code := p_language_code;
254: AND NVL(A.EXCLUDE_USER_VIEW, 'N') = 'Y');
255:
256: CURSOR C3(l_child_id NUMBER, l_language VARCHAR2) IS
257: SELECT TL.DESCRIPTION CHILD_DESC, C.CATEGORY_ID CHILD_ID
258: FROM MTL_CATEGORIES_TL TL,
259: (SELECT
260: CATEGORY_ID, LEVEL hrchy
261: FROM MTL_CATEGORY_SET_VALID_CATS
262: START WITH CATEGORY_ID = l_child_id AND CATEGORY_SET_ID = g_catset_id
433: WHERE B.CATEGORY_ID = D.CATEGORY_ID;
434:
435: CURSOR C3(l_child_id NUMBER, l_language VARCHAR2) IS
436: SELECT TL.DESCRIPTION CHILD_DESC, C.CATEGORY_ID CHILD_ID
437: FROM MTL_CATEGORIES_TL TL,
438: (SELECT
439: CATEGORY_ID, LEVEL hrchy
440: FROM MTL_CATEGORY_SET_VALID_CATS
441: START WITH CATEGORY_ID = l_child_id AND CATEGORY_SET_ID = g_catset_id