APPS.OTA_ENROLL_IN_TRAINING_SS dependencies on OTA_BOOKING_STATUS_TYPES

Line 96: OTA_BOOKING_STATUS_TYPES bst

92:
93: CURSOR get_existing_internal IS
94: SELECT count(*)
95: FROM OTA_DELEGATE_BOOKINGS dbt,
96: OTA_BOOKING_STATUS_TYPES bst
97: WHERE dbt.event_id = TO_NUMBER(p_event_id)
98: AND dbt.internal_booking_flag = 'Y'
99: AND dbt.booking_status_type_id = bst.booking_status_type_id
100: AND bst.type in ('P','A','E');

Line 129: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

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

Line 1013: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE

1009:
1010:
1011: FUNCTION Get_Booking_Status_For_Web (p_web_booking_status_type VARCHAR2
1012: ,p_business_group_id NUMBER)
1013: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE
1014:
1015: IS
1016:
1017: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE DEFAULT NULL;

Line 1017: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE DEFAULT NULL;

1013: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE
1014:
1015: IS
1016:
1017: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE DEFAULT NULL;
1018:
1019:
1020: BEGIN
1021:

Line 1428: FROM ota_booking_status_types os,

1424: CURSOR csr_chk_event
1425: (p_event_id IN NUMBER
1426: ,p_person_id IN NUMBER) IS
1427: SELECT ov.booking_id
1428: FROM ota_booking_status_types os,
1429: ota_delegate_bookings ov
1430: WHERE ov.event_id = p_event_id
1431: AND ov.delegate_person_id = p_person_id
1432: AND os.booking_status_type_id = ov.booking_status_type_id

Line 1439: FROM ota_booking_status_types os,

1435: CURSOR csr_chk_event_placed
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 1516: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

1512: procedure Chk_booking_clash (p_event_id IN NUMBER
1513: ,p_person_id IN NUMBER
1514: ,p_booking_Clash OUT nocopy varchar2)
1515: IS
1516: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1517: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1518:
1519:
1520: Begin

Line 1517: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;

1513: ,p_person_id IN NUMBER
1514: ,p_booking_Clash OUT nocopy varchar2)
1515: IS
1516: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1517: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1518:
1519:
1520: Begin
1521:

Line 1932: OTA_BOOKING_STATUS_TYPES bst

1928:
1929: CURSOR csr_booking_status(p_booking_id ota_delegate_bookings.booking_id%type) IS
1930: SELECT bst.Type
1931: FROM OTA_DELEGATE_BOOKINGS tdb,
1932: OTA_BOOKING_STATUS_TYPES bst
1933: WHERE tdb.booking_id = p_booking_id
1934: AND bst.booking_status_type_id = tdb.booking_status_type_id;
1935:
1936:

Line 1946: l_status_type ota_booking_status_types.type%type;

1942: l_offering_id ota_events.offering_id%type;
1943: l_booking_id ota_delegate_bookings.booking_id%type;
1944: l_version_name ota_activity_versions.version_name%type;
1945: l_notification_text varchar2(2000);
1946: l_status_type ota_booking_status_types.type%type;
1947: BEGIN
1948:
1949: l_event_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1950: ,itemkey => itemkey