APPS.FII_AR_CUSTOMER_DIMENSION_PKG dependencies on FII_AR_CUST_LNODES_GT

Line 178: --1. Populate intermediate tables FII_AR_Cust_LNodes_GT (Leaf Nodes) and

174: VALUES ('MAX_BATCH_PARTY_ID', l_max_batch_party_id, sysdate, g_fii_user_id, sysdate, g_fii_login_id, g_fii_user_id);
175: END IF;
176:
177: --If a hierarchy_type is chosen, populate hierarchical parties:
178: --1. Populate intermediate tables FII_AR_Cust_LNodes_GT (Leaf Nodes) and
179: -- FII_AR_Cust_Rlns_GT (Direct DBI Relationships).
180: --2. Populate FII_Customer_Hierarchies.
181:
182:

Line 185: g_state := 'Populating intermediate tables FII_AR_Cust_LNodes_GT and FII_AR_Cust_Rlns_GT.';

181:
182:
183: IF g_hierarchy_type IS NOT NULL THEN
184:
185: g_state := 'Populating intermediate tables FII_AR_Cust_LNodes_GT and FII_AR_Cust_Rlns_GT.';
186: if g_debug_flag = 'Y' then
187: FII_UTIL.put_line(g_state);
188: FII_UTIL.start_timer;
189: end if;

Line 194: FII_AR_CUST_LNODES_GT is populated with leaf node parties. The only

190:
191: /* With one scan of HZ_Hierarchy_Nodes, this sql populates 2 intermediate
192: tables to be used later:
193:
194: FII_AR_CUST_LNODES_GT is populated with leaf node parties. The only
195: way to detect leaf nodes is using the Leaf_Child_Flag column of
196: HZ_Hierarchy_Nodes for self-records. This table will later be used
197: to populate Next_Level_Is_Leaf_Flag in FII_Customer_Hierarchies.
198:

Line 209: THEN INTO FII_AR_Cust_LNodes_GT(

205:
206:
207: INSERT ALL
208: WHEN (Leaf_Child_Flag = 'Y')
209: THEN INTO FII_AR_Cust_LNodes_GT(
210: Leaf_Node_ID)
211: VALUES (Parent_ID)
212: WHEN (Top_Parent_Flag = 'Y' OR Level_Number = 1)
213: THEN INTO FII_AR_Cust_Rlns_GT(

Line 232: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AR_Cust_LNodes_GT and FII_AR_Cust_Rlns_GT');

228: (Level_Number = 0 AND (Top_Parent_Flag = 'Y' OR Leaf_Child_Flag = 'Y')) )
229: AND g_sysdate BETWEEN Effective_Start_Date AND Effective_End_Date;
230:
231: if g_debug_flag = 'Y' then
232: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AR_Cust_LNodes_GT and FII_AR_Cust_Rlns_GT');
233: FII_UTIL.stop_timer;
234: FII_UTIL.print_timer('Duration');
235: end if;
236:

Line 274: FII_AR_Cust_LNodes_GT Leaf

270: FROM FII_AR_Cust_Rlns_GT PTN,
271: HZ_Hierarchy_Nodes HN,
272: (SELECT 1 ID FROM Dual UNION
273: SELECT 2 ID FROM Dual) Temp,
274: FII_AR_Cust_LNodes_GT Leaf
275: WHERE PTN.Next_ID = HN.Parent_ID
276: AND (Temp.ID = 1 OR HN.Parent_ID = HN.Child_ID)
277: AND HN.Hierarchy_Type = g_hierarchy_type
278: AND g_sysdate BETWEEN HN.Effective_Start_Date AND HN.Effective_End_Date

Line 786: g_state := 'Populate FII_AR_Cust_LNodes_GT and FII_AR_Cust_Rlns_GT.';

782: FII_UTIL.print_timer('Duration');
783: end if;
784:
785:
786: g_state := 'Populate FII_AR_Cust_LNodes_GT and FII_AR_Cust_Rlns_GT.';
787: if g_debug_flag = 'Y' then
788: FII_UTIL.put_line(g_state);
789: FII_UTIL.start_timer;
790: end if;

Line 794: THEN INTO FII_AR_Cust_LNodes_GT(

790: end if;
791:
792: INSERT ALL
793: WHEN (Leaf_Child_Flag = 'Y')
794: THEN INTO FII_AR_Cust_LNodes_GT(
795: Leaf_Node_ID)
796: VALUES (Parent_ID)
797: WHEN (Top_Parent_Flag = 'Y' OR Level_Number = 1)
798: THEN INTO FII_AR_Cust_Rlns_GT(

Line 819: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AR_Cust_LNodes_GT and FII_AR_Cust_Rlns_GT.');

815: (Level_Number = 0 AND (Top_Parent_Flag = 'Y' OR Leaf_Child_Flag = 'Y')) )
816: AND g_sysdate BETWEEN Effective_Start_Date AND Effective_End_Date;
817:
818: if g_debug_flag = 'Y' then
819: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AR_Cust_LNodes_GT and FII_AR_Cust_Rlns_GT.');
820: FII_UTIL.stop_timer;
821: FII_UTIL.print_timer('Duration');
822: end if;
823:

Line 851: FII_AR_Cust_LNodes_GT Leaf

847: FROM FII_AR_Cust_Rlns_GT PTN,
848: HZ_Hierarchy_Nodes HN,
849: (SELECT 1 ID FROM Dual UNION
850: SELECT 2 ID FROM Dual) Temp,
851: FII_AR_Cust_LNodes_GT Leaf
852: WHERE PTN.Next_ID = HN.Parent_ID
853: AND (Temp.ID = 1 OR HN.Parent_ID = HN.Child_ID)
854: AND HN.Hierarchy_Type = g_hierarchy_type
855: AND g_sysdate BETWEEN HN.Effective_Start_Date AND HN.Effective_End_Date