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 871: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE

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

Line 875: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE DEFAULT NULL;

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

Line 1310: FROM ota_booking_status_types os,

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

Line 1323: FROM ota_booking_status_types os,

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

Line 1403: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

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

Line 1404: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;

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

Line 2593: RETURN ota_booking_status_types.booking_status_type_id%type

2589: --
2590: -- Description: Retrieves the default cancellation enrollment status id
2591: --
2592: Function getCancellationStatusId
2593: RETURN ota_booking_status_types.booking_status_type_id%type
2594: IS
2595: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
2596: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
2597: l_proc VARCHAR2(72) := g_package || 'getCancellationStatusId';

Line 2595: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

2591: --
2592: Function getCancellationStatusId
2593: RETURN ota_booking_status_types.booking_status_type_id%type
2594: IS
2595: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
2596: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
2597: l_proc VARCHAR2(72) := g_package || 'getCancellationStatusId';
2598: Begin
2599:

Line 2596: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;

2592: Function getCancellationStatusId
2593: RETURN ota_booking_status_types.booking_status_type_id%type
2594: IS
2595: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
2596: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
2597: l_proc VARCHAR2(72) := g_package || 'getCancellationStatusId';
2598: Begin
2599:
2600: l_booking_status_row := Get_Booking_Status_for_web