APPS.IRC_INP_BUS dependencies on IRC_INP_SHD

Line 46: (p_rec in irc_inp_shd.g_rec_type

42: -- Internal Row Handler Use Only.
43: --
44: -- ----------------------------------------------------------------------------
45: procedure chk_df
46: (p_rec in irc_inp_shd.g_rec_type
47: ) is
48: --
49: l_proc varchar2(72) := g_package || 'chk_df';
50: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 223: ,p_rec in irc_inp_shd.g_rec_type

219: -- {End Of Comments}
220: -- ----------------------------------------------------------------------------
221: Procedure chk_non_updateable_args
222: (p_effective_date in date
223: ,p_rec in irc_inp_shd.g_rec_type
224: ) IS
225: --
226: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
227: --

Line 233: IF NOT irc_inp_shd.api_updating

229: --
230: -- Only proceed with the validation if a row exists for the current
231: -- record in the HR Schema.
232: --
233: IF NOT irc_inp_shd.api_updating
234: (p_notification_preference_id => p_rec.notification_preference_id
235: ,p_object_version_number => p_rec.object_version_number
236: ) THEN
237: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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 249: ,p_base_table => irc_inp_shd.g_tab_nam

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: );
251: end if;
252: End chk_non_updateable_args;
253: --

Line 505: l_api_updating := irc_inp_shd.api_updating

501: if p_address_id is not null then
502: --
503: hr_utility.set_location(l_proc,20);
504: --
505: l_api_updating := irc_inp_shd.api_updating
506: (p_notification_preference_id => p_notification_preference_id
507: ,p_object_version_number => p_object_version_number);
508: --
509: hr_utility.set_location(l_proc,30);

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 604: l_api_updating := irc_inp_shd.api_updating

600: ,p_argument => 'MATCHING_JOBS'
601: ,p_argument_value => p_matching_jobs
602: );
603: --
604: l_api_updating := irc_inp_shd.api_updating
605: (p_notification_preference_id => p_notification_preference_id
606: ,p_object_version_number => p_object_version_number);
607: --
608: hr_utility.set_location(l_proc,20);

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 693: l_api_updating := irc_inp_shd.api_updating

689: ,p_argument => 'MATCHING_JOB_FREQ'
690: ,p_argument_value => p_matching_job_freq
691: );
692: --
693: l_api_updating := irc_inp_shd.api_updating
694: (p_notification_preference_id => p_notification_preference_id
695: ,p_object_version_number => p_object_version_number);
696: --
697: hr_utility.set_location(l_proc,20);

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 781: l_api_updating := irc_inp_shd.api_updating

777: ,p_argument => 'RECEIVE_INFO_MAIL'
778: ,p_argument_value => p_receive_info_mail
779: );
780: --
781: l_api_updating := irc_inp_shd.api_updating
782: (p_notification_preference_id => p_notification_preference_id
783: ,p_object_version_number => p_object_version_number);
784: --
785: hr_utility.set_location(l_proc,20);

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 866: l_api_updating := irc_inp_shd.api_updating

862: ,p_argument => 'ALLOW_ACCESS'
863: ,p_argument_value => p_allow_access
864: );
865: --
866: l_api_updating := irc_inp_shd.api_updating
867: (p_notification_preference_id => p_notification_preference_id
868: ,p_object_version_number => p_object_version_number);
869: --
870: hr_utility.set_location(l_proc,20);

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 1020: l_api_updating := irc_inp_shd.api_updating

1016: Begin
1017: --
1018: hr_utility.set_location(' Entering:'||l_proc,10);
1019: --
1020: l_api_updating := irc_inp_shd.api_updating
1021: (p_notification_preference_id => p_notification_preference_id
1022: ,p_object_version_number => p_object_version_number
1023: );
1024: --

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 1079: ,p_rec in out nocopy irc_inp_shd.g_rec_type

1075: -- |---------------------------< insert_validate >----------------------------|
1076: -- ----------------------------------------------------------------------------
1077: Procedure insert_validate
1078: (p_effective_date in date
1079: ,p_rec in out nocopy irc_inp_shd.g_rec_type
1080: ) is
1081: --
1082: l_proc varchar2(72) := g_package||'insert_validate';
1083: --

Line 1162: ,p_rec in out nocopy irc_inp_shd.g_rec_type

1158: -- |---------------------------< update_validate >----------------------------|
1159: -- ----------------------------------------------------------------------------
1160: Procedure update_validate
1161: (p_effective_date in date
1162: ,p_rec in out nocopy irc_inp_shd.g_rec_type
1163: ) is
1164: --
1165: l_proc varchar2(72) := g_package||'update_validate';
1166: --

Line 1245: (p_rec in irc_inp_shd.g_rec_type

1241: -- ----------------------------------------------------------------------------
1242: -- |---------------------------< delete_validate >----------------------------|
1243: -- ----------------------------------------------------------------------------
1244: Procedure delete_validate
1245: (p_rec in irc_inp_shd.g_rec_type
1246: ) is
1247: --
1248: l_proc varchar2(72) := g_package||'delete_validate';
1249: --