APPS.OTA_EL_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(*)
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');

Line 130: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

126: l_price_basis OTA_EVENTS.price_basis%TYPE;
127:
128: l_person_details csr_person_to_enroll_details%ROWTYPE;
129: --
130: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
131: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
132: l_object_version_number BINARY_INTEGER;
133: l_tfl_ovn BINARY_INTEGER;
134: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;

Line 1020: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE

1016:
1017:
1018: FUNCTION Get_Booking_Status_For_Web (p_web_booking_status_type VARCHAR2
1019: ,p_business_group_id NUMBER)
1020: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE
1021:
1022: IS
1023:
1024: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE DEFAULT NULL;

Line 1024: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE DEFAULT NULL;

1020: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE
1021:
1022: IS
1023:
1024: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE DEFAULT NULL;
1025:
1026:
1027: BEGIN
1028:

Line 1439: FROM ota_booking_status_types os,

1435: CURSOR csr_chk_event
1436: (p_event_id IN NUMBER
1437: ,p_person_id IN NUMBER) IS
1438: SELECT ov.booking_id
1439: FROM ota_booking_status_types os,
1440: ota_delegate_bookings ov
1441: WHERE ov.event_id = p_event_id
1442: AND ov.delegate_person_id = p_person_id
1443: AND os.booking_status_type_id = ov.booking_status_type_id

Line 1450: FROM ota_booking_status_types os,

1446: CURSOR csr_chk_event_placed
1447: (p_event_id IN NUMBER
1448: ,p_person_id IN NUMBER) IS
1449: SELECT ov.booking_id
1450: FROM ota_booking_status_types os,
1451: ota_delegate_bookings ov
1452: WHERE ov.event_id = p_event_id
1453: AND ov.delegate_person_id = p_person_id
1454: AND os.booking_status_type_id = ov.booking_status_type_id

Line 1527: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

1523: procedure Chk_booking_clash (p_event_id IN NUMBER
1524: ,p_person_id IN NUMBER
1525: ,p_booking_Clash OUT NOCOPY varchar2)
1526: IS
1527: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1528: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1529:
1530:
1531: Begin

Line 1528: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;

1524: ,p_person_id IN NUMBER
1525: ,p_booking_Clash OUT NOCOPY varchar2)
1526: IS
1527: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1528: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1529:
1530:
1531: Begin
1532:

Line 1915: OTA_BOOKING_STATUS_TYPES bst

1911:
1912: CURSOR csr_booking_status(p_booking_id ota_delegate_bookings.booking_id%type) IS
1913: SELECT bst.Type
1914: FROM OTA_DELEGATE_BOOKINGS tdb,
1915: OTA_BOOKING_STATUS_TYPES bst
1916: WHERE tdb.booking_id = p_booking_id
1917: AND bst.booking_status_type_id = tdb.booking_status_type_id;
1918:
1919:

Line 1929: l_status_type ota_booking_status_types.type%type;

1925: l_offering_id ota_events.offering_id%type;
1926: l_booking_id ota_delegate_bookings.booking_id%type;
1927: l_version_name ota_activity_versions.version_name%type;
1928: l_notification_text varchar2(2000);
1929: l_status_type ota_booking_status_types.type%type;
1930: BEGIN
1931:
1932: l_event_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1933: ,itemkey => itemkey