APPS.FII_FIN_CAT_MAINTAIN_PKG dependencies on FII_DIM_NORM_HIER_GT

Line 341: -- Populate the table FII_DIM_NORM_HIER_GT

337: END Initialize;
338:
339:
340: -- *******************************************************************
341: -- Populate the table FII_DIM_NORM_HIER_GT
342:
343: PROCEDURE Get_NORM_HIERARCHY_TMP IS
344:
345: -- Bug 4152798. Removed literal

Line 372: Insert into FII_DIM_NORM_HIER_GT (

368:
369: --First, copy table FII_DIM_NORM_HIERARCHY
370: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';
371:
372: Insert into FII_DIM_NORM_HIER_GT (
373: PARENT_FLEX_VALUE_SET_ID,
374: PARENT_FLEX_VALUE,
375: RANGE_ATTRIBUTE,
376: CHILD_FLEX_VALUE_SET_ID,

Line 400: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_DIM_NORM_HIER_GT');

396: and sts.source_ledger_group_id = slg.source_ledger_group_id
397: and slg.usage_code = 'DBI');
398:
399: IF (FIIDIM_Debug) THEN
400: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_DIM_NORM_HIER_GT');
401: END IF;
402:
403: --Insert records for the master value set
404: g_phase := 'insert records for the master value set';

Line 406: Insert into FII_DIM_NORM_HIER_GT (

402:
403: --Insert records for the master value set
404: g_phase := 'insert records for the master value set';
405:
406: Insert into FII_DIM_NORM_HIER_GT (
407: PARENT_FLEX_VALUE_SET_ID,
408: PARENT_FLEX_VALUE,
409: RANGE_ATTRIBUTE,
410: CHILD_FLEX_VALUE_SET_ID,

Line 424: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_DIM_NORM_HIER_GT');

420: From FND_FLEX_VALUE_NORM_HIERARCHY
421: Where flex_value_set_id = G_MASTER_VALUE_SET_ID;
422:
423: IF (FIIDIM_Debug) THEN
424: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_DIM_NORM_HIER_GT');
425: END IF;
426:
427: --Insert records for all local (child) value sets
428: g_phase := 'Insert records for all local (child) value sets';

Line 449: Insert into FII_DIM_NORM_HIER_GT (

445: End If;
446:
447: g_phase := 'Insert records for local value set ' || l_vset_id;
448:
449: Insert into FII_DIM_NORM_HIER_GT (
450: PARENT_FLEX_VALUE_SET_ID,
451: PARENT_FLEX_VALUE,
452: RANGE_ATTRIBUTE,
453: CHILD_FLEX_VALUE_SET_ID,

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

465:
466: END LOOP;
467:
468: --Call FND_STATS to collect statistics after populating the table
469: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
470:
471: FND_STATS.gather_table_stats
472: (ownname => g_schema_name,
473: tabname => 'FII_DIM_NORM_HIER_GT');

Line 473: tabname => 'FII_DIM_NORM_HIER_GT');

469: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
470:
471: FND_STATS.gather_table_stats
472: (ownname => g_schema_name,
473: tabname => 'FII_DIM_NORM_HIER_GT');
474:
475: Exception
476:
477: When FINDIM_fatal_err then

Line 606: --(it uses a new index FII_DIM_NORM_HIER_GT_N1)

602: PROCEDURE INSERT_IMM_CHILD_NODES
603: (p_vset_id NUMBER, p_root_node VARCHAR2) IS
604:
605: --Per suggestion from performance team, add a hint to the select
606: --(it uses a new index FII_DIM_NORM_HIER_GT_N1)
607: CURSOR direct_children_csr (p_parent_vs_id NUMBER, p_parent_node VARCHAR2) IS
608: SELECT /*+ leading(ffvnh) index(ffvnh) */
609: ffv.flex_value_id, ffv.flex_value, ffv.flex_value_set_id, attribute_sort_order sort_order
610: FROM FII_DIM_NORM_HIER_GT ffvnh,

Line 610: FROM FII_DIM_NORM_HIER_GT ffvnh,

606: --(it uses a new index FII_DIM_NORM_HIER_GT_N1)
607: CURSOR direct_children_csr (p_parent_vs_id NUMBER, p_parent_node VARCHAR2) IS
608: SELECT /*+ leading(ffvnh) index(ffvnh) */
609: ffv.flex_value_id, ffv.flex_value, ffv.flex_value_set_id, attribute_sort_order sort_order
610: FROM FII_DIM_NORM_HIER_GT ffvnh,
611: fnd_flex_values ffv
612: WHERE ffvnh.child_flex_value_set_id = ffv.flex_value_set_id
613: AND (ffv.flex_value BETWEEN ffvnh.child_flex_value_low
614: AND ffvnh.child_flex_value_high)

Line 1629: --Secondly populate the table FII_DIM_NORM_HIER_GT

1625:
1626: Initialize;
1627:
1628:
1629: --Secondly populate the table FII_DIM_NORM_HIER_GT
1630:
1631: g_phase := 'Call Get_NORM_HIERARCHY_TMP';
1632:
1633: Get_NORM_HIERARCHY_TMP;

Line 2074: --Secondly populate the table FII_DIM_NORM_HIER_GT

2070:
2071:
2072: Initialize;
2073:
2074: --Secondly populate the table FII_DIM_NORM_HIER_GT
2075:
2076: g_phase := 'Call Get_NORM_HIERARCHY_TMP';
2077:
2078: Get_NORM_HIERARCHY_TMP;