[Home] [Help]
51: AND enabled_flag = 'Y';
52:
53:
54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_TIMEFRAME_PVT;
57:
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_TIMEFRAME_PVT;
57:
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
60: p_api_version_number,
61: l_api_name,
62: G_PKG_NAME)
179: --
180: -- End of API body
181: --
182:
183: -- Standard check for p_commit
184: IF FND_API.to_Boolean( p_commit )
185: THEN
186: COMMIT WORK;
187: END IF;
193: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
194: END IF;
195:
196:
197: -- Standard call to get message count and if count is 1, get message info.
198: FND_MSG_PUB.Count_And_Get
199: ( p_count => x_msg_count,
200: p_data => x_msg_data
201: );
279: and timeframe_id <> p_timeframe_rec.timeframe_id
280: AND enabled_flag = 'Y';
281:
282: BEGIN
283: -- Standard Start of API savepoint
284: SAVEPOINT UPDATE_TIMEFRAME_PVT;
285:
286: -- Standard call to check for call compatibility.
287: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
282: BEGIN
283: -- Standard Start of API savepoint
284: SAVEPOINT UPDATE_TIMEFRAME_PVT;
285:
286: -- Standard call to check for call compatibility.
287: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
288: p_api_version_number,
289: l_api_name,
290: G_PKG_NAME)
444: --
445: -- End of API body.
446: --
447:
448: -- Standard check for p_commit
449: IF FND_API.to_Boolean( p_commit )
450: THEN
451: COMMIT WORK;
452: END IF;
458: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
459: END IF;
460:
461:
462: -- Standard call to get message count and if count is 1, get message info.
463: FND_MSG_PUB.Count_And_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data
466: );
522: l_api_name CONSTANT VARCHAR2(30) := 'Delete_timeframe';
523: l_api_version_number CONSTANT NUMBER := 2.0;
524: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
525: BEGIN
526: -- Standard Start of API savepoint
527: SAVEPOINT DELETE_TIMEFRAME_PVT;
528:
529: -- Standard call to check for call compatibility.
530: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
525: BEGIN
526: -- Standard Start of API savepoint
527: SAVEPOINT DELETE_TIMEFRAME_PVT;
528:
529: -- Standard call to check for call compatibility.
530: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
531: p_api_version_number,
532: l_api_name,
533: G_PKG_NAME)
591: --
592: -- End of API body
593: --
594:
595: -- Standard check for p_commit
596: IF FND_API.to_Boolean( p_commit )
597: THEN
598: COMMIT WORK;
599: END IF;
605: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
606: END IF;
607:
608:
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get
611: ( p_count => x_msg_count,
612: p_data => x_msg_data
613: );
685: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
686: NULL;
687: END IF;
688:
689: -- Standard call to get message count and if count is 1, get message info.
690: FND_MSG_PUB.Count_And_Get
691: ( p_count => x_msg_count,
692: p_data => x_msg_data
693: );
750:
751:
752:
753:
754: -- Standard call to get message count and if count is 1, get message info.
755: FND_MSG_PUB.Count_And_Get
756: ( p_count => x_msg_count,
757: p_data => x_msg_data
758: );
795:
796: x_return_status := FND_API.G_RET_STS_ERROR;
797: END IF;
798:
799: -- Standard call to get message count and if count is 1, get message info.
800: FND_MSG_PUB.Count_And_Get
801: ( p_count => x_msg_count,
802: p_data => x_msg_data
803: );