APPS.OTA_CRT_BUS dependencies on OTA_CRT_SHD

Line 189: (p_rec in ota_crt_shd.g_rec_type

185: -- Internal Row Handler Use Only.
186: --
187: -- ----------------------------------------------------------------------------
188: procedure chk_df
189: (p_rec in ota_crt_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --

Line 198: nvl(ota_crt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.certification_id is not null) and (
198: nvl(ota_crt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(ota_crt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_crt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 200: nvl(ota_crt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

196: --
197: if ((p_rec.certification_id is not null) and (
198: nvl(ota_crt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(ota_crt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_crt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(ota_crt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 202: nvl(ota_crt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

198: nvl(ota_crt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(ota_crt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_crt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(ota_crt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(ota_crt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 204: nvl(ota_crt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

200: nvl(ota_crt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_crt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(ota_crt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(ota_crt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(ota_crt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 206: nvl(ota_crt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

202: nvl(ota_crt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(ota_crt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(ota_crt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(ota_crt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(ota_crt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 208: nvl(ota_crt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

204: nvl(ota_crt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(ota_crt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(ota_crt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(ota_crt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(ota_crt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 210: nvl(ota_crt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

206: nvl(ota_crt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(ota_crt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(ota_crt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(ota_crt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(ota_crt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 212: nvl(ota_crt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

208: nvl(ota_crt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(ota_crt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(ota_crt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(ota_crt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(ota_crt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 214: nvl(ota_crt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

210: nvl(ota_crt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(ota_crt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(ota_crt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(ota_crt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(ota_crt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 216: nvl(ota_crt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

212: nvl(ota_crt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(ota_crt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(ota_crt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(ota_crt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(ota_crt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 218: nvl(ota_crt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

214: nvl(ota_crt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(ota_crt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(ota_crt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(ota_crt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(ota_crt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 220: nvl(ota_crt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

216: nvl(ota_crt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(ota_crt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(ota_crt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(ota_crt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(ota_crt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 222: nvl(ota_crt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

218: nvl(ota_crt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(ota_crt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(ota_crt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(ota_crt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(ota_crt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 224: nvl(ota_crt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

220: nvl(ota_crt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(ota_crt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(ota_crt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(ota_crt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(ota_crt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 226: nvl(ota_crt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

222: nvl(ota_crt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(ota_crt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(ota_crt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(ota_crt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(ota_crt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 228: nvl(ota_crt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

224: nvl(ota_crt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(ota_crt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(ota_crt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(ota_crt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(ota_crt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 230: nvl(ota_crt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

226: nvl(ota_crt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(ota_crt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(ota_crt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(ota_crt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_crt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 232: nvl(ota_crt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

228: nvl(ota_crt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(ota_crt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(ota_crt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_crt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_crt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 234: nvl(ota_crt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

230: nvl(ota_crt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(ota_crt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_crt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_crt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(ota_crt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 236: nvl(ota_crt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

232: nvl(ota_crt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_crt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_crt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(ota_crt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
240: or (p_rec.certification_id is null) then

Line 238: nvl(ota_crt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

234: nvl(ota_crt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_crt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(ota_crt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
240: or (p_rec.certification_id is null) then
241: --
242: -- Only execute the validation if absolutely necessary:

Line 326: ,p_rec in ota_crt_shd.g_rec_type

322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: Procedure chk_non_updateable_args
325: (p_effective_date in date
326: ,p_rec in ota_crt_shd.g_rec_type
327: ) IS
328: --
329: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
330: --

Line 336: IF NOT ota_crt_shd.api_updating

332: --
333: -- Only proceed with the validation if a row exists for the current
334: -- record in the HR Schema.
335: --
336: IF NOT ota_crt_shd.api_updating
337: (p_certification_id => p_rec.certification_id
338: ,p_object_version_number => p_rec.object_version_number
339: ) THEN
340: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 348: NVL(ota_crt_shd.g_old_rec.business_group_id, hr_api.g_number) THEN

344: END IF;
345: --
346: hr_utility.set_location(' Step:'|| l_proc, 10);
347: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
348: NVL(ota_crt_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
349: hr_api.argument_changed_error
350: (p_api_name => l_proc
351: ,p_argument => 'BUSINESS_GROUP_ID'
352: ,p_base_table => ota_crt_shd.g_tab_nam);

Line 352: ,p_base_table => ota_crt_shd.g_tab_nam);

348: NVL(ota_crt_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
349: hr_api.argument_changed_error
350: (p_api_name => l_proc
351: ,p_argument => 'BUSINESS_GROUP_ID'
352: ,p_base_table => ota_crt_shd.g_tab_nam);
353: END IF;
354: --
355: hr_utility.set_location(' Step:'|| l_proc, 20);
356: IF NVL(p_rec.certification_id, hr_api.g_number) <>

Line 357: NVL(ota_crt_shd.g_old_rec.certification_id, hr_api.g_number) THEN

353: END IF;
354: --
355: hr_utility.set_location(' Step:'|| l_proc, 20);
356: IF NVL(p_rec.certification_id, hr_api.g_number) <>
357: NVL(ota_crt_shd.g_old_rec.certification_id, hr_api.g_number) THEN
358: hr_api.argument_changed_error
359: (p_api_name => l_proc
360: ,p_argument => 'CERTIFICATION_ID'
361: ,p_base_table => ota_crt_shd.g_tab_nam);

Line 361: ,p_base_table => ota_crt_shd.g_tab_nam);

357: NVL(ota_crt_shd.g_old_rec.certification_id, hr_api.g_number) THEN
358: hr_api.argument_changed_error
359: (p_api_name => l_proc
360: ,p_argument => 'CERTIFICATION_ID'
361: ,p_base_table => ota_crt_shd.g_tab_nam);
362: END IF;
363: --
364: EXCEPTION
365:

Line 1071: l_init_compl_date_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_date,

1067: FETCH csr_exis_subscr into l_subscr_exists;
1068: CLOSE csr_exis_subscr;
1069:
1070: if l_subscr_exists = 'Y' then
1071: l_init_compl_date_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_date,
1072: p_initial_completion_date);
1073:
1074: l_init_compl_dur_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_duration,
1075: p_initial_completion_duration);

Line 1074: l_init_compl_dur_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_duration,

1070: if l_subscr_exists = 'Y' then
1071: l_init_compl_date_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_date,
1072: p_initial_completion_date);
1073:
1074: l_init_compl_dur_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_duration,
1075: p_initial_completion_duration);
1076:
1077: l_renew_flag_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.renewable_flag,
1078: p_renewable_flag);

Line 1077: l_renew_flag_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.renewable_flag,

1073:
1074: l_init_compl_dur_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_duration,
1075: p_initial_completion_duration);
1076:
1077: l_renew_flag_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.renewable_flag,
1078: p_renewable_flag);
1079:
1080: l_notify_days_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.notify_days_before_expire,
1081: p_notify_days);

Line 1080: l_notify_days_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.notify_days_before_expire,

1076:
1077: l_renew_flag_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.renewable_flag,
1078: p_renewable_flag);
1079:
1080: l_notify_days_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.notify_days_before_expire,
1081: p_notify_days);
1082:
1083: if l_init_compl_date_changed OR l_init_compl_dur_changed
1084: OR l_renew_flag_changed OR l_notify_days_changed

Line 1198: ,p_rec in ota_crt_shd.g_rec_type

1194: -- |---------------------------< insert_validate >----------------------------|
1195: -- ----------------------------------------------------------------------------
1196: Procedure insert_validate
1197: (p_effective_date in date
1198: ,p_rec in ota_crt_shd.g_rec_type
1199: ) is
1200: --
1201: l_proc varchar2(72) := g_package||'insert_validate';
1202: --

Line 1210: ,p_associated_column1 => ota_crt_shd.g_tab_nam

1206: -- Call all supporting business operations
1207: --
1208: hr_api.validate_bus_grp_id
1209: (p_business_group_id => p_rec.business_group_id
1210: ,p_associated_column1 => ota_crt_shd.g_tab_nam
1211: || '.BUSINESS_GROUP_ID');
1212: --
1213: -- After validating the set of important attributes,
1214: -- if Multiple Message detection is enabled and at least

Line 1287: ,p_rec in ota_crt_shd.g_rec_type

1283: -- |---------------------------< update_validate >----------------------------|
1284: -- ----------------------------------------------------------------------------
1285: Procedure update_validate
1286: (p_effective_date in date
1287: ,p_rec in ota_crt_shd.g_rec_type
1288: ) is
1289: --
1290: l_proc varchar2(72) := g_package||'update_validate';
1291: --

Line 1299: ,p_associated_column1 => ota_crt_shd.g_tab_nam

1295: -- Call all supporting business operations
1296: --
1297: hr_api.validate_bus_grp_id
1298: (p_business_group_id => p_rec.business_group_id
1299: ,p_associated_column1 => ota_crt_shd.g_tab_nam
1300: || '.BUSINESS_GROUP_ID');
1301: --
1302: -- After validating the set of important attributes,
1303: -- if Multiple Message detection is enabled and at least

Line 1395: (p_rec in ota_crt_shd.g_rec_type

1391: -- ----------------------------------------------------------------------------
1392: -- |---------------------------< delete_validate >----------------------------|
1393: -- ----------------------------------------------------------------------------
1394: Procedure delete_validate
1395: (p_rec in ota_crt_shd.g_rec_type
1396: ) is
1397: --
1398: l_proc varchar2(72) := g_package||'delete_validate';
1399: --