APPS.FII_AR_FACTS_AGING_PKG dependencies on FII_AR_HELP_COLLECTORS

Line 3986: g_state := 'Truncating table: FII_AR_HELP_COLLECTORS';

3982: FII_UTIL.print_timer('Duration');
3983: FII_UTIL.put_line('');
3984: end if;
3985:
3986: g_state := 'Truncating table: FII_AR_HELP_COLLECTORS';
3987: TRUNCATE_TABLE('FII_AR_HELP_COLLECTORS');
3988:
3989: g_state := 'Populating FII_AR_HELP_COLLECTORS';
3990: if g_debug_flag = 'Y' then

Line 3987: TRUNCATE_TABLE('FII_AR_HELP_COLLECTORS');

3983: FII_UTIL.put_line('');
3984: end if;
3985:
3986: g_state := 'Truncating table: FII_AR_HELP_COLLECTORS';
3987: TRUNCATE_TABLE('FII_AR_HELP_COLLECTORS');
3988:
3989: g_state := 'Populating FII_AR_HELP_COLLECTORS';
3990: if g_debug_flag = 'Y' then
3991: FII_UTIL.put_line(g_state);

Line 3989: g_state := 'Populating FII_AR_HELP_COLLECTORS';

3985:
3986: g_state := 'Truncating table: FII_AR_HELP_COLLECTORS';
3987: TRUNCATE_TABLE('FII_AR_HELP_COLLECTORS');
3988:
3989: g_state := 'Populating FII_AR_HELP_COLLECTORS';
3990: if g_debug_flag = 'Y' then
3991: FII_UTIL.put_line(g_state);
3992: FII_UTIL.start_timer;
3993: FII_UTIL.put_line('');

Line 3996: INSERT into fii_ar_help_collectors

3992: FII_UTIL.start_timer;
3993: FII_UTIL.put_line('');
3994: end if;
3995:
3996: INSERT into fii_ar_help_collectors
3997: (collector_id,
3998: name,
3999: creation_date,
4000: created_by,

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

4011: FROM ar_collectors c
4012: WHERE exists (select 'x' from fii_collectors hz where hz.collector_id = c.collector_id);
4013:
4014: if g_debug_flag = 'Y' then
4015: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_HELP_COLLECTORS');
4016: FII_UTIL.stop_timer;
4017: FII_UTIL.print_timer('Duration');
4018: FII_UTIL.put_line('');
4019: end if;

Line 4023: g_state := 'Analyzing FII_AR_HELP_COLLECTORS table';

4019: end if;
4020:
4021: g_state := 'Analyzing FII_AR_HELP_MKT_CLASSES table';
4022: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_HELP_MKT_CLASSES');
4023: g_state := 'Analyzing FII_AR_HELP_COLLECTORS table';
4024: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_HELP_COLLECTORS');
4025:
4026: commit;
4027:

Line 4024: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_HELP_COLLECTORS');

4020:
4021: g_state := 'Analyzing FII_AR_HELP_MKT_CLASSES table';
4022: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_HELP_MKT_CLASSES');
4023: g_state := 'Analyzing FII_AR_HELP_COLLECTORS table';
4024: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_HELP_COLLECTORS');
4025:
4026: commit;
4027:
4028: EXCEPTION

Line 4123: FII_UTIL.put_line('Populating dimension helper tables fii_ar_help_mkt_classes and fii_ar_help_collectors');

4119: END IF;
4120:
4121: if g_debug_flag = 'Y' then
4122: FII_UTIL.put_line('-------------------------------------------------');
4123: FII_UTIL.put_line('Populating dimension helper tables fii_ar_help_mkt_classes and fii_ar_help_collectors');
4124: FII_UTIL.put_line('-------------------------------------------------');
4125: end if;
4126:
4127: POPULATE_HELPER_TABLES;

Line 9282: FII_UTIL.put_line('Populating dimension helper tables fii_ar_help_mkt_classes and fii_ar_help_collectors');

9278: INIT;
9279:
9280: if g_debug_flag = 'Y' then
9281: FII_UTIL.put_line('-------------------------------------------------');
9282: FII_UTIL.put_line('Populating dimension helper tables fii_ar_help_mkt_classes and fii_ar_help_collectors');
9283: FII_UTIL.put_line('-------------------------------------------------');
9284: end if;
9285:
9286: POPULATE_HELPER_TABLES;