APPS.CS_KNOWLEDGE_GRP SQL Statements

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

Line: 72

PROCEDURE Delete_Set_Link(
  p_api_version	        in  number,
  p_init_msg_list       in  varchar2 := FND_API.G_FALSE,
  p_commit	        in  varchar2 := FND_API.G_FALSE,
  p_validation_level    in  number   := FND_API.G_VALID_LEVEL_FULL,
  x_return_status       OUT NOCOPY varchar2,
  x_msg_count	        OUT NOCOPY number,
  x_msg_data	        OUT NOCOPY varchar2,
  p_set_id              in  number,
  p_object_code         in  varchar2,
  p_other_id            in  number
) is
  l_api_name	CONSTANT varchar2(30)	:= 'Delete_Set_Link';

Line: 103

  l_ret := CS_KB_SET_LINKS_PKG.Delete_Set_Link_W_Obj_Code(
     p_set_id, p_object_code, p_other_id);

Line: 141

end Delete_Set_Link;

Line: 143

PROCEDURE Delete_Element_Link(
  p_api_version	        in  number,
  p_init_msg_list       in  varchar2 := FND_API.G_FALSE,
  p_commit	        in  varchar2 := FND_API.G_FALSE,
  p_validation_level    in  number   := FND_API.G_VALID_LEVEL_FULL,
  x_return_status       OUT NOCOPY varchar2,
  x_msg_count	        OUT NOCOPY number,
  x_msg_data	        OUT NOCOPY varchar2,
  p_element_id          in  number,
  p_object_code         in  varchar2,
  p_other_id            in  number
) is
  l_api_name	CONSTANT varchar2(30)	:= 'Delete_Element_Link';

Line: 176

  l_ret := CS_KB_ELEMENT_LINKS_PKG.Delete_Element_Link_W_Obj_Code(
    p_element_id, p_object_code, p_other_id);

Line: 214

end Delete_Element_Link;

Line: 799

PROCEDURE Update_Set_Link(
  p_api_version         in  number,
  p_init_msg_list       in  varchar2 := FND_API.G_FALSE,
  p_commit              in  varchar2 := FND_API.G_FALSE,
  p_validation_level    in  number   := FND_API.G_VALID_LEVEL_FULL,
  x_return_status       OUT NOCOPY varchar2,
  x_msg_count           OUT NOCOPY number,
  x_msg_data            OUT NOCOPY varchar2,
  p_set_link_rec   in  CS_KB_SET_LINKS%ROWTYPE
) is
  l_api_name    CONSTANT varchar2(30)   := 'Update_Set_Link';

Line: 816

  savepoint Update_Set_Link_Grp;

Line: 834

  l_sta := CS_KB_SET_LINKS_PKG.Update_Set_Link(
        p_set_link_rec.link_id,
        p_set_link_rec.link_type,
        p_set_link_rec.object_code,
        p_set_link_rec.set_id,
        p_set_link_rec.other_id,
        p_set_link_rec.attribute_category,
        p_set_link_rec.attribute1,
        p_set_link_rec.attribute2,
        p_set_link_rec.attribute3,
        p_set_link_rec.attribute4,
        p_set_link_rec.attribute5,
        p_set_link_rec.attribute6,
        p_set_link_rec.attribute7,
        p_set_link_rec.attribute8,
        p_set_link_rec.attribute9,
        p_set_link_rec.attribute10,
        p_set_link_rec.attribute11,
        p_set_link_rec.attribute12,
        p_set_link_rec.attribute13,
        p_set_link_rec.attribute14,
        p_set_link_rec.attribute15
  );

Line: 874

    ROLLBACK TO Update_Set_Link_Grp;

Line: 880

    ROLLBACK TO Update_Set_Link_Grp;

Line: 886

    ROLLBACK TO Update_Set_Link_Grp;

Line: 897

end Update_Set_Link;

Line: 907

  p_updated_in_days    IN   NUMBER := FND_API.G_MISS_NUM,
    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 := FND_API.G_MISS_NUM,
    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: 954

      p_days => p_updated_in_days,
      p_user_id => p_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: 1005

  p_updated_in_days    IN   NUMBER := FND_API.G_MISS_NUM,
  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,
  p_search_option  IN NUMBER := null
)is
  err_num number;

Line: 1036

    if( p_updated_in_days is not null and
        p_updated_in_days= 0) then
      l_days_cond :=
        ' and cs_kb_sets_b.last_update_date >= (sysdate - :2 ) ';

Line: 1055

        p_other_value  => p_updated_in_days,
        p_rows => p_rows_requested +
                  p_start_row_pos -1,
        p_start_row => 1,
        p_get_total_flag => p_get_total_cnt_flag,
        x_set_tbl => l_sms_res_tbl,
        x_total_rows => l_total_cnt,
        p_search_option => p_search_option);

Line: 1110

            l_sms_res_tbl(i).last_update_date,
            'cskmis03.jsp?setId='||to_char(l_sms_res_tbl(i).id),
            null, 'SMS', l_sms_res_tbl(i).solution_number);

Line: 1138

  p_updated_in_days    IN   NUMBER := FND_API.G_MISS_NUM,
   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 := FND_API.G_MISS_NUM,
   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,
  p_search_option      IN  NUMBER := NULL

)is
l_param_array   AMV_SEARCH_PVT.amv_searchpar_varray_type
                := AMV_SEARCH_PVT.amv_searchpar_varray_type();

Line: 1220

        p_updated_in_days => p_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 => p_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,
        p_search_option => p_search_option);

Line: 1256

  p_updated_in_days    IN   NUMBER := FND_API.G_MISS_NUM,
   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 := FND_API.G_MISS_NUM,
   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,
  p_search_option      IN  NUMBER := NULL

)is
l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;

Line: 1291

        p_updated_in_days => p_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 => p_user_id,
        p_category_id	=> p_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,
        p_search_option => p_search_option);

Line: 1325

  p_updated_in_days    IN   NUMBER := FND_API.G_MISS_NUM,
    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 := FND_API.G_MISS_NUM,
    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,
  p_search_option      IN  NUMBER := NULL

)is
  l_api_name	CONSTANT varchar2(30)	:= 'Specific_Search';

Line: 1414

        p_updated_in_days => p_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 => p_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);

Line: 1447

        p_updated_in_days => p_updated_in_days,
        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,
        p_search_option => l_search_option);

Line: 1477

        p_updated_in_days => p_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 => p_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);

Line: 1504

        p_updated_in_days => p_updated_in_days,
        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,
        p_search_option => l_search_option);

Line: 1612

    DELETE /*+ index(l) */ FROM CS_KB_SET_LINKS l
    WHERE l.Object_Code = P_OBJECT_TYPE
    AND l.Other_id IN ( SELECT /*+ no_unnest no_semijoin cardinality(10) */ t.Object_id
                        FROM JTF_OBJECT_PURGE_PARAM_TMP t
                        WHERE nvl(t.purge_status, 'S') <> 'E'
                        AND t.Processing_Set_Id = P_PROCESSING_SET_ID
                        AND t.Object_Type = P_OBJECT_TYPE
                       );