APPS.FII_AR_CUSTOMER_DIMENSION_PKG dependencies on FII_AR_CUST_HIER_D_GT

Line 487: TYPE Cust_Hier_D_Type IS TABLE OF FII_AR_CUST_HIER_D_GT%ROWTYPE

483:
484: TYPE Cust_Hier_UI_Type IS TABLE OF FII_AR_CUST_HIER_UI_GT%ROWTYPE
485: INDEX BY BINARY_INTEGER;
486:
487: TYPE Cust_Hier_D_Type IS TABLE OF FII_AR_CUST_HIER_D_GT%ROWTYPE
488: INDEX BY BINARY_INTEGER;
489:
490: TYPE CAcct_Denorm_D_Type IS TABLE OF FII_AR_CACCTS_D_GT%ROWTYPE
491: INDEX BY BINARY_INTEGER;

Line 510: l_d_ch FII_AR_CUST_HIER_D_GT%ROWTYPE;

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;
513: l_i_cad FII_CUST_ACCOUNTS%ROWTYPE;
514: l_d_cad FII_AR_CACCTS_D_GT%ROWTYPE;

Line 1371: g_state := 'Bulk inserting into FII_AR_Cust_Hier_D_GT from FII_Cust_Hier_D_MS.';

1367: FII_UTIL.stop_timer;
1368: FII_UTIL.print_timer('Duration');
1369: end if;
1370:
1371: g_state := 'Bulk inserting into FII_AR_Cust_Hier_D_GT from FII_Cust_Hier_D_MS.';
1372: if g_debug_flag = 'Y' then
1373: FII_UTIL.put_line(g_state);
1374: FII_UTIL.start_timer;
1375: end if;

Line 1379: INSERT INTO FII_AR_Cust_Hier_D_GT VALUES FII_Cust_Hier_D_MS(i);

1375: end if;
1376:
1377: IF FII_Cust_Hier_D_MS.Count > 0 THEN
1378: FORALL i IN FII_Cust_Hier_D_MS.First..FII_Cust_Hier_D_MS.Last
1379: INSERT INTO FII_AR_Cust_Hier_D_GT VALUES FII_Cust_Hier_D_MS(i);
1380: END IF;
1381:
1382: if g_debug_flag = 'Y' then
1383: FII_UTIL.put_line('Completed populating FII_AR_Cust_Hier_D_GT.');

Line 1383: FII_UTIL.put_line('Completed populating FII_AR_Cust_Hier_D_GT.');

1379: INSERT INTO FII_AR_Cust_Hier_D_GT VALUES FII_Cust_Hier_D_MS(i);
1380: END IF;
1381:
1382: if g_debug_flag = 'Y' then
1383: FII_UTIL.put_line('Completed populating FII_AR_Cust_Hier_D_GT.');
1384: FII_UTIL.stop_timer;
1385: FII_UTIL.print_timer('Duration');
1386: end if;
1387:

Line 1405: g_state := 'Deleting records from FII_Customer_Hierarchies using FII_AR_Cust_Hier_D_GT';

1401: FII_UTIL.stop_timer;
1402: FII_UTIL.print_timer('Duration');
1403: end if;
1404:
1405: g_state := 'Deleting records from FII_Customer_Hierarchies using FII_AR_Cust_Hier_D_GT';
1406: if g_debug_flag = 'Y' then
1407: FII_UTIL.put_line(g_state);
1408: FII_UTIL.start_timer;
1409: end if;

Line 1413: FROM FII_AR_Cust_Hier_D_GT D

1409: end if;
1410:
1411: DELETE FROM FII_Customer_Hierarchies CH
1412: WHERE EXISTS (SELECT 1
1413: FROM FII_AR_Cust_Hier_D_GT D
1414: WHERE D.Parent_Party_ID = CH.Parent_Party_ID
1415: AND D.Next_Level_Party_ID = CH.Next_Level_Party_ID
1416: AND D.Child_Party_ID = CH.Child_Party_ID);
1417: