DBA Data[Home] [Help]

APPS.EAM_ASSET_SEARCH_PVT dependencies on FND_API

Line 43: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

39: -- Function :
40: -- Pre-reqs : None.
41: -- Parameters :
42: -- IN p_api_version IN NUMBER Required
43: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
44: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
45: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
46: --
47: -- p_application_id IN NUMBER Optional Default = 401 (INV)

Line 44: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

40: -- Pre-reqs : None.
41: -- Parameters :
42: -- IN p_api_version IN NUMBER Required
43: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
44: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
45: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
46: --
47: -- p_application_id IN NUMBER Optional Default = 401 (INV)
48: -- p_descr_flexfield_name IN VARCHAR2 Opt Default = 'MTL_EAM_ASSET_ATTR_VALUES'

Line 45: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

41: -- Parameters :
42: -- IN p_api_version IN NUMBER Required
43: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
44: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
45: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
46: --
47: -- p_application_id IN NUMBER Optional Default = 401 (INV)
48: -- p_descr_flexfield_name IN VARCHAR2 Opt Default = 'MTL_EAM_ASSET_ATTR_VALUES'
49: -- p_search_set_id IN NUMBER

Line 51: -- p_purge_option IN VARCHAR2 Optional Default = FND_API.G_FALSE

47: -- p_application_id IN NUMBER Optional Default = 401 (INV)
48: -- p_descr_flexfield_name IN VARCHAR2 Opt Default = 'MTL_EAM_ASSET_ATTR_VALUES'
49: -- p_search_set_id IN NUMBER
50: -- p_where_clause IN VARCHAR2
51: -- p_purge_option IN VARCHAR2 Optional Default = FND_API.G_FALSE
52:
53: -- OUT x_return_status OUT VARCHAR2(1)
54: -- x_msg_count OUT NUMBER
55: -- x_msg_data OUT VARCHAR2(2000)

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

69:
70: PROCEDURE BUILD_SEARCH_SQL
71: (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
74: p_commit IN VARCHAR2 := fnd_api.g_false,
75: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
76: p_application_id IN NUMBER := 401,
77: p_descr_flexfield_name IN VARCHAR2 := 'MTL_EAM_ASSET_ATTR_VALUES',

Line 74: p_commit IN VARCHAR2 := fnd_api.g_false,

70: PROCEDURE BUILD_SEARCH_SQL
71: (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
74: p_commit IN VARCHAR2 := fnd_api.g_false,
75: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
76: p_application_id IN NUMBER := 401,
77: p_descr_flexfield_name IN VARCHAR2 := 'MTL_EAM_ASSET_ATTR_VALUES',
78: p_search_set_id IN NUMBER,

Line 75: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

71: (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
74: p_commit IN VARCHAR2 := fnd_api.g_false,
75: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
76: p_application_id IN NUMBER := 401,
77: p_descr_flexfield_name IN VARCHAR2 := 'MTL_EAM_ASSET_ATTR_VALUES',
78: p_search_set_id IN NUMBER,
79: p_where_clause IN VARCHAR2 := NULL,

Line 80: p_purge_option IN VARCHAR2 := fnd_api.g_false,

76: p_application_id IN NUMBER := 401,
77: p_descr_flexfield_name IN VARCHAR2 := 'MTL_EAM_ASSET_ATTR_VALUES',
78: p_search_set_id IN NUMBER,
79: p_where_clause IN VARCHAR2 := NULL,
80: p_purge_option IN VARCHAR2 := fnd_api.g_false,
81: x_sql_stmt OUT NOCOPY VARCHAR2,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2