APPS.FII_AR_CUSTOMER_DIMENSION_PKG dependencies on FII_AR_CACCTS_D_GT

Line 490: TYPE CAcct_Denorm_D_Type IS TABLE OF FII_AR_CACCTS_D_GT%ROWTYPE

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;
492:
493: FII_Cust_Hier_Old_MS Customer_Hierarchies_Type;
494: FII_Cust_Hier_New_MS Cust_Hier_Tmp_Type;

Line 514: l_d_cad FII_AR_CACCTS_D_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;
515:
516: BEGIN
517:
518: g_state := 'Inside the INCRE_UPDATE procedure.';

Line 1388: g_state := 'Bulk inserting into FII_AR_CAccts_D_GT from FII_CAcct_Denorm_D_MS.';

1384: FII_UTIL.stop_timer;
1385: FII_UTIL.print_timer('Duration');
1386: end if;
1387:
1388: g_state := 'Bulk inserting into FII_AR_CAccts_D_GT from FII_CAcct_Denorm_D_MS.';
1389: if g_debug_flag = 'Y' then
1390: FII_UTIL.put_line(g_state);
1391: FII_UTIL.start_timer;
1392: end if;

Line 1396: INSERT INTO FII_AR_CAccts_D_GT VALUES FII_CAcct_Denorm_D_MS(i);

1392: end if;
1393:
1394: IF FII_CAcct_Denorm_D_MS.Count > 0 THEN
1395: FORALL i IN FII_CAcct_Denorm_D_MS.First..FII_CAcct_Denorm_D_MS.Last
1396: INSERT INTO FII_AR_CAccts_D_GT VALUES FII_CAcct_Denorm_D_MS(i);
1397: END IF;
1398:
1399: if g_debug_flag = 'Y' then
1400: FII_UTIL.put_line('Completed populating FII_AR_CAccts_D_GT.');

Line 1400: FII_UTIL.put_line('Completed populating FII_AR_CAccts_D_GT.');

1396: INSERT INTO FII_AR_CAccts_D_GT VALUES FII_CAcct_Denorm_D_MS(i);
1397: END IF;
1398:
1399: if g_debug_flag = 'Y' then
1400: FII_UTIL.put_line('Completed populating FII_AR_CAccts_D_GT.');
1401: FII_UTIL.stop_timer;
1402: FII_UTIL.print_timer('Duration');
1403: end if;
1404:

Line 1475: g_state := 'Deleting records from FII_Cust_Accounts using FII_AR_CAccts_D_GT';

1471: FII_UTIL.stop_timer;
1472: FII_UTIL.print_timer('Duration');
1473: end if;
1474:
1475: g_state := 'Deleting records from FII_Cust_Accounts using FII_AR_CAccts_D_GT';
1476: if g_debug_flag = 'Y' then
1477: FII_UTIL.put_line(g_state);
1478: FII_UTIL.start_timer;
1479: end if;

Line 1483: FROM FII_AR_CAccts_D_GT D

1479: end if;
1480:
1481: DELETE FROM FII_Cust_Accounts CAD
1482: WHERE EXISTS (SELECT 1
1483: FROM FII_AR_CAccts_D_GT D
1484: WHERE D.Parent_Party_ID = CAD.Parent_Party_ID
1485: AND D.Cust_Account_ID = CAD.Cust_Account_ID);
1486:
1487: if g_debug_flag = 'Y' then