APPS.JTM_HANDHELD_WRAPPER_PKG SQL Statements

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

Line: 23

  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
BEGIN

null ;

Line: 51

 *  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
null ;

Line: 60

END DELETE_ACCESS_RECORDS;  -- end DELETE_ACCESS_RECORDS

Line: 69

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