APPS.CCT_MEDIA_QUEUE_PUB dependencies on STANDARD

Line 24: -- Standard Start of API savepoint

20: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_DEQUEUE_COUNT';
21: l_api_version CONSTANT NUMBER := 1.0;
22:
23: BEGIN
24: -- Standard Start of API savepoint
25: SAVEPOINT UPDATE_DEQUEUE_COUNT_PUB;
26: -- Standard call to check for call compatibility.
27: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
28: p_api_version ,

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

22:
23: BEGIN
24: -- Standard Start of API savepoint
25: SAVEPOINT UPDATE_DEQUEUE_COUNT_PUB;
26: -- Standard call to check for call compatibility.
27: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
28: p_api_version ,
29: l_api_name ,
30: G_PKG_NAME )

Line 52: -- Standard check of p_commit.

48: END IF;
49:
50:
51: -- End of API body.
52: -- Standard check of p_commit.
53: IF FND_API.To_Boolean( p_commit ) THEN
54: COMMIT WORK;
55: END IF;
56: -- Standard call to get message count and if count is 1, get message info.

Line 56: -- Standard call to get message count and if count is 1, get message info.

52: -- Standard check of p_commit.
53: IF FND_API.To_Boolean( p_commit ) THEN
54: COMMIT WORK;
55: END IF;
56: -- Standard call to get message count and if count is 1, get message info.
57: FND_MSG_PUB.Count_And_Get
58: ( p_count => x_msg_count ,
59: p_data => x_msg_data
60: );

Line 141: -- Standard Start of API savepoint

137: l_dequeue_count_all_types NUMBER := 0;
138: l_media_type NUMBER := -1;
139:
140: BEGIN
141: -- Standard Start of API savepoint
142: SAVEPOINT GET_MEDIA_QUEUE_DETAILS_PUB;
143: -- Standard call to check for call compatibility.
144: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
145: p_api_version ,

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

139:
140: BEGIN
141: -- Standard Start of API savepoint
142: SAVEPOINT GET_MEDIA_QUEUE_DETAILS_PUB;
143: -- Standard call to check for call compatibility.
144: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
145: p_api_version ,
146: l_api_name ,
147: G_PKG_NAME )

Line 259: -- Standard check of p_commit.

255: END IF;
256:
257:
258: -- End of API body.
259: -- Standard check of p_commit.
260: IF FND_API.To_Boolean( p_commit ) THEN
261: COMMIT WORK;
262: END IF;
263: -- Standard call to get message count and if count is 1, get message info.

Line 263: -- Standard call to get message count and if count is 1, get message info.

259: -- Standard check of p_commit.
260: IF FND_API.To_Boolean( p_commit ) THEN
261: COMMIT WORK;
262: END IF;
263: -- Standard call to get message count and if count is 1, get message info.
264: FND_MSG_PUB.Count_And_Get
265: ( p_count => x_msg_count ,
266: p_data => x_msg_data
267: );