91:
92: -- Define Procedure GET_MR_AFFECTED_ITEMS --
93: PROCEDURE GET_MR_AFFECTED_ITEMS (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE,
97: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
92: -- Define Procedure GET_MR_AFFECTED_ITEMS --
93: PROCEDURE GET_MR_AFFECTED_ITEMS (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE,
97: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
93: PROCEDURE GET_MR_AFFECTED_ITEMS (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE,
97: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_mr_header_id IN NUMBER,
133:
134: -- Declare Procedures GET_APPLICABLE_MRS --
135: PROCEDURE GET_APPLICABLE_MRS (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
134: -- Declare Procedures GET_APPLICABLE_MRS --
135: PROCEDURE GET_APPLICABLE_MRS (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
135: PROCEDURE GET_APPLICABLE_MRS (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_item_instance_id IN NUMBER,
197:
198: -- Declare Procedures GET_PM_APPLICABLE_MRS --
199: PROCEDURE GET_PM_APPLICABLE_MRS (
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
198: -- Declare Procedures GET_PM_APPLICABLE_MRS --
199: PROCEDURE GET_PM_APPLICABLE_MRS (
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
199: PROCEDURE GET_PM_APPLICABLE_MRS (
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_item_instance_id IN NUMBER,
236:
237: -- Declare Procedures GET_VISIT_APPLICABLE_MRS --
238: PROCEDURE get_visit_applicable_mrs (
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
237: -- Declare Procedures GET_VISIT_APPLICABLE_MRS --
238: PROCEDURE get_visit_applicable_mrs (
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,
238: PROCEDURE get_visit_applicable_mrs (
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,
246: p_item_instance_id IN NUMBER,