1 PACKAGE WSH_CONT_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHCONTS.pls 115.5 99/07/26 11:08:04 porting ship $ */
3
4 -- Name get_master_container
5 -- Purpose get master container id and master serial number
6 -- Arguments
7 -- X_container_id
8 -- X_master_container_id
9 -- X_master_serial_number
10
11 PROCEDURE get_master_container(
12 X_container_id IN NUMBER,
13 X_master_container_id IN OUT NUMBER,
14 X_master_serial_number IN OUT VARCHAR2);
15
16
17 -- Name check_child_containers
18 -- Purpose find all child containers and update master container
19 -- id and master serial number
20 -- Arguments
21 -- X_delivery_id
22 -- X_container_id
23 -- X_master_container_id
24 -- X_master_serial_number
25 -- X_status
26
27 PROCEDURE check_child_containers(
28 X_delivery_id IN NUMBER,
29 X_container_id IN NUMBER,
30 X_master_container_id IN NUMBER,
31 X_master_serial_number IN VARCHAR2,
32 X_status IN OUT NUMBER);
33
34
35 -- Name validate_master_serial_number
36 -- Purpose Customizable API for validating master serial number.
37 -- This API by default will always return true.
38 -- It can be customized to perform validation according to the
39 -- customer business needs.
40 -- Arguments
41 -- X_delivery_id
42 -- X_container_sequence_number
43 -- X_status
44
45 PROCEDURE validate_master_serial_number(
46 X_delivery_id IN NUMBER,
47 X_container_sequence_number IN NUMBER,
48 X_status IN OUT NUMBER);
49
50
51 -- Name update_master_serial_number
52 -- Purpose update master serial number
53 -- Arguments
54 -- X_master_serial_number
55 -- X_container_id
56 -- X_delivery_id
57 -- X_status
58
59 PROCEDURE update_master_serial_number(
60 X_master_serial_number IN VARCHAR2,
61 X_container_id IN NUMBER,
62 X_delivery_id IN NUMBER,
63 X_status IN OUT NUMBER);
64
65
66 PROCEDURE get_master_serial_number(
67 X_sequence_number IN NUMBER,
68 X_delivery_id IN NUMBER,
69 X_master_serial_number IN OUT VARCHAR2);
70
71
72 END WSH_CONT_PKG;