APPS.PER_SSL_BUS dependencies on PER_SSL_SHD

Line 51: l_api_updating := per_ssl_shd.api_updating

47: Begin
48: --
49: hr_utility.set_location('Entering:'||l_proc, 5);
50: --
51: l_api_updating := per_ssl_shd.api_updating
52: (p_salary_survey_line_id => p_salary_survey_line_id,
53: p_object_version_number => p_object_version_number);
54: --
55: -- Check that the primary key has not changed.

Line 59: <> per_ssl_shd.g_old_rec.salary_survey_line_id) Then

55: -- Check that the primary key has not changed.
56: --
57: If (l_api_updating
58: and nvl(p_salary_survey_line_id,hr_api.g_number)
59: <> per_ssl_shd.g_old_rec.salary_survey_line_id) Then
60: --
61: -- raise error as Primary Key has changed
62: --
63: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_PK');

Line 63: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_PK');

59: <> per_ssl_shd.g_old_rec.salary_survey_line_id) Then
60: --
61: -- raise error as Primary Key has changed
62: --
63: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_PK');
64: --
65: elsIf not l_api_updating Then
66: --
67: -- This is an insert so check that the primary key is null.

Line 73: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_PK');

69: If p_salary_survey_line_id is not null Then
70: --
71: -- raise error as Primary Key is not null
72: --
73: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_PK');
74: --
75: End If;
76: --
77: End If;

Line 152: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_FK1');

148: --
149: -- raise error as FK does not relate to PK in per_salary_surveys
150: -- table.
151: --
152: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_FK1');
153: --
154: End If;
155: --
156: close csr_chk_survey_exists;

Line 300: l_api_updating := per_ssl_shd.api_updating

296: -- The current g_old_rec is current and
297: -- Any of the values have changed or
298: -- A record is being inserted
299: --
300: l_api_updating := per_ssl_shd.api_updating
301: (p_salary_survey_line_id => p_salary_survey_line_id
302: ,p_object_version_number => p_object_version_number
303: );
304: --

Line 308: and nvl(per_ssl_shd.g_old_rec.survey_job_name_code,hr_api.g_varchar2)

304: --
305: hr_utility.set_location(l_proc, 15);
306: --
307: If (l_api_updating
308: and nvl(per_ssl_shd.g_old_rec.survey_job_name_code,hr_api.g_varchar2)
309: <> nvl(p_survey_job_name_code,hr_api.g_varchar2))
310: or
311: (l_api_updating and
312: nvl(per_ssl_shd.g_old_rec.survey_region_code,hr_api.g_varchar2)

Line 312: nvl(per_ssl_shd.g_old_rec.survey_region_code,hr_api.g_varchar2)

308: and nvl(per_ssl_shd.g_old_rec.survey_job_name_code,hr_api.g_varchar2)
309: <> nvl(p_survey_job_name_code,hr_api.g_varchar2))
310: or
311: (l_api_updating and
312: nvl(per_ssl_shd.g_old_rec.survey_region_code,hr_api.g_varchar2)
313: <> nvl(p_survey_region_code,hr_api.g_varchar2))
314: or
315: (l_api_updating and
316: nvl(per_ssl_shd.g_old_rec.survey_seniority_code,hr_api.g_varchar2)

Line 316: nvl(per_ssl_shd.g_old_rec.survey_seniority_code,hr_api.g_varchar2)

312: nvl(per_ssl_shd.g_old_rec.survey_region_code,hr_api.g_varchar2)
313: <> nvl(p_survey_region_code,hr_api.g_varchar2))
314: or
315: (l_api_updating and
316: nvl(per_ssl_shd.g_old_rec.survey_seniority_code,hr_api.g_varchar2)
317: <> nvl(p_survey_seniority_code,hr_api.g_varchar2))
318: or
319: (l_api_updating and
320: nvl(per_ssl_shd.g_old_rec.company_size_code,hr_api.g_varchar2)

Line 320: nvl(per_ssl_shd.g_old_rec.company_size_code,hr_api.g_varchar2)

316: nvl(per_ssl_shd.g_old_rec.survey_seniority_code,hr_api.g_varchar2)
317: <> nvl(p_survey_seniority_code,hr_api.g_varchar2))
318: or
319: (l_api_updating and
320: nvl(per_ssl_shd.g_old_rec.company_size_code,hr_api.g_varchar2)
321: <> nvl(p_company_size_code,hr_api.g_varchar2))
322: or
323: (l_api_updating and
324: nvl(per_ssl_shd.g_old_rec.industry_code,hr_api.g_varchar2)

Line 324: nvl(per_ssl_shd.g_old_rec.industry_code,hr_api.g_varchar2)

320: nvl(per_ssl_shd.g_old_rec.company_size_code,hr_api.g_varchar2)
321: <> nvl(p_company_size_code,hr_api.g_varchar2))
322: or
323: (l_api_updating and
324: nvl(per_ssl_shd.g_old_rec.industry_code,hr_api.g_varchar2)
325: <> nvl(p_industry_code,hr_api.g_varchar2))
326: or
327: (l_api_updating and
328: nvl(per_ssl_shd.g_old_rec.survey_age_code,hr_api.g_varchar2)

Line 328: nvl(per_ssl_shd.g_old_rec.survey_age_code,hr_api.g_varchar2)

324: nvl(per_ssl_shd.g_old_rec.industry_code,hr_api.g_varchar2)
325: <> nvl(p_industry_code,hr_api.g_varchar2))
326: or
327: (l_api_updating and
328: nvl(per_ssl_shd.g_old_rec.survey_age_code,hr_api.g_varchar2)
329: <> nvl(p_survey_age_code,hr_api.g_varchar2))
330:
331: or
332: (l_api_updating and

Line 333: per_ssl_shd.g_old_rec.start_date <> p_start_date)

329: <> nvl(p_survey_age_code,hr_api.g_varchar2))
330:
331: or
332: (l_api_updating and
333: per_ssl_shd.g_old_rec.start_date <> p_start_date)
334: or
335: (l_api_updating and
336: nvl(per_ssl_shd.g_old_rec.end_date,l_eot)
337: <> nvl(p_end_date,l_eot)

Line 336: nvl(per_ssl_shd.g_old_rec.end_date,l_eot)

332: (l_api_updating and
333: per_ssl_shd.g_old_rec.start_date <> p_start_date)
334: or
335: (l_api_updating and
336: nvl(per_ssl_shd.g_old_rec.end_date,l_eot)
337: <> nvl(p_end_date,l_eot)
338: or
339: (NOT l_api_updating))
340: Then

Line 355: per_ssl_shd.constraint_error(p_constraint_name =>

351: If csr_duplicate_key%found Then
352: --
353: close csr_duplicate_key;
354: --
355: per_ssl_shd.constraint_error(p_constraint_name =>
356: 'PER_SALARY_SURVEY_LINES_UK1');
357: --
358: End If;
359: --

Line 505: l_api_updating := per_ssl_shd.api_updating

501: -- another not null value.
502: -- b) This is an insert.
503: --
504: --
505: l_api_updating := per_ssl_shd.api_updating
506: (p_salary_survey_line_id => p_salary_survey_line_id
507: ,p_object_version_number => p_object_version_number
508: );
509: --

Line 511: (per_ssl_shd.g_old_rec.survey_job_name_code <>

507: ,p_object_version_number => p_object_version_number
508: );
509: --
510: If (( l_api_updating and
511: (per_ssl_shd.g_old_rec.survey_job_name_code <>
512: p_survey_job_name_code))
513: or
514: (p_salary_survey_line_id is null)) Then
515: --

Line 647: l_api_updating := per_ssl_shd.api_updating

643: -- another not null value.
644: -- b) This is an insert.
645: --
646: --
647: l_api_updating := per_ssl_shd.api_updating
648: (p_salary_survey_line_id => p_salary_survey_line_id
649: ,p_object_version_number => p_object_version_number
650: );
651: --

Line 655: (nvl(per_ssl_shd.g_old_rec.survey_region_code,hr_api.g_varchar2)

651: --
652: If p_survey_region_code is not null Then
653: --
654: If ( ( l_api_updating and
655: (nvl(per_ssl_shd.g_old_rec.survey_region_code,hr_api.g_varchar2)
656: <> nvl(p_survey_region_code,hr_api.g_varchar2)))
657: or
658: (p_salary_survey_line_id is null) ) Then
659: --

Line 793: l_api_updating := per_ssl_shd.api_updating

789: -- another not null value.
790: -- b) This is an insert.
791: --
792: --
793: l_api_updating := per_ssl_shd.api_updating
794: (p_salary_survey_line_id => p_salary_survey_line_id
795: ,p_object_version_number => p_object_version_number
796: );
797: --

Line 800: (nvl(per_ssl_shd.g_old_rec.survey_seniority_code,

796: );
797: --
798: If p_survey_seniority_code is not null Then
799: If ((l_api_updating and
800: (nvl(per_ssl_shd.g_old_rec.survey_seniority_code,
801: hr_api.g_varchar2) <>
802: nvl(p_survey_seniority_code,hr_api.g_varchar2)))
803: or
804: (p_salary_survey_line_id is null)) Then

Line 938: l_api_updating := per_ssl_shd.api_updating

934: -- another not null value.
935: -- b) This is an insert.
936: --
937: --
938: l_api_updating := per_ssl_shd.api_updating
939: (p_salary_survey_line_id => p_salary_survey_line_id
940: ,p_object_version_number => p_object_version_number
941: );
942: --

Line 945: (nvl(per_ssl_shd.g_old_rec.company_size_code,

941: );
942: --
943: If p_company_size_code is not null Then
944: If ((l_api_updating and
945: (nvl(per_ssl_shd.g_old_rec.company_size_code,
946: hr_api.g_varchar2) <>
947: nvl(p_company_size_code,hr_api.g_varchar2)))
948: or
949: (p_salary_survey_line_id is null)) Then

Line 1084: l_api_updating := per_ssl_shd.api_updating

1080: -- another not null value.
1081: -- b) This is an insert.
1082: --
1083: --
1084: l_api_updating := per_ssl_shd.api_updating
1085: (p_salary_survey_line_id => p_salary_survey_line_id
1086: ,p_object_version_number => p_object_version_number
1087: );
1088: --

Line 1092: (nvl(per_ssl_shd.g_old_rec.industry_code,

1088: --
1089: If p_industry_code is not null Then
1090: --
1091: If ((l_api_updating and
1092: (nvl(per_ssl_shd.g_old_rec.industry_code,
1093: hr_api.g_varchar2) <>
1094: nvl(p_industry_code,hr_api.g_varchar2)))
1095: or
1096: (p_salary_survey_line_id is null)) Then

Line 1233: l_api_updating := per_ssl_shd.api_updating

1229: -- another not null value.
1230: -- b) This is an insert.
1231: --
1232: --
1233: l_api_updating := per_ssl_shd.api_updating
1234: (p_salary_survey_line_id => p_salary_survey_line_id
1235: ,p_object_version_number => p_object_version_number
1236: );
1237: --

Line 1241: (nvl(per_ssl_shd.g_old_rec.survey_age_code,

1237: --
1238: If p_survey_age_code is not null Then
1239: --
1240: If ((l_api_updating and
1241: (nvl(per_ssl_shd.g_old_rec.survey_age_code,
1242: hr_api.g_varchar2) <>
1243: nvl(p_survey_age_code,hr_api.g_varchar2)))
1244: or
1245: (p_salary_survey_line_id is null)) Then

Line 1368: l_api_updating := per_ssl_shd.api_updating

1364: -- another not null value.
1365: -- b) This is an insert.
1366: --
1367: --
1368: l_api_updating := per_ssl_shd.api_updating
1369: (p_salary_survey_line_id => p_salary_survey_line_id
1370: ,p_object_version_number => p_object_version_number
1371: );
1372: --

Line 1377: (per_ssl_shd.g_old_rec.stock_display_type <>

1373: If p_stock_display_type_code is not null Then
1374: -- Above check added for bug4343756
1375: --
1376: If (( l_api_updating and
1377: (per_ssl_shd.g_old_rec.stock_display_type <>
1378: p_stock_display_type_code))
1379: or
1380: (p_salary_survey_line_id is null)) Then
1381: --

Line 1570: l_api_updating := per_ssl_shd.api_updating

1566: -- The current g_old_rec is current and
1567: -- Any of the values have changed or
1568: -- A record is being inserted
1569: --
1570: l_api_updating := per_ssl_shd.api_updating
1571: (p_salary_survey_line_id => p_salary_survey_line_id
1572: ,p_object_version_number => p_object_version_number
1573: );
1574: --

Line 1576: ((nvl(per_ssl_shd.g_old_rec.minimum_pay,hr_api.g_number)

1572: ,p_object_version_number => p_object_version_number
1573: );
1574: --
1575: If ( l_api_updating and
1576: ((nvl(per_ssl_shd.g_old_rec.minimum_pay,hr_api.g_number)
1577: <> nvl(p_minimum_pay,hr_api.g_number)) or
1578: (nvl(per_ssl_shd.g_old_rec.maximum_pay,hr_api.g_number)
1579: <> nvl(p_maximum_pay,hr_api.g_number)) or
1580: (nvl(per_ssl_shd.g_old_rec.mean_pay,hr_api.g_number)

Line 1578: (nvl(per_ssl_shd.g_old_rec.maximum_pay,hr_api.g_number)

1574: --
1575: If ( l_api_updating and
1576: ((nvl(per_ssl_shd.g_old_rec.minimum_pay,hr_api.g_number)
1577: <> nvl(p_minimum_pay,hr_api.g_number)) or
1578: (nvl(per_ssl_shd.g_old_rec.maximum_pay,hr_api.g_number)
1579: <> nvl(p_maximum_pay,hr_api.g_number)) or
1580: (nvl(per_ssl_shd.g_old_rec.mean_pay,hr_api.g_number)
1581: <> nvl(p_mean_pay,hr_api.g_number)) or
1582: (nvl(per_ssl_shd.g_old_rec.graduate_pay,hr_api.g_number)

Line 1580: (nvl(per_ssl_shd.g_old_rec.mean_pay,hr_api.g_number)

1576: ((nvl(per_ssl_shd.g_old_rec.minimum_pay,hr_api.g_number)
1577: <> nvl(p_minimum_pay,hr_api.g_number)) or
1578: (nvl(per_ssl_shd.g_old_rec.maximum_pay,hr_api.g_number)
1579: <> nvl(p_maximum_pay,hr_api.g_number)) or
1580: (nvl(per_ssl_shd.g_old_rec.mean_pay,hr_api.g_number)
1581: <> nvl(p_mean_pay,hr_api.g_number)) or
1582: (nvl(per_ssl_shd.g_old_rec.graduate_pay,hr_api.g_number)
1583: <> nvl(p_graduate_pay,hr_api.g_number)) or
1584: (nvl(per_ssl_shd.g_old_rec.starting_pay,hr_api.g_number)

Line 1582: (nvl(per_ssl_shd.g_old_rec.graduate_pay,hr_api.g_number)

1578: (nvl(per_ssl_shd.g_old_rec.maximum_pay,hr_api.g_number)
1579: <> nvl(p_maximum_pay,hr_api.g_number)) or
1580: (nvl(per_ssl_shd.g_old_rec.mean_pay,hr_api.g_number)
1581: <> nvl(p_mean_pay,hr_api.g_number)) or
1582: (nvl(per_ssl_shd.g_old_rec.graduate_pay,hr_api.g_number)
1583: <> nvl(p_graduate_pay,hr_api.g_number)) or
1584: (nvl(per_ssl_shd.g_old_rec.starting_pay,hr_api.g_number)
1585: <> nvl(p_starting_pay,hr_api.g_number)) or
1586: (nvl(per_ssl_shd.g_old_rec.percentage_change,hr_api.g_number)

Line 1584: (nvl(per_ssl_shd.g_old_rec.starting_pay,hr_api.g_number)

1580: (nvl(per_ssl_shd.g_old_rec.mean_pay,hr_api.g_number)
1581: <> nvl(p_mean_pay,hr_api.g_number)) or
1582: (nvl(per_ssl_shd.g_old_rec.graduate_pay,hr_api.g_number)
1583: <> nvl(p_graduate_pay,hr_api.g_number)) or
1584: (nvl(per_ssl_shd.g_old_rec.starting_pay,hr_api.g_number)
1585: <> nvl(p_starting_pay,hr_api.g_number)) or
1586: (nvl(per_ssl_shd.g_old_rec.percentage_change,hr_api.g_number)
1587: <> nvl(p_percentage_change,hr_api.g_number)) or
1588: (nvl(per_ssl_shd.g_old_rec.job_first_quartile,hr_api.g_number)

Line 1586: (nvl(per_ssl_shd.g_old_rec.percentage_change,hr_api.g_number)

1582: (nvl(per_ssl_shd.g_old_rec.graduate_pay,hr_api.g_number)
1583: <> nvl(p_graduate_pay,hr_api.g_number)) or
1584: (nvl(per_ssl_shd.g_old_rec.starting_pay,hr_api.g_number)
1585: <> nvl(p_starting_pay,hr_api.g_number)) or
1586: (nvl(per_ssl_shd.g_old_rec.percentage_change,hr_api.g_number)
1587: <> nvl(p_percentage_change,hr_api.g_number)) or
1588: (nvl(per_ssl_shd.g_old_rec.job_first_quartile,hr_api.g_number)
1589: <> nvl(p_job_first_quartile,hr_api.g_number)) or
1590: (nvl(per_ssl_shd.g_old_rec.job_median_quartile,hr_api.g_number)

Line 1588: (nvl(per_ssl_shd.g_old_rec.job_first_quartile,hr_api.g_number)

1584: (nvl(per_ssl_shd.g_old_rec.starting_pay,hr_api.g_number)
1585: <> nvl(p_starting_pay,hr_api.g_number)) or
1586: (nvl(per_ssl_shd.g_old_rec.percentage_change,hr_api.g_number)
1587: <> nvl(p_percentage_change,hr_api.g_number)) or
1588: (nvl(per_ssl_shd.g_old_rec.job_first_quartile,hr_api.g_number)
1589: <> nvl(p_job_first_quartile,hr_api.g_number)) or
1590: (nvl(per_ssl_shd.g_old_rec.job_median_quartile,hr_api.g_number)
1591: <> nvl(p_job_median_quartile,hr_api.g_number)) or
1592: (nvl(per_ssl_shd.g_old_rec.job_third_quartile,hr_api.g_number)

Line 1590: (nvl(per_ssl_shd.g_old_rec.job_median_quartile,hr_api.g_number)

1586: (nvl(per_ssl_shd.g_old_rec.percentage_change,hr_api.g_number)
1587: <> nvl(p_percentage_change,hr_api.g_number)) or
1588: (nvl(per_ssl_shd.g_old_rec.job_first_quartile,hr_api.g_number)
1589: <> nvl(p_job_first_quartile,hr_api.g_number)) or
1590: (nvl(per_ssl_shd.g_old_rec.job_median_quartile,hr_api.g_number)
1591: <> nvl(p_job_median_quartile,hr_api.g_number)) or
1592: (nvl(per_ssl_shd.g_old_rec.job_third_quartile,hr_api.g_number)
1593: <> nvl(p_job_third_quartile,hr_api.g_number)) or
1594: (nvl(per_ssl_shd.g_old_rec.job_fourth_quartile,hr_api.g_number)

Line 1592: (nvl(per_ssl_shd.g_old_rec.job_third_quartile,hr_api.g_number)

1588: (nvl(per_ssl_shd.g_old_rec.job_first_quartile,hr_api.g_number)
1589: <> nvl(p_job_first_quartile,hr_api.g_number)) or
1590: (nvl(per_ssl_shd.g_old_rec.job_median_quartile,hr_api.g_number)
1591: <> nvl(p_job_median_quartile,hr_api.g_number)) or
1592: (nvl(per_ssl_shd.g_old_rec.job_third_quartile,hr_api.g_number)
1593: <> nvl(p_job_third_quartile,hr_api.g_number)) or
1594: (nvl(per_ssl_shd.g_old_rec.job_fourth_quartile,hr_api.g_number)
1595: <> nvl(p_job_fourth_quartile,hr_api.g_number)) or
1596: (nvl(per_ssl_shd.g_old_rec.minimum_total_compensation,hr_api.g_number)

Line 1594: (nvl(per_ssl_shd.g_old_rec.job_fourth_quartile,hr_api.g_number)

1590: (nvl(per_ssl_shd.g_old_rec.job_median_quartile,hr_api.g_number)
1591: <> nvl(p_job_median_quartile,hr_api.g_number)) or
1592: (nvl(per_ssl_shd.g_old_rec.job_third_quartile,hr_api.g_number)
1593: <> nvl(p_job_third_quartile,hr_api.g_number)) or
1594: (nvl(per_ssl_shd.g_old_rec.job_fourth_quartile,hr_api.g_number)
1595: <> nvl(p_job_fourth_quartile,hr_api.g_number)) or
1596: (nvl(per_ssl_shd.g_old_rec.minimum_total_compensation,hr_api.g_number)
1597: <> nvl(p_minimum_total_compensation,hr_api.g_number)) or
1598: (nvl(per_ssl_shd.g_old_rec.mean_total_compensation,hr_api.g_number)

Line 1596: (nvl(per_ssl_shd.g_old_rec.minimum_total_compensation,hr_api.g_number)

1592: (nvl(per_ssl_shd.g_old_rec.job_third_quartile,hr_api.g_number)
1593: <> nvl(p_job_third_quartile,hr_api.g_number)) or
1594: (nvl(per_ssl_shd.g_old_rec.job_fourth_quartile,hr_api.g_number)
1595: <> nvl(p_job_fourth_quartile,hr_api.g_number)) or
1596: (nvl(per_ssl_shd.g_old_rec.minimum_total_compensation,hr_api.g_number)
1597: <> nvl(p_minimum_total_compensation,hr_api.g_number)) or
1598: (nvl(per_ssl_shd.g_old_rec.mean_total_compensation,hr_api.g_number)
1599: <> nvl(p_mean_total_compensation,hr_api.g_number)) or
1600: (nvl(per_ssl_shd.g_old_rec.maximum_total_compensation,hr_api.g_number)

Line 1598: (nvl(per_ssl_shd.g_old_rec.mean_total_compensation,hr_api.g_number)

1594: (nvl(per_ssl_shd.g_old_rec.job_fourth_quartile,hr_api.g_number)
1595: <> nvl(p_job_fourth_quartile,hr_api.g_number)) or
1596: (nvl(per_ssl_shd.g_old_rec.minimum_total_compensation,hr_api.g_number)
1597: <> nvl(p_minimum_total_compensation,hr_api.g_number)) or
1598: (nvl(per_ssl_shd.g_old_rec.mean_total_compensation,hr_api.g_number)
1599: <> nvl(p_mean_total_compensation,hr_api.g_number)) or
1600: (nvl(per_ssl_shd.g_old_rec.maximum_total_compensation,hr_api.g_number)
1601: <> nvl(p_maximum_total_compensation,hr_api.g_number)) or
1602: (nvl(per_ssl_shd.g_old_rec.compnstn_first_quartile,hr_api.g_number)

Line 1600: (nvl(per_ssl_shd.g_old_rec.maximum_total_compensation,hr_api.g_number)

1596: (nvl(per_ssl_shd.g_old_rec.minimum_total_compensation,hr_api.g_number)
1597: <> nvl(p_minimum_total_compensation,hr_api.g_number)) or
1598: (nvl(per_ssl_shd.g_old_rec.mean_total_compensation,hr_api.g_number)
1599: <> nvl(p_mean_total_compensation,hr_api.g_number)) or
1600: (nvl(per_ssl_shd.g_old_rec.maximum_total_compensation,hr_api.g_number)
1601: <> nvl(p_maximum_total_compensation,hr_api.g_number)) or
1602: (nvl(per_ssl_shd.g_old_rec.compnstn_first_quartile,hr_api.g_number)
1603: <> nvl(p_compnstn_first_quartile,hr_api.g_number)) or
1604: (nvl(per_ssl_shd.g_old_rec.compnstn_median_quartile,hr_api.g_number)

Line 1602: (nvl(per_ssl_shd.g_old_rec.compnstn_first_quartile,hr_api.g_number)

1598: (nvl(per_ssl_shd.g_old_rec.mean_total_compensation,hr_api.g_number)
1599: <> nvl(p_mean_total_compensation,hr_api.g_number)) or
1600: (nvl(per_ssl_shd.g_old_rec.maximum_total_compensation,hr_api.g_number)
1601: <> nvl(p_maximum_total_compensation,hr_api.g_number)) or
1602: (nvl(per_ssl_shd.g_old_rec.compnstn_first_quartile,hr_api.g_number)
1603: <> nvl(p_compnstn_first_quartile,hr_api.g_number)) or
1604: (nvl(per_ssl_shd.g_old_rec.compnstn_median_quartile,hr_api.g_number)
1605: <> nvl(p_compnstn_median_quartile,hr_api.g_number)) or
1606: (nvl(per_ssl_shd.g_old_rec.compnstn_third_quartile,hr_api.g_number)

Line 1604: (nvl(per_ssl_shd.g_old_rec.compnstn_median_quartile,hr_api.g_number)

1600: (nvl(per_ssl_shd.g_old_rec.maximum_total_compensation,hr_api.g_number)
1601: <> nvl(p_maximum_total_compensation,hr_api.g_number)) or
1602: (nvl(per_ssl_shd.g_old_rec.compnstn_first_quartile,hr_api.g_number)
1603: <> nvl(p_compnstn_first_quartile,hr_api.g_number)) or
1604: (nvl(per_ssl_shd.g_old_rec.compnstn_median_quartile,hr_api.g_number)
1605: <> nvl(p_compnstn_median_quartile,hr_api.g_number)) or
1606: (nvl(per_ssl_shd.g_old_rec.compnstn_third_quartile,hr_api.g_number)
1607: <> nvl(p_compnstn_third_quartile,hr_api.g_number)) or
1608: (nvl(per_ssl_shd.g_old_rec.compnstn_fourth_quartile,hr_api.g_number)

Line 1606: (nvl(per_ssl_shd.g_old_rec.compnstn_third_quartile,hr_api.g_number)

1602: (nvl(per_ssl_shd.g_old_rec.compnstn_first_quartile,hr_api.g_number)
1603: <> nvl(p_compnstn_first_quartile,hr_api.g_number)) or
1604: (nvl(per_ssl_shd.g_old_rec.compnstn_median_quartile,hr_api.g_number)
1605: <> nvl(p_compnstn_median_quartile,hr_api.g_number)) or
1606: (nvl(per_ssl_shd.g_old_rec.compnstn_third_quartile,hr_api.g_number)
1607: <> nvl(p_compnstn_third_quartile,hr_api.g_number)) or
1608: (nvl(per_ssl_shd.g_old_rec.compnstn_fourth_quartile,hr_api.g_number)
1609: <> nvl(p_compnstn_fourth_quartile,hr_api.g_number)) ) OR
1610: (not l_api_updating) )

Line 1608: (nvl(per_ssl_shd.g_old_rec.compnstn_fourth_quartile,hr_api.g_number)

1604: (nvl(per_ssl_shd.g_old_rec.compnstn_median_quartile,hr_api.g_number)
1605: <> nvl(p_compnstn_median_quartile,hr_api.g_number)) or
1606: (nvl(per_ssl_shd.g_old_rec.compnstn_third_quartile,hr_api.g_number)
1607: <> nvl(p_compnstn_third_quartile,hr_api.g_number)) or
1608: (nvl(per_ssl_shd.g_old_rec.compnstn_fourth_quartile,hr_api.g_number)
1609: <> nvl(p_compnstn_fourth_quartile,hr_api.g_number)) ) OR
1610: (not l_api_updating) )
1611: then
1612:

Line 1836: (per_ssl_shd.g_old_rec.start_date <> p_start_date)

1832: --
1833: If
1834: (p_salary_survey_line_id is not null)
1835: and
1836: (per_ssl_shd.g_old_rec.start_date <> p_start_date)
1837: or
1838: (p_salary_survey_line_id is null)
1839: Then
1840: --

Line 1928: nvl(per_ssl_shd.g_old_rec.currency_code,

1924: -- another not null value.
1925: -- b) This is an insert.
1926: --
1927: if (((p_salary_survey_line_id is not null) and
1928: nvl(per_ssl_shd.g_old_rec.currency_code,
1929: hr_api.g_varchar2) <> nvl(p_currency_code,
1930: hr_api.g_varchar2))
1931: or
1932: (p_salary_survey_line_id is null)) then

Line 2052: (p_rec in per_ssl_shd.g_rec_type,

2048: --
2049: -- {End Of Comments}
2050:
2051: Procedure chk_non_updateable_args
2052: (p_rec in per_ssl_shd.g_rec_type,
2053: p_effective_date in date
2054: ) is
2055: --
2056: l_proc varchar2(72) := g_package||'chk_non_updateable_args';

Line 2066: if not per_ssl_shd.api_updating

2062: --
2063: -- Only proceed with validation if a row exists for
2064: -- the current record in the HR Schema
2065: --
2066: if not per_ssl_shd.api_updating
2067: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2068: ,p_object_version_number => p_rec.object_version_number
2069: ) then
2070: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 2077: if (p_rec.salary_survey_id <> per_ssl_shd.g_old_rec.salary_survey_id) then

2073: end if;
2074: --
2075: hr_utility.set_location(l_proc, 30);
2076: --
2077: if (p_rec.salary_survey_id <> per_ssl_shd.g_old_rec.salary_survey_id) then
2078: --
2079: l_argument := 'salary_survey_id';
2080: --
2081: raise l_error;

Line 2130: (p_rec in per_ssl_shd.g_rec_type) is

2126: -- Access Status:
2127: -- Internal Row Handler Use Only.
2128: --
2129: Procedure chk_df
2130: (p_rec in per_ssl_shd.g_rec_type) is
2131: --
2132: l_proc varchar2(72) := g_package||'chk_df';
2133: --
2134: Begin

Line 2138: nvl(per_ssl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

2134: Begin
2135: hr_utility.set_location('Entering:'||l_proc, 10);
2136: --
2137: If ((p_rec.salary_survey_line_id is not null) and (
2138: nvl(per_ssl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2139: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2140: nvl(per_ssl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2141: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2142: nvl(per_ssl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 2140: nvl(per_ssl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

2136: --
2137: If ((p_rec.salary_survey_line_id is not null) and (
2138: nvl(per_ssl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2139: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2140: nvl(per_ssl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2141: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2142: nvl(per_ssl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2143: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2144: nvl(per_ssl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 2142: nvl(per_ssl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

2138: nvl(per_ssl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2139: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2140: nvl(per_ssl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2141: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2142: nvl(per_ssl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2143: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2144: nvl(per_ssl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2145: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2146: nvl(per_ssl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 2144: nvl(per_ssl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

2140: nvl(per_ssl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2141: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2142: nvl(per_ssl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2143: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2144: nvl(per_ssl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2145: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2146: nvl(per_ssl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2147: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2148: nvl(per_ssl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 2146: nvl(per_ssl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

2142: nvl(per_ssl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2143: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2144: nvl(per_ssl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2145: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2146: nvl(per_ssl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2147: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2148: nvl(per_ssl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2149: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2150: nvl(per_ssl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 2148: nvl(per_ssl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

2144: nvl(per_ssl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2145: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2146: nvl(per_ssl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2147: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2148: nvl(per_ssl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2149: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2150: nvl(per_ssl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2151: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2152: nvl(per_ssl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 2150: nvl(per_ssl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

2146: nvl(per_ssl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2147: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2148: nvl(per_ssl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2149: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2150: nvl(per_ssl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2151: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2152: nvl(per_ssl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2153: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2154: nvl(per_ssl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 2152: nvl(per_ssl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

2148: nvl(per_ssl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2149: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2150: nvl(per_ssl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2151: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2152: nvl(per_ssl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2153: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2154: nvl(per_ssl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2155: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2156: nvl(per_ssl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 2154: nvl(per_ssl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

2150: nvl(per_ssl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2151: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2152: nvl(per_ssl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2153: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2154: nvl(per_ssl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2155: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2156: nvl(per_ssl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2157: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2158: nvl(per_ssl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 2156: nvl(per_ssl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

2152: nvl(per_ssl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2153: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2154: nvl(per_ssl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2155: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2156: nvl(per_ssl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2157: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2158: nvl(per_ssl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2159: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2160: nvl(per_ssl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 2158: nvl(per_ssl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

2154: nvl(per_ssl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2155: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2156: nvl(per_ssl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2157: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2158: nvl(per_ssl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2159: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2160: nvl(per_ssl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2161: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2162: nvl(per_ssl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 2160: nvl(per_ssl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

2156: nvl(per_ssl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2157: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2158: nvl(per_ssl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2159: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2160: nvl(per_ssl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2161: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2162: nvl(per_ssl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2163: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2164: nvl(per_ssl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 2162: nvl(per_ssl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

2158: nvl(per_ssl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2159: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2160: nvl(per_ssl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2161: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2162: nvl(per_ssl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2163: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2164: nvl(per_ssl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2165: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2166: nvl(per_ssl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 2164: nvl(per_ssl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

2160: nvl(per_ssl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2161: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2162: nvl(per_ssl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2163: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2164: nvl(per_ssl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2165: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2166: nvl(per_ssl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2167: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2168: nvl(per_ssl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 2166: nvl(per_ssl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

2162: nvl(per_ssl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2163: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2164: nvl(per_ssl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2165: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2166: nvl(per_ssl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2167: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2168: nvl(per_ssl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2169: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2170: nvl(per_ssl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 2168: nvl(per_ssl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

2164: nvl(per_ssl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2165: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2166: nvl(per_ssl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2167: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2168: nvl(per_ssl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2169: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2170: nvl(per_ssl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2171: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2172: nvl(per_ssl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 2170: nvl(per_ssl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

2166: nvl(per_ssl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2167: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2168: nvl(per_ssl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2169: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2170: nvl(per_ssl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2171: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2172: nvl(per_ssl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2173: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2174: nvl(per_ssl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 2172: nvl(per_ssl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

2168: nvl(per_ssl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2169: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2170: nvl(per_ssl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2171: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2172: nvl(per_ssl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2173: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2174: nvl(per_ssl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2175: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2176: nvl(per_ssl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 2174: nvl(per_ssl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

2170: nvl(per_ssl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2171: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2172: nvl(per_ssl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2173: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2174: nvl(per_ssl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2175: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2176: nvl(per_ssl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2177: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2178: nvl(per_ssl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 2176: nvl(per_ssl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

2172: nvl(per_ssl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2173: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2174: nvl(per_ssl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2175: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2176: nvl(per_ssl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2177: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2178: nvl(per_ssl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2179: nvl(p_rec.attribute20, hr_api.g_varchar2)
2180: /*Added for Enhancement 4021737*/

Line 2178: nvl(per_ssl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

2174: nvl(per_ssl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2175: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2176: nvl(per_ssl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2177: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2178: nvl(per_ssl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2179: nvl(p_rec.attribute20, hr_api.g_varchar2)
2180: /*Added for Enhancement 4021737*/
2181: or
2182: nvl(per_ssl_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 2182: nvl(per_ssl_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

2178: nvl(per_ssl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2179: nvl(p_rec.attribute20, hr_api.g_varchar2)
2180: /*Added for Enhancement 4021737*/
2181: or
2182: nvl(per_ssl_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2183: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2184: nvl(per_ssl_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2185: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2186: nvl(per_ssl_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 2184: nvl(per_ssl_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

2180: /*Added for Enhancement 4021737*/
2181: or
2182: nvl(per_ssl_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2183: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2184: nvl(per_ssl_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2185: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2186: nvl(per_ssl_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2187: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2188: nvl(per_ssl_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 2186: nvl(per_ssl_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

2182: nvl(per_ssl_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2183: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2184: nvl(per_ssl_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2185: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2186: nvl(per_ssl_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2187: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2188: nvl(per_ssl_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2189: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2190: nvl(per_ssl_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 2188: nvl(per_ssl_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

2184: nvl(per_ssl_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2185: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2186: nvl(per_ssl_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2187: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2188: nvl(per_ssl_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2189: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2190: nvl(per_ssl_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2191: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2192: nvl(per_ssl_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 2190: nvl(per_ssl_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

2186: nvl(per_ssl_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2187: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2188: nvl(per_ssl_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2189: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2190: nvl(per_ssl_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2191: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2192: nvl(per_ssl_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2193: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2194: nvl(per_ssl_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 2192: nvl(per_ssl_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

2188: nvl(per_ssl_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2189: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2190: nvl(per_ssl_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2191: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2192: nvl(per_ssl_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2193: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2194: nvl(per_ssl_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2195: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2196: nvl(per_ssl_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 2194: nvl(per_ssl_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

2190: nvl(per_ssl_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2191: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2192: nvl(per_ssl_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2193: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2194: nvl(per_ssl_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2195: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2196: nvl(per_ssl_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2197: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2198: nvl(per_ssl_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 2196: nvl(per_ssl_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

2192: nvl(per_ssl_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2193: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2194: nvl(per_ssl_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2195: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2196: nvl(per_ssl_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2197: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2198: nvl(per_ssl_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2199: nvl(p_rec.attribute29, hr_api.g_varchar2) or
2200: nvl(per_ssl_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 2198: nvl(per_ssl_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

2194: nvl(per_ssl_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2195: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2196: nvl(per_ssl_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2197: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2198: nvl(per_ssl_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2199: nvl(p_rec.attribute29, hr_api.g_varchar2) or
2200: nvl(per_ssl_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
2201: nvl(p_rec.attribute30, hr_api.g_varchar2)))
2202: /*End Enhancement 4021737 */

Line 2200: nvl(per_ssl_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

2196: nvl(per_ssl_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2197: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2198: nvl(per_ssl_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2199: nvl(p_rec.attribute29, hr_api.g_varchar2) or
2200: nvl(per_ssl_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
2201: nvl(p_rec.attribute30, hr_api.g_varchar2)))
2202: /*End Enhancement 4021737 */
2203: or
2204: (p_rec.salary_survey_line_id is null) Then

Line 2286: Procedure insert_validate(p_rec in per_ssl_shd.g_rec_type,

2282: --
2283: -- ----------------------------------------------------------------------------
2284: -- |---------------------------< insert_validate >----------------------------|
2285: -- ----------------------------------------------------------------------------
2286: Procedure insert_validate(p_rec in per_ssl_shd.g_rec_type,
2287: p_effective_date in date) is
2288: --
2289: l_proc varchar2(72) := g_package||'insert_validate';
2290: --

Line 2458: Procedure update_validate(p_rec in per_ssl_shd.g_rec_type,

2454: --
2455: -- ----------------------------------------------------------------------------
2456: -- |---------------------------< update_validate >----------------------------|
2457: -- ----------------------------------------------------------------------------
2458: Procedure update_validate(p_rec in per_ssl_shd.g_rec_type,
2459: p_effective_date in date) is
2460: --
2461: l_proc varchar2(72) := g_package||'update_validate';
2462: --

Line 2627: Procedure delete_validate(p_rec in per_ssl_shd.g_rec_type) is

2623: --
2624: -- ----------------------------------------------------------------------------
2625: -- |---------------------------< delete_validate >----------------------------|
2626: -- ----------------------------------------------------------------------------
2627: Procedure delete_validate(p_rec in per_ssl_shd.g_rec_type) is
2628: --
2629: l_proc varchar2(72) := g_package||'delete_validate';
2630: --
2631: Begin