138: -- Parameters :
139: --
140: -- Standard IN Parameters :
141: -- p_api_version IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
145: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
146: -- Based on this flag, the API will set the default attributes.
139: --
140: -- Standard IN Parameters :
141: -- p_api_version IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
145: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
146: -- Based on this flag, the API will set the default attributes.
147: -- p_module_type IN VARCHAR2 Default NULL
140: -- Standard IN Parameters :
141: -- p_api_version IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
145: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
146: -- Based on this flag, the API will set the default attributes.
147: -- p_module_type IN VARCHAR2 Default NULL
148: -- This will be null.
141: -- p_api_version IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
145: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
146: -- Based on this flag, the API will set the default attributes.
147: -- p_module_type IN VARCHAR2 Default NULL
148: -- This will be null.
149: -- Standard OUT Parameters :
174:
175: PROCEDURE Search_MR_Instances
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_default IN VARCHAR2 := FND_API.G_TRUE,
182: p_module_type IN VARCHAR2 := NULL,
175: PROCEDURE Search_MR_Instances
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_default IN VARCHAR2 := FND_API.G_TRUE,
182: p_module_type IN VARCHAR2 := NULL,
183: p_start_row IN NUMBER,
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_default IN VARCHAR2 := FND_API.G_TRUE,
182: p_module_type IN VARCHAR2 := NULL,
183: p_start_row IN NUMBER,
184: p_rows_per_page IN NUMBER,
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_default IN VARCHAR2 := FND_API.G_TRUE,
182: p_module_type IN VARCHAR2 := NULL,
183: p_start_row IN NUMBER,
184: p_rows_per_page IN NUMBER,
185: p_search_mr_instance_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_MRInstance_Rec_Type,
198: -- Parameters :
199: --
200: -- Standard IN Parameters :
201: -- p_api_version IN NUMBER Required
202: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
203: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
204: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
205: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
206: -- Based on this flag, the API will set the default attributes.
199: --
200: -- Standard IN Parameters :
201: -- p_api_version IN NUMBER Required
202: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
203: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
204: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
205: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
206: -- Based on this flag, the API will set the default attributes.
207: -- p_module_type IN VARCHAR2 Default NULL
200: -- Standard IN Parameters :
201: -- p_api_version IN NUMBER Required
202: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
203: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
204: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
205: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
206: -- Based on this flag, the API will set the default attributes.
207: -- p_module_type IN VARCHAR2 Default NULL
208: -- This will be null.
201: -- p_api_version IN NUMBER Required
202: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
203: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
204: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
205: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
206: -- Based on this flag, the API will set the default attributes.
207: -- p_module_type IN VARCHAR2 Default NULL
208: -- This will be null.
209: -- Standard OUT Parameters :
235:
236: PROCEDURE BUILD_UMP_SEARCH_QUERY
237: (
238: P_API_VERSION IN NUMBER,
239: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
240: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
241: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242: P_DEFAULT IN VARCHAR2 := FND_API.G_TRUE,
243: P_MODULE_TYPE IN VARCHAR2 := NULL,
236: PROCEDURE BUILD_UMP_SEARCH_QUERY
237: (
238: P_API_VERSION IN NUMBER,
239: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
240: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
241: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242: P_DEFAULT IN VARCHAR2 := FND_API.G_TRUE,
243: P_MODULE_TYPE IN VARCHAR2 := NULL,
244: P_SEARCH_UMP_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_UMP_REC_TYPE,
237: (
238: P_API_VERSION IN NUMBER,
239: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
240: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
241: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242: P_DEFAULT IN VARCHAR2 := FND_API.G_TRUE,
243: P_MODULE_TYPE IN VARCHAR2 := NULL,
244: P_SEARCH_UMP_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_UMP_REC_TYPE,
245: X_UMP_SEARCH_QUERY OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_SEARCH_QUERY_TYPE,
238: P_API_VERSION IN NUMBER,
239: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
240: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
241: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242: P_DEFAULT IN VARCHAR2 := FND_API.G_TRUE,
243: P_MODULE_TYPE IN VARCHAR2 := NULL,
244: P_SEARCH_UMP_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_UMP_REC_TYPE,
245: X_UMP_SEARCH_QUERY OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_SEARCH_QUERY_TYPE,
246: X_UMP_BIND_PARAMS OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_BIND_PARAM_TBL_TYPE,