16: -- 1. x_status: status of the processing, -1 means no error
17: -- 2. x_error_msg: error message if any.
18: ----------------------------------------------------------------------------
19: PROCEDURE PROCESS_DATA (p_type IN VARCHAR2,
20: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
21: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
22: p_line_number IN NUMBER,
23: x_status OUT NOCOPY NUMBER,
24: x_error_msg OUT NOCOPY VARCHAR2);
17: -- 2. x_error_msg: error message if any.
18: ----------------------------------------------------------------------------
19: PROCEDURE PROCESS_DATA (p_type IN VARCHAR2,
20: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
21: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
22: p_line_number IN NUMBER,
23: x_status OUT NOCOPY NUMBER,
24: x_error_msg OUT NOCOPY VARCHAR2);
25:
38: -- OUT parameters:
39: -- 1. x_status: status of the processing, -1 means no error
40: -- 2. x_error_msg: error message if any.
41: ----------------------------------------------------------------------------
42: PROCEDURE PROCESS_RATE_CHART(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
43: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
44: p_line_number IN NUMBER,
45: p_validate_column IN BOOLEAN DEFAULT TRUE,
46: p_validate IN BOOLEAN DEFAULT TRUE,
39: -- 1. x_status: status of the processing, -1 means no error
40: -- 2. x_error_msg: error message if any.
41: ----------------------------------------------------------------------------
42: PROCEDURE PROCESS_RATE_CHART(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
43: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
44: p_line_number IN NUMBER,
45: p_validate_column IN BOOLEAN DEFAULT TRUE,
46: p_validate IN BOOLEAN DEFAULT TRUE,
47: p_process_id IN NUMBER DEFAULT NULL,
63: -- OUT parameters:
64: -- 1. x_status: status of the processing, -1 means no error
65: -- 2. x_error_msg: error message if any.
66: ----------------------------------------------------------------------------
67: PROCEDURE PROCESS_RATE_LINE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
68: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
69: p_line_number IN NUMBER,
70: p_validate_column IN BOOLEAN DEFAULT TRUE,
71: p_validate IN BOOLEAN DEFAULT TRUE,
64: -- 1. x_status: status of the processing, -1 means no error
65: -- 2. x_error_msg: error message if any.
66: ----------------------------------------------------------------------------
67: PROCEDURE PROCESS_RATE_LINE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
68: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
69: p_line_number IN NUMBER,
70: p_validate_column IN BOOLEAN DEFAULT TRUE,
71: p_validate IN BOOLEAN DEFAULT TRUE,
72: x_status OUT NOCOPY NUMBER,
87: -- OUT parameters:
88: -- 1. x_status: status of the processing, -1 means no error
89: -- 2. x_error_msg: error message if any.
90: ----------------------------------------------------------------------------
91: PROCEDURE PROCESS_RATE_BREAK(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
92: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
93: p_line_number IN NUMBER,
94: p_validate_column IN BOOLEAN DEFAULT TRUE,
95: p_validate IN BOOLEAN DEFAULT TRUE,
88: -- 1. x_status: status of the processing, -1 means no error
89: -- 2. x_error_msg: error message if any.
90: ----------------------------------------------------------------------------
91: PROCEDURE PROCESS_RATE_BREAK(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
92: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
93: p_line_number IN NUMBER,
94: p_validate_column IN BOOLEAN DEFAULT TRUE,
95: p_validate IN BOOLEAN DEFAULT TRUE,
96: x_status OUT NOCOPY NUMBER,
110: -- OUT parameters:
111: -- 1. x_status: status of the processing, -1 means no error
112: -- 2. x_error_msg: error message if any.
113: ----------------------------------------------------------------------------
114: PROCEDURE PROCESS_RATING_ATTRIBUTE(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
115: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
116: p_line_number IN NUMBER,
117: p_validate_column IN BOOLEAN DEFAULT TRUE,
118: x_status OUT NOCOPY NUMBER,
111: -- 1. x_status: status of the processing, -1 means no error
112: -- 2. x_error_msg: error message if any.
113: ----------------------------------------------------------------------------
114: PROCEDURE PROCESS_RATING_ATTRIBUTE(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
115: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
116: p_line_number IN NUMBER,
117: p_validate_column IN BOOLEAN DEFAULT TRUE,
118: x_status OUT NOCOPY NUMBER,
119: x_error_msg OUT NOCOPY VARCHAR2);
133: -- OUT parameters:
134: -- 1. x_status: status of the processing, -1 means no error
135: -- 2. x_error_msg: error message if any.
136: ----------------------------------------------------------------------------
137: PROCEDURE PROCESS_CHARGES_DISCOUNTS(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
138: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
139: p_line_number IN NUMBER,
140: p_validate_column IN BOOLEAN DEFAULT TRUE,
141: p_validate IN BOOLEAN DEFAULT TRUE,
134: -- 1. x_status: status of the processing, -1 means no error
135: -- 2. x_error_msg: error message if any.
136: ----------------------------------------------------------------------------
137: PROCEDURE PROCESS_CHARGES_DISCOUNTS(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
138: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
139: p_line_number IN NUMBER,
140: p_validate_column IN BOOLEAN DEFAULT TRUE,
141: p_validate IN BOOLEAN DEFAULT TRUE,
142: x_status OUT NOCOPY NUMBER,
157: -- OUT parameters:
158: -- 1. x_status: status of the processing, -1 means no error
159: -- 2. x_error_msg: error message if any.
160: ----------------------------------------------------------------------------
161: PROCEDURE PROCESS_CHARGES_DISCOUNTS_LINE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
162: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
163: p_line_number IN NUMBER,
164: p_validate_column IN BOOLEAN DEFAULT TRUE,
165: p_validate IN BOOLEAN DEFAULT TRUE,
158: -- 1. x_status: status of the processing, -1 means no error
159: -- 2. x_error_msg: error message if any.
160: ----------------------------------------------------------------------------
161: PROCEDURE PROCESS_CHARGES_DISCOUNTS_LINE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
162: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
163: p_line_number IN NUMBER,
164: p_validate_column IN BOOLEAN DEFAULT TRUE,
165: p_validate IN BOOLEAN DEFAULT TRUE,
166: x_status OUT NOCOPY NUMBER,
179: -- OUT parameters:
180: -- 1. x_status: status of the processing, -1 means no error
181: -- 2. x_error_msg: error message if any.
182: ----------------------------------------------------------------------------
183: PROCEDURE PROCESS_ADJUSTED_RATE_CHART (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
184: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
185: p_line_number IN NUMBER,
186: x_status OUT NOCOPY NUMBER,
187: x_error_msg OUT NOCOPY VARCHAR2);
180: -- 1. x_status: status of the processing, -1 means no error
181: -- 2. x_error_msg: error message if any.
182: ----------------------------------------------------------------------------
183: PROCEDURE PROCESS_ADJUSTED_RATE_CHART (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
184: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
185: p_line_number IN NUMBER,
186: x_status OUT NOCOPY NUMBER,
187: x_error_msg OUT NOCOPY VARCHAR2);
188:
199: -- OUT parameters:
200: -- 1. x_status: status of the processing, -1 means no error
201: -- 2. x_error_msg: error message if any.
202: ----------------------------------------------------------------------------
203: PROCEDURE PROCESS_QUALIFIER(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
204: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
205: p_line_number IN NUMBER,
206: x_status OUT NOCOPY NUMBER,
207: x_error_msg OUT NOCOPY VARCHAR2);
200: -- 1. x_status: status of the processing, -1 means no error
201: -- 2. x_error_msg: error message if any.
202: ----------------------------------------------------------------------------
203: PROCEDURE PROCESS_QUALIFIER(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
204: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
205: p_line_number IN NUMBER,
206: x_status OUT NOCOPY NUMBER,
207: x_error_msg OUT NOCOPY VARCHAR2);
208: