[Home] [Help]
138: l_api_name CONSTANT VARCHAR2(30) := 'Create_csc_prof_group_cat';
139: l_api_version_number CONSTANT NUMBER := 1.0;
140: l_pvt_PROF_GRP_CAT_rec CSC_PROF_GROUP_CAT_PVT.PROF_GRP_CAT_Rec_Type;
141: BEGIN
142: -- Standard Start of API savepoint
143: SAVEPOINT CREATE_CSC_PROF_GROUP_CAT_PUB;
144:
145: -- Standard call to check for call compatibility.
146: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
141: BEGIN
142: -- Standard Start of API savepoint
143: SAVEPOINT CREATE_CSC_PROF_GROUP_CAT_PUB;
144:
145: -- Standard call to check for call compatibility.
146: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
147: p_api_version_number,
148: l_api_name,
149: G_PKG_NAME)
199: --
200: -- End of API body.
201: --
202:
203: -- Standard check for p_commit
204: IF FND_API.to_Boolean( p_commit )
205: THEN
206: COMMIT WORK;
207: END IF;
207: END IF;
208:
209:
210:
211: -- Standard call to get message count and if count is 1, get message info.
212: FND_MSG_PUB.Count_And_Get
213: ( p_count => x_msg_count,
214: p_data => x_msg_data
215: );
306: l_api_name CONSTANT VARCHAR2(30) := 'Update_csc_prof_group_cat';
307: l_api_version_number CONSTANT NUMBER := 1.0;
308: l_pvt_PROF_GRP_CAT_rec CSC_PROF_GROUP_CAT_PVT.PROF_GRP_CAT_Rec_Type;
309: BEGIN
310: -- Standard Start of API savepoint
311: SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PUB;
312:
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
309: BEGIN
310: -- Standard Start of API savepoint
311: SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PUB;
312:
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
315: p_api_version_number,
316: l_api_name,
317: G_PKG_NAME)
364: --
365: -- End of API body
366: --
367:
368: -- Standard check for p_commit
369: IF FND_API.to_Boolean( p_commit )
370: THEN
371: COMMIT WORK;
372: END IF;
372: END IF;
373:
374:
375:
376: -- Standard call to get message count and if count is 1, get message info.
377: FND_MSG_PUB.Count_And_Get
378: ( p_count => x_msg_count,
379: p_data => x_msg_data
380: );
423: l_api_name CONSTANT VARCHAR2(30) := 'Delete_csc_prof_group_cat';
424: l_api_version_number CONSTANT NUMBER := 1.0;
425: l_pvt_PROF_GRP_CAT_rec CSC_PROF_GROUP_CAT_PVT.PROF_GRP_CAT_Rec_Type;
426: BEGIN
427: -- Standard Start of API savepoint
428: SAVEPOINT DELETE_CSC_PROF_GROUP_CAT_PUB;
429:
430: -- Standard call to check for call compatibility.
431: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
426: BEGIN
427: -- Standard Start of API savepoint
428: SAVEPOINT DELETE_CSC_PROF_GROUP_CAT_PUB;
429:
430: -- Standard call to check for call compatibility.
431: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
432: p_api_version_number,
433: l_api_name,
434: G_PKG_NAME)
480: --
481: -- End of API body
482: --
483:
484: -- Standard check for p_commit
485: IF FND_API.to_Boolean( p_commit )
486: THEN
487: COMMIT WORK;
488: END IF;
488: END IF;
489:
490:
491:
492: -- Standard call to get message count and if count is 1, get message info.
493: FND_MSG_PUB.Count_And_Get
494: ( p_count => x_msg_count,
495: p_data => x_msg_data
496: );