[Home] [Help]
1: PACKAGE BODY hr_user_init_earn AS
2: /* $Header: pyusuiet.pkb 120.2 2005/09/23 00:04:53 saurgupt noship $ */
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
486: v_formula_name VARCHAR2(80);
487:
488: BEGIN
489:
490: hr_utility.set_location('hr_user_init_earn.ins_formula',10);
491:
492: -- Bug 3768726 - With this, the upper clause will be removed from the first condition in query.
493:
494: v_formula_name := UPPER(p_amt_rule);
507: AND FF.effective_end_date;
508: --
509: -- Replace element name placeholders with current element name:
510:
511: hr_utility.set_location('hr_user_init_earn.ins_formula',15);
512: v_ele_name := REPLACE(LTRIM(RTRIM(UPPER(p_ff_ele_name))),' ','_');
513: --
514: v_ele_formula_text := REPLACE( v_skeleton_formula_text,
515: '
519: --
520: -- Insert the new formula into current business goup:
521: -- Get new id
522:
523: hr_utility.set_location('hr_user_init_earn.ins_formula',30);
524: SELECT ff_formulas_s.nextval
525: INTO v_formula_id
526: FROM sys.dual;
527: --
524: SELECT ff_formulas_s.nextval
525: INTO v_formula_id
526: FROM sys.dual;
527: --
528: hr_utility.set_location('hr_user_init_earn.ins_formula',40);
529: INSERT INTO ff_formulas_f (
530: FORMULA_ID,
531: EFFECTIVE_START_DATE,
532: EFFECTIVE_END_DATE,
5680:
5681: END do_deletions; -- Del recs according to lockladder.
5682: --
5683: --
5684: END hr_user_init_earn;