110: l_api_name CONSTANT VARCHAR2(30) := 'Create_csc_prof_group_cat';
111: l_api_version_number CONSTANT NUMBER := 1.0;
112: l_return_status_full VARCHAR2(1);
113: BEGIN
114: -- Standard Start of API savepoint
115: SAVEPOINT CREATE_CSC_PROF_GROUP_CAT_PVT;
116:
117: -- Standard call to check for call compatibility.
118: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
113: BEGIN
114: -- Standard Start of API savepoint
115: SAVEPOINT CREATE_CSC_PROF_GROUP_CAT_PVT;
116:
117: -- Standard call to check for call compatibility.
118: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
119: p_api_version_number,
120: l_api_name,
121: G_PKG_NAME)
180: --
181: -- End of API body
182: --
183:
184: -- Standard check for p_commit
185: IF FND_API.to_Boolean( p_commit )
186: THEN
187: COMMIT WORK;
188: END IF;
188: END IF;
189:
190:
191:
192: -- Standard call to get message count and if count is 1, get message info.
193: FND_MSG_PUB.Count_And_Get
194: ( p_count => x_msg_count,
195: p_data => x_msg_data
196: );
299: -- Local Variables
300: l_old_PROF_GRP_CAT_rec csc_prof_group_cat_PVT.PROF_GRP_CAT_Rec_Type;
301: l_rowid ROWID;
302: BEGIN
303: -- Standard Start of API savepoint
304: SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PVT;
305:
306: -- Standard call to check for call compatibility.
307: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
302: BEGIN
303: -- Standard Start of API savepoint
304: SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PVT;
305:
306: -- Standard call to check for call compatibility.
307: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
308: p_api_version_number,
309: l_api_name,
310: G_PKG_NAME)
384: --
385: -- End of API body.
386: --
387:
388: -- Standard check for p_commit
389: IF FND_API.to_Boolean( p_commit )
390: THEN
391: COMMIT WORK;
392: END IF;
393:
394:
395:
396:
397: -- Standard call to get message count and if count is 1, get message info.
398: FND_MSG_PUB.Count_And_Get
399: ( p_count => x_msg_count,
400: p_data => x_msg_data
401: );
436: IS
437: l_api_name CONSTANT VARCHAR2(30) := 'Delete_csc_prof_group_cat';
438: l_api_version_number CONSTANT NUMBER := 1.0;
439: BEGIN
440: -- Standard Start of API savepoint
441: SAVEPOINT DELETE_CSC_PROF_GROUP_CAT_PVT;
442:
443: -- Standard call to check for call compatibility.
444: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
439: BEGIN
440: -- Standard Start of API savepoint
441: SAVEPOINT DELETE_CSC_PROF_GROUP_CAT_PVT;
442:
443: -- Standard call to check for call compatibility.
444: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
445: p_api_version_number,
446: l_api_name,
447: G_PKG_NAME)
470: --
471: -- End of API body
472: --
473:
474: -- Standard check for p_commit
475: IF FND_API.to_Boolean( p_commit )
476: THEN
477: COMMIT WORK;
478: END IF;
479:
480:
481:
482:
483: -- Standard call to get message count and if count is 1, get message info.
484: FND_MSG_PUB.Count_And_Get
485: ( p_count => x_msg_count,
486: p_data => x_msg_data
487: );
556: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
557: NULL;
558: END IF;
559:
560: -- Standard call to get message count and if count is 1, get message info.
561: FND_MSG_PUB.Count_And_Get
562: ( p_count => x_msg_count,
563: p_data => x_msg_data
564: );
647: CLOSE C1;
648: END IF;
649: END IF;
650:
651: -- Standard call to get message count and if count is 1, get message info.
652: FND_MSG_PUB.Count_And_Get
653: ( p_count => x_msg_count,
654: p_data => x_msg_data
655: );
724: CLOSE C1;
725: END IF;
726: END IF;
727:
728: -- Standard call to get message count and if count is 1, get message info.
729: FND_MSG_PUB.Count_And_Get
730: ( p_count => x_msg_count,
731: p_data => x_msg_data
732: );
770: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
771: NULL;
772: END IF;
773:
774: -- Standard call to get message count and if count is 1, get message info.
775: FND_MSG_PUB.Count_And_Get
776: ( p_count => x_msg_count,
777: p_data => x_msg_data
778: );