APPS.HR_MASS_MOVE_API dependencies on HR_SCL_SHD

Line 367: l_scl_api_updating := hr_scl_shd.api_updating

363: --
364: if per_asg_shd.g_old_rec.soft_coding_keyflex_id is not null then
365: hr_utility.set_location( l_proc, 55 );
366: --
367: l_scl_api_updating := hr_scl_shd.api_updating
368: (p_soft_coding_keyflex_id =>
369: per_asg_shd.g_old_rec.soft_coding_keyflex_id);
370: --
371: -- Check whether any of the SCL segments are being updated.

Line 374: and nvl(hr_scl_shd.g_old_rec.segment1, hr_api.g_varchar2) <>

370: --
371: -- Check whether any of the SCL segments are being updated.
372: --
373: if ( ( (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2)
374: and nvl(hr_scl_shd.g_old_rec.segment1, hr_api.g_varchar2) <>
375: nvl(p_segment1, hr_api.g_varchar2) )
376: or ( (nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2)
377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>
378: nvl(p_segment2, hr_api.g_varchar2) )

Line 377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>

373: if ( ( (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2)
374: and nvl(hr_scl_shd.g_old_rec.segment1, hr_api.g_varchar2) <>
375: nvl(p_segment1, hr_api.g_varchar2) )
376: or ( (nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2)
377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>
378: nvl(p_segment2, hr_api.g_varchar2) )
379: or ( (nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2)
380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>
381: nvl(p_segment3, hr_api.g_varchar2) )

Line 380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>

376: or ( (nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2)
377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>
378: nvl(p_segment2, hr_api.g_varchar2) )
379: or ( (nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2)
380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>
381: nvl(p_segment3, hr_api.g_varchar2) )
382: or ( (nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2)
383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>
384: nvl(p_segment4, hr_api.g_varchar2) )

Line 383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>

379: or ( (nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2)
380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>
381: nvl(p_segment3, hr_api.g_varchar2) )
382: or ( (nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2)
383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>
384: nvl(p_segment4, hr_api.g_varchar2) )
385: or ( (nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2)
386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>
387: nvl(p_segment5, hr_api.g_varchar2) )

Line 386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>

382: or ( (nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2)
383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>
384: nvl(p_segment4, hr_api.g_varchar2) )
385: or ( (nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2)
386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>
387: nvl(p_segment5, hr_api.g_varchar2) )
388: or ( (nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2)
389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>
390: nvl(p_segment6, hr_api.g_varchar2) )

Line 389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>

385: or ( (nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2)
386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>
387: nvl(p_segment5, hr_api.g_varchar2) )
388: or ( (nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2)
389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>
390: nvl(p_segment6, hr_api.g_varchar2) )
391: or ( (nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2)
392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>
393: nvl(p_segment7, hr_api.g_varchar2) )

Line 392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>

388: or ( (nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2)
389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>
390: nvl(p_segment6, hr_api.g_varchar2) )
391: or ( (nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2)
392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>
393: nvl(p_segment7, hr_api.g_varchar2) )
394: or ( (nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2)
395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>
396: nvl(p_segment8, hr_api.g_varchar2) )

Line 395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>

391: or ( (nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2)
392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>
393: nvl(p_segment7, hr_api.g_varchar2) )
394: or ( (nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2)
395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>
396: nvl(p_segment8, hr_api.g_varchar2) )
397: or ( (nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2)
398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>
399: nvl(p_segment9, hr_api.g_varchar2) )

Line 398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>

394: or ( (nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2)
395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>
396: nvl(p_segment8, hr_api.g_varchar2) )
397: or ( (nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2)
398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>
399: nvl(p_segment9, hr_api.g_varchar2) )
400: or ( (nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2)
401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>
402: nvl(p_segment10, hr_api.g_varchar2) )

Line 401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>

397: or ( (nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2)
398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>
399: nvl(p_segment9, hr_api.g_varchar2) )
400: or ( (nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2)
401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>
402: nvl(p_segment10, hr_api.g_varchar2) )
403: or ( (nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2)
404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>
405: nvl(p_segment11, hr_api.g_varchar2) )

Line 404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>

400: or ( (nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2)
401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>
402: nvl(p_segment10, hr_api.g_varchar2) )
403: or ( (nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2)
404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>
405: nvl(p_segment11, hr_api.g_varchar2) )
406: or ( (nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2)
407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>
408: nvl(p_segment12, hr_api.g_varchar2) )

Line 407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>

403: or ( (nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2)
404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>
405: nvl(p_segment11, hr_api.g_varchar2) )
406: or ( (nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2)
407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>
408: nvl(p_segment12, hr_api.g_varchar2) )
409: or ( (nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2)
410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>
411: nvl(p_segment13, hr_api.g_varchar2) )

Line 410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>

406: or ( (nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2)
407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>
408: nvl(p_segment12, hr_api.g_varchar2) )
409: or ( (nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2)
410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>
411: nvl(p_segment13, hr_api.g_varchar2) )
412: or ( (nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2)
413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>
414: nvl(p_segment14, hr_api.g_varchar2) )

Line 413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>

409: or ( (nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2)
410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>
411: nvl(p_segment13, hr_api.g_varchar2) )
412: or ( (nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2)
413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>
414: nvl(p_segment14, hr_api.g_varchar2) )
415: or ( (nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2)
416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>
417: nvl(p_segment15, hr_api.g_varchar2) )

Line 416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>

412: or ( (nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2)
413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>
414: nvl(p_segment14, hr_api.g_varchar2) )
415: or ( (nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2)
416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>
417: nvl(p_segment15, hr_api.g_varchar2) )
418: or ( (nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2)
419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>
420: nvl(p_segment16, hr_api.g_varchar2) )

Line 419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>

415: or ( (nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2)
416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>
417: nvl(p_segment15, hr_api.g_varchar2) )
418: or ( (nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2)
419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>
420: nvl(p_segment16, hr_api.g_varchar2) )
421: or ( (nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2)
422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>
423: nvl(p_segment17, hr_api.g_varchar2) )

Line 422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>

418: or ( (nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2)
419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>
420: nvl(p_segment16, hr_api.g_varchar2) )
421: or ( (nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2)
422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>
423: nvl(p_segment17, hr_api.g_varchar2) )
424: or ( (nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2)
425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>
426: nvl(p_segment18, hr_api.g_varchar2) )

Line 425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>

421: or ( (nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2)
422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>
423: nvl(p_segment17, hr_api.g_varchar2) )
424: or ( (nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2)
425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>
426: nvl(p_segment18, hr_api.g_varchar2) )
427: or ( (nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2)
428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>
429: nvl(p_segment19, hr_api.g_varchar2) )

Line 428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>

424: or ( (nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2)
425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>
426: nvl(p_segment18, hr_api.g_varchar2) )
427: or ( (nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2)
428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>
429: nvl(p_segment19, hr_api.g_varchar2) )
430: or ( (nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2)
431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>
432: nvl(p_segment20, hr_api.g_varchar2) )

Line 431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>

427: or ( (nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2)
428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>
429: nvl(p_segment19, hr_api.g_varchar2) )
430: or ( (nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2)
431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>
432: nvl(p_segment20, hr_api.g_varchar2) )
433: or ( (nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2)
434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>
435: nvl(p_segment21, hr_api.g_varchar2) )

Line 434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>

430: or ( (nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2)
431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>
432: nvl(p_segment20, hr_api.g_varchar2) )
433: or ( (nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2)
434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>
435: nvl(p_segment21, hr_api.g_varchar2) )
436: or ( (nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2)
437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>
438: nvl(p_segment22, hr_api.g_varchar2) )

Line 437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>

433: or ( (nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2)
434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>
435: nvl(p_segment21, hr_api.g_varchar2) )
436: or ( (nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2)
437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>
438: nvl(p_segment22, hr_api.g_varchar2) )
439: or ( (nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2)
440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>
441: nvl(p_segment23, hr_api.g_varchar2) )

Line 440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>

436: or ( (nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2)
437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>
438: nvl(p_segment22, hr_api.g_varchar2) )
439: or ( (nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2)
440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>
441: nvl(p_segment23, hr_api.g_varchar2) )
442: or ( (nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2)
443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>
444: nvl(p_segment24, hr_api.g_varchar2) )

Line 443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>

439: or ( (nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2)
440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>
441: nvl(p_segment23, hr_api.g_varchar2) )
442: or ( (nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2)
443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>
444: nvl(p_segment24, hr_api.g_varchar2) )
445: or ( (nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2)
446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>
447: nvl(p_segment25, hr_api.g_varchar2) )

Line 446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>

442: or ( (nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2)
443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>
444: nvl(p_segment24, hr_api.g_varchar2) )
445: or ( (nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2)
446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>
447: nvl(p_segment25, hr_api.g_varchar2) )
448: or ( (nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2)
449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>
450: nvl(p_segment26, hr_api.g_varchar2) )

Line 449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>

445: or ( (nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2)
446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>
447: nvl(p_segment25, hr_api.g_varchar2) )
448: or ( (nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2)
449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>
450: nvl(p_segment26, hr_api.g_varchar2) )
451: or ( (nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2)
452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>
453: nvl(p_segment27, hr_api.g_varchar2) )

Line 452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>

448: or ( (nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2)
449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>
450: nvl(p_segment26, hr_api.g_varchar2) )
451: or ( (nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2)
452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>
453: nvl(p_segment27, hr_api.g_varchar2) )
454: or ( (nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2)
455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>
456: nvl(p_segment28, hr_api.g_varchar2) )

Line 455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>

451: or ( (nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2)
452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>
453: nvl(p_segment27, hr_api.g_varchar2) )
454: or ( (nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2)
455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>
456: nvl(p_segment28, hr_api.g_varchar2) )
457: or ( (nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2)
458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>
459: nvl(p_segment29, hr_api.g_varchar2) )

Line 458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>

454: or ( (nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2)
455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>
456: nvl(p_segment28, hr_api.g_varchar2) )
457: or ( (nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2)
458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>
459: nvl(p_segment29, hr_api.g_varchar2) )
460: or ( (nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2)
461: and nvl(hr_scl_shd.g_old_rec.segment30, hr_api.g_varchar2) <>
462: nvl(p_segment30, hr_api.g_varchar2) )

Line 461: and nvl(hr_scl_shd.g_old_rec.segment30, hr_api.g_varchar2) <>

457: or ( (nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2)
458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>
459: nvl(p_segment29, hr_api.g_varchar2) )
460: or ( (nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2)
461: and nvl(hr_scl_shd.g_old_rec.segment30, hr_api.g_varchar2) <>
462: nvl(p_segment30, hr_api.g_varchar2) )
463: ) then
464: --
465: hr_utility.set_location( l_proc, 60 );