40: -- IF PG_DEBUG < 10 THEN
41: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
42: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');
43: END IF;
44: -- Standard Start of API savepoint
45: SAVEPOINT CREATE_strategy_work_items_PVT;
46:
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
43: END IF;
44: -- Standard Start of API savepoint
45: SAVEPOINT CREATE_strategy_work_items_PVT;
46:
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
49: p_api_version_number,
50: l_api_name,
51: G_PKG_NAME)
208: */
209: /* end remove the check of profile, the procedure is doing nothing, ctlee 02/28/2005 */
210:
211:
212: -- Standard check for p_commit
213: IF FND_API.to_Boolean( p_commit )
214: THEN
215: COMMIT WORK;
216: END IF;
214: THEN
215: COMMIT WORK;
216: END IF;
217:
218: -- Standard call to get message count and if count is 1, get message info.
219: FND_MSG_PUB.Count_And_Get
220: ( p_count => x_msg_count,
221: p_data => x_msg_data
222: );
329: -- IF PG_DEBUG < 10 THEN
330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
331: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');
332: END IF;
333: -- Standard Start of API savepoint
334: SAVEPOINT UPDATE_strategy_work_items_PVT;
335:
336: -- Standard call to check for call compatibility.
337: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
332: END IF;
333: -- Standard Start of API savepoint
334: SAVEPOINT UPDATE_strategy_work_items_PVT;
335:
336: -- Standard call to check for call compatibility.
337: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
338: p_api_version_number,
339: l_api_name,
340: G_PKG_NAME)
438: /* end remove the check of profile, the procedure is doing nothing, ctlee 02/28/2005 */
439:
440: --
441:
442: -- Standard check for p_commit
443: IF FND_API.to_Boolean( p_commit )
444: THEN
445: COMMIT WORK;
446: END IF;
485:
486:
487:
488:
489: -- Standard call to get message count and if count is 1, get message info.
490: FND_MSG_PUB.Count_And_Get
491: ( p_count => x_msg_count,
492: p_data => x_msg_data
493: );
544: l_api_name CONSTANT VARCHAR2(30) := 'Delete_strategy_work_items';
545: l_api_version_number CONSTANT NUMBER := 2.0;
546: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
547: BEGIN
548: -- Standard Start of API savepoint
549: SAVEPOINT DELETE_strategy_work_items_PVT;
550:
551: -- Standard call to check for call compatibility.
552: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
547: BEGIN
548: -- Standard Start of API savepoint
549: SAVEPOINT DELETE_strategy_work_items_PVT;
550:
551: -- Standard call to check for call compatibility.
552: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
553: p_api_version_number,
554: l_api_name,
555: G_PKG_NAME)
579: --
580: -- End of API body
581: --
582:
583: -- Standard check for p_commit
584: IF FND_API.to_Boolean( p_commit )
585: THEN
586: COMMIT WORK;
587: END IF;
585: THEN
586: COMMIT WORK;
587: END IF;
588:
589: -- Standard call to get message count and if count is 1, get message info.
590: FND_MSG_PUB.Count_And_Get
591: ( p_count => x_msg_count,
592: p_data => x_msg_data
593: );