1 PACKAGE CSP_PC_FORM_PICKLINES AUTHID CURRENT_USER AS
2 /* $Header: cspgtpls.pls 115.6 2002/11/26 06:44:30 hhaugeru ship $ */
3 -- Start of Comments
4
5 -- Start of comments
6 --
7 -- API name : CSP_PC_FORM_PICKLINES
8 -- Type : Type of API (Eg. Public, simple entity)
9 -- Purpose : Wrapper for the picklist lines private procedure which calls table handlers
10 --
11 -- Modification History
12 -- Date Userid Comments
13 -- --------- ------ ------------------------------------------
14 --
15 -- Note : Useful information goes here
16 -- And here
17 -- End of comments
18
19 PROCEDURE Validate_And_Write
20 ( P_Api_Version_Number IN NUMBER,
21 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24 p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
25 px_PICKLIST_LINE_ID IN OUT NOCOPY NUMBER,
26 p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
27 p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
28 p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
29 p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
30 p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
31 p_PICKLIST_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
32 p_picklist_header_id IN NUMBER := FND_API.G_MISS_NUM,
33 p_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
34 p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
35 p_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
36 p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
37 p_QUANTITY_PICKED IN NUMBER := FND_API.G_MISS_NUM,
38 p_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
39 p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
40 p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41 p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42 p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43 p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44 p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45 p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46 p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47 p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48 p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50 p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51 p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52 p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53 p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54 p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2);
58
59 END; -- Package spec