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

Line 99: OTA_BOOKING_STATUS_TYPES bst

95:
96: CURSOR get_existing_internal IS
97: SELECT count(booking_id)
98: FROM OTA_DELEGATE_BOOKINGS dbt,
99: OTA_BOOKING_STATUS_TYPES bst
100: WHERE dbt.event_id = TO_NUMBER(p_event_id)
101: AND dbt.internal_booking_flag = 'Y'
102: AND dbt.booking_status_type_id = bst.booking_status_type_id
103: AND bst.type in ('P','A','E'); --Bug 4301617

Line 108: OTA_BOOKING_STATUS_TYPES bst

104:
105: CURSOR get_existing_bookings IS
106: SELECT sum(number_of_places)
107: FROM OTA_DELEGATE_BOOKINGS dbt,
108: OTA_BOOKING_STATUS_TYPES bst
109: WHERE dbt.event_id = TO_NUMBER(p_event_id)
110: AND dbt.booking_status_type_id = bst.booking_status_type_id
111: AND bst.type in ('P','A','E');
112:

Line 144: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

140: l_price_basis OTA_EVENTS.price_basis%TYPE;
141:
142: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
143: --
144: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
145: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
146: l_object_version_number BINARY_INTEGER;
147: l_tfl_ovn BINARY_INTEGER;
148: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;

Line 872: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE

868:
869:
870: FUNCTION Get_Booking_Status_For_Web (p_web_booking_status_type VARCHAR2
871: ,p_business_group_id NUMBER)
872: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE
873:
874: IS
875:
876: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE DEFAULT NULL;

Line 876: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE DEFAULT NULL;

872: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE
873:
874: IS
875:
876: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE DEFAULT NULL;
877:
878:
879: BEGIN
880:

Line 1311: FROM ota_booking_status_types os,

1307: (p_event_id IN NUMBER
1308: ,p_person_id IN NUMBER
1309: ,p_delegate_contact_id IN NUMBER) IS
1310: SELECT ov.booking_id
1311: FROM ota_booking_status_types os,
1312: ota_delegate_bookings ov
1313: WHERE ov.event_id = p_event_id
1314: AND (p_person_id IS NOT NULL AND ov.delegate_person_id = p_person_id
1315: OR p_delegate_contact_id IS NOT NULL and ov.delegate_contact_id = p_delegate_contact_id)

Line 1324: FROM ota_booking_status_types os,

1320: (p_event_id IN NUMBER
1321: ,p_person_id IN NUMBER
1322: ,p_delegate_contact_id IN NUMBER) IS
1323: SELECT ov.booking_id
1324: FROM ota_booking_status_types os,
1325: ota_delegate_bookings ov
1326: WHERE ov.event_id = p_event_id
1327: AND (p_person_id IS NOT NULL AND ov.delegate_person_id = p_person_id
1328: OR p_delegate_contact_id IS NOT NULL and ov.delegate_contact_id = p_delegate_contact_id)

Line 1404: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

1400: -- Added for External Learner support
1401: ,p_delegate_contact_id IN NUMBER
1402: ,p_booking_Clash OUT nocopy varchar2)
1403: IS
1404: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1405: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1406:
1407:
1408: Begin

Line 1405: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;

1401: ,p_delegate_contact_id IN NUMBER
1402: ,p_booking_Clash OUT nocopy varchar2)
1403: IS
1404: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1405: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1406:
1407:
1408: Begin
1409:

Line 2601: RETURN ota_booking_status_types.booking_status_type_id%type

2597: --
2598: -- Description: Retrieves the default cancellation enrollment status id
2599: --
2600: Function getCancellationStatusId
2601: RETURN ota_booking_status_types.booking_status_type_id%type
2602: IS
2603: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
2604: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
2605: l_proc VARCHAR2(72) := g_package || 'getCancellationStatusId';

Line 2603: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

2599: --
2600: Function getCancellationStatusId
2601: RETURN ota_booking_status_types.booking_status_type_id%type
2602: IS
2603: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
2604: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
2605: l_proc VARCHAR2(72) := g_package || 'getCancellationStatusId';
2606: Begin
2607:

Line 2604: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;

2600: Function getCancellationStatusId
2601: RETURN ota_booking_status_types.booking_status_type_id%type
2602: IS
2603: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
2604: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
2605: l_proc VARCHAR2(72) := g_package || 'getCancellationStatusId';
2606: Begin
2607:
2608: l_booking_status_row := Get_Booking_Status_for_web