DBA Data[Home] [Help]

APPS.HREMPTER dependencies on HREMPTER

Line 1: PACKAGE BODY hrempter AS

1: PACKAGE BODY hrempter AS
2: /* $Header: peempter.pkb 120.18.12010000.1 2008/07/28 04:36:06 appldev ship $ */
3: /*
4: ******************************************************************
5: * *

Line 23: Name : hrempter (BODY)

19: * England. *
20: * *
21: ****************************************************************** */
22: /*
23: Name : hrempter (BODY)
24:
25: Description : This package declares procedures required to
26: terminate and cancel the termination of an employee.
27:

Line 320: 115.66 17-JUL-2006 agolechh 4308892 This version of hrempter calls pay_element_entry_api

316: 115.62 09-May-2006 ghshanka 5152164 modified the procedure CANCEL_TERMINATION
317: 115.63 19-May-2006 ggnanagu Added the call to adjust_salary_proposals
318: in per_saladmin_utility to fix bug 5200269
319: 115.65 14-JUN-2006 avarri 4371218 Modified cancel_termination to fix 4371218
320: 115.66 17-JUL-2006 agolechh 4308892 This version of hrempter calls pay_element_entry_api
321: instead of performing direct DML statements on
322: pay_element_entries_f.
323: 115.67 26-Jul-2006 thabara 5368246 Modified terminate_entries_and_alus and
324: delete_alus to end date ALUs with final

Line 337: g_package varchar2(33) := ' hrempter.'; -- Global package name

333: added a condition - to call pay_element_entry_api in
334: DELETE mode only if p_term_date is not equal to
335: max_effective_end_date for the record.
336: ================================================================= */
337: g_package varchar2(33) := ' hrempter.'; -- Global package name
338:
339: --
340: -- ====================== delete_assign_atd =========================
341: --

Line 2195: l_action_chk := hrempter.check_for_future_person_rows(p_person_id

2191: end if;
2192: -- end if;
2193: --
2194: hr_utility.set_location(l_proc,7);
2195: l_action_chk := hrempter.check_for_future_person_rows(p_person_id
2196: ,p_actual_termination_date);
2197: --
2198: if l_action_chk = 'Y' then
2199: hr_utility.set_message(801,'HR_7440_TERM_FUT_ROWS_EXST');

Line 2220: l_action_chk := hrempter.check_for_compl_actions(p_person_id

2216: end if;
2217: --
2218: hr_utility.set_location(l_proc,20);
2219: -- VT 06/04/96 changed function call
2220: l_action_chk := hrempter.check_for_compl_actions(p_person_id
2221: ,p_actual_termination_date
2222: ,p_last_standard_process_date
2223: ,p_final_process_date);
2224: IF l_action_chk = 'W' THEN

Line 2240: if hrempter.check_cobra_benefits

2236: -- exist after the FPD
2237: --
2238: hr_utility.set_location(l_proc,23);
2239: if p_final_process_date IS NOT NULL then
2240: if hrempter.check_cobra_benefits
2241: (p_person_id
2242: ,p_final_process_date) then
2243: hr_utility.set_message(801,'HR_6968_EMP_COBRA_BENS_EXIST');
2244: hr_utility.raise_error;

Line 2567: l_max_end_date := hrempter.get_max_end_date(c_ass_rec.assignment_id);

2563: hr_utility.set_location(l_proc,50);
2564: FOR c_ass_rec IN c_assignment LOOP
2565: --
2566: hr_utility.set_location(l_proc,55);
2567: l_max_end_date := hrempter.get_max_end_date(c_ass_rec.assignment_id);
2568: --
2569: hr_utility.set_location(l_proc,60);
2570: FPD_FLAG := (p_final_process_date IS NOT NULL AND
2571: p_final_process_date < l_max_end_date);

Line 2585: hrempter.delete_assign_atd(c_ass_rec.assignment_id

2581: c_ass_rec.effective_start_date < p_actual_termination_date);
2582: --
2583: if NOT TA_FLAG then
2584: hr_utility.set_location(l_proc,75);
2585: hrempter.delete_assign_atd(c_ass_rec.assignment_id
2586: ,p_actual_termination_date);
2587: end if;
2588: --
2589: if FPD_FLAG then

Line 2591: hrempter.delete_assign_fpd(c_ass_rec.assignment_id

2587: end if;
2588: --
2589: if FPD_FLAG then
2590: hr_utility.set_location(l_proc,80);
2591: hrempter.delete_assign_fpd(c_ass_rec.assignment_id
2592: ,p_final_process_date);
2593: end if;
2594: --
2595: hr_utility.set_location(l_proc,85);

Line 2603: hrempter.terminate_entries_and_alus(c_ass_rec.assignment_id

2599: -- checking for the termination.
2600: --
2601: -- VT 10/07/96 bug #306710 new parameter
2602: l_ent_loop := 'N';
2603: hrempter.terminate_entries_and_alus(c_ass_rec.assignment_id
2604: ,p_actual_termination_date
2605: ,p_last_standard_process_date
2606: ,p_final_process_date
2607: ,l_legislation_code

Line 2640: hrempter.delete_de_assign(c_ass_rec.assignment_id

2636: if (FPD_FLAG AND TA_FLAG) OR
2637: (p_actual_termination_date = p_final_process_date) then
2638: --
2639: hr_utility.set_location(l_proc,90);
2640: hrempter.delete_de_assign(c_ass_rec.assignment_id
2641: ,p_final_process_date);
2642: --
2643: hr_utility.set_location(l_proc,95);
2644: UPDATE per_assignments_f

Line 2658: hrempter.delete_de_assign(c_ass_rec.assignment_id

2654: l_effective_end_date := l_max_end_date;
2655: end if;
2656: --
2657: hr_utility.set_location(l_proc,100);
2658: hrempter.delete_de_assign(c_ass_rec.assignment_id
2659: ,p_actual_termination_date);
2660: --
2661: hr_utility.set_location(l_proc,105);
2662: --

Line 2909: hrempter.delete_employee_atd(p_person_id

2905: --
2906: hr_utility.set_location(l_proc,1300);
2907: if NOT TA_FLAG then
2908: hr_utility.set_location(l_proc,115);
2909: hrempter.delete_employee_atd(p_person_id
2910: ,p_actual_termination_date);
2911: end if;
2912: --
2913: END LOOP;

Line 2999: l_action_chk := hrempter.check_for_compl_actions(p_person_id

2995: end if;
2996: --
2997: hr_utility.set_location(l_proc,5);
2998: -- VT 06/04/96 changed function call
2999: l_action_chk := hrempter.check_for_compl_actions(p_person_id
3000: ,l_actual_termination_date
3001: ,l_last_standard_process_date
3002: ,p_final_process_date);
3003: --

Line 3019: if hrempter.check_cobra_benefits

3015: -- If the FPD is not null then check that COBRA Benefits do not
3016: -- exist after the FPD
3017: --
3018: hr_utility.set_location(l_proc,7);
3019: if hrempter.check_cobra_benefits
3020: (p_person_id
3021: ,p_final_process_date) then
3022: hr_utility.set_message(801,'HR_6968_EMP_COBRA_BENS_EXIST');
3023: hr_utility.raise_error;

Line 3033: l_max_end_date := hrempter.get_max_end_date(c_ass_rec.assignment_id);

3029: hr_utility.set_location(l_proc,15);
3030: FOR c_ass_rec IN c_assignment LOOP
3031: --
3032: hr_utility.set_location(l_proc,20);
3033: l_max_end_date := hrempter.get_max_end_date(c_ass_rec.assignment_id);
3034: --
3035: if p_final_process_date < l_max_end_date then
3036: hr_utility.set_location(l_proc,25);
3037: hrempter.delete_assign_fpd(c_ass_rec.assignment_id

Line 3037: hrempter.delete_assign_fpd(c_ass_rec.assignment_id

3033: l_max_end_date := hrempter.get_max_end_date(c_ass_rec.assignment_id);
3034: --
3035: if p_final_process_date < l_max_end_date then
3036: hr_utility.set_location(l_proc,25);
3037: hrempter.delete_assign_fpd(c_ass_rec.assignment_id
3038: ,p_final_process_date);
3039: --
3040: hr_utility.set_location(l_proc,30);
3041: -- VT 10/07/96 bug #306710 new parameter

Line 3043: hrempter.terminate_entries_and_alus(c_ass_rec.assignment_id

3039: --
3040: hr_utility.set_location(l_proc,30);
3041: -- VT 10/07/96 bug #306710 new parameter
3042: l_ent_loop := 'N';
3043: hrempter.terminate_entries_and_alus(c_ass_rec.assignment_id
3044: ,null
3045: ,null
3046: ,p_final_process_date
3047: ,null

Line 3057: hrempter.delete_de_assign(c_ass_rec.assignment_id

3053: l_entries_changed := 'Y';
3054: end if;
3055: --
3056: hr_utility.set_location(l_proc,35);
3057: hrempter.delete_de_assign(c_ass_rec.assignment_id
3058: ,p_final_process_date);
3059: --
3060: hr_utility.set_location(l_proc,40);
3061: UPDATE per_assignments_f ass

Line 3497: l_action_chk := hrempter.check_for_future_person_type(p_person_id

3493: AND pc.effective_start_date > p_actual_termination_date;*/
3494: --- newly added code to cancel termination of contracts end
3495: --
3496: -- hr_utility.set_location(l_proc,2);
3497: l_action_chk := hrempter.check_for_future_person_type(p_person_id
3498: ,p_actual_termination_date);
3499: --
3500: if l_action_chk = 'Y' then
3501: hr_utility.set_message(801,'HR_7122_EMP_CNCL_TERM_INVLD');

Line 3507: l_action_chk := hrempter.check_for_compl_actions(p_person_id

3503: end if;
3504: --
3505: hr_utility.set_location(l_proc,99);
3506: -- VT 06/04/96 changed function call
3507: l_action_chk := hrempter.check_for_compl_actions(p_person_id
3508: ,p_actual_termination_date
3509: ,l_last_standard_process_date
3510: ,l_final_process_date);
3511: --

Line 3695: l_max_end_date := hrempter.get_max_end_date(c_ass_rec.assignment_id);

3691: --
3692: l_asg_status_type_id := c_ass_rec.assignment_status_type_id;
3693: --
3694: hr_utility.set_location(l_proc,16);
3695: l_max_end_date := hrempter.get_max_end_date(c_ass_rec.assignment_id);
3696: --
3697: --if l_per_system_status <> 'TERM_ASSIGN' then
3698: -- bug 5152164 commented out the above if condition and removed the condition
3699: -- added in previous fix for the same bug

Line 4273: end hrempter;

4269: --
4270: end cancel_termination;
4271: --
4272: --
4273: end hrempter;