APPS.OTA_ENROLL_REVIEW_SS dependencies on OTA_BOOKING_STATUS_TYPES

Line 888: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

884: PROCEDURE process_api2
885: (p_validate IN BOOLEAN,p_transaction_step_id IN NUMBER) IS
886:
887: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
888: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
889: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
890: l_eventid ota_events.event_id%TYPE;
891: l_object_version_number number;
892: l_person_details OTA_trng_enroll_SS.csr_person_to_enroll_details%ROWTYPE;

Line 994: OTA_BOOKING_STATUS_TYPES bst

990:
991: CURSOR get_existing_internal IS
992: SELECT count(*)
993: FROM OTA_DELEGATE_BOOKINGS dbt,
994: OTA_BOOKING_STATUS_TYPES bst
995: WHERE dbt.event_id = l_eventid
996: AND dbt.internal_booking_flag = 'Y'
997: AND dbt.booking_status_type_id = bst.booking_status_type_id
998: AND bst.type in ('P','A','E');

Line 1007: FROM ota_booking_status_types os,

1003: ,p_person_id IN NUMBER) IS
1004: SELECT ov.booking_id,
1005: ov.date_booking_placed,
1006: ov.object_version_number
1007: FROM ota_booking_status_types os,
1008: ota_delegate_bookings ov
1009: WHERE ov.event_id = p_event_id
1010: AND ov.delegate_person_id = p_person_id
1011: AND os.booking_status_type_id = ov.booking_status_type_id

Line 1784: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

1780: l_transaction_step_id number;
1781: l_eventid ota_events.event_id%TYPE;
1782: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1783: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
1784: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1785: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1786: l_object_version_number number;
1787: l_date_booking_placed date;
1788: l_current_date date;

Line 1801: FROM ota_booking_status_types os,

1797: SELECT ov.booking_id,
1798: ov.date_booking_placed,
1799: ov.object_version_number,
1800: ov.business_group_id
1801: FROM ota_booking_status_types os,
1802: ota_delegate_bookings ov
1803: WHERE ov.event_id = p_event_id
1804: AND ov.delegate_person_id = p_person_id
1805: AND os.booking_status_type_id = ov.booking_status_type_id