[Home] [Help]
100: alogue 30-NOV-2000 - New PAY_EARNED_PERIOD_CORE route, PAY_PD_DETAILS_CORE
101: user entity, and PAY_EARNED dbitems.
102: alogue 26-SEP-2000 - Fix to CHECK_RATE_TYPE formula.
103: Source_text into Oracle Payroll
104: ff_ftype_context_usages.
105: alogue 05-JUN-2000 - Fixes to SEH_ASSIGN_HR_ADDRESS, SEH_PER_PERSON_ADDRESS,
106: and SEH_CON_PERSON_ADDRESS route texts.
107: alogue 17-MAY-2000 - R11.5 Concurrent patch Entity Horizon changes:
108: Change to SEH_PER_PERSON_DETAILS, bug 1096840.
420: end do_insert;
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',
441: 'SOURCE_TEXT');
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',
458: 'JURISDICTION_CODE');
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: --
465: where context_name in ('DATE_EARNED', 'ASSIGNMENT_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: --
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);
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');
480: 'ASSIGNMENT_ID', 'BUSINESS_GROUP_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',
499: 'TAX_GROUP');
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');
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',
521: 'PERSON_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',
532: 'BUSINESS_GROUP_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',
543: 'BUSINESS_GROUP_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',
554: 'BUSINESS_GROUP_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',
568: 'ELEMENT_TYPE_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',
581: 'PERSON_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');
589: 'DATE_EARNED');
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',