APPS.FII_AR_CUSTOMER_DIMENSION_PKG dependencies on FII_AR_CUST_RLNS_GT

Line 179: -- FII_AR_Cust_Rlns_GT (Direct DBI Relationships).

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:
183: IF g_hierarchy_type IS NOT NULL THEN

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 199: FII_AR_CUST_RLNS_GT is populated with all direct relationships in the

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:
199: FII_AR_CUST_RLNS_GT is populated with all direct relationships in the
200: DBI hierarchy. The DBI hierarchy differs from the TCA hierarchy
201: because of the pseudo top node, -999. So additional records must be
202: inserted from -999 to any top node party. Party pairs in this table
203: will be used to populate Parent_Party_ID and Next_Level_Party_ID in

Line 213: THEN INTO FII_AR_Cust_Rlns_GT(

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(
214: Parent_ID,
215: Next_ID)
216: VALUES (CASE WHEN Level_Number = 0 THEN -999
217: ELSE Parent_ID END,

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 270: FROM FII_AR_Cust_Rlns_GT PTN,

266: g_fii_user_id,
267: sysdate,
268: g_fii_user_id,
269: g_fii_login_id
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

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 798: THEN INTO FII_AR_Cust_Rlns_GT(

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(
799: Parent_ID,
800: Next_ID)
801: VALUES (CASE WHEN Level_Number = 0 THEN -999
802: ELSE Parent_ID END,

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 847: FROM FII_AR_Cust_Rlns_GT PTN,

843: DECODE(g_hierarchy_type, NULL, 'N', 'Y') Is_Hierarchical_Flag,
844: CASE WHEN Temp.ID = 1 THEN 1
845: ELSE 0 END Parent_To_Next_Level,
846: HN.Level_Number Next_To_Child_Level
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