1: PACKAGE BODY PAY_US_BALANCE_FEEDS_HOOK AS
2: /* $Header: pyuspbfr.pkb 120.0 2006/03/05 22:08:37 rdhingra noship $ */
3: /*
4: ******************************************************************
5: * *
16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : PAY_US_BALANCE_FEEDS_HOOK
21: File Name : pyuspbfr.pkb
22:
23: Description : This package is called from the AFTER INSERT/UPDATE
24: User Hooks. The following are the functionalities present
98: lv_defined_bal_status VARCHAR2(1);
99: ln_element_type_id NUMBER;
100:
101: BEGIN
102: hr_utility.trace('Entering PAY_US_BALANCE_FEEDS_HOOK.INSERT_TIMEDEF_TYPE');
103:
104: /*Initialize local variables*/
105: lv_defined_bal_status := 'N';
106: ln_element_type_id := NULL;
136: END IF;
137: CLOSE get_defined_bal_status;
138:
139:
140: hr_utility.trace('Leaving PAY_US_BALANCE_FEEDS_HOOK.INSERT_TIMEDEF_TYPE');
141: END INSERT_TIMEDEF_TYPE;
142:
143:
144: /******************************************************************************
156: ,p_legislation_code IN VARCHAR2 DEFAULT NULL
157: ) IS
158: BEGIN
159:
160: hr_utility.trace('Entering PAY_US_BALANCE_FEEDS_HOOK.INSERT_USER_HOOK');
161:
162: -- Call INSERT_TIMEDEF_TYPE
163: -- The local procedure inserts time_definition_type as 'G' in pay_element_types_f
164: -- whenever that element feeds a balance for which defined balance exists with dimensions:
172: ,p_legislation_code => p_legislation_code
173: );
174:
175:
176: hr_utility.trace('Leaving PAY_US_BALANCE_FEEDS_HOOK.INSERT_USER_HOOK');
177: END INSERT_USER_HOOK;
178:
179: -----------------------------INSERT SECTION ENDS HERE--------------------------
180:
178:
179: -----------------------------INSERT SECTION ENDS HERE--------------------------
180:
181:
182: END PAY_US_BALANCE_FEEDS_HOOK;