51: FTE_UTIL_PKG.Init_Debug(1);
52: END IF;
53:
54: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
55: FTE_RATE_CHART_PKG.RESET_ALL;
56:
57: FOR i IN p_header_table.FIRST..p_header_table.LAST LOOP
58:
59: l_block_data(1)('ACTION') := 'UPDATE';
91: x_error_msg => x_error_msg);
92: END IF;
93:
94: IF (x_status <> -1) THEN
95: FTE_RATE_CHART_PKG.RESET_ALL;
96: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
97: RETURN;
98: END IF;
99:
140: x_error_msg => x_error_msg);
141: END IF;
142:
143: IF (x_status <> -1) THEN
144: FTE_RATE_CHART_PKG.RESET_ALL;
145: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
146: RETURN;
147: END IF;
148:
166: p_validate => FALSE,
167: x_status => x_status,
168: x_error_msg => x_error_msg);
169: IF (x_status <> -1) THEN
170: FTE_RATE_CHART_PKG.RESET_ALL;
171: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
172: RETURN;
173: END IF;
174:
182: x_error_msg => x_error_msg);
183: END IF;
184:
185: IF (x_status <> -1) THEN
186: FTE_RATE_CHART_PKG.RESET_ALL;
187: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
188: RETURN;
189: END IF;
190:
196: x_error_msg => x_error_msg);
197: END IF;
198:
199: IF (x_status <> -1) THEN
200: FTE_RATE_CHART_PKG.RESET_ALL;
201: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
202: RETURN;
203: END IF;
204:
210: x_error_msg => x_error_msg);
211: END IF;
212:
213: IF (x_status <> -1) THEN
214: FTE_RATE_CHART_PKG.RESET_ALL;
215: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
216: RETURN;
217: END IF;
218:
224: x_error_msg => x_error_msg);
225: END IF;
226:
227: IF (x_status <> -1) THEN
228: FTE_RATE_CHART_PKG.RESET_ALL;
229: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
230: RETURN;
231: END IF;
232:
238: x_error_msg => x_error_msg);
239: END IF;
240:
241: IF (x_status <> -1) THEN
242: FTE_RATE_CHART_PKG.RESET_ALL;
243: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
244: RETURN;
245: END IF;
246:
254: FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS(
255: x_status => x_status,
256: x_error_msg => x_error_msg);
257:
258: FTE_RATE_CHART_PKG.RESET_ALL;
259: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
260:
261: IF (x_status = -1) THEN
262: commit;
263: ELSE
264: rollback;
265: END IF;
266:
267: FTE_RATE_CHART_PKG.RESET_ALL;
268: FTE_RATE_CHART_LOADER.INIT_QP_TABLES;
269: END RATE_CHART_WRAPPER;
270:
271: