APPS.CSP_PICK_SL_UTIL dependencies on CSP_PICK_SERIAL_LOTS_PVT

Line 6: -- csp_pick_serial_lots_PVT.

2: /*$Header: cspgtslb.pls 120.0 2005/05/25 11:31:02 appldev noship $*/
3: -- Start of Comments
4: -- Package name : CSP_Pick_SL_Util
5: -- Purpose : A wrapper to prepare data to call the update, delete and insert procedures of the
6: -- csp_pick_serial_lots_PVT.
7: -- MODIFICATION HISTORY
8: -- Person Date Comments
9: -- --------- ------ ------------------------------------------
10: -- klou 01/28/00 Created.

Line 67: l_psl_rec csp_pick_serial_lots_PVT.psl_Rec_Type;

63: EXCP_USER_DEFINED EXCEPTION;
64:
65: -- customers declarations
66: l_picklist_Serial_Lot_ID NUMBER := NULL;
67: l_psl_rec csp_pick_serial_lots_PVT.psl_Rec_Type;
68:
69: BEGIN
70: SAVEPOINT Validate_And_Write_PUB;
71: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

Line 195: -- call the csp_pick_serial_lots_PVT.Create_pick_serial_lots

191: l_psl_rec.SERIAL_NUMBER := p_SERIAL_NUMBER;
192:
193:
194: IF p_action_code = 0 THEN
195: -- call the csp_pick_serial_lots_PVT.Create_pick_serial_lots
196: IF p_CREATION_DATE IS NULL THEN
197: l_psl_rec.CREATION_DATE := sysdate;
198: END IF;
199:

Line 204: csp_pick_serial_lots_PVT.Create_pick_serial_lots (

200: IF p_LAST_UPDATE_DATE IS NULL THEN
201: l_psl_rec.LAST_UPDATE_DATE := sysdate;
202: END IF;
203:
204: csp_pick_serial_lots_PVT.Create_pick_serial_lots (
205: P_Api_Version_Number => l_Api_Version_Number,
206: P_Init_Msg_List => p_Init_Msg_List,
207: P_Commit => l_Commit,
208: p_validation_level => l_validation_level,

Line 216: -- call the csp_pick_serial_lots_PVT.Update_pick_serial_lots

212: X_Msg_Count => l_msg_count,
213: X_Msg_Data => l_msg_data);
214:
215: ELSIF p_action_code = 1 THEN
216: -- call the csp_pick_serial_lots_PVT.Update_pick_serial_lots
217: IF p_LAST_UPDATE_DATE IS NULL THEN
218: l_psl_rec.LAST_UPDATE_DATE := sysdate;
219: END IF;
220:

Line 221: csp_pick_serial_lots_PVT.Update_pick_serial_lots(

217: IF p_LAST_UPDATE_DATE IS NULL THEN
218: l_psl_rec.LAST_UPDATE_DATE := sysdate;
219: END IF;
220:
221: csp_pick_serial_lots_PVT.Update_pick_serial_lots(
222: P_Api_Version_Number => l_Api_Version_Number,
223: P_Init_Msg_List => p_Init_Msg_List,
224: P_Commit => l_Commit,
225: p_validation_level => l_validation_level,

Line 233: -- call the csp_pick_serial_lots_PVT.Create_pick_serial_lots

229: X_Msg_Count => l_msg_count,
230: X_Msg_Data => l_msg_data);
231:
232: ELSIF p_action_code = 2 THEN
233: -- call the csp_pick_serial_lots_PVT.Create_pick_serial_lots
234: csp_pick_serial_lots_PVT.Delete_pick_serial_lots(
235: P_Api_Version_Number => l_Api_Version_Number,
236: P_Init_Msg_List => p_Init_Msg_List,
237: P_Commit => l_Commit,

Line 234: csp_pick_serial_lots_PVT.Delete_pick_serial_lots(

230: X_Msg_Data => l_msg_data);
231:
232: ELSIF p_action_code = 2 THEN
233: -- call the csp_pick_serial_lots_PVT.Create_pick_serial_lots
234: csp_pick_serial_lots_PVT.Delete_pick_serial_lots(
235: P_Api_Version_Number => l_Api_Version_Number,
236: P_Init_Msg_List => p_Init_Msg_List,
237: P_Commit => l_Commit,
238: p_validation_level => l_validation_level,