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 156: update ben_transaction set attribute12= l_approver_name , attribute13= l_approver_last_name

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

Line 224: UPDATE ben_transaction

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

Line 351: UPDATE ben_transaction

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

Line 405: UPDATE ben_transaction

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

Line 473: from ben_transaction

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

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

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

Line 873: insert into ben_transaction(transaction_id,

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

Line 965: update ben_transaction set attribute2=l_requestor_person_id

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

Line 1003: update ben_transaction set attribute2=l_requestor_person_id

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

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

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

Line 1183: insert into ben_transaction(transaction_id,

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

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

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

Line 1296: insert into ben_transaction(transaction_id,

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

Line 1372: update ben_transaction set status='DEL'

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