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.BEN_CWB_RSGN_EMP dependencies on BEN_TRANSACTION

Line 157: update ben_transaction set attribute12= l_approver_name , attribute13= l_approver_last_name

153: , avalue => l_approver_user);
154: hr_utility.set_location('Approver name is: '|| l_approver_name,200);
155:
156:
157: update ben_transaction set attribute12= l_approver_name , attribute13= l_approver_last_name
158: where attribute2= itemkey
159: and attribute1= 'EMP'
160: and transaction_type='CWBEMPRSGN';
161:

Line 225: UPDATE ben_transaction

221: -- Need to catch notification id , it will used in approved/rejected
222: -- notifications to show action history....
223: -- Begin
224:
225: UPDATE ben_transaction
226: SET attribute21 =
227: ( select notification_id
228: from wf_item_activity_statuses
229: where

Line 352: UPDATE ben_transaction

348: if( l_message_type='COMPLETED') then
349: l_error_message := wf_engine.GetItemAttrText(itemtype => itemtype,
350: itemkey => itemkey,
351: aname => 'ERROR_MESSAGE');
352: UPDATE ben_transaction
353: SET attribute40 = l_error_message
354: WHERE attribute2=itemkey
355: and transaction_type='CWBEMPRSGN'
356: and attribute1='EMP';

Line 406: UPDATE ben_transaction

402: -- Need to catch notification id , it will used in approved/rejected
403: -- notifications to show action history....
404: -- Begin
405:
406: UPDATE ben_transaction
407: SET attribute21 =
408: ( select notification_id
409: from wf_item_activity_statuses
410: where

Line 474: from ben_transaction

470: -- For API call end
471:
472: cursor getEmpToReassign is
473: select attribute3 , attribute10 , attribute8 ,attribute14 , attribute16 , attribute5 || ' ' || attribute18 , attribute7 || ' ' || attribute19 , attribute21 , attribute6
474: from ben_transaction
475: where attribute2=itemkey
476: and attribute1='EMP'
477: and transaction_type = 'CWBEMPRSGN';
478:

Line 872: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;

868: fetch get_top_person_id into l_top_person_id;
869:
870: close get_top_person_id;
871:
872: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;
873:
874: insert into ben_transaction(transaction_id,
875: transaction_type,
876: attribute1,

Line 874: insert into ben_transaction(transaction_id,

870: close get_top_person_id;
871:
872: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;
873:
874: insert into ben_transaction(transaction_id,
875: transaction_type,
876: attribute1,
877: attribute2,
878: attribute3,

Line 966: update ben_transaction set attribute2=l_requestor_person_id

962: close get_manager_id_from_pil;
963:
964:
965: if l_requestor_flag <> 1 then
966: update ben_transaction set attribute2=l_requestor_person_id
967: where attribute3=l_itemkey
968: and transaction_type='CWBEMPRSGN'
969: and attribute1='APPR';
970: end if;

Line 1004: update ben_transaction set attribute2=l_requestor_person_id

1000: hr_utility.set_location('flag'||l_requestor_flag,300);
1001: close get_manager_id_from_pil;
1002:
1003: if l_requestor_flag <> 1 then
1004: update ben_transaction set attribute2=l_requestor_person_id
1005: where attribute3=l_itemkey
1006: and transaction_type='CWBEMPRSGN'
1007: and attribute1='APPR';
1008: end if;

Line 1182: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;

1178:
1179:
1180: -- Make entry to make notification header
1181:
1182: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;
1183:
1184: insert into ben_transaction(transaction_id,
1185: transaction_type,
1186: attribute1,

Line 1184: insert into ben_transaction(transaction_id,

1180: -- Make entry to make notification header
1181:
1182: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;
1183:
1184: insert into ben_transaction(transaction_id,
1185: transaction_type,
1186: attribute1,
1187: attribute2,
1188: attribute3,

Line 1295: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;

1291: open requestor_name(p_requestor_id);
1292: fetch requestor_name into l_requestor_first_name , l_requestor_last_name ;
1293: close requestor_name;
1294:
1295: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;
1296:
1297: insert into ben_transaction(transaction_id,
1298: transaction_type,
1299: attribute1,

Line 1297: insert into ben_transaction(transaction_id,

1293: close requestor_name;
1294:
1295: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;
1296:
1297: insert into ben_transaction(transaction_id,
1298: transaction_type,
1299: attribute1,
1300: attribute2,
1301: attribute3,

Line 1373: update ben_transaction set status='DEL'

1369: l_error varchar2(5000);
1370: begin
1371:
1372: hr_utility.set_location('Entering '||l_package ,30);
1373: update ben_transaction set status='DEL'
1374: where attribute1= 'EMP'
1375: and transaction_type='CWBEMPRSGN'
1376: and attribute2=to_number(itemkey);
1377: