DBA Data[Home] [Help]

APPS.CSC_CUST_PLANS_PUB dependencies on STANDARD

Line 355: -- Standard Start of API savepoint

351: l_api_name CONSTANT VARCHAR2(30) := 'Create_cust_plans';
352: l_api_version_number CONSTANT NUMBER := 1.0;
353: l_pvt_CSC_CUST_PLANS_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_Rec_Type;
354: BEGIN
355: -- Standard Start of API savepoint
356: SAVEPOINT CREATE_CUST_PLANS_PUB;
357:
358: -- Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 358: -- Standard call to check for call compatibility.

354: BEGIN
355: -- Standard Start of API savepoint
356: SAVEPOINT CREATE_CUST_PLANS_PUB;
357:
358: -- Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
360: p_api_version_number,
361: l_api_name,
362: G_PKG_NAME)

Line 404: -- Standard check for p_commit

400: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
401: raise FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403:
404: -- Standard check for p_commit
405: IF FND_API.to_Boolean( p_commit )
406: THEN
407: COMMIT WORK;
408: END IF;

Line 410: -- Standard call to get message count and if count is 1, get message info.

406: THEN
407: COMMIT WORK;
408: END IF;
409:
410: -- Standard call to get message count and if count is 1, get message info.
411: FND_MSG_PUB.Count_And_Get
412: ( p_count => x_msg_count,
413: p_data => x_msg_data );
414:

Line 595: -- Standard Start of API savepoint

591: l_api_name CONSTANT VARCHAR2(30) := 'Update_cust_plans';
592: l_api_version_number CONSTANT NUMBER := 1.0;
593: l_pvt_CSC_CUST_PLANS_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_Rec_Type;
594: BEGIN
595: -- Standard Start of API savepoint
596: SAVEPOINT UPDATE_CUST_PLANS_PUB;
597:
598: -- Standard call to check for call compatibility.
599: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 598: -- Standard call to check for call compatibility.

594: BEGIN
595: -- Standard Start of API savepoint
596: SAVEPOINT UPDATE_CUST_PLANS_PUB;
597:
598: -- Standard call to check for call compatibility.
599: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
600: p_api_version_number,
601: l_api_name,
602: G_PKG_NAME)

Line 640: -- Standard check for p_commit

636: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
637: raise FND_API.G_EXC_UNEXPECTED_ERROR;
638: END IF;
639:
640: -- Standard check for p_commit
641: IF FND_API.to_Boolean( p_commit )
642: THEN
643: COMMIT WORK;
644: END IF;

Line 646: -- Standard call to get message count and if count is 1, get message info.

642: THEN
643: COMMIT WORK;
644: END IF;
645:
646: -- Standard call to get message count and if count is 1, get message info.
647: FND_MSG_PUB.Count_And_Get
648: ( p_count => x_msg_count,
649: p_data => x_msg_data );
650:

Line 704: -- Standard Start of API savepoint

700: l_csc_cust_plans_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_REC_TYPE;
701: l_api_name CONSTANT VARCHAR2(30) := 'Enable_Plan';
702: l_api_version_number CONSTANT NUMBER := 1.0;
703: BEGIN
704: -- Standard Start of API savepoint
705: SAVEPOINT ENABLE_PLAN_PUB;
706:
707: -- Standard call to check for call compatibility.
708: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 707: -- Standard call to check for call compatibility.

703: BEGIN
704: -- Standard Start of API savepoint
705: SAVEPOINT ENABLE_PLAN_PUB;
706:
707: -- Standard call to check for call compatibility.
708: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
709: p_api_version_number,
710: l_api_name,
711: G_PKG_NAME)

Line 748: -- Standard check for p_commit

744: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
745: APP_EXCEPTION.RAISE_EXCEPTION;
746: end if;
747:
748: -- Standard check for p_commit
749: IF FND_API.to_Boolean( p_commit )
750: THEN
751: COMMIT WORK;
752: END IF;

Line 754: -- Standard call to get message count and if count is 1, get message info.

750: THEN
751: COMMIT WORK;
752: END IF;
753:
754: -- Standard call to get message count and if count is 1, get message info.
755: FND_MSG_PUB.Count_And_Get
756: ( p_count => x_msg_count,
757: p_data => x_msg_data );
758:

Line 778: -- Standard Start of API savepoint

774: l_csc_cust_plans_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_REC_TYPE;
775: l_api_name CONSTANT VARCHAR2(30) := 'Disable_Plan';
776: l_api_version_number CONSTANT NUMBER := 1.0;
777: BEGIN
778: -- Standard Start of API savepoint
779: SAVEPOINT DISABLE_PLAN_PUB;
780:
781: -- Standard call to check for call compatibility.
782: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 781: -- Standard call to check for call compatibility.

777: BEGIN
778: -- Standard Start of API savepoint
779: SAVEPOINT DISABLE_PLAN_PUB;
780:
781: -- Standard call to check for call compatibility.
782: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
783: p_api_version_number,
784: l_api_name,
785: G_PKG_NAME)

Line 818: -- Standard check for p_commit

814: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
815: APP_EXCEPTION.RAISE_EXCEPTION;
816: end if;
817:
818: -- Standard check for p_commit
819: IF FND_API.to_Boolean( p_commit )
820: THEN
821: COMMIT WORK;
822: END IF;

Line 824: -- Standard call to get message count and if count is 1, get message info.

820: THEN
821: COMMIT WORK;
822: END IF;
823:
824: -- Standard call to get message count and if count is 1, get message info.
825: FND_MSG_PUB.Count_And_Get
826: ( p_count => x_msg_count,
827: p_data => x_msg_data );
828:

Line 845: -- Standard Start of API savepoint

841: l_api_name CONSTANT VARCHAR2(30) := 'Delete_cust_plans';
842: l_api_version_number CONSTANT NUMBER := 1.0;
843: l_pvt_CSC_CUST_PLANS_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_Rec_Type;
844: BEGIN
845: -- Standard Start of API savepoint
846: SAVEPOINT DELETE_CUST_PLANS_PUB;
847:
848: -- Standard call to check for call compatibility.
849: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 848: -- Standard call to check for call compatibility.

844: BEGIN
845: -- Standard Start of API savepoint
846: SAVEPOINT DELETE_CUST_PLANS_PUB;
847:
848: -- Standard call to check for call compatibility.
849: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
850: p_api_version_number,
851: l_api_name,
852: G_PKG_NAME)

Line 869: -- Standard check for p_commit

865:
866: CSC_CUST_PLANS_PKG.Delete_Row(
867: P_CUST_PLAN_ID => P_CUST_PLAN_ID);
868:
869: -- Standard check for p_commit
870: IF FND_API.to_Boolean( p_commit )
871: THEN
872: COMMIT WORK;
873: END IF;

Line 875: -- Standard call to get message count and if count is 1, get message info.

871: THEN
872: COMMIT WORK;
873: END IF;
874:
875: -- Standard call to get message count and if count is 1, get message info.
876: FND_MSG_PUB.Count_And_Get
877: ( p_count => x_msg_count,
878: p_data => x_msg_data );
879: