APPS.CSM_NOTIFICATION_EVENT_PKG SQL Statements

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

Line: 27

SELECT 1
FROM csm_notifications_acc
WHERE notification_id = b_notificationid
AND user_id = p_userid;

Line: 46

PROCEDURE INSERT_NOTIFICATIONS_ACC (p_notification_id wf_notifications.notification_id%TYPE,
                                    p_user_id	fnd_user.user_id%TYPE)
IS
  l_sysdate 	DATE;

Line: 52

    CSM_ACC_PKG.Insert_Acc
    ( P_PUBLICATION_ITEM_NAMES => g_notification_pubi_name
     ,P_ACC_TABLE_NAME         => g_notification_acc_table_name
     ,P_SEQ_NAME               => g_notification_seq_name
     ,P_PK1_NAME               => g_notification_pk1_name
     ,P_PK1_NUM_VALUE          => p_notification_id
     ,P_USER_ID                => p_user_id
    );

Line: 61

  CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC: '
      || sqlerrm|| ' for PK ' || to_char(p_notification_id),
      'CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC',FND_LOG.LEVEL_EXCEPTION);

Line: 65

END INSERT_NOTIFICATIONS_ACC;-- end INSERT_NOTIFICATIONS_ACC

Line: 77

 SELECT DISTINCT wfn.notification_id
 FROM   wf_notifications wfn,
        asg_user au
 WHERE  au.user_id=b_user_id
 AND    au.user_name IN (FROM_ROLE,RECIPIENT_ROLE)
 AND    (nvl(wfn.begin_date, sysdate) between
	               (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)
 AND  NOT EXISTS(SELECT 1
                 FROM CSM_NOTIFICATIONS_ACC ACC
				 WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
				 AND   ACC.USER_ID = AU.USER_ID);

Line: 91

 SELECT DISTINCT wfn.notification_id
 FROM  WF_NOTIFICATIONS wfn,
       ASG_USER au
 WHERE au.user_id=b_user_id
 AND   RECIPIENT_ROLE LIKE 'JRES_GRP:%'
 AND   au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))
 AND   au.enabled='Y'
 AND  (nvl(wfn.begin_date, sysdate) between
	              (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)
 AND  NOT EXISTS(SELECT 1
                 FROM CSM_NOTIFICATIONS_ACC ACC
				 WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
				 AND   ACC.USER_ID = AU.USER_ID);

Line: 113

   INSERT_NOTIFICATIONS_ACC (l_notf_rec.notification_id, p_user_id);

Line: 119

   INSERT_NOTIFICATIONS_ACC (l_notf_rec.notification_id, p_user_id);

Line: 138

 SELECT DISTINCT au.user_id
 FROM  WF_NOTIFICATIONS wfn,
       ASG_USER au
 WHERE wfn.NOTIFICATION_ID=b_nid
 AND   au.user_name IN (WFN.FROM_ROLE,WFN.RECIPIENT_ROLE)
 AND   au.enabled='Y'
 AND  (nvl(wfn.begin_date, sysdate) between
	              (sysdate - csm_profile_pkg.get_task_history_days(au.user_id))and sysdate)
 AND  NOT EXISTS(SELECT 1
                 FROM CSM_NOTIFICATIONS_ACC ACC
				 WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
				 AND   ACC.USER_ID = AU.USER_ID);

Line: 153

 SELECT DISTINCT au.user_id
 FROM  WF_NOTIFICATIONS wfn,
       ASG_USER au
 WHERE wfn.NOTIFICATION_ID=b_nid
 AND   RECIPIENT_ROLE LIKE 'JRES_GRP:%'
 AND   au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))
 AND   au.enabled='Y'
 AND  (nvl(wfn.begin_date, sysdate) between
	              (sysdate - csm_profile_pkg.get_task_history_days(au.user_id))and sysdate)
 AND  NOT EXISTS(SELECT 1
                 FROM CSM_NOTIFICATIONS_ACC ACC
				 WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
				 AND   ACC.USER_ID = AU.USER_ID);

Line: 182

    INSERT_NOTIFICATIONS_ACC (p_notification_id, r_rec.user_id);

Line: 188

    INSERT_NOTIFICATIONS_ACC (p_notification_id, r_rec.user_id);

Line: 255

 SELECT  acc.user_id
 FROM   CSM_NOTIFICATIONS_ACC acc
 WHERE  acc.NOTIFICATION_ID=b_nid;

Line: 271

        CSM_ACC_PKG.Delete_Acc
        ( P_PUBLICATION_ITEM_NAMES => g_notification_pubi_name
         ,P_ACC_TABLE_NAME         => g_notification_acc_table_name
         ,P_PK1_NAME               => g_notification_pk1_name
         ,P_PK1_NUM_VALUE          => l_notification_id
         ,P_USER_ID                => r_notification_rec.user_id
        );

Line: 305

SELECT /*+ INDEX(acc CSM_NOTIFICATIONS_ACC_U1) */
      acc.user_id,
      acc.notification_id
FROM csm_notifications_acc acc,
     wf_notifications wfn
WHERE acc.notification_id = wfn.notification_id
AND (NVL(wfn.begin_date, SYSDATE)
      < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)));

Line: 324

SELECT 1
FROM jtm_con_request_data
WHERE product_code = 'CSM'
AND package_name = 'CSM_NOTIFICATION_EVENT_PKG'
AND procedure_name = 'PURGE_NOTIFICATION_CONC'
FOR UPDATE OF last_run_date NOWAIT
;

Line: 338

       l_purge_notf_tbl.DELETE;

Line: 342

       l_purge_userid_tbl.DELETE;

Line: 354

      CSM_ACC_PKG.Delete_Acc
       ( P_PUBLICATION_ITEM_NAMES => g_notification_pubi_name
        ,P_ACC_TABLE_NAME         => g_notification_acc_table_name
        ,P_PK1_NAME               => g_notification_pk1_name
        ,P_PK1_NUM_VALUE          => l_notification_id
        ,P_USER_ID                => l_user_id
       );

Line: 372

     UPDATE jtm_con_request_data
     SET last_run_date = l_last_run_date
     WHERE CURRENT OF l_upd_last_run_date_csr;