APPS.PAY_US_BALANCE_FEEDS_HOOK dependencies on HR_UTILITY

Line 102: hr_utility.trace('Entering PAY_US_BALANCE_FEEDS_HOOK.INSERT_TIMEDEF_TYPE');

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;

Line 114: hr_utility.trace('No required defined balance exists');

110: ,p_business_group_id
111: );
112: FETCH get_defined_bal_status INTO lv_defined_bal_status;
113: IF ((get_defined_bal_status%NOTFOUND) OR (lv_defined_bal_status = 'N')) THEN
114: hr_utility.trace('No required defined balance exists');
115: ELSE
116: /*Get the element_type_id to update*/
117: OPEN get_element_type_id(p_input_value_id
118: ,p_business_group_id

Line 123: hr_utility.trace('No required element_type_id exists');

119: ,p_effective_date
120: );
121: FETCH get_element_type_id INTO ln_element_type_id;
122: IF ((get_element_type_id%NOTFOUND) OR (ln_element_type_id IS NULL)) THEN
123: hr_utility.trace('No required element_type_id exists');
124: ELSE
125: /*Update the time_definition_type to G for the element found above*/
126: UPDATE pay_element_types_f
127: SET time_definition_type = 'G'

Line 140: hr_utility.trace('Leaving PAY_US_BALANCE_FEEDS_HOOK.INSERT_TIMEDEF_TYPE');

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: /******************************************************************************

Line 160: hr_utility.trace('Entering PAY_US_BALANCE_FEEDS_HOOK.INSERT_USER_HOOK');

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:

Line 176: hr_utility.trace('Leaving PAY_US_BALANCE_FEEDS_HOOK.INSERT_USER_HOOK');

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: