APPS.HR_APPRAISAL_WORKFLOW_SS SQL Statements

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

Line: 40

    select 1
    from   wf_item_attribute_values wiav
    where  wiav.item_type = p_item_type
    and    wiav.item_key  = p_item_key
    and    wiav.name      = p_name;

Line: 81

        select system_params
        into l_system_params
        from per_appraisals
        where appraisal_id=ln_appraisal_id;

Line: 91

        update per_appraisals
        set
        system_params              = l_system_params
        where appraisal_id = ln_appraisal_id;

Line: 132

  ln_selected_person_id   hr_api_transactions.selected_person_id%TYPE;

Line: 153

    ln_selected_person_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HR_APPRAISEE_PERSON_ID',true);

Line: 168

                                        ,p_selected_person_id=>ln_selected_person_id
                                        ,p_transaction_effective_date=>trunc(sysdate)
                                        ,p_process_name=>lv_process_name
                                        ,result=>result) ;

Line: 211

       select APPRAISAL_ID, MAIN_APPRAISER_ID,APPRAISER_PERSON_ID,
              APPRAISEE_PERSON_ID,SYSTEM_PARAMS,system_type,assignment_id
       into   l_appraisal_id,l_main_appraiser_id, l_appraiser_person_id,
              l_appraisee_person_id,l_system_params,l_system_type,l_assignment_id
       from per_appraisals
       where APPRAISAL_ID=l_appraisal_id;

Line: 310

            select wma.display_name
             into   lv_link_label
             from   wf_notifications  wn, wf_message_attributes_vl  wma
             where  wn.notification_id  = document_id
             and    wn.message_name     = wma.message_name
             and    wma.message_type    = lv_item_type
             and    wma.name            = 'OBJECT_URL';

Line: 329

            select web_html_call,parameters
            into lv_web_html_call,lv_params
            from fnd_form_functions_vl
            where function_name=lv_pageFunc;

Line: 591

     select instr(lv_participants_list,hr_general_utilities.g_separator) into check_sep from dual;

Line: 656

     select person_id,participation_type
     into ln_participant_person_id,lv_participant_type
     from per_participants
     where participation_in_id = ln_appraisal_id
     and participant_id=ln_participant_id;

Line: 813

       SELECT process_activity
       into ln_appr_approval_block_id
       FROM   WF_ITEM_ACTIVITY_STATUSES IAS
       WHERE  ias.item_type          = p_itemType
       and    ias.item_key           = p_itemKey
       and    ias.activity_status    = 'NOTIFIED'
       and    ias.process_activity   not in
                            (getApprovalBlockId.ln_appr_main_block_id,getApprovalBlockId.ln_appr_particp_block_id);

Line: 836

       SELECT process_activity
       into ln_appr_approval_block_id
       FROM   WF_ITEM_ACTIVITY_STATUSES IAS
       WHERE  ias.item_type          = p_itemType
       and    ias.item_key           = p_itemKey
       and    ias.activity_status    = 'NOTIFIED'
       and    ias.notification_id is not null;

Line: 885

       select MAIN_APPRAISER_ID
       into   l_main_appraiser_id
       from per_appraisals
       where APPRAISAL_ID=l_appraisal_id;

Line: 973

PROCEDURE  update_appraisal_system_status
( p_itemtype in varchar2
, p_itemkey in varchar2
,p_status   in varchar2
)
is
-- local variables
l_appraisal_id per_appraisals.appraisal_id%type;

Line: 986

    hr_utility.set_location('Entered:'|| gv_package || '.update_appraisal_system_status', 1);

Line: 998

     select appraiser_person_id, object_version_number,system_params
        into l_appraiser_person_id,l_object_version_number,l_system_params
    from per_appraisals
   where appraisal_id=l_appraisal_id;

Line: 1010

        hr_utility.set_location('Calling hr_appraisals_api.update_appraisal with p_appraisal_id:
                                 p_object_version_number:p_appraiser_person_id:p_appraisal_system_status '
                                 || l_appraisal_id||':'||l_object_version_number||':'
                                 ||l_appraiser_person_id||p_status,3);

Line: 1016

     hr_appraisals_api.update_appraisal(p_effective_date=>trunc(sysdate),
                     p_appraisal_id=>l_appraisal_id,
                     p_object_version_number=>l_object_version_number,
                     p_appraiser_person_id=>l_appraiser_person_id,
                     p_appraisal_system_status=>p_status  --7210916 Bug Fix ,
                    --p_system_params => l_system_params
                    );

Line: 1024

    hr_utility.set_location('Leaving:'|| gv_package || '.update_appraisal_system_status', 10);

Line: 1028

      wf_core.Context(gv_package, '.update_appraisal_system_status', p_itemtype, p_itemkey);

Line: 1029

      hr_utility.trace(' exception in  '||gv_package||'.update_appraisal_system_status : ' || sqlerrm);

Line: 1032

end update_appraisal_system_status;

Line: 1048

       update_appraisal_system_status(p_itemtype=>p_itemtype, p_itemkey=>p_itemkey,p_status=>'RFC');

Line: 1074

       update_appraisal_system_status(p_itemtype=>p_itemtype, p_itemkey=>p_itemkey,p_status=>'ONGOING');

Line: 1177

 SELECT NVL(appr.provide_overall_feedback,'N')
   INTO l_provide_feedback
   from per_appraisals appr
  where appr.appraisal_id = p_appraisal_id;