[Home] [Help]
PACKAGE: APPS.WSH_TPA_DELIVERY_PKG
Source
1 PACKAGE WSH_TPA_DELIVERY_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHTPDES.pls 115.3 2002/11/12 01:55:42 nparikh ship $ */
3 --{
4 --
5 --
6 -- =================================================================
7 -- *** PLEASE DO NOT EDIT THIS FILE. ***
8 -- *** THIS FILE IS ALWAYS GENERATED BY TPA GENERATE UTILITY. ***
9 -- =================================================================
10 --
11 FUNCTION Check_Req_Date_Match
12 (
13 p_delivery_id IN NUMBER,
14 p_del_date IN DATE,
15 p_detail_date IN DATE
16 )
17 RETURN BOOLEAN;
18 --
19 --
20 FUNCTION Check_Sch_Date_Match
21 (
22 p_delivery_id IN NUMBER,
23 p_del_date IN DATE,
24 p_detail_date IN DATE
25 )
26 RETURN BOOLEAN;
27 --
28 --
29 PROCEDURE Check_Calendar
30 (
31 p_entity_type IN VARCHAR2,
32 p_entity_id IN NUMBER,
33 p_ship_date IN DATE,
34 p_ship_assoc_type IN VARCHAR2,
35 p_ship_location_id IN NUMBER,
36 p_freight_code IN VARCHAR2,
37 p_freight_org_id IN NUMBER,
38 p_receive_date IN DATE,
39 p_receive_assoc_type IN VARCHAR2,
40 p_receive_location_id IN NUMBER,
41 p_update_flag IN VARCHAR2,
42 x_return_status OUT NOCOPY VARCHAR2
43 );
44 --
45 --
46 PROCEDURE Check_Del_Final_Dest
47 (
48 p_delivery_id IN NUMBER,
49 p_final_dropoff_id IN NUMBER,
50 p_ultimate_dropoff_id IN NUMBER,
51 x_return_status OUT NOCOPY VARCHAR2
52 );
53 --
54 --
55 PROCEDURE Check_Del_Underfilled
56 (
57 p_delivery_id IN NUMBER,
58 p_cont_exists_flag IN BOOLEAN,
59 p_underfilled_flag IN BOOLEAN,
60 x_return_status OUT NOCOPY VARCHAR2
61 );
62 --
63 --
64 PROCEDURE Check_Del_Overfilled
65 (
66 p_delivery_id IN NUMBER,
67 p_cont_exists_flag IN BOOLEAN,
68 p_overfilled_flag IN BOOLEAN,
69 x_return_status OUT NOCOPY VARCHAR2
70 );
71 --
72 --
73 PROCEDURE Check_Del_Unpacked
74 (
75 p_delivery_id IN NUMBER,
76 p_cont_exists_flag IN BOOLEAN,
77 p_unpacked_flag IN BOOLEAN,
78 x_return_status OUT NOCOPY VARCHAR2
79 );
80 --
81 --
82 PROCEDURE Check_Released_Lines
83 (
84 p_delivery_id IN NUMBER,
85 rel_num IN NUMBER,
86 unrel_num IN NUMBER,
87 x_return_status OUT NOCOPY VARCHAR2
88 );
89 --
90 --
91 PROCEDURE Check_Del_Not_I_T
92 (
93 p_delivery_id IN NUMBER,
94 p_delivery_status IN VARCHAR2,
95 x_return_status OUT NOCOPY VARCHAR2
96 );
97 --
98 --
99 PROCEDURE Check_Arrival_Set
100 (
101 p_delivery_id IN NUMBER,
102 x_valid_flag OUT NOCOPY BOOLEAN,
103 x_return_status OUT NOCOPY VARCHAR2
104 );
105 --
106 --
107 PROCEDURE Check_Smc
108 (
109 p_delivery_id IN NUMBER,
110 x_valid_flag OUT NOCOPY BOOLEAN,
111 x_return_status OUT NOCOPY VARCHAR2
112 );
113 --
114 --
115 PROCEDURE Check_Ship_Set
116 (
117 p_delivery_id IN NUMBER,
118 x_valid_flag OUT NOCOPY BOOLEAN,
119 x_return_status OUT NOCOPY VARCHAR2
120 );
121 --
122 --
123 --
124 --}
125 END WSH_TPA_DELIVERY_PKG;
126 --