APPS.FND_OAM_CPCHARTS_COL dependencies on FND_OAM_CPSTATS_PROGRAM

Line 1037: delete from fnd_oam_cpstats_program where stats_interval = 24;

1033:
1034: BEGIN
1035:
1036: --Delete entries for statistics data for stats_interval=24hours.
1037: delete from fnd_oam_cpstats_program where stats_interval = 24;
1038: for stat in s24h_c loop
1039: -- insert the data
1040: insert_stats_program(stat.app_id, stat.prog_id, 24,
1041: stat.total, stat.ave, stat.minimum, stat.maximum, stat.count);

Line 1044: delete from fnd_oam_cpstats_program where stats_interval = 168; -- 7 days = 168 hours

1040: insert_stats_program(stat.app_id, stat.prog_id, 24,
1041: stat.total, stat.ave, stat.minimum, stat.maximum, stat.count);
1042: end loop;
1043:
1044: delete from fnd_oam_cpstats_program where stats_interval = 168; -- 7 days = 168 hours
1045: for stat in s7day_c loop
1046: -- insert the data
1047: insert_stats_program(stat.app_id, stat.prog_id, 168,
1048: stat.total, stat.ave, stat.minimum, stat.maximum, stat.count);

Line 1051: delete from fnd_oam_cpstats_program where stats_interval = 744; -- 31 days = 744 hours

1047: insert_stats_program(stat.app_id, stat.prog_id, 168,
1048: stat.total, stat.ave, stat.minimum, stat.maximum, stat.count);
1049: end loop;
1050:
1051: delete from fnd_oam_cpstats_program where stats_interval = 744; -- 31 days = 744 hours
1052: for stat in s31day_c loop
1053: -- insert the data
1054: insert_stats_program(stat.app_id, stat.prog_id, 744,
1055: stat.total, stat.ave, stat.minimum, stat.maximum, stat.count);

Line 1118: insert into fnd_oam_cpstats_program (application_id, program_id, stats_interval,

1114: BEGIN
1115: v_userid := get_user_id;
1116:
1117: -- insert the data
1118: insert into fnd_oam_cpstats_program (application_id, program_id, stats_interval,
1119: total_runtime, ave_runtime, min_runtime, max_runtime, times_run,
1120: last_updated_by, last_update_date,
1121: last_update_login, created_by, creation_date)
1122: values (p_app_id, p_program_id, p_stats_interval, p_total_runtime,