APPS.PER_IE_TERMINATION dependencies on HR_UTILITY

Line 49: hr_utility.set_location(

45: paye and prsi tables to final process date.
46: final process date is not available in this user hook.
47: so created another user use which is called by FINAL_PROCESS_DATE
48: */
49: hr_utility.set_location(
50: 'Entering pay_ie_termination ....'|| 'per_ie_termination',
51: 10);
52: hr_utility.set_location(
53: 'Leaving pay_ie_termination ....'|| 'per_ie_termination',

Line 52: hr_utility.set_location(

48: */
49: hr_utility.set_location(
50: 'Entering pay_ie_termination ....'|| 'per_ie_termination',
51: 10);
52: hr_utility.set_location(
53: 'Leaving pay_ie_termination ....'|| 'per_ie_termination',
54: 10);
55: EXCEPTION
56: WHEN OTHERS

Line 108: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN

104: BEGIN
105:
106:
107: /* Added for GSI Bug 5472781 */
108: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN
109:
110: hr_utility.set_location(
111: 'Entering pay_ie_termination ....'|| 'per_ie_termination',
112: 10);

Line 110: hr_utility.set_location(

106:
107: /* Added for GSI Bug 5472781 */
108: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN
109:
110: hr_utility.set_location(
111: 'Entering pay_ie_termination ....'|| 'per_ie_termination',
112: 10);
113:
114: OPEN c_get_person_id (p_period_of_service_id);

Line 161: hr_utility.set_location(

157: DELETE FROM pay_ie_paye_details_f
158: WHERE paye_details_id = l_paye_detail_id AND
159: effective_start_date > p_final_process_date;
160: CLOSE c_get_paye_details;
161: hr_utility.set_location(
162: 'Leaving pay_ie_termination ....'|| 'per_ie_termination',
163: 10);
164: End Loop;
165:

Line 190: hr_utility.trace('Inside reverse term');

186: FROM pay_ie_paye_details_f
187: WHERE assignment_id = p_assignment_id;
188: --
189: BEGIN
190: hr_utility.trace('Inside reverse term');
191:
192: OPEN c_get_person_id (p_period_of_service_id);
193: FETCH c_get_person_id into l_person_id;
194: CLOSE c_get_person_id;

Line 206: hr_utility.trace('l_final_process_date' || to_char(l_final_process_date));

202: l_final_process_date:=null;
203: OPEN csr_final_process_date(asg_id.assignment_id);
204: FETCH csr_final_process_date INTO l_final_process_date;
205: CLOSE csr_final_process_date;
206: hr_utility.trace('l_final_process_date' || to_char(l_final_process_date));
207: --
208: UPDATE pay_ie_paye_details_f
209: SET effective_end_date = TO_CHAR(hr_general.end_of_time, 'DD-MON-YYYY')
210: WHERE assignment_id = asg_id.assignment_id AND