112: l_orig_hire_warning boolean;
113: l_assign_payroll_warning boolean;
114: l_legislation_code per_business_groups_perf.legislation_code%type;
115: l_ptu_person_type_id number(15);
116: l_employee_number per_all_people_f.employee_number%type := hr_api.g_varchar2;
117: --
118: -- for disabling the descriptive flex field
119: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
120: hr_dflex_utility.l_ignore_dfcode_varray();
246: ,p_start_date => l_start_date
247: ,p_party_id => p_party_id
248: );
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'CREATE_CANDIDATE_INTERNAL'
253: ,p_hook_type => 'BP'
254: );
247: ,p_party_id => p_party_id
248: );
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'CREATE_CANDIDATE_INTERNAL'
253: ,p_hook_type => 'BP'
254: );
255: end;
687: ,p_start_date => l_start_date
688: ,p_party_id => p_party_id
689: );
690: exception
691: when hr_api.cannot_find_prog_unit then
692: hr_api.cannot_find_prog_unit_error
693: (p_module_name => 'CREATE_CANDIDATE_INTERNAL'
694: ,p_hook_type => 'AP'
695: );
688: ,p_party_id => p_party_id
689: );
690: exception
691: when hr_api.cannot_find_prog_unit then
692: hr_api.cannot_find_prog_unit_error
693: (p_module_name => 'CREATE_CANDIDATE_INTERNAL'
694: ,p_hook_type => 'AP'
695: );
696: end;
697: --
698: -- When IN validation only mode raise the Validate_Enabled exception
699: --
700: if p_validate then
701: raise hr_api.validate_enabled;
702: end if;
703: --
704: -- Set all output arguments
705: --
709: --
710: hr_utility.set_location(' Leaving:'||l_proc, 70);
711:
712: exception
713: when hr_Api.validate_enabled then
714: --
715: -- As the Validate_Enabled exception has been raised
716: -- we must rollback to the savepoint
717: --
970: ,p_allow_access => p_allow_access
971: ,p_start_date => p_start_date
972: );
973: exception
974: when hr_api.cannot_find_prog_unit then
975: hr_api.cannot_find_prog_unit_error
976: (p_module_name => 'CREATE_REGISTERED_USER'
977: ,p_hook_type => 'BP'
978: );
971: ,p_start_date => p_start_date
972: );
973: exception
974: when hr_api.cannot_find_prog_unit then
975: hr_api.cannot_find_prog_unit_error
976: (p_module_name => 'CREATE_REGISTERED_USER'
977: ,p_hook_type => 'BP'
978: );
979: end;
1204: ,p_allow_access => p_allow_access
1205: ,p_start_date => p_start_date
1206: );
1207: exception
1208: when hr_api.cannot_find_prog_unit then
1209: hr_api.cannot_find_prog_unit_error
1210: (p_module_name => 'CREATE_REGISTERED_USER'
1211: ,p_hook_type => 'AP'
1212: );
1205: ,p_start_date => p_start_date
1206: );
1207: exception
1208: when hr_api.cannot_find_prog_unit then
1209: hr_api.cannot_find_prog_unit_error
1210: (p_module_name => 'CREATE_REGISTERED_USER'
1211: ,p_hook_type => 'AP'
1212: );
1213: end;
1214: --
1215: -- When IN validation only mode raise the Validate_Enabled exception
1216: --
1217: if p_validate then
1218: raise hr_api.validate_enabled;
1219: end if;
1220: --
1221: -- Set all output arguments
1222: --
1226: --
1227: hr_utility.set_location(' Leaving:'||l_proc, 70);
1228: --
1229: exception
1230: when hr_Api.validate_enabled then
1231: --
1232: -- As the Validate_Enabled exception has been raised
1233: -- we must rollback to the savepoint
1234: --
1263: procedure update_registered_user
1264: (p_validate IN boolean default false
1265: ,p_effective_date IN date
1266: ,p_person_id IN number
1267: ,p_first_name IN varchar2 default hr_api.g_varchar2
1268: ,p_last_name IN varchar2 default hr_api.g_varchar2
1269: ,p_date_of_birth IN date default hr_api.g_date
1270: ,p_title IN varchar2 default hr_api.g_varchar2
1271: ,p_gender IN varchar2 default hr_api.g_varchar2
1264: (p_validate IN boolean default false
1265: ,p_effective_date IN date
1266: ,p_person_id IN number
1267: ,p_first_name IN varchar2 default hr_api.g_varchar2
1268: ,p_last_name IN varchar2 default hr_api.g_varchar2
1269: ,p_date_of_birth IN date default hr_api.g_date
1270: ,p_title IN varchar2 default hr_api.g_varchar2
1271: ,p_gender IN varchar2 default hr_api.g_varchar2
1272: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1265: ,p_effective_date IN date
1266: ,p_person_id IN number
1267: ,p_first_name IN varchar2 default hr_api.g_varchar2
1268: ,p_last_name IN varchar2 default hr_api.g_varchar2
1269: ,p_date_of_birth IN date default hr_api.g_date
1270: ,p_title IN varchar2 default hr_api.g_varchar2
1271: ,p_gender IN varchar2 default hr_api.g_varchar2
1272: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1273: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1266: ,p_person_id IN number
1267: ,p_first_name IN varchar2 default hr_api.g_varchar2
1268: ,p_last_name IN varchar2 default hr_api.g_varchar2
1269: ,p_date_of_birth IN date default hr_api.g_date
1270: ,p_title IN varchar2 default hr_api.g_varchar2
1271: ,p_gender IN varchar2 default hr_api.g_varchar2
1272: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1273: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1274: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1267: ,p_first_name IN varchar2 default hr_api.g_varchar2
1268: ,p_last_name IN varchar2 default hr_api.g_varchar2
1269: ,p_date_of_birth IN date default hr_api.g_date
1270: ,p_title IN varchar2 default hr_api.g_varchar2
1271: ,p_gender IN varchar2 default hr_api.g_varchar2
1272: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1273: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1274: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1275: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1268: ,p_last_name IN varchar2 default hr_api.g_varchar2
1269: ,p_date_of_birth IN date default hr_api.g_date
1270: ,p_title IN varchar2 default hr_api.g_varchar2
1271: ,p_gender IN varchar2 default hr_api.g_varchar2
1272: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1273: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1274: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1275: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1276: ,p_known_as IN varchar2 default hr_api.g_varchar2
1269: ,p_date_of_birth IN date default hr_api.g_date
1270: ,p_title IN varchar2 default hr_api.g_varchar2
1271: ,p_gender IN varchar2 default hr_api.g_varchar2
1272: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1273: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1274: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1275: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1276: ,p_known_as IN varchar2 default hr_api.g_varchar2
1277: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1270: ,p_title IN varchar2 default hr_api.g_varchar2
1271: ,p_gender IN varchar2 default hr_api.g_varchar2
1272: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1273: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1274: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1275: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1276: ,p_known_as IN varchar2 default hr_api.g_varchar2
1277: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1278: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1271: ,p_gender IN varchar2 default hr_api.g_varchar2
1272: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1273: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1274: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1275: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1276: ,p_known_as IN varchar2 default hr_api.g_varchar2
1277: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1278: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1279: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1272: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1273: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1274: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1275: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1276: ,p_known_as IN varchar2 default hr_api.g_varchar2
1277: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1278: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1279: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1280: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1273: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1274: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1275: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1276: ,p_known_as IN varchar2 default hr_api.g_varchar2
1277: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1278: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1279: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1280: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1281: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1274: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1275: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1276: ,p_known_as IN varchar2 default hr_api.g_varchar2
1277: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1278: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1279: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1280: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1281: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1282: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1275: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1276: ,p_known_as IN varchar2 default hr_api.g_varchar2
1277: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1278: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1279: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1280: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1281: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1282: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1283: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1276: ,p_known_as IN varchar2 default hr_api.g_varchar2
1277: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1278: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1279: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1280: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1281: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1282: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1283: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1284: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1277: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1278: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1279: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1280: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1281: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1282: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1283: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1284: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1285: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1278: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1279: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1280: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1281: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1282: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1283: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1284: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1285: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1286: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1279: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1280: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1281: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1282: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1283: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1284: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1285: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1286: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1287: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1280: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1281: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1282: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1283: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1284: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1285: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1286: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1287: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1288: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1281: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1282: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1283: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1284: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1285: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1286: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1287: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1288: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1289: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1282: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1283: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1284: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1285: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1286: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1287: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1288: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1289: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1290: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1283: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1284: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1285: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1286: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1287: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1288: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1289: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1290: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1291: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1284: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1285: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1286: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1287: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1288: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1289: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1290: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1291: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1292: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1285: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1286: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1287: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1288: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1289: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1290: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1291: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1292: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1293: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1286: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1287: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1288: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1289: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1290: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1291: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1292: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1293: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1294: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1287: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1288: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1289: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1290: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1291: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1292: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1293: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1294: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1295: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1288: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1289: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1290: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1291: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1292: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1293: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1294: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1295: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1296: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1289: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1290: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1291: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1292: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1293: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1294: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1295: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1296: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1297: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1290: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1291: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1292: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1293: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1294: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1295: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1296: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1297: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1298: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1291: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1292: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1293: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1294: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1295: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1296: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1297: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1298: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1299: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1292: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1293: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1294: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1295: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1296: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1297: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1298: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1299: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1300: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1293: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1294: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1295: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1296: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1297: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1298: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1299: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1300: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1301: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1294: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1295: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1296: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1297: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1298: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1299: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1300: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1301: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1302: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1295: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1296: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1297: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1298: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1299: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1300: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1301: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1302: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1303: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1296: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1297: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1298: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1299: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1300: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1301: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1302: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1303: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1304: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1297: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1298: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1299: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1300: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1301: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1302: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1303: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1304: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1305: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1298: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1299: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1300: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1301: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1302: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1303: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1304: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1305: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1299: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1300: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1301: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1302: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1303: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1304: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1305: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1300: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1301: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1302: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1303: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1304: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1305: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1301: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1302: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1303: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1304: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1305: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1302: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1303: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1304: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1305: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1310: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1303: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1304: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1305: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1310: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1311: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1304: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1305: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1310: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1311: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1312: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1305: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1310: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1311: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1312: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1313: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1310: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1311: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1312: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1313: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1314: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1310: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1311: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1312: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1313: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1314: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1315: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1310: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1311: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1312: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1313: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1314: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1315: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1316: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1310: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1311: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1312: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1313: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1314: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1315: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1316: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1317: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1310: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1311: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1312: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1313: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1314: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1315: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1316: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1317: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1318: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1311: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1312: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1313: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1314: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1315: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1316: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1317: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1318: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1319: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1312: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1313: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1314: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1315: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1316: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1317: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1318: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1319: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1320: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1313: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1314: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1315: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1316: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1317: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1318: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1319: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1320: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1321: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1314: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1315: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1316: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1317: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1318: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1319: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1320: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1321: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1322: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1315: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1316: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1317: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1318: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1319: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1320: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1321: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1322: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1323: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1316: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1317: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1318: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1319: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1320: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1321: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1322: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1323: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1324: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1317: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1318: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1319: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1320: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1321: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1322: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1323: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1324: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1325: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1318: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1319: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1320: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1321: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1322: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1323: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1324: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1325: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1326: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1319: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1320: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1321: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1322: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1323: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1324: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1325: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1326: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1327: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1320: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1321: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1322: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1323: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1324: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1325: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1326: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1327: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1328: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1321: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1322: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1323: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1324: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1325: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1326: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1327: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1328: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1329: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1322: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1323: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1324: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1325: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1326: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1327: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1328: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1329: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1330: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1323: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1324: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1325: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1326: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1327: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1328: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1329: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1330: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1331: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1324: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1325: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1326: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1327: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1328: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1329: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1330: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1331: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1332: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1325: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1326: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1327: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1328: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1329: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1330: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1331: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1332: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1333: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1326: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1327: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1328: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1329: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1330: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1331: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1332: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1333: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1334: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1327: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1328: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1329: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1330: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1331: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1332: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1333: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1334: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1335: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1328: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1329: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1330: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1331: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1332: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1333: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1334: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1335: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1336: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1329: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1330: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1331: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1332: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1333: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1334: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1335: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1336: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1330: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1331: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1332: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1333: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1334: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1335: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1336: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1331: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1332: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1333: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1334: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1335: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1336: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information29 IN varchar2 default hr_api.g_varchar2
1332: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1333: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1334: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1335: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1336: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information29 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information30 IN varchar2 default hr_api.g_varchar2
1333: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1334: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1335: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1336: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information29 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information30 IN varchar2 default hr_api.g_varchar2
1341: ) IS
1334: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1335: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1336: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information29 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information30 IN varchar2 default hr_api.g_varchar2
1341: ) IS
1342: --
1335: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1336: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information29 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information30 IN varchar2 default hr_api.g_varchar2
1341: ) IS
1342: --
1343: l_proc varchar2(72) := g_package||'update_registered_user';
1336: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information29 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information30 IN varchar2 default hr_api.g_varchar2
1341: ) IS
1342: --
1343: l_proc varchar2(72) := g_package||'update_registered_user';
1344: l_object_version_number per_all_people_f.object_version_number%TYPE;
1346: l_effective_date date;
1347: l_legislation_code per_business_groups.legislation_code%type;
1348: -- sex is defaulted to null - it is set to the value of sex
1349: -- on per_all_people_f if p_gender exists in hr_lookups
1350: l_sex per_all_people_f.sex%TYPE := hr_api.g_varchar2;
1351: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type
1352: := p_last_name_phonetic;
1353: --
1354: -- dummy variables
1474: ,p_per_information29 => p_per_information29
1475: ,p_per_information30 => p_per_information30
1476: );
1477: exception
1478: when hr_api.cannot_find_prog_unit then
1479: hr_api.cannot_find_prog_unit_error
1480: (p_module_name => 'UPDATE_REGISTERED_USER'
1481: ,p_hook_type => 'BP'
1482: );
1475: ,p_per_information30 => p_per_information30
1476: );
1477: exception
1478: when hr_api.cannot_find_prog_unit then
1479: hr_api.cannot_find_prog_unit_error
1480: (p_module_name => 'UPDATE_REGISTERED_USER'
1481: ,p_hook_type => 'BP'
1482: );
1483: end;
1485: -- Process Logic
1486: --
1487: --
1488: -- Set profile option
1489: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
1490: hr_utility.set_location(l_proc, 40);
1491: --
1492: -- Added for turn off key flex field validation
1493: --
1871: ,p_per_information29 => p_per_information29
1872: ,p_per_information30 => p_per_information30
1873: );
1874: exception
1875: when hr_api.cannot_find_prog_unit then
1876: hr_api.cannot_find_prog_unit_error
1877: (p_module_name => 'UPDATE_REGISTERED_USER'
1878: ,p_hook_type => 'AP'
1879: );
1872: ,p_per_information30 => p_per_information30
1873: );
1874: exception
1875: when hr_api.cannot_find_prog_unit then
1876: hr_api.cannot_find_prog_unit_error
1877: (p_module_name => 'UPDATE_REGISTERED_USER'
1878: ,p_hook_type => 'AP'
1879: );
1880: end;
1881: --
1882: -- When IN validation only mode raise the Validate_Enabled exception
1883: --
1884: if p_validate then
1885: raise hr_api.validate_enabled;
1886: end if;
1887: --
1888: -- Set all output arguments
1889: --
1890: --
1891: hr_utility.set_location(' Leaving:'||l_proc, 70);
1892:
1893: exception
1894: when hr_api.validate_enabled then
1895: --
1896: -- As the Validate_Enabled exception has been raised
1897: -- we must rollback to the savepoint
1898: --
2203: ,p_vacancy_id => p_vacancy_id
2204: ,p_posting_content_id => p_posting_content_id
2205: );
2206: exception
2207: when hr_api.cannot_find_prog_unit then
2208: hr_api.cannot_find_prog_unit_error
2209: (p_module_name => 'REGISTERED_USER_APPLICATION'
2210: ,p_hook_type => 'BP'
2211: );
2204: ,p_posting_content_id => p_posting_content_id
2205: );
2206: exception
2207: when hr_api.cannot_find_prog_unit then
2208: hr_api.cannot_find_prog_unit_error
2209: (p_module_name => 'REGISTERED_USER_APPLICATION'
2210: ,p_hook_type => 'BP'
2211: );
2212: end;
2568: ,p_assignment_id => l_assignment_id
2569: ,p_asg_object_version_number => l_asg_object_version_number
2570: );
2571: exception
2572: when hr_api.cannot_find_prog_unit then
2573: hr_api.cannot_find_prog_unit_error
2574: (p_module_name => 'REGISTERED_USER_APPLICATION'
2575: ,p_hook_type => 'AP'
2576: );
2569: ,p_asg_object_version_number => l_asg_object_version_number
2570: );
2571: exception
2572: when hr_api.cannot_find_prog_unit then
2573: hr_api.cannot_find_prog_unit_error
2574: (p_module_name => 'REGISTERED_USER_APPLICATION'
2575: ,p_hook_type => 'AP'
2576: );
2577: end;
2578: --
2579: -- When IN validation only mode raise the Validate_Enabled exception
2580: --
2581: if p_validate then
2582: raise hr_api.validate_enabled;
2583: end if;
2584: --
2585: -- Set all output arguments
2586: --
2590: --
2591: hr_utility.set_location(' Leaving:'||l_proc, 70);
2592:
2593: exception
2594: when hr_api.validate_enabled then
2595: --
2596: -- As the Validate_Enabled exception has been raised
2597: -- we must rollback to the savepoint
2598: --
3011: ,p_per_information29 => p_per_information29
3012: ,p_per_information30 => p_per_information30
3013: );
3014: exception
3015: when hr_api.cannot_find_prog_unit then
3016: hr_api.cannot_find_prog_unit_error
3017: (p_module_name => 'CREATE_USER'
3018: ,p_hook_type => 'BP'
3019: );
3012: ,p_per_information30 => p_per_information30
3013: );
3014: exception
3015: when hr_api.cannot_find_prog_unit then
3016: hr_api.cannot_find_prog_unit_error
3017: (p_module_name => 'CREATE_USER'
3018: ,p_hook_type => 'BP'
3019: );
3020: end;
3130: ,p_per_information29 => p_per_information29
3131: ,p_per_information30 => p_per_information30
3132: );
3133: exception
3134: when hr_api.cannot_find_prog_unit then
3135: hr_api.cannot_find_prog_unit_error
3136: (p_module_name => 'CREATE_USER'
3137: ,p_hook_type => 'AP'
3138: );
3131: ,p_per_information30 => p_per_information30
3132: );
3133: exception
3134: when hr_api.cannot_find_prog_unit then
3135: hr_api.cannot_find_prog_unit_error
3136: (p_module_name => 'CREATE_USER'
3137: ,p_hook_type => 'AP'
3138: );
3139: end;
3558: ,p_language => p_language
3559: ,p_user_name => p_user_name
3560: );
3561: exception
3562: when hr_api.cannot_find_prog_unit then
3563: hr_api.cannot_find_prog_unit_error
3564: (p_module_name => 'SELF_REGISTER_USER'
3565: ,p_hook_type => 'BP'
3566: );
3559: ,p_user_name => p_user_name
3560: );
3561: exception
3562: when hr_api.cannot_find_prog_unit then
3563: hr_api.cannot_find_prog_unit_error
3564: (p_module_name => 'SELF_REGISTER_USER'
3565: ,p_hook_type => 'BP'
3566: );
3567: end;
4020: ,p_language => p_language
4021: ,p_user_name => p_user_name
4022: );
4023: exception
4024: when hr_api.cannot_find_prog_unit then
4025: hr_api.cannot_find_prog_unit_error
4026: (p_module_name => 'SELF_REGISTER_USER'
4027: ,p_hook_type => 'AP'
4028: );
4021: ,p_user_name => p_user_name
4022: );
4023: exception
4024: when hr_api.cannot_find_prog_unit then
4025: hr_api.cannot_find_prog_unit_error
4026: (p_module_name => 'SELF_REGISTER_USER'
4027: ,p_hook_type => 'AP'
4028: );
4029: end;
4030: --
4031: -- When IN validation only mode raise the Validate_Enabled exception
4032: --
4033: if p_validate then
4034: raise hr_api.validate_enabled;
4035: end if;
4036: hr_utility.set_location(' Leaving:'||l_proc, 240);
4037:
4038: exception
4035: end if;
4036: hr_utility.set_location(' Leaving:'||l_proc, 240);
4037:
4038: exception
4039: when hr_api.validate_enabled then
4040: --
4041: -- As the Validate_Enabled exception has been raised
4042: -- we must rollback to the savepoint
4043: --
5149: ,p_per_information29 => p_per_information29
5150: ,p_per_information30 => p_per_information30
5151: );
5152: exception
5153: when hr_api.cannot_find_prog_unit then
5154: hr_api.cannot_find_prog_unit_error
5155: (p_module_name => 'CREATE_USER'
5156: ,p_hook_type => 'BP'
5157: );
5150: ,p_per_information30 => p_per_information30
5151: );
5152: exception
5153: when hr_api.cannot_find_prog_unit then
5154: hr_api.cannot_find_prog_unit_error
5155: (p_module_name => 'CREATE_USER'
5156: ,p_hook_type => 'BP'
5157: );
5158: end;
5269: ,p_per_information29 => p_per_information29
5270: ,p_per_information30 => p_per_information30
5271: );
5272: exception
5273: when hr_api.cannot_find_prog_unit then
5274: hr_api.cannot_find_prog_unit_error
5275: (p_module_name => 'CREATE_USER'
5276: ,p_hook_type => 'AP'
5277: );
5270: ,p_per_information30 => p_per_information30
5271: );
5272: exception
5273: when hr_api.cannot_find_prog_unit then
5274: hr_api.cannot_find_prog_unit_error
5275: (p_module_name => 'CREATE_USER'
5276: ,p_hook_type => 'AP'
5277: );
5278: end;