[Home] [Help]
52: l_count number;
53: BEGIN
54:
55:
56: -- Standard Start of API savepoint
57: SAVEPOINT CREATE_camp_outcome_PVT;
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
55:
56: -- Standard Start of API savepoint
57: SAVEPOINT CREATE_camp_outcome_PVT;
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
61: p_api_version_number,
62: l_api_name,
63: G_PKG_NAME)
142: --
143: -- End of API body
144: --
145:
146: -- Standard check for p_commit
147: IF FND_API.to_Boolean( p_commit )
148: THEN
149: COMMIT WORK;
150: END IF;
152:
153: -- Debug Message
154: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
155:
156: -- Standard call to get message count and if count is 1, get message info.
157: FND_MSG_PUB.Count_And_Get
158: ( p_count => x_msg_count,
159: p_data => x_msg_data
160: );
209: l_api_name CONSTANT VARCHAR2(30) := 'Delete_camp_outcome';
210: l_api_version_number CONSTANT NUMBER := 1.0;
211: l_camp_outcome_Rec camp_outcome_Rec_Type := p_camp_outcome_Rec;
212: BEGIN
213: -- Standard Start of API savepoint
214: SAVEPOINT DELETE_camp_outcome_PVT;
215:
216: -- Standard call to check for call compatibility.
217: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
212: BEGIN
213: -- Standard Start of API savepoint
214: SAVEPOINT DELETE_camp_outcome_PVT;
215:
216: -- Standard call to check for call compatibility.
217: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
218: p_api_version_number,
219: l_api_name,
220: G_PKG_NAME)
246: WHERE outcome_id = l_camp_outcome_Rec.outcome_id
247: AND source_code = l_camp_outcome_Rec.source_code
248: AND object_id = l_camp_outcome_Rec.object_id;
249:
250: -- Standard check for p_commit
251: IF FND_API.to_Boolean( p_commit )
252: THEN
253: COMMIT WORK;
254: END IF;
258: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
259:
260:
261:
262: -- Standard call to get message count and if count is 1, get message info.
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => x_msg_count,
265: p_data => x_msg_data
266: );
310: IS
311: l_api_name CONSTANT VARCHAR2(30) := 'Save_Change';
312: l_api_version_number CONSTANT NUMBER := 1.0;
313: BEGIN
314: -- Standard Start of API savepoint
315: SAVEPOINT Save_Change_PVT;
316:
317: -- Standard call to check for call compatibility.
318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
313: BEGIN
314: -- Standard Start of API savepoint
315: SAVEPOINT Save_Change_PVT;
316:
317: -- Standard call to check for call compatibility.
318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
319: p_api_version_number,
320: l_api_name,
321: G_PKG_NAME)
342: --
343: -- Api body
344: --
345:
346: -- Standard check for p_commit
347: IF FND_API.to_Boolean( p_commit )
348: THEN
349: COMMIT WORK;
350: END IF;
354: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
355:
356:
357:
358: -- Standard call to get message count and if count is 1, get message info.
359: FND_MSG_PUB.Count_And_Get
360: ( p_count => x_msg_count,
361: p_data => x_msg_data
362: );
420: Cursor WrapUp_Camp(p_Camp_id number) IS
421: Select object_type from JTF_IH_WRAP_UPS where object_id = p_Camp_id;
422:
423: BEGIN
424: -- Standard Start of API savepoint
425: SAVEPOINT Save_Change_PVT;
426:
427: -- Standard call to check for call compatibility.
428: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
423: BEGIN
424: -- Standard Start of API savepoint
425: SAVEPOINT Save_Change_PVT;
426:
427: -- Standard call to check for call compatibility.
428: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
429: p_api_version_number,
430: l_api_name,
431: G_PKG_NAME)
501: end if;
502: Close Wrapup_Camp;
503: end if;
504:
505: -- Standard check for p_commit
506: IF FND_API.to_Boolean( p_commit )
507: THEN
508: COMMIT WORK;
509: END IF;
512: -- Debug Message
513: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
514: 'AST', 'Private API: ' || l_api_name || 'end');
515:
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_MSG_PUB.Count_And_Get
518: ( p_count => x_msg_count,
519: p_data => x_msg_data
520: );
564: IS
565: l_api_name CONSTANT VARCHAR2(30) := 'Reset_Change';
566: l_api_version_number CONSTANT NUMBER := 1.0;
567: BEGIN
568: -- Standard Start of API savepoint
569: SAVEPOINT Save_Change_PVT;
570:
571: -- Standard call to check for call compatibility.
572: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
567: BEGIN
568: -- Standard Start of API savepoint
569: SAVEPOINT Save_Change_PVT;
570:
571: -- Standard call to check for call compatibility.
572: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
573: p_api_version_number,
574: l_api_name,
575: G_PKG_NAME)
597: -- Api body
598: --
599: ROLLBACK;
600:
601: -- Standard check for p_commit
602: IF FND_API.to_Boolean( p_commit )
603: THEN
604: COMMIT WORK;
605: END IF;
609: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
610:
611:
612:
613: -- Standard call to get message count and if count is 1, get message info.
614: FND_MSG_PUB.Count_And_Get
615: ( p_count => x_msg_count,
616: p_data => x_msg_data
617: );