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_TRAINING_SS dependencies on OTA_BOOKING_STATUS_TYPES

Line 1338: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

1334: PROCEDURE process_api2
1335: (p_validate IN BOOLEAN,p_transaction_step_id IN NUMBER, p_effective_date in varchar2 ) IS
1336:
1337: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1338: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1339: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1340: l_eventid ota_events.event_id%TYPE;
1341: l_object_version_number number;
1342: l_person_details OTA_ENROLL_IN_TRAINING_SS.csr_person_to_enroll_details%ROWTYPE;

Line 1444: OTA_BOOKING_STATUS_TYPES bst

1440:
1441: CURSOR get_existing_internal IS
1442: SELECT count(*)
1443: FROM OTA_DELEGATE_BOOKINGS dbt,
1444: OTA_BOOKING_STATUS_TYPES bst
1445: WHERE dbt.event_id = l_eventid
1446: AND dbt.internal_booking_flag = 'Y'
1447: AND dbt.booking_status_type_id = bst.booking_status_type_id
1448: AND bst.type in ('P','A','E');

Line 1457: FROM ota_booking_status_types os,

1453: ,p_person_id IN NUMBER) IS
1454: SELECT ov.booking_id,
1455: ov.date_booking_placed,
1456: ov.object_version_number
1457: FROM ota_booking_status_types os,
1458: ota_delegate_bookings ov
1459: WHERE ov.event_id = p_event_id
1460: AND ov.delegate_person_id = p_person_id
1461: AND os.booking_status_type_id = ov.booking_status_type_id

Line 2258: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

2254: l_transaction_step_id number;
2255: l_eventid ota_events.event_id%TYPE;
2256: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
2257: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
2258: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
2259: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
2260: l_object_version_number number;
2261: l_date_booking_placed date;
2262: l_current_date date;

Line 2275: FROM ota_booking_status_types os,

2271: SELECT ov.booking_id,
2272: ov.date_booking_placed,
2273: ov.object_version_number,
2274: ov.business_group_id
2275: FROM ota_booking_status_types os,
2276: ota_delegate_bookings ov
2277: WHERE ov.event_id = p_event_id
2278: AND ov.delegate_person_id = p_person_id
2279: AND os.booking_status_type_id = ov.booking_status_type_id