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

Line 47: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type

43: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
44: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
45: -- Added for External LearnerSupport
46: ,p_delegate_contact_id IN NUMBER
47: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type
48: ,p_message_name out nocopy varchar2
49: ,p_tdb_information_category in varchar2
50: ,p_tdb_information1 in varchar2
51: ,p_tdb_information2 in varchar2

Line 98: FROM OTA_DELEGATE_BOOKINGS dbt,

94: WHERE EVENT_ID = TO_NUMBER(p_event_id);
95:
96: CURSOR get_existing_internal IS
97: SELECT count(booking_id)
98: FROM OTA_DELEGATE_BOOKINGS dbt,
99: OTA_BOOKING_STATUS_TYPES bst
100: WHERE dbt.event_id = TO_NUMBER(p_event_id)
101: AND dbt.internal_booking_flag = 'Y'
102: AND dbt.booking_status_type_id = bst.booking_status_type_id

Line 107: FROM OTA_DELEGATE_BOOKINGS dbt,

103: AND bst.type in ('P','A','E'); --Bug 4301617
104:
105: CURSOR get_existing_bookings IS
106: SELECT sum(number_of_places)
107: FROM OTA_DELEGATE_BOOKINGS dbt,
108: OTA_BOOKING_STATUS_TYPES bst
109: WHERE dbt.event_id = TO_NUMBER(p_event_id)
110: AND dbt.booking_status_type_id = bst.booking_status_type_id
111: AND bst.type in ('P','A','E');

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

141:
142: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
143: --
144: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
145: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
146: l_object_version_number BINARY_INTEGER;
147: l_tfl_ovn BINARY_INTEGER;
148: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
149: l_booking_type VARCHAR2(4000);

Line 199: l_internal_booking_flag OTA_DELEGATE_BOOKINGS.internal_booking_flag%TYPE;

195:
196: l_existing_bookings NUMBER;
197: l_maximum_external_allowed NUMBER;
198: l_maximum_attendees NUMBER;
199: l_internal_booking_flag OTA_DELEGATE_BOOKINGS.internal_booking_flag%TYPE;
200: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;
201: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;
202: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
203: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;

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

196: l_existing_bookings NUMBER;
197: l_maximum_external_allowed NUMBER;
198: l_maximum_attendees NUMBER;
199: l_internal_booking_flag OTA_DELEGATE_BOOKINGS.internal_booking_flag%TYPE;
200: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;
201: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;
202: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
203: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;
204: l_email_address OTA_DELEGATE_BOOKINGS.delegate_contact_email%TYPE := NULL;

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

197: l_maximum_external_allowed NUMBER;
198: l_maximum_attendees NUMBER;
199: l_internal_booking_flag OTA_DELEGATE_BOOKINGS.internal_booking_flag%TYPE;
200: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;
201: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;
202: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
203: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;
204: l_email_address OTA_DELEGATE_BOOKINGS.delegate_contact_email%TYPE := NULL;
205: l_person_address_type varchar2(1);

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

198: l_maximum_attendees NUMBER;
199: l_internal_booking_flag OTA_DELEGATE_BOOKINGS.internal_booking_flag%TYPE;
200: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;
201: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;
202: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
203: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;
204: l_email_address OTA_DELEGATE_BOOKINGS.delegate_contact_email%TYPE := NULL;
205: l_person_address_type varchar2(1);
206: l_ext_lrnr_details csr_ext_lrnr_Details%ROWTYPE;

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

199: l_internal_booking_flag OTA_DELEGATE_BOOKINGS.internal_booking_flag%TYPE;
200: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;
201: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;
202: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
203: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;
204: l_email_address OTA_DELEGATE_BOOKINGS.delegate_contact_email%TYPE := NULL;
205: l_person_address_type varchar2(1);
206: l_ext_lrnr_details csr_ext_lrnr_Details%ROWTYPE;
207: l_customer_id HZ_CUST_ACCOUNT_ROLES.cust_account_id%type := NULL;

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

200: l_work_telephone OTA_DELEGATE_BOOKINGS.delegate_contact_phone%TYPE := NULL;
201: l_work_fax OTA_DELEGATE_BOOKINGS.delegate_contact_fax%TYPE := NULL;
202: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
203: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;
204: l_email_address OTA_DELEGATE_BOOKINGS.delegate_contact_email%TYPE := NULL;
205: l_person_address_type varchar2(1);
206: l_ext_lrnr_details csr_ext_lrnr_Details%ROWTYPE;
207: l_customer_id HZ_CUST_ACCOUNT_ROLES.cust_account_id%type := NULL;
208: l_corespondent varchar2(1) := NULL;

Line 718: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;

714: l_event_id ota_events.event_id%TYPE;
715: l_course_start_date ota_events.course_start_date%TYPE;
716: l_course_start_time ota_events.course_start_time%TYPE;
717: l_course_end_date ota_events.course_start_date%TYPE;
718: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
719: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
720: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
721: l_delegate_id ota_delegate_bookings.delegate_person_id%TYPE;
722: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;

Line 719: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;

715: l_course_start_date ota_events.course_start_date%TYPE;
716: l_course_start_time ota_events.course_start_time%TYPE;
717: l_course_end_date ota_events.course_start_date%TYPE;
718: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
719: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
720: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
721: l_delegate_id ota_delegate_bookings.delegate_person_id%TYPE;
722: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
723: l_tmp_booking_id ota_delegate_bookings.booking_id%TYPE;

Line 720: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;

716: l_course_start_time ota_events.course_start_time%TYPE;
717: l_course_end_date ota_events.course_start_date%TYPE;
718: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
719: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
720: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
721: l_delegate_id ota_delegate_bookings.delegate_person_id%TYPE;
722: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
723: l_tmp_booking_id ota_delegate_bookings.booking_id%TYPE;
724: l_cancel_boolean BOOLEAN;

Line 721: l_delegate_id ota_delegate_bookings.delegate_person_id%TYPE;

717: l_course_end_date ota_events.course_start_date%TYPE;
718: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
719: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
720: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
721: l_delegate_id ota_delegate_bookings.delegate_person_id%TYPE;
722: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
723: l_tmp_booking_id ota_delegate_bookings.booking_id%TYPE;
724: l_cancel_boolean BOOLEAN;
725:

Line 722: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;

718: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
719: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
720: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
721: l_delegate_id ota_delegate_bookings.delegate_person_id%TYPE;
722: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
723: l_tmp_booking_id ota_delegate_bookings.booking_id%TYPE;
724: l_cancel_boolean BOOLEAN;
725:
726: CURSOR finance (p_booking_id ota_finance_lines.booking_id%TYPE) IS

Line 723: l_tmp_booking_id ota_delegate_bookings.booking_id%TYPE;

719: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
720: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
721: l_delegate_id ota_delegate_bookings.delegate_person_id%TYPE;
722: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
723: l_tmp_booking_id ota_delegate_bookings.booking_id%TYPE;
724: l_cancel_boolean BOOLEAN;
725:
726: CURSOR finance (p_booking_id ota_finance_lines.booking_id%TYPE) IS
727: SELECT FLN.finance_line_id finance_line_id,

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

760: AND o.activity_version_id = a.activity_version_id
761: AND e.event_id = p_event_id
762: AND language=userenv('LANG');
763:
764: CURSOR booking_csr (p_booking_id ota_delegate_bookings.booking_id%TYPE) IS
765: SELECT b.event_id,
766: b.delegate_person_id,
767: b.delegate_contact_id,
768: b.date_booking_placed,

Line 771: FROM ota_delegate_bookings b

767: b.delegate_contact_id,
768: b.date_booking_placed,
769: b.content_player_status,
770: b.object_version_number
771: FROM ota_delegate_bookings b
772: WHERE b.booking_id = p_booking_id;
773:
774: BEGIN
775:

Line 1311: ota_delegate_bookings ov

1307: ,p_person_id IN NUMBER
1308: ,p_delegate_contact_id IN NUMBER) IS
1309: SELECT ov.booking_id
1310: FROM ota_booking_status_types os,
1311: ota_delegate_bookings ov
1312: WHERE ov.event_id = p_event_id
1313: AND (p_person_id IS NOT NULL AND ov.delegate_person_id = p_person_id
1314: OR p_delegate_contact_id IS NOT NULL and ov.delegate_contact_id = p_delegate_contact_id)
1315: AND os.booking_status_type_id = ov.booking_status_type_id

Line 1324: ota_delegate_bookings ov

1320: ,p_person_id IN NUMBER
1321: ,p_delegate_contact_id IN NUMBER) IS
1322: SELECT ov.booking_id
1323: FROM ota_booking_status_types os,
1324: ota_delegate_bookings ov
1325: WHERE ov.event_id = p_event_id
1326: AND (p_person_id IS NOT NULL AND ov.delegate_person_id = p_person_id
1327: OR p_delegate_contact_id IS NOT NULL and ov.delegate_contact_id = p_delegate_contact_id)
1328: AND os.booking_status_type_id = ov.booking_status_type_id

Line 1698: FROM ota_delegate_bookings

1694: IS
1695:
1696: CURSOR csr_get_ovn IS
1697: SELECT object_version_number
1698: FROM ota_delegate_bookings
1699: WHERE booking_id = p_booking_id;
1700: --
1701: l_ovn BINARY_INTEGER DEFAULT '';
1702:

Line 1815: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;

1811:
1812: -- ------------------------
1813: -- booking_csr variables
1814: -- ------------------------
1815: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
1816: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
1817: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
1818:
1819: -- ------------------------

Line 1816: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;

1812: -- ------------------------
1813: -- booking_csr variables
1814: -- ------------------------
1815: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
1816: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
1817: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
1818:
1819: -- ------------------------
1820: -- Finance_csr Variables

Line 1817: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;

1813: -- booking_csr variables
1814: -- ------------------------
1815: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
1816: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
1817: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
1818:
1819: -- ------------------------
1820: -- Finance_csr Variables
1821: -- ------------------------

Line 1846: l_daemon_flag ota_delegate_bookings.daemon_flag%TYPE;

1842: l_hours_until_class_starts NUMBER;
1843: l_minimum_advance_notice NUMBER;
1844: l_auto_waitlist_days NUMBER;
1845: l_sysdate DATE := SYSDATE;
1846: l_daemon_flag ota_delegate_bookings.daemon_flag%TYPE;
1847: l_daemon_type ota_delegate_bookings.daemon_type%TYPE;
1848: lb_object_version_number ota_delegate_bookings.object_version_number%TYPE;
1849: l_proc VARCHAR2(72) := 'ota_learner_enroll_ss.cancel_enrollment';
1850: l_activity_version_name ota_activity_versions.version_name%TYPE;

Line 1847: l_daemon_type ota_delegate_bookings.daemon_type%TYPE;

1843: l_minimum_advance_notice NUMBER;
1844: l_auto_waitlist_days NUMBER;
1845: l_sysdate DATE := SYSDATE;
1846: l_daemon_flag ota_delegate_bookings.daemon_flag%TYPE;
1847: l_daemon_type ota_delegate_bookings.daemon_type%TYPE;
1848: lb_object_version_number ota_delegate_bookings.object_version_number%TYPE;
1849: l_proc VARCHAR2(72) := 'ota_learner_enroll_ss.cancel_enrollment';
1850: l_activity_version_name ota_activity_versions.version_name%TYPE;
1851:

Line 1848: lb_object_version_number ota_delegate_bookings.object_version_number%TYPE;

1844: l_auto_waitlist_days NUMBER;
1845: l_sysdate DATE := SYSDATE;
1846: l_daemon_flag ota_delegate_bookings.daemon_flag%TYPE;
1847: l_daemon_type ota_delegate_bookings.daemon_type%TYPE;
1848: lb_object_version_number ota_delegate_bookings.object_version_number%TYPE;
1849: l_proc VARCHAR2(72) := 'ota_learner_enroll_ss.cancel_enrollment';
1850: l_activity_version_name ota_activity_versions.version_name%TYPE;
1851:
1852: CURSOR event_csr (p_event_id ota_events.event_id%TYPE)

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

1865: AND o.activity_version_id = a.activity_version_id
1866: AND e.event_id = p_event_id
1867: AND language=userenv('LANG');
1868:
1869: CURSOR booking_csr (p_booking_id ota_delegate_bookings.booking_id%TYPE)
1870: IS
1871: SELECT b.date_booking_placed, b.content_player_status, b.object_version_number
1872: FROM ota_delegate_bookings b
1873: WHERE b.booking_id = p_booking_id;

Line 1872: FROM ota_delegate_bookings b

1868:
1869: CURSOR booking_csr (p_booking_id ota_delegate_bookings.booking_id%TYPE)
1870: IS
1871: SELECT b.date_booking_placed, b.content_player_status, b.object_version_number
1872: FROM ota_delegate_bookings b
1873: WHERE b.booking_id = p_booking_id;
1874:
1875: CURSOR finance_csr (p_booking_id ota_finance_lines.booking_id%TYPE)
1876: IS