1 package per_cancel_hire_or_apl_pkg as
2 /* $Header: pecanhir.pkh 120.0.12010000.1 2008/07/28 04:17:46 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 */
45 --
46 PROCEDURE lock_cwk_rows
47 (p_person_id IN per_all_people_f.person_id%TYPE
48 ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
49 ,p_effective_date IN DATE);
50 --
51 procedure lock_per_rows(p_person_id NUMBER
52 ,p_primary_id NUMBER
53 ,p_primary_date DATE
54 ,p_business_group_id NUMBER
55 ,p_person_type VARCHAR2);
56 --
57 procedure pre_cancel_checks(p_person_id NUMBER
58 ,p_where IN OUT NOCOPY VARCHAR2
59 ,p_business_group_id NUMBER
60 ,p_system_person_type VARCHAR2
61 ,p_primary_id NUMBER
62 ,p_primary_date DATE
63 ,p_cancel_type VARCHAR2);
64 --
65 procedure do_cancel_hire(p_person_id NUMBER
66 ,p_date_start DATE
67 ,p_end_of_time DATE
68 ,p_business_group_id NUMBEr
69 ,p_period_of_service_id NUMBER);
70 --
71 procedure do_cancel_appl(p_person_id NUMBER
72 ,p_date_received DATE
73 ,p_end_of_time DATE
74 ,p_business_group_id NUMBER
75 ,p_application_id NUMBER);
76 --
77 procedure update_person_list (p_person_id NUMBER);
78 --
79 PROCEDURE do_cancel_placement
80 (p_person_id IN per_people_f.person_id%TYPE
81 ,p_business_group_id IN per_people_f.business_group_id%TYPE
82 ,p_effective_date IN DATE
83 ,p_date_start IN DATE);
84 --
85 PROCEDURE pre_cancel_placement_checks
86 (p_person_id IN NUMBER
87 ,p_business_group_id IN NUMBER
88 ,p_effective_date IN DATE
89 ,p_date_start IN DATE
90 ,p_supervisor_warning IN OUT NOCOPY BOOLEAN
91 ,p_recruiter_warning IN OUT NOCOPY BOOLEAN
92 ,p_event_warning IN OUT NOCOPY BOOLEAN
93 ,p_interview_warning IN OUT NOCOPY BOOLEAN
94 ,p_review_warning IN OUT NOCOPY BOOLEAN
95 ,p_vacancy_warning IN OUT NOCOPY BOOLEAN
96 ,p_requisition_warning IN OUT NOCOPY BOOLEAN
97 ,p_budget_warning IN OUT NOCOPY BOOLEAN
98 ,p_payment_warning IN OUT NOCOPY BOOLEAN);
99 --
100 FUNCTION return_legislation_code
101 (p_person_id IN NUMBER ) RETURN VARCHAR2;
102 --
103 END per_cancel_hire_or_apl_pkg;