[Home] [Help]
PACKAGE: APPS.WSH_TRIPS_PVT
Source
1 PACKAGE WSH_TRIPS_PVT AUTHID CURRENT_USER AS
2 /* $Header: WSHTRTHS.pls 120.0.12000000.1 2007/01/16 05:51:45 appldev ship $ */
3
4 --
5 -- Type: Trip_Rectype
6 -- Definition: In sync with the table definition for trips
7 -- Use: In table handlers, calling packages
8
9
10 TYPE trip_rec_type IS RECORD (
11 TRIP_ID NUMBER,
12 NAME VARCHAR2(30),
13 PLANNED_FLAG VARCHAR2(1),
14 ARRIVE_AFTER_TRIP_ID NUMBER,
15 STATUS_CODE VARCHAR2(2),
16 VEHICLE_ITEM_ID NUMBER,
17 VEHICLE_ORGANIZATION_ID NUMBER,
18 VEHICLE_NUMBER VARCHAR2(30),
19 VEHICLE_NUM_PREFIX VARCHAR2(10),
20 CARRIER_ID NUMBER,
21 SHIP_METHOD_CODE VARCHAR2(30),
22 ROUTE_ID NUMBER,
23 ROUTING_INSTRUCTIONS VARCHAR2(2000),
24 ATTRIBUTE_CATEGORY VARCHAR2(150),
25 ATTRIBUTE1 VARCHAR2(150),
26 ATTRIBUTE2 VARCHAR2(150),
27 ATTRIBUTE3 VARCHAR2(150),
28 ATTRIBUTE4 VARCHAR2(150),
29 ATTRIBUTE5 VARCHAR2(150),
30 ATTRIBUTE6 VARCHAR2(150),
31 ATTRIBUTE7 VARCHAR2(150),
32 ATTRIBUTE8 VARCHAR2(150),
33 ATTRIBUTE9 VARCHAR2(150),
34 ATTRIBUTE10 VARCHAR2(150),
35 ATTRIBUTE11 VARCHAR2(150),
36 ATTRIBUTE12 VARCHAR2(150),
37 ATTRIBUTE13 VARCHAR2(150),
38 ATTRIBUTE14 VARCHAR2(150),
39 ATTRIBUTE15 VARCHAR2(150),
40 CREATION_DATE DATE,
41 CREATED_BY NUMBER,
42 LAST_UPDATE_DATE DATE,
43 LAST_UPDATED_BY NUMBER,
44 LAST_UPDATE_LOGIN NUMBER,
45 PROGRAM_APPLICATION_ID NUMBER,
46 PROGRAM_ID NUMBER,
47 PROGRAM_UPDATE_DATE DATE,
48 REQUEST_ID NUMBER,
49 /* H Integration: datamodel changes wrudge */
50 SERVICE_LEVEL VARCHAR2(30),
51 MODE_OF_TRANSPORT VARCHAR2(30),
52 FREIGHT_TERMS_CODE VARCHAR2(30),
53 CONSOLIDATION_ALLOWED VARCHAR2(1),
54 /* I WSH-FTE Integration , update to 30 */
55 LOAD_TENDER_STATUS VARCHAR2(30),
56 ROUTE_LANE_ID NUMBER,
57 LANE_ID NUMBER,
58 SCHEDULE_ID NUMBER,
59 BOOKING_NUMBER VARCHAR2(30),
60 /* I Harmonization: Non Database Columns Added rvishnuv */
61 ROWID VARCHAR2(4000),
62 ARRIVE_AFTER_TRIP_NAME VARCHAR2(30),
63 SHIP_METHOD_NAME VARCHAR2(240),
64 VEHICLE_ITEM_DESC VARCHAR2(240),
65 VEHICLE_ORGANIZATION_CODE VARCHAR2(3),
66 /* I WSH-FTE LOAD TENDER Integration */
67 LOAD_TENDER_NUMBER NUMBER,
68 VESSEL VARCHAR2(100),
69 VOYAGE_NUMBER VARCHAR2(100),
70 PORT_OF_LOADING VARCHAR2(240),
71 PORT_OF_DISCHARGE VARCHAR2(240),
72 WF_NAME VARCHAR2(8),
73 WF_PROCESS_NAME VARCHAR2(30),
74 WF_ITEM_KEY VARCHAR2(240),
75 CARRIER_CONTACT_ID NUMBER,
76 SHIPPER_WAIT_TIME NUMBER,
77 WAIT_TIME_UOM VARCHAR2(3),
78 LOAD_TENDERED_TIME DATE,
79 CARRIER_RESPONSE VARCHAR2(2000),
80 /* J Inbound Logistics new columns jckwok */
81 SHIPMENTS_TYPE_FLAG VARCHAR2(30),
82 /* J TP Release : ttrichy */
83 IGNORE_FOR_PLANNING VARCHAR2(1),
84 TP_PLAN_NAME VARCHAR2(10),
85 TP_TRIP_NUMBER NUMBER,
86 SEAL_CODE VARCHAR2(30),
87 OPERATOR VARCHAR2(150),
88 /* R12 attributes */
89 CARRIER_REFERENCE_NUMBER VARCHAR2(30),
90 RANK_ID NUMBER,
91 CONSIGNEE_CARRIER_AC_NO VARCHAR2(240),
92 ROUTING_RULE_ID NUMBER,
93 APPEND_FLAG VARCHAR2(1)
94 );
95
96
97 TYPE Trip_Attr_Tbl_Type is TABLE of trip_rec_type index by binary_integer;
98 --
99 -- Procedure: Create_Trip
100 -- Parameters: Trip Record info; rowid, trip_id, name, return_status as OUT
101 -- Description: This procedure will create a trip. It will
102 -- return to the use the trip_id and generates a name if
103 -- trip name is not specified.
104 --
105
106 PROCEDURE Create_Trip(
107 p_trip_info IN trip_rec_type,
108 x_rowid OUT NOCOPY VARCHAR2,
109 x_trip_id OUT NOCOPY NUMBER,
110 x_name OUT NOCOPY VARCHAR2,
111 x_return_status OUT NOCOPY VARCHAR2
112 );
113
114 --
115 -- Procedure: Delete_Trip
116 -- Parameters: Row_id, trip_id, return_status and validate_flag
117 -- Description: This procedure will delete a trip. If rowid is not null
118 -- trip_id is found, and trip_id is used to delete trip.
119 -- validate_flag - 'Y' means check_delete_trip is called
120 --
121
122 procedure Delete_Trip(
123 p_rowid IN VARCHAR2,
124 p_trip_id IN NUMBER,
125 x_return_status OUT NOCOPY VARCHAR2,
126 p_validate_flag IN VARCHAR2 DEFAULT 'Y',
127 p_caller IN VARCHAR2 DEFAULT NULL
128 );
129
130
131 --
132 -- Procedure: Update_Trip
133 -- Parameters: Trip rowid, Trip Record info and return_status
134 -- Description: This procedure will update a trip.
135 --
136
137 procedure Update_Trip(
138 p_rowid IN VARCHAR2,
139 p_trip_info IN trip_rec_type,
140 x_return_status OUT NOCOPY VARCHAR2
141 );
142
143 --
144 -- Procedure: Lock_Trip
145 -- Parameters: Trip rowid, Trip Record info and return_status
146 -- Description: This procedure will lock a trip row.
147 --
148
149 procedure Lock_Trip(
150 p_rowid IN VARCHAR2,
151 p_trip_info IN trip_rec_type
152 );
153
154 --
155 -- Procedure: Populate_Record
156 -- Parameters: Trip id as IN, Trip Record info and return status as OUT
157 -- Description: This procedure will populate a Trip Record.
158 --
159
160 procedure Populate_Record(
161 p_trip_id IN NUMBER,
162 x_trip_info OUT NOCOPY trip_rec_type,
163 x_return_status OUT NOCOPY VARCHAR2);
164
165
166 --
167 -- Function: Get_Name
168 -- Parameters: p_trip_id - Id for trip
169 -- Description: This procedure will return Trip Name for a Trip Id
170 --
171
172 FUNCTION Get_Name
173 (p_trip_id IN NUMBER
174 ) RETURN VARCHAR2;
175
176
177 --
178 -- Procedure: Lock_Trip Wrapper
179 -- Parameters: A table of all Attributes of a Trip Record,
180 -- Caller in
181 -- Return_Status,Valid_index_id_tab out
182 -- Description: This procedure will lock multiple Trips.
183
184 procedure Lock_Trip(
185 p_rec_attr_tab IN Trip_Attr_Tbl_Type,
186 p_caller IN VARCHAR2,
187 p_valid_index_tab IN wsh_util_core.id_tab_type,
188 x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,
189 x_return_status OUT NOCOPY VARCHAR2
190 );
191
192 PROCEDURE lock_trip_no_compare (p_trip_id IN NUMBER);
193
194 END WSH_TRIPS_PVT;