APPS.OTA_CERT_APPROVAL_SS SQL Statements

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

Line: 23

select ctl.name, ctb.initial_completion_date
from ota_Certifications_tl ctl , ota_Certifications_b ctb
where ctl.certification_id = ctb.certification_id
and ctl.Language= USERENV('LANG')
and ctl.certification_id =crs_certification_id;

Line: 179

      hr_transaction_api.delete_transaction_step(p_validate                    => false
        					,p_transaction_step_id         => l_old_transaction_step_id
        					,p_person_id                   => p_login_person_id
       						,p_object_version_number       => l_old_object_version_number);

Line: 429

                             p_message_name => 'HR_UPDATE_NOT_ALLOWED');

Line: 678

 Select name,description,objectives,purpose,
 to_char(initial_completion_date, fnd_profile.value('ICX_DATE_FORMAT_MASK')),
 initial_completion_duration || initial_compl_duration_units,
 renewal_duration || renewal_duration_units,
 notify_days_before_expire,initial_period_comments
 from ota_certifications_vl
 where certification_id = crs_certification_id;

Line: 765

select ctl.name
from ota_Certifications_tl ctl , ota_Certifications_b ctb
where ctl.certification_id = ctb.certification_id
and ctl.Language= USERENV('LANG')
and ctl.certification_id =crs_certification_id;

Line: 942

procedure update_cert_enrollment_tt
(p_validate IN BOOLEAN,
p_transaction_step_id IN NUMBER,
p_trans_mode in varchar2 default null,
p_cert_enroll_id in number default null,
itemtype     in varchar2 default null,
  itemkey      in varchar2 default null)
  is

l_cert_enrollment_id number;

Line: 996

select certification_id, object_version_number
from ota_cert_enrollments
where cert_enrollment_id = crs_cert_enrollment_id;

Line: 1037

  ota_cert_enrollment_api.update_cert_enrollment
  (
   p_effective_date                 =>   l_effective_date
  ,p_validate                       =>      p_validate
  ,p_certification_id               =>   l_certification_id
  ,p_certification_status_code      =>   l_certification_status
  ,p_cert_enrollment_id             =>   l_cert_enrollment_id
  ,p_object_version_number          =>   l_object_version_number
  );

Line: 1181

end update_cert_enrollment_tt;

Line: 1196

 Select cert_enrollment_id
 from ota_cert_enrollments
 where certification_id = l_certification_id
 and person_id = l_person_id
 and business_group_id = ota_general.get_business_group_id();*/

Line: 1229

                    update hr_api_transaction_values
                    set varchar2_value = 'APPROVE'
                    where transaction_step_id = p_transaction_step_id
                    and name = 'P_FROM';

Line: 1237

   update_cert_enrollment_tt(p_validate => p_validate, p_transaction_step_id => p_transaction_step_id);

Line: 1304

       update_cert_enrollment_tt(p_validate => false,
                            p_transaction_step_id => l_trans_step_id,
                                 p_trans_mode => 'CANCEL',
                                 itemtype => itemtype,
                                 itemkey  => itemkey);