APPS.OTA_EL_ENROLL_SS dependencies on OTA_DELEGATE_BOOKINGS

Line 46: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type

42: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
43: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
44: ,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
45: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
46: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type
47: ,p_message_name out nocopy varchar2
48: ,p_item_key IN WF_ITEMS.ITEM_TYPE%TYPE
49: ,p_tdb_information_category in varchar2
50: ,p_tdb_information1 in varchar2

Line 98: FROM OTA_DELEGATE_BOOKINGS dbt,

94: WHERE EVENT_ID = TO_NUMBER(p_event_id);
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

Line 131: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;

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;
135: l_booking_type VARCHAR2(4000);

Line 1440: ota_delegate_bookings ov

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
1444: AND os.type = 'C';

Line 1451: ota_delegate_bookings ov

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
1455: AND os.type <> 'C';

Line 1788: l_booking_id ota_delegate_bookings.booking_id%type;

1784: )
1785:
1786: IS
1787:
1788: l_booking_id ota_delegate_bookings.booking_id%type;
1789: l_proc varchar2(72) := g_package||'check_enrollment_creation';
1790:
1791:
1792: BEGIN

Line 1912: CURSOR csr_booking_status(p_booking_id ota_delegate_bookings.booking_id%type) IS

1908: WHERE evt.event_id = p_event_id and
1909: usr.employee_id = evt.owner_id;
1910:
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

Line 1914: FROM OTA_DELEGATE_BOOKINGS tdb,

1910:
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:

Line 1926: l_booking_id ota_delegate_bookings.booking_id%type;

1922: l_api_to VARCHAR2(4000);
1923: l_event_id NUMBER;
1924: l_user_name FND_USER.USER_NAME%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

Line 2385: FROM ota_delegate_bookings

2381: IS
2382:
2383: CURSOR csr_get_ovn IS
2384: SELECT object_version_number
2385: FROM ota_delegate_bookings
2386: WHERE booking_id = p_booking_id;
2387: --
2388: l_ovn BINARY_INTEGER DEFAULT '';
2389: