1 PACKAGE INV_STATUS_PKG AS
2 /* $Header: INVUPMSS.pls 120.5 2008/04/15 13:36:10 abaid ship $ */
3 --BEGIN SCHANDRU INVERES
4 function get_from_status_code ( p_org_id in number default null,
5 p_item_id in number default null,
6 p_sub_inv in varchar2 default null,
7 p_locator_id in number default null,
8 p_lot in varchar2 default null,
9 p_serial in varchar2 default null ) return varchar2 ;
10
11 --END SCHANDRU INVERES
12
13
14 PROCEDURE check_lot_range_status(
15 p_org_id IN NUMBER,
16 p_item_id IN NUMBER,
17 p_from_lot IN VARCHAR2,
18 p_to_lot IN VARCHAR2,
19 x_Status OUT nocopy VARCHAR2,
20 x_Message OUT nocopy VARCHAR2,
21 x_Status_Code OUT nocopy VARCHAR2
22 );
23
24 PROCEDURE check_serial_range_status(
25 p_org_id IN NUMBER,
26 p_item_id IN NUMBER,
27 p_from_serial IN VARCHAR2,
28 p_to_serial IN VARCHAR2,
29 x_Status OUT nocopy VARCHAR2,
30 x_Message OUT nocopy VARCHAR2,
31 x_Status_Code OUT nocopy VARCHAR2
32 );
33 PROCEDURE update_status(
34 p_update_method IN NUMBER
35 , p_organization_id IN NUMBER
36 , p_inventory_item_id IN NUMBER
37 , p_sub_code IN VARCHAR2
38 , p_sub_status_id IN NUMBER
39 , p_sub_reason_id IN NUMBER
40 , p_locator_id IN NUMBER
41 , p_loc_status_id IN NUMBER
42 , p_loc_reason_id IN NUMBER
43 , p_from_lot_number IN VARCHAR2
44 , p_to_lot_number IN VARCHAR2
45 , p_lot_status_id IN NUMBER
46 , p_lot_reason_id IN NUMBER
47 , p_from_SN IN VARCHAR2
48 , p_to_SN IN VARCHAR2
49 , p_serial_status_id IN NUMBER
50 , p_serial_reason_id IN NUMBER
51 , x_Status OUT nocopy VARCHAR2
52 , x_Message OUT nocopy VARCHAR2
53 , p_update_from_mobile IN VARCHAR2 DEFAULT 'Y'
54 -- NSRIVAST, INVCONV , Start
55 , p_grade_code IN VARCHAR2 DEFAULT NULL
56 , p_primary_onhand IN NUMBER DEFAULT NULL
57 , p_secondary_onhand IN NUMBER DEFAULT NULL
58 -- NSRIVAST, INVCONV , End
59 , p_onhand_status_id IN NUMBER DEFAULT NULL -- Added for # 6633612
60 , p_onhand_reason_id IN NUMBER DEFAULT NULL -- Added for # 6633612
61 , p_lpn_id IN NUMBER DEFAULT NULL -- Added for # 6633612
62
63 );
64
65 PROCEDURE invoke_reason_wf(
66 p_update_method IN NUMBER
67 , p_organization_id IN NUMBER
68 , p_inventory_item_id IN NUMBER
69 , p_sub_code IN VARCHAR2
70 , p_sub_status_id IN NUMBER
71 , p_sub_reason_id IN NUMBER
72 , p_locator_id IN NUMBER
73 , p_loc_status_id IN NUMBER
74 , p_loc_reason_id IN NUMBER
75 , p_from_lot_number IN VARCHAR2
76 , p_to_lot_number IN VARCHAR2
77 , p_lot_status_id IN NUMBER
78 , p_lot_reason_id IN NUMBER
79 , p_from_SN IN VARCHAR2
80 , p_to_SN IN VARCHAR2
81 , p_serial_status_id IN NUMBER
82 , p_serial_reason_id IN NUMBER
83 , p_onhand_status_id IN NUMBER DEFAULT NULL -- Added for # 6633612
84 , p_onhand_reason_id IN NUMBER DEFAULT NULL -- Added for # 6633612
85 , p_lpn_id IN NUMBER DEFAULT NULL -- Added for # 6633612
86 , x_Status OUT nocopy VARCHAR2
87 , x_Message OUT nocopy VARCHAR2);
88 --Bug#5577767 Created this procedure to filter sec qty/uom based on tracking_quantity_ind.
89 PROCEDURE tracking_quantity_ind(p_item_id IN NUMBER,
90 p_org_id IN NUMBER,
91 x_sec_qty IN OUT nocopy NUMBER,
92 x_sec_uom IN OUT nocopy VARCHAR2);
93 --added for lpn status project to check if update transaction will result in mixed or not
94 FUNCTION get_mixed_status(p_lpn_id NUMBER,
95 p_organization_id NUMBER,
96 p_outermost_lpn_id NUMBER,
97 p_inventory_item_id NUMBER,
98 p_lot_number VARCHAR2 := NULL,
99 p_status_id NUMBER)
100 RETURN VARCHAR2;
101 --added for lpn status project to check if update transaction will result in mixed or not
102 FUNCTION get_mixed_status_serial(p_lpn_id NUMBER,
103 p_organization_id NUMBER,
104 p_outermost_lpn_id NUMBER,
105 p_inventory_item_id NUMBER,
106 p_lot_number VARCHAR2 := NULL,
107 p_fm_sn VARCHAR2,
108 p_to_sn VARCHAR2,
109 p_status_id NUMBER)
110 RETURN VARCHAR2;
111
112 END INV_STATUS_PKG;