The following lines contain the word 'select', 'insert', 'update' or 'delete':
X_delete_ndays IN number) IS
X_user_id NUMBER(15) ;
SELECT cn_event_log_s.NEXTVAL
INTO X_event_log_id
FROM sys.dual;
INSERT INTO cn_event_log(
event_log_id,
event_log_date,
delete_date,
event_name,
form_name,
user_id,
object_id,
object_type,
object_name)
VALUES(X_event_log_id,
SYSDATE,
(SYSDATE+X_delete_ndays),
X_event_name,
X_form_name,
X_user_id,
X_object_id,
X_object_type,
X_object_name) ;
X_delete_ndays IN number) IS
BEGIN
-- Update Notify Log with notify information
INSERT INTO cn_notify_log(
notify_log_id,
notify_log_date,
delete_date,
event_log_id,
notify_name,
notify_action,
object_owner_id,
object_id,
object_type,
object_name,
status,
priority)
VALUES(cn_notify_log_s.NEXTVAL,
SYSDATE,
(SYSDATE+X_delete_ndays),
X_event_log_id,
X_notify_name,
X_notify_action,
X_object_owner_id,
X_object_id,
X_object_type,
X_object_name,
X_status,
X_priority) ;
SELECT sr.salesrep_id, sr.name, sr.assigned_to_user_id
FROM cn_salesreps sr
WHERE sr.salesrep_id IN (SELECT pa.salesrep_id
FROM cn_srp_plan_assigns pa
WHERE pa.comp_plan_id = X_comp_plan_id) ;
SELECT name
INTO X_plan_name
FROM cn_comp_plans
WHERE comp_plan_id = X_comp_plan_id ;
X_delete_ndays => 30 ) ;
X_delete_ndays => 30 ) ;