[Home] [Help]
1: PACKAGE BODY hr_user_init_earn AS
2: /* $Header: pyusuiet.pkb 120.3 2011/12/21 04:19:10 emunisek ship $ */
3: /*******************************************************************
4: * *
5: * Copyright (C) 1993 Oracle Corporation. *
252: 20-MAY-2004 meshah 115.33 removed the logic not required for
253: Non-Recurring elements. Like creation of
254: additional and replacement defined balances.
255: 03-FEB-2005 RMONGE 115.34 Bug 4134473.
256: Modified package hr_user_init_earn to null out
257: the default values of local variables
258: v_lkp_type and v_dflt_value before calling
259: 'pay_db_pay_setup.create_input_value.
260: This applies to the following Input Values
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,
5682:
5683: END do_deletions; -- Del recs according to lockladder.
5684: --
5685: --
5686: END hr_user_init_earn;