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,
248: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
249: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
250: p_lane_commodity_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_commodity_tbl,
251: x_status OUT NOCOPY NUMBER,
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,
248: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
249: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
250: p_lane_commodity_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_commodity_tbl,
251: x_status OUT NOCOPY NUMBER,
252: x_error_msg OUT NOCOPY VARCHAR2);
245: p_type OUT NOCOPY VARCHAR2,
246: p_action OUT NOCOPY VARCHAR2,
247: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
248: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
249: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
250: p_lane_commodity_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_commodity_tbl,
251: x_status OUT NOCOPY NUMBER,
252: x_error_msg OUT NOCOPY VARCHAR2);
253:
246: p_action OUT NOCOPY VARCHAR2,
247: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
248: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
249: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
250: p_lane_commodity_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_commodity_tbl,
251: x_status OUT NOCOPY NUMBER,
252: x_error_msg OUT NOCOPY VARCHAR2);
253:
254: ----------------------------------------------------------------------------
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,
278: p_lane_function IN OUT NOCOPY VARCHAR2,
279: p_lane_number OUT NOCOPY VARCHAR2,
280: p_action OUT NOCOPY VARCHAR2,
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,
304: x_error_msg OUT NOCOPY VARCHAR2);
305:
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,
552: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
553: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
554: x_status OUT NOCOPY NUMBER,
555: x_error_msg OUT NOCOPY VARCHAR2);
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,
552: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
553: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
554: x_status OUT NOCOPY NUMBER,
555: x_error_msg OUT NOCOPY VARCHAR2);
556:
549: p_type OUT NOCOPY VARCHAR2,
550: p_action OUT NOCOPY VARCHAR2,
551: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
552: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
553: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
554: x_status OUT NOCOPY NUMBER,
555: x_error_msg OUT NOCOPY VARCHAR2);
556:
557: ----------------------------------------------------------------------------