[Home] [Help]
PACKAGE: APPS.INV_KANBANCARD_PKG
Source
1 PACKAGE INV_KanbanCard_PKG AUTHID CURRENT_USER as
2 /* $Header: INVKCRDS.pls 120.1 2011/02/07 09:54:09 sisankar ship $ */
3
4
5 FUNCTION Check_Unique(p_Kanban_Card_Id IN OUT NOCOPY NUMBER,
6 p_Organization_Id NUMBER,
7 p_Kanban_Card_Number VARCHAR2)
8 RETURN BOOLEAN;
9
10 FUNCTION Supply_Status_Change_OK
11 ( p_from_supply_status number,
12 p_to_supply_status number,
13 p_card_status number)
14 RETURN BOOLEAN;
15 --Added method with p_kanban_card_id by javakat for eKanban
16 FUNCTION supply_status_change_ok
17 (p_kanban_card_id NUMBER,
18 p_from_supply_status NUMBER,
19 p_to_supply_status NUMBER,
20 p_card_status NUMBER)
21 RETURN BOOLEAN;
22 FUNCTION Query_Row
23 ( p_kanban_card_id IN NUMBER )
24 RETURN INV_Kanban_PVT.Kanban_Card_Rec_Type;
25
26 Procedure commit_row;
27
28 Procedure rollback_row;
29
30 /*PROCEDURE Insert_Row( x_return_status OUT NOCOPY VARCHAR2,
31 p_Kanban_Card_Id IN OUT NOCOPY NUMBER,
32 p_Kanban_Card_Number IN OUT NOCOPY VARCHAR2,
33 p_Pull_Sequence_Id NUMBER,
34 p_Inventory_item_id NUMBER,
35 p_Organization_id NUMBER,
36 p_Subinventory_name VARCHAR2,
37 p_Supply_Status IN OUT NOCOPY NUMBER,
38 p_Card_Status IN OUT NOCOPY NUMBER,
39 p_Kanban_Card_Type NUMBER,
40 p_Source_type NUMBER,
41 p_Kanban_size NUMBER,
42 p_Last_Update_Date DATE,
43 p_Last_Updated_By NUMBER,
44 p_Creation_Date DATE,
45 p_Created_By NUMBER,
46 p_Last_Update_Login NUMBER,
47 p_Last_Print_Date DATE,
48 p_Locator_id NUMBER,
49 p_Supplier_id NUMBER,
50 p_Supplier_site_id NUMBER,
51 p_Source_Organization_id NUMBER,
52 p_Source_Subinventory VARCHAR2,
53 p_Source_Locator_id NUMBER,
54 p_wip_line_id NUMBER,
55 p_Current_Replnsh_Cycle_Id IN OUT NOCOPY NUMBER,
56 p_Document_Type NUMBER,
57 p_Document_Header_Id NUMBER,
58 p_Document_Detail_Id NUMBER,
59 p_Error_code NUMBER,
60 p_Attribute_Category VARCHAR2,
61 p_Attribute1 VARCHAR2,
62 p_Attribute2 VARCHAR2,
63 p_Attribute3 VARCHAR2,
64 p_Attribute4 VARCHAR2,
65 p_Attribute5 VARCHAR2,
66 p_Attribute6 VARCHAR2,
67 p_Attribute7 VARCHAR2,
68 p_Attribute8 VARCHAR2,
69 p_Attribute9 VARCHAR2,
70 p_Attribute10 VARCHAR2,
71 p_Attribute11 VARCHAR2,
72 p_Attribute12 VARCHAR2,
73 p_Attribute13 VARCHAR2,
74 p_Attribute14 VARCHAR2,
75 p_Attribute15 VARCHAR2,
76 p_Request_Id NUMBER,
77 p_Program_application_Id NUMBER,
78 p_Program_Id NUMBER,
79 p_Program_Update_date DATE,
80 p_release_kanban_flag NUMBER :=1);
81 */
82 PROCEDURE Lock_Row (p_Kanban_Card_Id NUMBER,
83 p_Kanban_Card_Number VARCHAR2,
84 p_Pull_Sequence_Id NUMBER,
85 p_Inventory_item_id NUMBER,
86 p_Organization_id NUMBER,
87 p_Subinventory_name VARCHAR2,
88 p_Supply_Status NUMBER,
89 p_Card_Status NUMBER,
90 p_Kanban_Card_Type NUMBER,
91 p_Source_type NUMBER,
92 p_Kanban_size NUMBER,
93 p_Last_Print_date DATE,
94 p_Locator_id NUMBER,
95 p_Supplier_id NUMBER,
96 p_Supplier_site_id NUMBER,
97 p_Source_Organization_id NUMBER,
98 p_Source_Subinventory VARCHAR2,
99 p_Source_Locator_id NUMBER,
100 p_wip_line_id NUMBER,
101 p_Current_Replnsh_Cycle_Id NUMBER,
102 p_Error_code NUMBER,
103 p_Attribute_Category VARCHAR2,
104 p_Attribute1 VARCHAR2,
105 p_Attribute2 VARCHAR2,
106 p_Attribute3 VARCHAR2,
107 p_Attribute4 VARCHAR2,
108 p_Attribute5 VARCHAR2,
109 p_Attribute6 VARCHAR2,
110 p_Attribute7 VARCHAR2,
111 p_Attribute8 VARCHAR2,
112 p_Attribute9 VARCHAR2,
113 p_Attribute10 VARCHAR2,
114 p_Attribute11 VARCHAR2,
115 p_Attribute12 VARCHAR2,
116 p_Attribute13 VARCHAR2,
117 p_Attribute14 VARCHAR2,
118 p_Attribute15 VARCHAR2);
119
120 -- Added for eKanban.
121 PROCEDURE insert_row(
122 x_return_status OUT NOCOPY VARCHAR2
123 , p_kanban_card_id IN OUT NOCOPY NUMBER
124 , p_kanban_card_number IN OUT NOCOPY VARCHAR2
125 , p_pull_sequence_id NUMBER
126 , p_inventory_item_id NUMBER
127 , p_organization_id NUMBER
128 , p_subinventory_name VARCHAR2
129 , p_supply_status IN OUT NOCOPY NUMBER
130 , p_card_status IN OUT NOCOPY NUMBER
131 , p_kanban_card_type NUMBER
132 , p_source_type NUMBER
133 , p_kanban_size NUMBER
134 , p_last_update_date DATE
135 , p_last_updated_by NUMBER
136 , p_creation_date DATE
137 , p_created_by NUMBER
138 , p_last_update_login NUMBER
139 , p_last_print_date DATE
140 , p_locator_id NUMBER
141 , p_supplier_id NUMBER
142 , p_supplier_site_id NUMBER
143 , p_source_organization_id NUMBER
144 , p_source_subinventory VARCHAR2
145 , p_source_locator_id NUMBER
146 , p_wip_line_id NUMBER
147 , p_current_replnsh_cycle_id IN OUT NOCOPY NUMBER
148 , p_document_type NUMBER
149 , p_document_header_id NUMBER
150 , p_document_detail_id NUMBER
151 , p_error_code NUMBER
152 , p_attribute_category VARCHAR2
153 , p_attribute1 VARCHAR2
154 , p_attribute2 VARCHAR2
155 , p_attribute3 VARCHAR2
156 , p_attribute4 VARCHAR2
157 , p_attribute5 VARCHAR2
158 , p_attribute6 VARCHAR2
159 , p_attribute7 VARCHAR2
160 , p_attribute8 VARCHAR2
161 , p_attribute9 VARCHAR2
162 , p_attribute10 VARCHAR2
163 , p_attribute11 VARCHAR2
164 , p_attribute12 VARCHAR2
165 , p_attribute13 VARCHAR2
166 , p_attribute14 VARCHAR2
167 , p_attribute15 VARCHAR2
168 , p_request_id NUMBER
169 , p_program_application_id NUMBER
170 , p_program_id NUMBER
171 , p_program_update_date DATE
172 , p_release_kanban_flag NUMBER DEFAULT NULL
173 --eKanban Changes
174 , p_replenishment_count NUMBER DEFAULT NULL
175 , p_max_replenishments NUMBER DEFAULT NULL
176 , p_disable_date DATE DEFAULT NULL
177 , p_replacement_flag NUMBER DEFAULT NULL
178 );
179
180
181 -- Added for eKanban.
182 PROCEDURE Update_Row(x_return_status Out NOCOPY VARCHAR2,
183 p_Kanban_Card_Id NUMBER,
184 p_Kanban_Card_Number VARCHAR2,
185 p_Pull_Sequence_Id NUMBER,
186 p_Inventory_item_id NUMBER,
187 p_Organization_id NUMBER,
188 p_Subinventory_name VARCHAR2,
189 p_Supply_Status In OUT NOCOPY NUMBER,
190 p_Card_Status In Out NOCOPY NUMBER,
191 p_Kanban_Card_Type NUMBER,
192 p_Source_type NUMBER,
193 p_Kanban_size NUMBER,
194 p_Last_Update_Date DATE,
195 p_Last_Updated_By NUMBER,
196 p_Creation_Date DATE,
197 p_Created_By NUMBER,
198 p_Last_Update_Login NUMBER,
199 p_Last_Print_Date Date,
200 p_Locator_id NUMBER,
201 p_Supplier_id NUMBER,
202 p_Supplier_site_id NUMBER,
203 p_Source_Organization_id NUMBER,
204 p_Source_Subinventory VARCHAR2,
205 p_Source_Locator_id NUMBER,
206 p_wip_line_id NUMBER,
207 p_Current_Replnsh_Cycle_Id In Out NOCOPY NUMBER,
208 p_Document_Type NUMBER,
209 p_Document_Header_Id NUMBER,
210 p_Document_Detail_Id NUMBER,
211 p_Error_code NUMBER,
212 p_Attribute_Category VARCHAR2,
213 p_Attribute1 VARCHAR2,
214 p_Attribute2 VARCHAR2,
215 p_Attribute3 VARCHAR2,
216 p_Attribute4 VARCHAR2,
217 p_Attribute5 VARCHAR2,
218 p_Attribute6 VARCHAR2,
219 p_Attribute7 VARCHAR2,
220 p_Attribute8 VARCHAR2,
221 p_Attribute9 VARCHAR2,
222 p_Attribute10 VARCHAR2,
226 p_Attribute14 VARCHAR2,
223 p_Attribute11 VARCHAR2,
224 p_Attribute12 VARCHAR2,
225 p_Attribute13 VARCHAR2,
227 p_Attribute15 VARCHAR2,
228 p_lot_item_id NUMBER DEFAULT NULL,
229 p_lot_number VARCHAR2 DEFAULT NULL,
230 p_lot_item_revision VARCHAR2 DEFAULT NULL,
231 p_lot_subinventory_code VARCHAR2 DEFAULT NULL,
232 p_lot_location_id NUMBER DEFAULT NULL,
233 p_lot_quantity NUMBER DEFAULT NULL,
234 p_replenish_quantity NUMBER DEFAULT NULL,
235 p_need_by_date DATE DEFAULT NULL,
236 p_source_wip_entity_id NUMBER DEFAULT NULL,
237 p_replenishment_count NUMBER DEFAULT NULL,
238 p_max_replenishments NUMBER DEFAULT NULL,
239 p_disable_date DATE DEFAULT NULL,
240 p_replacement_flag NUMBER DEFAULT NULL );
241
242
243 /*PROCEDURE Update_Row(x_return_status Out NOCOPY VARCHAR2,
244 p_Kanban_Card_Id NUMBER,
245 p_Kanban_Card_Number VARCHAR2,
246 p_Pull_Sequence_Id NUMBER,
247 p_Inventory_item_id NUMBER,
248 p_Organization_id NUMBER,
249 p_Subinventory_name VARCHAR2,
250 p_Supply_Status In OUT NOCOPY NUMBER,
251 p_Card_Status In Out NOCOPY NUMBER,
252 p_Kanban_Card_Type NUMBER,
253 p_Source_type NUMBER,
254 p_Kanban_size NUMBER,
255 p_Last_Update_Date DATE,
256 p_Last_Updated_By NUMBER,
257 p_Creation_Date DATE,
258 p_Created_By NUMBER,
259 p_Last_Update_Login NUMBER,
260 p_Last_Print_Date Date,
261 p_Locator_id NUMBER,
262 p_Supplier_id NUMBER,
263 p_Supplier_site_id NUMBER,
264 p_Source_Organization_id NUMBER,
265 p_Source_Subinventory VARCHAR2,
266 p_Source_Locator_id NUMBER,
267 p_wip_line_id NUMBER,
268 p_Current_Replnsh_Cycle_Id In Out NOCOPY NUMBER,
269 p_Document_Type NUMBER,
270 p_Document_Header_Id NUMBER,
271 p_Document_Detail_Id NUMBER,
272 p_Error_code NUMBER,
273 p_Attribute_Category VARCHAR2,
274 p_Attribute1 VARCHAR2,
275 p_Attribute2 VARCHAR2,
276 p_Attribute3 VARCHAR2,
277 p_Attribute4 VARCHAR2,
278 p_Attribute5 VARCHAR2,
279 p_Attribute6 VARCHAR2,
280 p_Attribute7 VARCHAR2,
281 p_Attribute8 VARCHAR2,
282 p_Attribute9 VARCHAR2,
283 p_Attribute10 VARCHAR2,
284 p_Attribute11 VARCHAR2,
285 p_Attribute12 VARCHAR2,
286 p_Attribute13 VARCHAR2,
287 p_Attribute14 VARCHAR2,
288 p_Attribute15 VARCHAR2,
289 p_lot_item_id NUMBER DEFAULT NULL,
290 p_lot_number VARCHAR2 DEFAULT NULL,
291 p_lot_item_revision VARCHAR2 DEFAULT NULL,
292 p_lot_subinventory_code VARCHAR2 DEFAULT NULL,
293 p_lot_location_id NUMBER DEFAULT NULL,
294 p_lot_quantity NUMBER DEFAULT NULL,
295 p_replenish_quantity NUMBER DEFAULT NULL,
296 p_need_by_date DATE DEFAULT NULL,
297 p_source_wip_entity_id NUMBER DEFAULT NULL);*/
298
299 PROCEDURE Update_Row(p_Kanban_Card_Rec
300 INV_Kanban_PVT.Kanban_Card_rec_Type);
301
302 PROCEDURE Update_Card_Status(p_Kanban_Card_Rec
303 IN OUT NOCOPY INV_Kanban_PVT.kanban_card_rec_type,
304 p_card_status IN NUMBER);
305
306 PROCEDURE Delete_Row(x_return_status Out NOCOPY Varchar2,
307 p_Kanban_Card_Id Number);
308
309 PROCEDURE Delete_Cards_For_Pull_Seq(p_Pull_Sequence_Id Number);
310
311 PROCEDURE Insert_Activity_For_Card
312 (p_Kanban_Card_Rec INV_Kanban_PVT.Kanban_Card_Rec_Type);
313
314 PROCEDURE Delete_Activity_For_Card(p_Kanban_Card_Id NUMBER);
315
316 PROCEDURE Delete_Activity_For_Pull_Seq(p_Pull_Sequence_Id NUMBER);
317
318 END INV_KanbanCard_PKG;