APPS.FII_LOB_MAINTAIN_PKG dependencies on FII_DIM_NORM_HIER_GT

Line 354: -- Populate the table FII_DIM_NORM_HIER_GT

350: END Initialize;
351:
352:
353: -- *******************************************************************
354: -- Populate the table FII_DIM_NORM_HIER_GT
355:
356: PROCEDURE Get_NORM_HIERARCHY_TMP IS
357:
358: Cursor all_local_value_sets IS

Line 384: Insert into FII_DIM_NORM_HIER_GT (

380:
381: --First, insert records for the master value set
382: g_phase := 'insert records for the master value set';
383:
384: Insert into FII_DIM_NORM_HIER_GT (
385: PARENT_FLEX_VALUE_SET_ID,
386: PARENT_FLEX_VALUE,
387: RANGE_ATTRIBUTE,
388: CHILD_FLEX_VALUE_SET_ID,

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

398: From FND_FLEX_VALUE_NORM_HIERARCHY
399: Where flex_value_set_id = G_MASTER_VALUE_SET_ID;
400:
401: IF (FIIDIM_Debug) THEN
402: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_DIM_NORM_HIER_GT');
403: END IF;
404:
405: -- For DBI 5.0 customers, use the master value set only
406: -- For DBI 6.0, need to get all child value sets

Line 412: Insert into FII_DIM_NORM_HIER_GT (

408:
409: --Copy table FII_DIM_NORM_HIERARCHY for parent-child valuesets relation
410: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';
411:
412: Insert into FII_DIM_NORM_HIER_GT (
413: PARENT_FLEX_VALUE_SET_ID,
414: PARENT_FLEX_VALUE,
415: RANGE_ATTRIBUTE,
416: CHILD_FLEX_VALUE_SET_ID,

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

436: and sts.source_ledger_group_id = slg.source_ledger_group_id
437: and slg.usage_code = 'DBI');
438:
439: IF (FIIDIM_Debug) THEN
440: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_DIM_NORM_HIER_GT');
441: END IF;
442:
443: --Insert records for all local (child) value sets
444: g_phase := 'Insert records for all local (child) value sets';

Line 465: Insert into FII_DIM_NORM_HIER_GT (

461: End If;
462:
463: g_phase := 'Insert records for local value set ' || l_vset_id;
464:
465: Insert into FII_DIM_NORM_HIER_GT (
466: PARENT_FLEX_VALUE_SET_ID,
467: PARENT_FLEX_VALUE,
468: RANGE_ATTRIBUTE,
469: CHILD_FLEX_VALUE_SET_ID,

Line 618: FROM FII_DIM_NORM_HIER_GT ffvnh,

614: (p_vset_id NUMBER, p_root_node VARCHAR2) IS
615:
616: CURSOR direct_children_csr (p_parent_vs_id NUMBER, p_parent_node VARCHAR2) IS
617: SELECT ffv.flex_value_id, ffv.flex_value, ffv.flex_value_set_id
618: FROM FII_DIM_NORM_HIER_GT ffvnh,
619: fnd_flex_values ffv
620: WHERE ffvnh.child_flex_value_set_id = ffv.flex_value_set_id
621: AND (ffv.flex_value BETWEEN ffvnh.child_flex_value_low
622: AND ffvnh.child_flex_value_high)

Line 1316: --Secondly populate the table FII_DIM_NORM_HIER_GT

1312: g_phase := 'Call Initialize';
1313:
1314: Initialize;
1315:
1316: --Secondly populate the table FII_DIM_NORM_HIER_GT
1317:
1318: g_phase := 'Call Get_NORM_HIERARCHY_TMP';
1319:
1320: Get_NORM_HIERARCHY_TMP;

Line 1532: --Secondly populate the table FII_DIM_NORM_HIER_GT

1528: g_phase := 'Call Initialize';
1529:
1530: Initialize;
1531:
1532: --Secondly populate the table FII_DIM_NORM_HIER_GT
1533:
1534: g_phase := 'Call Get_NORM_HIERARCHY_TMP';
1535:
1536: Get_NORM_HIERARCHY_TMP;