257: l_api_name CONSTANT VARCHAR2(30) := 'Create_plan_lines';
258: l_api_version_number CONSTANT NUMBER := 1.0;
259: l_pvt_CSC_PLAN_LINES_rec CSC_PLAN_LINES_PVT.CSC_PLAN_LINES_Rec_Type;
260: BEGIN
261: -- Standard Start of API savepoint
262: SAVEPOINT CREATE_PLAN_LINES_PUB;
263:
264: -- Standard call to check for call compatibility.
265: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
260: BEGIN
261: -- Standard Start of API savepoint
262: SAVEPOINT CREATE_PLAN_LINES_PUB;
263:
264: -- Standard call to check for call compatibility.
265: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
266: p_api_version_number,
267: l_api_name,
268: G_PKG_NAME)
305: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
306: raise FND_API.G_EXC_UNEXPECTED_ERROR;
307: END IF;
308:
309: -- Standard check for p_commit
310: IF FND_API.to_Boolean( p_commit )
311: THEN
312: COMMIT WORK;
313: END IF;
311: THEN
312: COMMIT WORK;
313: END IF;
314:
315: -- Standard call to get message count and if count is 1, get message info.
316: FND_MSG_PUB.Count_And_Get
317: ( p_count => x_msg_count,
318: p_data => x_msg_data );
319:
454: l_api_name CONSTANT VARCHAR2(30) := 'Update_plan_lines';
455: l_api_version_number CONSTANT NUMBER := 1.0;
456: l_pvt_CSC_PLAN_LINES_rec CSC_PLAN_LINES_PVT.CSC_PLAN_LINES_Rec_Type;
457: BEGIN
458: -- Standard Start of API savepoint
459: SAVEPOINT UPDATE_PLAN_LINES_PUB;
460:
461: -- Standard call to check for call compatibility.
462: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
457: BEGIN
458: -- Standard Start of API savepoint
459: SAVEPOINT UPDATE_PLAN_LINES_PUB;
460:
461: -- Standard call to check for call compatibility.
462: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
463: p_api_version_number,
464: l_api_name,
465: G_PKG_NAME)
499: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
500: raise FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;
502:
503: -- Standard check for p_commit
504: IF FND_API.to_Boolean( p_commit )
505: THEN
506: COMMIT WORK;
507: END IF;
505: THEN
506: COMMIT WORK;
507: END IF;
508:
509: -- Standard call to get message count and if count is 1, get message info.
510: FND_MSG_PUB.Count_And_Get
511: ( p_count => x_msg_count,
512: p_data => x_msg_data );
513:
564: l_api_name CONSTANT VARCHAR2(30) := 'Delete_plan_lines';
565: l_api_version_number CONSTANT NUMBER := 1.0;
566: l_pvt_CSC_PLAN_LINES_rec CSC_PLAN_LINES_PVT.CSC_PLAN_LINES_Rec_Type;
567: BEGIN
568: -- Standard Start of API savepoint
569: SAVEPOINT DELETE_PLAN_LINES_PUB;
570:
571: -- Standard call to check for call compatibility.
572: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
567: BEGIN
568: -- Standard Start of API savepoint
569: SAVEPOINT DELETE_PLAN_LINES_PUB;
570:
571: -- Standard call to check for call compatibility.
572: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
573: p_api_version_number,
574: l_api_name,
575: G_PKG_NAME)
602: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
603: raise FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606: -- Standard check for p_commit
607: IF FND_API.to_Boolean( p_commit )
608: THEN
609: COMMIT WORK;
610: END IF;
608: THEN
609: COMMIT WORK;
610: END IF;
611:
612: -- Standard call to get message count and if count is 1, get message info.
613: FND_MSG_PUB.Count_And_Get
614: ( p_count => x_msg_count,
615: p_data => x_msg_data );
616: