60: FROM cn_credit_conv_fcts
61: WHERE from_credit_type_id = p_from_credit_type
62: AND to_credit_type_id = p_to_credit_type;
63: BEGIN
64: -- Standard Start of API savepoint
65: SAVEPOINT create_conversion_pvt;
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.Compatible_API_Call
68: (l_api_version ,
62: AND to_credit_type_id = p_to_credit_type;
63: BEGIN
64: -- Standard Start of API savepoint
65: SAVEPOINT create_conversion_pvt;
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.Compatible_API_Call
68: (l_api_version ,
69: p_api_version ,
70: l_api_name ,
123: x_last_update_date => g_last_update_date,
124: x_last_updated_by => g_last_updated_by);
125:
126: -- End of API body.
127: -- Standard check of p_commit.
128: IF FND_API.To_Boolean( p_commit ) THEN
129: COMMIT WORK;
130: END IF;
131: -- Standard call to get message count and if count is 1, get message info.
127: -- Standard check of p_commit.
128: IF FND_API.To_Boolean( p_commit ) THEN
129: COMMIT WORK;
130: END IF;
131: -- Standard call to get message count and if count is 1, get message info.
132: FND_MSG_PUB.Count_And_Get
133: (p_count => x_msg_count ,
134: p_data => x_msg_data ,
135: p_encoded => FND_API.G_FALSE );
241: WHERE from_credit_type_id = p_from_credit_type
242: AND to_credit_type_id = p_to_credit_type
243: AND credit_conv_fct_id <> p_conv_id;
244: BEGIN
245: -- Standard Start of API savepoint
246: SAVEPOINT update_conversion_pvt;
247: -- Standard call to check for call compatibility.
248: IF NOT FND_API.Compatible_API_Call
249: (l_api_version ,
243: AND credit_conv_fct_id <> p_conv_id;
244: BEGIN
245: -- Standard Start of API savepoint
246: SAVEPOINT update_conversion_pvt;
247: -- Standard call to check for call compatibility.
248: IF NOT FND_API.Compatible_API_Call
249: (l_api_version ,
250: p_api_version ,
251: l_api_name ,
310: x_last_update_login => g_last_update_login,
311: x_last_update_date => g_last_update_date,
312: x_last_updated_by => g_last_updated_by);
313: -- End of API body.
314: -- Standard check of p_commit.
315: IF FND_API.To_Boolean( p_commit ) THEN
316: COMMIT WORK;
317: END IF;
318: -- Standard call to get message count and if count is 1, get message info.
314: -- Standard check of p_commit.
315: IF FND_API.To_Boolean( p_commit ) THEN
316: COMMIT WORK;
317: END IF;
318: -- Standard call to get message count and if count is 1, get message info.
319: FND_MSG_PUB.Count_And_Get
320: (p_count => x_msg_count ,
321: p_data => x_msg_data ,
322: p_encoded => FND_API.G_FALSE );
409: SELECT object_version_number
410: FROM cn_credit_conv_fcts
411: WHERE credit_conv_fct_id = p_conv_id;
412: BEGIN
413: -- Standard Start of API savepoint
414: SAVEPOINT delete_conversion_pvt;
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call
417: (l_api_version ,
411: WHERE credit_conv_fct_id = p_conv_id;
412: BEGIN
413: -- Standard Start of API savepoint
414: SAVEPOINT delete_conversion_pvt;
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call
417: (l_api_version ,
418: p_api_version ,
419: l_api_name ,
440:
441: CN_CREDIT_CONV_FCTS_PKG.Delete_Row(x_credit_conv_fct_id => p_conv_id);
442:
443: -- End of API body.
444: -- Standard check of p_commit.
445: IF FND_API.To_Boolean( p_commit ) THEN
446: COMMIT WORK;
447: END IF;
448: -- Standard call to get message count and if count is 1, get message info.
444: -- Standard check of p_commit.
445: IF FND_API.To_Boolean( p_commit ) THEN
446: COMMIT WORK;
447: END IF;
448: -- Standard call to get message count and if count is 1, get message info.
449: FND_MSG_PUB.Count_And_Get
450: (p_count => x_msg_count ,
451: p_data => x_msg_data ,
452: p_encoded => FND_API.G_FALSE );