APPS.HR_TRANSACTION_SS dependencies on PER_APPRAISALS

Line 723: if(upper(l_transaction_ref_table)='PER_APPRAISALS') then

719: into l_transaction_ref_table
720: from hr_api_transactions
721: where transaction_id=ln_transaction_id;
722:
723: if(upper(l_transaction_ref_table)='PER_APPRAISALS') then
724: hr_appraisal_workflow_ss.set_appraisal_rfc_status(p_itemtype=>itemType
725: ,p_itemkey=>itemKey
726: ,p_actid=>actid
727: ,p_funcmode=>funmode

Line 1137: FROM per_appraisals pa,

1133: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1134: --- Code added for bug10407680
1135: CURSOR csr_appr_dtls(p_transaction_id IN NUMBER) IS
1136: SELECT pa.appraisal_system_status
1137: FROM per_appraisals pa,
1138: hr_api_transactions txn
1139: WHERE txn.transaction_id = p_transaction_id
1140: AND txn.transaction_ref_table = 'PER_APPRAISALS'
1141: AND txn.transaction_ref_id = pa.appraisal_id;

Line 1140: AND txn.transaction_ref_table = 'PER_APPRAISALS'

1136: SELECT pa.appraisal_system_status
1137: FROM per_appraisals pa,
1138: hr_api_transactions txn
1139: WHERE txn.transaction_id = p_transaction_id
1140: AND txn.transaction_ref_table = 'PER_APPRAISALS'
1141: AND txn.transaction_ref_id = pa.appraisal_id;
1142: l_appr_status VARCHAR2(60);
1143: l_allow_delete VARCHAR2(1) := 'Y';
1144: --- End of Code added for bug10407680

Line 1164: IF lv_transaction_ref_table = 'PER_APPRAISALS' THEN

1160: into lv_transaction_ref_table
1161: from hr_api_transactions
1162: where hr_api_transactions.transaction_id=(get_transaction_id(itemtype,itemkey));
1163: --- Code added for bug10407680
1164: IF lv_transaction_ref_table = 'PER_APPRAISALS' THEN
1165: OPEN csr_appr_dtls(get_transaction_id(itemtype,itemkey));
1166: FETCH csr_appr_dtls INTO l_appr_status;
1167: CLOSE csr_appr_dtls;
1168: IF NVL(l_appr_status,'OLD') NOT IN ('COMPLETED','APPRFEEDBACK','DELETED') THEN

Line 1174: if(lv_transaction_ref_table='PER_APPRAISALS') then

1170: END IF;
1171: END IF;
1172: --- End of Code added for bug10407680
1173: /* BUG FIX 3112230
1174: if(lv_transaction_ref_table='PER_APPRAISALS') then
1175: -- call the custom call to update the status
1176: hr_appraisal_workflow_ss.set_appraisal_reject_status(itemtype,itemkey, actid ,
1177: funmode,result );
1178: end if;