[Home] [Help]
PACKAGE: APPS.PER_DB_PER_SETUP
Source
1 PACKAGE per_db_per_setup AUTHID CURRENT_USER AS
2 /* $Header: pesetupd.pkh 115.1 99/07/18 15:05:26 porting 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 : per_db_per_setup (HEADER)
25
26 Description : This package declares procedures required to
27 create all 'set up' entities in Personnel.
28 That is:
29
30 Business Groups,
31 HR Organizations,
32 Legal Companies,
33 Positions,
34 Jobs,
35 Grades,
36 Change List
37 -----------
38 Version Date Author ER/CR No. Description of Change
39 -------+---------+----------+---------+--------------------------
40 70.0 19-NOV-92 SZWILLIA Date Created
41 70.1 21-DEC-92 SZWILLIA Added Person Building Blocks
42 70.2 04-JAN-93 SZWILLIA Create Applicant added.
43 70.3 11-JAN-93 SZWILLIA Corrected date defaulting
44 70.4 11-JAN-93 SZWILLIA Moved person and assignment
45 procedures to db_per_additional
46 70.5 11-JAN-93 SZWILLIA Changed create_business_group to
47 accept structure names not
48 numbers
49 70.6 04-MAR-93 SZWILLIA Changed parameters to be correct
50 format for DATEs
51 70.7 09-MAR-93 SZWILLIA Made insert_org_information public.
52 70.8 11-MAR-93 NKHAn Added 'exit' to the enD
53 115.1 14-May-1999 mmillmor multi-radix fix to working_hours on position
54 ================================================================= */
55 --
56 FUNCTION insert_org_information
57 ( P_ORGANIZATION_ID NUMBER
58 ,P_ORG_INFORMATION_CONTEXT VARCHAR2
59 ,P_ORG_INFORMATION1 VARCHAR2
60 ,P_ORG_INFORMATION2 VARCHAR2 DEFAULT null
61 ,P_ORG_INFORMATION3 VARCHAR2 DEFAULT null
62 ,P_ORG_INFORMATION4 VARCHAR2 DEFAULT null
63 ,P_ORG_INFORMATION5 VARCHAR2 DEFAULT null
64 ,P_ORG_INFORMATION6 VARCHAR2 DEFAULT null
65 ,P_ORG_INFORMATION7 VARCHAR2 DEFAULT null
66 ,P_ORG_INFORMATION8 VARCHAR2 DEFAULT null
67 ,P_ORG_INFORMATION9 VARCHAR2 DEFAULT null
68 ,P_ORG_INFORMATION10 VARCHAR2 DEFAULT null
69 ,P_ORG_INFORMATION11 VARCHAR2 DEFAULT null
70 ,P_ORG_INFORMATION12 VARCHAR2 DEFAULT null
71 ,P_ORG_INFORMATION13 VARCHAR2 DEFAULT null
72 ,P_ORG_INFORMATION14 VARCHAR2 DEFAULT null
73 ,P_ORG_INFORMATION15 VARCHAR2 DEFAULT null
74 ,P_ORG_INFORMATION16 VARCHAR2 DEFAULT null
75 ,P_ORG_INFORMATION17 VARCHAR2 DEFAULT null
76 ,P_ORG_INFORMATION18 VARCHAR2 DEFAULT null
77 ,P_ORG_INFORMATION19 VARCHAR2 DEFAULT null
78 ,P_ORG_INFORMATION20 VARCHAR2 DEFAULT null
79 ) return NUMBER ;
80 --
81 --
82 FUNCTION create_business_group
83 ( P_GROUP VARCHAR2 DEFAULT 'Y'
84 ,P_NAME VARCHAR2
85 ,P_DATE_FROM DATE
86 ,P_DATE_TO DATE DEFAULT null
87 ,P_INTERNAL_ADDRESS_LINE VARCHAR2 DEFAULT null
88 ,P_DEFAULT_START_TIME VARCHAR2 DEFAULT '08:00'
89 ,P_DEFAULT_END_TIME VARCHAR2 DEFAULT '17:30'
90 ,P_WORKING_HOURS VARCHAR2 DEFAULT '37.5'
91 ,P_FREQUENCY VARCHAR2 DEFAULT 'W'
92 ,P_SHORT_NAME VARCHAR2
93 ,P_METHOD_OF_GENERATION_EMP_NUM VARCHAR2 DEFAULT 'A'
94 ,P_METHOD_OF_GENERATION_APL_NUM VARCHAR2 DEFAULT 'A'
95 ,P_GRADE_STRUCTURE VARCHAR2 DEFAULT 'Grade Volume Data'
96 ,P_PEOPLE_GROUP_STRUCTURE VARCHAR2
97 DEFAULT 'People Group Volume Data'
98 ,P_JOB_STRUCTURE VARCHAR2 DEFAULT 'Job Volume Data'
99 ,P_COST_ALLOCATION_STRUCTURE VARCHAR2
100 DEFAULT 'Cost Allocation Volume Data'
101 ,P_POSITION_STRUCTURE VARCHAR2 DEFAULT 'Position Volume Data'
102 ,P_LEGISLATION_CODE VARCHAR2 DEFAULT 'GB'
103 ,P_CURRENCY_CODE VARCHAR2 DEFAULT 'GBP'
104 ) return NUMBER;
105 --
106 --
107 FUNCTION create_per_organization
108 ( P_NAME VARCHAR2
109 ,P_BUSINESS_GROUP VARCHAR2
110 ,P_DATE_FROM DATE
111 ,P_DATE_TO DATE DEFAULT null
112 ,P_INTERNAL_ADDRESS_LINE VARCHAR2 DEFAULT null
113 ,P_DEFAULT_START_TIME VARCHAR2 DEFAULT '08:00'
114 ,P_DEFAULT_END_TIME VARCHAR2 DEFAULT '17:30'
115 ,P_WORKING_HOURS VARCHAR2 DEFAULT '37.5'
116 ,P_FREQUENCY VARCHAR2 DEFAULT 'W'
117 ,P_INTERNAL_EXTERNAL_FLAG VARCHAR2 DEFAULT 'INT'
118 ,P_TYPE VARCHAR2 DEFAULT null
119 ,P_LOCATION_ID NUMBER DEFAULT null
120 ) return NUMBER;
121 --
122 --
123 FUNCTION create_pay_legal_company
124 ( P_NAME VARCHAR2
125 ,P_BUSINESS_GROUP VARCHAR2
126 ,P_DATE_FROM DATE
127 ,P_DATE_TO DATE DEFAULT null
128 ,P_INTERNAL_ADDRESS_LINE VARCHAR2 DEFAULT null
129 ,P_LOCATION_ID NUMBER DEFAULT null
130 ,P_COMPANY_FEDERAL_IDENTIFIER VARCHAR2 DEFAULT null
131 ,P_NACHA_COMPANY_NAME VARCHAR2 DEFAULT null
132 ,P_NACHA_IDENTIFIER VARCHAR2 DEFAULT null
133 ,P_NACHA_DISCRETIONARY_CODE VARCHAR2 DEFAULT null
134 ) return NUMBER;
135 --
136 --
137 FUNCTION create_job
138 (p_default VARCHAR2 DEFAULT 'Y'
139 ,p_name VARCHAR2
140 ,p_business_group VARCHAR2
141 ,p_date_from DATE
142 ,p_date_to DATE DEFAULT null
143 ,p_segment1 VARCHAR2 DEFAULT null
144 ,p_segment2 VARCHAR2 DEFAULT null
145 ,p_segment3 VARCHAR2 DEFAULT null
146 ,p_segment4 VARCHAR2 DEFAULT null
147 ,p_segment5 VARCHAR2 DEFAULT null
148 ,p_segment6 VARCHAR2 DEFAULT null
149 ,p_segment7 VARCHAR2 DEFAULT null
150 ,p_segment8 VARCHAR2 DEFAULT null
151 ,p_segment9 VARCHAR2 DEFAULT null
152 ,p_segment10 VARCHAR2 DEFAULT null
153 ,p_segment11 VARCHAR2 DEFAULT null
154 ,p_segment12 VARCHAR2 DEFAULT null
155 ,p_segment13 VARCHAR2 DEFAULT null
159 ,p_segment17 VARCHAR2 DEFAULT null
156 ,p_segment14 VARCHAR2 DEFAULT null
157 ,p_segment15 VARCHAR2 DEFAULT null
158 ,p_segment16 VARCHAR2 DEFAULT null
160 ,p_segment18 VARCHAR2 DEFAULT null
161 ,p_segment19 VARCHAR2 DEFAULT null
162 ,p_segment20 VARCHAR2 DEFAULT null
163 ,p_segment21 VARCHAR2 DEFAULT null
164 ,p_segment22 VARCHAR2 DEFAULT null
165 ,p_segment23 VARCHAR2 DEFAULT null
166 ,p_segment24 VARCHAR2 DEFAULT null
167 ,p_segment25 VARCHAR2 DEFAULT null
168 ,p_segment26 VARCHAR2 DEFAULT null
169 ,p_segment27 VARCHAR2 DEFAULT null
170 ,p_segment28 VARCHAR2 DEFAULT null
171 ,p_segment29 VARCHAR2 DEFAULT null
172 ,p_segment30 VARCHAR2 DEFAULT null
173 ) return NUMBER;
174 --
175 --
176 FUNCTION create_position
177 (p_default VARCHAR2 DEFAULT 'Y'
178 ,p_name VARCHAR2
179 ,p_business_group VARCHAR2
180 ,p_date_effective DATE
181 ,p_date_end DATE DEFAULT null
182 ,p_job VARCHAR2
183 ,p_organization VARCHAR2
184 ,p_location VARCHAR2 DEFAULT null
185 ,p_time_normal_start VARCHAR2 DEFAULT '08:00'
186 ,p_time_normal_finish VARCHAR2 DEFAULT '17:30'
187 ,p_working_hours NUMBER DEFAULT 37.5
188 ,p_frequency VARCHAR2 DEFAULT 'W'
189 ,p_probation_period VARCHAR2 DEFAULT null
190 ,p_probation_units VARCHAR2 DEFAULT null
191 ,p_relief_position VARCHAR2 DEFAULT null
192 ,p_replacement_required VARCHAR2 DEFAULT 'N'
193 ,p_successor_position VARCHAR2 DEFAULT null
194 ,p_segment1 VARCHAR2 DEFAULT null
195 ,p_segment2 VARCHAR2 DEFAULT null
196 ,p_segment3 VARCHAR2 DEFAULT null
197 ,p_segment4 VARCHAR2 DEFAULT null
198 ,p_segment5 VARCHAR2 DEFAULT null
199 ,p_segment6 VARCHAR2 DEFAULT null
200 ,p_segment7 VARCHAR2 DEFAULT null
201 ,p_segment8 VARCHAR2 DEFAULT null
202 ,p_segment9 VARCHAR2 DEFAULT null
203 ,p_segment10 VARCHAR2 DEFAULT null
204 ,p_segment11 VARCHAR2 DEFAULT null
205 ,p_segment12 VARCHAR2 DEFAULT null
206 ,p_segment13 VARCHAR2 DEFAULT null
207 ,p_segment14 VARCHAR2 DEFAULT null
208 ,p_segment15 VARCHAR2 DEFAULT null
209 ,p_segment16 VARCHAR2 DEFAULT null
210 ,p_segment17 VARCHAR2 DEFAULT null
214 ,p_segment21 VARCHAR2 DEFAULT null
211 ,p_segment18 VARCHAR2 DEFAULT null
212 ,p_segment19 VARCHAR2 DEFAULT null
213 ,p_segment20 VARCHAR2 DEFAULT null
215 ,p_segment22 VARCHAR2 DEFAULT null
216 ,p_segment23 VARCHAR2 DEFAULT null
217 ,p_segment24 VARCHAR2 DEFAULT null
218 ,p_segment25 VARCHAR2 DEFAULT null
219 ,p_segment26 VARCHAR2 DEFAULT null
220 ,p_segment27 VARCHAR2 DEFAULT null
221 ,p_segment28 VARCHAR2 DEFAULT null
222 ,p_segment29 VARCHAR2 DEFAULT null
223 ,p_segment30 VARCHAR2 DEFAULT null
224 ) return NUMBER ;
225 --
226 --
227 FUNCTION create_grade
228 (p_default VARCHAR2 DEFAULT 'Y'
229 ,p_name VARCHAR2
230 ,p_business_group VARCHAR2
231 ,p_date_from DATE
232 ,p_date_to DATE DEFAULT null
233 ,p_sequence VARCHAR2 DEFAULT null
234 ,p_segment1 VARCHAR2 DEFAULT null
235 ,p_segment2 VARCHAR2 DEFAULT null
236 ,p_segment3 VARCHAR2 DEFAULT null
237 ,p_segment4 VARCHAR2 DEFAULT null
238 ,p_segment5 VARCHAR2 DEFAULT null
239 ,p_segment6 VARCHAR2 DEFAULT null
240 ,p_segment7 VARCHAR2 DEFAULT null
241 ,p_segment8 VARCHAR2 DEFAULT null
242 ,p_segment9 VARCHAR2 DEFAULT null
243 ,p_segment10 VARCHAR2 DEFAULT null
244 ,p_segment11 VARCHAR2 DEFAULT null
245 ,p_segment12 VARCHAR2 DEFAULT null
246 ,p_segment13 VARCHAR2 DEFAULT null
247 ,p_segment14 VARCHAR2 DEFAULT null
248 ,p_segment15 VARCHAR2 DEFAULT null
249 ,p_segment16 VARCHAR2 DEFAULT null
250 ,p_segment17 VARCHAR2 DEFAULT null
251 ,p_segment18 VARCHAR2 DEFAULT null
252 ,p_segment19 VARCHAR2 DEFAULT null
253 ,p_segment20 VARCHAR2 DEFAULT null
254 ,p_segment21 VARCHAR2 DEFAULT null
255 ,p_segment22 VARCHAR2 DEFAULT null
256 ,p_segment23 VARCHAR2 DEFAULT null
257 ,p_segment24 VARCHAR2 DEFAULT null
258 ,p_segment25 VARCHAR2 DEFAULT null
259 ,p_segment26 VARCHAR2 DEFAULT null
260 ,p_segment27 VARCHAR2 DEFAULT null
261 ,p_segment28 VARCHAR2 DEFAULT null
265 --
262 ,p_segment29 VARCHAR2 DEFAULT null
263 ,p_segment30 VARCHAR2 DEFAULT null
264 ) return NUMBER;
266 --
267 end per_db_per_setup;