APPS.OTA_TRNG_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 95: FROM OTA_DELEGATE_BOOKINGS dbt,

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

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

124:
125: l_person_details OTA_TRNG_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
126: --
127: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
128: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
129: l_object_version_number BINARY_INTEGER;
130: l_tfl_ovn BINARY_INTEGER;
131: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
132: l_booking_type VARCHAR2(4000);

Line 1429: ota_delegate_bookings ov

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

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 1777: l_booking_id ota_delegate_bookings.booking_id%type;

1773: )
1774:
1775: IS
1776:
1777: l_booking_id ota_delegate_bookings.booking_id%type;
1778: l_proc varchar2(72) := g_package||'check_enrollment_creation';
1779:
1780:
1781: BEGIN

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

1897: WHERE evt.event_id = p_event_id and
1898: usr.employee_id = evt.owner_id;
1899:
1900:
1901: CURSOR csr_booking_status(p_booking_id ota_delegate_bookings.booking_id%type) IS
1902: SELECT bst.Type
1903: FROM OTA_DELEGATE_BOOKINGS tdb,
1904: OTA_BOOKING_STATUS_TYPES bst
1905: WHERE tdb.booking_id = p_booking_id

Line 1903: FROM OTA_DELEGATE_BOOKINGS tdb,

1899:
1900:
1901: CURSOR csr_booking_status(p_booking_id ota_delegate_bookings.booking_id%type) IS
1902: SELECT bst.Type
1903: FROM OTA_DELEGATE_BOOKINGS tdb,
1904: OTA_BOOKING_STATUS_TYPES bst
1905: WHERE tdb.booking_id = p_booking_id
1906: AND bst.booking_status_type_id = tdb.booking_status_type_id;
1907:

Line 1915: l_booking_id ota_delegate_bookings.booking_id%type;

1911: l_api_to VARCHAR2(4000);
1912: l_event_id NUMBER;
1913: l_user_name FND_USER.USER_NAME%TYPE;
1914: l_offering_id ota_events.offering_id%type;
1915: l_booking_id ota_delegate_bookings.booking_id%type;
1916: l_version_name ota_activity_versions.version_name%type;
1917: l_notification_text varchar2(2000);
1918: l_status_type ota_booking_status_types.type%type;
1919: BEGIN

Line 2127: FROM ota_delegate_bookings

2123: IS
2124:
2125: CURSOR csr_get_ovn IS
2126: SELECT object_version_number
2127: FROM ota_delegate_bookings
2128: WHERE booking_id = p_booking_id;
2129: --
2130: l_ovn BINARY_INTEGER DEFAULT '';
2131: