[Home] [Help]
35: l_api_version_number CONSTANT NUMBER := 2.0;
36: l_return_status_full VARCHAR2(1);
37: l_access_flag VARCHAR2(1);
38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT CREATE_ENTYROUT_PVT;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT CREATE_ENTYROUT_PVT;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
44: p_api_version_number,
45: l_api_name,
46: G_PKG_NAME)
162: --
163: -- End of API body
164: --
165:
166: -- Standard check for p_commit
167: IF FND_API.to_Boolean( p_commit )
168: THEN
169: COMMIT WORK;
170: END IF;
176: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
177: END IF;
178:
179:
180: -- Standard call to get message count and if count is 1, get message info.
181: FND_MSG_PUB.Count_And_Get
182: ( p_count => x_msg_count,
183: p_data => x_msg_data
184: );
246: l_ref_ENTYROUT_rec PV_RULE_RECTYPE_PUB.ENTYROUT_Rec_Type;
247: l_tar_ENTYROUT_rec PV_RULE_RECTYPE_PUB.ENTYROUT_Rec_Type := P_ENTYROUT_Rec;
248: l_rowid ROWID;
249: BEGIN
250: -- Standard Start of API savepoint
251: SAVEPOINT UPDATE_ENTYROUT_PVT;
252:
253: -- Standard call to check for call compatibility.
254: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
249: BEGIN
250: -- Standard Start of API savepoint
251: SAVEPOINT UPDATE_ENTYROUT_PVT;
252:
253: -- Standard call to check for call compatibility.
254: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
255: p_api_version_number,
256: l_api_name,
257: G_PKG_NAME)
403: ); --
404: -- End of API body.
405: --
406:
407: -- Standard check for p_commit
408: IF FND_API.to_Boolean( p_commit )
409: THEN
410: COMMIT WORK;
411: END IF;
417: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
418: END IF;
419:
420:
421: -- Standard call to get message count and if count is 1, get message info.
422: FND_MSG_PUB.Count_And_Get
423: ( p_count => x_msg_count,
424: p_data => x_msg_data
425: );
476: IS
477: l_api_name CONSTANT VARCHAR2(30) := 'Delete_entyrout';
478: l_api_version_number CONSTANT NUMBER := 2.0;
479: BEGIN
480: -- Standard Start of API savepoint
481: SAVEPOINT DELETE_ENTYROUT_PVT;
482:
483: -- Standard call to check for call compatibility.
484: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
479: BEGIN
480: -- Standard Start of API savepoint
481: SAVEPOINT DELETE_ENTYROUT_PVT;
482:
483: -- Standard call to check for call compatibility.
484: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
485: p_api_version_number,
486: l_api_name,
487: G_PKG_NAME)
522: --
523: -- End of API body
524: --
525:
526: -- Standard check for p_commit
527: IF FND_API.to_Boolean( p_commit )
528: THEN
529: COMMIT WORK;
530: END IF;
536: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
537: END IF;
538:
539:
540: -- Standard call to get message count and if count is 1, get message info.
541: FND_MSG_PUB.Count_And_Get
542: ( p_count => x_msg_count,
543: p_data => x_msg_data
544: );
650: END IF;
651: END IF;
652:
653:
654: -- Standard call to get message count and if count is 1, get message info.
655: FND_MSG_PUB.Count_And_Get
656: ( p_count => x_msg_count,
657: p_data => x_msg_data
658: );
696: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
697: NULL;
698: END IF;
699:
700: -- Standard call to get message count and if count is 1, get message info.
701: FND_MSG_PUB.Count_And_Get
702: ( p_count => x_msg_count,
703: p_data => x_msg_data
704: );