1 PACKAGE WMS_TRIPSTOPS_STAGELANES_PUB AUTHID CURRENT_USER AS
2 --/* $Header: WMSDKTSS.pls 120.0 2005/05/24 18:08:13 appldev noship $ */
3
4 PROCEDURE get_stgln_for_tripstop
5 (
6 x_return_status OUT NOCOPY VARCHAR2
7 , x_msg_count OUT NOCOPY NUMBER
8 , x_msg_data OUT NOCOPY VARCHAR2
9 , p_org_id IN NUMBER
10 , p_trip_stop IN NUMBER
11 , x_stg_ln_id OUT NOCOPY NUMBER
12 , x_sub_code OUT NOCOPY VARCHAR2
13 );
14
15 FUNCTION get_available_staginglane
16 (
17 x_return_status OUT NOCOPY VARCHAR2
18 , x_msg_count OUT NOCOPY NUMBER
19 , x_msg_data OUT NOCOPY VARCHAR2
20 , p_trip_stop IN NUMBER
21 , p_dock_id IN NUMBER
22 )
23 RETURN NUMBER;
24
25 FUNCTION check_if_stagelane_assigned
26 (
27 x_return_status OUT NOCOPY VARCHAR2
28 , x_msg_count OUT NOCOPY NUMBER
29 , x_msg_data OUT NOCOPY VARCHAR2
30 , p_stg_lane_id IN NUMBER
31 , p_trip_stop IN NUMBER
32 , p_dock_id IN NUMBER
33 )
34 RETURN NUMBER;
35
36 FUNCTION get_earliest_available_stglane
37 (
38 p_dock_id IN NUMBER
39 )
40 RETURN NUMBER;
41
42 PROCEDURE check_dockdoor_tripstop_exists
43 (
44 x_return_status OUT NOCOPY VARCHAR2
45 , x_msg_count OUT NOCOPY NUMBER
46 , x_msg_data OUT NOCOPY VARCHAR2
47 , p_trip_stop IN NUMBER
48 , x_dock_id OUT NOCOPY NUMBER
49 , x_staging_lane_id OUT NOCOPY NUMBER
50 , x_dkdr_trpstp_exists OUT NOCOPY BOOLEAN
51 );
52
53 PROCEDURE update_staging_lane_id
54 (
55 x_return_status OUT NOCOPY VARCHAR2
56 , x_msg_count OUT NOCOPY NUMBER
57 , x_msg_data OUT NOCOPY VARCHAR2
58 , p_stage_lane_id IN NUMBER
59 , p_trip_stop IN NUMBER
60 , p_dock_id IN NUMBER
61 );
62
63 FUNCTION get_subinventory_code
64 (
65 x_return_status OUT NOCOPY VARCHAR2
66 , x_msg_count OUT NOCOPY NUMBER
67 , x_msg_data OUT NOCOPY VARCHAR2
68 , p_org_id IN NUMBER
69 , p_staging_lane_id IN NUMBER
70 )
71 RETURN VARCHAR2;
72
73
74 END WMS_TRIPSTOPS_STAGELANES_PUB;
75