APPS.JTM_MASTER_CONC_PROG_PUB SQL Statements

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

Line: 52

  SELECT PACKAGE_NAME, PROCEDURE_NAME
  FROM JTM_CON_REQUEST_DATA
  WHERE Category = p_Category_Type
  AND EXECUTE_FLAG = 'Y'
  ORDER BY EXECUTION_ORDER, PRODUCT_CODE;

Line: 90

    SELECT count(*)
    INTO l_active_count
    FROM fnd_concurrent_requests req, fnd_concurrent_programs cp
    WHERE req.argument1 = Category_Type
    AND req.PHASE_CODE = 'R'
    AND req.STATUS_CODE = 'R'
    AND req.PROGRAM_APPLICATION_ID = 874
    AND req.PROGRAM_APPLICATION_ID = cp.APPLICATION_ID
    AND req.CONCURRENT_PROGRAM_ID = cp.CONCURRENT_PROGRAM_ID
    AND cp.concurrent_program_name = 'JTM_MASTER_CONC_PROG';

Line: 106

    JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
        (v_package_name => G_PKG_NAME
	    ,v_procedure_name => L_API_NAME
	    ,v_con_query_id => NULL
        ,v_query_stmt => Category_Type
        ,v_start_time => l_proc_start
        ,v_end_time => NULL
        ,v_status => 'Running'
        ,v_message => 'JTM master concurrent program is called.'
        ,x_log_id => l_start_log_id
        ,x_status => l_status
        ,x_msg_data => l_message);

Line: 131

        JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
     	(v_package_name => x_request.PACKAGE_NAME
	    ,v_procedure_name =>  x_request.PROCEDURE_NAME
	    ,v_con_query_id => NULL
        ,v_query_stmt => Category_Type
        ,v_start_time => l_api_start
        ,v_end_time => l_api_end
        ,v_status =>  l_api_status
        ,v_message => 'The program is running.'
        ,x_log_id => l_log_id
        ,x_status => l_status
        ,x_msg_data => l_message);

Line: 212

      dynamic_stmt := 'UPDATE JTM_CON_REQUEST_DATA SET LAST_TXC_START = :1, '
          || 'LAST_TXC_END = :2, COMPLETION_TEXT = :3, STATUS = :4 '
          || 'WHERE PACKAGE_NAME = :5 AND PROCEDURE_NAME = :6';

Line: 219

      JTM_MESSAGE_LOG_PKG.UPDATE_CONC_STATUS_LOG
              (v_log_id =>l_log_id
              ,v_query_stmt => Category_Type
              ,v_start_time => l_api_start
              ,v_end_time   => l_api_end
              ,v_status     => l_api_status
              ,v_message    => l_status_message
              ,x_status     => l_status
              ,x_msg_data   => l_message);

Line: 239

   JTM_MESSAGE_LOG_PKG.UPDATE_CONC_STATUS_LOG
           (v_log_id =>l_start_log_id
           ,v_query_stmt => Category_Type
           ,v_start_time => l_proc_start
           ,v_end_time   => sysdate
           ,v_status     => l_api_status
           ,v_message    => errbuf
           ,x_status     => l_status
           ,x_msg_data   => l_message);

Line: 261

        JTM_MESSAGE_LOG_PKG.UPDATE_CONC_STATUS_LOG
           (v_log_id =>l_start_log_id
           ,v_query_stmt => Category_Type
           ,v_start_time => l_proc_start
           ,v_end_time   => sysdate
           ,v_status     => JTM_CON_QUERY_REQUEST_PKG.G_ERROR
           ,v_message    => errbuf
           ,x_status     => l_status
           ,x_msg_data   => l_message);