1 PACKAGE AMS_ITEM_CATEGORY_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvicas.pls 115.4 2002/11/11 22:06:15 abhola ship $ */
3
4 --------------------------------------------------------------
5 -- PROCEDURE
6 -- Create_Category_Assignment
7 --
8 --------------------------------------------------------------
9 PROCEDURE Create_Category_Assignment
10 (
11 p_api_version IN NUMBER,
12 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13 p_commit IN VARCHAR2 := FND_API.G_FALSE,
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_errorcode OUT NOCOPY NUMBER,
16 x_msg_count OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2,
18 p_category_id IN NUMBER,
19 p_category_set_id IN NUMBER,
20 p_inventory_item_id IN NUMBER,
21 p_organization_id IN NUMBER
22 );
23
24 -- Start OF comments
25 -- API name : Create_Category_Assignment
26 -- TYPE : Public
27 -- Pre-reqs : None
28 -- FUNCTION : Create an item category assignment.
29 -- If this operation fails then the item-category assignment
30 -- is not created and error code is returned.
31 --
32 -- Parameters:
33 -- IN : p_api_version IN NUMBER (required)
34 -- API Version of this procedure
35 --
36 -- p_init_msg_level IN VARCHAR2 (optional)
37 -- DEFAULT = FND_API.G_FALSE,
38 --
39 -- p_commit IN VARCHAR2 (optional)
40 -- DEFAULT = FND_API.G_FALSE,
41 --
42 -- p_category_id IN NUMBER (required)
43 -- category for assigning item
44 --
45 -- p_category_set_id IN NUMBER (required)
46 -- category set for assignment. An item can be assigned to
47 -- only one category within a category set.
48 --
49 -- p_inventory_item_id IN NUMBER (required)
50 -- id of inventory item (item key)
51 --
52 -- p_organization_id IN NUMBER (required)
53 -- id of item organization (item key)
54
55 -- OUT : x_msg_count OUT NUMBER,
56 -- number of messages in the message list
57 -- x_msg_data OUT VARCHAR2,
58 -- if number of messages is 1, then this parameter
59 -- contains the message itself
60 --
61 -- X_return_status OUT NUMBER
62 -- Result of all the operations
63 -- FND_API.G_RET_STS_SUCCESS if success
64 -- FND_API.G_RET_STS_ERROR if error
65 -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
66 --
67 -- X_ErrorCode OUT NUMBER
68 -- RETURN value OF the x_errorcode
69 -- check only if x_return_status <> fnd_api.g_ret_sts_success
70 -- These errors are unrecoverable and the API failed as a result of this
71 -- XXX - Error reason/message (will be updated after implementation)
72 -- -1 - unexpected error - all operations have been rollbacked
73 --
74 --
75 -- Version: Current Version 0.1
76 -- Previous Version : None
77 -- Notes :
78 --
79 -- END OF comments
80 ----------------------------------------------------------------------------
81 -- Delete_Category_Assignment
82 ----------------------------------------------------------------------------
83 PROCEDURE Delete_Category_Assignment
84 (
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87 p_commit IN VARCHAR2 := FND_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_errorcode OUT NOCOPY NUMBER,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_category_id IN NUMBER,
93 p_category_set_id IN NUMBER,
94 p_inventory_item_id IN NUMBER,
95 p_organization_id IN NUMBER
96 );
97 -- Start OF comments
98 -- API name : Delete_Category_Assignment
99 -- TYPE : Public
100 -- Pre-reqs : None
101 -- FUNCTION : Delete an item category assignment.
102 -- If this operation fails then the category is not
103 -- deleted and error code is returned.
104 --
105 -- Parameters:
106 -- IN : p_api_version IN NUMBER (required)
107 -- API Version of this procedure
108 --
109 -- p_init_msg_level IN VARCHAR2 (optional)
110 -- DEFAULT = FND_API.G_FALSE,
111 --
112 -- p_commit IN VARCHAR2 (optional)
113 -- DEFAULT = FND_API.G_FALSE,
114 --
115 -- p_category_id IN NUMBER (required)
116 -- category of the assginement
117 --
118 -- p_category_set_id IN NUMBER (required)
119 -- category set of the assignment.
120 --
121 -- p_inventory_item_id IN NUMBER (required)
122 -- p_organization_id IN NUMBER (required)
123 -- item organization of the assigned item (item key)
124
125 -- OUT : x_msg_count OUT NUMBER,
126 -- number of messages in the message list
127 --
128 -- x_msg_data OUT VARCHAR2,
129 -- if number of messages is 1, then this parameter
130 -- contains the message itself
131 --
132 -- X_return_status OUT NUMBER
133 -- Result of all the operations
134 -- FND_API.G_RET_STS_SUCCESS if success
135 -- FND_API.G_RET_STS_ERROR if error
136 -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
137 --
138 -- X_ErrorCode OUT NUMBER
139 -- RETURN value OF the x_errorcode
140 -- check only if x_return_status <> fnd_api.g_ret_sts_success
141 -- These errors are unrecoverable and the API failed as a result of this
142 -- XXX - Error reason/message (will be updated after implementation)
143 -- -1 - unexpected error - all operations have been rollbacked
144 --
145 --
146 -- Version: Current Version 0.1
147 -- Previous Version : None
148 -- Notes :
149 --
150 -- END OF comments
151
152 END AMS_ITEM_CATEGORY_PVT; -- Package spec