75: AND application_id = l_c_application_id;
76:
77: BEGIN
78:
79: -- Standard Start of API savepoint
80: SAVEPOINT Associate_Resps_To_Msite_Pvt;
81:
82: -- Standard call to check for call compatibility.
83: IF NOT FND_API.Compatible_API_Call(l_api_version,
78:
79: -- Standard Start of API savepoint
80: SAVEPOINT Associate_Resps_To_Msite_Pvt;
81:
82: -- Standard call to check for call compatibility.
83: IF NOT FND_API.Compatible_API_Call(l_api_version,
84: p_api_version,
85: l_api_name,
86: G_PKG_NAME)
156:
157: --
158: -- End of main API body.
159:
160: -- Standard check of p_commit.
161: IF (FND_API.To_Boolean(p_commit)) THEN
162: COMMIT WORK;
163: END IF;
164:
161: IF (FND_API.To_Boolean(p_commit)) THEN
162: COMMIT WORK;
163: END IF;
164:
165: -- Standard call to get message count and if count is 1, get message info.
166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
167: p_data => x_msg_data,
168: p_encoded => 'F');
169:
228: l_api_version CONSTANT NUMBER := 1.0;
229:
230: BEGIN
231:
232: -- Standard Start of API savepoint
233: SAVEPOINT Update_Delete_Msite_Resps_Pvt;
234:
235: -- Standard call to check for call compatibility.
236: IF NOT FND_API.Compatible_API_Call(l_api_version,
231:
232: -- Standard Start of API savepoint
233: SAVEPOINT Update_Delete_Msite_Resps_Pvt;
234:
235: -- Standard call to check for call compatibility.
236: IF NOT FND_API.Compatible_API_Call(l_api_version,
237: p_api_version,
238: l_api_name,
239: G_PKG_NAME)
321:
322: --
323: -- End of main API body.
324:
325: -- Standard check of p_commit.
326: IF (FND_API.To_Boolean(p_commit)) THEN
327: COMMIT WORK;
328: END IF;
329:
326: IF (FND_API.To_Boolean(p_commit)) THEN
327: COMMIT WORK;
328: END IF;
329:
330: -- Standard call to get message count and if count is 1, get message info.
331: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
332: p_data => x_msg_data,
333: p_encoded => 'F');
334:
402: BEGIN
403:
404: l_msite_resp_ids := JTF_NUMBER_TABLE();
405:
406: -- Standard Start of API savepoint
407: SAVEPOINT Update_Delete_Msite_Resps_Pvt;
408:
409: -- Standard call to check for call compatibility.
410: IF NOT FND_API.Compatible_API_Call(l_api_version,
405:
406: -- Standard Start of API savepoint
407: SAVEPOINT Update_Delete_Msite_Resps_Pvt;
408:
409: -- Standard call to check for call compatibility.
410: IF NOT FND_API.Compatible_API_Call(l_api_version,
411: p_api_version,
412: l_api_name,
413: G_PKG_NAME)
566:
567: --
568: -- End of main API body.
569:
570: -- Standard check of p_commit.
571: IF (FND_API.To_Boolean(p_commit)) THEN
572: COMMIT WORK;
573: END IF;
574:
571: IF (FND_API.To_Boolean(p_commit)) THEN
572: COMMIT WORK;
573: END IF;
574:
575: -- Standard call to get message count and if count is 1, get message info.
576: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
577: p_data => x_msg_data,
578: p_encoded => 'F');
579:
731:
732:
733: BEGIN
734:
735: -- Standard Start of API savepoint
736: SAVEPOINT Update_Msite_Resps_Pvt;
737:
738: -- Standard call to check for call compatibility.
739: IF NOT FND_API.Compatible_API_Call(l_api_version,
734:
735: -- Standard Start of API savepoint
736: SAVEPOINT Update_Msite_Resps_Pvt;
737:
738: -- Standard call to check for call compatibility.
739: IF NOT FND_API.Compatible_API_Call(l_api_version,
740: p_api_version,
741: l_api_name,
742: G_PKG_NAME)
796:
797: --
798: -- End of main API body.
799:
800: -- Standard check of p_commit.
801: IF (FND_API.To_Boolean(p_commit)) THEN
802: COMMIT WORK;
803: END IF;
804:
801: IF (FND_API.To_Boolean(p_commit)) THEN
802: COMMIT WORK;
803: END IF;
804:
805: -- Standard call to get message count and if count is 1, get message info.
806: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
807: p_data => x_msg_data,
808: p_encoded => 'F');
809: