DBA Data[Home] [Help]

APPS.IRC_PARTY_API dependencies on HR_API

Line 116: l_employee_number per_all_people_f.employee_number%type := hr_api.g_varchar2;

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();

Line 250: when hr_api.cannot_find_prog_unit then

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: );

Line 251: hr_api.cannot_find_prog_unit_error

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;

Line 691: when hr_api.cannot_find_prog_unit then

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: );

Line 692: hr_api.cannot_find_prog_unit_error

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;

Line 701: raise hr_api.validate_enabled;

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: --

Line 713: when hr_Api.validate_enabled then

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: --

Line 974: when hr_api.cannot_find_prog_unit then

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: );

Line 975: hr_api.cannot_find_prog_unit_error

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;

Line 1208: when hr_api.cannot_find_prog_unit then

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: );

Line 1209: hr_api.cannot_find_prog_unit_error

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;

Line 1218: raise hr_api.validate_enabled;

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: --

Line 1230: when hr_Api.validate_enabled then

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: --

Line 1267: ,p_first_name IN varchar2 default hr_api.g_varchar2

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

Line 1268: ,p_last_name 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

Line 1269: ,p_date_of_birth IN date default hr_api.g_date

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

Line 1270: ,p_title 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

Line 1271: ,p_gender 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

Line 1272: ,p_marital_status 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

Line 1273: ,p_previous_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
1277: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2

Line 1274: ,p_middle_name 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

Line 1275: ,p_name_suffix 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

Line 1276: ,p_known_as 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

Line 1277: ,p_first_name_phonetic 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

Line 1278: ,p_last_name_phonetic 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

Line 1279: ,p_attribute_category 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

Line 1280: ,p_attribute1 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

Line 1281: ,p_attribute2 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

Line 1282: ,p_attribute3 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

Line 1283: ,p_attribute4 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

Line 1284: ,p_attribute5 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

Line 1285: ,p_attribute6 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

Line 1286: ,p_attribute7 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

Line 1287: ,p_attribute8 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

Line 1288: ,p_attribute9 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

Line 1289: ,p_attribute10 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

Line 1290: ,p_attribute11 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

Line 1291: ,p_attribute12 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

Line 1292: ,p_attribute13 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

Line 1293: ,p_attribute14 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

Line 1294: ,p_attribute15 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

Line 1295: ,p_attribute16 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

Line 1296: ,p_attribute17 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

Line 1297: ,p_attribute18 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

Line 1298: ,p_attribute19 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

Line 1299: ,p_attribute20 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

Line 1300: ,p_attribute21 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

Line 1301: ,p_attribute22 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

Line 1302: ,p_attribute23 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

Line 1303: ,p_attribute24 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

Line 1304: ,p_attribute25 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

Line 1305: ,p_attribute26 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

Line 1306: ,p_attribute27 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

Line 1307: ,p_attribute28 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

Line 1308: ,p_attribute29 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

Line 1309: ,p_attribute30 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

Line 1310: ,p_per_information_category 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

Line 1311: ,p_per_information1 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

Line 1312: ,p_per_information2 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

Line 1313: ,p_per_information3 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

Line 1314: ,p_per_information4 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

Line 1315: ,p_per_information5 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

Line 1316: ,p_per_information6 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

Line 1317: ,p_per_information7 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

Line 1318: ,p_per_information8 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

Line 1319: ,p_per_information9 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

Line 1320: ,p_per_information10 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

Line 1321: ,p_per_information11 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

Line 1322: ,p_per_information12 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

Line 1323: ,p_per_information13 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

Line 1324: ,p_per_information14 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

Line 1325: ,p_per_information15 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

Line 1326: ,p_per_information16 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

Line 1327: ,p_per_information17 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

Line 1328: ,p_per_information18 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

Line 1329: ,p_per_information19 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

Line 1330: ,p_per_information20 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

Line 1331: ,p_per_information21 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

Line 1332: ,p_per_information22 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

Line 1333: ,p_per_information23 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

Line 1334: ,p_per_information24 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

Line 1335: ,p_per_information25 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

Line 1336: ,p_per_information26 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

Line 1337: ,p_per_information27 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

Line 1338: ,p_per_information28 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
1342: --

Line 1339: ,p_per_information29 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: --
1343: l_proc varchar2(72) := g_package||'update_registered_user';

Line 1340: ,p_per_information30 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';
1344: l_object_version_number per_all_people_f.object_version_number%TYPE;

Line 1350: l_sex per_all_people_f.sex%TYPE := hr_api.g_varchar2;

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

Line 1478: when hr_api.cannot_find_prog_unit then

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: );

Line 1479: hr_api.cannot_find_prog_unit_error

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;

Line 1489: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');

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: --

Line 1875: when hr_api.cannot_find_prog_unit then

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: );

Line 1876: hr_api.cannot_find_prog_unit_error

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;

Line 1885: raise hr_api.validate_enabled;

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: --

Line 1894: when hr_api.validate_enabled then

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: --

Line 2207: when hr_api.cannot_find_prog_unit then

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: );

Line 2208: hr_api.cannot_find_prog_unit_error

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;

Line 2572: when hr_api.cannot_find_prog_unit then

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: );

Line 2573: hr_api.cannot_find_prog_unit_error

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;

Line 2582: raise hr_api.validate_enabled;

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: --

Line 2594: when hr_api.validate_enabled then

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: --

Line 3015: when hr_api.cannot_find_prog_unit then

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: );

Line 3016: hr_api.cannot_find_prog_unit_error

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;

Line 3134: when hr_api.cannot_find_prog_unit then

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: );

Line 3135: hr_api.cannot_find_prog_unit_error

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;

Line 3562: when hr_api.cannot_find_prog_unit then

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: );

Line 3563: hr_api.cannot_find_prog_unit_error

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;

Line 4024: when hr_api.cannot_find_prog_unit then

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: );

Line 4025: hr_api.cannot_find_prog_unit_error

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;

Line 4034: raise hr_api.validate_enabled;

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

Line 4039: when hr_api.validate_enabled then

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: --

Line 5153: when hr_api.cannot_find_prog_unit then

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: );

Line 5154: hr_api.cannot_find_prog_unit_error

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;

Line 5273: when hr_api.cannot_find_prog_unit then

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: );

Line 5274: hr_api.cannot_find_prog_unit_error

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;