1 PACKAGE hr_org_pre_delete AUTHID CURRENT_USER AS
2 /* $Header: pedelorg.pkh 115.0 99/07/17 18:53:58 porting 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 : hr_org_pre_delete (HEADER)
24
25 Description : This package declares procedures required to test for referential integrity errors which could potentially be caused by deleting
26 an organization which relationship rows with other tables.
27 (Although ORACLE7 does this automatically the message isn't
28 vey user friendly).
29
30 Change List
31 -----------
32
33 Version Date Author ER/CR No. Description of Change
34 -------+---------+----------+---------+--------------------------
35 70.0 31-MAR-93 TMATHERS Date Created.
36 70.1 01-APR-93 TMATHERS Moved shared org tests to peorganz.
37 70.2 22-APR-93 TMATHERS Added hr_strong_bg_chk procedure.
38 */
39 ----------------------------- hr_org_predel_check ------------------------
40 --
41 -- Procedure used to check whether an organization
42 -- or business group (an org with a information type of business group)
43 -- can be deleted.
44 PROCEDURE hr_org_predel_check
45 (p_organization_id INTEGER
46 ,p_business_group_id INTEGER);
47 --
48 --
49 ---------------------------- hr_strong_bg_chk ------------------------------
50 --
51 -- Procedure to check whether an organization
52 -- can become a business group.
53 procedure hr_strong_bg_chk(
54 p_organization_id INTEGER);
55 --
56 END hr_org_pre_delete;
[Home] [Help]