APPS.FII_CC_MAINTAIN_PKG dependencies on FII_DIM_NORM_HIER_GT

Line 328: -- Populate the table FII_DIM_NORM_HIER_GT

324: END Initialize;
325:
326:
327: -- *******************************************************************
328: -- Populate the table FII_DIM_NORM_HIER_GT
329:
330: PROCEDURE Get_NORM_HIERARCHY_TMP IS
331:
332: Cursor all_local_value_sets IS

Line 357: Insert into FII_DIM_NORM_HIER_GT (

353: END IF;
354: --First, insert records for the master value set
355: g_phase := 'insert records for the master value set';
356:
357: Insert into FII_DIM_NORM_HIER_GT (
358: PARENT_FLEX_VALUE_SET_ID,
359: PARENT_FLEX_VALUE,
360: RANGE_ATTRIBUTE,
361: CHILD_FLEX_VALUE_SET_ID,

Line 377: Insert into FII_DIM_NORM_HIER_GT (

373:
374:
375: --Copy table FII_DIM_NORM_HIERARCHY for parent-child valuesets relation
376: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';
377: Insert into FII_DIM_NORM_HIER_GT (
378: PARENT_FLEX_VALUE_SET_ID,
379: PARENT_FLEX_VALUE,
380: RANGE_ATTRIBUTE,
381: CHILD_FLEX_VALUE_SET_ID,

Line 425: Insert into FII_DIM_NORM_HIER_GT (

421: v1 => Get_Value_Set_Name (l_vset_id));
422: RAISE CCDIM_fatal_err;
423: End If;
424:
425: Insert into FII_DIM_NORM_HIER_GT (
426: PARENT_FLEX_VALUE_SET_ID,
427: PARENT_FLEX_VALUE,
428: RANGE_ATTRIBUTE,
429: CHILD_FLEX_VALUE_SET_ID,

Line 445: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';

441:
442: END LOOP;
443:
444: --Call FND_STATS to collect statistics after populating the table
445: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
446:
447: FND_STATS.gather_table_stats
448: (ownname => g_schema_name,
449: tabname => 'FII_DIM_NORM_HIER_GT');

Line 449: tabname => 'FII_DIM_NORM_HIER_GT');

445: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
446:
447: FND_STATS.gather_table_stats
448: (ownname => g_schema_name,
449: tabname => 'FII_DIM_NORM_HIER_GT');
450:
451: IF (FIIDIM_Debug) THEN
452: FII_MESSAGE.Func_Succ ('FII_CC_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
453: END IF;

Line 585: FROM FII_DIM_NORM_HIER_GT ffvnh,

581: CURSOR direct_children_csr (p_parent_vs_id NUMBER, p_parent_node VARCHAR2)
582: IS
583:
584: SELECT ffv.flex_value_id, ffv.flex_value, ffv.flex_value_set_id, attribute_sort_order sort_order
585: FROM FII_DIM_NORM_HIER_GT ffvnh,
586: fnd_flex_values ffv
587: WHERE ffvnh.child_flex_value_set_id = ffv.flex_value_set_id
588: AND (ffv.flex_value BETWEEN ffvnh.child_flex_value_low
589: AND ffvnh.child_flex_value_high)

Line 1221: --Secondly populate the table FII_DIM_NORM_HIER_GT

1217: --First do the initialization
1218:
1219: Initialize;
1220:
1221: --Secondly populate the table FII_DIM_NORM_HIER_GT
1222:
1223: Get_NORM_HIERARCHY_TMP;
1224:
1225: --Call the Flatten COST CENTER dimension hierarchy routine to insert all mappings.

Line 1431: --Secondly populate the table FII_DIM_NORM_HIER_GT

1427: --First do the initialization
1428:
1429: Initialize;
1430:
1431: --Secondly populate the table FII_DIM_NORM_HIER_GT
1432:
1433: Get_NORM_HIERARCHY_TMP;
1434:
1435: --Call the Flatten COST CENTER dimension hierarchy routine to insert all mappings.