APPS.ENI_DENORM_HRCHY dependencies on ENI_DENORM_HRCHY_PARENTS

Line 303: DELETE ENI_DENORM_HRCHY_PARENTS;

299: RAISE;
300: END;
301:
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleting Denorm Hierarchy Parents table');
303: DELETE ENI_DENORM_HRCHY_PARENTS;
304:
305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Populating Denorm Hierarchy Parents table');
306: -- for each language installed and each category in hierarchy
307: l_count := 0;

Line 341: INSERT INTO ENI_DENORM_HRCHY_PARENTS (

337: l_imm_par_id := k.CHILD_ID;
338: END IF;
339: END LOOP;
340:
341: INSERT INTO ENI_DENORM_HRCHY_PARENTS (
342: OBJECT_TYPE,
343: OBJECT_ID,
344: ATTRIBUTE_GROUP_ID,
345: CATEGORY_ID,

Line 387: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gathering statistics on table: ENI_DENORM_HRCHY_PARENTS ');

383: END LOOP;
384:
385: FND_FILE.PUT_LINE(FND_FILE.LOG, l_count||' records inserted into Denorm Hierarchy Parents table.');
386:
387: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gathering statistics on table: ENI_DENORM_HRCHY_PARENTS ');
388: FND_STATS.gather_table_stats (ownname=>'ENI', tabname=>'ENI_DENORM_HRCHY_PARENTS');
389:
390: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Initial Load of Denorm Hierarchy Parents table Complete.');
391: EXCEPTION

Line 388: FND_STATS.gather_table_stats (ownname=>'ENI', tabname=>'ENI_DENORM_HRCHY_PARENTS');

384:
385: FND_FILE.PUT_LINE(FND_FILE.LOG, l_count||' records inserted into Denorm Hierarchy Parents table.');
386:
387: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Gathering statistics on table: ENI_DENORM_HRCHY_PARENTS ');
388: FND_STATS.gather_table_stats (ownname=>'ENI', tabname=>'ENI_DENORM_HRCHY_PARENTS');
389:
390: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Initial Load of Denorm Hierarchy Parents table Complete.');
391: EXCEPTION
392: WHEN NO_DATA_FOUND THEN

Line 484: DELETE FROM ENI_DENORM_HRCHY_PARENTS B

480:
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:

Line 495: DELETE FROM ENI_DENORM_HRCHY_PARENTS B

491: Bug 5233230 */
492:
493: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleting all categories which are deleted from hierarchy OR excluded from user view.');
494: -- Deleting all deleted nodes
495: DELETE FROM ENI_DENORM_HRCHY_PARENTS B
496: WHERE B.OBJECT_TYPE = 'CATEGORY_SET'
497: AND B.OBJECT_ID = g_catset_id
498: AND EXISTS (SELECT NULL FROM ENI_DENORM_HRCHY_STG S
499: WHERE S.OBJECT_TYPE = 'CATEGORY_SET'

Line 546: UPDATE ENI_DENORM_HRCHY_PARENTS B

542: l_imm_par_id := k.CHILD_ID;
543: END IF;
544: END LOOP;
545:
546: UPDATE ENI_DENORM_HRCHY_PARENTS B
547: SET CATEGORY_DESC = l_desc,
548: CONCAT_CAT_PARENTAGE = RTRIM(l_concat_desc, '/'),
549: CATEGORY_LEVEL_NUM = l_eff_level,
550: DISABLE_DATE = j.DISABLE_DATE,

Line 565: INSERT INTO ENI_DENORM_HRCHY_PARENTS (

561: AND CATEGORY_ID = j.CATEGORY_ID
562: AND LANGUAGE = i.LANGUAGE_CODE;
563:
564: IF SQL%NOTFOUND THEN
565: INSERT INTO ENI_DENORM_HRCHY_PARENTS (
566: OBJECT_TYPE,
567: OBJECT_ID,
568: ATTRIBUTE_GROUP_ID,
569: CATEGORY_ID,

Line 1499: FROM ENI_DENORM_HRCHY_PARENTS

1495: ret := null;
1496: -- if de-norm parents table is empty then call full load of only de-norm parents table
1497: BEGIN
1498: SELECT 1 INTO l_cnt
1499: FROM ENI_DENORM_HRCHY_PARENTS
1500: WHERE OBJECT_TYPE = 'CATEGORY_SET'
1501: AND ROWNUM = 1;
1502:
1503: SYNC_DENORM_PARENTS_PROD_HRCHY(err, ret);