APPS.CSL_FND_USER_ACC_PKG SQL Statements

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

Line: 20

   SELECT *
   FROM FND_USER
   WHERE user_id = b_user_id;

Line: 68

PROCEDURE Insert_ACC_Record
  ( p_user_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_user_id
    , g_table_name
    , 'Entering Insert_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 86

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

Line: 90

  /*** 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_user_id
    ,P_RESOURCE_ID            => p_resource_id
   );

Line: 103

    , 'Leaving Insert_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 106

END Insert_ACC_Record;

Line: 109

PROCEDURE Update_ACC_Record
  ( p_user_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_user_id
    , g_table_name
    , 'Entering Update_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 132

  /*** 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: 144

    , 'Leaving Update_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 147

END Update_ACC_Record;

Line: 149

/*** Private procedure that deletes user for resource from acc table ***/
PROCEDURE Delete_ACC_Record
  ( p_user_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_user_id
    , g_table_name
    , 'Entering Delete_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 172

  /*** Delete user ACC record ***/
  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_user_id
    ,P_RESOURCE_ID            => p_resource_id
   );

Line: 185

    , 'Leaving Delete_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 188

END Delete_ACC_Record;

Line: 191

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

Line: 206

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

Line: 212

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

Line: 224

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

Line: 228

END Insert_User;

Line: 231

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

Line: 248

    , 'Entering Update_User'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 262

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

Line: 276

    , 'Leaving Update_User'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 279

END Update_User;

Line: 282

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

Line: 299

    , 'Entering Delete_User'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 311

    /*** yes -> delete user acc record ***/
    Delete_ACC_Record
    ( p_user_id
     ,p_resource_id
    );

Line: 323

    , 'Leaving Delete_User'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 326

END Delete_User;