[Home] [Help]
PACKAGE: APPS.HREMPTER
Source
1 PACKAGE hrempter AS
2 /* $Header: peempter.pkh 120.1.12010000.1 2008/07/28 04:36:08 appldev 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 ================================================================= */
55 --
56 --
57 PROCEDURE terminate_employee(p_trigger VARCHAR2
58 ,p_business_group_id NUMBER
59 ,p_person_id NUMBER
60 ,p_assignment_status_type_id NUMBER
61 ,p_actual_termination_date DATE
62 ,p_last_standard_process_date DATE
63 ,p_final_process_date DATE);
64 --
65 --
66 PROCEDURE employee_shutdown(p_trigger VARCHAR2
67 ,p_person_id NUMBER
68 ,p_final_process_date DATE);
69 --
70 --
71 PROCEDURE cancel_termination(p_person_id NUMBER
72 ,p_actual_termination_date DATE
73 ,p_clear_details VARCHAR2 DEFAULT 'N');
74 --
75 --
76 PROCEDURE terminate_entries_and_alus(p_assignment_id NUMBER,
77 p_actual_term_date DATE,
78 p_last_standard_date DATE,
79 p_final_process_date DATE,
80 p_legislation_code VARCHAR2 DEFAULT
81 NULL);
82 --
83 --
84 PROCEDURE terminate_entries_and_alus(p_assignment_id NUMBER,
85 p_actual_term_date DATE,
86 p_last_standard_date DATE,
87 p_final_process_date DATE,
88 p_legislation_code VARCHAR2 DEFAULT
89 NULL,
90 p_entries_changed_warning IN OUT
91 VARCHAR2);
92 --
93 -- 115.6 (START)
94 --
95 PROCEDURE terminate_entries_and_alus(p_assignment_id NUMBER,
96 p_actual_term_date DATE,
97 p_last_standard_date DATE,
98 p_final_process_date DATE,
99 p_legislation_code VARCHAR2 DEFAULT
100 NULL,
101 p_entries_changed_warning IN OUT
102 VARCHAR2,
103 p_alu_change_warning IN OUT
104 VARCHAR2);
105 --
106 -- 115.6 (END)
107 --
108 PROCEDURE delete_de_assign(p_assignment_id NUMBER
109 ,p_delete_date DATE);
110
111 --
112 --
113 PROCEDURE delete_assign_fpd(p_assignment_id NUMBER
114 ,p_final_process_date DATE);
115 --
116 --
117 PROCEDURE delete_assign_atd(p_assignment_id NUMBER
118 ,p_actual_termination_date DATE);
119
120
121
122 end hrempter;