139: l_api_name CONSTANT VARCHAR2(30) := 'Create_rs_cust_relation';
140: l_api_version_number CONSTANT NUMBER := 2.0;
141: l_pvt_RCR_rec CSP_RS_CUST_RELATION_PVT.RCR_Rec_Type;
142: BEGIN
143: -- Standard Start of API savepoint
144: SAVEPOINT CREATE_RS_CUST_RELATION_PUB;
145:
146: -- Standard call to check for call compatibility.
147: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
142: BEGIN
143: -- Standard Start of API savepoint
144: SAVEPOINT CREATE_RS_CUST_RELATION_PUB;
145:
146: -- Standard call to check for call compatibility.
147: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
148: p_api_version_number,
149: l_api_name,
150: G_PKG_NAME)
208: --
209: -- End of API body.
210: --
211:
212: -- Standard check for p_commit
213: IF FND_API.to_Boolean( p_commit )
214: THEN
215: COMMIT WORK;
216: END IF;
220: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
221:
222: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
223:
224: -- Standard call to get message count and if count is 1, get message info.
225: FND_MSG_PUB.Count_And_Get
226: ( p_count => x_msg_count,
227: p_data => x_msg_data
228: );
278: l_api_name CONSTANT VARCHAR2(30) := 'Update_rs_cust_relation';
279: l_api_version_number CONSTANT NUMBER := 2.0;
280: l_pvt_RCR_rec CSP_RS_CUST_RELATION_PVT.RCR_Rec_Type;
281: BEGIN
282: -- Standard Start of API savepoint
283: SAVEPOINT UPDATE_RS_CUST_RELATION_PUB;
284:
285: -- Standard call to check for call compatibility.
286: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
281: BEGIN
282: -- Standard Start of API savepoint
283: SAVEPOINT UPDATE_RS_CUST_RELATION_PUB;
284:
285: -- Standard call to check for call compatibility.
286: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
287: p_api_version_number,
288: l_api_name,
289: G_PKG_NAME)
344: --
345: -- End of API body
346: --
347:
348: -- Standard check for p_commit
349: IF FND_API.to_Boolean( p_commit )
350: THEN
351: COMMIT WORK;
352: END IF;
356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
357:
358: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
359:
360: -- Standard call to get message count and if count is 1, get message info.
361: FND_MSG_PUB.Count_And_Get
362: ( p_count => x_msg_count,
363: p_data => x_msg_data
364: );
415: l_api_name CONSTANT VARCHAR2(30) := 'Delete_rs_cust_relation';
416: l_api_version_number CONSTANT NUMBER := 2.0;
417: l_pvt_RCR_rec CSP_RS_CUST_RELATION_PVT.RCR_Rec_Type;
418: BEGIN
419: -- Standard Start of API savepoint
420: SAVEPOINT DELETE_RS_CUST_RELATION_PUB;
421:
422: -- Standard call to check for call compatibility.
423: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
418: BEGIN
419: -- Standard Start of API savepoint
420: SAVEPOINT DELETE_RS_CUST_RELATION_PUB;
421:
422: -- Standard call to check for call compatibility.
423: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
424: p_api_version_number,
425: l_api_name,
426: G_PKG_NAME)
480: --
481: -- End of API body
482: --
483:
484: -- Standard check for p_commit
485: IF FND_API.to_Boolean( p_commit )
486: THEN
487: COMMIT WORK;
488: END IF;
492: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
493:
494: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
495:
496: -- Standard call to get message count and if count is 1, get message info.
497: FND_MSG_PUB.Count_And_Get
498: ( p_count => x_msg_count,
499: p_data => x_msg_data
500: );
560: IS
561: l_api_name CONSTANT VARCHAR2(30) := 'Get_rs_cust_relation';
562: l_api_version_number CONSTANT NUMBER := 2.0;
563: BEGIN
564: -- Standard Start of API savepoint
565: SAVEPOINT GET_RS_CUST_RELATION_PUB;
566:
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
563: BEGIN
564: -- Standard Start of API savepoint
565: SAVEPOINT GET_RS_CUST_RELATION_PUB;
566:
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
569: p_api_version_number,
570: l_api_name,
571: G_PKG_NAME)
634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
635:
636: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
637:
638: -- Standard call to get message count and if count is 1, get message info.
639: FND_MSG_PUB.Count_And_Get
640: ( p_count => x_msg_count,
641: p_data => x_msg_data
642: );