90: SELECT system_status_code FROM ams_user_statuses_v
91: WHERE user_status_id = id_in;
92:
93: BEGIN
94: -- Standard Start of API savepoint
95: SAVEPOINT Create_Act_Resource_PVT;
96:
97: -- Standard call to check for call compatibility.
98: IF NOT FND_API.Compatible_API_Call ( l_api_version,
93: BEGIN
94: -- Standard Start of API savepoint
95: SAVEPOINT Create_Act_Resource_PVT;
96:
97: -- Standard call to check for call compatibility.
98: IF NOT FND_API.Compatible_API_Call ( l_api_version,
99: p_api_version,
100: l_api_name,
101: G_PACKAGE_NAME)
264: );
265: -- set OUT value
266: x_act_resource_id := l_act_Resource_rec.activity_resource_id;
267:
268: -- Standard check of p_commit.
269: IF FND_API.To_Boolean ( p_commit )
270: THEN
271: COMMIT WORK;
272: END IF;
269: IF FND_API.To_Boolean ( p_commit )
270: THEN
271: COMMIT WORK;
272: END IF;
273: -- Standard call to get message count AND IF count is 1, get message info.
274: FND_MSG_PUB.Count_AND_Get
275: ( p_count => x_msg_count,
276: p_data => x_msg_data,
277: p_encoded => FND_API.G_FALSE
353: SELECT system_status_code FROM ams_user_statuses_v
354: WHERE user_status_id = id_in;
355:
356: BEGIN
357: -- Standard Start of API savepoint
358: SAVEPOINT Update_Act_Resource_PVT;
359: -- Standard call to check for call compatibility.
360: IF NOT FND_API.Compatible_API_Call ( l_api_version,
361: p_api_version,
355:
356: BEGIN
357: -- Standard Start of API savepoint
358: SAVEPOINT Update_Act_Resource_PVT;
359: -- Standard call to check for call compatibility.
360: IF NOT FND_API.Compatible_API_Call ( l_api_version,
361: p_api_version,
362: l_api_name,
363: G_PACKAGE_NAME)
508: END IF;
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: -- Standard check of p_commit.
513: IF FND_API.To_Boolean ( p_commit )
514: THEN
515: COMMIT WORK;
516: END IF;
513: IF FND_API.To_Boolean ( p_commit )
514: THEN
515: COMMIT WORK;
516: END IF;
517: -- Standard call to get message count AND IF count is 1, get message info.
518: FND_MSG_PUB.Count_AND_Get
519: ( p_count => x_msg_count,
520: p_data => x_msg_data,
521: p_encoded => FND_API.G_FALSE
588: l_role_relate_id NUMBER;
589:
590:
591: BEGIN
592: -- Standard Start of API savepoint
593: SAVEPOINT Delete_Act_Resource_PVT;
594:
595: -- Standard call to check for call compatibility.
596: IF NOT FND_API.Compatible_API_Call ( l_api_version,
591: BEGIN
592: -- Standard Start of API savepoint
593: SAVEPOINT Delete_Act_Resource_PVT;
594:
595: -- Standard call to check for call compatibility.
596: IF NOT FND_API.Compatible_API_Call ( l_api_version,
597: p_api_version,
598: l_api_name,
599: G_PACKAGE_NAME)
624: RAISE FND_API.g_exc_error;
625: END IF;
626:
627:
628: -- Standard check of p_commit.
629: IF FND_API.To_Boolean ( p_commit )
630: THEN
631: COMMIT WORK;
632: END IF;
630: THEN
631: COMMIT WORK;
632: END IF;
633:
634: -- Standard call to get message count AND IF count is 1, get message info.
635: FND_MSG_PUB.Count_AND_Get
636: ( p_count => x_msg_count,
637: p_data => x_msg_data,
638: p_encoded => FND_API.G_FALSE
708: AND object_version_number = p_object_version
709: FOR UPDATE of activity_resource_id NOWAIT;
710:
711: BEGIN
712: -- Standard call to check for call compatibility.
713: IF NOT FND_API.Compatible_API_Call ( l_api_version,
714: p_api_version,
715: l_api_name,
716: G_PACKAGE_NAME)
745: CLOSE c_act_resource;
746: --
747: -- END of API body.
748: --
749: -- Standard call to get message count AND IF count is 1, get message info.
750: FND_MSG_PUB.Count_AND_Get
751: ( p_count => x_msg_count,
752: p_data => x_msg_data,
753: p_encoded => FND_API.G_FALSE
826: l_act_resource_id NUMBER;
827:
828:
829: BEGIN
830: -- Standard call to check for call compatibility.
831: IF NOT FND_API.Compatible_API_Call ( l_api_version,
832: p_api_version,
833: l_api_name,
834: G_PACKAGE_NAME)
1671: l_return_status VARCHAR2(1);
1672: l_count NUMBER := 0;
1673:
1674: BEGIN
1675: -- Standard call to check for call compatibility.
1676: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1677: l_api_version,
1678: l_api_name,
1679: G_PACKAGE_NAME)