[Home] [Help]
35: l_return_status_full VARCHAR2(1);
36: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
37: l_access_flag VARCHAR2(1);
38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT CREATE_MONITOR_CONDITION_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_MONITOR_CONDITION_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)
163: --
164: -- End of API body
165: --
166:
167: -- Standard check for p_commit
168: IF FND_API.to_Boolean( p_commit )
169: THEN
170: COMMIT WORK;
171: 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: );
289: l_ref_CONDITION_rec AML_MONITOR_CONDITIONS_PUB.CONDITION_Rec_Type;
290: l_tar_CONDITION_rec AML_MONITOR_CONDITIONS_PUB.CONDITION_Rec_Type := P_CONDITION_Rec;
291: l_rowid ROWID;
292: BEGIN
293: -- Standard Start of API savepoint
294: SAVEPOINT UPDATE_MONITOR_CONDITION_PVT;
295:
296: -- Standard call to check for call compatibility.
297: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
292: BEGIN
293: -- Standard Start of API savepoint
294: SAVEPOINT UPDATE_MONITOR_CONDITION_PVT;
295:
296: -- Standard call to check for call compatibility.
297: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
298: p_api_version_number,
299: l_api_name,
300: G_PKG_NAME)
493: ); --
494: -- End of API body.
495: --
496:
497: -- Standard check for p_commit
498: IF FND_API.to_Boolean( p_commit )
499: THEN
500: COMMIT WORK;
501: END IF;
506: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
507: END IF;
508:
509:
510: -- Standard call to get message count and if count is 1, get message info.
511: FND_MSG_PUB.Count_And_Get
512: ( p_count => x_msg_count,
513: p_data => x_msg_data
514: );
566: l_api_name CONSTANT VARCHAR2(30) := 'Delete_monitor_condition';
567: l_api_version_number CONSTANT NUMBER := 2.0;
568: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
569: BEGIN
570: -- Standard Start of API savepoint
571: SAVEPOINT DELETE_MONITOR_CONDITION_PVT;
572:
573: -- Standard call to check for call compatibility.
574: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
569: BEGIN
570: -- Standard Start of API savepoint
571: SAVEPOINT DELETE_MONITOR_CONDITION_PVT;
572:
573: -- Standard call to check for call compatibility.
574: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
575: p_api_version_number,
576: l_api_name,
577: G_PKG_NAME)
611: --
612: -- End of API body
613: --
614:
615: -- Standard check for p_commit
616: IF FND_API.to_Boolean( p_commit )
617: THEN
618: COMMIT WORK;
619: END IF;
623: IF (AS_DEBUG_LOW_ON) THEN
624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
625: END IF;
626:
627: -- Standard call to get message count and if count is 1, get message info.
628: FND_MSG_PUB.Count_And_Get
629: ( p_count => x_msg_count,
630: p_data => x_msg_data
631: );
748: CLOSE C_condition_Id_Exists;
749: END IF;
750: END IF;
751:
752: -- Standard call to get message count and if count is 1, get message info.
753: FND_MSG_PUB.Count_And_Get
754: ( p_count => x_msg_count,
755: p_data => x_msg_data
756: );