DBA Data[Home] [Help]

APPS.AMS_ACTCATEGORY_PVT dependencies on STANDARD

Line 62: -- Standard Start of API savepoint

58: FROM dual;
59:
60: BEGIN
61:
62: -- Standard Start of API savepoint
63: SAVEPOINT Create_Act_Category_PVT;
64:
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

61:
62: -- Standard Start of API savepoint
63: SAVEPOINT Create_Act_Category_PVT;
64:
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call ( l_api_version,
67: p_api_version,
68: l_api_name,
69: G_PACKAGE_NAME)

Line 119: -- standard who columns

115:
116: INSERT INTO AMS_ACT_CATEGORIES
117: (activity_category_id,
118:
119: -- standard who columns
120: last_update_date,
121: last_updated_by,
122: creation_date,
123: created_by,

Line 154: -- standard who columns

150: VALUES
151: (
152: l_act_category_rec.activity_category_id,
153:
154: -- standard who columns
155: sysdate,
156: FND_GLOBAL.User_Id,
157: sysdate,
158: FND_GLOBAL.User_Id,

Line 192: -- Standard check of p_commit.

188: --
189: -- END of API body.
190: --
191:
192: -- Standard check of p_commit.
193: IF FND_API.To_Boolean ( p_commit )
194: THEN
195: COMMIT WORK;
196: END IF;

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

194: THEN
195: COMMIT WORK;
196: END IF;
197:
198: -- Standard call to get message count AND IF count is 1, get message info.
199: FND_MSG_PUB.Count_AND_Get
200: ( p_count => x_msg_count,
201: p_data => x_msg_data,
202: p_encoded => FND_API.G_FALSE

Line 282: -- Standard Start of API savepoint

278: l_act_category_rec act_category_rec_type;
279:
280: BEGIN
281:
282: -- Standard Start of API savepoint
283: SAVEPOINT Update_Act_Category_PVT;
284:
285: -- Standard call to check for call compatibility.
286: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

281:
282: -- Standard Start of API savepoint
283: SAVEPOINT Update_Act_Category_PVT;
284:
285: -- Standard call to check for call compatibility.
286: IF NOT FND_API.Compatible_API_Call ( l_api_version,
287: p_api_version,
288: l_api_name,
289: G_PACKAGE_NAME)

Line 378: -- Standard check of p_commit.

374: --
375: -- END of API body.
376: --
377:
378: -- Standard check of p_commit.
379: IF FND_API.To_Boolean ( p_commit )
380: THEN
381: COMMIT WORK;
382: END IF;

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

380: THEN
381: COMMIT WORK;
382: END IF;
383:
384: -- Standard call to get message count AND IF count is 1, get message info.
385: FND_MSG_PUB.Count_AND_Get
386: ( p_count => x_msg_count,
387: p_data => x_msg_data,
388: p_encoded => FND_API.G_FALSE

Line 469: -- Standard Start of API savepoint

465: l_return_status VARCHAR2(1); -- Return value from procedures
466: l_act_category_id NUMBER := p_act_category_id;
467: BEGIN
468:
469: -- Standard Start of API savepoint
470: SAVEPOINT Delete_Act_Category_PVT;
471:
472: -- Standard call to check for call compatibility.
473: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

468:
469: -- Standard Start of API savepoint
470: SAVEPOINT Delete_Act_Category_PVT;
471:
472: -- Standard call to check for call compatibility.
473: IF NOT FND_API.Compatible_API_Call ( l_api_version,
474: p_api_version,
475: l_api_name,
476: G_PACKAGE_NAME)

Line 518: -- Standard check of p_commit.

514: --
515: -- END of API body.
516: --
517:
518: -- Standard check of p_commit.
519: IF FND_API.To_Boolean ( p_commit )
520: THEN
521: COMMIT WORK;
522: END IF;

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

520: THEN
521: COMMIT WORK;
522: END IF;
523:
524: -- Standard call to get message count AND IF count is 1, get message info.
525: FND_MSG_PUB.Count_AND_Get
526: ( p_count => x_msg_count,
527: p_data => x_msg_data,
528: p_encoded => FND_API.G_FALSE

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

612: FOR UPDATE of activity_category_id NOWAIT;
613:
614: BEGIN
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version,
618: p_api_version,
619: l_api_name,
620: G_PACKAGE_NAME)

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

657: --
658: -- END of API body.
659: --
660:
661: -- Standard call to get message count AND IF count is 1, get message info.
662: FND_MSG_PUB.Count_AND_Get
663: ( p_count => x_msg_count,
664: p_data => x_msg_data,
665: p_encoded => FND_API.G_FALSE

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

764:
765:
766: BEGIN
767:
768: -- Standard call to check for call compatibility.
769: IF NOT FND_API.Compatible_API_Call ( l_api_version,
770: p_api_version,
771: l_api_name,
772: G_PACKAGE_NAME)

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

1178: -- Status Local Variables
1179: l_return_status VARCHAR2(1); -- Return value from procedures
1180: BEGIN
1181:
1182: -- Standard call to check for call compatibility.
1183: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1184: l_api_version,
1185: l_api_name,
1186: G_PACKAGE_NAME)