eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_SSL_BUS dependencies on HR_API

Line 58: and nvl(p_salary_survey_line_id,hr_api.g_number)

54: --
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: --

Line 129: hr_api.mandatory_arg_error

125: hr_utility.set_location('Entering:'||l_proc,5);
126: --
127: -- Check mandatory parameters have been set
128: --
129: hr_api.mandatory_arg_error
130: (p_api_name => l_proc
131: ,p_argument => 'salary_survey_id'
132: ,p_argument_value => p_salary_survey_id
133: );

Line 229: and nvl(survey_region_code,hr_api.g_varchar2)

225: select null
226: from per_salary_survey_lines
227: where p_start_date = start_date
228: and survey_job_name_code = p_survey_job_name_code
229: and nvl(survey_region_code,hr_api.g_varchar2)
230: = nvl(p_survey_region_code,hr_api.g_varchar2)
231: and nvl(survey_seniority_code,hr_api.g_varchar2)
232: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
233: and nvl(company_size_code,hr_api.g_varchar2)

Line 230: = nvl(p_survey_region_code,hr_api.g_varchar2)

226: from per_salary_survey_lines
227: where p_start_date = start_date
228: and survey_job_name_code = p_survey_job_name_code
229: and nvl(survey_region_code,hr_api.g_varchar2)
230: = nvl(p_survey_region_code,hr_api.g_varchar2)
231: and nvl(survey_seniority_code,hr_api.g_varchar2)
232: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
233: and nvl(company_size_code,hr_api.g_varchar2)
234: = nvl(p_company_size_code,hr_api.g_varchar2)

Line 231: and nvl(survey_seniority_code,hr_api.g_varchar2)

227: where p_start_date = start_date
228: and survey_job_name_code = p_survey_job_name_code
229: and nvl(survey_region_code,hr_api.g_varchar2)
230: = nvl(p_survey_region_code,hr_api.g_varchar2)
231: and nvl(survey_seniority_code,hr_api.g_varchar2)
232: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
233: and nvl(company_size_code,hr_api.g_varchar2)
234: = nvl(p_company_size_code,hr_api.g_varchar2)
235: and nvl(industry_code,hr_api.g_varchar2)

Line 232: = nvl(p_survey_seniority_code,hr_api.g_varchar2)

228: and survey_job_name_code = p_survey_job_name_code
229: and nvl(survey_region_code,hr_api.g_varchar2)
230: = nvl(p_survey_region_code,hr_api.g_varchar2)
231: and nvl(survey_seniority_code,hr_api.g_varchar2)
232: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
233: and nvl(company_size_code,hr_api.g_varchar2)
234: = nvl(p_company_size_code,hr_api.g_varchar2)
235: and nvl(industry_code,hr_api.g_varchar2)
236: = nvl(p_industry_code,hr_api.g_varchar2)

Line 233: and nvl(company_size_code,hr_api.g_varchar2)

229: and nvl(survey_region_code,hr_api.g_varchar2)
230: = nvl(p_survey_region_code,hr_api.g_varchar2)
231: and nvl(survey_seniority_code,hr_api.g_varchar2)
232: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
233: and nvl(company_size_code,hr_api.g_varchar2)
234: = nvl(p_company_size_code,hr_api.g_varchar2)
235: and nvl(industry_code,hr_api.g_varchar2)
236: = nvl(p_industry_code,hr_api.g_varchar2)
237: and nvl(survey_age_code,hr_api.g_varchar2)

Line 234: = nvl(p_company_size_code,hr_api.g_varchar2)

230: = nvl(p_survey_region_code,hr_api.g_varchar2)
231: and nvl(survey_seniority_code,hr_api.g_varchar2)
232: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
233: and nvl(company_size_code,hr_api.g_varchar2)
234: = nvl(p_company_size_code,hr_api.g_varchar2)
235: and nvl(industry_code,hr_api.g_varchar2)
236: = nvl(p_industry_code,hr_api.g_varchar2)
237: and nvl(survey_age_code,hr_api.g_varchar2)
238: = nvl(p_survey_age_code,hr_api.g_varchar2) and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)

Line 235: and nvl(industry_code,hr_api.g_varchar2)

231: and nvl(survey_seniority_code,hr_api.g_varchar2)
232: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
233: and nvl(company_size_code,hr_api.g_varchar2)
234: = nvl(p_company_size_code,hr_api.g_varchar2)
235: and nvl(industry_code,hr_api.g_varchar2)
236: = nvl(p_industry_code,hr_api.g_varchar2)
237: and nvl(survey_age_code,hr_api.g_varchar2)
238: = nvl(p_survey_age_code,hr_api.g_varchar2) and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
239: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);

Line 236: = nvl(p_industry_code,hr_api.g_varchar2)

232: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
233: and nvl(company_size_code,hr_api.g_varchar2)
234: = nvl(p_company_size_code,hr_api.g_varchar2)
235: and nvl(industry_code,hr_api.g_varchar2)
236: = nvl(p_industry_code,hr_api.g_varchar2)
237: and nvl(survey_age_code,hr_api.g_varchar2)
238: = nvl(p_survey_age_code,hr_api.g_varchar2) and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
239: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
240: --

Line 237: and nvl(survey_age_code,hr_api.g_varchar2)

233: and nvl(company_size_code,hr_api.g_varchar2)
234: = nvl(p_company_size_code,hr_api.g_varchar2)
235: and nvl(industry_code,hr_api.g_varchar2)
236: = nvl(p_industry_code,hr_api.g_varchar2)
237: and nvl(survey_age_code,hr_api.g_varchar2)
238: = nvl(p_survey_age_code,hr_api.g_varchar2) and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
239: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
240: --
241: cursor csr_overlap_date is

Line 238: = nvl(p_survey_age_code,hr_api.g_varchar2) and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)

234: = nvl(p_company_size_code,hr_api.g_varchar2)
235: and nvl(industry_code,hr_api.g_varchar2)
236: = nvl(p_industry_code,hr_api.g_varchar2)
237: and nvl(survey_age_code,hr_api.g_varchar2)
238: = nvl(p_survey_age_code,hr_api.g_varchar2) and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
239: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
240: --
241: cursor csr_overlap_date is
242: select null

Line 239: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);

235: and nvl(industry_code,hr_api.g_varchar2)
236: = nvl(p_industry_code,hr_api.g_varchar2)
237: and nvl(survey_age_code,hr_api.g_varchar2)
238: = nvl(p_survey_age_code,hr_api.g_varchar2) and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
239: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
240: --
241: cursor csr_overlap_date is
242: select null
243: from per_salary_survey_lines

Line 247: and nvl(survey_region_code,hr_api.g_varchar2)

243: from per_salary_survey_lines
244: where p_start_date <= nvl(end_date,l_eot)
245: and nvl(p_end_date,l_eot) >= start_date
246: and survey_job_name_code = p_survey_job_name_code
247: and nvl(survey_region_code,hr_api.g_varchar2)
248: = nvl(p_survey_region_code,hr_api.g_varchar2)
249: and nvl(survey_seniority_code,hr_api.g_varchar2)
250: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
251: and nvl(company_size_code,hr_api.g_varchar2)

Line 248: = nvl(p_survey_region_code,hr_api.g_varchar2)

244: where p_start_date <= nvl(end_date,l_eot)
245: and nvl(p_end_date,l_eot) >= start_date
246: and survey_job_name_code = p_survey_job_name_code
247: and nvl(survey_region_code,hr_api.g_varchar2)
248: = nvl(p_survey_region_code,hr_api.g_varchar2)
249: and nvl(survey_seniority_code,hr_api.g_varchar2)
250: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
251: and nvl(company_size_code,hr_api.g_varchar2)
252: = nvl(p_company_size_code,hr_api.g_varchar2)

Line 249: and nvl(survey_seniority_code,hr_api.g_varchar2)

245: and nvl(p_end_date,l_eot) >= start_date
246: and survey_job_name_code = p_survey_job_name_code
247: and nvl(survey_region_code,hr_api.g_varchar2)
248: = nvl(p_survey_region_code,hr_api.g_varchar2)
249: and nvl(survey_seniority_code,hr_api.g_varchar2)
250: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
251: and nvl(company_size_code,hr_api.g_varchar2)
252: = nvl(p_company_size_code,hr_api.g_varchar2)
253: and nvl(industry_code,hr_api.g_varchar2)

Line 250: = nvl(p_survey_seniority_code,hr_api.g_varchar2)

246: and survey_job_name_code = p_survey_job_name_code
247: and nvl(survey_region_code,hr_api.g_varchar2)
248: = nvl(p_survey_region_code,hr_api.g_varchar2)
249: and nvl(survey_seniority_code,hr_api.g_varchar2)
250: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
251: and nvl(company_size_code,hr_api.g_varchar2)
252: = nvl(p_company_size_code,hr_api.g_varchar2)
253: and nvl(industry_code,hr_api.g_varchar2)
254: = nvl(p_industry_code,hr_api.g_varchar2)

Line 251: and nvl(company_size_code,hr_api.g_varchar2)

247: and nvl(survey_region_code,hr_api.g_varchar2)
248: = nvl(p_survey_region_code,hr_api.g_varchar2)
249: and nvl(survey_seniority_code,hr_api.g_varchar2)
250: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
251: and nvl(company_size_code,hr_api.g_varchar2)
252: = nvl(p_company_size_code,hr_api.g_varchar2)
253: and nvl(industry_code,hr_api.g_varchar2)
254: = nvl(p_industry_code,hr_api.g_varchar2)
255: and nvl(survey_age_code,hr_api.g_varchar2)

Line 252: = nvl(p_company_size_code,hr_api.g_varchar2)

248: = nvl(p_survey_region_code,hr_api.g_varchar2)
249: and nvl(survey_seniority_code,hr_api.g_varchar2)
250: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
251: and nvl(company_size_code,hr_api.g_varchar2)
252: = nvl(p_company_size_code,hr_api.g_varchar2)
253: and nvl(industry_code,hr_api.g_varchar2)
254: = nvl(p_industry_code,hr_api.g_varchar2)
255: and nvl(survey_age_code,hr_api.g_varchar2)
256: = nvl(p_survey_age_code,hr_api.g_varchar2)

Line 253: and nvl(industry_code,hr_api.g_varchar2)

249: and nvl(survey_seniority_code,hr_api.g_varchar2)
250: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
251: and nvl(company_size_code,hr_api.g_varchar2)
252: = nvl(p_company_size_code,hr_api.g_varchar2)
253: and nvl(industry_code,hr_api.g_varchar2)
254: = nvl(p_industry_code,hr_api.g_varchar2)
255: and nvl(survey_age_code,hr_api.g_varchar2)
256: = nvl(p_survey_age_code,hr_api.g_varchar2)
257: and end_date is not null

Line 254: = nvl(p_industry_code,hr_api.g_varchar2)

250: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
251: and nvl(company_size_code,hr_api.g_varchar2)
252: = nvl(p_company_size_code,hr_api.g_varchar2)
253: and nvl(industry_code,hr_api.g_varchar2)
254: = nvl(p_industry_code,hr_api.g_varchar2)
255: and nvl(survey_age_code,hr_api.g_varchar2)
256: = nvl(p_survey_age_code,hr_api.g_varchar2)
257: and end_date is not null
258: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)

Line 255: and nvl(survey_age_code,hr_api.g_varchar2)

251: and nvl(company_size_code,hr_api.g_varchar2)
252: = nvl(p_company_size_code,hr_api.g_varchar2)
253: and nvl(industry_code,hr_api.g_varchar2)
254: = nvl(p_industry_code,hr_api.g_varchar2)
255: and nvl(survey_age_code,hr_api.g_varchar2)
256: = nvl(p_survey_age_code,hr_api.g_varchar2)
257: and end_date is not null
258: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
259: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);

Line 256: = nvl(p_survey_age_code,hr_api.g_varchar2)

252: = nvl(p_company_size_code,hr_api.g_varchar2)
253: and nvl(industry_code,hr_api.g_varchar2)
254: = nvl(p_industry_code,hr_api.g_varchar2)
255: and nvl(survey_age_code,hr_api.g_varchar2)
256: = nvl(p_survey_age_code,hr_api.g_varchar2)
257: and end_date is not null
258: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
259: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
260: --

Line 258: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)

254: = nvl(p_industry_code,hr_api.g_varchar2)
255: and nvl(survey_age_code,hr_api.g_varchar2)
256: = nvl(p_survey_age_code,hr_api.g_varchar2)
257: and end_date is not null
258: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
259: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
260: --
261: cursor csr_invalid_end_date is
262: select null

Line 259: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);

255: and nvl(survey_age_code,hr_api.g_varchar2)
256: = nvl(p_survey_age_code,hr_api.g_varchar2)
257: and end_date is not null
258: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
259: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
260: --
261: cursor csr_invalid_end_date is
262: select null
263: from per_salary_survey_lines

Line 269: and nvl(survey_region_code,hr_api.g_varchar2)

265: and (nvl(p_end_date,l_eot) >= start_date and
266: nvl(p_end_date,l_eot) <= nvl(end_date,l_eot)
267: )
268: and survey_job_name_code = p_survey_job_name_code
269: and nvl(survey_region_code,hr_api.g_varchar2)
270: = nvl(p_survey_region_code,hr_api.g_varchar2)
271: and nvl(survey_seniority_code,hr_api.g_varchar2)
272: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
273: and nvl(company_size_code,hr_api.g_varchar2)

Line 270: = nvl(p_survey_region_code,hr_api.g_varchar2)

266: nvl(p_end_date,l_eot) <= nvl(end_date,l_eot)
267: )
268: and survey_job_name_code = p_survey_job_name_code
269: and nvl(survey_region_code,hr_api.g_varchar2)
270: = nvl(p_survey_region_code,hr_api.g_varchar2)
271: and nvl(survey_seniority_code,hr_api.g_varchar2)
272: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
273: and nvl(company_size_code,hr_api.g_varchar2)
274: = nvl(p_company_size_code,hr_api.g_varchar2)

Line 271: and nvl(survey_seniority_code,hr_api.g_varchar2)

267: )
268: and survey_job_name_code = p_survey_job_name_code
269: and nvl(survey_region_code,hr_api.g_varchar2)
270: = nvl(p_survey_region_code,hr_api.g_varchar2)
271: and nvl(survey_seniority_code,hr_api.g_varchar2)
272: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
273: and nvl(company_size_code,hr_api.g_varchar2)
274: = nvl(p_company_size_code,hr_api.g_varchar2)
275: and nvl(industry_code,hr_api.g_varchar2)

Line 272: = nvl(p_survey_seniority_code,hr_api.g_varchar2)

268: and survey_job_name_code = p_survey_job_name_code
269: and nvl(survey_region_code,hr_api.g_varchar2)
270: = nvl(p_survey_region_code,hr_api.g_varchar2)
271: and nvl(survey_seniority_code,hr_api.g_varchar2)
272: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
273: and nvl(company_size_code,hr_api.g_varchar2)
274: = nvl(p_company_size_code,hr_api.g_varchar2)
275: and nvl(industry_code,hr_api.g_varchar2)
276: = nvl(p_industry_code,hr_api.g_varchar2)

Line 273: and nvl(company_size_code,hr_api.g_varchar2)

269: and nvl(survey_region_code,hr_api.g_varchar2)
270: = nvl(p_survey_region_code,hr_api.g_varchar2)
271: and nvl(survey_seniority_code,hr_api.g_varchar2)
272: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
273: and nvl(company_size_code,hr_api.g_varchar2)
274: = nvl(p_company_size_code,hr_api.g_varchar2)
275: and nvl(industry_code,hr_api.g_varchar2)
276: = nvl(p_industry_code,hr_api.g_varchar2)
277: and nvl(survey_age_code,hr_api.g_varchar2)

Line 274: = nvl(p_company_size_code,hr_api.g_varchar2)

270: = nvl(p_survey_region_code,hr_api.g_varchar2)
271: and nvl(survey_seniority_code,hr_api.g_varchar2)
272: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
273: and nvl(company_size_code,hr_api.g_varchar2)
274: = nvl(p_company_size_code,hr_api.g_varchar2)
275: and nvl(industry_code,hr_api.g_varchar2)
276: = nvl(p_industry_code,hr_api.g_varchar2)
277: and nvl(survey_age_code,hr_api.g_varchar2)
278: = nvl(p_survey_age_code,hr_api.g_varchar2)

Line 275: and nvl(industry_code,hr_api.g_varchar2)

271: and nvl(survey_seniority_code,hr_api.g_varchar2)
272: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
273: and nvl(company_size_code,hr_api.g_varchar2)
274: = nvl(p_company_size_code,hr_api.g_varchar2)
275: and nvl(industry_code,hr_api.g_varchar2)
276: = nvl(p_industry_code,hr_api.g_varchar2)
277: and nvl(survey_age_code,hr_api.g_varchar2)
278: = nvl(p_survey_age_code,hr_api.g_varchar2)
279: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)

Line 276: = nvl(p_industry_code,hr_api.g_varchar2)

272: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
273: and nvl(company_size_code,hr_api.g_varchar2)
274: = nvl(p_company_size_code,hr_api.g_varchar2)
275: and nvl(industry_code,hr_api.g_varchar2)
276: = nvl(p_industry_code,hr_api.g_varchar2)
277: and nvl(survey_age_code,hr_api.g_varchar2)
278: = nvl(p_survey_age_code,hr_api.g_varchar2)
279: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
280: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);

Line 277: and nvl(survey_age_code,hr_api.g_varchar2)

273: and nvl(company_size_code,hr_api.g_varchar2)
274: = nvl(p_company_size_code,hr_api.g_varchar2)
275: and nvl(industry_code,hr_api.g_varchar2)
276: = nvl(p_industry_code,hr_api.g_varchar2)
277: and nvl(survey_age_code,hr_api.g_varchar2)
278: = nvl(p_survey_age_code,hr_api.g_varchar2)
279: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
280: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
281: --

Line 278: = nvl(p_survey_age_code,hr_api.g_varchar2)

274: = nvl(p_company_size_code,hr_api.g_varchar2)
275: and nvl(industry_code,hr_api.g_varchar2)
276: = nvl(p_industry_code,hr_api.g_varchar2)
277: and nvl(survey_age_code,hr_api.g_varchar2)
278: = nvl(p_survey_age_code,hr_api.g_varchar2)
279: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
280: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
281: --
282: Begin

Line 279: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)

275: and nvl(industry_code,hr_api.g_varchar2)
276: = nvl(p_industry_code,hr_api.g_varchar2)
277: and nvl(survey_age_code,hr_api.g_varchar2)
278: = nvl(p_survey_age_code,hr_api.g_varchar2)
279: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
280: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
281: --
282: Begin
283: --

Line 280: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);

276: = nvl(p_industry_code,hr_api.g_varchar2)
277: and nvl(survey_age_code,hr_api.g_varchar2)
278: = nvl(p_survey_age_code,hr_api.g_varchar2)
279: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
280: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
281: --
282: Begin
283: --
284: hr_utility.set_location('Entering:'||l_proc, 5);

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 309: <> nvl(p_survey_job_name_code,hr_api.g_varchar2))

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)
313: <> nvl(p_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 313: <> nvl(p_survey_region_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)
317: <> nvl(p_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 317: <> nvl(p_survey_seniority_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)
321: <> nvl(p_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 321: <> nvl(p_company_size_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)
325: <> nvl(p_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 325: <> nvl(p_industry_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)
329: <> nvl(p_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 329: <> nvl(p_survey_age_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
333: per_ssl_shd.g_old_rec.start_date <> p_start_date)

Line 484: hr_api.mandatory_arg_error

480: hr_utility.set_location('Entering:'|| l_proc, 10);
481: --
482: -- Check mandatory parameters have been set
483: --
484: hr_api.mandatory_arg_error
485: (p_api_name => l_proc
486: ,p_argument => 'effective date'
487: ,p_argument_value => p_effective_date
488: );

Line 521: If hr_api.not_exists_in_hr_lookups --fix for bug 7240498

517: --
518: -- Check If the survey_job_name_code value exists
519: -- in hr_standard_lookups where the lookup_type is 'SURVEY_JOB_NAME'
520: --
521: If hr_api.not_exists_in_hr_lookups --fix for bug 7240498
522: (p_effective_date => p_effective_date
523: ,p_lookup_type => 'SURVEY_JOB_NAME'
524: ,p_lookup_code => p_survey_job_name_code
525: ) Then

Line 633: hr_api.mandatory_arg_error

629: hr_utility.set_location('Entering:'|| l_proc, 10);
630: --
631: -- Check mandatory parameters have been set
632: --
633: hr_api.mandatory_arg_error
634: (p_api_name => l_proc
635: ,p_argument => 'effective date'
636: ,p_argument_value => p_effective_date
637: );

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 656: <> nvl(p_survey_region_code,hr_api.g_varchar2)))

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: --
660: hr_utility.set_location(l_proc, 20);

Line 665: If hr_api.not_exists_in_hrstanlookups

661: --
662: -- Check If the survey_region_code value exists
663: -- in hr_standard_lookups where the lookup_type is 'SURVEY_REGION'
664: --
665: If hr_api.not_exists_in_hrstanlookups
666: (p_effective_date => p_effective_date
667: ,p_lookup_type => 'SURVEY_REGION'
668: ,p_lookup_code => p_survey_region_code
669: ) Then

Line 779: hr_api.mandatory_arg_error

775: hr_utility.set_location('Entering:'|| l_proc, 10);
776: --
777: -- Check mandatory parameters have been set
778: --
779: hr_api.mandatory_arg_error
780: (p_api_name => l_proc
781: ,p_argument => 'effective date'
782: ,p_argument_value => p_effective_date
783: );

Line 801: hr_api.g_varchar2) <>

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
805: --

Line 802: nvl(p_survey_seniority_code,hr_api.g_varchar2)))

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
805: --
806: hr_utility.set_location(l_proc, 20);

Line 811: If hr_api.not_exists_in_hrstanlookups

807: --
808: -- Check If the survey_seniority_code value exists
809: -- in hr_standard_lookups where the lookup_type is 'SURVEY_SENIORITY'
810: --
811: If hr_api.not_exists_in_hrstanlookups
812: (p_effective_date => p_effective_date
813: ,p_lookup_type => 'SURVEY_SENIORITY'
814: ,p_lookup_code => p_survey_seniority_code
815: ) Then

Line 924: hr_api.mandatory_arg_error

920: hr_utility.set_location('Entering:'|| l_proc, 10);
921: --
922: -- Check mandatory parameters have been set
923: --
924: hr_api.mandatory_arg_error
925: (p_api_name => l_proc
926: ,p_argument => 'effective date'
927: ,p_argument_value => p_effective_date
928: );

Line 946: hr_api.g_varchar2) <>

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
950: --

Line 947: nvl(p_company_size_code,hr_api.g_varchar2)))

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
950: --
951: hr_utility.set_location(l_proc, 20);

Line 956: If hr_api.not_exists_in_hrstanlookups

952: --
953: -- Check If the company_size_code value exists
954: -- in hr_standard_lookups where the lookup_type is 'COMPANY_SIZE'
955: --
956: If hr_api.not_exists_in_hrstanlookups
957: (p_effective_date => p_effective_date
958: ,p_lookup_type => 'COMPANY_SIZE'
959: ,p_lookup_code => p_company_size_code
960: ) Then

Line 1070: hr_api.mandatory_arg_error

1066: hr_utility.set_location('Entering:'|| l_proc, 10);
1067: --
1068: -- Check mandatory parameters have been set
1069: --
1070: hr_api.mandatory_arg_error
1071: (p_api_name => l_proc
1072: ,p_argument => 'effective date'
1073: ,p_argument_value => p_effective_date
1074: );

Line 1093: hr_api.g_varchar2) <>

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
1097: --

Line 1094: nvl(p_industry_code,hr_api.g_varchar2)))

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
1097: --
1098: hr_utility.set_location(l_proc, 20);

Line 1103: If hr_api.not_exists_in_hrstanlookups

1099: --
1100: -- Check If the industry_code value exists
1101: -- in hr_standard_lookups where the lookup_type is 'INDUSTRY'
1102: --
1103: If hr_api.not_exists_in_hrstanlookups
1104: (p_effective_date => p_effective_date
1105: ,p_lookup_type => 'INDUSTRY'
1106: ,p_lookup_code => p_industry_code
1107: ) Then

Line 1219: hr_api.mandatory_arg_error

1215: hr_utility.set_location('Entering:'|| l_proc, 10);
1216: --
1217: -- Check mandatory parameters have been set
1218: --
1219: hr_api.mandatory_arg_error
1220: (p_api_name => l_proc
1221: ,p_argument => 'effective date'
1222: ,p_argument_value => p_effective_date
1223: );

Line 1242: hr_api.g_varchar2) <>

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
1246: --

Line 1243: nvl(p_survey_age_code,hr_api.g_varchar2)))

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
1246: --
1247: hr_utility.set_location(l_proc, 20);

Line 1252: If hr_api.not_exists_in_hrstanlookups

1248: --
1249: -- Check If the survey_age_code value exists
1250: -- in hr_standard_lookups where the lookup_type is 'SURVEY_AGE'
1251: --
1252: If hr_api.not_exists_in_hrstanlookups
1253: (p_effective_date => p_effective_date
1254: ,p_lookup_type => 'SURVEY_AGE'
1255: ,p_lookup_code => p_survey_age_code
1256: ) Then

Line 1354: hr_api.mandatory_arg_error

1350: hr_utility.set_location('Entering:'|| l_proc, 10);
1351: --
1352: -- Check mandatory parameters have been set
1353: --
1354: hr_api.mandatory_arg_error
1355: (p_api_name => l_proc
1356: ,p_argument => 'effective date'
1357: ,p_argument_value => p_effective_date
1358: );

Line 1387: If hr_api.not_exists_in_hrstanlookups

1383: --
1384: -- Check If the stock_display_type_code value exists
1385: -- in hr_standard_lookups where the lookup_type is 'STOCK_DISPLAY_TYPE'
1386: --
1387: If hr_api.not_exists_in_hrstanlookups
1388: (p_effective_date => p_effective_date
1389: ,p_lookup_type => 'STOCK_DISPLAY_TYPE'
1390: ,p_lookup_code => p_stock_display_type_code
1391: ) Then

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 1577: <> nvl(p_minimum_pay,hr_api.g_number)) or

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)
1581: <> nvl(p_mean_pay,hr_api.g_number)) or

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 1579: <> nvl(p_maximum_pay,hr_api.g_number)) or

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)
1583: <> nvl(p_graduate_pay,hr_api.g_number)) or

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 1581: <> nvl(p_mean_pay,hr_api.g_number)) or

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)
1585: <> nvl(p_starting_pay,hr_api.g_number)) or

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 1583: <> nvl(p_graduate_pay,hr_api.g_number)) or

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)
1587: <> nvl(p_percentage_change,hr_api.g_number)) or

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 1585: <> nvl(p_starting_pay,hr_api.g_number)) or

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)
1589: <> nvl(p_job_first_quartile,hr_api.g_number)) or

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 1587: <> nvl(p_percentage_change,hr_api.g_number)) or

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)
1591: <> nvl(p_job_median_quartile,hr_api.g_number)) or

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 1589: <> nvl(p_job_first_quartile,hr_api.g_number)) or

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)
1593: <> nvl(p_job_third_quartile,hr_api.g_number)) or

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 1591: <> nvl(p_job_median_quartile,hr_api.g_number)) or

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)
1595: <> nvl(p_job_fourth_quartile,hr_api.g_number)) or

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 1593: <> nvl(p_job_third_quartile,hr_api.g_number)) or

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)
1597: <> nvl(p_minimum_total_compensation,hr_api.g_number)) or

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 1595: <> nvl(p_job_fourth_quartile,hr_api.g_number)) or

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)
1599: <> nvl(p_mean_total_compensation,hr_api.g_number)) or

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 1597: <> nvl(p_minimum_total_compensation,hr_api.g_number)) or

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)
1601: <> nvl(p_maximum_total_compensation,hr_api.g_number)) or

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 1599: <> nvl(p_mean_total_compensation,hr_api.g_number)) or

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)
1603: <> nvl(p_compnstn_first_quartile,hr_api.g_number)) or

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 1601: <> nvl(p_maximum_total_compensation,hr_api.g_number)) or

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)
1605: <> nvl(p_compnstn_median_quartile,hr_api.g_number)) or

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 1603: <> nvl(p_compnstn_first_quartile,hr_api.g_number)) or

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)
1607: <> nvl(p_compnstn_third_quartile,hr_api.g_number)) or

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 1605: <> nvl(p_compnstn_median_quartile,hr_api.g_number)) or

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)
1609: <> nvl(p_compnstn_fourth_quartile,hr_api.g_number)) ) OR

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 1607: <> nvl(p_compnstn_third_quartile,hr_api.g_number)) or

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) )
1611: then

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 1609: <> nvl(p_compnstn_fourth_quartile,hr_api.g_number)) ) OR

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:
1613: --

Line 1929: hr_api.g_varchar2) <> nvl(p_currency_code,

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
1933: --

Line 1930: hr_api.g_varchar2))

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
1933: --
1934: hr_utility.set_location(l_proc, 20);

Line 2089: hr_api.argument_changed_error

2085: hr_utility.set_location(l_proc, 40);
2086: --
2087: exception
2088: when l_error then
2089: hr_api.argument_changed_error
2090: (p_api_name => l_proc
2091: ,p_argument => l_argument
2092: );
2093: when others then

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 2139: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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) <>
2143: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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 2141: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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) <>
2145: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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 2143: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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) <>
2147: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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 2145: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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) <>
2149: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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 2147: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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) <>
2151: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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 2149: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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) <>
2153: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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 2151: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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) <>
2155: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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 2153: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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) <>
2157: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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 2155: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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) <>
2159: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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 2157: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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) <>
2161: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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 2159: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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) <>
2163: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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 2161: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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) <>
2165: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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 2163: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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) <>
2167: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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 2165: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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) <>
2169: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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 2167: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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) <>
2171: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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 2169: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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) <>
2173: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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 2171: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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) <>
2175: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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 2173: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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) <>
2177: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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 2175: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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) <>
2179: nvl(p_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 2177: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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*/
2181: or

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 2179: nvl(p_rec.attribute20, 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) <>
2183: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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 2183: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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) <>
2187: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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 2185: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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) <>
2189: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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 2187: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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) <>
2191: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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 2189: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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) <>
2193: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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 2191: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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) <>
2195: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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 2193: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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) <>
2197: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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 2195: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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) <>
2199: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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 2197: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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) <>
2201: nvl(p_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 2199: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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 */
2203: or

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 2201: nvl(p_rec.attribute30, 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
2205: --