APPS.HR_APPROVAL_SS dependencies on PER_APPRAISALS

Line 3104: IF NVL(l_transaction_ref_table,'XXX') = 'PER_APPRAISALS' and lv_result_code = 'DEL' THEN

3100: OPEN csr_txn(c_transaction_id);
3101: FETCH csr_txn INTO l_transaction_ref_table,l_transaction_ref_id;
3102: CLOSE csr_txn;
3103: hr_utility.trace('txn_ref_table: '||l_transaction_ref_table);
3104: IF NVL(l_transaction_ref_table,'XXX') = 'PER_APPRAISALS' and lv_result_code = 'DEL' THEN
3105: hr_utility.trace('returning with resubmit as we donot want RFC deletion for appraisal');
3106: result := 'COMPLETE:XYZ'; --so that this takes the default option in the WF
3107: RETURN;
3108: END IF;

Line 4672: l_appraisal_id per_appraisals.appraisal_id%type;

4668: lv_role_name wf_roles.name%type;
4669: lv_role_disp_name wf_roles.name%type;
4670: lv_role_orig_system wf_roles.orig_system%type;
4671: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4672: l_appraisal_id per_appraisals.appraisal_id%type;
4673: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
4674: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
4675: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
4676: begin

Line 4673: l_main_appraiser_id per_appraisals.main_appraiser_id%type;

4669: lv_role_disp_name wf_roles.name%type;
4670: lv_role_orig_system wf_roles.orig_system%type;
4671: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4672: l_appraisal_id per_appraisals.appraisal_id%type;
4673: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
4674: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
4675: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
4676: begin
4677:

Line 4674: l_appraiser_person_id per_appraisals.appraiser_person_id%type;

4670: lv_role_orig_system wf_roles.orig_system%type;
4671: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4672: l_appraisal_id per_appraisals.appraisal_id%type;
4673: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
4674: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
4675: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
4676: begin
4677:
4678: -- get the appraisal id

Line 4675: l_appraisee_person_id per_appraisals.appraisee_person_id%type;

4671: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4672: l_appraisal_id per_appraisals.appraisal_id%type;
4673: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
4674: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
4675: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
4676: begin
4677:
4678: -- get the appraisal id
4679: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_item_type ,

Line 4690: from per_appraisals

4686: begin
4687:
4688: select MAIN_APPRAISER_ID,APPRAISER_PERSON_ID,APPRAISEE_PERSON_ID
4689: into l_main_appraiser_id, l_appraiser_person_id,l_appraisee_person_id
4690: from per_appraisals
4691: where APPRAISAL_ID=l_appraisal_id;
4692:
4693: exception
4694: when others then

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

5341: if(p_transaction_id is not null) then
5342: select * into lr_hr_api_transaction_rec
5343: from hr_api_transactions
5344: where transaction_id=p_transaction_id;
5345: if(lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS') then
5346: -- appraisal specfic
5347:
5348: -- set the item attributes specific to appraisals
5349: -- get the wf role info for the login user

Line 6034: if l_trans_ref_table = 'PER_APPRAISALS' then

6030: l_trans_ref_table := null;
6031:
6032: end;
6033:
6034: if l_trans_ref_table = 'PER_APPRAISALS' then
6035: return;
6036: end if;
6037:
6038: