[Home] [Help]
39: 26-JAN-99 AHANDA 40.7/110.3 Changed script to delete only formulas which
40: it is creating. Moved delete statement
41: inside the loop.
42: 16-jun-99 achauhan 110.5 Changed dbms_output to
43: hr_utility.trace
44: */
45: --
46: /*
*/
47: ----------------------------------------------------------------------------------------
99: --
100: -- First we seed the formulas table, these are the names of all the formulas
101: -- that we plan to seed.
102: --
103: hr_utility.trace('Seeding formula name table');
104: --
105: l_message := 'Seeding formula name table';
106: --
107: l_formula_name_table(1) := 'US_1099R_FILE_TOTALS';
155: --
156: --
157: -- Now we seed the formula descriptions of the formulas that we plan to seed.
158: --
159: hr_utility.trace('Seeding formula description table');
160: --
161: l_message := 'Seeding formula table descriptions';
162: --
163: l_description_table(1) := '1099R File totals formula for retirement processing';
212: -- **************************************************************************
213: -- SET FORMULA_TYPE_ID
214: -- **************************************************************************
215: --
216: hr_utility.trace('Setting formula type id');
217: --
218: l_message := 'Setting formula type id';
219: --
220: -- Steps to set this variable are as follows :
240: -- *************************************************************************
241: -- SEED FF_FORMULAS_F TABLE
242: -- *************************************************************************
243: --
244: hr_utility.trace('Seeding ff_formulas_f table');
245: --
246: l_message := 'Seeding ff_formulas_f table';
247: --
248: FOR l_count in 1..l_case_count LOOP
277: where formula_id in (select formula_id
278: from ff_formulas_f
279: where formula_name = l_formula_name_table(l_count));
280: --
281: hr_utility.trace('Attempting to delete previous definitions of 1099R federal
282: formulas from FF_FORMULAS_F');
283: --
284: l_message := 'Attempting to delete previous definitions of 1099R federal
285: formulas from FF_FORMULAS_F for formula name - '||
293: where ff.formula_name = l_formula_name_table(l_count);
294: --
295: --
296: --
297: hr_utility.trace('Getting sequence for next record to seed in
298: ff_formulas_f');
299: --
300: l_message := 'Getting sequence for next record to seed in ff_formulas_f';
301: --
302: select ff_formulas_s.nextval
303: into l_formula_id
304: from sys.dual;
305: --
306: hr_utility.trace('Seeding formula : '||l_formula_name_table(l_count));
307: --
308: l_message := 'Seeding formula : '||l_formula_name_table(l_count);
309: --
310: insert into ff_formulas_f
339: null,
340: null,
341: null);
342: --
343: hr_utility.trace('Seeding '||l_formula_name_table(l_count));
344: --
345: end loop;
346: --
347: hr_utility.trace('Successful');
343: hr_utility.trace('Seeding '||l_formula_name_table(l_count));
344: --
345: end loop;
346: --
347: hr_utility.trace('Successful');
348: --
349: COMMIT;
350: --
351: EXCEPTION
350: --
351: EXCEPTION
352: WHEN NO_DATA_FOUND THEN
353: --
354: hr_utility.trace('ERROR : Cannot get formula type id for Application');
355: --
356: WHEN OTHERS THEN
357: --
358: hr_utility.trace('ERROR : ' ||l_message||' - ORA '||to_char(SQLCODE));
354: hr_utility.trace('ERROR : Cannot get formula type id for Application');
355: --
356: WHEN OTHERS THEN
357: --
358: hr_utility.trace('ERROR : ' ||l_message||' - ORA '||to_char(SQLCODE));
359: hr_utility.trace('ERROR : ' ||l_message||' - ORA '||to_char(SQLCODE));
360: --
361: END setup;
362: --
355: --
356: WHEN OTHERS THEN
357: --
358: hr_utility.trace('ERROR : ' ||l_message||' - ORA '||to_char(SQLCODE));
359: hr_utility.trace('ERROR : ' ||l_message||' - ORA '||to_char(SQLCODE));
360: --
361: END setup;
362: --
363: END pay_1099R_formula_driver;