DBA Data[Home] [Help]

APPS.WMS_CYCLE_PVT dependencies on STANDARD

Line 20: --with GSCC File.Sql.39 standard Bug:4410902

16: -- dbms_output.put_line(p_err_msg);
17: END print_debug;
18:
19: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data to comply
20: --with GSCC File.Sql.39 standard Bug:4410902
21: PROCEDURE Create_Unscheduled_Counts
22: ( p_api_version IN NUMBER ,
23: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
24: p_commit IN VARCHAR2 := fnd_api.g_false ,

Line 49: -- Standard Start of API savepoint

45: l_zero_count_flag NUMBER ; --Bug 5236299
46:
47: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
48: BEGIN
49: -- Standard Start of API savepoint
50: SAVEPOINT Create_Unscheduled_Counts_PVT;
51: -- Standard call to check for call compatibility.
52: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
53: p_api_version ,

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

47: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
48: BEGIN
49: -- Standard Start of API savepoint
50: SAVEPOINT Create_Unscheduled_Counts_PVT;
51: -- Standard call to check for call compatibility.
52: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
53: p_api_version ,
54: l_api_name ,
55: G_PKG_NAME )

Line 235: -- Standard check of p_commit.

231: COMMIT;
232: END IF;
233:
234: -- End of API body
235: -- Standard check of p_commit.
236: IF FND_API.To_Boolean( p_commit ) THEN
237: COMMIT WORK;
238: END IF;
239: -- Standard call to get message count and if count is 1,

Line 239: -- Standard call to get message count and if count is 1,

235: -- Standard check of p_commit.
236: IF FND_API.To_Boolean( p_commit ) THEN
237: COMMIT WORK;
238: END IF;
239: -- Standard call to get message count and if count is 1,
240: -- get message info.
241: FND_MSG_PUB.Count_And_Get
242: ( p_count => x_msg_count,
243: p_data => x_msg_data