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_GENERAL

Line 424: if not ota_general.check_fnd_user(p_person_id) then

420: --
421: procedure check_authorizer (p_person_id in number) is
422: begin
423: if p_person_id is not null then
424: if not ota_general.check_fnd_user(p_person_id) then
425: fnd_message.set_name ('OTA', 'OTA_13281_TFH_AUTHORIZER');
426: fnd_message.raise_error;
427: end if;
428: end if;

Line 496: l_return := ota_general.check_person (p_person_id ,p_date);

492: close c_external;
493: end if;
494: --
495: else
496: l_return := ota_general.check_person (p_person_id ,p_date);
497: end if;
498: --
499: return l_return;
500: --

Line 1634: Return (ota_general.check_current_employee (p_person_id,

1630: if p_person_id is not null and p_internal_booking_flag = 'Y' then
1631: --
1632: -- the person must be a current employee on the date the booking is made
1633: --
1634: Return (ota_general.check_current_employee (p_person_id,
1635: p_date_booking_placed));
1636: else
1637: --
1638: Return (True);

Line 2821: -- l_business_group_id := ota_general.get_business_group_id;

2817: where event_id = p_event_id;
2818: --
2819: BEGIN
2820: --Modified for Bug#3007934
2821: -- l_business_group_id := ota_general.get_business_group_id;
2822: OPEN csr_get_business_group_id;
2823: FETCH csr_get_business_group_id INTO l_business_group_id;
2824: CLOSE csr_get_business_group_id;
2825:

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 3748: ota_general.check_domain_value ('PRIORITY_LEVEL', p_rec.booking_priority);

3744: -- check that the priority is within the domain 'Priority Level'
3745: --
3746: if p_rec.booking_priority is not null then
3747: --
3748: ota_general.check_domain_value ('PRIORITY_LEVEL', p_rec.booking_priority);
3749: --
3750: end if;
3751: --
3752: --

Line 3757: ota_general.check_domain_value ('BOOKING_SOURCE', p_rec.source_of_booking);

3753: -- check that the source is within the domain 'Booking Source'
3754: --
3755: if p_rec.source_of_booking is not null then
3756: --
3757: ota_general.check_domain_value ('BOOKING_SOURCE', p_rec.source_of_booking);
3758: --
3759: end if;
3760: --
3761: -- check that the number of places is one for a delegate

Line 3858: ota_general.check_domain_value ('DELEGATE_FAILURE_REASON',

3854: -- Reason'
3855: --
3856: if p_rec.failure_reason is not null then
3857: --
3858: ota_general.check_domain_value ('DELEGATE_FAILURE_REASON',
3859: p_rec.failure_reason);
3860: --
3861: end if;
3862: --

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 4311: ota_general.check_domain_value ('PRIORITY_LEVEL', p_rec.booking_priority);

4307: -- check that the priority is within the domain 'Priority Level'
4308: --
4309: if l_booking_priority_changed and p_rec.booking_priority is not null then
4310: --
4311: ota_general.check_domain_value ('PRIORITY_LEVEL', p_rec.booking_priority);
4312: --
4313: end if;
4314: --
4315: --

Line 4320: ota_general.check_domain_value ('BOOKING_SOURCE', p_rec.source_of_booking);

4316: -- check that the source is within the domain 'Booking Source'
4317: --
4318: if l_source_of_booking_changed and p_rec.source_of_booking is not null then
4319: --
4320: ota_general.check_domain_value ('BOOKING_SOURCE', p_rec.source_of_booking);
4321: --
4322: end if;
4323: --
4324: --

Line 4341: ota_general.check_domain_value ('DELEGATE_FAILURE_REASON',

4337: -- Reason'
4338: --
4339: if l_failure_reason_changed and p_rec.failure_reason is not null then
4340: --
4341: ota_general.check_domain_value ('DELEGATE_FAILURE_REASON',
4342: p_rec.failure_reason);
4343: --
4344: end if;
4345: --