[Home] [Help]
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)
221: */
222: /* end remove the check of profile, the procedure is doing nothing, ctlee 02/28/2005 */
223:
224:
225: -- Standard check for p_commit
226: IF FND_API.to_Boolean( p_commit )
227: THEN
228: COMMIT WORK;
229: END IF;
227: THEN
228: COMMIT WORK;
229: END IF;
230:
231: -- Standard call to get message count and if count is 1, get message info.
232: FND_MSG_PUB.Count_And_Get
233: ( p_count => x_msg_count,
234: p_data => x_msg_data
235: );
342: -- IF PG_DEBUG < 10 THEN
343: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
344: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');
345: END IF;
346: -- Standard Start of API savepoint
347: SAVEPOINT UPDATE_strategy_work_items_PVT;
348:
349: -- Standard call to check for call compatibility.
350: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
345: END IF;
346: -- Standard Start of API savepoint
347: SAVEPOINT UPDATE_strategy_work_items_PVT;
348:
349: -- Standard call to check for call compatibility.
350: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
351: p_api_version_number,
352: l_api_name,
353: G_PKG_NAME)
451: /* end remove the check of profile, the procedure is doing nothing, ctlee 02/28/2005 */
452:
453: --
454:
455: -- Standard check for p_commit
456: IF FND_API.to_Boolean( p_commit )
457: THEN
458: COMMIT WORK;
459: END IF;
498:
499:
500:
501:
502: -- Standard call to get message count and if count is 1, get message info.
503: FND_MSG_PUB.Count_And_Get
504: ( p_count => x_msg_count,
505: p_data => x_msg_data
506: );
557: l_api_name CONSTANT VARCHAR2(30) := 'Delete_strategy_work_items';
558: l_api_version_number CONSTANT NUMBER := 2.0;
559: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
560: BEGIN
561: -- Standard Start of API savepoint
562: SAVEPOINT DELETE_strategy_work_items_PVT;
563:
564: -- Standard call to check for call compatibility.
565: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
560: BEGIN
561: -- Standard Start of API savepoint
562: SAVEPOINT DELETE_strategy_work_items_PVT;
563:
564: -- Standard call to check for call compatibility.
565: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
566: p_api_version_number,
567: l_api_name,
568: G_PKG_NAME)
592: --
593: -- End of API body
594: --
595:
596: -- Standard check for p_commit
597: IF FND_API.to_Boolean( p_commit )
598: THEN
599: COMMIT WORK;
600: END IF;
598: THEN
599: COMMIT WORK;
600: END IF;
601:
602: -- Standard call to get message count and if count is 1, get message info.
603: FND_MSG_PUB.Count_And_Get
604: ( p_count => x_msg_count,
605: p_data => x_msg_data
606: );