1 PACKAGE SERIAL_CHECK AUTHID CURRENT_USER AS
2 /* $Header: INVMKUMS.pls 120.2 2005/06/17 15:16:35 appldev $ */
3
4 PROCEDURE inv_mark_serial
5 ( from_serial_number IN VARCHAR2,
6 to_serial_number IN VARCHAR2 DEFAULT NULL,
7 item_id IN NUMBER,
8 org_id IN NUMBER,
9 hdr_id IN NUMBER,
10 temp_id IN NUMBER,
11 lot_temp_id IN NUMBER,
12 success IN OUT NOCOPY NUMBER);
13
14 /*** {{ R12 Enhanced reservations code changes ***/
15 -- overloaded procedure
16 PROCEDURE inv_mark_rsv_serial
17 ( from_serial_number IN VARCHAR2,
18 to_serial_number IN VARCHAR2 DEFAULT NULL,
19 item_id IN NUMBER,
20 org_id IN NUMBER,
21 hdr_id IN NUMBER,
22 temp_id IN NUMBER,
23 lot_temp_id IN NUMBER,
24 p_reservation_id IN NUMBER DEFAULT NULL,
25 p_update_reservation IN VARCHAR2 DEFAULT fnd_api.g_true,
26 success IN OUT NOCOPY NUMBER);
27 /*** End R12 }} ***/
28
29 PROCEDURE inv_unmark_serial
30 ( from_serial_number IN VARCHAR2,
31 to_serial_number IN VARCHAR2,
32 serial_code IN NUMBER,
33 hdr_id IN NUMBER,
34 temp_id IN NUMBER DEFAULT NULL,
35 lot_temp_id IN NUMBER DEFAULT NULL,
36 p_inventory_item_id IN NUMBER DEFAULT NULL);
37
38 /*** {{ R12 Enhanced reservations code changes ***/
39 -- overloaded procedure
40 PROCEDURE inv_unmark_rsv_serial
41 ( from_serial_number IN VARCHAR2,
42 to_serial_number IN VARCHAR2,
43 serial_code IN NUMBER,
44 hdr_id IN NUMBER,
45 temp_id IN NUMBER DEFAULT NULL,
46 lot_temp_id IN NUMBER DEFAULT NULL,
47 p_inventory_item_id IN NUMBER DEFAULT NULL,
48 p_update_reservation IN VARCHAR2 DEFAULT fnd_api.g_true);
49 /*** End R12 }} ***/
50
51 PROCEDURE inv_update_marked_serial
52 ( from_serial_number IN VARCHAR2,
53 to_serial_number IN VARCHAR2 DEFAULT NULL,
54 item_id IN NUMBER,
55 org_id IN NUMBER,
56 temp_id IN NUMBER DEFAULT NULL,
57 hdr_id IN NUMBER DEFAULT NULL,
58 lot_temp_id IN NUMBER DEFAULT NULL,
59 success OUT NOCOPY BOOLEAN );
60
61 END SERIAL_CHECK;