eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_USER_PKG SQL Statements

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

Line: 12


 SELECT USER_ID
 FROM JTF_RS_RESOURCE_EXTNS
 WHERE RESOURCE_ID = b_resource_id;

Line: 28


 /* First delete all ancient records*/
 DELETE_USER( p_resource_id, x_return_status );

Line: 31


 /* Because we delete also resource and user we need to recreate those records*/
 OPEN c_user(P_RESOURCE_ID );

Line: 35


  JTM_HOOK_UTIL_PKG.Insert_Acc
  ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('FND_USER')
   ,P_ACC_TABLE_NAME         => 'JTM_FND_USER_ACC'
   ,P_PK1_NAME               => 'USER_ID'
   ,P_PK1_NUM_VALUE          => r_user
   ,P_RESOURCE_ID            => P_RESOURCE_ID
   );

Line: 45


  JTM_HOOK_UTIL_PKG.Insert_Acc
  ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_RESOURCE_EXTNS')
   ,P_ACC_TABLE_NAME         => 'JTM_JTF_RS_RESOURCE_EXTNS_ACC'
   ,P_PK1_NAME               => 'RESOURCE_PK'
   ,P_PK1_NUM_VALUE          => P_RESOURCE_ID
   ,P_RESOURCE_ID            => P_RESOURCE_ID
   );

Line: 57


   , 'Calling CSL_JTF_TASK_ASS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 60


 CSL_JTF_TASK_ASS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status  );

Line: 67


 /*** insert SRs created by mobile resource ***/
 IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
   jtm_message_log_pkg.Log_Msg
   ( null
   , g_table_name
   , 'Calling CSL_CS_INCIDENTS_ALL_ACC_PKG.INSERT_ALL_ACC_RECORDS'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 75


 CSL_CS_INCIDENTS_ALL_ACC_PKG.INSERT_ALL_ACC_RECORDS
  ( p_resource_id
  , x_return_status );

Line: 84


 /*** insert tasks created by mobile resource ***/
 IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
   jtm_message_log_pkg.Log_Msg
   ( null
   , g_table_name
   , 'Calling CSL_JTF_TASKS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 92


 CSL_JTF_TASKS_ACC_PKG.INSERT_ALL_ACC_RECORDS
  ( p_resource_id
  , x_return_status );

Line: 105


   , 'Calling CSL_CSP_INV_LOC_ASS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 108


 CSL_CSP_INV_LOC_ASS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status  );

Line: 119


   , 'Calling CSL_CSP_LOCATIONS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 122


 CSL_CSP_LOCATIONS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status  );

Line: 133


   , 'Calling CSL_CSP_REQ_HEADERS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 136


 CSL_CSP_REQ_HEADERS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status  );

Line: 147


   , 'Calling CSL_CSP_REQ_LINES_ACC_PKG.INSERT_ALL_ACC_RECORDS'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 150


 CSL_CSP_REQ_LINES_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status  );

Line: 161


   , 'Calling CSL_WF_NOTIFICATION_AT_ACC_PKG.INSERT_ALL_ACC_RECORDS'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 164


 CSL_WF_NOTIFICATION_AT_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status  );

Line: 175


   , 'Calling CSL_JTF_RS_GRP_MEM_ACC_PKG.INSERT_ALL_ACC_RECORDS'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 178


 CSL_JTF_RS_GRP_MEM_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status  );

Line: 189


   , 'Calling CSL_MTL_SYSTEM_ITEMS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 192


 CSL_MTL_SYSTEM_ITEMS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );

Line: 199


 /*** fix for bug 2457810 (deadlock issue), now doing commit before running autonomous inserts ***/
 COMMIT;

Line: 228


   , 'Calling CSL_MTL_SERIAL_NUMBERS_ACC_PKG.INSERT_SERIAL_NUMBERS'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 231


 CSL_MTL_SERIAL_NUMBERS_ACC_PKG.INSERT_SERIAL_NUMBERS(p_resource_id);

Line: 275


/* Put all delete_user procedures here */
/* TODO add jtf_RS_resource_EXTNS and JTF_group_members and fnd_user*/
PROCEDURE DELETE_USER( p_resource_id IN NUMBER
                     , x_return_status OUT NOCOPY VARCHAR2 ) IS
BEGIN
 /*** get debug level ***/
 g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line: 287


   , 'Entering DELETE_USER'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
   , 'csl_user_pkg');

Line: 296


   , 'Delete from CSL_CONTR_BUSS_PROCESSES_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 300


 DELETE CSL_CONTR_BUSS_PROCESSES_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 308


   , 'Delete from CSL_CONTR_BUSS_TXN_TYPES_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 312


 DELETE CSL_CONTR_BUSS_TXN_TYPES_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 320


   , 'Delete from CSL_CSI_ITEM_INSTANCES_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 324


 DELETE CSL_CSI_ITEM_INSTANCES_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 332


   , 'Delete from CSL_CS_INCIDENTS_ALL_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 336


 DELETE CSL_CS_INCIDENTS_ALL_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 344


   , 'Delete from CSL_CS_HZ_SR_CONTACT_PTS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 348


 DELETE CSL_CS_HZ_SR_CONTACT_PTS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 356


   , 'Delete from CSL_HZ_CONTACT_POINTS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 360


 DELETE CSL_HZ_CONTACT_POINTS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 368


   , 'Delete from CSL_HZ_CUST_ACCT_SITES_ALL_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 372


 DELETE CSL_HZ_CUST_ACCT_SITES_ALL_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 380


   , 'Delete from CSL_HZ_CUST_SITE_USES_ALL_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 384


 DELETE CSL_HZ_CUST_SITE_USES_ALL_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 392


   , 'Delete from CSL_HZ_LOCATIONS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 396


 DELETE CSL_HZ_LOCATIONS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 405


   , 'Delete from CSL_HZ_PARTIES_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 409


 DELETE CSL_HZ_PARTIES_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 417


   , 'Delete from CSL_HZ_PARTY_SITES_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 421


 DELETE CSL_HZ_PARTY_SITES_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 429


   , 'Delete from CSL_HZ_RELATIONSHIPS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 433


 DELETE CSL_HZ_RELATIONSHIPS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 441


   , 'Delete from CSL_JTF_TASKS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 445


 DELETE CSL_JTF_TASKS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 453


   , 'Delete from CSL_JTF_TASK_ASS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 457


 DELETE CSL_JTF_TASK_ASS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 465


   , 'Delete from CSL_MTL_ONHAND_QTY_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 469


 DELETE CSL_MTL_ONHAND_QTY_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 477


   , 'Delete from CSL_SR_CONTRACT_HEADERS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 481


 DELETE CSL_SR_CONTRACT_HEADERS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 489


   , 'Delete from JTM_CSF_DEBRIEF_HEADERS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 493


 DELETE JTM_CSF_DEBRIEF_HEADERS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 501


   , 'Delete from JTM_CSF_DEBRIEF_LINES_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 505


 DELETE JTM_CSF_DEBRIEF_LINES_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 513


   , 'Delete from JTM_CSP_INV_LOC_ASS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 517


 DELETE JTM_CSP_INV_LOC_ASS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 525


   , 'Delete from JTM_CSP_REQ_HEADERS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 529


 DELETE JTM_CSP_REQ_HEADERS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 537


   , 'Delete from JTM_CSP_REQ_LINES_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 541


 DELETE JTM_CSP_REQ_LINES_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 549


   , 'Delete from JTM_CSP_RS_CUST_RELATIONS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 553


 DELETE JTM_CSP_RS_CUST_RELATIONS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 561


   , 'Delete from JTM_CSP_SEC_INV_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 565


 DELETE JTM_CSP_SEC_INV_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 574


   , 'Delete from JTM_CS_COUNTERS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 578


 DELETE JTM_CS_COUNTERS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 586


   , 'Delete from JTM_CS_COUNTER_GROUPS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 590


 DELETE JTM_CS_COUNTER_GROUPS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 598


   , 'Delete from JTM_CS_COUNTER_PROPS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 602


 DELETE JTM_CS_COUNTER_PROPS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 610


   , 'Delete from JTM_CS_COUNTER_PROP_VALS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 614


 DELETE JTM_CS_COUNTER_PROP_VALS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 622


   , 'Delete from JTM_CS_COUNTER_VALUES_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 626


 DELETE JTM_CS_COUNTER_VALUES_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 634


   , 'Delete from JTM_JTF_NOTES_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 638


 DELETE JTM_JTF_NOTES_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 646


   , 'Delete from JTM_JTF_TASK_REFERENCES_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 650


 DELETE JTM_JTF_TASK_REFERENCES_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 658


   , 'Delete from JTM_MTL_SEC_INV_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 662


 DELETE JTM_MTL_SEC_INV_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 670


   , 'Delete from JTM_MTL_SERIAL_NUMBERS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 674


 DELETE JTM_MTL_SERIAL_NUMBERS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 682


   , 'Delete from JTM_MTL_SYSTEM_ITEMS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 686


 DELETE JTM_MTL_SYSTEM_ITEMS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 694


   , 'Delete from CSL_RESOURCE_INVENTORY_ORG for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 698


 DELETE CSL_RESOURCE_INVENTORY_ORG
 WHERE RESOURCE_ID = p_resource_id;

Line: 706


   , 'Delete from JTM_MTL_TRANS_LOT_NUM_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 710


 DELETE JTM_MTL_TRANS_LOT_NUM_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 718


   , 'Delete from JTM_MTL_UNIT_TRANS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 722


 DELETE JTM_MTL_UNIT_TRANS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 730


   , 'Delete from JTM_OE_ORDER_HEADERS_ALL_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 734


 DELETE JTM_OE_ORDER_HEADERS_ALL_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 742


   , 'Delete from JTM_OE_ORDER_LINES_ALL_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 746


 DELETE JTM_OE_ORDER_LINES_ALL_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 754


   , 'Delete from JTM_PER_ALL_PEOPLE_F_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 758


 DELETE JTM_PER_ALL_PEOPLE_F_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 766


   , 'Delete from JTM_PO_LOC_ASS_ALL_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 770


 DELETE JTM_PO_LOC_ASS_ALL_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 778


   , 'Delete from JTM_WF_NOTIFICATIONS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 782


 DELETE JTM_WF_NOTIFICATIONS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 790


   , 'Delete from JTM_WF_NOTIFICATION_AT_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 794


 DELETE JTM_WF_NOTIFICATION_AT_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 802


   , 'Delete from JTM_FND_USER_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 806


 DELETE JTM_FND_USER_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 814


   , 'Delete from JTM_JTF_RS_RESOURCE_EXTNS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 818


 DELETE JTM_JTF_RS_RESOURCE_EXTNS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 826


   , 'Delete from JTM_JTF_RS_GROUP_MEMBERS_ACC for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 830


 DELETE JTM_JTF_RS_GROUP_MEMBERS_ACC
 WHERE  RESOURCE_ID = p_resource_id;

Line: 838


   , 'Delete from CSL_SERVICE_HISTORY for resource '||p_resource_id
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
   , 'csl_user_pkg');

Line: 842


 DELETE CSL_SERVICE_HISTORY
 WHERE  RESOURCE_ID = p_resource_id;

Line: 850


   , 'Leaving DELETE_USER'
   , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
   , 'csl_user_pkg');

Line: 865


      , 'Exception occurred in DELETE_USER when calling API'
      , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
      , 'csl_user_pkg');

Line: 869


  fnd_msg_pub.Add_Exc_Msg('CSL_USER_PKG','DELETE_USER','API error');

Line: 880


      , 'Caught exception in DELETE_USER:' || fnd_global.local_chr(10) || sqlerrm
      , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
      , 'csl_user_pkg');

Line: 885


  fnd_msg_pub.Add_Exc_Msg('CSL_USER_PKG','DELETE_USER',sqlerrm);

Line: 887


END DELETE_USER;