[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
415: -- Unless this function actually has to do anything, we can make call
416: -- to pay_db_pay_setup from do_insertions.
417: --
418:
419: hr_utility.set_location('pyusuiet',1);
420: IF p_ele_processing_type = 'N' THEN
421: v_mult_entries_allowed := 'Y';
422: ELSE
423: v_mult_entries_allowed := 'N';
430: --
431: -- insert check for ele type existence here...return id if it does!
432: --
433:
434: hr_utility.set_location('pyusuiet',3);
435: v_eletype_id := pay_db_pay_setup.create_element(
436: p_element_name => p_ele_name,
437: p_description => p_ele_description,
438: p_classification_name => p_ele_class,
488: v_formula_name VARCHAR2(80);
489:
490: BEGIN
491:
492: hr_utility.set_location('hr_user_init_earn.ins_formula',10);
493:
494: -- Bug 3768726 - With this, the upper clause will be removed from the first condition in query.
495:
496: v_formula_name := UPPER(p_amt_rule);
509: AND FF.effective_end_date;
510: --
511: -- Replace element name placeholders with current element name:
512:
513: hr_utility.set_location('hr_user_init_earn.ins_formula',15);
514: v_ele_name := REPLACE(LTRIM(RTRIM(UPPER(p_ff_ele_name))),' ','_');
515: --
516: v_ele_formula_text := REPLACE( v_skeleton_formula_text,
517: '
521: --
522: -- Insert the new formula into current business goup:
523: -- Get new id
524:
525: hr_utility.set_location('hr_user_init_earn.ins_formula',30);
526: SELECT ff_formulas_s.nextval
527: INTO v_formula_id
528: FROM sys.dual;
529: --
526: SELECT ff_formulas_s.nextval
527: INTO v_formula_id
528: FROM sys.dual;
529: --
530: hr_utility.set_location('hr_user_init_earn.ins_formula',40);
531: INSERT INTO ff_formulas_f (
532: FORMULA_ID,
533: EFFECTIVE_START_DATE,
534: EFFECTIVE_END_DATE,
657: 'GROSS_UP_NONRECUR_V2') THEN
658: --
659: IF UPPER(p_ele_class_name) = 'EARNINGS' THEN
660: v_ele_info_cat := 'US_EARNINGS';
661: hr_utility.set_location('pyusuiet',45);
662: UPDATE pay_element_types_f
663: SET element_information_category = v_ele_info_cat,
664: element_information1 = p_ele_cat,
665: element_information8 = p_include_in_ot,
668: element_information12 = p_hrs_baltype_id
669: WHERE element_type_id = p_ele_id
670: AND business_group_id = p_bg_id;
671: --
672: hr_utility.set_location('pyusuiet',50);
673: UPDATE pay_element_types_f
674: SET element_information_category = v_ele_info_cat,
675: element_information1 = p_ele_cat,
676: element_information8 = p_include_in_ot
679: --
680:
681: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
682:
683: hr_utility.set_location('pyusuiet',55);
684: UPDATE pay_element_types_f
685: SET element_information_category = v_ele_info_cat,
686: element_information1 = p_ele_cat,
687: element_information8 = p_include_in_ot
693: --
694: ELSIF UPPER(p_ele_class_name) = 'SUPPLEMENTAL EARNINGS' THEN
695:
696: v_ele_info_cat := 'US_SUPPLEMENTAL EARNINGS';
697: hr_utility.set_location('pyusuiet',60);
698: UPDATE pay_element_types_f
699: SET element_information_category = v_ele_info_cat,
700: element_information1 = p_ele_cat,
701: element_information8 = p_include_in_ot,
704: element_information12 = p_hrs_baltype_id
705: WHERE element_type_id = p_ele_id
706: AND business_group_id = p_bg_id;
707: --
708: hr_utility.set_location('pyusuiet',65);
709: UPDATE pay_element_types_f
710: SET element_information_category = v_ele_info_cat,
711: element_information1 = p_ele_cat,
712: element_information8 = p_include_in_ot
714: AND business_group_id = p_bg_id;
715: --
716: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
717:
718: hr_utility.set_location('pyusuiet',70);
719: UPDATE pay_element_types_f
720: SET element_information_category = v_ele_info_cat,
721: element_information1 = p_ele_cat,
722: element_information8 = p_include_in_ot
727: --
728: ELSIF UPPER(p_ele_class_name) = 'IMPUTED EARNINGS' THEN
729:
730: v_ele_info_cat := 'US_IMPUTED EARNINGS';
731: hr_utility.set_location('pyusuiet',75);
732: UPDATE pay_element_types_f
733: SET element_information_category = v_ele_info_cat,
734: element_information1 = p_ele_cat,
735: element_information9 = v_mix_category,
736: element_information12 = p_hrs_baltype_id
737: WHERE element_type_id = p_ele_id
738: AND business_group_id = p_bg_id;
739: --
740: hr_utility.set_location('pyusuiet',80);
741: UPDATE pay_element_types_f
742: SET element_information_category = v_ele_info_cat,
743: element_information1 = p_ele_cat
744: WHERE element_type_id = p_shadow_ele_id
746: --
747:
748: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
749:
750: hr_utility.set_location('pyusuiet',85);
751: UPDATE pay_element_types_f
752: SET element_information_category = v_ele_info_cat,
753: element_information1 = p_ele_cat
754: WHERE element_type_id = p_inputs_ele_id
759: --
760: ELSIF UPPER(p_ele_class_name) = 'NON-PAYROLL PAYMENTS' THEN
761:
762: v_ele_info_cat := 'US_NON-PAYROLL PAYMENTS';
763: hr_utility.set_location('pyusuiet',90);
764: UPDATE pay_element_types_f
765: SET element_information_category = v_ele_info_cat,
766: element_information1 = p_ele_cat,
767: element_information9 = v_mix_category
767: element_information9 = v_mix_category
768: WHERE element_type_id = p_ele_id
769: AND business_group_id = p_bg_id;
770: --
771: hr_utility.set_location('pyusuiet',95);
772: UPDATE pay_element_types_f
773: SET element_information_category = v_ele_info_cat,
774: element_information1 = p_ele_cat
775: WHERE element_type_id = p_shadow_ele_id
776: AND business_group_id = p_bg_id;
777: --
778: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
779:
780: hr_utility.set_location('pyusuiet',100);
781: UPDATE pay_element_types_f
782: SET element_information_category = v_ele_info_cat,
783: element_information1 = p_ele_cat
784: WHERE element_type_id = p_inputs_ele_id
791:
792: --
793: ELSE
794: -- Ele is a grossup ele, Information classification, just set mix flag.
795: hr_utility.set_location('pyusuiet',105);
796: UPDATE pay_element_types_f
797: SET element_information9 = v_mix_category
798: WHERE element_type_id = p_ele_id
799: AND business_group_id = p_bg_id;
815: -- Insert input vals;
816: -- Gather Hours By Rate Element Details
817: -- Insert formula result rules;
818: --
819: hr_utility.set_location('pyusuiet',110);
820: v_calc_rule_formula_id := ins_formula (
821: p_ff_ele_name => p_ele_name,
822: p_ff_suffix => '_HOURS_X_RATE',
823: p_ff_desc => 'Hours times Rate calculation for recurring earnings.',
823: p_ff_desc => 'Hours times Rate calculation for recurring earnings.',
824: p_ff_bg_id => p_bg_id,
825: p_amt_rule => UPPER(p_calc_ff_name));
826: --
827: hr_utility.set_location('pyusuiet',115);
828:
829: --
830: -- check for existence...return id...
831: --
843: p_processing_rule => v_proc_rule);
844:
845: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
846: -- Creating "Hours Worked" input val.
847: hr_utility.set_location('pyusuiet',120);
848: g_inpval_disp_seq := g_inpval_disp_seq + 1;
849: v_inpval_name := 'Hours';
850: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
851: v_gen_dbi := 'Y';
860: p_generate_db_item_flag => v_gen_dbi,
861: p_display_sequence => g_inpval_disp_seq,
862: p_business_group_name => p_bg_name);
863:
864: hr_utility.set_location('pyusuiet',125);
865: hr_input_values.chk_input_value(
866: p_element_type_id => p_ele_id,
867: p_legislation_code => g_template_leg_code,
868: p_val_start_date => p_eff_start_date,
884: p_formula_id => NULL,
885: p_generate_db_items_flag => v_gen_dbi,
886: p_warning_or_error => NULL);
887:
888: hr_utility.set_location('pyusuiet',130);
889: hr_input_values.ins_3p_input_values(
890: p_val_start_date => p_eff_start_date,
891: p_val_end_date => NULL,
892: p_element_type_id => p_ele_id,
905: p_startup_mode => NULL);
906: -- (HERE) Done inserting one "Hours" input value.
907: -- Now insert "Rate".
908: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
909: hr_utility.set_location('pyusuiet',135);
910: g_inpval_disp_seq := g_inpval_disp_seq + 1;
911: v_inpval_name := 'Rate';
912: v_inpval_uom := 'N'; -- Check that this can go out to 5 dec.
913: v_gen_dbi := 'Y';
919: p_generate_db_item_flag => v_gen_dbi,
920: p_display_sequence => g_inpval_disp_seq,
921: p_business_group_name => p_bg_name);
922:
923: hr_utility.set_location('pyusuiet',140);
924: hr_input_values.chk_input_value(
925: p_element_type_id => p_ele_id,
926: p_legislation_code => g_template_leg_code,
927: p_val_start_date => p_eff_start_date,
943: p_formula_id => NULL,
944: p_generate_db_items_flag => v_gen_dbi,
945: p_warning_or_error => NULL);
946:
947: hr_utility.set_location('pyusuiet',145);
948: hr_input_values.ins_3p_input_values(
949: p_val_start_date => p_eff_start_date,
950: p_val_end_date => NULL,
951: p_element_type_id => p_ele_id,
964: p_startup_mode => NULL);
965: -- (HERE) Done inserting one "Rate" input value.
966: -- Now insert "Rate Code".
967: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
968: hr_utility.set_location('pyusuiet',150);
969: g_inpval_disp_seq := g_inpval_disp_seq + 1;
970: v_inpval_name := 'Rate Code';
971: v_inpval_uom := 'C';
972: v_gen_dbi := 'N';
978: p_generate_db_item_flag => v_gen_dbi,
979: p_display_sequence => g_inpval_disp_seq,
980: p_business_group_name => p_bg_name);
981:
982: hr_utility.set_location('pyusuiet',155);
983: hr_input_values.chk_input_value(
984: p_element_type_id => p_ele_id,
985: p_legislation_code => g_template_leg_code,
986: p_val_start_date => p_eff_start_date,
1002: p_formula_id => NULL,
1003: p_generate_db_items_flag => v_gen_dbi,
1004: p_warning_or_error => NULL);
1005:
1006: hr_utility.set_location('pyusuiet',160);
1007: hr_input_values.ins_3p_input_values(
1008: p_val_start_date => p_eff_start_date,
1009: p_val_end_date => NULL,
1010: p_element_type_id => p_ele_id,
1024: -- (HERE) Done inserting "Rate Code" input value.
1025:
1026: -- Now insert "Shift".
1027: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1028: hr_utility.set_location('pyusuiet',165);
1029:
1030: -- Rmonge 01-FEB-2002
1031: -- Adding the following if condition to create Shift Input value.
1032: -- The Shift input values is only created if the p_ele_cat value
1031: -- Adding the following if condition to create Shift Input value.
1032: -- The Shift input values is only created if the p_ele_cat value
1033: -- is 'S'. S means Shift Category.
1034:
1035: hr_utility.trace('p_ele_cat is '||p_ele_cat);
1036:
1037: IF p_ele_cat = 'S' THEN
1038:
1039: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1048: p_generate_db_item_flag => v_gen_dbi,
1049: p_display_sequence => g_inpval_disp_seq,
1050: p_business_group_name => p_bg_name);
1051:
1052: hr_utility.set_location('pyusuiet',170);
1053: hr_input_values.chk_input_value(
1054: p_element_type_id => p_ele_id,
1055: p_legislation_code => g_template_leg_code,
1056: p_val_start_date => p_eff_start_date,
1072: p_formula_id => NULL,
1073: p_generate_db_items_flag => v_gen_dbi,
1074: p_warning_or_error => NULL);
1075:
1076: hr_utility.set_location('pyusuiet',175);
1077: hr_input_values.ins_3p_input_values(
1078: p_val_start_date => p_eff_start_date,
1079: p_val_end_date => NULL,
1080: p_element_type_id => p_ele_id,
1100: v_inpval_name := 'Date Earned';
1101: v_inpval_uom := 'Date (DD-MON-YYYY)';
1102: v_gen_dbi := 'N';
1103:
1104: hr_utility.set_location('pyusuiet',180);
1105: v_inpval_id := pay_db_pay_setup.create_input_value (
1106: p_element_name => p_ele_name,
1107: p_name => v_inpval_name,
1108: p_uom_code => v_inpval_uom,
1110: p_generate_db_item_flag => v_gen_dbi,
1111: p_display_sequence => g_inpval_disp_seq,
1112: p_business_group_name => p_bg_name);
1113:
1114: hr_utility.set_location('pyusuiet',185);
1115: hr_input_values.chk_input_value(
1116: p_element_type_id => p_ele_id,
1117: p_legislation_code => g_template_leg_code,
1118: p_val_start_date => p_eff_start_date,
1134: p_formula_id => NULL,
1135: p_generate_db_items_flag => v_gen_dbi,
1136: p_warning_or_error => NULL);
1137:
1138: hr_utility.set_location('pyusuiet',190);
1139: hr_input_values.ins_3p_input_values(
1140: p_val_start_date => p_eff_start_date,
1141: p_val_end_date => NULL,
1142: p_element_type_id => p_ele_id,
1165: -- Now insert appropriate formula_result_rules for "HRS X RATE"
1166: -- REMEMBER: Testing using 'HEP_TEST_01' formula.
1167:
1168: -- Gather Hours By Rate Element Details
1169: hr_utility.trace('Get Hours By Rate Element Id');
1170: hr_utility.set_location('pyusuiet',195);
1171: select element_type_id
1172: into v_hbyr_ele_type_id
1173: from pay_element_types_f
1166: -- REMEMBER: Testing using 'HEP_TEST_01' formula.
1167:
1168: -- Gather Hours By Rate Element Details
1169: hr_utility.trace('Get Hours By Rate Element Id');
1170: hr_utility.set_location('pyusuiet',195);
1171: select element_type_id
1172: into v_hbyr_ele_type_id
1173: from pay_element_types_f
1174: where element_name = 'Hours by Rate'
1175: and legislation_code = g_template_leg_code
1176: and sysdate between effective_start_date
1177: and effective_end_date;
1178:
1179: hr_utility.trace('Get Hours By Rate Element Inpval Id');
1180: hr_utility.set_location('pyusuiet',200);
1181: select input_value_id
1182: into v_hbyr_ele_inpval_id
1183: from pay_input_values_f
1176: and sysdate between effective_start_date
1177: and effective_end_date;
1178:
1179: hr_utility.trace('Get Hours By Rate Element Inpval Id');
1180: hr_utility.set_location('pyusuiet',200);
1181: select input_value_id
1182: into v_hbyr_ele_inpval_id
1183: from pay_input_values_f
1184: where element_type_id = v_hbyr_ele_type_id
1185: and name = 'Element Type Id'
1186: and sysdate between effective_start_date
1187: and effective_end_date;
1188:
1189: hr_utility.trace('Get Hours By Rate Rate Inpval Id');
1190: hr_utility.set_location('pyusuiet',205);
1191: select input_value_id
1192: into v_hbyr_rate_inpval_id
1193: from pay_input_values_f
1186: and sysdate between effective_start_date
1187: and effective_end_date;
1188:
1189: hr_utility.trace('Get Hours By Rate Rate Inpval Id');
1190: hr_utility.set_location('pyusuiet',205);
1191: select input_value_id
1192: into v_hbyr_rate_inpval_id
1193: from pay_input_values_f
1194: where element_type_id = v_hbyr_ele_type_id
1195: and name = 'Rate'
1196: and sysdate between effective_start_date
1197: and effective_end_date;
1198:
1199: hr_utility.trace('Get Hours By Rate Hours Inpval Id');
1200: hr_utility.set_location('pyusuiet',210);
1201: select input_value_id
1202: into v_hbyr_hours_inpval_id
1203: from pay_input_values_f
1196: and sysdate between effective_start_date
1197: and effective_end_date;
1198:
1199: hr_utility.trace('Get Hours By Rate Hours Inpval Id');
1200: hr_utility.set_location('pyusuiet',210);
1201: select input_value_id
1202: into v_hbyr_hours_inpval_id
1203: from pay_input_values_f
1204: where element_type_id = v_hbyr_ele_type_id
1206: and sysdate between effective_start_date
1207: and effective_end_date;
1208:
1209:
1210: hr_utility.set_location('pyusuiet',215);
1211: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1212: p_business_group_id => p_bg_id,
1213: p_legislation_code => NULL,
1214: p_legislation_subgroup => g_template_leg_subgroup,
1221: p_result_name => 'TEMPLATE_EARNING',
1222: p_result_rule_type => 'D',
1223: p_severity_level => NULL);
1224: --
1225: hr_utility.set_location('pyusuiet',220);
1226: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1227: p_business_group_id => p_bg_id,
1228: p_legislation_code => NULL,
1229: p_legislation_subgroup => g_template_leg_subgroup,
1236: p_result_name => 'MESG',
1237: p_result_rule_type => 'M',
1238: p_severity_level => 'W');
1239: --
1240: hr_utility.set_location('pyusuiet',225);
1241: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1242: p_business_group_id => p_bg_id,
1243: p_legislation_code => NULL,
1244: p_legislation_subgroup => g_template_leg_subgroup,
1250: p_result_rule_type => 'I',
1251: p_severity_level => NULL,
1252: p_element_type_id => v_hbyr_ele_type_id);
1253:
1254: hr_utility.set_location('pyusuiet',230);
1255: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1256: p_business_group_id => p_bg_id,
1257: p_legislation_code => NULL,
1258: p_legislation_subgroup => g_template_leg_subgroup,
1264: p_result_rule_type => 'I',
1265: p_severity_level => NULL,
1266: p_element_type_id => v_hbyr_ele_type_id);
1267:
1268: hr_utility.set_location('pyusuiet',235);
1269: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1270: p_business_group_id => p_bg_id,
1271: p_legislation_code => NULL,
1272: p_legislation_subgroup => g_template_leg_subgroup,
1280: p_element_type_id => v_hbyr_ele_type_id);
1281:
1282: IF p_ele_proc_type = 'R' THEN
1283: --
1284: hr_utility.set_location('pyusuiet',240);
1285: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1286: p_business_group_id => p_bg_id,
1287: p_legislation_code => NULL,
1288: p_legislation_subgroup => g_template_leg_subgroup,
1299: --
1300: ELSIF UPPER(p_calc_ff_name) IN ('HOURS_X_RATE_MULTIPLE_RECUR_V2',
1301: 'HOURS_X_RATE_MULTIPLE_NONRECUR_V2') THEN
1302: --
1303: hr_utility.set_location('pyusuiet',245);
1304: v_calc_rule_formula_id := ins_formula (
1305: p_ff_ele_name => p_ele_name,
1306: p_ff_suffix => '_HOURS_X_RATE_MULT',
1307: p_ff_desc => 'Hours * Rate * Multiple calculation for recurring earnings.',
1307: p_ff_desc => 'Hours * Rate * Multiple calculation for recurring earnings.',
1308: p_ff_bg_id => p_bg_id,
1309: p_amt_rule => UPPER(p_calc_ff_name));
1310: --
1311: hr_utility.set_location('pyusuiet',250);
1312: v_stat_proc_rule_id :=
1313: pay_formula_results.ins_stat_proc_rule (
1314: p_business_group_id => p_bg_id,
1315: p_legislation_code => NULL,
1323:
1324: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1325: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1326: -- Creating "Hours Worked" input val.
1327: hr_utility.set_location('pyusuiet',255);
1328: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1329: v_inpval_name := 'Hours';
1330: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
1331: v_gen_dbi := 'Y';
1337: p_generate_db_item_flag => v_gen_dbi,
1338: p_display_sequence => g_inpval_disp_seq,
1339: p_business_group_name => p_bg_name);
1340:
1341: hr_utility.set_location('pyusuiet',260);
1342: hr_input_values.chk_input_value(
1343: p_element_type_id => p_ele_id,
1344: p_legislation_code => g_template_leg_code,
1345: p_val_start_date => p_eff_start_date,
1361: p_formula_id => NULL,
1362: p_generate_db_items_flag => v_gen_dbi,
1363: p_warning_or_error => NULL);
1364:
1365: hr_utility.set_location('pyusuiet',265);
1366: hr_input_values.ins_3p_input_values(
1367: p_val_start_date => p_eff_start_date,
1368: p_val_end_date => NULL,
1369: p_element_type_id => p_ele_id,
1382: p_startup_mode => NULL);
1383: -- (HERE) Done inserting one "Hours" input value.
1384: -- Now insert "Multiple".
1385: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1386: hr_utility.set_location('pyusuiet',270);
1387: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1388: v_inpval_name := 'Multiple';
1389: v_inpval_uom := 'N'; -- Check that this can go out to 5 dec.
1390: v_gen_dbi := 'Y';
1396: p_generate_db_item_flag => v_gen_dbi,
1397: p_display_sequence => g_inpval_disp_seq,
1398: p_business_group_name => p_bg_name);
1399:
1400: hr_utility.set_location('pyusuiet',275);
1401: hr_input_values.chk_input_value(
1402: p_element_type_id => p_ele_id,
1403: p_legislation_code => g_template_leg_code,
1404: p_val_start_date => p_eff_start_date,
1420: p_formula_id => NULL,
1421: p_generate_db_items_flag => v_gen_dbi,
1422: p_warning_or_error => NULL);
1423:
1424: hr_utility.set_location('pyusuiet',280);
1425: hr_input_values.ins_3p_input_values(
1426: p_val_start_date => p_eff_start_date,
1427: p_val_end_date => NULL,
1428: p_element_type_id => p_ele_id,
1441: p_startup_mode => NULL);
1442: -- (HERE) Done inserting one "Multiple" input value.
1443: -- Now insert "Rate".
1444: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1445: hr_utility.set_location('pyusuiet',285);
1446: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1447: v_inpval_name := 'Rate';
1448: v_inpval_uom := 'N'; -- Check that this can go out to 5 dec.
1449: v_gen_dbi := 'Y';
1455: p_generate_db_item_flag => v_gen_dbi,
1456: p_display_sequence => g_inpval_disp_seq,
1457: p_business_group_name => p_bg_name);
1458:
1459: hr_utility.set_location('pyusuiet',290);
1460: hr_input_values.chk_input_value(
1461: p_element_type_id => p_ele_id,
1462: p_legislation_code => g_template_leg_code,
1463: p_val_start_date => p_eff_start_date,
1479: p_formula_id => NULL,
1480: p_generate_db_items_flag => v_gen_dbi,
1481: p_warning_or_error => NULL);
1482:
1483: hr_utility.set_location('pyusuiet',295);
1484: hr_input_values.ins_3p_input_values(
1485: p_val_start_date => p_eff_start_date,
1486: p_val_end_date => NULL,
1487: p_element_type_id => p_ele_id,
1500: p_startup_mode => NULL);
1501: -- (HERE) Done inserting one "Rate" input value.
1502: -- Now insert "Rate Code".
1503: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1504: hr_utility.set_location('pyusuiet',300);
1505: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1506: v_inpval_name := 'Rate Code';
1507: v_inpval_uom := 'C';
1508: v_gen_dbi := 'N';
1514: p_generate_db_item_flag => v_gen_dbi,
1515: p_display_sequence => g_inpval_disp_seq,
1516: p_business_group_name => p_bg_name);
1517:
1518: hr_utility.set_location('pyusuiet',305);
1519: hr_input_values.chk_input_value(
1520: p_element_type_id => p_ele_id,
1521: p_legislation_code => g_template_leg_code,
1522: p_val_start_date => p_eff_start_date,
1538: p_formula_id => NULL,
1539: p_generate_db_items_flag => v_gen_dbi,
1540: p_warning_or_error => NULL);
1541:
1542: hr_utility.set_location('pyusuiet',310);
1543: hr_input_values.ins_3p_input_values(
1544: p_val_start_date => p_eff_start_date,
1545: p_val_end_date => NULL,
1546: p_element_type_id => p_ele_id,
1562: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1563: -- Now insert appropriate formula_result_rules for "HRS X RATE X MULTIPLE"
1564: -- REMEMBER: Testing using 'HEP_TEST_01' formula.
1565:
1566: hr_utility.set_location('pyusuiet',315);
1567:
1568: --
1569: -- check for existence ... return id of result rule if it already exists.
1570: --
1568: --
1569: -- check for existence ... return id of result rule if it already exists.
1570: --
1571: -- Gather Hours By Rate Element Details
1572: hr_utility.trace('Get Hours By Rate Element Id');
1573: hr_utility.set_location('pyusuiet',320);
1574: select element_type_id
1575: into v_hbyr_ele_type_id
1576: from pay_element_types_f
1569: -- check for existence ... return id of result rule if it already exists.
1570: --
1571: -- Gather Hours By Rate Element Details
1572: hr_utility.trace('Get Hours By Rate Element Id');
1573: hr_utility.set_location('pyusuiet',320);
1574: select element_type_id
1575: into v_hbyr_ele_type_id
1576: from pay_element_types_f
1577: where element_name = 'Hours by Rate'
1578: and legislation_code = g_template_leg_code
1579: and sysdate between effective_start_date
1580: and effective_end_date;
1581:
1582: hr_utility.trace('Get Hours By Rate Element Inpval Id');
1583: hr_utility.set_location('pyusuiet',325);
1584: select input_value_id
1585: into v_hbyr_ele_inpval_id
1586: from pay_input_values_f
1579: and sysdate between effective_start_date
1580: and effective_end_date;
1581:
1582: hr_utility.trace('Get Hours By Rate Element Inpval Id');
1583: hr_utility.set_location('pyusuiet',325);
1584: select input_value_id
1585: into v_hbyr_ele_inpval_id
1586: from pay_input_values_f
1587: where element_type_id = v_hbyr_ele_type_id
1588: and name = 'Element Type Id'
1589: and sysdate between effective_start_date
1590: and effective_end_date;
1591:
1592: hr_utility.trace('Get Hours By Rate Rate Inpval Id');
1593: hr_utility.set_location('pyusuiet',330);
1594: select input_value_id
1595: into v_hbyr_rate_inpval_id
1596: from pay_input_values_f
1589: and sysdate between effective_start_date
1590: and effective_end_date;
1591:
1592: hr_utility.trace('Get Hours By Rate Rate Inpval Id');
1593: hr_utility.set_location('pyusuiet',330);
1594: select input_value_id
1595: into v_hbyr_rate_inpval_id
1596: from pay_input_values_f
1597: where element_type_id = v_hbyr_ele_type_id
1598: and name = 'Rate'
1599: and sysdate between effective_start_date
1600: and effective_end_date;
1601:
1602: hr_utility.trace('Get Hours By Rate Hours Inpval Id');
1603: hr_utility.set_location('pyusuiet',335);
1604: select input_value_id
1605: into v_hbyr_hours_inpval_id
1606: from pay_input_values_f
1599: and sysdate between effective_start_date
1600: and effective_end_date;
1601:
1602: hr_utility.trace('Get Hours By Rate Hours Inpval Id');
1603: hr_utility.set_location('pyusuiet',335);
1604: select input_value_id
1605: into v_hbyr_hours_inpval_id
1606: from pay_input_values_f
1607: where element_type_id = v_hbyr_ele_type_id
1608: and name = 'Hours'
1609: and sysdate between effective_start_date
1610: and effective_end_date;
1611:
1612: hr_utility.trace('Get Hours By Rate Multiple Inpval Id');
1613: hr_utility.set_location('pyusuiet',340);
1614: select input_value_id
1615: into v_hbyr_mult_inpval_id
1616: from pay_input_values_f
1609: and sysdate between effective_start_date
1610: and effective_end_date;
1611:
1612: hr_utility.trace('Get Hours By Rate Multiple Inpval Id');
1613: hr_utility.set_location('pyusuiet',340);
1614: select input_value_id
1615: into v_hbyr_mult_inpval_id
1616: from pay_input_values_f
1617: where element_type_id = v_hbyr_ele_type_id
1619: and sysdate between effective_start_date
1620: and effective_end_date;
1621:
1622:
1623: hr_utility.set_location('pyusuiet',345);
1624: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1625: p_business_group_id => p_bg_id,
1626: p_legislation_code => NULL,
1627: p_legislation_subgroup => g_template_leg_subgroup,
1634: p_result_name => 'TEMPLATE_EARNING',
1635: p_result_rule_type => 'D',
1636: p_severity_level => NULL);
1637: --
1638: hr_utility.set_location('pyusuiet',350);
1639: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1640: p_business_group_id => p_bg_id,
1641: p_legislation_code => NULL,
1642: p_legislation_subgroup => g_template_leg_subgroup,
1649: p_result_name => 'MESG',
1650: p_result_rule_type => 'M',
1651: p_severity_level => 'W');
1652: --
1653: hr_utility.set_location('pyusuiet',355);
1654: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1655: p_business_group_id => p_bg_id,
1656: p_legislation_code => NULL,
1657: p_legislation_subgroup => g_template_leg_subgroup,
1663: p_result_rule_type => 'I',
1664: p_severity_level => NULL,
1665: p_element_type_id => v_hbyr_ele_type_id);
1666:
1667: hr_utility.set_location('pyusuiet',360);
1668: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1669: p_business_group_id => p_bg_id,
1670: p_legislation_code => NULL,
1671: p_legislation_subgroup => g_template_leg_subgroup,
1677: p_result_rule_type => 'I',
1678: p_severity_level => NULL,
1679: p_element_type_id => v_hbyr_ele_type_id);
1680:
1681: hr_utility.set_location('pyusuiet',365);
1682: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1683: p_business_group_id => p_bg_id,
1684: p_legislation_code => NULL,
1685: p_legislation_subgroup => g_template_leg_subgroup,
1691: p_result_rule_type => 'I',
1692: p_severity_level => NULL,
1693: p_element_type_id => v_hbyr_ele_type_id);
1694:
1695: hr_utility.set_location('pyusuiet',370);
1696: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1697: p_business_group_id => p_bg_id,
1698: p_legislation_code => NULL,
1699: p_legislation_subgroup => g_template_leg_subgroup,
1707: p_element_type_id => v_hbyr_ele_type_id);
1708:
1709: IF p_ele_proc_type = 'R' THEN
1710: --
1711: hr_utility.set_location('pyusuiet',375);
1712: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1713: p_business_group_id => p_bg_id,
1714: p_legislation_code => NULL,
1715: p_legislation_subgroup => g_template_leg_subgroup,
1727: --
1728: ELSIF UPPER(p_calc_ff_name) IN ('PERCENTAGE_OF_REG_EARNINGS_RECUR_V2',
1729: 'PERCENTAGE_OF_REG_EARNINGS_NONRECUR_V2') THEN
1730: --
1731: hr_utility.set_location('pyusuiet',380);
1732: v_calc_rule_formula_id := ins_formula (
1733: p_ff_ele_name => p_ele_name,
1734: p_ff_suffix => '_PCT_EARN',
1735: p_ff_desc => 'Percentage of regular earnings calculation for recurring earnings.',
1735: p_ff_desc => 'Percentage of regular earnings calculation for recurring earnings.',
1736: p_ff_bg_id => p_bg_id,
1737: p_amt_rule => UPPER(p_calc_ff_name));
1738: --
1739: hr_utility.set_location('pyusuiet',385);
1740: v_stat_proc_rule_id :=
1741: pay_formula_results.ins_stat_proc_rule (
1742: p_business_group_id => p_bg_id,
1743: p_legislation_code => NULL,
1750: p_processing_rule => v_proc_rule);
1751:
1752: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1753: -- Creating "Percentage" input val.
1754: hr_utility.set_location('pyusuiet',390);
1755: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1756: v_inpval_name := 'Percentage';
1757: v_inpval_uom := 'N';
1758: v_gen_dbi := 'Y';
1764: p_generate_db_item_flag => v_gen_dbi,
1765: p_display_sequence => g_inpval_disp_seq,
1766: p_business_group_name => p_bg_name);
1767:
1768: hr_utility.set_location('pyusuiet',395);
1769: hr_input_values.chk_input_value(
1770: p_element_type_id => p_ele_id,
1771: p_legislation_code => g_template_leg_code,
1772: p_val_start_date => p_eff_start_date,
1788: p_formula_id => NULL,
1789: p_generate_db_items_flag => v_gen_dbi,
1790: p_warning_or_error => NULL);
1791:
1792: hr_utility.set_location('pyusuiet',400);
1793: hr_input_values.ins_3p_input_values(
1794: p_val_start_date => p_eff_start_date,
1795: p_val_end_date => NULL,
1796: p_element_type_id => p_ele_id,
1810: -- (HERE) Done inserting one "Percentage" input value.
1811: -- Now insert appropriate formula_result_rules for "PERCENT SALARY"
1812: -- REMEMBER: Testing using 'HEP_TEST_01' formula.
1813:
1814: hr_utility.set_location('pyusuiet',405);
1815: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1816: p_business_group_id => p_bg_id,
1817: p_legislation_code => NULL,
1818: p_legislation_subgroup => g_template_leg_subgroup,
1825: p_result_name => 'TEMPLATE_EARNING',
1826: p_result_rule_type => 'D',
1827: p_severity_level => NULL);
1828: --
1829: hr_utility.set_location('pyusuiet',410);
1830: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1831: p_business_group_id => p_bg_id,
1832: p_legislation_code => NULL,
1833: p_legislation_subgroup => g_template_leg_subgroup,
1842: p_severity_level => 'W');
1843: --
1844: IF p_ele_proc_type = 'R' THEN
1845: --
1846: hr_utility.set_location('pyusuiet',415);
1847: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1848: p_business_group_id => p_bg_id,
1849: p_legislation_code => NULL,
1850: p_legislation_subgroup => g_template_leg_subgroup,
1862:
1863: ELSIF UPPER(p_calc_ff_name) IN ('FLAT_AMOUNT_RECUR_V2',
1864: 'FLAT_AMOUNT_NONRECUR_V2') THEN
1865: --
1866: hr_utility.set_location('pyusuiet',420);
1867: v_calc_rule_formula_id := ins_formula (
1868: p_ff_ele_name => p_ele_name,
1869: p_ff_suffix => '_FLAT_AMOUNT',
1870: p_ff_desc => 'Flat Amount calculation for recurring earnings.',
1870: p_ff_desc => 'Flat Amount calculation for recurring earnings.',
1871: p_ff_bg_id => p_bg_id,
1872: p_amt_rule => UPPER(p_calc_ff_name));
1873: --
1874: hr_utility.set_location('pyusuiet',425);
1875: v_stat_proc_rule_id :=
1876: pay_formula_results.ins_stat_proc_rule (
1877: p_business_group_id => p_bg_id,
1878: p_legislation_code => NULL,
1884: p_formula_id => v_calc_rule_formula_id,
1885: p_processing_rule => v_proc_rule);
1886: --
1887: -- Creating "Amount" input val.
1888: hr_utility.set_location('pyusuiet',430);
1889: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1890: v_inpval_name := 'Amount';
1891: v_inpval_uom := 'M';
1892: v_gen_dbi := 'Y';
1898: p_generate_db_item_flag => v_gen_dbi,
1899: p_display_sequence => g_inpval_disp_seq,
1900: p_business_group_name => p_bg_name);
1901:
1902: hr_utility.set_location('pyusuiet',435);
1903: hr_input_values.chk_input_value(
1904: p_element_type_id => p_ele_id,
1905: p_legislation_code => g_template_leg_code,
1906: p_val_start_date => p_eff_start_date,
1922: p_formula_id => NULL,
1923: p_generate_db_items_flag => v_gen_dbi,
1924: p_warning_or_error => NULL);
1925:
1926: hr_utility.set_location('pyusuiet',440);
1927: hr_input_values.ins_3p_input_values(
1928: p_val_start_date => p_eff_start_date,
1929: p_val_end_date => NULL,
1930: p_element_type_id => p_ele_id,
1945: -- (HERE) Done inserting one "Amount" input value.
1946: --
1947: -- Now insert appropriate formula_result_rules for "FLAT AMOUNT"
1948: --
1949: hr_utility.set_location('pyusuiet',445);
1950: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1951: p_business_group_id => p_bg_id,
1952: p_legislation_code => NULL,
1953: p_legislation_subgroup => g_template_leg_subgroup,
1960: p_result_name => 'FLAT_AMOUNT',
1961: p_result_rule_type => 'D',
1962: p_severity_level => NULL);
1963: --
1964: hr_utility.set_location('pyusuiet',450);
1965: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1966: p_business_group_id => p_bg_id,
1967: p_legislation_code => NULL,
1968: p_legislation_subgroup => g_template_leg_subgroup,
1977: p_severity_level => 'W');
1978: --
1979: IF p_ele_proc_type = 'R' THEN
1980: --
1981: hr_utility.set_location('pyusuiet',455);
1982: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1983: p_business_group_id => p_bg_id,
1984: p_legislation_code => NULL,
1985: p_legislation_subgroup => g_template_leg_subgroup,
1999:
2000: -- Could not find this calc method formula(?) should never happen!
2001: -- No input vals or formula results required for calculation of
2002: -- this earning.
2003: hr_utility.set_location('pyusuiet',460);
2004: v_calc_rule_formula_id := '';
2005: v_stat_proc_rule_id :=
2006: pay_formula_results.ins_stat_proc_rule (
2007: p_business_group_id => p_bg_id,
2078: -- Add input values w/display seq = g_inpval_disp_seq + 1, and so on.
2079: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
2080: -- Creating "Jurisdiction" input val
2081:
2082: hr_utility.set_location('pyusuiet',465);
2083: SELECT formula_id
2084: INTO v_val_formula_id
2085: FROM ff_formulas_f
2086: WHERE business_group_id IS NULL
2086: WHERE business_group_id IS NULL
2087: AND legislation_code = 'US'
2088: AND formula_name = 'JURISDICTION_VALIDATION';
2089: --
2090: hr_utility.set_location('pyusuiet',86);
2091: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2092: v_inpval_name := 'Jurisdiction';
2093: v_inpval_uom := 'C';
2094: v_gen_dbi := 'N';
2093: v_inpval_uom := 'C';
2094: v_gen_dbi := 'N';
2095: v_lkp_type := NULL;
2096: --
2097: hr_utility.set_location('pyusuiet',470);
2098: v_inpval_id := pay_db_pay_setup.create_input_value (
2099: p_element_name => p_ele_name,
2100: p_name => v_inpval_name,
2101: p_uom_code => v_inpval_uom,
2112: p_business_group_name => p_bg_name,
2113: p_effective_start_date => p_eff_start,
2114: p_effective_end_date => p_eff_end);
2115: --
2116: hr_utility.set_location('pyusuiet',480);
2117: hr_input_values.chk_input_value(
2118: p_element_type_id => p_ele_type_id,
2119: p_legislation_code => g_template_leg_code,
2120: p_val_start_date => p_eff_start,
2136: p_formula_id => v_val_formula_id,
2137: p_generate_db_items_flag => v_gen_dbi,
2138: p_warning_or_error => 'Error');
2139: --
2140: hr_utility.set_location('pyusuiet',485);
2141: hr_input_values.ins_3p_input_values(
2142: p_val_start_date => p_eff_start,
2143: p_val_end_date => NULL,
2144: p_element_type_id => p_ele_type_id,
2160: -- Check classification, if supplemental, then create "Tax Separately"
2161: IF UPPER(p_ele_class) = 'SUPPLEMENTAL EARNINGS' THEN
2162: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
2163: -- Creating "Tax Separately" inpval
2164: hr_utility.set_location('pyusuiet',490);
2165: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2166: v_inpval_name := 'Tax Separately';
2167: v_inpval_uom := 'C';
2168: v_gen_dbi := 'N';
2179: p_default_value => v_dflt_value,
2180: p_lookup_type => v_lkp_type,
2181: p_business_group_name => p_bg_name);
2182:
2183: hr_utility.set_location('pyusuiet',495);
2184: hr_input_values.chk_input_value(
2185: p_element_type_id => p_ele_type_id,
2186: p_legislation_code => g_template_leg_code,
2187: p_val_start_date => p_eff_start,
2203: p_formula_id => NULL,
2204: p_generate_db_items_flag => v_gen_dbi,
2205: p_warning_or_error => NULL);
2206:
2207: hr_utility.set_location('pyusuiet',500);
2208: hr_input_values.ins_3p_input_values(
2209: p_val_start_date => p_eff_start,
2210: p_val_end_date => NULL,
2211: p_element_type_id => p_ele_type_id,
2230: -- G1188 (03-Aug-94): Also create these input values if ele classification
2231: -- is 'Supplemental Earnings'.
2232: --
2233: -- Creating "Deduction Processing" inpval
2234: hr_utility.set_location('pyusuiet',505);
2235: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2236: v_inpval_name := 'Deduction Processing';
2237: v_inpval_uom := 'C';
2238: v_gen_dbi := 'N';
2261: ELSE
2262: v_mand_flag := 'Y';
2263: END IF;
2264:
2265: hr_utility.set_location('pyusuiet',510);
2266: v_inpval_id := pay_db_pay_setup.create_input_value (
2267: p_element_name => p_ele_name,
2268: p_name => v_inpval_name,
2269: p_uom_code => v_inpval_uom,
2280: p_business_group_name => p_bg_name,
2281: p_effective_start_date => p_eff_start,
2282: p_effective_end_date => p_eff_end);
2283:
2284: hr_utility.set_location('pyusuiet',515);
2285: hr_input_values.chk_input_value(
2286: p_element_type_id => p_ele_type_id,
2287: p_legislation_code => g_template_leg_code,
2288: p_val_start_date => p_eff_start,
2304: p_formula_id => NULL,
2305: p_generate_db_items_flag => v_gen_dbi,
2306: p_warning_or_error => NULL);
2307:
2308: hr_utility.set_location('pyusuiet',520);
2309: hr_input_values.ins_3p_input_values(
2310: p_val_start_date => p_eff_start,
2311: p_val_end_date => p_eff_end,
2312: p_element_type_id => p_ele_type_id,
2326: -- (HERE) Done inserting "Deduction Processing" input value.
2327: --
2328: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
2329: -- Creating "Separate Check" inpval
2330: hr_utility.set_location('pyusuiet',525);
2331: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2332: v_inpval_name := 'Separate Check';
2333: v_inpval_uom := 'C';
2334: v_gen_dbi := 'N';
2357: v_mand_flag := 'Y';
2358:
2359: END IF;
2360:
2361: hr_utility.set_location('pyusuiet',530);
2362: v_inpval_id := pay_db_pay_setup.create_input_value (
2363: p_element_name => p_ele_name,
2364: p_name => v_inpval_name,
2365: p_uom_code => v_inpval_uom,
2376: p_business_group_name => p_bg_name,
2377: p_effective_start_date => p_eff_start,
2378: p_effective_end_date => p_eff_end);
2379:
2380: hr_utility.set_location('pyusuiet',535);
2381: hr_input_values.chk_input_value(
2382: p_element_type_id => p_ele_type_id,
2383: p_legislation_code => g_template_leg_code,
2384: p_val_start_date => p_eff_start,
2400: p_formula_id => NULL,
2401: p_generate_db_items_flag => v_gen_dbi,
2402: p_warning_or_error => NULL);
2403:
2404: hr_utility.set_location('pyusuiet',540);
2405: hr_input_values.ins_3p_input_values(
2406: p_val_start_date => p_eff_start,
2407: p_val_end_date => p_eff_end,
2408: p_element_type_id => p_ele_type_id,
2427: -- Creating "Date Earned" inpval
2428: --
2429: /*
2430:
2431: hr_utility.trace('I am going to create the Date Earned');
2432: hr_utility.set_location('pyusuiet',545);
2433: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2434: v_inpval_name := 'Date Earned';
2435: v_inpval_uom := 'Date (DD-MON-YYYY)';
2428: --
2429: /*
2430:
2431: hr_utility.trace('I am going to create the Date Earned');
2432: hr_utility.set_location('pyusuiet',545);
2433: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2434: v_inpval_name := 'Date Earned';
2435: v_inpval_uom := 'Date (DD-MON-YYYY)';
2436: v_gen_dbi := 'N';
2434: v_inpval_name := 'Date Earned';
2435: v_inpval_uom := 'Date (DD-MON-YYYY)';
2436: v_gen_dbi := 'N';
2437:
2438: hr_utility.trace('The input value name is '|| v_inpval_name );
2439: hr_utility.set_location('pyusuiet',550);
2440: v_inpval_id := pay_db_pay_setup.create_input_value (
2441: p_element_name => p_ele_name,
2442: p_name => v_inpval_name,
2435: v_inpval_uom := 'Date (DD-MON-YYYY)';
2436: v_gen_dbi := 'N';
2437:
2438: hr_utility.trace('The input value name is '|| v_inpval_name );
2439: hr_utility.set_location('pyusuiet',550);
2440: v_inpval_id := pay_db_pay_setup.create_input_value (
2441: p_element_name => p_ele_name,
2442: p_name => v_inpval_name,
2443: p_uom_code => v_inpval_uom,
2445: p_generate_db_item_flag => v_gen_dbi,
2446: p_display_sequence => g_inpval_disp_seq,
2447: p_business_group_name => p_bg_name);
2448:
2449: hr_utility.set_location('pyusuiet',555);
2450: hr_input_values.chk_input_value(
2451: p_element_type_id => p_ele_type_id,
2452: p_legislation_code => g_template_leg_code,
2453: p_val_start_date => p_eff_start,
2469: p_formula_id => NULL,
2470: p_generate_db_items_flag => v_gen_dbi,
2471: p_warning_or_error => NULL);
2472:
2473: hr_utility.set_location('pyusuiet',560);
2474: hr_input_values.ins_3p_input_values(
2475: p_val_start_date => p_eff_start,
2476: p_val_end_date => p_eff_end,
2477: p_element_type_id => p_ele_type_id,
2499: -- Creating "Replace Amt" inpval
2500:
2501: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
2502:
2503: hr_utility.set_location('pyusuiet',565);
2504: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2505: v_inpval_name := 'Replace Amt';
2506: v_inpval_uom := 'M';
2507: v_gen_dbi := 'N';
2524: p_business_group_name => p_bg_name,
2525: p_effective_start_date => p_eff_start,
2526: p_effective_end_date => p_eff_end);
2527:
2528: hr_utility.set_location('pyusuiet',570);
2529: hr_input_values.chk_input_value(
2530: p_element_type_id => p_inputs_ele_type_id,
2531: p_legislation_code => g_template_leg_code,
2532: p_val_start_date => p_eff_start,
2548: p_formula_id => NULL,
2549: p_generate_db_items_flag => v_gen_dbi,
2550: p_warning_or_error => NULL);
2551:
2552: hr_utility.set_location('pyusuiet',575);
2553: hr_input_values.ins_3p_input_values(
2554: p_val_start_date => p_eff_start,
2555: p_val_end_date => p_eff_end,
2556: p_element_type_id => p_inputs_ele_type_id,
2571: -- (HERE) Done inserting "Replacement Amount" input value.
2572: --
2573: -- Creating "Addl Amt" inpval
2574: --
2575: hr_utility.set_location('pyusuiet',580);
2576: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2577: v_inpval_name := 'Addl Amt';
2578: v_inpval_uom := 'M';
2579: v_gen_dbi := 'N';
2596: p_business_group_name => p_bg_name,
2597: p_effective_start_date => p_eff_start,
2598: p_effective_end_date => p_eff_end);
2599:
2600: hr_utility.set_location('pyusuiet',585);
2601: hr_input_values.chk_input_value(
2602: p_element_type_id => p_inputs_ele_type_id,
2603: p_legislation_code => g_template_leg_code,
2604: p_val_start_date => p_eff_start,
2620: p_formula_id => NULL,
2621: p_generate_db_items_flag => v_gen_dbi,
2622: p_warning_or_error => NULL);
2623:
2624: hr_utility.set_location('pyusuiet',590);
2625: hr_input_values.ins_3p_input_values(
2626: p_val_start_date => p_eff_start,
2627: p_val_end_date => p_eff_end,
2628: p_element_type_id => p_inputs_ele_type_id,
2659: g_inpval_disp_seq := 0;
2660:
2661: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
2662:
2663: hr_utility.set_location('pyusuiet',595);
2664: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2665: v_inpval_name := 'Replacement Amt';
2666: v_inpval_uom := 'M';
2667: v_gen_dbi := 'N';
2684: p_business_group_name => p_bg_name,
2685: p_effective_start_date => p_eff_start,
2686: p_effective_end_date => p_eff_end);
2687:
2688: hr_utility.set_location('pyusuiet',600);
2689: hr_input_values.chk_input_value(
2690: p_element_type_id => p_shadow_ele_type_id,
2691: p_legislation_code => g_template_leg_code,
2692: p_val_start_date => p_eff_start,
2708: p_formula_id => NULL,
2709: p_generate_db_items_flag => v_gen_dbi,
2710: p_warning_or_error => NULL);
2711:
2712: hr_utility.set_location('pyusuiet',605);
2713: hr_input_values.ins_3p_input_values(
2714: p_val_start_date => p_eff_start,
2715: p_val_end_date => p_eff_end,
2716: p_element_type_id => p_shadow_ele_type_id,
2731: -- (HERE) Done inserting "Replacement Amount" input value.
2732: --
2733: -- Creating "Addl Amt" inpval
2734: --
2735: hr_utility.set_location('pyusuiet',610);
2736: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2737: v_inpval_name := 'Additional Amt';
2738: v_inpval_uom := 'M';
2739: v_gen_dbi := 'N';
2756: p_business_group_name => p_bg_name,
2757: p_effective_start_date => p_eff_start,
2758: p_effective_end_date => p_eff_end);
2759:
2760: hr_utility.set_location('pyusuiet',615);
2761: hr_input_values.chk_input_value(
2762: p_element_type_id => p_shadow_ele_type_id,
2763: p_legislation_code => g_template_leg_code,
2764: p_val_start_date => p_eff_start,
2780: p_formula_id => NULL,
2781: p_generate_db_items_flag => v_gen_dbi,
2782: p_warning_or_error => NULL);
2783:
2784: hr_utility.set_location('pyusuiet',620);
2785: hr_input_values.ins_3p_input_values(
2786: p_val_start_date => p_eff_start,
2787: p_val_end_date => p_eff_end,
2788: p_element_type_id => p_shadow_ele_type_id,
2806: -- (HERE) Done inserting "Addl Amt" input value.
2807: --
2808: -- Now insert "Neg Earnings".
2809: --
2810: hr_utility.set_location('pyusuiet',625);
2811: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2812: v_inpval_name := 'Neg Earnings';
2813: v_inpval_uom := 'M';
2814: v_gen_dbi := 'N';
2831: p_business_group_name => p_bg_name,
2832: p_effective_start_date => p_eff_start,
2833: p_effective_end_date => p_eff_end);
2834:
2835: hr_utility.set_location('pyusuiet',630);
2836: hr_input_values.chk_input_value(
2837: p_element_type_id => p_shadow_ele_type_id,
2838: p_legislation_code => g_template_leg_code,
2839: p_val_start_date => p_eff_start,
2855: p_formula_id => NULL,
2856: p_generate_db_items_flag => v_gen_dbi,
2857: p_warning_or_error => NULL);
2858:
2859: hr_utility.set_location('pyusuiet',635);
2860: hr_input_values.ins_3p_input_values(
2861: p_val_start_date => p_eff_start,
2862: p_val_end_date => p_eff_end,
2863: p_element_type_id => p_shadow_ele_type_id,
2879: --
2880:
2881: -- Now insert "Reduce Reg Hours".
2882: --
2883: hr_utility.set_location('pyusuiet',640);
2884: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2885: v_inpval_name := 'Reduce Reg Hours';
2886: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
2887: v_gen_dbi := 'N';
2905: p_effective_start_date => p_eff_start,
2906: p_effective_end_date => p_eff_end);
2907:
2908:
2909: hr_utility.set_location('pyusuiet',645);
2910: hr_input_values.chk_input_value(
2911: p_element_type_id => p_shadow_ele_type_id,
2912: p_legislation_code => g_template_leg_code,
2913: p_val_start_date => p_eff_start,
2929: p_formula_id => NULL,
2930: p_generate_db_items_flag => v_gen_dbi,
2931: p_warning_or_error => NULL);
2932:
2933: hr_utility.set_location('pyusuiet',650);
2934: hr_input_values.ins_3p_input_values(
2935: p_val_start_date => p_eff_start,
2936: p_val_end_date => p_eff_end,
2937: p_element_type_id => p_shadow_ele_type_id,
2952: -- (HERE) Done inserting "Reduce Reg Hours" input value.
2953:
2954: -- Now insert "Reduce Reg Pay".
2955: --
2956: hr_utility.set_location('pyusuiet',655);
2957: g_inpval_disp_seq := g_inpval_disp_seq + 1;
2958: v_inpval_name := 'Reduce Reg Pay';
2959: v_inpval_uom := 'M';
2960: v_gen_dbi := 'N';
2977: p_business_group_name => p_bg_name,
2978: p_effective_start_date => p_eff_start,
2979: p_effective_end_date => p_eff_end);
2980:
2981: hr_utility.set_location('pyusuiet',660);
2982: hr_input_values.chk_input_value(
2983: p_element_type_id => p_shadow_ele_type_id,
2984: p_legislation_code => g_template_leg_code,
2985: p_val_start_date => p_eff_start,
3001: p_formula_id => NULL,
3002: p_generate_db_items_flag => v_gen_dbi,
3003: p_warning_or_error => NULL);
3004:
3005: hr_utility.set_location('pyusuiet',665);
3006: hr_input_values.ins_3p_input_values(
3007: p_val_start_date => p_eff_start,
3008: p_val_end_date => p_eff_end,
3009: p_element_type_id => p_shadow_ele_type_id,
3024: -- (HERE) Done inserting "Reduce Reg Pay" input value.
3025:
3026: -- Now insert "Reduce Sal Hours".
3027: --
3028: hr_utility.set_location('pyusuiet',670);
3029: g_inpval_disp_seq := g_inpval_disp_seq + 1;
3030: v_inpval_name := 'Reduce Sal Hours';
3031: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
3032: v_gen_dbi := 'N';
3049: p_business_group_name => p_bg_name,
3050: p_effective_start_date => p_eff_start,
3051: p_effective_end_date => p_eff_end);
3052:
3053: hr_utility.set_location('pyusuiet',675);
3054: hr_input_values.chk_input_value(
3055: p_element_type_id => p_shadow_ele_type_id,
3056: p_legislation_code => g_template_leg_code,
3057: p_val_start_date => p_eff_start,
3073: p_formula_id => NULL,
3074: p_generate_db_items_flag => v_gen_dbi,
3075: p_warning_or_error => NULL);
3076:
3077: hr_utility.set_location('pyusuiet',680);
3078: hr_input_values.ins_3p_input_values(
3079: p_val_start_date => p_eff_start,
3080: p_val_end_date => p_eff_end,
3081: p_element_type_id => p_shadow_ele_type_id,
3096: -- (HERE) Done inserting "Reduce Sal Hours" input value.
3097:
3098: -- Now insert "Reduce Sal Pay".
3099: --
3100: hr_utility.set_location('pyusuiet',685);
3101: g_inpval_disp_seq := g_inpval_disp_seq + 1;
3102: v_inpval_name := 'Reduce Sal Pay';
3103: v_inpval_uom := 'M';
3104: v_gen_dbi := 'N';
3121: p_business_group_name => p_bg_name,
3122: p_effective_start_date => p_eff_start,
3123: p_effective_end_date => p_eff_end);
3124:
3125: hr_utility.set_location('pyusuiet',690);
3126: hr_input_values.chk_input_value(
3127: p_element_type_id => p_shadow_ele_type_id,
3128: p_legislation_code => g_template_leg_code,
3129: p_val_start_date => p_eff_start,
3145: p_formula_id => NULL,
3146: p_generate_db_items_flag => v_gen_dbi,
3147: p_warning_or_error => NULL);
3148:
3149: hr_utility.set_location('pyusuiet',695);
3150: hr_input_values.ins_3p_input_values(
3151: p_val_start_date => p_eff_start,
3152: p_val_end_date => p_eff_end,
3153: p_element_type_id => p_shadow_ele_type_id,
3168: -- (HERE) Done inserting "Reduce Sal Pay" input value.
3169:
3170: -- Now insert "Reduce Wag Hours".
3171: --
3172: hr_utility.set_location('pyusuiet',700);
3173: g_inpval_disp_seq := g_inpval_disp_seq + 1;
3174: v_inpval_name := 'Reduce Wag Hours';
3175: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
3176: v_gen_dbi := 'N';
3193: p_business_group_name => p_bg_name,
3194: p_effective_start_date => p_eff_start,
3195: p_effective_end_date => p_eff_end);
3196:
3197: hr_utility.set_location('pyusuiet',705);
3198: hr_input_values.chk_input_value(
3199: p_element_type_id => p_shadow_ele_type_id,
3200: p_legislation_code => g_template_leg_code,
3201: p_val_start_date => p_eff_start,
3217: p_formula_id => NULL,
3218: p_generate_db_items_flag => v_gen_dbi,
3219: p_warning_or_error => NULL);
3220:
3221: hr_utility.set_location('pyusuiet',710);
3222: hr_input_values.ins_3p_input_values(
3223: p_val_start_date => p_eff_start,
3224: p_val_end_date => p_eff_end,
3225: p_element_type_id => p_shadow_ele_type_id,
3240: -- (HERE) Done inserting "Reduce Wag Hours" input value.
3241:
3242: -- Now insert "Reduce Wag Pay".
3243: --
3244: hr_utility.set_location('pyusuiet',715);
3245: g_inpval_disp_seq := g_inpval_disp_seq + 1;
3246: v_inpval_name := 'Reduce Wag Pay';
3247: v_inpval_uom := 'M';
3248: v_gen_dbi := 'N';
3265: p_business_group_name => p_bg_name,
3266: p_effective_start_date => p_eff_start,
3267: p_effective_end_date => p_eff_end);
3268:
3269: hr_utility.set_location('pyusuiet',720);
3270: hr_input_values.chk_input_value(
3271: p_element_type_id => p_shadow_ele_type_id,
3272: p_legislation_code => g_template_leg_code,
3273: p_val_start_date => p_eff_start,
3289: p_formula_id => NULL,
3290: p_generate_db_items_flag => v_gen_dbi,
3291: p_warning_or_error => NULL);
3292:
3293: hr_utility.set_location('pyusuiet',725);
3294: hr_input_values.ins_3p_input_values(
3295: p_val_start_date => p_eff_start,
3296: p_val_end_date => p_eff_end,
3297: p_element_type_id => p_shadow_ele_type_id,
3310: p_startup_mode => NULL);
3311: --
3312: -- (HERE) Done inserting "Reduce Wag Pay" input value.
3313:
3314: hr_utility.set_location('pyusuiet',730);
3315: SELECT status_processing_rule_id
3316: INTO v_status_proc_id
3317: FROM pay_status_processing_rules_f
3318: WHERE assignment_status_type_id IS NULL
3320: --
3321:
3322: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
3323:
3324: hr_utility.set_location('pyusuiet',735);
3325: v_resrule_id := pay_formula_results.ins_form_res_rule (
3326: p_business_group_id => p_bg_id,
3327: p_legislation_code => NULL,
3328: p_legislation_subgroup => g_template_leg_subgroup,
3334: p_result_rule_type => 'I',
3335: p_severity_level => NULL,
3336: p_element_type_id => p_shadow_ele_type_id);
3337: --
3338: hr_utility.set_location('pyusuiet',740);
3339: v_resrule_id := pay_formula_results.ins_form_res_rule (
3340: p_business_group_id => p_bg_id,
3341: p_legislation_code => NULL,
3342: p_legislation_subgroup => g_template_leg_subgroup,
3352:
3353: End if; /* Not required for NR Elements */
3354:
3355:
3356: hr_utility.set_location('pyusuiet',745);
3357: v_resrule_id := pay_formula_results.ins_form_res_rule (
3358: p_business_group_id => p_bg_id,
3359: p_legislation_code => NULL,
3360: p_legislation_subgroup => g_template_leg_subgroup,
3369: --
3370:
3371: /* get the input value id for the Pay Value input value for the shadow element. */
3372:
3373: hr_utility.set_location('pyusuiet',750);
3374: select pivf.input_value_id
3375: into g_shadow_info_payval_id
3376: from pay_input_values_f pivf
3377: where pivf.element_type_id = p_shadow_ele_type_id
3376: from pay_input_values_f pivf
3377: where pivf.element_type_id = p_shadow_ele_type_id
3378: and pivf.name = 'Pay Value';
3379:
3380: hr_utility.set_location('pyusuiet',755);
3381: v_resrule_id := pay_formula_results.ins_form_res_rule (
3382: p_business_group_id => p_bg_id,
3383: p_legislation_code => NULL,
3384: p_legislation_subgroup => g_template_leg_subgroup,
3392: p_element_type_id => p_shadow_ele_type_id );
3393: --
3394:
3395: --
3396: hr_utility.set_location('pyusuiet',760);
3397: v_resrule_id := pay_formula_results.ins_form_res_rule (
3398: p_business_group_id => p_bg_id,
3399: p_legislation_code => NULL,
3400: p_legislation_subgroup => g_template_leg_subgroup,
3406: p_result_rule_type => 'I',
3407: p_severity_level => NULL,
3408: p_element_type_id => p_shadow_ele_type_id );
3409: --
3410: hr_utility.set_location('pyusuiet',765);
3411: v_resrule_id := pay_formula_results.ins_form_res_rule (
3412: p_business_group_id => p_bg_id,
3413: p_legislation_code => NULL,
3414: p_legislation_subgroup => g_template_leg_subgroup,
3422: p_element_type_id => p_shadow_ele_type_id );
3423: --
3424:
3425: --
3426: hr_utility.set_location('pyusuiet',770);
3427: v_resrule_id := pay_formula_results.ins_form_res_rule (
3428: p_business_group_id => p_bg_id,
3429: p_legislation_code => NULL,
3430: p_legislation_subgroup => g_template_leg_subgroup,
3437: p_severity_level => NULL,
3438: p_element_type_id => p_shadow_ele_type_id );
3439: --
3440:
3441: hr_utility.set_location('pyusuiet',775);
3442: v_resrule_id := pay_formula_results.ins_form_res_rule (
3443: p_business_group_id => p_bg_id,
3444: p_legislation_code => NULL,
3445: p_legislation_subgroup => g_template_leg_subgroup,
3454: --
3455:
3456: IF UPPER(p_ele_proc_type) = 'R' THEN
3457: --
3458: hr_utility.set_location('pyusuiet',780);
3459: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
3460: p_business_group_id => p_bg_id,
3461: p_legislation_code => NULL,
3462: p_legislation_subgroup => g_template_leg_subgroup,
3772:
3773: --
3774: -- Set session date
3775:
3776: hr_utility.set_location('pyusuiet',785);
3777: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
3778: g_eff_start_date := NVL(p_ele_eff_start_date, sysdate);
3779: g_eff_end_date := NVL(p_ele_eff_end_date, c_end_of_time);
3780:
3778: g_eff_start_date := NVL(p_ele_eff_start_date, sysdate);
3779: g_eff_end_date := NVL(p_ele_eff_end_date, c_end_of_time);
3780:
3781: -- Set globals: v_bg_name
3782: hr_utility.set_location('pyusuiet',790);
3783: select name
3784: into v_bg_name
3785: from per_business_groups
3786: where business_group_id = p_bg_id;
3792: -- Create bal type, then Defined_Balances for PTD, MTD, and YTD dimensions.
3793: -- Let currency code default to leg currency.
3794: -- ins_uie_balance (e_name, bal_uom);
3795:
3796: hr_utility.set_location('pyusuiet',795);
3797: -- Check element name, ie. primary balance name, is unique to
3798: -- balances within this BG.
3799:
3800: pay_balance_types_pkg.chk_balance_type(
3804: p_balance_name => p_ele_name,
3805: p_reporting_name => p_ele_name,
3806: p_assignment_remuneration_flag => 'N');
3807:
3808: hr_utility.set_location('pyusuiet',800);
3809: -- Check element name, ie. primary balance name, is unique to
3810: -- balances provided as startup data.
3811:
3812: pay_balance_types_pkg.chk_balance_type(
3835: else
3836: l_bal_cat_classification := 'Supplemental Earnings';
3837: end if;
3838:
3839: hr_utility.set_location('pyusuiet',805);
3840: v_bal_type_id := pay_db_pay_setup.create_balance_type(
3841: p_balance_name => p_ele_name,
3842: p_uom => null,
3843: p_uom_code => 'M',
3852: IF p_ele_processing_type = 'R' THEN
3853: v_neg_earnbal_name := SUBSTR(p_ele_name, 1, 65)||' Neg Earnings';
3854: --v_bal_repname := SUBSTR(p_ele_reporting_name, 1, 15)||' Neg Earnings';
3855:
3856: hr_utility.set_location('pyusuiet',810);
3857: v_neg_earn_bal_type_id := pay_db_pay_setup.create_balance_type(
3858: p_balance_name => v_neg_earnbal_name,
3859: p_uom => null,
3860: p_uom_code => 'M',
3875: IF p_ele_processing_type = 'R' THEN /* Not required for NR Elements Change */
3876: v_addl_amt_bal_name := SUBSTR(p_ele_name, 1, 67)||' Additional';
3877: --v_bal_repname := SUBSTR(p_ele_reporting_name, 1, 17)||' Additional';
3878:
3879: hr_utility.set_location('pyusuiet',815);
3880: v_addl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(
3881: p_balance_name => v_addl_amt_bal_name,
3882: p_uom => null,
3883: p_uom_code => 'M',
3891: --
3892: v_repl_amt_bal_name := SUBSTR(p_ele_name, 1, 67)||' Replacement';
3893: --v_bal_repname := SUBSTR(p_ele_reporting_name, 1, 17)||' Replacement';
3894:
3895: hr_utility.set_location('pyusuiet',820);
3896: v_repl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(
3897: p_balance_name => v_repl_amt_bal_name,
3898: p_uom => null,
3899: p_uom_code => 'M',
3908: end if; /* Not required for NR Elements Change */
3909: --
3910: -- Defined Balances (ie. balance type associated with a dimension)
3911: --
3912: hr_utility.set_location('pyusuiet',825);
3913:
3914: --
3915: -- check for existence of defined balance before creating...return defbal id if already exists...
3916: --
3920: p_balance_dimension => 'Assignment within Government Reporting Entity Year to Date',
3921: p_business_group_name => v_bg_name,
3922: p_legislation_code => NULL);
3923:
3924: hr_utility.set_location('pyusuiet',830);
3925: pay_db_pay_setup.create_defined_balance (
3926: p_balance_name => p_ele_name,
3927: p_balance_dimension => 'Assignment within Government Reporting Entity Period to Date',
3928: p_business_group_name => v_bg_name,
3927: p_balance_dimension => 'Assignment within Government Reporting Entity Period to Date',
3928: p_business_group_name => v_bg_name,
3929: p_legislation_code => NULL);
3930:
3931: hr_utility.set_location('pyusuiet',835);
3932: pay_db_pay_setup.create_defined_balance (
3933: p_balance_name => p_ele_name,
3934: p_balance_dimension => 'Assignment within Government Reporting Entity Quarter to Date',
3935: p_business_group_name => v_bg_name,
3934: p_balance_dimension => 'Assignment within Government Reporting Entity Quarter to Date',
3935: p_business_group_name => v_bg_name,
3936: p_legislation_code => NULL);
3937:
3938: hr_utility.set_location('pyusuiet',840);
3939: pay_db_pay_setup.create_defined_balance (
3940: p_balance_name => p_ele_name,
3941: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
3942: p_business_group_name => v_bg_name,
3942: p_business_group_name => v_bg_name,
3943: p_legislation_code => NULL,
3944: p_save_run_bal => 'Y');
3945:
3946: hr_utility.set_location('pyusuiet',845);
3947: pay_db_pay_setup.create_defined_balance (
3948: p_balance_name => p_ele_name,
3949: p_balance_dimension => 'Assignment within Government Reporting Entity Month',
3950: p_business_group_name => v_bg_name,
3949: p_balance_dimension => 'Assignment within Government Reporting Entity Month',
3950: p_business_group_name => v_bg_name,
3951: p_legislation_code => NULL);
3952:
3953: hr_utility.set_location('pyusuiet',850);
3954: pay_db_pay_setup.create_defined_balance (
3955: p_balance_name => p_ele_name,
3956: p_balance_dimension => 'Assignment-Level Current Run',
3957: p_business_group_name => v_bg_name,
3956: p_balance_dimension => 'Assignment-Level Current Run',
3957: p_business_group_name => v_bg_name,
3958: p_legislation_code => NULL);
3959:
3960: hr_utility.set_location('pyusuiet',855);
3961: pay_db_pay_setup.create_defined_balance (
3962: p_balance_name => p_ele_name,
3963: p_balance_dimension => 'Assignment Period to Date',
3964: p_business_group_name => v_bg_name,
3963: p_balance_dimension => 'Assignment Period to Date',
3964: p_business_group_name => v_bg_name,
3965: p_legislation_code => NULL);
3966:
3967: hr_utility.set_location('pyusuiet',860);
3968: pay_db_pay_setup.create_defined_balance (
3969: p_balance_name => p_ele_name,
3970: p_balance_dimension => 'Assignment Month',
3971: p_business_group_name => v_bg_name,
3970: p_balance_dimension => 'Assignment Month',
3971: p_business_group_name => v_bg_name,
3972: p_legislation_code => NULL);
3973:
3974: hr_utility.set_location('pyusuiet',865);
3975: pay_db_pay_setup.create_defined_balance (
3976: p_balance_name => p_ele_name,
3977: p_balance_dimension => 'Assignment Quarter to Date',
3978: p_business_group_name => v_bg_name,
3977: p_balance_dimension => 'Assignment Quarter to Date',
3978: p_business_group_name => v_bg_name,
3979: p_legislation_code => NULL);
3980:
3981: hr_utility.set_location('pyusuiet',870);
3982: pay_db_pay_setup.create_defined_balance (
3983: p_balance_name => p_ele_name,
3984: p_balance_dimension => 'Assignment Year to Date',
3985: p_business_group_name => v_bg_name,
3984: p_balance_dimension => 'Assignment Year to Date',
3985: p_business_group_name => v_bg_name,
3986: p_legislation_code => NULL);
3987:
3988: hr_utility.set_location('pyusuiet',875);
3989: pay_db_pay_setup.create_defined_balance (
3990: p_balance_name => p_ele_name,
3991: p_balance_dimension => 'Person Run',
3992: p_business_group_name => v_bg_name,
3991: p_balance_dimension => 'Person Run',
3992: p_business_group_name => v_bg_name,
3993: p_legislation_code => NULL);
3994:
3995: hr_utility.set_location('pyusuiet',880);
3996: pay_db_pay_setup.create_defined_balance (
3997: p_balance_name => p_ele_name,
3998: p_balance_dimension => 'Person Quarter to Date',
3999: p_business_group_name => v_bg_name,
3998: p_balance_dimension => 'Person Quarter to Date',
3999: p_business_group_name => v_bg_name,
4000: p_legislation_code => NULL);
4001:
4002: hr_utility.set_location('pyusuiet',885);
4003: pay_db_pay_setup.create_defined_balance (
4004: p_balance_name => p_ele_name,
4005: p_balance_dimension => 'Person Year to Date',
4006: p_business_group_name => v_bg_name,
4005: p_balance_dimension => 'Person Year to Date',
4006: p_business_group_name => v_bg_name,
4007: p_legislation_code => NULL);
4008:
4009: hr_utility.set_location('pyusuiet',890);
4010: pay_db_pay_setup.create_defined_balance (
4011: p_balance_name => p_ele_name,
4012: p_balance_dimension => 'Person Month',
4013: p_business_group_name => v_bg_name,
4012: p_balance_dimension => 'Person Month',
4013: p_business_group_name => v_bg_name,
4014: p_legislation_code => NULL);
4015:
4016: hr_utility.set_location('pyusuiet',895);
4017: pay_db_pay_setup.create_defined_balance (
4018: p_balance_name => p_ele_name,
4019: p_balance_dimension => 'Person within Government Reporting Entity Run',
4020: p_business_group_name => v_bg_name,
4019: p_balance_dimension => 'Person within Government Reporting Entity Run',
4020: p_business_group_name => v_bg_name,
4021: p_legislation_code => NULL);
4022:
4023: hr_utility.set_location('pyusuiet',900);
4024: pay_db_pay_setup.create_defined_balance (
4025: p_balance_name => p_ele_name,
4026: p_balance_dimension => 'Person within Government Reporting Entity Quarter to Date',
4027: p_business_group_name => v_bg_name,
4026: p_balance_dimension => 'Person within Government Reporting Entity Quarter to Date',
4027: p_business_group_name => v_bg_name,
4028: p_legislation_code => NULL);
4029:
4030: hr_utility.set_location('pyusuiet',910);
4031: pay_db_pay_setup.create_defined_balance (
4032: p_balance_name => p_ele_name,
4033: p_balance_dimension => 'Person within Government Reporting Entity Year to Date',
4034: p_business_group_name => v_bg_name,
4033: p_balance_dimension => 'Person within Government Reporting Entity Year to Date',
4034: p_business_group_name => v_bg_name,
4035: p_legislation_code => NULL);
4036:
4037: hr_utility.set_location('pyusuiet',915);
4038: pay_db_pay_setup.create_defined_balance (
4039: p_balance_name => p_ele_name,
4040: p_balance_dimension => 'Person within Government Reporting Entity Month',
4041: p_business_group_name => v_bg_name,
4040: p_balance_dimension => 'Person within Government Reporting Entity Month',
4041: p_business_group_name => v_bg_name,
4042: p_legislation_code => NULL);
4043:
4044: hr_utility.set_location('pyusuiet',920);
4045: pay_db_pay_setup.create_defined_balance (
4046: p_balance_name => p_ele_name,
4047: p_balance_dimension => 'Government Reporting Entity Year to Date',
4048: p_business_group_name => v_bg_name,
4049: p_legislation_code => NULL);
4050:
4051: /* *** WWBug 133133 start *** */
4052: /* Adding defined balances for GRE_RUN and GRE_ITD for primary balance */
4053: hr_utility.set_location('pyusuiet',925);
4054: pay_db_pay_setup.create_defined_balance (
4055: p_balance_name => p_ele_name,
4056: p_balance_dimension => 'Government Reporting Entity Run',
4057: p_business_group_name => v_bg_name,
4058: p_legislation_code => NULL);
4059:
4060: IF p_ele_processing_type = 'R' THEN /* Not required for NR Elements */
4061:
4062: hr_utility.set_location('pyusuiet',930);
4063: pay_db_pay_setup.create_defined_balance (
4064: p_balance_name => p_ele_name,
4065: p_balance_dimension => 'Government Reporting Entity Inception to Date',
4066: p_business_group_name => v_bg_name,
4073: /* bug 1835350 begin
4074: IF UPPER(p_ele_classification) <> 'NON-PAYROLL PAYMENTS' THEN
4075: bug 1835350 end */
4076:
4077: hr_utility.set_location('pyusuiet',935);
4078: pay_db_pay_setup.create_defined_balance (
4079: p_balance_name => p_ele_name,
4080: p_balance_dimension => 'Payments',
4081: p_business_group_name => v_bg_name,
4080: p_balance_dimension => 'Payments',
4081: p_business_group_name => v_bg_name,
4082: p_legislation_code => NULL);
4083:
4084: hr_utility.set_location('pyusuiet',940);
4085: pay_db_pay_setup.create_defined_balance (
4086: p_balance_name => p_ele_name,
4087: p_balance_dimension => 'Assignment Payments',
4088: p_business_group_name => v_bg_name,
4091: /* bug 1835350 begin
4092: END IF;
4093: bug 1835350 end */
4094:
4095: hr_utility.trace('I before p_ele_processing_type ');
4096: hr_utility.trace('p_ele_processing_type is '||p_ele_processing_type);
4097:
4098: IF p_ele_processing_type = 'R' THEN
4099: hr_utility.set_location('pyusuiet',945);
4092: END IF;
4093: bug 1835350 end */
4094:
4095: hr_utility.trace('I before p_ele_processing_type ');
4096: hr_utility.trace('p_ele_processing_type is '||p_ele_processing_type);
4097:
4098: IF p_ele_processing_type = 'R' THEN
4099: hr_utility.set_location('pyusuiet',945);
4100: pay_db_pay_setup.create_defined_balance (
4095: hr_utility.trace('I before p_ele_processing_type ');
4096: hr_utility.trace('p_ele_processing_type is '||p_ele_processing_type);
4097:
4098: IF p_ele_processing_type = 'R' THEN
4099: hr_utility.set_location('pyusuiet',945);
4100: pay_db_pay_setup.create_defined_balance (
4101: p_balance_name => v_neg_earnbal_name,
4102: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
4103: p_business_group_name => v_bg_name,
4105: --
4106: END IF;
4107: --
4108: IF p_ele_processing_type = 'R' THEN /* Not required for NR Elements */
4109: hr_utility.set_location('pyusuiet',950);
4110: pay_db_pay_setup.create_defined_balance (
4111: p_balance_name => v_addl_amt_bal_name,
4112: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
4113: p_business_group_name => v_bg_name,
4112: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
4113: p_business_group_name => v_bg_name,
4114: p_legislation_code => NULL);
4115:
4116: hr_utility.set_location('pyusuiet',955);
4117: pay_db_pay_setup.create_defined_balance (
4118: p_balance_name => v_repl_amt_bal_name,
4119: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
4120: p_business_group_name => v_bg_name,
4128: 'HOURS_X_RATE_MULTIPLE_RECUR_V2',
4129: 'HOURS_X_RATE_MULTIPLE_NONRECUR_V2') THEN
4130:
4131:
4132: hr_utility.trace('I am inside the UPPER IN...HOURS X....');
4133: hr_utility.trace('p_ele_calc_ff_name is '||p_ele_calc_ff_name);
4134:
4135: -- Create "Hours" associated balance for this earning; _ASG_RUN dim.
4136: v_hrs_bal_name := SUBSTR(p_ele_name, 1, 73)||' Hours';
4129: 'HOURS_X_RATE_MULTIPLE_NONRECUR_V2') THEN
4130:
4131:
4132: hr_utility.trace('I am inside the UPPER IN...HOURS X....');
4133: hr_utility.trace('p_ele_calc_ff_name is '||p_ele_calc_ff_name);
4134:
4135: -- Create "Hours" associated balance for this earning; _ASG_RUN dim.
4136: v_hrs_bal_name := SUBSTR(p_ele_name, 1, 73)||' Hours';
4137: --v_hrs_bal_repname := SUBSTR(p_ele_reporting_name, 1, 23)||' Hours';
4135: -- Create "Hours" associated balance for this earning; _ASG_RUN dim.
4136: v_hrs_bal_name := SUBSTR(p_ele_name, 1, 73)||' Hours';
4137: --v_hrs_bal_repname := SUBSTR(p_ele_reporting_name, 1, 23)||' Hours';
4138:
4139: hr_utility.set_location('pyusuiet',960);
4140: v_hrs_bal_type_id := pay_db_pay_setup.create_balance_type(
4141: p_balance_name => v_hrs_bal_name,
4142: p_uom => null,
4143: p_uom_code => 'H_DECIMAL2',
4148: p_balance_category => l_bal_cat_classification, -- Bug 3311781
4149: p_bc_leg_code => 'US',
4150: p_effective_date => g_eff_start_date);
4151:
4152: hr_utility.set_location('pyusuiet',965);
4153: pay_db_pay_setup.create_defined_balance (
4154: p_balance_name => v_hrs_bal_name,
4155: p_balance_dimension => 'Assignment-Level Current Run',
4156: p_business_group_name => v_bg_name,
4155: p_balance_dimension => 'Assignment-Level Current Run',
4156: p_business_group_name => v_bg_name,
4157: p_legislation_code => NULL);
4158:
4159: hr_utility.set_location('pyusuiet',970);
4160: pay_db_pay_setup.create_defined_balance (
4161: p_balance_name => v_hrs_bal_name,
4162: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
4163: p_business_group_name => v_bg_name,
4164: p_legislation_code => NULL,
4165: p_save_run_bal => 'Y');
4166:
4167: -- 16th Feb 1996 Fix - added Payments defined bal to Hours assoc bal.
4168: hr_utility.set_location('pyusuiet',975);
4169: pay_db_pay_setup.create_defined_balance (
4170: p_balance_name => v_hrs_bal_name,
4171: p_balance_dimension => 'Payments',
4172: p_business_group_name => v_bg_name,
4171: p_balance_dimension => 'Payments',
4172: p_business_group_name => v_bg_name,
4173: p_legislation_code => NULL);
4174:
4175: hr_utility.set_location('pyusuiet',980);
4176: pay_db_pay_setup.create_defined_balance (
4177: p_balance_name => v_hrs_bal_name,
4178: p_balance_dimension => 'Assignment Quarter to Date',
4179: p_business_group_name => v_bg_name,
4178: p_balance_dimension => 'Assignment Quarter to Date',
4179: p_business_group_name => v_bg_name,
4180: p_legislation_code => NULL);
4181:
4182: hr_utility.set_location('pyusuiet',985);
4183: pay_db_pay_setup.create_defined_balance (
4184: p_balance_name => v_hrs_bal_name,
4185: p_balance_dimension => 'Assignment Year to Date',
4186: p_business_group_name => v_bg_name,
4185: p_balance_dimension => 'Assignment Year to Date',
4186: p_business_group_name => v_bg_name,
4187: p_legislation_code => NULL);
4188:
4189: hr_utility.set_location('pyusuiet',990);
4190: pay_db_pay_setup.create_defined_balance (
4191: p_balance_name => v_hrs_bal_name,
4192: p_balance_dimension => 'Assignment within Government Reporting Entity Quarter to Date',
4193: p_business_group_name => v_bg_name,
4198: p_balance_dimension => 'Assignment within Government Reporting Entity Year to Date',
4199: p_business_group_name => v_bg_name,
4200: p_legislation_code => NULL);
4201:
4202: hr_utility.set_location('pyusuiet',995);
4203: pay_db_pay_setup.create_defined_balance (
4204: p_balance_name => v_hrs_bal_name,
4205: p_balance_dimension => 'Assignment Payments',
4206: p_business_group_name => v_bg_name,
4210: -- Determine which earnings skip rule needed:
4211: -- Get skip rule formula id and pass it to create_element.
4212:
4213: IF UPPER(p_ele_classification) IN ('EARNINGS', 'IMPUTED EARNINGS') THEN
4214: hr_utility.set_location('pyusuiet',1000);
4215:
4216: hr_utility.trace('Element Classification is '|| p_ele_classification);
4217: --
4218: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4212:
4213: IF UPPER(p_ele_classification) IN ('EARNINGS', 'IMPUTED EARNINGS') THEN
4214: hr_utility.set_location('pyusuiet',1000);
4215:
4216: hr_utility.trace('Element Classification is '|| p_ele_classification);
4217: --
4218: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4219: --
4220: SELECT FF.formula_id
4227: AND p_ele_eff_start_date BETWEEN FF.effective_start_date
4228: AND FF.effective_end_date;
4229: --
4230: ELSIF UPPER(p_ele_classification) = 'SUPPLEMENTAL EARNINGS' THEN
4231: hr_utility.set_location('pyusuiet',1005);
4232: --
4233: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4234: --
4235: SELECT FF.formula_id
4248: --
4249: IF UPPER(p_ele_classification) = 'IMPUTED EARNINGS' AND
4250: p_ele_processing_type = 'N' THEN
4251:
4252: hr_utility.set_location('pyusuiet',1010);
4253: --
4254: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4255: --
4256: SELECT FF.formula_id
4273: IF UPPER(p_ele_calc_ff_name) NOT IN ( 'GROSS_UP_RECUR_V2',
4274: 'GROSS_UP_NONRECUR_V2')
4275: OR
4276: p_ele_calc_ff_name IS NULL THEN
4277: hr_utility.trace('This is inside p_ele_calc_ff_name not in gross_up...');
4278:
4279: hr_utility.set_location('pyusuiet',1015);
4280: v_ele_type_id := ins_uie_ele_type ( p_ele_name,
4281: p_ele_reporting_name,
4275: OR
4276: p_ele_calc_ff_name IS NULL THEN
4277: hr_utility.trace('This is inside p_ele_calc_ff_name not in gross_up...');
4278:
4279: hr_utility.set_location('pyusuiet',1015);
4280: v_ele_type_id := ins_uie_ele_type ( p_ele_name,
4281: p_ele_reporting_name,
4282: p_ele_description,
4283: p_ele_classification,
4291: v_bg_name,
4292: 'S'); -- process mode is S for the actual elements
4293:
4294: -- Need to find PRIMARY_CLASSIFICATION_ID of element type.
4295: hr_utility.set_location('pyusuiet',1020);
4296: select distinct(classification_id)
4297: into v_primary_class_id
4298: from pay_element_types_f
4299: where element_type_id = v_ele_type_id;
4297: into v_primary_class_id
4298: from pay_element_types_f
4299: where element_type_id = v_ele_type_id;
4300: --
4301: hr_utility.set_location('pyusuiet',1025);
4302: SELECT default_low_priority,
4303: default_high_priority
4304: INTO v_class_lo_priority,
4305: v_class_hi_priority
4312: ELSE
4313: l_ele_classification := p_ele_classification;
4314: END IF;
4315: --
4316: hr_utility.set_location('pyusuiet',1030);
4317: v_shadow_ele_name := SUBSTR(p_ele_name, 1, 61)||' Special Features';
4318: v_ele_repname := SUBSTR(p_ele_reporting_name, 1, 27)||' SF';
4319: v_shadow_ele_type_id := ins_uie_ele_type (
4320: v_shadow_ele_name,
4332: 'N'); -- process mode for Special Features should be 'N'
4333: --
4334:
4335: If p_ele_processing_type = 'R' then /* Not required for NR Elements */
4336: hr_utility.set_location('pyusuiet',1031);
4337: v_inputs_ele_name := SUBSTR(p_ele_name, 1, 61)||' Special Inputs';
4338: v_ele_repname := SUBSTR(p_ele_reporting_name, 1, 27)||' SI';
4339: v_inputs_ele_type_id := ins_uie_ele_type (
4340: v_inputs_ele_name,
4353:
4354: end if; /* Not required for NR Elements */
4355: --
4356: ELSE -- GrossUp element being created, need to create this one as "Info".
4357: hr_utility.set_location('pyusuiet',1032);
4358: SELECT classification_id,
4359: default_priority,
4360: default_low_priority,
4361: default_high_priority
4366: FROM pay_element_classifications
4367: WHERE classification_name = 'Information'
4368: AND nvl(business_group_id, p_bg_id) = p_bg_id;
4369: --
4370: hr_utility.set_location('pyusuiet',1033);
4371: v_ele_type_id := ins_uie_ele_type ( p_ele_name,
4372: p_ele_reporting_name,
4373: p_ele_description,
4374: 'Information',
4385: -- Set classification for future reference, call create_vertex_grossup w/this.
4386: --
4387: v_grossup_class_name := p_ele_classification;
4388: --
4389: hr_utility.set_location('pyusuiet',1034);
4390: v_info_payval_id := pay_db_pay_setup.create_input_value (
4391: p_element_name => p_ele_name,
4392: p_name => 'Pay Value',
4393: p_uom_code => 'M',
4404: p_business_group_name => v_bg_name,
4405: p_effective_start_date => g_eff_start_date,
4406: p_effective_end_date => g_eff_end_date);
4407: --
4408: hr_utility.set_location('pyusuiet',1035);
4409: hr_input_values.chk_input_value(
4410: p_element_type_id => v_ele_type_id,
4411: p_legislation_code => g_template_leg_code,
4412: p_val_start_date => g_eff_start_date,
4431: --
4432: --
4433: -- Commenting out this call to 3rd party inserts. Don't think it's needed.
4434: /*
4435: hr_utility.set_location('pyusuiet',1036);
4436: hr_input_values.ins_3p_input_values(
4437: p_val_start_date => g_eff_start_date,
4438: p_val_end_date => g_eff_end_date,
4439: p_element_type_id => v_eletype_id,
4456: --
4457: --
4458: -- Creating shadow element for gross up ele
4459: --
4460: hr_utility.set_location('pyusuiet',1037);
4461: v_shadow_ele_name := SUBSTR(p_ele_name, 1, 61)||' Special Features';
4462: v_ele_repname := SUBSTR(p_ele_reporting_name, 1, 27)||' SF';
4463: v_shadow_ele_type_id := ins_uie_ele_type (
4464: v_shadow_ele_name,
4474: g_eff_start_date,
4475: v_bg_name,
4476: 'N' ); -- process mode
4477:
4478: hr_utility.set_location('pyusuiet',1038);
4479:
4480: v_shadow_info_payval_id := pay_db_pay_setup.create_input_value (
4481: p_element_name => v_shadow_ele_name,
4482: p_name => 'Pay Value',
4494: p_business_group_name => v_bg_name,
4495: p_effective_start_date => g_eff_start_date,
4496: p_effective_end_date => g_eff_end_date);
4497:
4498: hr_utility.set_location('pyusuiet',1039);
4499: hr_input_values.chk_input_value(
4500: p_element_type_id => v_shadow_ele_type_id,
4501: p_legislation_code => g_template_leg_code,
4502: p_val_start_date => g_eff_start_date,
4523: --
4524:
4525: If p_ele_processing_type = 'R' then /* Not required for NR Elements */
4526:
4527: hr_utility.set_location('pyusuiet',1040);
4528: v_inputs_ele_name := SUBSTR(p_ele_name, 1, 61)||' Special Inputs';
4529: v_ele_repname := SUBSTR(p_ele_reporting_name, 1, 27)||' SI';
4530: v_inputs_ele_type_id := ins_uie_ele_type (
4531: v_inputs_ele_name,
4541: g_eff_start_date,
4542: v_bg_name,
4543: 'N' ); -- process mode
4544:
4545: hr_utility.set_location('pyusuiet',1045);
4546: v_inputs_info_payval_id := pay_db_pay_setup.create_input_value (
4547: p_element_name => v_inputs_ele_name,
4548: p_name => 'Pay Value',
4549: p_uom_code => 'M',
4560: p_business_group_name => v_bg_name,
4561: p_effective_start_date => g_eff_start_date,
4562: p_effective_end_date => g_eff_end_date);
4563:
4564: hr_utility.set_location('pyusuiet',1050);
4565: hr_input_values.chk_input_value(
4566: p_element_type_id => v_inputs_ele_type_id,
4567: p_legislation_code => g_template_leg_code,
4568: p_val_start_date => g_eff_start_date,
4621: -------------------------Insert Input Values --------------------------
4622: --
4623: -- Make insertion of all basic earnings input vals (ie. req'd for all
4624: -- earnings elements, not based on calc rule; instead on Class).
4625: hr_utility.set_location('pyusuiet',1055);
4626:
4627: ins_uie_input_vals ( v_ele_type_id,
4628: p_ele_name,
4629: v_shadow_ele_type_id,
4670: WHERE element_type_id = v_ele_type_id
4671: AND business_group_id = p_bg_id;
4672:
4673: -- So we need inpval_id of pay value for this element:
4674: hr_utility.set_location('pyusuiet',1060);
4675: v_payval_name := hr_input_values.get_pay_value_name(g_template_leg_code);
4676:
4677: hr_utility.set_location('pyusuiet',1065);
4678: select iv.input_value_id
4673: -- So we need inpval_id of pay value for this element:
4674: hr_utility.set_location('pyusuiet',1060);
4675: v_payval_name := hr_input_values.get_pay_value_name(g_template_leg_code);
4676:
4677: hr_utility.set_location('pyusuiet',1065);
4678: select iv.input_value_id
4679: into v_payval_id
4680: from pay_input_values_f iv
4681: where iv.element_type_id = v_ele_type_id
4687: -- 08 June 94: Don't need to anymore, payvalue's mandatory flag is set to
4688: -- 'X' (ie. Never enterable) after creation of element type.
4689: --
4690: /*
4691: hr_utility.set_location('pyusuiet',1066);
4692: SELECT formula_id
4693: INTO v_payval_formula_id
4694: FROM ff_formulas_f
4695: WHERE business_group_id IS NULL
4695: WHERE business_group_id IS NULL
4696: AND legislation_code = 'US'
4697: AND formula_name = 'PAYVALUE_VALIDATION';
4698:
4699: hr_utility.set_location('pyusuiet',1067);
4700: UPDATE pay_input_values_f
4701: SET formula_id = v_payval_formula_id,
4702: warning_or_error = 'E'
4703: WHERE input_value_id = v_payval_id;
4707: -- Note, there is a packaged function "chk_ins_balance_feed" in pybalnce.pkb.
4708: -- Since this is definitely a new balance feed for a new element and balance,
4709: -- there is no chance for duplicating an existing feed.
4710: --
4711: hr_utility.set_location('pyusuiet',1068);
4712:
4713: --
4714: -- check for existence of balance feed before creating...return bal feed id if already exists...
4715: --
4738: -- and Time Entry Wages.
4739: --
4740: IF p_ele_processing_type = 'R' THEN
4741:
4742: hr_utility.set_location('pyusuiet',1070);
4743: /*
4744: select iv.input_value_id
4745: into v_negearn_inpval_id
4746: from pay_input_values_f iv
4751: -- Now, insert feed.
4752: -- Note, there is a packaged function "chk_ins_balance_feed" in pybalnce.pkb.
4753: -- Since this is definitely a new balance feed for a new element and balance,
4754: -- there is no chance for duplicating an existing feed.
4755: hr_utility.set_location('pyusuiet',1075);
4756: hr_balances.ins_balance_feed(
4757: p_option => 'INS_MANUAL_FEED',
4758: p_input_value_id => g_neg_earn_inpval_id,
4759: p_element_type_id => NULL,
4769:
4770: --
4771: END IF;
4772: --
4773: hr_utility.set_location('pyusuiet',1080);
4774:
4775: If p_ele_processing_type = 'R' then /* Not required for NR Elements */
4776:
4777: /*
4787: -- Since this is definitely a new balance feed for a new element and balance,
4788: -- there is no chance for duplicating an existing feed.
4789:
4790:
4791: hr_utility.set_location('pyusuiet',1084);
4792: hr_balances.ins_balance_feed(
4793: p_option => 'INS_MANUAL_FEED',
4794: p_input_value_id => g_addl_inpval_id,
4795: p_element_type_id => NULL,
4802: p_business_group => p_bg_id,
4803: p_legislation_code => NULL,
4804: p_mode => 'USER');
4805:
4806: hr_utility.set_location('pyusuiet',1085);
4807: hr_balances.ins_balance_feed(
4808: p_option => 'INS_MANUAL_FEED',
4809: p_input_value_id => gi_addl_inpval_id,
4810: p_element_type_id => NULL,
4817: p_business_group => p_bg_id,
4818: p_legislation_code => NULL,
4819: p_mode => 'USER');
4820:
4821: hr_utility.set_location('pyusuiet',1086);
4822: /*
4823: select iv.input_value_id
4824: into g_repl_inpval_id
4825: from pay_input_values_f iv
4830: -- Now, insert feed.
4831: -- Note, there is a packaged function "chk_ins_balance_feed" in pybalnce.pkb.
4832: -- Since this is definitely a new balance feed for a new element and balance,
4833: -- there is no chance for duplicating an existing feed.
4834: hr_utility.set_location('pyusuiet',1090);
4835: hr_balances.ins_balance_feed(
4836: p_option => 'INS_MANUAL_FEED',
4837: p_input_value_id => g_repl_inpval_id,
4838: p_element_type_id => NULL,
4845: p_business_group => p_bg_id,
4846: p_legislation_code => NULL,
4847: p_mode => 'USER');
4848:
4849: hr_utility.set_location('pyusuiet',1095);
4850: hr_balances.ins_balance_feed(
4851: p_option => 'INS_MANUAL_FEED',
4852: p_input_value_id => gi_repl_inpval_id,
4853: p_element_type_id => NULL,
4875: AND
4876: UPPER(p_ele_category) = 'B'
4877: ) THEN
4878:
4879: hr_utility.set_location('pyusuiet',1100);
4880: SELECT balance_type_id
4881: INTO v_earn401k_bal_type_id
4882: FROM pay_balance_types
4883: WHERE balance_name = 'Earnings 401k'
4883: WHERE balance_name = 'Earnings 401k'
4884: AND business_group_id IS NULL
4885: AND legislation_code = 'US';
4886:
4887: hr_utility.set_location('pyusuiet',1105);
4888: hr_balances.ins_balance_feed(
4889: p_option => 'INS_MANUAL_FEED',
4890: p_input_value_id => v_payval_id,
4891: p_element_type_id => NULL,
4905: -- and p_flsa_hours.
4906:
4907: IF p_ele_ot_base = 'Y' THEN
4908:
4909: hr_utility.set_location('pyusuiet',1110);
4910:
4911: begin
4912:
4913: SELECT balance_type_id
4916: WHERE balance_name = 'FLSA Earnings'
4917: AND business_group_id IS NULL
4918: AND legislation_code = 'US';
4919:
4920: hr_utility.set_location('pyusuiet',1115);
4921: hr_balances.ins_balance_feed(
4922: p_option => 'INS_MANUAL_FEED',
4923: p_input_value_id => v_payval_id,
4924: p_element_type_id => NULL,
4935: exception
4936:
4937: when NO_DATA_FOUND then
4938:
4939: hr_utility.set_location('Could not find FLSA_Earnings balance.',1120);
4940:
4941: when TOO_MANY_ROWS then
4942:
4943: hr_utility.set_location('Too many STU FLSA_Earnings balances.',1125);
4939: hr_utility.set_location('Could not find FLSA_Earnings balance.',1120);
4940:
4941: when TOO_MANY_ROWS then
4942:
4943: hr_utility.set_location('Too many STU FLSA_Earnings balances.',1125);
4944:
4945: end;
4946:
4947: END IF;
4947: END IF;
4948:
4949: IF p_flsa_hours = 'Y' THEN
4950:
4951: hr_utility.set_location('pyusuiet',1130);
4952:
4953: begin
4954:
4955:
4959: WHERE balance_name = 'FLSA Hours'
4960: AND business_group_id IS NULL
4961: AND legislation_code = 'US';
4962:
4963: hr_utility.set_location('pyusuiet',1135);
4964: SELECT input_value_id
4965: INTO v_hrs_inpval_id
4966: FROM pay_input_values_f
4967: WHERE element_type_id = v_ele_type_id
4967: WHERE element_type_id = v_ele_type_id
4968: AND business_group_id = p_bg_id
4969: AND name = 'Hours';
4970:
4971: hr_utility.set_location('pyusuiet',1140);
4972: hr_balances.ins_balance_feed(
4973: p_option => 'INS_MANUAL_FEED',
4974: p_input_value_id => v_hrs_inpval_id,
4975: p_element_type_id => NULL,
4986: exception
4987:
4988: when NO_DATA_FOUND then
4989:
4990: hr_utility.set_location('Could not find FLSA_Hours bal or Hours inpval.',1145);
4991:
4992: when TOO_MANY_ROWS then
4993:
4994: hr_utility.set_location('Too many STU FLSA_Hours bals or Hours inpvals.',1150);
4990: hr_utility.set_location('Could not find FLSA_Hours bal or Hours inpval.',1145);
4991:
4992: when TOO_MANY_ROWS then
4993:
4994: hr_utility.set_location('Too many STU FLSA_Hours bals or Hours inpvals.',1150);
4995:
4996: end;
4997:
4998: END IF;
5006: -- Insert feed from "Hours" inpval to hours bal for this ele.
5007:
5008: -- begin
5009:
5010: hr_utility.set_location('pyusuiet',1155);
5011: SELECT input_value_id
5012: INTO v_hrs_inpval_id
5013: FROM pay_input_values_f
5014: WHERE element_type_id = v_ele_type_id
5014: WHERE element_type_id = v_ele_type_id
5015: AND business_group_id = p_bg_id
5016: AND name = 'Hours';
5017:
5018: hr_utility.set_location('pyusuiet',1160);
5019: hr_balances.ins_balance_feed(
5020: p_option => 'INS_MANUAL_FEED',
5021: p_input_value_id => v_hrs_inpval_id,
5022: p_element_type_id => NULL,
5034: exception
5035:
5036: when NO_DATA_FOUND then
5037:
5038: hr_utility.set_location('Could not find Hours inpval.',1170);
5039:
5040: when TOO_MANY_ROWS then
5041:
5042: hr_utility.set_location('Too many Hours inpvals.',1171);
5038: hr_utility.set_location('Could not find Hours inpval.',1170);
5039:
5040: when TOO_MANY_ROWS then
5041:
5042: hr_utility.set_location('Too many Hours inpvals.',1171);
5043:
5044: end;
5045: */
5046:
5059: where balance_name = 'Regular Hours Worked'
5060: and business_group_id is null
5061: and legislation_code = 'US';
5062:
5063: hr_utility.set_location('pyusuiet',1175);
5064: hr_balances.ins_balance_feed(
5065: p_option => 'INS_MANUAL_FEED',
5066: p_input_value_id => v_hrs_inpval_id,
5067: p_element_type_id => NULL,
5085: exception
5086:
5087: when NO_DATA_FOUND then
5088:
5089: hr_utility.set_location('Could not find Reg Hours Worked bal.',1180);
5090:
5091: when TOO_MANY_ROWS then
5092:
5093: hr_utility.set_location('Too many Reg Hours Worked bals.',1185);
5089: hr_utility.set_location('Could not find Reg Hours Worked bal.',1180);
5090:
5091: when TOO_MANY_ROWS then
5092:
5093: hr_utility.set_location('Too many Reg Hours Worked bals.',1185);
5094:
5095: end;
5096: */
5097:
5120: where upper(balance_name ) = 'REGULAR HOURS WORKED'
5121: and business_group_id is null
5122: and legislation_code = 'US';
5123: */
5124: hr_utility.set_location('pyusuiet',1190);
5125: hr_balances.ins_balance_feed(
5126: p_option => 'INS_MANUAL_FEED',
5127: p_input_value_id => g_reduce_hrs_inpval_id,
5128: p_element_type_id => NULL,
5138:
5139: /*
5140: exception
5141: when NO_DATA_FOUND then
5142: hr_utility.set_location('Could not find Regular Hours Worked bal.',1195);
5143: when TOO_MANY_ROWS then
5144: hr_utility.set_location('Too many Regular Hours Worked bals.',1200);
5145: end;
5146: */
5140: exception
5141: when NO_DATA_FOUND then
5142: hr_utility.set_location('Could not find Regular Hours Worked bal.',1195);
5143: when TOO_MANY_ROWS then
5144: hr_utility.set_location('Too many Regular Hours Worked bals.',1200);
5145: end;
5146: */
5147:
5148: -- begin
5155: where balance_name = 'Regular Salary Hours'
5156: and business_group_id is null
5157: and legislation_code = 'US';
5158:
5159: hr_utility.set_location('pyusuiet',1205);
5160: hr_balances.ins_balance_feed(
5161: p_option => 'INS_MANUAL_FEED',
5162: p_input_value_id => g_reduce_sal_hrs_inpval_id,
5163: p_element_type_id => NULL,
5173:
5174: /*
5175: exception
5176: when NO_DATA_FOUND then
5177: hr_utility.set_location('Could not find Regular Salary Hours bal.',170);
5178: when TOO_MANY_ROWS then
5179: hr_utility.set_location('Too many Regular Salary Hours bals.',170);
5180: end;
5181: */
5175: exception
5176: when NO_DATA_FOUND then
5177: hr_utility.set_location('Could not find Regular Salary Hours bal.',170);
5178: when TOO_MANY_ROWS then
5179: hr_utility.set_location('Too many Regular Salary Hours bals.',170);
5180: end;
5181: */
5182:
5183: -- begin
5190: where balance_name = 'Regular Wages Hours'
5191: and business_group_id is null
5192: and legislation_code = 'US';
5193:
5194: hr_utility.set_location('pyusuiet',1210);
5195: hr_balances.ins_balance_feed(
5196: p_option => 'INS_MANUAL_FEED',
5197: p_input_value_id => g_reduce_wag_hrs_inpval_id,
5198: p_element_type_id => NULL,
5208:
5209: /*
5210: exception
5211: when NO_DATA_FOUND then
5212: hr_utility.set_location('Could not find Regular Wages Hours bal.',170);
5213: when TOO_MANY_ROWS then
5214: hr_utility.set_location('Too many Regular Wages Hours bals.',170);
5215: end;
5216: */
5210: exception
5211: when NO_DATA_FOUND then
5212: hr_utility.set_location('Could not find Regular Wages Hours bal.',170);
5213: when TOO_MANY_ROWS then
5214: hr_utility.set_location('Too many Regular Wages Hours bals.',170);
5215: end;
5216: */
5217:
5218: -- Create feeds to all bals fed by RegSal and Wages pay values.
5258:
5259: recinfo chk_for_lock%ROWTYPE;
5260:
5261: BEGIN
5262: hr_utility.set_location('pyusuiet',1220);
5263: OPEN chk_for_lock;
5264: FETCH chk_for_lock INTO recinfo;
5265: CLOSE chk_for_lock;
5266:
5265: CLOSE chk_for_lock;
5266:
5267: -- Note: Not checking eff dates.
5268:
5269: hr_utility.set_location('pyusuiet',1225);
5270: IF ( ( (recinfo.element_type_id = p_ele_type_id)
5271: OR (recinfo.element_type_id IS NULL AND p_ele_type_id IS NULL))
5272: -- AND ( (recinfo.effective_start_date = fnd_date.canonical_to_date(p_ele_eff_start_date))
5273: -- OR (recinfo.effective_start_date IS NULL
5295: AND ( (recinfo.standard_link_flag = p_ele_standard_link)
5296: OR (recinfo.standard_link_flag IS NULL
5297: AND p_ele_standard_link IS NULL)))
5298: THEN
5299: hr_utility.set_location('pyusuiet',1230);
5300: RETURN;
5301: ELSE
5302: hr_utility.set_location('pyusuiet',151);
5303: hr_utility.set_message(801,'HR_51026_HR_LOCKED_OBJ');
5298: THEN
5299: hr_utility.set_location('pyusuiet',1230);
5300: RETURN;
5301: ELSE
5302: hr_utility.set_location('pyusuiet',151);
5303: hr_utility.set_message(801,'HR_51026_HR_LOCKED_OBJ');
5304: hr_utility.raise_error;
5305:
5306: -- FND_MESSAGE.SET_NAME('FND',
5299: hr_utility.set_location('pyusuiet',1230);
5300: RETURN;
5301: ELSE
5302: hr_utility.set_location('pyusuiet',151);
5303: hr_utility.set_message(801,'HR_51026_HR_LOCKED_OBJ');
5304: hr_utility.raise_error;
5305:
5306: -- FND_MESSAGE.SET_NAME('FND',
5307: -- 'FORM_RECORD_CHANGED_BY_ANOTHER_USER');
5300: RETURN;
5301: ELSE
5302: hr_utility.set_location('pyusuiet',151);
5303: hr_utility.set_message(801,'HR_51026_HR_LOCKED_OBJ');
5304: hr_utility.raise_error;
5305:
5306: -- FND_MESSAGE.SET_NAME('FND',
5307: -- 'FORM_RECORD_CHANGED_BY_ANOTHER_USER');
5308: -- APP_EXCEPTION.RAISE_EXCEPTION;
5373: OPEN get_formulae;
5374: LOOP
5375: FETCH get_formulae INTO v_ff_id;
5376: EXIT WHEN get_formulae%NOTFOUND;
5377: hr_utility.set_location('pyusuidt',1235);
5378:
5379: DELETE FROM ff_formulas_f
5380: WHERE formula_id = v_ff_id;
5381:
5399:
5400: END LOOP;
5401: CLOSE get_formulae;
5402:
5403: hr_utility.set_location('pyusuiet',1240);
5404:
5405: begin
5406:
5407: SELECT status_processing_rule_id
5408: INTO v_spr_id
5409: FROM pay_status_processing_rules_f
5410: WHERE element_type_id = p_ele_type_id;
5411:
5412: hr_utility.set_location('pyusuiet',1245);
5413: hr_elements.del_status_processing_rules(
5414: p_element_type_id => p_ele_type_id,
5415: p_delete_mode => v_del_mode,
5416: p_val_session_date => v_del_sess_date,
5427: OPEN get_inpvals;
5428: LOOP
5429: FETCH get_inpvals INTO v_inpval_id;
5430: EXIT WHEN get_inpvals%NOTFOUND;
5431: hr_utility.set_location('pyusuiet',1250);
5432: DELETE FROM pay_formula_result_rules_f
5433: WHERE input_value_id = v_inpval_id;
5434: END LOOP;
5435: CLOSE get_inpvals;
5464: exception when NO_DATA_FOUND then
5465: null;
5466: end;
5467:
5468: hr_utility.set_location('pyusuiet',1255);
5469: hr_elements.chk_del_element_type (
5470: p_mode => v_del_mode,
5471: p_element_type_id => p_ele_type_id,
5472: p_processing_priority => p_ele_priority,
5473: p_session_date => v_del_sess_date,
5474: p_val_start_date => v_del_val_start,
5475: p_val_end_date => v_del_val_end);
5476:
5477: hr_utility.set_location('pyusuiet',1256);
5478: hr_elements.del_3p_element_type (
5479: p_element_type_id => p_ele_type_id,
5480: p_delete_mode => v_del_mode,
5481: p_val_session_date => v_del_sess_date,
5483: p_val_end_date => v_del_val_end,
5484: p_startup_mode => v_startup_mode);
5485:
5486: -- Delete element type record:
5487: hr_utility.set_location('pyusuiet',1257);
5488: delete from PAY_ELEMENT_TYPES_F
5489: where element_type_id = p_ele_type_id;
5490:
5491: --
5496:
5497: -- Primary Balance
5498: IF p_ele_info_10 IS NOT NULL THEN
5499:
5500: hr_utility.set_location('pyusuiet',1260);
5501: hr_balances.del_balance_type_cascade (
5502: p_balance_type_id => fnd_number.canonical_to_number(p_ele_info_10),
5503: p_legislation_code => g_template_leg_code,
5504: p_mode => v_del_mode);
5502: p_balance_type_id => fnd_number.canonical_to_number(p_ele_info_10),
5503: p_legislation_code => g_template_leg_code,
5504: p_mode => v_del_mode);
5505:
5506: hr_utility.set_location('pyusuiet',1261);
5507: delete from PAY_BALANCE_TYPES
5508: where balance_type_id = fnd_number.canonical_to_number(p_ele_info_10);
5509:
5510: END IF;
5511:
5512: -- Hours Balance
5513: IF p_ele_info_12 IS NOT NULL THEN
5514:
5515: hr_utility.set_location('pyusuiet', 1262);
5516: hr_balances.del_balance_type_cascade (
5517: p_balance_type_id => fnd_number.canonical_to_number(p_ele_info_12),
5518: p_legislation_code => g_template_leg_code,
5519: p_mode => v_del_mode);
5517: p_balance_type_id => fnd_number.canonical_to_number(p_ele_info_12),
5518: p_legislation_code => g_template_leg_code,
5519: p_mode => v_del_mode);
5520:
5521: hr_utility.set_location('pyusuiet', 1263);
5522: DELETE FROM pay_balance_types
5523: WHERE balance_type_id = fnd_number.canonical_to_number(p_ele_info_12);
5524:
5525: END IF;
5525: END IF;
5526:
5527: v_negearn_bal_name := p_ele_name || ' Neg Earnings';
5528: v_negearn_bal_name := SUBSTR(v_negearn_bal_name, 1, 80);
5529: hr_utility.set_location('pyusuiet',162);
5530:
5531: begin
5532:
5533: hr_utility.set_location('pyusuiet',1264);
5529: hr_utility.set_location('pyusuiet',162);
5530:
5531: begin
5532:
5533: hr_utility.set_location('pyusuiet',1264);
5534: --
5535: -- 633443, added missing bussiness_group_id condition.mlisieck 28/02/98.
5536: --
5537: -- Bug 3349586 - removed 'upper' to improve performance.
5541: from pay_balance_types
5542: where balance_name = v_negearn_bal_name and
5543: business_group_id + 0 = p_business_group_id ;
5544:
5545: hr_utility.set_location('pyusuiet',164);
5546: hr_balances.del_balance_type_cascade (
5547: p_balance_type_id => v_negearn_bal_type_id,
5548: p_legislation_code => g_template_leg_code,
5549: p_mode => v_del_mode);
5547: p_balance_type_id => v_negearn_bal_type_id,
5548: p_legislation_code => g_template_leg_code,
5549: p_mode => v_del_mode);
5550:
5551: hr_utility.set_location('pyusuiet',1265);
5552: delete from PAY_BALANCE_TYPES
5553: where balance_type_id = v_negearn_bal_type_id;
5554:
5555: exception when NO_DATA_FOUND then
5557: end;
5558:
5559: v_addl_bal_name := p_ele_name || ' Additional';
5560: v_addl_bal_name := SUBSTR(v_addl_bal_name, 1, 80);
5561: hr_utility.set_location('pyusuiet',1266);
5562:
5563: begin
5564: --
5565: -- 633443, added missing bussiness_group_id condition.mlisieck 28/02/98.
5566: --
5567: -- Bug 3349586 - removed 'upper' to improve performance.
5568: --
5569:
5570: hr_utility.set_location('pyusuiet',1267);
5571: select balance_type_id
5572: into v_addl_bal_type_id
5573: from pay_balance_types
5574: where balance_name = v_addl_bal_name and
5573: from pay_balance_types
5574: where balance_name = v_addl_bal_name and
5575: business_group_id + 0 = p_business_group_id ;
5576:
5577: hr_utility.set_location('pyusuiet',1268);
5578: hr_balances.del_balance_type_cascade (
5579: p_balance_type_id => v_addl_bal_type_id,
5580: p_legislation_code => g_template_leg_code,
5581: p_mode => v_del_mode);
5579: p_balance_type_id => v_addl_bal_type_id,
5580: p_legislation_code => g_template_leg_code,
5581: p_mode => v_del_mode);
5582:
5583: hr_utility.set_location('pyusuiet',1268);
5584: delete from PAY_BALANCE_TYPES
5585: where balance_type_id = v_addl_bal_type_id;
5586:
5587: exception when NO_DATA_FOUND then
5589: end;
5590:
5591: v_repl_bal_name := p_ele_name || ' Replacement';
5592: v_repl_bal_name := SUBSTR(v_repl_bal_name, 1, 80);
5593: hr_utility.set_location('pyusuiet',1269);
5594:
5595: begin
5596:
5597: --
5599: --
5600: -- Bug 3349586 - removed 'upper' to improve performance.
5601: --
5602:
5603: hr_utility.set_location('pyusuiet',1270);
5604: select balance_type_id
5605: into v_repl_bal_type_id
5606: from pay_balance_types
5607: where balance_name = v_repl_bal_name and
5606: from pay_balance_types
5607: where balance_name = v_repl_bal_name and
5608: business_group_id + 0 = p_business_group_id ;
5609:
5610: hr_utility.set_location('pyusuiet',1275);
5611: hr_balances.del_balance_type_cascade (
5612: p_balance_type_id => v_repl_bal_type_id,
5613: p_legislation_code => g_template_leg_code,
5614: p_mode => v_del_mode);
5612: p_balance_type_id => v_repl_bal_type_id,
5613: p_legislation_code => g_template_leg_code,
5614: p_mode => v_del_mode);
5615:
5616: hr_utility.set_location('pyusuiet',1280);
5617: delete from PAY_BALANCE_TYPES
5618: where balance_type_id = v_repl_bal_type_id;
5619:
5620: exception when NO_DATA_FOUND then
5623:
5624: --
5625: -- Delete Shadow element...
5626: --
5627: hr_utility.set_location('pyusuiet',1285);
5628: hr_elements.chk_del_element_type (
5629: p_mode => v_del_mode,
5630: p_element_type_id => v_shadow_eletype_id,
5631: p_processing_priority => v_shadow_ele_priority,
5632: p_session_date => v_del_sess_date,
5633: p_val_start_date => v_del_val_start,
5634: p_val_end_date => v_del_val_end);
5635:
5636: hr_utility.set_location('pyusuiet',1290);
5637: hr_elements.del_3p_element_type (
5638: p_element_type_id => v_shadow_eletype_id,
5639: p_delete_mode => v_del_mode,
5640: p_val_session_date => v_del_sess_date,
5641: p_val_start_date => v_del_val_start,
5642: p_val_end_date => v_del_val_end,
5643: p_startup_mode => v_startup_mode);
5644:
5645: hr_utility.set_location('pyusuiet',1295);
5646: delete from PAY_ELEMENT_TYPES_F
5647: where element_type_id = v_shadow_eletype_id;
5648:
5649: --
5648:
5649: --
5650: -- Delete Special Inputs element...
5651: --
5652: hr_utility.set_location('pyusuiet',1300);
5653: hr_elements.chk_del_element_type (
5654: p_mode => v_del_mode,
5655: p_element_type_id => v_inputs_eletype_id,
5656: p_processing_priority => v_inputs_ele_priority,
5657: p_session_date => v_del_sess_date,
5658: p_val_start_date => v_del_val_start,
5659: p_val_end_date => v_del_val_end);
5660:
5661: hr_utility.set_location('pyusuiet',1305);
5662: hr_elements.del_3p_element_type (
5663: p_element_type_id => v_inputs_eletype_id,
5664: p_delete_mode => v_del_mode,
5665: p_val_session_date => v_del_sess_date,
5666: p_val_start_date => v_del_val_start,
5667: p_val_end_date => v_del_val_end,
5668: p_startup_mode => v_startup_mode);
5669:
5670: hr_utility.set_location('pyusuiet',1310);
5671: delete from PAY_ELEMENT_TYPES_F
5672: where element_type_id = v_inputs_eletype_id;
5673: --
5674: EXCEPTION