1 PACKAGE FTE_RATE_CHART_LOADER AUTHID CURRENT_USER AS
2 /* $Header: FTERCLDS.pls 120.0 2005/06/28 02:26:54 pkaliyam noship $ */
3
4 ----------------------------------------------------------------------------
5 -- PROCEDURE PROCESS_DATA
6 --
7 -- Purpose: Call appropriate process function according to the type.
8 --
9 -- IN parameters:
10 -- 1. p_type: type of the block (Rating zone chart, rating setup, orign, destination)
11 -- 2. p_block_header: pl/sql table of STRINGARRAY containing the block information
12 -- 3. p_block_data: pl/sql table of the data
13 -- 4. p_line_number: line number for the beginning of the block
14 --
15 -- OUT parameters:
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);
25
26 ----------------------------------------------------------------------------
27 -- PROCEDURE PROCESS_RATE_CHART
28 --
29 -- Purpose: process the lines in p_table for rate chart header
30 --
31 -- IN parameters:
32 -- 1. p_block_header: pl/sql table of STRINGARRAY containing the block information
33 -- 2. p_block_data: pl/sql table of the data
34 -- 3. p_line_number: line number for the beginning of the block
35 -- 4. p_validate_column: boolean for calling VALIDATE_COLUMNS, default true
36 -- 5. p_validate: boolean for validating data within VALIDATION procedure, default true
37 --
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,
47 p_process_id IN NUMBER DEFAULT NULL,
48 x_status OUT NOCOPY NUMBER,
49 x_error_msg OUT NOCOPY VARCHAR2);
50
51 ----------------------------------------------------------------------------
52 -- PROCEDURE PROCESS_RATE_LINE
53 --
54 -- Purpose: process the lines in p_table for rate chart line
55 --
56 -- IN parameters:
57 -- 1. p_block_header: pl/sql table of STRINGARRAY containing the block information
58 -- 2. p_block_data: pl/sql table of the data
59 -- 3. p_line_number: line number for the beginning of the block
60 -- 4. p_validate_column: boolean for calling VALIDATE_COLUMNS, default true
61 -- 5. p_validate: boolean for validating data within VALIDATION procedure, default true
62 --
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,
72 x_status OUT NOCOPY NUMBER,
73 x_error_msg OUT NOCOPY VARCHAR2);
74
75 ----------------------------------------------------------------------------
76 -- PROCEDURE PROCESS_RATE_BREAK
77 --
78 -- Purpose: process the lines in p_table for rate chart break
79 --
80 -- IN parameters:
81 -- 1. p_block_header: pl/sql table of STRINGARRAY containing the block information
82 -- 2. p_block_data: pl/sql table of the data
83 -- 3. p_line_number: line number for the beginning of the block
84 -- 4. p_validate_column: boolean for calling VALIDATE_COLUMNS, default true
85 -- 5. p_validate: boolean for validating data within VALIDATION procedure, default true
86 --
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,
96 x_status OUT NOCOPY NUMBER,
97 x_error_msg OUT NOCOPY VARCHAR2);
98
99 ----------------------------------------------------------------------------
100 -- PROCEDURE PROCESS_RATING_ATTRIBUTE
101 --
102 -- Purpose: process the lines in p_table for rate chart line attribute
103 --
104 -- IN parameters:
105 -- 1. p_block_header: pl/sql table of STRINGARRAY containing the block information
106 -- 2. p_block_data: pl/sql table of the data
107 -- 3. p_line_number: line number for the beginning of the block
108 -- 4. p_validate_column: boolean for calling VALIDATE_COLUMNS, default true
109 --
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,
119 x_error_msg OUT NOCOPY VARCHAR2);
120
121 ----------------------------------------------------------------------------
122 -- PROCEDURE PROCESS_CHARGES_DISCOUNTS
123 --
124 -- Purpose: process the lines in p_table for charges and discounts header
125 --
126 -- IN parameters:
127 -- 1. p_block_header: pl/sql table of STRINGARRAY containing the block information
128 -- 2. p_block_data: pl/sql table of the data
129 -- 3. p_line_number: line number for the beginning of the block
130 -- 4. p_validate_column: boolean for calling VALIDATE_COLUMNS, default true
131 -- 5. p_validate: boolean for validating data within VALIDATION procedure, default true
132 --
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,
142 x_status OUT NOCOPY NUMBER,
143 x_error_msg OUT NOCOPY VARCHAR2);
144
145 ----------------------------------------------------------------------------
146 -- PROCEDURE PROCESS_CHARGES_DISCOUNTS_LINE
147 --
148 -- Purpose: process the lines in p_table for charges and discounts line
149 --
150 -- IN parameters:
151 -- 1. p_block_header: pl/sql table of STRINGARRAY containing the block information
152 -- 2. p_block_data: pl/sql table of the data
153 -- 3. p_line_number: line number for the beginning of the block
154 -- 4. p_validate_column: boolean for calling VALIDATE_COLUMNS, default true
155 -- 5. p_validate: boolean for validating data within VALIDATION procedure, default true
156 --
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,
166 x_status OUT NOCOPY NUMBER,
167 x_error_msg OUT NOCOPY VARCHAR2);
168
169 ----------------------------------------------------------------------------
170 -- PROCEDURE PROCESS_ADJUSTED_RATE_CHART
171 --
172 -- Purpose: process the lines in p_table for charges and discounts' rate chart
173 --
174 -- IN parameters:
175 -- 1. p_block_header: pl/sql table of STRINGARRAY containing the block information
176 -- 2. p_block_data: pl/sql table of the data
177 -- 3. p_line_number: line number for the beginning of the block
178 --
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);
188
189 ----------------------------------------------------------------------------
190 -- PROCEDURE PROCESS_QUALIFIER
191 --
192 -- Purpose: process the qualifiers for TL Rate Chart
193 --
194 -- IN parameters:
195 -- 1. p_block_header: pl/sql table of STRINGARRAY containing the block information
196 -- 2. p_block_data: pl/sql table of the data
197 -- 3. p_line_number: line number for the beginning of the block
198 --
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);
208
209 ----------------------------------------------------------------------------
210 -- PROCEDURE ADD_ATTRIBUTE
211 --
212 -- Purpose: process the attributes from the UI by directly adding it to pricing attrib tbl
213 --
214 -- IN parameters:
215 -- 1. p_pricing_attribute: type of the attribute
216 -- 2. p_attr_value_from: value of the attribute
217 -- 3. p_linenum: line number
218 --
219 -- OUT parameters:
220 -- 1. x_status: status of the processing, -1 means no error
221 -- 2. x_error_msg: error message if any.
222 ----------------------------------------------------------------------------
223 PROCEDURE ADD_ATTRIBUTE(p_pricing_attribute IN VARCHAR2,
224 p_attr_value_from IN VARCHAR2,
225 p_line_number IN NUMBER,
226 x_status OUT NOCOPY NUMBER,
227 x_error_msg OUT NOCOPY VARCHAR2);
228
229 ----------------------------------------------------------------------
230 -- PROCEDURE SUBMIT_QP_PROCESS
231 --
232 -- Purpose: insert all pl/sql tables into QP_INTERFACE_* tables
233 ----------------------------------------------------------------------
234 PROCEDURE SUBMIT_QP_PROCESS(p_qp_call IN BOOLEAN DEFAULT TRUE,
235 x_status OUT NOCOPY NUMBER,
236 x_error_msg OUT NOCOPY VARCHAR2);
237
238
239 PROCEDURE INIT_QP_TABLES ;
240
241 END FTE_RATE_CHART_LOADER;