716: program => 'BULKCOMPILE' ,
717: argument1 => 'Oracle Payroll' ,
718: argument2 => l_formula_name );
719:
720: l_status_proc_rule_id := pay_formula_results.ins_stat_proc_rule
721: (
722: p_business_group_id =>l_business_group_id
723: ,p_legislation_code => NULL
724: ,p_effective_start_date => TO_DATE(l_date,'dd/mm/yyyy')
726: ,p_formula_id => l_formula_id
727: ,p_processing_rule => 'P'
728: );
729:
730: l_for_res_id := pay_formula_results.ins_form_res_rule
731: (
732: p_business_group_id => l_business_group_id
733: ,p_legislation_code => NULL
734: ,p_status_processing_rule_id => l_status_proc_rule_id
831: program => 'BULKCOMPILE' ,
832: argument1 => 'Oracle Payroll' ,
833: argument2 => l_formula_name );
834:
835: l_status_proc_rule_id := pay_formula_results.ins_stat_proc_rule
836: (
837: p_business_group_id =>l_business_group_id
838: ,p_legislation_code => NULL
839: ,p_effective_start_date => TO_DATE(l_date,'dd/mm/yyyy')
841: ,p_formula_id => l_formula_id
842: ,p_processing_rule => 'P'
843: );
844:
845: l_for_res_id := pay_formula_results.ins_form_res_rule
846: (
847: p_business_group_id => l_business_group_id
848: ,p_legislation_code => NULL
849: ,p_status_processing_rule_id => l_status_proc_rule_id
1172: program => 'BULKCOMPILE' ,
1173: argument1 => 'Oracle Payroll' ,
1174: argument2 => l_formula_name );
1175:
1176: l_status_proc_rule_id := pay_formula_results.ins_stat_proc_rule
1177: (
1178: p_business_group_id =>l_business_group_id
1179: ,p_legislation_code => NULL
1180: ,p_effective_start_date => TO_DATE(l_date,'dd/mm/yyyy')
1182: ,p_formula_id => l_formula_id
1183: ,p_processing_rule => 'P'
1184: );
1185:
1186: l_for_res_id := pay_formula_results.ins_form_res_rule
1187: (
1188: p_business_group_id => l_business_group_id
1189: ,p_legislation_code => NULL
1190: ,p_status_processing_rule_id => l_status_proc_rule_id
1550: program => 'BULKCOMPILE' ,
1551: argument1 => 'Oracle Payroll' ,
1552: argument2 => l_formula_name );
1553: --
1554: l_status_proc_rule_id := pay_formula_results.ins_stat_proc_rule
1555: (
1556: p_business_group_id => l_business_group_id
1557: ,p_legislation_code => NULL
1558: ,p_effective_start_date => TO_DATE(l_date,'dd/mm/yyyy')
1560: ,p_formula_id => l_formula_id
1561: ,p_processing_rule => 'P'
1562: );
1563:
1564: l_for_res_id := pay_formula_results.ins_form_res_rule
1565: (
1566: p_business_group_id => l_business_group_id
1567: ,p_legislation_code => NULL
1568: ,p_status_processing_rule_id => l_status_proc_rule_id
2367: LOOP
2368: l_ele_id := ceti.element_type_id;
2369: END LOOP;
2370:
2371: l_status_proc_rule_id := pay_formula_results.ins_stat_proc_rule
2372: (
2373: p_business_group_id => l_business_group_id
2374: ,p_legislation_code => NULL
2375: ,p_effective_start_date => TO_DATE(p_ele_startdate_fr,'dd/mm/yyyy')
2377: ,p_formula_id => l_formula_id
2378: ,p_processing_rule => 'P'
2379: );
2380:
2381: l_for_res_id := pay_formula_results.ins_form_res_rule
2382: (
2383: p_business_group_id => l_business_group_id
2384: ,p_legislation_code => NULL
2385: ,p_status_processing_rule_id => l_status_proc_rule_id