APPS.FII_AR_FACTS_AGING_PKG dependencies on FII_AR_SCHEDULED_DISC_F

Line 1914: -- This procedure inserts records in FII_AR_SCHEDULED_DISC_F

1910:
1911: ------------------------------------------------------------------
1912: -- Procedure POPULATE_SCHEDULED_DISCOUNTS
1913: -- Purpose
1914: -- This procedure inserts records in FII_AR_SCHEDULED_DISC_F
1915: ------------------------------------------------------------------
1916: PROCEDURE POPULATE_SCHEDULED_DISCOUNTS IS
1917: BEGIN
1918:

Line 1919: g_state := 'Truncating table FII_AR_SCHEDULED_DISC_F';

1915: ------------------------------------------------------------------
1916: PROCEDURE POPULATE_SCHEDULED_DISCOUNTS IS
1917: BEGIN
1918:
1919: g_state := 'Truncating table FII_AR_SCHEDULED_DISC_F';
1920: TRUNCATE_TABLE('FII_AR_SCHEDULED_DISC_F');
1921:
1922: g_state := 'Populating FII_AR_SCHEDULED_DISC_F';
1923: if g_debug_flag = 'Y' then

Line 1920: TRUNCATE_TABLE('FII_AR_SCHEDULED_DISC_F');

1916: PROCEDURE POPULATE_SCHEDULED_DISCOUNTS IS
1917: BEGIN
1918:
1919: g_state := 'Truncating table FII_AR_SCHEDULED_DISC_F';
1920: TRUNCATE_TABLE('FII_AR_SCHEDULED_DISC_F');
1921:
1922: g_state := 'Populating FII_AR_SCHEDULED_DISC_F';
1923: if g_debug_flag = 'Y' then
1924: FII_UTIL.put_line(g_state);

Line 1922: g_state := 'Populating FII_AR_SCHEDULED_DISC_F';

1918:
1919: g_state := 'Truncating table FII_AR_SCHEDULED_DISC_F';
1920: TRUNCATE_TABLE('FII_AR_SCHEDULED_DISC_F');
1921:
1922: g_state := 'Populating FII_AR_SCHEDULED_DISC_F';
1923: if g_debug_flag = 'Y' then
1924: FII_UTIL.put_line(g_state);
1925: FII_UTIL.start_timer;
1926: FII_UTIL.put_line('');

Line 1930: INSERT INTO FII_AR_SCHEDULED_DISC_F

1926: FII_UTIL.put_line('');
1927: end if;
1928:
1929:
1930: INSERT INTO FII_AR_SCHEDULED_DISC_F
1931: (term_id,
1932: sequence_num,
1933: discount1_percent,
1934: discount1_days,

Line 2015: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_SCHEDULED_DISC_F');

2011: GROUP BY term_id,
2012: sequence_num;
2013:
2014: if g_debug_flag = 'Y' then
2015: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_SCHEDULED_DISC_F');
2016: FII_UTIL.stop_timer;
2017: FII_UTIL.print_timer('Duration');
2018: FII_UTIL.put_line('');
2019: end if;

Line 2021: g_state := 'Analyzing FII_AR_SCHEDULED_DISC_F table';

2017: FII_UTIL.print_timer('Duration');
2018: FII_UTIL.put_line('');
2019: end if;
2020:
2021: g_state := 'Analyzing FII_AR_SCHEDULED_DISC_F table';
2022: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_SCHEDULED_DISC_F');
2023:
2024: EXCEPTION
2025: WHEN OTHERS THEN

Line 2022: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_SCHEDULED_DISC_F');

2018: FII_UTIL.put_line('');
2019: end if;
2020:
2021: g_state := 'Analyzing FII_AR_SCHEDULED_DISC_F table';
2022: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_SCHEDULED_DISC_F');
2023:
2024: EXCEPTION
2025: WHEN OTHERS THEN
2026: g_errbuf:=sqlerrm;