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_SHD dependencies on OTA_DELEGATE_BOOKINGS

Line 12: delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,

8: Type g_rec_type Is Record
9: (
10: booking_id number(9),
11: booking_status_type_id number(9),
12: delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
13: contact_id number(15),
14: business_group_id number(9),
15: event_id number(9),
16: customer_id number(15),

Line 17: authorizer_person_id ota_delegate_bookings.authorizer_person_id%TYPE,

13: contact_id number(15),
14: business_group_id number(9),
15: event_id number(9),
16: customer_id number(15),
17: authorizer_person_id ota_delegate_bookings.authorizer_person_id%TYPE,
18: date_booking_placed date,
19: corespondent varchar2(30),
20: internal_booking_flag varchar2(30),
21: number_of_places number(9),

Line 67: sponsor_person_id ota_delegate_bookings.sponsor_person_id%TYPE,

63: tdb_information18 varchar2(150),
64: tdb_information19 varchar2(150),
65: tdb_information20 varchar2(150),
66: organization_id number(15),
67: sponsor_person_id ota_delegate_bookings.sponsor_person_id%TYPE,
68: sponsor_assignment_id ota_delegate_bookings.sponsor_assignment_id%TYPE,
69: person_address_id number(15),
70: delegate_assignment_id ota_delegate_bookings.delegate_assignment_id%TYPE,
71: delegate_contact_id number(15),

Line 68: sponsor_assignment_id ota_delegate_bookings.sponsor_assignment_id%TYPE,

64: tdb_information19 varchar2(150),
65: tdb_information20 varchar2(150),
66: organization_id number(15),
67: sponsor_person_id ota_delegate_bookings.sponsor_person_id%TYPE,
68: sponsor_assignment_id ota_delegate_bookings.sponsor_assignment_id%TYPE,
69: person_address_id number(15),
70: delegate_assignment_id ota_delegate_bookings.delegate_assignment_id%TYPE,
71: delegate_contact_id number(15),
72: delegate_contact_email varchar2(240),

Line 70: delegate_assignment_id ota_delegate_bookings.delegate_assignment_id%TYPE,

66: organization_id number(15),
67: sponsor_person_id ota_delegate_bookings.sponsor_person_id%TYPE,
68: sponsor_assignment_id ota_delegate_bookings.sponsor_assignment_id%TYPE,
69: person_address_id number(15),
70: delegate_assignment_id ota_delegate_bookings.delegate_assignment_id%TYPE,
71: delegate_contact_id number(15),
72: delegate_contact_email varchar2(240),
73: third_party_email varchar2(240),
74: person_address_type varchar2(30),

Line 89: ,sign_eval_status ota_delegate_bookings.sign_eval_status%TYPE,

85: completed_content number ,
86: total_content number,
87: booking_justification_id number(15)
88: ,is_history_flag varchar2(9)
89: ,sign_eval_status ota_delegate_bookings.sign_eval_status%TYPE,
90: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE
91: );
92: --
93: -- ----------------------------------------------------------------------------

Line 90: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE

86: total_content number,
87: booking_justification_id number(15)
88: ,is_history_flag varchar2(9)
89: ,sign_eval_status ota_delegate_bookings.sign_eval_status%TYPE,
90: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE
91: );
92: --
93: -- ----------------------------------------------------------------------------
94: -- | Global Definitions - Internal Development Use Only |