APPS.BEN_CWB_RSGN_EMP dependencies on BEN_TRANSACTION_S

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 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 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 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,