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_AUTOGN dependencies on FF_ROUTES

Line 41: select ff_routes_s.currval,

37: insert into ff_route_context_usages
38: (route_id,
39: context_id,
40: sequence_no)
41: select ff_routes_s.currval,
42: CON.context_id,
43: 1
44: from ff_contexts CON
45: where CON.context_name = 'ASSIGNMENT_ACTION_ID';

Line 58: ff_routes_s.currval,

54: parameter_name,
55: data_type)
56: values
57: (ff_route_parameters_s.nextval,
58: ff_routes_s.currval,
59: 1,
60: 'Balance Type ID',
61: 'N');
62: hr_utility.set_location('pay_autogn.insert_bf_dimensions',40);

Line 63: select ff_routes_s.currval into x from dual;

59: 1,
60: 'Balance Type ID',
61: 'N');
62: hr_utility.set_location('pay_autogn.insert_bf_dimensions',40);
63: select ff_routes_s.currval into x from dual;
64: --
65: return x;
66: --
67: end do_child_inserts;

Line 69: -- Insert row in FF_ROUTES for this dimension

65: return x;
66: --
67: end do_child_inserts;
68: begin
69: -- Insert row in FF_ROUTES for this dimension
70: hr_utility.set_location('pay_autogn.insert_bf_dimensions',1);
71: insert into ff_routes
72: (route_id,
73: user_defined_flag,

Line 71: insert into ff_routes

67: end do_child_inserts;
68: begin
69: -- Insert row in FF_ROUTES for this dimension
70: hr_utility.set_location('pay_autogn.insert_bf_dimensions',1);
71: insert into ff_routes
72: (route_id,
73: user_defined_flag,
74: route_name,
75: description,

Line 78: (ff_routes_s.nextval,

74: route_name,
75: description,
76: text)
77: values
78: (ff_routes_s.nextval,
79: 'N',
80: 'BF Person-level Tax Year to Date Balance Dimension',
81: 'Summed data for the PERSON-LEVEL BF TAX YEAR TO DATE balance dimension',
82: ' pay_balance_feeds_f FEED

Line 135: -- Insert row in FF_ROUTES for this dimension

131: null, -- always feed
132: 'P', -- expiry check at payroll action level
133: 'pay_bf_expc.pytd_ec' -- expry checking procedure.
134: );
135: -- Insert row in FF_ROUTES for this dimension
136: hr_utility.set_location('pay_autogn.insert_bf_dimensions',2);
137: insert into ff_routes
138: (route_id,
139: user_defined_flag,

Line 137: insert into ff_routes

133: 'pay_bf_expc.pytd_ec' -- expry checking procedure.
134: );
135: -- Insert row in FF_ROUTES for this dimension
136: hr_utility.set_location('pay_autogn.insert_bf_dimensions',2);
137: insert into ff_routes
138: (route_id,
139: user_defined_flag,
140: route_name,
141: description,

Line 144: (ff_routes_s.nextval,

140: route_name,
141: description,
142: text)
143: values
144: (ff_routes_s.nextval,
145: 'N',
146: 'BF Assignment-level Tax Year to Date Balance Dimension',
147: 'Summed data for the ASSIGNMENT-LEVEL BF TAX YEAR TO DATE balance dimension',
148: ' pay_balance_feeds_f FEED

Line 193: -- Insert row in FF_ROUTES for this dimension

189: null, -- always feed (no code)
190: 'P',
191: 'pay_bf_expc.aytd_ec' -- checking code.
192: );
193: -- Insert row in FF_ROUTES for this dimension
194: hr_utility.set_location('pay_autogn.insert_bf_dimensions',3);
195: insert into ff_routes
196: (route_id,
197: user_defined_flag,

Line 195: insert into ff_routes

191: 'pay_bf_expc.aytd_ec' -- checking code.
192: );
193: -- Insert row in FF_ROUTES for this dimension
194: hr_utility.set_location('pay_autogn.insert_bf_dimensions',3);
195: insert into ff_routes
196: (route_id,
197: user_defined_flag,
198: route_name,
199: description,

Line 202: (ff_routes_s.nextval,

198: route_name,
199: description,
200: text)
201: values
202: (ff_routes_s.nextval,
203: 'N',
204: 'BF Person-level Period to Date Balance Dimension',
205: 'Summed data for the PERSON-LEVEL PERIOD TO DATE balance dimension',
206: ' pay_balance_feeds_f FEED

Line 258: -- Insert row in FF_ROUTES for this dimension

254: null, -- always feed
255: 'P', -- expiry check at Payroll Action level
256: 'pay_bf_expc.pptd_ec' -- expiry checking procedure.
257: );
258: -- Insert row in FF_ROUTES for this dimension
259: hr_utility.set_location('pay_autogn.insert_bf_dimensions',5);
260: insert into ff_routes
261: (route_id,
262: user_defined_flag,

Line 260: insert into ff_routes

256: 'pay_bf_expc.pptd_ec' -- expiry checking procedure.
257: );
258: -- Insert row in FF_ROUTES for this dimension
259: hr_utility.set_location('pay_autogn.insert_bf_dimensions',5);
260: insert into ff_routes
261: (route_id,
262: user_defined_flag,
263: route_name,
264: description,

Line 267: (ff_routes_s.nextval,

263: route_name,
264: description,
265: text)
266: values
267: (ff_routes_s.nextval,
268: 'N',
269: 'BF Assignment-level Period to Date Balance Dimension',
270: 'Summed data for the ASSIGNMENT-LEVEL PERIOD TO DATE balance dimension',
271: ' pay_balance_feeds_f FEED

Line 315: -- Insert row in FF_ROUTES for this dimension

311: null, -- always feed
312: 'P', -- expiry check at Payroll Action level
313: 'pay_bf_expc.aptd_ec' -- expiry checking procedure.
314: );
315: -- Insert row in FF_ROUTES for this dimension
316: hr_utility.set_location('pay_autogn.insert_bf_dimensions',4);
317: insert into ff_routes
318: (route_id,
319: user_defined_flag,

Line 317: insert into ff_routes

313: 'pay_bf_expc.aptd_ec' -- expiry checking procedure.
314: );
315: -- Insert row in FF_ROUTES for this dimension
316: hr_utility.set_location('pay_autogn.insert_bf_dimensions',4);
317: insert into ff_routes
318: (route_id,
319: user_defined_flag,
320: route_name,
321: description,

Line 324: (ff_routes_s.nextval,

320: route_name,
321: description,
322: text)
323: values
324: (ff_routes_s.nextval,
325: 'N',
326: 'BF Person-level Period to Date Balance Dimension (test)',
327: 'Summed data for the PERSON-LEVEL PERIOD TO DATE balance dimension (test)',
328: ' pay_balance_feeds_f FEED

Line 380: -- Insert row in FF_ROUTES for this dimension

376: null, -- always feed
377: 'A', -- expiry check at Assignment Action level
378: 'pay_bf_expc.pptd_alc_ec'
379: );
380: -- Insert row in FF_ROUTES for this dimension
381: hr_utility.set_location('pay_autogn.insert_bf_dimensions',6);
382: insert into ff_routes
383: (route_id,
384: user_defined_flag,

Line 382: insert into ff_routes

378: 'pay_bf_expc.pptd_alc_ec'
379: );
380: -- Insert row in FF_ROUTES for this dimension
381: hr_utility.set_location('pay_autogn.insert_bf_dimensions',6);
382: insert into ff_routes
383: (route_id,
384: user_defined_flag,
385: route_name,
386: description,

Line 389: (ff_routes_s.nextval,

385: route_name,
386: description,
387: text)
388: values
389: (ff_routes_s.nextval,
390: 'N',
391: 'BF Person-level User Cleared Balance Dimension',
392: 'Summed data for the PERSON-LEVEL USER CLEARED balance dimension',
393: ' pay_balance_feeds_f FEED

Line 439: -- Insert row in FF_ROUTES for this dimension

435: null, -- always feed
436: 'P', -- expiry check at payroll action level.
437: 'pay_bf_expc.never_expires'
438: );
439: -- Insert row in FF_ROUTES for this dimension
440: hr_utility.set_location('pay_autogn.insert_bf_dimensions',7);
441: insert into ff_routes
442: (route_id,
443: user_defined_flag,

Line 441: insert into ff_routes

437: 'pay_bf_expc.never_expires'
438: );
439: -- Insert row in FF_ROUTES for this dimension
440: hr_utility.set_location('pay_autogn.insert_bf_dimensions',7);
441: insert into ff_routes
442: (route_id,
443: user_defined_flag,
444: route_name,
445: description,

Line 448: (ff_routes_s.nextval,

444: route_name,
445: description,
446: text)
447: values
448: (ff_routes_s.nextval,
449: 'N',
450: 'BF Assignment-level User Cleared Balance Dimension',
451: 'Summed data for the ASSIGNMENT-LEVEL USER CLEARED balance dimension',
452: ' pay_balance_feeds_f FEED

Line 490: -- Insert row in FF_ROUTES for this dimension

486: null, -- always feed
487: 'P', -- expiry check at Payroll Action level
488: 'pay_bf_expc.never_expires'
489: );
490: -- Insert row in FF_ROUTES for this dimension
491: hr_utility.set_location('pay_autogn.insert_bf_dimensions',8);
492: insert into ff_routes
493: (route_id,
494: user_defined_flag,

Line 492: insert into ff_routes

488: 'pay_bf_expc.never_expires'
489: );
490: -- Insert row in FF_ROUTES for this dimension
491: hr_utility.set_location('pay_autogn.insert_bf_dimensions',8);
492: insert into ff_routes
493: (route_id,
494: user_defined_flag,
495: route_name,
496: description,

Line 499: (ff_routes_s.nextval,

495: route_name,
496: description,
497: text)
498: values
499: (ff_routes_s.nextval,
500: 'N',
501: 'BF Assignment-level User Cleared Balance Dimension (not fed)',
502: 'Summed data for the ASSIGNMENT-LEVEL USER balance dimension (not fed)',
503: ' pay_balance_feeds_f FEED

Line 541: -- Insert row in FF_ROUTES for this dimension

537: null, -- never fed or stored
538: null, -- never fed or stored
539: null -- never fed or stored
540: );
541: -- Insert row in FF_ROUTES for this dimension
542: hr_utility.set_location('pay_autogn.insert_bf_dimensions',9);
543: insert into ff_routes
544: (route_id,
545: user_defined_flag,

Line 543: insert into ff_routes

539: null -- never fed or stored
540: );
541: -- Insert row in FF_ROUTES for this dimension
542: hr_utility.set_location('pay_autogn.insert_bf_dimensions',9);
543: insert into ff_routes
544: (route_id,
545: user_defined_flag,
546: route_name,
547: description,

Line 550: (ff_routes_s.nextval,

546: route_name,
547: description,
548: text)
549: values
550: (ff_routes_s.nextval,
551: 'N',
552: 'BF Assignment-level Current Run Balance Dimension',
553: 'Summed data for the ASSIGNMENT-LEVEL CURRENT RUN balance dimension',
554: ' pay_balance_feeds_f FEED

Line 587: -- Insert row in FF_ROUTES for this dimension

583: null, -- always feed
584: null, -- never stored, no expiry details needed
585: null -- never stored, no expiry details needed
586: );
587: -- Insert row in FF_ROUTES for this dimension
588: hr_utility.set_location('pay_autogn.insert_bf_dimensions',10);
589: insert into ff_routes
590: (route_id,
591: user_defined_flag,

Line 589: insert into ff_routes

585: null -- never stored, no expiry details needed
586: );
587: -- Insert row in FF_ROUTES for this dimension
588: hr_utility.set_location('pay_autogn.insert_bf_dimensions',10);
589: insert into ff_routes
590: (route_id,
591: user_defined_flag,
592: route_name,
593: description,

Line 596: (ff_routes_s.nextval,

592: route_name,
593: description,
594: text)
595: values
596: (ff_routes_s.nextval,
597: 'N',
598: 'BF Person-level Contracted In YTD Balance Dimension',
599: 'Summed data for the PERSON-LEVEL CONTRACTED IN YTD balance dimension',
600: ' pay_balance_feeds_f FEED

Line 646: -- Insert row in FF_ROUTES for this dimension

642: 'pay_bf_expc.pcon_fc', -- feed checking procedure.
643: 'P', -- expiry check at payroll action level.
644: 'pay_bf_expc.pcon_ec' -- expiry checking procedure.
645: );
646: -- Insert row in FF_ROUTES for this dimension
647: hr_utility.set_location('pay_autogn.insert_bf_dimensions',11);
648: insert into ff_routes
649: (route_id,
650: user_defined_flag,

Line 648: insert into ff_routes

644: 'pay_bf_expc.pcon_ec' -- expiry checking procedure.
645: );
646: -- Insert row in FF_ROUTES for this dimension
647: hr_utility.set_location('pay_autogn.insert_bf_dimensions',11);
648: insert into ff_routes
649: (route_id,
650: user_defined_flag,
651: route_name,
652: description,

Line 655: (ff_routes_s.nextval,

651: route_name,
652: description,
653: text)
654: values
655: (ff_routes_s.nextval,
656: 'N',
657: 'BF Payments Balance Dimension',
658: 'Summed data for the PAYMENTS balance dimension',
659: ' pay_balance_feeds_f FEED