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: --
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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
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:
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: --
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');
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'
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: --
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);
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: --
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);
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: --
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);
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: --
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);
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: --
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);
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;
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: --
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: --
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: --
1153: -- |---------------------------< update_validate >----------------------------|
1154: -- ----------------------------------------------------------------------------
1155: Procedure update_validate
1156: (p_effective_date in date
1157: ,p_rec in out nocopy irc_inp_shd.g_rec_type
1158: ) is
1159: --
1160: l_proc varchar2(72) := g_package||'update_validate';
1161: --
1236: -- ----------------------------------------------------------------------------
1237: -- |---------------------------< delete_validate >----------------------------|
1238: -- ----------------------------------------------------------------------------
1239: Procedure delete_validate
1240: (p_rec in irc_inp_shd.g_rec_type
1241: ) is
1242: --
1243: l_proc varchar2(72) := g_package||'delete_validate';
1244: --