243: -- this procedure is called from the main procedure if sales and marketing is installed.
244: PROCEDURE LOAD_DENORM_PARENTS_PROD_HRCHY(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2) IS
245: CURSOR C1 IS
246: SELECT TL.LANGUAGE_CODE, C.CATEGORY_ID, B.DISABLE_DATE
247: FROM MTL_CATEGORY_SET_VALID_CATS C, MTL_CATEGORIES_B B, FND_LANGUAGES TL
248: WHERE C.CATEGORY_SET_ID = g_catset_id
249: AND TL.INSTALLED_FLAG IN ('I', 'B')
250: AND B.CATEGORY_ID = C.CATEGORY_ID
251: AND NOT EXISTS (SELECT NULL FROM EGO_PROD_CAT_SALES_MARKET_AGV A
428: WHERE A.CATEGORY_SET_ID = g_catset_id
429: AND A.CATEGORY_ID = C.CATEGORY_ID
430: AND NVL(A.EXCLUDE_USER_VIEW, 'N') = 'Y')
431: START WITH CATEGORY_ID = p_child AND CATEGORY_SET_ID = g_catset_id
432: CONNECT BY PARENT_CATEGORY_ID = PRIOR CATEGORY_ID AND CATEGORY_SET_ID = g_catset_id) D, MTL_CATEGORIES_B B
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
739: l_conc_request_id,
740: l_prog_appl_id,
741: SYSDATE,
742: l_conc_program_id
743: FROM MTL_CATEGORIES_B
744: WHERE STRUCTURE_ID = l_struct_id;
745: ELSE
746: -- Inserting Self-referencing Nodes
747: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting Self Referencing Nodes');
1037: l_conc_request_id,
1038: l_prog_appl_id,
1039: SYSDATE,
1040: l_conc_program_id
1041: FROM MTL_CATEGORIES_B B
1042: WHERE B.STRUCTURE_ID = l_struct_id
1043: AND NOT EXISTS (SELECT NULL FROM ENI_DENORM_HIERARCHIES H
1044: WHERE H.OBJECT_TYPE = 'CATEGORY_SET'
1045: AND H.OBJECT_ID = g_catset_id