1 PACKAGE CSP_Pick_SL_Util AUTHID CURRENT_USER AS
2 /* $Header: cspgtsls.pls 115.5 2002/11/26 06:09:09 hhaugeru ship $ */
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.
11 --
12 -- NOTE :
13 -- End of Comments
14
15 PROCEDURE Validate_And_Write (
16 P_Api_Version_Number IN NUMBER,
17 P_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE,
18 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20 p_action_code IN NUMBER,
21 px_PICKLIST_SERIAL_LOT_ID IN OUT NOCOPY NUMBER,
22 p_CREATED_BY IN NUMBER,
23 p_CREATION_DATE IN DATE,
24 p_LAST_UPDATED_BY IN NUMBER,
25 p_LAST_UPDATE_DATE IN DATE,
26 p_LAST_UPDATE_LOGIN IN NUMBER,
27 p_PICKLIST_LINE_ID IN NUMBER,
28 p_ORGANIZATION_ID IN NUMBER,
29 p_INVENTORY_ITEM_ID IN NUMBER,
30 p_QUANTITY IN NUMBER,
31 p_LOT_NUMBER IN VARCHAR2,
32 p_SERIAL_NUMBER IN VARCHAR2,
33 X_Return_Status OUT NOCOPY VARCHAR2,
34 X_Msg_Count OUT NOCOPY NUMBER,
35 X_Msg_Data OUT NOCOPY VARCHAR2
36 );
37
38 END CSP_Pick_SL_Util;