APPS.CSL_JTF_RESOURCE_EXTNS_ACC_PKG SQL Statements

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

Line: 24

       SELECT resource_id  -- Fix for Sql Performance
       FROM JTF_RS_RESOURCE_EXTNS
       WHERE resource_id = b_resource_extn_id;

Line: 71

PROCEDURE Insert_ACC_Record
  ( p_resource_extn_id    IN NUMBER
   ,p_resource_id         IN NUMBER
  )
IS
BEGIN
  IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
    jtm_message_log_pkg.Log_Msg
    ( p_resource_extn_id
    , g_table_name
    , 'Entering Insert_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 89

    , 'Inserting ACC record for resource_id = ' || p_resource_id
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 93

  /*** Insert user ACC record ***/
  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_pk_name
    ,P_PK1_NUM_VALUE          => p_resource_extn_id
    ,P_RESOURCE_ID            => p_resource_id
   );

Line: 106

    , 'Leaving Insert_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 109

END Insert_ACC_Record;

Line: 112

PROCEDURE Update_ACC_Record
  ( p_resource_extn_id           IN NUMBER
   ,p_resource_id                IN NUMBER
   ,p_acc_id                     IN NUMBER
  )
IS
BEGIN
  IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
    jtm_message_log_pkg.Log_Msg
    ( p_resource_extn_id
    , g_table_name
    , 'Entering Update_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 135

  /*** Update user ACC record ***/
  JTM_HOOK_UTIL_PKG.Update_Acc
   ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
    ,P_ACC_TABLE_NAME         => g_acc_table_name
    ,P_RESOURCE_ID            => p_resource_id
    ,P_ACCESS_ID              => p_acc_id
   );

Line: 147

    , 'Leaving Update_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 150

END Update_ACC_Record;

Line: 152

/*** Private procedure that deletes user for resource from acc table ***/
PROCEDURE Delete_ACC_Record
  ( p_resource_extn_id    IN NUMBER
   ,p_resource_id         IN NUMBER
  )
IS
BEGIN
  IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
    jtm_message_log_pkg.Log_Msg
    ( p_resource_extn_id
    , g_table_name
    , 'Entering Delete_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 175

  /*** Delete user ACC record ***/
/*
  removed because of bug 2539352

  JTM_HOOK_UTIL_PKG.Delete_Acc
   ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
    ,P_ACC_TABLE_NAME         => g_acc_table_name
    ,P_PK1_NAME               => g_pk_name
    ,P_PK1_NUM_VALUE          => p_resource_extn_id
    ,P_RESOURCE_ID            => p_resource_id
   );

Line: 192

    , 'Leaving Delete_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 195

END Delete_ACC_Record;

Line: 198

  Public procedure that gets called when a user needs to be inserted into ACC table.
***/
PROCEDURE Insert_Resource_Extns
  ( p_resource_extn_id     IN NUMBER
   ,p_resource_id          IN NUMBER
  )
IS
BEGIN
  /*** get debug level ***/
  g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line: 213

    , 'Entering Insert_Resource_Extns procedure'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 219

    /*** yes -> insert user acc record ***/
    Insert_ACC_Record
    ( p_resource_extn_id
     ,p_resource_id
    );

Line: 231

    , 'Leaving Insert_Resource_Extns procedure'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 235

END Insert_Resource_Extns;

Line: 238

  Public procedure that gets called when a user needs to be updated into ACC table.
***/
PROCEDURE Update_Resource_Extns
  ( p_resource_extn_id     IN NUMBER
   ,p_resource_id          IN NUMBER
  )
IS
  l_acc_id           NUMBER;

Line: 254

    , 'Entering Update_Resource_Extns procedure'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 268

      /*** yes -> update user acc record ***/
      Update_ACC_Record
      ( p_resource_extn_id
       ,p_resource_id
       ,l_acc_id
      );

Line: 282

    , 'Leaving Update_Resource_Extns procedure'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 286

END Update_Resource_Extns;

Line: 289

  Public procedure that gets called when a user needs to be deleted from ACC table.
***/
PROCEDURE Delete_Resource_Extns
  ( p_resource_extn_id     IN NUMBER
   ,p_resource_id          IN NUMBER
  )
IS
  l_acc_id           NUMBER;

Line: 306

    , 'Entering Delete_Resource_Extns'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 318

    /*** yes -> update user acc record ***/
    Delete_ACC_Record
    ( p_resource_extn_id
     ,p_resource_id);

Line: 329

    , 'Leaving Delete_Resource_Extns'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 332

END Delete_Resource_Extns;