APPS.OTA_INITIALIZATION_WF dependencies on OTA_DELEGATE_BOOKINGS

Line 705: --l_booking_id ota_delegate_bookings.booking_id%type;

701:
702:
703:
704:
705: --l_booking_id ota_delegate_bookings.booking_id%type;
706: /*
707: cursor get_resource_info
708: is
709: select osr.trainer_id

Line 963: l_booking_id ota_delegate_bookings.booking_id%type;

959: --l_object_type varchar2(240);
960: l_location_name hr_locations_all_tl.location_code%type;
961: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
962:
963: l_booking_id ota_delegate_bookings.booking_id%type;
964: l_person_id number(15);
965:
966: cursor get_event_info
967: is

Line 980: from ota_delegate_bookings odb, ota_booking_status_types bst

976: -- get all the person's enrolled into the event
977: cursor get_booking_info
978: is
979: select odb.booking_id , odb.delegate_person_id
980: from ota_delegate_bookings odb, ota_booking_status_types bst
981: where (p_person_id is null or
982: odb.delegate_person_id = p_person_id)
983: and odb.event_id =p_eventid
984: and odb.booking_status_type_id = bst.booking_status_type_id

Line 991: from ota_delegate_bookings odb, ota_booking_status_types bst

987: --Enh 5606090: Language support for Event Details.
988: cursor get_booking_info_class_cancel
989: is
990: select odb.booking_id , odb.delegate_person_id
991: from ota_delegate_bookings odb, ota_booking_status_types bst
992: where (p_person_id is null or
993: odb.delegate_person_id = p_person_id)
994: and odb.event_id =p_eventid
995: and odb.booking_status_type_id = bst.booking_status_type_id;

Line 1126: from ota_delegate_bookings odb,ota_booking_status_types bst

1122:
1123: cursor get_all_wait_Learners(crs_event_id number)
1124: is
1125: select odb.delegate_person_id
1126: from ota_delegate_bookings odb,ota_booking_status_types bst
1127: where odb.event_id = crs_event_id
1128: and odb.booking_status_type_id = bst.booking_status_type_id
1129: and bst.type = 'W';
1130:

Line 1923: procedure init_course_eval_notif(p_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type) is

1919: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
1920: ||','||SUBSTR(SQLERRM, 1, 500));
1921: END send_instructor_reminder_ntf;
1922:
1923: procedure init_course_eval_notif(p_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type) is
1924:
1925: l_proc varchar2(72) := g_package||'init_course_eval_notif';
1926:
1927: l_item_key wf_items.item_key%type;

Line 1938: FROM OTA_DELEGATE_BOOKINGS tdb,

1934: l_status_type ota_booking_status_types.type%type;
1935:
1936: cursor csr_booking_status is
1937: SELECT bst.Type, tdb.delegate_person_id, tdb.contact_id, tdb.event_id
1938: FROM OTA_DELEGATE_BOOKINGS tdb,
1939: OTA_BOOKING_STATUS_TYPES bst
1940: WHERE tdb.booking_id = p_booking_id
1941: AND bst.booking_status_type_id = tdb.booking_status_type_id;
1942:

Line 2067: l_booking_id ota_delegate_bookings.booking_id%type;

2063: l_location_name hr_locations_all_tl.location_code%type;
2064: l_training_center hr_all_organization_units.name%TYPE;
2065: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
2066:
2067: l_booking_id ota_delegate_bookings.booking_id%type;
2068: l_person_id number(15);
2069:
2070: l_event_data clob;
2071: l_text varchar2(2000);

Line 2088: from ota_delegate_bookings odb, ota_booking_status_types bst

2084: -- get all the person's enrolled into the event
2085: cursor get_booking_info
2086: is
2087: select odb.booking_id , odb.delegate_person_id, odb.delegate_contact_id
2088: from ota_delegate_bookings odb, ota_booking_status_types bst
2089: where odb.event_id =p_eventid
2090: and odb.booking_status_type_id = bst.booking_status_type_id
2091: and bst.type in ('P','W','R');
2092: