APPS.FII_SNAP_TBL_REFRESH dependencies on FII_GL_SNAP_SUM_F

Line 755: -- This procedure will (fully) refresh table FII_GL_SNAP_SUM_F

751:
752: ----------------------------------------------------
753: -- PROCEDURE REFRESH_GL_SNAP_SUM_F (private)
754: --
755: -- This procedure will (fully) refresh table FII_GL_SNAP_SUM_F
756: -- FROM FII_GL_SNAP_F.
757: -- It aggregates along Financial Category, Company, Cost Center.
758: -- AND User Defined 1 dimensions to the upper portions.
759: ----------------------------------------------------

Line 770: g_phase := 'Truncate table FII_GL_SNAP_SUM_F';

766: FII_UTIL.Write_Log ('> Entering REFRESH_GL_SNAP_SUM_F');
767: FII_UTIL.start_timer();
768: END IF;
769:
770: g_phase := 'Truncate table FII_GL_SNAP_SUM_F';
771: FII_UTIL.truncate_table ('FII_GL_SNAP_SUM_F', 'FII', g_retcode);
772:
773: g_phase := 'Starting to populate table FII_GL_SNAP_SUM_F';
774: IF g_debug_flag = 'Y' THEN

Line 771: FII_UTIL.truncate_table ('FII_GL_SNAP_SUM_F', 'FII', g_retcode);

767: FII_UTIL.start_timer();
768: END IF;
769:
770: g_phase := 'Truncate table FII_GL_SNAP_SUM_F';
771: FII_UTIL.truncate_table ('FII_GL_SNAP_SUM_F', 'FII', g_retcode);
772:
773: g_phase := 'Starting to populate table FII_GL_SNAP_SUM_F';
774: IF g_debug_flag = 'Y' THEN
775: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_SNAP_SUM_F');

Line 773: g_phase := 'Starting to populate table FII_GL_SNAP_SUM_F';

769:
770: g_phase := 'Truncate table FII_GL_SNAP_SUM_F';
771: FII_UTIL.truncate_table ('FII_GL_SNAP_SUM_F', 'FII', g_retcode);
772:
773: g_phase := 'Starting to populate table FII_GL_SNAP_SUM_F';
774: IF g_debug_flag = 'Y' THEN
775: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_SNAP_SUM_F');
776: END IF;
777:

Line 775: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_SNAP_SUM_F');

771: FII_UTIL.truncate_table ('FII_GL_SNAP_SUM_F', 'FII', g_retcode);
772:
773: g_phase := 'Starting to populate table FII_GL_SNAP_SUM_F';
774: IF g_debug_flag = 'Y' THEN
775: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_SNAP_SUM_F');
776: END IF;
777:
778: insert /*+ append */ INTO FII_GL_SNAP_SUM_F
779: (

Line 778: insert /*+ append */ INTO FII_GL_SNAP_SUM_F

774: IF g_debug_flag = 'Y' THEN
775: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_SNAP_SUM_F');
776: END IF;
777:
778: insert /*+ append */ INTO FII_GL_SNAP_SUM_F
779: (
780: COST_CENTER_DIM_ID,
781: PARENT_COST_CENTER_DIM_ID,
782: COMPANY_DIM_ID,

Line 1050: FII_UTIL.Write_Log ( 'FII_GL_SNAP_SUM_F has been populated successfully' );

1046: b.posted_date;
1047:
1048: IF g_debug_flag = 'Y' THEN
1049: FII_UTIL.stop_timer();
1050: FII_UTIL.Write_Log ( 'FII_GL_SNAP_SUM_F has been populated successfully' );
1051: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
1052: FII_UTIL.print_timer();
1053: END IF;
1054:

Line 1055: g_phase := 'Gather table stats for FII_GL_SNAP_SUM_F';

1051: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
1052: FII_UTIL.print_timer();
1053: END IF;
1054:
1055: g_phase := 'Gather table stats for FII_GL_SNAP_SUM_F';
1056: fnd_stats.gather_table_stats (ownname=>g_schema_name,
1057: tabname=>'FII_GL_SNAP_SUM_F');
1058:
1059: g_phase := 'Commit the change';

Line 1057: tabname=>'FII_GL_SNAP_SUM_F');

1053: END IF;
1054:
1055: g_phase := 'Gather table stats for FII_GL_SNAP_SUM_F';
1056: fnd_stats.gather_table_stats (ownname=>g_schema_name,
1057: tabname=>'FII_GL_SNAP_SUM_F');
1058:
1059: g_phase := 'Commit the change';
1060: commit;
1061:

Line 2017: g_phase := 'Populating FII_GL_SNAP_SUM_F';

2013: END IF;
2014:
2015: REFRESH_GL_SNAP_F;
2016:
2017: g_phase := 'Populating FII_GL_SNAP_SUM_F';
2018: IF g_debug_flag = 'Y' THEN
2019: FII_UTIL.Write_Log ('Populating FII_GL_SNAP_SUM_F');
2020: END IF;
2021:

Line 2019: FII_UTIL.Write_Log ('Populating FII_GL_SNAP_SUM_F');

2015: REFRESH_GL_SNAP_F;
2016:
2017: g_phase := 'Populating FII_GL_SNAP_SUM_F';
2018: IF g_debug_flag = 'Y' THEN
2019: FII_UTIL.Write_Log ('Populating FII_GL_SNAP_SUM_F');
2020: END IF;
2021:
2022: REFRESH_GL_SNAP_SUM_F;
2023: