APPS.PER_SSM_BUS dependencies on HR_API

Line 37: hr_api.mandatory_arg_error(p_api_name => l_proc

33: l_proc varchar2(72) := g_package||'return_legislation_code';
34: Begin
35: --
36: hr_utility.set_location('Entering:'||l_proc, 5);
37: hr_api.mandatory_arg_error(p_api_name => l_proc
38: ,p_argument => 'salary_survey_mapping_id'
39: ,p_argument_value => p_salary_survey_mapping_id
40: );
41: --

Line 42: if nvl( g_salary_survey_mapping_id, hr_api.g_number ) = p_salary_survey_mapping_id

38: ,p_argument => 'salary_survey_mapping_id'
39: ,p_argument_value => p_salary_survey_mapping_id
40: );
41: --
42: if nvl( g_salary_survey_mapping_id, hr_api.g_number ) = p_salary_survey_mapping_id
43: then
44: --
45: -- The legislation has already been found with a previous call to this
46: -- function. Just return the value in the global variable.

Line 96: if nvl(p_rec.business_group_id, hr_api.g_number) <>

92: end if;
93: --
94: hr_utility.set_location(l_proc, 6);
95: --
96: if nvl(p_rec.business_group_id, hr_api.g_number) <>
97: nvl(per_ssm_shd.g_old_rec.business_group_id, hr_api.g_number) then
98: l_argument := 'business_group_id';
99: raise l_error;
100: elsif nvl(p_rec.salary_survey_line_id, hr_api.g_number) <>

Line 97: nvl(per_ssm_shd.g_old_rec.business_group_id, hr_api.g_number) then

93: --
94: hr_utility.set_location(l_proc, 6);
95: --
96: if nvl(p_rec.business_group_id, hr_api.g_number) <>
97: nvl(per_ssm_shd.g_old_rec.business_group_id, hr_api.g_number) then
98: l_argument := 'business_group_id';
99: raise l_error;
100: elsif nvl(p_rec.salary_survey_line_id, hr_api.g_number) <>
101: nvl(per_ssm_shd.g_old_rec.salary_survey_line_id, hr_api.g_number) then

Line 100: elsif nvl(p_rec.salary_survey_line_id, hr_api.g_number) <>

96: if nvl(p_rec.business_group_id, hr_api.g_number) <>
97: nvl(per_ssm_shd.g_old_rec.business_group_id, hr_api.g_number) then
98: l_argument := 'business_group_id';
99: raise l_error;
100: elsif nvl(p_rec.salary_survey_line_id, hr_api.g_number) <>
101: nvl(per_ssm_shd.g_old_rec.salary_survey_line_id, hr_api.g_number) then
102: l_argument := 'salary_survey_line_id';
103: raise l_error;
104: elsif nvl(p_rec.parent_id, hr_api.g_number) <>

Line 101: nvl(per_ssm_shd.g_old_rec.salary_survey_line_id, hr_api.g_number) then

97: nvl(per_ssm_shd.g_old_rec.business_group_id, hr_api.g_number) then
98: l_argument := 'business_group_id';
99: raise l_error;
100: elsif nvl(p_rec.salary_survey_line_id, hr_api.g_number) <>
101: nvl(per_ssm_shd.g_old_rec.salary_survey_line_id, hr_api.g_number) then
102: l_argument := 'salary_survey_line_id';
103: raise l_error;
104: elsif nvl(p_rec.parent_id, hr_api.g_number) <>
105: nvl(per_ssm_shd.g_old_rec.parent_id, hr_api.g_number) then

Line 104: elsif nvl(p_rec.parent_id, hr_api.g_number) <>

100: elsif nvl(p_rec.salary_survey_line_id, hr_api.g_number) <>
101: nvl(per_ssm_shd.g_old_rec.salary_survey_line_id, hr_api.g_number) then
102: l_argument := 'salary_survey_line_id';
103: raise l_error;
104: elsif nvl(p_rec.parent_id, hr_api.g_number) <>
105: nvl(per_ssm_shd.g_old_rec.parent_id, hr_api.g_number) then
106: l_argument := 'parent_id';
107: raise l_error;
108: elsif nvl(p_rec.parent_table_name, hr_api.g_varchar2) <>

Line 105: nvl(per_ssm_shd.g_old_rec.parent_id, hr_api.g_number) then

101: nvl(per_ssm_shd.g_old_rec.salary_survey_line_id, hr_api.g_number) then
102: l_argument := 'salary_survey_line_id';
103: raise l_error;
104: elsif nvl(p_rec.parent_id, hr_api.g_number) <>
105: nvl(per_ssm_shd.g_old_rec.parent_id, hr_api.g_number) then
106: l_argument := 'parent_id';
107: raise l_error;
108: elsif nvl(p_rec.parent_table_name, hr_api.g_varchar2) <>
109: nvl(per_ssm_shd.g_old_rec.parent_table_name, hr_api.g_varchar2) then

Line 108: elsif nvl(p_rec.parent_table_name, hr_api.g_varchar2) <>

104: elsif nvl(p_rec.parent_id, hr_api.g_number) <>
105: nvl(per_ssm_shd.g_old_rec.parent_id, hr_api.g_number) then
106: l_argument := 'parent_id';
107: raise l_error;
108: elsif nvl(p_rec.parent_table_name, hr_api.g_varchar2) <>
109: nvl(per_ssm_shd.g_old_rec.parent_table_name, hr_api.g_varchar2) then
110: l_argument := 'parent_table_name';
111: raise l_error;
112: end if;

Line 109: nvl(per_ssm_shd.g_old_rec.parent_table_name, hr_api.g_varchar2) then

105: nvl(per_ssm_shd.g_old_rec.parent_id, hr_api.g_number) then
106: l_argument := 'parent_id';
107: raise l_error;
108: elsif nvl(p_rec.parent_table_name, hr_api.g_varchar2) <>
109: nvl(per_ssm_shd.g_old_rec.parent_table_name, hr_api.g_varchar2) then
110: l_argument := 'parent_table_name';
111: raise l_error;
112: end if;
113: hr_utility.set_location(l_proc, 11);

Line 117: hr_api.argument_changed_error

113: hr_utility.set_location(l_proc, 11);
114: --
115: exception
116: when l_error then
117: hr_api.argument_changed_error
118: (p_api_name => l_proc
119: ,p_argument => l_argument);
120: when others then
121: raise;

Line 213: select nvl(end_date,hr_api.g_eot)

209: l_proc varchar2(72) := g_package||'get_salary_survey_line_end';
210: l_end_date date;
211: --
212: cursor csr_get_dates is
213: select nvl(end_date,hr_api.g_eot)
214: from per_salary_survey_lines ssl
215: where ssl.salary_survey_line_id = p_salary_survey_line_id;
216: --
217: Begin

Line 278: --hr_api.mandatory_arg_error

274: hr_utility.set_location('Entering:'||l_proc,5);
275: --
276: -- Check mandatory parameters have been set
277: --
278: --hr_api.mandatory_arg_error
279: -- (p_api_name => l_proc
280: -- ,p_argument => 'salary_survey_line_id'
281: -- ,p_argument_value => p_salary_survey_line_id
282: -- );

Line 369: select j.business_group_id, date_from, nvl(date_to,hr_api.g_eot)

365: l_parent_start_date date;
366: l_parent_end_date date;
367: --
368: cursor csr_chk_job_id_exists is
369: select j.business_group_id, date_from, nvl(date_to,hr_api.g_eot)
370: from per_jobs j
371: where j.job_id = p_parent_id;
372: --
373: -- Changed 13-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position req

Line 396: -- hr_api.mandatory_arg_error

392: hr_utility.set_location('Entering:'||l_proc,5);
393: --
394: -- Check mandatory parameters have been set
395: --
396: -- hr_api.mandatory_arg_error
397: -- (p_api_name => l_proc
398: -- ,p_argument => 'parent_id'
399: -- ,p_argument_value => p_parent_id
400: -- );

Line 401: -- hr_api.mandatory_arg_error

397: -- (p_api_name => l_proc
398: -- ,p_argument => 'parent_id'
399: -- ,p_argument_value => p_parent_id
400: -- );
401: -- hr_api.mandatory_arg_error
402: -- (p_api_name => l_proc
403: -- ,p_argument => 'parent_table_name'
404: -- ,p_argument_value => p_parent_table_name
405: -- );

Line 416: (nvl(p_parent_id,hr_api.g_number)

412: --
413: hr_utility.set_location(l_proc,7);
414: --
415: If l_api_updating and
416: (nvl(p_parent_id,hr_api.g_number)
417: <> nvl(per_ssm_shd.g_old_rec.parent_id,hr_api.g_number)
418: or nvl(p_parent_table_name,hr_api.g_varchar2)
419: <> nvl(per_ssm_shd.g_old_rec.parent_table_name,hr_api.g_varchar2)) then
420: --

Line 417: <> nvl(per_ssm_shd.g_old_rec.parent_id,hr_api.g_number)

413: hr_utility.set_location(l_proc,7);
414: --
415: If l_api_updating and
416: (nvl(p_parent_id,hr_api.g_number)
417: <> nvl(per_ssm_shd.g_old_rec.parent_id,hr_api.g_number)
418: or nvl(p_parent_table_name,hr_api.g_varchar2)
419: <> nvl(per_ssm_shd.g_old_rec.parent_table_name,hr_api.g_varchar2)) then
420: --
421: hr_utility.set_location(l_proc,8);

Line 418: or nvl(p_parent_table_name,hr_api.g_varchar2)

414: --
415: If l_api_updating and
416: (nvl(p_parent_id,hr_api.g_number)
417: <> nvl(per_ssm_shd.g_old_rec.parent_id,hr_api.g_number)
418: or nvl(p_parent_table_name,hr_api.g_varchar2)
419: <> nvl(per_ssm_shd.g_old_rec.parent_table_name,hr_api.g_varchar2)) then
420: --
421: hr_utility.set_location(l_proc,8);
422: --

Line 419: <> nvl(per_ssm_shd.g_old_rec.parent_table_name,hr_api.g_varchar2)) then

415: If l_api_updating and
416: (nvl(p_parent_id,hr_api.g_number)
417: <> nvl(per_ssm_shd.g_old_rec.parent_id,hr_api.g_number)
418: or nvl(p_parent_table_name,hr_api.g_varchar2)
419: <> nvl(per_ssm_shd.g_old_rec.parent_table_name,hr_api.g_varchar2)) then
420: --
421: hr_utility.set_location(l_proc,8);
422: --
423: -- Trying to update parent_id or parent_table_name.

Line 509: Elsif (p_ssl_start_date > nvl(l_parent_end_date,hr_api.g_eot)) or

505: close csr_chk_position_id_exists;
506: fnd_message.set_name('PER','PER_52487_SSM_INVL_POS_BG');
507: fnd_message.raise_error;
508: --
509: Elsif (p_ssl_start_date > nvl(l_parent_end_date,hr_api.g_eot)) or
510: (nvl(p_ssl_end_date,hr_api.g_eot)< l_parent_start_date) then
511:
512: --
513: hr_utility.set_location(l_proc,62);

Line 510: (nvl(p_ssl_end_date,hr_api.g_eot)< l_parent_start_date) then

506: fnd_message.set_name('PER','PER_52487_SSM_INVL_POS_BG');
507: fnd_message.raise_error;
508: --
509: Elsif (p_ssl_start_date > nvl(l_parent_end_date,hr_api.g_eot)) or
510: (nvl(p_ssl_end_date,hr_api.g_eot)< l_parent_start_date) then
511:
512: --
513: hr_utility.set_location(l_proc,62);
514: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);

Line 553: Elsif (p_ssl_start_date > nvl(l_parent_end_date,hr_api.g_eot)) or

549: close csr_chk_assignment_id_exists;
550: fnd_message.set_name('PER','PER_SSM_INVL_ASG_BG');
551: fnd_message.raise_error;
552: --
553: Elsif (p_ssl_start_date > nvl(l_parent_end_date,hr_api.g_eot)) or
554: (nvl(p_ssl_end_date,hr_api.g_eot)< l_parent_start_date) then
555:
556: --
557: hr_utility.set_location(l_proc,62);

Line 554: (nvl(p_ssl_end_date,hr_api.g_eot)< l_parent_start_date) then

550: fnd_message.set_name('PER','PER_SSM_INVL_ASG_BG');
551: fnd_message.raise_error;
552: --
553: Elsif (p_ssl_start_date > nvl(l_parent_end_date,hr_api.g_eot)) or
554: (nvl(p_ssl_end_date,hr_api.g_eot)< l_parent_start_date) then
555:
556: --
557: hr_utility.set_location(l_proc,62);
558: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);

Line 810: select g.business_group_id, g.date_from, nvl(g.date_to,hr_api.g_eot)

806: l_grade_date_to date;
807: l_bg number(15);
808: --
809: cursor csr_chk_grade_exists is
810: select g.business_group_id, g.date_from, nvl(g.date_to,hr_api.g_eot)
811: from per_grades g
812: where g.grade_id = p_grade_id;
813: --
814: cursor csr_get_bg is

Line 852: Elsif (p_ssl_start_date > nvl(l_grade_date_to,hr_api.g_eot)

848: close csr_chk_grade_exists;
849: --
850: fnd_message.set_name('PER','PER_52491_SSM_INVL_GRD_BG');
851: fnd_message.raise_error;
852: Elsif (p_ssl_start_date > nvl(l_grade_date_to,hr_api.g_eot)
853: or nvl(p_ssl_end_date,hr_api.g_eot) < l_grade_date_from) then
854:
855: close csr_chk_grade_exists;
856: --

Line 853: or nvl(p_ssl_end_date,hr_api.g_eot) < l_grade_date_from) then

849: --
850: fnd_message.set_name('PER','PER_52491_SSM_INVL_GRD_BG');
851: fnd_message.raise_error;
852: Elsif (p_ssl_start_date > nvl(l_grade_date_to,hr_api.g_eot)
853: or nvl(p_ssl_end_date,hr_api.g_eot) < l_grade_date_from) then
854:
855: close csr_chk_grade_exists;
856: --
857: fnd_message.set_name('PER','PER_52492_SSM_GRD_DATE_INVL');

Line 913: select o.business_group_id, o.date_from, nvl(o.date_to,hr_api.g_eot)

909: l_org_date_to date;
910: l_bg number;
911: --
912: cursor csr_chk_company_org is
913: select o.business_group_id, o.date_from, nvl(o.date_to,hr_api.g_eot)
914: from hr_all_organization_units o
915: where o.organization_id = p_company_organization_id;
916: --
917: cursor csr_get_bg is

Line 1088: hr_api.mandatory_arg_error

1084: --
1085: l_effective_date := p_effective_date;
1086: --
1087: If l_effective_date is not null then
1088: hr_api.mandatory_arg_error
1089: (p_api_name => l_proc
1090: ,p_argument => 'effective_date'
1091: ,p_argument_value => l_effective_date
1092: );

Line 1140: nvl(per_ssm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1136: Begin
1137: hr_utility.set_location('Entering:'||l_proc, 10);
1138: --
1139: If ((p_rec.salary_survey_mapping_id is not null) and (
1140: nvl(per_ssm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1141: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

1137: hr_utility.set_location('Entering:'||l_proc, 10);
1138: --
1139: If ((p_rec.salary_survey_mapping_id is not null) and (
1140: nvl(per_ssm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1138: --
1139: If ((p_rec.salary_survey_mapping_id is not null) and (
1140: nvl(per_ssm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or

1139: If ((p_rec.salary_survey_mapping_id is not null) and (
1140: nvl(per_ssm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1140: nvl(per_ssm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or

1141: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or

1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or

1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or

1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or

1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or

1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or

1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or

1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or

1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or

1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or

1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or

1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or

1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or

1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or

1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or

1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1179: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1179: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1180: nvl(per_ssm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or

1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1179: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1180: nvl(per_ssm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1181: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1179: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1180: nvl(per_ssm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1181: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1182: or

Line 1179: nvl(p_rec.attribute19, hr_api.g_varchar2) or

1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1179: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1180: nvl(per_ssm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1181: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1182: or
1183: (p_rec.salary_survey_mapping_id is null) Then

Line 1180: nvl(per_ssm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1179: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1180: nvl(per_ssm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1181: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1182: or
1183: (p_rec.salary_survey_mapping_id is null) Then
1184: --

Line 1181: nvl(p_rec.attribute20, hr_api.g_varchar2)))

1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1179: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1180: nvl(per_ssm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1181: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1182: or
1183: (p_rec.salary_survey_mapping_id is null) Then
1184: --
1185: -- Only execute the validation If absolutely necessary:

Line 1257: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1253: hr_utility.set_location('Entering:'||l_proc, 5);
1254: --
1255: -- Call all supporting business operations
1256: --
1257: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1258: --
1259: hr_utility.set_location(l_proc, 6);
1260: --
1261: chk_unique_key( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id

Line 1359: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1355: -- Check that non updateable arguments have not bee updated.
1356: --
1357: chk_non_updateable_args(p_rec);
1358: --
1359: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1360: --
1361: --
1362: hr_utility.set_location(l_proc, 6);
1363: --