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 1922: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

1918: l_transaction_step_id number;
1919: l_eventid ota_events.event_id%TYPE;
1920: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1921: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
1922: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1923: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1924: l_object_version_number number;
1925: l_date_booking_placed date;
1926: l_current_date date;

Line 1939: FROM ota_booking_status_types os,

1935: SELECT ov.booking_id,
1936: ov.date_booking_placed,
1937: ov.object_version_number,
1938: ov.business_group_id
1939: FROM ota_booking_status_types os,
1940: ota_delegate_bookings ov
1941: WHERE ov.event_id = p_event_id
1942: AND ov.delegate_person_id = p_person_id
1943: AND os.booking_status_type_id = ov.booking_status_type_id

Line 2250: OTA_BOOKING_STATUS_TYPES bst

2246:
2247: CURSOR csr_booking_status(p_booking_id ota_delegate_bookings.booking_id%type) IS
2248: SELECT bst.Type
2249: FROM OTA_DELEGATE_BOOKINGS tdb,
2250: OTA_BOOKING_STATUS_TYPES bst
2251: WHERE tdb.booking_id = p_booking_id
2252: AND bst.booking_status_type_id = tdb.booking_status_type_id;
2253:
2254: CURSOR delivery_mode(p_event_id OTA_EVENTS.event_id%TYPE) IS

Line 2267: l_status_type ota_booking_status_types.type%type;

2263: l_event_id NUMBER;
2264: l_user_name FND_USER.USER_NAME%TYPE;
2265: l_booking_id ota_delegate_bookings.booking_id%type;
2266: l_notification_text varchar2(2000);
2267: l_status_type ota_booking_status_types.type%type;
2268:
2269: l_synchronous_flag ota_category_usages.synchronous_flag%type;
2270: l_online_flag ota_category_usages.online_flag%type;
2271: l_dm_status varchar2(20);