1 package per_cancel_hire_or_apl_pkg AUTHID CURRENT_USER as
2 /* $Header: pecanhir.pkh 120.1.12020000.1 2012/06/29 00:50:25 appldev ship $ */
3
4 /*
5 ******************************************************************
6 * *
7 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
8 * Chertsey, England. *
9 * *
10 * All rights reserved. *
11 * *
12 * This material has been provided pursuant to an agreement *
13 * containing restrictions on its use. The material is also *
14 * protected by copyright law. No part of this material may *
15 * be copied or distributed, transmitted or transcribed, in *
16 * any form or by any means, electronic, mechanical, magnetic, *
17 * manual, or otherwise, or disclosed to third parties without *
18 * the express written permission of Oracle Corporation UK Ltd, *
19 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
20 * England. *
21 * *
22 ****************************************************************** */
23 /*
24 Name : hr_person (BODY)
25
26 Description : This package declares procedures needed to cancel an
27 employee's hire.
28
29 Change List
30 -----------
31
32 Version Date Author ER/CR No. Description of Change
33 -------+---------+----------+---------+--------------------------
34 70.0 27-Oct-94 Tmathers First Version into Arcs.
35 70.1 13-May-95 ARoussel Fix error at end to report on header
36 70.2 15-May-95 RFine ...and also in the show errors line
37 70.3 11-Jun-97 Teyres Change 'is' to 'as' in create or replace
38 110.1 04-AUG-97 Mbocutt Changed package name to comply with
39 standards.
40 115.2 11-JUN-02 MGettins Added dbdrv commands
41 115.3 12-JUN-02 adhunter corrected dbdrv line
42 115.4 20-NOV-02 MGettins Added lock_cwk_rows procedure.
43 115.5 04-DEC-02 MGettins NOCOPY changes
44 115.6 12-Sep-08 ghshanka Bug 7001197 Added a mew procedure to handle the
45 emp_apl cancel hire issue.
46 */
47 --
48 PROCEDURE lock_cwk_rows
49 (p_person_id IN per_all_people_f.person_id%TYPE
50 ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
51 ,p_effective_date IN DATE);
52 --
53 procedure lock_per_rows(p_person_id NUMBER
54 ,p_primary_id NUMBER
55 ,p_primary_date DATE
56 ,p_business_group_id NUMBER
57 ,p_person_type VARCHAR2);
58 --
59 procedure pre_cancel_checks(p_person_id NUMBER
60 ,p_where IN OUT NOCOPY VARCHAR2
61 ,p_business_group_id NUMBER
62 ,p_system_person_type VARCHAR2
63 ,p_primary_id NUMBER
64 ,p_primary_date DATE
65 ,p_cancel_type VARCHAR2);
66 --
67 procedure do_cancel_hire(p_person_id NUMBER
68 ,p_date_start DATE
69 ,p_end_of_time DATE
70 ,p_business_group_id NUMBEr
71 ,p_period_of_service_id NUMBER);
72 --
73 procedure do_cancel_appl(p_person_id NUMBER
74 ,p_date_received DATE
75 ,p_end_of_time DATE
76 ,p_business_group_id NUMBER
77 ,p_application_id NUMBER);
78 --
79 procedure update_person_list (p_person_id NUMBER);
80 --
81 PROCEDURE do_cancel_placement
82 (p_person_id IN per_people_f.person_id%TYPE
83 ,p_business_group_id IN per_people_f.business_group_id%TYPE
84 ,p_effective_date IN DATE
85 ,p_date_start IN DATE);
86 --
87 PROCEDURE pre_cancel_placement_checks
88 (p_person_id IN NUMBER
89 ,p_business_group_id IN NUMBER
90 ,p_effective_date IN DATE
91 ,p_date_start IN DATE
92 ,p_supervisor_warning IN OUT NOCOPY BOOLEAN
93 ,p_recruiter_warning IN OUT NOCOPY BOOLEAN
94 ,p_event_warning IN OUT NOCOPY BOOLEAN
95 ,p_interview_warning IN OUT NOCOPY BOOLEAN
96 ,p_review_warning IN OUT NOCOPY BOOLEAN
97 ,p_vacancy_warning IN OUT NOCOPY BOOLEAN
98 ,p_requisition_warning IN OUT NOCOPY BOOLEAN
99 ,p_budget_warning IN OUT NOCOPY BOOLEAN
100 ,p_payment_warning IN OUT NOCOPY BOOLEAN);
101 --
102 procedure cancel_emp_apl_hire
103 (
104 p_person_id NUMBER
105 ,p_date_start DATE
106 ,p_end_of_time DATE
107 ,p_business_group_id NUMBEr
108 ,p_period_of_service_id NUMBER);
109 --
110 FUNCTION return_legislation_code
111 (p_person_id IN NUMBER ) RETURN VARCHAR2;
112 --
113 END per_cancel_hire_or_apl_pkg;