APPS.FII_UDD2_MAINTAIN_PKG dependencies on FII_DIM_NORM_HIER_GT

Line 330: -- Populate the table FII_DIM_NORM_HIER_GT

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

Line 360: Insert into FII_DIM_NORM_HIER_GT (

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

Line 380: Insert into FII_DIM_NORM_HIER_GT (

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

Line 428: Insert into FII_DIM_NORM_HIER_GT (

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

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

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

Line 452: tabname => 'FII_DIM_NORM_HIER_GT');

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

Line 591: FROM FII_DIM_NORM_HIER_GT ffvnh,

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

Line 1254: --Secondly populate the table FII_DIM_NORM_HIER_GT

1250: --First do the initialization
1251:
1252: Initialize;
1253:
1254: --Secondly populate the table FII_DIM_NORM_HIER_GT
1255:
1256: Get_NORM_HIERARCHY_TMP;
1257:
1258:

Line 1508: --Secondly populate the table FII_DIM_NORM_HIER_GT

1504: --First do the initialization
1505:
1506: Initialize;
1507:
1508: --Secondly populate the table FII_DIM_NORM_HIER_GT
1509:
1510: Get_NORM_HIERARCHY_TMP;
1511:
1512: --Call the Flatten User Defined Dimension2 dimension hierarchy routine to insert all mappings.