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.HRSTRDBI dependencies on FF_CONTEXTS

Line 194: OAB and other new ff_contexts, route

190: CURRENCY_CONVERT_AMOUNT, GET_RATE_TYPE,
191: CHECK_RATE_TYPE and accrual functions
192: into ff_functions.
193: alogue 11-JAN-1999 - R11.5 Entity Horizon changes:
194: OAB and other new ff_contexts, route
195: ASSIGNMENT_BUDGET_VALUES and dbitems,
196: ASSIGNMENT_FULL_TIME_CONDITIONS route
197: and dbitems.
198: R11.5 change whereby date contexts are passed

Line 307: ff_contexts.

303: set to yes - there wont be an entry for the
304: first run.
305: mwcallag 28-FEB-1994 - Database name changed from 'ASS_%' to 'ASG_%'.
306: mwcallag 11-JAN-1994 - New context of Element type id added to
307: ff_contexts.
308: mwcallag 06-JAN-1994 - Contact routes changed to use contact_person_id.
309: mwcallag 15-DEC-1993 - HR location (general, GB and US) DB items added.
310: G417 ASS_SALARY changed to Number data type.
311: ASS_SALARY_BASIS_CODE DB item added.

Line 342: -- | Insert FF contexts |

338: */
339: procedure insert_context is
340: --
341: -- +==================================================================+
342: -- | Insert FF contexts |
343: -- +==================================================================+
344: --
345: begin
346: declare

Line 353: insert into ff_contexts

349: begin
350: x := ffdict.get_context_level;
351: --
352: hr_utility.set_location('hrstrdbi.ff_context_do_insert', 1);
353: insert into ff_contexts
354: (context_id,
355: context_level,
356: context_name,
357: data_type)

Line 359: (ff_contexts_s.nextval,

355: context_level,
356: context_name,
357: data_type)
358: values
359: (ff_contexts_s.nextval,
360: x,
361: l_context_name,
362: l_data_type);
363: end;

Line 426: from ff_contexts CON

422: do_insert ('Oracle Payroll');
423: hr_utility.set_location('hrstrdbi.insert_context', 1);
424: insert into ff_ftype_context_usages (formula_type_id, context_id)
425: select ff_formula_types_s.currval, CON.context_id
426: from ff_contexts CON
427: where context_name in ('BUSINESS_GROUP_ID',
428: 'PAYROLL_ID',
429: 'PAYROLL_ACTION_ID',
430: 'ASSIGNMENT_ID',

Line 447: from ff_contexts CON

443: do_insert ('Payment');
444: hr_utility.set_location('hrstrdbi.insert_context', 2);
445: insert into ff_ftype_context_usages (formula_type_id, context_id)
446: select ff_formula_types_s.currval, CON.context_id
447: from ff_contexts CON
448: where context_name in ('BUSINESS_GROUP_ID',
449: 'PAYROLL_ID',
450: 'PAYROLL_ACTION_ID',
451: 'ASSIGNMENT_ID',

Line 464: from ff_contexts CON

460: do_insert ('Assignment Set');
461: hr_utility.set_location('hrstrdbi.insert_context', 3);
462: insert into ff_ftype_context_usages (formula_type_id, context_id)
463: select ff_formula_types_s.currval, CON.context_id
464: from ff_contexts CON
465: where context_name in ('DATE_EARNED', 'ASSIGNMENT_ID');
466: --
467: do_insert ('QuickPaint');
468: hr_utility.set_location('hrstrdbi.insert_context', 4);

Line 471: from ff_contexts CON

467: do_insert ('QuickPaint');
468: hr_utility.set_location('hrstrdbi.insert_context', 4);
469: insert into ff_ftype_context_usages (formula_type_id, context_id)
470: select ff_formula_types_s.currval, CON.context_id
471: from ff_contexts CON
472: where context_name in ('DATE_EARNED', 'ASSIGNMENT_ID');
473: --
474: do_insert ('Element Input Validation');
475: hr_utility.set_location('hrstrdbi.insert_context', 5);

Line 478: from ff_contexts CON

474: do_insert ('Element Input Validation');
475: hr_utility.set_location('hrstrdbi.insert_context', 5);
476: insert into ff_ftype_context_usages (formula_type_id, context_id)
477: select ff_formula_types_s.currval, CON.context_id
478: from ff_contexts CON
479: where context_name in ('DATE_EARNED',
480: 'ASSIGNMENT_ID', 'BUSINESS_GROUP_ID');
481: --
482: do_insert ('Element Skip');

Line 486: from ff_contexts CON

482: do_insert ('Element Skip');
483: hr_utility.set_location('hrstrdbi.insert_context', 6);
484: insert into ff_ftype_context_usages (formula_type_id, context_id)
485: select ff_formula_types_s.currval, CON.context_id
486: from ff_contexts CON
487: where context_name in ('BUSINESS_GROUP_ID',
488: 'PAYROLL_ID',
489: 'PAYROLL_ACTION_ID',
490: 'ASSIGNMENT_ID',

Line 505: from ff_contexts CON

501: do_insert ('Legislative Check');
502: hr_utility.set_location('hrstrdbi.insert_context', 7);
503: insert into ff_ftype_context_usages (formula_type_id, context_id)
504: select ff_formula_types_s.currval, CON.context_id
505: from ff_contexts CON
506: where context_name in ('ASSIGNMENT_ID',
507: 'ASSIGNMENT_ACTION_ID',
508: 'DATE_EARNED');
509: --

Line 514: from ff_contexts CON

510: do_insert ('Accrual');
511: hr_utility.set_location('hrstrdbi.insert_context', 8);
512: insert into ff_ftype_context_usages (formula_type_id, context_id)
513: select ff_formula_types_s.currval, CON.context_id
514: from ff_contexts CON
515: where context_name in ('ASSIGNMENT_ID',
516: 'ASSIGNMENT_ACTION_ID',
517: 'DATE_EARNED',
518: 'ACCRUAL_PLAN_ID',

Line 527: from ff_contexts CON

523: do_insert ('Accrual Subformula');
524: hr_utility.set_location('hrstrdbi.insert_context', 9);
525: insert into ff_ftype_context_usages (formula_type_id, context_id)
526: select ff_formula_types_s.currval, CON.context_id
527: from ff_contexts CON
528: where context_name in ('ASSIGNMENT_ID',
529: 'DATE_EARNED',
530: 'ACCRUAL_PLAN_ID',
531: 'PAYROLL_ID',

Line 538: from ff_contexts CON

534: do_insert ('Accrual Carryover');
535: hr_utility.set_location('hrstrdbi.insert_context', 10);
536: insert into ff_ftype_context_usages (formula_type_id, context_id)
537: select ff_formula_types_s.currval, CON.context_id
538: from ff_contexts CON
539: where context_name in ('ASSIGNMENT_ID',
540: 'DATE_EARNED',
541: 'ACCRUAL_PLAN_ID',
542: 'PAYROLL_ID',

Line 549: from ff_contexts CON

545: do_insert ('Accrual Ineligibility');
546: hr_utility.set_location('hrstrdbi.insert_context', 11);
547: insert into ff_ftype_context_usages (formula_type_id, context_id)
548: select ff_formula_types_s.currval, CON.context_id
549: from ff_contexts CON
550: where context_name in ('ASSIGNMENT_ID',
551: 'DATE_EARNED',
552: 'ACCRUAL_PLAN_ID',
553: 'PAYROLL_ID',

Line 560: from ff_contexts CON

556: do_insert ('Net to Gross');
557: hr_utility.set_location('hrstrdbi.insert_context', 12);
558: insert into ff_ftype_context_usages (formula_type_id, context_id)
559: select ff_formula_types_s.currval, CON.context_id
560: from ff_contexts CON
561: where context_name in ('BUSINESS_GROUP_ID',
562: 'PAYROLL_ID',
563: 'PAYROLL_ACTION_ID',
564: 'ASSIGNMENT_ID',

Line 574: from ff_contexts CON

570: do_insert('CAGR');
571: hr_utility.set_location('hrstrdbi.insert_context', 13);
572: insert into ff_ftype_context_usages (formula_type_id, context_id)
573: select ff_formula_types_s.currval, CON.context_id
574: from ff_contexts CON
575: where context_name in ('BUSINESS_GROUP_ID',
576: 'PAYROLL_ID',
577: 'ASSIGNMENT_ID',
578: 'DATE_EARNED',

Line 587: from ff_contexts CON

583: do_insert('Promotion');
584: hr_utility.set_location('hrstrdbi.insert_context', 14);
585: insert into ff_ftype_context_usages (formula_type_id, context_id)
586: select ff_formula_types_s.currval, CON.context_id
587: from ff_contexts CON
588: where context_name in ('ASSIGNMENT_ID',
589: 'DATE_EARNED');
590: --
591: do_insert('Payroll Run Proration');

Line 595: from ff_contexts CON

591: do_insert('Payroll Run Proration');
592: hr_utility.set_location('hrstrdbi.insert_context', 15);
593: insert into ff_ftype_context_usages (formula_type_id, context_id)
594: select ff_formula_types_s.currval, CON.context_id
595: from ff_contexts CON
596: where context_name in ('BUSINESS_GROUP_ID',
597: 'PAYROLL_ID',
598: 'PAYROLL_ACTION_ID',
599: 'ASSIGNMENT_ID',

Line 822: from ff_contexts

818: --
819: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 1);
820: select context_id
821: into l_date_earned_context_id
822: from ff_contexts
823: where context_name = 'DATE_EARNED';
824: --
825: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 2);
826: select context_id

Line 828: from ff_contexts

824: --
825: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 2);
826: select context_id
827: into l_assign_id_context_id
828: from ff_contexts
829: where context_name = 'ASSIGNMENT_ID';
830: --
831: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 3);
832: select context_id

Line 834: from ff_contexts

830: --
831: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 3);
832: select context_id
833: into l_payroll_action_id_context_id
834: from ff_contexts
835: where context_name = 'PAYROLL_ACTION_ID';
836: --
837: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 4);
838: select context_id

Line 840: from ff_contexts

836: --
837: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 4);
838: select context_id
839: into l_assign_action_id_context_id
840: from ff_contexts
841: where context_name = 'ASSIGNMENT_ACTION_ID';
842: --
843: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 5);
844: select context_id

Line 846: from ff_contexts

842: --
843: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 5);
844: select context_id
845: into l_payroll_id_context_id
846: from ff_contexts
847: where context_name = 'PAYROLL_ID';
848: --
849: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 6);
850: select context_id

Line 852: from ff_contexts

848: --
849: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 6);
850: select context_id
851: into l_accrual_plan_id_context_id
852: from ff_contexts
853: where context_name = 'ACCRUAL_PLAN_ID';
854: --
855: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 7);
856: select context_id

Line 858: from ff_contexts

854: --
855: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 7);
856: select context_id
857: into l_original_entry_id
858: from ff_contexts
859: where context_name = 'ORIGINAL_ENTRY_ID';
860: --
861: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 8);
862: select context_id

Line 864: from ff_contexts

860: --
861: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 8);
862: select context_id
863: into l_element_entry_id
864: from ff_contexts
865: where context_name = 'ELEMENT_ENTRY_ID';
866: --
867: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 9);
868: select context_id

Line 870: from ff_contexts

866: --
867: hr_utility.set_location('hrstrdbi.insert_routes_db_items', 9);
868: select context_id
869: into l_element_type_id
870: from ff_contexts
871: where context_name = 'ELEMENT_TYPE_ID';
872: --
873: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++
874: -- +

Line 5613: from ff_contexts

5609: begin
5610: --
5611: select context_id
5612: into l_context_id
5613: from ff_contexts
5614: where context_name = p_context_name;
5615: --
5616: insert into ff_function_context_usages
5617: (FUNCTION_ID