eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBU_KNOWLEDGE_GRP SQL Statements

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

Line: 13


  p_updated_in_days    IN   NUMBER := NULL,
    p_check_login_user  IN   VARCHAR2 := FND_API.G_TRUE,
    p_application_id    IN   NUMBER,
    p_area_array        IN   AMV_SEARCH_PVT.amv_char_varray_type
                            := null, --amv_search_grp.Default_AreaArray,
    p_content_array     IN   AMV_SEARCH_PVT.amv_char_varray_type
                            := null, --amv_search_grp.Default_ContentArray,
    p_param_array       IN   AMV_SEARCH_PVT.amv_searchpar_varray_type,
    p_user_id           IN   NUMBER := NULL,
    p_category_id       IN   AMV_SEARCH_PVT.amv_number_varray_type,
    p_include_subcats   IN      VARCHAR2 := FND_API.G_FALSE,
    p_external_contents IN      VARCHAR2 := FND_API.G_FALSE,
  p_rows_requested IN NUMBER,
  p_start_row_pos  IN NUMBER := 1,
  p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,
  x_rows_returned OUT NOCOPY NUMBER,
  x_next_row_pos OUT NOCOPY NUMBER,
  x_total_row_cnt OUT NOCOPY NUMBER,
  x_result_array       IN OUT  NOCOPY cs_kb_result_varray_type,
  x_amv_result_array   OUT  NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
) is
  l_amv_req_obj AMV_SEARCH_PVT.amv_request_obj_type;

Line: 39


   l_updated_in_days NUMBER := p_updated_in_days;

Line: 48


   if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
    l_updated_in_days := FND_API.G_MISS_NUM;

Line: 72


      p_days => l_updated_in_days,
      p_user_id => l_user_id,
      p_category_id	=> p_category_id,
      p_include_subcats => p_include_subcats,
      p_external_contents => p_external_contents,
      p_request_obj =>  l_amv_req_obj,
      x_return_obj  =>  l_amv_ret_obj,
      x_searchres_array  => l_amv_res_array);

Line: 125


  p_updated_in_days    IN   NUMBER := NULL,
   p_check_login_user   IN   VARCHAR2 := FND_API.G_TRUE,
   p_application_id     IN   NUMBER,
   p_area_array         IN   JTF_VARCHAR2_TABLE_4000   := null,
   p_content_array      IN   JTF_VARCHAR2_TABLE_4000   := null,
   p_param_operator_array     IN   JTF_VARCHAR2_TABLE_100   := null,
   p_param_searchstring_array IN   JTF_VARCHAR2_TABLE_400   := null,
   p_user_id            IN   NUMBER := NULL,
   p_category_id        IN   JTF_NUMBER_TABLE,
   p_include_subcats    IN   VARCHAR2 := FND_API.G_FALSE,
   p_external_contents  IN   VARCHAR2 := FND_API.G_FALSE,
  p_rows_requested_tbl IN   cs_kb_number_tbl_type,
  p_start_row_pos_tbl  IN   cs_kb_number_tbl_type,
  p_get_total_cnt_flag IN   VARCHAR2 := fnd_api.g_true,
  x_rows_returned_tbl  OUT  NOCOPY cs_kb_number_tbl_type,
  x_next_row_pos_tbl   OUT  NOCOPY cs_kb_number_tbl_type,
  x_total_row_cnt_tbl  OUT  NOCOPY cs_kb_number_tbl_type,
  x_result_array       OUT  NOCOPY cs_kb_result_varray_type
)is
l_param_array   AMV_SEARCH_PVT.amv_searchpar_varray_type
                := AMV_SEARCH_PVT.amv_searchpar_varray_type();

Line: 155


   l_updated_in_days NUMBER := p_updated_in_days;

Line: 162


   if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
    l_updated_in_days := FND_API.G_MISS_NUM;

Line: 218


        p_updated_in_days => l_updated_in_days,
        p_check_login_user => p_check_login_user,
        p_application_id => p_application_id,
        p_area_array => l_area_array,
        p_content_array => l_content_array,
        p_param_array  => l_param_array,
        p_user_id => l_user_id,
        p_category_id	=> l_category_id,
        p_include_subcats => p_include_subcats,
        p_external_contents => p_external_contents,
        p_rows_requested_tbl => p_rows_requested_tbl,
        p_start_row_pos_tbl  => p_start_row_pos_tbl,
        p_get_total_cnt_flag => p_get_total_cnt_flag,
        x_rows_returned_tbl => x_rows_returned_tbl,
        x_next_row_pos_tbl => x_next_row_pos_tbl,
        x_total_row_cnt_tbl => x_total_row_cnt_tbl,
        x_result_array => x_result_array,
        x_amv_result_array => l_amv_result_array);

Line: 252


  p_updated_in_days    IN   NUMBER := NULL,
    p_check_login_user  IN   VARCHAR2 := FND_API.G_TRUE,
    p_application_id    IN   NUMBER,
   p_area_array         IN   AMV_SEARCH_PVT.amv_char_varray_type
                            := AMV_SEARCH_PVT.amv_char_varray_type(),
   p_content_array      IN   AMV_SEARCH_PVT.amv_char_varray_type
                            := AMV_SEARCH_PVT.amv_char_varray_type(),
   p_param_array        IN   AMV_SEARCH_PVT.amv_searchpar_varray_type
                            := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
    p_user_id           IN   NUMBER := NULL,
    p_category_id       IN   AMV_SEARCH_PVT.amv_number_varray_type
                            :=AMV_SEARCH_PVT.amv_number_varray_type(),
    p_include_subcats   IN      VARCHAR2 := FND_API.G_FALSE,
    p_external_contents IN      VARCHAR2 := FND_API.G_FALSE,
  p_rows_requested_tbl IN cs_kb_number_tbl_type,
  p_start_row_pos_tbl  IN cs_kb_number_tbl_type,
  p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
  x_rows_returned_tbl  OUT NOCOPY cs_kb_number_tbl_type,
  x_next_row_pos_tbl   OUT NOCOPY cs_kb_number_tbl_type,
  x_total_row_cnt_tbl  OUT NOCOPY cs_kb_number_tbl_type,
  x_result_array       OUT  NOCOPY cs_kb_result_varray_type,
  x_amv_result_array   OUT  NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
)is
  l_api_name	CONSTANT varchar2(30)	:= 'Specific_Search';

Line: 279


   l_updated_in_days NUMBER := p_updated_in_days;

Line: 289


   if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
    l_updated_in_days := FND_API.G_MISS_NUM;

Line: 344


        p_updated_in_days => l_updated_in_days,
        p_check_login_user => p_check_login_user,
        p_application_id => p_application_id,
        p_area_array => p_area_array,
        p_content_array => p_content_array,
        p_param_array  => p_param_array,
        p_user_id => l_user_id,
        p_category_id	=> p_category_id,
        p_include_subcats => p_include_subcats,
        p_external_contents => p_external_contents,
        p_rows_requested => p_rows_requested_tbl(ind),
        p_start_row_pos  => p_start_row_pos_tbl(ind),
        p_get_total_cnt_flag => p_get_total_cnt_flag,
        x_rows_returned => x_rows_returned_tbl(ind),
        x_next_row_pos => x_next_row_pos_tbl(ind),
        x_total_row_cnt => x_total_row_cnt_tbl(ind),
        x_result_array => x_result_array,
        x_amv_result_array => x_amv_result_array);