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 465: l_type ota_booking_status_types.type%type;

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

Line 499: from ota_booking_status_types bst, ota_delegate_bookings tdb

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

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

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