eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HREMPTER dependencies on HREMPTER

Line 1: PACKAGE BODY hrempter AS

1: PACKAGE BODY hrempter AS
2: /* $Header: peempter.pkb 120.22.12020000.3 2013/02/13 07:10:12 srannama 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 339: 115.74 28-Aug-2009 sidsaxen 8841176 Modified cursor c_assignment in hrempter.cancel_termination(),

335: max_effective_end_date for the record.
336: 115.72 16-MAR-2009 sgundoju 8214333 added the Logical NOT condition to fix the bug
337: in cancel_termination procedure
338: 115.73 08-Apr-2009 ghshanka 8214333 Moved the cancel_termination procedure .
339: 115.74 28-Aug-2009 sidsaxen 8841176 Modified cursor c_assignment in hrempter.cancel_termination(),
340: so when final_process_date and actual_termination_date
341: are unequal then system should picks only those assignment
342: which has "Terminated Assignment" in future.
343: 115.75 08-Dec-2009 sidsaxen 8841176 Modified cursor c_assignment in hrempter.cancel_termination()

Line 343: 115.75 08-Dec-2009 sidsaxen 8841176 Modified cursor c_assignment in hrempter.cancel_termination()

339: 115.74 28-Aug-2009 sidsaxen 8841176 Modified cursor c_assignment in hrempter.cancel_termination(),
340: so when final_process_date and actual_termination_date
341: are unequal then system should picks only those assignment
342: which has "Terminated Assignment" in future.
343: 115.75 08-Dec-2009 sidsaxen 8841176 Modified cursor c_assignment in hrempter.cancel_termination()
344: 115.76 20-Mar-2012 shpatro 13571033 Added 2 new cursors csr_is_end_apl and csr_emp_ptu_info and modified
345: the code in cancel_termination procedure to resolve the bug#13571033.
346: 120.22.12020000.3
347: 11-Feb-2013 srannama ER - Future Person Types

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

345: the code in cancel_termination procedure to resolve the bug#13571033.
346: 120.22.12020000.3
347: 11-Feb-2013 srannama ER - Future Person Types
348: ================================================================= */
349: g_package varchar2(33) := ' hrempter.'; -- Global package name
350:
351: --
352: -- ====================== delete_assign_atd =========================
353: --

Line 856: hrempter.g_fpt_rev_ter := 'Y';

852: --
853: -- ER FPT
854: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
855: l_action_chk := 'N';
856: hrempter.g_fpt_rev_ter := 'Y';
857: else
858: l_action_chk := 'Y';
859: end if;
860: exit;

Line 2213: l_action_chk := hrempter.check_for_future_person_rows(p_person_id

2209: end if;
2210: -- end if;
2211: --
2212: hr_utility.set_location(l_proc,7);
2213: l_action_chk := hrempter.check_for_future_person_rows(p_person_id
2214: ,p_actual_termination_date);
2215: --
2216: if l_action_chk = 'Y' then
2217: hr_utility.set_message(801,'HR_7440_TERM_FUT_ROWS_EXST');

Line 2238: l_action_chk := hrempter.check_for_compl_actions(p_person_id

2234: end if;
2235: --
2236: hr_utility.set_location(l_proc,20);
2237: -- VT 06/04/96 changed function call
2238: l_action_chk := hrempter.check_for_compl_actions(p_person_id
2239: ,p_actual_termination_date
2240: ,p_last_standard_process_date
2241: ,p_final_process_date);
2242: IF l_action_chk = 'W' THEN

Line 2258: if hrempter.check_cobra_benefits

2254: -- exist after the FPD
2255: --
2256: hr_utility.set_location(l_proc,23);
2257: if p_final_process_date IS NOT NULL then
2258: if hrempter.check_cobra_benefits
2259: (p_person_id
2260: ,p_final_process_date) then
2261: hr_utility.set_message(801,'HR_6968_EMP_COBRA_BENS_EXIST');
2262: hr_utility.raise_error;

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

2581: hr_utility.set_location(l_proc,50);
2582: FOR c_ass_rec IN c_assignment LOOP
2583: --
2584: hr_utility.set_location(l_proc,55);
2585: l_max_end_date := hrempter.get_max_end_date(c_ass_rec.assignment_id);
2586: --
2587: hr_utility.set_location(l_proc,60);
2588: FPD_FLAG := (p_final_process_date IS NOT NULL AND
2589: p_final_process_date < l_max_end_date);

Line 2603: hrempter.delete_assign_atd(c_ass_rec.assignment_id

2599: c_ass_rec.effective_start_date < p_actual_termination_date);
2600: --
2601: if NOT TA_FLAG then
2602: hr_utility.set_location(l_proc,75);
2603: hrempter.delete_assign_atd(c_ass_rec.assignment_id
2604: ,p_actual_termination_date);
2605: end if;
2606: --
2607: if FPD_FLAG then

Line 2609: hrempter.delete_assign_fpd(c_ass_rec.assignment_id

2605: end if;
2606: --
2607: if FPD_FLAG then
2608: hr_utility.set_location(l_proc,80);
2609: hrempter.delete_assign_fpd(c_ass_rec.assignment_id
2610: ,p_final_process_date);
2611: end if;
2612: --
2613: hr_utility.set_location(l_proc,85);

Line 2621: hrempter.terminate_entries_and_alus(c_ass_rec.assignment_id

2617: -- checking for the termination.
2618: --
2619: -- VT 10/07/96 bug #306710 new parameter
2620: l_ent_loop := 'N';
2621: hrempter.terminate_entries_and_alus(c_ass_rec.assignment_id
2622: ,p_actual_termination_date
2623: ,p_last_standard_process_date
2624: ,p_final_process_date
2625: ,l_legislation_code

Line 2658: hrempter.delete_de_assign(c_ass_rec.assignment_id

2654: if (FPD_FLAG AND TA_FLAG) OR
2655: (p_actual_termination_date = p_final_process_date) then
2656: --
2657: hr_utility.set_location(l_proc,90);
2658: hrempter.delete_de_assign(c_ass_rec.assignment_id
2659: ,p_final_process_date);
2660: --
2661: hr_utility.set_location(l_proc,95);
2662: UPDATE per_assignments_f

Line 2676: hrempter.delete_de_assign(c_ass_rec.assignment_id

2672: l_effective_end_date := l_max_end_date;
2673: end if;
2674: --
2675: hr_utility.set_location(l_proc,100);
2676: hrempter.delete_de_assign(c_ass_rec.assignment_id
2677: ,p_actual_termination_date);
2678: --
2679: hr_utility.set_location(l_proc,105);
2680: --

Line 2927: hrempter.delete_employee_atd(p_person_id

2923: --
2924: hr_utility.set_location(l_proc,1300);
2925: if NOT TA_FLAG then
2926: hr_utility.set_location(l_proc,115);
2927: hrempter.delete_employee_atd(p_person_id
2928: ,p_actual_termination_date);
2929: end if;
2930: --
2931: END LOOP;

Line 3017: l_action_chk := hrempter.check_for_compl_actions(p_person_id

3013: end if;
3014: --
3015: hr_utility.set_location(l_proc,5);
3016: -- VT 06/04/96 changed function call
3017: l_action_chk := hrempter.check_for_compl_actions(p_person_id
3018: ,l_actual_termination_date
3019: ,l_last_standard_process_date
3020: ,p_final_process_date);
3021: --

Line 3037: if hrempter.check_cobra_benefits

3033: -- If the FPD is not null then check that COBRA Benefits do not
3034: -- exist after the FPD
3035: --
3036: hr_utility.set_location(l_proc,7);
3037: if hrempter.check_cobra_benefits
3038: (p_person_id
3039: ,p_final_process_date) then
3040: hr_utility.set_message(801,'HR_6968_EMP_COBRA_BENS_EXIST');
3041: hr_utility.raise_error;

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

3047: hr_utility.set_location(l_proc,15);
3048: FOR c_ass_rec IN c_assignment LOOP
3049: --
3050: hr_utility.set_location(l_proc,20);
3051: l_max_end_date := hrempter.get_max_end_date(c_ass_rec.assignment_id);
3052: --
3053: if p_final_process_date < l_max_end_date then
3054: hr_utility.set_location(l_proc,25);
3055: hrempter.delete_assign_fpd(c_ass_rec.assignment_id

Line 3055: hrempter.delete_assign_fpd(c_ass_rec.assignment_id

3051: l_max_end_date := hrempter.get_max_end_date(c_ass_rec.assignment_id);
3052: --
3053: if p_final_process_date < l_max_end_date then
3054: hr_utility.set_location(l_proc,25);
3055: hrempter.delete_assign_fpd(c_ass_rec.assignment_id
3056: ,p_final_process_date);
3057: --
3058: hr_utility.set_location(l_proc,30);
3059: -- VT 10/07/96 bug #306710 new parameter

Line 3061: hrempter.terminate_entries_and_alus(c_ass_rec.assignment_id

3057: --
3058: hr_utility.set_location(l_proc,30);
3059: -- VT 10/07/96 bug #306710 new parameter
3060: l_ent_loop := 'N';
3061: hrempter.terminate_entries_and_alus(c_ass_rec.assignment_id
3062: ,null
3063: ,null
3064: ,p_final_process_date
3065: ,null

Line 3075: hrempter.delete_de_assign(c_ass_rec.assignment_id

3071: l_entries_changed := 'Y';
3072: end if;
3073: --
3074: hr_utility.set_location(l_proc,35);
3075: hrempter.delete_de_assign(c_ass_rec.assignment_id
3076: ,p_final_process_date);
3077: --
3078: hr_utility.set_location(l_proc,40);
3079: UPDATE per_assignments_f ass

Line 3564: l_action_chk := hrempter.check_for_future_person_type(p_person_id

3560: AND pc.effective_start_date > p_actual_termination_date;*/
3561: --- newly added code to cancel termination of contracts end
3562: --
3563: -- hr_utility.set_location(l_proc,2);
3564: l_action_chk := hrempter.check_for_future_person_type(p_person_id
3565: ,p_actual_termination_date);
3566: --
3567: if l_action_chk = 'Y' then
3568: hr_utility.set_message(801,'HR_7122_EMP_CNCL_TERM_INVLD');

Line 3574: l_action_chk := hrempter.check_for_compl_actions(p_person_id

3570: end if;
3571: --
3572: hr_utility.set_location(l_proc,99);
3573: -- VT 06/04/96 changed function call
3574: l_action_chk := hrempter.check_for_compl_actions(p_person_id
3575: ,p_actual_termination_date
3576: ,l_last_standard_process_date
3577: ,l_final_process_date);
3578: --

Line 3603: IF hrempter.check_for_future_person_rows(p_person_id,p_actual_termination_date) = 'Y'

3599: hr_utility.set_location(l_proc,4);
3600: --
3601:
3602: -- ER FPT
3603: IF hrempter.check_for_future_person_rows(p_person_id,p_actual_termination_date) = 'Y'
3604: AND (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') THEN
3605:
3606: -- Updating the per table to EMP or EMP_APL according to existing data.
3607: UPDATE per_all_people_f

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

3809: --
3810: l_asg_status_type_id := c_ass_rec.assignment_status_type_id;
3811: --
3812: hr_utility.set_location(l_proc,16);
3813: l_max_end_date := hrempter.get_max_end_date(c_ass_rec.assignment_id);
3814: --
3815: --if l_per_system_status <> 'TERM_ASSIGN' then
3816: -- bug 5152164 commented out the above if condition and removed the condition
3817: -- added in previous fix for the same bug

Line 4489: end hrempter;

4485: --
4486: end cancel_termination;
4487: --
4488: --
4489: end hrempter;