DBA Data[Home] [Help]

APPS.PER_ASG_UPD dependencies on HR_API

Line 199: if nvl(per_asg_shd.g_old_rec.assignment_number, hr_api.g_varchar2) <>

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',

Line 200: nvl(p_rec.assignment_number, hr_api.g_varchar2) then

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',

Line 228: When hr_api.check_integrity_violated Then

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

Line 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

Line 233: When hr_api.unique_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
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 1046: when hr_api.cannot_find_prog_unit then

1042: ,p_projected_assignment_end_o
1043: => per_asg_shd.g_old_rec.projected_assignment_end
1044: );
1045: exception
1046: when hr_api.cannot_find_prog_unit then
1047: hr_api.cannot_find_prog_unit_error
1048: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'
1049: ,p_hook_type => 'AU'
1050: );

Line 1047: hr_api.cannot_find_prog_unit_error

1043: => per_asg_shd.g_old_rec.projected_assignment_end
1044: );
1045: exception
1046: when hr_api.cannot_find_prog_unit then
1047: hr_api.cannot_find_prog_unit_error
1048: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'
1049: ,p_hook_type => 'AU'
1050: );
1051: end;

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

1356: -- p_rec plsql record structure
1357: -- to see if a system default is being used. If a system default
1358: -- is being used then we must set to the 'current' argument value.
1359: --
1360: If (p_rec.business_group_id = hr_api.g_number) then
1361: p_rec.business_group_id :=
1362: per_asg_shd.g_old_rec.business_group_id;
1363: End If;
1364: If (p_rec.recruiter_id = hr_api.g_number) then

Line 1364: If (p_rec.recruiter_id = hr_api.g_number) then

1360: If (p_rec.business_group_id = hr_api.g_number) then
1361: p_rec.business_group_id :=
1362: per_asg_shd.g_old_rec.business_group_id;
1363: End If;
1364: If (p_rec.recruiter_id = hr_api.g_number) then
1365: p_rec.recruiter_id :=
1366: per_asg_shd.g_old_rec.recruiter_id;
1367: End If;
1368: If (p_rec.grade_id = hr_api.g_number) then

Line 1368: If (p_rec.grade_id = hr_api.g_number) then

1364: If (p_rec.recruiter_id = hr_api.g_number) then
1365: p_rec.recruiter_id :=
1366: per_asg_shd.g_old_rec.recruiter_id;
1367: End If;
1368: If (p_rec.grade_id = hr_api.g_number) then
1369: p_rec.grade_id :=
1370: per_asg_shd.g_old_rec.grade_id;
1371: End If;
1372: If (p_rec.position_id = hr_api.g_number) then

Line 1372: If (p_rec.position_id = hr_api.g_number) then

1368: If (p_rec.grade_id = hr_api.g_number) then
1369: p_rec.grade_id :=
1370: per_asg_shd.g_old_rec.grade_id;
1371: End If;
1372: If (p_rec.position_id = hr_api.g_number) then
1373: p_rec.position_id :=
1374: per_asg_shd.g_old_rec.position_id;
1375: End If;
1376: If (p_rec.job_id = hr_api.g_number) then

Line 1376: If (p_rec.job_id = hr_api.g_number) then

1372: If (p_rec.position_id = hr_api.g_number) then
1373: p_rec.position_id :=
1374: per_asg_shd.g_old_rec.position_id;
1375: End If;
1376: If (p_rec.job_id = hr_api.g_number) then
1377: p_rec.job_id :=
1378: per_asg_shd.g_old_rec.job_id;
1379: End If;
1380: If (p_rec.assignment_status_type_id = hr_api.g_number) then

Line 1380: If (p_rec.assignment_status_type_id = hr_api.g_number) then

1376: If (p_rec.job_id = hr_api.g_number) then
1377: p_rec.job_id :=
1378: per_asg_shd.g_old_rec.job_id;
1379: End If;
1380: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1381: p_rec.assignment_status_type_id :=
1382: per_asg_shd.g_old_rec.assignment_status_type_id;
1383: End If;
1384: If (p_rec.payroll_id = hr_api.g_number) then

Line 1384: If (p_rec.payroll_id = hr_api.g_number) then

1380: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1381: p_rec.assignment_status_type_id :=
1382: per_asg_shd.g_old_rec.assignment_status_type_id;
1383: End If;
1384: If (p_rec.payroll_id = hr_api.g_number) then
1385: p_rec.payroll_id :=
1386: per_asg_shd.g_old_rec.payroll_id;
1387: End If;
1388: If (p_rec.location_id = hr_api.g_number) then

Line 1388: If (p_rec.location_id = hr_api.g_number) then

1384: If (p_rec.payroll_id = hr_api.g_number) then
1385: p_rec.payroll_id :=
1386: per_asg_shd.g_old_rec.payroll_id;
1387: End If;
1388: If (p_rec.location_id = hr_api.g_number) then
1389: p_rec.location_id :=
1390: per_asg_shd.g_old_rec.location_id;
1391: End If;
1392: If (p_rec.person_referred_by_id = hr_api.g_number) then

Line 1392: If (p_rec.person_referred_by_id = hr_api.g_number) then

1388: If (p_rec.location_id = hr_api.g_number) then
1389: p_rec.location_id :=
1390: per_asg_shd.g_old_rec.location_id;
1391: End If;
1392: If (p_rec.person_referred_by_id = hr_api.g_number) then
1393: p_rec.person_referred_by_id :=
1394: per_asg_shd.g_old_rec.person_referred_by_id;
1395: End If;
1396: If (p_rec.supervisor_id = hr_api.g_number) then

Line 1396: If (p_rec.supervisor_id = hr_api.g_number) then

1392: If (p_rec.person_referred_by_id = hr_api.g_number) then
1393: p_rec.person_referred_by_id :=
1394: per_asg_shd.g_old_rec.person_referred_by_id;
1395: End If;
1396: If (p_rec.supervisor_id = hr_api.g_number) then
1397: p_rec.supervisor_id :=
1398: per_asg_shd.g_old_rec.supervisor_id;
1399: End If;
1400: If (p_rec.special_ceiling_step_id = hr_api.g_number) then

Line 1400: If (p_rec.special_ceiling_step_id = hr_api.g_number) then

1396: If (p_rec.supervisor_id = hr_api.g_number) then
1397: p_rec.supervisor_id :=
1398: per_asg_shd.g_old_rec.supervisor_id;
1399: End If;
1400: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1401: p_rec.special_ceiling_step_id :=
1402: per_asg_shd.g_old_rec.special_ceiling_step_id;
1403: End If;
1404: If (p_rec.person_id = hr_api.g_number) then

Line 1404: If (p_rec.person_id = hr_api.g_number) then

1400: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1401: p_rec.special_ceiling_step_id :=
1402: per_asg_shd.g_old_rec.special_ceiling_step_id;
1403: End If;
1404: If (p_rec.person_id = hr_api.g_number) then
1405: p_rec.person_id :=
1406: per_asg_shd.g_old_rec.person_id;
1407: End If;
1408: If (p_rec.recruitment_activity_id = hr_api.g_number) then

Line 1408: If (p_rec.recruitment_activity_id = hr_api.g_number) then

1404: If (p_rec.person_id = hr_api.g_number) then
1405: p_rec.person_id :=
1406: per_asg_shd.g_old_rec.person_id;
1407: End If;
1408: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1409: p_rec.recruitment_activity_id :=
1410: per_asg_shd.g_old_rec.recruitment_activity_id;
1411: End If;
1412: If (p_rec.source_organization_id = hr_api.g_number) then

Line 1412: If (p_rec.source_organization_id = hr_api.g_number) then

1408: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1409: p_rec.recruitment_activity_id :=
1410: per_asg_shd.g_old_rec.recruitment_activity_id;
1411: End If;
1412: If (p_rec.source_organization_id = hr_api.g_number) then
1413: p_rec.source_organization_id :=
1414: per_asg_shd.g_old_rec.source_organization_id;
1415: End If;
1416: If (p_rec.organization_id = hr_api.g_number) then

Line 1416: If (p_rec.organization_id = hr_api.g_number) then

1412: If (p_rec.source_organization_id = hr_api.g_number) then
1413: p_rec.source_organization_id :=
1414: per_asg_shd.g_old_rec.source_organization_id;
1415: End If;
1416: If (p_rec.organization_id = hr_api.g_number) then
1417: p_rec.organization_id :=
1418: per_asg_shd.g_old_rec.organization_id;
1419: End If;
1420: If (p_rec.people_group_id = hr_api.g_number) then

Line 1420: If (p_rec.people_group_id = hr_api.g_number) then

1416: If (p_rec.organization_id = hr_api.g_number) then
1417: p_rec.organization_id :=
1418: per_asg_shd.g_old_rec.organization_id;
1419: End If;
1420: If (p_rec.people_group_id = hr_api.g_number) then
1421: p_rec.people_group_id :=
1422: per_asg_shd.g_old_rec.people_group_id;
1423: End If;
1424: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then

Line 1424: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then

1420: If (p_rec.people_group_id = hr_api.g_number) then
1421: p_rec.people_group_id :=
1422: per_asg_shd.g_old_rec.people_group_id;
1423: End If;
1424: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1425: p_rec.soft_coding_keyflex_id :=
1426: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1427: End If;
1428: If (p_rec.vacancy_id = hr_api.g_number) then

Line 1428: If (p_rec.vacancy_id = hr_api.g_number) then

1424: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1425: p_rec.soft_coding_keyflex_id :=
1426: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1427: End If;
1428: If (p_rec.vacancy_id = hr_api.g_number) then
1429: p_rec.vacancy_id :=
1430: per_asg_shd.g_old_rec.vacancy_id;
1431: End If;
1432: If (p_rec.pay_basis_id = hr_api.g_number) then

Line 1432: If (p_rec.pay_basis_id = hr_api.g_number) then

1428: If (p_rec.vacancy_id = hr_api.g_number) then
1429: p_rec.vacancy_id :=
1430: per_asg_shd.g_old_rec.vacancy_id;
1431: End If;
1432: If (p_rec.pay_basis_id = hr_api.g_number) then
1433: p_rec.pay_basis_id :=
1434: per_asg_shd.g_old_rec.pay_basis_id;
1435: End If;
1436: If (p_rec.assignment_sequence = hr_api.g_number) then

Line 1436: If (p_rec.assignment_sequence = hr_api.g_number) then

1432: If (p_rec.pay_basis_id = hr_api.g_number) then
1433: p_rec.pay_basis_id :=
1434: per_asg_shd.g_old_rec.pay_basis_id;
1435: End If;
1436: If (p_rec.assignment_sequence = hr_api.g_number) then
1437: p_rec.assignment_sequence :=
1438: per_asg_shd.g_old_rec.assignment_sequence;
1439: End If;
1440: If (p_rec.assignment_type = hr_api.g_varchar2) then

Line 1440: If (p_rec.assignment_type = hr_api.g_varchar2) then

1436: If (p_rec.assignment_sequence = hr_api.g_number) then
1437: p_rec.assignment_sequence :=
1438: per_asg_shd.g_old_rec.assignment_sequence;
1439: End If;
1440: If (p_rec.assignment_type = hr_api.g_varchar2) then
1441: p_rec.assignment_type :=
1442: per_asg_shd.g_old_rec.assignment_type;
1443: End If;
1444: If (p_rec.primary_flag = hr_api.g_varchar2) then

Line 1444: If (p_rec.primary_flag = hr_api.g_varchar2) then

1440: If (p_rec.assignment_type = hr_api.g_varchar2) then
1441: p_rec.assignment_type :=
1442: per_asg_shd.g_old_rec.assignment_type;
1443: End If;
1444: If (p_rec.primary_flag = hr_api.g_varchar2) then
1445: p_rec.primary_flag :=
1446: per_asg_shd.g_old_rec.primary_flag;
1447: End If;
1448: If (p_rec.application_id = hr_api.g_number) then

Line 1448: If (p_rec.application_id = hr_api.g_number) then

1444: If (p_rec.primary_flag = hr_api.g_varchar2) then
1445: p_rec.primary_flag :=
1446: per_asg_shd.g_old_rec.primary_flag;
1447: End If;
1448: If (p_rec.application_id = hr_api.g_number) then
1449: p_rec.application_id :=
1450: per_asg_shd.g_old_rec.application_id;
1451: End If;
1452: If (p_rec.assignment_number = hr_api.g_varchar2) then

Line 1452: If (p_rec.assignment_number = hr_api.g_varchar2) then

1448: If (p_rec.application_id = hr_api.g_number) then
1449: p_rec.application_id :=
1450: per_asg_shd.g_old_rec.application_id;
1451: End If;
1452: If (p_rec.assignment_number = hr_api.g_varchar2) then
1453: p_rec.assignment_number :=
1454: per_asg_shd.g_old_rec.assignment_number;
1455: End If;
1456: If (p_rec.change_reason = hr_api.g_varchar2) then

Line 1456: If (p_rec.change_reason = hr_api.g_varchar2) then

1452: If (p_rec.assignment_number = hr_api.g_varchar2) then
1453: p_rec.assignment_number :=
1454: per_asg_shd.g_old_rec.assignment_number;
1455: End If;
1456: If (p_rec.change_reason = hr_api.g_varchar2) then
1457: p_rec.change_reason :=
1458: per_asg_shd.g_old_rec.change_reason;
1459: End If;
1460: If (p_rec.comment_id = hr_api.g_number) then

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

1456: If (p_rec.change_reason = hr_api.g_varchar2) then
1457: p_rec.change_reason :=
1458: per_asg_shd.g_old_rec.change_reason;
1459: End If;
1460: If (p_rec.comment_id = hr_api.g_number) then
1461: p_rec.comment_id :=
1462: per_asg_shd.g_old_rec.comment_id;
1463: End If;
1464: If (p_rec.comment_text = hr_api.g_varchar2) then

Line 1464: If (p_rec.comment_text = hr_api.g_varchar2) then

1460: If (p_rec.comment_id = hr_api.g_number) then
1461: p_rec.comment_id :=
1462: per_asg_shd.g_old_rec.comment_id;
1463: End If;
1464: If (p_rec.comment_text = hr_api.g_varchar2) then
1465: p_rec.comment_text :=
1466: per_asg_shd.g_old_rec.comment_text;
1467: End If;
1468: If (p_rec.date_probation_end = hr_api.g_date) then

Line 1468: If (p_rec.date_probation_end = hr_api.g_date) then

1464: If (p_rec.comment_text = hr_api.g_varchar2) then
1465: p_rec.comment_text :=
1466: per_asg_shd.g_old_rec.comment_text;
1467: End If;
1468: If (p_rec.date_probation_end = hr_api.g_date) then
1469: p_rec.date_probation_end :=
1470: per_asg_shd.g_old_rec.date_probation_end;
1471: End If;
1472: If (p_rec.default_code_comb_id = hr_api.g_number) then

Line 1472: If (p_rec.default_code_comb_id = hr_api.g_number) then

1468: If (p_rec.date_probation_end = hr_api.g_date) then
1469: p_rec.date_probation_end :=
1470: per_asg_shd.g_old_rec.date_probation_end;
1471: End If;
1472: If (p_rec.default_code_comb_id = hr_api.g_number) then
1473: p_rec.default_code_comb_id :=
1474: per_asg_shd.g_old_rec.default_code_comb_id;
1475: End If;
1476: If (p_rec.employment_category = hr_api.g_varchar2) then

Line 1476: If (p_rec.employment_category = hr_api.g_varchar2) then

1472: If (p_rec.default_code_comb_id = hr_api.g_number) then
1473: p_rec.default_code_comb_id :=
1474: per_asg_shd.g_old_rec.default_code_comb_id;
1475: End If;
1476: If (p_rec.employment_category = hr_api.g_varchar2) then
1477: p_rec.employment_category :=
1478: per_asg_shd.g_old_rec.employment_category;
1479: End If;
1480: If (p_rec.frequency = hr_api.g_varchar2) then

Line 1480: If (p_rec.frequency = hr_api.g_varchar2) then

1476: If (p_rec.employment_category = hr_api.g_varchar2) then
1477: p_rec.employment_category :=
1478: per_asg_shd.g_old_rec.employment_category;
1479: End If;
1480: If (p_rec.frequency = hr_api.g_varchar2) then
1481: p_rec.frequency :=
1482: per_asg_shd.g_old_rec.frequency;
1483: End If;
1484: If (p_rec.internal_address_line = hr_api.g_varchar2) then

Line 1484: If (p_rec.internal_address_line = hr_api.g_varchar2) then

1480: If (p_rec.frequency = hr_api.g_varchar2) then
1481: p_rec.frequency :=
1482: per_asg_shd.g_old_rec.frequency;
1483: End If;
1484: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1485: p_rec.internal_address_line :=
1486: per_asg_shd.g_old_rec.internal_address_line;
1487: End If;
1488: If (p_rec.manager_flag = hr_api.g_varchar2) then

Line 1488: If (p_rec.manager_flag = hr_api.g_varchar2) then

1484: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1485: p_rec.internal_address_line :=
1486: per_asg_shd.g_old_rec.internal_address_line;
1487: End If;
1488: If (p_rec.manager_flag = hr_api.g_varchar2) then
1489: p_rec.manager_flag :=
1490: per_asg_shd.g_old_rec.manager_flag;
1491: End If;
1492: If (p_rec.normal_hours = hr_api.g_number) then

Line 1492: If (p_rec.normal_hours = hr_api.g_number) then

1488: If (p_rec.manager_flag = hr_api.g_varchar2) then
1489: p_rec.manager_flag :=
1490: per_asg_shd.g_old_rec.manager_flag;
1491: End If;
1492: If (p_rec.normal_hours = hr_api.g_number) then
1493: p_rec.normal_hours :=
1494: per_asg_shd.g_old_rec.normal_hours;
1495: End If;
1496: If (p_rec.perf_review_period = hr_api.g_number) then

Line 1496: If (p_rec.perf_review_period = hr_api.g_number) then

1492: If (p_rec.normal_hours = hr_api.g_number) then
1493: p_rec.normal_hours :=
1494: per_asg_shd.g_old_rec.normal_hours;
1495: End If;
1496: If (p_rec.perf_review_period = hr_api.g_number) then
1497: p_rec.perf_review_period :=
1498: per_asg_shd.g_old_rec.perf_review_period;
1499: End If;
1500: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then

Line 1500: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then

1496: If (p_rec.perf_review_period = hr_api.g_number) then
1497: p_rec.perf_review_period :=
1498: per_asg_shd.g_old_rec.perf_review_period;
1499: End If;
1500: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1501: p_rec.perf_review_period_frequency :=
1502: per_asg_shd.g_old_rec.perf_review_period_frequency;
1503: End If;
1504: If (p_rec.period_of_service_id = hr_api.g_number) then

Line 1504: If (p_rec.period_of_service_id = hr_api.g_number) then

1500: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1501: p_rec.perf_review_period_frequency :=
1502: per_asg_shd.g_old_rec.perf_review_period_frequency;
1503: End If;
1504: If (p_rec.period_of_service_id = hr_api.g_number) then
1505: p_rec.period_of_service_id :=
1506: per_asg_shd.g_old_rec.period_of_service_id;
1507: End If;
1508: If (p_rec.probation_period = hr_api.g_number) then

Line 1508: If (p_rec.probation_period = hr_api.g_number) then

1504: If (p_rec.period_of_service_id = hr_api.g_number) then
1505: p_rec.period_of_service_id :=
1506: per_asg_shd.g_old_rec.period_of_service_id;
1507: End If;
1508: If (p_rec.probation_period = hr_api.g_number) then
1509: p_rec.probation_period :=
1510: per_asg_shd.g_old_rec.probation_period;
1511: End If;
1512: If (p_rec.probation_unit = hr_api.g_varchar2) then

Line 1512: If (p_rec.probation_unit = hr_api.g_varchar2) then

1508: If (p_rec.probation_period = hr_api.g_number) then
1509: p_rec.probation_period :=
1510: per_asg_shd.g_old_rec.probation_period;
1511: End If;
1512: If (p_rec.probation_unit = hr_api.g_varchar2) then
1513: p_rec.probation_unit :=
1514: per_asg_shd.g_old_rec.probation_unit;
1515: End If;
1516: If (p_rec.sal_review_period = hr_api.g_number) then

Line 1516: If (p_rec.sal_review_period = hr_api.g_number) then

1512: If (p_rec.probation_unit = hr_api.g_varchar2) then
1513: p_rec.probation_unit :=
1514: per_asg_shd.g_old_rec.probation_unit;
1515: End If;
1516: If (p_rec.sal_review_period = hr_api.g_number) then
1517: p_rec.sal_review_period :=
1518: per_asg_shd.g_old_rec.sal_review_period;
1519: End If;
1520: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then

Line 1520: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then

1516: If (p_rec.sal_review_period = hr_api.g_number) then
1517: p_rec.sal_review_period :=
1518: per_asg_shd.g_old_rec.sal_review_period;
1519: End If;
1520: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then
1521: p_rec.sal_review_period_frequency :=
1522: per_asg_shd.g_old_rec.sal_review_period_frequency;
1523: End If;
1524: If (p_rec.set_of_books_id = hr_api.g_number) then

Line 1524: If (p_rec.set_of_books_id = hr_api.g_number) then

1520: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then
1521: p_rec.sal_review_period_frequency :=
1522: per_asg_shd.g_old_rec.sal_review_period_frequency;
1523: End If;
1524: If (p_rec.set_of_books_id = hr_api.g_number) then
1525: p_rec.set_of_books_id :=
1526: per_asg_shd.g_old_rec.set_of_books_id;
1527: End If;
1528: If (p_rec.source_type = hr_api.g_varchar2) then

Line 1528: If (p_rec.source_type = hr_api.g_varchar2) then

1524: If (p_rec.set_of_books_id = hr_api.g_number) then
1525: p_rec.set_of_books_id :=
1526: per_asg_shd.g_old_rec.set_of_books_id;
1527: End If;
1528: If (p_rec.source_type = hr_api.g_varchar2) then
1529: p_rec.source_type :=
1530: per_asg_shd.g_old_rec.source_type;
1531: End If;
1532: If (p_rec.time_normal_finish = hr_api.g_varchar2) then

Line 1532: If (p_rec.time_normal_finish = hr_api.g_varchar2) then

1528: If (p_rec.source_type = hr_api.g_varchar2) then
1529: p_rec.source_type :=
1530: per_asg_shd.g_old_rec.source_type;
1531: End If;
1532: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1533: p_rec.time_normal_finish :=
1534: per_asg_shd.g_old_rec.time_normal_finish;
1535: End If;
1536: If (p_rec.time_normal_start = hr_api.g_varchar2) then

Line 1536: If (p_rec.time_normal_start = hr_api.g_varchar2) then

1532: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1533: p_rec.time_normal_finish :=
1534: per_asg_shd.g_old_rec.time_normal_finish;
1535: End If;
1536: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1537: p_rec.time_normal_start :=
1538: per_asg_shd.g_old_rec.time_normal_start;
1539: End If;
1540: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then

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

1536: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1537: p_rec.time_normal_start :=
1538: per_asg_shd.g_old_rec.time_normal_start;
1539: End If;
1540: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1541: p_rec.bargaining_unit_code :=
1542: per_asg_shd.g_old_rec.bargaining_unit_code;
1543: End If;
1544: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then

Line 1544: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then

1540: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1541: p_rec.bargaining_unit_code :=
1542: per_asg_shd.g_old_rec.bargaining_unit_code;
1543: End If;
1544: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1545: p_rec.labour_union_member_flag :=
1546: per_asg_shd.g_old_rec.labour_union_member_flag;
1547: End If;
1548: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then

Line 1548: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then

1544: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1545: p_rec.labour_union_member_flag :=
1546: per_asg_shd.g_old_rec.labour_union_member_flag;
1547: End If;
1548: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1549: p_rec.hourly_salaried_code :=
1550: per_asg_shd.g_old_rec.hourly_salaried_code;
1551: End If;
1552: If (p_rec.request_id = hr_api.g_number) then

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

1548: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1549: p_rec.hourly_salaried_code :=
1550: per_asg_shd.g_old_rec.hourly_salaried_code;
1551: End If;
1552: If (p_rec.request_id = hr_api.g_number) then
1553: p_rec.request_id :=
1554: per_asg_shd.g_old_rec.request_id;
1555: End If;
1556: If (p_rec.program_application_id = hr_api.g_number) then

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

1552: If (p_rec.request_id = hr_api.g_number) then
1553: p_rec.request_id :=
1554: per_asg_shd.g_old_rec.request_id;
1555: End If;
1556: If (p_rec.program_application_id = hr_api.g_number) then
1557: p_rec.program_application_id :=
1558: per_asg_shd.g_old_rec.program_application_id;
1559: End If;
1560: If (p_rec.program_id = hr_api.g_number) then

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

1556: If (p_rec.program_application_id = hr_api.g_number) then
1557: p_rec.program_application_id :=
1558: per_asg_shd.g_old_rec.program_application_id;
1559: End If;
1560: If (p_rec.program_id = hr_api.g_number) then
1561: p_rec.program_id :=
1562: per_asg_shd.g_old_rec.program_id;
1563: End If;
1564: If (p_rec.program_update_date = hr_api.g_date) then

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

1560: If (p_rec.program_id = hr_api.g_number) then
1561: p_rec.program_id :=
1562: per_asg_shd.g_old_rec.program_id;
1563: End If;
1564: If (p_rec.program_update_date = hr_api.g_date) then
1565: p_rec.program_update_date :=
1566: per_asg_shd.g_old_rec.program_update_date;
1567: End If;
1568: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then

Line 1568: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then

1564: If (p_rec.program_update_date = hr_api.g_date) then
1565: p_rec.program_update_date :=
1566: per_asg_shd.g_old_rec.program_update_date;
1567: End If;
1568: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1569: p_rec.ass_attribute_category :=
1570: per_asg_shd.g_old_rec.ass_attribute_category;
1571: End If;
1572: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then

Line 1572: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then

1568: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1569: p_rec.ass_attribute_category :=
1570: per_asg_shd.g_old_rec.ass_attribute_category;
1571: End If;
1572: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1573: p_rec.ass_attribute1 :=
1574: per_asg_shd.g_old_rec.ass_attribute1;
1575: End If;
1576: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then

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

1572: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1573: p_rec.ass_attribute1 :=
1574: per_asg_shd.g_old_rec.ass_attribute1;
1575: End If;
1576: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1577: p_rec.ass_attribute2 :=
1578: per_asg_shd.g_old_rec.ass_attribute2;
1579: End If;
1580: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then

Line 1580: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then

1576: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1577: p_rec.ass_attribute2 :=
1578: per_asg_shd.g_old_rec.ass_attribute2;
1579: End If;
1580: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1581: p_rec.ass_attribute3 :=
1582: per_asg_shd.g_old_rec.ass_attribute3;
1583: End If;
1584: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then

Line 1584: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then

1580: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1581: p_rec.ass_attribute3 :=
1582: per_asg_shd.g_old_rec.ass_attribute3;
1583: End If;
1584: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1585: p_rec.ass_attribute4 :=
1586: per_asg_shd.g_old_rec.ass_attribute4;
1587: End If;
1588: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then

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

1584: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1585: p_rec.ass_attribute4 :=
1586: per_asg_shd.g_old_rec.ass_attribute4;
1587: End If;
1588: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1589: p_rec.ass_attribute5 :=
1590: per_asg_shd.g_old_rec.ass_attribute5;
1591: End If;
1592: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then

Line 1592: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then

1588: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1589: p_rec.ass_attribute5 :=
1590: per_asg_shd.g_old_rec.ass_attribute5;
1591: End If;
1592: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1593: p_rec.ass_attribute6 :=
1594: per_asg_shd.g_old_rec.ass_attribute6;
1595: End If;
1596: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then

Line 1596: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then

1592: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1593: p_rec.ass_attribute6 :=
1594: per_asg_shd.g_old_rec.ass_attribute6;
1595: End If;
1596: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1597: p_rec.ass_attribute7 :=
1598: per_asg_shd.g_old_rec.ass_attribute7;
1599: End If;
1600: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then

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

1596: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1597: p_rec.ass_attribute7 :=
1598: per_asg_shd.g_old_rec.ass_attribute7;
1599: End If;
1600: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1601: p_rec.ass_attribute8 :=
1602: per_asg_shd.g_old_rec.ass_attribute8;
1603: End If;
1604: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then

Line 1604: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then

1600: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1601: p_rec.ass_attribute8 :=
1602: per_asg_shd.g_old_rec.ass_attribute8;
1603: End If;
1604: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1605: p_rec.ass_attribute9 :=
1606: per_asg_shd.g_old_rec.ass_attribute9;
1607: End If;
1608: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then

Line 1608: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then

1604: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1605: p_rec.ass_attribute9 :=
1606: per_asg_shd.g_old_rec.ass_attribute9;
1607: End If;
1608: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1609: p_rec.ass_attribute10 :=
1610: per_asg_shd.g_old_rec.ass_attribute10;
1611: End If;
1612: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then

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

1608: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1609: p_rec.ass_attribute10 :=
1610: per_asg_shd.g_old_rec.ass_attribute10;
1611: End If;
1612: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1613: p_rec.ass_attribute11 :=
1614: per_asg_shd.g_old_rec.ass_attribute11;
1615: End If;
1616: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then

Line 1616: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then

1612: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1613: p_rec.ass_attribute11 :=
1614: per_asg_shd.g_old_rec.ass_attribute11;
1615: End If;
1616: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1617: p_rec.ass_attribute12 :=
1618: per_asg_shd.g_old_rec.ass_attribute12;
1619: End If;
1620: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then

Line 1620: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then

1616: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1617: p_rec.ass_attribute12 :=
1618: per_asg_shd.g_old_rec.ass_attribute12;
1619: End If;
1620: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1621: p_rec.ass_attribute13 :=
1622: per_asg_shd.g_old_rec.ass_attribute13;
1623: End If;
1624: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then

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

1620: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1621: p_rec.ass_attribute13 :=
1622: per_asg_shd.g_old_rec.ass_attribute13;
1623: End If;
1624: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1625: p_rec.ass_attribute14 :=
1626: per_asg_shd.g_old_rec.ass_attribute14;
1627: End If;
1628: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then

Line 1628: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then

1624: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1625: p_rec.ass_attribute14 :=
1626: per_asg_shd.g_old_rec.ass_attribute14;
1627: End If;
1628: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1629: p_rec.ass_attribute15 :=
1630: per_asg_shd.g_old_rec.ass_attribute15;
1631: End If;
1632: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then

Line 1632: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then

1628: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1629: p_rec.ass_attribute15 :=
1630: per_asg_shd.g_old_rec.ass_attribute15;
1631: End If;
1632: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1633: p_rec.ass_attribute16 :=
1634: per_asg_shd.g_old_rec.ass_attribute16;
1635: End If;
1636: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then

Line 1636: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then

1632: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1633: p_rec.ass_attribute16 :=
1634: per_asg_shd.g_old_rec.ass_attribute16;
1635: End If;
1636: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1637: p_rec.ass_attribute17 :=
1638: per_asg_shd.g_old_rec.ass_attribute17;
1639: End If;
1640: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then

Line 1640: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then

1636: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1637: p_rec.ass_attribute17 :=
1638: per_asg_shd.g_old_rec.ass_attribute17;
1639: End If;
1640: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1641: p_rec.ass_attribute18 :=
1642: per_asg_shd.g_old_rec.ass_attribute18;
1643: End If;
1644: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then

Line 1644: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then

1640: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1641: p_rec.ass_attribute18 :=
1642: per_asg_shd.g_old_rec.ass_attribute18;
1643: End If;
1644: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1645: p_rec.ass_attribute19 :=
1646: per_asg_shd.g_old_rec.ass_attribute19;
1647: End If;
1648: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then

Line 1648: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then

1644: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1645: p_rec.ass_attribute19 :=
1646: per_asg_shd.g_old_rec.ass_attribute19;
1647: End If;
1648: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1649: p_rec.ass_attribute20 :=
1650: per_asg_shd.g_old_rec.ass_attribute20;
1651: End If;
1652: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then

Line 1652: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then

1648: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1649: p_rec.ass_attribute20 :=
1650: per_asg_shd.g_old_rec.ass_attribute20;
1651: End If;
1652: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1653: p_rec.ass_attribute21 :=
1654: per_asg_shd.g_old_rec.ass_attribute21;
1655: End If;
1656: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then

Line 1656: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then

1652: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1653: p_rec.ass_attribute21 :=
1654: per_asg_shd.g_old_rec.ass_attribute21;
1655: End If;
1656: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1657: p_rec.ass_attribute22 :=
1658: per_asg_shd.g_old_rec.ass_attribute22;
1659: End If;
1660: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then

Line 1660: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then

1656: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1657: p_rec.ass_attribute22 :=
1658: per_asg_shd.g_old_rec.ass_attribute22;
1659: End If;
1660: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1661: p_rec.ass_attribute23 :=
1662: per_asg_shd.g_old_rec.ass_attribute23;
1663: End If;
1664: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then

Line 1664: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then

1660: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1661: p_rec.ass_attribute23 :=
1662: per_asg_shd.g_old_rec.ass_attribute23;
1663: End If;
1664: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1665: p_rec.ass_attribute24 :=
1666: per_asg_shd.g_old_rec.ass_attribute24;
1667: End If;
1668: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then

Line 1668: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then

1664: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1665: p_rec.ass_attribute24 :=
1666: per_asg_shd.g_old_rec.ass_attribute24;
1667: End If;
1668: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1669: p_rec.ass_attribute25 :=
1670: per_asg_shd.g_old_rec.ass_attribute25;
1671: End If;
1672: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then

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

1668: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1669: p_rec.ass_attribute25 :=
1670: per_asg_shd.g_old_rec.ass_attribute25;
1671: End If;
1672: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1673: p_rec.ass_attribute26 :=
1674: per_asg_shd.g_old_rec.ass_attribute26;
1675: End If;
1676: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then

Line 1676: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then

1672: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1673: p_rec.ass_attribute26 :=
1674: per_asg_shd.g_old_rec.ass_attribute26;
1675: End If;
1676: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1677: p_rec.ass_attribute27 :=
1678: per_asg_shd.g_old_rec.ass_attribute27;
1679: End If;
1680: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then

Line 1680: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then

1676: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1677: p_rec.ass_attribute27 :=
1678: per_asg_shd.g_old_rec.ass_attribute27;
1679: End If;
1680: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1681: p_rec.ass_attribute28 :=
1682: per_asg_shd.g_old_rec.ass_attribute28;
1683: End If;
1684: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then

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

1680: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1681: p_rec.ass_attribute28 :=
1682: per_asg_shd.g_old_rec.ass_attribute28;
1683: End If;
1684: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1685: p_rec.ass_attribute29 :=
1686: per_asg_shd.g_old_rec.ass_attribute29;
1687: End If;
1688: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then

Line 1688: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then

1684: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1685: p_rec.ass_attribute29 :=
1686: per_asg_shd.g_old_rec.ass_attribute29;
1687: End If;
1688: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1689: p_rec.ass_attribute30 :=
1690: per_asg_shd.g_old_rec.ass_attribute30;
1691: End If;
1692: If (p_rec.title = hr_api.g_varchar2) then

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

1688: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1689: p_rec.ass_attribute30 :=
1690: per_asg_shd.g_old_rec.ass_attribute30;
1691: End If;
1692: If (p_rec.title = hr_api.g_varchar2) then
1693: p_rec.title :=
1694: per_asg_shd.g_old_rec.title;
1695: End If;
1696: If (p_rec.contract_id = hr_api.g_number) then

Line 1696: If (p_rec.contract_id = hr_api.g_number) then

1692: If (p_rec.title = hr_api.g_varchar2) then
1693: p_rec.title :=
1694: per_asg_shd.g_old_rec.title;
1695: End If;
1696: If (p_rec.contract_id = hr_api.g_number) then
1697: p_rec.contract_id :=
1698: per_asg_shd.g_old_rec.contract_id;
1699: End If;
1700: If (p_rec.establishment_id = hr_api.g_number) then

Line 1700: If (p_rec.establishment_id = hr_api.g_number) then

1696: If (p_rec.contract_id = hr_api.g_number) then
1697: p_rec.contract_id :=
1698: per_asg_shd.g_old_rec.contract_id;
1699: End If;
1700: If (p_rec.establishment_id = hr_api.g_number) then
1701: p_rec.establishment_id :=
1702: per_asg_shd.g_old_rec.establishment_id;
1703: End If;
1704: If (p_rec.collective_agreement_id = hr_api.g_number) then

Line 1704: If (p_rec.collective_agreement_id = hr_api.g_number) then

1700: If (p_rec.establishment_id = hr_api.g_number) then
1701: p_rec.establishment_id :=
1702: per_asg_shd.g_old_rec.establishment_id;
1703: End If;
1704: If (p_rec.collective_agreement_id = hr_api.g_number) then
1705: p_rec.collective_agreement_id :=
1706: per_asg_shd.g_old_rec.collective_agreement_id;
1707: End If;
1708: If (p_rec.cagr_grade_def_id = hr_api.g_number) then

Line 1708: If (p_rec.cagr_grade_def_id = hr_api.g_number) then

1704: If (p_rec.collective_agreement_id = hr_api.g_number) then
1705: p_rec.collective_agreement_id :=
1706: per_asg_shd.g_old_rec.collective_agreement_id;
1707: End If;
1708: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1709: p_rec.cagr_grade_def_id :=
1710: per_asg_shd.g_old_rec.cagr_grade_def_id;
1711: End If;
1712: If (p_rec.cagr_id_flex_num = hr_api.g_number) then

Line 1712: If (p_rec.cagr_id_flex_num = hr_api.g_number) then

1708: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1709: p_rec.cagr_grade_def_id :=
1710: per_asg_shd.g_old_rec.cagr_grade_def_id;
1711: End If;
1712: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1713: p_rec.cagr_id_flex_num :=
1714: per_asg_shd.g_old_rec.cagr_id_flex_num;
1715: End If;
1716: If (p_rec.notice_period = hr_api.g_number) then

Line 1716: If (p_rec.notice_period = hr_api.g_number) then

1712: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1713: p_rec.cagr_id_flex_num :=
1714: per_asg_shd.g_old_rec.cagr_id_flex_num;
1715: End If;
1716: If (p_rec.notice_period = hr_api.g_number) then
1717: p_rec.notice_period :=
1718: per_asg_shd.g_old_rec.notice_period;
1719: End If;
1720: If (p_rec.notice_period_uom = hr_api.g_varchar2) then

Line 1720: If (p_rec.notice_period_uom = hr_api.g_varchar2) then

1716: If (p_rec.notice_period = hr_api.g_number) then
1717: p_rec.notice_period :=
1718: per_asg_shd.g_old_rec.notice_period;
1719: End If;
1720: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1721: p_rec.notice_period_uom :=
1722: per_asg_shd.g_old_rec.notice_period_uom;
1723: End If;
1724: If (p_rec.employee_category = hr_api.g_varchar2) then

Line 1724: If (p_rec.employee_category = hr_api.g_varchar2) then

1720: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1721: p_rec.notice_period_uom :=
1722: per_asg_shd.g_old_rec.notice_period_uom;
1723: End If;
1724: If (p_rec.employee_category = hr_api.g_varchar2) then
1725: p_rec.employee_category :=
1726: per_asg_shd.g_old_rec.employee_category;
1727: End If;
1728: If (p_rec.work_at_home = hr_api.g_varchar2) then

Line 1728: If (p_rec.work_at_home = hr_api.g_varchar2) then

1724: If (p_rec.employee_category = hr_api.g_varchar2) then
1725: p_rec.employee_category :=
1726: per_asg_shd.g_old_rec.employee_category;
1727: End If;
1728: If (p_rec.work_at_home = hr_api.g_varchar2) then
1729: p_rec.work_at_home :=
1730: per_asg_shd.g_old_rec.work_at_home;
1731: End If;
1732: If (p_rec.job_post_source_name = hr_api.g_varchar2) then

Line 1732: If (p_rec.job_post_source_name = hr_api.g_varchar2) then

1728: If (p_rec.work_at_home = hr_api.g_varchar2) then
1729: p_rec.work_at_home :=
1730: per_asg_shd.g_old_rec.work_at_home;
1731: End If;
1732: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1733: p_rec.job_post_source_name :=
1734: per_asg_shd.g_old_rec.job_post_source_name;
1735: End If;
1736: If (p_rec.posting_content_id = hr_api.g_number) then

Line 1736: If (p_rec.posting_content_id = hr_api.g_number) then

1732: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1733: p_rec.job_post_source_name :=
1734: per_asg_shd.g_old_rec.job_post_source_name;
1735: End If;
1736: If (p_rec.posting_content_id = hr_api.g_number) then
1737: p_rec.posting_content_id :=
1738: per_asg_shd.g_old_rec.posting_content_id;
1739: End If;
1740: If (p_rec.period_of_placement_date_start = hr_api.g_date) then

Line 1740: If (p_rec.period_of_placement_date_start = hr_api.g_date) then

1736: If (p_rec.posting_content_id = hr_api.g_number) then
1737: p_rec.posting_content_id :=
1738: per_asg_shd.g_old_rec.posting_content_id;
1739: End If;
1740: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1741: p_rec.period_of_placement_date_start :=
1742: per_asg_shd.g_old_rec.period_of_placement_date_start;
1743: End If;
1744: If (p_rec.vendor_id = hr_api.g_number) then

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

1740: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1741: p_rec.period_of_placement_date_start :=
1742: per_asg_shd.g_old_rec.period_of_placement_date_start;
1743: End If;
1744: If (p_rec.vendor_id = hr_api.g_number) then
1745: p_rec.vendor_id :=
1746: per_asg_shd.g_old_rec.vendor_id;
1747: End If;
1748: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then

Line 1748: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then

1744: If (p_rec.vendor_id = hr_api.g_number) then
1745: p_rec.vendor_id :=
1746: per_asg_shd.g_old_rec.vendor_id;
1747: End If;
1748: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1749: p_rec.vendor_employee_number :=
1750: per_asg_shd.g_old_rec.vendor_employee_number;
1751: End If;
1752: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then

Line 1752: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then

1748: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1749: p_rec.vendor_employee_number :=
1750: per_asg_shd.g_old_rec.vendor_employee_number;
1751: End If;
1752: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1753: p_rec.vendor_assignment_number :=
1754: per_asg_shd.g_old_rec.vendor_assignment_number;
1755: End If;
1756: If (p_rec.assignment_category = hr_api.g_varchar2) then

Line 1756: If (p_rec.assignment_category = hr_api.g_varchar2) then

1752: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1753: p_rec.vendor_assignment_number :=
1754: per_asg_shd.g_old_rec.vendor_assignment_number;
1755: End If;
1756: If (p_rec.assignment_category = hr_api.g_varchar2) then
1757: p_rec.assignment_category :=
1758: per_asg_shd.g_old_rec.assignment_category;
1759: End If;
1760: If (p_rec.project_title = hr_api.g_varchar2) then

Line 1760: If (p_rec.project_title = hr_api.g_varchar2) then

1756: If (p_rec.assignment_category = hr_api.g_varchar2) then
1757: p_rec.assignment_category :=
1758: per_asg_shd.g_old_rec.assignment_category;
1759: End If;
1760: If (p_rec.project_title = hr_api.g_varchar2) then
1761: p_rec.project_title :=
1762: per_asg_shd.g_old_rec.project_title;
1763: End If;
1764: If (p_rec.applicant_rank = hr_api.g_number) then

Line 1764: If (p_rec.applicant_rank = hr_api.g_number) then

1760: If (p_rec.project_title = hr_api.g_varchar2) then
1761: p_rec.project_title :=
1762: per_asg_shd.g_old_rec.project_title;
1763: End If;
1764: If (p_rec.applicant_rank = hr_api.g_number) then
1765: p_rec.applicant_rank :=
1766: per_asg_shd.g_old_rec.applicant_rank;
1767: End If;
1768: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then

Line 1768: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then

1764: If (p_rec.applicant_rank = hr_api.g_number) then
1765: p_rec.applicant_rank :=
1766: per_asg_shd.g_old_rec.applicant_rank;
1767: End If;
1768: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then
1769: p_rec.grade_ladder_pgm_id :=
1770: per_asg_shd.g_old_rec.grade_ladder_pgm_id;
1771: End If;
1772: If (p_rec.supervisor_assignment_id = hr_api.g_number) then

Line 1772: If (p_rec.supervisor_assignment_id = hr_api.g_number) then

1768: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then
1769: p_rec.grade_ladder_pgm_id :=
1770: per_asg_shd.g_old_rec.grade_ladder_pgm_id;
1771: End If;
1772: If (p_rec.supervisor_assignment_id = hr_api.g_number) then
1773: p_rec.supervisor_assignment_id :=
1774: per_asg_shd.g_old_rec.supervisor_assignment_id;
1775: End If;
1776: If (p_rec.vendor_site_id = hr_api.g_number) then

Line 1776: If (p_rec.vendor_site_id = hr_api.g_number) then

1772: If (p_rec.supervisor_assignment_id = hr_api.g_number) then
1773: p_rec.supervisor_assignment_id :=
1774: per_asg_shd.g_old_rec.supervisor_assignment_id;
1775: End If;
1776: If (p_rec.vendor_site_id = hr_api.g_number) then
1777: p_rec.vendor_site_id :=
1778: per_asg_shd.g_old_rec.vendor_site_id;
1779: End If;
1780: If (p_rec.po_header_id = hr_api.g_number) then

Line 1780: If (p_rec.po_header_id = hr_api.g_number) then

1776: If (p_rec.vendor_site_id = hr_api.g_number) then
1777: p_rec.vendor_site_id :=
1778: per_asg_shd.g_old_rec.vendor_site_id;
1779: End If;
1780: If (p_rec.po_header_id = hr_api.g_number) then
1781: p_rec.po_header_id :=
1782: per_asg_shd.g_old_rec.po_header_id;
1783: End If;
1784: If (p_rec.po_line_id = hr_api.g_number) then

Line 1784: If (p_rec.po_line_id = hr_api.g_number) then

1780: If (p_rec.po_header_id = hr_api.g_number) then
1781: p_rec.po_header_id :=
1782: per_asg_shd.g_old_rec.po_header_id;
1783: End If;
1784: If (p_rec.po_line_id = hr_api.g_number) then
1785: p_rec.po_line_id :=
1786: per_asg_shd.g_old_rec.po_line_id;
1787: End If;
1788: If (p_rec.projected_assignment_end = hr_api.g_date) then

Line 1788: If (p_rec.projected_assignment_end = hr_api.g_date) then

1784: If (p_rec.po_line_id = hr_api.g_number) then
1785: p_rec.po_line_id :=
1786: per_asg_shd.g_old_rec.po_line_id;
1787: End If;
1788: If (p_rec.projected_assignment_end = hr_api.g_date) then
1789: p_rec.projected_assignment_end :=
1790: per_asg_shd.g_old_rec.projected_assignment_end;
1791: End If;
1792: --

Line 2082: Raise HR_Api.Validate_Enabled;

2078: --
2079: -- If we are validating then raise the Validate_Enabled exception
2080: --
2081: If p_validate then
2082: Raise HR_Api.Validate_Enabled;
2083: End If;
2084: --
2085: hr_utility.set_location(' Leaving:'||l_proc, 10);
2086: Exception

Line 2087: When HR_Api.Validate_Enabled Then

2083: End If;
2084: --
2085: hr_utility.set_location(' Leaving:'||l_proc, 10);
2086: Exception
2087: When HR_Api.Validate_Enabled Then
2088: --
2089: -- As the Validate_Enabled exception has been raised
2090: -- we must rollback to the savepoint
2091: --

Line 2105: p_recruiter_id in number default hr_api.g_number,

2101: p_effective_start_date out nocopy date,
2102: p_effective_end_date out nocopy date,
2103:
2104: p_business_group_id out nocopy number,
2105: p_recruiter_id in number default hr_api.g_number,
2106: p_grade_id in number default hr_api.g_number,
2107: p_position_id in number default hr_api.g_number,
2108: p_job_id in number default hr_api.g_number,
2109: p_assignment_status_type_id in number default hr_api.g_number,

Line 2106: p_grade_id in number default hr_api.g_number,

2102: p_effective_end_date out nocopy date,
2103:
2104: p_business_group_id out nocopy number,
2105: p_recruiter_id in number default hr_api.g_number,
2106: p_grade_id in number default hr_api.g_number,
2107: p_position_id in number default hr_api.g_number,
2108: p_job_id in number default hr_api.g_number,
2109: p_assignment_status_type_id in number default hr_api.g_number,
2110: p_payroll_id in number default hr_api.g_number,

Line 2107: p_position_id in number default hr_api.g_number,

2103:
2104: p_business_group_id out nocopy number,
2105: p_recruiter_id in number default hr_api.g_number,
2106: p_grade_id in number default hr_api.g_number,
2107: p_position_id in number default hr_api.g_number,
2108: p_job_id in number default hr_api.g_number,
2109: p_assignment_status_type_id in number default hr_api.g_number,
2110: p_payroll_id in number default hr_api.g_number,
2111: p_location_id in number default hr_api.g_number,

Line 2108: p_job_id in number default hr_api.g_number,

2104: p_business_group_id out nocopy number,
2105: p_recruiter_id in number default hr_api.g_number,
2106: p_grade_id in number default hr_api.g_number,
2107: p_position_id in number default hr_api.g_number,
2108: p_job_id in number default hr_api.g_number,
2109: p_assignment_status_type_id in number default hr_api.g_number,
2110: p_payroll_id in number default hr_api.g_number,
2111: p_location_id in number default hr_api.g_number,
2112: p_person_referred_by_id in number default hr_api.g_number,

Line 2109: p_assignment_status_type_id in number default hr_api.g_number,

2105: p_recruiter_id in number default hr_api.g_number,
2106: p_grade_id in number default hr_api.g_number,
2107: p_position_id in number default hr_api.g_number,
2108: p_job_id in number default hr_api.g_number,
2109: p_assignment_status_type_id in number default hr_api.g_number,
2110: p_payroll_id in number default hr_api.g_number,
2111: p_location_id in number default hr_api.g_number,
2112: p_person_referred_by_id in number default hr_api.g_number,
2113: p_supervisor_id in number default hr_api.g_number,

Line 2110: p_payroll_id in number default hr_api.g_number,

2106: p_grade_id in number default hr_api.g_number,
2107: p_position_id in number default hr_api.g_number,
2108: p_job_id in number default hr_api.g_number,
2109: p_assignment_status_type_id in number default hr_api.g_number,
2110: p_payroll_id in number default hr_api.g_number,
2111: p_location_id in number default hr_api.g_number,
2112: p_person_referred_by_id in number default hr_api.g_number,
2113: p_supervisor_id in number default hr_api.g_number,
2114: p_special_ceiling_step_id in number default hr_api.g_number,

Line 2111: p_location_id in number default hr_api.g_number,

2107: p_position_id in number default hr_api.g_number,
2108: p_job_id in number default hr_api.g_number,
2109: p_assignment_status_type_id in number default hr_api.g_number,
2110: p_payroll_id in number default hr_api.g_number,
2111: p_location_id in number default hr_api.g_number,
2112: p_person_referred_by_id in number default hr_api.g_number,
2113: p_supervisor_id in number default hr_api.g_number,
2114: p_special_ceiling_step_id in number default hr_api.g_number,
2115: p_recruitment_activity_id in number default hr_api.g_number,

Line 2112: p_person_referred_by_id in number default hr_api.g_number,

2108: p_job_id in number default hr_api.g_number,
2109: p_assignment_status_type_id in number default hr_api.g_number,
2110: p_payroll_id in number default hr_api.g_number,
2111: p_location_id in number default hr_api.g_number,
2112: p_person_referred_by_id in number default hr_api.g_number,
2113: p_supervisor_id in number default hr_api.g_number,
2114: p_special_ceiling_step_id in number default hr_api.g_number,
2115: p_recruitment_activity_id in number default hr_api.g_number,
2116: p_source_organization_id in number default hr_api.g_number,

Line 2113: p_supervisor_id in number default hr_api.g_number,

2109: p_assignment_status_type_id in number default hr_api.g_number,
2110: p_payroll_id in number default hr_api.g_number,
2111: p_location_id in number default hr_api.g_number,
2112: p_person_referred_by_id in number default hr_api.g_number,
2113: p_supervisor_id in number default hr_api.g_number,
2114: p_special_ceiling_step_id in number default hr_api.g_number,
2115: p_recruitment_activity_id in number default hr_api.g_number,
2116: p_source_organization_id in number default hr_api.g_number,
2117:

Line 2114: p_special_ceiling_step_id in number default hr_api.g_number,

2110: p_payroll_id in number default hr_api.g_number,
2111: p_location_id in number default hr_api.g_number,
2112: p_person_referred_by_id in number default hr_api.g_number,
2113: p_supervisor_id in number default hr_api.g_number,
2114: p_special_ceiling_step_id in number default hr_api.g_number,
2115: p_recruitment_activity_id in number default hr_api.g_number,
2116: p_source_organization_id in number default hr_api.g_number,
2117:
2118: p_organization_id in number default hr_api.g_number,

Line 2115: p_recruitment_activity_id in number default hr_api.g_number,

2111: p_location_id in number default hr_api.g_number,
2112: p_person_referred_by_id in number default hr_api.g_number,
2113: p_supervisor_id in number default hr_api.g_number,
2114: p_special_ceiling_step_id in number default hr_api.g_number,
2115: p_recruitment_activity_id in number default hr_api.g_number,
2116: p_source_organization_id in number default hr_api.g_number,
2117:
2118: p_organization_id in number default hr_api.g_number,
2119: p_people_group_id in number default hr_api.g_number,

Line 2116: p_source_organization_id in number default hr_api.g_number,

2112: p_person_referred_by_id in number default hr_api.g_number,
2113: p_supervisor_id in number default hr_api.g_number,
2114: p_special_ceiling_step_id in number default hr_api.g_number,
2115: p_recruitment_activity_id in number default hr_api.g_number,
2116: p_source_organization_id in number default hr_api.g_number,
2117:
2118: p_organization_id in number default hr_api.g_number,
2119: p_people_group_id in number default hr_api.g_number,
2120: p_soft_coding_keyflex_id in number default hr_api.g_number,

Line 2118: p_organization_id in number default hr_api.g_number,

2114: p_special_ceiling_step_id in number default hr_api.g_number,
2115: p_recruitment_activity_id in number default hr_api.g_number,
2116: p_source_organization_id in number default hr_api.g_number,
2117:
2118: p_organization_id in number default hr_api.g_number,
2119: p_people_group_id in number default hr_api.g_number,
2120: p_soft_coding_keyflex_id in number default hr_api.g_number,
2121: p_vacancy_id in number default hr_api.g_number,
2122: p_pay_basis_id in number default hr_api.g_number,

Line 2119: p_people_group_id in number default hr_api.g_number,

2115: p_recruitment_activity_id in number default hr_api.g_number,
2116: p_source_organization_id in number default hr_api.g_number,
2117:
2118: p_organization_id in number default hr_api.g_number,
2119: p_people_group_id in number default hr_api.g_number,
2120: p_soft_coding_keyflex_id in number default hr_api.g_number,
2121: p_vacancy_id in number default hr_api.g_number,
2122: p_pay_basis_id in number default hr_api.g_number,
2123: p_assignment_type in varchar2 default hr_api.g_varchar2,

Line 2120: p_soft_coding_keyflex_id in number default hr_api.g_number,

2116: p_source_organization_id in number default hr_api.g_number,
2117:
2118: p_organization_id in number default hr_api.g_number,
2119: p_people_group_id in number default hr_api.g_number,
2120: p_soft_coding_keyflex_id in number default hr_api.g_number,
2121: p_vacancy_id in number default hr_api.g_number,
2122: p_pay_basis_id in number default hr_api.g_number,
2123: p_assignment_type in varchar2 default hr_api.g_varchar2,
2124: p_primary_flag in varchar2 default hr_api.g_varchar2,

Line 2121: p_vacancy_id in number default hr_api.g_number,

2117:
2118: p_organization_id in number default hr_api.g_number,
2119: p_people_group_id in number default hr_api.g_number,
2120: p_soft_coding_keyflex_id in number default hr_api.g_number,
2121: p_vacancy_id in number default hr_api.g_number,
2122: p_pay_basis_id in number default hr_api.g_number,
2123: p_assignment_type in varchar2 default hr_api.g_varchar2,
2124: p_primary_flag in varchar2 default hr_api.g_varchar2,
2125: p_application_id in number default hr_api.g_number,

Line 2122: p_pay_basis_id in number default hr_api.g_number,

2118: p_organization_id in number default hr_api.g_number,
2119: p_people_group_id in number default hr_api.g_number,
2120: p_soft_coding_keyflex_id in number default hr_api.g_number,
2121: p_vacancy_id in number default hr_api.g_number,
2122: p_pay_basis_id in number default hr_api.g_number,
2123: p_assignment_type in varchar2 default hr_api.g_varchar2,
2124: p_primary_flag in varchar2 default hr_api.g_varchar2,
2125: p_application_id in number default hr_api.g_number,
2126: p_assignment_number in varchar2 default hr_api.g_varchar2,

Line 2123: p_assignment_type in varchar2 default hr_api.g_varchar2,

2119: p_people_group_id in number default hr_api.g_number,
2120: p_soft_coding_keyflex_id in number default hr_api.g_number,
2121: p_vacancy_id in number default hr_api.g_number,
2122: p_pay_basis_id in number default hr_api.g_number,
2123: p_assignment_type in varchar2 default hr_api.g_varchar2,
2124: p_primary_flag in varchar2 default hr_api.g_varchar2,
2125: p_application_id in number default hr_api.g_number,
2126: p_assignment_number in varchar2 default hr_api.g_varchar2,
2127: p_change_reason in varchar2 default hr_api.g_varchar2,

Line 2124: p_primary_flag in varchar2 default hr_api.g_varchar2,

2120: p_soft_coding_keyflex_id in number default hr_api.g_number,
2121: p_vacancy_id in number default hr_api.g_number,
2122: p_pay_basis_id in number default hr_api.g_number,
2123: p_assignment_type in varchar2 default hr_api.g_varchar2,
2124: p_primary_flag in varchar2 default hr_api.g_varchar2,
2125: p_application_id in number default hr_api.g_number,
2126: p_assignment_number in varchar2 default hr_api.g_varchar2,
2127: p_change_reason in varchar2 default hr_api.g_varchar2,
2128: p_comment_id out nocopy number,

Line 2125: p_application_id in number default hr_api.g_number,

2121: p_vacancy_id in number default hr_api.g_number,
2122: p_pay_basis_id in number default hr_api.g_number,
2123: p_assignment_type in varchar2 default hr_api.g_varchar2,
2124: p_primary_flag in varchar2 default hr_api.g_varchar2,
2125: p_application_id in number default hr_api.g_number,
2126: p_assignment_number in varchar2 default hr_api.g_varchar2,
2127: p_change_reason in varchar2 default hr_api.g_varchar2,
2128: p_comment_id out nocopy number,
2129: p_comments in varchar2 default hr_api.g_varchar2,

Line 2126: p_assignment_number in varchar2 default hr_api.g_varchar2,

2122: p_pay_basis_id in number default hr_api.g_number,
2123: p_assignment_type in varchar2 default hr_api.g_varchar2,
2124: p_primary_flag in varchar2 default hr_api.g_varchar2,
2125: p_application_id in number default hr_api.g_number,
2126: p_assignment_number in varchar2 default hr_api.g_varchar2,
2127: p_change_reason in varchar2 default hr_api.g_varchar2,
2128: p_comment_id out nocopy number,
2129: p_comments in varchar2 default hr_api.g_varchar2,
2130: p_date_probation_end in date default hr_api.g_date,

Line 2127: p_change_reason in varchar2 default hr_api.g_varchar2,

2123: p_assignment_type in varchar2 default hr_api.g_varchar2,
2124: p_primary_flag in varchar2 default hr_api.g_varchar2,
2125: p_application_id in number default hr_api.g_number,
2126: p_assignment_number in varchar2 default hr_api.g_varchar2,
2127: p_change_reason in varchar2 default hr_api.g_varchar2,
2128: p_comment_id out nocopy number,
2129: p_comments in varchar2 default hr_api.g_varchar2,
2130: p_date_probation_end in date default hr_api.g_date,
2131:

Line 2129: p_comments in varchar2 default hr_api.g_varchar2,

2125: p_application_id in number default hr_api.g_number,
2126: p_assignment_number in varchar2 default hr_api.g_varchar2,
2127: p_change_reason in varchar2 default hr_api.g_varchar2,
2128: p_comment_id out nocopy number,
2129: p_comments in varchar2 default hr_api.g_varchar2,
2130: p_date_probation_end in date default hr_api.g_date,
2131:
2132: p_default_code_comb_id in number default hr_api.g_number,
2133: p_employment_category in varchar2 default hr_api.g_varchar2,

Line 2130: p_date_probation_end in date default hr_api.g_date,

2126: p_assignment_number in varchar2 default hr_api.g_varchar2,
2127: p_change_reason in varchar2 default hr_api.g_varchar2,
2128: p_comment_id out nocopy number,
2129: p_comments in varchar2 default hr_api.g_varchar2,
2130: p_date_probation_end in date default hr_api.g_date,
2131:
2132: p_default_code_comb_id in number default hr_api.g_number,
2133: p_employment_category in varchar2 default hr_api.g_varchar2,
2134: p_frequency in varchar2 default hr_api.g_varchar2,

Line 2132: p_default_code_comb_id in number default hr_api.g_number,

2128: p_comment_id out nocopy number,
2129: p_comments in varchar2 default hr_api.g_varchar2,
2130: p_date_probation_end in date default hr_api.g_date,
2131:
2132: p_default_code_comb_id in number default hr_api.g_number,
2133: p_employment_category in varchar2 default hr_api.g_varchar2,
2134: p_frequency in varchar2 default hr_api.g_varchar2,
2135: p_internal_address_line in varchar2 default hr_api.g_varchar2,
2136: p_manager_flag in varchar2 default hr_api.g_varchar2,

Line 2133: p_employment_category in varchar2 default hr_api.g_varchar2,

2129: p_comments in varchar2 default hr_api.g_varchar2,
2130: p_date_probation_end in date default hr_api.g_date,
2131:
2132: p_default_code_comb_id in number default hr_api.g_number,
2133: p_employment_category in varchar2 default hr_api.g_varchar2,
2134: p_frequency in varchar2 default hr_api.g_varchar2,
2135: p_internal_address_line in varchar2 default hr_api.g_varchar2,
2136: p_manager_flag in varchar2 default hr_api.g_varchar2,
2137: p_normal_hours in number default hr_api.g_number,

Line 2134: p_frequency in varchar2 default hr_api.g_varchar2,

2130: p_date_probation_end in date default hr_api.g_date,
2131:
2132: p_default_code_comb_id in number default hr_api.g_number,
2133: p_employment_category in varchar2 default hr_api.g_varchar2,
2134: p_frequency in varchar2 default hr_api.g_varchar2,
2135: p_internal_address_line in varchar2 default hr_api.g_varchar2,
2136: p_manager_flag in varchar2 default hr_api.g_varchar2,
2137: p_normal_hours in number default hr_api.g_number,
2138: p_perf_review_period in number default hr_api.g_number,

Line 2135: p_internal_address_line in varchar2 default hr_api.g_varchar2,

2131:
2132: p_default_code_comb_id in number default hr_api.g_number,
2133: p_employment_category in varchar2 default hr_api.g_varchar2,
2134: p_frequency in varchar2 default hr_api.g_varchar2,
2135: p_internal_address_line in varchar2 default hr_api.g_varchar2,
2136: p_manager_flag in varchar2 default hr_api.g_varchar2,
2137: p_normal_hours in number default hr_api.g_number,
2138: p_perf_review_period in number default hr_api.g_number,
2139: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,

Line 2136: p_manager_flag in varchar2 default hr_api.g_varchar2,

2132: p_default_code_comb_id in number default hr_api.g_number,
2133: p_employment_category in varchar2 default hr_api.g_varchar2,
2134: p_frequency in varchar2 default hr_api.g_varchar2,
2135: p_internal_address_line in varchar2 default hr_api.g_varchar2,
2136: p_manager_flag in varchar2 default hr_api.g_varchar2,
2137: p_normal_hours in number default hr_api.g_number,
2138: p_perf_review_period in number default hr_api.g_number,
2139: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
2140: p_period_of_service_id in number default hr_api.g_number,

Line 2137: p_normal_hours in number default hr_api.g_number,

2133: p_employment_category in varchar2 default hr_api.g_varchar2,
2134: p_frequency in varchar2 default hr_api.g_varchar2,
2135: p_internal_address_line in varchar2 default hr_api.g_varchar2,
2136: p_manager_flag in varchar2 default hr_api.g_varchar2,
2137: p_normal_hours in number default hr_api.g_number,
2138: p_perf_review_period in number default hr_api.g_number,
2139: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
2140: p_period_of_service_id in number default hr_api.g_number,
2141: p_probation_period in number default hr_api.g_number,

Line 2138: p_perf_review_period in number default hr_api.g_number,

2134: p_frequency in varchar2 default hr_api.g_varchar2,
2135: p_internal_address_line in varchar2 default hr_api.g_varchar2,
2136: p_manager_flag in varchar2 default hr_api.g_varchar2,
2137: p_normal_hours in number default hr_api.g_number,
2138: p_perf_review_period in number default hr_api.g_number,
2139: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
2140: p_period_of_service_id in number default hr_api.g_number,
2141: p_probation_period in number default hr_api.g_number,
2142: p_probation_unit in varchar2 default hr_api.g_varchar2,

Line 2139: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,

2135: p_internal_address_line in varchar2 default hr_api.g_varchar2,
2136: p_manager_flag in varchar2 default hr_api.g_varchar2,
2137: p_normal_hours in number default hr_api.g_number,
2138: p_perf_review_period in number default hr_api.g_number,
2139: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
2140: p_period_of_service_id in number default hr_api.g_number,
2141: p_probation_period in number default hr_api.g_number,
2142: p_probation_unit in varchar2 default hr_api.g_varchar2,
2143: p_sal_review_period in number default hr_api.g_number,

Line 2140: p_period_of_service_id in number default hr_api.g_number,

2136: p_manager_flag in varchar2 default hr_api.g_varchar2,
2137: p_normal_hours in number default hr_api.g_number,
2138: p_perf_review_period in number default hr_api.g_number,
2139: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
2140: p_period_of_service_id in number default hr_api.g_number,
2141: p_probation_period in number default hr_api.g_number,
2142: p_probation_unit in varchar2 default hr_api.g_varchar2,
2143: p_sal_review_period in number default hr_api.g_number,
2144: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,

Line 2141: p_probation_period in number default hr_api.g_number,

2137: p_normal_hours in number default hr_api.g_number,
2138: p_perf_review_period in number default hr_api.g_number,
2139: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
2140: p_period_of_service_id in number default hr_api.g_number,
2141: p_probation_period in number default hr_api.g_number,
2142: p_probation_unit in varchar2 default hr_api.g_varchar2,
2143: p_sal_review_period in number default hr_api.g_number,
2144: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
2145: p_set_of_books_id in number default hr_api.g_number,

Line 2142: p_probation_unit in varchar2 default hr_api.g_varchar2,

2138: p_perf_review_period in number default hr_api.g_number,
2139: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
2140: p_period_of_service_id in number default hr_api.g_number,
2141: p_probation_period in number default hr_api.g_number,
2142: p_probation_unit in varchar2 default hr_api.g_varchar2,
2143: p_sal_review_period in number default hr_api.g_number,
2144: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
2145: p_set_of_books_id in number default hr_api.g_number,
2146:

Line 2143: p_sal_review_period in number default hr_api.g_number,

2139: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
2140: p_period_of_service_id in number default hr_api.g_number,
2141: p_probation_period in number default hr_api.g_number,
2142: p_probation_unit in varchar2 default hr_api.g_varchar2,
2143: p_sal_review_period in number default hr_api.g_number,
2144: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
2145: p_set_of_books_id in number default hr_api.g_number,
2146:
2147: p_source_type in varchar2 default hr_api.g_varchar2,

Line 2144: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,

2140: p_period_of_service_id in number default hr_api.g_number,
2141: p_probation_period in number default hr_api.g_number,
2142: p_probation_unit in varchar2 default hr_api.g_varchar2,
2143: p_sal_review_period in number default hr_api.g_number,
2144: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
2145: p_set_of_books_id in number default hr_api.g_number,
2146:
2147: p_source_type in varchar2 default hr_api.g_varchar2,
2148: p_time_normal_finish in varchar2 default hr_api.g_varchar2,

Line 2145: p_set_of_books_id in number default hr_api.g_number,

2141: p_probation_period in number default hr_api.g_number,
2142: p_probation_unit in varchar2 default hr_api.g_varchar2,
2143: p_sal_review_period in number default hr_api.g_number,
2144: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
2145: p_set_of_books_id in number default hr_api.g_number,
2146:
2147: p_source_type in varchar2 default hr_api.g_varchar2,
2148: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
2149: p_time_normal_start in varchar2 default hr_api.g_varchar2,

Line 2147: p_source_type in varchar2 default hr_api.g_varchar2,

2143: p_sal_review_period in number default hr_api.g_number,
2144: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
2145: p_set_of_books_id in number default hr_api.g_number,
2146:
2147: p_source_type in varchar2 default hr_api.g_varchar2,
2148: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
2149: p_time_normal_start in varchar2 default hr_api.g_varchar2,
2150: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
2151: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,

Line 2148: p_time_normal_finish in varchar2 default hr_api.g_varchar2,

2144: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
2145: p_set_of_books_id in number default hr_api.g_number,
2146:
2147: p_source_type in varchar2 default hr_api.g_varchar2,
2148: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
2149: p_time_normal_start in varchar2 default hr_api.g_varchar2,
2150: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
2151: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
2152: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,

Line 2149: p_time_normal_start in varchar2 default hr_api.g_varchar2,

2145: p_set_of_books_id in number default hr_api.g_number,
2146:
2147: p_source_type in varchar2 default hr_api.g_varchar2,
2148: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
2149: p_time_normal_start in varchar2 default hr_api.g_varchar2,
2150: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
2151: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
2152: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
2153: p_request_id in number default hr_api.g_number,

Line 2150: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,

2146:
2147: p_source_type in varchar2 default hr_api.g_varchar2,
2148: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
2149: p_time_normal_start in varchar2 default hr_api.g_varchar2,
2150: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
2151: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
2152: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
2153: p_request_id in number default hr_api.g_number,
2154: p_program_application_id in number default hr_api.g_number,

Line 2151: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,

2147: p_source_type in varchar2 default hr_api.g_varchar2,
2148: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
2149: p_time_normal_start in varchar2 default hr_api.g_varchar2,
2150: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
2151: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
2152: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
2153: p_request_id in number default hr_api.g_number,
2154: p_program_application_id in number default hr_api.g_number,
2155: p_program_id in number default hr_api.g_number,

Line 2152: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,

2148: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
2149: p_time_normal_start in varchar2 default hr_api.g_varchar2,
2150: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
2151: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
2152: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
2153: p_request_id in number default hr_api.g_number,
2154: p_program_application_id in number default hr_api.g_number,
2155: p_program_id in number default hr_api.g_number,
2156: p_program_update_date in date default hr_api.g_date,

Line 2153: p_request_id in number default hr_api.g_number,

2149: p_time_normal_start in varchar2 default hr_api.g_varchar2,
2150: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
2151: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
2152: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
2153: p_request_id in number default hr_api.g_number,
2154: p_program_application_id in number default hr_api.g_number,
2155: p_program_id in number default hr_api.g_number,
2156: p_program_update_date in date default hr_api.g_date,
2157: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,

Line 2154: p_program_application_id in number default hr_api.g_number,

2150: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
2151: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
2152: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
2153: p_request_id in number default hr_api.g_number,
2154: p_program_application_id in number default hr_api.g_number,
2155: p_program_id in number default hr_api.g_number,
2156: p_program_update_date in date default hr_api.g_date,
2157: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
2158: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,

Line 2155: p_program_id in number default hr_api.g_number,

2151: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
2152: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
2153: p_request_id in number default hr_api.g_number,
2154: p_program_application_id in number default hr_api.g_number,
2155: p_program_id in number default hr_api.g_number,
2156: p_program_update_date in date default hr_api.g_date,
2157: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
2158: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
2159: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,

Line 2156: p_program_update_date in date default hr_api.g_date,

2152: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
2153: p_request_id in number default hr_api.g_number,
2154: p_program_application_id in number default hr_api.g_number,
2155: p_program_id in number default hr_api.g_number,
2156: p_program_update_date in date default hr_api.g_date,
2157: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
2158: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
2159: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
2160: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,

Line 2157: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,

2153: p_request_id in number default hr_api.g_number,
2154: p_program_application_id in number default hr_api.g_number,
2155: p_program_id in number default hr_api.g_number,
2156: p_program_update_date in date default hr_api.g_date,
2157: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
2158: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
2159: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
2160: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
2161: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,

Line 2158: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,

2154: p_program_application_id in number default hr_api.g_number,
2155: p_program_id in number default hr_api.g_number,
2156: p_program_update_date in date default hr_api.g_date,
2157: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
2158: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
2159: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
2160: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
2161: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
2162: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,

Line 2159: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,

2155: p_program_id in number default hr_api.g_number,
2156: p_program_update_date in date default hr_api.g_date,
2157: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
2158: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
2159: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
2160: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
2161: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
2162: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
2163:

Line 2160: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,

2156: p_program_update_date in date default hr_api.g_date,
2157: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
2158: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
2159: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
2160: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
2161: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
2162: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
2163:
2164: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,

Line 2161: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,

2157: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
2158: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
2159: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
2160: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
2161: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
2162: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
2163:
2164: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
2165: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,

Line 2162: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,

2158: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
2159: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
2160: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
2161: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
2162: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
2163:
2164: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
2165: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
2166: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,

Line 2164: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,

2160: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
2161: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
2162: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
2163:
2164: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
2165: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
2166: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
2167: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
2168: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,

Line 2165: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,

2161: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
2162: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
2163:
2164: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
2165: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
2166: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
2167: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
2168: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
2169: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,

Line 2166: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,

2162: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
2163:
2164: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
2165: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
2166: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
2167: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
2168: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
2169: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
2170: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,

Line 2167: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,

2163:
2164: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
2165: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
2166: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
2167: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
2168: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
2169: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
2170: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
2171: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,

Line 2168: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,

2164: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
2165: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
2166: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
2167: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
2168: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
2169: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
2170: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
2171: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
2172: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,

Line 2169: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,

2165: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
2166: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
2167: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
2168: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
2169: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
2170: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
2171: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
2172: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
2173: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,

Line 2170: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,

2166: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
2167: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
2168: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
2169: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
2170: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
2171: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
2172: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
2173: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
2174: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,

Line 2171: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,

2167: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
2168: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
2169: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
2170: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
2171: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
2172: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
2173: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
2174: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
2175: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,

Line 2172: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,

2168: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
2169: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
2170: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
2171: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
2172: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
2173: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
2174: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
2175: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
2176: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,

Line 2173: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,

2169: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
2170: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
2171: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
2172: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
2173: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
2174: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
2175: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
2176: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
2177:

Line 2174: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,

2170: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
2171: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
2172: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
2173: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
2174: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
2175: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
2176: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
2177:
2178: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,

Line 2175: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,

2171: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
2172: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
2173: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
2174: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
2175: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
2176: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
2177:
2178: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
2179: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,

Line 2176: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,

2172: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
2173: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
2174: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
2175: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
2176: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
2177:
2178: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
2179: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
2180: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,

Line 2178: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,

2174: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
2175: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
2176: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
2177:
2178: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
2179: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
2180: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
2181: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
2182: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,

Line 2179: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,

2175: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
2176: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
2177:
2178: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
2179: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
2180: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
2181: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
2182: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
2183: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,

Line 2180: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,

2176: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
2177:
2178: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
2179: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
2180: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
2181: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
2182: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
2183: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
2184: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,

Line 2181: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,

2177:
2178: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
2179: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
2180: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
2181: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
2182: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
2183: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
2184: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
2185: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,

Line 2182: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,

2178: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
2179: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
2180: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
2181: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
2182: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
2183: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
2184: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
2185: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
2186: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,

Line 2183: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,

2179: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
2180: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
2181: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
2182: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
2183: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
2184: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
2185: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
2186: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
2187: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,

Line 2184: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,

2180: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
2181: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
2182: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
2183: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
2184: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
2185: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
2186: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
2187: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
2188: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,

Line 2185: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,

2181: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
2182: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
2183: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
2184: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
2185: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
2186: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
2187: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
2188: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
2189: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,

Line 2186: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,

2182: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
2183: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
2184: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
2185: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
2186: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
2187: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
2188: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
2189: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
2190: p_title in varchar2 default hr_api.g_varchar2,

Line 2187: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,

2183: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
2184: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
2185: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
2186: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
2187: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
2188: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
2189: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
2190: p_title in varchar2 default hr_api.g_varchar2,
2191: p_contract_id in number default hr_api.g_number,

Line 2188: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,

2184: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
2185: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
2186: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
2187: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
2188: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
2189: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
2190: p_title in varchar2 default hr_api.g_varchar2,
2191: p_contract_id in number default hr_api.g_number,
2192: p_establishment_id in number default hr_api.g_number,

Line 2189: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,

2185: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
2186: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
2187: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
2188: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
2189: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
2190: p_title in varchar2 default hr_api.g_varchar2,
2191: p_contract_id in number default hr_api.g_number,
2192: p_establishment_id in number default hr_api.g_number,
2193: p_collective_agreement_id in number default hr_api.g_number,

Line 2190: p_title in varchar2 default hr_api.g_varchar2,

2186: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
2187: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
2188: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
2189: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
2190: p_title in varchar2 default hr_api.g_varchar2,
2191: p_contract_id in number default hr_api.g_number,
2192: p_establishment_id in number default hr_api.g_number,
2193: p_collective_agreement_id in number default hr_api.g_number,
2194: p_cagr_grade_def_id in number default hr_api.g_number,

Line 2191: p_contract_id in number default hr_api.g_number,

2187: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
2188: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
2189: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
2190: p_title in varchar2 default hr_api.g_varchar2,
2191: p_contract_id in number default hr_api.g_number,
2192: p_establishment_id in number default hr_api.g_number,
2193: p_collective_agreement_id in number default hr_api.g_number,
2194: p_cagr_grade_def_id in number default hr_api.g_number,
2195: p_cagr_id_flex_num in number default hr_api.g_number,

Line 2192: p_establishment_id in number default hr_api.g_number,

2188: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
2189: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
2190: p_title in varchar2 default hr_api.g_varchar2,
2191: p_contract_id in number default hr_api.g_number,
2192: p_establishment_id in number default hr_api.g_number,
2193: p_collective_agreement_id in number default hr_api.g_number,
2194: p_cagr_grade_def_id in number default hr_api.g_number,
2195: p_cagr_id_flex_num in number default hr_api.g_number,
2196: p_object_version_number in out nocopy number,

Line 2193: p_collective_agreement_id in number default hr_api.g_number,

2189: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
2190: p_title in varchar2 default hr_api.g_varchar2,
2191: p_contract_id in number default hr_api.g_number,
2192: p_establishment_id in number default hr_api.g_number,
2193: p_collective_agreement_id in number default hr_api.g_number,
2194: p_cagr_grade_def_id in number default hr_api.g_number,
2195: p_cagr_id_flex_num in number default hr_api.g_number,
2196: p_object_version_number in out nocopy number,
2197: p_notice_period in number default hr_api.g_number,

Line 2194: p_cagr_grade_def_id in number default hr_api.g_number,

2190: p_title in varchar2 default hr_api.g_varchar2,
2191: p_contract_id in number default hr_api.g_number,
2192: p_establishment_id in number default hr_api.g_number,
2193: p_collective_agreement_id in number default hr_api.g_number,
2194: p_cagr_grade_def_id in number default hr_api.g_number,
2195: p_cagr_id_flex_num in number default hr_api.g_number,
2196: p_object_version_number in out nocopy number,
2197: p_notice_period in number default hr_api.g_number,
2198: p_notice_period_uom in varchar2 default hr_api.g_varchar2,

Line 2195: p_cagr_id_flex_num in number default hr_api.g_number,

2191: p_contract_id in number default hr_api.g_number,
2192: p_establishment_id in number default hr_api.g_number,
2193: p_collective_agreement_id in number default hr_api.g_number,
2194: p_cagr_grade_def_id in number default hr_api.g_number,
2195: p_cagr_id_flex_num in number default hr_api.g_number,
2196: p_object_version_number in out nocopy number,
2197: p_notice_period in number default hr_api.g_number,
2198: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
2199: p_employee_category in varchar2 default hr_api.g_varchar2,

Line 2197: p_notice_period in number default hr_api.g_number,

2193: p_collective_agreement_id in number default hr_api.g_number,
2194: p_cagr_grade_def_id in number default hr_api.g_number,
2195: p_cagr_id_flex_num in number default hr_api.g_number,
2196: p_object_version_number in out nocopy number,
2197: p_notice_period in number default hr_api.g_number,
2198: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
2199: p_employee_category in varchar2 default hr_api.g_varchar2,
2200: p_work_at_home in varchar2 default hr_api.g_varchar2,
2201: p_job_post_source_name in varchar2 default hr_api.g_varchar2,

Line 2198: p_notice_period_uom in varchar2 default hr_api.g_varchar2,

2194: p_cagr_grade_def_id in number default hr_api.g_number,
2195: p_cagr_id_flex_num in number default hr_api.g_number,
2196: p_object_version_number in out nocopy number,
2197: p_notice_period in number default hr_api.g_number,
2198: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
2199: p_employee_category in varchar2 default hr_api.g_varchar2,
2200: p_work_at_home in varchar2 default hr_api.g_varchar2,
2201: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
2202: p_posting_content_id in number default hr_api.g_number,

Line 2199: p_employee_category in varchar2 default hr_api.g_varchar2,

2195: p_cagr_id_flex_num in number default hr_api.g_number,
2196: p_object_version_number in out nocopy number,
2197: p_notice_period in number default hr_api.g_number,
2198: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
2199: p_employee_category in varchar2 default hr_api.g_varchar2,
2200: p_work_at_home in varchar2 default hr_api.g_varchar2,
2201: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
2202: p_posting_content_id in number default hr_api.g_number,
2203: p_placement_date_start in date default hr_api.g_date,

Line 2200: p_work_at_home in varchar2 default hr_api.g_varchar2,

2196: p_object_version_number in out nocopy number,
2197: p_notice_period in number default hr_api.g_number,
2198: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
2199: p_employee_category in varchar2 default hr_api.g_varchar2,
2200: p_work_at_home in varchar2 default hr_api.g_varchar2,
2201: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
2202: p_posting_content_id in number default hr_api.g_number,
2203: p_placement_date_start in date default hr_api.g_date,
2204: p_vendor_id in number default hr_api.g_number,

Line 2201: p_job_post_source_name in varchar2 default hr_api.g_varchar2,

2197: p_notice_period in number default hr_api.g_number,
2198: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
2199: p_employee_category in varchar2 default hr_api.g_varchar2,
2200: p_work_at_home in varchar2 default hr_api.g_varchar2,
2201: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
2202: p_posting_content_id in number default hr_api.g_number,
2203: p_placement_date_start in date default hr_api.g_date,
2204: p_vendor_id in number default hr_api.g_number,
2205: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,

Line 2202: p_posting_content_id in number default hr_api.g_number,

2198: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
2199: p_employee_category in varchar2 default hr_api.g_varchar2,
2200: p_work_at_home in varchar2 default hr_api.g_varchar2,
2201: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
2202: p_posting_content_id in number default hr_api.g_number,
2203: p_placement_date_start in date default hr_api.g_date,
2204: p_vendor_id in number default hr_api.g_number,
2205: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
2206: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,

Line 2203: p_placement_date_start in date default hr_api.g_date,

2199: p_employee_category in varchar2 default hr_api.g_varchar2,
2200: p_work_at_home in varchar2 default hr_api.g_varchar2,
2201: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
2202: p_posting_content_id in number default hr_api.g_number,
2203: p_placement_date_start in date default hr_api.g_date,
2204: p_vendor_id in number default hr_api.g_number,
2205: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
2206: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
2207: p_assignment_category in varchar2 default hr_api.g_varchar2,

Line 2204: p_vendor_id in number default hr_api.g_number,

2200: p_work_at_home in varchar2 default hr_api.g_varchar2,
2201: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
2202: p_posting_content_id in number default hr_api.g_number,
2203: p_placement_date_start in date default hr_api.g_date,
2204: p_vendor_id in number default hr_api.g_number,
2205: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
2206: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
2207: p_assignment_category in varchar2 default hr_api.g_varchar2,
2208: p_project_title in varchar2 default hr_api.g_varchar2,

Line 2205: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,

2201: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
2202: p_posting_content_id in number default hr_api.g_number,
2203: p_placement_date_start in date default hr_api.g_date,
2204: p_vendor_id in number default hr_api.g_number,
2205: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
2206: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
2207: p_assignment_category in varchar2 default hr_api.g_varchar2,
2208: p_project_title in varchar2 default hr_api.g_varchar2,
2209: p_applicant_rank in number default hr_api.g_number,

Line 2206: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,

2202: p_posting_content_id in number default hr_api.g_number,
2203: p_placement_date_start in date default hr_api.g_date,
2204: p_vendor_id in number default hr_api.g_number,
2205: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
2206: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
2207: p_assignment_category in varchar2 default hr_api.g_varchar2,
2208: p_project_title in varchar2 default hr_api.g_varchar2,
2209: p_applicant_rank in number default hr_api.g_number,
2210: p_grade_ladder_pgm_id in number default hr_api.g_number,

Line 2207: p_assignment_category in varchar2 default hr_api.g_varchar2,

2203: p_placement_date_start in date default hr_api.g_date,
2204: p_vendor_id in number default hr_api.g_number,
2205: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
2206: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
2207: p_assignment_category in varchar2 default hr_api.g_varchar2,
2208: p_project_title in varchar2 default hr_api.g_varchar2,
2209: p_applicant_rank in number default hr_api.g_number,
2210: p_grade_ladder_pgm_id in number default hr_api.g_number,
2211: p_supervisor_assignment_id in number default hr_api.g_number,

Line 2208: p_project_title in varchar2 default hr_api.g_varchar2,

2204: p_vendor_id in number default hr_api.g_number,
2205: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
2206: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
2207: p_assignment_category in varchar2 default hr_api.g_varchar2,
2208: p_project_title in varchar2 default hr_api.g_varchar2,
2209: p_applicant_rank in number default hr_api.g_number,
2210: p_grade_ladder_pgm_id in number default hr_api.g_number,
2211: p_supervisor_assignment_id in number default hr_api.g_number,
2212: p_vendor_site_id in number default hr_api.g_number,

Line 2209: p_applicant_rank in number default hr_api.g_number,

2205: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
2206: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
2207: p_assignment_category in varchar2 default hr_api.g_varchar2,
2208: p_project_title in varchar2 default hr_api.g_varchar2,
2209: p_applicant_rank in number default hr_api.g_number,
2210: p_grade_ladder_pgm_id in number default hr_api.g_number,
2211: p_supervisor_assignment_id in number default hr_api.g_number,
2212: p_vendor_site_id in number default hr_api.g_number,
2213: p_po_header_id in number default hr_api.g_number,

Line 2210: p_grade_ladder_pgm_id in number default hr_api.g_number,

2206: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
2207: p_assignment_category in varchar2 default hr_api.g_varchar2,
2208: p_project_title in varchar2 default hr_api.g_varchar2,
2209: p_applicant_rank in number default hr_api.g_number,
2210: p_grade_ladder_pgm_id in number default hr_api.g_number,
2211: p_supervisor_assignment_id in number default hr_api.g_number,
2212: p_vendor_site_id in number default hr_api.g_number,
2213: p_po_header_id in number default hr_api.g_number,
2214: p_po_line_id in number default hr_api.g_number,

Line 2211: p_supervisor_assignment_id in number default hr_api.g_number,

2207: p_assignment_category in varchar2 default hr_api.g_varchar2,
2208: p_project_title in varchar2 default hr_api.g_varchar2,
2209: p_applicant_rank in number default hr_api.g_number,
2210: p_grade_ladder_pgm_id in number default hr_api.g_number,
2211: p_supervisor_assignment_id in number default hr_api.g_number,
2212: p_vendor_site_id in number default hr_api.g_number,
2213: p_po_header_id in number default hr_api.g_number,
2214: p_po_line_id in number default hr_api.g_number,
2215: p_projected_assignment_end in date default hr_api.g_date,

Line 2212: p_vendor_site_id in number default hr_api.g_number,

2208: p_project_title in varchar2 default hr_api.g_varchar2,
2209: p_applicant_rank in number default hr_api.g_number,
2210: p_grade_ladder_pgm_id in number default hr_api.g_number,
2211: p_supervisor_assignment_id in number default hr_api.g_number,
2212: p_vendor_site_id in number default hr_api.g_number,
2213: p_po_header_id in number default hr_api.g_number,
2214: p_po_line_id in number default hr_api.g_number,
2215: p_projected_assignment_end in date default hr_api.g_date,
2216: p_payroll_id_updated out nocopy boolean,

Line 2213: p_po_header_id in number default hr_api.g_number,

2209: p_applicant_rank in number default hr_api.g_number,
2210: p_grade_ladder_pgm_id in number default hr_api.g_number,
2211: p_supervisor_assignment_id in number default hr_api.g_number,
2212: p_vendor_site_id in number default hr_api.g_number,
2213: p_po_header_id in number default hr_api.g_number,
2214: p_po_line_id in number default hr_api.g_number,
2215: p_projected_assignment_end in date default hr_api.g_date,
2216: p_payroll_id_updated out nocopy boolean,
2217: p_other_manager_warning out nocopy boolean,

Line 2214: p_po_line_id in number default hr_api.g_number,

2210: p_grade_ladder_pgm_id in number default hr_api.g_number,
2211: p_supervisor_assignment_id in number default hr_api.g_number,
2212: p_vendor_site_id in number default hr_api.g_number,
2213: p_po_header_id in number default hr_api.g_number,
2214: p_po_line_id in number default hr_api.g_number,
2215: p_projected_assignment_end in date default hr_api.g_date,
2216: p_payroll_id_updated out nocopy boolean,
2217: p_other_manager_warning out nocopy boolean,
2218: p_hourly_salaried_warning out nocopy boolean,

Line 2215: p_projected_assignment_end in date default hr_api.g_date,

2211: p_supervisor_assignment_id in number default hr_api.g_number,
2212: p_vendor_site_id in number default hr_api.g_number,
2213: p_po_header_id in number default hr_api.g_number,
2214: p_po_line_id in number default hr_api.g_number,
2215: p_projected_assignment_end in date default hr_api.g_date,
2216: p_payroll_id_updated out nocopy boolean,
2217: p_other_manager_warning out nocopy boolean,
2218: p_hourly_salaried_warning out nocopy boolean,
2219: p_no_managers_warning out nocopy boolean,

Line 2245: hr_api.g_number,

2241: p_assignment_id,
2242: null,
2243:
2244: null,
2245: hr_api.g_number,
2246: p_recruiter_id,
2247: p_grade_id,
2248: p_position_id,
2249: p_job_id,

Line 2256: hr_api.g_number,

2252: p_location_id,
2253: p_person_referred_by_id,
2254: p_supervisor_id,
2255: p_special_ceiling_step_id,
2256: hr_api.g_number,
2257:
2258: p_recruitment_activity_id,
2259: p_source_organization_id,
2260: p_organization_id,

Line 2265: hr_api.g_number,

2261: p_people_group_id,
2262: p_soft_coding_keyflex_id,
2263: p_vacancy_id,
2264: p_pay_basis_id,
2265: hr_api.g_number,
2266: p_assignment_type,
2267: p_primary_flag,
2268: p_application_id,
2269: p_assignment_number,

Line 2271: hr_api.g_number,

2267: p_primary_flag,
2268: p_application_id,
2269: p_assignment_number,
2270: p_change_reason,
2271: hr_api.g_number,
2272: p_comments,
2273: p_date_probation_end,
2274: p_default_code_comb_id,
2275: p_employment_category,