[Home] [Help]
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:
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,
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;
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;
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,
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,