1 PACKAGE hr_person_delete AUTHID CURRENT_USER AS
2 /* $Header: peperdel.pkh 120.0 2005/05/31 13:48:51 appldev noship $ */
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 : hr_person (HEADER)
24
25 Description : This package declares procedures required to DELETE
26 people on Oracle Human Resources. Note, this
27 does not include extra validation provided by calling programs (such
28 as screen QuickPicks and HRLink validation) OR that provided by use
29 of constraints and triggers held against individual tables.
30 Change List
31 -----------
32
33 Version Date Author ER/CR No. Description of Change
34 -------+---------+----------+---------+--------------------------
35 70.0 10-AUG-93 TMATHERS Date Created
36 80.0 Removed these procedures
37 from peperson(hr_person).
38 Orignally coded by PBARRY.
39 Moved to reduce size of
40 original package.
41 70.3 14-Jun-95 TMathers Created new procedure
42 moderate_predel_validation
43 ================================================================= */
44 --
45 --
46 -- ----------------------- product_installed --------------------------
47 --
48 -- Has this product been installed? Return status and oracleid also.
49 --
50 PROCEDURE product_installed (p_application_short_name IN varchar2,
51 p_status OUT NOCOPY varchar2,
52 p_yes_no OUT NOCOPY varchar2,
53 p_oracle_username OUT NOCOPY varchar2);
54 --
55 -- ----------------------- weak_predel_validation --------------------------
56 --
57 -- Weak pre-delete validation called primarily from Delete Person form.
58 --
59 PROCEDURE weak_predel_validation (p_person_id IN number,
60 p_session_date IN date,
61 p_dt_delete_mode IN varchar2 default 'ZAP'); -- 4169275
62
63 --
64 -- ----------------------- Moderate_predel_validation -----------------------
65 --
66 -- Moderate pre-delete validation called from the Stong_predel_validation
67 -- procedure and HR API's.
68 --
69 PROCEDURE moderate_predel_validation (p_person_id IN number,
70 p_session_date IN date,
71 p_dt_delete_mode IN varchar2 default 'ZAP'); -- 4169275
72 --
73 -- ----------------------- strong_predel_validation --------------------------
74 --
75 -- Strong pre-delete validation called from the Enter Person and Applicant
76 -- Quick Entry forms.
77 --
78 PROCEDURE strong_predel_validation (p_person_id IN number,
79 p_session_date IN date,
80 p_dt_delete_mode IN varchar2 default 'ZAP'); -- 4169275
81 --
82 -- ----------------------- check_contact --------------------------
83 --
84 -- Whilst deleteing a contact relationship, is this contact 'used' for
85 -- anything else? If not then delete this person.
86 --
87 PROCEDURE check_contact (p_person_id IN number,
88 p_contact_person_id IN number,
89 p_contact_relationship_id IN number,
90 p_session_date IN date);
91 --
92 -- ----------------------- delete_a_person --------------------------
93 --
94 -- Delete a person completely from the HR database. Deletes from all tables
95 -- referencing this person. Used primarily by Delete Person form.
96 --
97 PROCEDURE delete_a_person (p_person_id IN number,
98 p_form_call IN boolean,
99 p_session_date IN date);
100 --
101 -- ----------------------- people_default_deletes --------------------------
102 --
103 -- Delete people who only have default information entered for them.
104 -- Used primarily by the Enter Person form.
105 --
106 PROCEDURE people_default_deletes (p_person_id IN number,
107 p_form_call IN boolean);
108 --
109 -- ----------------------- applicant_default_deletes --------------------------
110 --
111 -- Delete applicants who only have default information entered for them.
112 -- Used primarily by the Applicant Quick Entry form.
113 --
114 PROCEDURE applicant_default_deletes (p_person_id IN number,
115 p_form_call IN boolean);
116 --
117 end hr_person_delete;
[Home] [Help]