[Home] [Help]
PACKAGE: APPS.FTE_WSH_TRIPS_PVT
Source
1 PACKAGE FTE_WSH_TRIPS_PVT AUTHID CURRENT_USER AS
2 /* $Header: FTEFWTHS.pls 115.7 2002/12/03 21:49:33 hbhagava noship $ */
3
4 c_sdebug CONSTANT NUMBER := wsh_debug_sv.c_level1;
5 c_debug CONSTANT NUMBER := wsh_debug_sv.c_level2;
6
7 --
8 -- Type: Trip_Rectype
9 -- Definition: In sync with the table definition for trips
10 -- Use: In table handlers, calling packages
11
12
13 TYPE fte_wsh_trip_rec_type IS RECORD (
14 FTE_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
15 WSH_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
16 SEQUENCE_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
17 CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
18 CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
19 LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
20 LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
21 LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
22 PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23 PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24 PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
25 REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
26 ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
27 ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
28 ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
29 ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
30 ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
31 ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32 ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33 ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34 ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35 ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36 ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37 ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38 ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39 ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40 ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41 ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
42 );
43
44
45 --
46 -- Procedure: Validate_Trip
47 -- Parameters: p_trip_info Trip Record info
48 -- p_action_code 'CREATE' or 'UPDATE'
49 -- x_return_status return_status
50 -- Description: This procedure will validate a fte_wsh_trip.
51 --
52
53 PROCEDURE Validate_Trip
54 (
55 p_trip_info IN fte_wsh_trip_rec_type,
56 p_action_code IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2
58 );
59
60 --
61 -- Procedure: Create_Trip
62 -- Parameters: p_trip_info Trip Record info
63 -- x_return_status return_status
64 -- Description: This procedure will create a fte_wsh_trip.
65 --
66
67 PROCEDURE Create_Trip
68 (
69 p_trip_info IN fte_wsh_trip_rec_type,
70 x_return_status OUT NOCOPY VARCHAR2
71 );
72
73 --
74 -- Procedure: Update_Trip
75 -- Parameters: p_trip_info Trip Record info
76 -- p_validate_flag 'Y' validate before update
77 -- x_return_status return_status
78 -- Description: This procedure will update a fte_wsh_trip.
79 --
80
81 PROCEDURE Update_Trip
82 (
83 p_trip_info IN fte_wsh_trip_rec_type,
84 p_validate_flag IN VARCHAR2 DEFAULT 'Y',
85 x_return_status OUT NOCOPY VARCHAR2
86 );
87
88 --
89 -- Procedure: Delete_Trip
90 -- Parameters: p_fte_trip_id
91 -- p_wsh_trip_id
92 -- x_return_status return_status
93 -- Description: This procedure will create a fte_wsh_trip.
94 --
95
96 PROCEDURE Validate_Trip_For_Delete
97 (
98 P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99 p_fte_trip_id IN NUMBER,
100 p_wsh_trip_id IN NUMBER,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 x_return_status OUT NOCOPY VARCHAR2
104 );
105
106 --
107 -- Procedure: Delete_Trip
108 -- Parameters: p_fte_trip_id
109 -- p_wsh_trip_id
110 -- x_return_status return_status
111 -- Description: This procedure will create a fte_wsh_trip.
112 --
113
114 PROCEDURE Delete_Trip
115 (
116 P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
117 p_fte_trip_id IN NUMBER,
118 p_wsh_trip_id IN NUMBER,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 x_return_status OUT NOCOPY VARCHAR2
122 );
123
124 --
125 -- Procedure: Create_Update_Trip
126 -- Description: Wrapper around Create_Trip and Update_Trip
127 -- depends on the p_action_code 'CREATE' or 'UPDATE'
128 --
129
130 PROCEDURE Validate_Trip_Wrapper
131 (
132 pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
133 pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
134 pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
135 pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
136 pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
137 pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
138 pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
139 pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
140 pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
141 pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
142 pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
143 pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
144 pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
145 pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
146 pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
147 pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
148 pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
149 pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
150 pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
151 pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
152 pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
153 pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
154 pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
155 pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
156 pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
157 pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
158 pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
159 pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
160 P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
161 p_action_code IN VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 x_return_status OUT NOCOPY VARCHAR2
165 );
166
167 --
168 -- Procedure: Create_Update_Trip_Wrapper
169 -- Description: Wrapper around Create_Trip and Update_Trip
170 -- depends on the p_action_code 'CREATE' or 'UPDATE'
171 --
172
173 PROCEDURE Create_Update_Trip_Wrapper
174 (
175 pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176 pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
177 pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
178 pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
179 pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
180 pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
181 pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
182 pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
183 pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
184 pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
185 pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
186 pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
187 pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
188 pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
189 pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
190 pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
191 pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
192 pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
193 pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
194 pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
195 pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
196 pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
197 pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
198 pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
199 pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200 pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
201 pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
202 pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
203 P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
204 p_action_code IN VARCHAR2,
205 p_validate_flag IN VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 x_return_status OUT NOCOPY VARCHAR2
209 );
210
211 END fte_wsh_trips_pvt;