166: l_api_name CONSTANT VARCHAR2(30) := 'Create_prof_module_groups';
167: l_api_version_number CONSTANT NUMBER := 2.0;
168: l_pvt_PROF_MODULE_GRP_rec CSC_PROF_MODULE_GROUPS_PVT.PROF_MODULE_GRP_Rec_Type;
169: BEGIN
170: -- Standard Start of API savepoint
171: SAVEPOINT CREATE_PROF_MODULE_GROUPS_PUB;
172:
173: -- Standard call to check for call compatibility.
174: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
169: BEGIN
170: -- Standard Start of API savepoint
171: SAVEPOINT CREATE_PROF_MODULE_GROUPS_PUB;
172:
173: -- Standard call to check for call compatibility.
174: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
175: p_api_version_number,
176: l_api_name,
177: G_PKG_NAME)
227: --
228: -- End of API body.
229: --
230:
231: -- Standard check for p_commit
232: IF FND_API.to_Boolean( p_commit )
233: THEN
234: COMMIT WORK;
235: END IF;
235: END IF;
236:
237:
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: );
344: l_api_name CONSTANT VARCHAR2(30) := 'Update_prof_module_groups';
345: l_api_version_number CONSTANT NUMBER := 1.0;
346: l_pvt_PROF_MODULE_GRP_rec CSC_PROF_MODULE_GROUPS_PVT.PROF_MODULE_GRP_Rec_Type;
347: BEGIN
348: -- Standard Start of API savepoint
349: SAVEPOINT UPDATE_PROF_MODULE_GROUPS_PUB;
350:
351: -- Standard call to check for call compatibility.
352: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
347: BEGIN
348: -- Standard Start of API savepoint
349: SAVEPOINT UPDATE_PROF_MODULE_GROUPS_PUB;
350:
351: -- Standard call to check for call compatibility.
352: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
353: p_api_version_number,
354: l_api_name,
355: G_PKG_NAME)
402: --
403: -- End of API body
404: --
405:
406: -- Standard check for p_commit
407: IF FND_API.to_Boolean( p_commit )
408: THEN
409: COMMIT WORK;
410: END IF;
410: END IF;
411:
412:
413:
414: -- Standard call to get message count and if count is 1, get message info.
415: FND_MSG_PUB.Count_And_Get
416: ( p_count => x_msg_count,
417: p_data => x_msg_data
418: );
459: l_api_name CONSTANT VARCHAR2(30) := 'Delete_prof_module_groups';
460: l_api_version_number CONSTANT NUMBER := 1.0;
461: l_pvt_PROF_MODULE_GRP_rec CSC_PROF_MODULE_GROUPS_PVT.PROF_MODULE_GRP_Rec_Type;
462: BEGIN
463: -- Standard Start of API savepoint
464: SAVEPOINT DELETE_PROF_MODULE_GROUPS_PUB;
465:
466: -- Standard call to check for call compatibility.
467: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
462: BEGIN
463: -- Standard Start of API savepoint
464: SAVEPOINT DELETE_PROF_MODULE_GROUPS_PUB;
465:
466: -- Standard call to check for call compatibility.
467: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
468: p_api_version_number,
469: l_api_name,
470: G_PKG_NAME)
518: --
519: -- End of API body
520: --
521:
522: -- Standard check for p_commit
523: IF FND_API.to_Boolean( p_commit )
524: THEN
525: COMMIT WORK;
526: END IF;
526: END IF;
527:
528:
529:
530: -- Standard call to get message count and if count is 1, get message info.
531: FND_MSG_PUB.Count_And_Get
532: ( p_count => x_msg_count,
533: p_data => x_msg_data
534: );