DBA Data[Home] [Help]

APPS.AMV_SEARCH_GRP dependencies on FND_API

Line 99: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 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,

Line 105: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 106: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,

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)

Line 107: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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:

Line 108: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

Line 109: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

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';

Line 133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;

Line 140: p_encoded => FND_API.G_FALSE,

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;

Line 245: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 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

Line 271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;

Line 278: p_encoded => FND_API.G_FALSE,

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;

Line 398: -- Flag consisting of the values {fnd_api.g_true,

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).

Line 399: -- fnd_api.g_false} to specify whether

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: --

Line 402: -- (Default fnd_api.g_false).

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.

Line 427: -- to fnd_api.g_true; Otherwise undefined.

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.

Line 481: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 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,

Line 491: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 492: p_days IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 493: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 495: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

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)

Line 496: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

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:

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;

Line 535: p_encoded => FND_API.G_FALSE,

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;