95: -- End of comments
96: --
97: PROCEDURE find_repositories
98: (p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
96: --
97: PROCEDURE find_repositories
98: (p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
105: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
106: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
107: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
105: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
106: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
107: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
105: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
106: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
107: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: x_searchrep_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchrep_varray_type)
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
105: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
106: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
107: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: x_searchrep_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchrep_varray_type)
111:
104: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
105: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
106: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
107: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: x_searchrep_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchrep_varray_type)
111:
112: IS
105: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
106: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
107: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: x_searchrep_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchrep_varray_type)
111:
112: IS
113: l_api_name varchar2(30) := 'find_repositories';
129: x_searchrep_array => x_searchrep_array);
130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
135: THEN
136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
137: END IF;
136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
137: END IF;
138: -- Standard call to get message count and if count=1, get the message
139: FND_MSG_PUB.Count_And_Get (
140: p_encoded => FND_API.G_FALSE,
141: p_count => x_msg_count,
142: p_data => x_msg_data
143: );
144: END find_repositories;
241: -- End of comments
242: --
243: PROCEDURE find_repository_areas
244: (p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
242: --
243: PROCEDURE find_repository_areas
244: (p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
251: p_searcharea_obj IN AMV_SEARCH_PVT.amv_searchara_obj_type,
252: x_searcharea_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchara_varray_type)
253:
254: IS
267: x_searcharea_array => x_searcharea_array);
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
273: THEN
274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
275: END IF;
274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
275: END IF;
276: -- Standard call to get message count and if count=1, get the message
277: FND_MSG_PUB.Count_And_Get (
278: p_encoded => FND_API.G_FALSE,
279: p_count => x_msg_count,
280: p_data => x_msg_data
281: );
282: END find_repository_areas;
394: -- with p_request_obj.next_record_position
395: -- (Default 1 ).
396: --
397: -- return_total_count_flag IN VARCHAR2
398: -- Flag consisting of the values {fnd_api.g_true,
399: -- fnd_api.g_false} to specify whether
400: -- p_request_obj.total_record_count is
401: -- derived, albeit at a possible cost to resources
402: -- (Default fnd_api.g_false).
395: -- (Default 1 ).
396: --
397: -- return_total_count_flag IN VARCHAR2
398: -- Flag consisting of the values {fnd_api.g_true,
399: -- fnd_api.g_false} to specify whether
400: -- p_request_obj.total_record_count is
401: -- derived, albeit at a possible cost to resources
402: -- (Default fnd_api.g_false).
403: --
398: -- Flag consisting of the values {fnd_api.g_true,
399: -- fnd_api.g_false} to specify whether
400: -- p_request_obj.total_record_count is
401: -- derived, albeit at a possible cost to resources
402: -- (Default fnd_api.g_false).
403: --
404: -- OUT NOCOPY : x_return_obj OUT NOCOPY OBJ_TYPE
405: -- Object structure that reports information abOUT NOCOPY the
406: -- retrieved results set defined by p_request_obj.
423: -- total_record_count OUT NOCOPY NUMBER
424: -- Indicates the total record count in the complete
425: -- varray retrieval set only if
426: -- p_request_obj.return_total_count is set
427: -- to fnd_api.g_true; Otherwise undefined.
428: --
429: -- : x_searchres_array OUT NOCOPY ARRAY_TYPE
430: -- Varying Array of Object amv_searchres_obj_type that
431: -- holds the resulting search matches.
477: -- End of comments
478: --
479: PROCEDURE Content_Search
480: (p_api_version IN NUMBER,
481: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
483: x_return_status OUT NOCOPY VARCHAR2,
484: x_msg_count OUT NOCOPY NUMBER,
485: x_msg_data OUT NOCOPY VARCHAR2,
478: --
479: PROCEDURE Content_Search
480: (p_api_version IN NUMBER,
481: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
483: x_return_status OUT NOCOPY VARCHAR2,
484: x_msg_count OUT NOCOPY NUMBER,
485: x_msg_data OUT NOCOPY VARCHAR2,
486: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
483: x_return_status OUT NOCOPY VARCHAR2,
484: x_msg_count OUT NOCOPY NUMBER,
485: x_msg_data OUT NOCOPY VARCHAR2,
486: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
487: p_application_id IN NUMBER,
488: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type,
489: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type,
490: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
487: p_application_id IN NUMBER,
488: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type,
489: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type,
490: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
491: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
492: p_days IN NUMBER := FND_API.G_MISS_NUM,
493: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
495: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
488: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type,
489: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type,
490: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
491: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
492: p_days IN NUMBER := FND_API.G_MISS_NUM,
493: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
495: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
496: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
489: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type,
490: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
491: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
492: p_days IN NUMBER := FND_API.G_MISS_NUM,
493: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
495: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
496: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
497: p_request_obj IN AMV_SEARCH_PVT.amv_request_obj_type,
491: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
492: p_days IN NUMBER := FND_API.G_MISS_NUM,
493: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
495: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
496: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
497: p_request_obj IN AMV_SEARCH_PVT.amv_request_obj_type,
498: x_return_obj OUT NOCOPY AMV_SEARCH_PVT.amv_return_obj_type,
499: x_searchres_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type)
492: p_days IN NUMBER := FND_API.G_MISS_NUM,
493: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
495: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
496: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
497: p_request_obj IN AMV_SEARCH_PVT.amv_request_obj_type,
498: x_return_obj OUT NOCOPY AMV_SEARCH_PVT.amv_return_obj_type,
499: x_searchres_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type)
500:
524: x_searchres_array => x_searchres_array);
525:
526: EXCEPTION
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
532: END IF;
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
532: END IF;
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get (
535: p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data
538: );
539: END content_search;