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.PER_PER_UPD dependencies on HR_API

Line 277: When hr_api.check_integrity_violated Then

273: End If;
274: --
275: hr_utility.set_location(' Leaving:'||l_proc, 15);
276: Exception
277: When hr_api.check_integrity_violated Then
278: -- A check constraint has been violated
279: per_per_shd.g_api_dml := false; -- Unset the api dml status
280: per_per_shd.constraint_error
281: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 281: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

277: When hr_api.check_integrity_violated Then
278: -- A check constraint has been violated
279: per_per_shd.g_api_dml := false; -- Unset the api dml status
280: per_per_shd.constraint_error
281: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
282: When hr_api.unique_integrity_violated Then
283: -- Unique integrity has been violated
284: per_per_shd.g_api_dml := false; -- Unset the api dml status
285: per_per_shd.constraint_error

Line 282: When hr_api.unique_integrity_violated Then

278: -- A check constraint has been violated
279: per_per_shd.g_api_dml := false; -- Unset the api dml status
280: per_per_shd.constraint_error
281: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
282: When hr_api.unique_integrity_violated Then
283: -- Unique integrity has been violated
284: per_per_shd.g_api_dml := false; -- Unset the api dml status
285: per_per_shd.constraint_error
286: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 286: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

282: When hr_api.unique_integrity_violated Then
283: -- Unique integrity has been violated
284: per_per_shd.g_api_dml := false; -- Unset the api dml status
285: per_per_shd.constraint_error
286: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
287: When Others Then
288: per_per_shd.g_api_dml := false; -- Unset the api dml status
289: Raise;
290: End dt_update_dml;

Line 1111: when hr_api.cannot_find_prog_unit then

1107: ,p_object_version_number_o
1108: => per_per_shd.g_old_rec.object_version_number
1109: );
1110: exception
1111: when hr_api.cannot_find_prog_unit then
1112: hr_api.cannot_find_prog_unit_error
1113: (p_module_name => 'per_all_people_f'
1114: ,p_hook_type => 'AU'
1115: );

Line 1112: hr_api.cannot_find_prog_unit_error

1108: => per_per_shd.g_old_rec.object_version_number
1109: );
1110: exception
1111: when hr_api.cannot_find_prog_unit then
1112: hr_api.cannot_find_prog_unit_error
1113: (p_module_name => 'per_all_people_f'
1114: ,p_hook_type => 'AU'
1115: );
1116: end;

Line 1190: If (p_rec.business_group_id = hr_api.g_number) then

1186: -- p_rec plsql record structure
1187: -- to see if a system default is being used. If a system default
1188: -- is being used then we must set to the 'current' argument value.
1189: --
1190: If (p_rec.business_group_id = hr_api.g_number) then
1191: p_rec.business_group_id :=
1192: per_per_shd.g_old_rec.business_group_id;
1193: End If;
1194: If (p_rec.person_type_id = hr_api.g_number) then

Line 1194: If (p_rec.person_type_id = hr_api.g_number) then

1190: If (p_rec.business_group_id = hr_api.g_number) then
1191: p_rec.business_group_id :=
1192: per_per_shd.g_old_rec.business_group_id;
1193: End If;
1194: If (p_rec.person_type_id = hr_api.g_number) then
1195: p_rec.person_type_id :=
1196: per_per_shd.g_old_rec.person_type_id;
1197: End If;
1198: If (p_rec.last_name = hr_api.g_varchar2) then

Line 1198: If (p_rec.last_name = hr_api.g_varchar2) then

1194: If (p_rec.person_type_id = hr_api.g_number) then
1195: p_rec.person_type_id :=
1196: per_per_shd.g_old_rec.person_type_id;
1197: End If;
1198: If (p_rec.last_name = hr_api.g_varchar2) then
1199: p_rec.last_name :=
1200: per_per_shd.g_old_rec.last_name;
1201: End If;
1202: If (p_rec.start_date = hr_api.g_date) then

Line 1202: If (p_rec.start_date = hr_api.g_date) then

1198: If (p_rec.last_name = hr_api.g_varchar2) then
1199: p_rec.last_name :=
1200: per_per_shd.g_old_rec.last_name;
1201: End If;
1202: If (p_rec.start_date = hr_api.g_date) then
1203: p_rec.start_date :=
1204: per_per_shd.g_old_rec.start_date;
1205: End If;
1206: If (p_rec.applicant_number = hr_api.g_varchar2) then

Line 1206: If (p_rec.applicant_number = hr_api.g_varchar2) then

1202: If (p_rec.start_date = hr_api.g_date) then
1203: p_rec.start_date :=
1204: per_per_shd.g_old_rec.start_date;
1205: End If;
1206: If (p_rec.applicant_number = hr_api.g_varchar2) then
1207: p_rec.applicant_number :=
1208: per_per_shd.g_old_rec.applicant_number;
1209: End If;
1210: If (p_rec.comment_id = hr_api.g_number) then

Line 1210: If (p_rec.comment_id = hr_api.g_number) then

1206: If (p_rec.applicant_number = hr_api.g_varchar2) then
1207: p_rec.applicant_number :=
1208: per_per_shd.g_old_rec.applicant_number;
1209: End If;
1210: If (p_rec.comment_id = hr_api.g_number) then
1211: p_rec.comment_id :=
1212: per_per_shd.g_old_rec.comment_id;
1213: End If;
1214: If (p_rec.comments = hr_api.g_varchar2) then

Line 1214: If (p_rec.comments = hr_api.g_varchar2) then

1210: If (p_rec.comment_id = hr_api.g_number) then
1211: p_rec.comment_id :=
1212: per_per_shd.g_old_rec.comment_id;
1213: End If;
1214: If (p_rec.comments = hr_api.g_varchar2) then
1215: p_rec.comments := per_per_shd.g_old_rec.comments;
1216: End If;
1217: If (p_rec.current_applicant_flag = hr_api.g_varchar2) then
1218: p_rec.current_applicant_flag :=

Line 1217: If (p_rec.current_applicant_flag = hr_api.g_varchar2) then

1213: End If;
1214: If (p_rec.comments = hr_api.g_varchar2) then
1215: p_rec.comments := per_per_shd.g_old_rec.comments;
1216: End If;
1217: If (p_rec.current_applicant_flag = hr_api.g_varchar2) then
1218: p_rec.current_applicant_flag :=
1219: per_per_shd.g_old_rec.current_applicant_flag;
1220: End If;
1221: If (p_rec.current_emp_or_apl_flag = hr_api.g_varchar2) then

Line 1221: If (p_rec.current_emp_or_apl_flag = hr_api.g_varchar2) then

1217: If (p_rec.current_applicant_flag = hr_api.g_varchar2) then
1218: p_rec.current_applicant_flag :=
1219: per_per_shd.g_old_rec.current_applicant_flag;
1220: End If;
1221: If (p_rec.current_emp_or_apl_flag = hr_api.g_varchar2) then
1222: p_rec.current_emp_or_apl_flag :=
1223: per_per_shd.g_old_rec.current_emp_or_apl_flag;
1224: End If;
1225: If (p_rec.current_employee_flag = hr_api.g_varchar2) then

Line 1225: If (p_rec.current_employee_flag = hr_api.g_varchar2) then

1221: If (p_rec.current_emp_or_apl_flag = hr_api.g_varchar2) then
1222: p_rec.current_emp_or_apl_flag :=
1223: per_per_shd.g_old_rec.current_emp_or_apl_flag;
1224: End If;
1225: If (p_rec.current_employee_flag = hr_api.g_varchar2) then
1226: p_rec.current_employee_flag :=
1227: per_per_shd.g_old_rec.current_employee_flag;
1228: End If;
1229: If (p_rec.date_employee_data_verified = hr_api.g_date) then

Line 1229: If (p_rec.date_employee_data_verified = hr_api.g_date) then

1225: If (p_rec.current_employee_flag = hr_api.g_varchar2) then
1226: p_rec.current_employee_flag :=
1227: per_per_shd.g_old_rec.current_employee_flag;
1228: End If;
1229: If (p_rec.date_employee_data_verified = hr_api.g_date) then
1230: p_rec.date_employee_data_verified :=
1231: per_per_shd.g_old_rec.date_employee_data_verified;
1232: End If;
1233: If (p_rec.date_of_birth = hr_api.g_date) then

Line 1233: If (p_rec.date_of_birth = hr_api.g_date) then

1229: If (p_rec.date_employee_data_verified = hr_api.g_date) then
1230: p_rec.date_employee_data_verified :=
1231: per_per_shd.g_old_rec.date_employee_data_verified;
1232: End If;
1233: If (p_rec.date_of_birth = hr_api.g_date) then
1234: p_rec.date_of_birth :=
1235: per_per_shd.g_old_rec.date_of_birth;
1236: End If;
1237: If (p_rec.email_address = hr_api.g_varchar2) then

Line 1237: If (p_rec.email_address = hr_api.g_varchar2) then

1233: If (p_rec.date_of_birth = hr_api.g_date) then
1234: p_rec.date_of_birth :=
1235: per_per_shd.g_old_rec.date_of_birth;
1236: End If;
1237: If (p_rec.email_address = hr_api.g_varchar2) then
1238: p_rec.email_address :=
1239: per_per_shd.g_old_rec.email_address;
1240: End If;
1241: If (p_rec.employee_number = hr_api.g_varchar2) then

Line 1241: If (p_rec.employee_number = hr_api.g_varchar2) then

1237: If (p_rec.email_address = hr_api.g_varchar2) then
1238: p_rec.email_address :=
1239: per_per_shd.g_old_rec.email_address;
1240: End If;
1241: If (p_rec.employee_number = hr_api.g_varchar2) then
1242: p_rec.employee_number :=
1243: per_per_shd.g_old_rec.employee_number;
1244: End If;
1245: If (p_rec.expense_check_send_to_address = hr_api.g_varchar2) then

Line 1245: If (p_rec.expense_check_send_to_address = hr_api.g_varchar2) then

1241: If (p_rec.employee_number = hr_api.g_varchar2) then
1242: p_rec.employee_number :=
1243: per_per_shd.g_old_rec.employee_number;
1244: End If;
1245: If (p_rec.expense_check_send_to_address = hr_api.g_varchar2) then
1246: p_rec.expense_check_send_to_address :=
1247: per_per_shd.g_old_rec.expense_check_send_to_address;
1248: End If;
1249: If (p_rec.first_name = hr_api.g_varchar2) then

Line 1249: If (p_rec.first_name = hr_api.g_varchar2) then

1245: If (p_rec.expense_check_send_to_address = hr_api.g_varchar2) then
1246: p_rec.expense_check_send_to_address :=
1247: per_per_shd.g_old_rec.expense_check_send_to_address;
1248: End If;
1249: If (p_rec.first_name = hr_api.g_varchar2) then
1250: p_rec.first_name :=
1251: per_per_shd.g_old_rec.first_name;
1252: End If;
1253: If (p_rec.full_name = hr_api.g_varchar2) then

Line 1253: If (p_rec.full_name = hr_api.g_varchar2) then

1249: If (p_rec.first_name = hr_api.g_varchar2) then
1250: p_rec.first_name :=
1251: per_per_shd.g_old_rec.first_name;
1252: End If;
1253: If (p_rec.full_name = hr_api.g_varchar2) then
1254: p_rec.full_name :=
1255: per_per_shd.g_old_rec.full_name;
1256: End If;
1257: If (p_rec.known_as = hr_api.g_varchar2) then

Line 1257: If (p_rec.known_as = hr_api.g_varchar2) then

1253: If (p_rec.full_name = hr_api.g_varchar2) then
1254: p_rec.full_name :=
1255: per_per_shd.g_old_rec.full_name;
1256: End If;
1257: If (p_rec.known_as = hr_api.g_varchar2) then
1258: p_rec.known_as :=
1259: per_per_shd.g_old_rec.known_as;
1260: End If;
1261: If (p_rec.marital_status = hr_api.g_varchar2) then

Line 1261: If (p_rec.marital_status = hr_api.g_varchar2) then

1257: If (p_rec.known_as = hr_api.g_varchar2) then
1258: p_rec.known_as :=
1259: per_per_shd.g_old_rec.known_as;
1260: End If;
1261: If (p_rec.marital_status = hr_api.g_varchar2) then
1262: p_rec.marital_status :=
1263: per_per_shd.g_old_rec.marital_status;
1264: End If;
1265: If (p_rec.middle_names = hr_api.g_varchar2) then

Line 1265: If (p_rec.middle_names = hr_api.g_varchar2) then

1261: If (p_rec.marital_status = hr_api.g_varchar2) then
1262: p_rec.marital_status :=
1263: per_per_shd.g_old_rec.marital_status;
1264: End If;
1265: If (p_rec.middle_names = hr_api.g_varchar2) then
1266: p_rec.middle_names :=
1267: per_per_shd.g_old_rec.middle_names;
1268: End If;
1269: If (p_rec.nationality = hr_api.g_varchar2) then

Line 1269: If (p_rec.nationality = hr_api.g_varchar2) then

1265: If (p_rec.middle_names = hr_api.g_varchar2) then
1266: p_rec.middle_names :=
1267: per_per_shd.g_old_rec.middle_names;
1268: End If;
1269: If (p_rec.nationality = hr_api.g_varchar2) then
1270: p_rec.nationality :=
1271: per_per_shd.g_old_rec.nationality;
1272: End If;
1273: If (p_rec.national_identifier = hr_api.g_varchar2) then

Line 1273: If (p_rec.national_identifier = hr_api.g_varchar2) then

1269: If (p_rec.nationality = hr_api.g_varchar2) then
1270: p_rec.nationality :=
1271: per_per_shd.g_old_rec.nationality;
1272: End If;
1273: If (p_rec.national_identifier = hr_api.g_varchar2) then
1274: p_rec.national_identifier :=
1275: per_per_shd.g_old_rec.national_identifier;
1276: End If;
1277: If (p_rec.previous_last_name = hr_api.g_varchar2) then

Line 1277: If (p_rec.previous_last_name = hr_api.g_varchar2) then

1273: If (p_rec.national_identifier = hr_api.g_varchar2) then
1274: p_rec.national_identifier :=
1275: per_per_shd.g_old_rec.national_identifier;
1276: End If;
1277: If (p_rec.previous_last_name = hr_api.g_varchar2) then
1278: p_rec.previous_last_name :=
1279: per_per_shd.g_old_rec.previous_last_name;
1280: End If;
1281: If (p_rec.registered_disabled_flag = hr_api.g_varchar2) then

Line 1281: If (p_rec.registered_disabled_flag = hr_api.g_varchar2) then

1277: If (p_rec.previous_last_name = hr_api.g_varchar2) then
1278: p_rec.previous_last_name :=
1279: per_per_shd.g_old_rec.previous_last_name;
1280: End If;
1281: If (p_rec.registered_disabled_flag = hr_api.g_varchar2) then
1282: p_rec.registered_disabled_flag :=
1283: per_per_shd.g_old_rec.registered_disabled_flag;
1284: End If;
1285: If (p_rec.sex = hr_api.g_varchar2) then

Line 1285: If (p_rec.sex = hr_api.g_varchar2) then

1281: If (p_rec.registered_disabled_flag = hr_api.g_varchar2) then
1282: p_rec.registered_disabled_flag :=
1283: per_per_shd.g_old_rec.registered_disabled_flag;
1284: End If;
1285: If (p_rec.sex = hr_api.g_varchar2) then
1286: p_rec.sex :=
1287: per_per_shd.g_old_rec.sex;
1288: End If;
1289: If (p_rec.title = hr_api.g_varchar2) then

Line 1289: If (p_rec.title = hr_api.g_varchar2) then

1285: If (p_rec.sex = hr_api.g_varchar2) then
1286: p_rec.sex :=
1287: per_per_shd.g_old_rec.sex;
1288: End If;
1289: If (p_rec.title = hr_api.g_varchar2) then
1290: p_rec.title :=
1291: per_per_shd.g_old_rec.title;
1292: End If;
1293: If (p_rec.vendor_id = hr_api.g_number) then

Line 1293: If (p_rec.vendor_id = hr_api.g_number) then

1289: If (p_rec.title = hr_api.g_varchar2) then
1290: p_rec.title :=
1291: per_per_shd.g_old_rec.title;
1292: End If;
1293: If (p_rec.vendor_id = hr_api.g_number) then
1294: p_rec.vendor_id :=
1295: per_per_shd.g_old_rec.vendor_id;
1296: End If;
1297: If (p_rec.work_telephone = hr_api.g_varchar2) then

Line 1297: If (p_rec.work_telephone = hr_api.g_varchar2) then

1293: If (p_rec.vendor_id = hr_api.g_number) then
1294: p_rec.vendor_id :=
1295: per_per_shd.g_old_rec.vendor_id;
1296: End If;
1297: If (p_rec.work_telephone = hr_api.g_varchar2) then
1298: p_rec.work_telephone :=
1299: per_per_shd.g_old_rec.work_telephone;
1300: End If;
1301: If (p_rec.request_id = hr_api.g_number) then

Line 1301: If (p_rec.request_id = hr_api.g_number) then

1297: If (p_rec.work_telephone = hr_api.g_varchar2) then
1298: p_rec.work_telephone :=
1299: per_per_shd.g_old_rec.work_telephone;
1300: End If;
1301: If (p_rec.request_id = hr_api.g_number) then
1302: p_rec.request_id :=
1303: per_per_shd.g_old_rec.request_id;
1304: End If;
1305: If (p_rec.program_application_id = hr_api.g_number) then

Line 1305: If (p_rec.program_application_id = hr_api.g_number) then

1301: If (p_rec.request_id = hr_api.g_number) then
1302: p_rec.request_id :=
1303: per_per_shd.g_old_rec.request_id;
1304: End If;
1305: If (p_rec.program_application_id = hr_api.g_number) then
1306: p_rec.program_application_id :=
1307: per_per_shd.g_old_rec.program_application_id;
1308: End If;
1309: If (p_rec.program_id = hr_api.g_number) then

Line 1309: If (p_rec.program_id = hr_api.g_number) then

1305: If (p_rec.program_application_id = hr_api.g_number) then
1306: p_rec.program_application_id :=
1307: per_per_shd.g_old_rec.program_application_id;
1308: End If;
1309: If (p_rec.program_id = hr_api.g_number) then
1310: p_rec.program_id :=
1311: per_per_shd.g_old_rec.program_id;
1312: End If;
1313: If (p_rec.program_update_date = hr_api.g_date) then

Line 1313: If (p_rec.program_update_date = hr_api.g_date) then

1309: If (p_rec.program_id = hr_api.g_number) then
1310: p_rec.program_id :=
1311: per_per_shd.g_old_rec.program_id;
1312: End If;
1313: If (p_rec.program_update_date = hr_api.g_date) then
1314: p_rec.program_update_date :=
1315: per_per_shd.g_old_rec.program_update_date;
1316: End If;
1317: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 1317: If (p_rec.attribute_category = hr_api.g_varchar2) then

1313: If (p_rec.program_update_date = hr_api.g_date) then
1314: p_rec.program_update_date :=
1315: per_per_shd.g_old_rec.program_update_date;
1316: End If;
1317: If (p_rec.attribute_category = hr_api.g_varchar2) then
1318: p_rec.attribute_category :=
1319: per_per_shd.g_old_rec.attribute_category;
1320: End If;
1321: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 1321: If (p_rec.attribute1 = hr_api.g_varchar2) then

1317: If (p_rec.attribute_category = hr_api.g_varchar2) then
1318: p_rec.attribute_category :=
1319: per_per_shd.g_old_rec.attribute_category;
1320: End If;
1321: If (p_rec.attribute1 = hr_api.g_varchar2) then
1322: p_rec.attribute1 :=
1323: per_per_shd.g_old_rec.attribute1;
1324: End If;
1325: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 1325: If (p_rec.attribute2 = hr_api.g_varchar2) then

1321: If (p_rec.attribute1 = hr_api.g_varchar2) then
1322: p_rec.attribute1 :=
1323: per_per_shd.g_old_rec.attribute1;
1324: End If;
1325: If (p_rec.attribute2 = hr_api.g_varchar2) then
1326: p_rec.attribute2 :=
1327: per_per_shd.g_old_rec.attribute2;
1328: End If;
1329: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 1329: If (p_rec.attribute3 = hr_api.g_varchar2) then

1325: If (p_rec.attribute2 = hr_api.g_varchar2) then
1326: p_rec.attribute2 :=
1327: per_per_shd.g_old_rec.attribute2;
1328: End If;
1329: If (p_rec.attribute3 = hr_api.g_varchar2) then
1330: p_rec.attribute3 :=
1331: per_per_shd.g_old_rec.attribute3;
1332: End If;
1333: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 1333: If (p_rec.attribute4 = hr_api.g_varchar2) then

1329: If (p_rec.attribute3 = hr_api.g_varchar2) then
1330: p_rec.attribute3 :=
1331: per_per_shd.g_old_rec.attribute3;
1332: End If;
1333: If (p_rec.attribute4 = hr_api.g_varchar2) then
1334: p_rec.attribute4 :=
1335: per_per_shd.g_old_rec.attribute4;
1336: End If;
1337: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 1337: If (p_rec.attribute5 = hr_api.g_varchar2) then

1333: If (p_rec.attribute4 = hr_api.g_varchar2) then
1334: p_rec.attribute4 :=
1335: per_per_shd.g_old_rec.attribute4;
1336: End If;
1337: If (p_rec.attribute5 = hr_api.g_varchar2) then
1338: p_rec.attribute5 :=
1339: per_per_shd.g_old_rec.attribute5;
1340: End If;
1341: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 1341: If (p_rec.attribute6 = hr_api.g_varchar2) then

1337: If (p_rec.attribute5 = hr_api.g_varchar2) then
1338: p_rec.attribute5 :=
1339: per_per_shd.g_old_rec.attribute5;
1340: End If;
1341: If (p_rec.attribute6 = hr_api.g_varchar2) then
1342: p_rec.attribute6 :=
1343: per_per_shd.g_old_rec.attribute6;
1344: End If;
1345: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 1345: If (p_rec.attribute7 = hr_api.g_varchar2) then

1341: If (p_rec.attribute6 = hr_api.g_varchar2) then
1342: p_rec.attribute6 :=
1343: per_per_shd.g_old_rec.attribute6;
1344: End If;
1345: If (p_rec.attribute7 = hr_api.g_varchar2) then
1346: p_rec.attribute7 :=
1347: per_per_shd.g_old_rec.attribute7;
1348: End If;
1349: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 1349: If (p_rec.attribute8 = hr_api.g_varchar2) then

1345: If (p_rec.attribute7 = hr_api.g_varchar2) then
1346: p_rec.attribute7 :=
1347: per_per_shd.g_old_rec.attribute7;
1348: End If;
1349: If (p_rec.attribute8 = hr_api.g_varchar2) then
1350: p_rec.attribute8 :=
1351: per_per_shd.g_old_rec.attribute8;
1352: End If;
1353: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 1353: If (p_rec.attribute9 = hr_api.g_varchar2) then

1349: If (p_rec.attribute8 = hr_api.g_varchar2) then
1350: p_rec.attribute8 :=
1351: per_per_shd.g_old_rec.attribute8;
1352: End If;
1353: If (p_rec.attribute9 = hr_api.g_varchar2) then
1354: p_rec.attribute9 :=
1355: per_per_shd.g_old_rec.attribute9;
1356: End If;
1357: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 1357: If (p_rec.attribute10 = hr_api.g_varchar2) then

1353: If (p_rec.attribute9 = hr_api.g_varchar2) then
1354: p_rec.attribute9 :=
1355: per_per_shd.g_old_rec.attribute9;
1356: End If;
1357: If (p_rec.attribute10 = hr_api.g_varchar2) then
1358: p_rec.attribute10 :=
1359: per_per_shd.g_old_rec.attribute10;
1360: End If;
1361: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 1361: If (p_rec.attribute11 = hr_api.g_varchar2) then

1357: If (p_rec.attribute10 = hr_api.g_varchar2) then
1358: p_rec.attribute10 :=
1359: per_per_shd.g_old_rec.attribute10;
1360: End If;
1361: If (p_rec.attribute11 = hr_api.g_varchar2) then
1362: p_rec.attribute11 :=
1363: per_per_shd.g_old_rec.attribute11;
1364: End If;
1365: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 1365: If (p_rec.attribute12 = hr_api.g_varchar2) then

1361: If (p_rec.attribute11 = hr_api.g_varchar2) then
1362: p_rec.attribute11 :=
1363: per_per_shd.g_old_rec.attribute11;
1364: End If;
1365: If (p_rec.attribute12 = hr_api.g_varchar2) then
1366: p_rec.attribute12 :=
1367: per_per_shd.g_old_rec.attribute12;
1368: End If;
1369: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 1369: If (p_rec.attribute13 = hr_api.g_varchar2) then

1365: If (p_rec.attribute12 = hr_api.g_varchar2) then
1366: p_rec.attribute12 :=
1367: per_per_shd.g_old_rec.attribute12;
1368: End If;
1369: If (p_rec.attribute13 = hr_api.g_varchar2) then
1370: p_rec.attribute13 :=
1371: per_per_shd.g_old_rec.attribute13;
1372: End If;
1373: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 1373: If (p_rec.attribute14 = hr_api.g_varchar2) then

1369: If (p_rec.attribute13 = hr_api.g_varchar2) then
1370: p_rec.attribute13 :=
1371: per_per_shd.g_old_rec.attribute13;
1372: End If;
1373: If (p_rec.attribute14 = hr_api.g_varchar2) then
1374: p_rec.attribute14 :=
1375: per_per_shd.g_old_rec.attribute14;
1376: End If;
1377: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 1377: If (p_rec.attribute15 = hr_api.g_varchar2) then

1373: If (p_rec.attribute14 = hr_api.g_varchar2) then
1374: p_rec.attribute14 :=
1375: per_per_shd.g_old_rec.attribute14;
1376: End If;
1377: If (p_rec.attribute15 = hr_api.g_varchar2) then
1378: p_rec.attribute15 :=
1379: per_per_shd.g_old_rec.attribute15;
1380: End If;
1381: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 1381: If (p_rec.attribute16 = hr_api.g_varchar2) then

1377: If (p_rec.attribute15 = hr_api.g_varchar2) then
1378: p_rec.attribute15 :=
1379: per_per_shd.g_old_rec.attribute15;
1380: End If;
1381: If (p_rec.attribute16 = hr_api.g_varchar2) then
1382: p_rec.attribute16 :=
1383: per_per_shd.g_old_rec.attribute16;
1384: End If;
1385: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 1385: If (p_rec.attribute17 = hr_api.g_varchar2) then

1381: If (p_rec.attribute16 = hr_api.g_varchar2) then
1382: p_rec.attribute16 :=
1383: per_per_shd.g_old_rec.attribute16;
1384: End If;
1385: If (p_rec.attribute17 = hr_api.g_varchar2) then
1386: p_rec.attribute17 :=
1387: per_per_shd.g_old_rec.attribute17;
1388: End If;
1389: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 1389: If (p_rec.attribute18 = hr_api.g_varchar2) then

1385: If (p_rec.attribute17 = hr_api.g_varchar2) then
1386: p_rec.attribute17 :=
1387: per_per_shd.g_old_rec.attribute17;
1388: End If;
1389: If (p_rec.attribute18 = hr_api.g_varchar2) then
1390: p_rec.attribute18 :=
1391: per_per_shd.g_old_rec.attribute18;
1392: End If;
1393: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 1393: If (p_rec.attribute19 = hr_api.g_varchar2) then

1389: If (p_rec.attribute18 = hr_api.g_varchar2) then
1390: p_rec.attribute18 :=
1391: per_per_shd.g_old_rec.attribute18;
1392: End If;
1393: If (p_rec.attribute19 = hr_api.g_varchar2) then
1394: p_rec.attribute19 :=
1395: per_per_shd.g_old_rec.attribute19;
1396: End If;
1397: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 1397: If (p_rec.attribute20 = hr_api.g_varchar2) then

1393: If (p_rec.attribute19 = hr_api.g_varchar2) then
1394: p_rec.attribute19 :=
1395: per_per_shd.g_old_rec.attribute19;
1396: End If;
1397: If (p_rec.attribute20 = hr_api.g_varchar2) then
1398: p_rec.attribute20 :=
1399: per_per_shd.g_old_rec.attribute20;
1400: End If;
1401: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 1401: If (p_rec.attribute21 = hr_api.g_varchar2) then

1397: If (p_rec.attribute20 = hr_api.g_varchar2) then
1398: p_rec.attribute20 :=
1399: per_per_shd.g_old_rec.attribute20;
1400: End If;
1401: If (p_rec.attribute21 = hr_api.g_varchar2) then
1402: p_rec.attribute21 :=
1403: per_per_shd.g_old_rec.attribute21;
1404: End If;
1405: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 1405: If (p_rec.attribute22 = hr_api.g_varchar2) then

1401: If (p_rec.attribute21 = hr_api.g_varchar2) then
1402: p_rec.attribute21 :=
1403: per_per_shd.g_old_rec.attribute21;
1404: End If;
1405: If (p_rec.attribute22 = hr_api.g_varchar2) then
1406: p_rec.attribute22 :=
1407: per_per_shd.g_old_rec.attribute22;
1408: End If;
1409: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 1409: If (p_rec.attribute23 = hr_api.g_varchar2) then

1405: If (p_rec.attribute22 = hr_api.g_varchar2) then
1406: p_rec.attribute22 :=
1407: per_per_shd.g_old_rec.attribute22;
1408: End If;
1409: If (p_rec.attribute23 = hr_api.g_varchar2) then
1410: p_rec.attribute23 :=
1411: per_per_shd.g_old_rec.attribute23;
1412: End If;
1413: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 1413: If (p_rec.attribute24 = hr_api.g_varchar2) then

1409: If (p_rec.attribute23 = hr_api.g_varchar2) then
1410: p_rec.attribute23 :=
1411: per_per_shd.g_old_rec.attribute23;
1412: End If;
1413: If (p_rec.attribute24 = hr_api.g_varchar2) then
1414: p_rec.attribute24 :=
1415: per_per_shd.g_old_rec.attribute24;
1416: End If;
1417: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 1417: If (p_rec.attribute25 = hr_api.g_varchar2) then

1413: If (p_rec.attribute24 = hr_api.g_varchar2) then
1414: p_rec.attribute24 :=
1415: per_per_shd.g_old_rec.attribute24;
1416: End If;
1417: If (p_rec.attribute25 = hr_api.g_varchar2) then
1418: p_rec.attribute25 :=
1419: per_per_shd.g_old_rec.attribute25;
1420: End If;
1421: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 1421: If (p_rec.attribute26 = hr_api.g_varchar2) then

1417: If (p_rec.attribute25 = hr_api.g_varchar2) then
1418: p_rec.attribute25 :=
1419: per_per_shd.g_old_rec.attribute25;
1420: End If;
1421: If (p_rec.attribute26 = hr_api.g_varchar2) then
1422: p_rec.attribute26 :=
1423: per_per_shd.g_old_rec.attribute26;
1424: End If;
1425: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 1425: If (p_rec.attribute27 = hr_api.g_varchar2) then

1421: If (p_rec.attribute26 = hr_api.g_varchar2) then
1422: p_rec.attribute26 :=
1423: per_per_shd.g_old_rec.attribute26;
1424: End If;
1425: If (p_rec.attribute27 = hr_api.g_varchar2) then
1426: p_rec.attribute27 :=
1427: per_per_shd.g_old_rec.attribute27;
1428: End If;
1429: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 1429: If (p_rec.attribute28 = hr_api.g_varchar2) then

1425: If (p_rec.attribute27 = hr_api.g_varchar2) then
1426: p_rec.attribute27 :=
1427: per_per_shd.g_old_rec.attribute27;
1428: End If;
1429: If (p_rec.attribute28 = hr_api.g_varchar2) then
1430: p_rec.attribute28 :=
1431: per_per_shd.g_old_rec.attribute28;
1432: End If;
1433: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 1433: If (p_rec.attribute29 = hr_api.g_varchar2) then

1429: If (p_rec.attribute28 = hr_api.g_varchar2) then
1430: p_rec.attribute28 :=
1431: per_per_shd.g_old_rec.attribute28;
1432: End If;
1433: If (p_rec.attribute29 = hr_api.g_varchar2) then
1434: p_rec.attribute29 :=
1435: per_per_shd.g_old_rec.attribute29;
1436: End If;
1437: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 1437: If (p_rec.attribute30 = hr_api.g_varchar2) then

1433: If (p_rec.attribute29 = hr_api.g_varchar2) then
1434: p_rec.attribute29 :=
1435: per_per_shd.g_old_rec.attribute29;
1436: End If;
1437: If (p_rec.attribute30 = hr_api.g_varchar2) then
1438: p_rec.attribute30 :=
1439: per_per_shd.g_old_rec.attribute30;
1440: End If;
1441: If (p_rec.per_information_category = hr_api.g_varchar2) then

Line 1441: If (p_rec.per_information_category = hr_api.g_varchar2) then

1437: If (p_rec.attribute30 = hr_api.g_varchar2) then
1438: p_rec.attribute30 :=
1439: per_per_shd.g_old_rec.attribute30;
1440: End If;
1441: If (p_rec.per_information_category = hr_api.g_varchar2) then
1442: p_rec.per_information_category :=
1443: per_per_shd.g_old_rec.per_information_category;
1444: End If;
1445: If (p_rec.per_information1 = hr_api.g_varchar2) then

Line 1445: If (p_rec.per_information1 = hr_api.g_varchar2) then

1441: If (p_rec.per_information_category = hr_api.g_varchar2) then
1442: p_rec.per_information_category :=
1443: per_per_shd.g_old_rec.per_information_category;
1444: End If;
1445: If (p_rec.per_information1 = hr_api.g_varchar2) then
1446: p_rec.per_information1 :=
1447: per_per_shd.g_old_rec.per_information1;
1448: End If;
1449: If (p_rec.per_information2 = hr_api.g_varchar2) then

Line 1449: If (p_rec.per_information2 = hr_api.g_varchar2) then

1445: If (p_rec.per_information1 = hr_api.g_varchar2) then
1446: p_rec.per_information1 :=
1447: per_per_shd.g_old_rec.per_information1;
1448: End If;
1449: If (p_rec.per_information2 = hr_api.g_varchar2) then
1450: p_rec.per_information2 :=
1451: per_per_shd.g_old_rec.per_information2;
1452: End If;
1453: If (p_rec.per_information3 = hr_api.g_varchar2) then

Line 1453: If (p_rec.per_information3 = hr_api.g_varchar2) then

1449: If (p_rec.per_information2 = hr_api.g_varchar2) then
1450: p_rec.per_information2 :=
1451: per_per_shd.g_old_rec.per_information2;
1452: End If;
1453: If (p_rec.per_information3 = hr_api.g_varchar2) then
1454: p_rec.per_information3 :=
1455: per_per_shd.g_old_rec.per_information3;
1456: End If;
1457: If (p_rec.per_information4 = hr_api.g_varchar2) then

Line 1457: If (p_rec.per_information4 = hr_api.g_varchar2) then

1453: If (p_rec.per_information3 = hr_api.g_varchar2) then
1454: p_rec.per_information3 :=
1455: per_per_shd.g_old_rec.per_information3;
1456: End If;
1457: If (p_rec.per_information4 = hr_api.g_varchar2) then
1458: p_rec.per_information4 :=
1459: per_per_shd.g_old_rec.per_information4;
1460: End If;
1461: If (p_rec.per_information5 = hr_api.g_varchar2) then

Line 1461: If (p_rec.per_information5 = hr_api.g_varchar2) then

1457: If (p_rec.per_information4 = hr_api.g_varchar2) then
1458: p_rec.per_information4 :=
1459: per_per_shd.g_old_rec.per_information4;
1460: End If;
1461: If (p_rec.per_information5 = hr_api.g_varchar2) then
1462: p_rec.per_information5 :=
1463: per_per_shd.g_old_rec.per_information5;
1464: End If;
1465: If (p_rec.per_information6 = hr_api.g_varchar2) then

Line 1465: If (p_rec.per_information6 = hr_api.g_varchar2) then

1461: If (p_rec.per_information5 = hr_api.g_varchar2) then
1462: p_rec.per_information5 :=
1463: per_per_shd.g_old_rec.per_information5;
1464: End If;
1465: If (p_rec.per_information6 = hr_api.g_varchar2) then
1466: p_rec.per_information6 :=
1467: per_per_shd.g_old_rec.per_information6;
1468: End If;
1469: If (p_rec.per_information7 = hr_api.g_varchar2) then

Line 1469: If (p_rec.per_information7 = hr_api.g_varchar2) then

1465: If (p_rec.per_information6 = hr_api.g_varchar2) then
1466: p_rec.per_information6 :=
1467: per_per_shd.g_old_rec.per_information6;
1468: End If;
1469: If (p_rec.per_information7 = hr_api.g_varchar2) then
1470: p_rec.per_information7 :=
1471: per_per_shd.g_old_rec.per_information7;
1472: End If;
1473: If (p_rec.per_information8 = hr_api.g_varchar2) then

Line 1473: If (p_rec.per_information8 = hr_api.g_varchar2) then

1469: If (p_rec.per_information7 = hr_api.g_varchar2) then
1470: p_rec.per_information7 :=
1471: per_per_shd.g_old_rec.per_information7;
1472: End If;
1473: If (p_rec.per_information8 = hr_api.g_varchar2) then
1474: p_rec.per_information8 :=
1475: per_per_shd.g_old_rec.per_information8;
1476: End If;
1477: If (p_rec.per_information9 = hr_api.g_varchar2) then

Line 1477: If (p_rec.per_information9 = hr_api.g_varchar2) then

1473: If (p_rec.per_information8 = hr_api.g_varchar2) then
1474: p_rec.per_information8 :=
1475: per_per_shd.g_old_rec.per_information8;
1476: End If;
1477: If (p_rec.per_information9 = hr_api.g_varchar2) then
1478: p_rec.per_information9 :=
1479: per_per_shd.g_old_rec.per_information9;
1480: End If;
1481: If (p_rec.per_information10 = hr_api.g_varchar2) then

Line 1481: If (p_rec.per_information10 = hr_api.g_varchar2) then

1477: If (p_rec.per_information9 = hr_api.g_varchar2) then
1478: p_rec.per_information9 :=
1479: per_per_shd.g_old_rec.per_information9;
1480: End If;
1481: If (p_rec.per_information10 = hr_api.g_varchar2) then
1482: p_rec.per_information10 :=
1483: per_per_shd.g_old_rec.per_information10;
1484: End If;
1485: If (p_rec.per_information11 = hr_api.g_varchar2) then

Line 1485: If (p_rec.per_information11 = hr_api.g_varchar2) then

1481: If (p_rec.per_information10 = hr_api.g_varchar2) then
1482: p_rec.per_information10 :=
1483: per_per_shd.g_old_rec.per_information10;
1484: End If;
1485: If (p_rec.per_information11 = hr_api.g_varchar2) then
1486: p_rec.per_information11 :=
1487: per_per_shd.g_old_rec.per_information11;
1488: End If;
1489: If (p_rec.per_information12 = hr_api.g_varchar2) then

Line 1489: If (p_rec.per_information12 = hr_api.g_varchar2) then

1485: If (p_rec.per_information11 = hr_api.g_varchar2) then
1486: p_rec.per_information11 :=
1487: per_per_shd.g_old_rec.per_information11;
1488: End If;
1489: If (p_rec.per_information12 = hr_api.g_varchar2) then
1490: p_rec.per_information12 :=
1491: per_per_shd.g_old_rec.per_information12;
1492: End If;
1493: If (p_rec.per_information13 = hr_api.g_varchar2) then

Line 1493: If (p_rec.per_information13 = hr_api.g_varchar2) then

1489: If (p_rec.per_information12 = hr_api.g_varchar2) then
1490: p_rec.per_information12 :=
1491: per_per_shd.g_old_rec.per_information12;
1492: End If;
1493: If (p_rec.per_information13 = hr_api.g_varchar2) then
1494: p_rec.per_information13 :=
1495: per_per_shd.g_old_rec.per_information13;
1496: End If;
1497: If (p_rec.per_information14 = hr_api.g_varchar2) then

Line 1497: If (p_rec.per_information14 = hr_api.g_varchar2) then

1493: If (p_rec.per_information13 = hr_api.g_varchar2) then
1494: p_rec.per_information13 :=
1495: per_per_shd.g_old_rec.per_information13;
1496: End If;
1497: If (p_rec.per_information14 = hr_api.g_varchar2) then
1498: p_rec.per_information14 :=
1499: per_per_shd.g_old_rec.per_information14;
1500: End If;
1501: If (p_rec.per_information15 = hr_api.g_varchar2) then

Line 1501: If (p_rec.per_information15 = hr_api.g_varchar2) then

1497: If (p_rec.per_information14 = hr_api.g_varchar2) then
1498: p_rec.per_information14 :=
1499: per_per_shd.g_old_rec.per_information14;
1500: End If;
1501: If (p_rec.per_information15 = hr_api.g_varchar2) then
1502: p_rec.per_information15 :=
1503: per_per_shd.g_old_rec.per_information15;
1504: End If;
1505: If (p_rec.per_information16 = hr_api.g_varchar2) then

Line 1505: If (p_rec.per_information16 = hr_api.g_varchar2) then

1501: If (p_rec.per_information15 = hr_api.g_varchar2) then
1502: p_rec.per_information15 :=
1503: per_per_shd.g_old_rec.per_information15;
1504: End If;
1505: If (p_rec.per_information16 = hr_api.g_varchar2) then
1506: p_rec.per_information16 :=
1507: per_per_shd.g_old_rec.per_information16;
1508: End If;
1509: If (p_rec.per_information17 = hr_api.g_varchar2) then

Line 1509: If (p_rec.per_information17 = hr_api.g_varchar2) then

1505: If (p_rec.per_information16 = hr_api.g_varchar2) then
1506: p_rec.per_information16 :=
1507: per_per_shd.g_old_rec.per_information16;
1508: End If;
1509: If (p_rec.per_information17 = hr_api.g_varchar2) then
1510: p_rec.per_information17 :=
1511: per_per_shd.g_old_rec.per_information17;
1512: End If;
1513: If (p_rec.per_information18 = hr_api.g_varchar2) then

Line 1513: If (p_rec.per_information18 = hr_api.g_varchar2) then

1509: If (p_rec.per_information17 = hr_api.g_varchar2) then
1510: p_rec.per_information17 :=
1511: per_per_shd.g_old_rec.per_information17;
1512: End If;
1513: If (p_rec.per_information18 = hr_api.g_varchar2) then
1514: p_rec.per_information18 :=
1515: per_per_shd.g_old_rec.per_information18;
1516: End If;
1517: If (p_rec.per_information19 = hr_api.g_varchar2) then

Line 1517: If (p_rec.per_information19 = hr_api.g_varchar2) then

1513: If (p_rec.per_information18 = hr_api.g_varchar2) then
1514: p_rec.per_information18 :=
1515: per_per_shd.g_old_rec.per_information18;
1516: End If;
1517: If (p_rec.per_information19 = hr_api.g_varchar2) then
1518: p_rec.per_information19 :=
1519: per_per_shd.g_old_rec.per_information19;
1520: End If;
1521: If (p_rec.per_information20 = hr_api.g_varchar2) then

Line 1521: If (p_rec.per_information20 = hr_api.g_varchar2) then

1517: If (p_rec.per_information19 = hr_api.g_varchar2) then
1518: p_rec.per_information19 :=
1519: per_per_shd.g_old_rec.per_information19;
1520: End If;
1521: If (p_rec.per_information20 = hr_api.g_varchar2) then
1522: p_rec.per_information20 :=
1523: per_per_shd.g_old_rec.per_information20;
1524: End If;
1525: If (p_rec.suffix = hr_api.g_varchar2) then

Line 1525: If (p_rec.suffix = hr_api.g_varchar2) then

1521: If (p_rec.per_information20 = hr_api.g_varchar2) then
1522: p_rec.per_information20 :=
1523: per_per_shd.g_old_rec.per_information20;
1524: End If;
1525: If (p_rec.suffix = hr_api.g_varchar2) then
1526: p_rec.suffix := per_per_shd.g_old_rec.suffix;
1527: End If;
1528: If (p_rec.DATE_OF_DEATH = hr_api.g_date) then
1529: p_rec.DATE_OF_DEATH := per_per_shd.g_old_rec.DATE_OF_DEATH ;

Line 1528: If (p_rec.DATE_OF_DEATH = hr_api.g_date) then

1524: End If;
1525: If (p_rec.suffix = hr_api.g_varchar2) then
1526: p_rec.suffix := per_per_shd.g_old_rec.suffix;
1527: End If;
1528: If (p_rec.DATE_OF_DEATH = hr_api.g_date) then
1529: p_rec.DATE_OF_DEATH := per_per_shd.g_old_rec.DATE_OF_DEATH ;
1530: End If;
1531: If (p_rec.BACKGROUND_CHECK_STATUS = hr_api.g_varchar2) then
1532: p_rec.BACKGROUND_CHECK_STATUS := per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS ;

Line 1531: If (p_rec.BACKGROUND_CHECK_STATUS = hr_api.g_varchar2) then

1527: End If;
1528: If (p_rec.DATE_OF_DEATH = hr_api.g_date) then
1529: p_rec.DATE_OF_DEATH := per_per_shd.g_old_rec.DATE_OF_DEATH ;
1530: End If;
1531: If (p_rec.BACKGROUND_CHECK_STATUS = hr_api.g_varchar2) then
1532: p_rec.BACKGROUND_CHECK_STATUS := per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS ;
1533: End If;
1534: If (p_rec.BACKGROUND_DATE_CHECK = hr_api.g_date) then
1535: p_rec.BACKGROUND_DATE_CHECK := per_per_shd.g_old_rec.BACKGROUND_DATE_CHECK ;

Line 1534: If (p_rec.BACKGROUND_DATE_CHECK = hr_api.g_date) then

1530: End If;
1531: If (p_rec.BACKGROUND_CHECK_STATUS = hr_api.g_varchar2) then
1532: p_rec.BACKGROUND_CHECK_STATUS := per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS ;
1533: End If;
1534: If (p_rec.BACKGROUND_DATE_CHECK = hr_api.g_date) then
1535: p_rec.BACKGROUND_DATE_CHECK := per_per_shd.g_old_rec.BACKGROUND_DATE_CHECK ;
1536: End If;
1537: If (p_rec.BLOOD_TYPE = hr_api.g_varchar2) then
1538: p_rec.BLOOD_TYPE := per_per_shd.g_old_rec.BLOOD_TYPE ;

Line 1537: If (p_rec.BLOOD_TYPE = hr_api.g_varchar2) then

1533: End If;
1534: If (p_rec.BACKGROUND_DATE_CHECK = hr_api.g_date) then
1535: p_rec.BACKGROUND_DATE_CHECK := per_per_shd.g_old_rec.BACKGROUND_DATE_CHECK ;
1536: End If;
1537: If (p_rec.BLOOD_TYPE = hr_api.g_varchar2) then
1538: p_rec.BLOOD_TYPE := per_per_shd.g_old_rec.BLOOD_TYPE ;
1539: End If;
1540: If (p_rec.CORRESPONDENCE_LANGUAGE = hr_api.g_varchar2) then
1541: p_rec.CORRESPONDENCE_LANGUAGE := per_per_shd.g_old_rec.CORRESPONDENCE_LANGUAGE ;

Line 1540: If (p_rec.CORRESPONDENCE_LANGUAGE = hr_api.g_varchar2) then

1536: End If;
1537: If (p_rec.BLOOD_TYPE = hr_api.g_varchar2) then
1538: p_rec.BLOOD_TYPE := per_per_shd.g_old_rec.BLOOD_TYPE ;
1539: End If;
1540: If (p_rec.CORRESPONDENCE_LANGUAGE = hr_api.g_varchar2) then
1541: p_rec.CORRESPONDENCE_LANGUAGE := per_per_shd.g_old_rec.CORRESPONDENCE_LANGUAGE ;
1542: End If;
1543: If (p_rec.FAST_PATH_EMPLOYEE = hr_api.g_varchar2) then
1544: p_rec.FAST_PATH_EMPLOYEE := per_per_shd.g_old_rec.FAST_PATH_EMPLOYEE ;

Line 1543: If (p_rec.FAST_PATH_EMPLOYEE = hr_api.g_varchar2) then

1539: End If;
1540: If (p_rec.CORRESPONDENCE_LANGUAGE = hr_api.g_varchar2) then
1541: p_rec.CORRESPONDENCE_LANGUAGE := per_per_shd.g_old_rec.CORRESPONDENCE_LANGUAGE ;
1542: End If;
1543: If (p_rec.FAST_PATH_EMPLOYEE = hr_api.g_varchar2) then
1544: p_rec.FAST_PATH_EMPLOYEE := per_per_shd.g_old_rec.FAST_PATH_EMPLOYEE ;
1545: End If;
1546: If (p_rec.FTE_CAPACITY = hr_api.g_number) then
1547: p_rec.FTE_CAPACITY := per_per_shd.g_old_rec.FTE_CAPACITY ;

Line 1546: If (p_rec.FTE_CAPACITY = hr_api.g_number) then

1542: End If;
1543: If (p_rec.FAST_PATH_EMPLOYEE = hr_api.g_varchar2) then
1544: p_rec.FAST_PATH_EMPLOYEE := per_per_shd.g_old_rec.FAST_PATH_EMPLOYEE ;
1545: End If;
1546: If (p_rec.FTE_CAPACITY = hr_api.g_number) then
1547: p_rec.FTE_CAPACITY := per_per_shd.g_old_rec.FTE_CAPACITY ;
1548: End If;
1549: If (p_rec.HOLD_APPLICANT_DATE_UNTIL = hr_api.g_date) then
1550: p_rec.HOLD_APPLICANT_DATE_UNTIL := per_per_shd.g_old_rec.HOLD_APPLICANT_DATE_UNTIL;

Line 1549: If (p_rec.HOLD_APPLICANT_DATE_UNTIL = hr_api.g_date) then

1545: End If;
1546: If (p_rec.FTE_CAPACITY = hr_api.g_number) then
1547: p_rec.FTE_CAPACITY := per_per_shd.g_old_rec.FTE_CAPACITY ;
1548: End If;
1549: If (p_rec.HOLD_APPLICANT_DATE_UNTIL = hr_api.g_date) then
1550: p_rec.HOLD_APPLICANT_DATE_UNTIL := per_per_shd.g_old_rec.HOLD_APPLICANT_DATE_UNTIL;
1551: End If;
1552: If (p_rec.HONORS = hr_api.g_varchar2) then
1553: p_rec.HONORS := per_per_shd.g_old_rec.HONORS ;

Line 1552: If (p_rec.HONORS = hr_api.g_varchar2) then

1548: End If;
1549: If (p_rec.HOLD_APPLICANT_DATE_UNTIL = hr_api.g_date) then
1550: p_rec.HOLD_APPLICANT_DATE_UNTIL := per_per_shd.g_old_rec.HOLD_APPLICANT_DATE_UNTIL;
1551: End If;
1552: If (p_rec.HONORS = hr_api.g_varchar2) then
1553: p_rec.HONORS := per_per_shd.g_old_rec.HONORS ;
1554: End If;
1555: If (p_rec.INTERNAL_LOCATION = hr_api.g_varchar2) then
1556: p_rec.INTERNAL_LOCATION := per_per_shd.g_old_rec.INTERNAL_LOCATION ;

Line 1555: If (p_rec.INTERNAL_LOCATION = hr_api.g_varchar2) then

1551: End If;
1552: If (p_rec.HONORS = hr_api.g_varchar2) then
1553: p_rec.HONORS := per_per_shd.g_old_rec.HONORS ;
1554: End If;
1555: If (p_rec.INTERNAL_LOCATION = hr_api.g_varchar2) then
1556: p_rec.INTERNAL_LOCATION := per_per_shd.g_old_rec.INTERNAL_LOCATION ;
1557: End If;
1558: If (p_rec.LAST_MEDICAL_TEST_BY = hr_api.g_varchar2) then
1559: p_rec.LAST_MEDICAL_TEST_BY := per_per_shd.g_old_rec.LAST_MEDICAL_TEST_BY ;

Line 1558: If (p_rec.LAST_MEDICAL_TEST_BY = hr_api.g_varchar2) then

1554: End If;
1555: If (p_rec.INTERNAL_LOCATION = hr_api.g_varchar2) then
1556: p_rec.INTERNAL_LOCATION := per_per_shd.g_old_rec.INTERNAL_LOCATION ;
1557: End If;
1558: If (p_rec.LAST_MEDICAL_TEST_BY = hr_api.g_varchar2) then
1559: p_rec.LAST_MEDICAL_TEST_BY := per_per_shd.g_old_rec.LAST_MEDICAL_TEST_BY ;
1560: End If;
1561: If (p_rec.LAST_MEDICAL_TEST_DATE = hr_api.g_date) then
1562: p_rec.LAST_MEDICAL_TEST_DATE := per_per_shd.g_old_rec.LAST_MEDICAL_TEST_DATE ;

Line 1561: If (p_rec.LAST_MEDICAL_TEST_DATE = hr_api.g_date) then

1557: End If;
1558: If (p_rec.LAST_MEDICAL_TEST_BY = hr_api.g_varchar2) then
1559: p_rec.LAST_MEDICAL_TEST_BY := per_per_shd.g_old_rec.LAST_MEDICAL_TEST_BY ;
1560: End If;
1561: If (p_rec.LAST_MEDICAL_TEST_DATE = hr_api.g_date) then
1562: p_rec.LAST_MEDICAL_TEST_DATE := per_per_shd.g_old_rec.LAST_MEDICAL_TEST_DATE ;
1563: End If;
1564: If (p_rec.MAILSTOP = hr_api.g_varchar2) then
1565: p_rec.MAILSTOP := per_per_shd.g_old_rec.MAILSTOP ;

Line 1564: If (p_rec.MAILSTOP = hr_api.g_varchar2) then

1560: End If;
1561: If (p_rec.LAST_MEDICAL_TEST_DATE = hr_api.g_date) then
1562: p_rec.LAST_MEDICAL_TEST_DATE := per_per_shd.g_old_rec.LAST_MEDICAL_TEST_DATE ;
1563: End If;
1564: If (p_rec.MAILSTOP = hr_api.g_varchar2) then
1565: p_rec.MAILSTOP := per_per_shd.g_old_rec.MAILSTOP ;
1566: End If;
1567: If (p_rec.OFFICE_NUMBER = hr_api.g_varchar2) then
1568: p_rec.OFFICE_NUMBER := per_per_shd.g_old_rec.OFFICE_NUMBER ;

Line 1567: If (p_rec.OFFICE_NUMBER = hr_api.g_varchar2) then

1563: End If;
1564: If (p_rec.MAILSTOP = hr_api.g_varchar2) then
1565: p_rec.MAILSTOP := per_per_shd.g_old_rec.MAILSTOP ;
1566: End If;
1567: If (p_rec.OFFICE_NUMBER = hr_api.g_varchar2) then
1568: p_rec.OFFICE_NUMBER := per_per_shd.g_old_rec.OFFICE_NUMBER ;
1569: End If;
1570: If (p_rec.ON_MILITARY_SERVICE = hr_api.g_varchar2) then
1571: p_rec.ON_MILITARY_SERVICE := per_per_shd.g_old_rec.ON_MILITARY_SERVICE ;

Line 1570: If (p_rec.ON_MILITARY_SERVICE = hr_api.g_varchar2) then

1566: End If;
1567: If (p_rec.OFFICE_NUMBER = hr_api.g_varchar2) then
1568: p_rec.OFFICE_NUMBER := per_per_shd.g_old_rec.OFFICE_NUMBER ;
1569: End If;
1570: If (p_rec.ON_MILITARY_SERVICE = hr_api.g_varchar2) then
1571: p_rec.ON_MILITARY_SERVICE := per_per_shd.g_old_rec.ON_MILITARY_SERVICE ;
1572: End If;
1573: If (p_rec.ORDER_NAME = hr_api.g_varchar2) then
1574: p_rec.ORDER_NAME := per_per_shd.g_old_rec.ORDER_NAME ;

Line 1573: If (p_rec.ORDER_NAME = hr_api.g_varchar2) then

1569: End If;
1570: If (p_rec.ON_MILITARY_SERVICE = hr_api.g_varchar2) then
1571: p_rec.ON_MILITARY_SERVICE := per_per_shd.g_old_rec.ON_MILITARY_SERVICE ;
1572: End If;
1573: If (p_rec.ORDER_NAME = hr_api.g_varchar2) then
1574: p_rec.ORDER_NAME := per_per_shd.g_old_rec.ORDER_NAME ;
1575: End If;
1576: If (p_rec.PRE_NAME_ADJUNCT = hr_api.g_varchar2) then
1577: p_rec.PRE_NAME_ADJUNCT := per_per_shd.g_old_rec.PRE_NAME_ADJUNCT ;

Line 1576: If (p_rec.PRE_NAME_ADJUNCT = hr_api.g_varchar2) then

1572: End If;
1573: If (p_rec.ORDER_NAME = hr_api.g_varchar2) then
1574: p_rec.ORDER_NAME := per_per_shd.g_old_rec.ORDER_NAME ;
1575: End If;
1576: If (p_rec.PRE_NAME_ADJUNCT = hr_api.g_varchar2) then
1577: p_rec.PRE_NAME_ADJUNCT := per_per_shd.g_old_rec.PRE_NAME_ADJUNCT ;
1578: End If;
1579: If (p_rec.PROJECTED_START_DATE = hr_api.g_date) then
1580: p_rec.PROJECTED_START_DATE := per_per_shd.g_old_rec.PROJECTED_START_DATE ;

Line 1579: If (p_rec.PROJECTED_START_DATE = hr_api.g_date) then

1575: End If;
1576: If (p_rec.PRE_NAME_ADJUNCT = hr_api.g_varchar2) then
1577: p_rec.PRE_NAME_ADJUNCT := per_per_shd.g_old_rec.PRE_NAME_ADJUNCT ;
1578: End If;
1579: If (p_rec.PROJECTED_START_DATE = hr_api.g_date) then
1580: p_rec.PROJECTED_START_DATE := per_per_shd.g_old_rec.PROJECTED_START_DATE ;
1581: End If;
1582: If (p_rec.REHIRE_AUTHORIZOR = hr_api.g_varchar2) then
1583: p_rec.REHIRE_AUTHORIZOR := per_per_shd.g_old_rec.REHIRE_AUTHORIZOR ;

Line 1582: If (p_rec.REHIRE_AUTHORIZOR = hr_api.g_varchar2) then

1578: End If;
1579: If (p_rec.PROJECTED_START_DATE = hr_api.g_date) then
1580: p_rec.PROJECTED_START_DATE := per_per_shd.g_old_rec.PROJECTED_START_DATE ;
1581: End If;
1582: If (p_rec.REHIRE_AUTHORIZOR = hr_api.g_varchar2) then
1583: p_rec.REHIRE_AUTHORIZOR := per_per_shd.g_old_rec.REHIRE_AUTHORIZOR ;
1584: End If;
1585: If (p_rec.REHIRE_RECOMMENDATION = hr_api.g_varchar2) then
1586: p_rec.REHIRE_RECOMMENDATION := per_per_shd.g_old_rec.REHIRE_RECOMMENDATION ;

Line 1585: If (p_rec.REHIRE_RECOMMENDATION = hr_api.g_varchar2) then

1581: End If;
1582: If (p_rec.REHIRE_AUTHORIZOR = hr_api.g_varchar2) then
1583: p_rec.REHIRE_AUTHORIZOR := per_per_shd.g_old_rec.REHIRE_AUTHORIZOR ;
1584: End If;
1585: If (p_rec.REHIRE_RECOMMENDATION = hr_api.g_varchar2) then
1586: p_rec.REHIRE_RECOMMENDATION := per_per_shd.g_old_rec.REHIRE_RECOMMENDATION ;
1587: End If;
1588: If (p_rec.RESUME_EXISTS = hr_api.g_varchar2) then
1589: p_rec.RESUME_EXISTS := per_per_shd.g_old_rec.RESUME_EXISTS ;

Line 1588: If (p_rec.RESUME_EXISTS = hr_api.g_varchar2) then

1584: End If;
1585: If (p_rec.REHIRE_RECOMMENDATION = hr_api.g_varchar2) then
1586: p_rec.REHIRE_RECOMMENDATION := per_per_shd.g_old_rec.REHIRE_RECOMMENDATION ;
1587: End If;
1588: If (p_rec.RESUME_EXISTS = hr_api.g_varchar2) then
1589: p_rec.RESUME_EXISTS := per_per_shd.g_old_rec.RESUME_EXISTS ;
1590: End If;
1591: If (p_rec.RESUME_LAST_UPDATED = hr_api.g_date) then
1592: p_rec.RESUME_LAST_UPDATED := per_per_shd.g_old_rec.RESUME_LAST_UPDATED ;

Line 1591: If (p_rec.RESUME_LAST_UPDATED = hr_api.g_date) then

1587: End If;
1588: If (p_rec.RESUME_EXISTS = hr_api.g_varchar2) then
1589: p_rec.RESUME_EXISTS := per_per_shd.g_old_rec.RESUME_EXISTS ;
1590: End If;
1591: If (p_rec.RESUME_LAST_UPDATED = hr_api.g_date) then
1592: p_rec.RESUME_LAST_UPDATED := per_per_shd.g_old_rec.RESUME_LAST_UPDATED ;
1593: End If;
1594: If (p_rec.SECOND_PASSPORT_EXISTS = hr_api.g_varchar2) then
1595: p_rec.SECOND_PASSPORT_EXISTS := per_per_shd.g_old_rec.SECOND_PASSPORT_EXISTS ;

Line 1594: If (p_rec.SECOND_PASSPORT_EXISTS = hr_api.g_varchar2) then

1590: End If;
1591: If (p_rec.RESUME_LAST_UPDATED = hr_api.g_date) then
1592: p_rec.RESUME_LAST_UPDATED := per_per_shd.g_old_rec.RESUME_LAST_UPDATED ;
1593: End If;
1594: If (p_rec.SECOND_PASSPORT_EXISTS = hr_api.g_varchar2) then
1595: p_rec.SECOND_PASSPORT_EXISTS := per_per_shd.g_old_rec.SECOND_PASSPORT_EXISTS ;
1596: End If;
1597: If (p_rec.STUDENT_STATUS = hr_api.g_varchar2) then
1598: p_rec.STUDENT_STATUS := per_per_shd.g_old_rec.STUDENT_STATUS ;

Line 1597: If (p_rec.STUDENT_STATUS = hr_api.g_varchar2) then

1593: End If;
1594: If (p_rec.SECOND_PASSPORT_EXISTS = hr_api.g_varchar2) then
1595: p_rec.SECOND_PASSPORT_EXISTS := per_per_shd.g_old_rec.SECOND_PASSPORT_EXISTS ;
1596: End If;
1597: If (p_rec.STUDENT_STATUS = hr_api.g_varchar2) then
1598: p_rec.STUDENT_STATUS := per_per_shd.g_old_rec.STUDENT_STATUS ;
1599: End If;
1600: If (p_rec.WORK_SCHEDULE = hr_api.g_varchar2) then
1601: p_rec.WORK_SCHEDULE := per_per_shd.g_old_rec.WORK_SCHEDULE ;

Line 1600: If (p_rec.WORK_SCHEDULE = hr_api.g_varchar2) then

1596: End If;
1597: If (p_rec.STUDENT_STATUS = hr_api.g_varchar2) then
1598: p_rec.STUDENT_STATUS := per_per_shd.g_old_rec.STUDENT_STATUS ;
1599: End If;
1600: If (p_rec.WORK_SCHEDULE = hr_api.g_varchar2) then
1601: p_rec.WORK_SCHEDULE := per_per_shd.g_old_rec.WORK_SCHEDULE ;
1602: End If;
1603: If (p_rec.PER_INFORMATION21 = hr_api.g_varchar2) then
1604: p_rec.PER_INFORMATION21 := per_per_shd.g_old_rec.PER_INFORMATION21 ;

Line 1603: If (p_rec.PER_INFORMATION21 = hr_api.g_varchar2) then

1599: End If;
1600: If (p_rec.WORK_SCHEDULE = hr_api.g_varchar2) then
1601: p_rec.WORK_SCHEDULE := per_per_shd.g_old_rec.WORK_SCHEDULE ;
1602: End If;
1603: If (p_rec.PER_INFORMATION21 = hr_api.g_varchar2) then
1604: p_rec.PER_INFORMATION21 := per_per_shd.g_old_rec.PER_INFORMATION21 ;
1605: End If;
1606: If (p_rec.PER_INFORMATION22 = hr_api.g_varchar2) then
1607: p_rec.PER_INFORMATION22 := per_per_shd.g_old_rec.PER_INFORMATION22 ;

Line 1606: If (p_rec.PER_INFORMATION22 = hr_api.g_varchar2) then

1602: End If;
1603: If (p_rec.PER_INFORMATION21 = hr_api.g_varchar2) then
1604: p_rec.PER_INFORMATION21 := per_per_shd.g_old_rec.PER_INFORMATION21 ;
1605: End If;
1606: If (p_rec.PER_INFORMATION22 = hr_api.g_varchar2) then
1607: p_rec.PER_INFORMATION22 := per_per_shd.g_old_rec.PER_INFORMATION22 ;
1608: End If;
1609: If (p_rec.PER_INFORMATION23 = hr_api.g_varchar2) then
1610: p_rec.PER_INFORMATION23 := per_per_shd.g_old_rec.PER_INFORMATION23 ;

Line 1609: If (p_rec.PER_INFORMATION23 = hr_api.g_varchar2) then

1605: End If;
1606: If (p_rec.PER_INFORMATION22 = hr_api.g_varchar2) then
1607: p_rec.PER_INFORMATION22 := per_per_shd.g_old_rec.PER_INFORMATION22 ;
1608: End If;
1609: If (p_rec.PER_INFORMATION23 = hr_api.g_varchar2) then
1610: p_rec.PER_INFORMATION23 := per_per_shd.g_old_rec.PER_INFORMATION23 ;
1611: End If;
1612: If (p_rec.PER_INFORMATION24 = hr_api.g_varchar2) then
1613: p_rec.PER_INFORMATION24 := per_per_shd.g_old_rec.PER_INFORMATION24 ;

Line 1612: If (p_rec.PER_INFORMATION24 = hr_api.g_varchar2) then

1608: End If;
1609: If (p_rec.PER_INFORMATION23 = hr_api.g_varchar2) then
1610: p_rec.PER_INFORMATION23 := per_per_shd.g_old_rec.PER_INFORMATION23 ;
1611: End If;
1612: If (p_rec.PER_INFORMATION24 = hr_api.g_varchar2) then
1613: p_rec.PER_INFORMATION24 := per_per_shd.g_old_rec.PER_INFORMATION24 ;
1614: End If;
1615: If (p_rec.PER_INFORMATION25 = hr_api.g_varchar2) then
1616: p_rec.PER_INFORMATION25 := per_per_shd.g_old_rec.PER_INFORMATION25 ;

Line 1615: If (p_rec.PER_INFORMATION25 = hr_api.g_varchar2) then

1611: End If;
1612: If (p_rec.PER_INFORMATION24 = hr_api.g_varchar2) then
1613: p_rec.PER_INFORMATION24 := per_per_shd.g_old_rec.PER_INFORMATION24 ;
1614: End If;
1615: If (p_rec.PER_INFORMATION25 = hr_api.g_varchar2) then
1616: p_rec.PER_INFORMATION25 := per_per_shd.g_old_rec.PER_INFORMATION25 ;
1617: End If;
1618: If (p_rec.PER_INFORMATION26 = hr_api.g_varchar2) then
1619: p_rec.PER_INFORMATION26 := per_per_shd.g_old_rec.PER_INFORMATION26 ;

Line 1618: If (p_rec.PER_INFORMATION26 = hr_api.g_varchar2) then

1614: End If;
1615: If (p_rec.PER_INFORMATION25 = hr_api.g_varchar2) then
1616: p_rec.PER_INFORMATION25 := per_per_shd.g_old_rec.PER_INFORMATION25 ;
1617: End If;
1618: If (p_rec.PER_INFORMATION26 = hr_api.g_varchar2) then
1619: p_rec.PER_INFORMATION26 := per_per_shd.g_old_rec.PER_INFORMATION26 ;
1620: End If;
1621: If (p_rec.PER_INFORMATION27 = hr_api.g_varchar2) then
1622: p_rec.PER_INFORMATION27 := per_per_shd.g_old_rec.PER_INFORMATION27 ;

Line 1621: If (p_rec.PER_INFORMATION27 = hr_api.g_varchar2) then

1617: End If;
1618: If (p_rec.PER_INFORMATION26 = hr_api.g_varchar2) then
1619: p_rec.PER_INFORMATION26 := per_per_shd.g_old_rec.PER_INFORMATION26 ;
1620: End If;
1621: If (p_rec.PER_INFORMATION27 = hr_api.g_varchar2) then
1622: p_rec.PER_INFORMATION27 := per_per_shd.g_old_rec.PER_INFORMATION27 ;
1623: End If;
1624: If (p_rec.PER_INFORMATION28 = hr_api.g_varchar2) then
1625: p_rec.PER_INFORMATION28 := per_per_shd.g_old_rec.PER_INFORMATION28 ;

Line 1624: If (p_rec.PER_INFORMATION28 = hr_api.g_varchar2) then

1620: End If;
1621: If (p_rec.PER_INFORMATION27 = hr_api.g_varchar2) then
1622: p_rec.PER_INFORMATION27 := per_per_shd.g_old_rec.PER_INFORMATION27 ;
1623: End If;
1624: If (p_rec.PER_INFORMATION28 = hr_api.g_varchar2) then
1625: p_rec.PER_INFORMATION28 := per_per_shd.g_old_rec.PER_INFORMATION28 ;
1626: End If;
1627: If (p_rec.PER_INFORMATION29 = hr_api.g_varchar2) then
1628: p_rec.PER_INFORMATION29 := per_per_shd.g_old_rec.PER_INFORMATION29 ;

Line 1627: If (p_rec.PER_INFORMATION29 = hr_api.g_varchar2) then

1623: End If;
1624: If (p_rec.PER_INFORMATION28 = hr_api.g_varchar2) then
1625: p_rec.PER_INFORMATION28 := per_per_shd.g_old_rec.PER_INFORMATION28 ;
1626: End If;
1627: If (p_rec.PER_INFORMATION29 = hr_api.g_varchar2) then
1628: p_rec.PER_INFORMATION29 := per_per_shd.g_old_rec.PER_INFORMATION29 ;
1629: End If;
1630: If (p_rec.PER_INFORMATION30 = hr_api.g_varchar2) then
1631: p_rec.PER_INFORMATION30 := per_per_shd.g_old_rec.PER_INFORMATION30 ;

Line 1630: If (p_rec.PER_INFORMATION30 = hr_api.g_varchar2) then

1626: End If;
1627: If (p_rec.PER_INFORMATION29 = hr_api.g_varchar2) then
1628: p_rec.PER_INFORMATION29 := per_per_shd.g_old_rec.PER_INFORMATION29 ;
1629: End If;
1630: If (p_rec.PER_INFORMATION30 = hr_api.g_varchar2) then
1631: p_rec.PER_INFORMATION30 := per_per_shd.g_old_rec.PER_INFORMATION30 ;
1632: End If;
1633: If (p_rec.REHIRE_REASON = hr_api.g_varchar2) then
1634: p_rec.REHIRE_REASON := per_per_shd.g_old_rec.REHIRE_REASON ;

Line 1633: If (p_rec.REHIRE_REASON = hr_api.g_varchar2) then

1629: End If;
1630: If (p_rec.PER_INFORMATION30 = hr_api.g_varchar2) then
1631: p_rec.PER_INFORMATION30 := per_per_shd.g_old_rec.PER_INFORMATION30 ;
1632: End If;
1633: If (p_rec.REHIRE_REASON = hr_api.g_varchar2) then
1634: p_rec.REHIRE_REASON := per_per_shd.g_old_rec.REHIRE_REASON ;
1635: End If;
1636: If (p_rec.BENEFIT_GROUP_ID = hr_api.g_number) then
1637: p_rec.BENEFIT_GROUP_ID := per_per_shd.g_old_rec.BENEFIT_GROUP_ID ;

Line 1636: If (p_rec.BENEFIT_GROUP_ID = hr_api.g_number) then

1632: End If;
1633: If (p_rec.REHIRE_REASON = hr_api.g_varchar2) then
1634: p_rec.REHIRE_REASON := per_per_shd.g_old_rec.REHIRE_REASON ;
1635: End If;
1636: If (p_rec.BENEFIT_GROUP_ID = hr_api.g_number) then
1637: p_rec.BENEFIT_GROUP_ID := per_per_shd.g_old_rec.BENEFIT_GROUP_ID ;
1638: End If;
1639: If (p_rec.RECEIPT_OF_DEATH_CERT_DATE = hr_api.g_date) then
1640: p_rec.RECEIPT_OF_DEATH_CERT_DATE := per_per_shd.g_old_rec.RECEIPT_OF_DEATH_CERT_DATE ;

Line 1639: If (p_rec.RECEIPT_OF_DEATH_CERT_DATE = hr_api.g_date) then

1635: End If;
1636: If (p_rec.BENEFIT_GROUP_ID = hr_api.g_number) then
1637: p_rec.BENEFIT_GROUP_ID := per_per_shd.g_old_rec.BENEFIT_GROUP_ID ;
1638: End If;
1639: If (p_rec.RECEIPT_OF_DEATH_CERT_DATE = hr_api.g_date) then
1640: p_rec.RECEIPT_OF_DEATH_CERT_DATE := per_per_shd.g_old_rec.RECEIPT_OF_DEATH_CERT_DATE ;
1641: End If;
1642: If (p_rec.COORD_BEN_MED_PLN_NO = hr_api.g_varchar2) then
1643: p_rec.COORD_BEN_MED_PLN_NO := per_per_shd.g_old_rec.COORD_BEN_MED_PLN_NO ;

Line 1642: If (p_rec.COORD_BEN_MED_PLN_NO = hr_api.g_varchar2) then

1638: End If;
1639: If (p_rec.RECEIPT_OF_DEATH_CERT_DATE = hr_api.g_date) then
1640: p_rec.RECEIPT_OF_DEATH_CERT_DATE := per_per_shd.g_old_rec.RECEIPT_OF_DEATH_CERT_DATE ;
1641: End If;
1642: If (p_rec.COORD_BEN_MED_PLN_NO = hr_api.g_varchar2) then
1643: p_rec.COORD_BEN_MED_PLN_NO := per_per_shd.g_old_rec.COORD_BEN_MED_PLN_NO ;
1644: End If;
1645: If (p_rec.COORD_BEN_NO_CVG_FLAG = hr_api.g_varchar2) then
1646: p_rec.COORD_BEN_NO_CVG_FLAG := per_per_shd.g_old_rec.COORD_BEN_NO_CVG_FLAG ;

Line 1645: If (p_rec.COORD_BEN_NO_CVG_FLAG = hr_api.g_varchar2) then

1641: End If;
1642: If (p_rec.COORD_BEN_MED_PLN_NO = hr_api.g_varchar2) then
1643: p_rec.COORD_BEN_MED_PLN_NO := per_per_shd.g_old_rec.COORD_BEN_MED_PLN_NO ;
1644: End If;
1645: If (p_rec.COORD_BEN_NO_CVG_FLAG = hr_api.g_varchar2) then
1646: p_rec.COORD_BEN_NO_CVG_FLAG := per_per_shd.g_old_rec.COORD_BEN_NO_CVG_FLAG ;
1647: End If;
1648: if (p_rec.COORD_BEN_MED_EXT_ER = hr_api.g_varchar2) then
1649: p_rec.COORD_BEN_MED_EXT_ER:= per_per_shd.g_old_rec.COORD_BEN_MED_EXT_ER;

Line 1648: if (p_rec.COORD_BEN_MED_EXT_ER = hr_api.g_varchar2) then

1644: End If;
1645: If (p_rec.COORD_BEN_NO_CVG_FLAG = hr_api.g_varchar2) then
1646: p_rec.COORD_BEN_NO_CVG_FLAG := per_per_shd.g_old_rec.COORD_BEN_NO_CVG_FLAG ;
1647: End If;
1648: if (p_rec.COORD_BEN_MED_EXT_ER = hr_api.g_varchar2) then
1649: p_rec.COORD_BEN_MED_EXT_ER:= per_per_shd.g_old_rec.COORD_BEN_MED_EXT_ER;
1650: end if;
1651: if (p_rec.COORD_BEN_MED_PL_NAME = hr_api.g_varchar2) then
1652: p_rec.COORD_BEN_MED_PL_NAME:= per_per_shd.g_old_rec.COORD_BEN_MED_PL_NAME;

Line 1651: if (p_rec.COORD_BEN_MED_PL_NAME = hr_api.g_varchar2) then

1647: End If;
1648: if (p_rec.COORD_BEN_MED_EXT_ER = hr_api.g_varchar2) then
1649: p_rec.COORD_BEN_MED_EXT_ER:= per_per_shd.g_old_rec.COORD_BEN_MED_EXT_ER;
1650: end if;
1651: if (p_rec.COORD_BEN_MED_PL_NAME = hr_api.g_varchar2) then
1652: p_rec.COORD_BEN_MED_PL_NAME:= per_per_shd.g_old_rec.COORD_BEN_MED_PL_NAME;
1653: end if;
1654: if (p_rec.COORD_BEN_MED_INSR_CRR_NAME = hr_api.g_varchar2) then
1655: p_rec.COORD_BEN_MED_INSR_CRR_NAME:= per_per_shd.g_old_rec.COORD_BEN_MED_INSR_CRR_NAME;

Line 1654: if (p_rec.COORD_BEN_MED_INSR_CRR_NAME = hr_api.g_varchar2) then

1650: end if;
1651: if (p_rec.COORD_BEN_MED_PL_NAME = hr_api.g_varchar2) then
1652: p_rec.COORD_BEN_MED_PL_NAME:= per_per_shd.g_old_rec.COORD_BEN_MED_PL_NAME;
1653: end if;
1654: if (p_rec.COORD_BEN_MED_INSR_CRR_NAME = hr_api.g_varchar2) then
1655: p_rec.COORD_BEN_MED_INSR_CRR_NAME:= per_per_shd.g_old_rec.COORD_BEN_MED_INSR_CRR_NAME;
1656: end if;
1657: if (p_rec.COORD_BEN_MED_INSR_CRR_IDENT = hr_api.g_varchar2) then
1658: p_rec.COORD_BEN_MED_INSR_CRR_IDENT:= per_per_shd.g_old_rec.COORD_BEN_MED_INSR_CRR_IDENT;

Line 1657: if (p_rec.COORD_BEN_MED_INSR_CRR_IDENT = hr_api.g_varchar2) then

1653: end if;
1654: if (p_rec.COORD_BEN_MED_INSR_CRR_NAME = hr_api.g_varchar2) then
1655: p_rec.COORD_BEN_MED_INSR_CRR_NAME:= per_per_shd.g_old_rec.COORD_BEN_MED_INSR_CRR_NAME;
1656: end if;
1657: if (p_rec.COORD_BEN_MED_INSR_CRR_IDENT = hr_api.g_varchar2) then
1658: p_rec.COORD_BEN_MED_INSR_CRR_IDENT:= per_per_shd.g_old_rec.COORD_BEN_MED_INSR_CRR_IDENT;
1659: end if;
1660: if (p_rec.COORD_BEN_MED_CVG_STRT_DT = hr_api.g_date) then
1661: p_rec.COORD_BEN_MED_CVG_STRT_DT:= per_per_shd.g_old_rec.COORD_BEN_MED_CVG_STRT_DT;

Line 1660: if (p_rec.COORD_BEN_MED_CVG_STRT_DT = hr_api.g_date) then

1656: end if;
1657: if (p_rec.COORD_BEN_MED_INSR_CRR_IDENT = hr_api.g_varchar2) then
1658: p_rec.COORD_BEN_MED_INSR_CRR_IDENT:= per_per_shd.g_old_rec.COORD_BEN_MED_INSR_CRR_IDENT;
1659: end if;
1660: if (p_rec.COORD_BEN_MED_CVG_STRT_DT = hr_api.g_date) then
1661: p_rec.COORD_BEN_MED_CVG_STRT_DT:= per_per_shd.g_old_rec.COORD_BEN_MED_CVG_STRT_DT;
1662: end if;
1663: if (p_rec.COORD_BEN_MED_CVG_END_DT = hr_api.g_date) then
1664: p_rec.COORD_BEN_MED_CVG_END_DT := per_per_shd.g_old_rec.COORD_BEN_MED_CVG_END_DT;

Line 1663: if (p_rec.COORD_BEN_MED_CVG_END_DT = hr_api.g_date) then

1659: end if;
1660: if (p_rec.COORD_BEN_MED_CVG_STRT_DT = hr_api.g_date) then
1661: p_rec.COORD_BEN_MED_CVG_STRT_DT:= per_per_shd.g_old_rec.COORD_BEN_MED_CVG_STRT_DT;
1662: end if;
1663: if (p_rec.COORD_BEN_MED_CVG_END_DT = hr_api.g_date) then
1664: p_rec.COORD_BEN_MED_CVG_END_DT := per_per_shd.g_old_rec.COORD_BEN_MED_CVG_END_DT;
1665: end if;
1666: If (p_rec.USES_TOBACCO_FLAG = hr_api.g_varchar2) then
1667: p_rec.USES_TOBACCO_FLAG := per_per_shd.g_old_rec.USES_TOBACCO_FLAG ;

Line 1666: If (p_rec.USES_TOBACCO_FLAG = hr_api.g_varchar2) then

1662: end if;
1663: if (p_rec.COORD_BEN_MED_CVG_END_DT = hr_api.g_date) then
1664: p_rec.COORD_BEN_MED_CVG_END_DT := per_per_shd.g_old_rec.COORD_BEN_MED_CVG_END_DT;
1665: end if;
1666: If (p_rec.USES_TOBACCO_FLAG = hr_api.g_varchar2) then
1667: p_rec.USES_TOBACCO_FLAG := per_per_shd.g_old_rec.USES_TOBACCO_FLAG ;
1668: End If;
1669: If (p_rec.DPDNT_ADOPTION_DATE = hr_api.g_date) then
1670: p_rec.DPDNT_ADOPTION_DATE := per_per_shd.g_old_rec.DPDNT_ADOPTION_DATE ;

Line 1669: If (p_rec.DPDNT_ADOPTION_DATE = hr_api.g_date) then

1665: end if;
1666: If (p_rec.USES_TOBACCO_FLAG = hr_api.g_varchar2) then
1667: p_rec.USES_TOBACCO_FLAG := per_per_shd.g_old_rec.USES_TOBACCO_FLAG ;
1668: End If;
1669: If (p_rec.DPDNT_ADOPTION_DATE = hr_api.g_date) then
1670: p_rec.DPDNT_ADOPTION_DATE := per_per_shd.g_old_rec.DPDNT_ADOPTION_DATE ;
1671: End If;
1672: If (p_rec.DPDNT_VLNTRY_SVCE_FLAG = hr_api.g_varchar2) then
1673: p_rec.DPDNT_VLNTRY_SVCE_FLAG := per_per_shd.g_old_rec.DPDNT_VLNTRY_SVCE_FLAG ;

Line 1672: If (p_rec.DPDNT_VLNTRY_SVCE_FLAG = hr_api.g_varchar2) then

1668: End If;
1669: If (p_rec.DPDNT_ADOPTION_DATE = hr_api.g_date) then
1670: p_rec.DPDNT_ADOPTION_DATE := per_per_shd.g_old_rec.DPDNT_ADOPTION_DATE ;
1671: End If;
1672: If (p_rec.DPDNT_VLNTRY_SVCE_FLAG = hr_api.g_varchar2) then
1673: p_rec.DPDNT_VLNTRY_SVCE_FLAG := per_per_shd.g_old_rec.DPDNT_VLNTRY_SVCE_FLAG ;
1674: End If;
1675: If (p_rec.ORIGINAL_DATE_OF_HIRE = hr_api.g_date) then
1676: p_rec.ORIGINAL_DATE_OF_HIRE := per_per_shd.g_old_rec.ORIGINAL_DATE_OF_HIRE ;

Line 1675: If (p_rec.ORIGINAL_DATE_OF_HIRE = hr_api.g_date) then

1671: End If;
1672: If (p_rec.DPDNT_VLNTRY_SVCE_FLAG = hr_api.g_varchar2) then
1673: p_rec.DPDNT_VLNTRY_SVCE_FLAG := per_per_shd.g_old_rec.DPDNT_VLNTRY_SVCE_FLAG ;
1674: End If;
1675: If (p_rec.ORIGINAL_DATE_OF_HIRE = hr_api.g_date) then
1676: p_rec.ORIGINAL_DATE_OF_HIRE := per_per_shd.g_old_rec.ORIGINAL_DATE_OF_HIRE ;
1677: End If;
1678: If (p_rec.town_of_birth = hr_api.g_varchar2) then
1679: p_rec.town_of_birth := per_per_shd.g_old_rec.town_of_birth ;

Line 1678: If (p_rec.town_of_birth = hr_api.g_varchar2) then

1674: End If;
1675: If (p_rec.ORIGINAL_DATE_OF_HIRE = hr_api.g_date) then
1676: p_rec.ORIGINAL_DATE_OF_HIRE := per_per_shd.g_old_rec.ORIGINAL_DATE_OF_HIRE ;
1677: End If;
1678: If (p_rec.town_of_birth = hr_api.g_varchar2) then
1679: p_rec.town_of_birth := per_per_shd.g_old_rec.town_of_birth ;
1680: End If;
1681: If (p_rec.region_of_birth = hr_api.g_varchar2) then
1682: p_rec.region_of_birth := per_per_shd.g_old_rec.region_of_birth ;

Line 1681: If (p_rec.region_of_birth = hr_api.g_varchar2) then

1677: End If;
1678: If (p_rec.town_of_birth = hr_api.g_varchar2) then
1679: p_rec.town_of_birth := per_per_shd.g_old_rec.town_of_birth ;
1680: End If;
1681: If (p_rec.region_of_birth = hr_api.g_varchar2) then
1682: p_rec.region_of_birth := per_per_shd.g_old_rec.region_of_birth ;
1683: End If;
1684: If (p_rec.country_of_birth = hr_api.g_varchar2) then
1685: p_rec.country_of_birth := per_per_shd.g_old_rec.country_of_birth ;

Line 1684: If (p_rec.country_of_birth = hr_api.g_varchar2) then

1680: End If;
1681: If (p_rec.region_of_birth = hr_api.g_varchar2) then
1682: p_rec.region_of_birth := per_per_shd.g_old_rec.region_of_birth ;
1683: End If;
1684: If (p_rec.country_of_birth = hr_api.g_varchar2) then
1685: p_rec.country_of_birth := per_per_shd.g_old_rec.country_of_birth ;
1686: End If;
1687: If (p_rec.global_person_id = hr_api.g_varchar2) then
1688: p_rec.global_person_id := per_per_shd.g_old_rec.global_person_id ;

Line 1687: If (p_rec.global_person_id = hr_api.g_varchar2) then

1683: End If;
1684: If (p_rec.country_of_birth = hr_api.g_varchar2) then
1685: p_rec.country_of_birth := per_per_shd.g_old_rec.country_of_birth ;
1686: End If;
1687: If (p_rec.global_person_id = hr_api.g_varchar2) then
1688: p_rec.global_person_id := per_per_shd.g_old_rec.global_person_id ;
1689: End If;
1690: If (p_rec.party_id = hr_api.g_number) then
1691: p_rec.party_id := per_per_shd.g_old_rec.party_id ;

Line 1690: If (p_rec.party_id = hr_api.g_number) then

1686: End If;
1687: If (p_rec.global_person_id = hr_api.g_varchar2) then
1688: p_rec.global_person_id := per_per_shd.g_old_rec.global_person_id ;
1689: End If;
1690: If (p_rec.party_id = hr_api.g_number) then
1691: p_rec.party_id := per_per_shd.g_old_rec.party_id ;
1692: End If;
1693: If (p_rec.npw_number = hr_api.g_varchar2) then
1694: p_rec.npw_number := per_per_shd.g_old_rec.npw_number ;

Line 1693: If (p_rec.npw_number = hr_api.g_varchar2) then

1689: End If;
1690: If (p_rec.party_id = hr_api.g_number) then
1691: p_rec.party_id := per_per_shd.g_old_rec.party_id ;
1692: End If;
1693: If (p_rec.npw_number = hr_api.g_varchar2) then
1694: p_rec.npw_number := per_per_shd.g_old_rec.npw_number ;
1695: End If;
1696: If (p_rec.current_npw_flag = hr_api.g_varchar2) then
1697: p_rec.current_npw_flag := per_per_shd.g_old_rec.current_npw_flag ;

Line 1696: If (p_rec.current_npw_flag = hr_api.g_varchar2) then

1692: End If;
1693: If (p_rec.npw_number = hr_api.g_varchar2) then
1694: p_rec.npw_number := per_per_shd.g_old_rec.npw_number ;
1695: End If;
1696: If (p_rec.current_npw_flag = hr_api.g_varchar2) then
1697: p_rec.current_npw_flag := per_per_shd.g_old_rec.current_npw_flag ;
1698: End If;
1699: --
1700: -- Return the plsql record structure.

Line 1808: Raise HR_Api.Validate_Enabled;

1804: hr_multi_message.end_validation_set;
1805: -- If we are validating then raise the Validate_Enabled exception
1806: --
1807: If p_validate then
1808: Raise HR_Api.Validate_Enabled;
1809: End If;
1810: --
1811: -- Set output arguments
1812: --

Line 1834: When HR_Api.Validate_Enabled Then

1830: end if;
1831: --
1832: hr_utility.set_location(' Leaving:'||l_proc, 10);
1833: Exception
1834: When HR_Api.Validate_Enabled Then
1835: --
1836: -- As the Validate_Enabled exception has been raised
1837: -- we must rollback to the savepoint
1838: --

Line 1850: p_person_type_id in number default hr_api.g_number,

1846: (
1847: p_person_id in number,
1848: p_effective_start_date out nocopy date,
1849: p_effective_end_date out nocopy date,
1850: p_person_type_id in number default hr_api.g_number,
1851: p_last_name in varchar2 default hr_api.g_varchar2,
1852: p_start_date in date default hr_api.g_date,
1853: p_applicant_number in out nocopy varchar2,
1854: p_comment_id out nocopy number,

Line 1851: p_last_name in varchar2 default hr_api.g_varchar2,

1847: p_person_id in number,
1848: p_effective_start_date out nocopy date,
1849: p_effective_end_date out nocopy date,
1850: p_person_type_id in number default hr_api.g_number,
1851: p_last_name in varchar2 default hr_api.g_varchar2,
1852: p_start_date in date default hr_api.g_date,
1853: p_applicant_number in out nocopy varchar2,
1854: p_comment_id out nocopy number,
1855: p_comments in varchar2 default hr_api.g_varchar2,

Line 1852: p_start_date in date default hr_api.g_date,

1848: p_effective_start_date out nocopy date,
1849: p_effective_end_date out nocopy date,
1850: p_person_type_id in number default hr_api.g_number,
1851: p_last_name in varchar2 default hr_api.g_varchar2,
1852: p_start_date in date default hr_api.g_date,
1853: p_applicant_number in out nocopy varchar2,
1854: p_comment_id out nocopy number,
1855: p_comments in varchar2 default hr_api.g_varchar2,
1856: p_current_applicant_flag out nocopy varchar2,

Line 1855: p_comments in varchar2 default hr_api.g_varchar2,

1851: p_last_name in varchar2 default hr_api.g_varchar2,
1852: p_start_date in date default hr_api.g_date,
1853: p_applicant_number in out nocopy varchar2,
1854: p_comment_id out nocopy number,
1855: p_comments in varchar2 default hr_api.g_varchar2,
1856: p_current_applicant_flag out nocopy varchar2,
1857: p_current_emp_or_apl_flag out nocopy varchar2,
1858: p_current_employee_flag out nocopy varchar2,
1859: p_date_employee_data_verified in date default hr_api.g_date,

Line 1859: p_date_employee_data_verified in date default hr_api.g_date,

1855: p_comments in varchar2 default hr_api.g_varchar2,
1856: p_current_applicant_flag out nocopy varchar2,
1857: p_current_emp_or_apl_flag out nocopy varchar2,
1858: p_current_employee_flag out nocopy varchar2,
1859: p_date_employee_data_verified in date default hr_api.g_date,
1860: p_date_of_birth in date default hr_api.g_date,
1861: p_email_address in varchar2 default hr_api.g_varchar2,
1862: p_employee_number in out nocopy varchar2,
1863: p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2,

Line 1860: p_date_of_birth in date default hr_api.g_date,

1856: p_current_applicant_flag out nocopy varchar2,
1857: p_current_emp_or_apl_flag out nocopy varchar2,
1858: p_current_employee_flag out nocopy varchar2,
1859: p_date_employee_data_verified in date default hr_api.g_date,
1860: p_date_of_birth in date default hr_api.g_date,
1861: p_email_address in varchar2 default hr_api.g_varchar2,
1862: p_employee_number in out nocopy varchar2,
1863: p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2,
1864: p_first_name in varchar2 default hr_api.g_varchar2,

Line 1861: p_email_address in varchar2 default hr_api.g_varchar2,

1857: p_current_emp_or_apl_flag out nocopy varchar2,
1858: p_current_employee_flag out nocopy varchar2,
1859: p_date_employee_data_verified in date default hr_api.g_date,
1860: p_date_of_birth in date default hr_api.g_date,
1861: p_email_address in varchar2 default hr_api.g_varchar2,
1862: p_employee_number in out nocopy varchar2,
1863: p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2,
1864: p_first_name in varchar2 default hr_api.g_varchar2,
1865: p_full_name out nocopy varchar2,

Line 1863: p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2,

1859: p_date_employee_data_verified in date default hr_api.g_date,
1860: p_date_of_birth in date default hr_api.g_date,
1861: p_email_address in varchar2 default hr_api.g_varchar2,
1862: p_employee_number in out nocopy varchar2,
1863: p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2,
1864: p_first_name in varchar2 default hr_api.g_varchar2,
1865: p_full_name out nocopy varchar2,
1866: p_known_as in varchar2 default hr_api.g_varchar2,
1867: p_marital_status in varchar2 default hr_api.g_varchar2,

Line 1864: p_first_name in varchar2 default hr_api.g_varchar2,

1860: p_date_of_birth in date default hr_api.g_date,
1861: p_email_address in varchar2 default hr_api.g_varchar2,
1862: p_employee_number in out nocopy varchar2,
1863: p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2,
1864: p_first_name in varchar2 default hr_api.g_varchar2,
1865: p_full_name out nocopy varchar2,
1866: p_known_as in varchar2 default hr_api.g_varchar2,
1867: p_marital_status in varchar2 default hr_api.g_varchar2,
1868: p_middle_names in varchar2 default hr_api.g_varchar2,

Line 1866: p_known_as in varchar2 default hr_api.g_varchar2,

1862: p_employee_number in out nocopy varchar2,
1863: p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2,
1864: p_first_name in varchar2 default hr_api.g_varchar2,
1865: p_full_name out nocopy varchar2,
1866: p_known_as in varchar2 default hr_api.g_varchar2,
1867: p_marital_status in varchar2 default hr_api.g_varchar2,
1868: p_middle_names in varchar2 default hr_api.g_varchar2,
1869: p_nationality in varchar2 default hr_api.g_varchar2,
1870: p_national_identifier in varchar2 default hr_api.g_varchar2,

Line 1867: p_marital_status in varchar2 default hr_api.g_varchar2,

1863: p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2,
1864: p_first_name in varchar2 default hr_api.g_varchar2,
1865: p_full_name out nocopy varchar2,
1866: p_known_as in varchar2 default hr_api.g_varchar2,
1867: p_marital_status in varchar2 default hr_api.g_varchar2,
1868: p_middle_names in varchar2 default hr_api.g_varchar2,
1869: p_nationality in varchar2 default hr_api.g_varchar2,
1870: p_national_identifier in varchar2 default hr_api.g_varchar2,
1871: p_previous_last_name in varchar2 default hr_api.g_varchar2,

Line 1868: p_middle_names in varchar2 default hr_api.g_varchar2,

1864: p_first_name in varchar2 default hr_api.g_varchar2,
1865: p_full_name out nocopy varchar2,
1866: p_known_as in varchar2 default hr_api.g_varchar2,
1867: p_marital_status in varchar2 default hr_api.g_varchar2,
1868: p_middle_names in varchar2 default hr_api.g_varchar2,
1869: p_nationality in varchar2 default hr_api.g_varchar2,
1870: p_national_identifier in varchar2 default hr_api.g_varchar2,
1871: p_previous_last_name in varchar2 default hr_api.g_varchar2,
1872: p_registered_disabled_flag in varchar2 default hr_api.g_varchar2,

Line 1869: p_nationality in varchar2 default hr_api.g_varchar2,

1865: p_full_name out nocopy varchar2,
1866: p_known_as in varchar2 default hr_api.g_varchar2,
1867: p_marital_status in varchar2 default hr_api.g_varchar2,
1868: p_middle_names in varchar2 default hr_api.g_varchar2,
1869: p_nationality in varchar2 default hr_api.g_varchar2,
1870: p_national_identifier in varchar2 default hr_api.g_varchar2,
1871: p_previous_last_name in varchar2 default hr_api.g_varchar2,
1872: p_registered_disabled_flag in varchar2 default hr_api.g_varchar2,
1873: p_sex in varchar2 default hr_api.g_varchar2,

Line 1870: p_national_identifier in varchar2 default hr_api.g_varchar2,

1866: p_known_as in varchar2 default hr_api.g_varchar2,
1867: p_marital_status in varchar2 default hr_api.g_varchar2,
1868: p_middle_names in varchar2 default hr_api.g_varchar2,
1869: p_nationality in varchar2 default hr_api.g_varchar2,
1870: p_national_identifier in varchar2 default hr_api.g_varchar2,
1871: p_previous_last_name in varchar2 default hr_api.g_varchar2,
1872: p_registered_disabled_flag in varchar2 default hr_api.g_varchar2,
1873: p_sex in varchar2 default hr_api.g_varchar2,
1874: p_title in varchar2 default hr_api.g_varchar2,

Line 1871: p_previous_last_name in varchar2 default hr_api.g_varchar2,

1867: p_marital_status in varchar2 default hr_api.g_varchar2,
1868: p_middle_names in varchar2 default hr_api.g_varchar2,
1869: p_nationality in varchar2 default hr_api.g_varchar2,
1870: p_national_identifier in varchar2 default hr_api.g_varchar2,
1871: p_previous_last_name in varchar2 default hr_api.g_varchar2,
1872: p_registered_disabled_flag in varchar2 default hr_api.g_varchar2,
1873: p_sex in varchar2 default hr_api.g_varchar2,
1874: p_title in varchar2 default hr_api.g_varchar2,
1875: p_vendor_id in number default hr_api.g_number,

Line 1872: p_registered_disabled_flag in varchar2 default hr_api.g_varchar2,

1868: p_middle_names in varchar2 default hr_api.g_varchar2,
1869: p_nationality in varchar2 default hr_api.g_varchar2,
1870: p_national_identifier in varchar2 default hr_api.g_varchar2,
1871: p_previous_last_name in varchar2 default hr_api.g_varchar2,
1872: p_registered_disabled_flag in varchar2 default hr_api.g_varchar2,
1873: p_sex in varchar2 default hr_api.g_varchar2,
1874: p_title in varchar2 default hr_api.g_varchar2,
1875: p_vendor_id in number default hr_api.g_number,
1876: p_work_telephone in varchar2 default hr_api.g_varchar2,

Line 1873: p_sex in varchar2 default hr_api.g_varchar2,

1869: p_nationality in varchar2 default hr_api.g_varchar2,
1870: p_national_identifier in varchar2 default hr_api.g_varchar2,
1871: p_previous_last_name in varchar2 default hr_api.g_varchar2,
1872: p_registered_disabled_flag in varchar2 default hr_api.g_varchar2,
1873: p_sex in varchar2 default hr_api.g_varchar2,
1874: p_title in varchar2 default hr_api.g_varchar2,
1875: p_vendor_id in number default hr_api.g_number,
1876: p_work_telephone in varchar2 default hr_api.g_varchar2,
1877: p_request_id in number default hr_api.g_number,

Line 1874: p_title in varchar2 default hr_api.g_varchar2,

1870: p_national_identifier in varchar2 default hr_api.g_varchar2,
1871: p_previous_last_name in varchar2 default hr_api.g_varchar2,
1872: p_registered_disabled_flag in varchar2 default hr_api.g_varchar2,
1873: p_sex in varchar2 default hr_api.g_varchar2,
1874: p_title in varchar2 default hr_api.g_varchar2,
1875: p_vendor_id in number default hr_api.g_number,
1876: p_work_telephone in varchar2 default hr_api.g_varchar2,
1877: p_request_id in number default hr_api.g_number,
1878: p_program_application_id in number default hr_api.g_number,

Line 1875: p_vendor_id in number default hr_api.g_number,

1871: p_previous_last_name in varchar2 default hr_api.g_varchar2,
1872: p_registered_disabled_flag in varchar2 default hr_api.g_varchar2,
1873: p_sex in varchar2 default hr_api.g_varchar2,
1874: p_title in varchar2 default hr_api.g_varchar2,
1875: p_vendor_id in number default hr_api.g_number,
1876: p_work_telephone in varchar2 default hr_api.g_varchar2,
1877: p_request_id in number default hr_api.g_number,
1878: p_program_application_id in number default hr_api.g_number,
1879: p_program_id in number default hr_api.g_number,

Line 1876: p_work_telephone in varchar2 default hr_api.g_varchar2,

1872: p_registered_disabled_flag in varchar2 default hr_api.g_varchar2,
1873: p_sex in varchar2 default hr_api.g_varchar2,
1874: p_title in varchar2 default hr_api.g_varchar2,
1875: p_vendor_id in number default hr_api.g_number,
1876: p_work_telephone in varchar2 default hr_api.g_varchar2,
1877: p_request_id in number default hr_api.g_number,
1878: p_program_application_id in number default hr_api.g_number,
1879: p_program_id in number default hr_api.g_number,
1880: p_program_update_date in date default hr_api.g_date,

Line 1877: p_request_id in number default hr_api.g_number,

1873: p_sex in varchar2 default hr_api.g_varchar2,
1874: p_title in varchar2 default hr_api.g_varchar2,
1875: p_vendor_id in number default hr_api.g_number,
1876: p_work_telephone in varchar2 default hr_api.g_varchar2,
1877: p_request_id in number default hr_api.g_number,
1878: p_program_application_id in number default hr_api.g_number,
1879: p_program_id in number default hr_api.g_number,
1880: p_program_update_date in date default hr_api.g_date,
1881: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 1878: p_program_application_id in number default hr_api.g_number,

1874: p_title in varchar2 default hr_api.g_varchar2,
1875: p_vendor_id in number default hr_api.g_number,
1876: p_work_telephone in varchar2 default hr_api.g_varchar2,
1877: p_request_id in number default hr_api.g_number,
1878: p_program_application_id in number default hr_api.g_number,
1879: p_program_id in number default hr_api.g_number,
1880: p_program_update_date in date default hr_api.g_date,
1881: p_attribute_category in varchar2 default hr_api.g_varchar2,
1882: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 1879: p_program_id in number default hr_api.g_number,

1875: p_vendor_id in number default hr_api.g_number,
1876: p_work_telephone in varchar2 default hr_api.g_varchar2,
1877: p_request_id in number default hr_api.g_number,
1878: p_program_application_id in number default hr_api.g_number,
1879: p_program_id in number default hr_api.g_number,
1880: p_program_update_date in date default hr_api.g_date,
1881: p_attribute_category in varchar2 default hr_api.g_varchar2,
1882: p_attribute1 in varchar2 default hr_api.g_varchar2,
1883: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 1880: p_program_update_date in date default hr_api.g_date,

1876: p_work_telephone in varchar2 default hr_api.g_varchar2,
1877: p_request_id in number default hr_api.g_number,
1878: p_program_application_id in number default hr_api.g_number,
1879: p_program_id in number default hr_api.g_number,
1880: p_program_update_date in date default hr_api.g_date,
1881: p_attribute_category in varchar2 default hr_api.g_varchar2,
1882: p_attribute1 in varchar2 default hr_api.g_varchar2,
1883: p_attribute2 in varchar2 default hr_api.g_varchar2,
1884: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 1881: p_attribute_category in varchar2 default hr_api.g_varchar2,

1877: p_request_id in number default hr_api.g_number,
1878: p_program_application_id in number default hr_api.g_number,
1879: p_program_id in number default hr_api.g_number,
1880: p_program_update_date in date default hr_api.g_date,
1881: p_attribute_category in varchar2 default hr_api.g_varchar2,
1882: p_attribute1 in varchar2 default hr_api.g_varchar2,
1883: p_attribute2 in varchar2 default hr_api.g_varchar2,
1884: p_attribute3 in varchar2 default hr_api.g_varchar2,
1885: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 1882: p_attribute1 in varchar2 default hr_api.g_varchar2,

1878: p_program_application_id in number default hr_api.g_number,
1879: p_program_id in number default hr_api.g_number,
1880: p_program_update_date in date default hr_api.g_date,
1881: p_attribute_category in varchar2 default hr_api.g_varchar2,
1882: p_attribute1 in varchar2 default hr_api.g_varchar2,
1883: p_attribute2 in varchar2 default hr_api.g_varchar2,
1884: p_attribute3 in varchar2 default hr_api.g_varchar2,
1885: p_attribute4 in varchar2 default hr_api.g_varchar2,
1886: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 1883: p_attribute2 in varchar2 default hr_api.g_varchar2,

1879: p_program_id in number default hr_api.g_number,
1880: p_program_update_date in date default hr_api.g_date,
1881: p_attribute_category in varchar2 default hr_api.g_varchar2,
1882: p_attribute1 in varchar2 default hr_api.g_varchar2,
1883: p_attribute2 in varchar2 default hr_api.g_varchar2,
1884: p_attribute3 in varchar2 default hr_api.g_varchar2,
1885: p_attribute4 in varchar2 default hr_api.g_varchar2,
1886: p_attribute5 in varchar2 default hr_api.g_varchar2,
1887: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 1884: p_attribute3 in varchar2 default hr_api.g_varchar2,

1880: p_program_update_date in date default hr_api.g_date,
1881: p_attribute_category in varchar2 default hr_api.g_varchar2,
1882: p_attribute1 in varchar2 default hr_api.g_varchar2,
1883: p_attribute2 in varchar2 default hr_api.g_varchar2,
1884: p_attribute3 in varchar2 default hr_api.g_varchar2,
1885: p_attribute4 in varchar2 default hr_api.g_varchar2,
1886: p_attribute5 in varchar2 default hr_api.g_varchar2,
1887: p_attribute6 in varchar2 default hr_api.g_varchar2,
1888: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 1885: p_attribute4 in varchar2 default hr_api.g_varchar2,

1881: p_attribute_category in varchar2 default hr_api.g_varchar2,
1882: p_attribute1 in varchar2 default hr_api.g_varchar2,
1883: p_attribute2 in varchar2 default hr_api.g_varchar2,
1884: p_attribute3 in varchar2 default hr_api.g_varchar2,
1885: p_attribute4 in varchar2 default hr_api.g_varchar2,
1886: p_attribute5 in varchar2 default hr_api.g_varchar2,
1887: p_attribute6 in varchar2 default hr_api.g_varchar2,
1888: p_attribute7 in varchar2 default hr_api.g_varchar2,
1889: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 1886: p_attribute5 in varchar2 default hr_api.g_varchar2,

1882: p_attribute1 in varchar2 default hr_api.g_varchar2,
1883: p_attribute2 in varchar2 default hr_api.g_varchar2,
1884: p_attribute3 in varchar2 default hr_api.g_varchar2,
1885: p_attribute4 in varchar2 default hr_api.g_varchar2,
1886: p_attribute5 in varchar2 default hr_api.g_varchar2,
1887: p_attribute6 in varchar2 default hr_api.g_varchar2,
1888: p_attribute7 in varchar2 default hr_api.g_varchar2,
1889: p_attribute8 in varchar2 default hr_api.g_varchar2,
1890: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 1887: p_attribute6 in varchar2 default hr_api.g_varchar2,

1883: p_attribute2 in varchar2 default hr_api.g_varchar2,
1884: p_attribute3 in varchar2 default hr_api.g_varchar2,
1885: p_attribute4 in varchar2 default hr_api.g_varchar2,
1886: p_attribute5 in varchar2 default hr_api.g_varchar2,
1887: p_attribute6 in varchar2 default hr_api.g_varchar2,
1888: p_attribute7 in varchar2 default hr_api.g_varchar2,
1889: p_attribute8 in varchar2 default hr_api.g_varchar2,
1890: p_attribute9 in varchar2 default hr_api.g_varchar2,
1891: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 1888: p_attribute7 in varchar2 default hr_api.g_varchar2,

1884: p_attribute3 in varchar2 default hr_api.g_varchar2,
1885: p_attribute4 in varchar2 default hr_api.g_varchar2,
1886: p_attribute5 in varchar2 default hr_api.g_varchar2,
1887: p_attribute6 in varchar2 default hr_api.g_varchar2,
1888: p_attribute7 in varchar2 default hr_api.g_varchar2,
1889: p_attribute8 in varchar2 default hr_api.g_varchar2,
1890: p_attribute9 in varchar2 default hr_api.g_varchar2,
1891: p_attribute10 in varchar2 default hr_api.g_varchar2,
1892: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 1889: p_attribute8 in varchar2 default hr_api.g_varchar2,

1885: p_attribute4 in varchar2 default hr_api.g_varchar2,
1886: p_attribute5 in varchar2 default hr_api.g_varchar2,
1887: p_attribute6 in varchar2 default hr_api.g_varchar2,
1888: p_attribute7 in varchar2 default hr_api.g_varchar2,
1889: p_attribute8 in varchar2 default hr_api.g_varchar2,
1890: p_attribute9 in varchar2 default hr_api.g_varchar2,
1891: p_attribute10 in varchar2 default hr_api.g_varchar2,
1892: p_attribute11 in varchar2 default hr_api.g_varchar2,
1893: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 1890: p_attribute9 in varchar2 default hr_api.g_varchar2,

1886: p_attribute5 in varchar2 default hr_api.g_varchar2,
1887: p_attribute6 in varchar2 default hr_api.g_varchar2,
1888: p_attribute7 in varchar2 default hr_api.g_varchar2,
1889: p_attribute8 in varchar2 default hr_api.g_varchar2,
1890: p_attribute9 in varchar2 default hr_api.g_varchar2,
1891: p_attribute10 in varchar2 default hr_api.g_varchar2,
1892: p_attribute11 in varchar2 default hr_api.g_varchar2,
1893: p_attribute12 in varchar2 default hr_api.g_varchar2,
1894: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 1891: p_attribute10 in varchar2 default hr_api.g_varchar2,

1887: p_attribute6 in varchar2 default hr_api.g_varchar2,
1888: p_attribute7 in varchar2 default hr_api.g_varchar2,
1889: p_attribute8 in varchar2 default hr_api.g_varchar2,
1890: p_attribute9 in varchar2 default hr_api.g_varchar2,
1891: p_attribute10 in varchar2 default hr_api.g_varchar2,
1892: p_attribute11 in varchar2 default hr_api.g_varchar2,
1893: p_attribute12 in varchar2 default hr_api.g_varchar2,
1894: p_attribute13 in varchar2 default hr_api.g_varchar2,
1895: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 1892: p_attribute11 in varchar2 default hr_api.g_varchar2,

1888: p_attribute7 in varchar2 default hr_api.g_varchar2,
1889: p_attribute8 in varchar2 default hr_api.g_varchar2,
1890: p_attribute9 in varchar2 default hr_api.g_varchar2,
1891: p_attribute10 in varchar2 default hr_api.g_varchar2,
1892: p_attribute11 in varchar2 default hr_api.g_varchar2,
1893: p_attribute12 in varchar2 default hr_api.g_varchar2,
1894: p_attribute13 in varchar2 default hr_api.g_varchar2,
1895: p_attribute14 in varchar2 default hr_api.g_varchar2,
1896: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 1893: p_attribute12 in varchar2 default hr_api.g_varchar2,

1889: p_attribute8 in varchar2 default hr_api.g_varchar2,
1890: p_attribute9 in varchar2 default hr_api.g_varchar2,
1891: p_attribute10 in varchar2 default hr_api.g_varchar2,
1892: p_attribute11 in varchar2 default hr_api.g_varchar2,
1893: p_attribute12 in varchar2 default hr_api.g_varchar2,
1894: p_attribute13 in varchar2 default hr_api.g_varchar2,
1895: p_attribute14 in varchar2 default hr_api.g_varchar2,
1896: p_attribute15 in varchar2 default hr_api.g_varchar2,
1897: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 1894: p_attribute13 in varchar2 default hr_api.g_varchar2,

1890: p_attribute9 in varchar2 default hr_api.g_varchar2,
1891: p_attribute10 in varchar2 default hr_api.g_varchar2,
1892: p_attribute11 in varchar2 default hr_api.g_varchar2,
1893: p_attribute12 in varchar2 default hr_api.g_varchar2,
1894: p_attribute13 in varchar2 default hr_api.g_varchar2,
1895: p_attribute14 in varchar2 default hr_api.g_varchar2,
1896: p_attribute15 in varchar2 default hr_api.g_varchar2,
1897: p_attribute16 in varchar2 default hr_api.g_varchar2,
1898: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 1895: p_attribute14 in varchar2 default hr_api.g_varchar2,

1891: p_attribute10 in varchar2 default hr_api.g_varchar2,
1892: p_attribute11 in varchar2 default hr_api.g_varchar2,
1893: p_attribute12 in varchar2 default hr_api.g_varchar2,
1894: p_attribute13 in varchar2 default hr_api.g_varchar2,
1895: p_attribute14 in varchar2 default hr_api.g_varchar2,
1896: p_attribute15 in varchar2 default hr_api.g_varchar2,
1897: p_attribute16 in varchar2 default hr_api.g_varchar2,
1898: p_attribute17 in varchar2 default hr_api.g_varchar2,
1899: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 1896: p_attribute15 in varchar2 default hr_api.g_varchar2,

1892: p_attribute11 in varchar2 default hr_api.g_varchar2,
1893: p_attribute12 in varchar2 default hr_api.g_varchar2,
1894: p_attribute13 in varchar2 default hr_api.g_varchar2,
1895: p_attribute14 in varchar2 default hr_api.g_varchar2,
1896: p_attribute15 in varchar2 default hr_api.g_varchar2,
1897: p_attribute16 in varchar2 default hr_api.g_varchar2,
1898: p_attribute17 in varchar2 default hr_api.g_varchar2,
1899: p_attribute18 in varchar2 default hr_api.g_varchar2,
1900: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 1897: p_attribute16 in varchar2 default hr_api.g_varchar2,

1893: p_attribute12 in varchar2 default hr_api.g_varchar2,
1894: p_attribute13 in varchar2 default hr_api.g_varchar2,
1895: p_attribute14 in varchar2 default hr_api.g_varchar2,
1896: p_attribute15 in varchar2 default hr_api.g_varchar2,
1897: p_attribute16 in varchar2 default hr_api.g_varchar2,
1898: p_attribute17 in varchar2 default hr_api.g_varchar2,
1899: p_attribute18 in varchar2 default hr_api.g_varchar2,
1900: p_attribute19 in varchar2 default hr_api.g_varchar2,
1901: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 1898: p_attribute17 in varchar2 default hr_api.g_varchar2,

1894: p_attribute13 in varchar2 default hr_api.g_varchar2,
1895: p_attribute14 in varchar2 default hr_api.g_varchar2,
1896: p_attribute15 in varchar2 default hr_api.g_varchar2,
1897: p_attribute16 in varchar2 default hr_api.g_varchar2,
1898: p_attribute17 in varchar2 default hr_api.g_varchar2,
1899: p_attribute18 in varchar2 default hr_api.g_varchar2,
1900: p_attribute19 in varchar2 default hr_api.g_varchar2,
1901: p_attribute20 in varchar2 default hr_api.g_varchar2,
1902: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 1899: p_attribute18 in varchar2 default hr_api.g_varchar2,

1895: p_attribute14 in varchar2 default hr_api.g_varchar2,
1896: p_attribute15 in varchar2 default hr_api.g_varchar2,
1897: p_attribute16 in varchar2 default hr_api.g_varchar2,
1898: p_attribute17 in varchar2 default hr_api.g_varchar2,
1899: p_attribute18 in varchar2 default hr_api.g_varchar2,
1900: p_attribute19 in varchar2 default hr_api.g_varchar2,
1901: p_attribute20 in varchar2 default hr_api.g_varchar2,
1902: p_attribute21 in varchar2 default hr_api.g_varchar2,
1903: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 1900: p_attribute19 in varchar2 default hr_api.g_varchar2,

1896: p_attribute15 in varchar2 default hr_api.g_varchar2,
1897: p_attribute16 in varchar2 default hr_api.g_varchar2,
1898: p_attribute17 in varchar2 default hr_api.g_varchar2,
1899: p_attribute18 in varchar2 default hr_api.g_varchar2,
1900: p_attribute19 in varchar2 default hr_api.g_varchar2,
1901: p_attribute20 in varchar2 default hr_api.g_varchar2,
1902: p_attribute21 in varchar2 default hr_api.g_varchar2,
1903: p_attribute22 in varchar2 default hr_api.g_varchar2,
1904: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 1901: p_attribute20 in varchar2 default hr_api.g_varchar2,

1897: p_attribute16 in varchar2 default hr_api.g_varchar2,
1898: p_attribute17 in varchar2 default hr_api.g_varchar2,
1899: p_attribute18 in varchar2 default hr_api.g_varchar2,
1900: p_attribute19 in varchar2 default hr_api.g_varchar2,
1901: p_attribute20 in varchar2 default hr_api.g_varchar2,
1902: p_attribute21 in varchar2 default hr_api.g_varchar2,
1903: p_attribute22 in varchar2 default hr_api.g_varchar2,
1904: p_attribute23 in varchar2 default hr_api.g_varchar2,
1905: p_attribute24 in varchar2 default hr_api.g_varchar2,

Line 1902: p_attribute21 in varchar2 default hr_api.g_varchar2,

1898: p_attribute17 in varchar2 default hr_api.g_varchar2,
1899: p_attribute18 in varchar2 default hr_api.g_varchar2,
1900: p_attribute19 in varchar2 default hr_api.g_varchar2,
1901: p_attribute20 in varchar2 default hr_api.g_varchar2,
1902: p_attribute21 in varchar2 default hr_api.g_varchar2,
1903: p_attribute22 in varchar2 default hr_api.g_varchar2,
1904: p_attribute23 in varchar2 default hr_api.g_varchar2,
1905: p_attribute24 in varchar2 default hr_api.g_varchar2,
1906: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 1903: p_attribute22 in varchar2 default hr_api.g_varchar2,

1899: p_attribute18 in varchar2 default hr_api.g_varchar2,
1900: p_attribute19 in varchar2 default hr_api.g_varchar2,
1901: p_attribute20 in varchar2 default hr_api.g_varchar2,
1902: p_attribute21 in varchar2 default hr_api.g_varchar2,
1903: p_attribute22 in varchar2 default hr_api.g_varchar2,
1904: p_attribute23 in varchar2 default hr_api.g_varchar2,
1905: p_attribute24 in varchar2 default hr_api.g_varchar2,
1906: p_attribute25 in varchar2 default hr_api.g_varchar2,
1907: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 1904: p_attribute23 in varchar2 default hr_api.g_varchar2,

1900: p_attribute19 in varchar2 default hr_api.g_varchar2,
1901: p_attribute20 in varchar2 default hr_api.g_varchar2,
1902: p_attribute21 in varchar2 default hr_api.g_varchar2,
1903: p_attribute22 in varchar2 default hr_api.g_varchar2,
1904: p_attribute23 in varchar2 default hr_api.g_varchar2,
1905: p_attribute24 in varchar2 default hr_api.g_varchar2,
1906: p_attribute25 in varchar2 default hr_api.g_varchar2,
1907: p_attribute26 in varchar2 default hr_api.g_varchar2,
1908: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 1905: p_attribute24 in varchar2 default hr_api.g_varchar2,

1901: p_attribute20 in varchar2 default hr_api.g_varchar2,
1902: p_attribute21 in varchar2 default hr_api.g_varchar2,
1903: p_attribute22 in varchar2 default hr_api.g_varchar2,
1904: p_attribute23 in varchar2 default hr_api.g_varchar2,
1905: p_attribute24 in varchar2 default hr_api.g_varchar2,
1906: p_attribute25 in varchar2 default hr_api.g_varchar2,
1907: p_attribute26 in varchar2 default hr_api.g_varchar2,
1908: p_attribute27 in varchar2 default hr_api.g_varchar2,
1909: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 1906: p_attribute25 in varchar2 default hr_api.g_varchar2,

1902: p_attribute21 in varchar2 default hr_api.g_varchar2,
1903: p_attribute22 in varchar2 default hr_api.g_varchar2,
1904: p_attribute23 in varchar2 default hr_api.g_varchar2,
1905: p_attribute24 in varchar2 default hr_api.g_varchar2,
1906: p_attribute25 in varchar2 default hr_api.g_varchar2,
1907: p_attribute26 in varchar2 default hr_api.g_varchar2,
1908: p_attribute27 in varchar2 default hr_api.g_varchar2,
1909: p_attribute28 in varchar2 default hr_api.g_varchar2,
1910: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 1907: p_attribute26 in varchar2 default hr_api.g_varchar2,

1903: p_attribute22 in varchar2 default hr_api.g_varchar2,
1904: p_attribute23 in varchar2 default hr_api.g_varchar2,
1905: p_attribute24 in varchar2 default hr_api.g_varchar2,
1906: p_attribute25 in varchar2 default hr_api.g_varchar2,
1907: p_attribute26 in varchar2 default hr_api.g_varchar2,
1908: p_attribute27 in varchar2 default hr_api.g_varchar2,
1909: p_attribute28 in varchar2 default hr_api.g_varchar2,
1910: p_attribute29 in varchar2 default hr_api.g_varchar2,
1911: p_attribute30 in varchar2 default hr_api.g_varchar2,

Line 1908: p_attribute27 in varchar2 default hr_api.g_varchar2,

1904: p_attribute23 in varchar2 default hr_api.g_varchar2,
1905: p_attribute24 in varchar2 default hr_api.g_varchar2,
1906: p_attribute25 in varchar2 default hr_api.g_varchar2,
1907: p_attribute26 in varchar2 default hr_api.g_varchar2,
1908: p_attribute27 in varchar2 default hr_api.g_varchar2,
1909: p_attribute28 in varchar2 default hr_api.g_varchar2,
1910: p_attribute29 in varchar2 default hr_api.g_varchar2,
1911: p_attribute30 in varchar2 default hr_api.g_varchar2,
1912: p_per_information_category in varchar2 default hr_api.g_varchar2,

Line 1909: p_attribute28 in varchar2 default hr_api.g_varchar2,

1905: p_attribute24 in varchar2 default hr_api.g_varchar2,
1906: p_attribute25 in varchar2 default hr_api.g_varchar2,
1907: p_attribute26 in varchar2 default hr_api.g_varchar2,
1908: p_attribute27 in varchar2 default hr_api.g_varchar2,
1909: p_attribute28 in varchar2 default hr_api.g_varchar2,
1910: p_attribute29 in varchar2 default hr_api.g_varchar2,
1911: p_attribute30 in varchar2 default hr_api.g_varchar2,
1912: p_per_information_category in varchar2 default hr_api.g_varchar2,
1913: p_per_information1 in varchar2 default hr_api.g_varchar2,

Line 1910: p_attribute29 in varchar2 default hr_api.g_varchar2,

1906: p_attribute25 in varchar2 default hr_api.g_varchar2,
1907: p_attribute26 in varchar2 default hr_api.g_varchar2,
1908: p_attribute27 in varchar2 default hr_api.g_varchar2,
1909: p_attribute28 in varchar2 default hr_api.g_varchar2,
1910: p_attribute29 in varchar2 default hr_api.g_varchar2,
1911: p_attribute30 in varchar2 default hr_api.g_varchar2,
1912: p_per_information_category in varchar2 default hr_api.g_varchar2,
1913: p_per_information1 in varchar2 default hr_api.g_varchar2,
1914: p_per_information2 in varchar2 default hr_api.g_varchar2,

Line 1911: p_attribute30 in varchar2 default hr_api.g_varchar2,

1907: p_attribute26 in varchar2 default hr_api.g_varchar2,
1908: p_attribute27 in varchar2 default hr_api.g_varchar2,
1909: p_attribute28 in varchar2 default hr_api.g_varchar2,
1910: p_attribute29 in varchar2 default hr_api.g_varchar2,
1911: p_attribute30 in varchar2 default hr_api.g_varchar2,
1912: p_per_information_category in varchar2 default hr_api.g_varchar2,
1913: p_per_information1 in varchar2 default hr_api.g_varchar2,
1914: p_per_information2 in varchar2 default hr_api.g_varchar2,
1915: p_per_information3 in varchar2 default hr_api.g_varchar2,

Line 1912: p_per_information_category in varchar2 default hr_api.g_varchar2,

1908: p_attribute27 in varchar2 default hr_api.g_varchar2,
1909: p_attribute28 in varchar2 default hr_api.g_varchar2,
1910: p_attribute29 in varchar2 default hr_api.g_varchar2,
1911: p_attribute30 in varchar2 default hr_api.g_varchar2,
1912: p_per_information_category in varchar2 default hr_api.g_varchar2,
1913: p_per_information1 in varchar2 default hr_api.g_varchar2,
1914: p_per_information2 in varchar2 default hr_api.g_varchar2,
1915: p_per_information3 in varchar2 default hr_api.g_varchar2,
1916: p_per_information4 in varchar2 default hr_api.g_varchar2,

Line 1913: p_per_information1 in varchar2 default hr_api.g_varchar2,

1909: p_attribute28 in varchar2 default hr_api.g_varchar2,
1910: p_attribute29 in varchar2 default hr_api.g_varchar2,
1911: p_attribute30 in varchar2 default hr_api.g_varchar2,
1912: p_per_information_category in varchar2 default hr_api.g_varchar2,
1913: p_per_information1 in varchar2 default hr_api.g_varchar2,
1914: p_per_information2 in varchar2 default hr_api.g_varchar2,
1915: p_per_information3 in varchar2 default hr_api.g_varchar2,
1916: p_per_information4 in varchar2 default hr_api.g_varchar2,
1917: p_per_information5 in varchar2 default hr_api.g_varchar2,

Line 1914: p_per_information2 in varchar2 default hr_api.g_varchar2,

1910: p_attribute29 in varchar2 default hr_api.g_varchar2,
1911: p_attribute30 in varchar2 default hr_api.g_varchar2,
1912: p_per_information_category in varchar2 default hr_api.g_varchar2,
1913: p_per_information1 in varchar2 default hr_api.g_varchar2,
1914: p_per_information2 in varchar2 default hr_api.g_varchar2,
1915: p_per_information3 in varchar2 default hr_api.g_varchar2,
1916: p_per_information4 in varchar2 default hr_api.g_varchar2,
1917: p_per_information5 in varchar2 default hr_api.g_varchar2,
1918: p_per_information6 in varchar2 default hr_api.g_varchar2,

Line 1915: p_per_information3 in varchar2 default hr_api.g_varchar2,

1911: p_attribute30 in varchar2 default hr_api.g_varchar2,
1912: p_per_information_category in varchar2 default hr_api.g_varchar2,
1913: p_per_information1 in varchar2 default hr_api.g_varchar2,
1914: p_per_information2 in varchar2 default hr_api.g_varchar2,
1915: p_per_information3 in varchar2 default hr_api.g_varchar2,
1916: p_per_information4 in varchar2 default hr_api.g_varchar2,
1917: p_per_information5 in varchar2 default hr_api.g_varchar2,
1918: p_per_information6 in varchar2 default hr_api.g_varchar2,
1919: p_per_information7 in varchar2 default hr_api.g_varchar2,

Line 1916: p_per_information4 in varchar2 default hr_api.g_varchar2,

1912: p_per_information_category in varchar2 default hr_api.g_varchar2,
1913: p_per_information1 in varchar2 default hr_api.g_varchar2,
1914: p_per_information2 in varchar2 default hr_api.g_varchar2,
1915: p_per_information3 in varchar2 default hr_api.g_varchar2,
1916: p_per_information4 in varchar2 default hr_api.g_varchar2,
1917: p_per_information5 in varchar2 default hr_api.g_varchar2,
1918: p_per_information6 in varchar2 default hr_api.g_varchar2,
1919: p_per_information7 in varchar2 default hr_api.g_varchar2,
1920: p_per_information8 in varchar2 default hr_api.g_varchar2,

Line 1917: p_per_information5 in varchar2 default hr_api.g_varchar2,

1913: p_per_information1 in varchar2 default hr_api.g_varchar2,
1914: p_per_information2 in varchar2 default hr_api.g_varchar2,
1915: p_per_information3 in varchar2 default hr_api.g_varchar2,
1916: p_per_information4 in varchar2 default hr_api.g_varchar2,
1917: p_per_information5 in varchar2 default hr_api.g_varchar2,
1918: p_per_information6 in varchar2 default hr_api.g_varchar2,
1919: p_per_information7 in varchar2 default hr_api.g_varchar2,
1920: p_per_information8 in varchar2 default hr_api.g_varchar2,
1921: p_per_information9 in varchar2 default hr_api.g_varchar2,

Line 1918: p_per_information6 in varchar2 default hr_api.g_varchar2,

1914: p_per_information2 in varchar2 default hr_api.g_varchar2,
1915: p_per_information3 in varchar2 default hr_api.g_varchar2,
1916: p_per_information4 in varchar2 default hr_api.g_varchar2,
1917: p_per_information5 in varchar2 default hr_api.g_varchar2,
1918: p_per_information6 in varchar2 default hr_api.g_varchar2,
1919: p_per_information7 in varchar2 default hr_api.g_varchar2,
1920: p_per_information8 in varchar2 default hr_api.g_varchar2,
1921: p_per_information9 in varchar2 default hr_api.g_varchar2,
1922: p_per_information10 in varchar2 default hr_api.g_varchar2,

Line 1919: p_per_information7 in varchar2 default hr_api.g_varchar2,

1915: p_per_information3 in varchar2 default hr_api.g_varchar2,
1916: p_per_information4 in varchar2 default hr_api.g_varchar2,
1917: p_per_information5 in varchar2 default hr_api.g_varchar2,
1918: p_per_information6 in varchar2 default hr_api.g_varchar2,
1919: p_per_information7 in varchar2 default hr_api.g_varchar2,
1920: p_per_information8 in varchar2 default hr_api.g_varchar2,
1921: p_per_information9 in varchar2 default hr_api.g_varchar2,
1922: p_per_information10 in varchar2 default hr_api.g_varchar2,
1923: p_per_information11 in varchar2 default hr_api.g_varchar2,

Line 1920: p_per_information8 in varchar2 default hr_api.g_varchar2,

1916: p_per_information4 in varchar2 default hr_api.g_varchar2,
1917: p_per_information5 in varchar2 default hr_api.g_varchar2,
1918: p_per_information6 in varchar2 default hr_api.g_varchar2,
1919: p_per_information7 in varchar2 default hr_api.g_varchar2,
1920: p_per_information8 in varchar2 default hr_api.g_varchar2,
1921: p_per_information9 in varchar2 default hr_api.g_varchar2,
1922: p_per_information10 in varchar2 default hr_api.g_varchar2,
1923: p_per_information11 in varchar2 default hr_api.g_varchar2,
1924: p_per_information12 in varchar2 default hr_api.g_varchar2,

Line 1921: p_per_information9 in varchar2 default hr_api.g_varchar2,

1917: p_per_information5 in varchar2 default hr_api.g_varchar2,
1918: p_per_information6 in varchar2 default hr_api.g_varchar2,
1919: p_per_information7 in varchar2 default hr_api.g_varchar2,
1920: p_per_information8 in varchar2 default hr_api.g_varchar2,
1921: p_per_information9 in varchar2 default hr_api.g_varchar2,
1922: p_per_information10 in varchar2 default hr_api.g_varchar2,
1923: p_per_information11 in varchar2 default hr_api.g_varchar2,
1924: p_per_information12 in varchar2 default hr_api.g_varchar2,
1925: p_per_information13 in varchar2 default hr_api.g_varchar2,

Line 1922: p_per_information10 in varchar2 default hr_api.g_varchar2,

1918: p_per_information6 in varchar2 default hr_api.g_varchar2,
1919: p_per_information7 in varchar2 default hr_api.g_varchar2,
1920: p_per_information8 in varchar2 default hr_api.g_varchar2,
1921: p_per_information9 in varchar2 default hr_api.g_varchar2,
1922: p_per_information10 in varchar2 default hr_api.g_varchar2,
1923: p_per_information11 in varchar2 default hr_api.g_varchar2,
1924: p_per_information12 in varchar2 default hr_api.g_varchar2,
1925: p_per_information13 in varchar2 default hr_api.g_varchar2,
1926: p_per_information14 in varchar2 default hr_api.g_varchar2,

Line 1923: p_per_information11 in varchar2 default hr_api.g_varchar2,

1919: p_per_information7 in varchar2 default hr_api.g_varchar2,
1920: p_per_information8 in varchar2 default hr_api.g_varchar2,
1921: p_per_information9 in varchar2 default hr_api.g_varchar2,
1922: p_per_information10 in varchar2 default hr_api.g_varchar2,
1923: p_per_information11 in varchar2 default hr_api.g_varchar2,
1924: p_per_information12 in varchar2 default hr_api.g_varchar2,
1925: p_per_information13 in varchar2 default hr_api.g_varchar2,
1926: p_per_information14 in varchar2 default hr_api.g_varchar2,
1927: p_per_information15 in varchar2 default hr_api.g_varchar2,

Line 1924: p_per_information12 in varchar2 default hr_api.g_varchar2,

1920: p_per_information8 in varchar2 default hr_api.g_varchar2,
1921: p_per_information9 in varchar2 default hr_api.g_varchar2,
1922: p_per_information10 in varchar2 default hr_api.g_varchar2,
1923: p_per_information11 in varchar2 default hr_api.g_varchar2,
1924: p_per_information12 in varchar2 default hr_api.g_varchar2,
1925: p_per_information13 in varchar2 default hr_api.g_varchar2,
1926: p_per_information14 in varchar2 default hr_api.g_varchar2,
1927: p_per_information15 in varchar2 default hr_api.g_varchar2,
1928: p_per_information16 in varchar2 default hr_api.g_varchar2,

Line 1925: p_per_information13 in varchar2 default hr_api.g_varchar2,

1921: p_per_information9 in varchar2 default hr_api.g_varchar2,
1922: p_per_information10 in varchar2 default hr_api.g_varchar2,
1923: p_per_information11 in varchar2 default hr_api.g_varchar2,
1924: p_per_information12 in varchar2 default hr_api.g_varchar2,
1925: p_per_information13 in varchar2 default hr_api.g_varchar2,
1926: p_per_information14 in varchar2 default hr_api.g_varchar2,
1927: p_per_information15 in varchar2 default hr_api.g_varchar2,
1928: p_per_information16 in varchar2 default hr_api.g_varchar2,
1929: p_per_information17 in varchar2 default hr_api.g_varchar2,

Line 1926: p_per_information14 in varchar2 default hr_api.g_varchar2,

1922: p_per_information10 in varchar2 default hr_api.g_varchar2,
1923: p_per_information11 in varchar2 default hr_api.g_varchar2,
1924: p_per_information12 in varchar2 default hr_api.g_varchar2,
1925: p_per_information13 in varchar2 default hr_api.g_varchar2,
1926: p_per_information14 in varchar2 default hr_api.g_varchar2,
1927: p_per_information15 in varchar2 default hr_api.g_varchar2,
1928: p_per_information16 in varchar2 default hr_api.g_varchar2,
1929: p_per_information17 in varchar2 default hr_api.g_varchar2,
1930: p_per_information18 in varchar2 default hr_api.g_varchar2,

Line 1927: p_per_information15 in varchar2 default hr_api.g_varchar2,

1923: p_per_information11 in varchar2 default hr_api.g_varchar2,
1924: p_per_information12 in varchar2 default hr_api.g_varchar2,
1925: p_per_information13 in varchar2 default hr_api.g_varchar2,
1926: p_per_information14 in varchar2 default hr_api.g_varchar2,
1927: p_per_information15 in varchar2 default hr_api.g_varchar2,
1928: p_per_information16 in varchar2 default hr_api.g_varchar2,
1929: p_per_information17 in varchar2 default hr_api.g_varchar2,
1930: p_per_information18 in varchar2 default hr_api.g_varchar2,
1931: p_per_information19 in varchar2 default hr_api.g_varchar2,

Line 1928: p_per_information16 in varchar2 default hr_api.g_varchar2,

1924: p_per_information12 in varchar2 default hr_api.g_varchar2,
1925: p_per_information13 in varchar2 default hr_api.g_varchar2,
1926: p_per_information14 in varchar2 default hr_api.g_varchar2,
1927: p_per_information15 in varchar2 default hr_api.g_varchar2,
1928: p_per_information16 in varchar2 default hr_api.g_varchar2,
1929: p_per_information17 in varchar2 default hr_api.g_varchar2,
1930: p_per_information18 in varchar2 default hr_api.g_varchar2,
1931: p_per_information19 in varchar2 default hr_api.g_varchar2,
1932: p_per_information20 in varchar2 default hr_api.g_varchar2,

Line 1929: p_per_information17 in varchar2 default hr_api.g_varchar2,

1925: p_per_information13 in varchar2 default hr_api.g_varchar2,
1926: p_per_information14 in varchar2 default hr_api.g_varchar2,
1927: p_per_information15 in varchar2 default hr_api.g_varchar2,
1928: p_per_information16 in varchar2 default hr_api.g_varchar2,
1929: p_per_information17 in varchar2 default hr_api.g_varchar2,
1930: p_per_information18 in varchar2 default hr_api.g_varchar2,
1931: p_per_information19 in varchar2 default hr_api.g_varchar2,
1932: p_per_information20 in varchar2 default hr_api.g_varchar2,
1933: p_suffix in varchar2 default hr_api.g_varchar2,

Line 1930: p_per_information18 in varchar2 default hr_api.g_varchar2,

1926: p_per_information14 in varchar2 default hr_api.g_varchar2,
1927: p_per_information15 in varchar2 default hr_api.g_varchar2,
1928: p_per_information16 in varchar2 default hr_api.g_varchar2,
1929: p_per_information17 in varchar2 default hr_api.g_varchar2,
1930: p_per_information18 in varchar2 default hr_api.g_varchar2,
1931: p_per_information19 in varchar2 default hr_api.g_varchar2,
1932: p_per_information20 in varchar2 default hr_api.g_varchar2,
1933: p_suffix in varchar2 default hr_api.g_varchar2,
1934: p_DATE_OF_DEATH in date default hr_api.g_date,

Line 1931: p_per_information19 in varchar2 default hr_api.g_varchar2,

1927: p_per_information15 in varchar2 default hr_api.g_varchar2,
1928: p_per_information16 in varchar2 default hr_api.g_varchar2,
1929: p_per_information17 in varchar2 default hr_api.g_varchar2,
1930: p_per_information18 in varchar2 default hr_api.g_varchar2,
1931: p_per_information19 in varchar2 default hr_api.g_varchar2,
1932: p_per_information20 in varchar2 default hr_api.g_varchar2,
1933: p_suffix in varchar2 default hr_api.g_varchar2,
1934: p_DATE_OF_DEATH in date default hr_api.g_date,
1935: p_BACKGROUND_CHECK_STATUS in varchar2 default hr_api.g_varchar2,

Line 1932: p_per_information20 in varchar2 default hr_api.g_varchar2,

1928: p_per_information16 in varchar2 default hr_api.g_varchar2,
1929: p_per_information17 in varchar2 default hr_api.g_varchar2,
1930: p_per_information18 in varchar2 default hr_api.g_varchar2,
1931: p_per_information19 in varchar2 default hr_api.g_varchar2,
1932: p_per_information20 in varchar2 default hr_api.g_varchar2,
1933: p_suffix in varchar2 default hr_api.g_varchar2,
1934: p_DATE_OF_DEATH in date default hr_api.g_date,
1935: p_BACKGROUND_CHECK_STATUS in varchar2 default hr_api.g_varchar2,
1936: p_BACKGROUND_DATE_CHECK in date default hr_api.g_date,

Line 1933: p_suffix in varchar2 default hr_api.g_varchar2,

1929: p_per_information17 in varchar2 default hr_api.g_varchar2,
1930: p_per_information18 in varchar2 default hr_api.g_varchar2,
1931: p_per_information19 in varchar2 default hr_api.g_varchar2,
1932: p_per_information20 in varchar2 default hr_api.g_varchar2,
1933: p_suffix in varchar2 default hr_api.g_varchar2,
1934: p_DATE_OF_DEATH in date default hr_api.g_date,
1935: p_BACKGROUND_CHECK_STATUS in varchar2 default hr_api.g_varchar2,
1936: p_BACKGROUND_DATE_CHECK in date default hr_api.g_date,
1937: p_BLOOD_TYPE in varchar2 default hr_api.g_varchar2,

Line 1934: p_DATE_OF_DEATH in date default hr_api.g_date,

1930: p_per_information18 in varchar2 default hr_api.g_varchar2,
1931: p_per_information19 in varchar2 default hr_api.g_varchar2,
1932: p_per_information20 in varchar2 default hr_api.g_varchar2,
1933: p_suffix in varchar2 default hr_api.g_varchar2,
1934: p_DATE_OF_DEATH in date default hr_api.g_date,
1935: p_BACKGROUND_CHECK_STATUS in varchar2 default hr_api.g_varchar2,
1936: p_BACKGROUND_DATE_CHECK in date default hr_api.g_date,
1937: p_BLOOD_TYPE in varchar2 default hr_api.g_varchar2,
1938: p_CORRESPONDENCE_LANGUAGE in varchar2 default hr_api.g_varchar2,

Line 1935: p_BACKGROUND_CHECK_STATUS in varchar2 default hr_api.g_varchar2,

1931: p_per_information19 in varchar2 default hr_api.g_varchar2,
1932: p_per_information20 in varchar2 default hr_api.g_varchar2,
1933: p_suffix in varchar2 default hr_api.g_varchar2,
1934: p_DATE_OF_DEATH in date default hr_api.g_date,
1935: p_BACKGROUND_CHECK_STATUS in varchar2 default hr_api.g_varchar2,
1936: p_BACKGROUND_DATE_CHECK in date default hr_api.g_date,
1937: p_BLOOD_TYPE in varchar2 default hr_api.g_varchar2,
1938: p_CORRESPONDENCE_LANGUAGE in varchar2 default hr_api.g_varchar2,
1939: p_FAST_PATH_EMPLOYEE in varchar2 default hr_api.g_varchar2,

Line 1936: p_BACKGROUND_DATE_CHECK in date default hr_api.g_date,

1932: p_per_information20 in varchar2 default hr_api.g_varchar2,
1933: p_suffix in varchar2 default hr_api.g_varchar2,
1934: p_DATE_OF_DEATH in date default hr_api.g_date,
1935: p_BACKGROUND_CHECK_STATUS in varchar2 default hr_api.g_varchar2,
1936: p_BACKGROUND_DATE_CHECK in date default hr_api.g_date,
1937: p_BLOOD_TYPE in varchar2 default hr_api.g_varchar2,
1938: p_CORRESPONDENCE_LANGUAGE in varchar2 default hr_api.g_varchar2,
1939: p_FAST_PATH_EMPLOYEE in varchar2 default hr_api.g_varchar2,
1940: p_FTE_CAPACITY in number default hr_api.g_number,

Line 1937: p_BLOOD_TYPE in varchar2 default hr_api.g_varchar2,

1933: p_suffix in varchar2 default hr_api.g_varchar2,
1934: p_DATE_OF_DEATH in date default hr_api.g_date,
1935: p_BACKGROUND_CHECK_STATUS in varchar2 default hr_api.g_varchar2,
1936: p_BACKGROUND_DATE_CHECK in date default hr_api.g_date,
1937: p_BLOOD_TYPE in varchar2 default hr_api.g_varchar2,
1938: p_CORRESPONDENCE_LANGUAGE in varchar2 default hr_api.g_varchar2,
1939: p_FAST_PATH_EMPLOYEE in varchar2 default hr_api.g_varchar2,
1940: p_FTE_CAPACITY in number default hr_api.g_number,
1941: p_HOLD_APPLICANT_DATE_UNTIL in date default hr_api.g_date,

Line 1938: p_CORRESPONDENCE_LANGUAGE in varchar2 default hr_api.g_varchar2,

1934: p_DATE_OF_DEATH in date default hr_api.g_date,
1935: p_BACKGROUND_CHECK_STATUS in varchar2 default hr_api.g_varchar2,
1936: p_BACKGROUND_DATE_CHECK in date default hr_api.g_date,
1937: p_BLOOD_TYPE in varchar2 default hr_api.g_varchar2,
1938: p_CORRESPONDENCE_LANGUAGE in varchar2 default hr_api.g_varchar2,
1939: p_FAST_PATH_EMPLOYEE in varchar2 default hr_api.g_varchar2,
1940: p_FTE_CAPACITY in number default hr_api.g_number,
1941: p_HOLD_APPLICANT_DATE_UNTIL in date default hr_api.g_date,
1942: p_HONORS in varchar2 default hr_api.g_varchar2,

Line 1939: p_FAST_PATH_EMPLOYEE in varchar2 default hr_api.g_varchar2,

1935: p_BACKGROUND_CHECK_STATUS in varchar2 default hr_api.g_varchar2,
1936: p_BACKGROUND_DATE_CHECK in date default hr_api.g_date,
1937: p_BLOOD_TYPE in varchar2 default hr_api.g_varchar2,
1938: p_CORRESPONDENCE_LANGUAGE in varchar2 default hr_api.g_varchar2,
1939: p_FAST_PATH_EMPLOYEE in varchar2 default hr_api.g_varchar2,
1940: p_FTE_CAPACITY in number default hr_api.g_number,
1941: p_HOLD_APPLICANT_DATE_UNTIL in date default hr_api.g_date,
1942: p_HONORS in varchar2 default hr_api.g_varchar2,
1943: p_INTERNAL_LOCATION in varchar2 default hr_api.g_varchar2,

Line 1940: p_FTE_CAPACITY in number default hr_api.g_number,

1936: p_BACKGROUND_DATE_CHECK in date default hr_api.g_date,
1937: p_BLOOD_TYPE in varchar2 default hr_api.g_varchar2,
1938: p_CORRESPONDENCE_LANGUAGE in varchar2 default hr_api.g_varchar2,
1939: p_FAST_PATH_EMPLOYEE in varchar2 default hr_api.g_varchar2,
1940: p_FTE_CAPACITY in number default hr_api.g_number,
1941: p_HOLD_APPLICANT_DATE_UNTIL in date default hr_api.g_date,
1942: p_HONORS in varchar2 default hr_api.g_varchar2,
1943: p_INTERNAL_LOCATION in varchar2 default hr_api.g_varchar2,
1944: p_LAST_MEDICAL_TEST_BY in varchar2 default hr_api.g_varchar2,

Line 1941: p_HOLD_APPLICANT_DATE_UNTIL in date default hr_api.g_date,

1937: p_BLOOD_TYPE in varchar2 default hr_api.g_varchar2,
1938: p_CORRESPONDENCE_LANGUAGE in varchar2 default hr_api.g_varchar2,
1939: p_FAST_PATH_EMPLOYEE in varchar2 default hr_api.g_varchar2,
1940: p_FTE_CAPACITY in number default hr_api.g_number,
1941: p_HOLD_APPLICANT_DATE_UNTIL in date default hr_api.g_date,
1942: p_HONORS in varchar2 default hr_api.g_varchar2,
1943: p_INTERNAL_LOCATION in varchar2 default hr_api.g_varchar2,
1944: p_LAST_MEDICAL_TEST_BY in varchar2 default hr_api.g_varchar2,
1945: p_LAST_MEDICAL_TEST_DATE in date default hr_api.g_date,

Line 1942: p_HONORS in varchar2 default hr_api.g_varchar2,

1938: p_CORRESPONDENCE_LANGUAGE in varchar2 default hr_api.g_varchar2,
1939: p_FAST_PATH_EMPLOYEE in varchar2 default hr_api.g_varchar2,
1940: p_FTE_CAPACITY in number default hr_api.g_number,
1941: p_HOLD_APPLICANT_DATE_UNTIL in date default hr_api.g_date,
1942: p_HONORS in varchar2 default hr_api.g_varchar2,
1943: p_INTERNAL_LOCATION in varchar2 default hr_api.g_varchar2,
1944: p_LAST_MEDICAL_TEST_BY in varchar2 default hr_api.g_varchar2,
1945: p_LAST_MEDICAL_TEST_DATE in date default hr_api.g_date,
1946: p_MAILSTOP in varchar2 default hr_api.g_varchar2,

Line 1943: p_INTERNAL_LOCATION in varchar2 default hr_api.g_varchar2,

1939: p_FAST_PATH_EMPLOYEE in varchar2 default hr_api.g_varchar2,
1940: p_FTE_CAPACITY in number default hr_api.g_number,
1941: p_HOLD_APPLICANT_DATE_UNTIL in date default hr_api.g_date,
1942: p_HONORS in varchar2 default hr_api.g_varchar2,
1943: p_INTERNAL_LOCATION in varchar2 default hr_api.g_varchar2,
1944: p_LAST_MEDICAL_TEST_BY in varchar2 default hr_api.g_varchar2,
1945: p_LAST_MEDICAL_TEST_DATE in date default hr_api.g_date,
1946: p_MAILSTOP in varchar2 default hr_api.g_varchar2,
1947: p_OFFICE_NUMBER in varchar2 default hr_api.g_varchar2,

Line 1944: p_LAST_MEDICAL_TEST_BY in varchar2 default hr_api.g_varchar2,

1940: p_FTE_CAPACITY in number default hr_api.g_number,
1941: p_HOLD_APPLICANT_DATE_UNTIL in date default hr_api.g_date,
1942: p_HONORS in varchar2 default hr_api.g_varchar2,
1943: p_INTERNAL_LOCATION in varchar2 default hr_api.g_varchar2,
1944: p_LAST_MEDICAL_TEST_BY in varchar2 default hr_api.g_varchar2,
1945: p_LAST_MEDICAL_TEST_DATE in date default hr_api.g_date,
1946: p_MAILSTOP in varchar2 default hr_api.g_varchar2,
1947: p_OFFICE_NUMBER in varchar2 default hr_api.g_varchar2,
1948: p_ON_MILITARY_SERVICE in varchar2 default hr_api.g_varchar2,

Line 1945: p_LAST_MEDICAL_TEST_DATE in date default hr_api.g_date,

1941: p_HOLD_APPLICANT_DATE_UNTIL in date default hr_api.g_date,
1942: p_HONORS in varchar2 default hr_api.g_varchar2,
1943: p_INTERNAL_LOCATION in varchar2 default hr_api.g_varchar2,
1944: p_LAST_MEDICAL_TEST_BY in varchar2 default hr_api.g_varchar2,
1945: p_LAST_MEDICAL_TEST_DATE in date default hr_api.g_date,
1946: p_MAILSTOP in varchar2 default hr_api.g_varchar2,
1947: p_OFFICE_NUMBER in varchar2 default hr_api.g_varchar2,
1948: p_ON_MILITARY_SERVICE in varchar2 default hr_api.g_varchar2,
1949: p_ORDER_NAME in varchar2 default hr_api.g_varchar2,

Line 1946: p_MAILSTOP in varchar2 default hr_api.g_varchar2,

1942: p_HONORS in varchar2 default hr_api.g_varchar2,
1943: p_INTERNAL_LOCATION in varchar2 default hr_api.g_varchar2,
1944: p_LAST_MEDICAL_TEST_BY in varchar2 default hr_api.g_varchar2,
1945: p_LAST_MEDICAL_TEST_DATE in date default hr_api.g_date,
1946: p_MAILSTOP in varchar2 default hr_api.g_varchar2,
1947: p_OFFICE_NUMBER in varchar2 default hr_api.g_varchar2,
1948: p_ON_MILITARY_SERVICE in varchar2 default hr_api.g_varchar2,
1949: p_ORDER_NAME in varchar2 default hr_api.g_varchar2,
1950: p_PRE_NAME_ADJUNCT in varchar2 default hr_api.g_varchar2,

Line 1947: p_OFFICE_NUMBER in varchar2 default hr_api.g_varchar2,

1943: p_INTERNAL_LOCATION in varchar2 default hr_api.g_varchar2,
1944: p_LAST_MEDICAL_TEST_BY in varchar2 default hr_api.g_varchar2,
1945: p_LAST_MEDICAL_TEST_DATE in date default hr_api.g_date,
1946: p_MAILSTOP in varchar2 default hr_api.g_varchar2,
1947: p_OFFICE_NUMBER in varchar2 default hr_api.g_varchar2,
1948: p_ON_MILITARY_SERVICE in varchar2 default hr_api.g_varchar2,
1949: p_ORDER_NAME in varchar2 default hr_api.g_varchar2,
1950: p_PRE_NAME_ADJUNCT in varchar2 default hr_api.g_varchar2,
1951: p_PROJECTED_START_DATE in date default hr_api.g_date,

Line 1948: p_ON_MILITARY_SERVICE in varchar2 default hr_api.g_varchar2,

1944: p_LAST_MEDICAL_TEST_BY in varchar2 default hr_api.g_varchar2,
1945: p_LAST_MEDICAL_TEST_DATE in date default hr_api.g_date,
1946: p_MAILSTOP in varchar2 default hr_api.g_varchar2,
1947: p_OFFICE_NUMBER in varchar2 default hr_api.g_varchar2,
1948: p_ON_MILITARY_SERVICE in varchar2 default hr_api.g_varchar2,
1949: p_ORDER_NAME in varchar2 default hr_api.g_varchar2,
1950: p_PRE_NAME_ADJUNCT in varchar2 default hr_api.g_varchar2,
1951: p_PROJECTED_START_DATE in date default hr_api.g_date,
1952: p_REHIRE_AUTHORIZOR in varchar2 default hr_api.g_varchar2,

Line 1949: p_ORDER_NAME in varchar2 default hr_api.g_varchar2,

1945: p_LAST_MEDICAL_TEST_DATE in date default hr_api.g_date,
1946: p_MAILSTOP in varchar2 default hr_api.g_varchar2,
1947: p_OFFICE_NUMBER in varchar2 default hr_api.g_varchar2,
1948: p_ON_MILITARY_SERVICE in varchar2 default hr_api.g_varchar2,
1949: p_ORDER_NAME in varchar2 default hr_api.g_varchar2,
1950: p_PRE_NAME_ADJUNCT in varchar2 default hr_api.g_varchar2,
1951: p_PROJECTED_START_DATE in date default hr_api.g_date,
1952: p_REHIRE_AUTHORIZOR in varchar2 default hr_api.g_varchar2,
1953: p_REHIRE_RECOMMENDATION in varchar2 default hr_api.g_varchar2,

Line 1950: p_PRE_NAME_ADJUNCT in varchar2 default hr_api.g_varchar2,

1946: p_MAILSTOP in varchar2 default hr_api.g_varchar2,
1947: p_OFFICE_NUMBER in varchar2 default hr_api.g_varchar2,
1948: p_ON_MILITARY_SERVICE in varchar2 default hr_api.g_varchar2,
1949: p_ORDER_NAME in varchar2 default hr_api.g_varchar2,
1950: p_PRE_NAME_ADJUNCT in varchar2 default hr_api.g_varchar2,
1951: p_PROJECTED_START_DATE in date default hr_api.g_date,
1952: p_REHIRE_AUTHORIZOR in varchar2 default hr_api.g_varchar2,
1953: p_REHIRE_RECOMMENDATION in varchar2 default hr_api.g_varchar2,
1954: p_RESUME_EXISTS in varchar2 default hr_api.g_varchar2,

Line 1951: p_PROJECTED_START_DATE in date default hr_api.g_date,

1947: p_OFFICE_NUMBER in varchar2 default hr_api.g_varchar2,
1948: p_ON_MILITARY_SERVICE in varchar2 default hr_api.g_varchar2,
1949: p_ORDER_NAME in varchar2 default hr_api.g_varchar2,
1950: p_PRE_NAME_ADJUNCT in varchar2 default hr_api.g_varchar2,
1951: p_PROJECTED_START_DATE in date default hr_api.g_date,
1952: p_REHIRE_AUTHORIZOR in varchar2 default hr_api.g_varchar2,
1953: p_REHIRE_RECOMMENDATION in varchar2 default hr_api.g_varchar2,
1954: p_RESUME_EXISTS in varchar2 default hr_api.g_varchar2,
1955: p_RESUME_LAST_UPDATED in date default hr_api.g_date,

Line 1952: p_REHIRE_AUTHORIZOR in varchar2 default hr_api.g_varchar2,

1948: p_ON_MILITARY_SERVICE in varchar2 default hr_api.g_varchar2,
1949: p_ORDER_NAME in varchar2 default hr_api.g_varchar2,
1950: p_PRE_NAME_ADJUNCT in varchar2 default hr_api.g_varchar2,
1951: p_PROJECTED_START_DATE in date default hr_api.g_date,
1952: p_REHIRE_AUTHORIZOR in varchar2 default hr_api.g_varchar2,
1953: p_REHIRE_RECOMMENDATION in varchar2 default hr_api.g_varchar2,
1954: p_RESUME_EXISTS in varchar2 default hr_api.g_varchar2,
1955: p_RESUME_LAST_UPDATED in date default hr_api.g_date,
1956: p_SECOND_PASSPORT_EXISTS in varchar2 default hr_api.g_varchar2,

Line 1953: p_REHIRE_RECOMMENDATION in varchar2 default hr_api.g_varchar2,

1949: p_ORDER_NAME in varchar2 default hr_api.g_varchar2,
1950: p_PRE_NAME_ADJUNCT in varchar2 default hr_api.g_varchar2,
1951: p_PROJECTED_START_DATE in date default hr_api.g_date,
1952: p_REHIRE_AUTHORIZOR in varchar2 default hr_api.g_varchar2,
1953: p_REHIRE_RECOMMENDATION in varchar2 default hr_api.g_varchar2,
1954: p_RESUME_EXISTS in varchar2 default hr_api.g_varchar2,
1955: p_RESUME_LAST_UPDATED in date default hr_api.g_date,
1956: p_SECOND_PASSPORT_EXISTS in varchar2 default hr_api.g_varchar2,
1957: p_STUDENT_STATUS in varchar2 default hr_api.g_varchar2,

Line 1954: p_RESUME_EXISTS in varchar2 default hr_api.g_varchar2,

1950: p_PRE_NAME_ADJUNCT in varchar2 default hr_api.g_varchar2,
1951: p_PROJECTED_START_DATE in date default hr_api.g_date,
1952: p_REHIRE_AUTHORIZOR in varchar2 default hr_api.g_varchar2,
1953: p_REHIRE_RECOMMENDATION in varchar2 default hr_api.g_varchar2,
1954: p_RESUME_EXISTS in varchar2 default hr_api.g_varchar2,
1955: p_RESUME_LAST_UPDATED in date default hr_api.g_date,
1956: p_SECOND_PASSPORT_EXISTS in varchar2 default hr_api.g_varchar2,
1957: p_STUDENT_STATUS in varchar2 default hr_api.g_varchar2,
1958: p_WORK_SCHEDULE in varchar2 default hr_api.g_varchar2,

Line 1955: p_RESUME_LAST_UPDATED in date default hr_api.g_date,

1951: p_PROJECTED_START_DATE in date default hr_api.g_date,
1952: p_REHIRE_AUTHORIZOR in varchar2 default hr_api.g_varchar2,
1953: p_REHIRE_RECOMMENDATION in varchar2 default hr_api.g_varchar2,
1954: p_RESUME_EXISTS in varchar2 default hr_api.g_varchar2,
1955: p_RESUME_LAST_UPDATED in date default hr_api.g_date,
1956: p_SECOND_PASSPORT_EXISTS in varchar2 default hr_api.g_varchar2,
1957: p_STUDENT_STATUS in varchar2 default hr_api.g_varchar2,
1958: p_WORK_SCHEDULE in varchar2 default hr_api.g_varchar2,
1959: p_PER_INFORMATION21 in varchar2 default hr_api.g_varchar2,

Line 1956: p_SECOND_PASSPORT_EXISTS in varchar2 default hr_api.g_varchar2,

1952: p_REHIRE_AUTHORIZOR in varchar2 default hr_api.g_varchar2,
1953: p_REHIRE_RECOMMENDATION in varchar2 default hr_api.g_varchar2,
1954: p_RESUME_EXISTS in varchar2 default hr_api.g_varchar2,
1955: p_RESUME_LAST_UPDATED in date default hr_api.g_date,
1956: p_SECOND_PASSPORT_EXISTS in varchar2 default hr_api.g_varchar2,
1957: p_STUDENT_STATUS in varchar2 default hr_api.g_varchar2,
1958: p_WORK_SCHEDULE in varchar2 default hr_api.g_varchar2,
1959: p_PER_INFORMATION21 in varchar2 default hr_api.g_varchar2,
1960: p_PER_INFORMATION22 in varchar2 default hr_api.g_varchar2,

Line 1957: p_STUDENT_STATUS in varchar2 default hr_api.g_varchar2,

1953: p_REHIRE_RECOMMENDATION in varchar2 default hr_api.g_varchar2,
1954: p_RESUME_EXISTS in varchar2 default hr_api.g_varchar2,
1955: p_RESUME_LAST_UPDATED in date default hr_api.g_date,
1956: p_SECOND_PASSPORT_EXISTS in varchar2 default hr_api.g_varchar2,
1957: p_STUDENT_STATUS in varchar2 default hr_api.g_varchar2,
1958: p_WORK_SCHEDULE in varchar2 default hr_api.g_varchar2,
1959: p_PER_INFORMATION21 in varchar2 default hr_api.g_varchar2,
1960: p_PER_INFORMATION22 in varchar2 default hr_api.g_varchar2,
1961: p_PER_INFORMATION23 in varchar2 default hr_api.g_varchar2,

Line 1958: p_WORK_SCHEDULE in varchar2 default hr_api.g_varchar2,

1954: p_RESUME_EXISTS in varchar2 default hr_api.g_varchar2,
1955: p_RESUME_LAST_UPDATED in date default hr_api.g_date,
1956: p_SECOND_PASSPORT_EXISTS in varchar2 default hr_api.g_varchar2,
1957: p_STUDENT_STATUS in varchar2 default hr_api.g_varchar2,
1958: p_WORK_SCHEDULE in varchar2 default hr_api.g_varchar2,
1959: p_PER_INFORMATION21 in varchar2 default hr_api.g_varchar2,
1960: p_PER_INFORMATION22 in varchar2 default hr_api.g_varchar2,
1961: p_PER_INFORMATION23 in varchar2 default hr_api.g_varchar2,
1962: p_PER_INFORMATION24 in varchar2 default hr_api.g_varchar2,

Line 1959: p_PER_INFORMATION21 in varchar2 default hr_api.g_varchar2,

1955: p_RESUME_LAST_UPDATED in date default hr_api.g_date,
1956: p_SECOND_PASSPORT_EXISTS in varchar2 default hr_api.g_varchar2,
1957: p_STUDENT_STATUS in varchar2 default hr_api.g_varchar2,
1958: p_WORK_SCHEDULE in varchar2 default hr_api.g_varchar2,
1959: p_PER_INFORMATION21 in varchar2 default hr_api.g_varchar2,
1960: p_PER_INFORMATION22 in varchar2 default hr_api.g_varchar2,
1961: p_PER_INFORMATION23 in varchar2 default hr_api.g_varchar2,
1962: p_PER_INFORMATION24 in varchar2 default hr_api.g_varchar2,
1963: p_PER_INFORMATION25 in varchar2 default hr_api.g_varchar2,

Line 1960: p_PER_INFORMATION22 in varchar2 default hr_api.g_varchar2,

1956: p_SECOND_PASSPORT_EXISTS in varchar2 default hr_api.g_varchar2,
1957: p_STUDENT_STATUS in varchar2 default hr_api.g_varchar2,
1958: p_WORK_SCHEDULE in varchar2 default hr_api.g_varchar2,
1959: p_PER_INFORMATION21 in varchar2 default hr_api.g_varchar2,
1960: p_PER_INFORMATION22 in varchar2 default hr_api.g_varchar2,
1961: p_PER_INFORMATION23 in varchar2 default hr_api.g_varchar2,
1962: p_PER_INFORMATION24 in varchar2 default hr_api.g_varchar2,
1963: p_PER_INFORMATION25 in varchar2 default hr_api.g_varchar2,
1964: p_PER_INFORMATION26 in varchar2 default hr_api.g_varchar2,

Line 1961: p_PER_INFORMATION23 in varchar2 default hr_api.g_varchar2,

1957: p_STUDENT_STATUS in varchar2 default hr_api.g_varchar2,
1958: p_WORK_SCHEDULE in varchar2 default hr_api.g_varchar2,
1959: p_PER_INFORMATION21 in varchar2 default hr_api.g_varchar2,
1960: p_PER_INFORMATION22 in varchar2 default hr_api.g_varchar2,
1961: p_PER_INFORMATION23 in varchar2 default hr_api.g_varchar2,
1962: p_PER_INFORMATION24 in varchar2 default hr_api.g_varchar2,
1963: p_PER_INFORMATION25 in varchar2 default hr_api.g_varchar2,
1964: p_PER_INFORMATION26 in varchar2 default hr_api.g_varchar2,
1965: p_PER_INFORMATION27 in varchar2 default hr_api.g_varchar2,

Line 1962: p_PER_INFORMATION24 in varchar2 default hr_api.g_varchar2,

1958: p_WORK_SCHEDULE in varchar2 default hr_api.g_varchar2,
1959: p_PER_INFORMATION21 in varchar2 default hr_api.g_varchar2,
1960: p_PER_INFORMATION22 in varchar2 default hr_api.g_varchar2,
1961: p_PER_INFORMATION23 in varchar2 default hr_api.g_varchar2,
1962: p_PER_INFORMATION24 in varchar2 default hr_api.g_varchar2,
1963: p_PER_INFORMATION25 in varchar2 default hr_api.g_varchar2,
1964: p_PER_INFORMATION26 in varchar2 default hr_api.g_varchar2,
1965: p_PER_INFORMATION27 in varchar2 default hr_api.g_varchar2,
1966: p_PER_INFORMATION28 in varchar2 default hr_api.g_varchar2,

Line 1963: p_PER_INFORMATION25 in varchar2 default hr_api.g_varchar2,

1959: p_PER_INFORMATION21 in varchar2 default hr_api.g_varchar2,
1960: p_PER_INFORMATION22 in varchar2 default hr_api.g_varchar2,
1961: p_PER_INFORMATION23 in varchar2 default hr_api.g_varchar2,
1962: p_PER_INFORMATION24 in varchar2 default hr_api.g_varchar2,
1963: p_PER_INFORMATION25 in varchar2 default hr_api.g_varchar2,
1964: p_PER_INFORMATION26 in varchar2 default hr_api.g_varchar2,
1965: p_PER_INFORMATION27 in varchar2 default hr_api.g_varchar2,
1966: p_PER_INFORMATION28 in varchar2 default hr_api.g_varchar2,
1967: p_PER_INFORMATION29 in varchar2 default hr_api.g_varchar2,

Line 1964: p_PER_INFORMATION26 in varchar2 default hr_api.g_varchar2,

1960: p_PER_INFORMATION22 in varchar2 default hr_api.g_varchar2,
1961: p_PER_INFORMATION23 in varchar2 default hr_api.g_varchar2,
1962: p_PER_INFORMATION24 in varchar2 default hr_api.g_varchar2,
1963: p_PER_INFORMATION25 in varchar2 default hr_api.g_varchar2,
1964: p_PER_INFORMATION26 in varchar2 default hr_api.g_varchar2,
1965: p_PER_INFORMATION27 in varchar2 default hr_api.g_varchar2,
1966: p_PER_INFORMATION28 in varchar2 default hr_api.g_varchar2,
1967: p_PER_INFORMATION29 in varchar2 default hr_api.g_varchar2,
1968: p_PER_INFORMATION30 in varchar2 default hr_api.g_varchar2,

Line 1965: p_PER_INFORMATION27 in varchar2 default hr_api.g_varchar2,

1961: p_PER_INFORMATION23 in varchar2 default hr_api.g_varchar2,
1962: p_PER_INFORMATION24 in varchar2 default hr_api.g_varchar2,
1963: p_PER_INFORMATION25 in varchar2 default hr_api.g_varchar2,
1964: p_PER_INFORMATION26 in varchar2 default hr_api.g_varchar2,
1965: p_PER_INFORMATION27 in varchar2 default hr_api.g_varchar2,
1966: p_PER_INFORMATION28 in varchar2 default hr_api.g_varchar2,
1967: p_PER_INFORMATION29 in varchar2 default hr_api.g_varchar2,
1968: p_PER_INFORMATION30 in varchar2 default hr_api.g_varchar2,
1969: p_REHIRE_REASON in varchar2 default hr_api.g_varchar2,

Line 1966: p_PER_INFORMATION28 in varchar2 default hr_api.g_varchar2,

1962: p_PER_INFORMATION24 in varchar2 default hr_api.g_varchar2,
1963: p_PER_INFORMATION25 in varchar2 default hr_api.g_varchar2,
1964: p_PER_INFORMATION26 in varchar2 default hr_api.g_varchar2,
1965: p_PER_INFORMATION27 in varchar2 default hr_api.g_varchar2,
1966: p_PER_INFORMATION28 in varchar2 default hr_api.g_varchar2,
1967: p_PER_INFORMATION29 in varchar2 default hr_api.g_varchar2,
1968: p_PER_INFORMATION30 in varchar2 default hr_api.g_varchar2,
1969: p_REHIRE_REASON in varchar2 default hr_api.g_varchar2,
1970: p_BENEFIT_GROUP_ID in number default hr_api.g_number,

Line 1967: p_PER_INFORMATION29 in varchar2 default hr_api.g_varchar2,

1963: p_PER_INFORMATION25 in varchar2 default hr_api.g_varchar2,
1964: p_PER_INFORMATION26 in varchar2 default hr_api.g_varchar2,
1965: p_PER_INFORMATION27 in varchar2 default hr_api.g_varchar2,
1966: p_PER_INFORMATION28 in varchar2 default hr_api.g_varchar2,
1967: p_PER_INFORMATION29 in varchar2 default hr_api.g_varchar2,
1968: p_PER_INFORMATION30 in varchar2 default hr_api.g_varchar2,
1969: p_REHIRE_REASON in varchar2 default hr_api.g_varchar2,
1970: p_BENEFIT_GROUP_ID in number default hr_api.g_number,
1971: p_RECEIPT_OF_DEATH_CERT_DATE in date default hr_api.g_date,

Line 1968: p_PER_INFORMATION30 in varchar2 default hr_api.g_varchar2,

1964: p_PER_INFORMATION26 in varchar2 default hr_api.g_varchar2,
1965: p_PER_INFORMATION27 in varchar2 default hr_api.g_varchar2,
1966: p_PER_INFORMATION28 in varchar2 default hr_api.g_varchar2,
1967: p_PER_INFORMATION29 in varchar2 default hr_api.g_varchar2,
1968: p_PER_INFORMATION30 in varchar2 default hr_api.g_varchar2,
1969: p_REHIRE_REASON in varchar2 default hr_api.g_varchar2,
1970: p_BENEFIT_GROUP_ID in number default hr_api.g_number,
1971: p_RECEIPT_OF_DEATH_CERT_DATE in date default hr_api.g_date,
1972: p_COORD_BEN_MED_PLN_NO in varchar2 default hr_api.g_varchar2,

Line 1969: p_REHIRE_REASON in varchar2 default hr_api.g_varchar2,

1965: p_PER_INFORMATION27 in varchar2 default hr_api.g_varchar2,
1966: p_PER_INFORMATION28 in varchar2 default hr_api.g_varchar2,
1967: p_PER_INFORMATION29 in varchar2 default hr_api.g_varchar2,
1968: p_PER_INFORMATION30 in varchar2 default hr_api.g_varchar2,
1969: p_REHIRE_REASON in varchar2 default hr_api.g_varchar2,
1970: p_BENEFIT_GROUP_ID in number default hr_api.g_number,
1971: p_RECEIPT_OF_DEATH_CERT_DATE in date default hr_api.g_date,
1972: p_COORD_BEN_MED_PLN_NO in varchar2 default hr_api.g_varchar2,
1973: p_COORD_BEN_NO_CVG_FLAG in varchar2 default hr_api.g_varchar2,

Line 1970: p_BENEFIT_GROUP_ID in number default hr_api.g_number,

1966: p_PER_INFORMATION28 in varchar2 default hr_api.g_varchar2,
1967: p_PER_INFORMATION29 in varchar2 default hr_api.g_varchar2,
1968: p_PER_INFORMATION30 in varchar2 default hr_api.g_varchar2,
1969: p_REHIRE_REASON in varchar2 default hr_api.g_varchar2,
1970: p_BENEFIT_GROUP_ID in number default hr_api.g_number,
1971: p_RECEIPT_OF_DEATH_CERT_DATE in date default hr_api.g_date,
1972: p_COORD_BEN_MED_PLN_NO in varchar2 default hr_api.g_varchar2,
1973: p_COORD_BEN_NO_CVG_FLAG in varchar2 default hr_api.g_varchar2,
1974: p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,

Line 1971: p_RECEIPT_OF_DEATH_CERT_DATE in date default hr_api.g_date,

1967: p_PER_INFORMATION29 in varchar2 default hr_api.g_varchar2,
1968: p_PER_INFORMATION30 in varchar2 default hr_api.g_varchar2,
1969: p_REHIRE_REASON in varchar2 default hr_api.g_varchar2,
1970: p_BENEFIT_GROUP_ID in number default hr_api.g_number,
1971: p_RECEIPT_OF_DEATH_CERT_DATE in date default hr_api.g_date,
1972: p_COORD_BEN_MED_PLN_NO in varchar2 default hr_api.g_varchar2,
1973: p_COORD_BEN_NO_CVG_FLAG in varchar2 default hr_api.g_varchar2,
1974: p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,
1975: p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,

Line 1972: p_COORD_BEN_MED_PLN_NO in varchar2 default hr_api.g_varchar2,

1968: p_PER_INFORMATION30 in varchar2 default hr_api.g_varchar2,
1969: p_REHIRE_REASON in varchar2 default hr_api.g_varchar2,
1970: p_BENEFIT_GROUP_ID in number default hr_api.g_number,
1971: p_RECEIPT_OF_DEATH_CERT_DATE in date default hr_api.g_date,
1972: p_COORD_BEN_MED_PLN_NO in varchar2 default hr_api.g_varchar2,
1973: p_COORD_BEN_NO_CVG_FLAG in varchar2 default hr_api.g_varchar2,
1974: p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,
1975: p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,
1976: p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,

Line 1973: p_COORD_BEN_NO_CVG_FLAG in varchar2 default hr_api.g_varchar2,

1969: p_REHIRE_REASON in varchar2 default hr_api.g_varchar2,
1970: p_BENEFIT_GROUP_ID in number default hr_api.g_number,
1971: p_RECEIPT_OF_DEATH_CERT_DATE in date default hr_api.g_date,
1972: p_COORD_BEN_MED_PLN_NO in varchar2 default hr_api.g_varchar2,
1973: p_COORD_BEN_NO_CVG_FLAG in varchar2 default hr_api.g_varchar2,
1974: p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,
1975: p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,
1976: p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,
1977: p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,

Line 1974: p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,

1970: p_BENEFIT_GROUP_ID in number default hr_api.g_number,
1971: p_RECEIPT_OF_DEATH_CERT_DATE in date default hr_api.g_date,
1972: p_COORD_BEN_MED_PLN_NO in varchar2 default hr_api.g_varchar2,
1973: p_COORD_BEN_NO_CVG_FLAG in varchar2 default hr_api.g_varchar2,
1974: p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,
1975: p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,
1976: p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,
1977: p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,
1978: p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,

Line 1975: p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,

1971: p_RECEIPT_OF_DEATH_CERT_DATE in date default hr_api.g_date,
1972: p_COORD_BEN_MED_PLN_NO in varchar2 default hr_api.g_varchar2,
1973: p_COORD_BEN_NO_CVG_FLAG in varchar2 default hr_api.g_varchar2,
1974: p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,
1975: p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,
1976: p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,
1977: p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,
1978: p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,
1979: p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,

Line 1976: p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,

1972: p_COORD_BEN_MED_PLN_NO in varchar2 default hr_api.g_varchar2,
1973: p_COORD_BEN_NO_CVG_FLAG in varchar2 default hr_api.g_varchar2,
1974: p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,
1975: p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,
1976: p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,
1977: p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,
1978: p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,
1979: p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,
1980: p_USES_TOBACCO_FLAG in varchar2 default hr_api.g_varchar2,

Line 1977: p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,

1973: p_COORD_BEN_NO_CVG_FLAG in varchar2 default hr_api.g_varchar2,
1974: p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,
1975: p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,
1976: p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,
1977: p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,
1978: p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,
1979: p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,
1980: p_USES_TOBACCO_FLAG in varchar2 default hr_api.g_varchar2,
1981: p_DPDNT_ADOPTION_DATE in date default hr_api.g_date,

Line 1978: p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,

1974: p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,
1975: p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,
1976: p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,
1977: p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,
1978: p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,
1979: p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,
1980: p_USES_TOBACCO_FLAG in varchar2 default hr_api.g_varchar2,
1981: p_DPDNT_ADOPTION_DATE in date default hr_api.g_date,
1982: p_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default hr_api.g_varchar2,

Line 1979: p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,

1975: p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,
1976: p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,
1977: p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,
1978: p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,
1979: p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,
1980: p_USES_TOBACCO_FLAG in varchar2 default hr_api.g_varchar2,
1981: p_DPDNT_ADOPTION_DATE in date default hr_api.g_date,
1982: p_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default hr_api.g_varchar2,
1983: p_ORIGINAL_DATE_OF_HIRE in date default hr_api.g_date,

Line 1980: p_USES_TOBACCO_FLAG in varchar2 default hr_api.g_varchar2,

1976: p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,
1977: p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,
1978: p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,
1979: p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,
1980: p_USES_TOBACCO_FLAG in varchar2 default hr_api.g_varchar2,
1981: p_DPDNT_ADOPTION_DATE in date default hr_api.g_date,
1982: p_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default hr_api.g_varchar2,
1983: p_ORIGINAL_DATE_OF_HIRE in date default hr_api.g_date,
1984: p_town_of_birth in varchar2 default hr_api.g_varchar2,

Line 1981: p_DPDNT_ADOPTION_DATE in date default hr_api.g_date,

1977: p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,
1978: p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,
1979: p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,
1980: p_USES_TOBACCO_FLAG in varchar2 default hr_api.g_varchar2,
1981: p_DPDNT_ADOPTION_DATE in date default hr_api.g_date,
1982: p_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default hr_api.g_varchar2,
1983: p_ORIGINAL_DATE_OF_HIRE in date default hr_api.g_date,
1984: p_town_of_birth in varchar2 default hr_api.g_varchar2,
1985: p_region_of_birth in varchar2 default hr_api.g_varchar2,

Line 1982: p_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default hr_api.g_varchar2,

1978: p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,
1979: p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,
1980: p_USES_TOBACCO_FLAG in varchar2 default hr_api.g_varchar2,
1981: p_DPDNT_ADOPTION_DATE in date default hr_api.g_date,
1982: p_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default hr_api.g_varchar2,
1983: p_ORIGINAL_DATE_OF_HIRE in date default hr_api.g_date,
1984: p_town_of_birth in varchar2 default hr_api.g_varchar2,
1985: p_region_of_birth in varchar2 default hr_api.g_varchar2,
1986: p_country_of_birth in varchar2 default hr_api.g_varchar2,

Line 1983: p_ORIGINAL_DATE_OF_HIRE in date default hr_api.g_date,

1979: p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,
1980: p_USES_TOBACCO_FLAG in varchar2 default hr_api.g_varchar2,
1981: p_DPDNT_ADOPTION_DATE in date default hr_api.g_date,
1982: p_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default hr_api.g_varchar2,
1983: p_ORIGINAL_DATE_OF_HIRE in date default hr_api.g_date,
1984: p_town_of_birth in varchar2 default hr_api.g_varchar2,
1985: p_region_of_birth in varchar2 default hr_api.g_varchar2,
1986: p_country_of_birth in varchar2 default hr_api.g_varchar2,
1987: p_global_person_id in varchar2 default hr_api.g_varchar2,

Line 1984: p_town_of_birth in varchar2 default hr_api.g_varchar2,

1980: p_USES_TOBACCO_FLAG in varchar2 default hr_api.g_varchar2,
1981: p_DPDNT_ADOPTION_DATE in date default hr_api.g_date,
1982: p_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default hr_api.g_varchar2,
1983: p_ORIGINAL_DATE_OF_HIRE in date default hr_api.g_date,
1984: p_town_of_birth in varchar2 default hr_api.g_varchar2,
1985: p_region_of_birth in varchar2 default hr_api.g_varchar2,
1986: p_country_of_birth in varchar2 default hr_api.g_varchar2,
1987: p_global_person_id in varchar2 default hr_api.g_varchar2,
1988: p_party_id in number default hr_api.g_number,

Line 1985: p_region_of_birth in varchar2 default hr_api.g_varchar2,

1981: p_DPDNT_ADOPTION_DATE in date default hr_api.g_date,
1982: p_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default hr_api.g_varchar2,
1983: p_ORIGINAL_DATE_OF_HIRE in date default hr_api.g_date,
1984: p_town_of_birth in varchar2 default hr_api.g_varchar2,
1985: p_region_of_birth in varchar2 default hr_api.g_varchar2,
1986: p_country_of_birth in varchar2 default hr_api.g_varchar2,
1987: p_global_person_id in varchar2 default hr_api.g_varchar2,
1988: p_party_id in number default hr_api.g_number,
1989: p_npw_number in out nocopy varchar2,

Line 1986: p_country_of_birth in varchar2 default hr_api.g_varchar2,

1982: p_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default hr_api.g_varchar2,
1983: p_ORIGINAL_DATE_OF_HIRE in date default hr_api.g_date,
1984: p_town_of_birth in varchar2 default hr_api.g_varchar2,
1985: p_region_of_birth in varchar2 default hr_api.g_varchar2,
1986: p_country_of_birth in varchar2 default hr_api.g_varchar2,
1987: p_global_person_id in varchar2 default hr_api.g_varchar2,
1988: p_party_id in number default hr_api.g_number,
1989: p_npw_number in out nocopy varchar2,
1990: p_current_npw_flag in varchar2 default hr_api.g_varchar2,

Line 1987: p_global_person_id in varchar2 default hr_api.g_varchar2,

1983: p_ORIGINAL_DATE_OF_HIRE in date default hr_api.g_date,
1984: p_town_of_birth in varchar2 default hr_api.g_varchar2,
1985: p_region_of_birth in varchar2 default hr_api.g_varchar2,
1986: p_country_of_birth in varchar2 default hr_api.g_varchar2,
1987: p_global_person_id in varchar2 default hr_api.g_varchar2,
1988: p_party_id in number default hr_api.g_number,
1989: p_npw_number in out nocopy varchar2,
1990: p_current_npw_flag in varchar2 default hr_api.g_varchar2,
1991: p_object_version_number in out nocopy number,

Line 1988: p_party_id in number default hr_api.g_number,

1984: p_town_of_birth in varchar2 default hr_api.g_varchar2,
1985: p_region_of_birth in varchar2 default hr_api.g_varchar2,
1986: p_country_of_birth in varchar2 default hr_api.g_varchar2,
1987: p_global_person_id in varchar2 default hr_api.g_varchar2,
1988: p_party_id in number default hr_api.g_number,
1989: p_npw_number in out nocopy varchar2,
1990: p_current_npw_flag in varchar2 default hr_api.g_varchar2,
1991: p_object_version_number in out nocopy number,
1992: p_effective_date in date,

Line 1990: p_current_npw_flag in varchar2 default hr_api.g_varchar2,

1986: p_country_of_birth in varchar2 default hr_api.g_varchar2,
1987: p_global_person_id in varchar2 default hr_api.g_varchar2,
1988: p_party_id in number default hr_api.g_number,
1989: p_npw_number in out nocopy varchar2,
1990: p_current_npw_flag in varchar2 default hr_api.g_varchar2,
1991: p_object_version_number in out nocopy number,
1992: p_effective_date in date,
1993: p_datetrack_mode in varchar2,
1994: p_validate in boolean default false,

Line 2015: hr_api.g_number,

2011: (
2012: p_person_id,
2013: null,
2014: null,
2015: hr_api.g_number,
2016: p_person_type_id,
2017: p_last_name,
2018: p_start_date,
2019: p_applicant_number,

Line 2020: hr_api.g_number,

2016: p_person_type_id,
2017: p_last_name,
2018: p_start_date,
2019: p_applicant_number,
2020: hr_api.g_number,
2021: p_comments,
2022: hr_api.g_varchar2,
2023: hr_api.g_varchar2,
2024: hr_api.g_varchar2,

Line 2022: hr_api.g_varchar2,

2018: p_start_date,
2019: p_applicant_number,
2020: hr_api.g_number,
2021: p_comments,
2022: hr_api.g_varchar2,
2023: hr_api.g_varchar2,
2024: hr_api.g_varchar2,
2025: p_date_employee_data_verified,
2026: p_date_of_birth,

Line 2023: hr_api.g_varchar2,

2019: p_applicant_number,
2020: hr_api.g_number,
2021: p_comments,
2022: hr_api.g_varchar2,
2023: hr_api.g_varchar2,
2024: hr_api.g_varchar2,
2025: p_date_employee_data_verified,
2026: p_date_of_birth,
2027: p_email_address,

Line 2024: hr_api.g_varchar2,

2020: hr_api.g_number,
2021: p_comments,
2022: hr_api.g_varchar2,
2023: hr_api.g_varchar2,
2024: hr_api.g_varchar2,
2025: p_date_employee_data_verified,
2026: p_date_of_birth,
2027: p_email_address,
2028: p_employee_number,