APPS.HR_APPROVAL_SS dependencies on PER_APPRAISALS

Line 3645: l_appraisal_id per_appraisals.appraisal_id%type;

3641: lv_role_name wf_roles.name%type;
3642: lv_role_disp_name wf_roles.name%type;
3643: lv_role_orig_system wf_roles.orig_system%type;
3644: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3645: l_appraisal_id per_appraisals.appraisal_id%type;
3646: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
3647: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
3648: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
3649: begin

Line 3646: l_main_appraiser_id per_appraisals.main_appraiser_id%type;

3642: lv_role_disp_name wf_roles.name%type;
3643: lv_role_orig_system wf_roles.orig_system%type;
3644: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3645: l_appraisal_id per_appraisals.appraisal_id%type;
3646: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
3647: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
3648: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
3649: begin
3650:

Line 3647: l_appraiser_person_id per_appraisals.appraiser_person_id%type;

3643: lv_role_orig_system wf_roles.orig_system%type;
3644: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3645: l_appraisal_id per_appraisals.appraisal_id%type;
3646: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
3647: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
3648: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
3649: begin
3650:
3651: -- get the appraisal id

Line 3648: l_appraisee_person_id per_appraisals.appraisee_person_id%type;

3644: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3645: l_appraisal_id per_appraisals.appraisal_id%type;
3646: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
3647: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
3648: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
3649: begin
3650:
3651: -- get the appraisal id
3652: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_item_type ,

Line 3663: from per_appraisals

3659: begin
3660:
3661: select MAIN_APPRAISER_ID,APPRAISER_PERSON_ID,APPRAISEE_PERSON_ID
3662: into l_main_appraiser_id, l_appraiser_person_id,l_appraisee_person_id
3663: from per_appraisals
3664: where APPRAISAL_ID=l_appraisal_id;
3665:
3666: exception
3667: when others then

Line 4304: if(lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS') then

4300: if(p_transaction_id is not null) then
4301: select * into lr_hr_api_transaction_rec
4302: from hr_api_transactions
4303: where transaction_id=p_transaction_id;
4304: if(lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS') then
4305: -- appraisal specfic
4306:
4307: -- set the item attributes specific to appraisals
4308: -- get the wf role info for the login user