eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TDB_BUS dependencies on OTA_TDB_SHD

Line 67: p_rec in ota_tdb_shd.g_rec_type

63: -- {End Of Comments}
64: -- ----------------------------------------------------------------------------
65: Procedure chk_non_updateable_args
66: (
67: p_rec in ota_tdb_shd.g_rec_type
68: ) IS
69: --
70: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
71: l_error EXCEPTION;

Line 79: IF NOT ota_tdb_shd.api_updating

75: --
76: -- Only proceed with the validation if a row exists for the current
77: -- record in the HR Schema.
78: --
79: IF NOT ota_tdb_shd.api_updating
80: (p_booking_id => p_rec.booking_id
81: ,p_object_version_number => p_rec.object_version_number
82: ) THEN
83: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 90: nvl(ota_tdb_shd.g_old_rec.business_group_id,hr_api.g_number)

86: fnd_message.raise_error;
87: END IF;
88:
89: if nvl(p_rec.business_group_id,hr_api.g_number) <>
90: nvl(ota_tdb_shd.g_old_rec.business_group_id,hr_api.g_number)
91: then
92: l_argument := 'business_group_id';
93: raise l_error;
94: end if;

Line 96: nvl(ota_tdb_shd.g_old_rec.Line_id,hr_api.g_number)

92: l_argument := 'business_group_id';
93: raise l_error;
94: end if;
95: /* if nvl(p_rec.line_id,hr_api.g_number) <>
96: nvl(ota_tdb_shd.g_old_rec.Line_id,hr_api.g_number)
97: then
98: l_argument := 'Line_id';
99: raise l_error;
100: end if;*/

Line 3031: l_event_id number := ota_tdb_shd.g_old_rec.event_id;

3027: -- deleted.
3028: --
3029: Procedure check_pmm_enrollments is
3030: --
3031: l_event_id number := ota_tdb_shd.g_old_rec.event_id;
3032: l_customer_id number := ota_tdb_shd.g_old_rec.customer_id;
3033: l_organization_id number := ota_tdb_shd.g_old_rec.organization_id;
3034: l_delegate_person_id number := ota_tdb_shd.g_old_rec.delegate_person_id;
3035: l_delegate_contact_id number := ota_tdb_shd.g_old_rec.delegate_contact_id;

Line 3032: l_customer_id number := ota_tdb_shd.g_old_rec.customer_id;

3028: --
3029: Procedure check_pmm_enrollments is
3030: --
3031: l_event_id number := ota_tdb_shd.g_old_rec.event_id;
3032: l_customer_id number := ota_tdb_shd.g_old_rec.customer_id;
3033: l_organization_id number := ota_tdb_shd.g_old_rec.organization_id;
3034: l_delegate_person_id number := ota_tdb_shd.g_old_rec.delegate_person_id;
3035: l_delegate_contact_id number := ota_tdb_shd.g_old_rec.delegate_contact_id;
3036: l_proc varchar2(72) := g_package||'check_pmm_enrollments';

Line 3033: l_organization_id number := ota_tdb_shd.g_old_rec.organization_id;

3029: Procedure check_pmm_enrollments is
3030: --
3031: l_event_id number := ota_tdb_shd.g_old_rec.event_id;
3032: l_customer_id number := ota_tdb_shd.g_old_rec.customer_id;
3033: l_organization_id number := ota_tdb_shd.g_old_rec.organization_id;
3034: l_delegate_person_id number := ota_tdb_shd.g_old_rec.delegate_person_id;
3035: l_delegate_contact_id number := ota_tdb_shd.g_old_rec.delegate_contact_id;
3036: l_proc varchar2(72) := g_package||'check_pmm_enrollments';
3037: l_result number;

Line 3034: l_delegate_person_id number := ota_tdb_shd.g_old_rec.delegate_person_id;

3030: --
3031: l_event_id number := ota_tdb_shd.g_old_rec.event_id;
3032: l_customer_id number := ota_tdb_shd.g_old_rec.customer_id;
3033: l_organization_id number := ota_tdb_shd.g_old_rec.organization_id;
3034: l_delegate_person_id number := ota_tdb_shd.g_old_rec.delegate_person_id;
3035: l_delegate_contact_id number := ota_tdb_shd.g_old_rec.delegate_contact_id;
3036: l_proc varchar2(72) := g_package||'check_pmm_enrollments';
3037: l_result number;
3038:

Line 3035: l_delegate_contact_id number := ota_tdb_shd.g_old_rec.delegate_contact_id;

3031: l_event_id number := ota_tdb_shd.g_old_rec.event_id;
3032: l_customer_id number := ota_tdb_shd.g_old_rec.customer_id;
3033: l_organization_id number := ota_tdb_shd.g_old_rec.organization_id;
3034: l_delegate_person_id number := ota_tdb_shd.g_old_rec.delegate_person_id;
3035: l_delegate_contact_id number := ota_tdb_shd.g_old_rec.delegate_contact_id;
3036: l_proc varchar2(72) := g_package||'check_pmm_enrollments';
3037: l_result number;
3038:
3039: cursor c_pmm_int_enrollments is

Line 3125: nvl(ota_tdb_shd.g_old_rec.line_id,hr_api.g_number) <>

3121: Begin
3122: hr_utility.set_location('Entering:'||l_proc, 5);
3123:
3124: if (((p_booking_id is not null) and
3125: nvl(ota_tdb_shd.g_old_rec.line_id,hr_api.g_number) <>
3126: nvl(p_line_id,hr_api.g_number))
3127: or (p_booking_id is null)) then
3128: --
3129: hr_utility.set_location('Entering:'||l_proc, 10);

Line 3189: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,

3185:
3186: l_proc varchar2(72) := g_package||'chk_status_changed';
3187:
3188: l_booking_status_changed boolean :=
3189: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,
3190: p_status_type_id);
3191: l_status_type ota_booking_status_types.type%type;
3192: l_old_status_type ota_booking_status_types.type%type;
3193: l_invoice_rule varchar2(80);

Line 3221: p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,

3217: p_line_id => p_line_id,
3218: p_invoice_rule => l_invoice_rule);*/
3219:
3220: ota_utility.get_booking_status_type(
3221: p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
3222: p_type => l_old_status_type) ;
3223: IF p_status_type_id is not null THEN
3224: ota_utility.get_booking_status_type(
3225: p_status_type_id => p_status_type_id,

Line 3327: p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,

3323: ELSIF p_line_id is null THEN
3324: IF l_booking_status_changed THEN
3325:
3326: ota_utility.get_booking_status_type(
3327: p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
3328: p_type => l_old_status_type) ;
3329:
3330: IF p_status_type_id is not null THEN
3331: ota_utility.get_booking_status_type(

Line 3444: ota_utility.get_booking_status_type(ota_tdb_shd.g_old_rec.booking_status_type_id,l_old_bst);

3440:
3441: BEGIN
3442: IF p_booking_status_type_id <> hr_api.g_number THEN
3443: ota_utility.get_booking_status_type(p_booking_status_type_id,l_bkng_status_type);
3444: ota_utility.get_booking_status_type(ota_tdb_shd.g_old_rec.booking_status_type_id,l_old_bst);
3445:
3446: IF l_bkng_status_type = 'A'
3447: OR l_old_bst not in('A','E') THEN RETURN; END IF;--Added for 6989133.
3448:

Line 3450: l_event_id := ota_tdb_shd.g_old_rec.event_id;

3446: IF l_bkng_status_type = 'A'
3447: OR l_old_bst not in('A','E') THEN RETURN; END IF;--Added for 6989133.
3448:
3449: IF p_event_id = hr_api.g_number THEN
3450: l_event_id := ota_tdb_shd.g_old_rec.event_id;
3451: END IF;
3452:
3453: OPEN csr_get_class_type(l_event_id);
3454: FETCH csr_get_class_type INTO l_lo_id, l_online_flag, l_imported_off_id;

Line 3463: l_player_status := ota_tdb_shd.g_old_rec.content_player_status;

3459: -- Add logic to check performance status and throw error acc.
3460: IF l_imported_off_id IS NOT NULL THEN
3461: -- Imported class. Performance data to be fetched from TDB table
3462: IF l_player_status = hr_api.g_varchar2 THEN
3463: l_player_status := ota_tdb_shd.g_old_rec.content_player_status;
3464: ELSE
3465: l_player_status := p_content_player_status;
3466: END IF;
3467: ELSE

Line 3470: l_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;

3466: END IF;
3467: ELSE
3468: -- Performance to be fetched from OTA_PERFORMANCES
3469: IF l_contact_id = hr_api.g_number THEN
3470: l_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;
3471: END IF;
3472: IF l_person_id = hr_api.g_number THEN
3473: l_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;
3474: END IF;

Line 3473: l_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;

3469: IF l_contact_id = hr_api.g_number THEN
3470: l_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;
3471: END IF;
3472: IF l_person_id = hr_api.g_number THEN
3473: l_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;
3474: END IF;
3475:
3476: IF l_person_id IS NOT NULL THEN
3477: OPEN csr_get_performance_data(l_person_id, 'E', l_lo_id);

Line 3529: (p_rec IN ota_tdb_shd.g_rec_type

3525: -- Internal Row Handler Use Only.
3526: --
3527: -- ----------------------------------------------------------------------------
3528: PROCEDURE chk_df
3529: (p_rec IN ota_tdb_shd.g_rec_type
3530: ) IS
3531: --
3532: l_proc varchar2(72) := g_package || 'chk_df';
3533: --

Line 3538: NVL(ota_tdb_shd.g_old_rec.tdb_information_category, hr_api.g_varchar2) <>

3534: BEGIN
3535: hr_utility.set_location('Entering:'||l_proc,10);
3536: --
3537: IF ((p_rec.booking_id IS NOT NULL) AND (
3538: NVL(ota_tdb_shd.g_old_rec.tdb_information_category, hr_api.g_varchar2) <>
3539: NVL(p_rec.tdb_information_category, hr_api.g_varchar2) OR
3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>
3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR
3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>

Line 3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>

3536: --
3537: IF ((p_rec.booking_id IS NOT NULL) AND (
3538: NVL(ota_tdb_shd.g_old_rec.tdb_information_category, hr_api.g_varchar2) <>
3539: NVL(p_rec.tdb_information_category, hr_api.g_varchar2) OR
3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>
3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR
3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>
3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR
3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>

Line 3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>

3538: NVL(ota_tdb_shd.g_old_rec.tdb_information_category, hr_api.g_varchar2) <>
3539: NVL(p_rec.tdb_information_category, hr_api.g_varchar2) OR
3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>
3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR
3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>
3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR
3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>
3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR
3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>

Line 3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>

3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>
3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR
3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>
3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR
3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>
3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR
3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>
3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR
3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>

Line 3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>

3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>
3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR
3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>
3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR
3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>
3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR
3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>
3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR
3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>

Line 3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>

3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>
3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR
3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>
3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR
3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>
3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR
3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>
3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR
3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>

Line 3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>

3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>
3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR
3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>
3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR
3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>
3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR
3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>
3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR
3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>

Line 3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>

3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>
3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR
3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>
3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR
3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>
3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR
3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>
3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR
3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>

Line 3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>

3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>
3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR
3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>
3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR
3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>
3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR
3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>
3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR
3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>

Line 3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>

3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>
3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR
3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>
3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR
3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>
3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR
3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>
3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR
3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>

Line 3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>

3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>
3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR
3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>
3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR
3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>
3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR
3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>
3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR
3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>

Line 3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>

3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>
3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR
3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>
3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR
3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>
3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR
3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>
3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR
3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>

Line 3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>

3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>
3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR
3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>
3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR
3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>
3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR
3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>
3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR
3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>

Line 3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>

3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>
3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR
3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>
3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR
3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>
3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR
3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>
3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR
3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>

Line 3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>

3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>
3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR
3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>
3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR
3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>
3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR
3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>
3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR
3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>

Line 3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>

3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>
3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR
3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>
3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR
3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>
3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR
3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>
3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR
3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>

Line 3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>

3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>
3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR
3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>
3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR
3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>
3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR
3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>
3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR
3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>

Line 3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>

3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>
3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR
3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>
3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR
3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>
3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR
3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>
3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR
3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>

Line 3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>

3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>
3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR
3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>
3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR
3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>
3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR
3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>
3577: NVL(p_rec.tdb_information19, hr_api.g_varchar2) OR
3578: NVL(ota_tdb_shd.g_old_rec.tdb_information20, hr_api.g_varchar2) <>

Line 3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>

3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>
3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR
3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>
3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR
3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>
3577: NVL(p_rec.tdb_information19, hr_api.g_varchar2) OR
3578: NVL(ota_tdb_shd.g_old_rec.tdb_information20, hr_api.g_varchar2) <>
3579: NVL(p_rec.tdb_information20, hr_api.g_varchar2) ) )
3580: OR (p_rec.booking_id IS NULL) THEN

Line 3578: NVL(ota_tdb_shd.g_old_rec.tdb_information20, hr_api.g_varchar2) <>

3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>
3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR
3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>
3577: NVL(p_rec.tdb_information19, hr_api.g_varchar2) OR
3578: NVL(ota_tdb_shd.g_old_rec.tdb_information20, hr_api.g_varchar2) <>
3579: NVL(p_rec.tdb_information20, hr_api.g_varchar2) ) )
3580: OR (p_rec.booking_id IS NULL) THEN
3581: --
3582: -- Only execute the validation if absolutely necessary:

Line 3647: p_rec in ota_tdb_shd.g_rec_type,

3643: --
3644: -- Description: Controls the validation execution on insert.
3645: --
3646: Procedure insert_validate(
3647: p_rec in ota_tdb_shd.g_rec_type,
3648: p_enrollment_type in varchar2
3649: ) is
3650: --
3651: l_proc varchar2(72) := g_package||'insert_validate';

Line 3920: p_rec in ota_tdb_shd.g_rec_type,

3916: --
3917: -- Description: Controls the validation execution on update.
3918: --
3919: Procedure update_validate(
3920: p_rec in ota_tdb_shd.g_rec_type,
3921: p_enrollment_type in varchar2
3922: ) is
3923: --
3924: l_proc varchar2(72) := g_package||'update_validate';

Line 3927: ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id,

3923: --
3924: l_proc varchar2(72) := g_package||'update_validate';
3925: --
3926: l_customer_id_changed boolean :=
3927: ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id,
3928: p_rec.customer_id);
3929: --
3930: l_status_type_id_changed boolean :=
3931: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,

Line 3931: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,

3927: ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id,
3928: p_rec.customer_id);
3929: --
3930: l_status_type_id_changed boolean :=
3931: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,
3932: p_rec.booking_status_type_id);
3933: --
3934: l_event_id_changed boolean :=
3935: ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id,

Line 3935: ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id,

3931: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,
3932: p_rec.booking_status_type_id);
3933: --
3934: l_event_id_changed boolean :=
3935: ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id,
3936: p_rec.event_id);
3937: --
3938: l_business_group_id_changed boolean :=
3939: ota_general.value_changed (ota_tdb_shd.g_old_rec.business_group_id,

Line 3939: ota_general.value_changed (ota_tdb_shd.g_old_rec.business_group_id,

3935: ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id,
3936: p_rec.event_id);
3937: --
3938: l_business_group_id_changed boolean :=
3939: ota_general.value_changed (ota_tdb_shd.g_old_rec.business_group_id,
3940: p_rec.business_group_id);
3941: --
3942: l_date_booking_placed_changed boolean :=
3943: ota_general.value_changed (ota_tdb_shd.g_old_rec.date_booking_placed,

Line 3943: ota_general.value_changed (ota_tdb_shd.g_old_rec.date_booking_placed,

3939: ota_general.value_changed (ota_tdb_shd.g_old_rec.business_group_id,
3940: p_rec.business_group_id);
3941: --
3942: l_date_booking_placed_changed boolean :=
3943: ota_general.value_changed (ota_tdb_shd.g_old_rec.date_booking_placed,
3944: p_rec.date_booking_placed);
3945: --
3946: l_delegate_person_id_changed boolean :=
3947: ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id,

Line 3947: ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id,

3943: ota_general.value_changed (ota_tdb_shd.g_old_rec.date_booking_placed,
3944: p_rec.date_booking_placed);
3945: --
3946: l_delegate_person_id_changed boolean :=
3947: ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id,
3948: p_rec.delegate_person_id);
3949: --
3950: l_sponsor_person_id_changed boolean :=
3951: ota_general.value_changed (ota_tdb_shd.g_old_rec.sponsor_person_id,

Line 3951: ota_general.value_changed (ota_tdb_shd.g_old_rec.sponsor_person_id,

3947: ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id,
3948: p_rec.delegate_person_id);
3949: --
3950: l_sponsor_person_id_changed boolean :=
3951: ota_general.value_changed (ota_tdb_shd.g_old_rec.sponsor_person_id,
3952: p_rec.sponsor_person_id);
3953: --
3954: l_organization_id_changed boolean :=
3955: ota_general.value_changed (ota_tdb_shd.g_old_rec.organization_id,

Line 3955: ota_general.value_changed (ota_tdb_shd.g_old_rec.organization_id,

3951: ota_general.value_changed (ota_tdb_shd.g_old_rec.sponsor_person_id,
3952: p_rec.sponsor_person_id);
3953: --
3954: l_organization_id_changed boolean :=
3955: ota_general.value_changed (ota_tdb_shd.g_old_rec.organization_id,
3956: p_rec.organization_id);
3957: --
3958: l_contact_id_changed boolean :=
3959: ota_general.value_changed (ota_tdb_shd.g_old_rec.contact_id,

Line 3959: ota_general.value_changed (ota_tdb_shd.g_old_rec.contact_id,

3955: ota_general.value_changed (ota_tdb_shd.g_old_rec.organization_id,
3956: p_rec.organization_id);
3957: --
3958: l_contact_id_changed boolean :=
3959: ota_general.value_changed (ota_tdb_shd.g_old_rec.contact_id,
3960: p_rec.contact_id);
3961: --
3962: l_contact_address_id_changed boolean :=
3963: ota_general.value_changed (ota_tdb_shd.g_old_rec.contact_address_id,

Line 3963: ota_general.value_changed (ota_tdb_shd.g_old_rec.contact_address_id,

3959: ota_general.value_changed (ota_tdb_shd.g_old_rec.contact_id,
3960: p_rec.contact_id);
3961: --
3962: l_contact_address_id_changed boolean :=
3963: ota_general.value_changed (ota_tdb_shd.g_old_rec.contact_address_id,
3964: p_rec.contact_address_id);
3965: --
3966: l_authorizer_person_id_changed boolean :=
3967: ota_general.value_changed (ota_tdb_shd.g_old_rec.authorizer_person_id,

Line 3967: ota_general.value_changed (ota_tdb_shd.g_old_rec.authorizer_person_id,

3963: ota_general.value_changed (ota_tdb_shd.g_old_rec.contact_address_id,
3964: p_rec.contact_address_id);
3965: --
3966: l_authorizer_person_id_changed boolean :=
3967: ota_general.value_changed (ota_tdb_shd.g_old_rec.authorizer_person_id,
3968: p_rec.authorizer_person_id);
3969: --
3970: l_number_of_places_changed boolean :=
3971: ota_general.value_changed (ota_tdb_shd.g_old_rec.number_of_places,

Line 3971: ota_general.value_changed (ota_tdb_shd.g_old_rec.number_of_places,

3967: ota_general.value_changed (ota_tdb_shd.g_old_rec.authorizer_person_id,
3968: p_rec.authorizer_person_id);
3969: --
3970: l_number_of_places_changed boolean :=
3971: ota_general.value_changed (ota_tdb_shd.g_old_rec.number_of_places,
3972: p_rec.number_of_places);
3973: --
3974: l_delegate_ass_changed boolean :=
3975: ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_assignment_id,

Line 3975: ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_assignment_id,

3971: ota_general.value_changed (ota_tdb_shd.g_old_rec.number_of_places,
3972: p_rec.number_of_places);
3973: --
3974: l_delegate_ass_changed boolean :=
3975: ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_assignment_id,
3976: p_rec.delegate_assignment_id);
3977: --
3978: l_sponsor_ass_changed boolean :=
3979: ota_general.value_changed (ota_tdb_shd.g_old_rec.sponsor_assignment_id,

Line 3979: ota_general.value_changed (ota_tdb_shd.g_old_rec.sponsor_assignment_id,

3975: ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_assignment_id,
3976: p_rec.delegate_assignment_id);
3977: --
3978: l_sponsor_ass_changed boolean :=
3979: ota_general.value_changed (ota_tdb_shd.g_old_rec.sponsor_assignment_id,
3980: p_rec.sponsor_assignment_id);
3981: --
3982: l_booking_priority_changed boolean :=
3983: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_priority,

Line 3983: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_priority,

3979: ota_general.value_changed (ota_tdb_shd.g_old_rec.sponsor_assignment_id,
3980: p_rec.sponsor_assignment_id);
3981: --
3982: l_booking_priority_changed boolean :=
3983: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_priority,
3984: p_rec.booking_priority);
3985: --
3986: l_person_address_id_changed boolean :=
3987: ota_general.value_changed (ota_tdb_shd.g_old_rec.person_address_id,

Line 3987: ota_general.value_changed (ota_tdb_shd.g_old_rec.person_address_id,

3983: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_priority,
3984: p_rec.booking_priority);
3985: --
3986: l_person_address_id_changed boolean :=
3987: ota_general.value_changed (ota_tdb_shd.g_old_rec.person_address_id,
3988: p_rec.person_address_id);
3989: --
3990: l_attendance_flag_changed boolean :=
3991: ota_general.value_changed (ota_tdb_shd.g_old_rec.successful_attendance_flag,

Line 3991: ota_general.value_changed (ota_tdb_shd.g_old_rec.successful_attendance_flag,

3987: ota_general.value_changed (ota_tdb_shd.g_old_rec.person_address_id,
3988: p_rec.person_address_id);
3989: --
3990: l_attendance_flag_changed boolean :=
3991: ota_general.value_changed (ota_tdb_shd.g_old_rec.successful_attendance_flag,
3992: p_rec.successful_attendance_flag);
3993: --
3994: l_source_of_booking_changed boolean :=
3995: ota_general.value_changed (ota_tdb_shd.g_old_rec.source_of_booking,

Line 3995: ota_general.value_changed (ota_tdb_shd.g_old_rec.source_of_booking,

3991: ota_general.value_changed (ota_tdb_shd.g_old_rec.successful_attendance_flag,
3992: p_rec.successful_attendance_flag);
3993: --
3994: l_source_of_booking_changed boolean :=
3995: ota_general.value_changed (ota_tdb_shd.g_old_rec.source_of_booking,
3996: p_rec.source_of_booking);
3997: --
3998: l_failure_reason_changed boolean :=
3999: ota_general.value_changed (ota_tdb_shd.g_old_rec.failure_reason,

Line 3999: ota_general.value_changed (ota_tdb_shd.g_old_rec.failure_reason,

3995: ota_general.value_changed (ota_tdb_shd.g_old_rec.source_of_booking,
3996: p_rec.source_of_booking);
3997: --
3998: l_failure_reason_changed boolean :=
3999: ota_general.value_changed (ota_tdb_shd.g_old_rec.failure_reason,
4000: p_rec.failure_reason);
4001: --
4002: l_delegate_contact_id_changed boolean :=
4003: ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id,

Line 4003: ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id,

3999: ota_general.value_changed (ota_tdb_shd.g_old_rec.failure_reason,
4000: p_rec.failure_reason);
4001: --
4002: l_delegate_contact_id_changed boolean :=
4003: ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id,
4004: p_rec.delegate_contact_id);
4005:
4006: l_old_event_id_changed boolean :=
4007: ota_general.value_changed (ota_tdb_shd.g_old_rec.old_event_id,

Line 4007: ota_general.value_changed (ota_tdb_shd.g_old_rec.old_event_id,

4003: ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id,
4004: p_rec.delegate_contact_id);
4005:
4006: l_old_event_id_changed boolean :=
4007: ota_general.value_changed (ota_tdb_shd.g_old_rec.old_event_id,
4008: p_rec.old_event_id);
4009: --
4010: l_event_record_use varchar2(10);
4011: --

Line 4423: OPEN get_inv_id (ota_tdb_shd.g_old_rec.event_id);

4419: /* Bug 4401588*/
4420: /* bug no 4509873 */
4421: -- Commented for bug#4874734
4422: -- IF p_rec.line_id is not null then
4423: OPEN get_inv_id (ota_tdb_shd.g_old_rec.event_id);
4424: FETCH get_inv_id INTO l_old_inv_id;
4425: CLOSE get_inv_id ;
4426: OPEN get_inv_id (p_rec.event_id);
4427: FETCH get_inv_id INTO l_new_inv_id;

Line 4456: ota_utility.get_booking_status_type( p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,

4452:
4453: -- Bug#5614187 - Enrollments can not be moved from cancelled status after enrollment
4454: -- period is over.
4455: IF l_status_type_id_changed THEN
4456: ota_utility.get_booking_status_type( p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
4457: p_type => l_status_type) ;
4458: IF l_status_type = 'C' THEN
4459: ota_utility.get_booking_status_type( p_status_type_id => p_rec.booking_status_type_id,
4460: p_type => l_status_type) ;

Line 4480: Procedure delete_validate(p_rec in ota_tdb_shd.g_rec_type) is

4476: -- ----------------------------------------------------------------------------
4477: --
4478: -- Description: Controls the validation execution on delete.
4479: --
4480: Procedure delete_validate(p_rec in ota_tdb_shd.g_rec_type) is
4481: --
4482: l_proc varchar2(72) := g_package||'delete_validate';
4483: --
4484: Begin

Line 4494: chk_Order_line_exist(ota_tdb_shd.g_old_rec.line_id

4490: --
4491: check_training_plan_costs(p_rec.booking_id);
4492: --
4493: -- Check if Line id is not null
4494: chk_Order_line_exist(ota_tdb_shd.g_old_rec.line_id
4495: ,ota_tdb_shd.g_old_rec.org_id) ;
4496: --
4497: -- check that no resources exist for the booking
4498: --

Line 4495: ,ota_tdb_shd.g_old_rec.org_id) ;

4491: check_training_plan_costs(p_rec.booking_id);
4492: --
4493: -- Check if Line id is not null
4494: chk_Order_line_exist(ota_tdb_shd.g_old_rec.line_id
4495: ,ota_tdb_shd.g_old_rec.org_id) ;
4496: --
4497: -- check that no resources exist for the booking
4498: --
4499: check_resources (p_rec.booking_id);