APPS.JTF_FM_OCM_REQUEST_GRP SQL Statements

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

Line: 375

	   	just before calling send request we will insert a record into
   	   	history table. Reason. GET_ATTACH_FILE_ID AND GET_FILE_ID in jtfgfmob.pls should
   	   	know about REQUEST_TYPE 'T'
   	   	other details in GET_ATTACH_FILE_ID and GET_FILE_ID
	      **/
      	 IF (upper(p_fulfill_electronic_rec.request_type) = 'T') THEN
    	  	  JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST TYPE IS TEST',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

Line: 382

          	  INSERT INTO JTF_FM_TEST_REQUESTS (REQUEST_ID) VALUES (x_request_history_id);

Line: 539

	      UPDATE JTF_FM_REQUEST_HISTORY_ALL
          SET request_type = 'T'
          WHERE hist_req_id = x_request_history_id;