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 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 54


Procedure delete_cancel_line
 (
  p_line_id    IN Number,
  p_org_id     IN Number,
  p_UOM        IN Varchar2,
  P_daemon_type   IN varchar2,
  x_return_status OUT NOCOPY varchar2)

  is

  l_proc    varchar2(72) := g_package||'cnc_evt_enr';

Line: 97


SELECT
  Event_ID,
  Business_Group_ID ,
  Event_status,
  Title,
  Owner_Id,
  Object_Version_number
  FROM OTA_Events_vl --MLS change _vl added
  WHERE Line_Id = p_line_Id;

Line: 108


 SELECT
   email_address, full_name
 FROM
   per_all_people_f
 WHERE
 person_id = l_owner_id and
   trunc(sysdate) between
   effective_start_date and
   effective_end_date;

Line: 119


SELECT
 USER_NAME
FROM
 FND_USER
WHERE
Employee_id = l_owner_id
AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD'));      --Bug 5676892

Line: 130


 SELECT
    tdb.Booking_id,
    tdb.Booking_status_type_id,
    tdb.Business_group_id,
    tdb.Object_version_number,
    tdb.event_id,
    evt.title
 FROM
    OTA_DELEGATE_BOOKINGS tdb,
    OTA_EVENTS_tl evt -- MLS change _tl added
 WHERE
    tdb.Line_id = p_line_id and
    evt.event_id = tdb.event_id;

Line: 147


 SELECT
   Type
 FROM
   OTA_BOOKING_STATUS_TYPES
 WHERE
   booking_status_type_id = l_booking_status_type_id;

Line: 155


SELECT to_date(to_char(evt.Course_start_date,'DD/MM/YYYY')||EVT.Course_start_time,'DD/MM/YYYYHH24:MI'),
       OWNER_ID
FROM   OTA_EVENTS  EVT
WHERE  evt.event_id = p_event_id;

Line: 161


SELECT
   sysdate
FROM
   dual;

Line: 217


                  OTA_EVT_API_UPD2.UPDATE_EVENT (
                                                 P_EVENT                      => 'STATUS',
                                                 P_EVENT_ID                   => l_event_id,
                                                 P_OBJECT_VERSION_NUMBER      => l_event_ovn,
                                                 P_EVENT_STATUS               => l2_event_status,
                                                 P_VALIDATE                   => false,
                                                 P_BOOKING_STATUS_TYPE_ID     => l_booking_status_type_id,
                                                 P_UPDATE_FINANCE_LINE        => 'C',
                                                 P_DATE_STATUS_CHANGED        => l_sysdate);

Line: 258


            ,p_comments       => 'The Order Line for this event has been deleted.'
            ,p_Line_id        => Null
            ,p_Org_id         => Null
            ,P_validate       => False);

Line: 323


       select to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') into l_wf_date from dual;

Line: 339


               ota_tdb_api_upd2.update_enrollment(
         p_booking_id         =>  l_booking_id
         ,p_object_version_number   => l_enr_ovn
         ,p_event_id       => l_event_id
         ,p_daemon_flag       => 'Y'
         ,p_tfl_object_version_number  => l_tfl_ovn
              ,p_booking_status_type_id   => l_Booking_status_type_id
      -- ,p_update_finance_line     => 'N'
         ,p_finance_line_id      => l_new_fl
         ,p_daemon_type       => p_daemon_type
         ,p_status_change_comments  => null); /* Bug# 3469326 */

Line: 463


 SELECT
    Event_id,
    Booking_id,
    Booking_status_type_id,
    Business_group_id,
    Object_version_number,
    daemon_flag,
    daemon_type,
    line_id,
    old_event_id,    -- added for bug #1632104
    date_booking_placed  -- Added for bug 1708632
 FROM
    OTA_DELEGATE_BOOKINGS
 WHERE
    (daemon_flag = 'Y' OR daemon_flag IS NULL) and
    daemon_type is not null and
    business_group_id = l_business_group_id;

Line: 486


SELECT
   BOOKING_STATUS_TYPE_ID
FROM
   OTA_BOOKING_STATUS_TYPES
WHERE
   Name =  l_status_name;

Line: 496


SELECT
   name
FROM
   OTA_BOOKING_STATUS_TYPES_TL  -- MLS change _TL added
WHERE
   booking_status_type_id =  l_booking_status_type_id;

Line: 506


SELECT
    Finance_Line_id,
    Finance_header_id,
    Transfer_Status,
    Object_version_number,
       Sequence_Number,
    Date_raised
FROM
    OTA_FINANCE_LINES
WHERE  Booking_id =  l_Booking_id;

Line: 521


SELECT
    Object_version_number,
       Transfer_status
FROM
   ota_finance_headers
WHERE
   finance_header_id = l_finance_header_id;

Line: 532


SELECT
   count(finance_line_id)
FROM
   ota_finance_lines
WHERE
   finance_header_id = l_finance_header_id;

Line: 540


SELECT
   sysdate
FROM
   dual;

Line: 546


SELECT to_date(to_char(evt.Course_start_date,'DD/MM/YYYY')||EVT.Course_start_time,'DD/MM/YYYYHH24:MI'),
       OWNER_ID
FROM   OTA_EVENTS  EVT
WHERE  evt.event_id = p_event_id;

Line: 612


               p_transaction_type   => 'UPDATE');

Line: 638


                       ,p_Transaction_type      => 'UPDATE');

Line: 662


        ota_tdb_api_upd2.Update_Enrollment(
             p_booking_id        => l_booking_id
               ,p_booking_status_type_id  => l_status_id
            ,p_event_id       => l_event_id
            ,p_business_group_id    => l_enr_business_group_id
            ,p_object_version_number   => l_enr_ovn
            ,p_update_finance_line     => 'N'
            ,p_finance_line_id      => l_new_fl
            ,p_tfl_object_version_number  => l_tfl_ovn
            ,p_validate       => False
            ,p_daemon_flag       => null
            ,p_daemon_type       => null
            ,p_date_status_changed     => sysdate   -- Added for bug# 1708632
            ,p_date_booking_placed     => l_date_booking_placed  -- Added for bug# 1708632
            ,p_status_change_comments  => null); /* Bug# 3469326 */

Line: 700


      ota_tdb_api_upd2.Update_Enrollment(
         p_booking_id         => l_booking_id
            ,p_booking_status_type_id  => l_booking_status_type_id
         ,p_event_id       => l_event_id
         ,p_business_group_id    => l_enr_business_group_id
         ,p_object_version_number   => l_enr_ovn
         ,p_update_finance_line     => 'N'
         ,p_finance_line_id      => l_new_fl
         ,p_validate       => False
         ,p_tfl_object_version_number  => l_tfl_ovn
         ,P_Line_id        => null
         ,p_Org_id         => null
         ,p_daemon_flag       => null
         ,p_daemon_type       => null
         ,p_status_change_comments  => null); /* Bug# 3469326 */

Line: 733


      ota_tdb_api_upd2.Update_Enrollment(
         p_booking_id         => l_booking_id
            ,p_booking_status_type_id  => l_status_id
         ,p_event_id       => l_event_id
         ,p_business_group_id    => l_enr_business_group_id
         ,p_object_version_number   => l_enr_ovn
         ,p_update_finance_line     => 'N'
         ,p_finance_line_id      => l_new_fl
         ,p_validate       => False
         ,p_tfl_object_version_number  => l_tfl_ovn
         ,P_Line_id        => null
         ,p_Org_id         => null
         ,p_daemon_flag       => null
         ,p_daemon_type       => null
         ,p_date_status_changed     => sysdate   -- Added for bug# 1708632
         ,p_date_booking_placed     => l_date_booking_placed  -- Added for bug# 1708632
         ,p_status_change_comments  => null); /* Bug# 3469326 */

Line: 775


      ota_tdb_api_upd2.Update_Enrollment(
         p_booking_id         => l_booking_id
            ,p_booking_status_type_id  => l_booking_status_type_id
         ,p_event_id       => l_event_id
         ,p_business_group_id    => l_enr_business_group_id
         ,p_object_version_number   => l_enr_ovn
         ,p_update_finance_line     => 'N'
         ,p_finance_line_id      => l_new_fl
         ,p_validate       => False
         ,p_tfl_object_version_number  => l_tfl_ovn
         ,p_daemon_flag       => null
         ,p_daemon_type       => null
         ,p_status_change_comments  => null); /* Bug# 3469326 */

Line: 803


      ota_tdb_api_upd2.Update_Enrollment(
         p_booking_id         => l_booking_id
            ,p_booking_status_type_id  => l_booking_status_type_id
         ,p_event_id       => l_event_id
         ,p_business_group_id    => l_enr_business_group_id
         ,p_object_version_number   => l_enr_ovn
         ,p_update_finance_line     => 'N'
         ,p_finance_line_id      => l_new_fl
         ,p_validate       => False
         ,p_tfl_object_version_number  => l_tfl_ovn
         ,p_daemon_flag       => null
         ,p_daemon_type       => null
         ,p_old_event_id         => null
         ,p_status_change_comments  => null); /* Bug# 3469326 */

Line: 1013


l_update_finance              varchar2(1);

Line: 1019


SELECT
  Event_ID,
  Business_Group_ID ,
  Object_Version_number,
  maximum_attendees
  FROM OTA_Events
  WHERE Line_Id = p_line_Id;

Line: 1029


SELECT
  booking_id,
  Object_Version_number,
  business_group_id,
  booking_status_type_id
  FROM OTA_Delegate_bookings
  WHERE event_Id = l_event_id and
  number_of_places = l_max_attendee;

Line: 1039


Select finance_line_id,
object_version_number
FROM OTA_FINANCE_LINES
WHERE booking_id = l_booking_id;

Line: 1048


 IF p_uom = 'EVT' AND p_operation = 'UPDATE' THEN

  OPEN C_event;

Line: 1068


            select count(*) into l_count
            from ota_delegate_bookings
            where  event_id = l_event_id;

Line: 1080


                  l_update_finance := 'Y';

Line: 1082


                  l_update_finance := 'N';

Line: 1088


             ota_tdb_api_upd2.Update_Enrollment(
         p_booking_id         => db.booking_id
            ,p_event_id       => l_event_id
         ,p_business_group_id    => db.business_group_id
                   ,p_booking_status_type_id => db.booking_status_type_id
         ,p_object_version_number   => l_booking_ovn
         ,p_update_finance_line     => l_update_finance
         ,p_finance_line_id      => l_finance_line_id
                   ,p_number_of_places         => p_max_attendee
         ,p_validate       => False
         ,p_tfl_object_version_number  => l_tfl_ovn
         ,p_status_change_comments  => null); /* Bug# 3469326 */