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 469: --l_daemon_type OTA_DELEGATE_BOOKINGS.daemon_type%TYPE := p_daemon_type;

465:
466: l_type ota_booking_status_types.type%type;
467: --
468: l_proc varchar2(72) ;
469: --l_daemon_type OTA_DELEGATE_BOOKINGS.daemon_type%TYPE := p_daemon_type;
470: --l_daemon_flag OTA_DELEGATE_BOOKINGS.daemon_flag%TYPE := p_daemon_flag;
471: l_daemon_type VARCHAR2(30) := p_daemon_type;
472: l_daemon_flag VARCHAR2(30) := p_daemon_flag;
473:

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

466: l_type ota_booking_status_types.type%type;
467: --
468: l_proc varchar2(72) ;
469: --l_daemon_type OTA_DELEGATE_BOOKINGS.daemon_type%TYPE := p_daemon_type;
470: --l_daemon_flag OTA_DELEGATE_BOOKINGS.daemon_flag%TYPE := p_daemon_flag;
471: l_daemon_type VARCHAR2(30) := p_daemon_type;
472: l_daemon_flag VARCHAR2(30) := p_daemon_flag;
473:
474: Cursor is_contact

Line 477: Ota_delegate_bookings

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

Line 500: from ota_booking_status_types bst, ota_delegate_bookings tdb

496: l_LO_id ota_offerings.Learning_object_id%type;
497:
498: cursor get_status_info is
499: select bst.Type
500: from ota_booking_status_types bst, ota_delegate_bookings tdb
501: where bst.booking_status_type_id= tdb.booking_status_type_id
502: and tdb.booking_id = p_booking_id;
503:
504: l_enroll_type varchar2(30);

Line 512: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;

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

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

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

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

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

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

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

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

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

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

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

Line 523: FROM ota_delegate_bookings

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

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

754:
755: -- Ignore Enrollment Dff Validation for some cases
756: 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
757: l_add_struct_d.extend(1);
758: l_add_struct_d(l_add_struct_d.count) := 'OTA_DELEGATE_BOOKINGS';
759: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
760: l_ignore_dff_validation := 'Y';
761: else
762: l_ignore_dff_validation := 'N';

Line 894: select delegate_person_id into l_person_id from ota_delegate_bookings

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

Line 1387: (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,

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

Line 1388: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,

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

Line 1389: p_customer_id ota_delegate_bookings.customer_id%TYPE,

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

Line 1391: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE

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

Line 1394: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;

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

Line 1395: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;

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

Line 1396: l_customer_id ota_delegate_bookings.customer_id%TYPE;

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

Line 1398: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;

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