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

Line 29: FROM ota_delegate_bookings tdb,

25: SELECT bst.type status_code,
26: btt.name Status,
27: bst.booking_status_type_id status_id,
28: decode(bst.type, 'C', 0,'R',1, 'W',2, 'P',3, 'E',4, 'A',5) status_number
29: FROM ota_delegate_bookings tdb,
30: ota_booking_status_types bst,
31: ota_booking_status_types_tl btt
32: WHERE tdb.delegate_person_id = p_learner_id
33: AND tdb.event_id = p_object_id

Line 121: FROM ota_delegate_bookings tdb, ota_booking_status_types bst

117: , p_status_message OUT NOCOPY VARCHAR2)
118: IS
119: CURSOR get_enrolled_places IS
120: SELECT sum(nvl(tdb.number_of_places,1)) enrolled_places
121: FROM ota_delegate_bookings tdb, ota_booking_status_types bst
122: WHERE tdb.event_id = p_class_id
123: and tdb.internal_booking_flag = 'Y'
124: and tdb.booking_status_type_id = bst.booking_status_type_id
125: and bst.type IN ('P', 'A','E');

Line 338: FROM ota_delegate_bookings tdb

334: RETURN NUMBER IS
335:
336: CURSOR cse_get_class_enrollments IS
337: SELECT sum(nvl(tdb.number_of_places,0))
338: FROM ota_delegate_bookings tdb
339: , ota_booking_status_types bst
340: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
341: AND tdb.event_id = p_object_id
342: --TBD: needs to be confirmed if Requested(R) and Waitlisted(W) should also be included here

Line 388: ,p_booking_id OUT NOCOPY OTA_DELEGATE_BOOKINGS.Booking_id%type

384: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
385: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
386: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
387: ,p_delegate_contact_id IN NUMBER
388: ,p_booking_id OUT NOCOPY OTA_DELEGATE_BOOKINGS.Booking_id%type
389: ,p_message_name OUT NOCOPY varchar2
390: ,p_tdb_information_category IN VARCHAR2
391: ,p_tdb_information1 IN VARCHAR2
392: ,p_tdb_information2 IN VARCHAR2

Line 442: FROM OTA_DELEGATE_BOOKINGS dbt,

438: WHERE EVENT_ID = TO_NUMBER(p_event_id);
439:
440: CURSOR get_existing_internal IS
441: SELECT sum(nvl(dbt.number_of_places, 0))
442: FROM OTA_DELEGATE_BOOKINGS dbt,
443: OTA_BOOKING_STATUS_TYPES bst
444: WHERE dbt.event_id = TO_NUMBER(p_event_id)
445: AND dbt.internal_booking_flag = 'Y'
446: AND dbt.booking_status_type_id = bst.booking_status_type_id

Line 451: FROM OTA_DELEGATE_BOOKINGS dbt,

447: AND bst.type in ('P','A','E');
448:
449: CURSOR get_existing_bookings IS
450: SELECT sum(number_of_places)
451: FROM OTA_DELEGATE_BOOKINGS dbt,
452: OTA_BOOKING_STATUS_TYPES bst
453: WHERE dbt.event_id = TO_NUMBER(p_event_id)
454: AND dbt.booking_status_type_id = bst.booking_status_type_id
455: AND bst.type in ('P','A','E');

Line 553: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;

549:
550: l_person_details csr_get_assignment_details%ROWTYPE;
551: --
552: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
553: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
554: l_object_version_number BINARY_INTEGER;
555: l_tfl_ovn BINARY_INTEGER;
556: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
557: l_booking_type VARCHAR2(4000);

Line 608: l_internal_booking_flag OTA_DELEGATE_BOOKINGS.internal_booking_flag%TYPE;

604:
605: l_existing_bookings NUMBER;
606: l_maximum_external_allowed NUMBER;
607: l_maximum_attendees NUMBER;
608: l_internal_booking_flag OTA_DELEGATE_BOOKINGS.internal_booking_flag%TYPE;
609: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;
610: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;
611: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
612: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;

Line 609: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;

605: l_existing_bookings NUMBER;
606: l_maximum_external_allowed NUMBER;
607: l_maximum_attendees NUMBER;
608: l_internal_booking_flag OTA_DELEGATE_BOOKINGS.internal_booking_flag%TYPE;
609: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;
610: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;
611: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
612: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;
613: l_email_address OTA_DELEGATE_BOOKINGS.delegate_contact_email%TYPE := NULL;

Line 610: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;

606: l_maximum_external_allowed NUMBER;
607: l_maximum_attendees NUMBER;
608: l_internal_booking_flag OTA_DELEGATE_BOOKINGS.internal_booking_flag%TYPE;
609: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;
610: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;
611: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
612: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;
613: l_email_address OTA_DELEGATE_BOOKINGS.delegate_contact_email%TYPE := NULL;
614: l_person_address_type VARCHAR2(1);

Line 611: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;

607: l_maximum_attendees NUMBER;
608: l_internal_booking_flag OTA_DELEGATE_BOOKINGS.internal_booking_flag%TYPE;
609: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;
610: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;
611: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
612: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;
613: l_email_address OTA_DELEGATE_BOOKINGS.delegate_contact_email%TYPE := NULL;
614: l_person_address_type VARCHAR2(1);
615: l_ext_lrnr_details ota_learner_enroll_ss.csr_ext_lrnr_Details%ROWTYPE;

Line 612: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;

608: l_internal_booking_flag OTA_DELEGATE_BOOKINGS.internal_booking_flag%TYPE;
609: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;
610: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;
611: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
612: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;
613: l_email_address OTA_DELEGATE_BOOKINGS.delegate_contact_email%TYPE := NULL;
614: l_person_address_type VARCHAR2(1);
615: l_ext_lrnr_details ota_learner_enroll_ss.csr_ext_lrnr_Details%ROWTYPE;
616: l_customer_id HZ_CUST_ACCOUNT_ROLES.cust_account_id%type := NULL;

Line 613: l_email_address OTA_DELEGATE_BOOKINGS.delegate_contact_email%TYPE := NULL;

609: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;
610: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;
611: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
612: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;
613: l_email_address OTA_DELEGATE_BOOKINGS.delegate_contact_email%TYPE := NULL;
614: l_person_address_type VARCHAR2(1);
615: l_ext_lrnr_details ota_learner_enroll_ss.csr_ext_lrnr_Details%ROWTYPE;
616: l_customer_id HZ_CUST_ACCOUNT_ROLES.cust_account_id%type := NULL;
617: l_corespondent VARCHAR2(1) := NULL;

Line 653: ,flex_field_name => 'OTA_DELEGATE_BOOKINGS'

649: -- ----------------------------------------------------------------------
650: -- RETRIEVE THE DATA REQUIRED
651: -- ----------------------------------------------------------------------
652: ota_utility.Get_Default_Value_Dff( appl_short_name => 'OTA'
653: ,flex_field_name => 'OTA_DELEGATE_BOOKINGS'
654: ,p_attribute_category => l_attribute_category
655: ,p_attribute1 => l_attribute1
656: ,p_attribute2 => l_attribute2
657: ,p_attribute3 => l_attribute3

Line 1533: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt

1529: IS
1530:
1531: CURSOR csr_get_booking_status_id(l_booking_id NUMBER) IS
1532: SELECT btt.booking_status_type_id , btt.name booking_status
1533: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt
1534: WHERE booking_id = l_booking_id
1535: and tdb.booking_status_type_id = btt.booking_status_type_id
1536: and btt.language = USERENV('LANG');
1537:

Line 1566: l_booking_id ota_delegate_bookings.booking_id%TYPE;

1562: l_booking_status ota_booking_status_types_tl.name%TYPE;
1563:
1564: l_request_rec csr_get_request_info%ROWTYPE;
1565: l_req_member_rec csr_get_request_members%ROWTYPE;
1566: l_booking_id ota_delegate_bookings.booking_id%TYPE;
1567:
1568: l_assignment_info csr_get_assignment_info%ROWTYPE;
1569: l_cost_center_info csr_get_cost_center_info%ROWTYPE;
1570:

Line 1663: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt

1659: IS
1660:
1661: CURSOR csr_get_booking_status_id(l_booking_id NUMBER) IS
1662: SELECT btt.booking_status_type_id , btt.name booking_status
1663: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt
1664: WHERE booking_id = l_booking_id
1665: and tdb.booking_status_type_id = btt.booking_status_type_id
1666: and btt.language = USERENV('LANG');
1667:

Line 1736: l_booking_id ota_delegate_bookings.booking_id%TYPE;

1732: l_booking_status ota_booking_status_types_tl.name%TYPE;
1733:
1734: l_request_rec csr_get_request_info%ROWTYPE;
1735: l_req_member_rec csr_get_request_members%ROWTYPE;
1736: l_booking_id ota_delegate_bookings.booking_id%TYPE;
1737:
1738: l_assignment_info csr_get_assignment_info%ROWTYPE;
1739: l_cost_center_info csr_get_cost_center_info%ROWTYPE;
1740:

Line 1751: l_existing_booking_id ota_delegate_bookings.booking_id%TYPE;

1747: lp_mem_enr_to_upd_rec csr_get_lp_member_to_upd%ROWTYPE;
1748:
1749: l_parent_object_type ota_bulk_enr_requests.object_type%TYPE;
1750:
1751: l_existing_booking_id ota_delegate_bookings.booking_id%TYPE;
1752: l_lp_name varchar2(80);
1753: l_class_name varchar2(80);
1754: l_override_prerequisites varchar2(1) := 'Y';
1755:

Line 2180: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt

2176:
2177:
2178: CURSOR csr_get_booking_status_id(l_booking_id NUMBER) IS
2179: SELECT btt.booking_status_type_id , btt.name booking_status
2180: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt
2181: WHERE booking_id = l_booking_id
2182: and tdb.booking_status_type_id = btt.booking_status_type_id
2183: and btt.language = USERENV('LANG');
2184:

Line 2185: CURSOR booking_csr (p_booking_id ota_delegate_bookings.booking_id%TYPE)

2181: WHERE booking_id = l_booking_id
2182: and tdb.booking_status_type_id = btt.booking_status_type_id
2183: and btt.language = USERENV('LANG');
2184:
2185: CURSOR booking_csr (p_booking_id ota_delegate_bookings.booking_id%TYPE)
2186: IS
2187: SELECT b.object_version_number
2188: FROM ota_delegate_bookings b
2189: WHERE b.booking_id = p_booking_id;

Line 2188: FROM ota_delegate_bookings b

2184:
2185: CURSOR booking_csr (p_booking_id ota_delegate_bookings.booking_id%TYPE)
2186: IS
2187: SELECT b.object_version_number
2188: FROM ota_delegate_bookings b
2189: WHERE b.booking_id = p_booking_id;
2190:
2191: CURSOR finance_csr (p_booking_id ota_finance_lines.booking_id%TYPE)
2192: IS

Line 2201: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;

2197:
2198: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
2199: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
2200: l_booking_status ota_booking_status_types_tl.name%TYPE;
2201: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
2202: l_request_rec csr_get_request_info%ROWTYPE;
2203: l_req_member_rec csr_get_request_members%ROWTYPE;
2204: l_booking_id ota_delegate_bookings.booking_id%TYPE;
2205: l_person_name per_all_people_f.full_name%TYPE;

Line 2204: l_booking_id ota_delegate_bookings.booking_id%TYPE;

2200: l_booking_status ota_booking_status_types_tl.name%TYPE;
2201: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
2202: l_request_rec csr_get_request_info%ROWTYPE;
2203: l_req_member_rec csr_get_request_members%ROWTYPE;
2204: l_booking_id ota_delegate_bookings.booking_id%TYPE;
2205: l_person_name per_all_people_f.full_name%TYPE;
2206:
2207:
2208: l_class_name varchar2(80);