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_FORMULA_TYPES

Line 405: insert into ff_formula_types

401: p_formula_type_name in varchar2
402: ) is
403: begin
404: hr_utility.set_location('hrstrdbi.ff_type_do_insert', 1);
405: insert into ff_formula_types
406: (formula_type_id,
407: formula_type_name,
408: last_update_date,
409: last_updated_by,

Line 413: values (ff_formula_types_s.nextval,

409: last_updated_by,
410: last_update_login,
411: created_by,
412: creation_date)
413: values (ff_formula_types_s.nextval,
414: p_formula_type_name,
415: sysdate,
416: 0,
417: 0,

Line 425: select ff_formula_types_s.currval, CON.context_id

421: begin
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',

Line 446: select ff_formula_types_s.currval, CON.context_id

442: --
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',

Line 463: select ff_formula_types_s.currval, CON.context_id

459: --
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');

Line 470: select ff_formula_types_s.currval, CON.context_id

466: --
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');

Line 477: select ff_formula_types_s.currval, CON.context_id

473: --
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: --

Line 485: select ff_formula_types_s.currval, CON.context_id

481: --
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',

Line 504: select ff_formula_types_s.currval, CON.context_id

500: --
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');

Line 513: select ff_formula_types_s.currval, CON.context_id

509: --
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',

Line 526: select ff_formula_types_s.currval, CON.context_id

522: --
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',

Line 537: select ff_formula_types_s.currval, CON.context_id

533: --
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',

Line 548: select ff_formula_types_s.currval, CON.context_id

544: --
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',

Line 559: select ff_formula_types_s.currval, CON.context_id

555: --
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',

Line 573: select ff_formula_types_s.currval, CON.context_id

569: --
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',

Line 586: select ff_formula_types_s.currval, CON.context_id

582: --
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: --

Line 594: select ff_formula_types_s.currval, CON.context_id

590: --
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',

Line 6400: from ff_formula_types

6396: ';
6397: --
6398: select formula_type_id
6399: into l_ftype_id
6400: from ff_formula_types
6401: where formula_type_name = 'QuickPaint';
6402: --
6403: INSERT INTO ff_formulas_f
6404: (formula_id,

Line 6580: from ff_formula_types

6576: ';
6577: --
6578: select formula_type_id
6579: into l_ftype_id
6580: from ff_formula_types
6581: where formula_type_name = 'QuickPaint';
6582: --
6583: INSERT INTO ff_formulas_f
6584: (formula_id,

Line 6654: from ff_formula_types

6650: ';
6651: --
6652: select formula_type_id
6653: into l_ftype_id
6654: from ff_formula_types
6655: where formula_type_name = 'QuickPaint';
6656: --
6657: INSERT INTO ff_formulas_f
6658: (formula_id,

Line 6728: from ff_formula_types

6724: ';
6725: --
6726: select formula_type_id
6727: into l_ftype_id
6728: from ff_formula_types
6729: where formula_type_name = 'QuickPaint';
6730: --
6731: INSERT INTO ff_formulas_f
6732: (formula_id,

Line 6866: from ff_formula_types

6862: ';
6863: --
6864: select formula_type_id
6865: into l_ftype_id
6866: from ff_formula_types
6867: where formula_type_name = 'Accrual Carryover';
6868: --
6869: INSERT INTO ff_formulas_f
6870: (formula_id,

Line 7031: from ff_formula_types

7027: ';
7028: --
7029: select formula_type_id
7030: into l_ftype_id
7031: from ff_formula_types
7032: where formula_type_name = 'Accrual Subformula';
7033: --
7034: INSERT INTO ff_formulas_f
7035: (formula_id,

Line 7406: from ff_formula_types

7402: ';
7403: --
7404: select formula_type_id
7405: into l_ftype_id
7406: from ff_formula_types
7407: where formula_type_name = 'Accrual';
7408: --
7409: INSERT INTO ff_formulas_f
7410: (formula_id,

Line 7454: from ff_formula_types

7450: ';
7451: --
7452: select formula_type_id
7453: into l_ftype_id
7454: from ff_formula_types
7455: where formula_type_name = 'Accrual Carryover';
7456: --
7457: INSERT INTO ff_formulas_f
7458: (formula_id,

Line 7578: from ff_formula_types

7574: ';
7575: --
7576: select formula_type_id
7577: into l_ftype_id
7578: from ff_formula_types
7579: where formula_type_name = 'Accrual Subformula';
7580: --
7581: INSERT INTO ff_formulas_f
7582: (formula_id,

Line 7917: from ff_formula_types

7913: ';
7914: --
7915: select formula_type_id
7916: into l_ftype_id
7917: from ff_formula_types
7918: where formula_type_name = 'Accrual';
7919: --
7920: INSERT INTO ff_formulas_f
7921: (formula_id,

Line 7980: from ff_formula_types

7976: ';
7977: --
7978: select formula_type_id
7979: into l_ftype_id
7980: from ff_formula_types
7981: where formula_type_name = 'Accrual Carryover';
7982: --
7983: INSERT INTO ff_formulas_f
7984: (formula_id,

Line 8102: from ff_formula_types

8098: ';
8099: --
8100: select formula_type_id
8101: into l_ftype_id
8102: from ff_formula_types
8103: where formula_type_name = 'Accrual Subformula';
8104: --
8105: INSERT INTO ff_formulas_f
8106: (formula_id,

Line 8446: from ff_formula_types

8442: ';
8443: --
8444: select formula_type_id
8445: into l_ftype_id
8446: from ff_formula_types
8447: where formula_type_name = 'Accrual';
8448: --
8449: INSERT INTO ff_formulas_f
8450: (formula_id,

Line 8609: from ff_formula_types

8605: ';
8606: --
8607: select formula_type_id
8608: into l_ftype_id
8609: from ff_formula_types
8610: where formula_type_name = 'Accrual Ineligibility';
8611: --
8612: INSERT INTO ff_formulas_f
8613: (formula_id,

Line 8663: from ff_formula_types

8659: ';
8660: --
8661: select formula_type_id
8662: into l_ftype_id
8663: from ff_formula_types
8664: where formula_type_name = 'User Table Validation';
8665: --
8666: INSERT INTO ff_formulas_f
8667: (formula_id,

Line 8759: from ff_formula_types

8755: ';
8756: --
8757: select formula_type_id
8758: into l_ftype_id
8759: from ff_formula_types
8760: where formula_type_name = 'QuickPaint';
8761: --
8762: INSERT INTO ff_formulas_f
8763: (formula_id,

Line 8962: from ff_formula_types

8958: return payment_amount';
8959: --
8960: select formula_type_id
8961: into l_ftype_id
8962: from ff_formula_types
8963: where formula_type_name = 'Oracle Payroll';
8964: --
8965: INSERT INTO ff_formulas_f
8966: (formula_id,

Line 9103: from ff_formula_types

9099: ';
9100: --
9101: select formula_type_id
9102: into l_ftype_id
9103: from ff_formula_types
9104: where formula_type_name = 'Net to Gross';
9105: --
9106: INSERT INTO ff_formulas_f
9107: (formula_id,

Line 9146: from ff_formula_types

9142: RETURN assignment_name';
9143: --
9144: select formula_type_id
9145: into l_ftype_id
9146: from ff_formula_types
9147: where formula_type_name = 'QuickPaint';
9148: --
9149: INSERT INTO ff_formulas_f
9150: (formula_id,

Line 9206: from ff_formula_types

9202: RETURN SKIP_FLAG';
9203: --
9204: select formula_type_id
9205: into l_ftype_id
9206: from ff_formula_types
9207: where formula_type_name = 'Element Skip';
9208: --
9209: INSERT INTO ff_formulas_f
9210: (formula_id,

Line 9691: from ff_formula_types

9687: ';
9688: --
9689: select formula_type_id
9690: into l_ftype_id
9691: from ff_formula_types
9692: where formula_type_name = 'Accrual';
9693: --
9694: INSERT INTO ff_formulas_f
9695: (formula_id,

Line 10134: from ff_formula_types

10130: ';
10131: --
10132: select formula_type_id
10133: into l_ftype_id
10134: from ff_formula_types
10135: where formula_type_name = 'Accrual';
10136: --
10137: INSERT INTO ff_formulas_f
10138: (formula_id,

Line 10565: from ff_formula_types

10561: ';
10562: --
10563: select formula_type_id
10564: into l_ftype_id
10565: from ff_formula_types
10566: where formula_type_name = 'Accrual';
10567: --
10568: INSERT INTO ff_formulas_f
10569: (formula_id,

Line 10687: from ff_formula_types

10683: ';
10684: --
10685: select formula_type_id
10686: into l_ftype_id
10687: from ff_formula_types
10688: where formula_type_name = 'Accrual Subformula';
10689: --
10690: INSERT INTO ff_formulas_f
10691: (formula_id,

Line 10748: from ff_formula_types

10744: ';
10745: --
10746: select formula_type_id
10747: into l_ftype_id
10748: from ff_formula_types
10749: where formula_type_name = 'Accrual Carryover';
10750: --
10751: INSERT INTO ff_formulas_f
10752: (formula_id,

Line 10797: from ff_formula_types

10793: ';
10794: --
10795: select formula_type_id
10796: into l_ftype_id
10797: from ff_formula_types
10798: where formula_type_name = 'Oracle Payroll';
10799: --
10800: INSERT INTO ff_formulas_f
10801: (formula_id,

Line 10900: from ff_formula_types

10896: ';
10897: --
10898: select formula_type_id
10899: into l_ftype_id
10900: from ff_formula_types
10901: where formula_type_name = 'CAGR';
10902: --
10903: INSERT INTO ff_formulas_f
10904: (formula_id,

Line 11004: from ff_formula_types

11000: ';
11001: --
11002: select formula_type_id
11003: into l_ftype_id
11004: from ff_formula_types
11005: where formula_type_name = 'CAGR';
11006: --
11007: INSERT INTO ff_formulas_f
11008: (formula_id,

Line 11097: from ff_formula_types

11093: return l_count';
11094:
11095: select formula_type_id
11096: into l_ftype_id
11097: from ff_formula_types
11098: where formula_type_name = 'Promotion';
11099: --
11100: INSERT INTO ff_formulas_f
11101: (formula_id,