APPS.OTA_TCC_BUS dependencies on OTA_TCC_SHD

Line 177: ,p_rec in ota_tcc_shd.g_rec_type

173: -- {End Of Comments}
174: -- ----------------------------------------------------------------------------
175: Procedure chk_non_updateable_args
176: (p_effective_date in date
177: ,p_rec in ota_tcc_shd.g_rec_type
178: ) IS
179: --
180: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
181: l_error EXCEPTION;

Line 189: IF NOT ota_tcc_shd.api_updating

185: --
186: -- Only proceed with the validation if a row exists for the current
187: -- record in the HR Schema.
188: --
189: IF NOT ota_tcc_shd.api_updating
190: (p_cross_charge_id => p_rec.cross_charge_id
191: ,p_object_version_number => p_rec.object_version_number
192: ) THEN
193: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 255: (nvl(ota_tcc_shd.g_old_rec.start_date_active,hr_api.g_date) <>

251: Begin
252: hr_utility.set_location(' entering:'||l_proc, 10);
253:
254: if (((p_cross_charge_id is not null) and
255: (nvl(ota_tcc_shd.g_old_rec.start_date_active,hr_api.g_date) <>
256: nvl(p_start_date_active,hr_api.g_date) or
257: nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>
258: nvl(p_end_date_active,hr_api.g_date)) )
259: or (p_cross_charge_id is null)) then

Line 257: nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>

253:
254: if (((p_cross_charge_id is not null) and
255: (nvl(ota_tcc_shd.g_old_rec.start_date_active,hr_api.g_date) <>
256: nvl(p_start_date_active,hr_api.g_date) or
257: nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>
258: nvl(p_end_date_active,hr_api.g_date)) )
259: or (p_cross_charge_id is null)) then
260:
261: If ota_tcc_shd.g_old_rec.end_date_active is not null and

Line 261: If ota_tcc_shd.g_old_rec.end_date_active is not null and

257: nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>
258: nvl(p_end_date_active,hr_api.g_date)) )
259: or (p_cross_charge_id is null)) then
260:
261: If ota_tcc_shd.g_old_rec.end_date_active is not null and
262: nvl(p_end_date_active,hr_api.g_date) >
263: ota_tcc_shd.g_old_rec.end_date_active then
264:
265: fnd_message.set_name('OTA','OTA_13348_TCC_EXT_END_DATE');

Line 263: ota_tcc_shd.g_old_rec.end_date_active then

259: or (p_cross_charge_id is null)) then
260:
261: If ota_tcc_shd.g_old_rec.end_date_active is not null and
262: nvl(p_end_date_active,hr_api.g_date) >
263: ota_tcc_shd.g_old_rec.end_date_active then
264:
265: fnd_message.set_name('OTA','OTA_13348_TCC_EXT_END_DATE');
266: fnd_message.raise_error;
267:

Line 299: (nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>

295: Begin
296: hr_utility.set_location(' entering:'||l_proc, 10);
297:
298: if (((p_cross_charge_id is not null) and
299: (nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>
300: nvl(p_end_date_active,hr_api.g_date)))
301: or (p_cross_charge_id is null)) then
302:
303: If ota_tcc_shd.g_old_rec.end_date_active is not null and

Line 303: If ota_tcc_shd.g_old_rec.end_date_active is not null and

299: (nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>
300: nvl(p_end_date_active,hr_api.g_date)))
301: or (p_cross_charge_id is null)) then
302:
303: If ota_tcc_shd.g_old_rec.end_date_active is not null and
304: nvl(p_end_date_active,hr_api.g_date) >
305: ota_tcc_shd.g_old_rec.end_date_active then
306:
307: fnd_message.set_name('OTA','OTA_13348_TCC_EXT_END_DATE');

Line 305: ota_tcc_shd.g_old_rec.end_date_active then

301: or (p_cross_charge_id is null)) then
302:
303: If ota_tcc_shd.g_old_rec.end_date_active is not null and
304: nvl(p_end_date_active,hr_api.g_date) >
305: ota_tcc_shd.g_old_rec.end_date_active then
306:
307: fnd_message.set_name('OTA','OTA_13348_TCC_EXT_END_DATE');
308: fnd_message.raise_error;
309:

Line 337: nvl(ota_tcc_shd.g_old_rec.type,hr_api.g_varchar2) <>

333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334:
335:
336: if (((p_cross_charge_id is not null) and
337: nvl(ota_tcc_shd.g_old_rec.type,hr_api.g_varchar2) <>
338: nvl(p_type,hr_api.g_varchar2))
339: or
340: (p_cross_charge_id is null)) then
341:

Line 383: nvl(ota_tcc_shd.g_old_rec.from_to,hr_api.g_varchar2) <>

379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380:
381:
382: if (((p_cross_charge_id is not null) and
383: nvl(ota_tcc_shd.g_old_rec.from_to,hr_api.g_varchar2) <>
384: nvl(p_from_to,hr_api.g_varchar2))
385: or
386: (p_cross_charge_id is null)) then
387:

Line 417: ,p_rec in ota_tcc_shd.g_rec_type

413: -- |---------------------------< insert_validate >----------------------------|
414: -- ----------------------------------------------------------------------------
415: Procedure insert_validate
416: (p_effective_date in date
417: ,p_rec in ota_tcc_shd.g_rec_type
418: ) is
419: --
420: l_proc varchar2(72) := g_package||'insert_validate';
421: --

Line 458: ,p_rec in ota_tcc_shd.g_rec_type

454: -- |---------------------------< update_validate >----------------------------|
455: -- ----------------------------------------------------------------------------
456: Procedure update_validate
457: (p_effective_date in date
458: ,p_rec in ota_tcc_shd.g_rec_type
459: ) is
460: --
461: l_proc varchar2(72) := g_package||'update_validate';
462: --

Line 507: (p_rec in ota_tcc_shd.g_rec_type

503: -- ----------------------------------------------------------------------------
504: -- |---------------------------< delete_validate >----------------------------|
505: -- ----------------------------------------------------------------------------
506: Procedure delete_validate
507: (p_rec in ota_tcc_shd.g_rec_type
508: ) is
509: --
510: l_proc varchar2(72) := g_package||'delete_validate';
511: --