eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_1099R_FORMULA_DRIVER dependencies on FF_FORMULAS_F

Line 51: -- Seeds formula data in ff_formulas_f table for 1099R federal formulas.

47: ----------------------------------------------------------------------------------------
48: -- Name
49: -- setup
50: -- Purpose
51: -- Seeds formula data in ff_formulas_f table for 1099R federal formulas.
52: -- Arguments
53: -- None
54: -- Notes
55: ----------------------------------------------------------------------------------------

Line 61: -- note: we are only inserting into the ff_formulas_f table.

57: PROCEDURE Setup IS
58: --
59: -- Define table structures to hold parameter details.
60: --
61: -- note: we are only inserting into the ff_formulas_f table.
62: -- The only fields that we have to cater for are the following :
63: -- LEGISLATION_CODE
64: -- FORMULA_TYPE_ID
65: -- FORMULA_NAME

Line 97: -- use to insert into the FF_FORMULAS_F table. This will allow the insertion

93: -- PL/SQL TABLE SEEDING
94: -- **************************************************************************
95: --
96: -- This part of the procedure is where we seed all of the tables that we
97: -- use to insert into the FF_FORMULAS_F table. This will allow the insertion
98: -- of further formulas to be that much more simpler.
99: --
100: -- First we seed the formulas table, these are the names of all the formulas
101: -- that we plan to seed.

Line 241: -- SEED FF_FORMULAS_F TABLE

237: --
238: close c_formula_type_id;
239: --
240: -- *************************************************************************
241: -- SEED FF_FORMULAS_F TABLE
242: -- *************************************************************************
243: --
244: hr_utility.trace('Seeding ff_formulas_f table');
245: --

Line 244: hr_utility.trace('Seeding ff_formulas_f table');

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

Line 246: l_message := 'Seeding 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
249:
250: -- **************************************************************************

Line 255: -- FF_FORMULAS_F, FF_FDI_USAGES_F and FF_COMPILED_INFO_F tables.

251: -- DELETION STEPS
252: -- **************************************************************************
253: --
254: -- This part of the procedure deletes all previous definitions from the
255: -- FF_FORMULAS_F, FF_FDI_USAGES_F and FF_COMPILED_INFO_F tables.
256: --
257: l_message := 'Attempting to delete previous definitions of 1099R federal
258: formulas from FF_COMPILED_INFO_F for formula - ' ||
259: l_formula_name_table(l_count);

Line 266: from ff_formulas_f ff

262: -- from FF_COMPILED_INFO_F
263: --
264: delete from ff_compiled_info_f fci
265: where fci.formula_id in (select ff.formula_id
266: from ff_formulas_f ff
267: where formula_name = l_formula_name_table(l_count));
268: --
269: l_message := 'Attempting to delete previous definitions of 1099R federal
270: formulas from FF_FDI_USAGES_F for formula - ' ||

Line 278: from ff_formulas_f

274: -- from FF_FDI_USAGES_F
275: --
276: delete from ff_fdi_usages_f
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');

Line 282: formulas from FF_FORMULAS_F');

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 - '||
286: l_formula_name_table(l_count);

Line 285: formulas from FF_FORMULAS_F for formula name - '||

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 - '||
286: l_formula_name_table(l_count);
287:
288: --
289: -- Delete all cases where 1099R Federal Formulas have been seeded previously

Line 290: -- in the FF_FORMULAS_F table.

286: l_formula_name_table(l_count);
287:
288: --
289: -- Delete all cases where 1099R Federal Formulas have been seeded previously
290: -- in the FF_FORMULAS_F table.
291: --
292: delete from ff_formulas_f ff
293: where ff.formula_name = l_formula_name_table(l_count);
294: --

Line 292: delete from ff_formulas_f ff

288: --
289: -- Delete all cases where 1099R Federal Formulas have been seeded previously
290: -- in the FF_FORMULAS_F table.
291: --
292: delete from ff_formulas_f ff
293: where ff.formula_name = l_formula_name_table(l_count);
294: --
295: --
296: --

Line 298: ff_formulas_f');

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

Line 300: l_message := 'Getting sequence for next record to seed in ff_formulas_f';

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;

Line 310: insert into ff_formulas_f

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
311: (FORMULA_ID,
312: EFFECTIVE_START_DATE,
313: EFFECTIVE_END_DATE,
314: BUSINESS_GROUP_ID,