[Home] [Help]
PACKAGE: APPS.HR_PERSON_RECORD
Source
1 PACKAGE HR_PERSON_RECORD AUTHID CURRENT_USER AS
2 /* $Header: peperqry.pkh 120.5 2011/10/03 10:09:25 srannama ship $ */
3 /*#
4 * This is the source file to HR_PERSON_RECORD
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname HR Person Record
8 */
9
10 -- Record for search criteria
11 Type srch_criteria_record is RECORD
12 (p_person_id per_all_people_f.person_id%type default null,
13 p_start_person_id per_all_people_f.person_id%type default null,
14 p_end_person_id per_all_people_f.person_id%type default null,
15 p_assignment_id per_all_assignments_f.assignment_id%type default null,
16 p_first_name per_all_people_f.first_name%type default null,
17 p_last_name per_all_people_f.last_name%type default null,
18 p_bgrp_name hr_all_organization_units.name%type default null,
19 p_bgrp_id hr_all_organization_units.business_group_id%type default null,
20 p_effective_date date,
21 p_employee_no per_all_people_f.employee_number%type default null,
22 p_applicant_no per_all_people_f.applicant_number%type default null,
23 p_cwk_no per_all_people_f.npw_number%type default null,
24 p_person_type PER_PERSON_TYPES_TL.user_person_type%TYPE default null,
25 p_employee_category hr_lookups.meaning%type default null,
26 p_employment_category hr_lookups.meaning%type default null,
27 p_phone_id per_phones.phone_id%type default null,
28 p_qualification_id per_qualifications.qualification_id%type default null,
29 p_delivery_method_id per_person_dlvry_methods.delivery_method_id%type default null,
30 p_address_id per_addresses.address_id%type default null);
31
32 -- Search criteria as table type
33 Type srch_criteria is table of srch_criteria_record INDEX BY BINARY_INTEGER;
34
35 /*This Table holds the list of options*/
36
37 type options is table of varchar2(200) index by binary_integer;
38
39 /*Record type for person details*/
40 TYPE person_details IS RECORD
41 (
42 PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
43 EFFECTIVE_START_DATE varchar2(10),
44 EFFECTIVE_END_DATE varchar2(10),
45 BUSINESS_GROUP_ID PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE,
46 BUSINESS_GROUP_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE, -- (BASED ON LANG)
47 PERSON_TYPE_ID PER_ALL_PEOPLE_F.PERSON_TYPE_ID%TYPE,
48 USER_PERSN_TYPE PER_PERSON_TYPES_TL.user_person_type%TYPE,
49 SYSTEM_PERSON_TYPE PER_PERSON_TYPES.system_person_type%TYPE,
50 LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE,
51 START_DATE varchar2(10),
52 APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
53 BACKGROUND_CHECK_STATUS PER_ALL_PEOPLE_F.BACKGROUND_CHECK_STATUS%TYPE,
54 BACKGROUND_DATE_CHECK varchar2(10),
55 BLOOD_TYPE PER_ALL_PEOPLE_F.BLOOD_TYPE%TYPE,
56 BLOOD_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'BLOOD_TYPE')
57 COMMENT_ID PER_ALL_PEOPLE_F.COMMENT_ID%TYPE,
58 CORRESPONDENCE_LANGUAGE PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE%TYPE,
59 CORRESPONDENCE_LANGUAGE_DESC FND_LANGUAGES_VL.DESCRIPTION%TYPE,
60 CURRENT_APPLICANT_FLAG PER_ALL_PEOPLE_F.CURRENT_APPLICANT_FLAG%TYPE,
61 CURRENT_EMP_OR_APL_FLAG PER_ALL_PEOPLE_F.CURRENT_EMP_OR_APL_FLAG%TYPE,
62 CURRENT_EMPLOYEE_FLAG PER_ALL_PEOPLE_F.CURRENT_EMPLOYEE_FLAG%TYPE,
63 DATE_EMPLOYEE_DATA_VERIFIED varchar2(10),
64 DATE_OF_BIRTH varchar2(10),
65 EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%TYPE,
66 EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
67 EXPENSE_CHECK_SEND_TO_ADDRESS PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS%TYPE,
68 FAST_PATH_EMPLOYEE PER_ALL_PEOPLE_F.FAST_PATH_EMPLOYEE%TYPE,
69 FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE,
70 FTE_CAPACITY PER_ALL_PEOPLE_F.FTE_CAPACITY%TYPE,
71 FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
72 HOLD_APPLICANT_DATE_UNTIL varchar2(10),
73 HONORS PER_ALL_PEOPLE_F.HONORS%TYPE,
74 INTERNAL_LOCATION PER_ALL_PEOPLE_F.INTERNAL_LOCATION%TYPE,
75 KNOWN_AS PER_ALL_PEOPLE_F.KNOWN_AS%TYPE,
76 LAST_MEDICAL_TEST_BY PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY%TYPE,
77 LAST_MEDICAL_TEST_DATE varchar2(10),
78 MAILSTOP PER_ALL_PEOPLE_F.MAILSTOP%TYPE,
79 MARITAL_STATUS PER_ALL_PEOPLE_F.MARITAL_STATUS%TYPE,
80 MARITAL_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'MARITAL_STATUS')
81 MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE,
82 NATIONALITY PER_ALL_PEOPLE_F.NATIONALITY%TYPE,
83 NATIONALITY_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'NATIONALITY')
84 NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE,
85 NATIONAL_ID_LABEL VARCHAR2(200),
86 OFFICE_NUMBER PER_ALL_PEOPLE_F.OFFICE_NUMBER%TYPE,
87 ON_MILITARY_SERVICE PER_ALL_PEOPLE_F.ON_MILITARY_SERVICE%TYPE,
88 ORDER_NAME PER_ALL_PEOPLE_F.ORDER_NAME%TYPE,
89 PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%TYPE,
90 PREVIOUS_LAST_NAME PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME%TYPE,
91 PROJECTED_START_DATE varchar2(10),
92 REHIRE_AUTHORIZOR PER_ALL_PEOPLE_F.REHIRE_AUTHORIZOR%TYPE,
93 REHIRE_REASON PER_ALL_PEOPLE_F.REHIRE_REASON%TYPE,
94 REHIRE_RECOMMENDATION PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION%TYPE, -- CHECK BOX
95 RESUME_EXISTS PER_ALL_PEOPLE_F.RESUME_EXISTS%TYPE, -- (CHECK BOX)
96 RESUME_LAST_UPDATED varchar2(10),
97 REGISTERED_DISABLED_FLAG PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG%TYPE,
98 SECOND_PASSPORT_EXISTS PER_ALL_PEOPLE_F.SECOND_PASSPORT_EXISTS%TYPE, -- CHECK BOX
99 SEX PER_ALL_PEOPLE_F.SEX%TYPE,
100 SEX_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'SEX')
101 STUDENT_STATUS PER_ALL_PEOPLE_F.STUDENT_STATUS%TYPE,
102 STUDENT_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'STUDENT_STATUS')
103 SUFFIX PER_ALL_PEOPLE_F.SUFFIX%TYPE,
104 TITLE PER_ALL_PEOPLE_F.TITLE%TYPE,
105 TITLE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'TITLE')
106 VENDOR_ID PER_ALL_PEOPLE_F.VENDOR_ID%TYPE,
107 WORK_SCHEDULE PER_ALL_PEOPLE_F.WORK_SCHEDULE%TYPE,
108 WORK_SCHEDULE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'WORK_SCHEDULE')
109 WORK_TELEPHONE PER_ALL_PEOPLE_F.WORK_TELEPHONE%TYPE,
110 COORD_BEN_MED_PLN_NO PER_ALL_PEOPLE_F.COORD_BEN_MED_PLN_NO%TYPE,
111 COORD_BEN_NO_CVG_FLAG PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG%TYPE, -- CHECK BOX
112 DPDNT_ADOPTION_DATE varchar2(10),
113 DPDNT_VLNTRY_SVCE_FLAG PER_ALL_PEOPLE_F.DPDNT_VLNTRY_SVCE_FLAG%TYPE, -- CHECK BOX
114 RECEIPT_OF_DEATH_CERT_DATE varchar2(10),
115 USES_TOBACCO_FLAG PER_ALL_PEOPLE_F.USES_TOBACCO_FLAG%TYPE,
116 USES_TOBACCO_FLAG_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'TOBACCO_USER')
117 BENEFIT_GROUP_ID PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID%TYPE,
118 BENEFIT_GROUP_NAME BEN_BENFTS_GRP.NAME%TYPE,
119 ATTRIBUTE_CATEGORY PER_ALL_PEOPLE_F.ATTRIBUTE_CATEGORY%TYPE,
120 ATTRIBUTE1 PER_ALL_PEOPLE_F.ATTRIBUTE1%TYPE,
121 ATTRIBUTE2 PER_ALL_PEOPLE_F.ATTRIBUTE2%TYPE,
122 ATTRIBUTE3 PER_ALL_PEOPLE_F.ATTRIBUTE3%TYPE,
123 ATTRIBUTE4 PER_ALL_PEOPLE_F.ATTRIBUTE4%TYPE,
124 ATTRIBUTE5 PER_ALL_PEOPLE_F.ATTRIBUTE5%TYPE,
125 ATTRIBUTE6 PER_ALL_PEOPLE_F.ATTRIBUTE6%TYPE,
126 ATTRIBUTE7 PER_ALL_PEOPLE_F.ATTRIBUTE7%TYPE,
127 ATTRIBUTE8 PER_ALL_PEOPLE_F.ATTRIBUTE8%TYPE,
128 ATTRIBUTE9 PER_ALL_PEOPLE_F.ATTRIBUTE9%TYPE,
129 ATTRIBUTE10 PER_ALL_PEOPLE_F.ATTRIBUTE10%TYPE,
130 ATTRIBUTE11 PER_ALL_PEOPLE_F.ATTRIBUTE11%TYPE,
131 ATTRIBUTE12 PER_ALL_PEOPLE_F.ATTRIBUTE12%TYPE,
132 ATTRIBUTE13 PER_ALL_PEOPLE_F.ATTRIBUTE13%TYPE,
133 ATTRIBUTE14 PER_ALL_PEOPLE_F.ATTRIBUTE14%TYPE,
134 ATTRIBUTE15 PER_ALL_PEOPLE_F.ATTRIBUTE15%TYPE,
135 ATTRIBUTE16 PER_ALL_PEOPLE_F.ATTRIBUTE16%TYPE,
136 ATTRIBUTE17 PER_ALL_PEOPLE_F.ATTRIBUTE17%TYPE,
137 ATTRIBUTE18 PER_ALL_PEOPLE_F.ATTRIBUTE18%TYPE,
138 ATTRIBUTE19 PER_ALL_PEOPLE_F.ATTRIBUTE19%TYPE,
139 ATTRIBUTE20 PER_ALL_PEOPLE_F.ATTRIBUTE20%TYPE,
140 ATTRIBUTE21 PER_ALL_PEOPLE_F.ATTRIBUTE21%TYPE,
141 ATTRIBUTE22 PER_ALL_PEOPLE_F.ATTRIBUTE22%TYPE,
142 ATTRIBUTE23 PER_ALL_PEOPLE_F.ATTRIBUTE23%TYPE,
143 ATTRIBUTE24 PER_ALL_PEOPLE_F.ATTRIBUTE24%TYPE,
144 ATTRIBUTE25 PER_ALL_PEOPLE_F.ATTRIBUTE25%TYPE,
145 ATTRIBUTE26 PER_ALL_PEOPLE_F.ATTRIBUTE26%TYPE,
146 ATTRIBUTE27 PER_ALL_PEOPLE_F.ATTRIBUTE27%TYPE,
147 ATTRIBUTE28 PER_ALL_PEOPLE_F.ATTRIBUTE28%TYPE,
148 ATTRIBUTE29 PER_ALL_PEOPLE_F.ATTRIBUTE29%TYPE,
149 ATTRIBUTE30 PER_ALL_PEOPLE_F.ATTRIBUTE30%TYPE,
150 PER_INFORMATION_CATEGORY PER_ALL_PEOPLE_F.PER_INFORMATION_CATEGORY%TYPE,
151 PER_INFORMATION1 PER_ALL_PEOPLE_F.PER_INFORMATION1%TYPE,
152 PER_INFORMATION2 PER_ALL_PEOPLE_F.PER_INFORMATION2%TYPE,
153 PER_INFORMATION3 PER_ALL_PEOPLE_F.PER_INFORMATION3%TYPE,
154 PER_INFORMATION4 PER_ALL_PEOPLE_F.PER_INFORMATION4%TYPE,
155 PER_INFORMATION5 PER_ALL_PEOPLE_F.PER_INFORMATION5%TYPE,
156 PER_INFORMATION6 PER_ALL_PEOPLE_F.PER_INFORMATION6%TYPE,
157 PER_INFORMATION7 PER_ALL_PEOPLE_F.PER_INFORMATION7%TYPE,
158 PER_INFORMATION8 PER_ALL_PEOPLE_F.PER_INFORMATION8%TYPE,
159 PER_INFORMATION9 PER_ALL_PEOPLE_F.PER_INFORMATION9%TYPE,
160 PER_INFORMATION10 PER_ALL_PEOPLE_F.PER_INFORMATION10%TYPE,
161 PER_INFORMATION11 PER_ALL_PEOPLE_F.PER_INFORMATION11%TYPE,
162 PER_INFORMATION12 PER_ALL_PEOPLE_F.PER_INFORMATION12%TYPE,
163 PER_INFORMATION13 PER_ALL_PEOPLE_F.PER_INFORMATION13%TYPE,
164 PER_INFORMATION14 PER_ALL_PEOPLE_F.PER_INFORMATION14%TYPE,
165 PER_INFORMATION15 PER_ALL_PEOPLE_F.PER_INFORMATION15%TYPE,
166 PER_INFORMATION16 PER_ALL_PEOPLE_F.PER_INFORMATION16%TYPE,
167 PER_INFORMATION17 PER_ALL_PEOPLE_F.PER_INFORMATION17%TYPE,
168 PER_INFORMATION18 PER_ALL_PEOPLE_F.PER_INFORMATION18%TYPE,
169 PER_INFORMATION19 PER_ALL_PEOPLE_F.PER_INFORMATION19%TYPE,
170 PER_INFORMATION20 PER_ALL_PEOPLE_F.PER_INFORMATION20%TYPE,
171 PER_INFORMATION21 PER_ALL_PEOPLE_F.PER_INFORMATION21%TYPE,
172 PER_INFORMATION22 PER_ALL_PEOPLE_F.PER_INFORMATION22%TYPE,
173 PER_INFORMATION23 PER_ALL_PEOPLE_F.PER_INFORMATION23%TYPE,
174 PER_INFORMATION24 PER_ALL_PEOPLE_F.PER_INFORMATION24%TYPE,
175 PER_INFORMATION25 PER_ALL_PEOPLE_F.PER_INFORMATION25%TYPE,
176 PER_INFORMATION26 PER_ALL_PEOPLE_F.PER_INFORMATION26%TYPE,
177 PER_INFORMATION27 PER_ALL_PEOPLE_F.PER_INFORMATION27%TYPE,
178 PER_INFORMATION28 PER_ALL_PEOPLE_F.PER_INFORMATION28%TYPE,
179 PER_INFORMATION29 PER_ALL_PEOPLE_F.PER_INFORMATION29%TYPE,
180 PER_INFORMATION30 PER_ALL_PEOPLE_F.PER_INFORMATION30%TYPE,
181 DATE_OF_DEATH varchar2(10),
182 ORIGINAL_DATE_OF_HIRE varchar2(10),
183 ADJUSTED_SVC_DATE varchar2(10),
184 DATE_START varchar2(10),
185 ACCEPTED_TERMINATION_DATE varchar2(10),
186 ACTUAL_TERMINATION_DATE varchar2(10),
187 FINAL_PROCESS_DATE varchar2(10),
188 LAST_STANDARD_PROCESS_DATE varchar2(10),
189 LEAVING_REASON PER_PERIODS_OF_SERVICE.LEAVING_REASON%TYPE,
190 TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%TYPE,
191 REGION_OF_BIRTH PER_ALL_PEOPLE_F.REGION_OF_BIRTH%TYPE,
192 COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%TYPE,
193 COUNTRY_OF_BIRTH_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
194 GLOBAL_PERSON_ID PER_ALL_PEOPLE_F.GLOBAL_PERSON_ID%TYPE,
195 COORD_BEN_MED_PL_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_PL_NAME%TYPE,
196 COORD_BEN_MED_INSR_CRR_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME%TYPE,
197 COORD_BEN_MED_INSR_CRR_IDENT PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_IDENT%TYPE,
198 COORD_BEN_MED_EXT_ER PER_ALL_PEOPLE_F.COORD_BEN_MED_EXT_ER%TYPE,
199 COORD_BEN_MED_CVG_STRT_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT%TYPE,
200 COORD_BEN_MED_CVG_END_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT%TYPE,
201 PARTY_ID PER_ALL_PEOPLE_F.PARTY_ID%TYPE,
202 NPW_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE,
203 CURRENT_NPW_FLAG PER_ALL_PEOPLE_F.CURRENT_NPW_FLAG%TYPE,
204 GLOBAL_NAME PER_ALL_PEOPLE_F.GLOBAL_NAME%TYPE,
205 LOCAL_NAME PER_ALL_PEOPLE_F.LOCAL_NAME%TYPE
206 );
207 /*Record type for assignment details*/
208 TYPE ASSGN_DETAILS is record
209 (
210 ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE
211 , EFFECTIVE_START_DATE varchar2(10)
212 , EFFECTIVE_END_DATE varchar2(10)
213 , RECRUITER_ID PER_ALL_ASSIGNMENTS_F.RECRUITER_ID%TYPE
214 , GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE
215 , GRADE_DESC PER_GRADES_TL.NAME%TYPE --(BASED ON LANG)
216 , POSITION_ID PER_ALL_ASSIGNMENTS_F.POSITION_ID%TYPE
217 , POSITION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE --(BASED ON LANG)
218 , JOB_ID PER_ALL_ASSIGNMENTS_F.JOB_ID%TYPE
219 , JOB_DESC PER_JOBS_TL.NAME%TYPE --(BASED ON LANG)
220 , ASSIGNMENT_STATUS_TYPE_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE
221 , USER_STATUS PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE
222 , PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE
223 , PER_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PER_SYSTEM_STATUS%TYPE
224 , PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE
225 , PAYROLL_DESC PAY_PAYROLLS_F.PAYROLL_NAME%TYPE
226 , LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE
227 , LOCATION_DESC HR_LOCATIONS_ALL_TL.DESCRIPTION%TYPE --(BASED ON LANG)
228 , PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE
229 , SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE
230 , SUPERVISOR_EMP_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
231 , SUPERVISOR_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE
232 , SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE
233 , SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE
234 , RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE
235 , SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE
236 , ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE
237 , ORGANIZATION_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE -- (BASED ON LANG)
238 , PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE
239 , SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE
240 , VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE
241 , VACANCY_DESC PER_VACANCIES.NAME%TYPE
242 , PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE
243 , PAY_BASIS_DESC PER_PAY_BASES.NAME%TYPE
244 , ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE
245 , ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE -- LIKE E,C ETC
246 , PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE -- CHECK BOX
247 , APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE
248 , ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
249 , CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE
250 , CHANGE_REASON_DESC FND_LOOKUP_VALUES.MEANING%TYPE -- (BASED ON LANG /'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON')
251 , COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE
252 , DATE_PROBATION_END varchar2(10)
253 , DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE
254 , EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE
255 , EMPLOYMENT_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMP_CAT')
256 , FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE
257 , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
258 , INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE
259 , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX
260 , NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE
261 , PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE
262 , PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE
263 , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
264 , PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE
265 , PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE
266 , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
267 , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')
268 , SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE
269 , SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE
270 , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
271 , SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE
272 , SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE
273 , TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE
274 , TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE
275 , BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE
276 , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')
277 , LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE -- CHECK BOX
278 , HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE
279 , HOURLY_SALARIED_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'HOURLY_SALARIED_CODE')
280 , CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE
281 , COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE
282 , COLLECTIVE_AGREEMENT_DESC PER_COLLECTIVE_AGREEMENTS.NAME%TYPE
283 , CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE
284 , CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE
285 , ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE
286 , ESTABLISHMENT_DESC HR_ESTABLISHMENTS_V.NAME%TYPE
287 , ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE
288 , ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE
289 , ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE
290 , ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE
291 , ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE
292 , ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE
293 , ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE
294 , ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE
295 , ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE
296 , ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE
297 , ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE
298 , ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE
299 , ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE
300 , ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE
301 , ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE
302 , ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE
303 , ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE
304 , ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE
305 , ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE
306 , ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE
307 , ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE
308 , ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE
309 , ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE
310 , ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE
311 , ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE
312 , ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE
313 , ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE
314 , ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE
315 , ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE
316 , ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE
317 , ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE
318 , TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE
319 , NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE
320 , NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE
321 , EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE
322 , EMPLOYEE_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMPLOYEE_CATG')
323 , WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE -- CHECK BOX
324 , JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE
325 , POSTING_CONTENT_ID PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID%TYPE
326 , PERIOD_OF_PLACEMENT_DATE_START varchar2(10)
327 , VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE
328 , VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE
329 , VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE
330 , ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE
331 , PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE
332 , APPLICANT_RANK PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK%TYPE
333 , VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE
334 , PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE
335 , PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE
336 , PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE
337 , GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE
338 , GRADE_LADDER_PGM_NAME BEN_PGM_F.NAME%TYPE -- FOR PGM TYPE CODE GSP
339 , SUPERVISOR_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID%TYPE
340 );
341
342 /*Record Type definition for Location Address*/
343
344 TYPE ASSGN_LOCN_ADDRESS IS RECORD
345 ( LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE
346 , STYLE HR_LOCATIONS_ALL.STYLE%TYPE
347 , STYLE_DESC VARCHAR2(100)
348 , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
349 , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
350 , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
351 , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
352 , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
353 , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
354 , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
355 , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
356 , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
357 , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
358 , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
359 , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
360 , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
361 , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
362 , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
363 , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
364 , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
365 , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
366 , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
367 , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE
368 , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE
369 );
370
371 /*Record type for assignment details with location address*/
372
373 TYPE ASSIGNMENT_DETAILS is RECORD
374 (ASG_DETAILS ASSGN_DETAILS,
375 ASG_LOC_ADDR ASSGN_LOCN_ADDRESS);
376
377 /*Record type for contact details*/
378 TYPE contact_details IS RECORD
379 (
380 CONTACT_RELATIONSHIP_ID PER_CONTACT_RELATIONSHIPS.CONTACT_RELATIONSHIP_ID%TYPE,
381 CONTACT_PERSON_ID PER_CONTACT_RELATIONSHIPS.CONTACT_PERSON_ID%TYPE,
382 CONTACT_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
383 CONTACT_TYPE PER_CONTACT_RELATIONSHIPS.CONTACT_TYPE%TYPE,
384 CONTACT_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE, -- 'CONTACT'
385 PRIMARY_CONTACT_FLAG PER_CONTACT_RELATIONSHIPS.PRIMARY_CONTACT_FLAG%TYPE,
386 DATE_START varchar2(10),
387 START_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.START_LIFE_REASON_ID%TYPE,
388 DATE_END varchar2(10),
389 END_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.END_LIFE_REASON_ID%TYPE,
390 RLTD_PER_RSDS_W_DSGNTR_FLAG PER_CONTACT_RELATIONSHIPS.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE,
391 PERSONAL_FLAG PER_CONTACT_RELATIONSHIPS.PERSONAL_FLAG%TYPE,
392 SEQUENCE_NUMBER PER_CONTACT_RELATIONSHIPS.SEQUENCE_NUMBER%TYPE,
393 CONT_ATTRIBUTE_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE_CATEGORY%TYPE,
394 CONT_ATTRIBUTE1 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE1%TYPE,
395 CONT_ATTRIBUTE2 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE2%TYPE,
396 CONT_ATTRIBUTE3 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE3%TYPE,
397 CONT_ATTRIBUTE4 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE4%TYPE,
398 CONT_ATTRIBUTE5 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE5%TYPE,
399 CONT_ATTRIBUTE6 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE6%TYPE,
400 CONT_ATTRIBUTE7 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE7%TYPE,
401 CONT_ATTRIBUTE8 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE8%TYPE,
402 CONT_ATTRIBUTE9 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE9%TYPE,
403 CONT_ATTRIBUTE10 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE10%TYPE,
404 CONT_ATTRIBUTE11 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE11%TYPE,
405 CONT_ATTRIBUTE12 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE12%TYPE,
406 CONT_ATTRIBUTE13 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE13%TYPE,
407 CONT_ATTRIBUTE14 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE14%TYPE,
408 CONT_ATTRIBUTE15 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE15%TYPE,
409 CONT_ATTRIBUTE16 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE16%TYPE,
410 CONT_ATTRIBUTE17 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE17%TYPE,
411 CONT_ATTRIBUTE18 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE18%TYPE,
412 CONT_ATTRIBUTE19 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE19%TYPE,
413 CONT_ATTRIBUTE20 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE20%TYPE,
414 THIRD_PARTY_PAY_FLAG PER_CONTACT_RELATIONSHIPS.THIRD_PARTY_PAY_FLAG%TYPE,
415 BONDHOLDER_FLAG PER_CONTACT_RELATIONSHIPS.BONDHOLDER_FLAG%TYPE,
416 DEPENDENT_FLAG PER_CONTACT_RELATIONSHIPS.DEPENDENT_FLAG%TYPE,
417 BENEFICIARY_FLAG PER_CONTACT_RELATIONSHIPS.BENEFICIARY_FLAG%TYPE,
418 PARTY_ID PER_CONTACT_RELATIONSHIPS.PARTY_ID%TYPE,
419 CONT_INFORMATION_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION_CATEGORY%TYPE,
420 CONT_INFORMATION1 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION1%TYPE,
421 CONT_INFORMATION2 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION2%TYPE,
422 CONT_INFORMATION3 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION3%TYPE,
423 CONT_INFORMATION4 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION4%TYPE,
424 CONT_INFORMATION5 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION5%TYPE,
425 CONT_INFORMATION6 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION6%TYPE,
426 CONT_INFORMATION7 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION7%TYPE,
427 CONT_INFORMATION8 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION8%TYPE,
428 CONT_INFORMATION9 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION9%TYPE,
429 CONT_INFORMATION10 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION10%TYPE,
430 CONT_INFORMATION11 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION11%TYPE,
431 CONT_INFORMATION12 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION12%TYPE,
432 CONT_INFORMATION13 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION13%TYPE,
433 CONT_INFORMATION14 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION14%TYPE,
434 CONT_INFORMATION15 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION15%TYPE,
435 CONT_INFORMATION16 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION16%TYPE,
436 CONT_INFORMATION17 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION17%TYPE,
437 CONT_INFORMATION18 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION18%TYPE,
438 CONT_INFORMATION19 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION19%TYPE,
439 CONT_INFORMATION20 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION20%TYPE
440 );
441
442 /*Record type for contact address details*/
443 TYPE CONTACT_ADDRESS_DETAILS is RECORD
444 (
445 CONTACT_RELATIONSHIP_ID PER_CONTACT_RELATIONSHIPS.CONTACT_RELATIONSHIP_ID%TYPE,
446 CONTACT_PERSON_ID PER_CONTACT_RELATIONSHIPS.CONTACT_PERSON_ID%TYPE,
447 ADDRESS_ID PER_ADDRESSES.ADDRESS_ID%TYPE,
448 DATE_FROM varchar2(10),
449 PRIMARY_FLAG PER_ADDRESSES.PRIMARY_FLAG%TYPE,
450 STYLE PER_ADDRESSES.STYLE%TYPE,
451 STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
452 ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
453 ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
454 ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
455 ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
456 ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
457 COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
458 COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
459 DATE_TO varchar2(10),
460 POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
461 REGION_1 PER_ADDRESSES.REGION_1%TYPE,
462 REGION_1_DESC VARCHAR2(240),
463 REGION_2 PER_ADDRESSES.REGION_2%TYPE,
464 REGION_2_DESC VARCHAR2(240),
465 REGION_3 PER_ADDRESSES.REGION_3%TYPE,
466 REGION_3_DESC VARCHAR2(240),
467 TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
468 TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
469 TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
470 TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
471 TOWN_OR_CITY_DESC VARCHAR2(240),
472 ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
473 ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
474 ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
475 ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
476 ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
477 ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
478 ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
479 ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
480 ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
481 ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
482 ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
483 ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
484 ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
485 ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
486 ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
487 ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
488 ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
489 ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
490 ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
491 ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
492 ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
493 ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
494 ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
495 ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
496 ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
497 ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
498 ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
499 ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
500 ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
501 PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
502 DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
503 GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
504 COMMENTS PER_ADDRESSES.COMMENTS%TYPE
505 );
506
507
508
509 /*Record type for address details*/
510 TYPE ADDRESS_DETAILS is RECORD
511 (
512 ADDRESS_ID PER_ADDRESSES.ADDRESS_ID%TYPE,
513 DATE_FROM varchar2(10),
514 PRIMARY_FLAG PER_ADDRESSES.PRIMARY_FLAG%TYPE,
515 STYLE PER_ADDRESSES.STYLE%TYPE,
516 STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
517 ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
518 ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
519 ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
520 ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
521 ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
522 COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
523 COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
524 DATE_TO varchar2(10),
525 POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
526 REGION_1 PER_ADDRESSES.REGION_1%TYPE,
527 REGION_1_DESC VARCHAR2(240),
528 REGION_2 PER_ADDRESSES.REGION_2%TYPE,
529 REGION_2_DESC VARCHAR2(240),
530 REGION_3 PER_ADDRESSES.REGION_3%TYPE,
531 REGION_3_DESC VARCHAR2(240),
532 TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
533 TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
534 TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
535 TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
536 TOWN_OR_CITY_DESC VARCHAR2(240),
537 ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
538 ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
539 ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
540 ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
541 ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
542 ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
543 ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
544 ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
545 ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
546 ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
547 ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
548 ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
549 ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
550 ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
551 ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
552 ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
553 ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
554 ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
555 ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
556 ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
557 ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
558 ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
559 ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
560 ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
561 ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
562 ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
563 ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
564 ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
565 ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
566 PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
567 DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
568 GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
569 COMMENTS PER_ADDRESSES.COMMENTS%TYPE
570
571 );
572 /*Record type for person extra information details*/
573 TYPE PERSON_EXTRA_INFO_DETAILS IS RECORD
574 (
575 PERSON_EXTRA_INFO_ID PER_PEOPLE_EXTRA_INFO.PERSON_EXTRA_INFO_ID%TYPE,
576 INFORMATION_TYPE PER_PEOPLE_EXTRA_INFO.INFORMATION_TYPE%TYPE,
577 PEI_INFORMATION_CATEGORY PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION_CATEGORY%TYPE,
578 PEI_INFORMATION1 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION1%TYPE,
579 PEI_INFORMATION2 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION2%TYPE,
580 PEI_INFORMATION3 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE,
581 PEI_INFORMATION4 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION4%TYPE,
582 PEI_INFORMATION5 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION5%TYPE,
583 PEI_INFORMATION6 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION6%TYPE,
584 PEI_INFORMATION7 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION7%TYPE,
585 PEI_INFORMATION8 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION8%TYPE,
586 PEI_INFORMATION9 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION9%TYPE,
587 PEI_INFORMATION10 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION10%TYPE,
588 PEI_INFORMATION11 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION11%TYPE,
589 PEI_INFORMATION12 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION12%TYPE,
590 PEI_INFORMATION13 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION13%TYPE,
591 PEI_INFORMATION14 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION14%TYPE,
592 PEI_INFORMATION15 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION15%TYPE,
593 PEI_INFORMATION16 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION16%TYPE,
594 PEI_INFORMATION17 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION17%TYPE,
595 PEI_INFORMATION18 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION18%TYPE,
596 PEI_INFORMATION19 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION19%TYPE,
597 PEI_INFORMATION20 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION20%TYPE,
598 PEI_INFORMATION21 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION21%TYPE,
599 PEI_INFORMATION22 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION22%TYPE,
600 PEI_INFORMATION23 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION23%TYPE,
601 PEI_INFORMATION24 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION24%TYPE,
602 PEI_INFORMATION25 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION25%TYPE,
603 PEI_INFORMATION26 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION26%TYPE,
604 PEI_INFORMATION27 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION27%TYPE,
605 PEI_INFORMATION28 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION28%TYPE,
606 PEI_INFORMATION29 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION29%TYPE,
607 PEI_INFORMATION30 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION30%TYPE,
608 PEI_ATTRIBUTE_CATEGORY PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE_CATEGORY%TYPE,
609 PEI_ATTRIBUTE1 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE1%TYPE,
610 PEI_ATTRIBUTE2 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE2%TYPE,
611 PEI_ATTRIBUTE3 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE3%TYPE,
612 PEI_ATTRIBUTE4 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE4%TYPE,
613 PEI_ATTRIBUTE5 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE5%TYPE,
614 PEI_ATTRIBUTE6 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE6%TYPE,
615 PEI_ATTRIBUTE7 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE7%TYPE,
616 PEI_ATTRIBUTE8 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE8%TYPE,
617 PEI_ATTRIBUTE9 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE9%TYPE,
618 PEI_ATTRIBUTE10 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE10%TYPE,
619 PEI_ATTRIBUTE11 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE11%TYPE,
620 PEI_ATTRIBUTE12 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE12%TYPE,
621 PEI_ATTRIBUTE13 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE13%TYPE,
622 PEI_ATTRIBUTE14 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE14%TYPE,
623 PEI_ATTRIBUTE15 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE15%TYPE,
624 PEI_ATTRIBUTE16 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE16%TYPE,
625 PEI_ATTRIBUTE17 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE17%TYPE,
626 PEI_ATTRIBUTE18 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE18%TYPE,
627 PEI_ATTRIBUTE19 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE19%TYPE,
628 PEI_ATTRIBUTE20 PER_PEOPLE_EXTRA_INFO.PEI_ATTRIBUTE20%TYPE,
629 PARTY_ID PER_PEOPLE_EXTRA_INFO.PARTY_ID%TYPE
630 );
631
632 /*Record type for special information details*/
633 TYPE SPECIAL_INFORMATION_DETAILS is record
634 (
635 PERSON_ANALYSIS_ID PER_PERSON_ANALYSES.PERSON_ANALYSIS_ID%TYPE,
636 ANALYSIS_CRITERIA_ID PER_PERSON_ANALYSES.ANALYSIS_CRITERIA_ID%TYPE,
637 DATE_FROM varchar2(10),
638 DATE_TO varchar2(10),
639 ID_FLEX_NUM PER_PERSON_ANALYSES.ID_FLEX_NUM%TYPE,
640 SEGMENT1 PER_ANALYSIS_CRITERIA.SEGMENT1%TYPE,
641 SEGMENT2 PER_ANALYSIS_CRITERIA.SEGMENT2%TYPE,
642 SEGMENT3 PER_ANALYSIS_CRITERIA.SEGMENT3%TYPE,
643 SEGMENT4 PER_ANALYSIS_CRITERIA.SEGMENT4%TYPE,
644 SEGMENT5 PER_ANALYSIS_CRITERIA.SEGMENT5%TYPE,
645 SEGMENT6 PER_ANALYSIS_CRITERIA.SEGMENT6%TYPE,
646 SEGMENT7 PER_ANALYSIS_CRITERIA.SEGMENT7%TYPE,
647 SEGMENT8 PER_ANALYSIS_CRITERIA.SEGMENT8%TYPE,
648 SEGMENT9 PER_ANALYSIS_CRITERIA.SEGMENT9%TYPE,
649 SEGMENT10 PER_ANALYSIS_CRITERIA.SEGMENT10%TYPE,
650 SEGMENT11 PER_ANALYSIS_CRITERIA.SEGMENT11%TYPE,
651 SEGMENT12 PER_ANALYSIS_CRITERIA.SEGMENT12%TYPE,
652 SEGMENT13 PER_ANALYSIS_CRITERIA.SEGMENT13%TYPE,
653 SEGMENT14 PER_ANALYSIS_CRITERIA.SEGMENT14%TYPE,
654 SEGMENT15 PER_ANALYSIS_CRITERIA.SEGMENT15%TYPE,
655 SEGMENT16 PER_ANALYSIS_CRITERIA.SEGMENT16%TYPE,
656 SEGMENT17 PER_ANALYSIS_CRITERIA.SEGMENT17%TYPE,
657 SEGMENT18 PER_ANALYSIS_CRITERIA.SEGMENT18%TYPE,
658 SEGMENT19 PER_ANALYSIS_CRITERIA.SEGMENT19%TYPE,
659 SEGMENT20 PER_ANALYSIS_CRITERIA.SEGMENT20%TYPE,
660 SEGMENT21 PER_ANALYSIS_CRITERIA.SEGMENT21%TYPE,
661 SEGMENT22 PER_ANALYSIS_CRITERIA.SEGMENT22%TYPE,
662 SEGMENT23 PER_ANALYSIS_CRITERIA.SEGMENT23%TYPE,
663 SEGMENT24 PER_ANALYSIS_CRITERIA.SEGMENT24%TYPE,
664 SEGMENT25 PER_ANALYSIS_CRITERIA.SEGMENT25%TYPE,
665 SEGMENT26 PER_ANALYSIS_CRITERIA.SEGMENT26%TYPE,
666 SEGMENT27 PER_ANALYSIS_CRITERIA.SEGMENT27%TYPE,
667 SEGMENT28 PER_ANALYSIS_CRITERIA.SEGMENT28%TYPE,
668 SEGMENT29 PER_ANALYSIS_CRITERIA.SEGMENT29%TYPE,
669 SEGMENT30 PER_ANALYSIS_CRITERIA.SEGMENT30%TYPE,
670 ATTRIBUTE_CATEGORY PER_PERSON_ANALYSES.ATTRIBUTE_CATEGORY%TYPE,
671 ATTRIBUTE1 PER_PERSON_ANALYSES.ATTRIBUTE1%TYPE,
672 ATTRIBUTE2 PER_PERSON_ANALYSES.ATTRIBUTE2%TYPE,
673 ATTRIBUTE3 PER_PERSON_ANALYSES.ATTRIBUTE3%TYPE,
674 ATTRIBUTE4 PER_PERSON_ANALYSES.ATTRIBUTE4%TYPE,
675 ATTRIBUTE5 PER_PERSON_ANALYSES.ATTRIBUTE5%TYPE,
676 ATTRIBUTE6 PER_PERSON_ANALYSES.ATTRIBUTE6%TYPE,
677 ATTRIBUTE7 PER_PERSON_ANALYSES.ATTRIBUTE7%TYPE,
678 ATTRIBUTE8 PER_PERSON_ANALYSES.ATTRIBUTE8%TYPE,
679 ATTRIBUTE9 PER_PERSON_ANALYSES.ATTRIBUTE9%TYPE,
680 ATTRIBUTE10 PER_PERSON_ANALYSES.ATTRIBUTE10%TYPE,
681 ATTRIBUTE11 PER_PERSON_ANALYSES.ATTRIBUTE11%TYPE,
682 ATTRIBUTE12 PER_PERSON_ANALYSES.ATTRIBUTE12%TYPE,
683 ATTRIBUTE13 PER_PERSON_ANALYSES.ATTRIBUTE13%TYPE,
684 ATTRIBUTE14 PER_PERSON_ANALYSES.ATTRIBUTE14%TYPE,
685 ATTRIBUTE15 PER_PERSON_ANALYSES.ATTRIBUTE15%TYPE,
686 ATTRIBUTE16 PER_PERSON_ANALYSES.ATTRIBUTE16%TYPE,
687 ATTRIBUTE17 PER_PERSON_ANALYSES.ATTRIBUTE17%TYPE,
688 ATTRIBUTE18 PER_PERSON_ANALYSES.ATTRIBUTE18%TYPE,
689 ATTRIBUTE19 PER_PERSON_ANALYSES.ATTRIBUTE19%TYPE,
690 ATTRIBUTE20 PER_PERSON_ANALYSES.ATTRIBUTE20%TYPE,
691 PARTY_ID PER_PERSON_ANALYSES.PARTY_ID%TYPE,
692 COMMENTS PER_PERSON_ANALYSES.COMMENTS%TYPE
693 );
694
695 /*Record type for work incidents*/
696 TYPE WORK_INC_INFO is Record
697 (INCIDENT_ID PER_WORK_INCIDENTS.INCIDENT_ID%TYPE,
698 INCIDENT_REFERENCE PER_WORK_INCIDENTS.INCIDENT_REFERENCE%TYPE,
699 INCIDENT_TYPE PER_WORK_INCIDENTS.INCIDENT_TYPE%TYPE,
700 INCIDENT_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
701 INCIDENT_DATE varchar2(10),
702 INCIDENT_TIME PER_WORK_INCIDENTS.INCIDENT_TIME%TYPE,
703 ASSIGNMENT_ID PER_WORK_INCIDENTS.ASSIGNMENT_ID%TYPE,
704 LOCATION PER_WORK_INCIDENTS.LOCATION%TYPE,
705 AT_WORK_FLAG PER_WORK_INCIDENTS.AT_WORK_FLAG%TYPE,
706 AT_WORK_FLAG_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
707 --LAST_WORK_DATE varchar2(10), -- comented for bug 8905622
708 --LAST_WORK_TIME PER_WORK_INCIDENTS.LAST_WORK_TIME%TYPE, -- comented for bug 8905622
709 REPORT_DATE varchar2(10),
710 REPORT_TIME PER_WORK_INCIDENTS.REPORT_TIME%TYPE,
711 REPORT_METHOD PER_WORK_INCIDENTS.REPORT_METHOD%TYPE,
712 PERSON_REPORTED_BY PER_WORK_INCIDENTS.PERSON_REPORTED_BY%TYPE,
713 PERSON_REPORTED_BY_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
714 PERSON_REPORTED_TO PER_WORK_INCIDENTS.PERSON_REPORTED_TO%TYPE,
715 WITNESS_DETAILS PER_WORK_INCIDENTS.WITNESS_DETAILS%TYPE,
716 DESCRIPTION PER_WORK_INCIDENTS.DESCRIPTION%TYPE,
717 INJURY_TYPE PER_WORK_INCIDENTS.INJURY_TYPE%TYPE,
718 INJURY_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
719 DISEASE_TYPE PER_WORK_INCIDENTS.DISEASE_TYPE%TYPE,
720 DISEASE_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
721 HAZARD_TYPE PER_WORK_INCIDENTS.HAZARD_TYPE%TYPE,
722 HAZARD_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
723 BODY_PART PER_WORK_INCIDENTS.BODY_PART%TYPE,
724 TREATMENT_RECEIVED_FLAG PER_WORK_INCIDENTS.TREATMENT_RECEIVED_FLAG%TYPE,
725 HOSPITAL_DETAILS PER_WORK_INCIDENTS.HOSPITAL_DETAILS%TYPE,
726 --DOCTOR_ID PER_WORK_INCIDENTS.DOCTOR_ID%TYPE,-- comented for bug 8905622
727 --NEXT_OF_KIN_ID PER_WORK_INCIDENTS.NEXT_OF_KIN_ID%TYPE,-- comented for bug 8905622
728 --ABSENCE_ID PER_WORK_INCIDENTS.ABSENCE_ID%TYPE,-- comented for bug 8905622
729 COMPENSATION_DATE varchar2(10),
730 COMPENSATION_CURRENCY PER_WORK_INCIDENTS.COMPENSATION_CURRENCY%TYPE,
731 COMPENSATION_AMOUNT PER_WORK_INCIDENTS.COMPENSATION_AMOUNT%TYPE,
732 REMEDIAL_HS_ACTION PER_WORK_INCIDENTS.REMEDIAL_HS_ACTION%TYPE,
733 NOTIFIED_HSREP_ID PER_WORK_INCIDENTS.NOTIFIED_HSREP_ID%TYPE,
734 NOTIFIED_HSREP_DATE varchar2(10),
735 /* Bug 11792686
736 NOTIFIED_UREP_ID PER_WORK_INCIDENTS.NOTIFIED_UREP_ID%TYPE,
737 NOTIFIED_UREP_DATE varchar2(10),
738 PREVIOUS_INCIDENT_ID PER_WORK_INCIDENTS.PREVIOUS_INCIDENT_ID%TYPE, */
739
740 ATTRIBUTE_CATEGORY PER_WORK_INCIDENTS.ATTRIBUTE_CATEGORY%TYPE,
741 ATTRIBUTE1 PER_WORK_INCIDENTS.ATTRIBUTE1%TYPE,
742 ATTRIBUTE2 PER_WORK_INCIDENTS.ATTRIBUTE2%TYPE,
743 ATTRIBUTE3 PER_WORK_INCIDENTS.ATTRIBUTE3%TYPE,
744 ATTRIBUTE4 PER_WORK_INCIDENTS.ATTRIBUTE4%TYPE,
745 ATTRIBUTE5 PER_WORK_INCIDENTS.ATTRIBUTE5%TYPE,
746 ATTRIBUTE6 PER_WORK_INCIDENTS.ATTRIBUTE6%TYPE,
747 ATTRIBUTE7 PER_WORK_INCIDENTS.ATTRIBUTE7%TYPE,
748 ATTRIBUTE8 PER_WORK_INCIDENTS.ATTRIBUTE8%TYPE,
749 ATTRIBUTE9 PER_WORK_INCIDENTS.ATTRIBUTE9%TYPE,
750 ATTRIBUTE10 PER_WORK_INCIDENTS.ATTRIBUTE10%TYPE,
751 ATTRIBUTE11 PER_WORK_INCIDENTS.ATTRIBUTE11%TYPE,
752 ATTRIBUTE12 PER_WORK_INCIDENTS.ATTRIBUTE12%TYPE,
753 ATTRIBUTE13 PER_WORK_INCIDENTS.ATTRIBUTE13%TYPE,
754 ATTRIBUTE14 PER_WORK_INCIDENTS.ATTRIBUTE14%TYPE,
755 ATTRIBUTE15 PER_WORK_INCIDENTS.ATTRIBUTE15%TYPE,
756 ATTRIBUTE16 PER_WORK_INCIDENTS.ATTRIBUTE16%TYPE,
757 ATTRIBUTE17 PER_WORK_INCIDENTS.ATTRIBUTE17%TYPE,
758 ATTRIBUTE18 PER_WORK_INCIDENTS.ATTRIBUTE18%TYPE,
759 ATTRIBUTE19 PER_WORK_INCIDENTS.ATTRIBUTE19%TYPE,
760 ATTRIBUTE20 PER_WORK_INCIDENTS.ATTRIBUTE20%TYPE,
761 ATTRIBUTE21 PER_WORK_INCIDENTS.ATTRIBUTE21%TYPE,
762 ATTRIBUTE22 PER_WORK_INCIDENTS.ATTRIBUTE22%TYPE,
763 ATTRIBUTE23 PER_WORK_INCIDENTS.ATTRIBUTE23%TYPE,
764 ATTRIBUTE24 PER_WORK_INCIDENTS.ATTRIBUTE24%TYPE,
765 ATTRIBUTE25 PER_WORK_INCIDENTS.ATTRIBUTE25%TYPE,
766 ATTRIBUTE26 PER_WORK_INCIDENTS.ATTRIBUTE26%TYPE,
767 ATTRIBUTE27 PER_WORK_INCIDENTS.ATTRIBUTE27%TYPE,
768 ATTRIBUTE28 PER_WORK_INCIDENTS.ATTRIBUTE28%TYPE,
769 ATTRIBUTE29 PER_WORK_INCIDENTS.ATTRIBUTE29%TYPE,
770 ATTRIBUTE30 PER_WORK_INCIDENTS.ATTRIBUTE30%TYPE,
771 INC_INFORMATION_CATEGORY PER_WORK_INCIDENTS.INC_INFORMATION_CATEGORY%TYPE,
772 INC_INFORMATION1 PER_WORK_INCIDENTS.INC_INFORMATION1%TYPE,
773 INC_INFORMATION2 PER_WORK_INCIDENTS.INC_INFORMATION2%TYPE,
774 INC_INFORMATION3 PER_WORK_INCIDENTS.INC_INFORMATION3%TYPE,
775 INC_INFORMATION4 PER_WORK_INCIDENTS.INC_INFORMATION4%TYPE,
776 INC_INFORMATION5 PER_WORK_INCIDENTS.INC_INFORMATION5%TYPE,
777 INC_INFORMATION6 PER_WORK_INCIDENTS.INC_INFORMATION6%TYPE,
778 INC_INFORMATION7 PER_WORK_INCIDENTS.INC_INFORMATION7%TYPE,
779 INC_INFORMATION8 PER_WORK_INCIDENTS.INC_INFORMATION8%TYPE,
780 INC_INFORMATION9 PER_WORK_INCIDENTS.INC_INFORMATION9%TYPE,
781 INC_INFORMATION10 PER_WORK_INCIDENTS.INC_INFORMATION10%TYPE,
782 INC_INFORMATION11 PER_WORK_INCIDENTS.INC_INFORMATION11%TYPE,
783 INC_INFORMATION12 PER_WORK_INCIDENTS.INC_INFORMATION12%TYPE,
784 INC_INFORMATION13 PER_WORK_INCIDENTS.INC_INFORMATION13%TYPE,
785 INC_INFORMATION14 PER_WORK_INCIDENTS.INC_INFORMATION14%TYPE,
786 INC_INFORMATION15 PER_WORK_INCIDENTS.INC_INFORMATION15%TYPE,
787 INC_INFORMATION16 PER_WORK_INCIDENTS.INC_INFORMATION16%TYPE,
788 INC_INFORMATION17 PER_WORK_INCIDENTS.INC_INFORMATION17%TYPE,
789 INC_INFORMATION18 PER_WORK_INCIDENTS.INC_INFORMATION18%TYPE,
790 INC_INFORMATION19 PER_WORK_INCIDENTS.INC_INFORMATION19%TYPE,
791 INC_INFORMATION20 PER_WORK_INCIDENTS.INC_INFORMATION20%TYPE,
792 INC_INFORMATION21 PER_WORK_INCIDENTS.INC_INFORMATION21%TYPE,
793 INC_INFORMATION22 PER_WORK_INCIDENTS.INC_INFORMATION22%TYPE,
794 INC_INFORMATION23 PER_WORK_INCIDENTS.INC_INFORMATION23%TYPE,
795 INC_INFORMATION24 PER_WORK_INCIDENTS.INC_INFORMATION24%TYPE,
796 INC_INFORMATION25 PER_WORK_INCIDENTS.INC_INFORMATION25%TYPE,
797 INC_INFORMATION26 PER_WORK_INCIDENTS.INC_INFORMATION26%TYPE,
798 INC_INFORMATION27 PER_WORK_INCIDENTS.INC_INFORMATION27%TYPE,
799 INC_INFORMATION28 PER_WORK_INCIDENTS.INC_INFORMATION28%TYPE,
800 INC_INFORMATION29 PER_WORK_INCIDENTS.INC_INFORMATION29%TYPE,
801 INC_INFORMATION30 PER_WORK_INCIDENTS.INC_INFORMATION30%TYPE,
802 ORG_NOTIFIED_DATE varchar2(10),
803 DOCTOR_NAME PER_WORK_INCIDENTS.DOCTOR_NAME%TYPE,
804 NOTIFIED_REP_ID PER_WORK_INCIDENTS.NOTIFIED_REP_ID%TYPE,
805 NOTIFIED_REP_DATE varchar2(10),
806 NOTIFIED_REP_ORG_ID PER_WORK_INCIDENTS.NOTIFIED_REP_ORG_ID%TYPE,
807 RELATED_INCIDENT_ID PER_WORK_INCIDENTS.RELATED_INCIDENT_ID%TYPE,
808 OVER_TIME_FLAG PER_WORK_INCIDENTS.OVER_TIME_FLAG%TYPE,
809 ABSENCE_EXISTS_FLAG PER_WORK_INCIDENTS.ABSENCE_EXISTS_FLAG%TYPE,
810 EMERGENCY_CODE PER_WORK_INCIDENTS.EMERGENCY_CODE%TYPE,
811 PRIVACY_ISSUE PER_WORK_INCIDENTS.PRIVACY_ISSUE%TYPE,
812 OBJECTS_INVOLVED PER_WORK_INCIDENTS.OBJECTS_INVOLVED%TYPE,
813 ACTIVITY_AT_TIME_OF_WORK PER_WORK_INCIDENTS.ACTIVITY_AT_TIME_OF_WORK%TYPE,
814 HOSPITAL_ADDRESS PER_WORK_INCIDENTS.HOSPITAL_ADDRESS%TYPE,
815 DAYS_RESTRICTED_WORK PER_WORK_INCIDENTS.DAYS_RESTRICTED_WORK%TYPE,
816 HOSPITALIZED_FLAG PER_WORK_INCIDENTS.HOSPITALIZED_FLAG%TYPE,
817 DATE_OF_DEATH varchar2(10),
818 DAYS_AWAY_FROM_WORK PER_WORK_INCIDENTS.DAYS_AWAY_FROM_WORK%TYPE,
819 WORK_START_TIME PER_WORK_INCIDENTS.WORK_START_TIME%TYPE,
820 REPORTING_PERSON_PHONE PER_WORK_INCIDENTS.REPORTING_PERSON_PHONE%TYPE,
821 REPORTING_PERSON_TITLE PER_WORK_INCIDENTS.REPORTING_PERSON_TITLE%TYPE,
822 REPORT_COMPLETED_BY PER_WORK_INCIDENTS.REPORT_COMPLETED_BY%TYPE);
823
824
825 /*Record type for Previosu employment details*/
826 TYPE PREV_EMP_INFO IS RECORD
827 (
828 PREVIOUS_EMPLOYER_ID PER_PREVIOUS_EMPLOYERS.PREVIOUS_EMPLOYER_ID%TYPE,
829 PARTY_ID PER_PREVIOUS_EMPLOYERS.PARTY_ID%TYPE,
830 START_DATE varchar2(10),
831 END_DATE varchar2(10),
832 PERIOD_YEARS PER_PREVIOUS_EMPLOYERS.PERIOD_YEARS%TYPE,
833 PERIOD_DAYS PER_PREVIOUS_EMPLOYERS.PERIOD_DAYS%TYPE,
834 EMPLOYER_NAME PER_PREVIOUS_EMPLOYERS.EMPLOYER_NAME%TYPE,
835 EMPLOYER_COUNTRY PER_PREVIOUS_EMPLOYERS.EMPLOYER_COUNTRY%TYPE,
836 EMPLOYER_COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
837 EMPLOYER_ADDRESS PER_PREVIOUS_EMPLOYERS.EMPLOYER_ADDRESS%TYPE,
838 EMPLOYER_TYPE PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE%TYPE,
839 EMPLOYER_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
840 EMPLOYER_SUBTYPE PER_PREVIOUS_EMPLOYERS.EMPLOYER_SUBTYPE%TYPE,
841 EMPLOYER_SUBTYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
842 DESCRIPTION PER_PREVIOUS_EMPLOYERS.DESCRIPTION%TYPE,
843 PEM_ATTRIBUTE_CATEGORY PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE_CATEGORY%TYPE,
844 PEM_ATTRIBUTE1 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE1%TYPE,
845 PEM_ATTRIBUTE2 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE2%TYPE,
846 PEM_ATTRIBUTE3 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE3%TYPE,
847 PEM_ATTRIBUTE4 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE4%TYPE,
848 PEM_ATTRIBUTE5 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE5%TYPE,
849 PEM_ATTRIBUTE6 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE6%TYPE,
850 PEM_ATTRIBUTE7 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE7%TYPE,
851 PEM_ATTRIBUTE8 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE8%TYPE,
852 PEM_ATTRIBUTE9 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE9%TYPE,
853 PEM_ATTRIBUTE10 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE10%TYPE,
854 PEM_ATTRIBUTE11 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE11%TYPE,
855 PEM_ATTRIBUTE12 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE12%TYPE,
856 PEM_ATTRIBUTE13 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE13%TYPE,
857 PEM_ATTRIBUTE14 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE14%TYPE,
858 PEM_ATTRIBUTE15 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE15%TYPE,
859 PEM_ATTRIBUTE16 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE16%TYPE,
860 PEM_ATTRIBUTE17 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE17%TYPE,
861 PEM_ATTRIBUTE18 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE18%TYPE,
862 PEM_ATTRIBUTE19 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE19%TYPE,
863 PEM_ATTRIBUTE20 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE20%TYPE,
864 PEM_ATTRIBUTE21 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE21%TYPE,
865 PEM_ATTRIBUTE22 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE22%TYPE,
866 PEM_ATTRIBUTE23 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE23%TYPE,
867 PEM_ATTRIBUTE24 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE24%TYPE,
868 PEM_ATTRIBUTE25 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE25%TYPE,
869 PEM_ATTRIBUTE26 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE26%TYPE,
870 PEM_ATTRIBUTE27 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE27%TYPE,
871 PEM_ATTRIBUTE28 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE28%TYPE,
872 PEM_ATTRIBUTE29 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE29%TYPE,
873 PEM_ATTRIBUTE30 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE30%TYPE,
874 PEM_INFORMATION_CATEGORY PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION_CATEGORY%TYPE,
875 PEM_INFORMATION1 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION1%TYPE,
876 PEM_INFORMATION2 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION2%TYPE,
877 PEM_INFORMATION3 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION3%TYPE,
878 PEM_INFORMATION4 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION4%TYPE,
879 PEM_INFORMATION5 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION5%TYPE,
880 PEM_INFORMATION6 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION6%TYPE,
881 PEM_INFORMATION7 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION7%TYPE,
882 PEM_INFORMATION8 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION8%TYPE,
883 PEM_INFORMATION9 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION9%TYPE,
884 PEM_INFORMATION10 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION10%TYPE,
885 PEM_INFORMATION11 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION11%TYPE,
886 PEM_INFORMATION12 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION12%TYPE,
887 PEM_INFORMATION13 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION13%TYPE,
888 PEM_INFORMATION14 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION14%TYPE,
889 PEM_INFORMATION15 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION15%TYPE,
890 PEM_INFORMATION16 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION16%TYPE,
891 PEM_INFORMATION17 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION17%TYPE,
892 PEM_INFORMATION18 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION18%TYPE,
893 PEM_INFORMATION19 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION19%TYPE,
894 PEM_INFORMATION20 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION20%TYPE,
895 PEM_INFORMATION21 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION21%TYPE,
896 PEM_INFORMATION22 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION22%TYPE,
897 PEM_INFORMATION23 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION23%TYPE,
898 PEM_INFORMATION24 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION24%TYPE,
899 PEM_INFORMATION25 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION25%TYPE,
900 PEM_INFORMATION26 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION26%TYPE,
901 PEM_INFORMATION27 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION27%TYPE,
902 PEM_INFORMATION28 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION28%TYPE,
903 PEM_INFORMATION29 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION29%TYPE,
904 PEM_INFORMATION30 PER_PREVIOUS_EMPLOYERS.PEM_INFORMATION30%TYPE,
905 ALL_ASSIGNMENTS PER_PREVIOUS_EMPLOYERS.ALL_ASSIGNMENTS%TYPE,
906 PERIOD_MONTHS PER_PREVIOUS_EMPLOYERS.PERIOD_MONTHS%TYPE
907 );
908
909 TYPE DELIV_METHOD_INFO is RECORD
910 (DELIVERY_METHOD_ID PER_PERSON_DLVRY_METHODS.DELIVERY_METHOD_ID%TYPE,
911 DATE_START varchar2(10),
912 DATE_END varchar2(10),
913 COMM_DLVRY_METHOD PER_PERSON_DLVRY_METHODS.COMM_DLVRY_METHOD%TYPE,
914 COMM_DLVRY_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,
915 PREFERRED_FLAG PER_PERSON_DLVRY_METHODS.PREFERRED_FLAG%TYPE,
916 ATTRIBUTE_CATEGORY PER_PERSON_DLVRY_METHODS.ATTRIBUTE_CATEGORY%TYPE,
917 ATTRIBUTE1 PER_PERSON_DLVRY_METHODS.ATTRIBUTE1%TYPE,
918 ATTRIBUTE2 PER_PERSON_DLVRY_METHODS.ATTRIBUTE2%TYPE,
919 ATTRIBUTE3 PER_PERSON_DLVRY_METHODS.ATTRIBUTE3%TYPE,
920 ATTRIBUTE4 PER_PERSON_DLVRY_METHODS.ATTRIBUTE4%TYPE,
921 ATTRIBUTE5 PER_PERSON_DLVRY_METHODS.ATTRIBUTE5%TYPE,
922 ATTRIBUTE6 PER_PERSON_DLVRY_METHODS.ATTRIBUTE6%TYPE,
923 ATTRIBUTE7 PER_PERSON_DLVRY_METHODS.ATTRIBUTE7%TYPE,
924 ATTRIBUTE8 PER_PERSON_DLVRY_METHODS.ATTRIBUTE8%TYPE,
925 ATTRIBUTE9 PER_PERSON_DLVRY_METHODS.ATTRIBUTE9%TYPE,
926 ATTRIBUTE10 PER_PERSON_DLVRY_METHODS.ATTRIBUTE10%TYPE,
927 ATTRIBUTE11 PER_PERSON_DLVRY_METHODS.ATTRIBUTE11%TYPE,
928 ATTRIBUTE12 PER_PERSON_DLVRY_METHODS.ATTRIBUTE12%TYPE,
929 ATTRIBUTE13 PER_PERSON_DLVRY_METHODS.ATTRIBUTE13%TYPE,
930 ATTRIBUTE14 PER_PERSON_DLVRY_METHODS.ATTRIBUTE14%TYPE,
931 ATTRIBUTE15 PER_PERSON_DLVRY_METHODS.ATTRIBUTE15%TYPE,
932 ATTRIBUTE16 PER_PERSON_DLVRY_METHODS.ATTRIBUTE16%TYPE,
933 ATTRIBUTE17 PER_PERSON_DLVRY_METHODS.ATTRIBUTE17%TYPE,
934 ATTRIBUTE18 PER_PERSON_DLVRY_METHODS.ATTRIBUTE18%TYPE,
935 ATTRIBUTE19 PER_PERSON_DLVRY_METHODS.ATTRIBUTE19%TYPE,
936 ATTRIBUTE20 PER_PERSON_DLVRY_METHODS.ATTRIBUTE20%TYPE
937 );
938
939 TYPE ASSIGNMENT_EXTRA_INFO is RECORD
940 (
941 ASSIGNMENT_EXTRA_INFO_ID PER_ASSIGNMENT_EXTRA_INFO.ASSIGNMENT_EXTRA_INFO_ID%TYPE,
942 ASSIGNMENT_ID PER_ASSIGNMENT_EXTRA_INFO.ASSIGNMENT_ID%TYPE,
943 INFORMATION_TYPE PER_ASSIGNMENT_EXTRA_INFO.INFORMATION_TYPE%TYPE,
944 AEI_ATTRIBUTE_CATEGORY PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE_CATEGORY%TYPE,
945 AEI_ATTRIBUTE1 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE1%TYPE,
946 AEI_ATTRIBUTE2 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE2%TYPE,
947 AEI_ATTRIBUTE3 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE3%TYPE,
948 AEI_ATTRIBUTE4 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE4%TYPE,
949 AEI_ATTRIBUTE5 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE5%TYPE,
950 AEI_ATTRIBUTE6 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE6%TYPE,
951 AEI_ATTRIBUTE7 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE7%TYPE,
952 AEI_ATTRIBUTE8 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE8%TYPE,
953 AEI_ATTRIBUTE9 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE9%TYPE,
954 AEI_ATTRIBUTE10 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE10%TYPE,
955 AEI_ATTRIBUTE11 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE11%TYPE,
956 AEI_ATTRIBUTE12 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE12%TYPE,
957 AEI_ATTRIBUTE13 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE13%TYPE,
958 AEI_ATTRIBUTE14 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE14%TYPE,
959 AEI_ATTRIBUTE15 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE15%TYPE,
960 AEI_ATTRIBUTE16 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE16%TYPE,
961 AEI_ATTRIBUTE17 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE17%TYPE,
962 AEI_ATTRIBUTE18 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE18%TYPE,
963 AEI_ATTRIBUTE19 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE19%TYPE,
964 AEI_ATTRIBUTE20 PER_ASSIGNMENT_EXTRA_INFO.AEI_ATTRIBUTE20%TYPE,
965 AEI_INFORMATION_CATEGORY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION_CATEGORY%TYPE,
966 AEI_INFORMATION1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%TYPE,
967 AEI_INFORMATION2 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION2%TYPE,
968 AEI_INFORMATION3 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION3%TYPE,
969 AEI_INFORMATION4 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION4%TYPE,
970 AEI_INFORMATION5 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION5%TYPE,
971 AEI_INFORMATION6 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION6%TYPE,
972 AEI_INFORMATION7 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION7%TYPE,
973 AEI_INFORMATION8 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION8%TYPE,
974 AEI_INFORMATION9 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION9%TYPE,
975 AEI_INFORMATION10 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION10%TYPE,
976 AEI_INFORMATION11 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION11%TYPE,
977 AEI_INFORMATION12 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION12%TYPE,
978 AEI_INFORMATION13 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION13%TYPE,
979 AEI_INFORMATION14 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION14%TYPE,
980 AEI_INFORMATION15 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION15%TYPE,
981 AEI_INFORMATION16 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION16%TYPE,
982 AEI_INFORMATION17 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION17%TYPE,
983 AEI_INFORMATION18 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION18%TYPE,
984 AEI_INFORMATION19 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION19%TYPE,
985 AEI_INFORMATION20 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION20%TYPE,
986 AEI_INFORMATION21 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION21%TYPE,
987 AEI_INFORMATION22 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION22%TYPE,
988 AEI_INFORMATION23 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION23%TYPE,
989 AEI_INFORMATION24 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION24%TYPE,
990 AEI_INFORMATION25 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION25%TYPE,
991 AEI_INFORMATION26 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION26%TYPE,
992 AEI_INFORMATION27 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION27%TYPE,
993 AEI_INFORMATION28 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION28%TYPE,
994 AEI_INFORMATION29 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION29%TYPE,
995 AEI_INFORMATION30 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION30%TYPE
996 );
997
998 TYPE CONTACT_EXTRA_INFO is RECORD
999 (
1000 CONTACT_EXTRA_INFO_ID PER_CONTACT_EXTRA_INFO_F.CONTACT_EXTRA_INFO_ID%TYPE,
1001 EFFECTIVE_START_DATE varchar2(10),
1002 EFFECTIVE_END_DATE varchar2(10),
1003 CONTACT_RELATIONSHIP_ID PER_CONTACT_EXTRA_INFO_F.CONTACT_RELATIONSHIP_ID%TYPE,
1004 INFORMATION_TYPE PER_CONTACT_EXTRA_INFO_F.INFORMATION_TYPE%TYPE,
1005 CEI_INFORMATION_CATEGORY PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION_CATEGORY%TYPE,
1006 CEI_INFORMATION1 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION1%TYPE,
1007 CEI_INFORMATION2 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE,
1008 CEI_INFORMATION3 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE,
1009 CEI_INFORMATION4 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION4%TYPE,
1010 CEI_INFORMATION5 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION5%TYPE,
1011 CEI_INFORMATION6 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION6%TYPE,
1012 CEI_INFORMATION7 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION7%TYPE,
1013 CEI_INFORMATION8 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION8%TYPE,
1014 CEI_INFORMATION9 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION9%TYPE,
1015 CEI_INFORMATION10 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION10%TYPE,
1016 CEI_INFORMATION11 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION11%TYPE,
1017 CEI_INFORMATION12 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION12%TYPE,
1018 CEI_INFORMATION13 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION13%TYPE,
1019 CEI_INFORMATION14 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION14%TYPE,
1020 CEI_INFORMATION15 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION15%TYPE,
1021 CEI_INFORMATION16 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION16%TYPE,
1022 CEI_INFORMATION17 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION17%TYPE,
1023 CEI_INFORMATION18 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION18%TYPE,
1024 CEI_INFORMATION19 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION19%TYPE,
1025 CEI_INFORMATION20 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION20%TYPE,
1026 CEI_INFORMATION21 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION21%TYPE,
1027 CEI_INFORMATION22 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION22%TYPE,
1028 CEI_INFORMATION23 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION23%TYPE,
1029 CEI_INFORMATION24 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION24%TYPE,
1030 CEI_INFORMATION25 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION25%TYPE,
1031 CEI_INFORMATION26 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION26%TYPE,
1032 CEI_INFORMATION27 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION27%TYPE,
1033 CEI_INFORMATION28 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION28%TYPE,
1034 CEI_INFORMATION29 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION29%TYPE,
1035 CEI_INFORMATION30 PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION30%TYPE,
1036 CEI_ATTRIBUTE_CATEGORY PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE_CATEGORY%TYPE,
1037 CEI_ATTRIBUTE1 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE1%TYPE,
1038 CEI_ATTRIBUTE2 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE2%TYPE,
1039 CEI_ATTRIBUTE3 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE3%TYPE,
1040 CEI_ATTRIBUTE4 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE4%TYPE,
1041 CEI_ATTRIBUTE5 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE5%TYPE,
1042 CEI_ATTRIBUTE6 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE6%TYPE,
1043 CEI_ATTRIBUTE7 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE7%TYPE,
1044 CEI_ATTRIBUTE8 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE8%TYPE,
1045 CEI_ATTRIBUTE9 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE9%TYPE,
1046 CEI_ATTRIBUTE10 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE10%TYPE,
1047 CEI_ATTRIBUTE11 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE11%TYPE,
1048 CEI_ATTRIBUTE12 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE12%TYPE,
1049 CEI_ATTRIBUTE13 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE13%TYPE,
1050 CEI_ATTRIBUTE14 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE14%TYPE,
1051 CEI_ATTRIBUTE15 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE15%TYPE,
1052 CEI_ATTRIBUTE16 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE16%TYPE,
1053 CEI_ATTRIBUTE17 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE17%TYPE,
1054 CEI_ATTRIBUTE18 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE18%TYPE,
1055 CEI_ATTRIBUTE19 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE19%TYPE,
1056 CEI_ATTRIBUTE20 PER_CONTACT_EXTRA_INFO_F.CEI_ATTRIBUTE20%TYPE
1057 );
1058
1059 TYPE phone_details is RECORD
1060 (
1061 PHONE_ID PER_PHONES.PHONE_ID%TYPE,
1062 DATE_FROM varchar2(10),
1063 DATE_TO varchar2(10),
1064 PHONE_TYPE PER_PHONES.PHONE_TYPE%TYPE,
1065 PHONE_TYPE_DESC HR_LOOKUPS.MEANING%TYPE,
1066 PHONE_NUMBER PER_PHONES.PHONE_NUMBER%TYPE,
1067 ATTRIBUTE_CATEGORY PER_PHONES.ATTRIBUTE_CATEGORY%TYPE,
1068 ATTRIBUTE1 PER_PHONES.ATTRIBUTE1%TYPE,
1069 ATTRIBUTE2 PER_PHONES.ATTRIBUTE2%TYPE,
1070 ATTRIBUTE3 PER_PHONES.ATTRIBUTE3%TYPE,
1071 ATTRIBUTE4 PER_PHONES.ATTRIBUTE4%TYPE,
1072 ATTRIBUTE5 PER_PHONES.ATTRIBUTE5%TYPE,
1073 ATTRIBUTE6 PER_PHONES.ATTRIBUTE6%TYPE,
1074 ATTRIBUTE7 PER_PHONES.ATTRIBUTE7%TYPE,
1075 ATTRIBUTE8 PER_PHONES.ATTRIBUTE8%TYPE,
1076 ATTRIBUTE9 PER_PHONES.ATTRIBUTE9%TYPE,
1077 ATTRIBUTE10 PER_PHONES.ATTRIBUTE10%TYPE,
1078 ATTRIBUTE11 PER_PHONES.ATTRIBUTE11%TYPE,
1079 ATTRIBUTE12 PER_PHONES.ATTRIBUTE12%TYPE,
1080 ATTRIBUTE13 PER_PHONES.ATTRIBUTE13%TYPE,
1081 ATTRIBUTE14 PER_PHONES.ATTRIBUTE14%TYPE,
1082 ATTRIBUTE15 PER_PHONES.ATTRIBUTE15%TYPE,
1083 ATTRIBUTE16 PER_PHONES.ATTRIBUTE16%TYPE,
1084 ATTRIBUTE17 PER_PHONES.ATTRIBUTE17%TYPE,
1085 ATTRIBUTE18 PER_PHONES.ATTRIBUTE18%TYPE,
1086 ATTRIBUTE19 PER_PHONES.ATTRIBUTE19%TYPE,
1087 ATTRIBUTE20 PER_PHONES.ATTRIBUTE20%TYPE,
1088 ATTRIBUTE21 PER_PHONES.ATTRIBUTE21%TYPE,
1089 ATTRIBUTE22 PER_PHONES.ATTRIBUTE22%TYPE,
1090 ATTRIBUTE23 PER_PHONES.ATTRIBUTE23%TYPE,
1091 ATTRIBUTE24 PER_PHONES.ATTRIBUTE24%TYPE,
1092 ATTRIBUTE25 PER_PHONES.ATTRIBUTE25%TYPE,
1093 ATTRIBUTE26 PER_PHONES.ATTRIBUTE26%TYPE,
1094 ATTRIBUTE27 PER_PHONES.ATTRIBUTE27%TYPE,
1095 ATTRIBUTE28 PER_PHONES.ATTRIBUTE28%TYPE,
1096 ATTRIBUTE29 PER_PHONES.ATTRIBUTE29%TYPE,
1097 ATTRIBUTE30 PER_PHONES.ATTRIBUTE30%TYPE,
1098 PARTY_ID PER_PHONES.PARTY_ID%TYPE,
1099 VALIDITY PER_PHONES.VALIDITY%TYPE
1100 );
1101
1102 TYPE SUBJECT_DETAILS IS RECORD
1103 (
1104 SUBJECTS_TAKEN_ID PER_SUBJECTS_TAKEN.SUBJECTS_TAKEN_ID%TYPE,
1105 START_DATE VARCHAR2(10),
1106 MAJOR PER_SUBJECTS_TAKEN.MAJOR%TYPE,
1107 SUBJECT_STATUS PER_SUBJECTS_TAKEN.SUBJECT_STATUS%TYPE,
1108 SUBJECT_STATUS_DESC HR_LOOKUPS.MEANING%TYPE,
1109 SUBJECT PER_SUBJECTS_TAKEN.SUBJECT%TYPE,
1110 SUBJECT_DESC HR_LOOKUPS.MEANING%TYPE,
1111 GRADE_ATTAINED PER_SUBJECTS_TAKEN.GRADE_ATTAINED%TYPE,
1112 END_DATE VARCHAR2(10),
1113 ATTRIBUTE_CATEGORY PER_SUBJECTS_TAKEN.ATTRIBUTE_CATEGORY%TYPE,
1114 ATTRIBUTE1 PER_SUBJECTS_TAKEN.ATTRIBUTE1%TYPE,
1115 ATTRIBUTE2 PER_SUBJECTS_TAKEN.ATTRIBUTE2%TYPE,
1116 ATTRIBUTE3 PER_SUBJECTS_TAKEN.ATTRIBUTE3%TYPE,
1117 ATTRIBUTE4 PER_SUBJECTS_TAKEN.ATTRIBUTE4%TYPE,
1118 ATTRIBUTE5 PER_SUBJECTS_TAKEN.ATTRIBUTE5%TYPE,
1119 ATTRIBUTE6 PER_SUBJECTS_TAKEN.ATTRIBUTE6%TYPE,
1120 ATTRIBUTE7 PER_SUBJECTS_TAKEN.ATTRIBUTE7%TYPE,
1121 ATTRIBUTE8 PER_SUBJECTS_TAKEN.ATTRIBUTE8%TYPE,
1122 ATTRIBUTE9 PER_SUBJECTS_TAKEN.ATTRIBUTE9%TYPE,
1123 ATTRIBUTE10 PER_SUBJECTS_TAKEN.ATTRIBUTE10%TYPE,
1124 ATTRIBUTE11 PER_SUBJECTS_TAKEN.ATTRIBUTE11%TYPE,
1125 ATTRIBUTE12 PER_SUBJECTS_TAKEN.ATTRIBUTE12%TYPE,
1126 ATTRIBUTE13 PER_SUBJECTS_TAKEN.ATTRIBUTE13%TYPE,
1127 ATTRIBUTE14 PER_SUBJECTS_TAKEN.ATTRIBUTE14%TYPE,
1128 ATTRIBUTE15 PER_SUBJECTS_TAKEN.ATTRIBUTE15%TYPE,
1129 ATTRIBUTE16 PER_SUBJECTS_TAKEN.ATTRIBUTE16%TYPE,
1130 ATTRIBUTE17 PER_SUBJECTS_TAKEN.ATTRIBUTE17%TYPE,
1131 ATTRIBUTE18 PER_SUBJECTS_TAKEN.ATTRIBUTE18%TYPE,
1132 ATTRIBUTE19 PER_SUBJECTS_TAKEN.ATTRIBUTE19%TYPE,
1133 ATTRIBUTE20 PER_SUBJECTS_TAKEN.ATTRIBUTE20%TYPE,
1134 SUB_INFORMATION_CATEGORY PER_SUBJECTS_TAKEN.SUB_INFORMATION_CATEGORY%TYPE,
1135 SUB_INFORMATION1 PER_SUBJECTS_TAKEN.SUB_INFORMATION1%TYPE,
1136 SUB_INFORMATION2 PER_SUBJECTS_TAKEN.SUB_INFORMATION2%TYPE,
1137 SUB_INFORMATION3 PER_SUBJECTS_TAKEN.SUB_INFORMATION3%TYPE,
1138 SUB_INFORMATION4 PER_SUBJECTS_TAKEN.SUB_INFORMATION4%TYPE,
1139 SUB_INFORMATION5 PER_SUBJECTS_TAKEN.SUB_INFORMATION5%TYPE,
1140 SUB_INFORMATION6 PER_SUBJECTS_TAKEN.SUB_INFORMATION6%TYPE,
1141 SUB_INFORMATION7 PER_SUBJECTS_TAKEN.SUB_INFORMATION7%TYPE,
1142 SUB_INFORMATION8 PER_SUBJECTS_TAKEN.SUB_INFORMATION8%TYPE,
1143 SUB_INFORMATION9 PER_SUBJECTS_TAKEN.SUB_INFORMATION9%TYPE,
1144 SUB_INFORMATION10 PER_SUBJECTS_TAKEN.SUB_INFORMATION10%TYPE,
1145 SUB_INFORMATION11 PER_SUBJECTS_TAKEN.SUB_INFORMATION11%TYPE,
1146 SUB_INFORMATION12 PER_SUBJECTS_TAKEN.SUB_INFORMATION12%TYPE,
1147 SUB_INFORMATION13 PER_SUBJECTS_TAKEN.SUB_INFORMATION13%TYPE,
1148 SUB_INFORMATION14 PER_SUBJECTS_TAKEN.SUB_INFORMATION14%TYPE,
1149 SUB_INFORMATION15 PER_SUBJECTS_TAKEN.SUB_INFORMATION15%TYPE,
1150 SUB_INFORMATION16 PER_SUBJECTS_TAKEN.SUB_INFORMATION16%TYPE,
1151 SUB_INFORMATION17 PER_SUBJECTS_TAKEN.SUB_INFORMATION17%TYPE,
1152 SUB_INFORMATION18 PER_SUBJECTS_TAKEN.SUB_INFORMATION18%TYPE,
1153 SUB_INFORMATION19 PER_SUBJECTS_TAKEN.SUB_INFORMATION19%TYPE,
1154 SUB_INFORMATION20 PER_SUBJECTS_TAKEN.SUB_INFORMATION20%TYPE
1155 );
1156
1157 TYPE SUBJECT_RECORD IS TABLE OF SUBJECT_DETAILS INDEX BY BINARY_INTEGER;
1158
1159 TYPE QUALIFICATION_DET IS RECORD
1160 (
1161 QUALIFICATION_ID PER_QUALIFICATIONS.QUALIFICATION_ID%type,
1162 TITLE PER_QUALIFICATIONS.TITLE%TYPE,
1163 GRADE_ATTAINED PER_QUALIFICATIONS.GRADE_ATTAINED%TYPE,
1164 STATUS PER_QUALIFICATIONS.STATUS%TYPE,
1165 STATUS_DESC HR_LOOKUPS.MEANING%TYPE,
1166 AWARDED_DATE VARCHAR2(10),
1167 FEE PER_QUALIFICATIONS.FEE%TYPE,
1168 FEE_CURRENCY PER_QUALIFICATIONS.FEE_CURRENCY%TYPE,
1169 FEE_CURRENCY_DESC FND_CURRENCIES_VL.NAME%TYPE,
1170 TRAINING_COMPLETED_AMOUNT PER_QUALIFICATIONS.TRAINING_COMPLETED_AMOUNT%TYPE,
1171 REIMBURSEMENT_ARRANGEMENTS PER_QUALIFICATIONS.REIMBURSEMENT_ARRANGEMENTS%TYPE,
1172 TRAINING_COMPLETED_UNITS PER_QUALIFICATIONS.TRAINING_COMPLETED_UNITS%TYPE,
1173 TOTAL_TRAINING_AMOUNT PER_QUALIFICATIONS.TOTAL_TRAINING_AMOUNT%TYPE,
1174 START_DATE VARCHAR2(10),
1175 END_DATE VARCHAR2(10),
1176 LICENSE_NUMBER PER_QUALIFICATIONS.LICENSE_NUMBER%TYPE,
1177 EXPIRY_DATE VARCHAR2(10),
1178 LICENSE_RESTRICTIONS PER_QUALIFICATIONS.LICENSE_RESTRICTIONS%TYPE,
1179 PROJECTED_COMPLETION_DATE VARCHAR2(10),
1180 AWARDING_BODY PER_QUALIFICATIONS.AWARDING_BODY%TYPE,
1181 TUITION_METHOD PER_QUALIFICATIONS.TUITION_METHOD%TYPE,
1182 TUITION_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,
1183 GROUP_RANKING PER_QUALIFICATIONS.GROUP_RANKING%TYPE,
1184 COMMENTS PER_QUALIFICATIONS.COMMENTS%TYPE,
1185 QUALIFICATION_TYPE_ID PER_QUALIFICATIONS.QUALIFICATION_TYPE_ID%TYPE,
1186 QUALIFICATION_TYPE_DESC PER_QUALIFICATION_TYPES_TL.NAME%TYPE,
1187 ATTENDANCE_ID PER_QUALIFICATIONS.ATTENDANCE_ID%TYPE,
1188 ATTRIBUTE_CATEGORY PER_QUALIFICATIONS.ATTRIBUTE_CATEGORY%TYPE,
1189 ATTRIBUTE1 PER_QUALIFICATIONS.ATTRIBUTE1%TYPE,
1190 ATTRIBUTE2 PER_QUALIFICATIONS.ATTRIBUTE2%TYPE,
1191 ATTRIBUTE3 PER_QUALIFICATIONS.ATTRIBUTE3%TYPE,
1192 ATTRIBUTE4 PER_QUALIFICATIONS.ATTRIBUTE4%TYPE,
1193 ATTRIBUTE5 PER_QUALIFICATIONS.ATTRIBUTE5%TYPE,
1194 ATTRIBUTE6 PER_QUALIFICATIONS.ATTRIBUTE6%TYPE,
1195 ATTRIBUTE7 PER_QUALIFICATIONS.ATTRIBUTE7%TYPE,
1196 ATTRIBUTE8 PER_QUALIFICATIONS.ATTRIBUTE8%TYPE,
1197 ATTRIBUTE9 PER_QUALIFICATIONS.ATTRIBUTE9%TYPE,
1198 ATTRIBUTE10 PER_QUALIFICATIONS.ATTRIBUTE10%TYPE,
1199 ATTRIBUTE11 PER_QUALIFICATIONS.ATTRIBUTE11%TYPE,
1200 ATTRIBUTE12 PER_QUALIFICATIONS.ATTRIBUTE12%TYPE,
1201 ATTRIBUTE13 PER_QUALIFICATIONS.ATTRIBUTE13%TYPE,
1202 ATTRIBUTE14 PER_QUALIFICATIONS.ATTRIBUTE14%TYPE,
1203 ATTRIBUTE15 PER_QUALIFICATIONS.ATTRIBUTE15%TYPE,
1204 ATTRIBUTE16 PER_QUALIFICATIONS.ATTRIBUTE16%TYPE,
1205 ATTRIBUTE17 PER_QUALIFICATIONS.ATTRIBUTE17%TYPE,
1206 ATTRIBUTE18 PER_QUALIFICATIONS.ATTRIBUTE18%TYPE,
1207 ATTRIBUTE19 PER_QUALIFICATIONS.ATTRIBUTE19%TYPE,
1208 ATTRIBUTE20 PER_QUALIFICATIONS.ATTRIBUTE20%TYPE,
1209 PARTY_ID PER_QUALIFICATIONS.PARTY_ID%TYPE,
1210 PROFESSIONAL_BODY_NAME PER_QUALIFICATIONS.PROFESSIONAL_BODY_NAME%TYPE,
1211 MEMBERSHIP_NUMBER PER_QUALIFICATIONS.MEMBERSHIP_NUMBER%TYPE,
1212 MEMBERSHIP_CATEGORY PER_QUALIFICATIONS.MEMBERSHIP_CATEGORY%TYPE,
1213 SUBSCRIPTION_PAYMENT_METHOD PER_QUALIFICATIONS.SUBSCRIPTION_PAYMENT_METHOD%TYPE,
1214 SUBSCRIPTION_PAYMENT_DESC HR_LOOKUPS.MEANING%TYPE,
1215 QUA_INFORMATION_CATEGORY PER_QUALIFICATIONS.QUA_INFORMATION_CATEGORY%TYPE,
1216 QUA_INFORMATION1 PER_QUALIFICATIONS.QUA_INFORMATION1%TYPE,
1217 QUA_INFORMATION2 PER_QUALIFICATIONS.QUA_INFORMATION2%TYPE,
1218 QUA_INFORMATION3 PER_QUALIFICATIONS.QUA_INFORMATION3%TYPE,
1219 QUA_INFORMATION4 PER_QUALIFICATIONS.QUA_INFORMATION4%TYPE,
1220 QUA_INFORMATION5 PER_QUALIFICATIONS.QUA_INFORMATION5%TYPE,
1221 QUA_INFORMATION6 PER_QUALIFICATIONS.QUA_INFORMATION6%TYPE,
1222 QUA_INFORMATION7 PER_QUALIFICATIONS.QUA_INFORMATION7%TYPE,
1223 QUA_INFORMATION8 PER_QUALIFICATIONS.QUA_INFORMATION8%TYPE,
1224 QUA_INFORMATION9 PER_QUALIFICATIONS.QUA_INFORMATION9%TYPE,
1225 QUA_INFORMATION10 PER_QUALIFICATIONS.QUA_INFORMATION10%TYPE,
1226 QUA_INFORMATION11 PER_QUALIFICATIONS.QUA_INFORMATION11%TYPE,
1227 QUA_INFORMATION12 PER_QUALIFICATIONS.QUA_INFORMATION12%TYPE,
1228 QUA_INFORMATION13 PER_QUALIFICATIONS.QUA_INFORMATION13%TYPE,
1229 QUA_INFORMATION14 PER_QUALIFICATIONS.QUA_INFORMATION14%TYPE,
1230 QUA_INFORMATION15 PER_QUALIFICATIONS.QUA_INFORMATION15%TYPE,
1231 QUA_INFORMATION16 PER_QUALIFICATIONS.QUA_INFORMATION16%TYPE,
1232 QUA_INFORMATION17 PER_QUALIFICATIONS.QUA_INFORMATION17%TYPE,
1233 QUA_INFORMATION18 PER_QUALIFICATIONS.QUA_INFORMATION18%TYPE,
1234 QUA_INFORMATION19 PER_QUALIFICATIONS.QUA_INFORMATION19%TYPE,
1235 QUA_INFORMATION20 PER_QUALIFICATIONS.QUA_INFORMATION20%TYPE
1236 );
1237
1238 TYPE QUALIFICATION_DETAILS IS RECORD
1239 (QUALIFICATIONS QUALIFICATION_DET,
1240 SUBJECT SUBJECT_RECORD);
1241
1242 TYPE REPORTEE_DETAILS IS RECORD
1243 (
1244 REPORTEE_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
1245 REPORTEE_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
1246 REPORTEE_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
1247 REPORTEE_CWK_NUMBER PER_ALL_PEOPLe_F.NPW_NUMBER%TYPE,
1248 REPORTEE_APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
1249 REPORTEE_LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE,
1250 REPORTEE_LOCATION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE, --(BASED ON LANG)E,
1251 REPORTEE_ASG_STATUS_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE,
1252 REPORTEE_ASG_STATUS_DESC PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE
1253 );
1254
1255 TYPE ABSENCE_DETAILS IS RECORD
1256 (
1257 ACCRUAL_PLAN_NAME PAY_VIEW_ACCRUAL_PLANS_V.ACCRUAL_PLAN_NAME%TYPE,
1258 ACCRUAL_NET_ENTITLEMENT NUMBER,
1259 ACCRUAL_UOM PAY_VIEW_ACCRUAL_PLANS_V.ACCRUAL_UNITS_OF_MEASURE_NAME%TYPE,
1260 AS_OF_DATE VARCHAR2(10)
1261 );
1262
1263 -- Benefits record structure was removed.
1264
1265 /*Record structure for Payroll details*/
1266 TYPE payroll_details IS RECORD
1267 (
1268 LEGISLATION_CODE VARCHAR2(30),
1269 COMPANY PAY_EMPLOYEE_ACTION_INFO_V.ORGANIZATION_NAME%TYPE,
1270 JOB_TITLE PAY_EMPLOYEE_ACTION_INFO_V.JOB%TYPE,
1271 PAYMENT_DATE VARCHAR2(10),
1272 ADDRESS VARCHAR2(2000),
1273 TAX_LOCATION PAY_EMPLOYEE_ACTION_INFO_V.LOCATION_NAME%TYPE,
1274 PAY_GROUP PAY_EMPLOYEE_ACTION_INFO_V.PAYROLL_NAME%TYPE,
1275 CURRENCY_CODE PER_BUSINESS_GROUPS.CURRENCY_CODE%TYPE,
1276 PERIOD_BEGIN VARCHAR2(10),
1277 PERIOD_END VARCHAR2(10),
1278 TAX_JURISDICTION PAY_US_EMP_W4DTL_ACTION_INFO_V.TAX_JURISDICTION%TYPE,
1279 MARITAL_STATUS PAY_US_EMP_W4DTL_ACTION_INFO_V.STATUS%TYPE,
1280 PAY_FREQUENCY PAY_EMPLOYEE_ACTION_INFO_V.PERIOD_TYPE%TYPE,
1281 RUN_TYPE PAY_RUN_TYPES_F.RUN_TYPE_NAME%TYPE,
1282 FED_EXEMPTIONS PAY_US_EMP_W4DTL_ACTION_INFO_V.EXEMPTIONS%TYPE,
1283 FED_ADDNL_TAX_AMOUNT PAY_US_EMP_W4DTL_ACTION_INFO_V.ADDITIONAL_TAX_AMOUNT%TYPE,
1284 FED_OVERRIDE_TAX_AMOUNT PAY_US_EMP_W4DTL_ACTION_INFO_V.OVERRIDE_TAX_AMOUNT%TYPE,
1285 FED_OVERRIDE_TAX_PERCENTAGE PAY_US_EMP_W4DTL_ACTION_INFO_V.OVERRIDE_TAX_PERCENTAGE%TYPE,
1286 STATE_CODE VARCHAR2(30),
1287 ST_EXEMPTIONS PAY_US_EMP_W4DTL_ACTION_INFO_V.EXEMPTIONS%TYPE,
1288 ST_ADDNL_TAX_AMOUNT PAY_US_EMP_W4DTL_ACTION_INFO_V.ADDITIONAL_TAX_AMOUNT%TYPE,
1289 ST_OVERRIDE_TAX_AMOUNT PAY_US_EMP_W4DTL_ACTION_INFO_V.OVERRIDE_TAX_AMOUNT%TYPE,
1290 ST_OVERRIDE_TAX_PERCENTAGE PAY_US_EMP_W4DTL_ACTION_INFO_V.OVERRIDE_TAX_PERCENTAGE%TYPE,
1291 TOTAL_EARNINGS_CV NUMBER,
1292 TOTAL_EARNINGS_YTD NUMBER,
1293 TOTAL_TAXES_CV NUMBER,
1294 TOTAL_TAXES_YTD NUMBER,
1295 TAX_GROSS_CV NUMBER,
1296 TAX_GROSS_YTD NUMBER,
1297 TOTAL_DED_CV NUMBER,
1298 TOTAL_DED_YTD NUMBER,
1299 TOTAL_NETPAY_CV NUMBER,
1300 TOTAL_NETPAY_YTD NUMBER,
1301 NI_CV NUMBER,
1302 NI_YTD NUMBER);
1303
1304 TYPE assignment_record is table of assignment_details INDEX BY BINARY_INTEGER;
1305 TYPE address_record is table of address_details INDEX BY BINARY_INTEGER;
1306 TYPE contact_record is table of contact_details INDEX BY BINARY_INTEGER;
1307 TYPE person_extra_info_record is table of person_extra_info_details INDEX BY BINARY_INTEGER;
1308 TYPE special_info_record is table of special_information_details INDEX BY BINARY_INTEGER;
1309 TYPE WORK_INC_INFO_RECORD is table of WORK_INC_INFO INDEX BY BINARY_INTEGER;
1310 TYPE PREV_EMP_INFO_RECORD is table of PREV_EMP_INFO INDEX BY BINARY_INTEGER;
1311 TYPE DELIV_METHOD_INFO_RECORD is table of DELIV_METHOD_INFO INDEX BY BINARY_INTEGER;
1312 TYPE ASSIGNMENT_EXTRA_INFO_RECORD is table of ASSIGNMENT_EXTRA_INFO INDEX BY BINARY_INTEGER;
1313 TYPE CONTACT_EXTRA_INFO_RECORD is table of CONTACT_EXTRA_INFO INDEX BY BINARY_INTEGER;
1314 TYPE PHONE_RECORD is table of PHONE_DETAILS INDEX BY BINARY_INTEGER;
1315 TYPE QUALIFICATION_RECORD is table of QUALIFICATION_DETAILS INDEX BY BINARY_INTEGER;
1316 TYPE REPORTEE_RECORD is table of REPORTEE_DETAILS INDEX BY BINARY_INTEGER;
1317 TYPE CONTACT_ADDRESS_RECORD IS TABLE OF CONTACT_ADDRESS_DETAILS INDEX BY BINARY_INTEGER;
1318 TYPE ABSENCE_RECORD IS TABLE OF ABSENCE_DETAILS INDEX BY BINARY_INTEGER;
1319 TYPE PAYROLL_RECORD IS TABLE OF PAYROLL_DETAILS INDEX BY BINARY_INTEGER;
1320
1321 /*Complete person record structure*/
1322 TYPE person_record_details is record
1323 (
1324 person person_details,
1325 assignment assignment_record,
1326 address address_record,
1327 contact contact_record,
1328 person_extra_information person_extra_info_record,
1329 special_information special_info_record,
1330 work_incidents work_inc_info_record,
1331 previous_employment prev_emp_info_record,
1332 delivery_methods deliv_method_info_record,
1333 assignment_extra_information assignment_extra_info_record,
1334 contact_extra_information contact_extra_info_record,
1335 phone phone_record,
1336 qualification qualification_record,
1337 reportee reportee_record,
1338 contact_address contact_address_record,
1339 absence absence_record,
1340 benefit_details BEN_PERSON_RECORD.ben_record_details,
1341 payroll payroll_record
1342 );
1343
1344 -- Person Record as table type
1345 TYPE person_record is table of person_record_details index by binary_integer;
1346
1347 /*#
1348 * This is source for GET_PERSON_DETAILS
1349 * @rep:displayname Get Person Details
1350 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
1351 * @rep:scope public
1352 * @rep:lifecycle active
1353 */
1354 procedure GET_PERSON_DETAILS (p_srch_criteria in srch_criteria,
1355 p_entity in options,
1356 p_person out nocopy person_record,
1357 p_error out nocopy varchar2);
1358 END HR_PERSON_RECORD;