APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on OTA_BOOKING_STATUS_TYPES

Line 966: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

962: (p_validate IN BOOLEAN,p_transaction_step_id IN NUMBER
963: ,p_effective_date in varchar2) IS
964:
965: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
966: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
967: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
968: l_eventid ota_events.event_id%TYPE;
969: l_object_version_number number;
970: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;

Line 1093: OTA_BOOKING_STATUS_TYPES bst

1089:
1090: CURSOR get_existing_internal IS
1091: SELECT count(*)
1092: FROM OTA_DELEGATE_BOOKINGS dbt,
1093: OTA_BOOKING_STATUS_TYPES bst
1094: WHERE dbt.event_id = l_eventid
1095: AND dbt.internal_booking_flag = 'Y'
1096: AND dbt.booking_status_type_id = bst.booking_status_type_id
1097: AND bst.type in ('P','A','E');

Line 1106: FROM ota_booking_status_types os,

1102: ,p_person_id IN NUMBER) IS
1103: SELECT ov.booking_id,
1104: ov.date_booking_placed,
1105: ov.object_version_number
1106: FROM ota_booking_status_types os,
1107: ota_delegate_bookings ov
1108: WHERE ov.event_id = p_event_id
1109: AND ov.delegate_person_id = p_person_id
1110: AND os.booking_status_type_id = ov.booking_status_type_id

Line 1913: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

1909: l_transaction_step_id number;
1910: l_eventid ota_events.event_id%TYPE;
1911: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1912: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
1913: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1914: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1915: l_object_version_number number;
1916: l_date_booking_placed date;
1917: l_current_date date;

Line 1930: FROM ota_booking_status_types os,

1926: SELECT ov.booking_id,
1927: ov.date_booking_placed,
1928: ov.object_version_number,
1929: ov.business_group_id
1930: FROM ota_booking_status_types os,
1931: ota_delegate_bookings ov
1932: WHERE ov.event_id = p_event_id
1933: AND ov.delegate_person_id = p_person_id
1934: AND os.booking_status_type_id = ov.booking_status_type_id

Line 2926: OTA_BOOKING_STATUS_TYPES bst

2922:
2923: CURSOR csr_booking_status(p_booking_id ota_delegate_bookings.booking_id%type) IS
2924: SELECT bst.Type
2925: FROM OTA_DELEGATE_BOOKINGS tdb,
2926: OTA_BOOKING_STATUS_TYPES bst
2927: WHERE tdb.booking_id = p_booking_id
2928: AND bst.booking_status_type_id = tdb.booking_status_type_id;
2929:
2930: CURSOR delivery_mode(p_event_id OTA_EVENTS.event_id%TYPE) IS

Line 2943: l_status_type ota_booking_status_types.type%type;

2939: l_event_id NUMBER;
2940: l_user_name FND_USER.USER_NAME%TYPE;
2941: l_booking_id ota_delegate_bookings.booking_id%type;
2942: l_notification_text varchar2(2000);
2943: l_status_type ota_booking_status_types.type%type;
2944:
2945: l_synchronous_flag ota_category_usages.synchronous_flag%type;
2946: l_online_flag ota_category_usages.online_flag%type;
2947: l_dm_status varchar2(20);