[Home] [Help]
41: l_return_status_full VARCHAR2(1);
42: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
43: l_access_flag VARCHAR2(1);
44: BEGIN
45: -- Standard Start of API savepoint
46: SAVEPOINT CREATE_MONITOR_CONDITION_PUB;
47:
48: -- Standard call to check for call compatibility.
49: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
44: BEGIN
45: -- Standard Start of API savepoint
46: SAVEPOINT CREATE_MONITOR_CONDITION_PUB;
47:
48: -- Standard call to check for call compatibility.
49: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
50: p_api_version_number,
51: l_api_name,
52: G_PKG_NAME)
92: --
93: -- End of API body
94: --
95:
96: -- Standard check for p_commit
97: IF FND_API.to_Boolean( p_commit )
98: THEN
99: COMMIT WORK;
100: END IF;
103: IF (AS_DEBUG_LOW_ON) THEN
104: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
105: END IF;
106:
107: -- Standard call to get message count and if count is 1, get message info.
108: FND_MSG_PUB.Count_And_Get
109: ( p_count => x_msg_count,
110: p_data => x_msg_data
111: );
164: l_api_name CONSTANT VARCHAR2(30) := 'Update_monitor_condition';
165: l_api_version_number CONSTANT NUMBER := 2.0;
166:
167: BEGIN
168: -- Standard Start of API savepoint
169: SAVEPOINT UPDATE_MONITOR_CONDITION_PUB;
170:
171: -- Standard call to check for call compatibility.
172: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
167: BEGIN
168: -- Standard Start of API savepoint
169: SAVEPOINT UPDATE_MONITOR_CONDITION_PUB;
170:
171: -- Standard call to check for call compatibility.
172: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
173: p_api_version_number,
174: l_api_name,
175: G_PKG_NAME)
215: END IF;
216: -- End of API body.
217: --
218:
219: -- Standard check for p_commit
220: IF FND_API.to_Boolean( p_commit )
221: THEN
222: COMMIT WORK;
223: END IF;
226: IF (AS_DEBUG_LOW_ON) THEN
227: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
228: END IF;
229:
230: -- Standard call to get message count and if count is 1, get message info.
231: FND_MSG_PUB.Count_And_Get
232: ( p_count => x_msg_count,
233: p_data => x_msg_data
234: );
285: l_api_name CONSTANT VARCHAR2(30) := 'Delete_monitor_condition';
286: l_api_version_number CONSTANT NUMBER := 2.0;
287: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
288: BEGIN
289: -- Standard Start of API savepoint
290: SAVEPOINT DELETE_MONITOR_CONDITION_PVT;
291:
292: -- Standard call to check for call compatibility.
293: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
288: BEGIN
289: -- Standard Start of API savepoint
290: SAVEPOINT DELETE_MONITOR_CONDITION_PVT;
291:
292: -- Standard call to check for call compatibility.
293: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
294: p_api_version_number,
295: l_api_name,
296: G_PKG_NAME)
333: --
334: -- End of API body
335: --
336:
337: -- Standard check for p_commit
338: IF FND_API.to_Boolean( p_commit )
339: THEN
340: COMMIT WORK;
341: END IF;
345: IF (AS_DEBUG_LOW_ON) THEN
346: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
347: END IF;
348:
349: -- Standard call to get message count and if count is 1, get message info.
350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data
353: );