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 522: l_add_struct_d(l_add_struct_d.count) := 'OTA_DELEGATE_BOOKINGS';

518:
519: -- Ignore Enrollment Dff Validation for some cases
520: 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
521: l_add_struct_d.extend(1);
522: l_add_struct_d(l_add_struct_d.count) := 'OTA_DELEGATE_BOOKINGS';
523: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
524: l_ignore_dff_validation := 'Y';
525: else
526: l_ignore_dff_validation := 'N';

Line 1429: ota_delegate_bookings tdb

1425: SELECT evt.course_start_time
1426: ,evt.course_start_date
1427: ,evt.event_id
1428: FROM ota_events evt,
1429: ota_delegate_bookings tdb
1430: WHERE tdb.event_id = evt.event_id
1431: AND tdb.booking_id = p_booking_id;
1432:
1433: CURSOR csr_get_waitlist_count(p_event_id NUMBER) IS

Line 1435: FROM ota_delegate_bookings tdb

1431: AND tdb.booking_id = p_booking_id;
1432:
1433: CURSOR csr_get_waitlist_count(p_event_id NUMBER) IS
1434: SELECT 1
1435: FROM ota_delegate_bookings tdb
1436: ,ota_booking_status_types bst
1437: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1438: AND bst.type = 'W'
1439: AND tdb.event_id = p_event_id;

Line 1610: l_old_event_id ota_delegate_bookings.event_id%TYPE;

1606: l_sysdate VARCHAR2(30);
1607: l_course_start_date ota_events.course_start_date%TYPE;
1608: l_course_start_time ota_events.course_start_time%TYPE;
1609: l_event_title ota_events.title%TYPE;
1610: l_old_event_id ota_delegate_bookings.event_id%TYPE;
1611: l_owner_id ota_events.owner_id%TYPE;
1612: l_username fnd_user.user_name%TYPE;
1613: l_auto_waitlist_days NUMBER;
1614: l_auto_waitlist varchar2(1) := 'N';

Line 1639: l_existing_booking_status_id ota_delegate_bookings.booking_status_type_id%TYPE;

1635: --bug 603768 changes ends
1636:
1637: --Bug6801749:ANY CHANGE BY ADMIN TO ENROLLMENT CAUSED DATE_STATUS_CHANGED UPDATE
1638: l_booking_status_type_changed boolean := false;
1639: l_existing_booking_status_id ota_delegate_bookings.booking_status_type_id%TYPE;
1640: l_new_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE := p_booking_status_type_id;
1641:
1642: CURSOR csr_get_cur_booking_status IS
1643: SELECT booking_status_type_id

Line 1640: l_new_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE := p_booking_status_type_id;

1636:
1637: --Bug6801749:ANY CHANGE BY ADMIN TO ENROLLMENT CAUSED DATE_STATUS_CHANGED UPDATE
1638: l_booking_status_type_changed boolean := false;
1639: l_existing_booking_status_id ota_delegate_bookings.booking_status_type_id%TYPE;
1640: l_new_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE := p_booking_status_type_id;
1641:
1642: CURSOR csr_get_cur_booking_status IS
1643: SELECT booking_status_type_id
1644: FROM ota_delegate_bookings

Line 1644: FROM ota_delegate_bookings

1640: l_new_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE := p_booking_status_type_id;
1641:
1642: CURSOR csr_get_cur_booking_status IS
1643: SELECT booking_status_type_id
1644: FROM ota_delegate_bookings
1645: WHERE booking_id = p_booking_id;
1646:
1647: Cursor is_contact
1648: is

Line 1650: Ota_delegate_bookings

1646:
1647: Cursor is_contact
1648: is
1649: Select contact_id,delegate_contact_id from
1650: Ota_delegate_bookings
1651: where booking_id= p_booking_id;
1652:
1653: l_delegate_contact_id number(15);
1654: l_contact_id number(15);

Line 1673: from ota_booking_status_types bst, ota_delegate_bookings tdb

1669: l_LO_id ota_offerings.Learning_object_id%type;
1670:
1671: cursor get_status_info is
1672: select bst.Type
1673: from ota_booking_status_types bst, ota_delegate_bookings tdb
1674: where bst.booking_status_type_id= tdb.booking_status_type_id
1675: and tdb.booking_id = p_booking_id;
1676:
1677: l_enroll_type varchar2(30);

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

1682: l_organization_id_changed boolean;
1683: l_delegate_person_id_changed boolean;
1684: l_delegate_asg_changed boolean;
1685:
1686: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
1687: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
1688: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
1689: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
1690: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;

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

1683: l_delegate_person_id_changed boolean;
1684: l_delegate_asg_changed boolean;
1685:
1686: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
1687: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
1688: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
1689: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
1690: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
1691: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;

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

1684: l_delegate_asg_changed boolean;
1685:
1686: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
1687: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
1688: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
1689: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
1690: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
1691: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
1692:

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

1685:
1686: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
1687: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
1688: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
1689: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
1690: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
1691: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
1692:
1693: CURSOR csr_get_enr_details IS

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

1686: l_new_event_id ota_delegate_bookings.event_id%TYPE := p_event_id;
1687: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
1688: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
1689: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
1690: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
1691: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
1692:
1693: CURSOR csr_get_enr_details IS
1694: SELECT event_id, customer_id, organization_id,

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

1687: l_new_customer_id ota_delegate_bookings.customer_id%TYPE := p_customer_id;
1688: l_new_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
1689: l_new_organization_id ota_delegate_bookings.organization_id%TYPE := p_organization_id;
1690: l_new_del_asg_id ota_delegate_bookings.delegate_assignment_id%TYPE := p_delegate_assignment_id;
1691: l_new_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
1692:
1693: CURSOR csr_get_enr_details IS
1694: SELECT event_id, customer_id, organization_id,
1695: delegate_person_id, delegate_assignment_id,

Line 1697: FROM ota_delegate_bookings

1693: CURSOR csr_get_enr_details IS
1694: SELECT event_id, customer_id, organization_id,
1695: delegate_person_id, delegate_assignment_id,
1696: delegate_contact_id
1697: FROM ota_delegate_bookings
1698: WHERE booking_id = p_booking_id;
1699:
1700:
1701: l_enr_details_rec csr_get_enr_details%ROWTYPE;

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

1986:
1987: -- Ignore Enrollment Dff Validation for some cases
1988: 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
1989: l_add_struct_d.extend(1);
1990: l_add_struct_d(l_add_struct_d.count) := 'OTA_DELEGATE_BOOKINGS';
1991: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
1992: l_ignore_dff_validation := 'Y';
1993: ELSE
1994: l_ignore_dff_validation := 'N';

Line 2252: select delegate_person_id into l_person_id from ota_delegate_bookings

2248: FETCH is_contact INTO l_contact_id,l_delegate_contact_id;
2249: CLOSE is_contact;
2250:
2251: IF (p_delegate_person_id = hr_api.g_number) THEN
2252: select delegate_person_id into l_person_id from ota_delegate_bookings
2253: where booking_id = p_booking_id;
2254: else l_person_id := p_delegate_person_id;
2255: END IF;
2256:

Line 2923: l_event_id ota_delegate_bookings.event_id%TYPE;

2919: l_course_start_date ota_events.course_start_date%TYPE;
2920: l_course_start_time ota_events.course_start_time%TYPE;
2921: l_event_title ota_events.title%TYPE;
2922: l_owner_id ota_events.owner_id%TYPE;
2923: l_event_id ota_delegate_bookings.event_id%TYPE;
2924: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
2925: l_booking_status ota_booking_status_types.type%TYPE;
2926: l_username fnd_user.user_name%TYPE;
2927: l_auto_waitlist_days NUMBER;

Line 2924: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;

2920: l_course_start_time ota_events.course_start_time%TYPE;
2921: l_event_title ota_events.title%TYPE;
2922: l_owner_id ota_events.owner_id%TYPE;
2923: l_event_id ota_delegate_bookings.event_id%TYPE;
2924: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
2925: l_booking_status ota_booking_status_types.type%TYPE;
2926: l_username fnd_user.user_name%TYPE;
2927: l_auto_waitlist_days NUMBER;
2928: l_auto_waitlist VARCHAR2(2) := 'N';

Line 2950: FROM ota_delegate_bookings

2946: AND trunc(sysdate) BETWEEN trunc(start_date) AND nvl(trunc(end_date),trunc(sysdate)+1);
2947:
2948: CURSOR booking_csr(p_booking_id NUMBER) IS
2949: SELECT event_id,booking_status_type_id
2950: FROM ota_delegate_bookings
2951: WHERE booking_id = p_booking_id;
2952:
2953: CURSOR booking_status_csr(l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE) IS
2954: SELECT type

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

2949: SELECT event_id,booking_status_type_id
2950: FROM ota_delegate_bookings
2951: WHERE booking_id = p_booking_id;
2952:
2953: CURSOR booking_status_csr(l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE) IS
2954: SELECT type
2955: FROM ota_booking_status_types
2956: WHERE booking_status_type_id = l_booking_status_type_id;
2957:

Line 3178: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;

3174: p_event_id in number,
3175: p_booking_status_type_id in number
3176: ) IS
3177:
3178: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
3179: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
3180: l_customer_id ota_delegate_bookings.customer_id%TYPE;
3181: l_event_id ota_events.event_id%TYPE;
3182: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;

Line 3179: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;

3175: p_booking_status_type_id in number
3176: ) IS
3177:
3178: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
3179: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
3180: l_customer_id ota_delegate_bookings.customer_id%TYPE;
3181: l_event_id ota_events.event_id%TYPE;
3182: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3183: l_check_prereq boolean;

Line 3180: l_customer_id ota_delegate_bookings.customer_id%TYPE;

3176: ) IS
3177:
3178: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
3179: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
3180: l_customer_id ota_delegate_bookings.customer_id%TYPE;
3181: l_event_id ota_events.event_id%TYPE;
3182: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3183: l_check_prereq boolean;
3184: l_old_status_type varchar2(30);

Line 3182: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;

3178: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
3179: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
3180: l_customer_id ota_delegate_bookings.customer_id%TYPE;
3181: l_event_id ota_events.event_id%TYPE;
3182: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3183: l_check_prereq boolean;
3184: l_old_status_type varchar2(30);
3185: l_new_status_type varchar2(30);
3186: