61: l_cursorID INTEGER;
62: l_dummy INTEGER;
63: BEGIN
64: SAVEPOINT search_message_pvt;
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
67: p_api_version_number,
68: l_api_name,
69: G_PKG_NAME)
299: END LOOP;
300:
301: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
302:
303: -- Standard Check Of p_commit.
304: IF FND_API.To_Boolean(p_commit) THEN
305: COMMIT WORK;
306: END IF;
307: -- Standard callto get message count and if count is 1, get message info.
303: -- Standard Check Of p_commit.
304: IF FND_API.To_Boolean(p_commit) THEN
305: COMMIT WORK;
306: END IF;
307: -- Standard callto get message count and if count is 1, get message info.
308: FND_MSG_PUB.Count_And_Get
309: ( p_count => x_msg_count,
310: p_data => x_msg_data
311: );
393: l_dummy INTEGER;
394: BEGIN
395:
396: SAVEPOINT get_total_count_pvt;
397: -- Standard call to check for call compatibility.
398: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
399: p_api_version_number,
400: l_api_name,
401: G_PKG_NAME)
506: END IF;
507:
508:
509: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
510: -- Standard Check Of p_commit.
511: IF FND_API.To_Boolean(p_commit) THEN
512: COMMIT WORK;
513: END IF;
514: -- Standard callto get message count and if count is 1, get message info.
510: -- Standard Check Of p_commit.
511: IF FND_API.To_Boolean(p_commit) THEN
512: COMMIT WORK;
513: END IF;
514: -- Standard callto get message count and if count is 1, get message info.
515: FND_MSG_PUB.Count_And_Get
516: ( p_count => x_msg_count,
517: p_data => x_msg_data
518: );
585:
586: BEGIN
587:
588: SAVEPOINT show_agent_list_pvt;
589: -- Standard call to check for call compatibility.
590: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
591: p_api_version_number,
592: l_api_name,
593: G_PKG_NAME)
799: end if; -- if p_sort_column=2
800:
801: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
802:
803: -- Standard Check Of p_commit.
804: IF FND_API.To_Boolean(p_commit) THEN
805: COMMIT WORK;
806: END IF;
807: -- Standard callto get message count and if count is 1, get message info.
803: -- Standard Check Of p_commit.
804: IF FND_API.To_Boolean(p_commit) THEN
805: COMMIT WORK;
806: END IF;
807: -- Standard callto get message count and if count is 1, get message info.
808: FND_MSG_PUB.Count_And_Get
809: ( p_count => x_msg_count,
810: p_data => x_msg_data
811: );
875: l_dummy INTEGER;
876:
877: BEGIN
878: SAVEPOINT show_resource_group_list_pvt;
879: -- Standard call to check for call compatibility.
880: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
881: p_api_version_number,
882: l_api_name,
883: G_PKG_NAME)
1073:
1074: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1075:
1076:
1077: -- Standard Check Of p_commit.
1078: IF FND_API.To_Boolean(p_commit) THEN
1079: COMMIT WORK;
1080: END IF;
1081: -- Standard callto get message count and if count is 1, get message info.
1077: -- Standard Check Of p_commit.
1078: IF FND_API.To_Boolean(p_commit) THEN
1079: COMMIT WORK;
1080: END IF;
1081: -- Standard callto get message count and if count is 1, get message info.
1082: FND_MSG_PUB.Count_And_Get
1083: ( p_count => x_msg_count,
1084: p_data => x_msg_data
1085: );