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