eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_BOOKING_STATUS_TYPES

Line 242: select type into l_booking_status_type from ota_booking_status_types

238: OPEN csr_get_cost_center_info;
239: FETCH csr_get_cost_center_info INTO l_cost_allocation_keyflex_id;
240: CLOSE csr_get_cost_center_info;
241:
242: select type into l_booking_status_type from ota_booking_status_types
243: where booking_status_type_id = p_booking_status_type_id;
244:
245: if p_delegate_person_id is not null and l_auto_create_finance = 'Y'
246: and l_price_basis <> 'N' and l_event_currency_code is not null

Line 312: from ota_delegate_bookings odb, ota_booking_status_types bst

308: and evt.event_id=p_event_id;
309:
310: Cursor csr_booking_info is
311: select odb.sign_eval_status,bst.type
312: from ota_delegate_bookings odb, ota_booking_status_types bst
313: where odb.booking_status_type_id = bst.booking_status_type_id
314: and odb.booking_id=p_booking_id;
315:
316: l_sign_required varchar2(1);

Line 320: l_old_status_type ota_booking_status_types.type%type;

316: l_sign_required varchar2(1);
317: l_pending_info varchar2(2);
318: l_old_sign_eval_status varchar2(2);
319: l_new_sign_eval_status varchar2(2);
320: l_old_status_type ota_booking_status_types.type%type;
321: l_type ota_booking_status_types.type%type;
322: l_manual_update boolean:=false;
323: l_status_change boolean:=false;
324: --p_sign_eval_status varchar2(2) := 'NN';

Line 321: l_type ota_booking_status_types.type%type;

317: l_pending_info varchar2(2);
318: l_old_sign_eval_status varchar2(2);
319: l_new_sign_eval_status varchar2(2);
320: l_old_status_type ota_booking_status_types.type%type;
321: l_type ota_booking_status_types.type%type;
322: l_manual_update boolean:=false;
323: l_status_change boolean:=false;
324: --p_sign_eval_status varchar2(2) := 'NN';
325: BEGIN

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

347: elsif p_sign_eval_status is not null then
348: return p_sign_eval_status;
349: end if;
350: end if;
351: select Type into l_type from ota_booking_status_types where booking_status_type_id=p_booking_status_type_id;
352: l_manual_update:= (p_booking_id is not null) and (p_sign_eval_status is null) and (l_old_sign_eval_status is not null);
353: l_status_change:= (p_booking_id is not null) and (l_type <>l_old_status_type);
354: if l_manual_update and l_status_change then
355: if l_type='A' then

Line 529: l_type ota_booking_status_types.type%type;

525: l_lp_enrollment_ids varchar2(4000);
526: l_cert_prd_enrollment_ids varchar2(4000);
527: l_item_key wf_items.item_key%type;
528:
529: l_type ota_booking_status_types.type%type;
530:
531:
532: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
533: hr_dflex_utility.l_ignore_dfcode_varray();

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

920: p_person_id => p_delegate_person_id,
921: p_contact_id => p_delegate_contact_id,
922: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
923:
924: select Type into l_type from ota_booking_status_types where booking_status_type_id=p_booking_status_type_id;
925:
926: if l_type='A' and p_delegate_contact_id is null and p_contact_id is null then
927:
928: -- check whether class is online or not

Line 1529: l_type ota_booking_status_types.type%type;

1525: v_forum_id number;
1526: v_business_group_id number;
1527: l_dummy number;
1528: l_proc varchar2(72);
1529: l_type ota_booking_status_types.type%type;
1530:
1531: begin
1532: --
1533: if g_debug then

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

1534: l_proc := g_package||'createForumNotification';
1535: hr_utility.set_location('Entering:'||l_proc, 5);
1536: end if;
1537:
1538: select Type into l_type from ota_booking_status_types where booking_status_type_id=l_booking_status_type_id;
1539:
1540: --create frm_notif_subscriber record for enrollment_status of 'P' or 'A'.
1541: if l_type = 'P' or l_type = 'A' then
1542: OPEN csr_forums_for_class;

Line 1605: ,ota_booking_status_types bst

1601:
1602: CURSOR csr_get_waitlist_count(p_event_id NUMBER) IS
1603: SELECT 1
1604: FROM ota_delegate_bookings tdb
1605: ,ota_booking_status_types bst
1606: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1607: AND bst.type = 'W'
1608: AND tdb.event_id = p_event_id;
1609:

Line 1769: l_type ota_booking_status_types.type%type;

1765: l_lp_enrollment_ids varchar2(4000);
1766: l_cert_prd_enrollment_ids varchar2(4000);
1767: l_item_key wf_items.item_key%type;
1768:
1769: l_type ota_booking_status_types.type%type;
1770: --
1771: l_daemon_type VARCHAR2(30) := p_daemon_type;
1772: l_daemon_flag VARCHAR2(30) := p_daemon_flag;
1773:

Line 1843: from ota_booking_status_types bst, ota_delegate_bookings tdb

1839: l_LO_id ota_offerings.Learning_object_id%type;
1840:
1841: cursor get_status_info is
1842: select bst.Type
1843: from ota_booking_status_types bst, ota_delegate_bookings tdb
1844: where bst.booking_status_type_id= tdb.booking_status_type_id
1845: and tdb.booking_id = p_booking_id;
1846:
1847: l_enroll_type varchar2(30);

Line 1940: l_old_booking_status_type ota_booking_status_types.type%TYPE;

1936: l_contact_user_id ota_attempts.user_id%type;
1937: l_old_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
1938: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
1939:
1940: l_old_booking_status_type ota_booking_status_types.type%TYPE;
1941: l_new_booking_status_type ota_booking_status_types.type%TYPE;
1942:
1943: begin
1944: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1941: l_new_booking_status_type ota_booking_status_types.type%TYPE;

1937: l_old_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
1938: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
1939:
1940: l_old_booking_status_type ota_booking_status_types.type%TYPE;
1941: l_new_booking_status_type ota_booking_status_types.type%TYPE;
1942:
1943: begin
1944: hr_utility.set_location('Entering:'|| l_proc, 10);
1945: if g_debug then

Line 2529: select Type into l_type from ota_booking_status_types where booking_status_type_id=l_new_booking_status_type_id;

2525: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2526:
2527: END IF; -- contact_id
2528:
2529: select Type into l_type from ota_booking_status_types where booking_status_type_id=l_new_booking_status_type_id;
2530:
2531: IF l_type='A' and l_delegate_contact_id is null and l_contact_id IS NULL THEN
2532:
2533: -- check whether class is online or not

Line 3158: l_booking_status ota_booking_status_types.type%TYPE;

3154: l_event_title ota_events.title%TYPE;
3155: l_owner_id ota_events.owner_id%TYPE;
3156: l_event_id ota_delegate_bookings.event_id%TYPE;
3157: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3158: l_booking_status ota_booking_status_types.type%TYPE;
3159: l_username fnd_user.user_name%TYPE;
3160: l_auto_waitlist_days NUMBER;
3161: l_auto_waitlist VARCHAR2(2) := 'N';
3162: l_waitlist_size NUMBER := 0;

Line 3188: FROM ota_booking_status_types

3184: WHERE booking_id = p_booking_id;
3185:
3186: CURSOR booking_status_csr(l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE) IS
3187: SELECT type
3188: FROM ota_booking_status_types
3189: WHERE booking_status_type_id = l_booking_status_type_id;
3190:
3191: --bug 603768 changes ends
3192: