[Home] [Help]
479: --
480: BEGIN
481: --dbms_output.put_line('Create_TerrResource PVT: Entering API');
482:
483: -- Standard Start of API savepoint
484: SAVEPOINT CREATE_TERRRESOURCE_PVT;
485:
486: -- Standard call to check for call compatibility.
487: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
482:
483: -- Standard Start of API savepoint
484: SAVEPOINT CREATE_TERRRESOURCE_PVT;
485:
486: -- Standard call to check for call compatibility.
487: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
488: p_api_version_number,
489: l_api_name,
490: G_PKG_NAME)
635: ( p_count => x_msg_count,
636: p_data => x_msg_data
637: );
638:
639: -- Standard check for p_commit
640: IF FND_API.to_Boolean( p_commit )
641: THEN
642: COMMIT WORK;
643: END IF;
745: --
746: BEGIN
747: --dbms_output.put_line('Create_TerrResource PVT: Entering API');
748:
749: -- Standard Start of API savepoint
750: SAVEPOINT CREATE_TERRRESOURCE_PVT;
751:
752: -- Standard call to check for call compatibility.
753: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
748:
749: -- Standard Start of API savepoint
750: SAVEPOINT CREATE_TERRRESOURCE_PVT;
751:
752: -- Standard call to check for call compatibility.
753: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
754: p_api_version_number,
755: l_api_name,
756: G_PKG_NAME)
901: ( p_count => x_msg_count,
902: p_data => x_msg_data
903: );
904:
905: -- Standard check for p_commit
906: IF FND_API.to_Boolean( p_commit )
907: THEN
908: COMMIT WORK;
909: END IF;
1009: l_return_status VARCHAR2(1);
1010:
1011: BEGIN
1012: --
1013: -- Standard Start of API savepoint
1014: SAVEPOINT DELETE_TERR_RESOURCE_PVT;
1015:
1016: -- Standard call to check for call compatibility.
1017: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1012: --
1013: -- Standard Start of API savepoint
1014: SAVEPOINT DELETE_TERR_RESOURCE_PVT;
1015:
1016: -- Standard call to check for call compatibility.
1017: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1018: p_api_version_number,
1019: l_api_name,
1020: G_PKG_NAME)
1082: ( p_count => x_msg_count,
1083: p_data => x_msg_data
1084: );
1085:
1086: -- Standard check for p_commit
1087: IF FND_API.to_Boolean( p_commit )
1088: THEN
1089: COMMIT WORK;
1090: END IF;
1178: l_return_status VARCHAR2(1);
1179:
1180:
1181: BEGIN
1182: -- Standard Start of API savepoint
1183: SAVEPOINT UPDATE_TERRRESOURCE_PVT;
1184:
1185: --ARPATEL: bug#2849410
1186: Check_for_duplicate (p_TerrRsc_Tbl => p_TerrRsc_Tbl,
1191: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1192: x_return_status := l_return_status;
1193: END IF;
1194:
1195: -- Standard call to check for call compatibility.
1196: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1197: p_api_version_number,
1198: l_api_name,
1199: G_PKG_NAME)
1272: ( p_count => x_msg_count,
1273: p_data => x_msg_data
1274: );
1275:
1276: -- Standard check for p_commit
1277: IF FND_API.to_Boolean( p_commit )
1278: THEN
1279: COMMIT WORK;
1280: END IF;
2201: l_api_version_number CONSTANT NUMBER := 1.0;
2202: l_return_status VARCHAR2(1);
2203:
2204: BEGIN
2205: -- Standard start of PAI savepoint
2206: SAVEPOINT DELETE_TERRRSC_ACCESS_PVT;
2207:
2208: -- Standard call to check for call compatibility.
2209: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2204: BEGIN
2205: -- Standard start of PAI savepoint
2206: SAVEPOINT DELETE_TERRRSC_ACCESS_PVT;
2207:
2208: -- Standard call to check for call compatibility.
2209: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2210: p_api_version_number,
2211: l_api_name,
2212: G_PKG_NAME)
2257: ( p_count => x_msg_count,
2258: p_data => x_msg_data
2259: );
2260:
2261: -- Standard check for p_commit
2262: IF FND_API.to_Boolean( p_commit )
2263: THEN
2264: COMMIT WORK;
2265: END IF;
2340: l_api_version_number CONSTANT NUMBER := 1.0;
2341: l_return_status VARCHAR2(1);
2342:
2343: BEGIN
2344: -- Standard start of PAI savepoint
2345: SAVEPOINT DELETE_TERRRSC_PVT;
2346:
2347: -- Standard call to check for call compatibility.
2348: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2343: BEGIN
2344: -- Standard start of PAI savepoint
2345: SAVEPOINT DELETE_TERRRSC_PVT;
2346:
2347: -- Standard call to check for call compatibility.
2348: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2349: p_api_version_number,
2350: l_api_name,
2351: G_PKG_NAME)
2398: ( p_count => x_msg_count,
2399: p_data => x_msg_data
2400: );
2401:
2402: -- Standard check for p_commit
2403: IF FND_API.to_Boolean( p_commit )
2404: THEN
2405: COMMIT WORK;
2406: END IF;
4545:
4546:
4547: BEGIN
4548:
4549: -- Standard Start of API savepoint
4550: SAVEPOINT COPY_TERR_RESOURCES;
4551:
4552: /*
4553: -- Standard call to check for call compatibility.
4549: -- Standard Start of API savepoint
4550: SAVEPOINT COPY_TERR_RESOURCES;
4551:
4552: /*
4553: -- Standard call to check for call compatibility.
4554: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4555: p_api_version_number,
4556: l_api_name,
4557: G_PKG_NAME)
4688: x_Msg_Data := l_Msg_Data;
4689: */
4690:
4691:
4692: /* Standard call to get message count and
4693: the message information */
4694:
4695: FND_MSG_PUB.Count_And_Get
4696: (
4891: and ( jt.terr_group_flag is null OR jt.terr_group_flag = 'N' )
4892: and not jt.terr_id = 1;
4893:
4894: BEGIN
4895: -- Standard Start of API savepoint
4896: SAVEPOINT TRANSFER_TERR_RES;
4897:
4898:
4899: -- Standard call to check for call compatibility.
4895: -- Standard Start of API savepoint
4896: SAVEPOINT TRANSFER_TERR_RES;
4897:
4898:
4899: -- Standard call to check for call compatibility.
4900: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4901: p_api_version_number,
4902: l_api_name,
4903: G_PKG_NAME)
5178: ( p_count => x_msg_count,
5179: p_data => x_msg_data
5180: );
5181:
5182: -- Standard check for p_commit
5183: IF FND_API.to_Boolean( p_commit )
5184: THEN
5185: COMMIT WORK;
5186: END IF;