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_CANCEL_API dependencies on OTA_EVENTS

Line 66: l_event_id ota_events.event_id%type;

62: is
63:
64: l_proc varchar2(72) := g_package||'cnc_evt_enr';
65:
66: l_event_id ota_events.event_id%type;
67: l_event_business_group_id ota_events.business_group_id%type;
68: l_event_status varchar2(100);
69: l_title ota_events_tl.title%type; -- MLS change _tl added
70: l_owner_id ota_events.owner_id%type := null;

Line 67: l_event_business_group_id ota_events.business_group_id%type;

63:
64: l_proc varchar2(72) := g_package||'cnc_evt_enr';
65:
66: l_event_id ota_events.event_id%type;
67: l_event_business_group_id ota_events.business_group_id%type;
68: l_event_status varchar2(100);
69: l_title ota_events_tl.title%type; -- MLS change _tl added
70: l_owner_id ota_events.owner_id%type := null;
71: l_owner_email varchar2(100);

Line 69: l_title ota_events_tl.title%type; -- MLS change _tl added

65:
66: l_event_id ota_events.event_id%type;
67: l_event_business_group_id ota_events.business_group_id%type;
68: l_event_status varchar2(100);
69: l_title ota_events_tl.title%type; -- MLS change _tl added
70: l_owner_id ota_events.owner_id%type := null;
71: l_owner_email varchar2(100);
72: l_type varchar2(4);
73: l_event_ovn ota_events.object_version_number%type;

Line 70: l_owner_id ota_events.owner_id%type := null;

66: l_event_id ota_events.event_id%type;
67: l_event_business_group_id ota_events.business_group_id%type;
68: l_event_status varchar2(100);
69: l_title ota_events_tl.title%type; -- MLS change _tl added
70: l_owner_id ota_events.owner_id%type := null;
71: l_owner_email varchar2(100);
72: l_type varchar2(4);
73: l_event_ovn ota_events.object_version_number%type;
74: l_full_name per_people_f.full_name%type;

Line 73: l_event_ovn ota_events.object_version_number%type;

69: l_title ota_events_tl.title%type; -- MLS change _tl added
70: l_owner_id ota_events.owner_id%type := null;
71: l_owner_email varchar2(100);
72: l_type varchar2(4);
73: l_event_ovn ota_events.object_version_number%type;
74: l_full_name per_people_f.full_name%type;
75:
76: l_booking_id ota_delegate_bookings.booking_id%type;
77: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;

Line 92: -- l_event_owner_id ota_events.owner_id%type;

88: l_event_date date;
89: l_current_date date;
90: l_sysdate date;
91: l_wf_date varchar2(30);
92: -- l_event_owner_id ota_events.owner_id%type;
93:
94: l2_event_status OTA_EVENTS.EVENT_STATUS%TYPE;
95: --
96: CURSOR C_event IS

Line 94: l2_event_status OTA_EVENTS.EVENT_STATUS%TYPE;

90: l_sysdate date;
91: l_wf_date varchar2(30);
92: -- l_event_owner_id ota_events.owner_id%type;
93:
94: l2_event_status OTA_EVENTS.EVENT_STATUS%TYPE;
95: --
96: CURSOR C_event IS
97: SELECT
98: Event_ID,

Line 104: FROM OTA_Events_vl --MLS change _vl added

100: Event_status,
101: Title,
102: Owner_Id,
103: Object_Version_number
104: FROM OTA_Events_vl --MLS change _vl added
105: WHERE Line_Id = p_line_Id;
106:
107: CURSOR C_PEOPLE IS
108: SELECT

Line 139: OTA_EVENTS_tl evt -- MLS change _tl added

135: tdb.event_id,
136: evt.title
137: FROM
138: OTA_DELEGATE_BOOKINGS tdb,
139: OTA_EVENTS_tl evt -- MLS change _tl added
140: WHERE
141: tdb.Line_id = p_line_id and
142: evt.event_id = tdb.event_id;
143:

Line 154: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS

150: OTA_BOOKING_STATUS_TYPES
151: WHERE
152: booking_status_type_id = l_booking_status_type_id;
153: --bug # 5231470 first Date format changed to DD/MM/YYYY from DD-MON-YYYY
154: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS
155: SELECT to_date(to_char(evt.Course_start_date,'DD/MM/YYYY')||EVT.Course_start_time,'DD/MM/YYYYHH24:MI'),
156: OWNER_ID
157: FROM OTA_EVENTS EVT
158: WHERE evt.event_id = p_event_id;

Line 157: FROM OTA_EVENTS EVT

153: --bug # 5231470 first Date format changed to DD/MM/YYYY from DD-MON-YYYY
154: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS
155: SELECT to_date(to_char(evt.Course_start_date,'DD/MM/YYYY')||EVT.Course_start_time,'DD/MM/YYYYHH24:MI'),
156: OWNER_ID
157: FROM OTA_EVENTS EVT
158: WHERE evt.event_id = p_event_id;
159:
160: CURSOR c_sysdate IS
161: SELECT

Line 424: l_event_title ota_events_tl.title%type; -- MLS change _tl added

420: l_booking_status_type ota_booking_status_types.type%type;
421: l_daemon_flag ota_delegate_bookings.daemon_flag%type;
422: l_daemon_type ota_delegate_bookings.daemon_type%type;
423: l_line_id ota_delegate_bookings.line_id%type;
424: l_event_title ota_events_tl.title%type; -- MLS change _tl added
425: l_business_group_id ota_delegate_bookings.business_group_id%type;
426: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
427: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
428: -- Define local variable for status

Line 456: l_owner_id ota_events.owner_id%type;

452:
453: l_different_hours number(11,3);
454: l_event_date date;
455: l_current_date date;
456: l_owner_id ota_events.owner_id%type;
457:
458: l_date_booking_placed date;
459:
460: -- Define Enrollment cursor

Line 545: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS

541: sysdate
542: FROM
543: dual;
544: --bug # 5231470 first date format changed to DD/MM/YYYY from DD-MON-YYYY
545: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS
546: SELECT to_date(to_char(evt.Course_start_date,'DD/MM/YYYY')||EVT.Course_start_time,'DD/MM/YYYYHH24:MI'),
547: OWNER_ID
548: FROM OTA_EVENTS EVT
549: WHERE evt.event_id = p_event_id;

Line 548: FROM OTA_EVENTS EVT

544: --bug # 5231470 first date format changed to DD/MM/YYYY from DD-MON-YYYY
545: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS
546: SELECT to_date(to_char(evt.Course_start_date,'DD/MM/YYYY')||EVT.Course_start_time,'DD/MM/YYYYHH24:MI'),
547: OWNER_ID
548: FROM OTA_EVENTS EVT
549: WHERE evt.event_id = p_event_id;
550:
551:
552: l_proc varchar2(72) := g_package||'cancel_enrollment';

Line 1005: l_event_id ota_events.event_id%type;

1001: x_msg_data out nocopy varchar2
1002: )
1003: IS
1004:
1005: l_event_id ota_events.event_id%type;
1006: l_event_business_group_id ota_events.business_group_id%type;
1007: l_event_ovn ota_events.object_version_number%type;
1008: l_max_attendee ota_events.maximum_attendees%type;
1009: l_return_status varchar2(1) := 'S';

Line 1006: l_event_business_group_id ota_events.business_group_id%type;

1002: )
1003: IS
1004:
1005: l_event_id ota_events.event_id%type;
1006: l_event_business_group_id ota_events.business_group_id%type;
1007: l_event_ovn ota_events.object_version_number%type;
1008: l_max_attendee ota_events.maximum_attendees%type;
1009: l_return_status varchar2(1) := 'S';
1010: l_booking_ovn ota_delegate_bookings.object_version_number%type;

Line 1007: l_event_ovn ota_events.object_version_number%type;

1003: IS
1004:
1005: l_event_id ota_events.event_id%type;
1006: l_event_business_group_id ota_events.business_group_id%type;
1007: l_event_ovn ota_events.object_version_number%type;
1008: l_max_attendee ota_events.maximum_attendees%type;
1009: l_return_status varchar2(1) := 'S';
1010: l_booking_ovn ota_delegate_bookings.object_version_number%type;
1011: l_finance_line_id ota_finance_lines.finance_line_id%type;

Line 1008: l_max_attendee ota_events.maximum_attendees%type;

1004:
1005: l_event_id ota_events.event_id%type;
1006: l_event_business_group_id ota_events.business_group_id%type;
1007: l_event_ovn ota_events.object_version_number%type;
1008: l_max_attendee ota_events.maximum_attendees%type;
1009: l_return_status varchar2(1) := 'S';
1010: l_booking_ovn ota_delegate_bookings.object_version_number%type;
1011: l_finance_line_id ota_finance_lines.finance_line_id%type;
1012: l_tfl_ovn ota_finance_lines.object_version_number%type;

Line 1024: FROM OTA_Events

1020: Event_ID,
1021: Business_Group_ID ,
1022: Object_Version_number,
1023: maximum_attendees
1024: FROM OTA_Events
1025: WHERE Line_Id = p_line_Id;
1026:
1027:
1028: CURSOR c_booking is