[Home] [Help]
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
412: -- sales and marketing is installed
413: PROCEDURE SYNC_DENORM_PARENTS_PROD_HRCHY(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2) IS
414: CURSOR C1 IS
415: SELECT TL.LANGUAGE_CODE, S.CHILD_ID, S.MODE_FLAG, S.LANGUAGE_CODE STG_LANG
416: FROM ENI_DENORM_HRCHY_STG S, FND_LANGUAGES TL
417: WHERE S.OBJECT_ID = g_catset_id
418: AND S.OBJECT_TYPE = 'CATEGORY_SET'
419: AND TL.INSTALLED_FLAG IN ('I', 'B')
420: AND S.MODE_FLAG <> 'D'
481: /* Bug : 5233230
482: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleting records of all disabled languages from Denorm Hierarchy Parents table');
483: -- Deleting all languages, which are being deactivated
484: DELETE FROM ENI_DENORM_HRCHY_PARENTS B
485: WHERE NOT EXISTS (SELECT NULL FROM FND_LANGUAGES L
486: WHERE L.INSTALLED_FLAG IN ('I', 'B')
487: AND B.LANGUAGE = L.LANGUAGE_CODE);
488:
489: l_count := SQL%ROWCOUNT;