97:
98: -- Define Procedure GET_MR_AFFECTED_ITEMS --
99: PROCEDURE GET_MR_AFFECTED_ITEMS (
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
98: -- Define Procedure GET_MR_AFFECTED_ITEMS --
99: PROCEDURE GET_MR_AFFECTED_ITEMS (
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
99: PROCEDURE GET_MR_AFFECTED_ITEMS (
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_mr_header_id IN NUMBER,
142:
143: -- Declare Procedures GET_APPLICABLE_MRS --
144: PROCEDURE GET_APPLICABLE_MRS (
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
143: -- Declare Procedures GET_APPLICABLE_MRS --
144: PROCEDURE GET_APPLICABLE_MRS (
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
144: PROCEDURE GET_APPLICABLE_MRS (
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_item_instance_id IN NUMBER,
211:
212: -- Declare Procedures GET_PM_APPLICABLE_MRS --
213: PROCEDURE GET_PM_APPLICABLE_MRS (
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
212: -- Declare Procedures GET_PM_APPLICABLE_MRS --
213: PROCEDURE GET_PM_APPLICABLE_MRS (
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
213: PROCEDURE GET_PM_APPLICABLE_MRS (
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_item_instance_id IN NUMBER,
250:
251: -- Declare Procedures GET_VISIT_APPLICABLE_MRS --
252: PROCEDURE get_visit_applicable_mrs (
253: p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255: p_commit IN VARCHAR2 := FND_API.G_FALSE,
256: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_msg_count OUT NOCOPY NUMBER,
251: -- Declare Procedures GET_VISIT_APPLICABLE_MRS --
252: PROCEDURE get_visit_applicable_mrs (
253: p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255: p_commit IN VARCHAR2 := FND_API.G_FALSE,
256: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_msg_count OUT NOCOPY NUMBER,
259: x_msg_data OUT NOCOPY VARCHAR2,
252: PROCEDURE get_visit_applicable_mrs (
253: p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255: p_commit IN VARCHAR2 := FND_API.G_FALSE,
256: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_msg_count OUT NOCOPY NUMBER,
259: x_msg_data OUT NOCOPY VARCHAR2,
260: p_item_instance_id IN NUMBER,
288: -- Given a MR Header ID and Instance, this procedure returns effectivities
289: -- applicable even if MR has expired.
290: PROCEDURE GET_MR_APPLICABILITY(
291: p_api_version IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_commit IN VARCHAR2 := FND_API.G_FALSE,
294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
289: -- applicable even if MR has expired.
290: PROCEDURE GET_MR_APPLICABILITY(
291: p_api_version IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_commit IN VARCHAR2 := FND_API.G_FALSE,
294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,
290: PROCEDURE GET_MR_APPLICABILITY(
291: p_api_version IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_commit IN VARCHAR2 := FND_API.G_FALSE,
294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,
298: p_item_instance_id IN NUMBER,