APPS.FND_OAM_CPCHARTS_COL dependencies on FND_OAM_CPSTATS_USER

Line 960: delete from fnd_oam_cpstats_user where stats_interval = 24; --24 hours

956:
957: BEGIN
958:
959: --Delete entries for statistics data for stats_interval=24hours.
960: delete from fnd_oam_cpstats_user where stats_interval = 24; --24 hours
961: for stat in s24h_c loop
962: -- insert the data
963: insert_stats_user(stat.user_id, 24, stat.count, stat.runtime);
964: end loop;

Line 966: delete from fnd_oam_cpstats_user where stats_interval = 168; -- 7days = 168 hours

962: -- insert the data
963: insert_stats_user(stat.user_id, 24, stat.count, stat.runtime);
964: end loop;
965:
966: delete from fnd_oam_cpstats_user where stats_interval = 168; -- 7days = 168 hours
967: for stat in s7day_c loop
968: -- insert the data
969: insert_stats_user(stat.user_id, 168, stat.count, stat.runtime);
970: end loop;

Line 972: delete from fnd_oam_cpstats_user where stats_interval = 744; --31 days = 744 hours

968: -- insert the data
969: insert_stats_user(stat.user_id, 168, stat.count, stat.runtime);
970: end loop;
971:
972: delete from fnd_oam_cpstats_user where stats_interval = 744; --31 days = 744 hours
973: for stat in s31day_c loop
974: -- insert the data
975: insert_stats_user(stat.user_id, 744, stat.count, stat.runtime);
976: end loop;

Line 1085: insert into fnd_oam_cpstats_user (user_id, stats_interval,

1081: BEGIN
1082: v_userid := get_user_id;
1083:
1084: -- insert the data
1085: insert into fnd_oam_cpstats_user (user_id, stats_interval,
1086: comp_req_count, total_runtime,
1087: last_updated_by, last_update_date,
1088: last_update_login, created_by, creation_date)
1089: values (p_user_id, p_stats_interval, p_comp_req_count,