[Home] [Help]
348: x number;
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,
400: (
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,
419: sysdate);
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',
440: 'TAX_GROUP',
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',
457: 'TAX_UNIT_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');
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);
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');
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);
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',
479: where context_name in ('DATE_EARNED',
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',
498: 'SOURCE_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',
520: 'BUSINESS_GROUP_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',
531: 'PAYROLL_ID',
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',
542: 'PAYROLL_ID',
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',
553: 'PAYROLL_ID',
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',
567: 'ASSIGNMENT_ACTION_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',
580: 'TAX_UNIT_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',
588: where context_name in ('ASSIGNMENT_ID',
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',
637: p_data_type in varchar2,
638: p_sequence_no in number
639: ) is
640: begin
641: hr_utility.set_location('hrstrdbi.insert_route_parameters', 1);
642: insert into ff_route_parameters
643: (route_id,
644: sequence_no,
645: parameter_name,
660: p_route_parameter_id in number,
661: p_value in varchar2
662: ) is
663: begin
664: hr_utility.set_location('hrstrdbi.insert_route_parameter_values', 1);
665: insert into ff_route_parameter_values
666: (route_parameter_id,
667: user_entity_id,
668: value,
682: p_context_id in number,
683: p_sequence_no in number
684: ) is
685: begin
686: hr_utility.set_location('hrstrdbi.insert_route_context_usages', 1);
687: insert into ff_route_context_usages
688: (route_id,
689: context_id,
690: sequence_no)
702: p_description in varchar2,
703: p_notfound_allowed_flag in varchar2 default 'N'
704: ) is
705: begin
706: hr_utility.set_location('hrstrdbi.insert_user_entity', 1);
707: insert into ff_user_entities
708: (user_entity_id,
709: business_group_id,
710: legislation_code,
746: p_data_type in varchar2,
747: p_null_allowed_flag in varchar2
748: ) is
749: begin
750: hr_utility.set_location('hrstrdbi.insert_database_item', 1);
751: hr_utility.trace ('creating : ' || p_user_name);
752: insert into ff_database_items (
753: user_name,
754: user_entity_id,
747: p_null_allowed_flag in varchar2
748: ) is
749: begin
750: hr_utility.set_location('hrstrdbi.insert_database_item', 1);
751: hr_utility.trace ('creating : ' || p_user_name);
752: insert into ff_database_items (
753: user_name,
754: user_entity_id,
755: data_type,
784: p_description in varchar2,
785: p_text in varchar2
786: ) is
787: begin
788: hr_utility.trace ('creating route : ' || p_route_name);
789: hr_utility.set_location('hrstrdbi.insert_route', 1);
790: insert into ff_routes
791: (route_id,
792: route_name,
785: p_text in varchar2
786: ) is
787: begin
788: hr_utility.trace ('creating route : ' || p_route_name);
789: hr_utility.set_location('hrstrdbi.insert_route', 1);
790: insert into ff_routes
791: (route_id,
792: route_name,
793: user_defined_flag,
815: BEGIN
816: --
817: -- get the context ids from the context table
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';
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
827: into l_assign_id_context_id
828: from ff_contexts
829: where context_name = 'ASSIGNMENT_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
833: into l_payroll_action_id_context_id
834: from ff_contexts
835: where context_name = 'PAYROLL_ACTION_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
839: into l_assign_action_id_context_id
840: from ff_contexts
841: where context_name = 'ASSIGNMENT_ACTION_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
845: into l_payroll_id_context_id
846: from ff_contexts
847: where context_name = 'PAYROLL_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
851: into l_accrual_plan_id_context_id
852: from ff_contexts
853: where context_name = 'ACCRUAL_PLAN_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
857: into l_original_entry_id
858: from ff_contexts
859: where context_name = 'ORIGINAL_ENTRY_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
863: into l_element_entry_id
864: from ff_contexts
865: where context_name = 'ELEMENT_ENTRY_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
869: into l_element_type_id
870: from ff_contexts
871: where context_name = 'ELEMENT_TYPE_ID';
5630: --
5631: --
5632: -- PLSQL mod function
5633: --
5634: hr_utility.set_location ('hrstrdbi.insert_functions' , 10);
5635: load_function('MOD',
5636: 'N',
5637: 'MOD',
5638: 'Function to implement plsql mod function',
5639: l_function_id,
5640: 'MODULUS'
5641: );
5642: --
5643: hr_utility.set_location ('hrstrdbi.insert_functions' , 11);
5644: load_parameter(1,
5645: l_function_id,
5646: 'N', 'P_VAL1');
5647: --
5644: load_parameter(1,
5645: l_function_id,
5646: 'N', 'P_VAL1');
5647: --
5648: hr_utility.set_location ('hrstrdbi.insert_functions' , 12);
5649: load_parameter(2,
5650: l_function_id,
5651: 'N', 'P_VAL2');
5652: --
5651: 'N', 'P_VAL2');
5652: --
5653: -- The following function GET_HOURS_WORKED is used by report HRUTLHRS.
5654: --
5655: hr_utility.set_location ('hrstrdbi.insert_functions' , 10);
5656: load_function('GET_HOURS_WORKED',
5657: 'N',
5658: 'hrfastanswers.get_hours_worked',
5659: 'Function to return the number of overtime hours worked',
5659: 'Function to return the number of overtime hours worked',
5660: l_function_id
5661: );
5662: --
5663: hr_utility.set_location ('hrstrdbi.insert_functions' , 11);
5664: load_parameter(1,
5665: l_function_id,
5666: 'N', 'P_MULTIPLE');
5667: --
5664: load_parameter(1,
5665: l_function_id,
5666: 'N', 'P_MULTIPLE');
5667: --
5668: hr_utility.set_location ('hrstrdbi.insert_functions', 12);
5669: load_context_usage(1,
5670: l_function_id,
5671: 'ASSIGNMENT_ID');
5672: --
5669: load_context_usage(1,
5670: l_function_id,
5671: 'ASSIGNMENT_ID');
5672: --
5673: hr_utility.set_location ('hrstrdbi.insert_functions', 13);
5674: load_context_usage(2,
5675: l_function_id,
5676: 'DATE_EARNED');
5677: --
5674: load_context_usage(2,
5675: l_function_id,
5676: 'DATE_EARNED');
5677: --
5678: hr_utility.set_location ('hrstrdbi.insert_functions', 14);
5679: --
5680: -- CURRENCY_CONVERT_AMOUNT function
5681: --
5682: load_function('CURRENCY_CONVERT_AMOUNT',
5705: load_parameter(5,
5706: l_function_id,
5707: 'T', 'rate_type');
5708: --
5709: hr_utility.set_location ('hrstrdbi.insert_functions', 15);
5710: --
5711: -- GET_RATE_TYPE function
5712: --
5713: load_function('GET_RATE_TYPE',
5728: load_parameter(3,
5729: l_function_id,
5730: 'T', 'processing_type');
5731: --
5732: hr_utility.set_location ('hrstrdbi.insert_functions', 16);
5733: --
5734: -- CHECK_RATE_TYPE function
5735: --
5736: load_function('CHECK_RATE_TYPE',
5743: load_parameter(1,
5744: l_function_id,
5745: 'T', 'rate_type');
5746: --
5747: hr_utility.set_location ('hrstrdbi.insert_functions', 17);
5748: --
5749: -- accrual functions
5750: --
5751: /********* CALCULATE_PAYROLL_PERIODS ***********************/
6148: load_context_usage(2,
6149: l_function_id,
6150: 'ACCRUAL_PLAN_ID');
6151: --
6152: hr_utility.set_location ('hrstrdbi.insert_functions', 15);
6153: --
6154: load_function('CHK_NAT_ID_FORMAT',
6155: 'T',
6156: 'hr_ni_chk_pkg.chk_nat_id_format',
6164: load_parameter(2,
6165: l_function_id,
6166: 'T', 'format');
6167: --
6168: hr_utility.set_location ('hrstrdbi.insert_functions', 16);
6169: --
6170: load_function('COUNT_WORKING_DAYS',
6171: 'T',
6172: 'hr_cal_abs_dur_pkg.count_working_days',
6180: load_parameter(2,
6181: l_function_id,
6182: 'T', 'total_days');
6183: --
6184: hr_utility.set_location ('hrstrdbi.insert_functions', 17);
6185: --
6186: /********* ITERATION_INITIALISE ***********************/
6187: --
6188: load_function('ITERATION_INITIALISE',
6206: load_context_usage(1,
6207: l_function_id,
6208: 'ELEMENT_ENTRY_ID');
6209: --
6210: hr_utility.set_location ('hrstrdbi.insert_functions', 18);
6211: --
6212: /********* ITERATION_GET_INTERPOLATION ****************/
6213: --
6214: load_function('ITERATION_GET_INTERPOLATION',
6224: load_context_usage(1,
6225: l_function_id,
6226: 'ELEMENT_ENTRY_ID');
6227: --
6228: hr_utility.set_location ('hrstrdbi.insert_functions', 19);
6229: --
6230: /********* ITERATION_GET_BINARY ***********************/
6231: --
6232: load_function('ITERATION_GET_BINARY',
6242: load_context_usage(1,
6243: l_function_id,
6244: 'ELEMENT_ENTRY_ID');
6245: --
6246: hr_utility.set_location ('hrstrdbi.insert_functions', 20);
6247: --
6248: /********* ITERATION_GET_HIGH ***********************/
6249: --
6250: load_function('ITERATION_GET_HIGH',
6256: load_context_usage(1,
6257: l_function_id,
6258: 'ELEMENT_ENTRY_ID');
6259: --
6260: hr_utility.set_location ('hrstrdbi.insert_functions', 21);
6261: --
6262: /********* ITERATION_GET_LOW ***********************/
6263: --
6264: load_function('ITERATION_GET_LOW',
6422: 'Template conversion from Days to Hours',
6423: l_text,
6424: NULL);
6425: --
6426: hr_utility.set_location ('hrstrdbi.insert_formula', 114);
6427: --
6428: -- BIS template formula TEMPLATE_FTE
6429: --
6430: l_text := '
6602: 'Calculates Assignment Full Time Equivalent Value',
6603: l_text,
6604: NULL);
6605: --
6606: hr_utility.set_location ('hrstrdbi.insert_formula', 115);
6607: --
6608: -- BIS template formula TEMPLATE_HEAD
6609: --
6610: l_text := '
6676: 'Calculates Assignment Headcount Value',
6677: l_text,
6678: NULL);
6679: --
6680: hr_utility.set_location ('hrstrdbi.insert_formula', 116);
6681: --
6682: -- BIS template formula EXAMPLE_BIS_OT_BAND1
6683: --
6684: l_text := '
6750: 'Calculate Overtime',
6751: l_text,
6752: NULL);
6753: --
6754: hr_utility.set_location ('hrstrdbi.insert_formula', 117);
6755: --
6756: l_text := '
6757: DEFAULT FOR ACP_CONTINUOUS_SERVICE_DATE IS ''4712/12/31 00:00:00'' (date)
6758: DEFAULT FOR ACP_SERVICE_START_DATE IS ''4712/12/31 00:00:00'' (date)
6888: 'Seeded carry over payroll formula for PTO accruals',
6889: l_text,
6890: NULL);
6891: --
6892: hr_utility.set_location ('hrstrdbi.insert_formula', 118);
6893: --
6894: l_text := '
6895: /* ------------------------------------------------------------------------
6896: NAME : PTO_PAYROLL_PERIOD_ACCRUAL
7053: 'Seeded looping payroll formula for PTO accruals',
7054: l_text,
7055: NULL);
7056: --
7057: hr_utility.set_location ('hrstrdbi.insert_formula', 119);
7058: --
7059: l_text := '
7060: /* ------------------------------------------------------------------------
7061: NAME : PTO_PAYROLL_CALCULATION
7428: 'Seeded top level payroll formula for PTO accruals',
7429: l_text,
7430: NULL);
7431: --
7432: hr_utility.set_location ('hrstrdbi.insert_formula', 120);
7433: --
7434: l_text := '
7435: /* ------------------------------------------------------------------------
7436: NAME : PTO_ROLLING_CARRYOVER
7476: 'Seeded carry over rolling formula for PTO accruals',
7477: l_text,
7478: NULL);
7479: --
7480: hr_utility.set_location ('hrstrdbi.insert_formula', 121);
7481: --
7482: l_text := '
7483: /* ------------------------------------------------------------------------
7484: NAME : PTO_ROLLING_PERIOD_ACCRUAL
7600: 'Seeded looping rolling formula for PTO accruals',
7601: l_text,
7602: NULL);
7603: --
7604: hr_utility.set_location ('hrstrdbi.insert_formula', 122);
7605: --
7606: l_text := '
7607: /* ------------------------------------------------------------------------
7608: NAME : PTO_ROLLING_ACCRUAL
7939: 'Seeded top level rolling formula for PTO accruals',
7940: l_text,
7941: NULL);
7942: --
7943: hr_utility.set_location ('hrstrdbi.insert_formula', 123);
7944: --
7945: l_text := '
7946: /* ------------------------------------------------------------------------
7947: NAME : PTO_SIMPLE_CARRYOVER
8002: 'Seeded simple carryover formula for PTO accruals',
8003: l_text,
8004: NULL);
8005: --
8006: hr_utility.set_location ('hrstrdbi.insert_formula', 124);
8007: --
8008: l_text := '
8009: /* ------------------------------------------------------------------------
8010: NAME : PTO_SIMPLE_MULTIPLIER_PERIOD_ACCRUAL
8124: 'Seeded simple looping formula for PTO accruals',
8125: l_text,
8126: NULL);
8127: --
8128: hr_utility.set_location ('hrstrdbi.insert_formula', 125);
8129: --
8130: l_text := '
8131: /* ------------------------------------------------------------------------
8132: NAME : PTO_SIMPLE_MULTIPLIER
8469: l_text,
8470: NULL);
8471: --
8472: --
8473: hr_utility.set_location ('hrstrdbi.insert_formula', 126);
8474: --
8475: l_text := '
8476: /* ------------------------------------------------------------------------
8477: NAME : PTO_INELIGIBILITY_CALCULATION
8631: 'Seeded formula allowing paymix to cope with PTO accruals upgrade',
8632: l_text,
8633: NULL);
8634: --
8635: hr_utility.set_location ('hrstrdbi.insert_formula', 127);
8636: --
8637: l_text := ' /**************************************************************
8638: FORMULA NAME: CHECK_RATE_TYPE
8639: FORMULA TYPE: User Table Validation
8685: 'Checks that conversion type exists',
8686: l_text,
8687: NULL);
8688: --
8689: hr_utility.set_location ('hrstrdbi.insert_formula', 128);
8690: --
8691: l_text := '/*******************************************************************
8692: FORMULA NAME: TEMPLATE_BIS_TRAINING_CONVERT_DURATION
8693: FORMULA TYPE: Quickpaint
8781: 'Seeded formula to Calculate Training Duration',
8782: l_text,
8783: NULL);
8784: --
8785: hr_utility.set_location ('hrstrdbi.insert_formula', 128);
8786: --
8787: l_text := '/*
8788: FORMULA NAME: TEMPLATE_ABSENCE_DURATION
8789: FORMULA TYPE: Quickpaint
8933: 'formula template for absence duration calculation',
8934: l_text,
8935: NULL);
8936: --
8937: hr_utility.set_location ('hrstrdbi.insert_formula', 129);
8938: --
8939: l_text := '
8940: /******************************************************************************
8941: *
8984: 'This formula is used in the grossup calculations',
8985: l_text,
8986: NULL);
8987: --
8988: hr_utility.set_location ('hrstrdbi.insert_formula', 130);
8989: --
8990: l_text := '
8991: /******************************************************************************
8992: *
9125: 'This formula is used in the grossup calculations',
9126: l_text,
9127: NULL);
9128: --
9129: hr_utility.set_location ('hrstrdbi.insert_formula', 131);
9130: --
9131: l_text := '
9132: /******************************************************************************
9133: *
9168: 'This formula is used to get a job assignment_name',
9169: l_text,
9170: NULL);
9171: --
9172: hr_utility.set_location ('hrstrdbi.insert_formula', 132);
9173: --
9174: l_text := '
9175: /* ------------------------------------------------------------------------
9176: FORMULA NAME : PTO_ORACLE_SKIP_RULE
9228: 'Skips PTO elements that have already been processed in the same period',
9229: l_text,
9230: NULL);
9231: --
9232: hr_utility.set_location ('hrstrdbi.insert_formula', 133);
9233: --
9234: l_text := '
9235: /* ------------------------------------------------------------------------
9236: NAME : PTO_PAYROLL_BALANCE_CALCULATION
9713: 'Seeded top level payroll formula for PTO accruals',
9714: l_text,
9715: NULL);
9716: --
9717: hr_utility.set_location ('hrstrdbi.insert_formula', 134);
9718: --
9719: l_text := '
9720: /* ------------------------------------------------------------------------
9721: NAME : PTO_SIMPLE_BALANCE_MULTIPLIER
10156: 'Seeded top level formula for PTO accruals',
10157: l_text,
10158: NULL);
10159: --
10160: hr_utility.set_location ('hrstrdbi.insert_formula', 135);
10161: --
10162: l_text := '
10163: /* ------------------------------------------------------------------------
10164: NAME : PTO_HD_ANNIVERSARY_BALANCE
10587: 'Seeded simple top level formula for PTO accruals',
10588: l_text,
10589: NULL);
10590: --
10591: hr_utility.set_location ('hrstrdbi.insert_formula', 136);
10592: --
10593: l_text := '
10594: /* ------------------------------------------------------------------------
10595: NAME : PTO_HD_ANNIVERSARY_PERIOD_ACCRUAL
10709: 'Seeded hire date anniversary looping formula for PTO accruals',
10710: l_text,
10711: NULL);
10712: --
10713: hr_utility.set_location ('hrstrdbi.insert_formula', 137);
10714: --
10715: l_text := '
10716: /* ------------------------------------------------------------------------
10717: NAME : PTO_HD_ANNIVERSARY_CARRYOVER
10770: 'Seeded simple carryover formula for PTO accruals',
10771: l_text,
10772: NULL);
10773: --
10774: hr_utility.set_location ('hrstrdbi.insert_formula', 138);
10775: --
10776: l_text := '
10777: /* -------------------------------------------------------
10778: NAME : PTO_TAGGING_FORMULA
10819: 'Seeded top level payroll formula for PTO accruals',
10820: l_text,
10821: NULL);
10822: --
10823: hr_utility.set_location ('hrstrdbi.insert_formula', 139);
10824: --
10825: l_text := '
10826: /* -------------------------------------------------------
10827: NAME : HR_CAGR_PYS_TEMPLATE
10922: 'HR_CAGR_PYS_TEMPLATE',
10923: l_text,
10924: NULL);
10925: --
10926: hr_utility.set_location ('hrstrdbi.insert_formula', 140);
10927: --
10928: l_text := '
10929: /* -------------------------------------------------------
10930: NAME : HR_CAGR_TEMPLATE
11026: 'HR_CAGR_TEMPLATE',
11027: l_text,
11028: NULL);
11029: --
11030: hr_utility.set_location ('hrstrdbi.insert_formula', 141);
11031: --
11032: l_text := '
11033: /****************************************************************
11034: FORMULA NAME: PROMOTION_TEMPLATE
11119: 'Seeded Promotions Formula',
11120: l_text,
11121: NULL);
11122: --
11123: hr_utility.set_location ('hrstrdbi.insert_formula', 142);
11124: --
11125: --
11126: end insert_formula;
11127: --
11128: procedure insert_user_tables is
11129: --
11130: l_formula_id number;
11131: begin
11132: hr_utility.set_location ('hrstrdbi.insert_user_tables', 1);
11133: --
11134: BEGIN
11135: select formula_id into l_formula_id
11136: FROM ff_formulas_f
11295: ,sysdate
11296: from pay_user_tables udt
11297: where udt.user_table_name = 'EXCHANGE_RATE_TYPES';
11298: --
11299: hr_utility.set_location ('hrstrdbi.insert_user_tables', 2);
11300: --
11301: end insert_user_tables;
11302: --
11303: procedure insert_monetary_units is