APPS.FII_UDD1_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 UDIM1_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_UDD1_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
456: END IF;

Line 590: FROM FII_DIM_NORM_HIER_GT ffvnh,

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

Line 1255: --Secondly populate the table FII_DIM_NORM_HIER_GT

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

Line 1517: --Secondly populate the table FII_DIM_NORM_HIER_GT

1513: --First do the initialization
1514:
1515: Initialize;
1516:
1517: --Secondly populate the table FII_DIM_NORM_HIER_GT
1518:
1519: Get_NORM_HIERARCHY_TMP;
1520:
1521: --Call the Flatten User Defined Dimension1 dimension hierarchy routine to insert all mappings.