[Home] [Help]
PACKAGE: APPS.HREMPTER
Source
1 PACKAGE hrempter AUTHID CURRENT_USER AS
2 /* $Header: peempter.pkh 120.1.12020000.2 2013/02/14 06:29:25 srannama ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
7 * Chertsey, England. *
8 * *
9 * All rights reserved. *
10 * *
11 * This material has been provided pursuant to an agreement *
12 * containing restrictions on its use. The material is also *
13 * protected by copyright law. No part of this material may *
14 * be copied or distributed, transmitted or transcribed, in *
15 * any form or by any means, electronic, mechanical, magnetic, *
16 * manual, or otherwise, or disclosed to third parties without *
17 * the express written permission of Oracle Corporation UK Ltd, *
18 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
19 * England. *
20 * *
21 ****************************************************************** */
22 /*
23 Name : hrempter (HEADER)
24
25 Description : This package declares procedures required to
26 terminate and cancel the termination of an employee.
27
28
29 Change List
30 -----------
31
32 Version Date Author ER/CR No. Description of Change
33 -------+---------+----------+---------+--------------------------
34 70.0 11-FEB-93 SZWILLIA Date Created
35 70.1 11-MAR-93 NKHAN Added 'exit' to end of code
36 70.6 20-APR-95 TMathers 271941 Fixed the WWBUG
37 Also added flag to allow only
38 some of Term
39 details to be deleted.
40 70.7 26-MAR-1995 TMathers 276096 Added Legislation code to
41 terminate_alu procedure.
42 70.8 25-Oct-1995 JTHURING Missing ???.
43 70.9 17-Oct-1996 VTreiger 306710 Added parameter p_entries
44 _changed_warning to procedure
45 terminate_entries_and_alus.
46 70.10 01-Nov-1996 VTreiger 306710 Added procedure terminate_
47 entries_and_alus overload.
48 110.1 14-Sep-2001 M Bocutt 1271513 Added some additional procedures
49 required for terminations rework.
50 115.4 22-AUG-2002 adhunter correct GSCC warning
51 115.5 05-DEC-2002 pkakar -
52 115.6 22-MAR-2006 LSilveir 4449472 Overloaded the procedure
53 terminate_entries_and_alus
54 120.1.12020000.1
55 11-FEB-2013 srannama ER - Future Person Types
56 ================================================================= */
57 --
58 --
59 g_fpt_rev_ter varchar2(1) := 'N'; -- ER FPT
60
61 PROCEDURE terminate_employee(p_trigger VARCHAR2
62 ,p_business_group_id NUMBER
63 ,p_person_id NUMBER
64 ,p_assignment_status_type_id NUMBER
65 ,p_actual_termination_date DATE
66 ,p_last_standard_process_date DATE
67 ,p_final_process_date DATE);
68 --
69 --
70 PROCEDURE employee_shutdown(p_trigger VARCHAR2
71 ,p_person_id NUMBER
72 ,p_final_process_date DATE);
73 --
74 --
75 PROCEDURE cancel_termination(p_person_id NUMBER
76 ,p_actual_termination_date DATE
77 ,p_clear_details VARCHAR2 DEFAULT 'N');
78 --
79 --
80 PROCEDURE terminate_entries_and_alus(p_assignment_id NUMBER,
81 p_actual_term_date DATE,
82 p_last_standard_date DATE,
83 p_final_process_date DATE,
84 p_legislation_code VARCHAR2 DEFAULT
85 NULL);
86 --
87 --
88 PROCEDURE terminate_entries_and_alus(p_assignment_id NUMBER,
89 p_actual_term_date DATE,
90 p_last_standard_date DATE,
91 p_final_process_date DATE,
92 p_legislation_code VARCHAR2 DEFAULT
93 NULL,
94 p_entries_changed_warning IN OUT
95 VARCHAR2);
96 --
97 -- 115.6 (START)
98 --
99 PROCEDURE terminate_entries_and_alus(p_assignment_id NUMBER,
100 p_actual_term_date DATE,
101 p_last_standard_date DATE,
102 p_final_process_date DATE,
103 p_legislation_code VARCHAR2 DEFAULT
104 NULL,
105 p_entries_changed_warning IN OUT
106 VARCHAR2,
107 p_alu_change_warning IN OUT
108 VARCHAR2);
109 --
110 -- 115.6 (END)
111 --
112 PROCEDURE delete_de_assign(p_assignment_id NUMBER
113 ,p_delete_date DATE);
114
115 --
116 --
117 PROCEDURE delete_assign_fpd(p_assignment_id NUMBER
118 ,p_final_process_date DATE);
119 --
120 --
121 PROCEDURE delete_assign_atd(p_assignment_id NUMBER
122 ,p_actual_termination_date DATE);
123
124
125
126 end hrempter;