APPS.CSL_WF_NOTIFICATIONS_ACC_PKG SQL Statements

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

Line: 17

  SELECT wn.RECIPIENT_ROLE
  ,      wna.TEXT_VALUE
  FROM  WF_NOTIFICATIONS wn
  ,     WF_NOTIFICATION_ATTRIBUTES wna
  WHERE wn.NOTIFICATION_ID = b_notification_id
  AND   wn.MESSAGE_TYPE = 'CS_MSGS'
  AND   wn.MESSAGE_NAME = 'FYI_MESSAGE'
  AND   wn.STATUS = 'OPEN'
  AND   wn.NOTIFICATION_ID = wna.NOTIFICATION_ID
  AND   wna.NAME = 'SENDER';

Line: 31

  SELECT jre.RESOURCE_ID
  FROM   JTF_RS_RESOURCE_EXTNS jre
  ,      FND_USER usr
  WHERE  usr.USER_NAME = b_user_name
  AND    usr.user_id = jre.user_id;

Line: 104

PROCEDURE INSERT_NOTIFICATION( p_notification_id IN NUMBER )
IS
  l_replicate     BOOLEAN;

Line: 113

  SELECT jre.resource_id
  ,      usr.user_id
  FROM   jtf_rs_resource_extns jre
  ,      fnd_user              usr
  ,      wf_notifications      wfn
  WHERE  wfn.recipient_role = usr.user_name
  AND    usr.user_id        = jre.user_id
  AND    jre.category       = 'EMPLOYEE'
  AND    wfn.notification_id = b_notification_id;

Line: 126

    SELECT jre.resource_id
    FROM   jtf_rs_resource_extns      jre
    ,      fnd_user                   usr
    ,      wf_notification_attributes wna
    WHERE  wna.name           = 'SENDER'
    AND    wna.text_value     = usr.user_name
    AND    usr.user_id        = jre.user_id
    AND    jre.category       = 'EMPLOYEE'
    AND    wna.notification_id = b_notification_id;

Line: 144

    , 'Entering Procedure INSERT_NOTIFICATION'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 155

        JTM_HOOK_UTIL_PKG.Insert_Acc
          ( p_publication_item_names => g_publication_item_name
          , p_acc_table_name         => g_acc_table_name
          , p_pk1_name               => g_pk1_name
          , p_pk1_num_value          => p_notification_id
          , p_resource_id            => r_get_recipient.resource_id
          );

Line: 163

        CSL_FND_USER_ACC_PKG.Insert_User (r_get_recipient.user_id, r_get_recipient.resource_id);

Line: 172

        JTM_HOOK_UTIL_PKG.Insert_Acc
          ( p_publication_item_names => g_publication_item_name
          , p_acc_table_name         => g_acc_table_name
          , p_pk1_name               => g_pk1_name
          , p_pk1_num_value          => p_notification_id
          , p_resource_id            => r_get_sender.resource_id
          );

Line: 181

        CSL_FND_USER_ACC_PKG.Insert_User (r_get_recipient.user_id, r_get_sender.resource_id);

Line: 191

      , 'Leaving Procedure INSERT_NOTIFICATION'
      , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 195

END INSERT_NOTIFICATION;