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

Line 39: select ff_routes_s.currval,

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

Line 56: ff_routes_s.currval,

52: parameter_name,
53: data_type)
54: values
55: (ff_route_parameters_s.nextval,
56: ff_routes_s.currval,
57: 1,
58: 'Balance Type ID',
59: 'N');
60: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',40);

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

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

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

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

Line 69: insert into ff_routes

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

Line 76: (ff_routes_s.nextval,

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

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

145: l_dimension_expired := 1;
146: end if;
147: end;'
148: );
149: -- Insert row in FF_ROUTES for this dimension
150: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',2);
151: insert into ff_routes
152: (route_id,
153: user_defined_flag,

Line 151: insert into ff_routes

147: end;'
148: );
149: -- Insert row in FF_ROUTES for this dimension
150: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',2);
151: insert into ff_routes
152: (route_id,
153: user_defined_flag,
154: route_name,
155: description,

Line 158: (ff_routes_s.nextval,

154: route_name,
155: description,
156: text)
157: values
158: (ff_routes_s.nextval,
159: 'N',
160: 'GB Assignment-level Tax Year to Date Balance Dimension',
161: 'Summed data for the ASSIGNMENT-LEVEL GB TAX YEAR TO DATE balance dimension',
162: ' pay_balance_feeds_f FEED

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

219: l_dimension_expired := 1;
220: end if;
221: end;'
222: );
223: -- Insert row in FF_ROUTES for this dimension
224: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',3);
225: insert into ff_routes
226: (route_id,
227: user_defined_flag,

Line 225: insert into ff_routes

221: end;'
222: );
223: -- Insert row in FF_ROUTES for this dimension
224: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',3);
225: insert into ff_routes
226: (route_id,
227: user_defined_flag,
228: route_name,
229: description,

Line 232: (ff_routes_s.nextval,

228: route_name,
229: description,
230: text)
231: values
232: (ff_routes_s.nextval,
233: 'N',
234: 'GB Person-level Period to Date Balance Dimension',
235: 'Summed data for the PERSON-LEVEL PERIOD TO DATE balance dimension',
236: ' pay_balance_feeds_f FEED

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

299: l_dimension_expired := 1;
300: end if;
301: end;'
302: );
303: -- Insert row in FF_ROUTES for this dimension
304: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',4);
305: insert into ff_routes
306: (route_id,
307: user_defined_flag,

Line 305: insert into ff_routes

301: end;'
302: );
303: -- Insert row in FF_ROUTES for this dimension
304: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',4);
305: insert into ff_routes
306: (route_id,
307: user_defined_flag,
308: route_name,
309: description,

Line 312: (ff_routes_s.nextval,

308: route_name,
309: description,
310: text)
311: values
312: (ff_routes_s.nextval,
313: 'N',
314: 'GB Assignment-level Period to Date Balance Dimension',
315: 'Summed data for the ASSIGNMENT-LEVEL PERIOD TO DATE balance dimension',
316: ' pay_balance_feeds_f FEED

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

371: l_dimension_expired := 1;
372: end if;
373: end;'
374: );
375: -- Insert row in FF_ROUTES for this dimension
376: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',5);
377: insert into ff_routes
378: (route_id,
379: user_defined_flag,

Line 377: insert into ff_routes

373: end;'
374: );
375: -- Insert row in FF_ROUTES for this dimension
376: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',5);
377: insert into ff_routes
378: (route_id,
379: user_defined_flag,
380: route_name,
381: description,

Line 384: (ff_routes_s.nextval,

380: route_name,
381: description,
382: text)
383: values
384: (ff_routes_s.nextval,
385: 'N',
386: 'GB Person-level User Cleared Balance Dimension',
387: 'Summed data for the PERSON-LEVEL USER CLEARED balance dimension',
388: ' pay_balance_feeds_f FEED

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

429: null, -- always feed
430: 'P', -- expiry check at Payroll Action level
431: 'l_dimension_expired := 0;' -- never expires
432: );
433: -- Insert row in FF_ROUTES for this dimension
434: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',6);
435: insert into ff_routes
436: (route_id,
437: user_defined_flag,

Line 435: insert into ff_routes

431: 'l_dimension_expired := 0;' -- never expires
432: );
433: -- Insert row in FF_ROUTES for this dimension
434: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',6);
435: insert into ff_routes
436: (route_id,
437: user_defined_flag,
438: route_name,
439: description,

Line 442: (ff_routes_s.nextval,

438: route_name,
439: description,
440: text)
441: values
442: (ff_routes_s.nextval,
443: 'N',
444: 'GB Assignment-level User Cleared Balance Dimension',
445: 'Summed data for the ASSIGNMENT-LEVEL USER CLEARED balance dimension',
446: ' pay_balance_feeds_f FEED

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

479: null, -- always feed
480: 'P', -- expiry check at Payroll Action level
481: 'l_dimension_expired := 0;' -- never expires
482: );
483: -- Insert row in FF_ROUTES for this dimension
484: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',7);
485: insert into ff_routes
486: (route_id,
487: user_defined_flag,

Line 485: insert into ff_routes

481: 'l_dimension_expired := 0;' -- never expires
482: );
483: -- Insert row in FF_ROUTES for this dimension
484: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',7);
485: insert into ff_routes
486: (route_id,
487: user_defined_flag,
488: route_name,
489: description,

Line 492: (ff_routes_s.nextval,

488: route_name,
489: description,
490: text)
491: values
492: (ff_routes_s.nextval,
493: 'N',
494: 'GB Assignment-level Current Run Balance Dimension',
495: 'Summed data for the ASSIGNMENT-LEVEL CURRENT RUN balance dimension',
496: ' pay_balance_feeds_f FEED

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

525: null, -- always feed
526: null, -- never stored, no expiry details needed
527: null -- never stored, no expiry details needed
528: );
529: -- Insert row in FF_ROUTES for this dimension
530: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',8);
531: insert into ff_routes
532: (route_id,
533: user_defined_flag,

Line 531: insert into ff_routes

527: null -- never stored, no expiry details needed
528: );
529: -- Insert row in FF_ROUTES for this dimension
530: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',8);
531: insert into ff_routes
532: (route_id,
533: user_defined_flag,
534: route_name,
535: description,

Line 538: (ff_routes_s.nextval,

534: route_name,
535: description,
536: text)
537: values
538: (ff_routes_s.nextval,
539: 'N',
540: 'GB Person-level Contracted In YTD Balance Dimension',
541: 'Summed data for the PERSON-LEVEL CONTRACTED IN YTD balance dimension',
542: ' pay_balance_feeds_f FEED

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

615: l_dimension_expired := 1;
616: end if;
617: end;'
618: );
619: -- Insert row in FF_ROUTES for this dimension
620: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',9);
621: insert into ff_routes
622: (route_id,
623: user_defined_flag,

Line 621: insert into ff_routes

617: end;'
618: );
619: -- Insert row in FF_ROUTES for this dimension
620: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',9);
621: insert into ff_routes
622: (route_id,
623: user_defined_flag,
624: route_name,
625: description,

Line 628: (ff_routes_s.nextval,

624: route_name,
625: description,
626: text)
627: values
628: (ff_routes_s.nextval,
629: 'N',
630: 'GB Payments Balance Dimension',
631: 'Summed data for the PAYMENTS balance dimension',
632: ' pay_balance_feeds_f FEED