[Home] [Help]
121: -- OUT parameters:
122: -- 1. x_status: status, -1 if no error(1 wrong number, 2 wrong column, 3 no such type)
123: -- 2. x_error_msg: error message if status <> -1
124: ----------------------------------------------------------------------------
125: PROCEDURE VALIDATE_COLUMNS (p_keys IN FTE_BULKLOAD_PKG.block_header_tbl,
126: p_type IN VARCHAR2,
127: p_line_number IN NUMBER,
128: x_status OUT NOCOPY NUMBER,
129: x_error_msg OUT NOCOPY VARCHAR2);
142: -- carrier_id, price_prefix, view_flag, start_date, and end_date
143: -- 2. x_status: status of the processing, -1 means no error
144: -- 3. x_error_msg: error message if any.
145: ----------------------------------------------------------------------------
146: PROCEDURE VALIDATE_RATING_ZONE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
147: p_line_number IN NUMBER,
148: p_chart_info OUT NOCOPY STRINGARRAY,
149: x_status OUT NOCOPY NUMBER,
150: x_error_msg OUT NOCOPY VARCHAR2);
163: -- 2. p_last_service_type: last line's service type
164: -- 3. x_status: status of the processing, -1 means no error
165: -- 4. x_error_msg: error message if any.
166: ----------------------------------------------------------------------------
167: PROCEDURE VALIDATE_RATING_SETUP(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
168: p_line_number IN NUMBER,
169: p_setup_info IN OUT NOCOPY FTE_BULKLOAD_PKG.array_tbl,
170: p_last_service_type IN OUT NOCOPY VARCHAR2,
171: x_status OUT NOCOPY NUMBER,
165: -- 4. x_error_msg: error message if any.
166: ----------------------------------------------------------------------------
167: PROCEDURE VALIDATE_RATING_SETUP(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
168: p_line_number IN NUMBER,
169: p_setup_info IN OUT NOCOPY FTE_BULKLOAD_PKG.array_tbl,
170: p_last_service_type IN OUT NOCOPY VARCHAR2,
171: x_status OUT NOCOPY NUMBER,
172: x_error_msg OUT NOCOPY VARCHAR2);
173:
184: -- 1. p_origin: STRINGARRAY of origin_postal, origin_country, origin_state, and origin_city
185: -- 2. x_status: status of the processing, -1 means no error
186: -- 3. x_error_msg: error message if any.
187: ----------------------------------------------------------------------------
188: PROCEDURE VALIDATE_ORIGIN(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
189: p_line_number IN NUMBER,
190: p_origin OUT NOCOPY STRINGARRAY,
191: x_status OUT NOCOPY NUMBER,
192: x_error_msg OUT NOCOPY VARCHAR2);
209: -- 1. p_dest: STRINGARRAY of dest_postal, dest_country, dest_state, and dest_city
210: -- 2. x_status: status of the processing, -1 means no error
211: -- 3. x_error_msg: error message if any.
212: ----------------------------------------------------------------------------
213: PROCEDURE VALIDATE_DESTINATION(p_values IN OUT NOCOPY FTE_BULKLOAD_PKG.data_values_tbl,
214: p_line_number IN NUMBER,
215: p_price_prefix IN VARCHAR2,
216: p_carrier_id IN NUMBER,
217: p_origin_zone IN FTE_BULKLOAD_PKG.data_values_tbl,
213: PROCEDURE VALIDATE_DESTINATION(p_values IN OUT NOCOPY FTE_BULKLOAD_PKG.data_values_tbl,
214: p_line_number IN NUMBER,
215: p_price_prefix IN VARCHAR2,
216: p_carrier_id IN NUMBER,
217: p_origin_zone IN FTE_BULKLOAD_PKG.data_values_tbl,
218: p_service_count IN OUT NOCOPY NUMBER,
219: p_services IN OUT NOCOPY FTE_PARCEL_LOADER.service_array,
220: p_dest OUT NOCOPY STRINGARRAY,
221: x_status OUT NOCOPY NUMBER,
239: -- 6. p_lane_commodity_tbl: pl/sql table for lane commodity
240: -- 7. x_status: status of the processing, -1 means no error
241: -- 8. x_error_msg: error message if any.
242: ----------------------------------------------------------------------------
243: PROCEDURE VALIDATE_SERVICE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
244: p_line_number IN NUMBER,
245: p_type OUT NOCOPY VARCHAR2,
246: p_action OUT NOCOPY VARCHAR2,
247: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
269: -- 5. p_action: action value of the line
270: -- 6. x_status: status of the processing, -1 means no error
271: -- 7. x_error_msg: error message if any.
272: ----------------------------------------------------------------------------
273: PROCEDURE VALIDATE_SERVICE_RATING_SETUP(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
274: p_line_number IN NUMBER,
275: p_pre_lane_number IN VARCHAR2,
276: p_prc_parameter_tbl IN OUT NOCOPY FTE_LANE_PKG.prc_parameter_tbl,
277: p_deficit_wt IN OUT NOCOPY BOOLEAN,
295: -- 2. p_action: action value of the line
296: -- 3. x_status: status of the processing, -1 means no error
297: -- 4. x_error_msg: error message if any.
298: ----------------------------------------------------------------------------
299: PROCEDURE VALIDATE_SCHEDULE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
300: p_line_number IN NUMBER,
301: p_schedule_tbl IN OUT NOCOPY FTE_LANE_PKG.schedule_tbl,
302: p_action OUT NOCOPY VARCHAR2,
303: x_status OUT NOCOPY NUMBER,
323: -- 4. p_carrier_id: carrier id
324: -- 4. x_status: status of the processing, -1 means no error
325: -- 5. x_error_msg: error message if any.
326: -----------------------------------------------------------------------------
327: PROCEDURE VALIDATE_RATE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
328: p_line_number IN NUMBER,
329: p_validate IN BOOLEAN DEFAULT TRUE,
330: p_process_id IN NUMBER default null,
331: p_qp_list_header_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_list_header_tbl,
352: -- 2. p_qp_pricing_attrib_tbl: pl/sql table for the attributes
353: -- 3. x_status: status of the processing, -1 means no error
354: -- 4. x_error_msg: error message if any.
355: -----------------------------------------------------------------------------
356: PROCEDURE VALIDATE_RATE_LINE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
357: p_line_number IN NUMBER,
358: p_validate IN BOOLEAN DEFAULT TRUE,
359: p_qp_list_line_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_list_line_tbl,
360: p_qp_pricing_attrib_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl,
378: -- 2. p_qp_pricing_attrib_tbl: pl/sql table for the attributes
379: -- 3. x_status: status of the processing, -1 means no error
380: -- 4. x_error_msg: error message if any.
381: -----------------------------------------------------------------------------
382: PROCEDURE VALIDATE_RATE_BREAK(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
383: p_line_number IN NUMBER,
384: p_validate IN BOOLEAN DEFAULT TRUE,
385: p_qp_list_line_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_list_line_tbl,
386: p_qp_pricing_attrib_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl,
402: -- 1. p_qp_pricing_attrib_tbl: pl/sql table for the attributes
403: -- 2. x_status: status of the processing, -1 means no error
404: -- 3. x_error_msg: error message if any.
405: -----------------------------------------------------------------------------
406: PROCEDURE VALIDATE_RATING_ATTRIBUTE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
407: p_line_number IN NUMBER,
408: p_qp_pricing_attrib_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl,
409: x_status OUT NOCOPY NUMBER,
410: x_error_msg OUT NOCOPY VARCHAR2);
425: -- 1. p_qp_qualifier_tbl: pl/sql table for the attributes
426: -- 2. x_status: status of the processing, -1 means no error
427: -- 3. x_error_msg: error message if any.
428: -----------------------------------------------------------------------------
429: PROCEDURE VALIDATE_ADJUSTED_RATE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
430: p_line_number IN NUMBER,
431: p_carrier_id IN NUMBER,
432: p_qp_qualifier_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_qualifier_tbl,
433: x_status OUT NOCOPY NUMBER,
447: -- 1. p_qp_qualifier_tbl: pl/sql table for the attributes
448: -- 2. x_status: status of the processing, -1 means no error
449: -- 3. x_error_msg: error message if any.
450: -----------------------------------------------------------------------------
451: PROCEDURE VALIDATE_QUALIFIER(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
452: p_line_number IN NUMBER,
453: p_qp_qualifier_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_qualifier_tbl,
454: x_status OUT NOCOPY NUMBER,
455: x_error_msg OUT NOCOPY VARCHAR2);
534: --
535: -- Purpose: does validation for a line in tl service block
536: --
537: -- IN parameters:
538: -- 1. p_values: FTE_BULKLOAD_PKG.data_values_tbl
539: -- 2. p_line_number: line number of current line
540: --
541: -- OUT parameters:
542: -- 1. p_type: type value of the line
543: -- 2. p_action: action value of the line
544: -- 3. x_status: status of the processing, -1 means no error
545: -- 4. x_error_msg: error message if any.
546: ----------------------------------------------------------------------------
547: PROCEDURE VALIDATE_TL_SERVICE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
548: p_line_number IN NUMBER,
549: p_type OUT NOCOPY VARCHAR2,
550: p_action OUT NOCOPY VARCHAR2,
551: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
598: -- 7. x_status: status of the processing, -1 means no error
599: -- 8. x_error_msg: error message if any.
600: --_______________________________________________________________________________________--
601:
602: PROCEDURE VALIDATE_ZONE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
603: p_line_number IN NUMBER,
604: p_region_type IN VARCHAR2,
605: p_action OUT NOCOPY VARCHAR2,
606: p_zone_name OUT NOCOPY VARCHAR2,