eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_AR_FACTS_AGING_PKG dependencies on FII_AR_HELP_MKT_CLASSES

Line 3935: g_state := 'Truncating table: fii_ar_help_mkt_classes';

3931: l_unassigned_message VARCHAR2(30) := FND_MESSAGE.get_string('BIS', 'EDW_UNASSIGNED');
3932:
3933: BEGIN
3934:
3935: g_state := 'Truncating table: fii_ar_help_mkt_classes';
3936: TRUNCATE_TABLE('FII_AR_HELP_MKT_CLASSES');
3937:
3938: g_state := 'Populating fii_ar_help_mkt_classes';
3939: if g_debug_flag = 'Y' then

Line 3936: TRUNCATE_TABLE('FII_AR_HELP_MKT_CLASSES');

3932:
3933: BEGIN
3934:
3935: g_state := 'Truncating table: fii_ar_help_mkt_classes';
3936: TRUNCATE_TABLE('FII_AR_HELP_MKT_CLASSES');
3937:
3938: g_state := 'Populating fii_ar_help_mkt_classes';
3939: if g_debug_flag = 'Y' then
3940: FII_UTIL.put_line(g_state);

Line 3938: g_state := 'Populating fii_ar_help_mkt_classes';

3934:
3935: g_state := 'Truncating table: fii_ar_help_mkt_classes';
3936: TRUNCATE_TABLE('FII_AR_HELP_MKT_CLASSES');
3937:
3938: g_state := 'Populating fii_ar_help_mkt_classes';
3939: if g_debug_flag = 'Y' then
3940: FII_UTIL.put_line(g_state);
3941: FII_UTIL.start_timer;
3942: FII_UTIL.put_line('');

Line 3945: INSERT into fii_ar_help_mkt_classes

3941: FII_UTIL.start_timer;
3942: FII_UTIL.put_line('');
3943: end if;
3944:
3945: INSERT into fii_ar_help_mkt_classes
3946: (class_category,
3947: class_code,
3948: class_name,
3949: creation_date,

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

3976: g_fii_login_id --LAST_UPDATE_LOGIN
3977: FROM dual;
3978:
3979: if g_debug_flag = 'Y' then
3980: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_HELP_MKT_CLASSES');
3981: FII_UTIL.stop_timer;
3982: FII_UTIL.print_timer('Duration');
3983: FII_UTIL.put_line('');
3984: end if;

Line 4021: g_state := 'Analyzing FII_AR_HELP_MKT_CLASSES table';

4017: FII_UTIL.print_timer('Duration');
4018: FII_UTIL.put_line('');
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:

Line 4022: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_HELP_MKT_CLASSES');

4018: FII_UTIL.put_line('');
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;

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;