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 1919: procedure init_course_eval_notif(p_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type) is

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

Line 1934: FROM OTA_DELEGATE_BOOKINGS tdb,

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

Line 2062: l_booking_id ota_delegate_bookings.booking_id%type;

2058: l_location_name hr_locations_all_tl.location_code%type;
2059: l_training_center hr_all_organization_units.name%TYPE;
2060: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
2061:
2062: l_booking_id ota_delegate_bookings.booking_id%type;
2063: l_person_id number(15);
2064:
2065: l_event_data clob;
2066: l_text varchar2(2000);

Line 2083: from ota_delegate_bookings odb, ota_booking_status_types bst

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