APPS.PER_APR_BUS dependencies on HR_API

Line 46: hr_api.mandatory_arg_error(p_api_name => l_proc,

42: hr_utility.set_location('Entering:'|| l_proc, 10);
43:
44: -- Ensure that all the mandatory parameter are not null
45:
46: hr_api.mandatory_arg_error(p_api_name => l_proc,
47: p_argument => 'appraisal_id',
48: p_argument_value => p_appraisal_id);
49:
50: open csr_sec_grp;

Line 65: hr_api.set_security_group_id

61: close csr_sec_grp;
62: --
63: -- Set the security_group_id in CLIENT_INFO
64: --
65: hr_api.set_security_group_id
66: (p_security_group_id => l_security_group_id
67: );
68: end if;
69:

Line 100: hr_api.argument_changed_error

96:
97: hr_utility.set_location(l_proc, 6);
98:
99: if p_rec.business_group_id <> per_apr_shd.g_old_rec.business_group_id then
100: hr_api.argument_changed_error
101: (
102: p_api_name => l_proc
103: ,p_argument => 'BUSINESS_GROUP_ID'
104: ,p_base_table => per_per_shd.g_tab_nam

Line 108: hr_api.argument_changed_error

104: ,p_base_table => per_per_shd.g_tab_nam
105: );
106: elsif p_rec.appraisal_template_id <> per_apr_shd.g_old_rec.appraisal_template_id then
107: hr_utility.set_location(l_proc, 7);
108: hr_api.argument_changed_error
109: (
110: p_api_name => l_proc
111: ,p_argument => 'APPRAISAL_TEMPLATE_ID'
112: ,p_base_table => per_per_shd.g_tab_nam

Line 116: hr_api.argument_changed_error

112: ,p_base_table => per_per_shd.g_tab_nam
113: );
114: elsif p_rec.appraisee_person_id <> per_apr_shd.g_old_rec.appraisee_person_id then
115: hr_utility.set_location(l_proc, 8);
116: hr_api.argument_changed_error
117: (
118: p_api_name => l_proc
119: ,p_argument => 'APPRAISEE_ID'
120: ,p_base_table => per_per_shd.g_tab_nam

Line 124: hr_api.argument_changed_error

120: ,p_base_table => per_per_shd.g_tab_nam
121: );
122: elsif p_rec.assignment_id <> per_apr_shd.g_old_rec.assignment_id then
123: hr_utility.set_location(l_proc, 9);
124: hr_api.argument_changed_error
125: (
126: p_api_name => l_proc
127: ,p_argument => 'ASSIGNMENT_ID'
128: ,p_base_table => per_per_shd.g_tab_nam

Line 132: hr_api.argument_changed_error

128: ,p_base_table => per_per_shd.g_tab_nam
129: );
130: elsif p_rec.assignment_start_date <> per_apr_shd.g_old_rec.assignment_start_date then
131: hr_utility.set_location(l_proc, 10);
132: hr_api.argument_changed_error
133: (
134: p_api_name => l_proc
135: ,p_argument => 'ASSIGNMENT_START_DATE'
136: ,p_base_table => per_per_shd.g_tab_nam

Line 140: hr_api.argument_changed_error

136: ,p_base_table => per_per_shd.g_tab_nam
137: );
138: elsif p_rec.assignment_business_group_id <> per_apr_shd.g_old_rec.assignment_business_group_id then
139: hr_utility.set_location(l_proc, 11);
140: hr_api.argument_changed_error
141: (
142: p_api_name => l_proc
143: ,p_argument => 'ASSIGNMENT_BUSINESS_GROUP_ID'
144: ,p_base_table => per_per_shd.g_tab_nam

Line 148: hr_api.argument_changed_error

144: ,p_base_table => per_per_shd.g_tab_nam
145: );
146: elsif p_rec.assignment_organization_id <> per_apr_shd.g_old_rec.assignment_organization_id then
147: hr_utility.set_location(l_proc, 12);
148: hr_api.argument_changed_error
149: (
150: p_api_name => l_proc
151: ,p_argument => 'ASSIGNMENT_ORGANIZATION_ID'
152: ,p_base_table => per_per_shd.g_tab_nam

Line 156: hr_api.argument_changed_error

152: ,p_base_table => per_per_shd.g_tab_nam
153: );
154: elsif p_rec.assignment_job_id <> per_apr_shd.g_old_rec.assignment_job_id then
155: hr_utility.set_location(l_proc, 13);
156: hr_api.argument_changed_error
157: (
158: p_api_name => l_proc
159: ,p_argument => 'ASSIGNMENT_JOB_ID'
160: ,p_base_table => per_per_shd.g_tab_nam

Line 164: hr_api.argument_changed_error

160: ,p_base_table => per_per_shd.g_tab_nam
161: );
162: elsif p_rec.assignment_position_id <> per_apr_shd.g_old_rec.assignment_position_id then
163: hr_utility.set_location(l_proc, 14);
164: hr_api.argument_changed_error
165: (
166: p_api_name => l_proc
167: ,p_argument => 'ASSIGNMENT_POSITION_ID'
168: ,p_base_table => per_per_shd.g_tab_nam

Line 218: (hr_api.not_exists_in_hr_lookups

214:
215: hr_utility.set_location('Entering: '||l_proc,10);
216:
217: if (p_open <> null) and
218: (hr_api.not_exists_in_hr_lookups
219: (p_effective_date => p_effective_date
220: ,p_lookup_type => 'YES_NO'
221: ,p_lookup_code => p_open
222: )) then

Line 654: nvl(date_from,hr_api.g_sot) and nvl(date_to,hr_api.g_eot);

650: select 'Y'
651: from per_appraisal_templates
652: where appraisal_template_id = p_appraisal_template_id
653: and p_effective_date between
654: nvl(date_from,hr_api.g_sot) and nvl(date_to,hr_api.g_eot);
655:
656:
657: begin
658: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 662: hr_api.mandatory_arg_error

658: hr_utility.set_location('Entering:'|| l_proc, 1);
659:
660: -- Check mandatory parameters have been set
661:
662: hr_api.mandatory_arg_error
663: (p_api_name => l_proc
664: ,p_argument => 'business_group_id'
665: ,p_argument_value => p_business_group_id
666: );

Line 669: hr_api.mandatory_arg_error

665: ,p_argument_value => p_business_group_id
666: );
667:
668:
669: hr_api.mandatory_arg_error
670: (p_api_name => l_proc
671: ,p_argument => 'effective_date'
672: ,p_argument_value => p_effective_date
673: );

Line 804: effective_start_date and nvl(effective_end_date,hr_api.g_eot);

800: select 'Y'
801: from per_all_people_f
802: where person_id = p_person_id
803: and p_effective_date between
804: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
805:
806: -- bug 1980440 fix
807: -- WE NEED to use different cursors as Appraiser can be changed to
808: -- a person from a different BG

Line 818: effective_start_date and nvl(effective_end_date,hr_api.g_eot);

814: select 'Y'
815: from per_all_people_f
816: where person_id = p_person_id
817: and p_effective_date between
818: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
819:
820: begin
821: hr_utility.set_location('Entering:'|| l_proc, 1);
822:

Line 835: hr_api.mandatory_arg_error

831: end if;
832:
833: -- Check mandatory parameters have been set
834:
835: hr_api.mandatory_arg_error
836: (p_api_name => l_proc
837: ,p_argument => 'effective_date'
838: ,p_argument_value => p_effective_date
839: );

Line 959: effective_start_date and nvl(effective_end_date,hr_api.g_eot);

955: from per_all_people_f
956: where person_id = p_main_appraiser_id
957: and business_group_id = p_business_group_id
958: and p_effective_date between
959: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
960:
961: -- Cursor to check if person is valid
962: -- as of effective date
963:

Line 970: effective_start_date and nvl(effective_end_date,hr_api.g_eot);

966: select 'Y'
967: from per_all_people_f
968: where person_id = p_main_appraiser_id
969: and p_effective_date between
970: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
971:
972:
973: begin
974:

Line 985: hr_api.mandatory_arg_error

981: END IF;
982:
983: -- Check mandatory parameters have been set
984:
985: hr_api.mandatory_arg_error
986: (p_api_name => l_proc
987: ,p_argument => 'effective_date'
988: ,p_argument_value => p_effective_date
989: );

Line 1074: hr_api.mandatory_arg_error

1070: hr_utility.set_location('Entering:'|| l_proc, 1);
1071:
1072: -- Check mandatory parameters have been set
1073:
1074: hr_api.mandatory_arg_error
1075: (p_api_name => l_proc
1076: ,p_argument => 'effective_date'
1077: ,p_argument_value => p_effective_date
1078: );

Line 1089: hr_api.g_varchar2)

1085: (p_appraisal_id => p_appraisal_id
1086: ,p_object_version_number => p_object_version_number);
1087:
1088: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.type,
1089: hr_api.g_varchar2)
1090: <> nvl(p_type,hr_api.g_varchar2)
1091: ) or
1092: (NOT l_api_updating)
1093: ) then

Line 1090: <> nvl(p_type,hr_api.g_varchar2)

1086: ,p_object_version_number => p_object_version_number);
1087:
1088: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.type,
1089: hr_api.g_varchar2)
1090: <> nvl(p_type,hr_api.g_varchar2)
1091: ) or
1092: (NOT l_api_updating)
1093: ) then
1094:

Line 1104: if hr_api.not_exists_in_hr_lookups

1100: -- where the lookup_type = 'APPRAISAL_TYPE'
1101:
1102:
1103: if p_type is not null then
1104: if hr_api.not_exists_in_hr_lookups
1105: (p_effective_date => p_effective_date
1106: ,p_lookup_type => 'APPRAISAL_TYPE'
1107: ,p_lookup_code => p_type
1108: ) then

Line 1173: hr_api.mandatory_arg_error

1169: hr_utility.set_location('Entering:'|| l_proc, 1);
1170:
1171: -- Check mandatory parameters have been set
1172:
1173: hr_api.mandatory_arg_error
1174: (p_api_name => l_proc
1175: ,p_argument => 'effective_date'
1176: ,p_argument_value => p_effective_date
1177: );

Line 1188: hr_api.g_varchar2)

1184: (p_appraisal_id => p_appraisal_id
1185: ,p_object_version_number => p_object_version_number);
1186:
1187: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.status,
1188: hr_api.g_varchar2)
1189: <> nvl(p_status,hr_api.g_varchar2)
1190: ) or
1191: (NOT l_api_updating)
1192: ) then

Line 1189: <> nvl(p_status,hr_api.g_varchar2)

1185: ,p_object_version_number => p_object_version_number);
1186:
1187: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.status,
1188: hr_api.g_varchar2)
1189: <> nvl(p_status,hr_api.g_varchar2)
1190: ) or
1191: (NOT l_api_updating)
1192: ) then
1193:

Line 1203: if hr_api.not_exists_in_hr_lookups

1199: -- where the lookup_type = 'APPRAISAL_ASSESSMENT_STATUS'
1200:
1201:
1202: if p_status is not null then
1203: if hr_api.not_exists_in_hr_lookups
1204: (p_effective_date => p_effective_date
1205: ,p_lookup_type => 'APPRAISAL_ASSESSMENT_STATUS'
1206: ,p_lookup_code => p_status
1207: ) then

Line 1658: if ( nvl(p_next_appraisal_date,hr_api.g_eot ) < p_appraisal_date) then

1654: hr_utility.set_location(l_proc,60);
1655:
1656: -- Fix 3061901
1657:
1658: if ( nvl(p_next_appraisal_date,hr_api.g_eot ) < p_appraisal_date) then
1659: hr_utility.set_message(800, 'HR_449014_INV_NEXT_APPR_DATE');
1660: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.NEXT_APPRAISAL_DATE'
1661: ,p_associated_column2 => 'PER_APPRAISALS.APPRAISAL_DATE'
1662: );

Line 1745: hr_api.mandatory_arg_error

1741: hr_utility.set_location('Entering:'|| l_proc, 1);
1742:
1743: -- Check mandatory parameters have been set
1744:
1745: hr_api.mandatory_arg_error
1746: (p_api_name => l_proc
1747: ,p_argument => 'appraisal_template_id'
1748: ,p_argument_value => p_appraisal_template_id
1749: );

Line 1760: hr_api.g_number)

1756: (p_appraisal_id => p_appraisal_id
1757: ,p_object_version_number => p_object_version_number);
1758:
1759: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.overall_performance_level_id,
1760: hr_api.g_number)
1761: <> nvl(p_overall_performance_level_id,hr_api.g_number)
1762: ) or
1763: (NOT l_api_updating)
1764: ) then

Line 1761: <> nvl(p_overall_performance_level_id,hr_api.g_number)

1757: ,p_object_version_number => p_object_version_number);
1758:
1759: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.overall_performance_level_id,
1760: hr_api.g_number)
1761: <> nvl(p_overall_performance_level_id,hr_api.g_number)
1762: ) or
1763: (NOT l_api_updating)
1764: ) then
1765: -- Do the check

Line 1914: hr_api.mandatory_arg_error

1910: hr_utility.set_location('Entering:'|| l_proc, 1);
1911:
1912: -- Check mandatory parameters have been set
1913:
1914: hr_api.mandatory_arg_error
1915: (p_api_name => l_proc
1916: ,p_argument => 'appraisal_id'
1917: ,p_argument_value => p_appraisal_id
1918: );

Line 2052: AND nvl(per_apr_shd.g_old_rec.plan_id, hr_api.g_number)

2048: (p_appraisal_id => p_appraisal_id
2049: ,p_object_version_number => p_object_version_number);
2050: --
2051: IF (l_api_updating
2052: AND nvl(per_apr_shd.g_old_rec.plan_id, hr_api.g_number)
2053: = nvl(p_plan_id, hr_api.g_number))
2054: THEN
2055: RETURN;
2056: END IF;

Line 2053: = nvl(p_plan_id, hr_api.g_number))

2049: ,p_object_version_number => p_object_version_number);
2050: --
2051: IF (l_api_updating
2052: AND nvl(per_apr_shd.g_old_rec.plan_id, hr_api.g_number)
2053: = nvl(p_plan_id, hr_api.g_number))
2054: THEN
2055: RETURN;
2056: END IF;
2057:

Line 2141: AND nvl(per_apr_shd.g_old_rec.offline_status, hr_api.g_varchar2)

2137: (p_appraisal_id => p_appraisal_id
2138: ,p_object_version_number => p_object_version_number);
2139: --
2140: IF (l_api_updating
2141: AND nvl(per_apr_shd.g_old_rec.offline_status, hr_api.g_varchar2)
2142: = nvl(p_offline_status, hr_api.g_varchar2))
2143: THEN
2144: RETURN;
2145: END IF;

Line 2142: = nvl(p_offline_status, hr_api.g_varchar2))

2138: ,p_object_version_number => p_object_version_number);
2139: --
2140: IF (l_api_updating
2141: AND nvl(per_apr_shd.g_old_rec.offline_status, hr_api.g_varchar2)
2142: = nvl(p_offline_status, hr_api.g_varchar2))
2143: THEN
2144: RETURN;
2145: END IF;
2146:

Line 2152: IF hr_api.not_exists_in_hr_lookups(

2148: --
2149: -- Check that offline status is valid.
2150: --
2151: hr_utility.set_location(l_proc, 20);
2152: IF hr_api.not_exists_in_hr_lookups(
2153: p_effective_date => p_effective_date
2154: ,p_lookup_type => 'APPRAISAL_OFFLINE_STATUS'
2155: ,p_lookup_code => upper(p_offline_status)
2156: ) THEN

Line 2213: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

2209: begin
2210: hr_utility.set_location('Entering:'||l_proc, 10);
2211:
2212: if ((p_rec.appraisal_id is not null) and (
2213: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2214: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2215: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2216: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

2210: hr_utility.set_location('Entering:'||l_proc, 10);
2211:
2212: if ((p_rec.appraisal_id is not null) and (
2213: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2214: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2215: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2216: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 2215: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

2211:
2212: if ((p_rec.appraisal_id is not null) and (
2213: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2214: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2215: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2216: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

2212: if ((p_rec.appraisal_id is not null) and (
2213: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2214: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2215: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2216: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

2213: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2214: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2215: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2216: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

2214: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2215: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2216: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

2215: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2216: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

2216: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2252: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2252: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2253: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2252: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2253: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2254: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2252: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2253: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2254: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2255: or

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

2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2252: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2253: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2254: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2255: or
2256: (p_rec.appraisal_id is null) then

Line 2253: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2252: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2253: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2254: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2255: or
2256: (p_rec.appraisal_id is null) then
2257:

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

2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2252: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2253: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2254: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2255: or
2256: (p_rec.appraisal_id is null) then
2257:
2258: -- Only execute the validation if absolutely necessary:

Line 2328: hr_api.validate_bus_grp_id

2324: hr_utility.set_location('Entering:'||l_proc, 5);
2325:
2326: -- Call all supporting business operations
2327:
2328: hr_api.validate_bus_grp_id
2329: (p_business_group_id => p_rec.business_group_id
2330: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
2331: ); -- VALIDATE BUSINESS GROUP
2332:

Line 2472: hr_api.validate_bus_grp_id

2468: -- Call all supporting business operations
2469:
2470: -- Rule Check non-updateable fields cannot be updated
2471:
2472: hr_api.validate_bus_grp_id
2473: (p_business_group_id => p_rec.business_group_id
2474: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
2475: ); -- VALIDATE BUSINESS GROUP
2476:

Line 2650: hr_api.mandatory_arg_error (p_api_name => l_proc,

2646: hr_utility.set_location('Entering:'||l_proc, 5);
2647:
2648: -- Ensure that all the mandatory parameters are not null
2649:
2650: hr_api.mandatory_arg_error (p_api_name => l_proc,
2651: p_argument => 'appraisal_id',
2652: p_argument_value => p_appraisal_id );
2653:
2654: if nvl(g_appraisal_id, hr_api.g_number) = p_appraisal_id then

Line 2654: if nvl(g_appraisal_id, hr_api.g_number) = p_appraisal_id then

2650: hr_api.mandatory_arg_error (p_api_name => l_proc,
2651: p_argument => 'appraisal_id',
2652: p_argument_value => p_appraisal_id );
2653:
2654: if nvl(g_appraisal_id, hr_api.g_number) = p_appraisal_id then
2655:
2656: -- The legislation has already been found with a previous
2657: -- call to this function. Just return the value in the global
2658: -- variable.