157: -- End of comments
158: --
159: PROCEDURE find_repositories
160: (p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
158: --
159: PROCEDURE find_repositories
160: (p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
167: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
168: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
167: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
168: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
167: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
168: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: x_searchrep_array OUT NOCOPY amv_searchrep_varray_type);
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
167: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
168: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: x_searchrep_array OUT NOCOPY amv_searchrep_varray_type);
173: --
166: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
167: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
168: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: x_searchrep_array OUT NOCOPY amv_searchrep_varray_type);
173: --
174: --------------------------------------------------------------------------------
167: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
168: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: x_searchrep_array OUT NOCOPY amv_searchrep_varray_type);
173: --
174: --------------------------------------------------------------------------------
175: -- Start of comments
269: -- End of comments
270: --
271: PROCEDURE find_repository_areas
272: (p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
270: --
271: PROCEDURE find_repository_areas
272: (p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
279: p_searcharea_obj IN amv_searchara_obj_type,
280: x_searcharea_array OUT NOCOPY amv_searchara_varray_type);
281: --
282: --------------------------------------------------------------------------------
392: -- with p_request_obj.next_record_position
393: -- (Default 1 ).
394: --
395: -- return_total_count_flag IN VARCHAR2
396: -- Flag consisting of the values {fnd_api.g_true,
397: -- fnd_api.g_false} to specify whether
398: -- p_request_obj.total_record_count is
399: -- derived, albeit at a possible cost to resources
400: -- (Default fnd_api.g_false).
393: -- (Default 1 ).
394: --
395: -- return_total_count_flag IN VARCHAR2
396: -- Flag consisting of the values {fnd_api.g_true,
397: -- fnd_api.g_false} to specify whether
398: -- p_request_obj.total_record_count is
399: -- derived, albeit at a possible cost to resources
400: -- (Default fnd_api.g_false).
401: --
396: -- Flag consisting of the values {fnd_api.g_true,
397: -- fnd_api.g_false} to specify whether
398: -- p_request_obj.total_record_count is
399: -- derived, albeit at a possible cost to resources
400: -- (Default fnd_api.g_false).
401: --
402: -- OUT : x_return_obj OUT OBJ_TYPE
403: -- Object structure that reports information about the
404: -- retrieved results set defined by p_request_obj.
421: -- total_record_count OUT NUMBER
422: -- Indicates the total record count in the complete
423: -- varray retrieval set only if
424: -- p_request_obj.return_total_count is set
425: -- to fnd_api.g_true; Otherwise undefined.
426: --
427: -- : x_searchres_array OUT ARRAY_TYPE
428: -- Varying Array of Object amv_searchres_obj_type that
429: -- holds the resulting search matches.
475: -- End of comments
476: --
477: PROCEDURE Content_Search
478: (p_api_version IN NUMBER,
479: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
480: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
481: x_return_status OUT NOCOPY VARCHAR2,
482: x_msg_count OUT NOCOPY NUMBER,
483: x_msg_data OUT NOCOPY VARCHAR2,
476: --
477: PROCEDURE Content_Search
478: (p_api_version IN NUMBER,
479: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
480: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
481: x_return_status OUT NOCOPY VARCHAR2,
482: x_msg_count OUT NOCOPY NUMBER,
483: x_msg_data OUT NOCOPY VARCHAR2,
484: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
480: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
481: x_return_status OUT NOCOPY VARCHAR2,
482: x_msg_count OUT NOCOPY NUMBER,
483: x_msg_data OUT NOCOPY VARCHAR2,
484: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
485: p_application_id IN NUMBER,
486: p_area_array IN amv_char_varray_type,
487: p_content_array IN amv_char_varray_type,
488: p_param_array IN amv_searchpar_varray_type,
485: p_application_id IN NUMBER,
486: p_area_array IN amv_char_varray_type,
487: p_content_array IN amv_char_varray_type,
488: p_param_array IN amv_searchpar_varray_type,
489: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_days IN NUMBER := FND_API.G_MISS_NUM,
491: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
492: p_category_id IN amv_number_varray_type,
493: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
486: p_area_array IN amv_char_varray_type,
487: p_content_array IN amv_char_varray_type,
488: p_param_array IN amv_searchpar_varray_type,
489: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_days IN NUMBER := FND_API.G_MISS_NUM,
491: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
492: p_category_id IN amv_number_varray_type,
493: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
494: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
487: p_content_array IN amv_char_varray_type,
488: p_param_array IN amv_searchpar_varray_type,
489: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_days IN NUMBER := FND_API.G_MISS_NUM,
491: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
492: p_category_id IN amv_number_varray_type,
493: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
494: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
495: p_request_obj IN amv_request_obj_type,
489: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_days IN NUMBER := FND_API.G_MISS_NUM,
491: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
492: p_category_id IN amv_number_varray_type,
493: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
494: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
495: p_request_obj IN amv_request_obj_type,
496: x_return_obj OUT NOCOPY amv_return_obj_type,
497: x_searchres_array OUT NOCOPY amv_searchres_varray_type);
490: p_days IN NUMBER := FND_API.G_MISS_NUM,
491: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
492: p_category_id IN amv_number_varray_type,
493: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
494: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
495: p_request_obj IN amv_request_obj_type,
496: x_return_obj OUT NOCOPY amv_return_obj_type,
497: x_searchres_array OUT NOCOPY amv_searchres_varray_type);
498: