63: AND application_id = l_c_application_id;
64:
65: BEGIN
66:
67: -- Standard Start of API savepoint
68: SAVEPOINT Associate_Resps_To_Msite_Pvt;
69:
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call(l_api_version,
66:
67: -- Standard Start of API savepoint
68: SAVEPOINT Associate_Resps_To_Msite_Pvt;
69:
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call(l_api_version,
72: p_api_version,
73: l_api_name,
74: G_PKG_NAME)
143:
144: --
145: -- End of main API body.
146:
147: -- Standard check of p_commit.
148: IF (FND_API.To_Boolean(p_commit)) THEN
149: COMMIT WORK;
150: END IF;
151:
148: IF (FND_API.To_Boolean(p_commit)) THEN
149: COMMIT WORK;
150: END IF;
151:
152: -- Standard call to get message count and if count is 1, get message info.
153: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
154: p_data => x_msg_data,
155: p_encoded => 'F');
156:
215: l_api_version CONSTANT NUMBER := 1.0;
216:
217: BEGIN
218:
219: -- Standard Start of API savepoint
220: SAVEPOINT Update_Delete_Msite_Resps_Pvt;
221:
222: -- Standard call to check for call compatibility.
223: IF NOT FND_API.Compatible_API_Call(l_api_version,
218:
219: -- Standard Start of API savepoint
220: SAVEPOINT Update_Delete_Msite_Resps_Pvt;
221:
222: -- Standard call to check for call compatibility.
223: IF NOT FND_API.Compatible_API_Call(l_api_version,
224: p_api_version,
225: l_api_name,
226: G_PKG_NAME)
307:
308: --
309: -- End of main API body.
310:
311: -- Standard check of p_commit.
312: IF (FND_API.To_Boolean(p_commit)) THEN
313: COMMIT WORK;
314: END IF;
315:
312: IF (FND_API.To_Boolean(p_commit)) THEN
313: COMMIT WORK;
314: END IF;
315:
316: -- Standard call to get message count and if count is 1, get message info.
317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
318: p_data => x_msg_data,
319: p_encoded => 'F');
320:
485: l_application_id_sql_str VARCHAR2(30);
486:
487: BEGIN
488:
489: -- Standard call to check for call compatibility.
490: IF NOT FND_API.Compatible_API_Call(l_api_version,
491: p_api_version,
492: l_api_name,
493: G_PKG_NAME)
580:
581: --
582: -- End of main API body.
583:
584: -- Standard check of p_commit.
585: IF (FND_API.To_Boolean(p_commit)) THEN
586: COMMIT WORK;
587: END IF;
588:
585: IF (FND_API.To_Boolean(p_commit)) 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(p_count => x_msg_count,
591: p_data => x_msg_data,
592: p_encoded => 'F');
593:
650: l_tmp_str VARCHAR2(2000);
651:
652: BEGIN
653:
654: -- Standard call to check for call compatibility.
655: IF NOT FND_API.Compatible_API_Call(l_api_version,
656: p_api_version,
657: l_api_name,
658: G_PKG_NAME)
714:
715: --
716: -- End of main API body.
717:
718: -- Standard check of p_commit.
719: IF (FND_API.To_Boolean(p_commit)) THEN
720: COMMIT WORK;
721: END IF;
722:
719: IF (FND_API.To_Boolean(p_commit)) THEN
720: COMMIT WORK;
721: END IF;
722:
723: -- Standard call to get message count and if count is 1, get message info.
724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
725: p_data => x_msg_data,
726: p_encoded => 'F');
727: