APPS.FII_AR_CUSTOMER_DIMENSION_PKG dependencies on FII_AR_TOP_TO_SOURCE_GT

Line 676: THEN INTO FII_AR_Top_To_Source_GT(

672: THEN INTO FII_AR_Parties_Level2_GT(
673: Party_ID)
674: VALUES(Child_ID)
675: WHEN (SRLID=1)
676: THEN INTO FII_AR_Top_To_Source_GT(
677: Top_Node_ID,
678: Source_Node_ID,
679: Level_Number)
680: VALUES(Parent_ID,

Line 732: g_state := 'Populate FII_AR_Top_To_Source_GT with descendants of parties already in FII_AR_Top_To_Source_GT.';

728: FII_UTIL.stop_timer;
729: FII_UTIL.print_timer('Duration');
730: end if;
731:
732: g_state := 'Populate FII_AR_Top_To_Source_GT with descendants of parties already in FII_AR_Top_To_Source_GT.';
733: if g_debug_flag = 'Y' then
734: FII_UTIL.put_line(g_state);
735: FII_UTIL.start_timer;
736: end if;

Line 738: INSERT INTO FII_AR_Top_To_Source_GT(

734: FII_UTIL.put_line(g_state);
735: FII_UTIL.start_timer;
736: end if;
737:
738: INSERT INTO FII_AR_Top_To_Source_GT(
739: Top_Node_ID,
740: Source_Node_ID,
741: Level_Number)
742: SELECT GT.Top_Node_ID,

Line 745: FROM FII_AR_Top_To_Source_GT GT,

741: Level_Number)
742: SELECT GT.Top_Node_ID,
743: HN.Child_ID,
744: GT.Level_Number + HN.Level_Number Level_Number
745: FROM FII_AR_Top_To_Source_GT GT,
746: HZ_Hierarchy_Nodes HN
747: WHERE GT.Source_Node_ID = HN.Parent_ID
748: AND HN.Hierarchy_Type = g_hierarchy_type
749: AND g_sysdate BETWEEN HN.Effective_Start_Date AND HN.Effective_End_Date

Line 753: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AR_Top_To_Source_GT.');

749: AND g_sysdate BETWEEN HN.Effective_Start_Date AND HN.Effective_End_Date
750: AND HN.Level_Number > 0;
751:
752: if g_debug_flag = 'Y' then
753: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AR_Top_To_Source_GT.');
754: FII_UTIL.stop_timer;
755: FII_UTIL.print_timer('Duration');
756: end if;
757:

Line 989: g_state := 'Merging records in FII_Customer_Hierarchies using FII_AR_Top_To_Source_GT.';

985: FII_UTIL.stop_timer;
986: FII_UTIL.print_timer('Duration');
987: end if;
988:
989: g_state := 'Merging records in FII_Customer_Hierarchies using FII_AR_Top_To_Source_GT.';
990: if g_debug_flag = 'Y' then
991: FII_UTIL.put_line(g_state);
992: FII_UTIL.start_timer;
993: end if;

Line 997: FROM FII_AR_Top_To_Source_GT) GT

993: end if;
994:
995: MERGE INTO FII_Customer_Hierarchies CH
996: USING (SELECT DISTINCT Top_Node_ID, Source_Node_ID, Level_Number
997: FROM FII_AR_Top_To_Source_GT) GT
998: ON (CH.Parent_Party_ID = -999 AND
999: CH.Child_Party_ID = GT.Source_Node_ID)
1000: WHEN MATCHED THEN
1001: UPDATE SET CH.Next_Level_Party_ID = GT.Top_Node_ID,