eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_UDD1_MAINTAIN_PKG dependencies on FII_UDD1_HIER_GT

Line 480: -- to different parents within FII_UDD1_HIER_GT (the TMP hierarchy table)

476:
477:
478: -- **************************************************************************
479: -- This procedure will check for child value multiple assignments
480: -- to different parents within FII_UDD1_HIER_GT (the TMP hierarchy table)
481:
482: PROCEDURE Detect_Diamond_Shape IS
483:
484: --The first cursor is to find all flex_value_id which has multiple parents;

Line 489: FROM FII_UDD1_HIER_GT

485: --we look at records such as (P1,A,A) and (P2,A,A)
486: Cursor Dup_Assg_Cur IS
487: SELECT count(parent_value_id) parents,
488: child_value_id flex_value_id
489: FROM FII_UDD1_HIER_GT
490: WHERE next_level_value_id = child_value_id
491: AND parent_level = next_level - 1
492: GROUP BY child_value_id
493: HAVING count(parent_value_id) > 1;

Line 502: FROM FII_UDD1_HIER_GT

498: SELECT parent_value_id,
499: parent_flex_value_set_id,
500: child_value_id,
501: child_flex_value_set_id
502: FROM FII_UDD1_HIER_GT
503: WHERE child_value_id = p_child_value_id
504: AND next_level_value_id = child_value_id
505: AND parent_level = next_level - 1;
506:

Line 637: INSERT INTO fii_UDD1_hier_gt (

633: FOR direct_children_rec IN direct_children_csr(p_vset_id, p_root_node)
634: LOOP
635:
636: /* Inserting record with all parents */
637: INSERT INTO fii_UDD1_hier_gt (
638: parent_level,
639: parent_value_id,
640: child_value_id,
641: next_level,

Line 702: FROM fii_UDD1_hier_gt

698: CURSOR MAIN_CSR is
699: SELECT parent_level, parent_value_id, next_level, next_level_value_id,
700: child_level, child_value_id, child_flex_value_set_id,
701: parent_flex_value_set_id
702: FROM fii_UDD1_hier_gt
703: ORDER BY parent_level, child_level;
704:
705: l_flex_value VARCHAR2(150);
706: p_parent_id NUMBER(15);

Line 714: g_phase := 'Truncate table FII_UDD1_HIER_GT';

710: IF (FIIDIM_Debug) THEN
711: FII_MESSAGE.Func_Ent(func_name => 'FII_UDD1_MAINTAIN_PKG.'||
712: 'Flatten_UD1_Dim_Hier');
713: END IF;
714: g_phase := 'Truncate table FII_UDD1_HIER_GT';
715: FII_UTIL.truncate_table ('FII_UDD1_HIER_GT', 'FII', g_retcode);
716:
717: -----------------------------------------------------------------
718:

Line 715: FII_UTIL.truncate_table ('FII_UDD1_HIER_GT', 'FII', g_retcode);

711: FII_MESSAGE.Func_Ent(func_name => 'FII_UDD1_MAINTAIN_PKG.'||
712: 'Flatten_UD1_Dim_Hier');
713: END IF;
714: g_phase := 'Truncate table FII_UDD1_HIER_GT';
715: FII_UTIL.truncate_table ('FII_UDD1_HIER_GT', 'FII', g_retcode);
716:
717: -----------------------------------------------------------------
718:
719: UDIM1_parent_node := p_root_node;

Line 739: insert into fii_UDD1_hier_gt (

735:
736: INSERT_IMM_CHILD_NODES (p_vset_id, p_root_node);
737:
738: g_phase := 'Insert all the self records';
739: insert into fii_UDD1_hier_gt (
740: parent_level,
741: parent_value_id,
742: next_level,
743: next_level_value_id,

Line 761: from (select distinct child_value_id,child_level,child_flex_value_set_id from fii_udd1_hier_gt);

757: child_flex_value_set_id,
758: child_flex_value_set_id,
759: 'N',
760: 'N'
761: from (select distinct child_value_id,child_level,child_flex_value_set_id from fii_udd1_hier_gt);
762:
763: IF (FIIDIM_Debug) THEN
764: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIER_GT');
765: END IF;

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

760: 'N'
761: from (select distinct child_value_id,child_level,child_flex_value_set_id from fii_udd1_hier_gt);
762:
763: IF (FIIDIM_Debug) THEN
764: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIER_GT');
765: END IF;
766:
767: g_phase := 'Insert self record for the top node';
768: INSERT INTO fii_UDD1_hier_gt

Line 768: INSERT INTO fii_UDD1_hier_gt

764: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIER_GT');
765: END IF;
766:
767: g_phase := 'Insert self record for the top node';
768: INSERT INTO fii_UDD1_hier_gt
769: (parent_level,
770: parent_value_id,
771: next_level,
772: next_level_value_id,

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

788: 'N',
789: 'N');
790:
791: IF (FIIDIM_Debug) THEN
792: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIER_GT');
793: END IF;
794:
795: --Insert the UNASSIGNED to the hierarchy table.
796: --Use G_TOP_NODE_ID as the parent

Line 800: INSERT INTO fii_UDD1_hier_gt

796: --Use G_TOP_NODE_ID as the parent
797: g_phase := 'Insert the UNASSIGNED to the hierarchy table';
798:
799: -- First one is (G_TOP_NODE_ID, UNASSIGNED, UNASSIGNED)
800: INSERT INTO fii_UDD1_hier_gt
801: (parent_level,
802: parent_value_id,
803: next_level,
804: next_level_value_id,

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

820: 'N',
821: 'N');
822:
823: IF (FIIDIM_Debug) THEN
824: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIER_GT');
825: END IF;
826:
827:
828: -- Another one is (UNASSIGNED, UNASSIGNED, UNASSIGNED)

Line 829: INSERT INTO fii_UDD1_hier_gt

825: END IF;
826:
827:
828: -- Another one is (UNASSIGNED, UNASSIGNED, UNASSIGNED)
829: INSERT INTO fii_UDD1_hier_gt
830: (parent_level,
831: parent_value_id,
832: next_level,
833: next_level_value_id,

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

849: 'N',
850: 'N');
851:
852: IF (FIIDIM_Debug) THEN
853: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIER_GT');
854: END IF;
855:
856: -- Insert a dummy super top node (-999) to the hierarchy table
857: -- (the dummy value set id is -998)

Line 860: INSERT INTO fii_UDD1_hier_gt

856: -- Insert a dummy super top node (-999) to the hierarchy table
857: -- (the dummy value set id is -998)
858: g_phase := 'Insert a dummy top node (-999) to the hierarchy table';
859:
860: INSERT INTO fii_UDD1_hier_gt
861: (parent_level,
862: parent_value_id,
863: next_level,
864: next_level_value_id,

Line 882: FROM fii_UDD1_hier_gt

878: child_flex_value_set_id,
879: -998,
880: 'N',
881: 'N'
882: FROM fii_UDD1_hier_gt
883: WHERE child_value_id = parent_value_id;
884:
885: IF (FIIDIM_Debug) THEN
886: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIER_GT');

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

882: FROM fii_UDD1_hier_gt
883: WHERE child_value_id = parent_value_id;
884:
885: IF (FIIDIM_Debug) THEN
886: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIER_GT');
887: END IF;
888:
889: --Call FND_STATS to collect statistics after populating the table
890: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';

Line 903: -- We use (just created) TMP table FII_UDD1_HIER_GT for this purpose

899: --If so, we will report the problem, and error out the program
900:
901: -- The following block checks for child value multiple assignments
902: -- to different parents within the value sets
903: -- We use (just created) TMP table FII_UDD1_HIER_GT for this purpose
904: g_phase := 'Call Detect_Diamond_Shape';
905:
906: Detect_Diamond_Shape;
907:

Line 1022: -- FII_UDD1_HIER_GT (full version) the LVS records

1018: END Get_UD1_Mapping_GT;
1019:
1020: -- **************************************************************************
1021: -- Populate the pruned User Defined Dimension1 hierarchy FII_UDD1_HIERARCHIES by deleting from
1022: -- FII_UDD1_HIER_GT (full version) the LVS records
1023:
1024: PROCEDURE Get_Pruned_UD1_GT IS
1025:
1026: Begin

Line 1033: --Delete from FII_UDD1_HIER_GT for child value set not equal to

1029: FII_MESSAGE.Func_Ent(func_name => 'FII_UDD1_MAINTAIN_PKG.'||
1030: 'Get_Pruned_UD1_GT');
1031: END IF;
1032:
1033: --Delete from FII_UDD1_HIER_GT for child value set not equal to
1034: --the master value set and not equal to the UNASSIGNED value set.
1035: g_phase := 'Delete FII_UDD1_HIER_GT #1';
1036:
1037: Delete from FII_UDD1_HIER_GT

Line 1035: g_phase := 'Delete FII_UDD1_HIER_GT #1';

1031: END IF;
1032:
1033: --Delete from FII_UDD1_HIER_GT for child value set not equal to
1034: --the master value set and not equal to the UNASSIGNED value set.
1035: g_phase := 'Delete FII_UDD1_HIER_GT #1';
1036:
1037: Delete from FII_UDD1_HIER_GT
1038: Where child_flex_value_set_id <> G_MASTER_VALUE_SET_ID
1039: And child_flex_value_set_id <> G_FII_INT_VALUE_SET_ID;

Line 1037: Delete from FII_UDD1_HIER_GT

1033: --Delete from FII_UDD1_HIER_GT for child value set not equal to
1034: --the master value set and not equal to the UNASSIGNED value set.
1035: g_phase := 'Delete FII_UDD1_HIER_GT #1';
1036:
1037: Delete from FII_UDD1_HIER_GT
1038: Where child_flex_value_set_id <> G_MASTER_VALUE_SET_ID
1039: And child_flex_value_set_id <> G_FII_INT_VALUE_SET_ID;
1040:
1041: IF (FIIDIM_Debug) THEN

Line 1042: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows form FII_UDD1_HIER_GT');

1038: Where child_flex_value_set_id <> G_MASTER_VALUE_SET_ID
1039: And child_flex_value_set_id <> G_FII_INT_VALUE_SET_ID;
1040:
1041: IF (FIIDIM_Debug) THEN
1042: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows form FII_UDD1_HIER_GT');
1043: END IF;
1044:
1045: --Finally, update the columns next_level_is_leaf_flag, is_leaf_flag again
1046: --for the latest FII_UDD1_HIER_GT

Line 1046: --for the latest FII_UDD1_HIER_GT

1042: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows form FII_UDD1_HIER_GT');
1043: END IF;
1044:
1045: --Finally, update the columns next_level_is_leaf_flag, is_leaf_flag again
1046: --for the latest FII_UDD1_HIER_GT
1047: g_phase := 'Update next_level_is_leaf_flag, is_leaf_flag';
1048:
1049: --Update the column next_level_is_leaf_flag
1050: --We look at those records (P,A,A) in which A is a leaf value

Line 1051: Update fii_UDD1_hier_gt tab1

1047: g_phase := 'Update next_level_is_leaf_flag, is_leaf_flag';
1048:
1049: --Update the column next_level_is_leaf_flag
1050: --We look at those records (P,A,A) in which A is a leaf value
1051: Update fii_UDD1_hier_gt tab1
1052: Set next_level_is_leaf_flag = 'Y'
1053: Where tab1.next_level_value_id = tab1.child_value_id
1054: and tab1.next_level_value_id IN (
1055: select /*+ ordered */ tab3.next_level_value_id

Line 1056: from fii_UDD1_hier_gt tab3,

1052: Set next_level_is_leaf_flag = 'Y'
1053: Where tab1.next_level_value_id = tab1.child_value_id
1054: and tab1.next_level_value_id IN (
1055: select /*+ ordered */ tab3.next_level_value_id
1056: from fii_UDD1_hier_gt tab3,
1057: fii_UDD1_hier_gt tab2
1058: where tab2.parent_value_id = tab3.parent_value_id
1059: and tab3.parent_value_id = tab3.child_value_id
1060: group by tab3.next_level_value_id

Line 1057: fii_UDD1_hier_gt tab2

1053: Where tab1.next_level_value_id = tab1.child_value_id
1054: and tab1.next_level_value_id IN (
1055: select /*+ ordered */ tab3.next_level_value_id
1056: from fii_UDD1_hier_gt tab3,
1057: fii_UDD1_hier_gt tab2
1058: where tab2.parent_value_id = tab3.parent_value_id
1059: and tab3.parent_value_id = tab3.child_value_id
1060: group by tab3.next_level_value_id
1061: having count(*) = 1);

Line 1064: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_UDD1_HIER_GT');

1060: group by tab3.next_level_value_id
1061: having count(*) = 1);
1062:
1063: IF (FIIDIM_Debug) THEN
1064: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_UDD1_HIER_GT');
1065: END IF;
1066:
1067: --Update the column is_leaf_flag
1068: --We look at all records (A,A,A) in which A is a leaf value

Line 1069: Update fii_UDD1_hier_gt

1065: END IF;
1066:
1067: --Update the column is_leaf_flag
1068: --We look at all records (A,A,A) in which A is a leaf value
1069: Update fii_UDD1_hier_gt
1070: Set is_leaf_flag = 'Y'
1071: Where parent_value_id = child_value_id
1072: and next_level_is_leaf_flag = 'Y';
1073:

Line 1075: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_UDD1_HIER_GT');

1071: Where parent_value_id = child_value_id
1072: and next_level_is_leaf_flag = 'Y';
1073:
1074: IF (FIIDIM_Debug) THEN
1075: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_UDD1_HIER_GT');
1076: END IF;
1077:
1078: IF (FIIDIM_Debug) THEN
1079: FII_MESSAGE.Func_Succ(func_name => 'FII_UDD1_MAINTAIN_PKG.'||

Line 1304: FROM FII_UDD1_HIER_GT;

1300: FII_USER_ID,
1301: SYSDATE,
1302: FII_USER_ID,
1303: FII_LOGIN_ID
1304: FROM FII_UDD1_HIER_GT;
1305:
1306: IF (FIIDIM_Debug) THEN
1307: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows in FII_FULL_UDD1_HIERS');
1308: END IF;

Line 1322: --Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table

1318: tabname => 'FII_FULL_UDD1_HIERS');
1319:
1320: --==============================================================--
1321:
1322: --Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table
1323: g_phase := 'Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table';
1324:
1325: Get_Pruned_UD1_GT;
1326:

Line 1323: g_phase := 'Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table';

1319:
1320: --==============================================================--
1321:
1322: --Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table
1323: g_phase := 'Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table';
1324:
1325: Get_Pruned_UD1_GT;
1326:
1327: --Copy FII_UDD1_HIER_GT to the final (pruned) dimension table

Line 1327: --Copy FII_UDD1_HIER_GT to the final (pruned) dimension table

1323: g_phase := 'Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table';
1324:
1325: Get_Pruned_UD1_GT;
1326:
1327: --Copy FII_UDD1_HIER_GT to the final (pruned) dimension table
1328: g_phase := 'Copy TMP hierarchy table to the final pruned dimension table';
1329:
1330: FII_UTIL.truncate_table ('FII_UDD1_HIERARCHIES', 'FII', g_retcode);
1331:

Line 1368: FROM FII_UDD1_HIER_GT;

1364: FII_USER_ID,
1365: SYSDATE,
1366: FII_USER_ID,
1367: FII_LOGIN_ID
1368: FROM FII_UDD1_HIER_GT;
1369:
1370: IF (FIIDIM_Debug) THEN
1371: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
1372: END IF;

Line 1559: FROM FII_UDD1_HIER_GT;

1555: FII_USER_ID,
1556: SYSDATE,
1557: FII_USER_ID,
1558: FII_LOGIN_ID
1559: FROM FII_UDD1_HIER_GT;
1560:
1561: IF (FIIDIM_Debug) THEN
1562: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_UDD1_HIERS');
1563: END IF;

Line 1576: --Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table

1572: tabname => 'FII_FULL_UDD1_HIERS');
1573:
1574: --==============================================================--
1575:
1576: --Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table
1577: g_phase := 'Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table';
1578:
1579: Get_Pruned_UD1_GT;
1580:

Line 1577: g_phase := 'Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table';

1573:
1574: --==============================================================--
1575:
1576: --Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table
1577: g_phase := 'Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table';
1578:
1579: Get_Pruned_UD1_GT;
1580:
1581: --Copy FII_UDD1_HIER_GT to the final (pruned) dimension table

Line 1581: --Copy FII_UDD1_HIER_GT to the final (pruned) dimension table

1577: g_phase := 'Delete/Update FII_UDD1_HIER_GT for pruned hierarchy table';
1578:
1579: Get_Pruned_UD1_GT;
1580:
1581: --Copy FII_UDD1_HIER_GT to the final (pruned) dimension table
1582: g_phase := 'Copy TMP hierarchy table to the final pruned dimension table';
1583:
1584: -- Incremental Dimension Maintence
1585: -- All data is now in the temporary table FII_UDD1_HIER_GT,

Line 1585: -- All data is now in the temporary table FII_UDD1_HIER_GT,

1581: --Copy FII_UDD1_HIER_GT to the final (pruned) dimension table
1582: g_phase := 'Copy TMP hierarchy table to the final pruned dimension table';
1583:
1584: -- Incremental Dimension Maintence
1585: -- All data is now in the temporary table FII_UDD1_HIER_GT,
1586: -- we need to maintain the permanent table FII_UDD1_HIERARCHIES
1587: -- by diffing the 2 tables.
1588: -- The maintenance is done by 2 statements, one INSERT and one DELETE.
1589:

Line 1612: FROM FII_UDD1_HIER_GT);

1608: next_level_is_leaf_flag, is_leaf_flag,
1609: child_level, child_value_id,
1610: parent_flex_value_set_id,
1611: child_flex_value_set_id, NVL(next_level_value_sort_order, -92883)
1612: FROM FII_UDD1_HIER_GT);
1613:
1614:
1615: IF (FIIDIM_Debug) THEN
1616: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD1_HIERARCHIES');

Line 1654: FROM FII_UDD1_HIER_GT

1650: FII_USER_ID,
1651: SYSDATE,
1652: FII_USER_ID,
1653: FII_LOGIN_ID
1654: FROM FII_UDD1_HIER_GT
1655: MINUS
1656: SELECT parent_level,
1657: parent_value_id,
1658: next_level,