906: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
907: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
908: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
909: p_application_id IN NUMBER,
910: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
911: := null, --amv_search_grp.Default_AreaArray,
912: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
913: := null, --amv_search_grp.Default_ContentArray,
914: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
908: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
909: p_application_id IN NUMBER,
910: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
911: := null, --amv_search_grp.Default_AreaArray,
912: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
913: := null, --amv_search_grp.Default_ContentArray,
914: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
915: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
916: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
910: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
911: := null, --amv_search_grp.Default_AreaArray,
912: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
913: := null, --amv_search_grp.Default_ContentArray,
914: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
915: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
916: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
917: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
918: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
912: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
913: := null, --amv_search_grp.Default_ContentArray,
914: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
915: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
916: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
917: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
918: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
919: p_rows_requested IN NUMBER,
920: p_start_row_pos IN NUMBER := 1,
922: x_rows_returned OUT NOCOPY NUMBER,
923: x_next_row_pos OUT NOCOPY NUMBER,
924: x_total_row_cnt OUT NOCOPY NUMBER,
925: x_result_array IN OUT NOCOPY cs_kb_result_varray_type,
926: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
927: ) is
928: l_amv_req_obj AMV_SEARCH_PVT.amv_request_obj_type;
929: l_amv_ret_obj AMV_SEARCH_PVT.amv_return_obj_type;
930: l_amv_res_array AMV_SEARCH_PVT.amv_searchres_varray_type;
924: x_total_row_cnt OUT NOCOPY NUMBER,
925: x_result_array IN OUT NOCOPY cs_kb_result_varray_type,
926: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
927: ) is
928: l_amv_req_obj AMV_SEARCH_PVT.amv_request_obj_type;
929: l_amv_ret_obj AMV_SEARCH_PVT.amv_return_obj_type;
930: l_amv_res_array AMV_SEARCH_PVT.amv_searchres_varray_type;
931: l_ret_cnt pls_integer :=0;
932:
925: x_result_array IN OUT NOCOPY cs_kb_result_varray_type,
926: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
927: ) is
928: l_amv_req_obj AMV_SEARCH_PVT.amv_request_obj_type;
929: l_amv_ret_obj AMV_SEARCH_PVT.amv_return_obj_type;
930: l_amv_res_array AMV_SEARCH_PVT.amv_searchres_varray_type;
931: l_ret_cnt pls_integer :=0;
932:
933: begin
926: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
927: ) is
928: l_amv_req_obj AMV_SEARCH_PVT.amv_request_obj_type;
929: l_amv_ret_obj AMV_SEARCH_PVT.amv_return_obj_type;
930: l_amv_res_array AMV_SEARCH_PVT.amv_searchres_varray_type;
931: l_ret_cnt pls_integer :=0;
932:
933: begin
934: -- x_result_array := cs_kb_result_varray_type();
1155: x_result_array OUT NOCOPY cs_kb_result_varray_type,
1156: p_search_option IN NUMBER := NULL
1157:
1158: )is
1159: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type
1160: := AMV_SEARCH_PVT.amv_searchpar_varray_type();
1161: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
1162: := AMV_SEARCH_PVT.amv_char_varray_type();
1163: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
1156: p_search_option IN NUMBER := NULL
1157:
1158: )is
1159: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type
1160: := AMV_SEARCH_PVT.amv_searchpar_varray_type();
1161: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
1162: := AMV_SEARCH_PVT.amv_char_varray_type();
1163: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
1164: := AMV_SEARCH_PVT.amv_char_varray_type();
1157:
1158: )is
1159: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type
1160: := AMV_SEARCH_PVT.amv_searchpar_varray_type();
1161: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
1162: := AMV_SEARCH_PVT.amv_char_varray_type();
1163: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
1164: := AMV_SEARCH_PVT.amv_char_varray_type();
1165: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
1158: )is
1159: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type
1160: := AMV_SEARCH_PVT.amv_searchpar_varray_type();
1161: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
1162: := AMV_SEARCH_PVT.amv_char_varray_type();
1163: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
1164: := AMV_SEARCH_PVT.amv_char_varray_type();
1165: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
1166: := AMV_SEARCH_PVT.amv_number_varray_type();
1159: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type
1160: := AMV_SEARCH_PVT.amv_searchpar_varray_type();
1161: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
1162: := AMV_SEARCH_PVT.amv_char_varray_type();
1163: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
1164: := AMV_SEARCH_PVT.amv_char_varray_type();
1165: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
1166: := AMV_SEARCH_PVT.amv_number_varray_type();
1167: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
1160: := AMV_SEARCH_PVT.amv_searchpar_varray_type();
1161: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
1162: := AMV_SEARCH_PVT.amv_char_varray_type();
1163: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
1164: := AMV_SEARCH_PVT.amv_char_varray_type();
1165: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
1166: := AMV_SEARCH_PVT.amv_number_varray_type();
1167: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
1168: i1 pls_integer;
1161: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
1162: := AMV_SEARCH_PVT.amv_char_varray_type();
1163: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
1164: := AMV_SEARCH_PVT.amv_char_varray_type();
1165: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
1166: := AMV_SEARCH_PVT.amv_number_varray_type();
1167: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
1168: i1 pls_integer;
1169: begin
1162: := AMV_SEARCH_PVT.amv_char_varray_type();
1163: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
1164: := AMV_SEARCH_PVT.amv_char_varray_type();
1165: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
1166: := AMV_SEARCH_PVT.amv_number_varray_type();
1167: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
1168: i1 pls_integer;
1169: begin
1170:
1163: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
1164: := AMV_SEARCH_PVT.amv_char_varray_type();
1165: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
1166: := AMV_SEARCH_PVT.amv_number_varray_type();
1167: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
1168: i1 pls_integer;
1169: begin
1170:
1171: -- convert to amv record types
1255: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1256: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1257: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1258: p_application_id IN NUMBER,
1259: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1260: := AMV_SEARCH_PVT.amv_char_varray_type(),
1261: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1262: := AMV_SEARCH_PVT.amv_char_varray_type(),
1263: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1256: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1257: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1258: p_application_id IN NUMBER,
1259: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1260: := AMV_SEARCH_PVT.amv_char_varray_type(),
1261: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1262: := AMV_SEARCH_PVT.amv_char_varray_type(),
1263: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1264: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1257: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1258: p_application_id IN NUMBER,
1259: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1260: := AMV_SEARCH_PVT.amv_char_varray_type(),
1261: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1262: := AMV_SEARCH_PVT.amv_char_varray_type(),
1263: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1264: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1265: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1258: p_application_id IN NUMBER,
1259: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1260: := AMV_SEARCH_PVT.amv_char_varray_type(),
1261: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1262: := AMV_SEARCH_PVT.amv_char_varray_type(),
1263: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1264: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1265: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1259: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1260: := AMV_SEARCH_PVT.amv_char_varray_type(),
1261: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1262: := AMV_SEARCH_PVT.amv_char_varray_type(),
1263: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1264: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1265: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1267: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1260: := AMV_SEARCH_PVT.amv_char_varray_type(),
1261: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1262: := AMV_SEARCH_PVT.amv_char_varray_type(),
1263: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1264: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1265: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1267: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1268: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1262: := AMV_SEARCH_PVT.amv_char_varray_type(),
1263: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1264: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1265: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1267: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1268: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1269: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1270: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1263: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1264: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1265: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1267: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1268: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1269: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1270: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1271: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1276: x_result_array OUT NOCOPY cs_kb_result_varray_type,
1277: p_search_option IN NUMBER := NULL
1278:
1279: )is
1280: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
1281: begin
1282: Specific_Search(
1283: p_api_version => p_api_version,
1284: p_init_msg_list => p_init_msg_list,
1324: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1325: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1326: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1327: p_application_id IN NUMBER,
1328: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1329: := AMV_SEARCH_PVT.amv_char_varray_type(),
1330: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1331: := AMV_SEARCH_PVT.amv_char_varray_type(),
1332: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1325: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1326: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1327: p_application_id IN NUMBER,
1328: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1329: := AMV_SEARCH_PVT.amv_char_varray_type(),
1330: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1331: := AMV_SEARCH_PVT.amv_char_varray_type(),
1332: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1333: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1326: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1327: p_application_id IN NUMBER,
1328: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1329: := AMV_SEARCH_PVT.amv_char_varray_type(),
1330: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1331: := AMV_SEARCH_PVT.amv_char_varray_type(),
1332: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1333: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1334: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1327: p_application_id IN NUMBER,
1328: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1329: := AMV_SEARCH_PVT.amv_char_varray_type(),
1330: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1331: := AMV_SEARCH_PVT.amv_char_varray_type(),
1332: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1333: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1334: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1335: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1328: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1329: := AMV_SEARCH_PVT.amv_char_varray_type(),
1330: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1331: := AMV_SEARCH_PVT.amv_char_varray_type(),
1332: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1333: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1334: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1335: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1336: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1329: := AMV_SEARCH_PVT.amv_char_varray_type(),
1330: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1331: := AMV_SEARCH_PVT.amv_char_varray_type(),
1332: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1333: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1334: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1335: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1336: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1337: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1331: := AMV_SEARCH_PVT.amv_char_varray_type(),
1332: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1333: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1334: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1335: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1336: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1337: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1338: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1339: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1332: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1333: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1334: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1335: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1336: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1337: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1338: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1339: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1340: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1342: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1343: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1344: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1345: x_result_array OUT NOCOPY cs_kb_result_varray_type,
1346: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type,
1347: p_search_option IN NUMBER := NULL
1348:
1349: )is
1350: l_api_name CONSTANT varchar2(30) := 'Specific_Search';