APPS.OTA_TDB_API_UPD2 dependencies on OTA_BOOKING_STATUS_TYPES

Line 230: l_type ota_booking_status_types.type%type;

226: v_forum_id number;
227: v_business_group_id number;
228: l_dummy number;
229: l_proc varchar2(72);
230: l_type ota_booking_status_types.type%type;
231:
232: begin
233: --
234: if g_debug then

Line 239: select Type into l_type from ota_booking_status_types where booking_status_type_id=l_booking_status_type_id;

235: l_proc := g_package||'createForumNotification';
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: end if;
238:
239: select Type into l_type from ota_booking_status_types where booking_status_type_id=l_booking_status_type_id;
240:
241: --create frm_notif_subscriber record for enrollment_status of 'P' or 'A'.
242: if l_type = 'P' or l_type = 'A' then
243: OPEN csr_forums_for_class;

Line 306: ,ota_booking_status_types bst

302:
303: CURSOR csr_get_waitlist_count(p_event_id NUMBER) IS
304: SELECT 1
305: FROM ota_delegate_bookings tdb
306: ,ota_booking_status_types bst
307: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
308: AND bst.type = 'W'
309: AND tdb.event_id = p_event_id;
310:

Line 466: l_type ota_booking_status_types.type%type;

462: l_lp_enrollment_ids varchar2(4000);
463: l_cert_prd_enrollment_ids varchar2(4000);
464: l_item_key wf_items.item_key%type;
465:
466: l_type ota_booking_status_types.type%type;
467: --
468: l_proc varchar2(72) ;
469: --l_daemon_type OTA_DELEGATE_BOOKINGS.daemon_type%TYPE := p_daemon_type;
470: --l_daemon_flag OTA_DELEGATE_BOOKINGS.daemon_flag%TYPE := p_daemon_flag;

Line 500: from ota_booking_status_types bst, ota_delegate_bookings tdb

496: l_LO_id ota_offerings.Learning_object_id%type;
497:
498: cursor get_status_info is
499: select bst.Type
500: from ota_booking_status_types bst, ota_delegate_bookings tdb
501: where bst.booking_status_type_id= tdb.booking_status_type_id
502: and tdb.booking_id = p_booking_id;
503:
504: l_enroll_type varchar2(30);

Line 956: select Type into l_type from ota_booking_status_types where booking_status_type_id=p_booking_status_type_id;

952: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
953:
954: end if; -- contact_id
955:
956: select Type into l_type from ota_booking_status_types where booking_status_type_id=p_booking_status_type_id;
957:
958: if l_type='A' and l_delegate_contact_id is null and l_contact_id is null then
959:
960: -- check whether class is online or not