[Home] [Help]
PACKAGE: APPS.FTE_CARRIER_RANK_LIST_PVT
Source
1 PACKAGE FTE_CARRIER_RANK_LIST_PVT AUTHID CURRENT_USER AS
2 /* $Header: FTECLTHS.pls 120.2 2005/06/23 16:17:57 appldev noship $ */
3
4 c_sdebug CONSTANT NUMBER := wsh_debug_sv.c_level1;
5 c_debug CONSTANT NUMBER := wsh_debug_sv.c_level2;
6
7 S_CREATE CONSTANT VARCHAR2(30) := 'CREATE';
8 S_UPDATE CONSTANT VARCHAR2(30) := 'UPDATE';
9 S_DELETE CONSTANT VARCHAR2(30) := 'DELETE';
10 S_SET_CURRENT CONSTANT VARCHAR2(30) := 'SET_CURRENT';
11 S_APPEND CONSTANT VARCHAR2(30) := 'APPEND';
12 S_REPLACE CONSTANT VARCHAR2(30) := 'REPLACE';
13 S_GET CONSTANT VARCHAR2(30) := 'GET';
14
15 S_SOURCE_RG CONSTANT VARCHAR2(30) := 'RG';
16 S_SOURCE_UI CONSTANT VARCHAR2(30) := 'MAN';
17 S_SOURCE_LCSS CONSTANT VARCHAR2(30) := 'LCSS';
18 S_SOURCE_TP CONSTANT VARCHAR2(30) := 'TP';
19
20 --
21 -- Procedure: RANK_LIST_ACTION
22 -- Parameters: Move Record info; rowid, move_id, name, return_status as OUT
23 -- Description: This procedure will create a move. It will
24 -- return to the user the move_id and generates a name if
25 -- move name is not specified.
26 --
27
28 TYPE carrier_rank_list_rec IS RECORD (
29 RANK_ID NUMBER ,
30 TRIP_ID NUMBER ,
31 RANK_SEQUENCE NUMBER ,
32 CARRIER_ID NUMBER,
33 SERVICE_LEVEL VARCHAR2(30),
34 MODE_OF_TRANSPORT VARCHAR2(30),
35 LANE_ID NUMBER,
36 SOURCE VARCHAR2(30),
37 ENABLED VARCHAR2(1),
38 ESTIMATED_RATE NUMBER,
39 CURRENCY_CODE VARCHAR2(15),
40 VEHICLE_ITEM_ID NUMBER,
41 ESTIMATED_TRANSIT_TIME NUMBER,
42 TRANSIT_TIME_UOM VARCHAR2(3),
43 VERSION NUMBER,
44 CONSIGNEE_CARRIER_AC_NO VARCHAR2(240),
45 FREIGHT_TERMS_CODE VARCHAR2(30),
46 INITSMCONFIG VARCHAR2(3),
47 ATTRIBUTE_CATEGORY VARCHAR2(150),
48 ATTRIBUTE1 VARCHAR2(150),
49 ATTRIBUTE2 VARCHAR2(150),
50 ATTRIBUTE3 VARCHAR2(150),
51 ATTRIBUTE4 VARCHAR2(150),
52 ATTRIBUTE5 VARCHAR2(150),
53 ATTRIBUTE6 VARCHAR2(150),
54 ATTRIBUTE7 VARCHAR2(150),
55 ATTRIBUTE8 VARCHAR2(150),
56 ATTRIBUTE9 VARCHAR2(150),
57 ATTRIBUTE10 VARCHAR2(150),
58 ATTRIBUTE11 VARCHAR2(150),
59 ATTRIBUTE12 VARCHAR2(150),
60 ATTRIBUTE13 VARCHAR2(150),
61 ATTRIBUTE14 VARCHAR2(150),
62 ATTRIBUTE15 VARCHAR2(150),
63 CREATION_DATE DATE ,
64 CREATED_BY NUMBER ,
65 LAST_UPDATE_DATE DATE ,
66 LAST_UPDATED_BY NUMBER ,
67 LAST_UPDATE_LOGIN NUMBER,
68 IS_CURRENT VARCHAR(1),
69 SINGLE_CURR_RATE NUMBER,
70 SORT VARCHAR2(2),
71 SCHEDULE_FROM DATE,
72 SCHEDULE_TO DATE,
73 SCHEDULE_ID NUMBER,
74 VEHICLE_ORG_ID NUMBER,
75 CALL_RG_FLAG VARCHAR2(1));
76
77 TYPE carrier_rank_list_tbl_type is TABLE of carrier_rank_list_rec index by binary_integer;
78
79 TYPE NUMBER_TAB IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
80 TYPE DATE_TAB IS TABLE OF DATE INDEX BY BINARY_INTEGER;
81 TYPE VARCHAR2_150TAB IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
82 TYPE VARCHAR2_30TAB IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
83
84 -- For bulk operations
85 TYPE ENABLED_TAB IS TABLE OF FTE_CARRIER_RANK_LIST.ENABLED%TYPE INDEX BY BINARY_INTEGER;
86 TYPE CURRENCY_CODE_TAB IS TABLE OF FTE_CARRIER_RANK_LIST.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
87 TYPE TRANSIT_TIME_UOM_TAB IS TABLE OF FTE_CARRIER_RANK_LIST.TRANSIT_TIME_UOM%TYPE INDEX BY BINARY_INTEGER;
88 TYPE INITSMCONFIG_TAB IS TABLE OF FTE_CARRIER_RANK_LIST.INITSMCONFIG%TYPE INDEX BY BINARY_INTEGER;
89 TYPE IS_CURRENT_TAB IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
90 TYPE SORT_TAB IS TABLE OF VARCHAR2(2) INDEX BY BINARY_INTEGER;
91 TYPE CALL_RG_FLAG_TAB IS TABLE OF FTE_CARRIER_RANK_LIST.CALL_RG_FLAG%TYPE INDEX BY BINARY_INTEGER;
92
93
94 TYPE carrier_rank_list_bulk_rec IS RECORD (
95 RANK_ID NUMBER_TAB,
96 TRIP_ID NUMBER_TAB,
97 RANK_SEQUENCE NUMBER_TAB,
98 CARRIER_ID NUMBER_TAB,
99 SERVICE_LEVEL VARCHAR2_30TAB,
100 MODE_OF_TRANSPORT VARCHAR2_30TAB,
101 LANE_ID NUMBER_TAB,
102 SOURCE VARCHAR2_30TAB,
103 ESTIMATED_RATE NUMBER_TAB,
104 CURRENCY_CODE CURRENCY_CODE_TAB,
105 VEHICLE_ITEM_ID NUMBER_TAB,
106 ESTIMATED_TRANSIT_TIME NUMBER_TAB,
107 TRANSIT_TIME_UOM TRANSIT_TIME_UOM_TAB,
108 CONSIGNEE_CARRIER_AC_NO NUMBER_TAB,
109 FREIGHT_TERMS_CODE VARCHAR2_30TAB,
110 ATTRIBUTE_CATEGORY VARCHAR2_150TAB,
111 ATTRIBUTE1 VARCHAR2_150TAB,
112 ATTRIBUTE2 VARCHAR2_150TAB,
113 ATTRIBUTE3 VARCHAR2_150TAB,
114 ATTRIBUTE4 VARCHAR2_150TAB,
115 ATTRIBUTE5 VARCHAR2_150TAB,
116 ATTRIBUTE6 VARCHAR2_150TAB,
117 ATTRIBUTE7 VARCHAR2_150TAB,
118 ATTRIBUTE8 VARCHAR2_150TAB,
119 ATTRIBUTE9 VARCHAR2_150TAB,
120 ATTRIBUTE10 VARCHAR2_150TAB,
121 ATTRIBUTE11 VARCHAR2_150TAB,
122 ATTRIBUTE12 VARCHAR2_150TAB,
123 ATTRIBUTE13 VARCHAR2_150TAB,
124 ATTRIBUTE14 VARCHAR2_150TAB,
125 ATTRIBUTE15 VARCHAR2_150TAB,
126 SCHEDULE_FROM DATE_TAB,
127 SCHEDULE_TO DATE_TAB,
128 SCHEDULE_ID NUMBER_TAB,
129 VEHICLE_ORG_ID NUMBER_TAB,
130 CALL_RG_FLAG CALL_RG_FLAG_TAB);
131
132
133 -- Global Cursor
134 PROCEDURE CREATE_RANK_LIST_BULK(
135 p_api_version_number IN NUMBER,
136 p_init_msg_list IN VARCHAR2,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_ranklist IN OUT NOCOPY carrier_rank_list_bulk_rec);
141
142
143
144 PROCEDURE RANK_LIST_ACTION(
145 p_api_version_number IN NUMBER,
146 p_init_msg_list IN VARCHAR2,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_action_code IN VARCHAR2,
151 p_ranklist IN OUT NOCOPY carrier_rank_list_tbl_type,
152 p_trip_id IN NUMBER,
153 p_rank_id IN NUMBER);
154
155 PROCEDURE RANK_LIST_ACTION_UIWRAPPER(
156 p_api_version_number IN NUMBER,
157 p_init_msg_list IN VARCHAR2,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_action_code IN VARCHAR2,
162 p_ranklist IN OUT NOCOPY FTE_SS_RATE_SORT_TAB_TYPE,
163 p_trip_id IN NUMBER,
164 p_rank_id IN NUMBER);
165
166 PROCEDURE DELETE_RANK_LIST_UIWRAPPER(
167 p_api_version_number IN NUMBER,
168 p_init_msg_list IN VARCHAR2,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_trip_id IN FTE_ID_TAB_TYPE);
173
174
175 PROCEDURE GET_RANK_DETAILS(
176 p_init_msg_list IN VARCHAR2,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 x_rankdetails OUT NOCOPY carrier_rank_list_rec,
181 p_rank_id IN NUMBER);
182
183 PROCEDURE GET_RANK_LIST(
184 p_init_msg_list IN VARCHAR2,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 x_ranklist OUT NOCOPY carrier_rank_list_tbl_type,
189 p_trip_id IN NUMBER);
190
191 PROCEDURE IS_RANK_LIST_EXHAUSTED(
192 p_init_msg_list IN VARCHAR2,
193 x_is_exhausted OUT NOCOPY VARCHAR2,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_trip_id IN NUMBER);
198
199
200 PROCEDURE REMOVE_SERVICE_APPLY_NEXT(
201 p_init_msg_list IN VARCHAR2,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_trip_id IN NUMBER,
206 p_price_request_id IN NUMBER);
207
208
209 PROCEDURE PRINT_RANK_LIST(p_trip_id IN NUMBER);
210
211
212 END FTE_CARRIER_RANK_LIST_PVT;
213
214