APPS.FII_AR_CUSTOMER_DIMENSION_PKG dependencies on FII_AR_CUST_HIER_TMP_GT

Line 475: TYPE Cust_Hier_Tmp_Type IS TABLE OF FII_AR_CUST_HIER_TMP_GT%ROWTYPE

471:
472: TYPE Customer_Hierarchies_Type IS TABLE OF FII_CUSTOMER_HIERARCHIES%ROWTYPE
473: INDEX BY BINARY_INTEGER;
474:
475: TYPE Cust_Hier_Tmp_Type IS TABLE OF FII_AR_CUST_HIER_TMP_GT%ROWTYPE
476: INDEX BY BINARY_INTEGER;
477:
478: TYPE Cust_Account_Denorm_Type IS TABLE OF FII_CUST_ACCOUNTS%ROWTYPE
479: INDEX BY BINARY_INTEGER;

Line 508: l_new_ch FII_AR_CUST_HIER_TMP_GT%ROWTYPE;

504: l_cacct_denorm_old_marker BINARY_INTEGER;
505: l_cacct_denorm_new_marker BINARY_INTEGER;
506:
507: l_old_ch FII_CUSTOMER_HIERARCHIES%ROWTYPE;
508: l_new_ch FII_AR_CUST_HIER_TMP_GT%ROWTYPE;
509: l_ui_ch FII_AR_CUST_HIER_UI_GT%ROWTYPE;
510: l_d_ch FII_AR_CUST_HIER_D_GT%ROWTYPE;
511: l_old_cad FII_CUST_ACCOUNTS%ROWTYPE;
512: l_new_cad FII_AR_CACCTS_TMP_GT%ROWTYPE;

Line 824: g_state := 'Populate FII_AR_Cust_Hier_Tmp_GT.';

820: FII_UTIL.stop_timer;
821: FII_UTIL.print_timer('Duration');
822: end if;
823:
824: g_state := 'Populate FII_AR_Cust_Hier_Tmp_GT.';
825: if g_debug_flag = 'Y' then
826: FII_UTIL.put_line(g_state);
827: FII_UTIL.start_timer;
828: end if;

Line 830: INSERT INTO FII_AR_Cust_Hier_Tmp_GT(

826: FII_UTIL.put_line(g_state);
827: FII_UTIL.start_timer;
828: end if;
829:
830: INSERT INTO FII_AR_Cust_Hier_Tmp_GT(
831: Parent_Party_ID,
832: Next_Level_Party_ID,
833: Child_Party_ID,
834: Next_Level_Is_Leaf_Flag,

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

855: AND g_sysdate BETWEEN HN.Effective_Start_Date AND HN.Effective_End_Date
856: AND PTN.Next_ID = Leaf.Leaf_Node_ID (+);
857:
858: if g_debug_flag = 'Y' then
859: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AR_Cust_Hier_Tmp_GT.');
860: FII_UTIL.stop_timer;
861: FII_UTIL.print_timer('Duration');
862: end if;
863:

Line 910: g_state := 'Populating FII_AR_Cust_Hier_Tmp_GT with new non-hierarchical customers and FII_AR_CAccts_Tmp_GT with all new customers.';

906: FII_UTIL.stop_timer;
907: FII_UTIL.print_timer('Duration');
908: end if;
909:
910: g_state := 'Populating FII_AR_Cust_Hier_Tmp_GT with new non-hierarchical customers and FII_AR_CAccts_Tmp_GT with all new customers.';
911: if g_debug_flag = 'Y' then
912: FII_UTIL.put_line(g_state);
913: FII_UTIL.start_timer;
914: end if;

Line 938: THEN INTO FII_AR_Cust_Hier_Tmp_GT(

934: Cust_Account_ID,
935: Party_ID,
936: Account_Number)
937: WHEN (Parent_Party_ID IS NULL AND SRLID = 1)
938: THEN INTO FII_AR_Cust_Hier_Tmp_GT(
939: Parent_Party_ID,
940: Next_Level_Party_ID,
941: Child_Party_ID,
942: Next_Level_Is_Leaf_Flag,

Line 954: THEN INTO FII_AR_Cust_Hier_Tmp_GT(

950: DECODE(g_hierarchy_type, NULL, 'N', 'Y'),
951: 1,
952: 0)
953: WHEN (Parent_Party_ID IS NULL AND SRLID = 1)
954: THEN INTO FII_AR_Cust_Hier_Tmp_GT(
955: Parent_Party_ID,
956: Next_Level_Party_ID,
957: Child_Party_ID,
958: Next_Level_Is_Leaf_Flag,

Line 984: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AR_Cust_Hier_Tmp_GT and FII_AR_CAccts_Tmp_GT.');

980: AND g_sysdate BETWEEN Effective_Start_Date AND Effective_End_Date) Hier
981: WHERE CA.Party_ID = Hier.Child_ID (+);
982:
983: if g_debug_flag = 'Y' then
984: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AR_Cust_Hier_Tmp_GT and FII_AR_CAccts_Tmp_GT.');
985: FII_UTIL.stop_timer;
986: FII_UTIL.print_timer('Duration');
987: end if;
988:

Line 1055: FROM FII_AR_Cust_Hier_Tmp_GT CH

1051: end if;
1052:
1053: SELECT *
1054: BULK COLLECT INTO FII_Cust_Hier_New_MS
1055: FROM FII_AR_Cust_Hier_Tmp_GT CH
1056: ORDER BY Parent_Party_ID, Next_Level_Party_ID, Child_Party_ID;
1057:
1058: if g_debug_flag = 'Y' then
1059: FII_UTIL.put_line('Inserted ' || FII_Cust_Hier_New_MS.COUNT || ' records into FII_Cust_Hier_New_MS.');