APPS.FII_COM_MAINTAIN_PKG dependencies on FII_DIM_NORM_HIER_GT

Line 332: -- Populate the table FII_DIM_NORM_HIER_GT

328: END Initialize;
329:
330:
331: -- *******************************************************************
332: -- Populate the table FII_DIM_NORM_HIER_GT
333:
334: PROCEDURE Get_NORM_HIERARCHY_TMP IS
335:
336: Cursor all_local_value_sets IS

Line 362: Insert into FII_DIM_NORM_HIER_GT (

358:
359: --First, insert records for the master value set
360: g_phase := 'insert records for the master value set';
361:
362: Insert into FII_DIM_NORM_HIER_GT (
363: PARENT_FLEX_VALUE_SET_ID,
364: PARENT_FLEX_VALUE,
365: RANGE_ATTRIBUTE,
366: CHILD_FLEX_VALUE_SET_ID,

Line 382: Insert into FII_DIM_NORM_HIER_GT (

378:
379:
380: --Copy table FII_DIM_NORM_HIERARCHY for parent-child valuesets relation
381: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';
382: Insert into FII_DIM_NORM_HIER_GT (
383: PARENT_FLEX_VALUE_SET_ID,
384: PARENT_FLEX_VALUE,
385: RANGE_ATTRIBUTE,
386: CHILD_FLEX_VALUE_SET_ID,

Line 430: Insert into FII_DIM_NORM_HIER_GT (

426: v1 => Get_Value_Set_Name (l_vset_id));
427: RAISE CODIM_fatal_err;
428: End If;
429:
430: Insert into FII_DIM_NORM_HIER_GT (
431: PARENT_FLEX_VALUE_SET_ID,
432: PARENT_FLEX_VALUE,
433: RANGE_ATTRIBUTE,
434: CHILD_FLEX_VALUE_SET_ID,

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

446:
447: END LOOP;
448:
449: --Call FND_STATS to collect statistics after populating the table
450: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
451:
452: FND_STATS.gather_table_stats
453: (ownname => g_schema_name,
454: tabname => 'FII_DIM_NORM_HIER_GT');

Line 454: tabname => 'FII_DIM_NORM_HIER_GT');

450: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
451:
452: FND_STATS.gather_table_stats
453: (ownname => g_schema_name,
454: tabname => 'FII_DIM_NORM_HIER_GT');
455:
456: IF (FIIDIM_Debug) THEN
457: FII_MESSAGE.Func_Succ ('FII_COM_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
458: END IF;

Line 592: FROM FII_DIM_NORM_HIER_GT ffvnh,

588: CURSOR direct_children_csr (p_parent_vs_id NUMBER, p_parent_node VARCHAR2)
589: IS
590:
591: SELECT ffv.flex_value_id, ffv.flex_value, ffv.flex_value_set_id, attribute_sort_order sort_order
592: FROM FII_DIM_NORM_HIER_GT ffvnh,
593: fnd_flex_values ffv
594: WHERE ffvnh.child_flex_value_set_id = ffv.flex_value_set_id
595: AND (ffv.flex_value BETWEEN ffvnh.child_flex_value_low
596: AND ffvnh.child_flex_value_high)

Line 1231: --Secondly populate the table FII_DIM_NORM_HIER_GT

1227: --First do the initialization
1228:
1229: Initialize;
1230:
1231: --Secondly populate the table FII_DIM_NORM_HIER_GT
1232:
1233: Get_NORM_HIERARCHY_TMP;
1234:
1235:

Line 1443: --Secondly populate the table FII_DIM_NORM_HIER_GT

1439: --First do the initialization
1440:
1441: Initialize;
1442:
1443: --Secondly populate the table FII_DIM_NORM_HIER_GT
1444:
1445: Get_NORM_HIERARCHY_TMP;
1446:
1447: --Call the Flatten COMPANY dimension hierarchy routine to insert all mappings.