APPS.CN_EVENT_LOG_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

            X_delete_ndays   IN      number)  IS

     X_user_id  NUMBER(15) ;

Line: 28

     SELECT cn_event_log_s.NEXTVAL
     INTO   X_event_log_id
     FROM   sys.dual;

Line: 33

     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) ;

Line: 68

            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) ;

Line: 120

     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) ;

Line: 130

     	SELECT name
     	INTO   X_plan_name
     	FROM   cn_comp_plans
     	WHERE  comp_plan_id = X_comp_plan_id ;

Line: 149

                X_delete_ndays  =>  30 ) ;

Line: 173

                     X_delete_ndays     =>  30 ) ;