APPS.FII_SNAP_TBL_REFRESH dependencies on FII_GL_LOCAL_SNAP_F

Line 1082: -- This procedure will (fully) refresh table FII_GL_LOCAL_SNAP_F

1078:
1079: ----------------------------------------------------
1080: -- PROCEDURE REFRESH_GL_LOCAL_SNAP_F (private)
1081: --
1082: -- This procedure will (fully) refresh table FII_GL_LOCAL_SNAP_F
1083: -- FROM FII_GL_JE_SUMMARY_B.
1084: -- It populates data FROM GL base summary by changing rows INTO columns
1085: ----------------------------------------------------
1086: PROCEDURE REFRESH_GL_LOCAL_SNAP_F IS

Line 1123: g_phase := 'Truncate table FII_GL_LOCAL_SNAP_F';

1119: FII_UTIL.Write_Log ('>> l_year_id = ' || l_year_id);
1120: FII_UTIL.Write_Log (' ');
1121: END IF;
1122:
1123: g_phase := 'Truncate table FII_GL_LOCAL_SNAP_F';
1124: FII_UTIL.truncate_table ('FII_GL_LOCAL_SNAP_F', 'FII', g_retcode);
1125:
1126: g_phase := 'Starting to populate table FII_GL_LOCAL_SNAP_F';
1127: IF g_debug_flag = 'Y' THEN

Line 1124: FII_UTIL.truncate_table ('FII_GL_LOCAL_SNAP_F', 'FII', g_retcode);

1120: FII_UTIL.Write_Log (' ');
1121: END IF;
1122:
1123: g_phase := 'Truncate table FII_GL_LOCAL_SNAP_F';
1124: FII_UTIL.truncate_table ('FII_GL_LOCAL_SNAP_F', 'FII', g_retcode);
1125:
1126: g_phase := 'Starting to populate table FII_GL_LOCAL_SNAP_F';
1127: IF g_debug_flag = 'Y' THEN
1128: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_LOCAL_SNAP_F');

Line 1126: g_phase := 'Starting to populate table FII_GL_LOCAL_SNAP_F';

1122:
1123: g_phase := 'Truncate table FII_GL_LOCAL_SNAP_F';
1124: FII_UTIL.truncate_table ('FII_GL_LOCAL_SNAP_F', 'FII', g_retcode);
1125:
1126: g_phase := 'Starting to populate table FII_GL_LOCAL_SNAP_F';
1127: IF g_debug_flag = 'Y' THEN
1128: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_LOCAL_SNAP_F');
1129: END IF;
1130:

Line 1128: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_LOCAL_SNAP_F');

1124: FII_UTIL.truncate_table ('FII_GL_LOCAL_SNAP_F', 'FII', g_retcode);
1125:
1126: g_phase := 'Starting to populate table FII_GL_LOCAL_SNAP_F';
1127: IF g_debug_flag = 'Y' THEN
1128: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_LOCAL_SNAP_F');
1129: END IF;
1130:
1131: l_profile := NVL(FND_PROFILE.VALUE('INDUSTRY'),'C');
1132:

Line 1145: insert /*+ append */ INTO FII_GL_LOCAL_SNAP_F

1141:
1142:
1143: IF l_profile = 'G' THEN
1144:
1145: insert /*+ append */ INTO FII_GL_LOCAL_SNAP_F
1146: ( YEAR_ID,
1147: COST_CENTER_ID,
1148: COMPANY_ID,
1149: FIN_CATEGORY_ID,

Line 1684: insert /*+ append */ INTO FII_GL_LOCAL_SNAP_F

1680: f.ledger_id, a.fin_cat_type_code,amount_type_code;
1681:
1682: ELSE
1683:
1684: insert /*+ append */ INTO FII_GL_LOCAL_SNAP_F
1685: ( YEAR_ID,
1686: COST_CENTER_ID,
1687: COMPANY_ID,
1688: FIN_CATEGORY_ID,

Line 1950: FII_UTIL.Write_Log ( 'FII_GL_LOCAL_SNAP_F has been populated successfully' );

1946:
1947:
1948: IF g_debug_flag = 'Y' THEN
1949: FII_UTIL.stop_timer();
1950: FII_UTIL.Write_Log ( 'FII_GL_LOCAL_SNAP_F has been populated successfully' );
1951: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
1952: FII_UTIL.print_timer();
1953: END IF;
1954:

Line 1955: g_phase := 'Gather table stats for FII_GL_LOCAL_SNAP_F';

1951: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
1952: FII_UTIL.print_timer();
1953: END IF;
1954:
1955: g_phase := 'Gather table stats for FII_GL_LOCAL_SNAP_F';
1956: fnd_stats.gather_table_stats (ownname=>g_schema_name,
1957: tabname=>'FII_GL_LOCAL_SNAP_F');
1958:
1959: g_phase := 'Commit the change';

Line 1957: tabname=>'FII_GL_LOCAL_SNAP_F');

1953: END IF;
1954:
1955: g_phase := 'Gather table stats for FII_GL_LOCAL_SNAP_F';
1956: fnd_stats.gather_table_stats (ownname=>g_schema_name,
1957: tabname=>'FII_GL_LOCAL_SNAP_F');
1958:
1959: g_phase := 'Commit the change';
1960: commit;
1961:

Line 2003: g_phase := 'Populating FII_GL_LOCAL_SNAP_F';

1999: END IF;
2000:
2001: Initialize;
2002:
2003: g_phase := 'Populating FII_GL_LOCAL_SNAP_F';
2004: IF g_debug_flag = 'Y' THEN
2005: FII_UTIL.Write_Log ('Populating FII_GL_LOCAL_SNAP_F');
2006: END IF;
2007:

Line 2005: FII_UTIL.Write_Log ('Populating FII_GL_LOCAL_SNAP_F');

2001: Initialize;
2002:
2003: g_phase := 'Populating FII_GL_LOCAL_SNAP_F';
2004: IF g_debug_flag = 'Y' THEN
2005: FII_UTIL.Write_Log ('Populating FII_GL_LOCAL_SNAP_F');
2006: END IF;
2007:
2008: REFRESH_GL_LOCAL_SNAP_F;
2009: