24: Select organization_id
25: From mtl_parameters
26: Where organization_code = P_Code;
27: BEGIN
28: -- Standard call to check for call compatibility.
29: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
30: G_PKG_NAME) THEN
31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END IF;
70: End if;
71:
72: x_RtgRevision_rec := l_RtgRevision_rec;
73: -- End of API body.
74: -- Standard call to get message count and if count is 1, get message info.
75: FND_MSG_PUB.Count_And_Get(
76: p_count => x_msg_count,
77: p_data => x_msg_data
78: );
157: )
158: );
159:
160: BEGIN
161: -- Standard call to check for call compatibility.
162: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
163: G_PKG_NAME) THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
235:
236: x_RtgRevision_rec := l_RtgRevision_rec;
237: -- End of API body.
238:
239: -- Standard call to get message count and if count is 1, get message info.
240: FND_MSG_PUB.Count_And_Get(
241: p_count => x_msg_count,
242: p_data => x_msg_data
243: );
288: l_ProgramId number;
289: l_ApplicationId number;
290: l_ProgramUpdate date;
291: BEGIN
292: -- Standard Start of API savepoint
293: SAVEPOINT CreateRtgRevision_Pvt;
294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
296: G_PKG_NAME) THEN
290: l_ProgramUpdate date;
291: BEGIN
292: -- Standard Start of API savepoint
293: SAVEPOINT CreateRtgRevision_Pvt;
294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
296: G_PKG_NAME) THEN
297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298: END IF;
510:
511: x_RtgRevision_rec := l_RtgRevision_rec;
512: -- End of API body.
513:
514: -- Standard check of p_commit.
515: IF FND_API.To_Boolean(p_commit) THEN
516: COMMIT WORK;
517: END IF;
518: -- Standard call to get message count and if count is 1, get message info.
514: -- Standard check of p_commit.
515: IF FND_API.To_Boolean(p_commit) THEN
516: COMMIT WORK;
517: END IF;
518: -- Standard call to get message count and if count is 1, get message info.
519: FND_MSG_PUB.Count_And_Get(
520: p_count => x_msg_count,
521: p_data => x_msg_data
522: );
587: And organization_id = P_OrgId
588: And process_revision = P_Revision;
589: l_RowsFound boolean := false;
590: BEGIN
591: -- Standard Start of API savepoint
592: SAVEPOINT UpdateRtgRevision_Pvt;
593: -- Standard call to check for call compatibility.
594: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
595: G_PKG_NAME) THEN
589: l_RowsFound boolean := false;
590: BEGIN
591: -- Standard Start of API savepoint
592: SAVEPOINT UpdateRtgRevision_Pvt;
593: -- Standard call to check for call compatibility.
594: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
595: G_PKG_NAME) THEN
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
795:
796: x_RtgRevision_rec := l_RtgRevision_rec ;
797: -- End of API body.
798:
799: -- Standard check of p_commit.
800: IF FND_API.To_Boolean(p_commit) THEN
801: COMMIT WORK;
802: END IF;
803: -- Standard call to get message count and if count is 1, get message info.
799: -- Standard check of p_commit.
800: IF FND_API.To_Boolean(p_commit) THEN
801: COMMIT WORK;
802: END IF;
803: -- Standard call to get message count and if count is 1, get message info.
804: FND_MSG_PUB.Count_And_Get(
805: p_count => x_msg_count,
806: p_data => x_msg_data
807: );
857: And mrir.organization_id = P_OrgId
858: And mrir.process_revision = P_Rev
859: And mrir.effectivity_date < sysdate;
860: BEGIN
861: -- Standard Start of API savepoint
862: SAVEPOINT DeleteRtgRevision_Pvt;
863: -- Standard call to check for call compatibility.
864: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
865: G_PKG_NAME) THEN
859: And mrir.effectivity_date < sysdate;
860: BEGIN
861: -- Standard Start of API savepoint
862: SAVEPOINT DeleteRtgRevision_Pvt;
863: -- Standard call to check for call compatibility.
864: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
865: G_PKG_NAME) THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
916:
917: x_RtgRevision_rec := l_RtgRevision_rec;
918: -- End of API body.
919:
920: -- Standard check of p_commit.
921: IF FND_API.To_Boolean(p_commit) THEN
922: COMMIT WORK;
923: END IF;
924: -- Standard call to get message count and if count is 1, get message info.
920: -- Standard check of p_commit.
921: IF FND_API.To_Boolean(p_commit) THEN
922: COMMIT WORK;
923: END IF;
924: -- Standard call to get message count and if count is 1, get message info.
925: FND_MSG_PUB.Count_And_Get(
926: p_count => x_msg_count,
927: p_data => x_msg_data
928: );