[Home] [Help]
136: l_api_name CONSTANT VARCHAR2(30) := 'Create_profile_groups';
137: l_api_version_number CONSTANT NUMBER := 1.0;
138: l_return_status_full VARCHAR2(1);
139: BEGIN
140: -- Standard Start of API savepoint
141: SAVEPOINT CREATE_PROFILE_GROUPS_PVT;
142:
143: -- Standard call to check for call compatibility.
144: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
139: BEGIN
140: -- Standard Start of API savepoint
141: SAVEPOINT CREATE_PROFILE_GROUPS_PVT;
142:
143: -- Standard call to check for call compatibility.
144: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
145: p_api_version_number,
146: l_api_name,
147: G_PKG_NAME)
210: --
211: -- End of API body
212: --
213:
214: -- Standard check for p_commit
215: IF FND_API.to_Boolean( p_commit )
216: THEN
217: COMMIT WORK;
218: END IF;
218: END IF;
219:
220:
221:
222: -- Standard call to get message count and if count is 1, get message info.
223: FND_MSG_PUB.Count_And_Get
224: ( p_count => x_msg_count,
225: p_data => x_msg_data
226: );
354:
355: l_old_PROF_GROUP_rec PROF_GROUP_Rec_Type;
356: l_rowid ROWID;
357: BEGIN
358: -- Standard Start of API savepoint
359: SAVEPOINT UPDATE_PROFILE_GROUPS_PVT;
360:
361: -- Standard call to check for call compatibility.
362: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
357: BEGIN
358: -- Standard Start of API savepoint
359: SAVEPOINT UPDATE_PROFILE_GROUPS_PVT;
360:
361: -- Standard call to check for call compatibility.
362: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
363: p_api_version_number,
364: l_api_name,
365: G_PKG_NAME)
455: --
456: -- End of API body.
457: --
458:
459: -- Standard check for p_commit
460: IF FND_API.to_Boolean( p_commit )
461: THEN
462: COMMIT WORK;
463: END IF;
463: END IF;
464:
465:
466:
467: -- Standard call to get message count and if count is 1, get message info.
468: FND_MSG_PUB.Count_And_Get
469: ( p_count => x_msg_count,
470: p_data => x_msg_data
471: );
510: IS
511: l_api_name CONSTANT VARCHAR2(30) := 'Delete_profile_groups';
512: l_api_version_number CONSTANT NUMBER := 1.0;
513: BEGIN
514: -- Standard Start of API savepoint
515: SAVEPOINT DELETE_PROFILE_GROUPS_PVT;
516:
517: -- Standard call to check for call compatibility.
518: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
513: BEGIN
514: -- Standard Start of API savepoint
515: SAVEPOINT DELETE_PROFILE_GROUPS_PVT;
516:
517: -- Standard call to check for call compatibility.
518: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
519: p_api_version_number,
520: l_api_name,
521: G_PKG_NAME)
545: p_OBJECT_VERSION_NUMBER => p_OBJECT_VERSION_NUMBER);
546: --
547: -- End of API body
548: --
549: -- Standard check for p_commit
550: IF FND_API.to_Boolean( p_commit )
551: THEN
552: COMMIT WORK;
553: END IF;
552: COMMIT WORK;
553: END IF;
554:
555:
556: -- Standard call to get message count and if count is 1, get message info.
557: FND_MSG_PUB.Count_And_Get
558: ( p_count => x_msg_count,
559: p_data => x_msg_data
560: );
664: END LOOP;
665: END IF;
666: END IF;
667:
668: -- Standard call to get message count and if count is 1, get message info.
669: FND_MSG_PUB.Count_And_Get
670: ( p_count => x_msg_count,
671: p_data => x_msg_data
672: );
730: --no validate of group name code
731: NULL;
732: END IF;
733:
734: -- Standard call to get message count and if count is 1, get message info.
735: FND_MSG_PUB.Count_And_Get
736: ( p_count => x_msg_count,
737: p_data => x_msg_data
738: );
777: p_argument => 'P_USE_IN_CUSTOMER_DASHBOARD');
778: END IF;
779: END IF;
780:
781: -- Standard call to get message count and if count is 1, get message info.
782: FND_MSG_PUB.Count_And_Get
783: ( p_count => x_msg_count,
784: p_data => x_msg_data
785: );
821: p_argument => 'P_SEEDED_FLAG');
822: END IF;
823: END IF;
824:
825: -- Standard call to get message count and if count is 1, get message info.
826: FND_MSG_PUB.Count_And_Get
827: ( p_count => x_msg_count,
828: p_data => x_msg_data
829: );