1 PACKAGE wms_pick_load_ui AUTHID CURRENT_USER AS
2 /* $Header: WMSPLUIS.pls 120.3 2011/02/21 10:24:35 ssikhara ship $ */
3
4 TYPE t_genref IS REF CURSOR;
5
6 PROCEDURE validate_subinventory(p_organization_id IN NUMBER,
7 p_item_id IN NUMBER,
8 p_subinventory_code IN VARCHAR2,
9 p_restrict_subinventories_code IN NUMBER,
10 p_transaction_type_id IN NUMBER,
11 x_is_valid_subinventory OUT nocopy VARCHAR2,
12 x_is_lpn_controlled OUT nocopy VARCHAR2,
13 x_message OUT nocopy VARCHAR2);
14 --x_alias_enabled OUT nocopy VARCHAR2);commented Bug 7225845
15
16 PROCEDURE validate_locator_lpn
17 (p_organization_id IN NUMBER,
18 p_restrict_locators_code IN NUMBER,
19 p_inventory_item_id IN NUMBER,
20 p_revision IN VARCHAR2,
21 p_locator_lpn IN VARCHAR2,
22 p_subinventory_code IN VARCHAR2,
23 p_transaction_temp_id IN NUMBER,
24 p_transaction_type_id IN NUMBER,
25 p_project_id IN NUMBER,
26 p_task_id IN NUMBER,
27 p_allocated_lpn IN VARCHAR2,
28 p_suggested_loc IN VARCHAR2,
29 p_suggested_loc_id IN NUMBER,
30 p_suggested_sub IN VARCHAR2,
31 p_serial_allocated IN VARCHAR2,
32 p_allow_locator_change IN VARCHAR2,
33 p_is_loc_or_lpn IN VARCHAR2,
34 p_confirm_locator_hidden IN VARCHAR2, --10435590
35 x_is_valid_locator OUT nocopy VARCHAR2,
36 x_is_valid_lpn OUT nocopy VARCHAR2,
37 x_subinventory_code OUT nocopy VARCHAR2,
38 x_locator OUT nocopy VARCHAR2,
39 x_locator_id OUT nocopy NUMBER,
40 x_lpn_id OUT nocopy NUMBER,
41 x_is_lpn_controlled OUT nocopy VARCHAR2,
42 x_return_status OUT nocopy VARCHAR2,
43 x_msg_count OUT nocopy NUMBER,
44 x_msg_data OUT nocopy VARCHAR2);
45
46 END wms_pick_load_ui;