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.IRC_RSE_BUS dependencies on HR_API

Line 49: nvl(irc_rse_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

45: begin
46: hr_utility.set_location('Entering:'||l_proc,10);
47: --
48: if ((p_rec.recruiting_site_id is not null) and (
49: nvl(irc_rse_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(irc_rse_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(irc_rse_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

46: hr_utility.set_location('Entering:'||l_proc,10);
47: --
48: if ((p_rec.recruiting_site_id is not null) and (
49: nvl(irc_rse_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(irc_rse_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(irc_rse_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 51: nvl(irc_rse_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

47: --
48: if ((p_rec.recruiting_site_id is not null) and (
49: nvl(irc_rse_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(irc_rse_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(irc_rse_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(irc_rse_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

48: if ((p_rec.recruiting_site_id is not null) and (
49: nvl(irc_rse_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(irc_rse_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(irc_rse_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(irc_rse_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 53: nvl(irc_rse_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

49: nvl(irc_rse_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(irc_rse_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(irc_rse_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(irc_rse_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(irc_rse_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
51: nvl(irc_rse_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(irc_rse_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(irc_rse_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(irc_rse_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 55: nvl(irc_rse_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

51: nvl(irc_rse_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(irc_rse_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(irc_rse_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(irc_rse_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(irc_rse_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

52: nvl(p_rec.attribute1, hr_api.g_varchar2) or
53: nvl(irc_rse_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(irc_rse_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(irc_rse_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(irc_rse_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 57: nvl(irc_rse_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

53: nvl(irc_rse_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(irc_rse_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(irc_rse_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(irc_rse_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(irc_rse_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

54: nvl(p_rec.attribute2, hr_api.g_varchar2) or
55: nvl(irc_rse_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(irc_rse_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(irc_rse_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(irc_rse_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 59: nvl(irc_rse_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

55: nvl(irc_rse_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(irc_rse_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(irc_rse_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(irc_rse_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(irc_rse_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

56: nvl(p_rec.attribute3, hr_api.g_varchar2) or
57: nvl(irc_rse_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(irc_rse_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(irc_rse_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(irc_rse_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 61: nvl(irc_rse_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

57: nvl(irc_rse_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(irc_rse_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(irc_rse_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(irc_rse_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(irc_rse_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

58: nvl(p_rec.attribute4, hr_api.g_varchar2) or
59: nvl(irc_rse_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(irc_rse_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(irc_rse_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(irc_rse_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 63: nvl(irc_rse_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

59: nvl(irc_rse_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(irc_rse_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(irc_rse_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(irc_rse_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(irc_rse_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

60: nvl(p_rec.attribute5, hr_api.g_varchar2) or
61: nvl(irc_rse_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(irc_rse_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(irc_rse_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(irc_rse_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 65: nvl(irc_rse_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

61: nvl(irc_rse_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(irc_rse_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(irc_rse_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(irc_rse_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(irc_rse_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

62: nvl(p_rec.attribute6, hr_api.g_varchar2) or
63: nvl(irc_rse_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(irc_rse_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(irc_rse_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(irc_rse_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 67: nvl(irc_rse_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

63: nvl(irc_rse_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(irc_rse_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(irc_rse_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(irc_rse_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(irc_rse_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

64: nvl(p_rec.attribute7, hr_api.g_varchar2) or
65: nvl(irc_rse_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(irc_rse_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(irc_rse_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(irc_rse_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 69: nvl(irc_rse_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

65: nvl(irc_rse_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(irc_rse_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(irc_rse_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(irc_rse_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(irc_rse_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

66: nvl(p_rec.attribute8, hr_api.g_varchar2) or
67: nvl(irc_rse_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(irc_rse_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(irc_rse_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(irc_rse_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 71: nvl(irc_rse_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

67: nvl(irc_rse_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(irc_rse_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(irc_rse_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(irc_rse_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(irc_rse_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

68: nvl(p_rec.attribute9, hr_api.g_varchar2) or
69: nvl(irc_rse_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(irc_rse_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(irc_rse_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(irc_rse_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 73: nvl(irc_rse_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

69: nvl(irc_rse_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(irc_rse_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(irc_rse_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(irc_rse_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(irc_rse_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

70: nvl(p_rec.attribute10, hr_api.g_varchar2) or
71: nvl(irc_rse_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(irc_rse_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(irc_rse_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(irc_rse_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 75: nvl(irc_rse_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

71: nvl(irc_rse_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(irc_rse_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(irc_rse_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(irc_rse_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(irc_rse_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

72: nvl(p_rec.attribute11, hr_api.g_varchar2) or
73: nvl(irc_rse_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(irc_rse_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(irc_rse_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(irc_rse_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 77: nvl(irc_rse_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

73: nvl(irc_rse_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(irc_rse_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(irc_rse_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(irc_rse_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(irc_rse_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

74: nvl(p_rec.attribute12, hr_api.g_varchar2) or
75: nvl(irc_rse_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(irc_rse_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(irc_rse_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(irc_rse_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 79: nvl(irc_rse_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

75: nvl(irc_rse_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(irc_rse_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(irc_rse_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(irc_rse_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(irc_rse_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

76: nvl(p_rec.attribute13, hr_api.g_varchar2) or
77: nvl(irc_rse_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(irc_rse_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(irc_rse_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(irc_rse_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 81: nvl(irc_rse_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

77: nvl(irc_rse_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(irc_rse_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(irc_rse_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(irc_rse_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(irc_rse_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

78: nvl(p_rec.attribute14, hr_api.g_varchar2) or
79: nvl(irc_rse_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(irc_rse_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(irc_rse_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(irc_rse_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 83: nvl(irc_rse_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

79: nvl(irc_rse_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(irc_rse_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(irc_rse_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(irc_rse_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(irc_rse_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

80: nvl(p_rec.attribute15, hr_api.g_varchar2) or
81: nvl(irc_rse_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(irc_rse_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(irc_rse_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(irc_rse_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 85: nvl(irc_rse_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

81: nvl(irc_rse_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(irc_rse_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(irc_rse_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(irc_rse_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(irc_rse_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

82: nvl(p_rec.attribute16, hr_api.g_varchar2) or
83: nvl(irc_rse_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(irc_rse_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(irc_rse_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(irc_rse_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or

Line 87: nvl(irc_rse_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

83: nvl(irc_rse_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(irc_rse_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(irc_rse_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(irc_rse_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(irc_rse_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

84: nvl(p_rec.attribute17, hr_api.g_varchar2) or
85: nvl(irc_rse_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(irc_rse_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(irc_rse_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(irc_rse_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or

Line 89: nvl(irc_rse_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

85: nvl(irc_rse_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(irc_rse_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(irc_rse_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(irc_rse_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(irc_rse_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 90: nvl(p_rec.attribute20, hr_api.g_varchar2) or

86: nvl(p_rec.attribute18, hr_api.g_varchar2) or
87: nvl(irc_rse_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(irc_rse_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(irc_rse_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(irc_rse_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or

Line 91: nvl(irc_rse_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

87: nvl(irc_rse_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(irc_rse_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(irc_rse_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(irc_rse_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(irc_rse_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 92: nvl(p_rec.attribute21, hr_api.g_varchar2) or

88: nvl(p_rec.attribute19, hr_api.g_varchar2) or
89: nvl(irc_rse_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(irc_rse_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(irc_rse_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(irc_rse_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or

Line 93: nvl(irc_rse_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

89: nvl(irc_rse_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(irc_rse_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(irc_rse_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(irc_rse_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(irc_rse_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 94: nvl(p_rec.attribute22, hr_api.g_varchar2) or

90: nvl(p_rec.attribute20, hr_api.g_varchar2) or
91: nvl(irc_rse_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(irc_rse_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(irc_rse_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(irc_rse_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or

Line 95: nvl(irc_rse_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

91: nvl(irc_rse_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(irc_rse_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(irc_rse_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(irc_rse_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(irc_rse_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 96: nvl(p_rec.attribute23, hr_api.g_varchar2) or

92: nvl(p_rec.attribute21, hr_api.g_varchar2) or
93: nvl(irc_rse_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(irc_rse_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(irc_rse_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(irc_rse_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or

Line 97: nvl(irc_rse_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

93: nvl(irc_rse_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(irc_rse_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(irc_rse_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(irc_rse_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(irc_rse_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 98: nvl(p_rec.attribute24, hr_api.g_varchar2) or

94: nvl(p_rec.attribute22, hr_api.g_varchar2) or
95: nvl(irc_rse_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(irc_rse_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(irc_rse_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(irc_rse_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or

Line 99: nvl(irc_rse_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

95: nvl(irc_rse_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(irc_rse_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(irc_rse_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(irc_rse_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(irc_rse_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 100: nvl(p_rec.attribute25, hr_api.g_varchar2) or

96: nvl(p_rec.attribute23, hr_api.g_varchar2) or
97: nvl(irc_rse_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(irc_rse_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(irc_rse_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(irc_rse_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or

Line 101: nvl(irc_rse_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

97: nvl(irc_rse_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(irc_rse_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(irc_rse_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(irc_rse_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(irc_rse_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 102: nvl(p_rec.attribute26, hr_api.g_varchar2) or

98: nvl(p_rec.attribute24, hr_api.g_varchar2) or
99: nvl(irc_rse_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(irc_rse_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(irc_rse_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(irc_rse_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or

Line 103: nvl(irc_rse_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

99: nvl(irc_rse_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(irc_rse_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(irc_rse_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(irc_rse_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(irc_rse_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 104: nvl(p_rec.attribute27, hr_api.g_varchar2) or

100: nvl(p_rec.attribute25, hr_api.g_varchar2) or
101: nvl(irc_rse_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(irc_rse_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(irc_rse_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(irc_rse_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or

Line 105: nvl(irc_rse_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

101: nvl(irc_rse_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(irc_rse_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(irc_rse_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(irc_rse_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(irc_rse_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 106: nvl(p_rec.attribute28, hr_api.g_varchar2) or

102: nvl(p_rec.attribute26, hr_api.g_varchar2) or
103: nvl(irc_rse_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(irc_rse_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(irc_rse_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(irc_rse_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))

Line 107: nvl(irc_rse_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

103: nvl(irc_rse_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(irc_rse_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(irc_rse_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(irc_rse_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
111: or (p_rec.recruiting_site_id is null) then

Line 108: nvl(p_rec.attribute29, hr_api.g_varchar2) or

104: nvl(p_rec.attribute27, hr_api.g_varchar2) or
105: nvl(irc_rse_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(irc_rse_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(irc_rse_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
111: or (p_rec.recruiting_site_id is null) then
112: --

Line 109: nvl(irc_rse_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

105: nvl(irc_rse_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(irc_rse_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(irc_rse_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
111: or (p_rec.recruiting_site_id is null) then
112: --
113: hr_utility.set_location('Inside the ff stuff',20);

Line 110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))

106: nvl(p_rec.attribute28, hr_api.g_varchar2) or
107: nvl(irc_rse_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute29, hr_api.g_varchar2) or
109: nvl(irc_rse_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
111: or (p_rec.recruiting_site_id is null) then
112: --
113: hr_utility.set_location('Inside the ff stuff',20);
114: --

Line 285: NVL(irc_rse_shd.g_old_rec.internal,hr_api.g_varchar2)

281: --
282: hr_utility.set_location(l_proc,20);
283: if (l_api_updating and
284: p_internal <>
285: NVL(irc_rse_shd.g_old_rec.internal,hr_api.g_varchar2)
286: ) or (NOT l_api_updating) then
287: -- Check that internal has a valid value of either 'Y' or 'N'
288: hr_utility.set_location(l_proc,30);
289: if not p_internal in ('Y','N') then

Line 352: NVL(irc_rse_shd.g_old_rec.external,hr_api.g_varchar2)

348: --
349: hr_utility.set_location(l_proc,20);
350: if (l_api_updating and
351: p_external <>
352: NVL(irc_rse_shd.g_old_rec.external,hr_api.g_varchar2)
353: ) or (NOT l_api_updating) then
354: -- Check that external has a valid value of either 'Y' or 'N'
355: hr_utility.set_location(l_proc,30);
356: if not p_external in ('Y','N') then

Line 421: NVL(irc_rse_shd.g_old_rec.third_party,hr_api.g_varchar2)

417: --
418: hr_utility.set_location(l_proc,20);
419: if (l_api_updating and
420: p_third_party <>
421: NVL(irc_rse_shd.g_old_rec.third_party,hr_api.g_varchar2)
422: ) or (NOT l_api_updating) then
423: -- Check that third_party has a valid value of either 'Y' or 'N'
424: hr_utility.set_location(l_proc,30);
425: if not p_third_party in ('Y','N') then

Line 495: hr_api.mandatory_arg_error

491: hr_utility.set_location('Entering:'|| l_proc, 1);
492: --
493: -- Check mandatory parameters have been set
494: --
495: hr_api.mandatory_arg_error
496: (p_api_name => l_proc
497: ,p_argument => 'effective_date'
498: ,p_argument_value => p_effective_date
499: );

Line 512: hr_api.g_varchar2)

508: ,p_object_version_number => p_object_version_number
509: );
510: --
511: if ((l_api_updating and nvl(irc_rse_shd.g_old_rec.posting_cost_period,
512: hr_api.g_varchar2)
513: <> nvl(p_posting_cost_period, hr_api.g_varchar2)
514: or p_posting_cost_period is not null)
515: or
516: (NOT l_api_updating and

Line 513: <> nvl(p_posting_cost_period, hr_api.g_varchar2)

509: );
510: --
511: if ((l_api_updating and nvl(irc_rse_shd.g_old_rec.posting_cost_period,
512: hr_api.g_varchar2)
513: <> nvl(p_posting_cost_period, hr_api.g_varchar2)
514: or p_posting_cost_period is not null)
515: or
516: (NOT l_api_updating and
517: p_posting_cost_period is not null)) then

Line 523: if hr_api.not_exists_in_hr_lookups

519: hr_utility.set_location(l_proc, 2);
520: --
521: -- Check the value in p_posting_cost_period exists in hr_lookups
522: --
523: if hr_api.not_exists_in_hr_lookups
524: (p_effective_date => p_effective_date
525: ,p_lookup_type => 'IRC_POSTING_COST_FREQ'
526: ,p_lookup_code => p_posting_cost_period
527: ) then

Line 600: hr_api.mandatory_arg_error

596: hr_utility.set_location('Entering:'|| l_proc, 1);
597: --
598: -- Check mandatory parameters have been set
599: --
600: hr_api.mandatory_arg_error
601: (p_api_name => l_proc
602: ,p_argument => 'effective_date'
603: ,p_argument_value => p_effective_date
604: );

Line 619: hr_api.g_number)

615: );
616: --
617: hr_utility.set_location(l_proc, 3);
618: if ((l_api_updating and (nvl(irc_rse_shd.g_old_rec.posting_cost,
619: hr_api.g_number)
620: <> nvl(p_posting_cost , hr_api.g_number)
621: or nvl(irc_rse_shd.g_old_rec.posting_cost_period,
622: hr_api.g_varchar2)
623: <> nvl(p_posting_cost_period, hr_api.g_varchar2)

Line 620: <> nvl(p_posting_cost , hr_api.g_number)

616: --
617: hr_utility.set_location(l_proc, 3);
618: if ((l_api_updating and (nvl(irc_rse_shd.g_old_rec.posting_cost,
619: hr_api.g_number)
620: <> nvl(p_posting_cost , hr_api.g_number)
621: or nvl(irc_rse_shd.g_old_rec.posting_cost_period,
622: hr_api.g_varchar2)
623: <> nvl(p_posting_cost_period, hr_api.g_varchar2)
624: or nvl(irc_rse_shd.g_old_rec.posting_cost_currency,

Line 622: hr_api.g_varchar2)

618: if ((l_api_updating and (nvl(irc_rse_shd.g_old_rec.posting_cost,
619: hr_api.g_number)
620: <> nvl(p_posting_cost , hr_api.g_number)
621: or nvl(irc_rse_shd.g_old_rec.posting_cost_period,
622: hr_api.g_varchar2)
623: <> nvl(p_posting_cost_period, hr_api.g_varchar2)
624: or nvl(irc_rse_shd.g_old_rec.posting_cost_currency,
625: hr_api.g_varchar2)
626: <> nvl(p_posting_cost_currency, hr_api.g_varchar2)

Line 623: <> nvl(p_posting_cost_period, hr_api.g_varchar2)

619: hr_api.g_number)
620: <> nvl(p_posting_cost , hr_api.g_number)
621: or nvl(irc_rse_shd.g_old_rec.posting_cost_period,
622: hr_api.g_varchar2)
623: <> nvl(p_posting_cost_period, hr_api.g_varchar2)
624: or nvl(irc_rse_shd.g_old_rec.posting_cost_currency,
625: hr_api.g_varchar2)
626: <> nvl(p_posting_cost_currency, hr_api.g_varchar2)
627: )

Line 625: hr_api.g_varchar2)

621: or nvl(irc_rse_shd.g_old_rec.posting_cost_period,
622: hr_api.g_varchar2)
623: <> nvl(p_posting_cost_period, hr_api.g_varchar2)
624: or nvl(irc_rse_shd.g_old_rec.posting_cost_currency,
625: hr_api.g_varchar2)
626: <> nvl(p_posting_cost_currency, hr_api.g_varchar2)
627: )
628: )
629: or

Line 626: <> nvl(p_posting_cost_currency, hr_api.g_varchar2)

622: hr_api.g_varchar2)
623: <> nvl(p_posting_cost_period, hr_api.g_varchar2)
624: or nvl(irc_rse_shd.g_old_rec.posting_cost_currency,
625: hr_api.g_varchar2)
626: <> nvl(p_posting_cost_currency, hr_api.g_varchar2)
627: )
628: )
629: or
630: (NOT l_api_updating)) then

Line 636: if ((l_api_updating and p_posting_cost <> hr_api.g_number)

632: --
633: -- Now, we know we're either inserting or updating one of the three
634: -- values has changed.
635: --
636: if ((l_api_updating and p_posting_cost <> hr_api.g_number)
637: or p_posting_cost is null
638: or not l_api_updating) then
639: hr_utility.set_location(l_proc, 10);
640: l_posting_cost := p_posting_cost;

Line 646: if ((l_api_updating and p_posting_cost_period <> hr_api.g_varchar2)

642: hr_utility.set_location(l_proc, 20);
643: l_posting_cost := irc_rse_shd.g_old_rec.posting_cost;
644: end if;
645: --
646: if ((l_api_updating and p_posting_cost_period <> hr_api.g_varchar2)
647: or p_posting_cost_period is null
648: or not l_api_updating) then
649: hr_utility.set_location(l_proc, 30);
650: l_posting_cost_period := p_posting_cost_period;

Line 657: hr_utility.set_location('hr_api.g_varchar2:'||hr_api.g_varchar2, 10);

653: l_posting_cost_period := irc_rse_shd.g_old_rec.posting_cost_period;
654: end if;
655: --
656: hr_utility.set_location('posting_cost_currency:'||p_posting_cost_currency, 10);
657: hr_utility.set_location('hr_api.g_varchar2:'||hr_api.g_varchar2, 10);
658: if ((l_api_updating and p_posting_cost_currency <> hr_api.g_varchar2)
659: or p_posting_cost_currency is null
660: or not l_api_updating) then
661: hr_utility.set_location(l_proc, 50);

Line 658: if ((l_api_updating and p_posting_cost_currency <> hr_api.g_varchar2)

654: end if;
655: --
656: hr_utility.set_location('posting_cost_currency:'||p_posting_cost_currency, 10);
657: hr_utility.set_location('hr_api.g_varchar2:'||hr_api.g_varchar2, 10);
658: if ((l_api_updating and p_posting_cost_currency <> hr_api.g_varchar2)
659: or p_posting_cost_currency is null
660: or not l_api_updating) then
661: hr_utility.set_location(l_proc, 50);
662: l_posting_cost_currency := p_posting_cost_currency;

Line 752: hr_api.g_date)

748: ,p_object_version_number => p_object_version_number
749: );
750: --
751: if (((l_api_updating and nvl(irc_rse_shd.g_old_rec.date_from,
752: hr_api.g_date)
753: <> nvl(p_date_from, hr_api.g_date))
754: or
755: (l_api_updating and nvl(irc_rse_shd.g_old_rec.date_to,
756: hr_api.g_date)

Line 753: <> nvl(p_date_from, hr_api.g_date))

749: );
750: --
751: if (((l_api_updating and nvl(irc_rse_shd.g_old_rec.date_from,
752: hr_api.g_date)
753: <> nvl(p_date_from, hr_api.g_date))
754: or
755: (l_api_updating and nvl(irc_rse_shd.g_old_rec.date_to,
756: hr_api.g_date)
757: <> nvl(p_date_to, hr_api.g_date))

Line 756: hr_api.g_date)

752: hr_api.g_date)
753: <> nvl(p_date_from, hr_api.g_date))
754: or
755: (l_api_updating and nvl(irc_rse_shd.g_old_rec.date_to,
756: hr_api.g_date)
757: <> nvl(p_date_to, hr_api.g_date))
758: )
759: or
760: (NOT l_api_updating)) then

Line 757: <> nvl(p_date_to, hr_api.g_date))

753: <> nvl(p_date_from, hr_api.g_date))
754: or
755: (l_api_updating and nvl(irc_rse_shd.g_old_rec.date_to,
756: hr_api.g_date)
757: <> nvl(p_date_to, hr_api.g_date))
758: )
759: or
760: (NOT l_api_updating)) then
761: --