APPS.HR_WPM_MASS_SCORE_CARD_TRNSF SQL Statements

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

Line: 29

   procedure  update_score_cards(p_score_card_list varchar2 default null,
                                p_sc_ovn_list varchar2 default null,
                                p_sc_latest_ovn_list  in out nocopy varchar2)
   is
    l_sc_ovn_list varchar2(1000);

Line: 37

    select scorecard_id, object_version_number from per_personal_scorecards
    where scorecard_id = p_sc_id;

Line: 67

                    hr_personal_scorecard_swi.update_scorecard_status
                          (p_validate          =>            hr_Api.g_false_num
                          ,p_effective_date    =>            trunc(sysdate)   -- to be
                          ,p_scorecard_id      =>            l_sc_id
                          ,p_object_version_number   =>      l_sc_ovn
                          ,p_status_code       =>   'TRANSFER'
                          ,p_return_status     =>     api_return_status
                          );

Line: 105

                    hr_personal_scorecard_swi.update_scorecard_status
                          (p_validate          =>            hr_Api.g_false_num
                          ,p_effective_date    =>            trunc(sysdate)   -- to be
                          ,p_scorecard_id      =>            score_card_list.scorecard_id
                          ,p_object_version_number   =>      l_temp_ovn
                          ,p_status_code       =>   'TRANSFER'
                          ,p_return_status     =>     api_return_status
                          );

Line: 134

   end update_score_cards;

Line: 150

     select global_name from per_people_f
     where person_id = p_person_id
     and trunc(sysdate) between effective_start_date and effective_end_date;

Line: 156

     select name from wf_roles
     where orig_system_id  = p_person_id
     and orig_system = 'PER';

Line: 169

       select hr_workflow_item_key_s.NEXTVAL into item_key_number from dual ;

Line: 183

       update_score_cards(score_card_list, sc_ovn_list, l_sc_latest_ovn_list);

Line: 329

     select  wf.name wf_role, people.global_name emp_name, sc.scorecard_name, sc.plan_id
     from per_personal_scorecards sc, per_all_assignments_f asgn,
          per_all_people_f people, wf_roles wf
     where sc.scorecard_id = p_score_card_id
     and asgn.assignment_id = sc.assignment_id
     and sysdate between asgn.effective_start_date and asgn.effective_end_date
     and asgn.person_id = people.person_id
     and  wf.orig_system_id = people.person_id
     and wf.orig_system = 'PER'
     and sysdate between people.effective_start_date and people.effective_end_date;

Line: 342

     select transaction_id from hr_api_transactions
     where transaction_ref_id = p_score_card_id
     and transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
     and creator_person_id = txn_owner;

Line: 350

      select object_version_number from per_personal_scorecards
      where scorecard_id = p_sc_id;

Line: 424

                        hr_personal_scorecard_swi.update_scorecard_status
                          (p_validate          =>            hr_Api.g_false_num
                          ,p_effective_date    =>            trunc(sysdate)   -- to be
                          ,p_scorecard_id      =>            to_number(next_score_card)
                          ,p_object_version_number   =>      next_sc_ovn
                          ,p_status_code       =>   'WKR'
                          ,p_return_status     =>     api_return_status
                          );

Line: 466

                            hr_personal_scorecard_swi.update_scorecard_status
                              (p_validate          =>            hr_Api.g_false_num
                              ,p_effective_date    =>            trunc(sysdate)   -- to be
                              ,p_scorecard_id      =>            to_number(next_score_card)
                              ,p_object_version_number   =>      next_sc_ovn
                              ,p_status_code       =>   'ERROR'
                              ,p_return_status     =>     api_return_status
                              );

Line: 476

                        fnd_msg_pub.Delete_Msg;

Line: 519

                            fnd_msg_pub.Delete_Msg;

Line: 528

                            hr_personal_scorecard_swi.update_scorecard_status
                              (p_validate          =>            hr_Api.g_false_num
                              ,p_effective_date    =>            trunc(sysdate)   -- to be
                              ,p_scorecard_id      =>            to_number(next_score_card)
                              ,p_object_version_number   =>      next_sc_ovn
                              ,p_status_code       =>   'WKR'
                              ,p_return_status     =>     api_return_status
                              );

Line: 543

                            hr_transaction_swi.delete_transaction(score_card_txn_id,hr_Api.g_false_num);