1 PACKAGE hr_organization AUTHID CURRENT_USER AS
2 /* $Header: peorganz.pkh 115.4 2002/08/20 11:30:10 skota 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_organization (HEADER)
24
25 Description : This package declares procedures required to INSERT
26 or UPDATE organizations in any application. DELETE
27 control is being handled via Foreign Key Constraints
28 on the ORGANIZATION_UNIT, four of which will allow
29 CASCADE DELETE to
30 HR_ORGANIZATION_INFORMATION
31 PER_NUMBER_GENERATION_CONTROLS
32 PER_ASSIGNMENT_STATUS_TYPE
33 PER_PERSON_TYPES.
34 Note: none of these tables can be deleted directly and
35 INSERTS into the PER tables are controlled by the
36 After Row Insert trigger on HR_ORGANIZATION_INFORMATION.
37
38 Change List
39 -----------
40
41 Version Date Author ER/CR No. Description of Change
42 -------+---------+----------+---------+--------------------------
43 70.0 17-NOV-92 SZWILLIA Date Created
44 70.1 17-NOV-92 SZWILLIA Commenting
45 70.2 20-NOV-92 SZWILLIA Added declaration of
46 insert_bus_grp_details.
47 70.4 01-MAR-93 TMATHERS Added declaration of
48 org_predel_check.
49 70.5 04-MAR-93 SZWILLIA Changed parameters to DATES
50 70.6 11-MAR-93 NKHAN Added 'exit' to the end
51 70.7 31-MAR-93 TMATHERS removed org_predel_check to
52 separate package.
53 70.8 01-APR-93 TMATHERS Included shared org_predel_check
54 procedure.(WHich includes only shared
55 tables of the Org CBB).
56 70.9 22-APR-93 TMATHERS Included shared hr_weak_bg_chk
57 70.12 02-JUN-94 TMathers Added get_flex_msg as a result of
58 using FND PLSQL in PERORDOR.
59 115.1 05-JUN-00 CCarter Added parameter p_org_information6
60 to insert_bus_grp_details in order
61 to create a Job Group everytime a
62 Business Group is created.
63 115.2 12-jun-02 adhunter added dbdrv lines
64 ================================================================= */
65 --
66 -- ----------------------- insert_business_group_details ------------
67 -- Called from trigger hr_org_info_ari
68 --
69 PROCEDURE insert_bus_grp_details (p_organization_id NUMBER
70 ,p_org_information9 VARCHAR2
71 ,p_org_information6 VARCHAR2
72 ,p_last_update_date DATE
73 ,p_last_updated_by NUMBER
74 ,p_last_update_login NUMBER
75 ,p_created_by NUMBER
76 ,p_creation_date DATE);
77 --
78 ----------------------------- unique_name -----------------------
79 --
80 -- Procedure used to check for unique organization name
81 --
82 PROCEDURE unique_name
83 (p_business_group_id NUMBER,
84 p_organization_id NUMBER,
85 p_organization_name VARCHAR2);
86 --
87 --
88 ----------------------------- date_range ------------------------
89 --
90 -- Procedure used to check date range on organization
91 --
92 PROCEDURE date_range
93 (p_date_from DATE,
94 p_date_to DATE);
95 --
96 --
97 ----------------------------- org_predel_check ------------------------
98 --
99 -- Procedure used to check whether an organization
100 -- can be deleted from a shared enviromnment..
101 -- (Personnel/Payroll Specific checks will not be made).
102 --
103 PROCEDURE org_predel_check
104 (p_organization_id INTEGER
105 ,p_business_group_id INTEGER);
106 --
107 --
108 -- Procedure used to check whether an organization
109 -- can become a business group.
110 --
111 procedure hr_weak_bg_chk(p_organization_id INTEGER);
112 --
113 -- Procedure required due to FND PLSQL not being able to handle hr_message
114 --
115 procedure get_flex_msg;
116 --
117 END hr_organization;