APPS.OTA_ILEARNING2 SQL Statements

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

Line: 20

         28-Feb-02  115.3     HDSHAH  2246791  Need to lock record before calling update_enrollment procedure.
         26-nov-02  115.4    ARKASHYA 2684733  Included NOCOPY directive in the OUT and IN OUT parameters.
*/
--------------------------------------------------------------------------------
g_package  varchar2(33) := '  ota_ilearning2.';  -- Global package name

Line: 74

     select
            max(booking_id) booking_id
     from
            ota_delegate_bookings TDB,
            ota_events            EVT,
            ota_activity_versions OAV
     where
            OAV.rco_id = p_rco_id                             and
            OAV.activity_version_id = EVT.activity_version_id and
            EVT.event_id = TDB.event_id                       and
            TDB.delegate_person_id = p_person_id              and
            TDB.business_group_id  = p_business_group_id;

Line: 89

     select
            booking_status_type_id,
            content_player_status,
            object_version_number,
            event_id,
            date_booking_placed
     from
            ota_delegate_bookings
     where
            booking_id  = l_booking_id;

Line: 103

     select
            finance_line_id,
            object_version_number,
            sequence_number,
            date_raised,
            finance_header_id
     from
            ota_finance_lines
     where
            booking_id      = l_booking_id  and
            cancelled_flag  = 'N'           and
	    transfer_status = 'NT';

Line: 118

     select
            booking_status_type_id
     from
            ota_booking_status_types
     where
            type          = 'A'  and
            default_flag  = 'Y'  and
            active_flag   = 'Y'  and
            business_group_id = p_business_group_id;

Line: 129

Select type
from   ota_booking_status_types
where booking_status_type_id = p_status_type_id;

Line: 135

select object_version_number from
ota_finance_headers
where finance_header_id = p_finance_header_id;

Line: 210

                ,p_transaction_type             => 'UPDATE'                          --  (Input)
                ); */

Line: 216

                p_message := 'Successfully updated finance line ';

Line: 223

                    FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the finance line for RCO ID '|| p_rco_id ||
                                           ', Person ID ' || p_person_id || ', Booking ID-' ||
                                           cur_booking_id.booking_id || ', and Finance Line ID-' || l_finance_line_id
                                           || '. Reason:' || hr_utility.get_message);

Line: 292

              ota_tdb_api_upd2.update_enrollment
              (p_booking_id                 =>  cur_booking_id.booking_id             --   (Input)
              ,p_booking_status_type_id     =>  l_booking_status_type_id              --   (Input)
              ,p_object_version_number      =>  l_ovn                                 --   (In Out)
              ,p_event_id                   =>  l_cur_event_id                        --   (Input)
              ,p_content_player_status      =>  p_status                              --   (Input)
              ,p_score                      =>  p_score                               --   (Input)
              ,p_total_training_time        =>  p_time                                --   (Input)
              ,p_completed_content          =>  p_complete                            --   (Input)
              ,p_total_content              =>  p_total                               --   (Input)
              ,p_tfl_object_version_number  =>  l_tfl_ovn                             --   (In Out)
              ,p_finance_line_id            =>  l_tfl_finance_line_id                 --   (In Out)
              );

Line: 306

              ota_tdb_api_upd2.update_enrollment
              (p_booking_id                 =>  cur_booking_id.booking_id             --   (Input)
              ,p_booking_status_type_id     =>  l_booking_status_type_id              --   (Input)
              ,p_object_version_number      =>  l_ovn                                 --   (In Out)
              ,p_event_id                   =>  l_cur_event_id                        --   (Input)
              ,p_content_player_status      =>  p_status                              --   (Input)
              ,p_score                      =>  p_score                               --   (Input)
              ,p_total_training_time        =>  p_time                                --   (Input)
              ,p_completed_content          =>  p_complete                            --   (Input)
              ,p_total_content              =>  p_total                               --   (Input)
              ,p_tfl_object_version_number  =>  l_tfl_ovn                             --   (In Out)
              ,p_finance_line_id            =>  l_tfl_finance_line_id                 --   (In Out)
              ,p_date_status_changed        =>   sysdate
              ,p_date_booking_placed        => l_date_booking_placed);

Line: 324

            FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated history for RCO ID - '|| p_rco_id ||
                                           ', Person ID ' || p_person_id || ', and Booking ID ' ||
                                           cur_booking_id.booking_id ||'.');

Line: 327

            p_message := 'Successfully updated history ';

Line: 334

            FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update history for RCO ID - '|| p_rco_id ||
                                           ', Person ID ' || p_person_id || ', and Booking ID ' ||
                                           cur_booking_id.booking_id || '. REASON:' || hr_utility.get_message);

Line: 385

l_update                 varchar2(10);