eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_TRANSACTION_SWI dependencies on PER_APPRAISALS

Line 1286: lr_per_appraisals_rec per_appraisals%rowtype;

1282: is
1283: -- local variables
1284: editAllowed varchar2(1);
1285: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1286: lr_per_appraisals_rec per_appraisals%rowtype;
1287: l_authenticateNtf boolean;
1288:
1289: CURSOR csr_appr_details (p_appraisal_id IN NUMBER)
1290: IS

Line 1291: SELECT * FROM per_appraisals WHERE appraisal_id = p_appraisal_id;

1287: l_authenticateNtf boolean;
1288:
1289: CURSOR csr_appr_details (p_appraisal_id IN NUMBER)
1290: IS
1291: SELECT * FROM per_appraisals WHERE appraisal_id = p_appraisal_id;
1292:
1293:
1294: begin
1295:

Line 1360: if(p_transaction_status in ('W', 'RI') and (lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS'))

1356: -- 14341883 edit allowed is disabled for all the entries confined to Batch Element Entry
1357:
1358: --start - fix for bug 14592885
1359: if(p_transaction_status not in ('Y','YS','RO','ROS')) then
1360: if(p_transaction_status in ('W', 'RI') and (lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS'))
1361: then
1362: OPEN csr_appr_details (lr_hr_api_transaction_rec.transaction_ref_id);
1363: FETCH csr_appr_details INTO lr_per_appraisals_rec;
1364: CLOSE csr_appr_details;

Line 1363: FETCH csr_appr_details INTO lr_per_appraisals_rec;

1359: if(p_transaction_status not in ('Y','YS','RO','ROS')) then
1360: if(p_transaction_status in ('W', 'RI') and (lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS'))
1361: then
1362: OPEN csr_appr_details (lr_hr_api_transaction_rec.transaction_ref_id);
1363: FETCH csr_appr_details INTO lr_per_appraisals_rec;
1364: CLOSE csr_appr_details;
1365:
1366: if(lr_per_appraisals_rec.main_appraiser_id = p_loginPersonId AND (lr_per_appraisals_rec.appraisal_system_status in ('ONGOING', 'RFC')))
1367: then

Line 1366: if(lr_per_appraisals_rec.main_appraiser_id = p_loginPersonId AND (lr_per_appraisals_rec.appraisal_system_status in ('ONGOING', 'RFC')))

1362: OPEN csr_appr_details (lr_hr_api_transaction_rec.transaction_ref_id);
1363: FETCH csr_appr_details INTO lr_per_appraisals_rec;
1364: CLOSE csr_appr_details;
1365:
1366: if(lr_per_appraisals_rec.main_appraiser_id = p_loginPersonId AND (lr_per_appraisals_rec.appraisal_system_status in ('ONGOING', 'RFC')))
1367: then
1368: editAllowed := 'Y';
1369: return editAllowed;
1370: elsif(lr_per_appraisals_rec.appraisee_person_id = p_loginPersonId AND lr_per_appraisals_rec.appraisal_system_status = 'TRANSFER')

Line 1370: elsif(lr_per_appraisals_rec.appraisee_person_id = p_loginPersonId AND lr_per_appraisals_rec.appraisal_system_status = 'TRANSFER')

1366: if(lr_per_appraisals_rec.main_appraiser_id = p_loginPersonId AND (lr_per_appraisals_rec.appraisal_system_status in ('ONGOING', 'RFC')))
1367: then
1368: editAllowed := 'Y';
1369: return editAllowed;
1370: elsif(lr_per_appraisals_rec.appraisee_person_id = p_loginPersonId AND lr_per_appraisals_rec.appraisal_system_status = 'TRANSFER')
1371: then
1372: editAllowed := 'Y';
1373: return editAllowed;
1374: else

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

1403: end if;
1404:
1405: -- case 2: Functional module layer
1406: -- appraisal specific, not edit allowed for now by approvers
1407: if(lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS') then
1408: editAllowed := 'N';
1409: -- no more checks return
1410: return editAllowed;
1411: end if;

Line 1513: IF lr_hr_api_transaction_rec.transaction_ref_table = 'PER_APPRAISALS'

1509: if(p_transaction_status not in ('Y','YS','RO','ROS')
1510: and isTxnOwner(null,lr_hr_api_transaction_rec.creator_person_id)) then
1511: -- it is the creator editing the transaction
1512: --- added for 9661713 -- delete always disabled for Appraisal notifications
1513: IF lr_hr_api_transaction_rec.transaction_ref_table = 'PER_APPRAISALS'
1514: and lr_hr_api_transaction_rec.status IN ('C','RI','RIS') THEN
1515: deleteAllowed := 'N';
1516: ELSE
1517: deleteAllowed := 'Y';