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_FIN_CAT_MAINTAIN_PKG dependencies on FII_FIN_ITEM_HIER_GT

Line 498: -- to different parents within FII_FIN_ITEM_HIER_GT (the TMP hierarchy table)

494:
495:
496: -- **************************************************************************
497: -- This procedure will check for child value multiple assignments
498: -- to different parents within FII_FIN_ITEM_HIER_GT (the TMP hierarchy table)
499:
500: PROCEDURE Detect_Diamond_Shape IS
501:
502: --The first cursor is to find all flex_value_id which has multiple parents;

Line 507: FROM FII_FIN_ITEM_HIER_GT

503: --we look at records such as (P1,A,A) and (P2,A,A)
504: Cursor Dup_Assg_Cur IS
505: SELECT count(parent_fin_cat_id) parents,
506: child_fin_cat_id flex_value_id
507: FROM FII_FIN_ITEM_HIER_GT
508: WHERE next_level_fin_cat_id = child_fin_cat_id
509: AND parent_level = next_level - 1
510: GROUP BY child_fin_cat_id
511: HAVING count(parent_fin_cat_id) > 1;

Line 520: FROM FII_FIN_ITEM_HIER_GT

516: SELECT parent_fin_cat_id,
517: parent_flex_value_set_id,
518: child_fin_cat_id,
519: child_flex_value_set_id
520: FROM FII_FIN_ITEM_HIER_GT
521: WHERE child_fin_cat_id = p_child_value_id
522: AND next_level_fin_cat_id = child_fin_cat_id
523: AND parent_level = next_level - 1;
524:

Line 658: INSERT INTO fii_fin_item_hier_gt (

654: FOR direct_children_rec IN direct_children_csr(p_vset_id, p_root_node)
655: LOOP
656:
657: /* Inserting record with all parents */
658: INSERT INTO fii_fin_item_hier_gt (
659: parent_level,
660: parent_fin_cat_id,
661: child_fin_cat_id,
662: next_level,

Line 732: g_phase := 'Truncate table FII_FIN_ITEM_HIER_GT';

728: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
729: 'Flatten_Fin_Dim_Hier');
730: END IF;
731:
732: g_phase := 'Truncate table FII_FIN_ITEM_HIER_GT';
733: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIER_GT', 'FII', g_retcode);
734:
735: -----------------------------------------------------------------
736:

Line 733: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIER_GT', 'FII', g_retcode);

729: 'Flatten_Fin_Dim_Hier');
730: END IF;
731:
732: g_phase := 'Truncate table FII_FIN_ITEM_HIER_GT';
733: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIER_GT', 'FII', g_retcode);
734:
735: -----------------------------------------------------------------
736:
737: FINDIM_parent_node := p_root_node;

Line 758: insert into fii_fin_item_hier_gt (

754: INSERT_IMM_CHILD_NODES (p_vset_id, p_root_node);
755:
756: g_phase := 'insert all self nodes';
757:
758: insert into fii_fin_item_hier_gt (
759: parent_level,
760: parent_fin_cat_id,
761: next_level,
762: next_level_fin_cat_id,

Line 780: from (select distinct child_fin_cat_id,child_level,child_flex_value_set_id from fii_fin_item_hier_gt);

776: child_flex_value_set_id,
777: child_flex_value_set_id,
778: 'N',
779: 'N'
780: from (select distinct child_fin_cat_id,child_level,child_flex_value_set_id from fii_fin_item_hier_gt);
781:
782: IF (FIIDIM_Debug) THEN
783: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_fin_item_hier_gt');
784: END IF;

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

779: 'N'
780: from (select distinct child_fin_cat_id,child_level,child_flex_value_set_id from fii_fin_item_hier_gt);
781:
782: IF (FIIDIM_Debug) THEN
783: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_fin_item_hier_gt');
784: END IF;
785:
786: g_phase := 'Insert self node for the top node';
787:

Line 788: INSERT INTO fii_fin_item_hier_gt

784: END IF;
785:
786: g_phase := 'Insert self node for the top node';
787:
788: INSERT INTO fii_fin_item_hier_gt
789: (parent_level,
790: parent_fin_cat_id,
791: next_level,
792: next_level_fin_cat_id,

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

808: 'N',
809: 'N');
810:
811: IF (FIIDIM_Debug) THEN
812: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_fin_item_hier_gt');
813: END IF;
814:
815:
816: --Call FND_STATS to collect statistics after populating the table

Line 817: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';

813: END IF;
814:
815:
816: --Call FND_STATS to collect statistics after populating the table
817: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';
818:
819: FND_STATS.gather_table_stats
820: (ownname => g_schema_name,
821: tabname => 'FII_FIN_ITEM_HIER_GT');

Line 821: tabname => 'FII_FIN_ITEM_HIER_GT');

817: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';
818:
819: FND_STATS.gather_table_stats
820: (ownname => g_schema_name,
821: tabname => 'FII_FIN_ITEM_HIER_GT');
822:
823: --====================================================================
824: --Before we proceed to populate the final hierarchy table, we should
825: --check if there are any diamond shapes in the TMP hierarchy table.

Line 830: -- We use (just created) TMP table FII_FIN_ITEM_HIER_GT for this purpose

826: --If so, we will report the problem, and error out the program
827:
828: -- The following block checks for child value multiple assignments
829: -- to different parents within the value sets
830: -- We use (just created) TMP table FII_FIN_ITEM_HIER_GT for this purpose
831: g_phase := 'Call Detect_Diamond_Shape';
832:
833: Detect_Diamond_Shape;
834:

Line 845: --Update fii_fin_item_hier_gt tab1

841: -- g_phase := 'Update the column next_level_is_leaf';
842:
843: --Per suggestion from performance team,
844: --rewrite the update statement
845: --Update fii_fin_item_hier_gt tab1
846: -- Set next_level_is_leaf = 'Y'
847: -- Where tab1.next_level_fin_cat_id = tab1.child_fin_cat_id
848: -- And 1 = (select count(*)
849: -- from fii_fin_item_hier_gt tab2

Line 849: -- from fii_fin_item_hier_gt tab2

845: --Update fii_fin_item_hier_gt tab1
846: -- Set next_level_is_leaf = 'Y'
847: -- Where tab1.next_level_fin_cat_id = tab1.child_fin_cat_id
848: -- And 1 = (select count(*)
849: -- from fii_fin_item_hier_gt tab2
850: -- where tab2.parent_fin_cat_id = tab1.next_level_fin_cat_id);
851:
852:
853: -------------------------------------------------------

Line 859: --Update fii_fin_item_hier_gt tab1

855: --the full hierarchy since it's not used anywhere
856: -------------------------------------------------------
857:
858: -- Note that we use self record (A,A,A) for tab3 here!
859: --Update fii_fin_item_hier_gt tab1
860: -- Set next_level_is_leaf = 'Y'
861: -- Where tab1.next_level_fin_cat_id = tab1.child_fin_cat_id
862: -- and tab1.next_level_fin_cat_id IN (
863: -- select /*+ ordered */ tab3.next_level_fin_cat_id

Line 864: -- from fii_fin_item_hier_gt tab3,

860: -- Set next_level_is_leaf = 'Y'
861: -- Where tab1.next_level_fin_cat_id = tab1.child_fin_cat_id
862: -- and tab1.next_level_fin_cat_id IN (
863: -- select /*+ ordered */ tab3.next_level_fin_cat_id
864: -- from fii_fin_item_hier_gt tab3,
865: -- fii_fin_item_hier_gt tab2
866: -- where tab2.parent_fin_cat_id = tab3.parent_fin_cat_id
867: -- and tab3.parent_fin_cat_id = tab3.child_fin_cat_id
868: -- group by tab3.next_level_fin_cat_id

Line 865: -- fii_fin_item_hier_gt tab2

861: -- Where tab1.next_level_fin_cat_id = tab1.child_fin_cat_id
862: -- and tab1.next_level_fin_cat_id IN (
863: -- select /*+ ordered */ tab3.next_level_fin_cat_id
864: -- from fii_fin_item_hier_gt tab3,
865: -- fii_fin_item_hier_gt tab2
866: -- where tab2.parent_fin_cat_id = tab3.parent_fin_cat_id
867: -- and tab3.parent_fin_cat_id = tab3.child_fin_cat_id
868: -- group by tab3.next_level_fin_cat_id
869: -- having count(*) = 1);

Line 880: --Update fii_fin_item_hier_gt

876: -------------------------------------------------------
877: --Currently , there is no need to update this column for
878: --the full hierarchy since it's not used anywhere
879: -------------------------------------------------------
880: --Update fii_fin_item_hier_gt
881: -- Set is_leaf_flag = 'Y'
882: --Where parent_fin_cat_id = next_level_fin_cat_id
883: -- and next_level_fin_cat_id = child_fin_cat_id
884: -- and next_level_is_leaf = 'Y';

Line 918: -- Update next_level_is_leaf and is_leaf_flag in FII_FIN_ITEM_HIER_GT

914:
915: END Flatten_Fin_Dim_Hier;
916:
917: -- **************************************************************************
918: -- Update next_level_is_leaf and is_leaf_flag in FII_FIN_ITEM_HIER_GT
919:
920: PROCEDURE Update_GT IS
921:
922: Begin

Line 930: --for the latest FII_FIN_ITEM_HIER_GT

926: 'Update_GT');
927: END IF;
928:
929: --Update the columns next_level_is_leaf, is_leaf_flag
930: --for the latest FII_FIN_ITEM_HIER_GT
931: g_phase := 'Update next_level_is_leaf, is_leaf_flag';
932:
933: --Update the column next_level_is_leaf
934: --We look at those records (P,A,A) in which A is a leaf value

Line 937: Update fii_fin_item_hier_gt tab1

933: --Update the column next_level_is_leaf
934: --We look at those records (P,A,A) in which A is a leaf value
935:
936: --Note that we use self record (A,A,A) for tab3 here!
937: Update fii_fin_item_hier_gt tab1
938: Set next_level_is_leaf = 'Y'
939: Where tab1.next_level_fin_cat_id = tab1.child_fin_cat_id
940: and tab1.next_level_fin_cat_id IN (
941: select /*+ ordered */ tab3.next_level_fin_cat_id

Line 942: from fii_fin_item_hier_gt tab3,

938: Set next_level_is_leaf = 'Y'
939: Where tab1.next_level_fin_cat_id = tab1.child_fin_cat_id
940: and tab1.next_level_fin_cat_id IN (
941: select /*+ ordered */ tab3.next_level_fin_cat_id
942: from fii_fin_item_hier_gt tab3,
943: fii_fin_item_hier_gt tab2
944: where tab2.parent_fin_cat_id = tab3.parent_fin_cat_id
945: and tab3.parent_fin_cat_id = tab3.child_fin_cat_id
946: group by tab3.next_level_fin_cat_id

Line 943: fii_fin_item_hier_gt tab2

939: Where tab1.next_level_fin_cat_id = tab1.child_fin_cat_id
940: and tab1.next_level_fin_cat_id IN (
941: select /*+ ordered */ tab3.next_level_fin_cat_id
942: from fii_fin_item_hier_gt tab3,
943: fii_fin_item_hier_gt tab2
944: where tab2.parent_fin_cat_id = tab3.parent_fin_cat_id
945: and tab3.parent_fin_cat_id = tab3.child_fin_cat_id
946: group by tab3.next_level_fin_cat_id
947: having count(*) = 1);

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

946: group by tab3.next_level_fin_cat_id
947: having count(*) = 1);
948:
949: IF (FIIDIM_Debug) THEN
950: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_fin_item_hier_gt');
951: END IF;
952:
953: g_phase := 'Update is_leaf_flag';
954:

Line 957: Update fii_fin_item_hier_gt

953: g_phase := 'Update is_leaf_flag';
954:
955: --Update the column is_leaf_flag
956: --We look at all records (A,A,A) in which A is a leaf value
957: Update fii_fin_item_hier_gt
958: Set is_leaf_flag = 'Y'
959: Where parent_fin_cat_id = next_level_fin_cat_id
960: and next_level_fin_cat_id = child_fin_cat_id
961: and next_level_is_leaf = 'Y';

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

960: and next_level_fin_cat_id = child_fin_cat_id
961: and next_level_is_leaf = 'Y';
962:
963: IF (FIIDIM_Debug) THEN
964: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_fin_item_hier_gt');
965: END IF;
966:
967: IF (FIIDIM_Debug) THEN
968: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

Line 995: from fii_fin_item_hier_gt

991: , child_fin_cat_id cid
992: , child_level clv
993: , child_flex_value_set_id cvs
994: , is_leaf_flag clf
995: from fii_fin_item_hier_gt
996: where parent_level + 1 = child_level
997: --and child_flex_value_set_id = G_MASTER_VALUE_SET_ID
998: union all
999: select null, G_TOP_NODE_ID, 1, G_MASTER_VALUE_SET_ID, 'N'

Line 1035: update fii_fin_item_hier_gt

1031: END IF;
1032:
1033: FII_UTIL.Write_Log('Updating for parent and child : ' || r_stack( p_top ).cid || ' and ' || r_stack( c_top ).cid );
1034:
1035: update fii_fin_item_hier_gt
1036: set LEVEL2_fin_cat_ID = r_stack( least( p_top + 1, c_top) ).cid
1037: , LEVEL3_fin_cat_ID = r_stack( least( p_top + 2, c_top ) ).cid
1038: , LEVEL4_fin_cat_ID = r_stack( least( p_top + 3, c_top ) ).cid
1039: , LEVEL5_fin_cat_ID = r_stack( least( p_top + 4, c_top ) ).cid

Line 1050: -- Delete the LVS records from FII_FIN_ITEM_HIER_GT table

1046:
1047: END Get_level_populated;
1048:
1049: -- **************************************************************************
1050: -- Delete the LVS records from FII_FIN_ITEM_HIER_GT table
1051:
1052: PROCEDURE Delete_LVS_Records IS
1053:
1054: Begin

Line 1061: --Delete from FII_FIN_ITEM_HIER_GT for child value set not equal to

1057: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1058: 'Delete_LVS_Records');
1059: END IF;
1060:
1061: --Delete from FII_FIN_ITEM_HIER_GT for child value set not equal to
1062: --the master value set
1063: g_phase := 'Delete FII_FIN_ITEM_HIER_GT ';
1064:
1065: Delete from FII_FIN_ITEM_HIER_GT

Line 1063: g_phase := 'Delete FII_FIN_ITEM_HIER_GT ';

1059: END IF;
1060:
1061: --Delete from FII_FIN_ITEM_HIER_GT for child value set not equal to
1062: --the master value set
1063: g_phase := 'Delete FII_FIN_ITEM_HIER_GT ';
1064:
1065: Delete from FII_FIN_ITEM_HIER_GT
1066: Where child_flex_value_set_id <> G_MASTER_VALUE_SET_ID;
1067:

Line 1065: Delete from FII_FIN_ITEM_HIER_GT

1061: --Delete from FII_FIN_ITEM_HIER_GT for child value set not equal to
1062: --the master value set
1063: g_phase := 'Delete FII_FIN_ITEM_HIER_GT ';
1064:
1065: Delete from FII_FIN_ITEM_HIER_GT
1066: Where child_flex_value_set_id <> G_MASTER_VALUE_SET_ID;
1067:
1068:
1069: IF (FIIDIM_Debug) THEN

Line 1070: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows in fii_fin_item_hier_gt');

1066: Where child_flex_value_set_id <> G_MASTER_VALUE_SET_ID;
1067:
1068:
1069: IF (FIIDIM_Debug) THEN
1070: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows in fii_fin_item_hier_gt');
1071: END IF;
1072:
1073: Get_level_populated ;
1074:

Line 1075: --Update FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis

1071: END IF;
1072:
1073: Get_level_populated ;
1074:
1075: --Update FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis
1076: g_phase := 'Update FII_FIN_ITEM_HIER_GT for pruned hierarchy table';
1077:
1078: Update_Gt;
1079:

Line 1076: g_phase := 'Update FII_FIN_ITEM_HIER_GT for pruned hierarchy table';

1072:
1073: Get_level_populated ;
1074:
1075: --Update FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis
1076: g_phase := 'Update FII_FIN_ITEM_HIER_GT for pruned hierarchy table';
1077:
1078: Update_Gt;
1079:
1080: IF (FIIDIM_Debug) THEN

Line 1680: FROM FII_FIN_ITEM_HIER_GT;

1676: FII_USER_ID,
1677: SYSDATE,
1678: FII_USER_ID,
1679: FII_LOGIN_ID
1680: FROM FII_FIN_ITEM_HIER_GT;
1681:
1682: IF (FIIDIM_Debug) THEN
1683: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_FIN_ITEM_HIERS');
1684: END IF;

Line 1699: --Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis

1695: tabname => 'FII_FULL_FIN_ITEM_HIERS');
1696:
1697: --==============================================================--
1698:
1699: --Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis
1700: g_phase := 'Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis';
1701:
1702: Delete_LVS_Records;
1703:

Line 1700: g_phase := 'Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis';

1696:
1697: --==============================================================--
1698:
1699: --Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis
1700: g_phase := 'Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis';
1701:
1702: Delete_LVS_Records;
1703:
1704: --Copy TMP hierarchy table to the final dimension table for Expense Analysis

Line 1755: FROM FII_FIN_ITEM_HIER_GT;

1751: SYSDATE,
1752: FII_USER_ID,
1753: FII_LOGIN_ID,
1754: 'N'
1755: FROM FII_FIN_ITEM_HIER_GT;
1756:
1757: IF (FIIDIM_Debug) THEN
1758: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
1759: END IF;

Line 1763: -- Since leaf nodes are always included we copy FII_FIN_ITEM_HIER_GT to FII_FIN_ITEM_HIERARCHIES

1759: END IF;
1760:
1761: commit;
1762:
1763: -- Since leaf nodes are always included we copy FII_FIN_ITEM_HIER_GT to FII_FIN_ITEM_HIERARCHIES
1764: --Copy FII_FIN_ITEM_HIER_GT hierarchy table to the final dimension table for DBI6.0
1765: g_phase := 'Copy FII_FIN_ITEM_HIER_GT hierarchy table to the final full dimension table for DBI 6.0';
1766:
1767: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);

Line 1764: --Copy FII_FIN_ITEM_HIER_GT hierarchy table to the final dimension table for DBI6.0

1760:
1761: commit;
1762:
1763: -- Since leaf nodes are always included we copy FII_FIN_ITEM_HIER_GT to FII_FIN_ITEM_HIERARCHIES
1764: --Copy FII_FIN_ITEM_HIER_GT hierarchy table to the final dimension table for DBI6.0
1765: g_phase := 'Copy FII_FIN_ITEM_HIER_GT hierarchy table to the final full dimension table for DBI 6.0';
1766:
1767: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);
1768:

Line 1765: g_phase := 'Copy FII_FIN_ITEM_HIER_GT hierarchy table to the final full dimension table for DBI 6.0';

1761: commit;
1762:
1763: -- Since leaf nodes are always included we copy FII_FIN_ITEM_HIER_GT to FII_FIN_ITEM_HIERARCHIES
1764: --Copy FII_FIN_ITEM_HIER_GT hierarchy table to the final dimension table for DBI6.0
1765: g_phase := 'Copy FII_FIN_ITEM_HIER_GT hierarchy table to the final full dimension table for DBI 6.0';
1766:
1767: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);
1768:
1769: INSERT /*+ APPEND */ INTO FII_FIN_ITEM_HIERARCHIES (

Line 1801: FROM FII_FIN_ITEM_HIER_GT;

1797: FII_USER_ID,
1798: SYSDATE,
1799: FII_USER_ID,
1800: FII_LOGIN_ID
1801: FROM FII_FIN_ITEM_HIER_GT;
1802:
1803: IF (FIIDIM_Debug) THEN
1804: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_HIERARCHIES');
1805: END IF;

Line 2125: FROM FII_FIN_ITEM_HIER_GT;

2121: FII_USER_ID,
2122: SYSDATE,
2123: FII_USER_ID,
2124: FII_LOGIN_ID
2125: FROM FII_FIN_ITEM_HIER_GT;
2126:
2127: commit;
2128:
2129: IF (FIIDIM_Debug) THEN

Line 2144: --Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis

2140: tabname => 'FII_FULL_FIN_ITEM_HIERS');
2141:
2142: --==============================================================--
2143:
2144: --Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis
2145: g_phase := 'Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis';
2146:
2147: Delete_LVS_Records;
2148:

Line 2145: g_phase := 'Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis';

2141:
2142: --==============================================================--
2143:
2144: --Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis
2145: g_phase := 'Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis';
2146:
2147: Delete_LVS_Records;
2148:
2149: --Copy FII_FIN_ITEM_HIER_GT to the final (pruned) dimension table for Expense Analysis

Line 2149: --Copy FII_FIN_ITEM_HIER_GT to the final (pruned) dimension table for Expense Analysis

2145: g_phase := 'Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis';
2146:
2147: Delete_LVS_Records;
2148:
2149: --Copy FII_FIN_ITEM_HIER_GT to the final (pruned) dimension table for Expense Analysis
2150:
2151: -- Incremental Dimension Maintence
2152: -- All data is now in the temporary table FII_FIN_ITEM_HIER_GT,
2153: -- we need to maintain the permanent table FII_FIN_ITEM__LEAF_HIERS

Line 2152: -- All data is now in the temporary table FII_FIN_ITEM_HIER_GT,

2148:
2149: --Copy FII_FIN_ITEM_HIER_GT to the final (pruned) dimension table for Expense Analysis
2150:
2151: -- Incremental Dimension Maintence
2152: -- All data is now in the temporary table FII_FIN_ITEM_HIER_GT,
2153: -- we need to maintain the permanent table FII_FIN_ITEM__LEAF_HIERS
2154: -- by diffing the 2 tables.
2155: -- The maintenance is done by 2 statements, one INSERT and one DELETE.
2156:

Line 2187: FROM FII_FIN_ITEM_HIER_GT);

2183: LEVEL2_fin_cat_ID,
2184: LEVEL3_fin_cat_ID,
2185: LEVEL4_fin_cat_ID,
2186: LEVEL5_fin_cat_ID
2187: FROM FII_FIN_ITEM_HIER_GT);
2188:
2189: IF (FIIDIM_Debug) THEN
2190: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FIN_ITEM_LEAF_HIERS');
2191: END IF;

Line 2240: FROM FII_FIN_ITEM_HIER_GT

2236: SYSDATE,
2237: FII_USER_ID,
2238: FII_LOGIN_ID,
2239: 'N'
2240: FROM FII_FIN_ITEM_HIER_GT
2241: MINUS
2242: SELECT parent_level,
2243: parent_fin_cat_id,
2244: next_level,

Line 2270: --Copy FII_FIN_ITEM_HIER_GT to the final (pruned) dimension table for DBI6.0

2266: IF (FIIDIM_Debug) THEN
2267: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
2268: END IF;
2269:
2270: --Copy FII_FIN_ITEM_HIER_GT to the final (pruned) dimension table for DBI6.0
2271:
2272: -- Incremental Dimension Maintence
2273: -- All data is now in the temporary table FII_FIN_ITEM_LEAF_HIERS,
2274: -- we need to maintain the permanent table FII_FIN_ITEM_HIERARCHIES

Line 2293: FROM FII_FIN_ITEM_HIER_GT);

2289: MINUS
2290: SELECT parent_level, parent_fin_cat_id, next_level, next_level_fin_cat_id,
2291: next_level_is_leaf, is_leaf_flag, child_level, child_fin_cat_id,
2292: parent_flex_value_set_id, child_flex_value_set_id
2293: FROM FII_FIN_ITEM_HIER_GT);
2294:
2295: IF (FIIDIM_Debug) THEN
2296: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FIN_ITEM_HIERARCHIES');
2297: END IF;

Line 2332: FROM FII_FIN_ITEM_HIER_GT

2328: FII_USER_ID,
2329: SYSDATE,
2330: FII_USER_ID,
2331: FII_LOGIN_ID
2332: FROM FII_FIN_ITEM_HIER_GT
2333: MINUS
2334: SELECT parent_level,
2335: parent_fin_cat_id,
2336: next_level,