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

Line 312: from ota_delegate_bookings odb, ota_booking_status_types bst

308: and evt.event_id=p_event_id;
309:
310: Cursor csr_booking_info is
311: select odb.sign_eval_status,bst.type
312: from ota_delegate_bookings odb, ota_booking_status_types bst
313: where odb.booking_status_type_id = bst.booking_status_type_id
314: and odb.booking_id=p_booking_id;
315:
316: l_sign_required varchar2(1);

Line 591: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;

587: select currency_code from ota_events
588: where event_id = p_event_id;
589:
590: l_currency_code varchar2(40);
591: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
592:
593: begin
594: hr_utility.set_location('Entering:'|| l_proc, 10);
595: --

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

672:
673: -- Ignore Enrollment Dff Validation for some cases
674: 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
675: l_add_struct_d.extend(1);
676: l_add_struct_d(l_add_struct_d.count) := 'OTA_DELEGATE_BOOKINGS';
677: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
678: l_ignore_dff_validation := 'Y';
679: else
680: l_ignore_dff_validation := 'N';

Line 1598: ota_delegate_bookings tdb

1594: SELECT evt.course_start_time
1595: ,evt.course_start_date
1596: ,evt.event_id
1597: FROM ota_events evt,
1598: ota_delegate_bookings tdb
1599: WHERE tdb.event_id = evt.event_id
1600: AND tdb.booking_id = p_booking_id;
1601:
1602: CURSOR csr_get_waitlist_count(p_event_id NUMBER) IS

Line 1604: FROM ota_delegate_bookings tdb

1600: AND tdb.booking_id = p_booking_id;
1601:
1602: CURSOR csr_get_waitlist_count(p_event_id NUMBER) IS
1603: SELECT 1
1604: FROM ota_delegate_bookings tdb
1605: ,ota_booking_status_types bst
1606: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1607: AND bst.type = 'W'
1608: AND tdb.event_id = p_event_id;

Line 1780: l_old_event_id ota_delegate_bookings.event_id%TYPE;

1776: l_sysdate VARCHAR2(30);
1777: l_course_start_date ota_events.course_start_date%TYPE;
1778: l_course_start_time ota_events.course_start_time%TYPE;
1779: l_event_title ota_events.title%TYPE;
1780: l_old_event_id ota_delegate_bookings.event_id%TYPE;
1781: l_owner_id ota_events.owner_id%TYPE;
1782: l_username fnd_user.user_name%TYPE;
1783: l_auto_waitlist_days NUMBER;
1784: l_auto_waitlist varchar2(1) := 'N';

Line 1809: l_existing_booking_status_id ota_delegate_bookings.booking_status_type_id%TYPE;

1805: --bug 603768 changes ends
1806:
1807: --Bug6801749:ANY CHANGE BY ADMIN TO ENROLLMENT CAUSED DATE_STATUS_CHANGED UPDATE
1808: l_booking_status_type_changed boolean := false;
1809: l_existing_booking_status_id ota_delegate_bookings.booking_status_type_id%TYPE;
1810: l_new_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE := nvl(p_booking_status_type_id,hr_api.g_number);
1811:
1812: CURSOR csr_get_cur_booking_status IS
1813: SELECT booking_status_type_id

Line 1810: l_new_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE := nvl(p_booking_status_type_id,hr_api.g_number);

1806:
1807: --Bug6801749:ANY CHANGE BY ADMIN TO ENROLLMENT CAUSED DATE_STATUS_CHANGED UPDATE
1808: l_booking_status_type_changed boolean := false;
1809: l_existing_booking_status_id ota_delegate_bookings.booking_status_type_id%TYPE;
1810: l_new_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE := nvl(p_booking_status_type_id,hr_api.g_number);
1811:
1812: CURSOR csr_get_cur_booking_status IS
1813: SELECT booking_status_type_id
1814: FROM ota_delegate_bookings

Line 1814: FROM ota_delegate_bookings

1810: l_new_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE := nvl(p_booking_status_type_id,hr_api.g_number);
1811:
1812: CURSOR csr_get_cur_booking_status IS
1813: SELECT booking_status_type_id
1814: FROM ota_delegate_bookings
1815: WHERE booking_id = p_booking_id;
1816:
1817: Cursor is_contact
1818: is

Line 1820: Ota_delegate_bookings

1816:
1817: Cursor is_contact
1818: is
1819: Select contact_id,delegate_contact_id from
1820: Ota_delegate_bookings
1821: where booking_id= p_booking_id;
1822:
1823: l_delegate_contact_id number(15);
1824: l_contact_id number(15);

Line 1843: from ota_booking_status_types bst, ota_delegate_bookings tdb

1839: l_LO_id ota_offerings.Learning_object_id%type;
1840:
1841: cursor get_status_info is
1842: select bst.Type
1843: from ota_booking_status_types bst, ota_delegate_bookings tdb
1844: where bst.booking_status_type_id= tdb.booking_status_type_id
1845: and tdb.booking_id = p_booking_id;
1846:
1847: l_enroll_type varchar2(30);

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

1852: l_organization_id_changed boolean;
1853: l_delegate_person_id_changed boolean;
1854: l_delegate_asg_changed boolean;
1855:
1856: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
1857: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
1858: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
1859: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
1860: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;

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

1853: l_delegate_person_id_changed boolean;
1854: l_delegate_asg_changed boolean;
1855:
1856: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
1857: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
1858: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
1859: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
1860: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
1861: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;

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

1854: l_delegate_asg_changed boolean;
1855:
1856: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
1857: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
1858: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
1859: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
1860: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
1861: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
1862:

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

1855:
1856: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
1857: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
1858: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
1859: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
1860: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
1861: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
1862:
1863: CURSOR csr_get_enr_details IS

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

1856: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
1857: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
1858: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
1859: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
1860: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
1861: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
1862:
1863: CURSOR csr_get_enr_details IS
1864: SELECT event_id, customer_id, organization_id,

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

1857: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
1858: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
1859: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
1860: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
1861: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
1862:
1863: CURSOR csr_get_enr_details IS
1864: SELECT event_id, customer_id, organization_id,
1865: delegate_person_id, delegate_assignment_id,

Line 1867: FROM ota_delegate_bookings

1863: CURSOR csr_get_enr_details IS
1864: SELECT event_id, customer_id, organization_id,
1865: delegate_person_id, delegate_assignment_id,
1866: delegate_contact_id
1867: FROM ota_delegate_bookings
1868: WHERE booking_id = p_booking_id;
1869:
1870:
1871: l_enr_details_rec csr_get_enr_details%ROWTYPE;

Line 1933: FROM ota_delegate_bookings

1929: AND sysdate between NVL(start_date_active, sysdate) AND NVL(end_date_active, (sysdate+1));
1930:
1931: CURSOR c_sign_info IS
1932: SELECT sign_eval_status
1933: FROM ota_delegate_bookings
1934: WHERE booking_id = p_booking_id;
1935:
1936: l_contact_user_id ota_attempts.user_id%type;
1937: l_old_sign_eval_status ota_delegate_bookings.sign_eval_status%type;

Line 1937: l_old_sign_eval_status ota_delegate_bookings.sign_eval_status%type;

1933: FROM ota_delegate_bookings
1934: WHERE booking_id = p_booking_id;
1935:
1936: l_contact_user_id ota_attempts.user_id%type;
1937: l_old_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
1938: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
1939:
1940: l_old_booking_status_type ota_booking_status_types.type%TYPE;
1941: l_new_booking_status_type ota_booking_status_types.type%TYPE;

Line 1938: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;

1934: WHERE booking_id = p_booking_id;
1935:
1936: l_contact_user_id ota_attempts.user_id%type;
1937: l_old_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
1938: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
1939:
1940: l_old_booking_status_type ota_booking_status_types.type%TYPE;
1941: l_new_booking_status_type ota_booking_status_types.type%TYPE;
1942:

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

2187:
2188: -- Ignore Enrollment Dff Validation for some cases
2189: 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
2190: l_add_struct_d.extend(1);
2191: l_add_struct_d(l_add_struct_d.count) := 'OTA_DELEGATE_BOOKINGS';
2192: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
2193: l_ignore_dff_validation := 'Y';
2194: ELSE
2195: l_ignore_dff_validation := 'N';

Line 2463: select delegate_person_id into l_person_id from ota_delegate_bookings

2459: FETCH is_contact INTO l_contact_id,l_delegate_contact_id;
2460: CLOSE is_contact;
2461:
2462: IF (p_delegate_person_id = hr_api.g_number) THEN
2463: select delegate_person_id into l_person_id from ota_delegate_bookings
2464: where booking_id = p_booking_id;
2465: else l_person_id := p_delegate_person_id;
2466: END IF;
2467:

Line 3156: l_event_id ota_delegate_bookings.event_id%TYPE;

3152: l_course_start_date ota_events.course_start_date%TYPE;
3153: l_course_start_time ota_events.course_start_time%TYPE;
3154: l_event_title ota_events.title%TYPE;
3155: l_owner_id ota_events.owner_id%TYPE;
3156: l_event_id ota_delegate_bookings.event_id%TYPE;
3157: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3158: l_booking_status ota_booking_status_types.type%TYPE;
3159: l_username fnd_user.user_name%TYPE;
3160: l_auto_waitlist_days NUMBER;

Line 3157: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;

3153: l_course_start_time ota_events.course_start_time%TYPE;
3154: l_event_title ota_events.title%TYPE;
3155: l_owner_id ota_events.owner_id%TYPE;
3156: l_event_id ota_delegate_bookings.event_id%TYPE;
3157: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3158: l_booking_status ota_booking_status_types.type%TYPE;
3159: l_username fnd_user.user_name%TYPE;
3160: l_auto_waitlist_days NUMBER;
3161: l_auto_waitlist VARCHAR2(2) := 'N';

Line 3183: FROM ota_delegate_bookings

3179: AND trunc(sysdate) BETWEEN trunc(start_date) AND nvl(trunc(end_date),trunc(sysdate)+1);
3180:
3181: CURSOR booking_csr(p_booking_id NUMBER) IS
3182: SELECT event_id,booking_status_type_id
3183: FROM ota_delegate_bookings
3184: WHERE booking_id = p_booking_id;
3185:
3186: CURSOR booking_status_csr(l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE) IS
3187: SELECT type

Line 3186: CURSOR booking_status_csr(l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE) IS

3182: SELECT event_id,booking_status_type_id
3183: FROM ota_delegate_bookings
3184: WHERE booking_id = p_booking_id;
3185:
3186: CURSOR booking_status_csr(l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE) IS
3187: SELECT type
3188: FROM ota_booking_status_types
3189: WHERE booking_status_type_id = l_booking_status_type_id;
3190:

Line 3195: from ota_delegate_bookings

3191: --bug 603768 changes ends
3192:
3193: CURSOR get_person_info IS
3194: select delegate_person_id
3195: from ota_delegate_bookings
3196: where BOOKING_ID = p_booking_id ;
3197:
3198: l_person_id number := -1;
3199:

Line 3424: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;

3420: p_event_id in number,
3421: p_booking_status_type_id in number
3422: ) IS
3423:
3424: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
3425: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
3426: l_customer_id ota_delegate_bookings.customer_id%TYPE;
3427: l_event_id ota_events.event_id%TYPE;
3428: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;

Line 3425: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;

3421: p_booking_status_type_id in number
3422: ) IS
3423:
3424: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
3425: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
3426: l_customer_id ota_delegate_bookings.customer_id%TYPE;
3427: l_event_id ota_events.event_id%TYPE;
3428: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3429: l_check_prereq boolean;

Line 3426: l_customer_id ota_delegate_bookings.customer_id%TYPE;

3422: ) IS
3423:
3424: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
3425: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
3426: l_customer_id ota_delegate_bookings.customer_id%TYPE;
3427: l_event_id ota_events.event_id%TYPE;
3428: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3429: l_check_prereq boolean;
3430: l_old_status_type varchar2(30);

Line 3428: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;

3424: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
3425: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
3426: l_customer_id ota_delegate_bookings.customer_id%TYPE;
3427: l_event_id ota_events.event_id%TYPE;
3428: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3429: l_check_prereq boolean;
3430: l_old_status_type varchar2(30);
3431: l_new_status_type varchar2(30);
3432: