[Home] [Help]
1 PACKAGE PER_PEOPLE_V14_PKG AS
2 /* $Header: peper14t.pkh 120.0 2005/05/31 13:41:55 appldev noship $ */
3 PROCEDURE form_startup(X_Business_group_id IN OUT NOCOPY NUMBER
4 ,X_Set_Of_Books_Id IN OUT NOCOPY NUMBER
5 ,X_Resp_Appl_Id NUMBER
6 ,X_Resp_Id NUMBER
7 ,X_Legislation_Code IN OUT NOCOPY VARCHAR2
8 ,X_business_group_name IN OUT NOCOPY VARCHAR2
9 ,X_property_on NUMBER
10 ,X_property_off NUMBER
11 ,X_Query_Only_Flag VARCHAR2
12 ,X_employee_property IN OUT NOCOPY NUMBER
13 ,X_expense_check_to_address IN OUT NOCOPY VARCHAR2
14 ,X_expense_to_address_meaning IN OUT NOCOPY VARCHAR2
15 ,X_chart_of_accounts_id IN OUT NOCOPY NUMBER
16 ,X_set_of_books_name IN OUT NOCOPY VARCHAR2
17 ,X_Session_Date IN OUT NOCOPY DATE
18 ,X_End_Of_Time IN OUT NOCOPY DATE
19 ,X_current_appl_id IN OUT NOCOPY NUMBER
20 ,X_person_type_id IN OUT NOCOPY NUMBER
21 ,X_current_employee_flag IN OUT NOCOPY VARCHAR2
22 ,X_current_applicant_flag IN OUT NOCOPY VARCHAR2
23 ,X_current_emp_or_apl_flag IN OUT NOCOPY VARCHAR2);
24
25 --
26 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
27 X_Person_Id IN OUT NOCOPY NUMBER,
28 X_Party_Id NUMBER DEFAULT NULL,
29 X_Effective_Start_Date DATE,
30 X_Effective_End_Date DATE,
31 X_Business_Group_Id NUMBER,
32 X_Person_Type_Id NUMBER,
33 X_Last_Name VARCHAR2,
34 X_Start_Date DATE,
35 X_Applicant_Number VARCHAR2,
36 X_Comment_Id NUMBER,
37 X_Current_Applicant_Flag VARCHAR2,
38 X_Current_Emp_Or_Apl_Flag VARCHAR2,
39 X_Current_Employee_Flag VARCHAR2,
40 X_Date_Employee_Data_Verified DATE,
41 X_Date_Of_Birth DATE,
42 X_Email_Address VARCHAR2,
43 X_Employee_Number VARCHAR2,
44 X_Expense_Check_To_Address VARCHAR2,
45 X_First_Name VARCHAR2,
46 X_Full_Name VARCHAR2,
47 X_Known_As VARCHAR2,
48 X_Marital_Status VARCHAR2,
49 X_Middle_Names VARCHAR2,
50 X_Nationality VARCHAR2,
51 X_National_Identifier VARCHAR2,
52 X_Previous_Last_Name VARCHAR2,
53 X_Registered_Disabled_Flag VARCHAR2,
54 X_Sex VARCHAR2,
55 X_Title VARCHAR2,
56 X_Vendor_Id NUMBER,
57 X_Work_Telephone VARCHAR2,
58 X_Attribute_Category VARCHAR2,
59 X_Attribute1 VARCHAR2,
60 X_Attribute2 VARCHAR2,
61 X_Attribute3 VARCHAR2,
62 X_Attribute4 VARCHAR2,
63 X_Attribute5 VARCHAR2,
64 X_Attribute6 VARCHAR2,
65 X_Attribute7 VARCHAR2,
66 X_Attribute8 VARCHAR2,
67 X_Attribute9 VARCHAR2,
68 X_Attribute10 VARCHAR2,
69 X_Attribute11 VARCHAR2,
70 X_Attribute12 VARCHAR2,
71 X_Attribute13 VARCHAR2,
72 X_Attribute14 VARCHAR2,
73 X_Attribute15 VARCHAR2,
74 X_Attribute16 VARCHAR2,
75 X_Attribute17 VARCHAR2,
76 X_Attribute18 VARCHAR2,
77 X_Attribute19 VARCHAR2,
78 X_Attribute20 VARCHAR2,
79 X_Attribute21 VARCHAR2,
80 X_Attribute22 VARCHAR2,
81 X_Attribute23 VARCHAR2,
82 X_Attribute24 VARCHAR2,
83 X_Attribute25 VARCHAR2,
84 X_Attribute26 VARCHAR2,
85 X_Attribute27 VARCHAR2,
86 X_Attribute28 VARCHAR2,
87 X_Attribute29 VARCHAR2,
88 X_Attribute30 VARCHAR2,
89 X_Per_Information_Category VARCHAR2,
90 X_Per_Information1 VARCHAR2,
91 X_Per_Information2 VARCHAR2,
92 X_Per_Information3 VARCHAR2,
93 X_Per_Information4 VARCHAR2,
94 X_Per_Information5 VARCHAR2,
95 X_Per_Information6 VARCHAR2,
96 X_Per_Information7 VARCHAR2,
97 X_Per_Information8 VARCHAR2,
98 X_Per_Information9 VARCHAR2,
99 X_Per_Information10 VARCHAR2,
100 X_Per_Information11 VARCHAR2,
101 X_Per_Information12 VARCHAR2,
102 X_Per_Information13 VARCHAR2,
103 X_Per_Information14 VARCHAR2,
104 X_Per_Information15 VARCHAR2,
105 X_Per_Information16 VARCHAR2,
106 X_Per_Information17 VARCHAR2,
107 X_Per_Information18 VARCHAR2,
108 X_Per_Information19 VARCHAR2,
109 X_Per_Information20 VARCHAR2,
110 X_Per_Information21 VARCHAR2,
111 X_Per_Information22 VARCHAR2,
112 X_Per_Information23 VARCHAR2,
113 X_Per_Information24 VARCHAR2,
114 X_Per_Information25 VARCHAR2,
115 X_Per_Information26 VARCHAR2,
116 X_Per_Information27 VARCHAR2,
117 X_Per_Information28 VARCHAR2,
118 X_Per_Information29 VARCHAR2,
119 X_Per_Information30 VARCHAR2,
120 X_Last_Update_Date DATE,
121 X_Last_Updated_By NUMBER,
122 X_Last_Update_Login NUMBER,
123 X_Created_By NUMBER,
124 X_Creation_Date DATE,
125 X_Order_Name VARCHAR2,
126 X_Global_Name VARCHAR2,
127 X_Local_Name VARCHAR2,
128 X_PERIOD_OF_SERVICE_ID IN OUT NOCOPY NUMBER,
129 X_town_of_birth VARCHAR2 DEFAULT NULL,
130 X_region_of_birth VARCHAR2 DEFAULT NULL,
131 X_country_of_birth VARCHAR2 DEFAULT NULL,
132 X_global_person_id VARCHAR2 DEFAULT NULL,
133 X_blood_type VARCHAR2 default NULL,
134 X_correspondence_language VARCHAR2 default NULL,
135 X_honors VARCHAR2 default NULL,
136 X_pre_name_adjunct VARCHAR2 default NULL,
137 X_rehire_authorizor VARCHAR2 default NULL,
138 X_rehire_recommendation VARCHAR2 default NULL,
139 X_resume_exists VARCHAR2 default NULL,
140 X_resume_last_updated DATE default NULL,
141 X_second_passport_exists VARCHAR2 default NULL,
142 X_student_status VARCHAR2 default NULL,
143 X_suffix VARCHAR2 default NULL,
144 X_date_of_death DATE default NULL,
145 X_uses_tobacco_flag VARCHAR2 default NULL,
146 X_fast_path_employee VARCHAR2 default NULL,
147 X_fte_capacity VARCHAR2 default NULL
148 );
149 --
150 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
151 X_Person_Id NUMBER,
152 X_Effective_Start_Date DATE,
153 X_Effective_End_Date DATE,
154 X_Business_Group_Id NUMBER,
155 X_Person_Type_Id NUMBER,
156 X_Last_Name VARCHAR2,
157 X_Start_Date DATE,
158 X_Applicant_Number VARCHAR2,
159 X_Comment_Id NUMBER,
160 X_Current_Applicant_Flag VARCHAR2,
161 X_Current_Emp_Or_Apl_Flag VARCHAR2,
162 X_Current_Employee_Flag VARCHAR2,
163 X_Date_Employee_Data_Verified DATE,
164 X_Date_Of_Birth DATE,
165 X_Email_Address VARCHAR2,
166 X_Employee_Number VARCHAR2,
167 X_Expense_Check_To_Address VARCHAR2,
168 X_First_Name VARCHAR2,
169 X_Full_Name VARCHAR2,
170 X_Known_As VARCHAR2,
171 X_Marital_Status VARCHAR2,
172 X_Middle_Names VARCHAR2,
173 X_Nationality VARCHAR2,
174 X_National_Identifier VARCHAR2,
175 X_Previous_Last_Name VARCHAR2,
176 X_Registered_Disabled_Flag VARCHAR2,
177 X_Sex VARCHAR2,
178 X_Title VARCHAR2,
179 X_Vendor_Id NUMBER,
180 X_Work_Telephone VARCHAR2,
181 X_Attribute_Category VARCHAR2,
182 X_Attribute1 VARCHAR2,
183 X_Attribute2 VARCHAR2,
184 X_Attribute3 VARCHAR2,
185 X_Attribute4 VARCHAR2,
186 X_Attribute5 VARCHAR2,
187 X_Attribute6 VARCHAR2,
188 X_Attribute7 VARCHAR2,
189 X_Attribute8 VARCHAR2,
190 X_Attribute9 VARCHAR2,
191 X_Attribute10 VARCHAR2,
192 X_Attribute11 VARCHAR2,
193 X_Attribute12 VARCHAR2,
194 X_Attribute13 VARCHAR2,
195 X_Attribute14 VARCHAR2,
196 X_Attribute15 VARCHAR2,
197 X_Attribute16 VARCHAR2,
198 X_Attribute17 VARCHAR2,
199 X_Attribute18 VARCHAR2,
200 X_Attribute19 VARCHAR2,
201 X_Attribute20 VARCHAR2,
202 X_Attribute21 VARCHAR2,
203 X_Attribute22 VARCHAR2,
204 X_Attribute23 VARCHAR2,
205 X_Attribute24 VARCHAR2,
206 X_Attribute25 VARCHAR2,
207 X_Attribute26 VARCHAR2,
208 X_Attribute27 VARCHAR2,
209 X_Attribute28 VARCHAR2,
210 X_Attribute29 VARCHAR2,
211 X_Attribute30 VARCHAR2,
212 X_Per_Information_Category VARCHAR2,
213 X_Per_Information1 VARCHAR2,
214 X_Per_Information2 VARCHAR2,
215 X_Per_Information3 VARCHAR2,
216 X_Per_Information4 VARCHAR2,
217 X_Per_Information5 VARCHAR2,
218 X_Per_Information6 VARCHAR2,
219 X_Per_Information7 VARCHAR2,
220 X_Per_Information8 VARCHAR2,
221 X_Per_Information9 VARCHAR2,
222 X_Per_Information10 VARCHAR2,
223 X_Per_Information11 VARCHAR2,
224 X_Per_Information12 VARCHAR2,
225 X_Per_Information13 VARCHAR2,
226 X_Per_Information14 VARCHAR2,
227 X_Per_Information15 VARCHAR2,
228 X_Per_Information16 VARCHAR2,
229 X_Per_Information17 VARCHAR2,
230 X_Per_Information18 VARCHAR2,
231 X_Per_Information19 VARCHAR2,
232 X_Per_Information20 VARCHAR2,
233 X_Per_Information21 VARCHAR2,
234 X_Per_Information22 VARCHAR2,
235 X_Per_Information23 VARCHAR2,
236 X_Per_Information24 VARCHAR2,
237 X_Per_Information25 VARCHAR2,
238 X_Per_Information26 VARCHAR2,
239 X_Per_Information27 VARCHAR2,
240 X_Per_Information28 VARCHAR2,
241 X_Per_Information29 VARCHAR2,
242 X_Per_Information30 VARCHAR2
243 );
244
245 PROCEDURE Insert_period_of_Service(X_Person_Id NUMBER
246 ,X_Business_Group_Id NUMBER
247 ,X_Date_Start DATE
248 ,X_Period_of_Service_Id IN OUT NOCOPY NUMBER
249 );
250
251 --
252 END PER_PEOPLE_V14_PKG;
|
|
|
|