DBA Data[Home] [Help]

APPS.CSP_PACK_SERIAL_LOTS_PUB dependencies on STANDARD

Line 128: -- Standard Start of API savepoint

124: l_api_name CONSTANT VARCHAR2(30) := 'Create_pack_serial_lots';
125: l_api_version_number CONSTANT NUMBER := 2.0;
126: l_pvt_plsl_rec CSP_Pack_Serial_Lots_PVT.plsl_Rec_Type;
127: BEGIN
128: -- Standard Start of API savepoint
129: SAVEPOINT CREATE_Pack_Serial_Lots_PUB;
130:
131: -- Standard call to check for call compatibility.
132: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

127: BEGIN
128: -- Standard Start of API savepoint
129: SAVEPOINT CREATE_Pack_Serial_Lots_PUB;
130:
131: -- Standard call to check for call compatibility.
132: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
133: p_api_version_number,
134: l_api_name,
135: G_PKG_NAME)

Line 196: -- Standard check for p_commit

192: --
193: -- End of API body.
194: --
195:
196: -- Standard check for p_commit
197: IF FND_API.to_Boolean( p_commit )
198: THEN
199: COMMIT WORK;
200: END IF;

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

203: -- Debug Message
204: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
205:
206:
207: -- Standard call to get message count and if count is 1, get message info.
208: FND_MSG_PUB.Count_And_Get
209: ( p_count => x_msg_count,
210: p_data => x_msg_data
211: );

Line 263: -- Standard Start of API savepoint

259: l_api_name CONSTANT VARCHAR2(30) := 'Update_pack_serial_lots';
260: l_api_version_number CONSTANT NUMBER := 2.0;
261: l_pvt_plsl_rec CSP_Pack_Serial_Lots_PVT.plsl_Rec_Type;
262: BEGIN
263: -- Standard Start of API savepoint
264: SAVEPOINT UPDATE_Pack_Serial_Lots_PUB;
265:
266: -- Standard call to check for call compatibility.
267: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

262: BEGIN
263: -- Standard Start of API savepoint
264: SAVEPOINT UPDATE_Pack_Serial_Lots_PUB;
265:
266: -- Standard call to check for call compatibility.
267: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
268: p_api_version_number,
269: l_api_name,
270: G_PKG_NAME)

Line 328: -- Standard check for p_commit

324: --
325: -- End of API body
326: --
327:
328: -- Standard check for p_commit
329: IF FND_API.to_Boolean( p_commit )
330: THEN
331: COMMIT WORK;
332: END IF;

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

335: -- Debug Message
336: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
337:
338:
339: -- Standard call to get message count and if count is 1, get message info.
340: FND_MSG_PUB.Count_And_Get
341: ( p_count => x_msg_count,
342: p_data => x_msg_data
343: );

Line 396: -- Standard Start of API savepoint

392: l_api_name CONSTANT VARCHAR2(30) := 'Delete_pack_serial_lots';
393: l_api_version_number CONSTANT NUMBER := 2.0;
394: l_pvt_plsl_rec CSP_Pack_Serial_Lots_PVT.plsl_Rec_Type;
395: BEGIN
396: -- Standard Start of API savepoint
397: SAVEPOINT DELETE_Pack_Serial_Lots_PUB;
398:
399: -- Standard call to check for call compatibility.
400: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

395: BEGIN
396: -- Standard Start of API savepoint
397: SAVEPOINT DELETE_Pack_Serial_Lots_PUB;
398:
399: -- Standard call to check for call compatibility.
400: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
401: p_api_version_number,
402: l_api_name,
403: G_PKG_NAME)

Line 461: -- Standard check for p_commit

457: --
458: -- End of API body
459: --
460:
461: -- Standard check for p_commit
462: IF FND_API.to_Boolean( p_commit )
463: THEN
464: COMMIT WORK;
465: END IF;

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

468: -- Debug Message
469: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
470:
471:
472: -- Standard call to get message count and if count is 1, get message info.
473: FND_MSG_PUB.Count_And_Get
474: ( p_count => x_msg_count,
475: p_data => x_msg_data
476: );

Line 537: -- Standard Start of API savepoint

533: IS
534: l_api_name CONSTANT VARCHAR2(30) := 'Get_pack_serial_lots';
535: l_api_version_number CONSTANT NUMBER := 2.0;
536: BEGIN
537: -- Standard Start of API savepoint
538: SAVEPOINT GET_Pack_Serial_Lots_PUB;
539:
540: -- Standard call to check for call compatibility.
541: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

536: BEGIN
537: -- Standard Start of API savepoint
538: SAVEPOINT GET_Pack_Serial_Lots_PUB;
539:
540: -- Standard call to check for call compatibility.
541: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
542: p_api_version_number,
543: l_api_name,
544: G_PKG_NAME)

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

605: -- Debug Message
606: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
607:
608:
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get
611: ( p_count => x_msg_count,
612: p_data => x_msg_data
613: );