[Home] [Help]
1: package body hr_us_garn_gen as
2: /*$Header: pywatgen.pkb 120.1.12000000.1 2007/01/18 03:19:40 appldev noship $*/
3:
4: /*
5: +======================================================================+
873: -- Call function to check existence of formula to get id.
874: -- Get original formula id, name, and text for this element currently,
875: -- ie. before putting in new ff text.
876:
877: hr_utility.set_location('hr_us_garn_gen.ins_formula',20);
878:
879: already_exists := hr_template_existence.ele_ff_exists(
880: p_ele_name => p_ff_ele_name,
881: p_bg_id => p_ff_bg_id,
896:
897: --
898: -- Insert the new formula into current business group:
899: --
900: hr_utility.set_location('hr_us_garn_gen.ins_formula',40);
901: INSERT INTO ff_formulas_f (
902: FORMULA_ID,
903: EFFECTIVE_START_DATE,
904: EFFECTIVE_END_DATE,
936: -- Element already has formula attached via stat proc rule...
937: -- original formula name and text have been populated as outputs
938: -- from check for existence.
939:
940: hr_utility.set_location('hr_us_garn_gen.ins_formula',50);
941:
942: v_new_ele_formula_id := already_exists;
943: v_new_ele_formula_name := v_orig_ele_formula_name;
944:
946:
947: -- dbms_output.put_line('existing FF '||v_new_ele_formula_id||' being updated');
948: -- dbms_output.put_line(v_new_ele_formula_name);
949:
950: hr_utility.set_location('hr_us_garn_gen.ins_formula',70);
951:
952: UPDATE ff_formulas_f
953: SET formula_text = v_new_ele_formula_text
954: WHERE formula_id = v_new_ele_formula_id
972: and fff.legislation_code = 'US'
973: and ffft.formula_type_name = 'Oracle Payroll'
974: and ffft.formula_type_id = fff.formula_type_id;
975:
976: hr_utility.set_location('hr_us_garn_gen.ins_formula',35);
977:
978: hr_utility.trace('Preserving text for formula '||v_orig_ele_formula_name ||
979: ' for BG ' || p_ff_bg_id);
980:
982: v_orig_ele_formula_name := substr(v_orig_ele_formula_name,1,80);
983:
984: hr_utility.trace('Text saved in formula named '||v_orig_ele_formula_name);
985:
986: hr_utility.set_location('hr_us_garn_gen.ins_formula',30);
987:
988: SELECT ff_formulas_s.nextval
989: INTO v_orig_ele_formula_id
990: FROM sys.dual;
988: SELECT ff_formulas_s.nextval
989: INTO v_orig_ele_formula_id
990: FROM sys.dual;
991:
992: hr_utility.set_location('hr_us_garn_gen.ins_formula',40);
993:
994: INSERT INTO ff_formulas_f ( FORMULA_ID,
995: EFFECTIVE_START_DATE,
996: EFFECTIVE_END_DATE,
5152: -- Do not allow direct deletion of any associated element, these will be
5153: -- deleted by deleting the "base" ele.
5154: --
5155: IF p_ele_name like '% Special Features' THEN
5156: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5157: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5158: hr_utility.raise_error;
5159: END IF;
5160: --
5160: --
5161: -- Do not allow deletion of Special Inputs ele, delete by deleting base ele:
5162: --
5163: IF p_ele_name like '% Special Inputs' THEN
5164: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5165: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5166: hr_utility.raise_error;
5167: END IF;
5168: --
5168: --
5169: -- Do not allow deletion of Calculator element, delete by deleting base ele:
5170: --
5171: IF p_ele_name like '% Calculator' THEN
5172: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5173: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5174: hr_utility.raise_error;
5175: END IF;
5176: --
5176: --
5177: -- Do not allow deletion of Verifier element, delete by deleting base ele:
5178: --
5179: IF p_ele_name like '% Verifier' THEN
5180: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5181: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5182: hr_utility.raise_error;
5183: END IF;
5184: --
5184: --
5185: -- Do not allow deletion of Fees element, delete by deleting base ele:
5186: --
5187: IF p_ele_name like '% Fees' THEN
5188: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5189: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5190: hr_utility.raise_error;
5191: END IF;
5192:
5190: hr_utility.raise_error;
5191: END IF;
5192:
5193: IF p_ele_name like '% Priority' THEN
5194: hr_utility.set_location('hr_us_garn_gen.delete_dedn',40);
5195: hr_utility.set_message(801,'PAY_xxxx_CANNOT_DEL_ELE');
5196: hr_utility.raise_error;
5197: END IF;
5198: --
5287:
5288: FETCH get_spr INTO v_spr_id;
5289: EXIT WHEN get_spr%NOTFOUND;
5290:
5291: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 10);
5292: hr_elements.del_status_processing_rules(
5293: p_element_type_id => assoc_eles(i),
5294: p_delete_mode => v_del_mode,
5295: p_val_session_date => v_del_sess_date,
5354: FOR i in 1..l_num_assoc_bals LOOP
5355:
5356: IF assoc_bals(i) IS NOT NULL THEN
5357:
5358: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 50);
5359: hr_balances.del_balance_type_cascade (
5360: p_balance_type_id => assoc_bals(i),
5361: p_legislation_code => g_template_leg_code,
5362: p_mode => v_del_mode);
5360: p_balance_type_id => assoc_bals(i),
5361: p_legislation_code => g_template_leg_code,
5362: p_mode => v_del_mode);
5363:
5364: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 60);
5365: DELETE FROM pay_balance_types
5366: WHERE balance_type_id = assoc_bals(i);
5367:
5368: END IF;
5385: where element_type_id = assoc_eles(j)
5386: and v_del_sess_date between effective_start_date
5387: and effective_end_date;
5388:
5389: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 20);
5390: hr_elements.chk_del_element_type (
5391: p_mode => v_del_mode,
5392: p_element_type_id => assoc_eles(j),
5393: p_processing_priority => v_assoc_ele_priority,
5394: p_session_date => v_del_sess_date,
5395: p_val_start_date => v_del_val_start,
5396: p_val_end_date => v_del_val_end);
5397:
5398: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 30);
5399: hr_elements.del_3p_element_type (
5400: p_element_type_id => assoc_eles(j),
5401: p_delete_mode => v_del_mode,
5402: p_val_session_date => v_del_sess_date,
5406: --
5407: -- Delete element type record:
5408: -- Remember, we're 'ZAP'ing, no need to worry about date-effective delete.
5409: --
5410: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 35);
5411: delete from PAY_ELEMENT_TYPES_F
5412: where element_type_id = assoc_eles(j);
5413:
5414: END IF;
5427:
5428: -- Check if the element to be deleted was created using CORE template. If yes
5429: -- delete the template created while creating the element.
5430: if v_template_id is not null then
5431: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 45);
5432: -- Bug 4680388
5433: -- Modified the code to use delete_user_structure
5434: pay_element_template_api.delete_user_structure(
5435: p_drop_formula_packages => TRUE
5438:
5439:
5440: END delete_dedn;
5441:
5442: END hr_us_garn_gen;