APPS.IRC_INP_BUS dependencies on HR_API

Line 55: nvl(irc_inp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

51: begin
52: hr_utility.set_location('Entering:'||l_proc,10);
53: --
54: if ((p_rec.notification_preference_id is not null) and (
55: nvl(irc_inp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
57: nvl(irc_inp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute1, hr_api.g_varchar2) or
59: nvl(irc_inp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

52: hr_utility.set_location('Entering:'||l_proc,10);
53: --
54: if ((p_rec.notification_preference_id is not null) and (
55: nvl(irc_inp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
57: nvl(irc_inp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute1, hr_api.g_varchar2) or
59: nvl(irc_inp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 57: nvl(irc_inp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

53: --
54: if ((p_rec.notification_preference_id is not null) and (
55: nvl(irc_inp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
57: nvl(irc_inp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute1, hr_api.g_varchar2) or
59: nvl(irc_inp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or
61: nvl(irc_inp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

54: if ((p_rec.notification_preference_id is not null) and (
55: nvl(irc_inp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
57: nvl(irc_inp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute1, hr_api.g_varchar2) or
59: nvl(irc_inp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or
61: nvl(irc_inp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 59: nvl(irc_inp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

55: nvl(irc_inp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
57: nvl(irc_inp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute1, hr_api.g_varchar2) or
59: nvl(irc_inp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or
61: nvl(irc_inp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or
63: nvl(irc_inp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

56: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
57: nvl(irc_inp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute1, hr_api.g_varchar2) or
59: nvl(irc_inp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or
61: nvl(irc_inp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or
63: nvl(irc_inp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 61: nvl(irc_inp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

57: nvl(irc_inp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute1, hr_api.g_varchar2) or
59: nvl(irc_inp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or
61: nvl(irc_inp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or
63: nvl(irc_inp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or
65: nvl(irc_inp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

58: nvl(p_rec.attribute1, hr_api.g_varchar2) or
59: nvl(irc_inp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or
61: nvl(irc_inp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or
63: nvl(irc_inp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or
65: nvl(irc_inp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 63: nvl(irc_inp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

59: nvl(irc_inp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute2, hr_api.g_varchar2) or
61: nvl(irc_inp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or
63: nvl(irc_inp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or
65: nvl(irc_inp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or
67: nvl(irc_inp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

60: nvl(p_rec.attribute2, hr_api.g_varchar2) or
61: nvl(irc_inp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or
63: nvl(irc_inp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or
65: nvl(irc_inp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or
67: nvl(irc_inp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 65: nvl(irc_inp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

61: nvl(irc_inp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute3, hr_api.g_varchar2) or
63: nvl(irc_inp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or
65: nvl(irc_inp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or
67: nvl(irc_inp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or
69: nvl(irc_inp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

62: nvl(p_rec.attribute3, hr_api.g_varchar2) or
63: nvl(irc_inp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or
65: nvl(irc_inp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or
67: nvl(irc_inp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or
69: nvl(irc_inp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 67: nvl(irc_inp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

63: nvl(irc_inp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute4, hr_api.g_varchar2) or
65: nvl(irc_inp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or
67: nvl(irc_inp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or
69: nvl(irc_inp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or
71: nvl(irc_inp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

64: nvl(p_rec.attribute4, hr_api.g_varchar2) or
65: nvl(irc_inp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or
67: nvl(irc_inp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or
69: nvl(irc_inp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or
71: nvl(irc_inp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 69: nvl(irc_inp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

65: nvl(irc_inp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute5, hr_api.g_varchar2) or
67: nvl(irc_inp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or
69: nvl(irc_inp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or
71: nvl(irc_inp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or
73: nvl(irc_inp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

66: nvl(p_rec.attribute5, hr_api.g_varchar2) or
67: nvl(irc_inp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or
69: nvl(irc_inp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or
71: nvl(irc_inp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or
73: nvl(irc_inp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 71: nvl(irc_inp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

67: nvl(irc_inp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute6, hr_api.g_varchar2) or
69: nvl(irc_inp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or
71: nvl(irc_inp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or
73: nvl(irc_inp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or
75: nvl(irc_inp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

68: nvl(p_rec.attribute6, hr_api.g_varchar2) or
69: nvl(irc_inp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or
71: nvl(irc_inp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or
73: nvl(irc_inp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or
75: nvl(irc_inp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 73: nvl(irc_inp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

69: nvl(irc_inp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute7, hr_api.g_varchar2) or
71: nvl(irc_inp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or
73: nvl(irc_inp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or
75: nvl(irc_inp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or
77: nvl(irc_inp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

70: nvl(p_rec.attribute7, hr_api.g_varchar2) or
71: nvl(irc_inp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or
73: nvl(irc_inp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or
75: nvl(irc_inp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or
77: nvl(irc_inp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 75: nvl(irc_inp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

71: nvl(irc_inp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute8, hr_api.g_varchar2) or
73: nvl(irc_inp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or
75: nvl(irc_inp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or
77: nvl(irc_inp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or
79: nvl(irc_inp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

72: nvl(p_rec.attribute8, hr_api.g_varchar2) or
73: nvl(irc_inp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or
75: nvl(irc_inp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or
77: nvl(irc_inp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or
79: nvl(irc_inp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 77: nvl(irc_inp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

73: nvl(irc_inp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute9, hr_api.g_varchar2) or
75: nvl(irc_inp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or
77: nvl(irc_inp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or
79: nvl(irc_inp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or
81: nvl(irc_inp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

74: nvl(p_rec.attribute9, hr_api.g_varchar2) or
75: nvl(irc_inp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or
77: nvl(irc_inp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or
79: nvl(irc_inp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or
81: nvl(irc_inp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 79: nvl(irc_inp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

75: nvl(irc_inp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute10, hr_api.g_varchar2) or
77: nvl(irc_inp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or
79: nvl(irc_inp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or
81: nvl(irc_inp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or
83: nvl(irc_inp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

76: nvl(p_rec.attribute10, hr_api.g_varchar2) or
77: nvl(irc_inp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or
79: nvl(irc_inp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or
81: nvl(irc_inp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or
83: nvl(irc_inp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 81: nvl(irc_inp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

77: nvl(irc_inp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute11, hr_api.g_varchar2) or
79: nvl(irc_inp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or
81: nvl(irc_inp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or
83: nvl(irc_inp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or
85: nvl(irc_inp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

78: nvl(p_rec.attribute11, hr_api.g_varchar2) or
79: nvl(irc_inp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or
81: nvl(irc_inp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or
83: nvl(irc_inp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or
85: nvl(irc_inp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 83: nvl(irc_inp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

79: nvl(irc_inp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute12, hr_api.g_varchar2) or
81: nvl(irc_inp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or
83: nvl(irc_inp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or
85: nvl(irc_inp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or
87: nvl(irc_inp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

80: nvl(p_rec.attribute12, hr_api.g_varchar2) or
81: nvl(irc_inp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or
83: nvl(irc_inp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or
85: nvl(irc_inp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or
87: nvl(irc_inp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 85: nvl(irc_inp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

81: nvl(irc_inp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
82: nvl(p_rec.attribute13, hr_api.g_varchar2) or
83: nvl(irc_inp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or
85: nvl(irc_inp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or
87: nvl(irc_inp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or
89: nvl(irc_inp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

82: nvl(p_rec.attribute13, hr_api.g_varchar2) or
83: nvl(irc_inp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or
85: nvl(irc_inp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or
87: nvl(irc_inp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or
89: nvl(irc_inp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 87: nvl(irc_inp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

83: nvl(irc_inp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
84: nvl(p_rec.attribute14, hr_api.g_varchar2) or
85: nvl(irc_inp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or
87: nvl(irc_inp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or
89: nvl(irc_inp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or
91: nvl(irc_inp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

84: nvl(p_rec.attribute14, hr_api.g_varchar2) or
85: nvl(irc_inp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or
87: nvl(irc_inp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or
89: nvl(irc_inp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or
91: nvl(irc_inp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 89: nvl(irc_inp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

85: nvl(irc_inp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
86: nvl(p_rec.attribute15, hr_api.g_varchar2) or
87: nvl(irc_inp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or
89: nvl(irc_inp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or
91: nvl(irc_inp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or
93: nvl(irc_inp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

86: nvl(p_rec.attribute15, hr_api.g_varchar2) or
87: nvl(irc_inp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or
89: nvl(irc_inp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or
91: nvl(irc_inp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or
93: nvl(irc_inp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 91: nvl(irc_inp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

87: nvl(irc_inp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
88: nvl(p_rec.attribute16, hr_api.g_varchar2) or
89: nvl(irc_inp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or
91: nvl(irc_inp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or
93: nvl(irc_inp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or
95: nvl(irc_inp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

88: nvl(p_rec.attribute16, hr_api.g_varchar2) or
89: nvl(irc_inp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or
91: nvl(irc_inp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or
93: nvl(irc_inp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or
95: nvl(irc_inp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or

Line 93: nvl(irc_inp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

89: nvl(irc_inp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
90: nvl(p_rec.attribute17, hr_api.g_varchar2) or
91: nvl(irc_inp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or
93: nvl(irc_inp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or
95: nvl(irc_inp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or
97: nvl(irc_inp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

90: nvl(p_rec.attribute17, hr_api.g_varchar2) or
91: nvl(irc_inp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or
93: nvl(irc_inp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or
95: nvl(irc_inp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or
97: nvl(irc_inp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or

Line 95: nvl(irc_inp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

91: nvl(irc_inp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
92: nvl(p_rec.attribute18, hr_api.g_varchar2) or
93: nvl(irc_inp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or
95: nvl(irc_inp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or
97: nvl(irc_inp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or
99: nvl(irc_inp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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

92: nvl(p_rec.attribute18, hr_api.g_varchar2) or
93: nvl(irc_inp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or
95: nvl(irc_inp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or
97: nvl(irc_inp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or
99: nvl(irc_inp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or

Line 97: nvl(irc_inp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

93: nvl(irc_inp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
94: nvl(p_rec.attribute19, hr_api.g_varchar2) or
95: nvl(irc_inp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or
97: nvl(irc_inp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or
99: nvl(irc_inp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or
101: nvl(irc_inp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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

94: nvl(p_rec.attribute19, hr_api.g_varchar2) or
95: nvl(irc_inp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or
97: nvl(irc_inp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or
99: nvl(irc_inp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or
101: nvl(irc_inp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or

Line 99: nvl(irc_inp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

95: nvl(irc_inp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
96: nvl(p_rec.attribute20, hr_api.g_varchar2) or
97: nvl(irc_inp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or
99: nvl(irc_inp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or
101: nvl(irc_inp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or
103: nvl(irc_inp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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

96: nvl(p_rec.attribute20, hr_api.g_varchar2) or
97: nvl(irc_inp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or
99: nvl(irc_inp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or
101: nvl(irc_inp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or
103: nvl(irc_inp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or

Line 101: nvl(irc_inp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

97: nvl(irc_inp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
98: nvl(p_rec.attribute21, hr_api.g_varchar2) or
99: nvl(irc_inp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or
101: nvl(irc_inp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or
103: nvl(irc_inp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or
105: nvl(irc_inp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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

98: nvl(p_rec.attribute21, hr_api.g_varchar2) or
99: nvl(irc_inp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or
101: nvl(irc_inp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or
103: nvl(irc_inp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or
105: nvl(irc_inp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or

Line 103: nvl(irc_inp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

99: nvl(irc_inp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
100: nvl(p_rec.attribute22, hr_api.g_varchar2) or
101: nvl(irc_inp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or
103: nvl(irc_inp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or
105: nvl(irc_inp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or
107: nvl(irc_inp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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

100: nvl(p_rec.attribute22, hr_api.g_varchar2) or
101: nvl(irc_inp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or
103: nvl(irc_inp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or
105: nvl(irc_inp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or
107: nvl(irc_inp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or

Line 105: nvl(irc_inp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

101: nvl(irc_inp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
102: nvl(p_rec.attribute23, hr_api.g_varchar2) or
103: nvl(irc_inp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or
105: nvl(irc_inp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or
107: nvl(irc_inp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or
109: nvl(irc_inp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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

102: nvl(p_rec.attribute23, hr_api.g_varchar2) or
103: nvl(irc_inp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or
105: nvl(irc_inp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or
107: nvl(irc_inp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or
109: nvl(irc_inp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or

Line 107: nvl(irc_inp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

103: nvl(irc_inp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
104: nvl(p_rec.attribute24, hr_api.g_varchar2) or
105: nvl(irc_inp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or
107: nvl(irc_inp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or
109: nvl(irc_inp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or
111: nvl(irc_inp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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

104: nvl(p_rec.attribute24, hr_api.g_varchar2) or
105: nvl(irc_inp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or
107: nvl(irc_inp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or
109: nvl(irc_inp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or
111: nvl(irc_inp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or

Line 109: nvl(irc_inp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

105: nvl(irc_inp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
106: nvl(p_rec.attribute25, hr_api.g_varchar2) or
107: nvl(irc_inp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or
109: nvl(irc_inp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or
111: nvl(irc_inp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or
113: nvl(irc_inp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

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

106: nvl(p_rec.attribute25, hr_api.g_varchar2) or
107: nvl(irc_inp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or
109: nvl(irc_inp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or
111: nvl(irc_inp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or
113: nvl(irc_inp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
114: nvl(p_rec.attribute29, hr_api.g_varchar2) or

Line 111: nvl(irc_inp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

107: nvl(irc_inp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
108: nvl(p_rec.attribute26, hr_api.g_varchar2) or
109: nvl(irc_inp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or
111: nvl(irc_inp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or
113: nvl(irc_inp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
114: nvl(p_rec.attribute29, hr_api.g_varchar2) or
115: nvl(irc_inp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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

108: nvl(p_rec.attribute26, hr_api.g_varchar2) or
109: nvl(irc_inp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or
111: nvl(irc_inp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or
113: nvl(irc_inp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
114: nvl(p_rec.attribute29, hr_api.g_varchar2) or
115: nvl(irc_inp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
116: nvl(p_rec.attribute30, hr_api.g_varchar2) ))

Line 113: nvl(irc_inp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

109: nvl(irc_inp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute27, hr_api.g_varchar2) or
111: nvl(irc_inp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or
113: nvl(irc_inp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
114: nvl(p_rec.attribute29, hr_api.g_varchar2) or
115: nvl(irc_inp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
116: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
117: or (p_rec.notification_preference_id is null) then

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

110: nvl(p_rec.attribute27, hr_api.g_varchar2) or
111: nvl(irc_inp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or
113: nvl(irc_inp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
114: nvl(p_rec.attribute29, hr_api.g_varchar2) or
115: nvl(irc_inp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
116: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
117: or (p_rec.notification_preference_id is null) then
118: --

Line 115: nvl(irc_inp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

111: nvl(irc_inp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
112: nvl(p_rec.attribute28, hr_api.g_varchar2) or
113: nvl(irc_inp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
114: nvl(p_rec.attribute29, hr_api.g_varchar2) or
115: nvl(irc_inp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
116: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
117: or (p_rec.notification_preference_id is null) then
118: --
119: -- Only execute the validation if absolutely necessary:

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

112: nvl(p_rec.attribute28, hr_api.g_varchar2) or
113: nvl(irc_inp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
114: nvl(p_rec.attribute29, hr_api.g_varchar2) or
115: nvl(irc_inp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
116: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
117: or (p_rec.notification_preference_id is null) then
118: --
119: -- Only execute the validation if absolutely necessary:
120: -- a) During update, the structure column value or any

Line 243: if nvl(p_rec.notification_preference_id, hr_api.g_number) <>

239: fnd_message.set_token('STEP ', '5');
240: fnd_message.raise_error;
241: END IF;
242: --
243: if nvl(p_rec.notification_preference_id, hr_api.g_number) <>
244: nvl(irc_inp_shd.g_old_rec.notification_preference_id, hr_api.g_number)
245: then
246: hr_api.argument_changed_error
247: (p_api_name => l_proc

Line 244: nvl(irc_inp_shd.g_old_rec.notification_preference_id, hr_api.g_number)

240: fnd_message.raise_error;
241: END IF;
242: --
243: if nvl(p_rec.notification_preference_id, hr_api.g_number) <>
244: nvl(irc_inp_shd.g_old_rec.notification_preference_id, hr_api.g_number)
245: then
246: hr_api.argument_changed_error
247: (p_api_name => l_proc
248: ,p_argument => 'NOTIFICATION_PREFERENCE_ID'

Line 246: hr_api.argument_changed_error

242: --
243: if nvl(p_rec.notification_preference_id, hr_api.g_number) <>
244: nvl(irc_inp_shd.g_old_rec.notification_preference_id, hr_api.g_number)
245: then
246: hr_api.argument_changed_error
247: (p_api_name => l_proc
248: ,p_argument => 'NOTIFICATION_PREFERENCE_ID'
249: ,p_base_table => irc_inp_shd.g_tab_nam
250: );

Line 388: hr_api.mandatory_arg_error

384: Begin
385: --
386: hr_utility.set_location(' Entering:'||l_proc,10);
387: --
388: hr_api.mandatory_arg_error
389: (p_api_name => l_proc
390: ,p_argument => 'PARTY_ID'
391: ,p_argument_value => p_party_id
392: );

Line 511: if(l_api_updating and nvl(p_address_id, hr_api.g_number)

507: ,p_object_version_number => p_object_version_number);
508: --
509: hr_utility.set_location(l_proc,30);
510: --
511: if(l_api_updating and nvl(p_address_id, hr_api.g_number)
512: <> nvl(irc_inp_shd.g_old_rec.address_id, hr_api.g_number))
513: or (not l_api_updating) then
514: --
515: hr_utility.set_location(l_proc,40);

Line 512: <> nvl(irc_inp_shd.g_old_rec.address_id, hr_api.g_number))

508: --
509: hr_utility.set_location(l_proc,30);
510: --
511: if(l_api_updating and nvl(p_address_id, hr_api.g_number)
512: <> nvl(irc_inp_shd.g_old_rec.address_id, hr_api.g_number))
513: or (not l_api_updating) then
514: --
515: hr_utility.set_location(l_proc,40);
516: --

Line 598: hr_api.mandatory_arg_error

594: Begin
595: --
596: hr_utility.set_location(' Entering:'||l_proc,10);
597: --
598: hr_api.mandatory_arg_error
599: (p_api_name => l_proc
600: ,p_argument => 'MATCHING_JOBS'
601: ,p_argument_value => p_matching_jobs
602: );

Line 611: and nvl(p_matching_jobs, hr_api.g_varchar2)

607: --
608: hr_utility.set_location(l_proc,20);
609: --
610: if (l_api_updating
611: and nvl(p_matching_jobs, hr_api.g_varchar2)
612: <> nvl(irc_inp_shd.g_old_rec.matching_jobs, hr_api.g_varchar2))
613: or (not l_api_updating) then
614: --
615: hr_utility.set_location(l_proc,30);

Line 612: <> nvl(irc_inp_shd.g_old_rec.matching_jobs, hr_api.g_varchar2))

608: hr_utility.set_location(l_proc,20);
609: --
610: if (l_api_updating
611: and nvl(p_matching_jobs, hr_api.g_varchar2)
612: <> nvl(irc_inp_shd.g_old_rec.matching_jobs, hr_api.g_varchar2))
613: or (not l_api_updating) then
614: --
615: hr_utility.set_location(l_proc,30);
616: --

Line 687: hr_api.mandatory_arg_error

683: Begin
684: --
685: hr_utility.set_location(' Entering:'||l_proc,10);
686: --
687: hr_api.mandatory_arg_error
688: (p_api_name => l_proc
689: ,p_argument => 'MATCHING_JOB_FREQ'
690: ,p_argument_value => p_matching_job_freq
691: );

Line 700: and nvl(p_matching_job_freq, hr_api.g_varchar2)

696: --
697: hr_utility.set_location(l_proc,20);
698: --
699: if (l_api_updating
700: and nvl(p_matching_job_freq, hr_api.g_varchar2)
701: <> nvl(irc_inp_shd.g_old_rec.matching_job_freq, hr_api.g_varchar2))
702: or (not l_api_updating) then
703: --
704: hr_utility.set_location(l_proc,30);

Line 701: <> nvl(irc_inp_shd.g_old_rec.matching_job_freq, hr_api.g_varchar2))

697: hr_utility.set_location(l_proc,20);
698: --
699: if (l_api_updating
700: and nvl(p_matching_job_freq, hr_api.g_varchar2)
701: <> nvl(irc_inp_shd.g_old_rec.matching_job_freq, hr_api.g_varchar2))
702: or (not l_api_updating) then
703: --
704: hr_utility.set_location(l_proc,30);
705: --

Line 706: if hr_api.not_exists_in_hr_lookups

702: or (not l_api_updating) then
703: --
704: hr_utility.set_location(l_proc,30);
705: --
706: if hr_api.not_exists_in_hr_lookups
707: ( p_effective_date => p_effective_date
708: , p_lookup_type => 'IRC_MESSAGE_FREQ'
709: , p_lookup_code => p_matching_job_freq) then
710: fnd_message.set_name('PER','IRC_412003_BAD_MATCH_JOB_FREQ');

Line 775: hr_api.mandatory_arg_error

771: Begin
772: --
773: hr_utility.set_location(' Entering:'||l_proc,10);
774: --
775: hr_api.mandatory_arg_error
776: (p_api_name => l_proc
777: ,p_argument => 'RECEIVE_INFO_MAIL'
778: ,p_argument_value => p_receive_info_mail
779: );

Line 788: and nvl(p_receive_info_mail, hr_api.g_varchar2)

784: --
785: hr_utility.set_location(l_proc,20);
786: --
787: if (l_api_updating
788: and nvl(p_receive_info_mail, hr_api.g_varchar2)
789: <> nvl(irc_inp_shd.g_old_rec.receive_info_mail, hr_api.g_varchar2))
790: or (not l_api_updating) then
791: --
792: hr_utility.set_location(l_proc,30);

Line 789: <> nvl(irc_inp_shd.g_old_rec.receive_info_mail, hr_api.g_varchar2))

785: hr_utility.set_location(l_proc,20);
786: --
787: if (l_api_updating
788: and nvl(p_receive_info_mail, hr_api.g_varchar2)
789: <> nvl(irc_inp_shd.g_old_rec.receive_info_mail, hr_api.g_varchar2))
790: or (not l_api_updating) then
791: --
792: hr_utility.set_location(l_proc,30);
793: --

Line 860: hr_api.mandatory_arg_error

856: Begin
857: --
858: hr_utility.set_location(' Entering:'||l_proc,10);
859: --
860: hr_api.mandatory_arg_error
861: (p_api_name => l_proc
862: ,p_argument => 'ALLOW_ACCESS'
863: ,p_argument_value => p_allow_access
864: );

Line 873: and nvl(p_allow_access, hr_api.g_varchar2)

869: --
870: hr_utility.set_location(l_proc,20);
871: --
872: if (l_api_updating
873: and nvl(p_allow_access, hr_api.g_varchar2)
874: <> nvl(irc_inp_shd.g_old_rec.allow_access, hr_api.g_varchar2))
875: or (not l_api_updating) then
876: if p_allow_access not in ('Y','N') then
877: fnd_message.set_name('PER','IRC_412005_BAD_ALLOW_ACCESS');

Line 874: <> nvl(irc_inp_shd.g_old_rec.allow_access, hr_api.g_varchar2))

870: hr_utility.set_location(l_proc,20);
871: --
872: if (l_api_updating
873: and nvl(p_allow_access, hr_api.g_varchar2)
874: <> nvl(irc_inp_shd.g_old_rec.allow_access, hr_api.g_varchar2))
875: or (not l_api_updating) then
876: if p_allow_access not in ('Y','N') then
877: fnd_message.set_name('PER','IRC_412005_BAD_ALLOW_ACCESS');
878: fnd_message.raise_error;

Line 1027: nvl(irc_inp_shd.g_old_rec.attempt_id, hr_api.g_number) <>

1023: );
1024: --
1025: hr_utility.set_location(l_proc, 20);
1026: if ((l_api_updating and
1027: nvl(irc_inp_shd.g_old_rec.attempt_id, hr_api.g_number) <>
1028: nvl(p_attempt_id, hr_api.g_number))
1029: or
1030: (NOT l_api_updating)) then
1031: --

Line 1028: nvl(p_attempt_id, hr_api.g_number))

1024: --
1025: hr_utility.set_location(l_proc, 20);
1026: if ((l_api_updating and
1027: nvl(irc_inp_shd.g_old_rec.attempt_id, hr_api.g_number) <>
1028: nvl(p_attempt_id, hr_api.g_number))
1029: or
1030: (NOT l_api_updating)) then
1031: --
1032: hr_utility.set_location(l_proc, 30);