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_DELEGATE_BOOKINGS

Line 365: ota_Delegate_bookings tdb,

361: evt.Course_Start_Date,
362: evt.Course_End_Date,
363: tdb.delegate_contact_id
364: From
365: ota_Delegate_bookings tdb,
366: ota_Events_vl evt, --MLS change _vl added
367: ota_activity_versions_tl tav -- MLS change _tl added
368: Where
369: evt.event_id = tdb.event_id and

Line 757: OTA_DELEGATE_BOOKINGS

753: CURSOR C_enrollment
754: IS
755: Select null
756: FROM
757: OTA_DELEGATE_BOOKINGS
758: WHERE
759: Line_id = p_line_id;
760:
761:

Line 1053: from ota_delegate_bookings db,

1049: -- clash with the event being booked
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

Line 1080: from ota_delegate_bookings db,

1076: order by bst.type;
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

Line 1478: FROM ota_delegate_bookings tdb

1474: BEGIN
1475: hr_utility.set_location('Entering :'||l_proc,5);
1476: SELECT COUNT(booking_id)
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');

Line 1521: FROM ota_delegate_bookings tdb,

1517: l_count number := 1;
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

Line 1530: FROM ota_delegate_bookings tdb,

1526: ORDER BY tdb.date_booking_placed;
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

Line 2205: FUNCTION get_enrollment_status(p_delegate_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,

2201:
2202: end get_question_bank_count ;
2203:
2204: -- Author: sbhullar
2205: FUNCTION get_enrollment_status(p_delegate_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
2206: p_delegate_contact_id IN NUMBER,
2207: p_event_id IN ota_events.event_id%TYPE,
2208: p_code IN number)
2209: RETURN VARCHAR2 IS

Line 2214: ota_delegate_bookings ODB

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)
2218: AND ODB.booking_status_type_id = BST.booking_status_type_id

Line 2321: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,

2317:
2318: END get_person_fullname;
2319:
2320: FUNCTION get_learner_name(p_person_id IN per_all_people_f.person_id%TYPE,
2321: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
2322: p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
2323: RETURN VARCHAR2 IS
2324:
2325: CURSOR c_person_name IS

Line 2322: p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)

2318: END get_person_fullname;
2319:
2320: FUNCTION get_learner_name(p_person_id IN per_all_people_f.person_id%TYPE,
2321: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
2322: p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
2323: RETURN VARCHAR2 IS
2324:
2325: CURSOR c_person_name IS
2326: select pap.full_name from per_all_people_f pap

Line 2331: CURSOR c_contact_name(l_customer_id IN ota_delegate_bookings.customer_id%TYPE) IS

2327: where pap.person_id = p_person_id
2328: and trunc(sysdate) between nvl(pap.effective_start_date, trunc(sysdate))
2329: and nvl(pap.effective_end_date, trunc(sysdate));
2330:
2331: CURSOR c_contact_name(l_customer_id IN ota_delegate_bookings.customer_id%TYPE) IS
2332: SELECT
2333: SUBSTRB( PARTY.PERSON_LAST_NAME,1,50) || ' ' ||
2334: SUBSTRB( PARTY.PERSON_FIRST_NAME,1,40) || ' ' ||
2335: HR_GENERAL.DECODE_AR_LOOKUP('CONTACT_TITLE',nvl(PARTY.PERSON_PRE_NAME_ADJUNCT,PARTY.PERSON_TITLE)) LEARNER_NAME

Line 2411: l_return ota_delegate_bookings.customer_id%TYPE;

2407: and role_acct.party_id = rel.object_id
2408: and ACCT_ROLE.cust_account_role_id = p_contact_id;
2409:
2410: l_proc VARCHAR2(72) := g_package|| 'get_customer_id';
2411: l_return ota_delegate_bookings.customer_id%TYPE;
2412:
2413: Begin
2414: hr_utility.set_location(' Step:'|| l_proc, 10);
2415:

Line 2424: FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,

2420: return l_return;
2421: hr_utility.set_location(' Step:'|| l_proc, 20);
2422: End get_customer_id;
2423:
2424: FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,
2425: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
2426: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
2427: RETURN VARCHAR2 IS
2428:

Line 2425: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,

2421: hr_utility.set_location(' Step:'|| l_proc, 20);
2422: End get_customer_id;
2423:
2424: FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,
2425: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
2426: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
2427: RETURN VARCHAR2 IS
2428:
2429: CURSOR c_organization_name IS

Line 2433: CURSOR c_customer_name(l_customer_id IN ota_delegate_bookings.customer_id%TYPE) IS

2429: CURSOR c_organization_name IS
2430: select name from hr_all_organization_units_tl
2431: where language = userenv('LANG') and organization_id = p_organization_id;
2432:
2433: CURSOR c_customer_name(l_customer_id IN ota_delegate_bookings.customer_id%TYPE) IS
2434: select substrb(party.party_name,1,50)
2435: from hz_parties party
2436: ,hz_cust_accounts cust_acct
2437: where

Line 2744: (p_delegate_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)

2740: -- Public
2741: -- {End of Comments}
2742: ------------------------------------------------------------------
2743: FUNCTION get_ext_lrnr_party_id
2744: (p_delegate_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
2745: RETURN number IS
2746:
2747: Cursor get_ext_lrn_party_id is
2748: select party.party_id

Line 3478: p_mandatory_flag in ota_delegate_bookings.is_mandatory_enrollment%TYPE,

3474: function get_cls_enroll_image(p_manager_flag in varchar2,
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

Line 3537: from ota_delegate_bookings odb,

3533:
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

Line 3558: ota_delegate_bookings odb,

3554: HZ_ORG_CONTACTS ORG_CONT,
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'