APPS.IEX_API_RECORDS_PVT SQL Statements

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

Line: 191

	-- select all the parameters for the given query_id from jtf_perz_query_param into pl/sql table
    JTF_PERZ_QUERY_PVT.Get_Perz_Query
   	(
    	  p_api_version_number  => p_api_version_number,
    	  p_init_msg_list       => p_init_msg_list,
      p_application_id      => p_application_id,
      p_profile_id          => p_profile_id,
      p_profile_name        => p_profile_name,
      p_query_id            => p_query_id,
      p_query_name          => p_query_name,
      p_query_type          => p_query_type,
      x_query_id            => x_query_id,
      x_query_name          => x_query_name,
      x_query_type          => x_query_type,
      x_query_desc          => x_query_desc,
      x_query_data_source   => x_query_data_source,
      x_query_param_tbl     => l_query_param_tbl,
      x_query_order_by_tbl  => x_query_order_by_tbl,
      x_query_raw_sql_rec   => x_query_raw_sql_rec,
      x_return_status       => x_return_status,
      x_msg_count           => x_msg_count,
      x_msg_data            => x_msg_data
   );

Line: 328

        p_date_selected           IN       VARCHAR2 DEFAULT null,
        p_category_id             IN       NUMBER DEFAULT null,
        p_show_on_calendar        IN       VARCHAR2 DEFAULT null,
        p_owner_status_id         IN       NUMBER DEFAULT null,
        p_template_id             IN       NUMBER DEFAULT null,
        p_template_group_id       IN       NUMBER DEFAULT null
    )
IS
  l_task_rsrc_req_tbl   JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;