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_UTILITY dependencies on OTA_BOOKING_STATUS_TYPES

Line 634: FROM OTA_BOOKING_STATUS_TYPES

630:
631:
632: CURSOR c_status_type IS
633: SELECT Type
634: FROM OTA_BOOKING_STATUS_TYPES
635: WHERE booking_status_type_id = p_status_type_id;
636:
637: l_status_type ota_booking_status_types.type%type ;
638:

Line 637: l_status_type ota_booking_status_types.type%type ;

633: SELECT Type
634: FROM OTA_BOOKING_STATUS_TYPES
635: WHERE booking_status_type_id = p_status_type_id;
636:
637: l_status_type ota_booking_status_types.type%type ;
638:
639:
640: BEGIN
641: hr_utility.set_location('Entering:'||l_proc, 5);

Line 696: FROM OTA_BOOKING_STATUS_TYPES_VL

692:
693:
694: CURSOR c_status_type IS
695: SELECT name
696: FROM OTA_BOOKING_STATUS_TYPES_VL
697: WHERE booking_status_type_id = p_status_type_id;
698:
699: l_status_name ota_booking_status_types.name%type ;
700:

Line 699: l_status_name ota_booking_status_types.name%type ;

695: SELECT name
696: FROM OTA_BOOKING_STATUS_TYPES_VL
697: WHERE booking_status_type_id = p_status_type_id;
698:
699: l_status_name ota_booking_status_types.name%type ;
700:
701:
702: BEGIN
703: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1054: ota_booking_status_types bst,

1050: --
1051: cursor c_other_person_bookings is
1052: select bst.type
1053: from ota_delegate_bookings db,
1054: ota_booking_status_types bst,
1055: ota_events ev,
1056: ota_events evt
1057: where db.delegate_person_id = p_delegate_person_id
1058: and db.booking_status_type_id = bst.booking_status_type_id

Line 1081: ota_booking_status_types bst,

1077: --
1078: cursor c_other_contact_bookings is
1079: select bst.type
1080: from ota_delegate_bookings db,
1081: ota_booking_status_types bst,
1082: ota_events ev,
1083: ota_events evt
1084: where db.delegate_contact_id = p_delegate_contact_id
1085: and db.booking_status_type_id = bst.booking_status_type_id

Line 1481: FROM ota_booking_status_types bst

1477: INTO l_num_waitlisted
1478: FROM ota_delegate_bookings tdb
1479: WHERE tdb.event_id = p_event_id
1480: AND tdb.booking_status_type_id IN (SELECT bst.booking_status_type_id
1481: FROM ota_booking_status_types bst
1482: WHERE bst.type = 'W');
1483: hr_utility.set_location('Leaving :'||l_proc,10);
1484: RETURN l_num_waitlisted;
1485:

Line 1522: ota_booking_status_types bst

1518:
1519: CURSOR c_date_waitlist is
1520: SELECT tdb.booking_id
1521: FROM ota_delegate_bookings tdb,
1522: ota_booking_status_types bst
1523: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1524: AND bst.type = 'W'
1525: AND tdb.event_id = p_event_id
1526: ORDER BY tdb.date_booking_placed;

Line 1531: ota_booking_status_types bst

1527:
1528: CURSOR c_priority_waitlist is
1529: SELECT tdb.booking_id
1530: FROM ota_delegate_bookings tdb,
1531: ota_booking_status_types bst
1532: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1533: AND bst.type = 'W'
1534: AND tdb.event_id = p_event_id
1535: ORDER BY tdb.booking_priority,

Line 2213: FROM ota_booking_status_types_vl BST,

2209: RETURN VARCHAR2 IS
2210:
2211: CURSOR enroll_status IS
2212: SELECT DECODE(BST.type,'C','Y',BST.type) status, BST.name
2213: FROM ota_booking_status_types_vl BST,
2214: ota_delegate_bookings ODB
2215: WHERE ODB.event_id = p_event_id
2216: AND (p_delegate_person_id IS NOT NULL AND ODB.delegate_person_id = p_delegate_person_id
2217: OR p_delegate_contact_id IS NOT NULL and ODB.delegate_contact_id = p_delegate_contact_id)

Line 2225: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

2221:
2222: l_proc VARCHAR2(72) := g_package|| 'get_enrollment_status';
2223:
2224: l_enrollment_status VARCHAR2(30) := 'Z'; --Default is Not Enrolled(Status Z)
2225: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
2226:
2227: BEGIN
2228: hr_utility.set_location(' Step:'|| l_proc, 10);
2229:

Line 3479: p_booking_status_type in ota_booking_status_types.type%TYPE) return varchar2 is

3475: p_person_id in number,
3476: p_contact_id in number,
3477: p_event_id in ota_events.event_id%TYPE,
3478: p_mandatory_flag in ota_delegate_bookings.is_mandatory_enrollment%TYPE,
3479: p_booking_status_type in ota_booking_status_types.type%TYPE) return varchar2 is
3480:
3481: CURSOR lp_cls_enroll_p IS
3482: SELECT lpe.lp_enrollment_id
3483: FROM ota_lp_enrollments lpe,

Line 3538: ota_booking_status_types obst,

3534: function get_learners_email_addresses(p_event_id ota_events.event_id%type) return clob is
3535: cursor get_internal_email_addresses is
3536: select paf.email_address
3537: from ota_delegate_bookings odb,
3538: ota_booking_status_types obst,
3539: per_all_people_f paf
3540: where odb.event_id = p_event_id and
3541: odb.booking_status_type_id = obst.booking_status_type_id and
3542: obst.type in ('A', 'P', 'E') and

Line 3559: ota_booking_status_types obst

3555: HZ_LOCATIONS LOC,
3556: HZ_PARTY_SITES PARTY_SITE,
3557: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
3558: ota_delegate_bookings odb,
3559: ota_booking_status_types obst
3560: WHERE
3561: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3562: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3563: AND REL.SUBJECT_ID = PARTY.PARTY_ID