eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_PARTY_API dependencies on HR_API

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

117: l_orig_hire_warning boolean;
118: l_assign_payroll_warning boolean;
119: l_legislation_code per_business_groups_perf.legislation_code%type;
120: l_ptu_person_type_id number(15);
121: l_employee_number per_all_people_f.employee_number%type := hr_api.g_varchar2;
122: --
123: -- for disabling the descriptive flex field
124: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
125: hr_dflex_utility.l_ignore_dfcode_varray();

Line 260: when hr_api.cannot_find_prog_unit then

256: ,p_start_date => l_start_date
257: ,p_party_id => p_party_id
258: );
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'CREATE_CANDIDATE_INTERNAL'
263: ,p_hook_type => 'BP'
264: );

Line 261: hr_api.cannot_find_prog_unit_error

257: ,p_party_id => p_party_id
258: );
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'CREATE_CANDIDATE_INTERNAL'
263: ,p_hook_type => 'BP'
264: );
265: end;

Line 718: when hr_api.cannot_find_prog_unit then

714: ,p_start_date => l_start_date
715: ,p_party_id => p_party_id
716: );
717: exception
718: when hr_api.cannot_find_prog_unit then
719: hr_api.cannot_find_prog_unit_error
720: (p_module_name => 'CREATE_CANDIDATE_INTERNAL'
721: ,p_hook_type => 'AP'
722: );

Line 719: hr_api.cannot_find_prog_unit_error

715: ,p_party_id => p_party_id
716: );
717: exception
718: when hr_api.cannot_find_prog_unit then
719: hr_api.cannot_find_prog_unit_error
720: (p_module_name => 'CREATE_CANDIDATE_INTERNAL'
721: ,p_hook_type => 'AP'
722: );
723: end;

Line 728: raise hr_api.validate_enabled;

724: --
725: -- When IN validation only mode raise the Validate_Enabled exception
726: --
727: if p_validate then
728: raise hr_api.validate_enabled;
729: end if;
730: --
731: -- Set all output arguments
732: --

Line 740: when hr_Api.validate_enabled then

736: --
737: hr_utility.set_location(' Leaving:'||l_proc, 70);
738:
739: exception
740: when hr_Api.validate_enabled then
741: --
742: -- As the Validate_Enabled exception has been raised
743: -- we must rollback to the savepoint
744: --

Line 1001: when hr_api.cannot_find_prog_unit then

997: ,p_allow_access => p_allow_access
998: ,p_start_date => p_start_date
999: );
1000: exception
1001: when hr_api.cannot_find_prog_unit then
1002: hr_api.cannot_find_prog_unit_error
1003: (p_module_name => 'CREATE_REGISTERED_USER'
1004: ,p_hook_type => 'BP'
1005: );

Line 1002: hr_api.cannot_find_prog_unit_error

998: ,p_start_date => p_start_date
999: );
1000: exception
1001: when hr_api.cannot_find_prog_unit then
1002: hr_api.cannot_find_prog_unit_error
1003: (p_module_name => 'CREATE_REGISTERED_USER'
1004: ,p_hook_type => 'BP'
1005: );
1006: end;

Line 1235: when hr_api.cannot_find_prog_unit then

1231: ,p_allow_access => p_allow_access
1232: ,p_start_date => p_start_date
1233: );
1234: exception
1235: when hr_api.cannot_find_prog_unit then
1236: hr_api.cannot_find_prog_unit_error
1237: (p_module_name => 'CREATE_REGISTERED_USER'
1238: ,p_hook_type => 'AP'
1239: );

Line 1236: hr_api.cannot_find_prog_unit_error

1232: ,p_start_date => p_start_date
1233: );
1234: exception
1235: when hr_api.cannot_find_prog_unit then
1236: hr_api.cannot_find_prog_unit_error
1237: (p_module_name => 'CREATE_REGISTERED_USER'
1238: ,p_hook_type => 'AP'
1239: );
1240: end;

Line 1245: raise hr_api.validate_enabled;

1241: --
1242: -- When IN validation only mode raise the Validate_Enabled exception
1243: --
1244: if p_validate then
1245: raise hr_api.validate_enabled;
1246: end if;
1247: --
1248: -- Set all output arguments
1249: --

Line 1257: when hr_Api.validate_enabled then

1253: --
1254: hr_utility.set_location(' Leaving:'||l_proc, 70);
1255: --
1256: exception
1257: when hr_Api.validate_enabled then
1258: --
1259: -- As the Validate_Enabled exception has been raised
1260: -- we must rollback to the savepoint
1261: --

Line 1294: ,p_first_name IN varchar2 default hr_api.g_varchar2

1290: procedure update_registered_user
1291: (p_validate IN boolean default false
1292: ,p_effective_date IN date
1293: ,p_person_id IN number
1294: ,p_first_name IN varchar2 default hr_api.g_varchar2
1295: ,p_last_name IN varchar2 default hr_api.g_varchar2
1296: ,p_date_of_birth IN date default hr_api.g_date
1297: ,p_title IN varchar2 default hr_api.g_varchar2
1298: ,p_gender IN varchar2 default hr_api.g_varchar2

Line 1295: ,p_last_name IN varchar2 default hr_api.g_varchar2

1291: (p_validate IN boolean default false
1292: ,p_effective_date IN date
1293: ,p_person_id IN number
1294: ,p_first_name IN varchar2 default hr_api.g_varchar2
1295: ,p_last_name IN varchar2 default hr_api.g_varchar2
1296: ,p_date_of_birth IN date default hr_api.g_date
1297: ,p_title IN varchar2 default hr_api.g_varchar2
1298: ,p_gender IN varchar2 default hr_api.g_varchar2
1299: ,p_marital_status IN varchar2 default hr_api.g_varchar2

Line 1296: ,p_date_of_birth IN date default hr_api.g_date

1292: ,p_effective_date IN date
1293: ,p_person_id IN number
1294: ,p_first_name IN varchar2 default hr_api.g_varchar2
1295: ,p_last_name IN varchar2 default hr_api.g_varchar2
1296: ,p_date_of_birth IN date default hr_api.g_date
1297: ,p_title IN varchar2 default hr_api.g_varchar2
1298: ,p_gender IN varchar2 default hr_api.g_varchar2
1299: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1300: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2

Line 1297: ,p_title IN varchar2 default hr_api.g_varchar2

1293: ,p_person_id IN number
1294: ,p_first_name IN varchar2 default hr_api.g_varchar2
1295: ,p_last_name IN varchar2 default hr_api.g_varchar2
1296: ,p_date_of_birth IN date default hr_api.g_date
1297: ,p_title IN varchar2 default hr_api.g_varchar2
1298: ,p_gender IN varchar2 default hr_api.g_varchar2
1299: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1300: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1301: ,p_middle_name IN varchar2 default hr_api.g_varchar2

Line 1298: ,p_gender IN varchar2 default hr_api.g_varchar2

1294: ,p_first_name IN varchar2 default hr_api.g_varchar2
1295: ,p_last_name IN varchar2 default hr_api.g_varchar2
1296: ,p_date_of_birth IN date default hr_api.g_date
1297: ,p_title IN varchar2 default hr_api.g_varchar2
1298: ,p_gender IN varchar2 default hr_api.g_varchar2
1299: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1300: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1301: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1302: ,p_name_suffix IN varchar2 default hr_api.g_varchar2

Line 1299: ,p_marital_status IN varchar2 default hr_api.g_varchar2

1295: ,p_last_name IN varchar2 default hr_api.g_varchar2
1296: ,p_date_of_birth IN date default hr_api.g_date
1297: ,p_title IN varchar2 default hr_api.g_varchar2
1298: ,p_gender IN varchar2 default hr_api.g_varchar2
1299: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1300: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1301: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1302: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1303: ,p_known_as IN varchar2 default hr_api.g_varchar2

Line 1300: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2

1296: ,p_date_of_birth IN date default hr_api.g_date
1297: ,p_title IN varchar2 default hr_api.g_varchar2
1298: ,p_gender IN varchar2 default hr_api.g_varchar2
1299: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1300: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1301: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1302: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1303: ,p_known_as IN varchar2 default hr_api.g_varchar2
1304: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2

Line 1301: ,p_middle_name IN varchar2 default hr_api.g_varchar2

1297: ,p_title IN varchar2 default hr_api.g_varchar2
1298: ,p_gender IN varchar2 default hr_api.g_varchar2
1299: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1300: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1301: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1302: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1303: ,p_known_as IN varchar2 default hr_api.g_varchar2
1304: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1305: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2

Line 1302: ,p_name_suffix IN varchar2 default hr_api.g_varchar2

1298: ,p_gender IN varchar2 default hr_api.g_varchar2
1299: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1300: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1301: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1302: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1303: ,p_known_as IN varchar2 default hr_api.g_varchar2
1304: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1305: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute_category IN varchar2 default hr_api.g_varchar2

Line 1303: ,p_known_as IN varchar2 default hr_api.g_varchar2

1299: ,p_marital_status IN varchar2 default hr_api.g_varchar2
1300: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1301: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1302: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1303: ,p_known_as IN varchar2 default hr_api.g_varchar2
1304: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1305: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute1 IN varchar2 default hr_api.g_varchar2

Line 1304: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2

1300: ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
1301: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1302: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1303: ,p_known_as IN varchar2 default hr_api.g_varchar2
1304: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1305: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute2 IN varchar2 default hr_api.g_varchar2

Line 1305: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2

1301: ,p_middle_name IN varchar2 default hr_api.g_varchar2
1302: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1303: ,p_known_as IN varchar2 default hr_api.g_varchar2
1304: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1305: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute3 IN varchar2 default hr_api.g_varchar2

Line 1306: ,p_attribute_category IN varchar2 default hr_api.g_varchar2

1302: ,p_name_suffix IN varchar2 default hr_api.g_varchar2
1303: ,p_known_as IN varchar2 default hr_api.g_varchar2
1304: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1305: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1310: ,p_attribute4 IN varchar2 default hr_api.g_varchar2

Line 1307: ,p_attribute1 IN varchar2 default hr_api.g_varchar2

1303: ,p_known_as IN varchar2 default hr_api.g_varchar2
1304: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1305: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1310: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1311: ,p_attribute5 IN varchar2 default hr_api.g_varchar2

Line 1308: ,p_attribute2 IN varchar2 default hr_api.g_varchar2

1304: ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
1305: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1310: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1311: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1312: ,p_attribute6 IN varchar2 default hr_api.g_varchar2

Line 1309: ,p_attribute3 IN varchar2 default hr_api.g_varchar2

1305: ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
1306: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1310: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1311: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1312: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1313: ,p_attribute7 IN varchar2 default hr_api.g_varchar2

Line 1310: ,p_attribute4 IN varchar2 default hr_api.g_varchar2

1306: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
1307: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1310: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1311: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1312: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1313: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1314: ,p_attribute8 IN varchar2 default hr_api.g_varchar2

Line 1311: ,p_attribute5 IN varchar2 default hr_api.g_varchar2

1307: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
1308: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1310: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1311: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1312: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1313: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1314: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1315: ,p_attribute9 IN varchar2 default hr_api.g_varchar2

Line 1312: ,p_attribute6 IN varchar2 default hr_api.g_varchar2

1308: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
1309: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1310: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1311: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1312: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1313: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1314: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1315: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1316: ,p_attribute10 IN varchar2 default hr_api.g_varchar2

Line 1313: ,p_attribute7 IN varchar2 default hr_api.g_varchar2

1309: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
1310: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1311: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1312: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1313: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1314: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1315: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1316: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1317: ,p_attribute11 IN varchar2 default hr_api.g_varchar2

Line 1314: ,p_attribute8 IN varchar2 default hr_api.g_varchar2

1310: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
1311: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1312: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1313: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1314: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1315: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1316: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1317: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1318: ,p_attribute12 IN varchar2 default hr_api.g_varchar2

Line 1315: ,p_attribute9 IN varchar2 default hr_api.g_varchar2

1311: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
1312: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1313: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1314: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1315: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1316: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1317: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1318: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1319: ,p_attribute13 IN varchar2 default hr_api.g_varchar2

Line 1316: ,p_attribute10 IN varchar2 default hr_api.g_varchar2

1312: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
1313: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1314: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1315: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1316: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1317: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1318: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1319: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1320: ,p_attribute14 IN varchar2 default hr_api.g_varchar2

Line 1317: ,p_attribute11 IN varchar2 default hr_api.g_varchar2

1313: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
1314: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1315: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1316: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1317: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1318: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1319: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1320: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1321: ,p_attribute15 IN varchar2 default hr_api.g_varchar2

Line 1318: ,p_attribute12 IN varchar2 default hr_api.g_varchar2

1314: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
1315: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1316: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1317: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1318: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1319: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1320: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1321: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1322: ,p_attribute16 IN varchar2 default hr_api.g_varchar2

Line 1319: ,p_attribute13 IN varchar2 default hr_api.g_varchar2

1315: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
1316: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1317: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1318: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1319: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1320: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1321: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1322: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1323: ,p_attribute17 IN varchar2 default hr_api.g_varchar2

Line 1320: ,p_attribute14 IN varchar2 default hr_api.g_varchar2

1316: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
1317: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1318: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1319: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1320: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1321: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1322: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1323: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1324: ,p_attribute18 IN varchar2 default hr_api.g_varchar2

Line 1321: ,p_attribute15 IN varchar2 default hr_api.g_varchar2

1317: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
1318: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1319: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1320: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1321: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1322: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1323: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1324: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1325: ,p_attribute19 IN varchar2 default hr_api.g_varchar2

Line 1322: ,p_attribute16 IN varchar2 default hr_api.g_varchar2

1318: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
1319: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1320: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1321: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1322: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1323: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1324: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1325: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1326: ,p_attribute20 IN varchar2 default hr_api.g_varchar2

Line 1323: ,p_attribute17 IN varchar2 default hr_api.g_varchar2

1319: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
1320: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1321: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1322: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1323: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1324: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1325: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1326: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1327: ,p_attribute21 IN varchar2 default hr_api.g_varchar2

Line 1324: ,p_attribute18 IN varchar2 default hr_api.g_varchar2

1320: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
1321: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1322: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1323: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1324: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1325: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1326: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1327: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1328: ,p_attribute22 IN varchar2 default hr_api.g_varchar2

Line 1325: ,p_attribute19 IN varchar2 default hr_api.g_varchar2

1321: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
1322: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1323: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1324: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1325: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1326: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1327: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1328: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1329: ,p_attribute23 IN varchar2 default hr_api.g_varchar2

Line 1326: ,p_attribute20 IN varchar2 default hr_api.g_varchar2

1322: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
1323: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1324: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1325: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1326: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1327: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1328: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1329: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1330: ,p_attribute24 IN varchar2 default hr_api.g_varchar2

Line 1327: ,p_attribute21 IN varchar2 default hr_api.g_varchar2

1323: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
1324: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1325: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1326: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1327: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1328: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1329: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1330: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1331: ,p_attribute25 IN varchar2 default hr_api.g_varchar2

Line 1328: ,p_attribute22 IN varchar2 default hr_api.g_varchar2

1324: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
1325: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1326: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1327: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1328: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1329: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1330: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1331: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1332: ,p_attribute26 IN varchar2 default hr_api.g_varchar2

Line 1329: ,p_attribute23 IN varchar2 default hr_api.g_varchar2

1325: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
1326: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1327: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1328: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1329: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1330: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1331: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1332: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1333: ,p_attribute27 IN varchar2 default hr_api.g_varchar2

Line 1330: ,p_attribute24 IN varchar2 default hr_api.g_varchar2

1326: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
1327: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1328: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1329: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1330: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1331: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1332: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1333: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1334: ,p_attribute28 IN varchar2 default hr_api.g_varchar2

Line 1331: ,p_attribute25 IN varchar2 default hr_api.g_varchar2

1327: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
1328: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1329: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1330: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1331: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1332: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1333: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1334: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1335: ,p_attribute29 IN varchar2 default hr_api.g_varchar2

Line 1332: ,p_attribute26 IN varchar2 default hr_api.g_varchar2

1328: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
1329: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1330: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1331: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1332: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1333: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1334: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1335: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1336: ,p_attribute30 IN varchar2 default hr_api.g_varchar2

Line 1333: ,p_attribute27 IN varchar2 default hr_api.g_varchar2

1329: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
1330: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1331: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1332: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1333: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1334: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1335: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1336: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information_category IN varchar2 default hr_api.g_varchar2

Line 1334: ,p_attribute28 IN varchar2 default hr_api.g_varchar2

1330: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
1331: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1332: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1333: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1334: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1335: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1336: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information1 IN varchar2 default hr_api.g_varchar2

Line 1335: ,p_attribute29 IN varchar2 default hr_api.g_varchar2

1331: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
1332: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1333: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1334: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1335: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1336: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information2 IN varchar2 default hr_api.g_varchar2

Line 1336: ,p_attribute30 IN varchar2 default hr_api.g_varchar2

1332: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
1333: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1334: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1335: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1336: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information3 IN varchar2 default hr_api.g_varchar2

Line 1337: ,p_per_information_category IN varchar2 default hr_api.g_varchar2

1333: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
1334: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1335: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1336: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1341: ,p_per_information4 IN varchar2 default hr_api.g_varchar2

Line 1338: ,p_per_information1 IN varchar2 default hr_api.g_varchar2

1334: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
1335: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1336: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1341: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1342: ,p_per_information5 IN varchar2 default hr_api.g_varchar2

Line 1339: ,p_per_information2 IN varchar2 default hr_api.g_varchar2

1335: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
1336: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1341: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1342: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1343: ,p_per_information6 IN varchar2 default hr_api.g_varchar2

Line 1340: ,p_per_information3 IN varchar2 default hr_api.g_varchar2

1336: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
1337: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1341: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1342: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1343: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1344: ,p_per_information7 IN varchar2 default hr_api.g_varchar2

Line 1341: ,p_per_information4 IN varchar2 default hr_api.g_varchar2

1337: ,p_per_information_category IN varchar2 default hr_api.g_varchar2
1338: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1341: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1342: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1343: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1344: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1345: ,p_per_information8 IN varchar2 default hr_api.g_varchar2

Line 1342: ,p_per_information5 IN varchar2 default hr_api.g_varchar2

1338: ,p_per_information1 IN varchar2 default hr_api.g_varchar2
1339: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1341: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1342: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1343: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1344: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1345: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1346: ,p_per_information9 IN varchar2 default hr_api.g_varchar2

Line 1343: ,p_per_information6 IN varchar2 default hr_api.g_varchar2

1339: ,p_per_information2 IN varchar2 default hr_api.g_varchar2
1340: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1341: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1342: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1343: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1344: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1345: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1346: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1347: ,p_per_information10 IN varchar2 default hr_api.g_varchar2

Line 1344: ,p_per_information7 IN varchar2 default hr_api.g_varchar2

1340: ,p_per_information3 IN varchar2 default hr_api.g_varchar2
1341: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1342: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1343: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1344: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1345: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1346: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1347: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1348: ,p_per_information11 IN varchar2 default hr_api.g_varchar2

Line 1345: ,p_per_information8 IN varchar2 default hr_api.g_varchar2

1341: ,p_per_information4 IN varchar2 default hr_api.g_varchar2
1342: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1343: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1344: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1345: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1346: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1347: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1348: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1349: ,p_per_information12 IN varchar2 default hr_api.g_varchar2

Line 1346: ,p_per_information9 IN varchar2 default hr_api.g_varchar2

1342: ,p_per_information5 IN varchar2 default hr_api.g_varchar2
1343: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1344: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1345: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1346: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1347: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1348: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1349: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1350: ,p_per_information13 IN varchar2 default hr_api.g_varchar2

Line 1347: ,p_per_information10 IN varchar2 default hr_api.g_varchar2

1343: ,p_per_information6 IN varchar2 default hr_api.g_varchar2
1344: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1345: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1346: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1347: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1348: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1349: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1350: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1351: ,p_per_information14 IN varchar2 default hr_api.g_varchar2

Line 1348: ,p_per_information11 IN varchar2 default hr_api.g_varchar2

1344: ,p_per_information7 IN varchar2 default hr_api.g_varchar2
1345: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1346: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1347: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1348: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1349: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1350: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1351: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1352: ,p_per_information15 IN varchar2 default hr_api.g_varchar2

Line 1349: ,p_per_information12 IN varchar2 default hr_api.g_varchar2

1345: ,p_per_information8 IN varchar2 default hr_api.g_varchar2
1346: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1347: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1348: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1349: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1350: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1351: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1352: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1353: ,p_per_information16 IN varchar2 default hr_api.g_varchar2

Line 1350: ,p_per_information13 IN varchar2 default hr_api.g_varchar2

1346: ,p_per_information9 IN varchar2 default hr_api.g_varchar2
1347: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1348: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1349: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1350: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1351: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1352: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1353: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1354: ,p_per_information17 IN varchar2 default hr_api.g_varchar2

Line 1351: ,p_per_information14 IN varchar2 default hr_api.g_varchar2

1347: ,p_per_information10 IN varchar2 default hr_api.g_varchar2
1348: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1349: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1350: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1351: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1352: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1353: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1354: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1355: ,p_per_information18 IN varchar2 default hr_api.g_varchar2

Line 1352: ,p_per_information15 IN varchar2 default hr_api.g_varchar2

1348: ,p_per_information11 IN varchar2 default hr_api.g_varchar2
1349: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1350: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1351: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1352: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1353: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1354: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1355: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1356: ,p_per_information19 IN varchar2 default hr_api.g_varchar2

Line 1353: ,p_per_information16 IN varchar2 default hr_api.g_varchar2

1349: ,p_per_information12 IN varchar2 default hr_api.g_varchar2
1350: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1351: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1352: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1353: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1354: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1355: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1356: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1357: ,p_per_information20 IN varchar2 default hr_api.g_varchar2

Line 1354: ,p_per_information17 IN varchar2 default hr_api.g_varchar2

1350: ,p_per_information13 IN varchar2 default hr_api.g_varchar2
1351: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1352: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1353: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1354: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1355: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1356: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1357: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1358: ,p_per_information21 IN varchar2 default hr_api.g_varchar2

Line 1355: ,p_per_information18 IN varchar2 default hr_api.g_varchar2

1351: ,p_per_information14 IN varchar2 default hr_api.g_varchar2
1352: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1353: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1354: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1355: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1356: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1357: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1358: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1359: ,p_per_information22 IN varchar2 default hr_api.g_varchar2

Line 1356: ,p_per_information19 IN varchar2 default hr_api.g_varchar2

1352: ,p_per_information15 IN varchar2 default hr_api.g_varchar2
1353: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1354: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1355: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1356: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1357: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1358: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1359: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1360: ,p_per_information23 IN varchar2 default hr_api.g_varchar2

Line 1357: ,p_per_information20 IN varchar2 default hr_api.g_varchar2

1353: ,p_per_information16 IN varchar2 default hr_api.g_varchar2
1354: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1355: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1356: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1357: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1358: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1359: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1360: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1361: ,p_per_information24 IN varchar2 default hr_api.g_varchar2

Line 1358: ,p_per_information21 IN varchar2 default hr_api.g_varchar2

1354: ,p_per_information17 IN varchar2 default hr_api.g_varchar2
1355: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1356: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1357: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1358: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1359: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1360: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1361: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1362: ,p_per_information25 IN varchar2 default hr_api.g_varchar2

Line 1359: ,p_per_information22 IN varchar2 default hr_api.g_varchar2

1355: ,p_per_information18 IN varchar2 default hr_api.g_varchar2
1356: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1357: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1358: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1359: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1360: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1361: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1362: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1363: ,p_per_information26 IN varchar2 default hr_api.g_varchar2

Line 1360: ,p_per_information23 IN varchar2 default hr_api.g_varchar2

1356: ,p_per_information19 IN varchar2 default hr_api.g_varchar2
1357: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1358: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1359: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1360: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1361: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1362: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1363: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1364: ,p_per_information27 IN varchar2 default hr_api.g_varchar2

Line 1361: ,p_per_information24 IN varchar2 default hr_api.g_varchar2

1357: ,p_per_information20 IN varchar2 default hr_api.g_varchar2
1358: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1359: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1360: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1361: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1362: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1363: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1364: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1365: ,p_per_information28 IN varchar2 default hr_api.g_varchar2

Line 1362: ,p_per_information25 IN varchar2 default hr_api.g_varchar2

1358: ,p_per_information21 IN varchar2 default hr_api.g_varchar2
1359: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1360: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1361: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1362: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1363: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1364: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1365: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1366: ,p_per_information29 IN varchar2 default hr_api.g_varchar2

Line 1363: ,p_per_information26 IN varchar2 default hr_api.g_varchar2

1359: ,p_per_information22 IN varchar2 default hr_api.g_varchar2
1360: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1361: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1362: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1363: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1364: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1365: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1366: ,p_per_information29 IN varchar2 default hr_api.g_varchar2
1367: ,p_per_information30 IN varchar2 default hr_api.g_varchar2

Line 1364: ,p_per_information27 IN varchar2 default hr_api.g_varchar2

1360: ,p_per_information23 IN varchar2 default hr_api.g_varchar2
1361: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1362: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1363: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1364: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1365: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1366: ,p_per_information29 IN varchar2 default hr_api.g_varchar2
1367: ,p_per_information30 IN varchar2 default hr_api.g_varchar2
1368: ) IS

Line 1365: ,p_per_information28 IN varchar2 default hr_api.g_varchar2

1361: ,p_per_information24 IN varchar2 default hr_api.g_varchar2
1362: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1363: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1364: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1365: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1366: ,p_per_information29 IN varchar2 default hr_api.g_varchar2
1367: ,p_per_information30 IN varchar2 default hr_api.g_varchar2
1368: ) IS
1369: --

Line 1366: ,p_per_information29 IN varchar2 default hr_api.g_varchar2

1362: ,p_per_information25 IN varchar2 default hr_api.g_varchar2
1363: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1364: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1365: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1366: ,p_per_information29 IN varchar2 default hr_api.g_varchar2
1367: ,p_per_information30 IN varchar2 default hr_api.g_varchar2
1368: ) IS
1369: --
1370: l_proc varchar2(72) := g_package||'update_registered_user';

Line 1367: ,p_per_information30 IN varchar2 default hr_api.g_varchar2

1363: ,p_per_information26 IN varchar2 default hr_api.g_varchar2
1364: ,p_per_information27 IN varchar2 default hr_api.g_varchar2
1365: ,p_per_information28 IN varchar2 default hr_api.g_varchar2
1366: ,p_per_information29 IN varchar2 default hr_api.g_varchar2
1367: ,p_per_information30 IN varchar2 default hr_api.g_varchar2
1368: ) IS
1369: --
1370: l_proc varchar2(72) := g_package||'update_registered_user';
1371: l_object_version_number per_all_people_f.object_version_number%TYPE;

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

1373: l_effective_date date;
1374: l_legislation_code per_business_groups.legislation_code%type;
1375: -- sex is defaulted to null - it is set to the value of sex
1376: -- on per_all_people_f if p_gender exists in hr_lookups
1377: l_sex per_all_people_f.sex%TYPE := hr_api.g_varchar2;
1378: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type
1379: := p_last_name_phonetic;
1380: --
1381: -- dummy variables

Line 1506: when hr_api.cannot_find_prog_unit then

1502: ,p_per_information29 => p_per_information29
1503: ,p_per_information30 => p_per_information30
1504: );
1505: exception
1506: when hr_api.cannot_find_prog_unit then
1507: hr_api.cannot_find_prog_unit_error
1508: (p_module_name => 'UPDATE_REGISTERED_USER'
1509: ,p_hook_type => 'BP'
1510: );

Line 1507: hr_api.cannot_find_prog_unit_error

1503: ,p_per_information30 => p_per_information30
1504: );
1505: exception
1506: when hr_api.cannot_find_prog_unit then
1507: hr_api.cannot_find_prog_unit_error
1508: (p_module_name => 'UPDATE_REGISTERED_USER'
1509: ,p_hook_type => 'BP'
1510: );
1511: end;

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

1513: -- Process Logic
1514: --
1515: --
1516: -- Set profile option
1517: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
1518: hr_utility.set_location(l_proc, 40);
1519: --
1520: -- Added for turn off key flex field validation
1521: --

Line 1900: when hr_api.cannot_find_prog_unit then

1896: ,p_per_information29 => p_per_information29
1897: ,p_per_information30 => p_per_information30
1898: );
1899: exception
1900: when hr_api.cannot_find_prog_unit then
1901: hr_api.cannot_find_prog_unit_error
1902: (p_module_name => 'UPDATE_REGISTERED_USER'
1903: ,p_hook_type => 'AP'
1904: );

Line 1901: hr_api.cannot_find_prog_unit_error

1897: ,p_per_information30 => p_per_information30
1898: );
1899: exception
1900: when hr_api.cannot_find_prog_unit then
1901: hr_api.cannot_find_prog_unit_error
1902: (p_module_name => 'UPDATE_REGISTERED_USER'
1903: ,p_hook_type => 'AP'
1904: );
1905: end;

Line 1910: raise hr_api.validate_enabled;

1906: --
1907: -- When IN validation only mode raise the Validate_Enabled exception
1908: --
1909: if p_validate then
1910: raise hr_api.validate_enabled;
1911: end if;
1912: --
1913: -- Set all output arguments
1914: --

Line 1919: when hr_api.validate_enabled then

1915: --
1916: hr_utility.set_location(' Leaving:'||l_proc, 70);
1917:
1918: exception
1919: when hr_api.validate_enabled then
1920: --
1921: -- As the Validate_Enabled exception has been raised
1922: -- we must rollback to the savepoint
1923: --

Line 2267: when hr_api.cannot_find_prog_unit then

2263: ,p_vacancy_id => p_vacancy_id
2264: ,p_posting_content_id => p_posting_content_id
2265: );
2266: exception
2267: when hr_api.cannot_find_prog_unit then
2268: hr_api.cannot_find_prog_unit_error
2269: (p_module_name => 'REGISTERED_USER_APPLICATION'
2270: ,p_hook_type => 'BP'
2271: );

Line 2268: hr_api.cannot_find_prog_unit_error

2264: ,p_posting_content_id => p_posting_content_id
2265: );
2266: exception
2267: when hr_api.cannot_find_prog_unit then
2268: hr_api.cannot_find_prog_unit_error
2269: (p_module_name => 'REGISTERED_USER_APPLICATION'
2270: ,p_hook_type => 'BP'
2271: );
2272: end;

Line 2689: when hr_api.cannot_find_prog_unit then

2685: ,p_assignment_id => l_assignment_id
2686: ,p_asg_object_version_number => l_asg_object_version_number
2687: );
2688: exception
2689: when hr_api.cannot_find_prog_unit then
2690: hr_api.cannot_find_prog_unit_error
2691: (p_module_name => 'REGISTERED_USER_APPLICATION'
2692: ,p_hook_type => 'AP'
2693: );

Line 2690: hr_api.cannot_find_prog_unit_error

2686: ,p_asg_object_version_number => l_asg_object_version_number
2687: );
2688: exception
2689: when hr_api.cannot_find_prog_unit then
2690: hr_api.cannot_find_prog_unit_error
2691: (p_module_name => 'REGISTERED_USER_APPLICATION'
2692: ,p_hook_type => 'AP'
2693: );
2694: end;

Line 2699: raise hr_api.validate_enabled;

2695: --
2696: -- When IN validation only mode raise the Validate_Enabled exception
2697: --
2698: if p_validate then
2699: raise hr_api.validate_enabled;
2700: end if;
2701: --
2702: -- Set all output arguments
2703: --

Line 2711: when hr_api.validate_enabled then

2707: --
2708: hr_utility.set_location(' Leaving:'||l_proc, 70);
2709:
2710: exception
2711: when hr_api.validate_enabled then
2712: --
2713: -- As the Validate_Enabled exception has been raised
2714: -- we must rollback to the savepoint
2715: --

Line 3132: when hr_api.cannot_find_prog_unit then

3128: ,p_per_information29 => p_per_information29
3129: ,p_per_information30 => p_per_information30
3130: );
3131: exception
3132: when hr_api.cannot_find_prog_unit then
3133: hr_api.cannot_find_prog_unit_error
3134: (p_module_name => 'CREATE_USER'
3135: ,p_hook_type => 'BP'
3136: );

Line 3133: hr_api.cannot_find_prog_unit_error

3129: ,p_per_information30 => p_per_information30
3130: );
3131: exception
3132: when hr_api.cannot_find_prog_unit then
3133: hr_api.cannot_find_prog_unit_error
3134: (p_module_name => 'CREATE_USER'
3135: ,p_hook_type => 'BP'
3136: );
3137: end;

Line 3251: when hr_api.cannot_find_prog_unit then

3247: ,p_per_information29 => p_per_information29
3248: ,p_per_information30 => p_per_information30
3249: );
3250: exception
3251: when hr_api.cannot_find_prog_unit then
3252: hr_api.cannot_find_prog_unit_error
3253: (p_module_name => 'CREATE_USER'
3254: ,p_hook_type => 'AP'
3255: );

Line 3252: hr_api.cannot_find_prog_unit_error

3248: ,p_per_information30 => p_per_information30
3249: );
3250: exception
3251: when hr_api.cannot_find_prog_unit then
3252: hr_api.cannot_find_prog_unit_error
3253: (p_module_name => 'CREATE_USER'
3254: ,p_hook_type => 'AP'
3255: );
3256: end;

Line 3703: when hr_api.cannot_find_prog_unit then

3699: ,p_language => p_language
3700: ,p_user_name => p_user_name
3701: );
3702: exception
3703: when hr_api.cannot_find_prog_unit then
3704: hr_api.cannot_find_prog_unit_error
3705: (p_module_name => 'SELF_REGISTER_USER'
3706: ,p_hook_type => 'BP'
3707: );

Line 3704: hr_api.cannot_find_prog_unit_error

3700: ,p_user_name => p_user_name
3701: );
3702: exception
3703: when hr_api.cannot_find_prog_unit then
3704: hr_api.cannot_find_prog_unit_error
3705: (p_module_name => 'SELF_REGISTER_USER'
3706: ,p_hook_type => 'BP'
3707: );
3708: end;

Line 3931: raise hr_api.validate_enabled;

3927: --
3928: -- Raise error before creating user as data is getting committed to OID.
3929: --
3930: if p_validate then
3931: raise hr_api.validate_enabled;
3932: end if;
3933: --
3934: -- close off the old user accounts for this person
3935: --

Line 4252: when hr_api.cannot_find_prog_unit then

4248: ,p_language => p_language
4249: ,p_user_name => p_user_name
4250: );
4251: exception
4252: when hr_api.cannot_find_prog_unit then
4253: hr_api.cannot_find_prog_unit_error
4254: (p_module_name => 'SELF_REGISTER_USER'
4255: ,p_hook_type => 'AP'
4256: );

Line 4253: hr_api.cannot_find_prog_unit_error

4249: ,p_user_name => p_user_name
4250: );
4251: exception
4252: when hr_api.cannot_find_prog_unit then
4253: hr_api.cannot_find_prog_unit_error
4254: (p_module_name => 'SELF_REGISTER_USER'
4255: ,p_hook_type => 'AP'
4256: );
4257: end;

Line 4262: raise hr_api.validate_enabled;

4258: --
4259: -- When IN validation only mode raise the Validate_Enabled exception
4260: --
4261: if p_validate then
4262: raise hr_api.validate_enabled;
4263: end if;
4264: hr_utility.set_location(' Leaving:'||l_proc, 240);
4265:
4266: exception

Line 4267: when hr_api.validate_enabled then

4263: end if;
4264: hr_utility.set_location(' Leaving:'||l_proc, 240);
4265:
4266: exception
4267: when hr_api.validate_enabled then
4268: --
4269: -- As the Validate_Enabled exception has been raised
4270: -- we must rollback to the savepoint
4271: --

Line 5387: when hr_api.cannot_find_prog_unit then

5383: ,p_per_information29 => p_per_information29
5384: ,p_per_information30 => p_per_information30
5385: );
5386: exception
5387: when hr_api.cannot_find_prog_unit then
5388: hr_api.cannot_find_prog_unit_error
5389: (p_module_name => 'CREATE_USER'
5390: ,p_hook_type => 'BP'
5391: );

Line 5388: hr_api.cannot_find_prog_unit_error

5384: ,p_per_information30 => p_per_information30
5385: );
5386: exception
5387: when hr_api.cannot_find_prog_unit then
5388: hr_api.cannot_find_prog_unit_error
5389: (p_module_name => 'CREATE_USER'
5390: ,p_hook_type => 'BP'
5391: );
5392: end;

Line 5510: when hr_api.cannot_find_prog_unit then

5506: ,p_per_information29 => p_per_information29
5507: ,p_per_information30 => p_per_information30
5508: );
5509: exception
5510: when hr_api.cannot_find_prog_unit then
5511: hr_api.cannot_find_prog_unit_error
5512: (p_module_name => 'CREATE_USER'
5513: ,p_hook_type => 'AP'
5514: );

Line 5511: hr_api.cannot_find_prog_unit_error

5507: ,p_per_information30 => p_per_information30
5508: );
5509: exception
5510: when hr_api.cannot_find_prog_unit then
5511: hr_api.cannot_find_prog_unit_error
5512: (p_module_name => 'CREATE_USER'
5513: ,p_hook_type => 'AP'
5514: );
5515: end;