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 966: when hr_api.cannot_find_prog_unit then

962: ,p_projected_assignment_end_o
963: => per_asg_shd.g_old_rec.projected_assignment_end
964: );
965: exception
966: when hr_api.cannot_find_prog_unit then
967: hr_api.cannot_find_prog_unit_error
968: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'
969: ,p_hook_type => 'AU'
970: );

Line 967: hr_api.cannot_find_prog_unit_error

963: => per_asg_shd.g_old_rec.projected_assignment_end
964: );
965: exception
966: when hr_api.cannot_find_prog_unit then
967: hr_api.cannot_find_prog_unit_error
968: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'
969: ,p_hook_type => 'AU'
970: );
971: end;

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

1276: -- p_rec plsql record structure
1277: -- to see if a system default is being used. If a system default
1278: -- is being used then we must set to the 'current' argument value.
1279: --
1280: If (p_rec.business_group_id = hr_api.g_number) then
1281: p_rec.business_group_id :=
1282: per_asg_shd.g_old_rec.business_group_id;
1283: End If;
1284: If (p_rec.recruiter_id = hr_api.g_number) then

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

1280: If (p_rec.business_group_id = hr_api.g_number) then
1281: p_rec.business_group_id :=
1282: per_asg_shd.g_old_rec.business_group_id;
1283: End If;
1284: If (p_rec.recruiter_id = hr_api.g_number) then
1285: p_rec.recruiter_id :=
1286: per_asg_shd.g_old_rec.recruiter_id;
1287: End If;
1288: If (p_rec.grade_id = hr_api.g_number) then

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

1284: If (p_rec.recruiter_id = hr_api.g_number) then
1285: p_rec.recruiter_id :=
1286: per_asg_shd.g_old_rec.recruiter_id;
1287: End If;
1288: If (p_rec.grade_id = hr_api.g_number) then
1289: p_rec.grade_id :=
1290: per_asg_shd.g_old_rec.grade_id;
1291: End If;
1292: If (p_rec.position_id = hr_api.g_number) then

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

1288: If (p_rec.grade_id = hr_api.g_number) then
1289: p_rec.grade_id :=
1290: per_asg_shd.g_old_rec.grade_id;
1291: End If;
1292: If (p_rec.position_id = hr_api.g_number) then
1293: p_rec.position_id :=
1294: per_asg_shd.g_old_rec.position_id;
1295: End If;
1296: If (p_rec.job_id = hr_api.g_number) then

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

1292: If (p_rec.position_id = hr_api.g_number) then
1293: p_rec.position_id :=
1294: per_asg_shd.g_old_rec.position_id;
1295: End If;
1296: If (p_rec.job_id = hr_api.g_number) then
1297: p_rec.job_id :=
1298: per_asg_shd.g_old_rec.job_id;
1299: End If;
1300: If (p_rec.assignment_status_type_id = hr_api.g_number) then

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

1296: If (p_rec.job_id = hr_api.g_number) then
1297: p_rec.job_id :=
1298: per_asg_shd.g_old_rec.job_id;
1299: End If;
1300: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1301: p_rec.assignment_status_type_id :=
1302: per_asg_shd.g_old_rec.assignment_status_type_id;
1303: End If;
1304: If (p_rec.payroll_id = hr_api.g_number) then

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

1300: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1301: p_rec.assignment_status_type_id :=
1302: per_asg_shd.g_old_rec.assignment_status_type_id;
1303: End If;
1304: If (p_rec.payroll_id = hr_api.g_number) then
1305: p_rec.payroll_id :=
1306: per_asg_shd.g_old_rec.payroll_id;
1307: End If;
1308: If (p_rec.location_id = hr_api.g_number) then

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

1304: If (p_rec.payroll_id = hr_api.g_number) then
1305: p_rec.payroll_id :=
1306: per_asg_shd.g_old_rec.payroll_id;
1307: End If;
1308: If (p_rec.location_id = hr_api.g_number) then
1309: p_rec.location_id :=
1310: per_asg_shd.g_old_rec.location_id;
1311: End If;
1312: If (p_rec.person_referred_by_id = hr_api.g_number) then

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

1308: If (p_rec.location_id = hr_api.g_number) then
1309: p_rec.location_id :=
1310: per_asg_shd.g_old_rec.location_id;
1311: End If;
1312: If (p_rec.person_referred_by_id = hr_api.g_number) then
1313: p_rec.person_referred_by_id :=
1314: per_asg_shd.g_old_rec.person_referred_by_id;
1315: End If;
1316: If (p_rec.supervisor_id = hr_api.g_number) then

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

1312: If (p_rec.person_referred_by_id = hr_api.g_number) then
1313: p_rec.person_referred_by_id :=
1314: per_asg_shd.g_old_rec.person_referred_by_id;
1315: End If;
1316: If (p_rec.supervisor_id = hr_api.g_number) then
1317: p_rec.supervisor_id :=
1318: per_asg_shd.g_old_rec.supervisor_id;
1319: End If;
1320: If (p_rec.special_ceiling_step_id = hr_api.g_number) then

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

1316: If (p_rec.supervisor_id = hr_api.g_number) then
1317: p_rec.supervisor_id :=
1318: per_asg_shd.g_old_rec.supervisor_id;
1319: End If;
1320: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1321: p_rec.special_ceiling_step_id :=
1322: per_asg_shd.g_old_rec.special_ceiling_step_id;
1323: End If;
1324: If (p_rec.person_id = hr_api.g_number) then

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

1320: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1321: p_rec.special_ceiling_step_id :=
1322: per_asg_shd.g_old_rec.special_ceiling_step_id;
1323: End If;
1324: If (p_rec.person_id = hr_api.g_number) then
1325: p_rec.person_id :=
1326: per_asg_shd.g_old_rec.person_id;
1327: End If;
1328: If (p_rec.recruitment_activity_id = hr_api.g_number) then

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

1324: If (p_rec.person_id = hr_api.g_number) then
1325: p_rec.person_id :=
1326: per_asg_shd.g_old_rec.person_id;
1327: End If;
1328: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1329: p_rec.recruitment_activity_id :=
1330: per_asg_shd.g_old_rec.recruitment_activity_id;
1331: End If;
1332: If (p_rec.source_organization_id = hr_api.g_number) then

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

1328: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1329: p_rec.recruitment_activity_id :=
1330: per_asg_shd.g_old_rec.recruitment_activity_id;
1331: End If;
1332: If (p_rec.source_organization_id = hr_api.g_number) then
1333: p_rec.source_organization_id :=
1334: per_asg_shd.g_old_rec.source_organization_id;
1335: End If;
1336: If (p_rec.organization_id = hr_api.g_number) then

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

1332: If (p_rec.source_organization_id = hr_api.g_number) then
1333: p_rec.source_organization_id :=
1334: per_asg_shd.g_old_rec.source_organization_id;
1335: End If;
1336: If (p_rec.organization_id = hr_api.g_number) then
1337: p_rec.organization_id :=
1338: per_asg_shd.g_old_rec.organization_id;
1339: End If;
1340: If (p_rec.people_group_id = hr_api.g_number) then

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

1336: If (p_rec.organization_id = hr_api.g_number) then
1337: p_rec.organization_id :=
1338: per_asg_shd.g_old_rec.organization_id;
1339: End If;
1340: If (p_rec.people_group_id = hr_api.g_number) then
1341: p_rec.people_group_id :=
1342: per_asg_shd.g_old_rec.people_group_id;
1343: End If;
1344: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then

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

1340: If (p_rec.people_group_id = hr_api.g_number) then
1341: p_rec.people_group_id :=
1342: per_asg_shd.g_old_rec.people_group_id;
1343: End If;
1344: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1345: p_rec.soft_coding_keyflex_id :=
1346: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1347: End If;
1348: If (p_rec.vacancy_id = hr_api.g_number) then

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

1344: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1345: p_rec.soft_coding_keyflex_id :=
1346: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1347: End If;
1348: If (p_rec.vacancy_id = hr_api.g_number) then
1349: p_rec.vacancy_id :=
1350: per_asg_shd.g_old_rec.vacancy_id;
1351: End If;
1352: If (p_rec.pay_basis_id = hr_api.g_number) then

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

1348: If (p_rec.vacancy_id = hr_api.g_number) then
1349: p_rec.vacancy_id :=
1350: per_asg_shd.g_old_rec.vacancy_id;
1351: End If;
1352: If (p_rec.pay_basis_id = hr_api.g_number) then
1353: p_rec.pay_basis_id :=
1354: per_asg_shd.g_old_rec.pay_basis_id;
1355: End If;
1356: If (p_rec.assignment_sequence = hr_api.g_number) then

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

1352: If (p_rec.pay_basis_id = hr_api.g_number) then
1353: p_rec.pay_basis_id :=
1354: per_asg_shd.g_old_rec.pay_basis_id;
1355: End If;
1356: If (p_rec.assignment_sequence = hr_api.g_number) then
1357: p_rec.assignment_sequence :=
1358: per_asg_shd.g_old_rec.assignment_sequence;
1359: End If;
1360: If (p_rec.assignment_type = hr_api.g_varchar2) then

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

1356: If (p_rec.assignment_sequence = hr_api.g_number) then
1357: p_rec.assignment_sequence :=
1358: per_asg_shd.g_old_rec.assignment_sequence;
1359: End If;
1360: If (p_rec.assignment_type = hr_api.g_varchar2) then
1361: p_rec.assignment_type :=
1362: per_asg_shd.g_old_rec.assignment_type;
1363: End If;
1364: If (p_rec.primary_flag = hr_api.g_varchar2) then

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

1360: If (p_rec.assignment_type = hr_api.g_varchar2) then
1361: p_rec.assignment_type :=
1362: per_asg_shd.g_old_rec.assignment_type;
1363: End If;
1364: If (p_rec.primary_flag = hr_api.g_varchar2) then
1365: p_rec.primary_flag :=
1366: per_asg_shd.g_old_rec.primary_flag;
1367: End If;
1368: If (p_rec.application_id = hr_api.g_number) then

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

1364: If (p_rec.primary_flag = hr_api.g_varchar2) then
1365: p_rec.primary_flag :=
1366: per_asg_shd.g_old_rec.primary_flag;
1367: End If;
1368: If (p_rec.application_id = hr_api.g_number) then
1369: p_rec.application_id :=
1370: per_asg_shd.g_old_rec.application_id;
1371: End If;
1372: If (p_rec.assignment_number = hr_api.g_varchar2) then

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

1368: If (p_rec.application_id = hr_api.g_number) then
1369: p_rec.application_id :=
1370: per_asg_shd.g_old_rec.application_id;
1371: End If;
1372: If (p_rec.assignment_number = hr_api.g_varchar2) then
1373: p_rec.assignment_number :=
1374: per_asg_shd.g_old_rec.assignment_number;
1375: End If;
1376: If (p_rec.change_reason = hr_api.g_varchar2) then

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

1372: If (p_rec.assignment_number = hr_api.g_varchar2) then
1373: p_rec.assignment_number :=
1374: per_asg_shd.g_old_rec.assignment_number;
1375: End If;
1376: If (p_rec.change_reason = hr_api.g_varchar2) then
1377: p_rec.change_reason :=
1378: per_asg_shd.g_old_rec.change_reason;
1379: End If;
1380: If (p_rec.comment_id = hr_api.g_number) then

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

1376: If (p_rec.change_reason = hr_api.g_varchar2) then
1377: p_rec.change_reason :=
1378: per_asg_shd.g_old_rec.change_reason;
1379: End If;
1380: If (p_rec.comment_id = hr_api.g_number) then
1381: p_rec.comment_id :=
1382: per_asg_shd.g_old_rec.comment_id;
1383: End If;
1384: If (p_rec.comment_text = hr_api.g_varchar2) then

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

1380: If (p_rec.comment_id = hr_api.g_number) then
1381: p_rec.comment_id :=
1382: per_asg_shd.g_old_rec.comment_id;
1383: End If;
1384: If (p_rec.comment_text = hr_api.g_varchar2) then
1385: p_rec.comment_text :=
1386: per_asg_shd.g_old_rec.comment_text;
1387: End If;
1388: If (p_rec.date_probation_end = hr_api.g_date) then

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

1384: If (p_rec.comment_text = hr_api.g_varchar2) then
1385: p_rec.comment_text :=
1386: per_asg_shd.g_old_rec.comment_text;
1387: End If;
1388: If (p_rec.date_probation_end = hr_api.g_date) then
1389: p_rec.date_probation_end :=
1390: per_asg_shd.g_old_rec.date_probation_end;
1391: End If;
1392: If (p_rec.default_code_comb_id = hr_api.g_number) then

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

1388: If (p_rec.date_probation_end = hr_api.g_date) then
1389: p_rec.date_probation_end :=
1390: per_asg_shd.g_old_rec.date_probation_end;
1391: End If;
1392: If (p_rec.default_code_comb_id = hr_api.g_number) then
1393: p_rec.default_code_comb_id :=
1394: per_asg_shd.g_old_rec.default_code_comb_id;
1395: End If;
1396: If (p_rec.employment_category = hr_api.g_varchar2) then

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

1392: If (p_rec.default_code_comb_id = hr_api.g_number) then
1393: p_rec.default_code_comb_id :=
1394: per_asg_shd.g_old_rec.default_code_comb_id;
1395: End If;
1396: If (p_rec.employment_category = hr_api.g_varchar2) then
1397: p_rec.employment_category :=
1398: per_asg_shd.g_old_rec.employment_category;
1399: End If;
1400: If (p_rec.frequency = hr_api.g_varchar2) then

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

1396: If (p_rec.employment_category = hr_api.g_varchar2) then
1397: p_rec.employment_category :=
1398: per_asg_shd.g_old_rec.employment_category;
1399: End If;
1400: If (p_rec.frequency = hr_api.g_varchar2) then
1401: p_rec.frequency :=
1402: per_asg_shd.g_old_rec.frequency;
1403: End If;
1404: If (p_rec.internal_address_line = hr_api.g_varchar2) then

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

1400: If (p_rec.frequency = hr_api.g_varchar2) then
1401: p_rec.frequency :=
1402: per_asg_shd.g_old_rec.frequency;
1403: End If;
1404: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1405: p_rec.internal_address_line :=
1406: per_asg_shd.g_old_rec.internal_address_line;
1407: End If;
1408: If (p_rec.manager_flag = hr_api.g_varchar2) then

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

1404: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1405: p_rec.internal_address_line :=
1406: per_asg_shd.g_old_rec.internal_address_line;
1407: End If;
1408: If (p_rec.manager_flag = hr_api.g_varchar2) then
1409: p_rec.manager_flag :=
1410: per_asg_shd.g_old_rec.manager_flag;
1411: End If;
1412: If (p_rec.normal_hours = hr_api.g_number) then

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

1408: If (p_rec.manager_flag = hr_api.g_varchar2) then
1409: p_rec.manager_flag :=
1410: per_asg_shd.g_old_rec.manager_flag;
1411: End If;
1412: If (p_rec.normal_hours = hr_api.g_number) then
1413: p_rec.normal_hours :=
1414: per_asg_shd.g_old_rec.normal_hours;
1415: End If;
1416: If (p_rec.perf_review_period = hr_api.g_number) then

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

1412: If (p_rec.normal_hours = hr_api.g_number) then
1413: p_rec.normal_hours :=
1414: per_asg_shd.g_old_rec.normal_hours;
1415: End If;
1416: If (p_rec.perf_review_period = hr_api.g_number) then
1417: p_rec.perf_review_period :=
1418: per_asg_shd.g_old_rec.perf_review_period;
1419: End If;
1420: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then

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

1416: If (p_rec.perf_review_period = hr_api.g_number) then
1417: p_rec.perf_review_period :=
1418: per_asg_shd.g_old_rec.perf_review_period;
1419: End If;
1420: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1421: p_rec.perf_review_period_frequency :=
1422: per_asg_shd.g_old_rec.perf_review_period_frequency;
1423: End If;
1424: If (p_rec.period_of_service_id = hr_api.g_number) then

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

1420: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1421: p_rec.perf_review_period_frequency :=
1422: per_asg_shd.g_old_rec.perf_review_period_frequency;
1423: End If;
1424: If (p_rec.period_of_service_id = hr_api.g_number) then
1425: p_rec.period_of_service_id :=
1426: per_asg_shd.g_old_rec.period_of_service_id;
1427: End If;
1428: If (p_rec.probation_period = hr_api.g_number) then

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

1424: If (p_rec.period_of_service_id = hr_api.g_number) then
1425: p_rec.period_of_service_id :=
1426: per_asg_shd.g_old_rec.period_of_service_id;
1427: End If;
1428: If (p_rec.probation_period = hr_api.g_number) then
1429: p_rec.probation_period :=
1430: per_asg_shd.g_old_rec.probation_period;
1431: End If;
1432: If (p_rec.probation_unit = hr_api.g_varchar2) then

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

1428: If (p_rec.probation_period = hr_api.g_number) then
1429: p_rec.probation_period :=
1430: per_asg_shd.g_old_rec.probation_period;
1431: End If;
1432: If (p_rec.probation_unit = hr_api.g_varchar2) then
1433: p_rec.probation_unit :=
1434: per_asg_shd.g_old_rec.probation_unit;
1435: End If;
1436: If (p_rec.sal_review_period = hr_api.g_number) then

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

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

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

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

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

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

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

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

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

1448: If (p_rec.source_type = hr_api.g_varchar2) then
1449: p_rec.source_type :=
1450: per_asg_shd.g_old_rec.source_type;
1451: End If;
1452: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1453: p_rec.time_normal_finish :=
1454: per_asg_shd.g_old_rec.time_normal_finish;
1455: End If;
1456: If (p_rec.time_normal_start = hr_api.g_varchar2) then

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

1452: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1453: p_rec.time_normal_finish :=
1454: per_asg_shd.g_old_rec.time_normal_finish;
1455: End If;
1456: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1457: p_rec.time_normal_start :=
1458: per_asg_shd.g_old_rec.time_normal_start;
1459: End If;
1460: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then

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

1456: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1457: p_rec.time_normal_start :=
1458: per_asg_shd.g_old_rec.time_normal_start;
1459: End If;
1460: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1461: p_rec.bargaining_unit_code :=
1462: per_asg_shd.g_old_rec.bargaining_unit_code;
1463: End If;
1464: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then

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

1460: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1461: p_rec.bargaining_unit_code :=
1462: per_asg_shd.g_old_rec.bargaining_unit_code;
1463: End If;
1464: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1465: p_rec.labour_union_member_flag :=
1466: per_asg_shd.g_old_rec.labour_union_member_flag;
1467: End If;
1468: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then

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

1464: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1465: p_rec.labour_union_member_flag :=
1466: per_asg_shd.g_old_rec.labour_union_member_flag;
1467: End If;
1468: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1469: p_rec.hourly_salaried_code :=
1470: per_asg_shd.g_old_rec.hourly_salaried_code;
1471: End If;
1472: If (p_rec.request_id = hr_api.g_number) then

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

1468: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1469: p_rec.hourly_salaried_code :=
1470: per_asg_shd.g_old_rec.hourly_salaried_code;
1471: End If;
1472: If (p_rec.request_id = hr_api.g_number) then
1473: p_rec.request_id :=
1474: per_asg_shd.g_old_rec.request_id;
1475: End If;
1476: If (p_rec.program_application_id = hr_api.g_number) then

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

1472: If (p_rec.request_id = hr_api.g_number) then
1473: p_rec.request_id :=
1474: per_asg_shd.g_old_rec.request_id;
1475: End If;
1476: If (p_rec.program_application_id = hr_api.g_number) then
1477: p_rec.program_application_id :=
1478: per_asg_shd.g_old_rec.program_application_id;
1479: End If;
1480: If (p_rec.program_id = hr_api.g_number) then

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

1476: If (p_rec.program_application_id = hr_api.g_number) then
1477: p_rec.program_application_id :=
1478: per_asg_shd.g_old_rec.program_application_id;
1479: End If;
1480: If (p_rec.program_id = hr_api.g_number) then
1481: p_rec.program_id :=
1482: per_asg_shd.g_old_rec.program_id;
1483: End If;
1484: If (p_rec.program_update_date = hr_api.g_date) then

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

1480: If (p_rec.program_id = hr_api.g_number) then
1481: p_rec.program_id :=
1482: per_asg_shd.g_old_rec.program_id;
1483: End If;
1484: If (p_rec.program_update_date = hr_api.g_date) then
1485: p_rec.program_update_date :=
1486: per_asg_shd.g_old_rec.program_update_date;
1487: End If;
1488: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then

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

1484: If (p_rec.program_update_date = hr_api.g_date) then
1485: p_rec.program_update_date :=
1486: per_asg_shd.g_old_rec.program_update_date;
1487: End If;
1488: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1489: p_rec.ass_attribute_category :=
1490: per_asg_shd.g_old_rec.ass_attribute_category;
1491: End If;
1492: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then

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

1488: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1489: p_rec.ass_attribute_category :=
1490: per_asg_shd.g_old_rec.ass_attribute_category;
1491: End If;
1492: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1493: p_rec.ass_attribute1 :=
1494: per_asg_shd.g_old_rec.ass_attribute1;
1495: End If;
1496: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then

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

1492: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1493: p_rec.ass_attribute1 :=
1494: per_asg_shd.g_old_rec.ass_attribute1;
1495: End If;
1496: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1497: p_rec.ass_attribute2 :=
1498: per_asg_shd.g_old_rec.ass_attribute2;
1499: End If;
1500: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then

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

1496: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1497: p_rec.ass_attribute2 :=
1498: per_asg_shd.g_old_rec.ass_attribute2;
1499: End If;
1500: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1501: p_rec.ass_attribute3 :=
1502: per_asg_shd.g_old_rec.ass_attribute3;
1503: End If;
1504: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then

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

1500: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1501: p_rec.ass_attribute3 :=
1502: per_asg_shd.g_old_rec.ass_attribute3;
1503: End If;
1504: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1505: p_rec.ass_attribute4 :=
1506: per_asg_shd.g_old_rec.ass_attribute4;
1507: End If;
1508: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then

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

1504: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1505: p_rec.ass_attribute4 :=
1506: per_asg_shd.g_old_rec.ass_attribute4;
1507: End If;
1508: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1509: p_rec.ass_attribute5 :=
1510: per_asg_shd.g_old_rec.ass_attribute5;
1511: End If;
1512: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then

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

1508: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1509: p_rec.ass_attribute5 :=
1510: per_asg_shd.g_old_rec.ass_attribute5;
1511: End If;
1512: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1513: p_rec.ass_attribute6 :=
1514: per_asg_shd.g_old_rec.ass_attribute6;
1515: End If;
1516: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then

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

1512: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1513: p_rec.ass_attribute6 :=
1514: per_asg_shd.g_old_rec.ass_attribute6;
1515: End If;
1516: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1517: p_rec.ass_attribute7 :=
1518: per_asg_shd.g_old_rec.ass_attribute7;
1519: End If;
1520: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then

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

1516: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1517: p_rec.ass_attribute7 :=
1518: per_asg_shd.g_old_rec.ass_attribute7;
1519: End If;
1520: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1521: p_rec.ass_attribute8 :=
1522: per_asg_shd.g_old_rec.ass_attribute8;
1523: End If;
1524: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then

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

1520: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1521: p_rec.ass_attribute8 :=
1522: per_asg_shd.g_old_rec.ass_attribute8;
1523: End If;
1524: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1525: p_rec.ass_attribute9 :=
1526: per_asg_shd.g_old_rec.ass_attribute9;
1527: End If;
1528: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then

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

1524: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1525: p_rec.ass_attribute9 :=
1526: per_asg_shd.g_old_rec.ass_attribute9;
1527: End If;
1528: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1529: p_rec.ass_attribute10 :=
1530: per_asg_shd.g_old_rec.ass_attribute10;
1531: End If;
1532: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then

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

1528: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1529: p_rec.ass_attribute10 :=
1530: per_asg_shd.g_old_rec.ass_attribute10;
1531: End If;
1532: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1533: p_rec.ass_attribute11 :=
1534: per_asg_shd.g_old_rec.ass_attribute11;
1535: End If;
1536: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then

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

1532: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1533: p_rec.ass_attribute11 :=
1534: per_asg_shd.g_old_rec.ass_attribute11;
1535: End If;
1536: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1537: p_rec.ass_attribute12 :=
1538: per_asg_shd.g_old_rec.ass_attribute12;
1539: End If;
1540: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then

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

1536: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1537: p_rec.ass_attribute12 :=
1538: per_asg_shd.g_old_rec.ass_attribute12;
1539: End If;
1540: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1541: p_rec.ass_attribute13 :=
1542: per_asg_shd.g_old_rec.ass_attribute13;
1543: End If;
1544: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then

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

1540: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1541: p_rec.ass_attribute13 :=
1542: per_asg_shd.g_old_rec.ass_attribute13;
1543: End If;
1544: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1545: p_rec.ass_attribute14 :=
1546: per_asg_shd.g_old_rec.ass_attribute14;
1547: End If;
1548: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then

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

1544: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1545: p_rec.ass_attribute14 :=
1546: per_asg_shd.g_old_rec.ass_attribute14;
1547: End If;
1548: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1549: p_rec.ass_attribute15 :=
1550: per_asg_shd.g_old_rec.ass_attribute15;
1551: End If;
1552: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then

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

1548: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1549: p_rec.ass_attribute15 :=
1550: per_asg_shd.g_old_rec.ass_attribute15;
1551: End If;
1552: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1553: p_rec.ass_attribute16 :=
1554: per_asg_shd.g_old_rec.ass_attribute16;
1555: End If;
1556: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then

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

1552: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1553: p_rec.ass_attribute16 :=
1554: per_asg_shd.g_old_rec.ass_attribute16;
1555: End If;
1556: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1557: p_rec.ass_attribute17 :=
1558: per_asg_shd.g_old_rec.ass_attribute17;
1559: End If;
1560: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then

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

1556: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1557: p_rec.ass_attribute17 :=
1558: per_asg_shd.g_old_rec.ass_attribute17;
1559: End If;
1560: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1561: p_rec.ass_attribute18 :=
1562: per_asg_shd.g_old_rec.ass_attribute18;
1563: End If;
1564: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then

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

1560: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1561: p_rec.ass_attribute18 :=
1562: per_asg_shd.g_old_rec.ass_attribute18;
1563: End If;
1564: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1565: p_rec.ass_attribute19 :=
1566: per_asg_shd.g_old_rec.ass_attribute19;
1567: End If;
1568: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then

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

1564: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1565: p_rec.ass_attribute19 :=
1566: per_asg_shd.g_old_rec.ass_attribute19;
1567: End If;
1568: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1569: p_rec.ass_attribute20 :=
1570: per_asg_shd.g_old_rec.ass_attribute20;
1571: End If;
1572: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then

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

1568: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1569: p_rec.ass_attribute20 :=
1570: per_asg_shd.g_old_rec.ass_attribute20;
1571: End If;
1572: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1573: p_rec.ass_attribute21 :=
1574: per_asg_shd.g_old_rec.ass_attribute21;
1575: End If;
1576: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then

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

1572: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1573: p_rec.ass_attribute21 :=
1574: per_asg_shd.g_old_rec.ass_attribute21;
1575: End If;
1576: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1577: p_rec.ass_attribute22 :=
1578: per_asg_shd.g_old_rec.ass_attribute22;
1579: End If;
1580: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then

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

1576: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1577: p_rec.ass_attribute22 :=
1578: per_asg_shd.g_old_rec.ass_attribute22;
1579: End If;
1580: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1581: p_rec.ass_attribute23 :=
1582: per_asg_shd.g_old_rec.ass_attribute23;
1583: End If;
1584: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then

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

1580: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1581: p_rec.ass_attribute23 :=
1582: per_asg_shd.g_old_rec.ass_attribute23;
1583: End If;
1584: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1585: p_rec.ass_attribute24 :=
1586: per_asg_shd.g_old_rec.ass_attribute24;
1587: End If;
1588: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then

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

1584: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1585: p_rec.ass_attribute24 :=
1586: per_asg_shd.g_old_rec.ass_attribute24;
1587: End If;
1588: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1589: p_rec.ass_attribute25 :=
1590: per_asg_shd.g_old_rec.ass_attribute25;
1591: End If;
1592: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then

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

1588: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1589: p_rec.ass_attribute25 :=
1590: per_asg_shd.g_old_rec.ass_attribute25;
1591: End If;
1592: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1593: p_rec.ass_attribute26 :=
1594: per_asg_shd.g_old_rec.ass_attribute26;
1595: End If;
1596: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then

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

1592: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1593: p_rec.ass_attribute26 :=
1594: per_asg_shd.g_old_rec.ass_attribute26;
1595: End If;
1596: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1597: p_rec.ass_attribute27 :=
1598: per_asg_shd.g_old_rec.ass_attribute27;
1599: End If;
1600: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then

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

1596: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1597: p_rec.ass_attribute27 :=
1598: per_asg_shd.g_old_rec.ass_attribute27;
1599: End If;
1600: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1601: p_rec.ass_attribute28 :=
1602: per_asg_shd.g_old_rec.ass_attribute28;
1603: End If;
1604: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then

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

1600: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1601: p_rec.ass_attribute28 :=
1602: per_asg_shd.g_old_rec.ass_attribute28;
1603: End If;
1604: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1605: p_rec.ass_attribute29 :=
1606: per_asg_shd.g_old_rec.ass_attribute29;
1607: End If;
1608: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then

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

1604: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1605: p_rec.ass_attribute29 :=
1606: per_asg_shd.g_old_rec.ass_attribute29;
1607: End If;
1608: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1609: p_rec.ass_attribute30 :=
1610: per_asg_shd.g_old_rec.ass_attribute30;
1611: End If;
1612: If (p_rec.title = hr_api.g_varchar2) then

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

1608: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1609: p_rec.ass_attribute30 :=
1610: per_asg_shd.g_old_rec.ass_attribute30;
1611: End If;
1612: If (p_rec.title = hr_api.g_varchar2) then
1613: p_rec.title :=
1614: per_asg_shd.g_old_rec.title;
1615: End If;
1616: If (p_rec.contract_id = hr_api.g_number) then

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

1612: If (p_rec.title = hr_api.g_varchar2) then
1613: p_rec.title :=
1614: per_asg_shd.g_old_rec.title;
1615: End If;
1616: If (p_rec.contract_id = hr_api.g_number) then
1617: p_rec.contract_id :=
1618: per_asg_shd.g_old_rec.contract_id;
1619: End If;
1620: If (p_rec.establishment_id = hr_api.g_number) then

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

1616: If (p_rec.contract_id = hr_api.g_number) then
1617: p_rec.contract_id :=
1618: per_asg_shd.g_old_rec.contract_id;
1619: End If;
1620: If (p_rec.establishment_id = hr_api.g_number) then
1621: p_rec.establishment_id :=
1622: per_asg_shd.g_old_rec.establishment_id;
1623: End If;
1624: If (p_rec.collective_agreement_id = hr_api.g_number) then

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

1620: If (p_rec.establishment_id = hr_api.g_number) then
1621: p_rec.establishment_id :=
1622: per_asg_shd.g_old_rec.establishment_id;
1623: End If;
1624: If (p_rec.collective_agreement_id = hr_api.g_number) then
1625: p_rec.collective_agreement_id :=
1626: per_asg_shd.g_old_rec.collective_agreement_id;
1627: End If;
1628: If (p_rec.cagr_grade_def_id = hr_api.g_number) then

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

1624: If (p_rec.collective_agreement_id = hr_api.g_number) then
1625: p_rec.collective_agreement_id :=
1626: per_asg_shd.g_old_rec.collective_agreement_id;
1627: End If;
1628: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1629: p_rec.cagr_grade_def_id :=
1630: per_asg_shd.g_old_rec.cagr_grade_def_id;
1631: End If;
1632: If (p_rec.cagr_id_flex_num = hr_api.g_number) then

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

1628: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1629: p_rec.cagr_grade_def_id :=
1630: per_asg_shd.g_old_rec.cagr_grade_def_id;
1631: End If;
1632: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1633: p_rec.cagr_id_flex_num :=
1634: per_asg_shd.g_old_rec.cagr_id_flex_num;
1635: End If;
1636: If (p_rec.notice_period = hr_api.g_number) then

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

1632: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1633: p_rec.cagr_id_flex_num :=
1634: per_asg_shd.g_old_rec.cagr_id_flex_num;
1635: End If;
1636: If (p_rec.notice_period = hr_api.g_number) then
1637: p_rec.notice_period :=
1638: per_asg_shd.g_old_rec.notice_period;
1639: End If;
1640: If (p_rec.notice_period_uom = hr_api.g_varchar2) then

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

1636: If (p_rec.notice_period = hr_api.g_number) then
1637: p_rec.notice_period :=
1638: per_asg_shd.g_old_rec.notice_period;
1639: End If;
1640: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1641: p_rec.notice_period_uom :=
1642: per_asg_shd.g_old_rec.notice_period_uom;
1643: End If;
1644: If (p_rec.employee_category = hr_api.g_varchar2) then

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

1640: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1641: p_rec.notice_period_uom :=
1642: per_asg_shd.g_old_rec.notice_period_uom;
1643: End If;
1644: If (p_rec.employee_category = hr_api.g_varchar2) then
1645: p_rec.employee_category :=
1646: per_asg_shd.g_old_rec.employee_category;
1647: End If;
1648: If (p_rec.work_at_home = hr_api.g_varchar2) then

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

1644: If (p_rec.employee_category = hr_api.g_varchar2) then
1645: p_rec.employee_category :=
1646: per_asg_shd.g_old_rec.employee_category;
1647: End If;
1648: If (p_rec.work_at_home = hr_api.g_varchar2) then
1649: p_rec.work_at_home :=
1650: per_asg_shd.g_old_rec.work_at_home;
1651: End If;
1652: If (p_rec.job_post_source_name = hr_api.g_varchar2) then

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

1648: If (p_rec.work_at_home = hr_api.g_varchar2) then
1649: p_rec.work_at_home :=
1650: per_asg_shd.g_old_rec.work_at_home;
1651: End If;
1652: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1653: p_rec.job_post_source_name :=
1654: per_asg_shd.g_old_rec.job_post_source_name;
1655: End If;
1656: If (p_rec.posting_content_id = hr_api.g_number) then

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

1652: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1653: p_rec.job_post_source_name :=
1654: per_asg_shd.g_old_rec.job_post_source_name;
1655: End If;
1656: If (p_rec.posting_content_id = hr_api.g_number) then
1657: p_rec.posting_content_id :=
1658: per_asg_shd.g_old_rec.posting_content_id;
1659: End If;
1660: If (p_rec.period_of_placement_date_start = hr_api.g_date) then

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

1656: If (p_rec.posting_content_id = hr_api.g_number) then
1657: p_rec.posting_content_id :=
1658: per_asg_shd.g_old_rec.posting_content_id;
1659: End If;
1660: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1661: p_rec.period_of_placement_date_start :=
1662: per_asg_shd.g_old_rec.period_of_placement_date_start;
1663: End If;
1664: If (p_rec.vendor_id = hr_api.g_number) then

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

1660: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1661: p_rec.period_of_placement_date_start :=
1662: per_asg_shd.g_old_rec.period_of_placement_date_start;
1663: End If;
1664: If (p_rec.vendor_id = hr_api.g_number) then
1665: p_rec.vendor_id :=
1666: per_asg_shd.g_old_rec.vendor_id;
1667: End If;
1668: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then

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

1664: If (p_rec.vendor_id = hr_api.g_number) then
1665: p_rec.vendor_id :=
1666: per_asg_shd.g_old_rec.vendor_id;
1667: End If;
1668: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1669: p_rec.vendor_employee_number :=
1670: per_asg_shd.g_old_rec.vendor_employee_number;
1671: End If;
1672: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then

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

1668: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1669: p_rec.vendor_employee_number :=
1670: per_asg_shd.g_old_rec.vendor_employee_number;
1671: End If;
1672: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1673: p_rec.vendor_assignment_number :=
1674: per_asg_shd.g_old_rec.vendor_assignment_number;
1675: End If;
1676: If (p_rec.assignment_category = hr_api.g_varchar2) then

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

1672: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1673: p_rec.vendor_assignment_number :=
1674: per_asg_shd.g_old_rec.vendor_assignment_number;
1675: End If;
1676: If (p_rec.assignment_category = hr_api.g_varchar2) then
1677: p_rec.assignment_category :=
1678: per_asg_shd.g_old_rec.assignment_category;
1679: End If;
1680: If (p_rec.project_title = hr_api.g_varchar2) then

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

1676: If (p_rec.assignment_category = hr_api.g_varchar2) then
1677: p_rec.assignment_category :=
1678: per_asg_shd.g_old_rec.assignment_category;
1679: End If;
1680: If (p_rec.project_title = hr_api.g_varchar2) then
1681: p_rec.project_title :=
1682: per_asg_shd.g_old_rec.project_title;
1683: End If;
1684: If (p_rec.applicant_rank = hr_api.g_number) then

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

1680: If (p_rec.project_title = hr_api.g_varchar2) then
1681: p_rec.project_title :=
1682: per_asg_shd.g_old_rec.project_title;
1683: End If;
1684: If (p_rec.applicant_rank = hr_api.g_number) then
1685: p_rec.applicant_rank :=
1686: per_asg_shd.g_old_rec.applicant_rank;
1687: End If;
1688: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then

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

1684: If (p_rec.applicant_rank = hr_api.g_number) then
1685: p_rec.applicant_rank :=
1686: per_asg_shd.g_old_rec.applicant_rank;
1687: End If;
1688: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then
1689: p_rec.grade_ladder_pgm_id :=
1690: per_asg_shd.g_old_rec.grade_ladder_pgm_id;
1691: End If;
1692: If (p_rec.supervisor_assignment_id = hr_api.g_number) then

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

1688: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then
1689: p_rec.grade_ladder_pgm_id :=
1690: per_asg_shd.g_old_rec.grade_ladder_pgm_id;
1691: End If;
1692: If (p_rec.supervisor_assignment_id = hr_api.g_number) then
1693: p_rec.supervisor_assignment_id :=
1694: per_asg_shd.g_old_rec.supervisor_assignment_id;
1695: End If;
1696: If (p_rec.vendor_site_id = hr_api.g_number) then

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

1692: If (p_rec.supervisor_assignment_id = hr_api.g_number) then
1693: p_rec.supervisor_assignment_id :=
1694: per_asg_shd.g_old_rec.supervisor_assignment_id;
1695: End If;
1696: If (p_rec.vendor_site_id = hr_api.g_number) then
1697: p_rec.vendor_site_id :=
1698: per_asg_shd.g_old_rec.vendor_site_id;
1699: End If;
1700: If (p_rec.po_header_id = hr_api.g_number) then

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

1696: If (p_rec.vendor_site_id = hr_api.g_number) then
1697: p_rec.vendor_site_id :=
1698: per_asg_shd.g_old_rec.vendor_site_id;
1699: End If;
1700: If (p_rec.po_header_id = hr_api.g_number) then
1701: p_rec.po_header_id :=
1702: per_asg_shd.g_old_rec.po_header_id;
1703: End If;
1704: If (p_rec.po_line_id = hr_api.g_number) then

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

1700: If (p_rec.po_header_id = hr_api.g_number) then
1701: p_rec.po_header_id :=
1702: per_asg_shd.g_old_rec.po_header_id;
1703: End If;
1704: If (p_rec.po_line_id = hr_api.g_number) then
1705: p_rec.po_line_id :=
1706: per_asg_shd.g_old_rec.po_line_id;
1707: End If;
1708: If (p_rec.projected_assignment_end = hr_api.g_date) then

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

1704: If (p_rec.po_line_id = hr_api.g_number) then
1705: p_rec.po_line_id :=
1706: per_asg_shd.g_old_rec.po_line_id;
1707: End If;
1708: If (p_rec.projected_assignment_end = hr_api.g_date) then
1709: p_rec.projected_assignment_end :=
1710: per_asg_shd.g_old_rec.projected_assignment_end;
1711: End If;
1712: --

Line 1847: Raise HR_Api.Validate_Enabled;

1843: --
1844: -- If we are validating then raise the Validate_Enabled exception
1845: --
1846: If p_validate then
1847: Raise HR_Api.Validate_Enabled;
1848: End If;
1849: --
1850: hr_utility.set_location(' Leaving:'||l_proc, 10);
1851: Exception

Line 1852: When HR_Api.Validate_Enabled Then

1848: End If;
1849: --
1850: hr_utility.set_location(' Leaving:'||l_proc, 10);
1851: Exception
1852: When HR_Api.Validate_Enabled Then
1853: --
1854: -- As the Validate_Enabled exception has been raised
1855: -- we must rollback to the savepoint
1856: --

Line 1870: p_recruiter_id in number default hr_api.g_number,

1866: p_effective_start_date out nocopy date,
1867: p_effective_end_date out nocopy date,
1868:
1869: p_business_group_id out nocopy number,
1870: p_recruiter_id in number default hr_api.g_number,
1871: p_grade_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,

Line 1871: p_grade_id in number default hr_api.g_number,

1867: p_effective_end_date out nocopy date,
1868:
1869: p_business_group_id out nocopy number,
1870: p_recruiter_id in number default hr_api.g_number,
1871: p_grade_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,

Line 1872: p_position_id in number default hr_api.g_number,

1868:
1869: p_business_group_id out nocopy number,
1870: p_recruiter_id in number default hr_api.g_number,
1871: p_grade_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,

Line 1873: p_job_id in number default hr_api.g_number,

1869: p_business_group_id out nocopy number,
1870: p_recruiter_id in number default hr_api.g_number,
1871: p_grade_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,

Line 1874: p_assignment_status_type_id in number default hr_api.g_number,

1870: p_recruiter_id in number default hr_api.g_number,
1871: p_grade_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,

Line 1875: p_payroll_id in number default hr_api.g_number,

1871: p_grade_id in number default hr_api.g_number,
1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,

Line 1876: p_location_id in number default hr_api.g_number,

1872: p_position_id in number default hr_api.g_number,
1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,

Line 1877: p_person_referred_by_id in number default hr_api.g_number,

1873: p_job_id in number default hr_api.g_number,
1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,

Line 1878: p_supervisor_id in number default hr_api.g_number,

1874: p_assignment_status_type_id in number default hr_api.g_number,
1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1882:

Line 1879: p_special_ceiling_step_id in number default hr_api.g_number,

1875: p_payroll_id in number default hr_api.g_number,
1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1882:
1883: p_organization_id in number default hr_api.g_number,

Line 1880: p_recruitment_activity_id in number default hr_api.g_number,

1876: p_location_id in number default hr_api.g_number,
1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1882:
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,

Line 1881: p_source_organization_id in number default hr_api.g_number,

1877: p_person_referred_by_id in number default hr_api.g_number,
1878: p_supervisor_id in number default hr_api.g_number,
1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1882:
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,

Line 1883: p_organization_id in number default hr_api.g_number,

1879: p_special_ceiling_step_id in number default hr_api.g_number,
1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1882:
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,

Line 1884: p_people_group_id in number default hr_api.g_number,

1880: p_recruitment_activity_id in number default hr_api.g_number,
1881: p_source_organization_id in number default hr_api.g_number,
1882:
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,

Line 1885: p_soft_coding_keyflex_id in number default hr_api.g_number,

1881: p_source_organization_id in number default hr_api.g_number,
1882:
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,

Line 1886: p_vacancy_id in number default hr_api.g_number,

1882:
1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,

Line 1887: p_pay_basis_id in number default hr_api.g_number,

1883: p_organization_id in number default hr_api.g_number,
1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,

Line 1888: p_assignment_type in varchar2 default hr_api.g_varchar2,

1884: p_people_group_id in number default hr_api.g_number,
1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,

Line 1889: p_primary_flag in varchar2 default hr_api.g_varchar2,

1885: p_soft_coding_keyflex_id in number default hr_api.g_number,
1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,

Line 1890: p_application_id in number default hr_api.g_number,

1886: p_vacancy_id in number default hr_api.g_number,
1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,
1894: p_comments in varchar2 default hr_api.g_varchar2,

Line 1891: p_assignment_number in varchar2 default hr_api.g_varchar2,

1887: p_pay_basis_id in number default hr_api.g_number,
1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,
1894: p_comments in varchar2 default hr_api.g_varchar2,
1895: p_date_probation_end in date default hr_api.g_date,

Line 1892: p_change_reason in varchar2 default hr_api.g_varchar2,

1888: p_assignment_type in varchar2 default hr_api.g_varchar2,
1889: p_primary_flag in varchar2 default hr_api.g_varchar2,
1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,
1894: p_comments in varchar2 default hr_api.g_varchar2,
1895: p_date_probation_end in date default hr_api.g_date,
1896:

Line 1894: p_comments in varchar2 default hr_api.g_varchar2,

1890: p_application_id in number default hr_api.g_number,
1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,
1894: p_comments in varchar2 default hr_api.g_varchar2,
1895: p_date_probation_end in date default hr_api.g_date,
1896:
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,

Line 1895: p_date_probation_end in date default hr_api.g_date,

1891: p_assignment_number in varchar2 default hr_api.g_varchar2,
1892: p_change_reason in varchar2 default hr_api.g_varchar2,
1893: p_comment_id out nocopy number,
1894: p_comments in varchar2 default hr_api.g_varchar2,
1895: p_date_probation_end in date default hr_api.g_date,
1896:
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,

Line 1897: p_default_code_comb_id in number default hr_api.g_number,

1893: p_comment_id out nocopy number,
1894: p_comments in varchar2 default hr_api.g_varchar2,
1895: p_date_probation_end in date default hr_api.g_date,
1896:
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,

Line 1898: p_employment_category in varchar2 default hr_api.g_varchar2,

1894: p_comments in varchar2 default hr_api.g_varchar2,
1895: p_date_probation_end in date default hr_api.g_date,
1896:
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,

Line 1899: p_frequency in varchar2 default hr_api.g_varchar2,

1895: p_date_probation_end in date default hr_api.g_date,
1896:
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,

Line 1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,

1896:
1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,

Line 1901: p_manager_flag in varchar2 default hr_api.g_varchar2,

1897: p_default_code_comb_id in number default hr_api.g_number,
1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,

Line 1902: p_normal_hours in number default hr_api.g_number,

1898: p_employment_category in varchar2 default hr_api.g_varchar2,
1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,

Line 1903: p_perf_review_period in number default hr_api.g_number,

1899: p_frequency in varchar2 default hr_api.g_varchar2,
1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,

Line 1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,

1900: p_internal_address_line in varchar2 default hr_api.g_varchar2,
1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,

Line 1905: p_period_of_service_id in number default hr_api.g_number,

1901: p_manager_flag in varchar2 default hr_api.g_varchar2,
1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,

Line 1906: p_probation_period in number default hr_api.g_number,

1902: p_normal_hours in number default hr_api.g_number,
1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,

Line 1907: p_probation_unit in varchar2 default hr_api.g_varchar2,

1903: p_perf_review_period in number default hr_api.g_number,
1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:

Line 1908: p_sal_review_period in number default hr_api.g_number,

1904: p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,

Line 1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,

1905: p_period_of_service_id in number default hr_api.g_number,
1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,

Line 1910: p_set_of_books_id in number default hr_api.g_number,

1906: p_probation_period in number default hr_api.g_number,
1907: p_probation_unit in varchar2 default hr_api.g_varchar2,
1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,

Line 1912: p_source_type in varchar2 default hr_api.g_varchar2,

1908: p_sal_review_period in number default hr_api.g_number,
1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,

Line 1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,

1909: p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,

Line 1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,

1910: p_set_of_books_id in number default hr_api.g_number,
1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,

Line 1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,

1911:
1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,

Line 1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,

1912: p_source_type in varchar2 default hr_api.g_varchar2,
1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,

Line 1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,

1913: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,

Line 1918: p_request_id in number default hr_api.g_number,

1914: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,

Line 1919: p_program_application_id in number default hr_api.g_number,

1915: p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,

Line 1920: p_program_id in number default hr_api.g_number,

1916: p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,

Line 1921: p_program_update_date in date default hr_api.g_date,

1917: p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,

Line 1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,

1918: p_request_id in number default hr_api.g_number,
1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,

Line 1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,

1919: p_program_application_id in number default hr_api.g_number,
1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,

Line 1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,

1920: p_program_id in number default hr_api.g_number,
1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:

Line 1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,

1921: p_program_update_date in date default hr_api.g_date,
1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,

Line 1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,

1922: p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,

Line 1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,

1923: p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
1924: p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,

Line 1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,

1925: p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,

Line 1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,

1926: p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,

Line 1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,

1927: p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,

Line 1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,

1928:
1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,

Line 1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,

1929: p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,

Line 1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,

1930: p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,

Line 1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,

1931: p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,

Line 1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,

1932: p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,

Line 1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,

1933: p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,

Line 1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,

1934: p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:

Line 1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,

1935: p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,

Line 1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,

1936: p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,

Line 1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,

1937: p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
1938: p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,

Line 1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,

1939: p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,

Line 1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,

1940: p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,

Line 1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,

1941: p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,

Line 1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,

1942:
1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,

Line 1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,

1943: p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,

Line 1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,

1944: p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,

Line 1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,

1945: p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,

Line 1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,

1946: p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,

Line 1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,

1947: p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,

Line 1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,

1948: p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,

Line 1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,

1949: p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,

Line 1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,

1950: p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,

Line 1955: p_title in varchar2 default hr_api.g_varchar2,

1951: p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,

Line 1956: p_contract_id in number default hr_api.g_number,

1952: p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,

Line 1957: p_establishment_id in number default hr_api.g_number,

1953: p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,

Line 1958: p_collective_agreement_id in number default hr_api.g_number,

1954: p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,

Line 1959: p_cagr_grade_def_id in number default hr_api.g_number,

1955: p_title in varchar2 default hr_api.g_varchar2,
1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,

Line 1960: p_cagr_id_flex_num in number default hr_api.g_number,

1956: p_contract_id in number default hr_api.g_number,
1957: p_establishment_id in number default hr_api.g_number,
1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,

Line 1962: p_notice_period in number default hr_api.g_number,

1958: p_collective_agreement_id in number default hr_api.g_number,
1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,

Line 1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,

1959: p_cagr_grade_def_id in number default hr_api.g_number,
1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,

Line 1964: p_employee_category in varchar2 default hr_api.g_varchar2,

1960: p_cagr_id_flex_num in number default hr_api.g_number,
1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,

Line 1965: p_work_at_home in varchar2 default hr_api.g_varchar2,

1961: p_object_version_number in out nocopy number,
1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,

Line 1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,

1962: p_notice_period in number default hr_api.g_number,
1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,

Line 1967: p_posting_content_id in number default hr_api.g_number,

1963: p_notice_period_uom in varchar2 default hr_api.g_varchar2,
1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,

Line 1968: p_placement_date_start in date default hr_api.g_date,

1964: p_employee_category in varchar2 default hr_api.g_varchar2,
1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,

Line 1969: p_vendor_id in number default hr_api.g_number,

1965: p_work_at_home in varchar2 default hr_api.g_varchar2,
1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,

Line 1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,

1966: p_job_post_source_name in varchar2 default hr_api.g_varchar2,
1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,

Line 1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,

1967: p_posting_content_id in number default hr_api.g_number,
1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,

Line 1972: p_assignment_category in varchar2 default hr_api.g_varchar2,

1968: p_placement_date_start in date default hr_api.g_date,
1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,

Line 1973: p_project_title in varchar2 default hr_api.g_varchar2,

1969: p_vendor_id in number default hr_api.g_number,
1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,

Line 1974: p_applicant_rank in number default hr_api.g_number,

1970: p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,

Line 1975: p_grade_ladder_pgm_id in number default hr_api.g_number,

1971: p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1979: p_po_line_id in number default hr_api.g_number,

Line 1976: p_supervisor_assignment_id in number default hr_api.g_number,

1972: p_assignment_category in varchar2 default hr_api.g_varchar2,
1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1979: p_po_line_id in number default hr_api.g_number,
1980: p_projected_assignment_end in date default hr_api.g_date,

Line 1977: p_vendor_site_id in number default hr_api.g_number,

1973: p_project_title in varchar2 default hr_api.g_varchar2,
1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1979: p_po_line_id in number default hr_api.g_number,
1980: p_projected_assignment_end in date default hr_api.g_date,
1981: p_payroll_id_updated out nocopy boolean,

Line 1978: p_po_header_id in number default hr_api.g_number,

1974: p_applicant_rank in number default hr_api.g_number,
1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1979: p_po_line_id in number default hr_api.g_number,
1980: p_projected_assignment_end in date default hr_api.g_date,
1981: p_payroll_id_updated out nocopy boolean,
1982: p_other_manager_warning out nocopy boolean,

Line 1979: p_po_line_id in number default hr_api.g_number,

1975: p_grade_ladder_pgm_id in number default hr_api.g_number,
1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1979: p_po_line_id in number default hr_api.g_number,
1980: p_projected_assignment_end in date default hr_api.g_date,
1981: p_payroll_id_updated out nocopy boolean,
1982: p_other_manager_warning out nocopy boolean,
1983: p_hourly_salaried_warning out nocopy boolean,

Line 1980: p_projected_assignment_end in date default hr_api.g_date,

1976: p_supervisor_assignment_id in number default hr_api.g_number,
1977: p_vendor_site_id in number default hr_api.g_number,
1978: p_po_header_id in number default hr_api.g_number,
1979: p_po_line_id in number default hr_api.g_number,
1980: p_projected_assignment_end in date default hr_api.g_date,
1981: p_payroll_id_updated out nocopy boolean,
1982: p_other_manager_warning out nocopy boolean,
1983: p_hourly_salaried_warning out nocopy boolean,
1984: p_no_managers_warning out nocopy boolean,

Line 2010: hr_api.g_number,

2006: p_assignment_id,
2007: null,
2008:
2009: null,
2010: hr_api.g_number,
2011: p_recruiter_id,
2012: p_grade_id,
2013: p_position_id,
2014: p_job_id,

Line 2021: hr_api.g_number,

2017: p_location_id,
2018: p_person_referred_by_id,
2019: p_supervisor_id,
2020: p_special_ceiling_step_id,
2021: hr_api.g_number,
2022:
2023: p_recruitment_activity_id,
2024: p_source_organization_id,
2025: p_organization_id,

Line 2030: hr_api.g_number,

2026: p_people_group_id,
2027: p_soft_coding_keyflex_id,
2028: p_vacancy_id,
2029: p_pay_basis_id,
2030: hr_api.g_number,
2031: p_assignment_type,
2032: p_primary_flag,
2033: p_application_id,
2034: p_assignment_number,

Line 2036: hr_api.g_number,

2032: p_primary_flag,
2033: p_application_id,
2034: p_assignment_number,
2035: p_change_reason,
2036: hr_api.g_number,
2037: p_comments,
2038: p_date_probation_end,
2039: p_default_code_comb_id,
2040: p_employment_category,