APPS.CSM_USER_EVENT_PKG SQL Statements

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

Line: 24

SELECT 1					  --R12-Multiple Responsibility
FROM  asg_user_pub_resps aupr,
	  asg_user asu
WHERE aupr.user_name 		   = asu.user_name
AND   aupr.responsibility_id   = p_resp_id
AND   asu.user_id 			   = l_user_id
AND   aupr.pub_name			   = 'SERVICEP';

Line: 95

SELECT au.user_id
FROM asg_user au,
     asg_user_pub_resps  asg_resp
WHERE au.user_id <> p_user_id
AND au.enabled = 'Y'
AND asg_resp.pub_name = 'SERVICEP'
AND asg_resp.user_name = au.user_name;

Line: 205

IS  --SELECT tasks which are open and are closed and within history days
SELECT jt.task_id
FROM   JTF_TASKS_B jt,
       jtf_task_statuses_b jts
WHERE  jt.created_by = b_user_id
AND    jts.task_status_id = jt.task_status_id
AND    ( --task which are closed and within history days
	   	 (  jt.creation_date BETWEEN SYSDATE AND (SYSDATE - csm_profile_pkg.get_task_history_days(b_user_id))
      	   AND (   NVL(jts.cancelled_flag,'N')   = 'Y' OR NVL(jts.closed_flag,'N')     = 'Y'
           	 OR NVL(jts.rejected_flag,'N') 	= 'Y' OR NVL(jts.completed_flag, 'N') = 'Y'
		   	 )
	  	 )
         OR --task which are open
         (	 NOT (NVL(jts.cancelled_flag,'N') = 'Y' OR NVL(jts.closed_flag,'N') 	  = 'Y'
           OR NVL(jts.rejected_flag,'N') 	= 'Y' OR NVL(jts.completed_flag, 'N') = 'Y'
		       )
	     )
	  )
UNION	--select tasks which are created by the user and their correspdg SR is open
SELECT jt.task_id
FROM   JTF_TASKS_B jt
WHERE  jt.created_by = b_user_id
AND	   jt.source_object_type_code ='SR'
AND   EXISTS
	  (SELECT inc.incident_id
	   FROM   cs_incidents_all_b 	  inc,
       		  cs_incident_statuses_b ists
	   WHERE  inc.INCIDENT_STATUS_ID  = ists.INCIDENT_STATUS_ID
	   AND    NVL(ists.CLOSE_FLAG,'N')= 'N'
	   AND    inc.incident_id 		  = jt.source_object_id
	  );

Line: 270

SELECT incident_id
FROM   cs_incidents_all_b inc,
       cs_incident_statuses_b   ists
WHERE (
       inc.owner_group_id = b_grp_id
      OR
       csm_util_pkg.get_owner(inc.created_by)=b_user_id
      )
AND    inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
AND    inc.install_site_id IS NOT NULL
AND    NVL(ists.CLOSE_FLAG, 'N') <> 'Y';

Line: 285

SELECT GROUP_ID,USER_ID
FROM ASG_USER
WHERE USER_ID=b_user_id
AND   USER_ID=OWNER_ID;

Line: 329

SELECT jtf_ta.task_assignment_id  --get all the task assignments which are open and of type TASK
FROM   jtf_rs_resource_extns jtf_rs,
       jtf_task_assignments  jtf_ta,
       jtf_task_statuses_b 	 jts_jta
WHERE  jtf_rs.user_id 	   	  = p_user_id
AND    jtf_ta.resource_id 	  = jtf_rs.resource_id
AND    jts_jta.task_Status_id = jtf_ta.assignment_status_id
AND NOT( NVL(jts_jta.cancelled_flag, 'N')     = 'Y' OR NVL(jts_jta.closed_flag, 'N')  = 'Y'
     	  OR NVL(jts_jta.completed_flag, 'N') = 'Y' OR NVL(jts_jta.rejected_flag,'N') = 'Y')
AND EXISTS (

		    SELECT 1
		    FROM   jtf_tasks_b jt,
      			   jtf_task_statuses_b jts
		    WHERE 	jt.task_id = jtf_ta.task_id
			AND    jts.task_status_id = jt.task_status_id
			AND    jt.source_object_type_code ='TASK'
 			AND NOT (   NVL(jts.cancelled_flag, 'N')     = 'Y' OR NVL(jts.closed_flag, 'N')      = 'Y'
          		OR NVL(jts.completed_flag, 'N') 	  = 'Y' OR NVL(jts.rejected_flag,'N')     = 'Y'
	 			 )
 			)
UNION ALL--Select task assignments which are for open SRs
SELECT jtf_ta.task_assignment_id
FROM   jtf_rs_resource_extns jtf_rs,
       jtf_task_assignments jtf_ta,
	   JTF_TASKS_B jt
WHERE  jtf_rs.user_id 	   	  = p_user_id
AND    jt.task_id 			  = jtf_ta.task_id
AND    jtf_ta.resource_id 	  = jtf_rs.resource_id
AND    jt.source_object_type_code ='SR'
AND   EXISTS
	  (SELECT 'X'
	   FROM   cs_incidents_all_b 	  inc,
       		  cs_incident_statuses_b ists
	   WHERE  inc.INCIDENT_STATUS_ID  = ists.INCIDENT_STATUS_ID
	   AND    NVL(ists.CLOSE_FLAG,'N')= 'N'
	   AND    inc.incident_id 		  = jt.source_object_id
	  );

Line: 412

    DELETE FROM csm_user_inventory_org WHERE user_id = p_user_id;

Line: 414

    INSERT INTO csm_user_inventory_org (
      user_id, organization_id, last_update_date, last_updated_by,
      creation_date, created_by, category_set_id, category_id )
    VALUES (
      p_user_id, l_organization_id, SYSDATE, 1, SYSDATE, 1,
      l_category_set_id, l_category_id );

Line: 448

SELECT csp_inv_loc_assignment_id
FROM csp_inv_loc_assignments
WHERE resource_id = p_resource_id
AND resource_type = 'RS_EMPLOYEE'
AND SYSDATE BETWEEN nvl(effective_date_start, SYSDATE) AND nvl(effective_date_end, SYSDATE);

Line: 486

SELECT pla.location_id ,
       pla.org_id ,
	   decode(rcr.resource_type,'RS_GROUP','G','E') resource_type,
       au.user_id                 user_id,
       cas.party_site_id            party_site_id
FROM   po_location_associations_all pla,
       hz_cust_site_uses_all        csu,
       hz_cust_acct_sites_all       cas,
       csp_rs_cust_relations        rcr,
       asg_user                      au
WHERE  csu.site_use_id       = pla.site_use_id
AND    csu.site_use_code     = 'SHIP_TO'
AND    csu.cust_acct_site_id = cas.cust_acct_site_id
AND    csu.status            = 'A'
AND    cas.cust_account_id   = rcr.customer_id
AND    cas.status            = 'A'
AND    ((rcr.resource_type='RS_EMPLOYEE' AND au.resource_id      = rcr.resource_id)
        OR
	    (rcr.resource_type='RS_GROUP' AND    rcr.resource_id IN (SELECT group_id FROM jtf_rs_group_members_vl WHERE category='EMPLOYEE' AND resource_id = au.resource_id)))
AND    au.resource_id      = p_resource_id;

Line: 551

SELECT hdr.requirement_header_id,
       au.resource_id,
       au.user_id
FROM   csp_requirement_headers hdr,
       asg_user au
WHERE hdr.resource_id = au.resource_id
AND   au.resource_id = p_resource_id
AND NOT EXISTS
(SELECT 1
 FROM csm_req_headers_acc acc
 WHERE acc.requirement_header_id = hdr.requirement_header_id
 AND acc.user_id = au.user_id
 );

Line: 599

SELECT hdr.requirement_header_id,
       hdr.resource_id,
       line.requirement_line_id,
       au.user_id
FROM   csp_requirement_headers hdr,
       csp_requirement_lines line,
       asg_user au
WHERE  hdr.requirement_header_id = line.requirement_header_id
AND    hdr.resource_id = au.resource_id
AND    au.resource_id = p_resource_id
AND NOT EXISTS
(SELECT 1
 FROM csm_req_lines_acc acc
 WHERE acc.requirement_line_id = line.requirement_line_id
 AND acc.user_id = au.user_id
 );

Line: 672

 select count(1) into l_req from csm_html5_cache where user_name='CSM_CACHE_PVT' and rownum=1;

Line: 696

SELECT user_name,resource_id, NVL(multi_platform,'N')
FROM asg_user
WHERE user_id = p_user_id;

Line: 720

  CSM_USER_EVENT_PKG.INSERT_ACC (p_user_id =>p_user_id
             ,x_return_status =>l_return_status
             ,x_error_message =>l_error_msg);

Line: 787

    CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP (p_user_id=>p_user_id
                                    ,X_RETURN_STATUS=>L_RETURN_STATUS
                                    , x_error_message => l_error_msg);

Line: 794

    CSM_LOBS_EVENT_PKG.Insert_all_acc_records(p_user_id=>p_user_id);

Line: 871

     DELETE FROM CSM_DEBRIEF_LINES_ACC 	 	   WHERE user_id = p_user_id;

Line: 872

     DELETE FROM CSM_DEBRIEF_HEADERS_ACC 	   WHERE user_id = p_user_id;

Line: 873

     DELETE FROM CSM_ITEM_INSTANCES_ACC  	   WHERE user_id = p_user_id;

Line: 874

     DELETE FROM CSM_NOTES_ACC 			 	   WHERE user_id = p_user_id;

Line: 875

     DELETE FROM CSM_NOTIFICATIONS_ACC 	 	   WHERE user_id = p_user_id;

Line: 877

     DELETE FROM CSM_PARTIES_ACC 		 	   WHERE user_id = p_user_id;

Line: 878

     DELETE FROM CSM_PARTY_SITES_ACC 	 	   WHERE user_id = p_user_id;

Line: 879

     DELETE FROM csm_profile_option_values_acc WHERE user_id = p_user_id;

Line: 881

     DELETE FROM CSM_RS_RESOURCE_EXTNS_ACC 	   WHERE user_id = p_user_id;

Line: 885

     DELETE FROM CSM_TASK_ASSIGNMENTS_ACC 	   WHERE user_id = p_user_id;

Line: 887

     DELETE FROM CSM_TASKS_ACC 				   WHERE user_id = p_user_id;

Line: 888

     DELETE FROM CSM_INCIDENTS_ALL_ACC 		   WHERE user_id = p_user_id;

Line: 889

     DELETE FROM CSM_SR_CONTACTS_ACC 		   WHERE user_id = p_user_id;

Line: 890

     DELETE FROM CSM_CUSTOMIZATION_VIEWS_ACC   WHERE user_id = p_user_id;

Line: 891

     DELETE FROM CSM_PAGE_PERZ_DELTA_ACC 	   WHERE user_id = p_user_id;

Line: 893

     DELETE FROM CSM_NEW_MESSAGES_ACC 		   WHERE user_id = p_user_id;

Line: 894

     DELETE FROM CSM_STATE_TRANSITIONS_ACC 	   WHERE user_id = p_user_id;

Line: 895

     DELETE FROM csm_mtl_system_items_acc 	   WHERE user_id = p_user_id;

Line: 896

     DELETE FROM csm_mtl_serial_numbers_acc    WHERE user_id = p_user_id;

Line: 897

     DELETE FROM csm_mtl_material_txn_acc 	   WHERE user_id = p_user_id;

Line: 899

     DELETE FROM csm_mtl_txn_lot_num_acc 	   WHERE user_id = p_user_id;

Line: 900

     DELETE FROM csm_mtl_unit_txn_acc 		   WHERE user_id = p_user_id;

Line: 901

     DELETE FROM csm_inv_loc_ass_acc 		   WHERE user_id = p_user_id;

Line: 902

     DELETE FROM csm_po_loc_ass_all_acc 	   WHERE user_id = p_user_id;

Line: 903

     DELETE FROM csm_req_lines_acc 			   WHERE user_id = p_user_id;

Line: 905

	 DELETE FROM csm_req_line_Details_acc 	   WHERE user_id = p_user_id;

Line: 906

     DELETE FROM csm_req_headers_acc 		   WHERE user_id = p_user_id;

Line: 907

     DELETE FROM csm_system_items_acc 		   WHERE user_id = p_user_id;

Line: 908

     DELETE FROM csm_mtl_item_subinv_acc 	   WHERE user_id = p_user_id;

Line: 909

     DELETE FROM csm_mtl_sec_inv_acc 		   WHERE user_id = p_user_id;

Line: 910

     DELETE FROM csm_ii_relationships_acc 	   WHERE user_id = p_user_id;

Line: 912

     DELETE FROM csm_contr_headers_acc 		   WHERE user_id = p_user_id;

Line: 913

     DELETE FROM csm_contr_buss_processes_acc  WHERE user_id = p_user_id;

Line: 914

     DELETE FROM csm_contr_buss_txn_types_acc  WHERE user_id = p_user_id;

Line: 916

     DELETE FROM csm_service_history_acc 	   WHERE user_id = p_user_id;

Line: 917

     DELETE FROM csm_debrief_headers_acc 	   WHERE user_id = p_user_id;

Line: 919

     DELETE FROM csm_counters_acc 			   WHERE user_id = p_user_id;

Line: 920

     DELETE FROM csm_counter_values_acc 	   WHERE user_id = p_user_id;

Line: 921

     DELETE FROM csm_mtl_item_locations_acc    WHERE user_id = p_user_id;

Line: 922

     DELETE FROM csm_mtl_secondary_locators_acc WHERE user_id = p_user_id;

Line: 923

     DELETE FROM csm_mtl_onhand_qty_acc 	   WHERE user_id = p_user_id;

Line: 925

     DELETE FROM csm_user_inventory_org 	   WHERE user_id = p_user_id;

Line: 926

     DELETE FROM CSM_FND_LOBS_ACC 			   WHERE user_id = p_user_id;--Bug 4938130

Line: 927

	 DELETE FROM CSM_HZ_CUST_ACCOUNTS_ACC      WHERE user_id = p_user_id;--Bug 5213097

Line: 928

	 DELETE FROM CSM_SR_TYPE_MAPPING_ACC	   WHERE user_id = p_user_id;--Bug 5213097

Line: 929

	 DELETE FROM CSM_CSI_ITEM_ATTR_ACC		   WHERE user_id = p_user_id;--Bug 5213097

Line: 930

	 DELETE FROM CSM_HZ_LOCATIONS_ACC		   WHERE user_id = p_user_id;--Bug 5213097

Line: 932

	 DELETE FROM CSM_HZ_CONTACT_POINTS_ACC 	   WHERE user_id = p_user_id;

Line: 933

	 DELETE FROM CSM_COUNTER_PROP_VALUES_ACC   WHERE user_id = p_user_id;

Line: 934

	 DELETE FROM CSM_COUNTER_PROPERTIES_ACC	   WHERE user_id = p_user_id;

Line: 935

	 DELETE FROM CSM_HZ_RELATIONSHIPS_ACC 	   WHERE user_id = p_user_id;

Line: 936

	 DELETE FROM CSM_PARTY_ASSIGNMENT 	   WHERE user_id = p_user_id;

Line: 938

   DELETE FROM CSM_CLIENT_NFN_LOG_ACC   WHERE user_id=p_user_id;

Line: 939

   DELETE FROM CSM_AUTO_SYNC_LOG_ACC    WHERE user_id=p_user_id;

Line: 940

   DELETE FROM CSM_AUTO_SYNC_ACC        WHERE user_id=p_user_id;

Line: 941

   DELETE FROM CSM_QUERY_ACC            WHERE user_id=p_user_id;

Line: 942

   DELETE FROM CSM_QUERY_VARIABLES_ACC  WHERE user_id=p_user_id;

Line: 943

   DELETE FROM CSM_QUERY_INSTANCES_ACC  WHERE user_id=p_user_id;

Line: 944

   DELETE FROM CSM_QUERY_VARIABLE_VALUES_ACC  WHERE user_id=p_user_id;

Line: 945

   DELETE FROM CSM_QUERY_RESULTS_ACC    WHERE user_id=p_user_id;

Line: 946

   DELETE FROM CSM_COV_ACTION_TIMES_ACC WHERE user_id=p_user_id;

Line: 947

   DELETE FROM CSM_CLIENT_UNDO_REQUEST_ACC    WHERE user_id=p_user_id;

Line: 953

  CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP (p_user_id=>p_user_id
                                    ,x_return_status=>l_return_status
                                    , x_error_message => l_error_msg);

Line: 957

  CSM_USER_EVENT_PKG.DELETE_ACC (p_user_id =>p_user_id
             ,x_return_status =>l_return_status
             ,x_error_message =>l_error_msg);

Line: 1015

	 CSM_SERIAL_NUMBERS_EVENT_PKG.insert_mtl_serial_numbers(l_organization_id,TO_DATE('1','J'),p_resource_id,p_user_id);

Line: 1031

PROCEDURE INSERT_ACC (p_user_id IN NUMBER
                                    ,x_return_status OUT NOCOPY VARCHAR2
                                    , x_error_message OUT NOCOPY VARCHAR2)
IS
l_sqlerrno 	VARCHAR(20);

Line: 1050

SELECT USER_ID,OWNER_ID,GROUP_ID
FROM
ASG_USER
WHERE USER_ID=l_user_id;

Line: 1057

SELECT USER_ID
FROM
CSM_USER_ACC
WHERE USER_ID=l_user_id;

Line: 1064

SELECT USR.USER_ID,USR.OWNER_ID,ACC.ACCESS_ID
FROM   ASG_USER USR,
       CSM_USER_ACC ACC
WHERE  USR.OWNER_ID=l_owner_id
AND    USR.USER_ID = ACC.USER_ID;

Line: 1071

   CSM_UTIL_PKG.LOG('Entering INSERT_ACC for User_id ' || p_user_id,
     'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 1080

    DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;

Line: 1083

   SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id  FROM DUAL;

Line: 1085

   INSERT INTO CSM_USER_ACC(ACCESS_ID,USER_ID,OWNER_ID,COUNTER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
   VALUES     (l_access_id,l_user_id,l_owner_id,1,sysdate,1,sysdate,1,1);

Line: 1096

   CSM_UTIL_PKG.LOG('User is inserted into the Access table: User_id ' || p_user_id,
     'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 1103

        l_tab_user_id.DELETE;

Line: 1106

        l_tab_owner_id.DELETE;

Line: 1109

        l_tab_access_id.DELETE;

Line: 1116

          UPDATE CSM_USER_ACC
          SET OWNER_ID     = l_tab_owner_id(i),
          LAST_UPDATE_DATE = SYSDATE
          WHERE USER_ID = l_tab_user_id(i);

Line: 1135

   CSM_UTIL_PKG.LOG('Leaving INSERT_ACC for User_id ' || p_user_id,
     'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 1141

	  l_error_msg := 'Exception in 	INSERT_ACC for User_id '
	  || TO_CHAR(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line: 1144

	  CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_EXCEPTION);

Line: 1146

END INSERT_ACC;

Line: 1148

PROCEDURE DELETE_ACC (p_user_id IN NUMBER
                                    ,x_return_status OUT NOCOPY VARCHAR2
                                    , x_error_message OUT NOCOPY VARCHAR2)
IS
l_sqlerrno 	VARCHAR(20);

Line: 1163

SELECT ACCESS_ID,USER_ID,OWNER_ID
FROM
CSM_USER_ACC
WHERE USER_ID=l_user_id;

Line: 1170

   CSM_UTIL_PKG.LOG('Entering DELETE_ACC for User_id ' || p_user_id,
     'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 1187

      DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;

Line: 1189

      CSM_UTIL_PKG.LOG('User is Deleted From the Access table for  User_id :' || p_user_id,
        'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 1194

   CSM_UTIL_PKG.LOG('Leaving DELETE_ACC for User_id ' || p_user_id,
     'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 1200

	  l_error_msg := 'Exception in 	DELETE_ACC for User_id '
	  || TO_CHAR(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line: 1203

	  CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_EXCEPTION);

Line: 1205

END DELETE_ACC;

Line: 1208

  The following two apis are used for inserting/deleting
  non-group member records in CSM_USER_ACC for the (user,owner)
*/

PROCEDURE INSERT_ACC (p_user_id IN NUMBER,p_owner_id IN NUMBER)
IS
l_sqlerrno 	VARCHAR(20);

Line: 1226

SELECT ACCESS_ID
FROM CSM_USER_ACC
WHERE USER_ID=b_user_id
AND OWNER_ID = b_owner_id;

Line: 1232

   CSM_UTIL_PKG.LOG('Entering INSERT_ACC for User_id ' || p_user_id ||' and owner_id: '||p_owner_id,
     'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 1239

     'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 1240

     UPDATE CSM_USER_ACC SET COUNTER=COUNTER+1 ,LAST_UPDATE_DATE=sysdate WHERE ACCESS_ID=l_access_id;

Line: 1246

     SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id  FROM DUAL;

Line: 1248

     INSERT INTO CSM_USER_ACC(ACCESS_ID,USER_ID,OWNER_ID,COUNTER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
     VALUES     (l_access_id,p_user_id,p_owner_id,1,sysdate,1,sysdate,1,1);

Line: 1251

     CSM_UTIL_PKG.LOG('Record inserted into the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||') and Marking dirty',
       'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 1263

   CSM_UTIL_PKG.LOG('Leaving INSERT_ACC for User_id ' || p_user_id ||' and owner_id: '||p_owner_id,'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 1268

	  l_error_msg := 'Exception in 	INSERT_ACC for User_id '
	  || TO_CHAR(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line: 1271

	  CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_EXCEPTION);

Line: 1273

END INSERT_ACC;

Line: 1275

PROCEDURE DELETE_ACC (p_user_id IN NUMBER,p_owner_id IN NUMBER)
IS
l_sqlerrno 	VARCHAR(20);

Line: 1287

SELECT access_id,counter
FROM CSM_USER_ACC
WHERE USER_ID=b_user_id
AND OWNER_ID = b_owner_id;

Line: 1293

   CSM_UTIL_PKG.LOG('Entering DELETE_ACC for User_id ' || p_user_id ||' and owner_id: '||p_owner_id,
     'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 1309

       DELETE FROM CSM_USER_ACC WHERE USER_ID =p_user_id
 	   AND OWNER_ID=p_owner_id;

Line: 1312

       UPDATE CSM_USER_ACC SET COUNTER=COUNTER-1 ,LAST_UPDATE_DATE=sysdate WHERE USER_ID =p_user_id
       AND OWNER_ID=p_owner_id;

Line: 1317

   CSM_UTIL_PKG.LOG('Leaving DELETE_ACC for User_id ' || p_user_id ||' and owner_id: '||p_owner_id,
     'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 1323

	  l_error_msg := 'Exception in 	DELETE_ACC for User_id '
	  || TO_CHAR(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line: 1326

	  CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_EXCEPTION);

Line: 1328

END DELETE_ACC;