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_TDB_API_UPD2 dependencies on OTA_DELEGATE_BOOKINGS

Line 299: ota_delegate_bookings tdb

295: SELECT evt.course_start_time
296: ,evt.course_start_date
297: ,evt.event_id
298: FROM ota_events evt,
299: ota_delegate_bookings tdb
300: WHERE tdb.event_id = evt.event_id
301: AND tdb.booking_id = p_booking_id;
302:
303: CURSOR csr_get_waitlist_count(p_event_id NUMBER) IS

Line 305: FROM ota_delegate_bookings tdb

301: AND tdb.booking_id = p_booking_id;
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;

Line 468: --l_daemon_type OTA_DELEGATE_BOOKINGS.daemon_type%TYPE := p_daemon_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;
470: l_daemon_type VARCHAR2(30) := p_daemon_type;
471: l_daemon_flag VARCHAR2(30) := p_daemon_flag;
472:

Line 469: --l_daemon_flag OTA_DELEGATE_BOOKINGS.daemon_flag%TYPE := p_daemon_flag;

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;
470: l_daemon_type VARCHAR2(30) := p_daemon_type;
471: l_daemon_flag VARCHAR2(30) := p_daemon_flag;
472:
473: Cursor is_contact

Line 476: Ota_delegate_bookings

472:
473: Cursor is_contact
474: is
475: Select contact_id,delegate_contact_id from
476: Ota_delegate_bookings
477: where booking_id= p_booking_id;
478:
479: l_delegate_contact_id number(15);
480: l_contact_id number(15);

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 511: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;

507: l_organization_id_changed boolean;
508: l_delegate_person_id_changed boolean;
509: l_delegate_asg_changed boolean;
510:
511: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
512: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
513: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
514: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
515: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;

Line 512: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;

508: l_delegate_person_id_changed boolean;
509: l_delegate_asg_changed boolean;
510:
511: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
512: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
513: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
514: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
515: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
516: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;

Line 513: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;

509: l_delegate_asg_changed boolean;
510:
511: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
512: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
513: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
514: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
515: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
516: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
517:

Line 514: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;

510:
511: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
512: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
513: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
514: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
515: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
516: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
517:
518: CURSOR csr_get_enr_details IS

Line 515: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;

511: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
512: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
513: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
514: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
515: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
516: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
517:
518: CURSOR csr_get_enr_details IS
519: SELECT event_id, customer_id, organization_id,

Line 516: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;

512: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
513: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
514: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
515: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
516: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
517:
518: CURSOR csr_get_enr_details IS
519: SELECT event_id, customer_id, organization_id,
520: delegate_person_id, delegate_assignment_id,

Line 522: FROM ota_delegate_bookings

518: CURSOR csr_get_enr_details IS
519: SELECT event_id, customer_id, organization_id,
520: delegate_person_id, delegate_assignment_id,
521: delegate_contact_id
522: FROM ota_delegate_bookings
523: WHERE booking_id = p_booking_id;
524:
525:
526: l_enr_details_rec csr_get_enr_details%ROWTYPE;

Line 756: l_add_struct_d(l_add_struct_d.count) := 'OTA_DELEGATE_BOOKINGS';

752:
753: -- Ignore Enrollment Dff Validation for some cases
754: if ( (l_event_rec.price_basis = 'C' and p_contact_id is not null) or (l_event_rec.line_id is not null) or (p_line_id is not null) ) then
755: l_add_struct_d.extend(1);
756: l_add_struct_d(l_add_struct_d.count) := 'OTA_DELEGATE_BOOKINGS';
757: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
758: l_ignore_dff_validation := 'Y';
759: else
760: l_ignore_dff_validation := 'N';

Line 892: select delegate_person_id into l_person_id from ota_delegate_bookings

888: FETCH is_contact INTO l_contact_id,l_delegate_contact_id;
889: CLOSE is_contact;
890:
891: If (p_delegate_person_id = hr_api.g_number) then
892: select delegate_person_id into l_person_id from ota_delegate_bookings
893: where booking_id = p_booking_id;
894: else l_person_id := p_delegate_person_id;
895: End If;
896: --

Line 1385: (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,

1381: --
1382: end Update_Waitlisted;
1383:
1384: Procedure chk_mandatory_prereqs
1385: (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
1386: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
1387: p_customer_id ota_delegate_bookings.customer_id%TYPE,
1388: p_event_id ota_events.event_id%TYPE,
1389: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE

Line 1386: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,

1382: end Update_Waitlisted;
1383:
1384: Procedure chk_mandatory_prereqs
1385: (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
1386: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
1387: p_customer_id ota_delegate_bookings.customer_id%TYPE,
1388: p_event_id ota_events.event_id%TYPE,
1389: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE
1390: ) IS

Line 1387: p_customer_id ota_delegate_bookings.customer_id%TYPE,

1383:
1384: Procedure chk_mandatory_prereqs
1385: (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
1386: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
1387: p_customer_id ota_delegate_bookings.customer_id%TYPE,
1388: p_event_id ota_events.event_id%TYPE,
1389: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE
1390: ) IS
1391:

Line 1389: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE

1385: (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
1386: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
1387: p_customer_id ota_delegate_bookings.customer_id%TYPE,
1388: p_event_id ota_events.event_id%TYPE,
1389: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE
1390: ) IS
1391:
1392: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
1393: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;

Line 1392: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;

1388: p_event_id ota_events.event_id%TYPE,
1389: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE
1390: ) IS
1391:
1392: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
1393: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
1394: l_customer_id ota_delegate_bookings.customer_id%TYPE;
1395: l_event_id ota_events.event_id%TYPE;
1396: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;

Line 1393: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;

1389: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE
1390: ) IS
1391:
1392: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
1393: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
1394: l_customer_id ota_delegate_bookings.customer_id%TYPE;
1395: l_event_id ota_events.event_id%TYPE;
1396: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
1397: l_check_prereq boolean;

Line 1394: l_customer_id ota_delegate_bookings.customer_id%TYPE;

1390: ) IS
1391:
1392: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
1393: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
1394: l_customer_id ota_delegate_bookings.customer_id%TYPE;
1395: l_event_id ota_events.event_id%TYPE;
1396: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
1397: l_check_prereq boolean;
1398: l_old_status_type varchar2(30);

Line 1396: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;

1392: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
1393: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
1394: l_customer_id ota_delegate_bookings.customer_id%TYPE;
1395: l_event_id ota_events.event_id%TYPE;
1396: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
1397: l_check_prereq boolean;
1398: l_old_status_type varchar2(30);
1399: l_new_status_type varchar2(30);
1400: