DBA Data[Home] [Help]

APPS.IRC_IRF_BUS dependencies on IRC_IRF_SHD

Line 88: (p_rec in irc_irf_shd.g_rec_type

84: -- Internal Row Handler Use Only.
85: --
86: -- ----------------------------------------------------------------------------
87: procedure chk_ddf
88: (p_rec in irc_irf_shd.g_rec_type
89: ) is
90: --
91: l_proc varchar2(72) := g_package || 'chk_ddf';
92: --

Line 97: nvl(irc_irf_shd.g_old_rec.irf_information_category, hr_api.g_varchar2) <>

93: begin
94: hr_utility.set_location('Entering:'||l_proc,10);
95: --
96: if ((p_rec.referral_info_id is not null) and (
97: nvl(irc_irf_shd.g_old_rec.irf_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.irf_information_category, hr_api.g_varchar2) or
99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or
101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>

Line 99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>

95: --
96: if ((p_rec.referral_info_id is not null) and (
97: nvl(irc_irf_shd.g_old_rec.irf_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.irf_information_category, hr_api.g_varchar2) or
99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or
101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or
103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>

Line 101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>

97: nvl(irc_irf_shd.g_old_rec.irf_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.irf_information_category, hr_api.g_varchar2) or
99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or
101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or
103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or
105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>

Line 103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>

99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or
101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or
103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or
105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or
107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>

Line 105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>

101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or
103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or
105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or
107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or
109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>

Line 107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>

103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or
105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or
107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or
109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or
111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>

Line 109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>

105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or
107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or
109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or
111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or
113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>

Line 111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>

107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or
109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or
111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or
113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or
115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>

Line 113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>

109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or
111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or
113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or
115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.irf_information9, hr_api.g_varchar2) or
117: nvl(irc_irf_shd.g_old_rec.irf_information10, hr_api.g_varchar2) <>

Line 115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>

111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or
113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or
115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.irf_information9, hr_api.g_varchar2) or
117: nvl(irc_irf_shd.g_old_rec.irf_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.irf_information10, hr_api.g_varchar2) ))
119: or (p_rec.referral_info_id is null) then

Line 117: nvl(irc_irf_shd.g_old_rec.irf_information10, hr_api.g_varchar2) <>

113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or
115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.irf_information9, hr_api.g_varchar2) or
117: nvl(irc_irf_shd.g_old_rec.irf_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.irf_information10, hr_api.g_varchar2) ))
119: or (p_rec.referral_info_id is null) then
120: --
121: -- Only execute the validation if absolutely necessary:

Line 185: (p_rec in irc_irf_shd.g_rec_type

181: -- Internal Row Handler Use Only.
182: --
183: -- ----------------------------------------------------------------------------
184: procedure chk_df
185: (p_rec in irc_irf_shd.g_rec_type
186: ) is
187: --
188: l_proc varchar2(72) := g_package || 'chk_df';
189: --

Line 194: nvl(irc_irf_shd.g_old_rec.irf_attribute_category, hr_api.g_varchar2) <>

190: begin
191: hr_utility.set_location('Entering:'||l_proc,10);
192: --
193: if ((p_rec.referral_info_id is not null) and (
194: nvl(irc_irf_shd.g_old_rec.irf_attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.irf_attribute_category, hr_api.g_varchar2) or
196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or
198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>

Line 196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>

192: --
193: if ((p_rec.referral_info_id is not null) and (
194: nvl(irc_irf_shd.g_old_rec.irf_attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.irf_attribute_category, hr_api.g_varchar2) or
196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or
198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or
200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>

Line 198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>

194: nvl(irc_irf_shd.g_old_rec.irf_attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.irf_attribute_category, hr_api.g_varchar2) or
196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or
198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or
200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or
202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>

Line 200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>

196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or
198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or
200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or
202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or
204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>

Line 202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>

198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or
200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or
202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or
204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or
206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>

Line 204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>

200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or
202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or
204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or
206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or
208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>

Line 206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>

202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or
204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or
206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or
208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or
210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>

Line 208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>

204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or
206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or
208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or
210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or
212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>

Line 210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>

206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or
208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or
210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or
212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.irf_attribute9, hr_api.g_varchar2) or
214: nvl(irc_irf_shd.g_old_rec.irf_attribute10, hr_api.g_varchar2) <>

Line 212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>

208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or
210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or
212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.irf_attribute9, hr_api.g_varchar2) or
214: nvl(irc_irf_shd.g_old_rec.irf_attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.irf_attribute10, hr_api.g_varchar2) ))
216: or (p_rec.referral_info_id is null) then

Line 214: nvl(irc_irf_shd.g_old_rec.irf_attribute10, hr_api.g_varchar2) <>

210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or
212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.irf_attribute9, hr_api.g_varchar2) or
214: nvl(irc_irf_shd.g_old_rec.irf_attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.irf_attribute10, hr_api.g_varchar2) ))
216: or (p_rec.referral_info_id is null) then
217: --
218: -- Only execute the validation if absolutely necessary:

Line 282: ,p_rec in irc_irf_shd.g_rec_type

278: -- {End Of Comments}
279: -- ----------------------------------------------------------------------------
280: Procedure chk_non_updateable_args
281: (p_effective_date in date
282: ,p_rec in irc_irf_shd.g_rec_type
283: ) IS
284: --
285: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
286: --

Line 294: IF NOT irc_irf_shd.api_updating

290: --
291: -- Only proceed with the validation if a row exists for the current
292: -- record in the HR Schema.
293: --
294: IF NOT irc_irf_shd.api_updating
295: (p_effective_date => p_effective_date
296: ,p_referral_info_id => p_rec.referral_info_id
297: ,p_object_version_number => p_rec.object_version_number
298: ) THEN

Line 308: if p_rec.object_id <> irc_irf_shd.g_old_rec.object_id then

304: --
305: -- Add checks to ensure non-updateable args have
306: -- not been updated.
307: --
308: if p_rec.object_id <> irc_irf_shd.g_old_rec.object_id then
309: hr_api.argument_changed_error
310: ( p_api_name => l_proc
311: ,p_argument => 'OBJECT_ID'
312: ,p_base_table => irc_irf_shd.g_tab_name

Line 312: ,p_base_table => irc_irf_shd.g_tab_name

308: if p_rec.object_id <> irc_irf_shd.g_old_rec.object_id then
309: hr_api.argument_changed_error
310: ( p_api_name => l_proc
311: ,p_argument => 'OBJECT_ID'
312: ,p_base_table => irc_irf_shd.g_tab_name
313: );
314: end if;
315: --
316: if p_rec.object_type <> irc_irf_shd.g_old_rec.object_type then

Line 316: if p_rec.object_type <> irc_irf_shd.g_old_rec.object_type then

312: ,p_base_table => irc_irf_shd.g_tab_name
313: );
314: end if;
315: --
316: if p_rec.object_type <> irc_irf_shd.g_old_rec.object_type then
317: hr_api.argument_changed_error
318: ( p_api_name => l_proc
319: ,p_argument => 'OBJECT_TYPE'
320: ,p_base_table => irc_irf_shd.g_tab_name

Line 320: ,p_base_table => irc_irf_shd.g_tab_name

316: if p_rec.object_type <> irc_irf_shd.g_old_rec.object_type then
317: hr_api.argument_changed_error
318: ( p_api_name => l_proc
319: ,p_argument => 'OBJECT_TYPE'
320: ,p_base_table => irc_irf_shd.g_tab_name
321: );
322: end if;
323: --
324: if p_rec.object_created_by <> irc_irf_shd.g_old_rec.object_created_by then

Line 324: if p_rec.object_created_by <> irc_irf_shd.g_old_rec.object_created_by then

320: ,p_base_table => irc_irf_shd.g_tab_name
321: );
322: end if;
323: --
324: if p_rec.object_created_by <> irc_irf_shd.g_old_rec.object_created_by then
325: hr_api.argument_changed_error
326: ( p_api_name => l_proc
327: ,p_argument => 'OBJECT_CREATED_BY'
328: ,p_base_table => irc_irf_shd.g_tab_name

Line 328: ,p_base_table => irc_irf_shd.g_tab_name

324: if p_rec.object_created_by <> irc_irf_shd.g_old_rec.object_created_by then
325: hr_api.argument_changed_error
326: ( p_api_name => l_proc
327: ,p_argument => 'OBJECT_CREATED_BY'
328: ,p_base_table => irc_irf_shd.g_tab_name
329: );
330: end if;
331: --
332: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 575: (p_rec in irc_irf_shd.g_rec_type

571: -- ----------------------------------------------------------------------------
572: -- |---------------------------< chk_object >----------------------------|
573: -- ----------------------------------------------------------------------------
574: Procedure chk_object
575: (p_rec in irc_irf_shd.g_rec_type
576: ,p_effective_date in date
577: ) is
578: --
579: l_proc varchar2(72) := g_package||'chk_object';

Line 609: (p_rec in irc_irf_shd.g_rec_type

605: -- ----------------------------------------------------------------------------
606: -- |---------------------------< chk_object_created_by >----------------------|
607: -- ----------------------------------------------------------------------------
608: Procedure chk_object_created_by
609: (p_rec in irc_irf_shd.g_rec_type
610: ,p_effective_date in date
611: ) is
612: --
613: l_proc varchar2(72) := g_package||'chk_object_created_by';

Line 828: (p_rec in irc_irf_shd.g_rec_type

824: -- ----------------------------------------------------------------------------
825: -- |---------------------------< insert_validate >----------------------------|
826: -- ----------------------------------------------------------------------------
827: Procedure insert_validate
828: (p_rec in irc_irf_shd.g_rec_type
829: ,p_effective_date in date
830: ,p_datetrack_mode in varchar2
831: ,p_validation_start_date in date
832: ,p_validation_end_date in date

Line 907: (p_rec in irc_irf_shd.g_rec_type

903: -- ----------------------------------------------------------------------------
904: -- |---------------------------< update_validate >----------------------------|
905: -- ----------------------------------------------------------------------------
906: Procedure update_validate
907: (p_rec in irc_irf_shd.g_rec_type
908: ,p_effective_date in date
909: ,p_datetrack_mode in varchar2
910: ,p_validation_start_date in date
911: ,p_validation_end_date in date