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_INITIALIZATION_WF dependencies on OTA_BOOKING_STATUS_TYPES

Line 699: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

695: l_person_id per_people_f.person_id%type;
696:
697: l_object_type varchar2(240);
698: l_location_name hr_locations_all_tl.location_code%type;
699: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
700: l_timezone varchar2(300);
701:
702:
703:

Line 961: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

957: l_event_type ota_events.event_type%type;
958:
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:

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 1930: l_status_type ota_booking_status_types.type%type;

1926:
1927: l_person_id ota_forum_messages.person_id%type;
1928: l_contact_id ota_forum_messages.contact_id%type;
1929: l_event_id ota_events.event_id%type;
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,

Line 1935: OTA_BOOKING_STATUS_TYPES bst

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:
1939: begin

Line 1964: l_status_type ota_booking_status_types.type%type;

1960: actid IN NUMBER,
1961: funcmode IN VARCHAR2,
1962: resultout OUT nocopy VARCHAR2 ) is
1963:
1964: l_status_type ota_booking_status_types.type%type;
1965: begin
1966: if(funcmode = 'RUN') then
1967: l_status_type := wf_engine.getItemAttrtext(itemtype => itemtype ,itemkey => itemkey ,aname => 'STATUS');
1968:

Line 2060: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

2056: l_event_type ota_events.event_type%type;
2057:
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:

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: