APPS.CSL_CONC_NOTIFICATION_PKG SQL Statements

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

Line: 8

  SELECT LAST_RUN_DATE
  FROM   JTM_CON_REQUEST_DATA
  WHERE  package_name =  'CSL_CONC_NOTIFICATION_PKG'
  AND    procedure_name = 'RUN_CONCURRENT_NOTIFICATIONS';

Line: 15

  SELECT NOTIFICATION_ID
  FROM WF_NOTIFICATIONS
  WHERE BEGIN_DATE >=NVL( b_last_date, BEGIN_DATE )
  AND NOTIFICATION_ID NOT IN
  ( SELECT NOTIFICATION_ID
    FROM JTM_WF_NOTIFICATIONS_ACC );

Line: 23

  SELECT NAME
  FROM WF_NOTIFICATION_ATTRIBUTES
  WHERE NOTIFICATION_ID = b_notification_id;

Line: 29

   SELECT asgusr.resource_id
   FROM   asg_pub                pub
   ,      asg_pub_responsibility pubresp
   ,      fnd_user_resp_groups   usrresp
   ,      fnd_user               usr
   ,      jtf_rs_resource_extns  res
   ,      asg_user               asgusr
   WHERE  asgusr.resource_id = res.resource_id
   AND    pub.name    = 'SERVICEL'
   AND    pub.enabled = 'Y'
   AND    pub.status  = 'Y'
   AND    pub.pub_id  = pubresp.pub_id
   AND    pubresp.responsibility_id = usrresp.responsibility_id
   AND    TRUNC(sysdate) BETWEEN TRUNC(NVL(usrresp.start_date,sysdate))
                             AND TRUNC(NVL(usrresp.end_date,sysdate))
   AND    usrresp.user_id = usr.user_id
   AND    TRUNC(sysdate) BETWEEN TRUNC(NVL(usr.start_date,sysdate))
                             AND TRUNC(NVL(usr.end_date,sysdate))
   AND    usr.user_id = res.user_id
   AND    TRUNC(sysdate) BETWEEN TRUNC(NVL(res.start_date_active,sysdate))
                             AND TRUNC(NVL(res.end_date_active,sysdate));

Line: 55

   SELECT NOTIFICATION_ID, NAME
   FROM   WF_NOTIFICATION_ATTRIBUTES
   WHERE  NAME IN ('SENDER', 'SUBJECT', 'MESSAGE_TEXT', 'PRIORITY', 'READ_FLAG', 'DELETE_FLAG')
   AND    (NOTIFICATION_ID, NAME) NOT IN
          (
            SELECT NOTIFICATION_ID, NAME
            FROM   JTM_WF_NOTIFICATION_AT_ACC
            WHERE  RESOURCE_ID = b_resource_id
          )
   AND    NOTIFICATION_ID IN
          (
            SELECT NOTIFICATION_ID
            FROM   JTM_WF_NOTIFICATIONS_ACC
            WHERE  RESOURCE_ID = b_resource_id
          );

Line: 74

 /*Fetch and update last run date*/
 OPEN  c_LastRundate;

Line: 90

 /*Update the last run date*/
 UPDATE JTM_CON_REQUEST_DATA
 SET    LAST_RUN_DATE = SYSDATE
 WHERE  package_name = 'CSL_CONC_NOTIFICATION_PKG'
 AND    procedure_name = 'RUN_CONCURRENT_NOTIFICATIONS';

Line: 98

   CSL_WF_NOTIFICATIONS_ACC_PKG.INSERT_NOTIFICATION( r_notification.NOTIFICATION_ID );

Line: 102

     CSL_WF_NOTIFICATION_AT_ACC_PKG.INSERT_NOTIFICATION_ATTRIBUTE ( r_notification.NOTIFICATION_ID
                                                                , r_attribute.NAME );

Line: 115

     CSL_WF_NOTIFICATION_AT_ACC_PKG.INSERT_NOTIFICATION_ATTRIBUTE
       ( r_get_attr_per_notification.NOTIFICATION_ID,
         r_get_attr_per_notification.NAME );