DBA Data[Home] [Help]

APPS.AMS_ACTRESOURCE_PVT dependencies on STANDARD

Line 94: -- Standard Start of API savepoint

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,

Line 97: -- Standard call to check for call compatibility.

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)

Line 268: -- Standard check of p_commit.

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;

Line 273: -- Standard call to get message count AND IF count is 1, get message info.

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

Line 357: -- Standard Start of API savepoint

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,

Line 359: -- Standard call to check for call compatibility.

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)

Line 512: -- Standard check of p_commit.

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;

Line 517: -- Standard call to get message count AND IF count is 1, get message info.

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

Line 592: -- Standard Start of API savepoint

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,

Line 595: -- Standard call to check for call compatibility.

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)

Line 628: -- Standard check of p_commit.

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;

Line 634: -- Standard call to get message count AND IF count is 1, get message info.

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

Line 712: -- Standard call to check for call compatibility.

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)

Line 749: -- Standard call to get message count AND IF count is 1, get message info.

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

Line 830: -- Standard call to check for call compatibility.

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)

Line 1675: -- Standard call to check for call compatibility.

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)