APPS.CSM_SERVICEP_WRAPPER_PKG SQL Statements

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

Line: 30

SELECT 1
FROM asg_deferred_traninfo
WHERE device_user_name = p_user_name
AND  deferred_tran_id = p_tranid
AND  object_name = p_pubitem
;

Line: 94

        /*** found item -> delete from array and return TRUE ***/
        p_pubitems_tbl.DELETE( l_index );

Line: 318

  procedures which will insert the data that came from mobile into the backend tables using public APIs.
***/
PROCEDURE APPLY_CLIENT_CHANGES
         (
           p_user_name IN VARCHAR2,
           p_tranid    IN NUMBER
         ) IS
  l_pubitems_tbl  asg_apply.vc2_tbl_type;

Line: 401

    SELECT DISTINCT aupr.RESPONSIBILITY_ID AS RESPONSIBILITY_ID
    FROM   ASG_USER au
	,      asg_user_pub_resps aupr
    WHERE  au.USER_ID 		  	  = b_userid
	AND    aupr.pub_name 		  = 'SERVICEP'
	AND    au.user_name  		  = aupr.user_name;

Line: 411

   csm_util_pkg.log('insert called','CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);

Line: 413

   csm_util_pkg.pvt_log('insert called' || 'CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS');

Line: 424

 *  DELETE_ACCESS_RECORDS
 *  is the bootstrap procedure called by MDG upon CSM user deletion
 *  we need to iterate over the responsibilities assigned to this CSM user
 *  and call the CSM_WF_PKG.User_Resp_Post_Ins(user_id, resp_id)
 */
PROCEDURE DELETE_ACCESS_RECORDS ( p_userid in number)
IS
BEGIN
    csm_util_pkg.log('delete called','CSM_SERVICEP_WRAPPER_PKG.DELETE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);

Line: 434

END DELETE_ACCESS_RECORDS;  -- end DELETE_ACCESS_RECORDS

Line: 443

  SELECT count(1) INTO l_count
  FROM all_synonyms
  WHERE owner = g_olite_schema AND SYNONYM_NAME = 'FND_GLOBAL';

Line: 452

  SELECT count(1) INTO l_count
  FROM all_synonyms
  WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_PROFILE_PKG';

Line: 462

  SELECT count(1) INTO l_count
  FROM all_synonyms
  WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_UTIL_PKG';