APPS.JTF_FM_IH_LOGGER_PVT SQL Statements

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

Line: 12

    select ih_outcome_id
    from jtf_fm_service
    where server_id = P_server_ID;

Line: 38

    select ih_failure_result_id
    from jtf_fm_service where server_id = P_server_ID;

Line: 62

    select ih_success_result_id
    from jtf_fm_service where server_id = P_server_ID;

Line: 187

     select fm.HIST_REQ_ID , fm.SOURCE_CODE_ID, fm.SOURCE_CODE, fm.OBJECT_ID, fm.OBJECT_TYPE, fm.OUTCOME_DESC, fm.SERVER_ID, fm.USER_ID, fm.OUTCOME_CODE
     from JTF_FM_REQUEST_HISTORY_ALL fm
     where fm.OUTCOME_CODE = 'READYTOLOG'
     and fm.SERVER_ID = p_server_id
     and rownum < 2
     order by fm.PRIORITY, fm.HIST_REQ_ID;

Line: 198

    select REQUEST_ID, JOB, PARTY_ID, EMAIL_ADDRESS, OUTCOME_CODE, decode(EMAIL_STATUS,'SENT',l_sent_result_id,l_not_sent_result_id) as RESULT_ID,
    to_char(CREATION_DATE, 'MON DD RRRR HH24:MI:SS') as CREATION_DATE
    from jtf_fm_processed
    where request_id = l_request_id;

Line: 205

    select resource_id
	from jtf_rs_resource_extns
	where user_id = l_user_id;

Line: 359

         select user_data into l_user_data  from jtf_ih_bulk_qtbl where msgid = hextoraw(l_mesg_id);

Line: 394

      select user_data into l_user_data  from jtf_ih_bulk_qtbl where msgid = hextoraw(l_mesg_id);

Line: 409

      Update_history(l_header_rec.hist_req_id, 'SUCCESS');

Line: 411

      Update_history(l_header_rec.hist_req_id, 'FAILURE');

Line: 413

      Update_history(l_header_rec.hist_req_id, 'PARTIAL_SUCCESS');

Line: 415

      Update_history(l_header_rec.hist_req_id, 'FAILURE');

Line: 440

             Update_history(l_header_rec.hist_req_id, 'IHFAILED');

Line: 454

             Update_history(l_header_rec.hist_req_id, 'IHFAILED');

Line: 471

             Update_history(l_header_rec.hist_req_id, 'IHFAILED');

Line: 488

             Update_history(l_header_rec.hist_req_id, 'IHFAILED');

Line: 507

   delete from jtf_fm_status_all
   where request_id = P_Request_ID;

Line: 514

 PROCEDURE Update_history(P_Request_ID IN NUMBER, P_Status IN VARCHAR) Is
 BEGIN

   update JTF_FM_REQUEST_HISTORY_ALL
   set outcome_code = P_Status
   where hist_req_id = P_Request_id;