[Home] [Help]
PACKAGE: APPS.WSH_DELIVERY_LEGS_PVT
Source
1 PACKAGE WSH_DELIVERY_LEGS_PVT AUTHID CURRENT_USER as
2 /* $Header: WSHDGTHS.pls 120.1.12000000.1 2007/01/16 05:44:48 appldev ship $ */
3
4 --
5 -- Package type declarations
6 --
7
8 TYPE Delivery_Leg_Rec_Type IS RECORD (
9 DELIVERY_LEG_ID NUMBER,
10 DELIVERY_ID NUMBER,
11 SEQUENCE_NUMBER NUMBER,
12 LOADING_ORDER_FLAG VARCHAR2(2),
13 PICK_UP_STOP_ID NUMBER,
14 DROP_OFF_STOP_ID NUMBER,
15 GROSS_WEIGHT NUMBER,
16 NET_WEIGHT NUMBER,
17 WEIGHT_UOM_CODE VARCHAR2(3),
18 VOLUME NUMBER,
19 VOLUME_UOM_CODE VARCHAR2(3),
20 CREATION_DATE DATE,
21 CREATED_BY NUMBER,
22 LAST_UPDATE_DATE DATE,
23 LAST_UPDATED_BY NUMBER,
24 LAST_UPDATE_LOGIN NUMBER,
25 PROGRAM_APPLICATION_ID NUMBER,
26 PROGRAM_ID NUMBER,
27 PROGRAM_UPDATE_DATE DATE,
28 REQUEST_ID NUMBER,
29 LOAD_TENDER_STATUS VARCHAR2(1),
30 /* Changes for the Shipping Data Model Bug#1918342*/
31 SHIPPER_TITLE VARCHAR2(20),
32 SHIPPER_PHONE VARCHAR2(20),
33 POD_FLAG VARCHAR2(1),
34 POD_BY VARCHAR2(150),
35 POD_DATE DATE,
36 EXPECTED_POD_DATE DATE,
37 BOOKING_OFFICE VARCHAR2(50),
38 SHIPPER_EXPORT_REF VARCHAR2(30),
39 CARRIER_EXPORT_REF VARCHAR2(30),
40 DOC_NOTIFY_PARTY VARCHAR2(30),
41 AETC_NUMBER VARCHAR2(30),
42 SHIPPER_SIGNED_BY VARCHAR2(150),
43 SHIPPER_DATE DATE,
44 CARRIER_SIGNED_BY VARCHAR2(150),
45 CARRIER_DATE DATE,
46 DOC_ISSUE_OFFICE VARCHAR2(150),
47 DOC_ISSUED_BY VARCHAR2(150),
48 DOC_DATE_ISSUED DATE,
49 SHIPPER_HM_BY VARCHAR2(150),
50 SHIPPER_HM_DATE DATE,
51 CARRIER_HM_BY VARCHAR2(150),
52 CARRIER_HM_DATE DATE,
53 BOOKING_NUMBER VARCHAR2(30),
54 PORT_OF_LOADING VARCHAR2(150),
55 PORT_OF_DISCHARGE VARCHAR2(150),
56 SERVICE_CONTRACT VARCHAR2(30),
57 BILL_FREIGHT_TO VARCHAR2(1000),
58 /* H Integration: datamodel changes wrudge */
59 FTE_TRIP_ID NUMBER,
60 REPRICE_REQUIRED VARCHAR2(1),
61 ACTUAL_ARRIVAL_DATE DATE,
62 ACTUAL_DEPARTURE_DATE DATE,
63 ACTUAL_RECEIPT_DATE DATE,
64 TRACKING_DRILLDOWN_FLAG VARCHAR2(1),
65 STATUS_CODE VARCHAR2(30),
66 TRACKING_REMARKS VARCHAR2(4000),
67 CARRIER_EST_DEPARTURE_DATE DATE,
68 CARRIER_EST_ARRIVAL_DATE DATE,
69 LOADING_START_DATETIME DATE,
70 LOADING_END_DATETIME DATE,
71 UNLOADING_START_DATETIME DATE,
72 UNLOADING_END_DATETIME DATE,
73 DELIVERED_QUANTITY NUMBER,
74 LOADED_QUANTITY NUMBER,
75 RECEIVED_QUANTITY NUMBER,
76 ORIGIN_STOP_ID NUMBER,
77 DESTINATION_STOP_ID NUMBER,
78 /* Harmonizination project **heali */
79 ROWID VARCHAR2(4000),
80 /* K: MDC: sperera */
81 PARENT_DELIVERY_LEG_ID NUMBER
82
83 );
84
85 --
86 -- Procedure: Create_Delivery_Leg
87 -- Parameters: All Attributes of a Delivery Leg Record
88 -- Description: This procedure will create a delivery leg. It will
89 -- return to the user the delivery_leg_id.
90 -- This is a table handler style procedure and no additional
91 -- validations are provided.
92 --
93
94 PROCEDURE Create_Delivery_Leg (
95 p_delivery_leg_info IN Delivery_Leg_Rec_Type,
96 x_rowid OUT NOCOPY VARCHAR2,
97 x_delivery_leg_id OUT NOCOPY NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2);
99
100
101 --
102 -- Procedure: Update_Delivery_Leg
103 -- Parameters: All Attributes of a Delivery Leg Record
104 -- Description: This procedure will update attributes of a delivery leg.
105 -- This is a table handler style procedure and no additional
106 -- validations are provided.
107 --
108
109 PROCEDURE Update_Delivery_Leg(
110 p_rowid IN VARCHAR2 := NULL,
111 p_delivery_leg_info IN Delivery_Leg_Rec_Type,
112 x_return_status OUT NOCOPY VARCHAR2);
113
114
115
116 --
117 -- Procedure: Delete_Delivery_Leg
118 -- Parameters: All Attributes of a Delivery Leg Record
119 -- Description: This procedure will delete a delivery Leg.
120 -- The order in which it looks at the parameters
121 -- are:
122 -- - p_rowid
123 -- - p_delivery_leg_id
124 -- This is a table handler style procedure and no additional
125 -- validations are provided.
126 --
127
128 PROCEDURE Delete_Delivery_Leg (
129 p_rowid IN VARCHAR2 := NULL,
130 p_delivery_leg_id IN NUMBER := NULL,
131 x_return_status OUT NOCOPY VARCHAR2
132 );
133
134
135
136 --
137 -- Procedure: Lock_Delivery_Leg
138 -- Parameters: Delivery_Leg rowid, Delivery Leg Record and return_status
139 -- Description: This procedure will lock a delivery leg row.
140 --
141
142 PROCEDURE Lock_Delivery_Leg(
143 p_rowid IN VARCHAR2,
144 p_delivery_leg_info IN delivery_leg_rec_type
145 );
146
147
148 --
149 -- Procedure: Populate_Record
150 -- Parameters: Delivery_leg_id as IN, Delivery Leg record and status as OUT
151 -- Description: This procedure will populate a stop record
152 --
153
154 PROCEDURE Populate_Record (
155 p_delivery_leg_id IN NUMBER,
156 x_delivery_leg_info OUT NOCOPY Delivery_Leg_Rec_Type,
157 x_return_status OUT NOCOPY VARCHAR2);
158
159 -----------------------------------------------------------------------------
160 --
161 -- Procedure: Get_Disabled_List
162 -- Parameters: stop_id, x_return_status, p_trip_flag
163 -- Description: Get the disabled columns/fields in a delivery leg
164 --
165 -----------------------------------------------------------------------------
166
167 PROCEDURE Get_Disabled_List (
168 p_delivery_leg_id IN NUMBER,
169 p_parent_entity_id IN NUMBER ,
170 p_list_type IN VARCHAR2,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_disabled_list OUT NOCOPY wsh_util_core.column_tab_type,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2
175 );
176
177 /* ---------------------------------------------------------------------
178 Procedure: Lock_Dlvy_Leg_no_compare
179
180 Parameters: Delivery_Leg Id DEFAULT NULL
181 Delivery Id DEFAULT NULL
182
183 Description: This procedure is used for obtaining locks of delivery legs
184 using the delivery_leg_id or the delivery_id.
185 It is called by delivery's wrapper lock API when the
186 action is CONFIRM.
187 This procedure does not compare the attributes. It just
188 does a SELECT using FOR UPDATE NOWAIT
189 Created: Harmonization Project. Patchset I
190 ----------------------------------------------------------------------- */
191
192
193 PROCEDURE lock_dlvy_leg_no_compare(
194 p_dlvy_leg_id IN NUMBER DEFAULT NULL,
195 p_delivery_id IN NUMBER DEFAULT NULL);
196
197
198 END WSH_DELIVERY_LEGS_PVT;