195: and effective_end_date = p_validation_end_date;
196: --
197:
198: -- Start of fix 518655
199: if nvl(per_asg_shd.g_old_rec.assignment_number, hr_api.g_varchar2) <>
200: nvl(p_rec.assignment_number, hr_api.g_varchar2) then
201: --
202: l_object_version_number := dt_api.get_object_version_number
203: (p_base_table_name => 'per_all_assignments_f',
196: --
197:
198: -- Start of fix 518655
199: if nvl(per_asg_shd.g_old_rec.assignment_number, hr_api.g_varchar2) <>
200: nvl(p_rec.assignment_number, hr_api.g_varchar2) then
201: --
202: l_object_version_number := dt_api.get_object_version_number
203: (p_base_table_name => 'per_all_assignments_f',
204: p_base_key_column => 'assignment_id',
224: End If;
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 15);
227: Exception
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: per_asg_shd.g_api_dml := false; -- Unset the api dml status
231: per_asg_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: per_asg_shd.g_api_dml := false; -- Unset the api dml status
231: per_asg_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: per_asg_shd.g_api_dml := false; -- Unset the api dml status
236: per_asg_shd.constraint_error
229: -- A check constraint has been violated
230: per_asg_shd.g_api_dml := false; -- Unset the api dml status
231: per_asg_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: per_asg_shd.g_api_dml := false; -- Unset the api dml status
236: per_asg_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: per_asg_shd.g_api_dml := false; -- Unset the api dml status
236: per_asg_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When Others Then
239: per_asg_shd.g_api_dml := false; -- Unset the api dml status
240: Raise;
241: End dt_update_dml;
962: ,p_projected_assignment_end_o
963: => per_asg_shd.g_old_rec.projected_assignment_end
964: );
965: exception
966: when hr_api.cannot_find_prog_unit then
967: hr_api.cannot_find_prog_unit_error
968: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'
969: ,p_hook_type => 'AU'
970: );
963: => per_asg_shd.g_old_rec.projected_assignment_end
964: );
965: exception
966: when hr_api.cannot_find_prog_unit then
967: hr_api.cannot_find_prog_unit_error
968: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'
969: ,p_hook_type => 'AU'
970: );
971: end;
1276: -- p_rec plsql record structure
1277: -- to see if a system default is being used. If a system default
1278: -- is being used then we must set to the 'current' argument value.
1279: --
1280: If (p_rec.business_group_id = hr_api.g_number) then
1281: p_rec.business_group_id :=
1282: per_asg_shd.g_old_rec.business_group_id;
1283: End If;
1284: If (p_rec.recruiter_id = hr_api.g_number) then
1280: If (p_rec.business_group_id = hr_api.g_number) then
1281: p_rec.business_group_id :=
1282: per_asg_shd.g_old_rec.business_group_id;
1283: End If;
1284: If (p_rec.recruiter_id = hr_api.g_number) then
1285: p_rec.recruiter_id :=
1286: per_asg_shd.g_old_rec.recruiter_id;
1287: End If;
1288: If (p_rec.grade_id = hr_api.g_number) then
1284: If (p_rec.recruiter_id = hr_api.g_number) then
1285: p_rec.recruiter_id :=
1286: per_asg_shd.g_old_rec.recruiter_id;
1287: End If;
1288: If (p_rec.grade_id = hr_api.g_number) then
1289: p_rec.grade_id :=
1290: per_asg_shd.g_old_rec.grade_id;
1291: End If;
1292: If (p_rec.position_id = hr_api.g_number) then
1288: If (p_rec.grade_id = hr_api.g_number) then
1289: p_rec.grade_id :=
1290: per_asg_shd.g_old_rec.grade_id;
1291: End If;
1292: If (p_rec.position_id = hr_api.g_number) then
1293: p_rec.position_id :=
1294: per_asg_shd.g_old_rec.position_id;
1295: End If;
1296: If (p_rec.job_id = hr_api.g_number) then
1292: If (p_rec.position_id = hr_api.g_number) then
1293: p_rec.position_id :=
1294: per_asg_shd.g_old_rec.position_id;
1295: End If;
1296: If (p_rec.job_id = hr_api.g_number) then
1297: p_rec.job_id :=
1298: per_asg_shd.g_old_rec.job_id;
1299: End If;
1300: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1296: If (p_rec.job_id = hr_api.g_number) then
1297: p_rec.job_id :=
1298: per_asg_shd.g_old_rec.job_id;
1299: End If;
1300: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1301: p_rec.assignment_status_type_id :=
1302: per_asg_shd.g_old_rec.assignment_status_type_id;
1303: End If;
1304: If (p_rec.payroll_id = hr_api.g_number) then
1300: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1301: p_rec.assignment_status_type_id :=
1302: per_asg_shd.g_old_rec.assignment_status_type_id;
1303: End If;
1304: If (p_rec.payroll_id = hr_api.g_number) then
1305: p_rec.payroll_id :=
1306: per_asg_shd.g_old_rec.payroll_id;
1307: End If;
1308: If (p_rec.location_id = hr_api.g_number) then
1304: If (p_rec.payroll_id = hr_api.g_number) then
1305: p_rec.payroll_id :=
1306: per_asg_shd.g_old_rec.payroll_id;
1307: End If;
1308: If (p_rec.location_id = hr_api.g_number) then
1309: p_rec.location_id :=
1310: per_asg_shd.g_old_rec.location_id;
1311: End If;
1312: If (p_rec.person_referred_by_id = hr_api.g_number) then
1308: If (p_rec.location_id = hr_api.g_number) then
1309: p_rec.location_id :=
1310: per_asg_shd.g_old_rec.location_id;
1311: End If;
1312: If (p_rec.person_referred_by_id = hr_api.g_number) then
1313: p_rec.person_referred_by_id :=
1314: per_asg_shd.g_old_rec.person_referred_by_id;
1315: End If;
1316: If (p_rec.supervisor_id = hr_api.g_number) then
1312: If (p_rec.person_referred_by_id = hr_api.g_number) then
1313: p_rec.person_referred_by_id :=
1314: per_asg_shd.g_old_rec.person_referred_by_id;
1315: End If;
1316: If (p_rec.supervisor_id = hr_api.g_number) then
1317: p_rec.supervisor_id :=
1318: per_asg_shd.g_old_rec.supervisor_id;
1319: End If;
1320: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1316: If (p_rec.supervisor_id = hr_api.g_number) then
1317: p_rec.supervisor_id :=
1318: per_asg_shd.g_old_rec.supervisor_id;
1319: End If;
1320: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1321: p_rec.special_ceiling_step_id :=
1322: per_asg_shd.g_old_rec.special_ceiling_step_id;
1323: End If;
1324: If (p_rec.person_id = hr_api.g_number) then
1320: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1321: p_rec.special_ceiling_step_id :=
1322: per_asg_shd.g_old_rec.special_ceiling_step_id;
1323: End If;
1324: If (p_rec.person_id = hr_api.g_number) then
1325: p_rec.person_id :=
1326: per_asg_shd.g_old_rec.person_id;
1327: End If;
1328: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1324: If (p_rec.person_id = hr_api.g_number) then
1325: p_rec.person_id :=
1326: per_asg_shd.g_old_rec.person_id;
1327: End If;
1328: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1329: p_rec.recruitment_activity_id :=
1330: per_asg_shd.g_old_rec.recruitment_activity_id;
1331: End If;
1332: If (p_rec.source_organization_id = hr_api.g_number) then
1328: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1329: p_rec.recruitment_activity_id :=
1330: per_asg_shd.g_old_rec.recruitment_activity_id;
1331: End If;
1332: If (p_rec.source_organization_id = hr_api.g_number) then
1333: p_rec.source_organization_id :=
1334: per_asg_shd.g_old_rec.source_organization_id;
1335: End If;
1336: If (p_rec.organization_id = hr_api.g_number) then
1332: If (p_rec.source_organization_id = hr_api.g_number) then
1333: p_rec.source_organization_id :=
1334: per_asg_shd.g_old_rec.source_organization_id;
1335: End If;
1336: If (p_rec.organization_id = hr_api.g_number) then
1337: p_rec.organization_id :=
1338: per_asg_shd.g_old_rec.organization_id;
1339: End If;
1340: If (p_rec.people_group_id = hr_api.g_number) then
1336: If (p_rec.organization_id = hr_api.g_number) then
1337: p_rec.organization_id :=
1338: per_asg_shd.g_old_rec.organization_id;
1339: End If;
1340: If (p_rec.people_group_id = hr_api.g_number) then
1341: p_rec.people_group_id :=
1342: per_asg_shd.g_old_rec.people_group_id;
1343: End If;
1344: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1340: If (p_rec.people_group_id = hr_api.g_number) then
1341: p_rec.people_group_id :=
1342: per_asg_shd.g_old_rec.people_group_id;
1343: End If;
1344: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1345: p_rec.soft_coding_keyflex_id :=
1346: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1347: End If;
1348: If (p_rec.vacancy_id = hr_api.g_number) then
1344: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1345: p_rec.soft_coding_keyflex_id :=
1346: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1347: End If;
1348: If (p_rec.vacancy_id = hr_api.g_number) then
1349: p_rec.vacancy_id :=
1350: per_asg_shd.g_old_rec.vacancy_id;
1351: End If;
1352: If (p_rec.pay_basis_id = hr_api.g_number) then
1348: If (p_rec.vacancy_id = hr_api.g_number) then
1349: p_rec.vacancy_id :=
1350: per_asg_shd.g_old_rec.vacancy_id;
1351: End If;
1352: If (p_rec.pay_basis_id = hr_api.g_number) then
1353: p_rec.pay_basis_id :=
1354: per_asg_shd.g_old_rec.pay_basis_id;
1355: End If;
1356: If (p_rec.assignment_sequence = hr_api.g_number) then
1352: If (p_rec.pay_basis_id = hr_api.g_number) then
1353: p_rec.pay_basis_id :=
1354: per_asg_shd.g_old_rec.pay_basis_id;
1355: End If;
1356: If (p_rec.assignment_sequence = hr_api.g_number) then
1357: p_rec.assignment_sequence :=
1358: per_asg_shd.g_old_rec.assignment_sequence;
1359: End If;
1360: If (p_rec.assignment_type = hr_api.g_varchar2) then
1356: If (p_rec.assignment_sequence = hr_api.g_number) then
1357: p_rec.assignment_sequence :=
1358: per_asg_shd.g_old_rec.assignment_sequence;
1359: End If;
1360: If (p_rec.assignment_type = hr_api.g_varchar2) then
1361: p_rec.assignment_type :=
1362: per_asg_shd.g_old_rec.assignment_type;
1363: End If;
1364: If (p_rec.primary_flag = hr_api.g_varchar2) then
1360: If (p_rec.assignment_type = hr_api.g_varchar2) then
1361: p_rec.assignment_type :=
1362: per_asg_shd.g_old_rec.assignment_type;
1363: End If;
1364: If (p_rec.primary_flag = hr_api.g_varchar2) then
1365: p_rec.primary_flag :=
1366: per_asg_shd.g_old_rec.primary_flag;
1367: End If;
1368: If (p_rec.application_id = hr_api.g_number) then
1364: If (p_rec.primary_flag = hr_api.g_varchar2) then
1365: p_rec.primary_flag :=
1366: per_asg_shd.g_old_rec.primary_flag;
1367: End If;
1368: If (p_rec.application_id = hr_api.g_number) then
1369: p_rec.application_id :=
1370: per_asg_shd.g_old_rec.application_id;
1371: End If;
1372: If (p_rec.assignment_number = hr_api.g_varchar2) then
1368: If (p_rec.application_id = hr_api.g_number) then
1369: p_rec.application_id :=
1370: per_asg_shd.g_old_rec.application_id;
1371: End If;
1372: If (p_rec.assignment_number = hr_api.g_varchar2) then
1373: p_rec.assignment_number :=
1374: per_asg_shd.g_old_rec.assignment_number;
1375: End If;
1376: If (p_rec.change_reason = hr_api.g_varchar2) then
1372: If (p_rec.assignment_number = hr_api.g_varchar2) then
1373: p_rec.assignment_number :=
1374: per_asg_shd.g_old_rec.assignment_number;
1375: End If;
1376: If (p_rec.change_reason = hr_api.g_varchar2) then
1377: p_rec.change_reason :=
1378: per_asg_shd.g_old_rec.change_reason;
1379: End If;
1380: If (p_rec.comment_id = hr_api.g_number) then
1376: If (p_rec.change_reason = hr_api.g_varchar2) then
1377: p_rec.change_reason :=
1378: per_asg_shd.g_old_rec.change_reason;
1379: End If;
1380: If (p_rec.comment_id = hr_api.g_number) then
1381: p_rec.comment_id :=
1382: per_asg_shd.g_old_rec.comment_id;
1383: End If;
1384: If (p_rec.comment_text = hr_api.g_varchar2) then
1380: If (p_rec.comment_id = hr_api.g_number) then
1381: p_rec.comment_id :=
1382: per_asg_shd.g_old_rec.comment_id;
1383: End If;
1384: If (p_rec.comment_text = hr_api.g_varchar2) then
1385: p_rec.comment_text :=
1386: per_asg_shd.g_old_rec.comment_text;
1387: End If;
1388: If (p_rec.date_probation_end = hr_api.g_date) then
1384: If (p_rec.comment_text = hr_api.g_varchar2) then
1385: p_rec.comment_text :=
1386: per_asg_shd.g_old_rec.comment_text;
1387: End If;
1388: If (p_rec.date_probation_end = hr_api.g_date) then
1389: p_rec.date_probation_end :=
1390: per_asg_shd.g_old_rec.date_probation_end;
1391: End If;
1392: If (p_rec.default_code_comb_id = hr_api.g_number) then
1388: If (p_rec.date_probation_end = hr_api.g_date) then
1389: p_rec.date_probation_end :=
1390: per_asg_shd.g_old_rec.date_probation_end;
1391: End If;
1392: If (p_rec.default_code_comb_id = hr_api.g_number) then
1393: p_rec.default_code_comb_id :=
1394: per_asg_shd.g_old_rec.default_code_comb_id;
1395: End If;
1396: If (p_rec.employment_category = hr_api.g_varchar2) then
1392: If (p_rec.default_code_comb_id = hr_api.g_number) then
1393: p_rec.default_code_comb_id :=
1394: per_asg_shd.g_old_rec.default_code_comb_id;
1395: End If;
1396: If (p_rec.employment_category = hr_api.g_varchar2) then
1397: p_rec.employment_category :=
1398: per_asg_shd.g_old_rec.employment_category;
1399: End If;
1400: If (p_rec.frequency = hr_api.g_varchar2) then
1396: If (p_rec.employment_category = hr_api.g_varchar2) then
1397: p_rec.employment_category :=
1398: per_asg_shd.g_old_rec.employment_category;
1399: End If;
1400: If (p_rec.frequency = hr_api.g_varchar2) then
1401: p_rec.frequency :=
1402: per_asg_shd.g_old_rec.frequency;
1403: End If;
1404: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1400: If (p_rec.frequency = hr_api.g_varchar2) then
1401: p_rec.frequency :=
1402: per_asg_shd.g_old_rec.frequency;
1403: End If;
1404: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1405: p_rec.internal_address_line :=
1406: per_asg_shd.g_old_rec.internal_address_line;
1407: End If;
1408: If (p_rec.manager_flag = hr_api.g_varchar2) then
1404: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1405: p_rec.internal_address_line :=
1406: per_asg_shd.g_old_rec.internal_address_line;
1407: End If;
1408: If (p_rec.manager_flag = hr_api.g_varchar2) then
1409: p_rec.manager_flag :=
1410: per_asg_shd.g_old_rec.manager_flag;
1411: End If;
1412: If (p_rec.normal_hours = hr_api.g_number) then
1408: If (p_rec.manager_flag = hr_api.g_varchar2) then
1409: p_rec.manager_flag :=
1410: per_asg_shd.g_old_rec.manager_flag;
1411: End If;
1412: If (p_rec.normal_hours = hr_api.g_number) then
1413: p_rec.normal_hours :=
1414: per_asg_shd.g_old_rec.normal_hours;
1415: End If;
1416: If (p_rec.perf_review_period = hr_api.g_number) then
1412: If (p_rec.normal_hours = hr_api.g_number) then
1413: p_rec.normal_hours :=
1414: per_asg_shd.g_old_rec.normal_hours;
1415: End If;
1416: If (p_rec.perf_review_period = hr_api.g_number) then
1417: p_rec.perf_review_period :=
1418: per_asg_shd.g_old_rec.perf_review_period;
1419: End If;
1420: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1416: If (p_rec.perf_review_period = hr_api.g_number) then
1417: p_rec.perf_review_period :=
1418: per_asg_shd.g_old_rec.perf_review_period;
1419: End If;
1420: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1421: p_rec.perf_review_period_frequency :=
1422: per_asg_shd.g_old_rec.perf_review_period_frequency;
1423: End If;
1424: If (p_rec.period_of_service_id = hr_api.g_number) then
1420: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1421: p_rec.perf_review_period_frequency :=
1422: per_asg_shd.g_old_rec.perf_review_period_frequency;
1423: End If;
1424: If (p_rec.period_of_service_id = hr_api.g_number) then
1425: p_rec.period_of_service_id :=
1426: per_asg_shd.g_old_rec.period_of_service_id;
1427: End If;
1428: If (p_rec.probation_period = hr_api.g_number) then
1424: If (p_rec.period_of_service_id = hr_api.g_number) then
1425: p_rec.period_of_service_id :=
1426: per_asg_shd.g_old_rec.period_of_service_id;
1427: End If;
1428: If (p_rec.probation_period = hr_api.g_number) then
1429: p_rec.probation_period :=
1430: per_asg_shd.g_old_rec.probation_period;
1431: End If;
1432: If (p_rec.probation_unit = hr_api.g_varchar2) then
1428: If (p_rec.probation_period = hr_api.g_number) then
1429: p_rec.probation_period :=
1430: per_asg_shd.g_old_rec.probation_period;
1431: End If;
1432: If (p_rec.probation_unit = hr_api.g_varchar2) then
1433: p_rec.probation_unit :=
1434: per_asg_shd.g_old_rec.probation_unit;
1435: End If;
1436: If (p_rec.sal_review_period = hr_api.g_number) then
1432: If (p_rec.probation_unit = hr_api.g_varchar2) then
1433: p_rec.probation_unit :=
1434: per_asg_shd.g_old_rec.probation_unit;
1435: End If;
1436: If (p_rec.sal_review_period = hr_api.g_number) then
1437: p_rec.sal_review_period :=
1438: per_asg_shd.g_old_rec.sal_review_period;
1439: End If;
1440: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then
1436: If (p_rec.sal_review_period = hr_api.g_number) then
1437: p_rec.sal_review_period :=
1438: per_asg_shd.g_old_rec.sal_review_period;
1439: End If;
1440: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then
1441: p_rec.sal_review_period_frequency :=
1442: per_asg_shd.g_old_rec.sal_review_period_frequency;
1443: End If;
1444: If (p_rec.set_of_books_id = hr_api.g_number) then
1440: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then
1441: p_rec.sal_review_period_frequency :=
1442: per_asg_shd.g_old_rec.sal_review_period_frequency;
1443: End If;
1444: If (p_rec.set_of_books_id = hr_api.g_number) then
1445: p_rec.set_of_books_id :=
1446: per_asg_shd.g_old_rec.set_of_books_id;
1447: End If;
1448: If (p_rec.source_type = hr_api.g_varchar2) then
1444: If (p_rec.set_of_books_id = hr_api.g_number) then
1445: p_rec.set_of_books_id :=
1446: per_asg_shd.g_old_rec.set_of_books_id;
1447: End If;
1448: If (p_rec.source_type = hr_api.g_varchar2) then
1449: p_rec.source_type :=
1450: per_asg_shd.g_old_rec.source_type;
1451: End If;
1452: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1448: If (p_rec.source_type = hr_api.g_varchar2) then
1449: p_rec.source_type :=
1450: per_asg_shd.g_old_rec.source_type;
1451: End If;
1452: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1453: p_rec.time_normal_finish :=
1454: per_asg_shd.g_old_rec.time_normal_finish;
1455: End If;
1456: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1452: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1453: p_rec.time_normal_finish :=
1454: per_asg_shd.g_old_rec.time_normal_finish;
1455: End If;
1456: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1457: p_rec.time_normal_start :=
1458: per_asg_shd.g_old_rec.time_normal_start;
1459: End If;
1460: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1456: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1457: p_rec.time_normal_start :=
1458: per_asg_shd.g_old_rec.time_normal_start;
1459: End If;
1460: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1461: p_rec.bargaining_unit_code :=
1462: per_asg_shd.g_old_rec.bargaining_unit_code;
1463: End If;
1464: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1460: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1461: p_rec.bargaining_unit_code :=
1462: per_asg_shd.g_old_rec.bargaining_unit_code;
1463: End If;
1464: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1465: p_rec.labour_union_member_flag :=
1466: per_asg_shd.g_old_rec.labour_union_member_flag;
1467: End If;
1468: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1464: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1465: p_rec.labour_union_member_flag :=
1466: per_asg_shd.g_old_rec.labour_union_member_flag;
1467: End If;
1468: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1469: p_rec.hourly_salaried_code :=
1470: per_asg_shd.g_old_rec.hourly_salaried_code;
1471: End If;
1472: If (p_rec.request_id = hr_api.g_number) then
1468: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1469: p_rec.hourly_salaried_code :=
1470: per_asg_shd.g_old_rec.hourly_salaried_code;
1471: End If;
1472: If (p_rec.request_id = hr_api.g_number) then
1473: p_rec.request_id :=
1474: per_asg_shd.g_old_rec.request_id;
1475: End If;
1476: If (p_rec.program_application_id = hr_api.g_number) then
1472: If (p_rec.request_id = hr_api.g_number) then
1473: p_rec.request_id :=
1474: per_asg_shd.g_old_rec.request_id;
1475: End If;
1476: If (p_rec.program_application_id = hr_api.g_number) then
1477: p_rec.program_application_id :=
1478: per_asg_shd.g_old_rec.program_application_id;
1479: End If;
1480: If (p_rec.program_id = hr_api.g_number) then
1476: If (p_rec.program_application_id = hr_api.g_number) then
1477: p_rec.program_application_id :=
1478: per_asg_shd.g_old_rec.program_application_id;
1479: End If;
1480: If (p_rec.program_id = hr_api.g_number) then
1481: p_rec.program_id :=
1482: per_asg_shd.g_old_rec.program_id;
1483: End If;
1484: If (p_rec.program_update_date = hr_api.g_date) then
1480: If (p_rec.program_id = hr_api.g_number) then
1481: p_rec.program_id :=
1482: per_asg_shd.g_old_rec.program_id;
1483: End If;
1484: If (p_rec.program_update_date = hr_api.g_date) then
1485: p_rec.program_update_date :=
1486: per_asg_shd.g_old_rec.program_update_date;
1487: End If;
1488: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1484: If (p_rec.program_update_date = hr_api.g_date) then
1485: p_rec.program_update_date :=
1486: per_asg_shd.g_old_rec.program_update_date;
1487: End If;
1488: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1489: p_rec.ass_attribute_category :=
1490: per_asg_shd.g_old_rec.ass_attribute_category;
1491: End If;
1492: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1488: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1489: p_rec.ass_attribute_category :=
1490: per_asg_shd.g_old_rec.ass_attribute_category;
1491: End If;
1492: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1493: p_rec.ass_attribute1 :=
1494: per_asg_shd.g_old_rec.ass_attribute1;
1495: End If;
1496: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1492: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1493: p_rec.ass_attribute1 :=
1494: per_asg_shd.g_old_rec.ass_attribute1;
1495: End If;
1496: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1497: p_rec.ass_attribute2 :=
1498: per_asg_shd.g_old_rec.ass_attribute2;
1499: End If;
1500: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1496: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1497: p_rec.ass_attribute2 :=
1498: per_asg_shd.g_old_rec.ass_attribute2;
1499: End If;
1500: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1501: p_rec.ass_attribute3 :=
1502: per_asg_shd.g_old_rec.ass_attribute3;
1503: End If;
1504: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1500: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1501: p_rec.ass_attribute3 :=
1502: per_asg_shd.g_old_rec.ass_attribute3;
1503: End If;
1504: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1505: p_rec.ass_attribute4 :=
1506: per_asg_shd.g_old_rec.ass_attribute4;
1507: End If;
1508: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1504: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1505: p_rec.ass_attribute4 :=
1506: per_asg_shd.g_old_rec.ass_attribute4;
1507: End If;
1508: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1509: p_rec.ass_attribute5 :=
1510: per_asg_shd.g_old_rec.ass_attribute5;
1511: End If;
1512: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1508: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1509: p_rec.ass_attribute5 :=
1510: per_asg_shd.g_old_rec.ass_attribute5;
1511: End If;
1512: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1513: p_rec.ass_attribute6 :=
1514: per_asg_shd.g_old_rec.ass_attribute6;
1515: End If;
1516: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1512: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1513: p_rec.ass_attribute6 :=
1514: per_asg_shd.g_old_rec.ass_attribute6;
1515: End If;
1516: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1517: p_rec.ass_attribute7 :=
1518: per_asg_shd.g_old_rec.ass_attribute7;
1519: End If;
1520: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1516: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1517: p_rec.ass_attribute7 :=
1518: per_asg_shd.g_old_rec.ass_attribute7;
1519: End If;
1520: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1521: p_rec.ass_attribute8 :=
1522: per_asg_shd.g_old_rec.ass_attribute8;
1523: End If;
1524: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1520: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1521: p_rec.ass_attribute8 :=
1522: per_asg_shd.g_old_rec.ass_attribute8;
1523: End If;
1524: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1525: p_rec.ass_attribute9 :=
1526: per_asg_shd.g_old_rec.ass_attribute9;
1527: End If;
1528: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1524: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1525: p_rec.ass_attribute9 :=
1526: per_asg_shd.g_old_rec.ass_attribute9;
1527: End If;
1528: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1529: p_rec.ass_attribute10 :=
1530: per_asg_shd.g_old_rec.ass_attribute10;
1531: End If;
1532: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1528: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1529: p_rec.ass_attribute10 :=
1530: per_asg_shd.g_old_rec.ass_attribute10;
1531: End If;
1532: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1533: p_rec.ass_attribute11 :=
1534: per_asg_shd.g_old_rec.ass_attribute11;
1535: End If;
1536: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1532: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1533: p_rec.ass_attribute11 :=
1534: per_asg_shd.g_old_rec.ass_attribute11;
1535: End If;
1536: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1537: p_rec.ass_attribute12 :=
1538: per_asg_shd.g_old_rec.ass_attribute12;
1539: End If;
1540: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1536: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1537: p_rec.ass_attribute12 :=
1538: per_asg_shd.g_old_rec.ass_attribute12;
1539: End If;
1540: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1541: p_rec.ass_attribute13 :=
1542: per_asg_shd.g_old_rec.ass_attribute13;
1543: End If;
1544: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1540: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1541: p_rec.ass_attribute13 :=
1542: per_asg_shd.g_old_rec.ass_attribute13;
1543: End If;
1544: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1545: p_rec.ass_attribute14 :=
1546: per_asg_shd.g_old_rec.ass_attribute14;
1547: End If;
1548: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1544: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1545: p_rec.ass_attribute14 :=
1546: per_asg_shd.g_old_rec.ass_attribute14;
1547: End If;
1548: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1549: p_rec.ass_attribute15 :=
1550: per_asg_shd.g_old_rec.ass_attribute15;
1551: End If;
1552: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1548: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1549: p_rec.ass_attribute15 :=
1550: per_asg_shd.g_old_rec.ass_attribute15;
1551: End If;
1552: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1553: p_rec.ass_attribute16 :=
1554: per_asg_shd.g_old_rec.ass_attribute16;
1555: End If;
1556: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1552: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1553: p_rec.ass_attribute16 :=
1554: per_asg_shd.g_old_rec.ass_attribute16;
1555: End If;
1556: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1557: p_rec.ass_attribute17 :=
1558: per_asg_shd.g_old_rec.ass_attribute17;
1559: End If;
1560: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1556: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1557: p_rec.ass_attribute17 :=
1558: per_asg_shd.g_old_rec.ass_attribute17;
1559: End If;
1560: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1561: p_rec.ass_attribute18 :=
1562: per_asg_shd.g_old_rec.ass_attribute18;
1563: End If;
1564: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1560: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1561: p_rec.ass_attribute18 :=
1562: per_asg_shd.g_old_rec.ass_attribute18;
1563: End If;
1564: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1565: p_rec.ass_attribute19 :=
1566: per_asg_shd.g_old_rec.ass_attribute19;
1567: End If;
1568: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1564: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1565: p_rec.ass_attribute19 :=
1566: per_asg_shd.g_old_rec.ass_attribute19;
1567: End If;
1568: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1569: p_rec.ass_attribute20 :=
1570: per_asg_shd.g_old_rec.ass_attribute20;
1571: End If;
1572: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1568: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1569: p_rec.ass_attribute20 :=
1570: per_asg_shd.g_old_rec.ass_attribute20;
1571: End If;
1572: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1573: p_rec.ass_attribute21 :=
1574: per_asg_shd.g_old_rec.ass_attribute21;
1575: End If;
1576: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1572: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1573: p_rec.ass_attribute21 :=
1574: per_asg_shd.g_old_rec.ass_attribute21;
1575: End If;
1576: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1577: p_rec.ass_attribute22 :=
1578: per_asg_shd.g_old_rec.ass_attribute22;
1579: End If;
1580: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1576: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1577: p_rec.ass_attribute22 :=
1578: per_asg_shd.g_old_rec.ass_attribute22;
1579: End If;
1580: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1581: p_rec.ass_attribute23 :=
1582: per_asg_shd.g_old_rec.ass_attribute23;
1583: End If;
1584: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1580: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1581: p_rec.ass_attribute23 :=
1582: per_asg_shd.g_old_rec.ass_attribute23;
1583: End If;
1584: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1585: p_rec.ass_attribute24 :=
1586: per_asg_shd.g_old_rec.ass_attribute24;
1587: End If;
1588: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1584: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1585: p_rec.ass_attribute24 :=
1586: per_asg_shd.g_old_rec.ass_attribute24;
1587: End If;
1588: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1589: p_rec.ass_attribute25 :=
1590: per_asg_shd.g_old_rec.ass_attribute25;
1591: End If;
1592: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1588: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1589: p_rec.ass_attribute25 :=
1590: per_asg_shd.g_old_rec.ass_attribute25;
1591: End If;
1592: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1593: p_rec.ass_attribute26 :=
1594: per_asg_shd.g_old_rec.ass_attribute26;
1595: End If;
1596: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1592: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1593: p_rec.ass_attribute26 :=
1594: per_asg_shd.g_old_rec.ass_attribute26;
1595: End If;
1596: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1597: p_rec.ass_attribute27 :=
1598: per_asg_shd.g_old_rec.ass_attribute27;
1599: End If;
1600: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1596: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1597: p_rec.ass_attribute27 :=
1598: per_asg_shd.g_old_rec.ass_attribute27;
1599: End If;
1600: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1601: p_rec.ass_attribute28 :=
1602: per_asg_shd.g_old_rec.ass_attribute28;
1603: End If;
1604: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1600: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1601: p_rec.ass_attribute28 :=
1602: per_asg_shd.g_old_rec.ass_attribute28;
1603: End If;
1604: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1605: p_rec.ass_attribute29 :=
1606: per_asg_shd.g_old_rec.ass_attribute29;
1607: End If;
1608: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1604: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1605: p_rec.ass_attribute29 :=
1606: per_asg_shd.g_old_rec.ass_attribute29;
1607: End If;
1608: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1609: p_rec.ass_attribute30 :=
1610: per_asg_shd.g_old_rec.ass_attribute30;
1611: End If;
1612: If (p_rec.title = hr_api.g_varchar2) then
1608: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1609: p_rec.ass_attribute30 :=
1610: per_asg_shd.g_old_rec.ass_attribute30;
1611: End If;
1612: If (p_rec.title = hr_api.g_varchar2) then
1613: p_rec.title :=
1614: per_asg_shd.g_old_rec.title;
1615: End If;
1616: If (p_rec.contract_id = hr_api.g_number) then
1612: If (p_rec.title = hr_api.g_varchar2) then
1613: p_rec.title :=
1614: per_asg_shd.g_old_rec.title;
1615: End If;
1616: If (p_rec.contract_id = hr_api.g_number) then
1617: p_rec.contract_id :=
1618: per_asg_shd.g_old_rec.contract_id;
1619: End If;
1620: If (p_rec.establishment_id = hr_api.g_number) then
1616: If (p_rec.contract_id = hr_api.g_number) then
1617: p_rec.contract_id :=
1618: per_asg_shd.g_old_rec.contract_id;
1619: End If;
1620: If (p_rec.establishment_id = hr_api.g_number) then
1621: p_rec.establishment_id :=
1622: per_asg_shd.g_old_rec.establishment_id;
1623: End If;
1624: If (p_rec.collective_agreement_id = hr_api.g_number) then
1620: If (p_rec.establishment_id = hr_api.g_number) then
1621: p_rec.establishment_id :=
1622: per_asg_shd.g_old_rec.establishment_id;
1623: End If;
1624: If (p_rec.collective_agreement_id = hr_api.g_number) then
1625: p_rec.collective_agreement_id :=
1626: per_asg_shd.g_old_rec.collective_agreement_id;
1627: End If;
1628: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1624: If (p_rec.collective_agreement_id = hr_api.g_number) then
1625: p_rec.collective_agreement_id :=
1626: per_asg_shd.g_old_rec.collective_agreement_id;
1627: End If;
1628: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1629: p_rec.cagr_grade_def_id :=
1630: per_asg_shd.g_old_rec.cagr_grade_def_id;
1631: End If;
1632: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1628: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1629: p_rec.cagr_grade_def_id :=
1630: per_asg_shd.g_old_rec.cagr_grade_def_id;
1631: End If;
1632: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1633: p_rec.cagr_id_flex_num :=
1634: per_asg_shd.g_old_rec.cagr_id_flex_num;
1635: End If;
1636: If (p_rec.notice_period = hr_api.g_number) then
1632: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1633: p_rec.cagr_id_flex_num :=
1634: per_asg_shd.g_old_rec.cagr_id_flex_num;
1635: End If;
1636: If (p_rec.notice_period = hr_api.g_number) then
1637: p_rec.notice_period :=
1638: per_asg_shd.g_old_rec.notice_period;
1639: End If;
1640: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1636: If (p_rec.notice_period = hr_api.g_number) then
1637: p_rec.notice_period :=
1638: per_asg_shd.g_old_rec.notice_period;
1639: End If;
1640: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1641: p_rec.notice_period_uom :=
1642: per_asg_shd.g_old_rec.notice_period_uom;
1643: End If;
1644: If (p_rec.employee_category = hr_api.g_varchar2) then
1640: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1641: p_rec.notice_period_uom :=
1642: per_asg_shd.g_old_rec.notice_period_uom;
1643: End If;
1644: If (p_rec.employee_category = hr_api.g_varchar2) then
1645: p_rec.employee_category :=
1646: per_asg_shd.g_old_rec.employee_category;
1647: End If;
1648: If (p_rec.work_at_home = hr_api.g_varchar2) then
1644: If (p_rec.employee_category = hr_api.g_varchar2) then
1645: p_rec.employee_category :=
1646: per_asg_shd.g_old_rec.employee_category;
1647: End If;
1648: If (p_rec.work_at_home = hr_api.g_varchar2) then
1649: p_rec.work_at_home :=
1650: per_asg_shd.g_old_rec.work_at_home;
1651: End If;
1652: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1648: If (p_rec.work_at_home = hr_api.g_varchar2) then
1649: p_rec.work_at_home :=
1650: per_asg_shd.g_old_rec.work_at_home;
1651: End If;
1652: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1653: p_rec.job_post_source_name :=
1654: per_asg_shd.g_old_rec.job_post_source_name;
1655: End If;
1656: If (p_rec.posting_content_id = hr_api.g_number) then
1652: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1653: p_rec.job_post_source_name :=
1654: per_asg_shd.g_old_rec.job_post_source_name;
1655: End If;
1656: If (p_rec.posting_content_id = hr_api.g_number) then
1657: p_rec.posting_content_id :=
1658: per_asg_shd.g_old_rec.posting_content_id;
1659: End If;
1660: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1656: If (p_rec.posting_content_id = hr_api.g_number) then
1657: p_rec.posting_content_id :=
1658: per_asg_shd.g_old_rec.posting_content_id;
1659: End If;
1660: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1661: p_rec.period_of_placement_date_start :=
1662: per_asg_shd.g_old_rec.period_of_placement_date_start;
1663: End If;
1664: If (p_rec.vendor_id = hr_api.g_number) then
1660: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1661: p_rec.period_of_placement_date_start :=
1662: per_asg_shd.g_old_rec.period_of_placement_date_start;
1663: End If;
1664: If (p_rec.vendor_id = hr_api.g_number) then
1665: p_rec.vendor_id :=
1666: per_asg_shd.g_old_rec.vendor_id;
1667: End If;
1668: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1664: If (p_rec.vendor_id = hr_api.g_number) then
1665: p_rec.vendor_id :=
1666: per_asg_shd.g_old_rec.vendor_id;
1667: End If;
1668: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1669: p_rec.vendor_employee_number :=
1670: per_asg_shd.g_old_rec.vendor_employee_number;
1671: End If;
1672: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1668: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1669: p_rec.vendor_employee_number :=
1670: per_asg_shd.g_old_rec.vendor_employee_number;
1671: End If;
1672: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1673: p_rec.vendor_assignment_number :=
1674: per_asg_shd.g_old_rec.vendor_assignment_number;
1675: End If;
1676: If (p_rec.assignment_category = hr_api.g_varchar2) then
1672: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1673: p_rec.vendor_assignment_number :=
1674: per_asg_shd.g_old_rec.vendor_assignment_number;
1675: End If;
1676: If (p_rec.assignment_category = hr_api.g_varchar2) then
1677: p_rec.assignment_category :=
1678: per_asg_shd.g_old_rec.assignment_category;
1679: End If;
1680: If (p_rec.project_title = hr_api.g_varchar2) then
1676: If (p_rec.assignment_category = hr_api.g_varchar2) then
1677: p_rec.assignment_category :=
1678: per_asg_shd.g_old_rec.assignment_category;
1679: End If;
1680: If (p_rec.project_title = hr_api.g_varchar2) then
1681: p_rec.project_title :=
1682: per_asg_shd.g_old_rec.project_title;
1683: End If;
1684: If (p_rec.applicant_rank = hr_api.g_number) then
1680: If (p_rec.project_title = hr_api.g_varchar2) then
1681: p_rec.project_title :=
1682: per_asg_shd.g_old_rec.project_title;
1683: End If;
1684: If (p_rec.applicant_rank = hr_api.g_number) then
1685: p_rec.applicant_rank :=
1686: per_asg_shd.g_old_rec.applicant_rank;
1687: End If;
1688: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then
1684: If (p_rec.applicant_rank = hr_api.g_number) then
1685: p_rec.applicant_rank :=
1686: per_asg_shd.g_old_rec.applicant_rank;
1687: End If;
1688: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then
1689: p_rec.grade_ladder_pgm_id :=
1690: per_asg_shd.g_old_rec.grade_ladder_pgm_id;
1691: End If;
1692: If (p_rec.supervisor_assignment_id = hr_api.g_number) then
1688: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then
1689: p_rec.grade_ladder_pgm_id :=
1690: per_asg_shd.g_old_rec.grade_ladder_pgm_id;
1691: End If;
1692: If (p_rec.supervisor_assignment_id = hr_api.g_number) then
1693: p_rec.supervisor_assignment_id :=
1694: per_asg_shd.g_old_rec.supervisor_assignment_id;
1695: End If;
1696: If (p_rec.vendor_site_id = hr_api.g_number) then
1692: If (p_rec.supervisor_assignment_id = hr_api.g_number) then
1693: p_rec.supervisor_assignment_id :=
1694: per_asg_shd.g_old_rec.supervisor_assignment_id;
1695: End If;
1696: If (p_rec.vendor_site_id = hr_api.g_number) then
1697: p_rec.vendor_site_id :=
1698: per_asg_shd.g_old_rec.vendor_site_id;
1699: End If;
1700: If (p_rec.po_header_id = hr_api.g_number) then
1696: If (p_rec.vendor_site_id = hr_api.g_number) then
1697: p_rec.vendor_site_id :=
1698: per_asg_shd.g_old_rec.vendor_site_id;
1699: End If;
1700: If (p_rec.po_header_id = hr_api.g_number) then
1701: p_rec.po_header_id :=
1702: per_asg_shd.g_old_rec.po_header_id;
1703: End If;
1704: If (p_rec.po_line_id = hr_api.g_number) then
1700: If (p_rec.po_header_id = hr_api.g_number) then
1701: p_rec.po_header_id :=
1702: per_asg_shd.g_old_rec.po_header_id;
1703: End If;
1704: If (p_rec.po_line_id = hr_api.g_number) then
1705: p_rec.po_line_id :=
1706: per_asg_shd.g_old_rec.po_line_id;
1707: End If;
1708: If (p_rec.projected_assignment_end = hr_api.g_date) then
1704: If (p_rec.po_line_id = hr_api.g_number) then
1705: p_rec.po_line_id :=
1706: per_asg_shd.g_old_rec.po_line_id;
1707: End If;
1708: If (p_rec.projected_assignment_end = hr_api.g_date) then
1709: p_rec.projected_assignment_end :=
1710: per_asg_shd.g_old_rec.projected_assignment_end;
1711: End If;
1712: --
1843: --
1844: -- If we are validating then raise the Validate_Enabled exception
1845: --
1846: If p_validate then
1847: Raise HR_Api.Validate_Enabled;
1848: End If;
1849: --
1850: hr_utility.set_location(' Leaving:'||l_proc, 10);
1851: Exception
1848: End If;
1849: --
1850: hr_utility.set_location(' Leaving:'||l_proc, 10);
1851: Exception
1852: When HR_Api.Validate_Enabled Then
1853: --
1854: -- As the Validate_Enabled exception has been raised
1855: -- we must rollback to the savepoint
1856: --
1866: p_effective_start_date out nocopy date,
1867: p_effective_end_date out nocopy date,
1868:
1869: p_business_group_id out nocopy number,
1870: p_recruiter_id in number default hr_api.g_number,
1871: p_grade_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1867: p_effective_end_date out nocopy date,
1868:
1869: p_business_group_id out nocopy number,
1870: p_recruiter_id in number default hr_api.g_number,
1871: p_grade_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1868:
1869: p_business_group_id out nocopy number,
1870: p_recruiter_id in number default hr_api.g_number,
1871: p_grade_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1869: p_business_group_id out nocopy number,
1870: p_recruiter_id in number default hr_api.g_number,
1871: p_grade_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1870: p_recruiter_id in number default hr_api.g_number,
1871: p_grade_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1871: p_grade_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1882:
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1882:
1883: p_organization_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1882:
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1882:
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1882:
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1882:
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1881: p_source_organization_id in number default hr_api.g_number,
1882:
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1882:
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,
1894: p_comments in varchar2 default hr_api.g_varchar2,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,
1894: p_comments in varchar2 default hr_api.g_varchar2,
1895: p_date_probation_end in date default hr_api.g_date,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,
1894: p_comments in varchar2 default hr_api.g_varchar2,
1895: p_date_probation_end in date default hr_api.g_date,
1896:
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,
1894: p_comments in varchar2 default hr_api.g_varchar2,
1895: p_date_probation_end in date default hr_api.g_date,
1896:
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,
1894: p_comments in varchar2 default hr_api.g_varchar2,
1895: p_date_probation_end in date default hr_api.g_date,
1896:
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,
1894: p_comments in varchar2 default hr_api.g_varchar2,
1895: p_date_probation_end in date default hr_api.g_date,
1896:
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1894: p_comments in varchar2 default hr_api.g_varchar2,
1895: p_date_probation_end in date default hr_api.g_date,
1896:
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1895: p_date_probation_end in date default hr_api.g_date,
1896:
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1896:
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1979: p_po_line_id in number default hr_api.g_number,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1979: p_po_line_id in number default hr_api.g_number,
1980: p_projected_assignment_end in date default hr_api.g_date,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1979: p_po_line_id in number default hr_api.g_number,
1980: p_projected_assignment_end in date default hr_api.g_date,
1981: p_payroll_id_updated out nocopy boolean,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1979: p_po_line_id in number default hr_api.g_number,
1980: p_projected_assignment_end in date default hr_api.g_date,
1981: p_payroll_id_updated out nocopy boolean,
1982: p_other_manager_warning out nocopy boolean,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1979: p_po_line_id in number default hr_api.g_number,
1980: p_projected_assignment_end in date default hr_api.g_date,
1981: p_payroll_id_updated out nocopy boolean,
1982: p_other_manager_warning out nocopy boolean,
1983: p_hourly_salaried_warning out nocopy boolean,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1979: p_po_line_id in number default hr_api.g_number,
1980: p_projected_assignment_end in date default hr_api.g_date,
1981: p_payroll_id_updated out nocopy boolean,
1982: p_other_manager_warning out nocopy boolean,
1983: p_hourly_salaried_warning out nocopy boolean,
1984: p_no_managers_warning out nocopy boolean,
2006: p_assignment_id,
2007: null,
2008:
2009: null,
2010: hr_api.g_number,
2011: p_recruiter_id,
2012: p_grade_id,
2013: p_position_id,
2014: p_job_id,
2017: p_location_id,
2018: p_person_referred_by_id,
2019: p_supervisor_id,
2020: p_special_ceiling_step_id,
2021: hr_api.g_number,
2022:
2023: p_recruitment_activity_id,
2024: p_source_organization_id,
2025: p_organization_id,
2026: p_people_group_id,
2027: p_soft_coding_keyflex_id,
2028: p_vacancy_id,
2029: p_pay_basis_id,
2030: hr_api.g_number,
2031: p_assignment_type,
2032: p_primary_flag,
2033: p_application_id,
2034: p_assignment_number,
2032: p_primary_flag,
2033: p_application_id,
2034: p_assignment_number,
2035: p_change_reason,
2036: hr_api.g_number,
2037: p_comments,
2038: p_date_probation_end,
2039: p_default_code_comb_id,
2040: p_employment_category,