140: l_api_name CONSTANT VARCHAR2(30) := 'Create_prof_module_groups';
141: l_api_version_number CONSTANT NUMBER := 1.0;
142: l_return_status_full VARCHAR2(1);
143: BEGIN
144: -- Standard Start of API savepoint
145: SAVEPOINT CREATE_PROF_MODULE_GROUPS_PVT;
146:
147: -- Standard call to check for call compatibility.
148: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
143: BEGIN
144: -- Standard Start of API savepoint
145: SAVEPOINT CREATE_PROF_MODULE_GROUPS_PVT;
146:
147: -- Standard call to check for call compatibility.
148: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
149: p_api_version_number,
150: l_api_name,
151: G_PKG_NAME)
216: --
217: -- End of API body
218: --
219:
220: -- Standard check for p_commit
221: IF FND_API.to_Boolean( p_commit )
222: THEN
223: COMMIT WORK;
224: END IF;
223: COMMIT WORK;
224: END IF;
225:
226:
227: -- Standard call to get message count and if count is 1, get message info.
228: FND_MSG_PUB.Count_And_Get
229: ( p_count => x_msg_count,
230: p_data => x_msg_data
231: );
356: l_old_PROF_MODULE_GRP_rec PROF_MODULE_GRP_Rec_Type;
357: l_PROF_MODULE_GRP_Rec PROF_MODULE_GRP_Rec_Type := p_PROF_MODULE_GRP_REC;
358: l_rowid ROWID;
359: BEGIN
360: -- Standard Start of API savepoint
361: SAVEPOINT UPDATE_PROF_MODULE_GROUPS_PVT;
362:
363: -- Standard call to check for call compatibility.
364: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
359: BEGIN
360: -- Standard Start of API savepoint
361: SAVEPOINT UPDATE_PROF_MODULE_GROUPS_PVT;
362:
363: -- Standard call to check for call compatibility.
364: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
365: p_api_version_number,
366: l_api_name,
367: G_PKG_NAME)
476: --
477: -- End of API body.
478: --
479:
480: -- Standard check for p_commit
481: IF FND_API.to_Boolean( p_commit )
482: THEN
483: COMMIT WORK;
484: END IF;
483: COMMIT WORK;
484: END IF;
485:
486:
487: -- Standard call to get message count and if count is 1, get message info.
488: FND_MSG_PUB.Count_And_Get
489: ( p_count => x_msg_count,
490: p_data => x_msg_data
491: );
526: IS
527: l_api_name CONSTANT VARCHAR2(30) := 'Delete_prof_module_groups';
528: l_api_version_number CONSTANT NUMBER := 1.0;
529: BEGIN
530: -- Standard Start of API savepoint
531: SAVEPOINT DELETE_PROF_MODULE_GROUPS_PVT;
532:
533: -- Standard call to check for call compatibility.
534: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
529: BEGIN
530: -- Standard Start of API savepoint
531: SAVEPOINT DELETE_PROF_MODULE_GROUPS_PVT;
532:
533: -- Standard call to check for call compatibility.
534: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
535: p_api_version_number,
536: l_api_name,
537: G_PKG_NAME)
556: --
557: -- End of API body
558: --
559:
560: -- Standard check for p_commit
561: IF FND_API.to_Boolean( p_commit )
562: THEN
563: COMMIT WORK;
564: END IF;
564: END IF;
565:
566:
567:
568: -- Standard call to get message count and if count is 1, get message info.
569: FND_MSG_PUB.Count_And_Get
570: ( p_count => x_msg_count,
571: p_data => x_msg_data
572: );
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: END IF;
640: END IF;
641:
642: -- Standard call to get message count and if count is 1, get message info.
643: FND_MSG_PUB.Count_And_Get
644: ( p_count => x_msg_count,
645: p_data => x_msg_data
646: );
691: END IF;
692: Close C1;
693: END IF;
694:
695: -- Standard call to get message count and if count is 1, get message info.
696: FND_MSG_PUB.Count_And_Get
697: ( p_count => x_msg_count,
698: p_data => x_msg_data
699: );
742: END IF;
743: Close C1;
744: END IF;
745:
746: -- Standard call to get message count and if count is 1, get message info.
747: FND_MSG_PUB.Count_And_Get
748: ( p_count => x_msg_count,
749: p_data => x_msg_data
750: );
793: end if;
794: close C1;
795: END IF;
796:
797: -- Standard call to get message count and if count is 1, get message info.
798: FND_MSG_PUB.Count_And_Get
799: ( p_count => x_msg_count,
800: p_data => x_msg_data
801: );
858: END IF;
859: END IF;
860: END IF;
861:
862: -- Standard call to get message count and if count is 1, get message info.
863: FND_MSG_PUB.Count_And_Get
864: ( p_count => x_msg_count,
865: p_data => x_msg_data
866: );
951: Close C1;
952: END IF;
953: END IF;
954:
955: -- Standard call to get message count and if count is 1, get message info.
956: FND_MSG_PUB.Count_And_Get
957: ( p_count => x_msg_count,
958: p_data => x_msg_data
959: );
1029: END IF;
1030: END IF;
1031:
1032:
1033: -- Standard call to get message count and if count is 1, get message info.
1034: FND_MSG_PUB.Count_And_Get
1035: ( p_count => x_msg_count,
1036: p_data => x_msg_data
1037: );
1077: p_argument => 'P_CURRENCY_CODE');
1078:
1079: END IF;
1080: END IF;
1081: -- Standard call to get message count and if count is 1, get message info.
1082: FND_MSG_PUB.Count_And_Get
1083: ( p_count => x_msg_count,
1084: p_data => x_msg_data
1085: );
1189: End If;
1190:
1191: end if;
1192:
1193: -- Standard call to get message count and if count is 1, get message info.
1194: FND_MSG_PUB.Count_And_Get
1195: ( p_count => x_msg_count,
1196: p_data => x_msg_data
1197: );
1275: Close C1;
1276: END IF;
1277: END IF;
1278:
1279: -- Standard call to get message count and if count is 1, get message info.
1280: FND_MSG_PUB.Count_And_Get
1281: ( p_count => x_msg_count,
1282: p_data => x_msg_data
1283: );