65:
66: PRAGMA AUTONOMOUS_TRANSACTION;
67: begin
68: --savepoint create_transaction;
69: l_creator_role := nvl(P_CREATOR_ROLE, 'PER:' || fnd_global.employee_id);
70: l_last_update_role := nvl(P_LAST_UPDATE_ROLE, 'PER:' || fnd_global.employee_id);
71:
72:
73:
66: PRAGMA AUTONOMOUS_TRANSACTION;
67: begin
68: --savepoint create_transaction;
69: l_creator_role := nvl(P_CREATOR_ROLE, 'PER:' || fnd_global.employee_id);
70: l_last_update_role := nvl(P_LAST_UPDATE_ROLE, 'PER:' || fnd_global.employee_id);
71:
72:
73:
74: l_TRANSACTION_ID := P_TRANSACTION_ID;
293: l_last_update_role hr_api_transactions.last_update_role%type;
294: PRAGMA AUTONOMOUS_TRANSACTION;
295: begin
296: --savepoint update_transaction;
297: l_last_update_role := nvl(P_LAST_UPDATE_ROLE, 'PER:' || fnd_global.employee_id);
298: hr_trn_upd.upd(
299: p_validate => false
300: ,p_creator_person_id => p_creator_person_id
301: ,p_transaction_privilege => P_TRANSACTION_PRIVILEGE
1203: editAllowed :='E';
1204: return editAllowed;
1205: end if;
1206: -- authenticate login user access to the notifcation id
1207: if(l_authenticateNtf and (wf_advanced_worklist.authenticate(fnd_global.user_name,
1208: p_notification_id,null)
1209: <>fnd_global.user_name)) then
1210:
1211: -- no more iterations return false
1205: end if;
1206: -- authenticate login user access to the notifcation id
1207: if(l_authenticateNtf and (wf_advanced_worklist.authenticate(fnd_global.user_name,
1208: p_notification_id,null)
1209: <>fnd_global.user_name)) then
1210:
1211: -- no more iterations return false
1212: if(hr_multi_message.is_message_list_enabled) then
1213: hr_multi_message.add(null,null,null,null,null,'N',hr_multi_message.g_error_msg);
1236: elsif(p_transaction_status in ('Y','YS','RO','ROS' )) then
1237: -- case where approvers trying to edit
1238:
1239: -- check if the login person is the approver
1240: if(fnd_global.user_name=wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1241: lr_hr_api_transaction_rec.item_key,
1242: 'FORWARD_TO_USERNAME',true)) then
1243: -- check the profile if the system is configured for approvers editing
1244: IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' ) THEN
1263:
1264:
1265: -- check the if the appover is allowed to edit
1266: pqh_ss_utility.check_edit_privilege (
1267: p_personId => nvl(p_loginPersonId,fnd_global.employee_id)
1268: ,p_businessGroupId => p_loginPersonBgId
1269: ,p_editAllowed => editAllowed);
1270:
1271:
1331: return deleteAllowed;
1332: end if;
1333:
1334: -- authenticate login user access to the notifcation id
1335: if(l_authenticateNtf and (wf_advanced_worklist.authenticate(fnd_global.user_name,
1336: p_notification_id,null)
1337: <>fnd_global.user_name)) then
1338: -- no more iterations return false
1339: if(hr_multi_message.is_message_list_enabled) then
1333:
1334: -- authenticate login user access to the notifcation id
1335: if(l_authenticateNtf and (wf_advanced_worklist.authenticate(fnd_global.user_name,
1336: p_notification_id,null)
1337: <>fnd_global.user_name)) then
1338: -- no more iterations return false
1339: if(hr_multi_message.is_message_list_enabled) then
1340: hr_multi_message.add(null,null,null,null,null,'N',hr_multi_message.g_error_msg);
1341: end if;
1434: ,'DEL');
1435: wf_notification.respond(
1436: ln_notification_id
1437: ,null
1438: ,fnd_global.user_name
1439: ,null);
1440: else
1441: -- throw exception
1442: null;
1522: ,'REJECTED');
1523: wf_notification.respond(
1524: ln_notification_id
1525: ,null
1526: ,fnd_global.user_name
1527: ,null);
1528:
1529: else
1530: -- throw exception
1730: where transaction_id=p_transaction_id;
1731: end if;
1732:
1733: --
1734: if(ln_person_id= fnd_global.employee_id) then
1735: x_returnStatus := true;
1736: else
1737: x_returnStatus :=false;
1738: end if;
2100: where transaction_id=p_transaction_id;
2101: -- send sfl notification to login user
2102: hr_sflutil_ss.sendsflnotification(p_transaction_id,
2103: p_transaction_ref_table,
2104: fnd_global.user_name,
2105: 'HR_RELAUNCH_SS',
2106: null,
2107: ln_notification_id);
2108: -- return success status
2115:
2116: -- add the code plugin transfer history
2117: hr_trans_history_api.archive_sfl(p_transaction_id,
2118: ln_notification_id,
2119: fnd_global.user_name);
2120: elsif(p_proposedTxnStatus='A') then
2121:
2122:
2123: begin