[Home] [Help]
195: create_reduce_regpay_feeds procedure to not
196: return balance that are fed via the
197: element classification balance feeder
198: processes.
199: 21-DEC-2001 ahanda 115.15 1902232 Changed insert into ff_formulas_f
200: to insert null for legislation_code.
201: 22-JAN-2002 ahanda 115.16 Added call to create_defined_balance
202: ID for 'Assignment Payments' dimension.
203:
494: v_formula_name := UPPER(p_amt_rule);
495:
496: -- Bug 3349586 - Condition for formula_id added to improve performance.
497: --
498: -- Bug 3768726 - Index FF_FORMULAS_F_UK2 is modified for bug 3768764. So ff.formula_id >= 0 is not needed.
499:
500: SELECT FF.formula_text, FF.formula_type_id
501: INTO v_skeleton_formula_text, v_skeleton_formula_type_id
502: FROM ff_formulas_f FF
498: -- Bug 3768726 - Index FF_FORMULAS_F_UK2 is modified for bug 3768764. So ff.formula_id >= 0 is not needed.
499:
500: SELECT FF.formula_text, FF.formula_type_id
501: INTO v_skeleton_formula_text, v_skeleton_formula_type_id
502: FROM ff_formulas_f FF
503: WHERE FF.formula_name = v_formula_name --UPPER(FF.formula_name) = UPPER(p_amt_rule)
504: AND FF.business_group_id IS NULL
505: AND FF.legislation_code = 'US'
506: AND g_eff_start_date BETWEEN FF.effective_start_date
525: INTO v_formula_id
526: FROM sys.dual;
527: --
528: hr_utility.set_location('hr_user_init_earn.ins_formula',40);
529: INSERT INTO ff_formulas_f (
530: FORMULA_ID,
531: EFFECTIVE_START_DATE,
532: EFFECTIVE_END_DATE,
533: BUSINESS_GROUP_ID,
2079:
2080: hr_utility.set_location('pyusuiet',465);
2081: SELECT formula_id
2082: INTO v_val_formula_id
2083: FROM ff_formulas_f
2084: WHERE business_group_id IS NULL
2085: AND legislation_code = 'US'
2086: AND formula_name = 'JURISDICTION_VALIDATION';
2087: --
4216: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4217: --
4218: SELECT FF.formula_id
4219: INTO v_skip_formula_id
4220: FROM ff_formulas_f FF
4221: WHERE FF.formula_name = 'REGULAR_EARNINGS'
4222: AND FF.formula_id >= 0
4223: AND FF.business_group_id IS NULL
4224: AND legislation_code = g_template_leg_code
4231: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4232: --
4233: SELECT FF.formula_id
4234: INTO v_skip_formula_id
4235: FROM ff_formulas_f FF
4236: WHERE FF.formula_name = 'SUPPLEMENTAL_EARNINGS'
4237: AND FF.formula_id >= 0
4238: AND FF.business_group_id IS NULL
4239: AND legislation_code = g_template_leg_code
4252: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4253: --
4254: SELECT FF.formula_id
4255: INTO v_skip_formula_id
4256: FROM ff_formulas_f FF
4257: WHERE FF.formula_name = 'SUPPLEMENTAL_EARNINGS'
4258: AND FF.formula_id >= 0
4259: AND FF.business_group_id IS NULL
4260: AND legislation_code = g_template_leg_code
4688: /*
4689: hr_utility.set_location('pyusuiet',1066);
4690: SELECT formula_id
4691: INTO v_payval_formula_id
4692: FROM ff_formulas_f
4693: WHERE business_group_id IS NULL
4694: AND legislation_code = 'US'
4695: AND formula_name = 'PAYVALUE_VALIDATION';
4696:
5363: v_del_val_start := nvl(p_del_val_start_date, sysdate);
5364: v_del_sess_date := nvl(p_del_sess_date, sysdate);
5365: --
5366: -- Get formula_ids to delete from various tables:
5367: -- FF_FORMULAS_F
5368: -- FF_FDI_USAGES_F
5369: -- FF_COMPILED_INFO_F
5370: --
5371: OPEN get_formulae;
5373: FETCH get_formulae INTO v_ff_id;
5374: EXIT WHEN get_formulae%NOTFOUND;
5375: hr_utility.set_location('pyusuidt',1235);
5376:
5377: DELETE FROM ff_formulas_f
5378: WHERE formula_id = v_ff_id;
5379:
5380: begin
5381: