APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_BOOKING_STATUS_TYPES

Line 383: l_type ota_booking_status_types.type%type;

379: l_lp_enrollment_ids varchar2(4000);
380: l_cert_prd_enrollment_ids varchar2(4000);
381: l_item_key wf_items.item_key%type;
382:
383: l_type ota_booking_status_types.type%type;
384:
385:
386: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
387: hr_dflex_utility.l_ignore_dfcode_varray();

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

764: p_person_id => p_delegate_person_id,
765: p_contact_id => p_delegate_contact_id,
766: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
767:
768: select Type into l_type from ota_booking_status_types where booking_status_type_id=p_booking_status_type_id;
769:
770: if l_type='A' and p_delegate_contact_id is null and p_contact_id is null then
771:
772: -- check whether class is online or not

Line 1360: l_type ota_booking_status_types.type%type;

1356: v_forum_id number;
1357: v_business_group_id number;
1358: l_dummy number;
1359: l_proc varchar2(72);
1360: l_type ota_booking_status_types.type%type;
1361:
1362: begin
1363: --
1364: if g_debug then

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

1365: l_proc := g_package||'createForumNotification';
1366: hr_utility.set_location('Entering:'||l_proc, 5);
1367: end if;
1368:
1369: select Type into l_type from ota_booking_status_types where booking_status_type_id=l_booking_status_type_id;
1370:
1371: --create frm_notif_subscriber record for enrollment_status of 'P' or 'A'.
1372: if l_type = 'P' or l_type = 'A' then
1373: OPEN csr_forums_for_class;

Line 1436: ,ota_booking_status_types bst

1432:
1433: CURSOR csr_get_waitlist_count(p_event_id NUMBER) IS
1434: SELECT 1
1435: FROM ota_delegate_bookings tdb
1436: ,ota_booking_status_types bst
1437: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1438: AND bst.type = 'W'
1439: AND tdb.event_id = p_event_id;
1440:

Line 1599: l_type ota_booking_status_types.type%type;

1595: l_lp_enrollment_ids varchar2(4000);
1596: l_cert_prd_enrollment_ids varchar2(4000);
1597: l_item_key wf_items.item_key%type;
1598:
1599: l_type ota_booking_status_types.type%type;
1600: --
1601: l_daemon_type VARCHAR2(30) := p_daemon_type;
1602: l_daemon_flag VARCHAR2(30) := p_daemon_flag;
1603:

Line 1673: from ota_booking_status_types bst, ota_delegate_bookings tdb

1669: l_LO_id ota_offerings.Learning_object_id%type;
1670:
1671: cursor get_status_info is
1672: select bst.Type
1673: from ota_booking_status_types bst, ota_delegate_bookings tdb
1674: where bst.booking_status_type_id= tdb.booking_status_type_id
1675: and tdb.booking_id = p_booking_id;
1676:
1677: l_enroll_type varchar2(30);

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

2314: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2315:
2316: END IF; -- contact_id
2317:
2318: select Type into l_type from ota_booking_status_types where booking_status_type_id=p_booking_status_type_id;
2319:
2320: IF l_type='A' and l_delegate_contact_id is null and l_contact_id IS NULL THEN
2321:
2322: -- check whether class is online or not

Line 2925: l_booking_status ota_booking_status_types.type%TYPE;

2921: l_event_title ota_events.title%TYPE;
2922: l_owner_id ota_events.owner_id%TYPE;
2923: l_event_id ota_delegate_bookings.event_id%TYPE;
2924: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
2925: l_booking_status ota_booking_status_types.type%TYPE;
2926: l_username fnd_user.user_name%TYPE;
2927: l_auto_waitlist_days NUMBER;
2928: l_auto_waitlist VARCHAR2(2) := 'N';
2929: l_waitlist_size NUMBER := 0;

Line 2955: FROM ota_booking_status_types

2951: WHERE booking_id = p_booking_id;
2952:
2953: CURSOR booking_status_csr(l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE) IS
2954: SELECT type
2955: FROM ota_booking_status_types
2956: WHERE booking_status_type_id = l_booking_status_type_id;
2957:
2958: --bug 603768 changes ends
2959: --