DBA Data[Home] [Help]

APPS.CSP_PICK_SERIAL_LOTS_PUB dependencies on CSP_PICK_SERIAL_LOTS_PVT

Line 36: x_pvt_psl_rec OUT NOCOPY csp_pick_serial_lots_PVT.psl_Rec_Type

32: --
33: -- End of Comments
34: PROCEDURE Convert_psl_Values_To_Ids(
35: P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,
36: x_pvt_psl_rec OUT NOCOPY csp_pick_serial_lots_PVT.psl_Rec_Type
37: )
38: IS
39: -- Hint: Declare cursor and local variables
40: -- Example: CURSOR C_Get_Lookup_Code(X_Lookup_Type VARCHAR2, X_Meaning VARCHAR2) IS

Line 126: l_pvt_psl_rec csp_pick_serial_lots_PVT.psl_Rec_Type;

122:
123: IS
124: l_api_name CONSTANT VARCHAR2(30) := 'Create_pick_serial_lots';
125: l_api_version_number CONSTANT NUMBER := 2.0;
126: l_pvt_psl_rec csp_pick_serial_lots_PVT.psl_Rec_Type;
127: BEGIN
128: -- Standard Start of API savepoint
129: SAVEPOINT CREATE_pick_serial_lots_PUB;
130:

Line 171: csp_pick_serial_lots_PVT.Create_pick_serial_lots(

167: );
168:
169: -- Calling Private package: Create_pick_serial_lots
170: -- Hint: Primary key needs to be returned
171: csp_pick_serial_lots_PVT.Create_pick_serial_lots(
172: P_Api_Version_Number => 2.0,
173: P_Init_Msg_List => FND_API.G_FALSE,
174: P_Commit => FND_API.G_FALSE,
175: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 261: l_pvt_psl_rec csp_pick_serial_lots_PVT.psl_Rec_Type;

257:
258: IS
259: l_api_name CONSTANT VARCHAR2(30) := 'Update_pick_serial_lots';
260: l_api_version_number CONSTANT NUMBER := 2.0;
261: l_pvt_psl_rec csp_pick_serial_lots_PVT.psl_Rec_Type;
262: BEGIN
263: -- Standard Start of API savepoint
264: SAVEPOINT UPDATE_pick_serial_lots_PUB;
265:

Line 304: csp_pick_serial_lots_PVT.Update_pick_serial_lots(

300: p_psl_rec => p_psl_rec,
301: x_pvt_psl_rec => l_pvt_psl_rec
302: );
303:
304: csp_pick_serial_lots_PVT.Update_pick_serial_lots(
305: P_Api_Version_Number => 2.0,
306: P_Init_Msg_List => FND_API.G_FALSE,
307: P_Commit => p_commit,
308: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 394: l_pvt_psl_rec csp_pick_serial_lots_PVT.psl_Rec_Type;

390:
391: IS
392: l_api_name CONSTANT VARCHAR2(30) := 'Delete_pick_serial_lots';
393: l_api_version_number CONSTANT NUMBER := 2.0;
394: l_pvt_psl_rec csp_pick_serial_lots_PVT.psl_Rec_Type;
395: BEGIN
396: -- Standard Start of API savepoint
397: SAVEPOINT DELETE_pick_serial_lots_PUB;
398:

Line 437: csp_pick_serial_lots_PVT.Delete_pick_serial_lots(

433: p_psl_rec => p_psl_rec,
434: x_pvt_psl_rec => l_pvt_psl_rec
435: );
436:
437: csp_pick_serial_lots_PVT.Delete_pick_serial_lots(
438: P_Api_Version_Number => 2.0,
439: P_Init_Msg_List => FND_API.G_FALSE,
440: P_Commit => p_commit,
441: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 570: csp_pick_serial_lots_PVT.Get_pick_serial_lots(

566: --
567: -- Debug Message
568: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Public API: - Calling PVT.Get_pick_serial_lots');
569: /*
570: csp_pick_serial_lots_PVT.Get_pick_serial_lots(
571: P_Api_Version_Number => 2.0,
572: P_Init_Msg_List => FND_API.G_FALSE,
573: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
574: P_Identity_Salesforce_id => p_identity_salesforce_id,