APPS.OTA_ENROLL_IN_TRAINING_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 130: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;

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

1801: )
1802:
1803: IS
1804:
1805: l_booking_id ota_delegate_bookings.booking_id%type;
1806: l_proc varchar2(72) := g_package||'check_enrollment_creation';
1807:
1808:
1809: BEGIN

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

1925: WHERE evt.event_id = p_event_id and
1926: usr.employee_id = evt.owner_id;
1927:
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

Line 1931: FROM OTA_DELEGATE_BOOKINGS tdb,

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

Line 1943: l_booking_id ota_delegate_bookings.booking_id%type;

1939: l_api_to VARCHAR2(4000);
1940: l_event_id NUMBER;
1941: l_user_name FND_USER.USER_NAME%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

Line 2164: FROM ota_delegate_bookings

2160: IS
2161:
2162: CURSOR csr_get_ovn IS
2163: SELECT object_version_number
2164: FROM ota_delegate_bookings
2165: WHERE booking_id = p_booking_id;
2166: --
2167: l_ovn BINARY_INTEGER DEFAULT '';
2168: