[Home] [Help]
206: Earning Element with a Shift Category.
207: 17-May-2002 ekim 115.19 Added p_termination_rule
208: 23-Jul-2002 ekim 115.20 Changed v_bg_name type to use
209: per_business_groups.name%TYPE
210: Re-numbered hr_utility.set_location
211: number to avoid duplicates.
212: 08-Oct-2002 ekim 115.21 Changed to use p_uom_code instead of
213: p_uom in call to
214: pay_db_pay_setup.create_input_value
413: -- Unless this function actually has to do anything, we can make call
414: -- to pay_db_pay_setup from do_insertions.
415: --
416:
417: hr_utility.set_location('pyusuiet',1);
418: IF p_ele_processing_type = 'N' THEN
419: v_mult_entries_allowed := 'Y';
420: ELSE
421: v_mult_entries_allowed := 'N';
428: --
429: -- insert check for ele type existence here...return id if it does!
430: --
431:
432: hr_utility.set_location('pyusuiet',3);
433: v_eletype_id := pay_db_pay_setup.create_element(
434: p_element_name => p_ele_name,
435: p_description => p_ele_description,
436: p_classification_name => p_ele_class,
486: v_formula_name VARCHAR2(80);
487:
488: BEGIN
489:
490: hr_utility.set_location('hr_user_init_earn.ins_formula',10);
491:
492: -- Bug 3768726 - With this, the upper clause will be removed from the first condition in query.
493:
494: v_formula_name := UPPER(p_amt_rule);
507: AND FF.effective_end_date;
508: --
509: -- Replace element name placeholders with current element name:
510:
511: hr_utility.set_location('hr_user_init_earn.ins_formula',15);
512: v_ele_name := REPLACE(LTRIM(RTRIM(UPPER(p_ff_ele_name))),' ','_');
513: --
514: v_ele_formula_text := REPLACE( v_skeleton_formula_text,
515: '
519: --
520: -- Insert the new formula into current business goup:
521: -- Get new id
522:
523: hr_utility.set_location('hr_user_init_earn.ins_formula',30);
524: SELECT ff_formulas_s.nextval
525: INTO v_formula_id
526: FROM sys.dual;
527: --
524: SELECT ff_formulas_s.nextval
525: INTO v_formula_id
526: FROM sys.dual;
527: --
528: hr_utility.set_location('hr_user_init_earn.ins_formula',40);
529: INSERT INTO ff_formulas_f (
530: FORMULA_ID,
531: EFFECTIVE_START_DATE,
532: EFFECTIVE_END_DATE,
655: 'GROSS_UP_NONRECUR_V2') THEN
656: --
657: IF UPPER(p_ele_class_name) = 'EARNINGS' THEN
658: v_ele_info_cat := 'US_EARNINGS';
659: hr_utility.set_location('pyusuiet',45);
660: UPDATE pay_element_types_f
661: SET element_information_category = v_ele_info_cat,
662: element_information1 = p_ele_cat,
663: element_information8 = p_include_in_ot,
666: element_information12 = p_hrs_baltype_id
667: WHERE element_type_id = p_ele_id
668: AND business_group_id = p_bg_id;
669: --
670: hr_utility.set_location('pyusuiet',50);
671: UPDATE pay_element_types_f
672: SET element_information_category = v_ele_info_cat,
673: element_information1 = p_ele_cat,
674: element_information8 = p_include_in_ot
677: --
678:
679: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
680:
681: hr_utility.set_location('pyusuiet',55);
682: UPDATE pay_element_types_f
683: SET element_information_category = v_ele_info_cat,
684: element_information1 = p_ele_cat,
685: element_information8 = p_include_in_ot
691: --
692: ELSIF UPPER(p_ele_class_name) = 'SUPPLEMENTAL EARNINGS' THEN
693:
694: v_ele_info_cat := 'US_SUPPLEMENTAL EARNINGS';
695: hr_utility.set_location('pyusuiet',60);
696: UPDATE pay_element_types_f
697: SET element_information_category = v_ele_info_cat,
698: element_information1 = p_ele_cat,
699: element_information8 = p_include_in_ot,
702: element_information12 = p_hrs_baltype_id
703: WHERE element_type_id = p_ele_id
704: AND business_group_id = p_bg_id;
705: --
706: hr_utility.set_location('pyusuiet',65);
707: UPDATE pay_element_types_f
708: SET element_information_category = v_ele_info_cat,
709: element_information1 = p_ele_cat,
710: element_information8 = p_include_in_ot
712: AND business_group_id = p_bg_id;
713: --
714: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
715:
716: hr_utility.set_location('pyusuiet',70);
717: UPDATE pay_element_types_f
718: SET element_information_category = v_ele_info_cat,
719: element_information1 = p_ele_cat,
720: element_information8 = p_include_in_ot
725: --
726: ELSIF UPPER(p_ele_class_name) = 'IMPUTED EARNINGS' THEN
727:
728: v_ele_info_cat := 'US_IMPUTED EARNINGS';
729: hr_utility.set_location('pyusuiet',75);
730: UPDATE pay_element_types_f
731: SET element_information_category = v_ele_info_cat,
732: element_information1 = p_ele_cat,
733: element_information9 = v_mix_category,
734: element_information12 = p_hrs_baltype_id
735: WHERE element_type_id = p_ele_id
736: AND business_group_id = p_bg_id;
737: --
738: hr_utility.set_location('pyusuiet',80);
739: UPDATE pay_element_types_f
740: SET element_information_category = v_ele_info_cat,
741: element_information1 = p_ele_cat
742: WHERE element_type_id = p_shadow_ele_id
744: --
745:
746: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
747:
748: hr_utility.set_location('pyusuiet',85);
749: UPDATE pay_element_types_f
750: SET element_information_category = v_ele_info_cat,
751: element_information1 = p_ele_cat
752: WHERE element_type_id = p_inputs_ele_id
757: --
758: ELSIF UPPER(p_ele_class_name) = 'NON-PAYROLL PAYMENTS' THEN
759:
760: v_ele_info_cat := 'US_NON-PAYROLL PAYMENTS';
761: hr_utility.set_location('pyusuiet',90);
762: UPDATE pay_element_types_f
763: SET element_information_category = v_ele_info_cat,
764: element_information1 = p_ele_cat,
765: element_information9 = v_mix_category
765: element_information9 = v_mix_category
766: WHERE element_type_id = p_ele_id
767: AND business_group_id = p_bg_id;
768: --
769: hr_utility.set_location('pyusuiet',95);
770: UPDATE pay_element_types_f
771: SET element_information_category = v_ele_info_cat,
772: element_information1 = p_ele_cat
773: WHERE element_type_id = p_shadow_ele_id
774: AND business_group_id = p_bg_id;
775: --
776: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
777:
778: hr_utility.set_location('pyusuiet',100);
779: UPDATE pay_element_types_f
780: SET element_information_category = v_ele_info_cat,
781: element_information1 = p_ele_cat
782: WHERE element_type_id = p_inputs_ele_id
789:
790: --
791: ELSE
792: -- Ele is a grossup ele, Information classification, just set mix flag.
793: hr_utility.set_location('pyusuiet',105);
794: UPDATE pay_element_types_f
795: SET element_information9 = v_mix_category
796: WHERE element_type_id = p_ele_id
797: AND business_group_id = p_bg_id;
813: -- Insert input vals;
814: -- Gather Hours By Rate Element Details
815: -- Insert formula result rules;
816: --
817: hr_utility.set_location('pyusuiet',110);
818: v_calc_rule_formula_id := ins_formula (
819: p_ff_ele_name => p_ele_name,
820: p_ff_suffix => '_HOURS_X_RATE',
821: p_ff_desc => 'Hours times Rate calculation for recurring earnings.',
821: p_ff_desc => 'Hours times Rate calculation for recurring earnings.',
822: p_ff_bg_id => p_bg_id,
823: p_amt_rule => UPPER(p_calc_ff_name));
824: --
825: hr_utility.set_location('pyusuiet',115);
826:
827: --
828: -- check for existence...return id...
829: --
841: p_processing_rule => v_proc_rule);
842:
843: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
844: -- Creating "Hours Worked" input val.
845: hr_utility.set_location('pyusuiet',120);
846: g_inpval_disp_seq := g_inpval_disp_seq + 1;
847: v_inpval_name := 'Hours';
848: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
849: v_gen_dbi := 'Y';
858: p_generate_db_item_flag => v_gen_dbi,
859: p_display_sequence => g_inpval_disp_seq,
860: p_business_group_name => p_bg_name);
861:
862: hr_utility.set_location('pyusuiet',125);
863: hr_input_values.chk_input_value(
864: p_element_type_id => p_ele_id,
865: p_legislation_code => g_template_leg_code,
866: p_val_start_date => p_eff_start_date,
882: p_formula_id => NULL,
883: p_generate_db_items_flag => v_gen_dbi,
884: p_warning_or_error => NULL);
885:
886: hr_utility.set_location('pyusuiet',130);
887: hr_input_values.ins_3p_input_values(
888: p_val_start_date => p_eff_start_date,
889: p_val_end_date => NULL,
890: p_element_type_id => p_ele_id,
903: p_startup_mode => NULL);
904: -- (HERE) Done inserting one "Hours" input value.
905: -- Now insert "Rate".
906: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
907: hr_utility.set_location('pyusuiet',135);
908: g_inpval_disp_seq := g_inpval_disp_seq + 1;
909: v_inpval_name := 'Rate';
910: v_inpval_uom := 'N'; -- Check that this can go out to 5 dec.
911: v_gen_dbi := 'Y';
917: p_generate_db_item_flag => v_gen_dbi,
918: p_display_sequence => g_inpval_disp_seq,
919: p_business_group_name => p_bg_name);
920:
921: hr_utility.set_location('pyusuiet',140);
922: hr_input_values.chk_input_value(
923: p_element_type_id => p_ele_id,
924: p_legislation_code => g_template_leg_code,
925: p_val_start_date => p_eff_start_date,
941: p_formula_id => NULL,
942: p_generate_db_items_flag => v_gen_dbi,
943: p_warning_or_error => NULL);
944:
945: hr_utility.set_location('pyusuiet',145);
946: hr_input_values.ins_3p_input_values(
947: p_val_start_date => p_eff_start_date,
948: p_val_end_date => NULL,
949: p_element_type_id => p_ele_id,
962: p_startup_mode => NULL);
963: -- (HERE) Done inserting one "Rate" input value.
964: -- Now insert "Rate Code".
965: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
966: hr_utility.set_location('pyusuiet',150);
967: g_inpval_disp_seq := g_inpval_disp_seq + 1;
968: v_inpval_name := 'Rate Code';
969: v_inpval_uom := 'C';
970: v_gen_dbi := 'N';
976: p_generate_db_item_flag => v_gen_dbi,
977: p_display_sequence => g_inpval_disp_seq,
978: p_business_group_name => p_bg_name);
979:
980: hr_utility.set_location('pyusuiet',155);
981: hr_input_values.chk_input_value(
982: p_element_type_id => p_ele_id,
983: p_legislation_code => g_template_leg_code,
984: p_val_start_date => p_eff_start_date,
1000: p_formula_id => NULL,
1001: p_generate_db_items_flag => v_gen_dbi,
1002: p_warning_or_error => NULL);
1003:
1004: hr_utility.set_location('pyusuiet',160);
1005: hr_input_values.ins_3p_input_values(
1006: p_val_start_date => p_eff_start_date,
1007: p_val_end_date => NULL,
1008: p_element_type_id => p_ele_id,
1022: -- (HERE) Done inserting "Rate Code" input value.
1023:
1024: -- Now insert "Shift".
1025: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1026: hr_utility.set_location('pyusuiet',165);
1027:
1028: -- Rmonge 01-FEB-2002
1029: -- Adding the following if condition to create Shift Input value.
1030: -- The Shift input values is only created if the p_ele_cat value
1029: -- Adding the following if condition to create Shift Input value.
1030: -- The Shift input values is only created if the p_ele_cat value
1031: -- is 'S'. S means Shift Category.
1032:
1033: hr_utility.trace('p_ele_cat is '||p_ele_cat);
1034:
1035: IF p_ele_cat = 'S' THEN
1036:
1037: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1046: p_generate_db_item_flag => v_gen_dbi,
1047: p_display_sequence => g_inpval_disp_seq,
1048: p_business_group_name => p_bg_name);
1049:
1050: hr_utility.set_location('pyusuiet',170);
1051: hr_input_values.chk_input_value(
1052: p_element_type_id => p_ele_id,
1053: p_legislation_code => g_template_leg_code,
1054: p_val_start_date => p_eff_start_date,
1070: p_formula_id => NULL,
1071: p_generate_db_items_flag => v_gen_dbi,
1072: p_warning_or_error => NULL);
1073:
1074: hr_utility.set_location('pyusuiet',175);
1075: hr_input_values.ins_3p_input_values(
1076: p_val_start_date => p_eff_start_date,
1077: p_val_end_date => NULL,
1078: p_element_type_id => p_ele_id,
1098: v_inpval_name := 'Date Earned';
1099: v_inpval_uom := 'Date (DD-MON-YYYY)';
1100: v_gen_dbi := 'N';
1101:
1102: hr_utility.set_location('pyusuiet',180);
1103: v_inpval_id := pay_db_pay_setup.create_input_value (
1104: p_element_name => p_ele_name,
1105: p_name => v_inpval_name,
1106: p_uom_code => v_inpval_uom,
1108: p_generate_db_item_flag => v_gen_dbi,
1109: p_display_sequence => g_inpval_disp_seq,
1110: p_business_group_name => p_bg_name);
1111:
1112: hr_utility.set_location('pyusuiet',185);
1113: hr_input_values.chk_input_value(
1114: p_element_type_id => p_ele_id,
1115: p_legislation_code => g_template_leg_code,
1116: p_val_start_date => p_eff_start_date,
1132: p_formula_id => NULL,
1133: p_generate_db_items_flag => v_gen_dbi,
1134: p_warning_or_error => NULL);
1135:
1136: hr_utility.set_location('pyusuiet',190);
1137: hr_input_values.ins_3p_input_values(
1138: p_val_start_date => p_eff_start_date,
1139: p_val_end_date => NULL,
1140: p_element_type_id => p_ele_id,
1163: -- Now insert appropriate formula_result_rules for "HRS X RATE"
1164: -- REMEMBER: Testing using 'HEP_TEST_01' formula.
1165:
1166: -- Gather Hours By Rate Element Details
1167: hr_utility.trace('Get Hours By Rate Element Id');
1168: hr_utility.set_location('pyusuiet',195);
1169: select element_type_id
1170: into v_hbyr_ele_type_id
1171: from pay_element_types_f
1164: -- REMEMBER: Testing using 'HEP_TEST_01' formula.
1165:
1166: -- Gather Hours By Rate Element Details
1167: hr_utility.trace('Get Hours By Rate Element Id');
1168: hr_utility.set_location('pyusuiet',195);
1169: select element_type_id
1170: into v_hbyr_ele_type_id
1171: from pay_element_types_f
1172: where element_name = 'Hours by Rate'
1173: and legislation_code = g_template_leg_code
1174: and sysdate between effective_start_date
1175: and effective_end_date;
1176:
1177: hr_utility.trace('Get Hours By Rate Element Inpval Id');
1178: hr_utility.set_location('pyusuiet',200);
1179: select input_value_id
1180: into v_hbyr_ele_inpval_id
1181: from pay_input_values_f
1174: and sysdate between effective_start_date
1175: and effective_end_date;
1176:
1177: hr_utility.trace('Get Hours By Rate Element Inpval Id');
1178: hr_utility.set_location('pyusuiet',200);
1179: select input_value_id
1180: into v_hbyr_ele_inpval_id
1181: from pay_input_values_f
1182: where element_type_id = v_hbyr_ele_type_id
1183: and name = 'Element Type Id'
1184: and sysdate between effective_start_date
1185: and effective_end_date;
1186:
1187: hr_utility.trace('Get Hours By Rate Rate Inpval Id');
1188: hr_utility.set_location('pyusuiet',205);
1189: select input_value_id
1190: into v_hbyr_rate_inpval_id
1191: from pay_input_values_f
1184: and sysdate between effective_start_date
1185: and effective_end_date;
1186:
1187: hr_utility.trace('Get Hours By Rate Rate Inpval Id');
1188: hr_utility.set_location('pyusuiet',205);
1189: select input_value_id
1190: into v_hbyr_rate_inpval_id
1191: from pay_input_values_f
1192: where element_type_id = v_hbyr_ele_type_id
1193: and name = 'Rate'
1194: and sysdate between effective_start_date
1195: and effective_end_date;
1196:
1197: hr_utility.trace('Get Hours By Rate Hours Inpval Id');
1198: hr_utility.set_location('pyusuiet',210);
1199: select input_value_id
1200: into v_hbyr_hours_inpval_id
1201: from pay_input_values_f
1194: and sysdate between effective_start_date
1195: and effective_end_date;
1196:
1197: hr_utility.trace('Get Hours By Rate Hours Inpval Id');
1198: hr_utility.set_location('pyusuiet',210);
1199: select input_value_id
1200: into v_hbyr_hours_inpval_id
1201: from pay_input_values_f
1202: where element_type_id = v_hbyr_ele_type_id
1204: and sysdate between effective_start_date
1205: and effective_end_date;
1206:
1207:
1208: hr_utility.set_location('pyusuiet',215);
1209: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1210: p_business_group_id => p_bg_id,
1211: p_legislation_code => NULL,
1212: p_legislation_subgroup => g_template_leg_subgroup,
1219: p_result_name => 'TEMPLATE_EARNING',
1220: p_result_rule_type => 'D',
1221: p_severity_level => NULL);
1222: --
1223: hr_utility.set_location('pyusuiet',220);
1224: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1225: p_business_group_id => p_bg_id,
1226: p_legislation_code => NULL,
1227: p_legislation_subgroup => g_template_leg_subgroup,
1234: p_result_name => 'MESG',
1235: p_result_rule_type => 'M',
1236: p_severity_level => 'W');
1237: --
1238: hr_utility.set_location('pyusuiet',225);
1239: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1240: p_business_group_id => p_bg_id,
1241: p_legislation_code => NULL,
1242: p_legislation_subgroup => g_template_leg_subgroup,
1248: p_result_rule_type => 'I',
1249: p_severity_level => NULL,
1250: p_element_type_id => v_hbyr_ele_type_id);
1251:
1252: hr_utility.set_location('pyusuiet',230);
1253: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1254: p_business_group_id => p_bg_id,
1255: p_legislation_code => NULL,
1256: p_legislation_subgroup => g_template_leg_subgroup,
1262: p_result_rule_type => 'I',
1263: p_severity_level => NULL,
1264: p_element_type_id => v_hbyr_ele_type_id);
1265:
1266: hr_utility.set_location('pyusuiet',235);
1267: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1268: p_business_group_id => p_bg_id,
1269: p_legislation_code => NULL,
1270: p_legislation_subgroup => g_template_leg_subgroup,
1278: p_element_type_id => v_hbyr_ele_type_id);
1279:
1280: IF p_ele_proc_type = 'R' THEN
1281: --
1282: hr_utility.set_location('pyusuiet',240);
1283: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1284: p_business_group_id => p_bg_id,
1285: p_legislation_code => NULL,
1286: p_legislation_subgroup => g_template_leg_subgroup,
1297: --
1298: ELSIF UPPER(p_calc_ff_name) IN ('HOURS_X_RATE_MULTIPLE_RECUR_V2',
1299: 'HOURS_X_RATE_MULTIPLE_NONRECUR_V2') THEN
1300: --
1301: hr_utility.set_location('pyusuiet',245);
1302: v_calc_rule_formula_id := ins_formula (
1303: p_ff_ele_name => p_ele_name,
1304: p_ff_suffix => '_HOURS_X_RATE_MULT',
1305: p_ff_desc => 'Hours * Rate * Multiple calculation for recurring earnings.',
1305: p_ff_desc => 'Hours * Rate * Multiple calculation for recurring earnings.',
1306: p_ff_bg_id => p_bg_id,
1307: p_amt_rule => UPPER(p_calc_ff_name));
1308: --
1309: hr_utility.set_location('pyusuiet',250);
1310: v_stat_proc_rule_id :=
1311: pay_formula_results.ins_stat_proc_rule (
1312: p_business_group_id => p_bg_id,
1313: p_legislation_code => NULL,
1321:
1322: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1323: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1324: -- Creating "Hours Worked" input val.
1325: hr_utility.set_location('pyusuiet',255);
1326: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1327: v_inpval_name := 'Hours';
1328: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
1329: v_gen_dbi := 'Y';
1335: p_generate_db_item_flag => v_gen_dbi,
1336: p_display_sequence => g_inpval_disp_seq,
1337: p_business_group_name => p_bg_name);
1338:
1339: hr_utility.set_location('pyusuiet',260);
1340: hr_input_values.chk_input_value(
1341: p_element_type_id => p_ele_id,
1342: p_legislation_code => g_template_leg_code,
1343: p_val_start_date => p_eff_start_date,
1359: p_formula_id => NULL,
1360: p_generate_db_items_flag => v_gen_dbi,
1361: p_warning_or_error => NULL);
1362:
1363: hr_utility.set_location('pyusuiet',265);
1364: hr_input_values.ins_3p_input_values(
1365: p_val_start_date => p_eff_start_date,
1366: p_val_end_date => NULL,
1367: p_element_type_id => p_ele_id,
1380: p_startup_mode => NULL);
1381: -- (HERE) Done inserting one "Hours" input value.
1382: -- Now insert "Multiple".
1383: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1384: hr_utility.set_location('pyusuiet',270);
1385: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1386: v_inpval_name := 'Multiple';
1387: v_inpval_uom := 'N'; -- Check that this can go out to 5 dec.
1388: v_gen_dbi := 'Y';
1394: p_generate_db_item_flag => v_gen_dbi,
1395: p_display_sequence => g_inpval_disp_seq,
1396: p_business_group_name => p_bg_name);
1397:
1398: hr_utility.set_location('pyusuiet',275);
1399: hr_input_values.chk_input_value(
1400: p_element_type_id => p_ele_id,
1401: p_legislation_code => g_template_leg_code,
1402: p_val_start_date => p_eff_start_date,
1418: p_formula_id => NULL,
1419: p_generate_db_items_flag => v_gen_dbi,
1420: p_warning_or_error => NULL);
1421:
1422: hr_utility.set_location('pyusuiet',280);
1423: hr_input_values.ins_3p_input_values(
1424: p_val_start_date => p_eff_start_date,
1425: p_val_end_date => NULL,
1426: p_element_type_id => p_ele_id,
1439: p_startup_mode => NULL);
1440: -- (HERE) Done inserting one "Multiple" input value.
1441: -- Now insert "Rate".
1442: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1443: hr_utility.set_location('pyusuiet',285);
1444: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1445: v_inpval_name := 'Rate';
1446: v_inpval_uom := 'N'; -- Check that this can go out to 5 dec.
1447: v_gen_dbi := 'Y';
1453: p_generate_db_item_flag => v_gen_dbi,
1454: p_display_sequence => g_inpval_disp_seq,
1455: p_business_group_name => p_bg_name);
1456:
1457: hr_utility.set_location('pyusuiet',290);
1458: hr_input_values.chk_input_value(
1459: p_element_type_id => p_ele_id,
1460: p_legislation_code => g_template_leg_code,
1461: p_val_start_date => p_eff_start_date,
1477: p_formula_id => NULL,
1478: p_generate_db_items_flag => v_gen_dbi,
1479: p_warning_or_error => NULL);
1480:
1481: hr_utility.set_location('pyusuiet',295);
1482: hr_input_values.ins_3p_input_values(
1483: p_val_start_date => p_eff_start_date,
1484: p_val_end_date => NULL,
1485: p_element_type_id => p_ele_id,
1498: p_startup_mode => NULL);
1499: -- (HERE) Done inserting one "Rate" input value.
1500: -- Now insert "Rate Code".
1501: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1502: hr_utility.set_location('pyusuiet',300);
1503: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1504: v_inpval_name := 'Rate Code';
1505: v_inpval_uom := 'C';
1506: v_gen_dbi := 'N';
1512: p_generate_db_item_flag => v_gen_dbi,
1513: p_display_sequence => g_inpval_disp_seq,
1514: p_business_group_name => p_bg_name);
1515:
1516: hr_utility.set_location('pyusuiet',305);
1517: hr_input_values.chk_input_value(
1518: p_element_type_id => p_ele_id,
1519: p_legislation_code => g_template_leg_code,
1520: p_val_start_date => p_eff_start_date,
1536: p_formula_id => NULL,
1537: p_generate_db_items_flag => v_gen_dbi,
1538: p_warning_or_error => NULL);
1539:
1540: hr_utility.set_location('pyusuiet',310);
1541: hr_input_values.ins_3p_input_values(
1542: p_val_start_date => p_eff_start_date,
1543: p_val_end_date => NULL,
1544: p_element_type_id => p_ele_id,
1560: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1561: -- Now insert appropriate formula_result_rules for "HRS X RATE X MULTIPLE"
1562: -- REMEMBER: Testing using 'HEP_TEST_01' formula.
1563:
1564: hr_utility.set_location('pyusuiet',315);
1565:
1566: --
1567: -- check for existence ... return id of result rule if it already exists.
1568: --
1566: --
1567: -- check for existence ... return id of result rule if it already exists.
1568: --
1569: -- Gather Hours By Rate Element Details
1570: hr_utility.trace('Get Hours By Rate Element Id');
1571: hr_utility.set_location('pyusuiet',320);
1572: select element_type_id
1573: into v_hbyr_ele_type_id
1574: from pay_element_types_f
1567: -- check for existence ... return id of result rule if it already exists.
1568: --
1569: -- Gather Hours By Rate Element Details
1570: hr_utility.trace('Get Hours By Rate Element Id');
1571: hr_utility.set_location('pyusuiet',320);
1572: select element_type_id
1573: into v_hbyr_ele_type_id
1574: from pay_element_types_f
1575: where element_name = 'Hours by Rate'
1576: and legislation_code = g_template_leg_code
1577: and sysdate between effective_start_date
1578: and effective_end_date;
1579:
1580: hr_utility.trace('Get Hours By Rate Element Inpval Id');
1581: hr_utility.set_location('pyusuiet',325);
1582: select input_value_id
1583: into v_hbyr_ele_inpval_id
1584: from pay_input_values_f
1577: and sysdate between effective_start_date
1578: and effective_end_date;
1579:
1580: hr_utility.trace('Get Hours By Rate Element Inpval Id');
1581: hr_utility.set_location('pyusuiet',325);
1582: select input_value_id
1583: into v_hbyr_ele_inpval_id
1584: from pay_input_values_f
1585: where element_type_id = v_hbyr_ele_type_id
1586: and name = 'Element Type Id'
1587: and sysdate between effective_start_date
1588: and effective_end_date;
1589:
1590: hr_utility.trace('Get Hours By Rate Rate Inpval Id');
1591: hr_utility.set_location('pyusuiet',330);
1592: select input_value_id
1593: into v_hbyr_rate_inpval_id
1594: from pay_input_values_f
1587: and sysdate between effective_start_date
1588: and effective_end_date;
1589:
1590: hr_utility.trace('Get Hours By Rate Rate Inpval Id');
1591: hr_utility.set_location('pyusuiet',330);
1592: select input_value_id
1593: into v_hbyr_rate_inpval_id
1594: from pay_input_values_f
1595: where element_type_id = v_hbyr_ele_type_id
1596: and name = 'Rate'
1597: and sysdate between effective_start_date
1598: and effective_end_date;
1599:
1600: hr_utility.trace('Get Hours By Rate Hours Inpval Id');
1601: hr_utility.set_location('pyusuiet',335);
1602: select input_value_id
1603: into v_hbyr_hours_inpval_id
1604: from pay_input_values_f
1597: and sysdate between effective_start_date
1598: and effective_end_date;
1599:
1600: hr_utility.trace('Get Hours By Rate Hours Inpval Id');
1601: hr_utility.set_location('pyusuiet',335);
1602: select input_value_id
1603: into v_hbyr_hours_inpval_id
1604: from pay_input_values_f
1605: where element_type_id = v_hbyr_ele_type_id
1606: and name = 'Hours'
1607: and sysdate between effective_start_date
1608: and effective_end_date;
1609:
1610: hr_utility.trace('Get Hours By Rate Multiple Inpval Id');
1611: hr_utility.set_location('pyusuiet',340);
1612: select input_value_id
1613: into v_hbyr_mult_inpval_id
1614: from pay_input_values_f
1607: and sysdate between effective_start_date
1608: and effective_end_date;
1609:
1610: hr_utility.trace('Get Hours By Rate Multiple Inpval Id');
1611: hr_utility.set_location('pyusuiet',340);
1612: select input_value_id
1613: into v_hbyr_mult_inpval_id
1614: from pay_input_values_f
1615: where element_type_id = v_hbyr_ele_type_id
1617: and sysdate between effective_start_date
1618: and effective_end_date;
1619:
1620:
1621: hr_utility.set_location('pyusuiet',345);
1622: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1623: p_business_group_id => p_bg_id,
1624: p_legislation_code => NULL,
1625: p_legislation_subgroup => g_template_leg_subgroup,
1632: p_result_name => 'TEMPLATE_EARNING',
1633: p_result_rule_type => 'D',
1634: p_severity_level => NULL);
1635: --
1636: hr_utility.set_location('pyusuiet',350);
1637: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1638: p_business_group_id => p_bg_id,
1639: p_legislation_code => NULL,
1640: p_legislation_subgroup => g_template_leg_subgroup,
1647: p_result_name => 'MESG',
1648: p_result_rule_type => 'M',
1649: p_severity_level => 'W');
1650: --
1651: hr_utility.set_location('pyusuiet',355);
1652: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1653: p_business_group_id => p_bg_id,
1654: p_legislation_code => NULL,
1655: p_legislation_subgroup => g_template_leg_subgroup,
1661: p_result_rule_type => 'I',
1662: p_severity_level => NULL,
1663: p_element_type_id => v_hbyr_ele_type_id);
1664:
1665: hr_utility.set_location('pyusuiet',360);
1666: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1667: p_business_group_id => p_bg_id,
1668: p_legislation_code => NULL,
1669: p_legislation_subgroup => g_template_leg_subgroup,
1675: p_result_rule_type => 'I',
1676: p_severity_level => NULL,
1677: p_element_type_id => v_hbyr_ele_type_id);
1678:
1679: hr_utility.set_location('pyusuiet',365);
1680: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1681: p_business_group_id => p_bg_id,
1682: p_legislation_code => NULL,
1683: p_legislation_subgroup => g_template_leg_subgroup,
1689: p_result_rule_type => 'I',
1690: p_severity_level => NULL,
1691: p_element_type_id => v_hbyr_ele_type_id);
1692:
1693: hr_utility.set_location('pyusuiet',370);
1694: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1695: p_business_group_id => p_bg_id,
1696: p_legislation_code => NULL,
1697: p_legislation_subgroup => g_template_leg_subgroup,
1705: p_element_type_id => v_hbyr_ele_type_id);
1706:
1707: IF p_ele_proc_type = 'R' THEN
1708: --
1709: hr_utility.set_location('pyusuiet',375);
1710: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1711: p_business_group_id => p_bg_id,
1712: p_legislation_code => NULL,
1713: p_legislation_subgroup => g_template_leg_subgroup,
1725: --
1726: ELSIF UPPER(p_calc_ff_name) IN ('PERCENTAGE_OF_REG_EARNINGS_RECUR_V2',
1727: 'PERCENTAGE_OF_REG_EARNINGS_NONRECUR_V2') THEN
1728: --
1729: hr_utility.set_location('pyusuiet',380);
1730: v_calc_rule_formula_id := ins_formula (
1731: p_ff_ele_name => p_ele_name,
1732: p_ff_suffix => '_PCT_EARN',
1733: p_ff_desc => 'Percentage of regular earnings calculation for recurring earnings.',
1733: p_ff_desc => 'Percentage of regular earnings calculation for recurring earnings.',
1734: p_ff_bg_id => p_bg_id,
1735: p_amt_rule => UPPER(p_calc_ff_name));
1736: --
1737: hr_utility.set_location('pyusuiet',385);
1738: v_stat_proc_rule_id :=
1739: pay_formula_results.ins_stat_proc_rule (
1740: p_business_group_id => p_bg_id,
1741: p_legislation_code => NULL,
1748: p_processing_rule => v_proc_rule);
1749:
1750: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1751: -- Creating "Percentage" input val.
1752: hr_utility.set_location('pyusuiet',390);
1753: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1754: v_inpval_name := 'Percentage';
1755: v_inpval_uom := 'N';
1756: v_gen_dbi := 'Y';
1762: p_generate_db_item_flag => v_gen_dbi,
1763: p_display_sequence => g_inpval_disp_seq,
1764: p_business_group_name => p_bg_name);
1765:
1766: hr_utility.set_location('pyusuiet',395);
1767: hr_input_values.chk_input_value(
1768: p_element_type_id => p_ele_id,
1769: p_legislation_code => g_template_leg_code,
1770: p_val_start_date => p_eff_start_date,
1786: p_formula_id => NULL,
1787: p_generate_db_items_flag => v_gen_dbi,
1788: p_warning_or_error => NULL);
1789:
1790: hr_utility.set_location('pyusuiet',400);
1791: hr_input_values.ins_3p_input_values(
1792: p_val_start_date => p_eff_start_date,
1793: p_val_end_date => NULL,
1794: p_element_type_id => p_ele_id,
1808: -- (HERE) Done inserting one "Percentage" input value.
1809: -- Now insert appropriate formula_result_rules for "PERCENT SALARY"
1810: -- REMEMBER: Testing using 'HEP_TEST_01' formula.
1811:
1812: hr_utility.set_location('pyusuiet',405);
1813: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1814: p_business_group_id => p_bg_id,
1815: p_legislation_code => NULL,
1816: p_legislation_subgroup => g_template_leg_subgroup,
1823: p_result_name => 'TEMPLATE_EARNING',
1824: p_result_rule_type => 'D',
1825: p_severity_level => NULL);
1826: --
1827: hr_utility.set_location('pyusuiet',410);
1828: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1829: p_business_group_id => p_bg_id,
1830: p_legislation_code => NULL,
1831: p_legislation_subgroup => g_template_leg_subgroup,
1840: p_severity_level => 'W');
1841: --
1842: IF p_ele_proc_type = 'R' THEN
1843: --
1844: hr_utility.set_location('pyusuiet',415);
1845: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1846: p_business_group_id => p_bg_id,
1847: p_legislation_code => NULL,
1848: p_legislation_subgroup => g_template_leg_subgroup,
1860:
1861: ELSIF UPPER(p_calc_ff_name) IN ('FLAT_AMOUNT_RECUR_V2',
1862: 'FLAT_AMOUNT_NONRECUR_V2') THEN
1863: --
1864: hr_utility.set_location('pyusuiet',420);
1865: v_calc_rule_formula_id := ins_formula (
1866: p_ff_ele_name => p_ele_name,
1867: p_ff_suffix => '_FLAT_AMOUNT',
1868: p_ff_desc => 'Flat Amount calculation for recurring earnings.',
1868: p_ff_desc => 'Flat Amount calculation for recurring earnings.',
1869: p_ff_bg_id => p_bg_id,
1870: p_amt_rule => UPPER(p_calc_ff_name));
1871: --
1872: hr_utility.set_location('pyusuiet',425);
1873: v_stat_proc_rule_id :=
1874: pay_formula_results.ins_stat_proc_rule (
1875: p_business_group_id => p_bg_id,
1876: p_legislation_code => NULL,
1882: p_formula_id => v_calc_rule_formula_id,
1883: p_processing_rule => v_proc_rule);
1884: --
1885: -- Creating "Amount" input val.
1886: hr_utility.set_location('pyusuiet',430);
1887: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1888: v_inpval_name := 'Amount';
1889: v_inpval_uom := 'M';
1890: v_gen_dbi := 'Y';
1896: p_generate_db_item_flag => v_gen_dbi,
1897: p_display_sequence => g_inpval_disp_seq,
1898: p_business_group_name => p_bg_name);
1899:
1900: hr_utility.set_location('pyusuiet',435);
1901: hr_input_values.chk_input_value(
1902: p_element_type_id => p_ele_id,
1903: p_legislation_code => g_template_leg_code,
1904: p_val_start_date => p_eff_start_date,
1920: p_formula_id => NULL,
1921: p_generate_db_items_flag => v_gen_dbi,
1922: p_warning_or_error => NULL);
1923:
1924: hr_utility.set_location('pyusuiet',440);
1925: hr_input_values.ins_3p_input_values(
1926: p_val_start_date => p_eff_start_date,
1927: p_val_end_date => NULL,
1928: p_element_type_id => p_ele_id,
1943: -- (HERE) Done inserting one "Amount" input value.
1944: --
1945: -- Now insert appropriate formula_result_rules for "FLAT AMOUNT"
1946: --
1947: hr_utility.set_location('pyusuiet',445);
1948: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1949: p_business_group_id => p_bg_id,
1950: p_legislation_code => NULL,
1951: p_legislation_subgroup => g_template_leg_subgroup,
1958: p_result_name => 'FLAT_AMOUNT',
1959: p_result_rule_type => 'D',
1960: p_severity_level => NULL);
1961: --
1962: hr_utility.set_location('pyusuiet',450);
1963: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1964: p_business_group_id => p_bg_id,
1965: p_legislation_code => NULL,
1966: p_legislation_subgroup => g_template_leg_subgroup,
1975: p_severity_level => 'W');
1976: --
1977: IF p_ele_proc_type = 'R' THEN
1978: --
1979: hr_utility.set_location('pyusuiet',455);
1980: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1981: p_business_group_id => p_bg_id,
1982: p_legislation_code => NULL,
1983: p_legislation_subgroup => g_template_leg_subgroup,
1997:
1998: -- Could not find this calc method formula(?) should never happen!
1999: -- No input vals or formula results required for calculation of
2000: -- this earning.
2001: hr_utility.set_location('pyusuiet',460);
2002: v_calc_rule_formula_id := '';
2003: v_stat_proc_rule_id :=
2004: pay_formula_results.ins_stat_proc_rule (
2005: p_business_group_id => p_bg_id,
2076: -- Add input values w/display seq = g_inpval_disp_seq + 1, and so on.
2077: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
2078: -- Creating "Jurisdiction" input val
2079:
2080: hr_utility.set_location('pyusuiet',465);
2081: SELECT formula_id
2082: INTO v_val_formula_id
2083: FROM ff_formulas_f
2084: WHERE business_group_id IS NULL
2084: WHERE business_group_id IS NULL
2085: AND legislation_code = 'US'
2086: AND formula_name = 'JURISDICTION_VALIDATION';
2087: --
2088: hr_utility.set_location('pyusuiet',86);
2089: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2090: v_inpval_name := 'Jurisdiction';
2091: v_inpval_uom := 'C';
2092: v_gen_dbi := 'N';
2091: v_inpval_uom := 'C';
2092: v_gen_dbi := 'N';
2093: v_lkp_type := NULL;
2094: --
2095: hr_utility.set_location('pyusuiet',470);
2096: v_inpval_id := pay_db_pay_setup.create_input_value (
2097: p_element_name => p_ele_name,
2098: p_name => v_inpval_name,
2099: p_uom_code => v_inpval_uom,
2110: p_business_group_name => p_bg_name,
2111: p_effective_start_date => p_eff_start,
2112: p_effective_end_date => p_eff_end);
2113: --
2114: hr_utility.set_location('pyusuiet',480);
2115: hr_input_values.chk_input_value(
2116: p_element_type_id => p_ele_type_id,
2117: p_legislation_code => g_template_leg_code,
2118: p_val_start_date => p_eff_start,
2134: p_formula_id => v_val_formula_id,
2135: p_generate_db_items_flag => v_gen_dbi,
2136: p_warning_or_error => 'Error');
2137: --
2138: hr_utility.set_location('pyusuiet',485);
2139: hr_input_values.ins_3p_input_values(
2140: p_val_start_date => p_eff_start,
2141: p_val_end_date => NULL,
2142: p_element_type_id => p_ele_type_id,
2158: -- Check classification, if supplemental, then create "Tax Separately"
2159: IF UPPER(p_ele_class) = 'SUPPLEMENTAL EARNINGS' THEN
2160: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
2161: -- Creating "Tax Separately" inpval
2162: hr_utility.set_location('pyusuiet',490);
2163: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2164: v_inpval_name := 'Tax Separately';
2165: v_inpval_uom := 'C';
2166: v_gen_dbi := 'N';
2177: p_default_value => v_dflt_value,
2178: p_lookup_type => v_lkp_type,
2179: p_business_group_name => p_bg_name);
2180:
2181: hr_utility.set_location('pyusuiet',495);
2182: hr_input_values.chk_input_value(
2183: p_element_type_id => p_ele_type_id,
2184: p_legislation_code => g_template_leg_code,
2185: p_val_start_date => p_eff_start,
2201: p_formula_id => NULL,
2202: p_generate_db_items_flag => v_gen_dbi,
2203: p_warning_or_error => NULL);
2204:
2205: hr_utility.set_location('pyusuiet',500);
2206: hr_input_values.ins_3p_input_values(
2207: p_val_start_date => p_eff_start,
2208: p_val_end_date => NULL,
2209: p_element_type_id => p_ele_type_id,
2228: -- G1188 (03-Aug-94): Also create these input values if ele classification
2229: -- is 'Supplemental Earnings'.
2230: --
2231: -- Creating "Deduction Processing" inpval
2232: hr_utility.set_location('pyusuiet',505);
2233: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2234: v_inpval_name := 'Deduction Processing';
2235: v_inpval_uom := 'C';
2236: v_gen_dbi := 'N';
2259: ELSE
2260: v_mand_flag := 'Y';
2261: END IF;
2262:
2263: hr_utility.set_location('pyusuiet',510);
2264: v_inpval_id := pay_db_pay_setup.create_input_value (
2265: p_element_name => p_ele_name,
2266: p_name => v_inpval_name,
2267: p_uom_code => v_inpval_uom,
2278: p_business_group_name => p_bg_name,
2279: p_effective_start_date => p_eff_start,
2280: p_effective_end_date => p_eff_end);
2281:
2282: hr_utility.set_location('pyusuiet',515);
2283: hr_input_values.chk_input_value(
2284: p_element_type_id => p_ele_type_id,
2285: p_legislation_code => g_template_leg_code,
2286: p_val_start_date => p_eff_start,
2302: p_formula_id => NULL,
2303: p_generate_db_items_flag => v_gen_dbi,
2304: p_warning_or_error => NULL);
2305:
2306: hr_utility.set_location('pyusuiet',520);
2307: hr_input_values.ins_3p_input_values(
2308: p_val_start_date => p_eff_start,
2309: p_val_end_date => p_eff_end,
2310: p_element_type_id => p_ele_type_id,
2324: -- (HERE) Done inserting "Deduction Processing" input value.
2325: --
2326: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
2327: -- Creating "Separate Check" inpval
2328: hr_utility.set_location('pyusuiet',525);
2329: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2330: v_inpval_name := 'Separate Check';
2331: v_inpval_uom := 'C';
2332: v_gen_dbi := 'N';
2355: v_mand_flag := 'Y';
2356:
2357: END IF;
2358:
2359: hr_utility.set_location('pyusuiet',530);
2360: v_inpval_id := pay_db_pay_setup.create_input_value (
2361: p_element_name => p_ele_name,
2362: p_name => v_inpval_name,
2363: p_uom_code => v_inpval_uom,
2374: p_business_group_name => p_bg_name,
2375: p_effective_start_date => p_eff_start,
2376: p_effective_end_date => p_eff_end);
2377:
2378: hr_utility.set_location('pyusuiet',535);
2379: hr_input_values.chk_input_value(
2380: p_element_type_id => p_ele_type_id,
2381: p_legislation_code => g_template_leg_code,
2382: p_val_start_date => p_eff_start,
2398: p_formula_id => NULL,
2399: p_generate_db_items_flag => v_gen_dbi,
2400: p_warning_or_error => NULL);
2401:
2402: hr_utility.set_location('pyusuiet',540);
2403: hr_input_values.ins_3p_input_values(
2404: p_val_start_date => p_eff_start,
2405: p_val_end_date => p_eff_end,
2406: p_element_type_id => p_ele_type_id,
2425: -- Creating "Date Earned" inpval
2426: --
2427: /*
2428:
2429: hr_utility.trace('I am going to create the Date Earned');
2430: hr_utility.set_location('pyusuiet',545);
2431: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2432: v_inpval_name := 'Date Earned';
2433: v_inpval_uom := 'Date (DD-MON-YYYY)';
2426: --
2427: /*
2428:
2429: hr_utility.trace('I am going to create the Date Earned');
2430: hr_utility.set_location('pyusuiet',545);
2431: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2432: v_inpval_name := 'Date Earned';
2433: v_inpval_uom := 'Date (DD-MON-YYYY)';
2434: v_gen_dbi := 'N';
2432: v_inpval_name := 'Date Earned';
2433: v_inpval_uom := 'Date (DD-MON-YYYY)';
2434: v_gen_dbi := 'N';
2435:
2436: hr_utility.trace('The input value name is '|| v_inpval_name );
2437: hr_utility.set_location('pyusuiet',550);
2438: v_inpval_id := pay_db_pay_setup.create_input_value (
2439: p_element_name => p_ele_name,
2440: p_name => v_inpval_name,
2433: v_inpval_uom := 'Date (DD-MON-YYYY)';
2434: v_gen_dbi := 'N';
2435:
2436: hr_utility.trace('The input value name is '|| v_inpval_name );
2437: hr_utility.set_location('pyusuiet',550);
2438: v_inpval_id := pay_db_pay_setup.create_input_value (
2439: p_element_name => p_ele_name,
2440: p_name => v_inpval_name,
2441: p_uom_code => v_inpval_uom,
2443: p_generate_db_item_flag => v_gen_dbi,
2444: p_display_sequence => g_inpval_disp_seq,
2445: p_business_group_name => p_bg_name);
2446:
2447: hr_utility.set_location('pyusuiet',555);
2448: hr_input_values.chk_input_value(
2449: p_element_type_id => p_ele_type_id,
2450: p_legislation_code => g_template_leg_code,
2451: p_val_start_date => p_eff_start,
2467: p_formula_id => NULL,
2468: p_generate_db_items_flag => v_gen_dbi,
2469: p_warning_or_error => NULL);
2470:
2471: hr_utility.set_location('pyusuiet',560);
2472: hr_input_values.ins_3p_input_values(
2473: p_val_start_date => p_eff_start,
2474: p_val_end_date => p_eff_end,
2475: p_element_type_id => p_ele_type_id,
2497: -- Creating "Replace Amt" inpval
2498:
2499: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
2500:
2501: hr_utility.set_location('pyusuiet',565);
2502: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2503: v_inpval_name := 'Replace Amt';
2504: v_inpval_uom := 'M';
2505: v_gen_dbi := 'N';
2522: p_business_group_name => p_bg_name,
2523: p_effective_start_date => p_eff_start,
2524: p_effective_end_date => p_eff_end);
2525:
2526: hr_utility.set_location('pyusuiet',570);
2527: hr_input_values.chk_input_value(
2528: p_element_type_id => p_inputs_ele_type_id,
2529: p_legislation_code => g_template_leg_code,
2530: p_val_start_date => p_eff_start,
2546: p_formula_id => NULL,
2547: p_generate_db_items_flag => v_gen_dbi,
2548: p_warning_or_error => NULL);
2549:
2550: hr_utility.set_location('pyusuiet',575);
2551: hr_input_values.ins_3p_input_values(
2552: p_val_start_date => p_eff_start,
2553: p_val_end_date => p_eff_end,
2554: p_element_type_id => p_inputs_ele_type_id,
2569: -- (HERE) Done inserting "Replacement Amount" input value.
2570: --
2571: -- Creating "Addl Amt" inpval
2572: --
2573: hr_utility.set_location('pyusuiet',580);
2574: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2575: v_inpval_name := 'Addl Amt';
2576: v_inpval_uom := 'M';
2577: v_gen_dbi := 'N';
2594: p_business_group_name => p_bg_name,
2595: p_effective_start_date => p_eff_start,
2596: p_effective_end_date => p_eff_end);
2597:
2598: hr_utility.set_location('pyusuiet',585);
2599: hr_input_values.chk_input_value(
2600: p_element_type_id => p_inputs_ele_type_id,
2601: p_legislation_code => g_template_leg_code,
2602: p_val_start_date => p_eff_start,
2618: p_formula_id => NULL,
2619: p_generate_db_items_flag => v_gen_dbi,
2620: p_warning_or_error => NULL);
2621:
2622: hr_utility.set_location('pyusuiet',590);
2623: hr_input_values.ins_3p_input_values(
2624: p_val_start_date => p_eff_start,
2625: p_val_end_date => p_eff_end,
2626: p_element_type_id => p_inputs_ele_type_id,
2657: g_inpval_disp_seq := 0;
2658:
2659: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
2660:
2661: hr_utility.set_location('pyusuiet',595);
2662: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2663: v_inpval_name := 'Replacement Amt';
2664: v_inpval_uom := 'M';
2665: v_gen_dbi := 'N';
2682: p_business_group_name => p_bg_name,
2683: p_effective_start_date => p_eff_start,
2684: p_effective_end_date => p_eff_end);
2685:
2686: hr_utility.set_location('pyusuiet',600);
2687: hr_input_values.chk_input_value(
2688: p_element_type_id => p_shadow_ele_type_id,
2689: p_legislation_code => g_template_leg_code,
2690: p_val_start_date => p_eff_start,
2706: p_formula_id => NULL,
2707: p_generate_db_items_flag => v_gen_dbi,
2708: p_warning_or_error => NULL);
2709:
2710: hr_utility.set_location('pyusuiet',605);
2711: hr_input_values.ins_3p_input_values(
2712: p_val_start_date => p_eff_start,
2713: p_val_end_date => p_eff_end,
2714: p_element_type_id => p_shadow_ele_type_id,
2729: -- (HERE) Done inserting "Replacement Amount" input value.
2730: --
2731: -- Creating "Addl Amt" inpval
2732: --
2733: hr_utility.set_location('pyusuiet',610);
2734: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2735: v_inpval_name := 'Additional Amt';
2736: v_inpval_uom := 'M';
2737: v_gen_dbi := 'N';
2754: p_business_group_name => p_bg_name,
2755: p_effective_start_date => p_eff_start,
2756: p_effective_end_date => p_eff_end);
2757:
2758: hr_utility.set_location('pyusuiet',615);
2759: hr_input_values.chk_input_value(
2760: p_element_type_id => p_shadow_ele_type_id,
2761: p_legislation_code => g_template_leg_code,
2762: p_val_start_date => p_eff_start,
2778: p_formula_id => NULL,
2779: p_generate_db_items_flag => v_gen_dbi,
2780: p_warning_or_error => NULL);
2781:
2782: hr_utility.set_location('pyusuiet',620);
2783: hr_input_values.ins_3p_input_values(
2784: p_val_start_date => p_eff_start,
2785: p_val_end_date => p_eff_end,
2786: p_element_type_id => p_shadow_ele_type_id,
2804: -- (HERE) Done inserting "Addl Amt" input value.
2805: --
2806: -- Now insert "Neg Earnings".
2807: --
2808: hr_utility.set_location('pyusuiet',625);
2809: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2810: v_inpval_name := 'Neg Earnings';
2811: v_inpval_uom := 'M';
2812: v_gen_dbi := 'N';
2829: p_business_group_name => p_bg_name,
2830: p_effective_start_date => p_eff_start,
2831: p_effective_end_date => p_eff_end);
2832:
2833: hr_utility.set_location('pyusuiet',630);
2834: hr_input_values.chk_input_value(
2835: p_element_type_id => p_shadow_ele_type_id,
2836: p_legislation_code => g_template_leg_code,
2837: p_val_start_date => p_eff_start,
2853: p_formula_id => NULL,
2854: p_generate_db_items_flag => v_gen_dbi,
2855: p_warning_or_error => NULL);
2856:
2857: hr_utility.set_location('pyusuiet',635);
2858: hr_input_values.ins_3p_input_values(
2859: p_val_start_date => p_eff_start,
2860: p_val_end_date => p_eff_end,
2861: p_element_type_id => p_shadow_ele_type_id,
2877: --
2878:
2879: -- Now insert "Reduce Reg Hours".
2880: --
2881: hr_utility.set_location('pyusuiet',640);
2882: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2883: v_inpval_name := 'Reduce Reg Hours';
2884: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
2885: v_gen_dbi := 'N';
2903: p_effective_start_date => p_eff_start,
2904: p_effective_end_date => p_eff_end);
2905:
2906:
2907: hr_utility.set_location('pyusuiet',645);
2908: hr_input_values.chk_input_value(
2909: p_element_type_id => p_shadow_ele_type_id,
2910: p_legislation_code => g_template_leg_code,
2911: p_val_start_date => p_eff_start,
2927: p_formula_id => NULL,
2928: p_generate_db_items_flag => v_gen_dbi,
2929: p_warning_or_error => NULL);
2930:
2931: hr_utility.set_location('pyusuiet',650);
2932: hr_input_values.ins_3p_input_values(
2933: p_val_start_date => p_eff_start,
2934: p_val_end_date => p_eff_end,
2935: p_element_type_id => p_shadow_ele_type_id,
2950: -- (HERE) Done inserting "Reduce Reg Hours" input value.
2951:
2952: -- Now insert "Reduce Reg Pay".
2953: --
2954: hr_utility.set_location('pyusuiet',655);
2955: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2956: v_inpval_name := 'Reduce Reg Pay';
2957: v_inpval_uom := 'M';
2958: v_gen_dbi := 'N';
2975: p_business_group_name => p_bg_name,
2976: p_effective_start_date => p_eff_start,
2977: p_effective_end_date => p_eff_end);
2978:
2979: hr_utility.set_location('pyusuiet',660);
2980: hr_input_values.chk_input_value(
2981: p_element_type_id => p_shadow_ele_type_id,
2982: p_legislation_code => g_template_leg_code,
2983: p_val_start_date => p_eff_start,
2999: p_formula_id => NULL,
3000: p_generate_db_items_flag => v_gen_dbi,
3001: p_warning_or_error => NULL);
3002:
3003: hr_utility.set_location('pyusuiet',665);
3004: hr_input_values.ins_3p_input_values(
3005: p_val_start_date => p_eff_start,
3006: p_val_end_date => p_eff_end,
3007: p_element_type_id => p_shadow_ele_type_id,
3022: -- (HERE) Done inserting "Reduce Reg Pay" input value.
3023:
3024: -- Now insert "Reduce Sal Hours".
3025: --
3026: hr_utility.set_location('pyusuiet',670);
3027: g_inpval_disp_seq := g_inpval_disp_seq + 1;
3028: v_inpval_name := 'Reduce Sal Hours';
3029: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
3030: v_gen_dbi := 'N';
3047: p_business_group_name => p_bg_name,
3048: p_effective_start_date => p_eff_start,
3049: p_effective_end_date => p_eff_end);
3050:
3051: hr_utility.set_location('pyusuiet',675);
3052: hr_input_values.chk_input_value(
3053: p_element_type_id => p_shadow_ele_type_id,
3054: p_legislation_code => g_template_leg_code,
3055: p_val_start_date => p_eff_start,
3071: p_formula_id => NULL,
3072: p_generate_db_items_flag => v_gen_dbi,
3073: p_warning_or_error => NULL);
3074:
3075: hr_utility.set_location('pyusuiet',680);
3076: hr_input_values.ins_3p_input_values(
3077: p_val_start_date => p_eff_start,
3078: p_val_end_date => p_eff_end,
3079: p_element_type_id => p_shadow_ele_type_id,
3094: -- (HERE) Done inserting "Reduce Sal Hours" input value.
3095:
3096: -- Now insert "Reduce Sal Pay".
3097: --
3098: hr_utility.set_location('pyusuiet',685);
3099: g_inpval_disp_seq := g_inpval_disp_seq + 1;
3100: v_inpval_name := 'Reduce Sal Pay';
3101: v_inpval_uom := 'M';
3102: v_gen_dbi := 'N';
3119: p_business_group_name => p_bg_name,
3120: p_effective_start_date => p_eff_start,
3121: p_effective_end_date => p_eff_end);
3122:
3123: hr_utility.set_location('pyusuiet',690);
3124: hr_input_values.chk_input_value(
3125: p_element_type_id => p_shadow_ele_type_id,
3126: p_legislation_code => g_template_leg_code,
3127: p_val_start_date => p_eff_start,
3143: p_formula_id => NULL,
3144: p_generate_db_items_flag => v_gen_dbi,
3145: p_warning_or_error => NULL);
3146:
3147: hr_utility.set_location('pyusuiet',695);
3148: hr_input_values.ins_3p_input_values(
3149: p_val_start_date => p_eff_start,
3150: p_val_end_date => p_eff_end,
3151: p_element_type_id => p_shadow_ele_type_id,
3166: -- (HERE) Done inserting "Reduce Sal Pay" input value.
3167:
3168: -- Now insert "Reduce Wag Hours".
3169: --
3170: hr_utility.set_location('pyusuiet',700);
3171: g_inpval_disp_seq := g_inpval_disp_seq + 1;
3172: v_inpval_name := 'Reduce Wag Hours';
3173: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
3174: v_gen_dbi := 'N';
3191: p_business_group_name => p_bg_name,
3192: p_effective_start_date => p_eff_start,
3193: p_effective_end_date => p_eff_end);
3194:
3195: hr_utility.set_location('pyusuiet',705);
3196: hr_input_values.chk_input_value(
3197: p_element_type_id => p_shadow_ele_type_id,
3198: p_legislation_code => g_template_leg_code,
3199: p_val_start_date => p_eff_start,
3215: p_formula_id => NULL,
3216: p_generate_db_items_flag => v_gen_dbi,
3217: p_warning_or_error => NULL);
3218:
3219: hr_utility.set_location('pyusuiet',710);
3220: hr_input_values.ins_3p_input_values(
3221: p_val_start_date => p_eff_start,
3222: p_val_end_date => p_eff_end,
3223: p_element_type_id => p_shadow_ele_type_id,
3238: -- (HERE) Done inserting "Reduce Wag Hours" input value.
3239:
3240: -- Now insert "Reduce Wag Pay".
3241: --
3242: hr_utility.set_location('pyusuiet',715);
3243: g_inpval_disp_seq := g_inpval_disp_seq + 1;
3244: v_inpval_name := 'Reduce Wag Pay';
3245: v_inpval_uom := 'M';
3246: v_gen_dbi := 'N';
3263: p_business_group_name => p_bg_name,
3264: p_effective_start_date => p_eff_start,
3265: p_effective_end_date => p_eff_end);
3266:
3267: hr_utility.set_location('pyusuiet',720);
3268: hr_input_values.chk_input_value(
3269: p_element_type_id => p_shadow_ele_type_id,
3270: p_legislation_code => g_template_leg_code,
3271: p_val_start_date => p_eff_start,
3287: p_formula_id => NULL,
3288: p_generate_db_items_flag => v_gen_dbi,
3289: p_warning_or_error => NULL);
3290:
3291: hr_utility.set_location('pyusuiet',725);
3292: hr_input_values.ins_3p_input_values(
3293: p_val_start_date => p_eff_start,
3294: p_val_end_date => p_eff_end,
3295: p_element_type_id => p_shadow_ele_type_id,
3308: p_startup_mode => NULL);
3309: --
3310: -- (HERE) Done inserting "Reduce Wag Pay" input value.
3311:
3312: hr_utility.set_location('pyusuiet',730);
3313: SELECT status_processing_rule_id
3314: INTO v_status_proc_id
3315: FROM pay_status_processing_rules_f
3316: WHERE assignment_status_type_id IS NULL
3318: --
3319:
3320: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
3321:
3322: hr_utility.set_location('pyusuiet',735);
3323: v_resrule_id := pay_formula_results.ins_form_res_rule (
3324: p_business_group_id => p_bg_id,
3325: p_legislation_code => NULL,
3326: p_legislation_subgroup => g_template_leg_subgroup,
3332: p_result_rule_type => 'I',
3333: p_severity_level => NULL,
3334: p_element_type_id => p_shadow_ele_type_id);
3335: --
3336: hr_utility.set_location('pyusuiet',740);
3337: v_resrule_id := pay_formula_results.ins_form_res_rule (
3338: p_business_group_id => p_bg_id,
3339: p_legislation_code => NULL,
3340: p_legislation_subgroup => g_template_leg_subgroup,
3350:
3351: End if; /* Not required for NR Elements */
3352:
3353:
3354: hr_utility.set_location('pyusuiet',745);
3355: v_resrule_id := pay_formula_results.ins_form_res_rule (
3356: p_business_group_id => p_bg_id,
3357: p_legislation_code => NULL,
3358: p_legislation_subgroup => g_template_leg_subgroup,
3367: --
3368:
3369: /* get the input value id for the Pay Value input value for the shadow element. */
3370:
3371: hr_utility.set_location('pyusuiet',750);
3372: select pivf.input_value_id
3373: into g_shadow_info_payval_id
3374: from pay_input_values_f pivf
3375: where pivf.element_type_id = p_shadow_ele_type_id
3374: from pay_input_values_f pivf
3375: where pivf.element_type_id = p_shadow_ele_type_id
3376: and pivf.name = 'Pay Value';
3377:
3378: hr_utility.set_location('pyusuiet',755);
3379: v_resrule_id := pay_formula_results.ins_form_res_rule (
3380: p_business_group_id => p_bg_id,
3381: p_legislation_code => NULL,
3382: p_legislation_subgroup => g_template_leg_subgroup,
3390: p_element_type_id => p_shadow_ele_type_id );
3391: --
3392:
3393: --
3394: hr_utility.set_location('pyusuiet',760);
3395: v_resrule_id := pay_formula_results.ins_form_res_rule (
3396: p_business_group_id => p_bg_id,
3397: p_legislation_code => NULL,
3398: p_legislation_subgroup => g_template_leg_subgroup,
3404: p_result_rule_type => 'I',
3405: p_severity_level => NULL,
3406: p_element_type_id => p_shadow_ele_type_id );
3407: --
3408: hr_utility.set_location('pyusuiet',765);
3409: v_resrule_id := pay_formula_results.ins_form_res_rule (
3410: p_business_group_id => p_bg_id,
3411: p_legislation_code => NULL,
3412: p_legislation_subgroup => g_template_leg_subgroup,
3420: p_element_type_id => p_shadow_ele_type_id );
3421: --
3422:
3423: --
3424: hr_utility.set_location('pyusuiet',770);
3425: v_resrule_id := pay_formula_results.ins_form_res_rule (
3426: p_business_group_id => p_bg_id,
3427: p_legislation_code => NULL,
3428: p_legislation_subgroup => g_template_leg_subgroup,
3435: p_severity_level => NULL,
3436: p_element_type_id => p_shadow_ele_type_id );
3437: --
3438:
3439: hr_utility.set_location('pyusuiet',775);
3440: v_resrule_id := pay_formula_results.ins_form_res_rule (
3441: p_business_group_id => p_bg_id,
3442: p_legislation_code => NULL,
3443: p_legislation_subgroup => g_template_leg_subgroup,
3452: --
3453:
3454: IF UPPER(p_ele_proc_type) = 'R' THEN
3455: --
3456: hr_utility.set_location('pyusuiet',780);
3457: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
3458: p_business_group_id => p_bg_id,
3459: p_legislation_code => NULL,
3460: p_legislation_subgroup => g_template_leg_subgroup,
3770:
3771: --
3772: -- Set session date
3773:
3774: hr_utility.set_location('pyusuiet',785);
3775: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
3776: g_eff_start_date := NVL(p_ele_eff_start_date, sysdate);
3777: g_eff_end_date := NVL(p_ele_eff_end_date, c_end_of_time);
3778:
3776: g_eff_start_date := NVL(p_ele_eff_start_date, sysdate);
3777: g_eff_end_date := NVL(p_ele_eff_end_date, c_end_of_time);
3778:
3779: -- Set globals: v_bg_name
3780: hr_utility.set_location('pyusuiet',790);
3781: select name
3782: into v_bg_name
3783: from per_business_groups
3784: where business_group_id = p_bg_id;
3790: -- Create bal type, then Defined_Balances for PTD, MTD, and YTD dimensions.
3791: -- Let currency code default to leg currency.
3792: -- ins_uie_balance (e_name, bal_uom);
3793:
3794: hr_utility.set_location('pyusuiet',795);
3795: -- Check element name, ie. primary balance name, is unique to
3796: -- balances within this BG.
3797:
3798: pay_balance_types_pkg.chk_balance_type(
3802: p_balance_name => p_ele_name,
3803: p_reporting_name => p_ele_name,
3804: p_assignment_remuneration_flag => 'N');
3805:
3806: hr_utility.set_location('pyusuiet',800);
3807: -- Check element name, ie. primary balance name, is unique to
3808: -- balances provided as startup data.
3809:
3810: pay_balance_types_pkg.chk_balance_type(
3833: else
3834: l_bal_cat_classification := 'Supplemental Earnings';
3835: end if;
3836:
3837: hr_utility.set_location('pyusuiet',805);
3838: v_bal_type_id := pay_db_pay_setup.create_balance_type(
3839: p_balance_name => p_ele_name,
3840: p_uom => null,
3841: p_uom_code => 'M',
3850: IF p_ele_processing_type = 'R' THEN
3851: v_neg_earnbal_name := SUBSTR(p_ele_name, 1, 65)||' Neg Earnings';
3852: --v_bal_repname := SUBSTR(p_ele_reporting_name, 1, 15)||' Neg Earnings';
3853:
3854: hr_utility.set_location('pyusuiet',810);
3855: v_neg_earn_bal_type_id := pay_db_pay_setup.create_balance_type(
3856: p_balance_name => v_neg_earnbal_name,
3857: p_uom => null,
3858: p_uom_code => 'M',
3873: IF p_ele_processing_type = 'R' THEN /* Not required for NR Elements Change */
3874: v_addl_amt_bal_name := SUBSTR(p_ele_name, 1, 67)||' Additional';
3875: --v_bal_repname := SUBSTR(p_ele_reporting_name, 1, 17)||' Additional';
3876:
3877: hr_utility.set_location('pyusuiet',815);
3878: v_addl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(
3879: p_balance_name => v_addl_amt_bal_name,
3880: p_uom => null,
3881: p_uom_code => 'M',
3889: --
3890: v_repl_amt_bal_name := SUBSTR(p_ele_name, 1, 67)||' Replacement';
3891: --v_bal_repname := SUBSTR(p_ele_reporting_name, 1, 17)||' Replacement';
3892:
3893: hr_utility.set_location('pyusuiet',820);
3894: v_repl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(
3895: p_balance_name => v_repl_amt_bal_name,
3896: p_uom => null,
3897: p_uom_code => 'M',
3906: end if; /* Not required for NR Elements Change */
3907: --
3908: -- Defined Balances (ie. balance type associated with a dimension)
3909: --
3910: hr_utility.set_location('pyusuiet',825);
3911:
3912: --
3913: -- check for existence of defined balance before creating...return defbal id if already exists...
3914: --
3918: p_balance_dimension => 'Assignment within Government Reporting Entity Year to Date',
3919: p_business_group_name => v_bg_name,
3920: p_legislation_code => NULL);
3921:
3922: hr_utility.set_location('pyusuiet',830);
3923: pay_db_pay_setup.create_defined_balance (
3924: p_balance_name => p_ele_name,
3925: p_balance_dimension => 'Assignment within Government Reporting Entity Period to Date',
3926: p_business_group_name => v_bg_name,
3925: p_balance_dimension => 'Assignment within Government Reporting Entity Period to Date',
3926: p_business_group_name => v_bg_name,
3927: p_legislation_code => NULL);
3928:
3929: hr_utility.set_location('pyusuiet',835);
3930: pay_db_pay_setup.create_defined_balance (
3931: p_balance_name => p_ele_name,
3932: p_balance_dimension => 'Assignment within Government Reporting Entity Quarter to Date',
3933: p_business_group_name => v_bg_name,
3932: p_balance_dimension => 'Assignment within Government Reporting Entity Quarter to Date',
3933: p_business_group_name => v_bg_name,
3934: p_legislation_code => NULL);
3935:
3936: hr_utility.set_location('pyusuiet',840);
3937: pay_db_pay_setup.create_defined_balance (
3938: p_balance_name => p_ele_name,
3939: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
3940: p_business_group_name => v_bg_name,
3940: p_business_group_name => v_bg_name,
3941: p_legislation_code => NULL,
3942: p_save_run_bal => 'Y');
3943:
3944: hr_utility.set_location('pyusuiet',845);
3945: pay_db_pay_setup.create_defined_balance (
3946: p_balance_name => p_ele_name,
3947: p_balance_dimension => 'Assignment within Government Reporting Entity Month',
3948: p_business_group_name => v_bg_name,
3947: p_balance_dimension => 'Assignment within Government Reporting Entity Month',
3948: p_business_group_name => v_bg_name,
3949: p_legislation_code => NULL);
3950:
3951: hr_utility.set_location('pyusuiet',850);
3952: pay_db_pay_setup.create_defined_balance (
3953: p_balance_name => p_ele_name,
3954: p_balance_dimension => 'Assignment-Level Current Run',
3955: p_business_group_name => v_bg_name,
3954: p_balance_dimension => 'Assignment-Level Current Run',
3955: p_business_group_name => v_bg_name,
3956: p_legislation_code => NULL);
3957:
3958: hr_utility.set_location('pyusuiet',855);
3959: pay_db_pay_setup.create_defined_balance (
3960: p_balance_name => p_ele_name,
3961: p_balance_dimension => 'Assignment Period to Date',
3962: p_business_group_name => v_bg_name,
3961: p_balance_dimension => 'Assignment Period to Date',
3962: p_business_group_name => v_bg_name,
3963: p_legislation_code => NULL);
3964:
3965: hr_utility.set_location('pyusuiet',860);
3966: pay_db_pay_setup.create_defined_balance (
3967: p_balance_name => p_ele_name,
3968: p_balance_dimension => 'Assignment Month',
3969: p_business_group_name => v_bg_name,
3968: p_balance_dimension => 'Assignment Month',
3969: p_business_group_name => v_bg_name,
3970: p_legislation_code => NULL);
3971:
3972: hr_utility.set_location('pyusuiet',865);
3973: pay_db_pay_setup.create_defined_balance (
3974: p_balance_name => p_ele_name,
3975: p_balance_dimension => 'Assignment Quarter to Date',
3976: p_business_group_name => v_bg_name,
3975: p_balance_dimension => 'Assignment Quarter to Date',
3976: p_business_group_name => v_bg_name,
3977: p_legislation_code => NULL);
3978:
3979: hr_utility.set_location('pyusuiet',870);
3980: pay_db_pay_setup.create_defined_balance (
3981: p_balance_name => p_ele_name,
3982: p_balance_dimension => 'Assignment Year to Date',
3983: p_business_group_name => v_bg_name,
3982: p_balance_dimension => 'Assignment Year to Date',
3983: p_business_group_name => v_bg_name,
3984: p_legislation_code => NULL);
3985:
3986: hr_utility.set_location('pyusuiet',875);
3987: pay_db_pay_setup.create_defined_balance (
3988: p_balance_name => p_ele_name,
3989: p_balance_dimension => 'Person Run',
3990: p_business_group_name => v_bg_name,
3989: p_balance_dimension => 'Person Run',
3990: p_business_group_name => v_bg_name,
3991: p_legislation_code => NULL);
3992:
3993: hr_utility.set_location('pyusuiet',880);
3994: pay_db_pay_setup.create_defined_balance (
3995: p_balance_name => p_ele_name,
3996: p_balance_dimension => 'Person Quarter to Date',
3997: p_business_group_name => v_bg_name,
3996: p_balance_dimension => 'Person Quarter to Date',
3997: p_business_group_name => v_bg_name,
3998: p_legislation_code => NULL);
3999:
4000: hr_utility.set_location('pyusuiet',885);
4001: pay_db_pay_setup.create_defined_balance (
4002: p_balance_name => p_ele_name,
4003: p_balance_dimension => 'Person Year to Date',
4004: p_business_group_name => v_bg_name,
4003: p_balance_dimension => 'Person Year to Date',
4004: p_business_group_name => v_bg_name,
4005: p_legislation_code => NULL);
4006:
4007: hr_utility.set_location('pyusuiet',890);
4008: pay_db_pay_setup.create_defined_balance (
4009: p_balance_name => p_ele_name,
4010: p_balance_dimension => 'Person Month',
4011: p_business_group_name => v_bg_name,
4010: p_balance_dimension => 'Person Month',
4011: p_business_group_name => v_bg_name,
4012: p_legislation_code => NULL);
4013:
4014: hr_utility.set_location('pyusuiet',895);
4015: pay_db_pay_setup.create_defined_balance (
4016: p_balance_name => p_ele_name,
4017: p_balance_dimension => 'Person within Government Reporting Entity Run',
4018: p_business_group_name => v_bg_name,
4017: p_balance_dimension => 'Person within Government Reporting Entity Run',
4018: p_business_group_name => v_bg_name,
4019: p_legislation_code => NULL);
4020:
4021: hr_utility.set_location('pyusuiet',900);
4022: pay_db_pay_setup.create_defined_balance (
4023: p_balance_name => p_ele_name,
4024: p_balance_dimension => 'Person within Government Reporting Entity Quarter to Date',
4025: p_business_group_name => v_bg_name,
4024: p_balance_dimension => 'Person within Government Reporting Entity Quarter to Date',
4025: p_business_group_name => v_bg_name,
4026: p_legislation_code => NULL);
4027:
4028: hr_utility.set_location('pyusuiet',910);
4029: pay_db_pay_setup.create_defined_balance (
4030: p_balance_name => p_ele_name,
4031: p_balance_dimension => 'Person within Government Reporting Entity Year to Date',
4032: p_business_group_name => v_bg_name,
4031: p_balance_dimension => 'Person within Government Reporting Entity Year to Date',
4032: p_business_group_name => v_bg_name,
4033: p_legislation_code => NULL);
4034:
4035: hr_utility.set_location('pyusuiet',915);
4036: pay_db_pay_setup.create_defined_balance (
4037: p_balance_name => p_ele_name,
4038: p_balance_dimension => 'Person within Government Reporting Entity Month',
4039: p_business_group_name => v_bg_name,
4038: p_balance_dimension => 'Person within Government Reporting Entity Month',
4039: p_business_group_name => v_bg_name,
4040: p_legislation_code => NULL);
4041:
4042: hr_utility.set_location('pyusuiet',920);
4043: pay_db_pay_setup.create_defined_balance (
4044: p_balance_name => p_ele_name,
4045: p_balance_dimension => 'Government Reporting Entity Year to Date',
4046: p_business_group_name => v_bg_name,
4047: p_legislation_code => NULL);
4048:
4049: /* *** WWBug 133133 start *** */
4050: /* Adding defined balances for GRE_RUN and GRE_ITD for primary balance */
4051: hr_utility.set_location('pyusuiet',925);
4052: pay_db_pay_setup.create_defined_balance (
4053: p_balance_name => p_ele_name,
4054: p_balance_dimension => 'Government Reporting Entity Run',
4055: p_business_group_name => v_bg_name,
4056: p_legislation_code => NULL);
4057:
4058: IF p_ele_processing_type = 'R' THEN /* Not required for NR Elements */
4059:
4060: hr_utility.set_location('pyusuiet',930);
4061: pay_db_pay_setup.create_defined_balance (
4062: p_balance_name => p_ele_name,
4063: p_balance_dimension => 'Government Reporting Entity Inception to Date',
4064: p_business_group_name => v_bg_name,
4071: /* bug 1835350 begin
4072: IF UPPER(p_ele_classification) <> 'NON-PAYROLL PAYMENTS' THEN
4073: bug 1835350 end */
4074:
4075: hr_utility.set_location('pyusuiet',935);
4076: pay_db_pay_setup.create_defined_balance (
4077: p_balance_name => p_ele_name,
4078: p_balance_dimension => 'Payments',
4079: p_business_group_name => v_bg_name,
4078: p_balance_dimension => 'Payments',
4079: p_business_group_name => v_bg_name,
4080: p_legislation_code => NULL);
4081:
4082: hr_utility.set_location('pyusuiet',940);
4083: pay_db_pay_setup.create_defined_balance (
4084: p_balance_name => p_ele_name,
4085: p_balance_dimension => 'Assignment Payments',
4086: p_business_group_name => v_bg_name,
4089: /* bug 1835350 begin
4090: END IF;
4091: bug 1835350 end */
4092:
4093: hr_utility.trace('I before p_ele_processing_type ');
4094: hr_utility.trace('p_ele_processing_type is '||p_ele_processing_type);
4095:
4096: IF p_ele_processing_type = 'R' THEN
4097: hr_utility.set_location('pyusuiet',945);
4090: END IF;
4091: bug 1835350 end */
4092:
4093: hr_utility.trace('I before p_ele_processing_type ');
4094: hr_utility.trace('p_ele_processing_type is '||p_ele_processing_type);
4095:
4096: IF p_ele_processing_type = 'R' THEN
4097: hr_utility.set_location('pyusuiet',945);
4098: pay_db_pay_setup.create_defined_balance (
4093: hr_utility.trace('I before p_ele_processing_type ');
4094: hr_utility.trace('p_ele_processing_type is '||p_ele_processing_type);
4095:
4096: IF p_ele_processing_type = 'R' THEN
4097: hr_utility.set_location('pyusuiet',945);
4098: pay_db_pay_setup.create_defined_balance (
4099: p_balance_name => v_neg_earnbal_name,
4100: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
4101: p_business_group_name => v_bg_name,
4103: --
4104: END IF;
4105: --
4106: IF p_ele_processing_type = 'R' THEN /* Not required for NR Elements */
4107: hr_utility.set_location('pyusuiet',950);
4108: pay_db_pay_setup.create_defined_balance (
4109: p_balance_name => v_addl_amt_bal_name,
4110: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
4111: p_business_group_name => v_bg_name,
4110: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
4111: p_business_group_name => v_bg_name,
4112: p_legislation_code => NULL);
4113:
4114: hr_utility.set_location('pyusuiet',955);
4115: pay_db_pay_setup.create_defined_balance (
4116: p_balance_name => v_repl_amt_bal_name,
4117: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
4118: p_business_group_name => v_bg_name,
4126: 'HOURS_X_RATE_MULTIPLE_RECUR_V2',
4127: 'HOURS_X_RATE_MULTIPLE_NONRECUR_V2') THEN
4128:
4129:
4130: hr_utility.trace('I am inside the UPPER IN...HOURS X....');
4131: hr_utility.trace('p_ele_calc_ff_name is '||p_ele_calc_ff_name);
4132:
4133: -- Create "Hours" associated balance for this earning; _ASG_RUN dim.
4134: v_hrs_bal_name := SUBSTR(p_ele_name, 1, 73)||' Hours';
4127: 'HOURS_X_RATE_MULTIPLE_NONRECUR_V2') THEN
4128:
4129:
4130: hr_utility.trace('I am inside the UPPER IN...HOURS X....');
4131: hr_utility.trace('p_ele_calc_ff_name is '||p_ele_calc_ff_name);
4132:
4133: -- Create "Hours" associated balance for this earning; _ASG_RUN dim.
4134: v_hrs_bal_name := SUBSTR(p_ele_name, 1, 73)||' Hours';
4135: --v_hrs_bal_repname := SUBSTR(p_ele_reporting_name, 1, 23)||' Hours';
4133: -- Create "Hours" associated balance for this earning; _ASG_RUN dim.
4134: v_hrs_bal_name := SUBSTR(p_ele_name, 1, 73)||' Hours';
4135: --v_hrs_bal_repname := SUBSTR(p_ele_reporting_name, 1, 23)||' Hours';
4136:
4137: hr_utility.set_location('pyusuiet',960);
4138: v_hrs_bal_type_id := pay_db_pay_setup.create_balance_type(
4139: p_balance_name => v_hrs_bal_name,
4140: p_uom => null,
4141: p_uom_code => 'H_DECIMAL2',
4146: p_balance_category => l_bal_cat_classification, -- Bug 3311781
4147: p_bc_leg_code => 'US',
4148: p_effective_date => g_eff_start_date);
4149:
4150: hr_utility.set_location('pyusuiet',965);
4151: pay_db_pay_setup.create_defined_balance (
4152: p_balance_name => v_hrs_bal_name,
4153: p_balance_dimension => 'Assignment-Level Current Run',
4154: p_business_group_name => v_bg_name,
4153: p_balance_dimension => 'Assignment-Level Current Run',
4154: p_business_group_name => v_bg_name,
4155: p_legislation_code => NULL);
4156:
4157: hr_utility.set_location('pyusuiet',970);
4158: pay_db_pay_setup.create_defined_balance (
4159: p_balance_name => v_hrs_bal_name,
4160: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
4161: p_business_group_name => v_bg_name,
4162: p_legislation_code => NULL,
4163: p_save_run_bal => 'Y');
4164:
4165: -- 16th Feb 1996 Fix - added Payments defined bal to Hours assoc bal.
4166: hr_utility.set_location('pyusuiet',975);
4167: pay_db_pay_setup.create_defined_balance (
4168: p_balance_name => v_hrs_bal_name,
4169: p_balance_dimension => 'Payments',
4170: p_business_group_name => v_bg_name,
4169: p_balance_dimension => 'Payments',
4170: p_business_group_name => v_bg_name,
4171: p_legislation_code => NULL);
4172:
4173: hr_utility.set_location('pyusuiet',980);
4174: pay_db_pay_setup.create_defined_balance (
4175: p_balance_name => v_hrs_bal_name,
4176: p_balance_dimension => 'Assignment Quarter to Date',
4177: p_business_group_name => v_bg_name,
4176: p_balance_dimension => 'Assignment Quarter to Date',
4177: p_business_group_name => v_bg_name,
4178: p_legislation_code => NULL);
4179:
4180: hr_utility.set_location('pyusuiet',985);
4181: pay_db_pay_setup.create_defined_balance (
4182: p_balance_name => v_hrs_bal_name,
4183: p_balance_dimension => 'Assignment Year to Date',
4184: p_business_group_name => v_bg_name,
4183: p_balance_dimension => 'Assignment Year to Date',
4184: p_business_group_name => v_bg_name,
4185: p_legislation_code => NULL);
4186:
4187: hr_utility.set_location('pyusuiet',990);
4188: pay_db_pay_setup.create_defined_balance (
4189: p_balance_name => v_hrs_bal_name,
4190: p_balance_dimension => 'Assignment within Government Reporting Entity Quarter to Date',
4191: p_business_group_name => v_bg_name,
4196: p_balance_dimension => 'Assignment within Government Reporting Entity Year to Date',
4197: p_business_group_name => v_bg_name,
4198: p_legislation_code => NULL);
4199:
4200: hr_utility.set_location('pyusuiet',995);
4201: pay_db_pay_setup.create_defined_balance (
4202: p_balance_name => v_hrs_bal_name,
4203: p_balance_dimension => 'Assignment Payments',
4204: p_business_group_name => v_bg_name,
4208: -- Determine which earnings skip rule needed:
4209: -- Get skip rule formula id and pass it to create_element.
4210:
4211: IF UPPER(p_ele_classification) IN ('EARNINGS', 'IMPUTED EARNINGS') THEN
4212: hr_utility.set_location('pyusuiet',1000);
4213:
4214: hr_utility.trace('Element Classification is '|| p_ele_classification);
4215: --
4216: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4210:
4211: IF UPPER(p_ele_classification) IN ('EARNINGS', 'IMPUTED EARNINGS') THEN
4212: hr_utility.set_location('pyusuiet',1000);
4213:
4214: hr_utility.trace('Element Classification is '|| p_ele_classification);
4215: --
4216: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4217: --
4218: SELECT FF.formula_id
4225: AND p_ele_eff_start_date BETWEEN FF.effective_start_date
4226: AND FF.effective_end_date;
4227: --
4228: ELSIF UPPER(p_ele_classification) = 'SUPPLEMENTAL EARNINGS' THEN
4229: hr_utility.set_location('pyusuiet',1005);
4230: --
4231: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4232: --
4233: SELECT FF.formula_id
4246: --
4247: IF UPPER(p_ele_classification) = 'IMPUTED EARNINGS' AND
4248: p_ele_processing_type = 'N' THEN
4249:
4250: hr_utility.set_location('pyusuiet',1010);
4251: --
4252: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4253: --
4254: SELECT FF.formula_id
4271: IF UPPER(p_ele_calc_ff_name) NOT IN ( 'GROSS_UP_RECUR_V2',
4272: 'GROSS_UP_NONRECUR_V2')
4273: OR
4274: p_ele_calc_ff_name IS NULL THEN
4275: hr_utility.trace('This is inside p_ele_calc_ff_name not in gross_up...');
4276:
4277: hr_utility.set_location('pyusuiet',1015);
4278: v_ele_type_id := ins_uie_ele_type ( p_ele_name,
4279: p_ele_reporting_name,
4273: OR
4274: p_ele_calc_ff_name IS NULL THEN
4275: hr_utility.trace('This is inside p_ele_calc_ff_name not in gross_up...');
4276:
4277: hr_utility.set_location('pyusuiet',1015);
4278: v_ele_type_id := ins_uie_ele_type ( p_ele_name,
4279: p_ele_reporting_name,
4280: p_ele_description,
4281: p_ele_classification,
4289: v_bg_name,
4290: 'S'); -- process mode is S for the actual elements
4291:
4292: -- Need to find PRIMARY_CLASSIFICATION_ID of element type.
4293: hr_utility.set_location('pyusuiet',1020);
4294: select distinct(classification_id)
4295: into v_primary_class_id
4296: from pay_element_types_f
4297: where element_type_id = v_ele_type_id;
4295: into v_primary_class_id
4296: from pay_element_types_f
4297: where element_type_id = v_ele_type_id;
4298: --
4299: hr_utility.set_location('pyusuiet',1025);
4300: SELECT default_low_priority,
4301: default_high_priority
4302: INTO v_class_lo_priority,
4303: v_class_hi_priority
4310: ELSE
4311: l_ele_classification := p_ele_classification;
4312: END IF;
4313: --
4314: hr_utility.set_location('pyusuiet',1030);
4315: v_shadow_ele_name := SUBSTR(p_ele_name, 1, 61)||' Special Features';
4316: v_ele_repname := SUBSTR(p_ele_reporting_name, 1, 27)||' SF';
4317: v_shadow_ele_type_id := ins_uie_ele_type (
4318: v_shadow_ele_name,
4330: 'N'); -- process mode for Special Features should be 'N'
4331: --
4332:
4333: If p_ele_processing_type = 'R' then /* Not required for NR Elements */
4334: hr_utility.set_location('pyusuiet',1031);
4335: v_inputs_ele_name := SUBSTR(p_ele_name, 1, 61)||' Special Inputs';
4336: v_ele_repname := SUBSTR(p_ele_reporting_name, 1, 27)||' SI';
4337: v_inputs_ele_type_id := ins_uie_ele_type (
4338: v_inputs_ele_name,
4351:
4352: end if; /* Not required for NR Elements */
4353: --
4354: ELSE -- GrossUp element being created, need to create this one as "Info".
4355: hr_utility.set_location('pyusuiet',1032);
4356: SELECT classification_id,
4357: default_priority,
4358: default_low_priority,
4359: default_high_priority
4364: FROM pay_element_classifications
4365: WHERE classification_name = 'Information'
4366: AND nvl(business_group_id, p_bg_id) = p_bg_id;
4367: --
4368: hr_utility.set_location('pyusuiet',1033);
4369: v_ele_type_id := ins_uie_ele_type ( p_ele_name,
4370: p_ele_reporting_name,
4371: p_ele_description,
4372: 'Information',
4383: -- Set classification for future reference, call create_vertex_grossup w/this.
4384: --
4385: v_grossup_class_name := p_ele_classification;
4386: --
4387: hr_utility.set_location('pyusuiet',1034);
4388: v_info_payval_id := pay_db_pay_setup.create_input_value (
4389: p_element_name => p_ele_name,
4390: p_name => 'Pay Value',
4391: p_uom_code => 'M',
4402: p_business_group_name => v_bg_name,
4403: p_effective_start_date => g_eff_start_date,
4404: p_effective_end_date => g_eff_end_date);
4405: --
4406: hr_utility.set_location('pyusuiet',1035);
4407: hr_input_values.chk_input_value(
4408: p_element_type_id => v_ele_type_id,
4409: p_legislation_code => g_template_leg_code,
4410: p_val_start_date => g_eff_start_date,
4429: --
4430: --
4431: -- Commenting out this call to 3rd party inserts. Don't think it's needed.
4432: /*
4433: hr_utility.set_location('pyusuiet',1036);
4434: hr_input_values.ins_3p_input_values(
4435: p_val_start_date => g_eff_start_date,
4436: p_val_end_date => g_eff_end_date,
4437: p_element_type_id => v_eletype_id,
4454: --
4455: --
4456: -- Creating shadow element for gross up ele
4457: --
4458: hr_utility.set_location('pyusuiet',1037);
4459: v_shadow_ele_name := SUBSTR(p_ele_name, 1, 61)||' Special Features';
4460: v_ele_repname := SUBSTR(p_ele_reporting_name, 1, 27)||' SF';
4461: v_shadow_ele_type_id := ins_uie_ele_type (
4462: v_shadow_ele_name,
4472: g_eff_start_date,
4473: v_bg_name,
4474: 'N' ); -- process mode
4475:
4476: hr_utility.set_location('pyusuiet',1038);
4477:
4478: v_shadow_info_payval_id := pay_db_pay_setup.create_input_value (
4479: p_element_name => v_shadow_ele_name,
4480: p_name => 'Pay Value',
4492: p_business_group_name => v_bg_name,
4493: p_effective_start_date => g_eff_start_date,
4494: p_effective_end_date => g_eff_end_date);
4495:
4496: hr_utility.set_location('pyusuiet',1039);
4497: hr_input_values.chk_input_value(
4498: p_element_type_id => v_shadow_ele_type_id,
4499: p_legislation_code => g_template_leg_code,
4500: p_val_start_date => g_eff_start_date,
4521: --
4522:
4523: If p_ele_processing_type = 'R' then /* Not required for NR Elements */
4524:
4525: hr_utility.set_location('pyusuiet',1040);
4526: v_inputs_ele_name := SUBSTR(p_ele_name, 1, 61)||' Special Inputs';
4527: v_ele_repname := SUBSTR(p_ele_reporting_name, 1, 27)||' SI';
4528: v_inputs_ele_type_id := ins_uie_ele_type (
4529: v_inputs_ele_name,
4539: g_eff_start_date,
4540: v_bg_name,
4541: 'N' ); -- process mode
4542:
4543: hr_utility.set_location('pyusuiet',1045);
4544: v_inputs_info_payval_id := pay_db_pay_setup.create_input_value (
4545: p_element_name => v_inputs_ele_name,
4546: p_name => 'Pay Value',
4547: p_uom_code => 'M',
4558: p_business_group_name => v_bg_name,
4559: p_effective_start_date => g_eff_start_date,
4560: p_effective_end_date => g_eff_end_date);
4561:
4562: hr_utility.set_location('pyusuiet',1050);
4563: hr_input_values.chk_input_value(
4564: p_element_type_id => v_inputs_ele_type_id,
4565: p_legislation_code => g_template_leg_code,
4566: p_val_start_date => g_eff_start_date,
4619: -------------------------Insert Input Values --------------------------
4620: --
4621: -- Make insertion of all basic earnings input vals (ie. req'd for all
4622: -- earnings elements, not based on calc rule; instead on Class).
4623: hr_utility.set_location('pyusuiet',1055);
4624:
4625: ins_uie_input_vals ( v_ele_type_id,
4626: p_ele_name,
4627: v_shadow_ele_type_id,
4668: WHERE element_type_id = v_ele_type_id
4669: AND business_group_id = p_bg_id;
4670:
4671: -- So we need inpval_id of pay value for this element:
4672: hr_utility.set_location('pyusuiet',1060);
4673: v_payval_name := hr_input_values.get_pay_value_name(g_template_leg_code);
4674:
4675: hr_utility.set_location('pyusuiet',1065);
4676: select iv.input_value_id
4671: -- So we need inpval_id of pay value for this element:
4672: hr_utility.set_location('pyusuiet',1060);
4673: v_payval_name := hr_input_values.get_pay_value_name(g_template_leg_code);
4674:
4675: hr_utility.set_location('pyusuiet',1065);
4676: select iv.input_value_id
4677: into v_payval_id
4678: from pay_input_values_f iv
4679: where iv.element_type_id = v_ele_type_id
4685: -- 08 June 94: Don't need to anymore, payvalue's mandatory flag is set to
4686: -- 'X' (ie. Never enterable) after creation of element type.
4687: --
4688: /*
4689: hr_utility.set_location('pyusuiet',1066);
4690: SELECT formula_id
4691: INTO v_payval_formula_id
4692: FROM ff_formulas_f
4693: WHERE business_group_id IS NULL
4693: WHERE business_group_id IS NULL
4694: AND legislation_code = 'US'
4695: AND formula_name = 'PAYVALUE_VALIDATION';
4696:
4697: hr_utility.set_location('pyusuiet',1067);
4698: UPDATE pay_input_values_f
4699: SET formula_id = v_payval_formula_id,
4700: warning_or_error = 'E'
4701: WHERE input_value_id = v_payval_id;
4705: -- Note, there is a packaged function "chk_ins_balance_feed" in pybalnce.pkb.
4706: -- Since this is definitely a new balance feed for a new element and balance,
4707: -- there is no chance for duplicating an existing feed.
4708: --
4709: hr_utility.set_location('pyusuiet',1068);
4710:
4711: --
4712: -- check for existence of balance feed before creating...return bal feed id if already exists...
4713: --
4736: -- and Time Entry Wages.
4737: --
4738: IF p_ele_processing_type = 'R' THEN
4739:
4740: hr_utility.set_location('pyusuiet',1070);
4741: /*
4742: select iv.input_value_id
4743: into v_negearn_inpval_id
4744: from pay_input_values_f iv
4749: -- Now, insert feed.
4750: -- Note, there is a packaged function "chk_ins_balance_feed" in pybalnce.pkb.
4751: -- Since this is definitely a new balance feed for a new element and balance,
4752: -- there is no chance for duplicating an existing feed.
4753: hr_utility.set_location('pyusuiet',1075);
4754: hr_balances.ins_balance_feed(
4755: p_option => 'INS_MANUAL_FEED',
4756: p_input_value_id => g_neg_earn_inpval_id,
4757: p_element_type_id => NULL,
4767:
4768: --
4769: END IF;
4770: --
4771: hr_utility.set_location('pyusuiet',1080);
4772:
4773: If p_ele_processing_type = 'R' then /* Not required for NR Elements */
4774:
4775: /*
4785: -- Since this is definitely a new balance feed for a new element and balance,
4786: -- there is no chance for duplicating an existing feed.
4787:
4788:
4789: hr_utility.set_location('pyusuiet',1084);
4790: hr_balances.ins_balance_feed(
4791: p_option => 'INS_MANUAL_FEED',
4792: p_input_value_id => g_addl_inpval_id,
4793: p_element_type_id => NULL,
4800: p_business_group => p_bg_id,
4801: p_legislation_code => NULL,
4802: p_mode => 'USER');
4803:
4804: hr_utility.set_location('pyusuiet',1085);
4805: hr_balances.ins_balance_feed(
4806: p_option => 'INS_MANUAL_FEED',
4807: p_input_value_id => gi_addl_inpval_id,
4808: p_element_type_id => NULL,
4815: p_business_group => p_bg_id,
4816: p_legislation_code => NULL,
4817: p_mode => 'USER');
4818:
4819: hr_utility.set_location('pyusuiet',1086);
4820: /*
4821: select iv.input_value_id
4822: into g_repl_inpval_id
4823: from pay_input_values_f iv
4828: -- Now, insert feed.
4829: -- Note, there is a packaged function "chk_ins_balance_feed" in pybalnce.pkb.
4830: -- Since this is definitely a new balance feed for a new element and balance,
4831: -- there is no chance for duplicating an existing feed.
4832: hr_utility.set_location('pyusuiet',1090);
4833: hr_balances.ins_balance_feed(
4834: p_option => 'INS_MANUAL_FEED',
4835: p_input_value_id => g_repl_inpval_id,
4836: p_element_type_id => NULL,
4843: p_business_group => p_bg_id,
4844: p_legislation_code => NULL,
4845: p_mode => 'USER');
4846:
4847: hr_utility.set_location('pyusuiet',1095);
4848: hr_balances.ins_balance_feed(
4849: p_option => 'INS_MANUAL_FEED',
4850: p_input_value_id => gi_repl_inpval_id,
4851: p_element_type_id => NULL,
4873: AND
4874: UPPER(p_ele_category) = 'B'
4875: ) THEN
4876:
4877: hr_utility.set_location('pyusuiet',1100);
4878: SELECT balance_type_id
4879: INTO v_earn401k_bal_type_id
4880: FROM pay_balance_types
4881: WHERE balance_name = 'Earnings 401k'
4881: WHERE balance_name = 'Earnings 401k'
4882: AND business_group_id IS NULL
4883: AND legislation_code = 'US';
4884:
4885: hr_utility.set_location('pyusuiet',1105);
4886: hr_balances.ins_balance_feed(
4887: p_option => 'INS_MANUAL_FEED',
4888: p_input_value_id => v_payval_id,
4889: p_element_type_id => NULL,
4903: -- and p_flsa_hours.
4904:
4905: IF p_ele_ot_base = 'Y' THEN
4906:
4907: hr_utility.set_location('pyusuiet',1110);
4908:
4909: begin
4910:
4911: SELECT balance_type_id
4914: WHERE balance_name = 'FLSA Earnings'
4915: AND business_group_id IS NULL
4916: AND legislation_code = 'US';
4917:
4918: hr_utility.set_location('pyusuiet',1115);
4919: hr_balances.ins_balance_feed(
4920: p_option => 'INS_MANUAL_FEED',
4921: p_input_value_id => v_payval_id,
4922: p_element_type_id => NULL,
4933: exception
4934:
4935: when NO_DATA_FOUND then
4936:
4937: hr_utility.set_location('Could not find FLSA_Earnings balance.',1120);
4938:
4939: when TOO_MANY_ROWS then
4940:
4941: hr_utility.set_location('Too many STU FLSA_Earnings balances.',1125);
4937: hr_utility.set_location('Could not find FLSA_Earnings balance.',1120);
4938:
4939: when TOO_MANY_ROWS then
4940:
4941: hr_utility.set_location('Too many STU FLSA_Earnings balances.',1125);
4942:
4943: end;
4944:
4945: END IF;
4945: END IF;
4946:
4947: IF p_flsa_hours = 'Y' THEN
4948:
4949: hr_utility.set_location('pyusuiet',1130);
4950:
4951: begin
4952:
4953:
4957: WHERE balance_name = 'FLSA Hours'
4958: AND business_group_id IS NULL
4959: AND legislation_code = 'US';
4960:
4961: hr_utility.set_location('pyusuiet',1135);
4962: SELECT input_value_id
4963: INTO v_hrs_inpval_id
4964: FROM pay_input_values_f
4965: WHERE element_type_id = v_ele_type_id
4965: WHERE element_type_id = v_ele_type_id
4966: AND business_group_id = p_bg_id
4967: AND name = 'Hours';
4968:
4969: hr_utility.set_location('pyusuiet',1140);
4970: hr_balances.ins_balance_feed(
4971: p_option => 'INS_MANUAL_FEED',
4972: p_input_value_id => v_hrs_inpval_id,
4973: p_element_type_id => NULL,
4984: exception
4985:
4986: when NO_DATA_FOUND then
4987:
4988: hr_utility.set_location('Could not find FLSA_Hours bal or Hours inpval.',1145);
4989:
4990: when TOO_MANY_ROWS then
4991:
4992: hr_utility.set_location('Too many STU FLSA_Hours bals or Hours inpvals.',1150);
4988: hr_utility.set_location('Could not find FLSA_Hours bal or Hours inpval.',1145);
4989:
4990: when TOO_MANY_ROWS then
4991:
4992: hr_utility.set_location('Too many STU FLSA_Hours bals or Hours inpvals.',1150);
4993:
4994: end;
4995:
4996: END IF;
5004: -- Insert feed from "Hours" inpval to hours bal for this ele.
5005:
5006: -- begin
5007:
5008: hr_utility.set_location('pyusuiet',1155);
5009: SELECT input_value_id
5010: INTO v_hrs_inpval_id
5011: FROM pay_input_values_f
5012: WHERE element_type_id = v_ele_type_id
5012: WHERE element_type_id = v_ele_type_id
5013: AND business_group_id = p_bg_id
5014: AND name = 'Hours';
5015:
5016: hr_utility.set_location('pyusuiet',1160);
5017: hr_balances.ins_balance_feed(
5018: p_option => 'INS_MANUAL_FEED',
5019: p_input_value_id => v_hrs_inpval_id,
5020: p_element_type_id => NULL,
5032: exception
5033:
5034: when NO_DATA_FOUND then
5035:
5036: hr_utility.set_location('Could not find Hours inpval.',1170);
5037:
5038: when TOO_MANY_ROWS then
5039:
5040: hr_utility.set_location('Too many Hours inpvals.',1171);
5036: hr_utility.set_location('Could not find Hours inpval.',1170);
5037:
5038: when TOO_MANY_ROWS then
5039:
5040: hr_utility.set_location('Too many Hours inpvals.',1171);
5041:
5042: end;
5043: */
5044:
5057: where balance_name = 'Regular Hours Worked'
5058: and business_group_id is null
5059: and legislation_code = 'US';
5060:
5061: hr_utility.set_location('pyusuiet',1175);
5062: hr_balances.ins_balance_feed(
5063: p_option => 'INS_MANUAL_FEED',
5064: p_input_value_id => v_hrs_inpval_id,
5065: p_element_type_id => NULL,
5083: exception
5084:
5085: when NO_DATA_FOUND then
5086:
5087: hr_utility.set_location('Could not find Reg Hours Worked bal.',1180);
5088:
5089: when TOO_MANY_ROWS then
5090:
5091: hr_utility.set_location('Too many Reg Hours Worked bals.',1185);
5087: hr_utility.set_location('Could not find Reg Hours Worked bal.',1180);
5088:
5089: when TOO_MANY_ROWS then
5090:
5091: hr_utility.set_location('Too many Reg Hours Worked bals.',1185);
5092:
5093: end;
5094: */
5095:
5118: where upper(balance_name ) = 'REGULAR HOURS WORKED'
5119: and business_group_id is null
5120: and legislation_code = 'US';
5121: */
5122: hr_utility.set_location('pyusuiet',1190);
5123: hr_balances.ins_balance_feed(
5124: p_option => 'INS_MANUAL_FEED',
5125: p_input_value_id => g_reduce_hrs_inpval_id,
5126: p_element_type_id => NULL,
5136:
5137: /*
5138: exception
5139: when NO_DATA_FOUND then
5140: hr_utility.set_location('Could not find Regular Hours Worked bal.',1195);
5141: when TOO_MANY_ROWS then
5142: hr_utility.set_location('Too many Regular Hours Worked bals.',1200);
5143: end;
5144: */
5138: exception
5139: when NO_DATA_FOUND then
5140: hr_utility.set_location('Could not find Regular Hours Worked bal.',1195);
5141: when TOO_MANY_ROWS then
5142: hr_utility.set_location('Too many Regular Hours Worked bals.',1200);
5143: end;
5144: */
5145:
5146: -- begin
5153: where balance_name = 'Regular Salary Hours'
5154: and business_group_id is null
5155: and legislation_code = 'US';
5156:
5157: hr_utility.set_location('pyusuiet',1205);
5158: hr_balances.ins_balance_feed(
5159: p_option => 'INS_MANUAL_FEED',
5160: p_input_value_id => g_reduce_sal_hrs_inpval_id,
5161: p_element_type_id => NULL,
5171:
5172: /*
5173: exception
5174: when NO_DATA_FOUND then
5175: hr_utility.set_location('Could not find Regular Salary Hours bal.',170);
5176: when TOO_MANY_ROWS then
5177: hr_utility.set_location('Too many Regular Salary Hours bals.',170);
5178: end;
5179: */
5173: exception
5174: when NO_DATA_FOUND then
5175: hr_utility.set_location('Could not find Regular Salary Hours bal.',170);
5176: when TOO_MANY_ROWS then
5177: hr_utility.set_location('Too many Regular Salary Hours bals.',170);
5178: end;
5179: */
5180:
5181: -- begin
5188: where balance_name = 'Regular Wages Hours'
5189: and business_group_id is null
5190: and legislation_code = 'US';
5191:
5192: hr_utility.set_location('pyusuiet',1210);
5193: hr_balances.ins_balance_feed(
5194: p_option => 'INS_MANUAL_FEED',
5195: p_input_value_id => g_reduce_wag_hrs_inpval_id,
5196: p_element_type_id => NULL,
5206:
5207: /*
5208: exception
5209: when NO_DATA_FOUND then
5210: hr_utility.set_location('Could not find Regular Wages Hours bal.',170);
5211: when TOO_MANY_ROWS then
5212: hr_utility.set_location('Too many Regular Wages Hours bals.',170);
5213: end;
5214: */
5208: exception
5209: when NO_DATA_FOUND then
5210: hr_utility.set_location('Could not find Regular Wages Hours bal.',170);
5211: when TOO_MANY_ROWS then
5212: hr_utility.set_location('Too many Regular Wages Hours bals.',170);
5213: end;
5214: */
5215:
5216: -- Create feeds to all bals fed by RegSal and Wages pay values.
5256:
5257: recinfo chk_for_lock%ROWTYPE;
5258:
5259: BEGIN
5260: hr_utility.set_location('pyusuiet',1220);
5261: OPEN chk_for_lock;
5262: FETCH chk_for_lock INTO recinfo;
5263: CLOSE chk_for_lock;
5264:
5263: CLOSE chk_for_lock;
5264:
5265: -- Note: Not checking eff dates.
5266:
5267: hr_utility.set_location('pyusuiet',1225);
5268: IF ( ( (recinfo.element_type_id = p_ele_type_id)
5269: OR (recinfo.element_type_id IS NULL AND p_ele_type_id IS NULL))
5270: -- AND ( (recinfo.effective_start_date = fnd_date.canonical_to_date(p_ele_eff_start_date))
5271: -- OR (recinfo.effective_start_date IS NULL
5293: AND ( (recinfo.standard_link_flag = p_ele_standard_link)
5294: OR (recinfo.standard_link_flag IS NULL
5295: AND p_ele_standard_link IS NULL)))
5296: THEN
5297: hr_utility.set_location('pyusuiet',1230);
5298: RETURN;
5299: ELSE
5300: hr_utility.set_location('pyusuiet',151);
5301: hr_utility.set_message(801,'HR_51026_HR_LOCKED_OBJ');
5296: THEN
5297: hr_utility.set_location('pyusuiet',1230);
5298: RETURN;
5299: ELSE
5300: hr_utility.set_location('pyusuiet',151);
5301: hr_utility.set_message(801,'HR_51026_HR_LOCKED_OBJ');
5302: hr_utility.raise_error;
5303:
5304: -- FND_MESSAGE.SET_NAME('FND',
5297: hr_utility.set_location('pyusuiet',1230);
5298: RETURN;
5299: ELSE
5300: hr_utility.set_location('pyusuiet',151);
5301: hr_utility.set_message(801,'HR_51026_HR_LOCKED_OBJ');
5302: hr_utility.raise_error;
5303:
5304: -- FND_MESSAGE.SET_NAME('FND',
5305: -- 'FORM_RECORD_CHANGED_BY_ANOTHER_USER');
5298: RETURN;
5299: ELSE
5300: hr_utility.set_location('pyusuiet',151);
5301: hr_utility.set_message(801,'HR_51026_HR_LOCKED_OBJ');
5302: hr_utility.raise_error;
5303:
5304: -- FND_MESSAGE.SET_NAME('FND',
5305: -- 'FORM_RECORD_CHANGED_BY_ANOTHER_USER');
5306: -- APP_EXCEPTION.RAISE_EXCEPTION;
5371: OPEN get_formulae;
5372: LOOP
5373: FETCH get_formulae INTO v_ff_id;
5374: EXIT WHEN get_formulae%NOTFOUND;
5375: hr_utility.set_location('pyusuidt',1235);
5376:
5377: DELETE FROM ff_formulas_f
5378: WHERE formula_id = v_ff_id;
5379:
5397:
5398: END LOOP;
5399: CLOSE get_formulae;
5400:
5401: hr_utility.set_location('pyusuiet',1240);
5402:
5403: begin
5404:
5405: SELECT status_processing_rule_id
5406: INTO v_spr_id
5407: FROM pay_status_processing_rules_f
5408: WHERE element_type_id = p_ele_type_id;
5409:
5410: hr_utility.set_location('pyusuiet',1245);
5411: hr_elements.del_status_processing_rules(
5412: p_element_type_id => p_ele_type_id,
5413: p_delete_mode => v_del_mode,
5414: p_val_session_date => v_del_sess_date,
5425: OPEN get_inpvals;
5426: LOOP
5427: FETCH get_inpvals INTO v_inpval_id;
5428: EXIT WHEN get_inpvals%NOTFOUND;
5429: hr_utility.set_location('pyusuiet',1250);
5430: DELETE FROM pay_formula_result_rules_f
5431: WHERE input_value_id = v_inpval_id;
5432: END LOOP;
5433: CLOSE get_inpvals;
5462: exception when NO_DATA_FOUND then
5463: null;
5464: end;
5465:
5466: hr_utility.set_location('pyusuiet',1255);
5467: hr_elements.chk_del_element_type (
5468: p_mode => v_del_mode,
5469: p_element_type_id => p_ele_type_id,
5470: p_processing_priority => p_ele_priority,
5471: p_session_date => v_del_sess_date,
5472: p_val_start_date => v_del_val_start,
5473: p_val_end_date => v_del_val_end);
5474:
5475: hr_utility.set_location('pyusuiet',1256);
5476: hr_elements.del_3p_element_type (
5477: p_element_type_id => p_ele_type_id,
5478: p_delete_mode => v_del_mode,
5479: p_val_session_date => v_del_sess_date,
5481: p_val_end_date => v_del_val_end,
5482: p_startup_mode => v_startup_mode);
5483:
5484: -- Delete element type record:
5485: hr_utility.set_location('pyusuiet',1257);
5486: delete from PAY_ELEMENT_TYPES_F
5487: where element_type_id = p_ele_type_id;
5488:
5489: --
5494:
5495: -- Primary Balance
5496: IF p_ele_info_10 IS NOT NULL THEN
5497:
5498: hr_utility.set_location('pyusuiet',1260);
5499: hr_balances.del_balance_type_cascade (
5500: p_balance_type_id => fnd_number.canonical_to_number(p_ele_info_10),
5501: p_legislation_code => g_template_leg_code,
5502: p_mode => v_del_mode);
5500: p_balance_type_id => fnd_number.canonical_to_number(p_ele_info_10),
5501: p_legislation_code => g_template_leg_code,
5502: p_mode => v_del_mode);
5503:
5504: hr_utility.set_location('pyusuiet',1261);
5505: delete from PAY_BALANCE_TYPES
5506: where balance_type_id = fnd_number.canonical_to_number(p_ele_info_10);
5507:
5508: END IF;
5509:
5510: -- Hours Balance
5511: IF p_ele_info_12 IS NOT NULL THEN
5512:
5513: hr_utility.set_location('pyusuiet', 1262);
5514: hr_balances.del_balance_type_cascade (
5515: p_balance_type_id => fnd_number.canonical_to_number(p_ele_info_12),
5516: p_legislation_code => g_template_leg_code,
5517: p_mode => v_del_mode);
5515: p_balance_type_id => fnd_number.canonical_to_number(p_ele_info_12),
5516: p_legislation_code => g_template_leg_code,
5517: p_mode => v_del_mode);
5518:
5519: hr_utility.set_location('pyusuiet', 1263);
5520: DELETE FROM pay_balance_types
5521: WHERE balance_type_id = fnd_number.canonical_to_number(p_ele_info_12);
5522:
5523: END IF;
5523: END IF;
5524:
5525: v_negearn_bal_name := p_ele_name || ' Neg Earnings';
5526: v_negearn_bal_name := SUBSTR(v_negearn_bal_name, 1, 80);
5527: hr_utility.set_location('pyusuiet',162);
5528:
5529: begin
5530:
5531: hr_utility.set_location('pyusuiet',1264);
5527: hr_utility.set_location('pyusuiet',162);
5528:
5529: begin
5530:
5531: hr_utility.set_location('pyusuiet',1264);
5532: --
5533: -- 633443, added missing bussiness_group_id condition.mlisieck 28/02/98.
5534: --
5535: -- Bug 3349586 - removed 'upper' to improve performance.
5539: from pay_balance_types
5540: where balance_name = v_negearn_bal_name and
5541: business_group_id + 0 = p_business_group_id ;
5542:
5543: hr_utility.set_location('pyusuiet',164);
5544: hr_balances.del_balance_type_cascade (
5545: p_balance_type_id => v_negearn_bal_type_id,
5546: p_legislation_code => g_template_leg_code,
5547: p_mode => v_del_mode);
5545: p_balance_type_id => v_negearn_bal_type_id,
5546: p_legislation_code => g_template_leg_code,
5547: p_mode => v_del_mode);
5548:
5549: hr_utility.set_location('pyusuiet',1265);
5550: delete from PAY_BALANCE_TYPES
5551: where balance_type_id = v_negearn_bal_type_id;
5552:
5553: exception when NO_DATA_FOUND then
5555: end;
5556:
5557: v_addl_bal_name := p_ele_name || ' Additional';
5558: v_addl_bal_name := SUBSTR(v_addl_bal_name, 1, 80);
5559: hr_utility.set_location('pyusuiet',1266);
5560:
5561: begin
5562: --
5563: -- 633443, added missing bussiness_group_id condition.mlisieck 28/02/98.
5564: --
5565: -- Bug 3349586 - removed 'upper' to improve performance.
5566: --
5567:
5568: hr_utility.set_location('pyusuiet',1267);
5569: select balance_type_id
5570: into v_addl_bal_type_id
5571: from pay_balance_types
5572: where balance_name = v_addl_bal_name and
5571: from pay_balance_types
5572: where balance_name = v_addl_bal_name and
5573: business_group_id + 0 = p_business_group_id ;
5574:
5575: hr_utility.set_location('pyusuiet',1268);
5576: hr_balances.del_balance_type_cascade (
5577: p_balance_type_id => v_addl_bal_type_id,
5578: p_legislation_code => g_template_leg_code,
5579: p_mode => v_del_mode);
5577: p_balance_type_id => v_addl_bal_type_id,
5578: p_legislation_code => g_template_leg_code,
5579: p_mode => v_del_mode);
5580:
5581: hr_utility.set_location('pyusuiet',1268);
5582: delete from PAY_BALANCE_TYPES
5583: where balance_type_id = v_addl_bal_type_id;
5584:
5585: exception when NO_DATA_FOUND then
5587: end;
5588:
5589: v_repl_bal_name := p_ele_name || ' Replacement';
5590: v_repl_bal_name := SUBSTR(v_repl_bal_name, 1, 80);
5591: hr_utility.set_location('pyusuiet',1269);
5592:
5593: begin
5594:
5595: --
5597: --
5598: -- Bug 3349586 - removed 'upper' to improve performance.
5599: --
5600:
5601: hr_utility.set_location('pyusuiet',1270);
5602: select balance_type_id
5603: into v_repl_bal_type_id
5604: from pay_balance_types
5605: where balance_name = v_repl_bal_name and
5604: from pay_balance_types
5605: where balance_name = v_repl_bal_name and
5606: business_group_id + 0 = p_business_group_id ;
5607:
5608: hr_utility.set_location('pyusuiet',1275);
5609: hr_balances.del_balance_type_cascade (
5610: p_balance_type_id => v_repl_bal_type_id,
5611: p_legislation_code => g_template_leg_code,
5612: p_mode => v_del_mode);
5610: p_balance_type_id => v_repl_bal_type_id,
5611: p_legislation_code => g_template_leg_code,
5612: p_mode => v_del_mode);
5613:
5614: hr_utility.set_location('pyusuiet',1280);
5615: delete from PAY_BALANCE_TYPES
5616: where balance_type_id = v_repl_bal_type_id;
5617:
5618: exception when NO_DATA_FOUND then
5621:
5622: --
5623: -- Delete Shadow element...
5624: --
5625: hr_utility.set_location('pyusuiet',1285);
5626: hr_elements.chk_del_element_type (
5627: p_mode => v_del_mode,
5628: p_element_type_id => v_shadow_eletype_id,
5629: p_processing_priority => v_shadow_ele_priority,
5630: p_session_date => v_del_sess_date,
5631: p_val_start_date => v_del_val_start,
5632: p_val_end_date => v_del_val_end);
5633:
5634: hr_utility.set_location('pyusuiet',1290);
5635: hr_elements.del_3p_element_type (
5636: p_element_type_id => v_shadow_eletype_id,
5637: p_delete_mode => v_del_mode,
5638: p_val_session_date => v_del_sess_date,
5639: p_val_start_date => v_del_val_start,
5640: p_val_end_date => v_del_val_end,
5641: p_startup_mode => v_startup_mode);
5642:
5643: hr_utility.set_location('pyusuiet',1295);
5644: delete from PAY_ELEMENT_TYPES_F
5645: where element_type_id = v_shadow_eletype_id;
5646:
5647: --
5646:
5647: --
5648: -- Delete Special Inputs element...
5649: --
5650: hr_utility.set_location('pyusuiet',1300);
5651: hr_elements.chk_del_element_type (
5652: p_mode => v_del_mode,
5653: p_element_type_id => v_inputs_eletype_id,
5654: p_processing_priority => v_inputs_ele_priority,
5655: p_session_date => v_del_sess_date,
5656: p_val_start_date => v_del_val_start,
5657: p_val_end_date => v_del_val_end);
5658:
5659: hr_utility.set_location('pyusuiet',1305);
5660: hr_elements.del_3p_element_type (
5661: p_element_type_id => v_inputs_eletype_id,
5662: p_delete_mode => v_del_mode,
5663: p_val_session_date => v_del_sess_date,
5664: p_val_start_date => v_del_val_start,
5665: p_val_end_date => v_del_val_end,
5666: p_startup_mode => v_startup_mode);
5667:
5668: hr_utility.set_location('pyusuiet',1310);
5669: delete from PAY_ELEMENT_TYPES_F
5670: where element_type_id = v_inputs_eletype_id;
5671: --
5672: EXCEPTION