78: IS
79: l_approver_user varchar2(240);
80: l_approver_name varchar2(240);
81: l_approver_last_name varchar2(240);
82: c_next_approver_out ame_util.approverRecord;
83: c_all_approvers ame_util.approversTable;
84: l_recCount number;
85: l_flag number;
86: l_requestorId number;
79: l_approver_user varchar2(240);
80: l_approver_name varchar2(240);
81: l_approver_last_name varchar2(240);
82: c_next_approver_out ame_util.approverRecord;
83: c_all_approvers ame_util.approversTable;
84: l_recCount number;
85: l_flag number;
86: l_requestorId number;
87: l_package varchar2(80) := g_package||'.check_approver';
240:
241:
242: ame_api.updateApprovalStatus2(applicationIdIn =>805,
243: transactionIdIn => itemkey,
244: approvalStatusIn => ame_util.approvedStatus,
245: approverPersonIdIn=> l_approver_id,
246: transactionTypeIn=> 'PROPEMPRSGN' );
247:
248: hr_utility.set_location('Leaving '||l_package ,30);
727: l_prop_ws_manager_name varchar2(240);
728: l_prop_ws_manager_last_name varchar2(240);
729: l_prop_ws_manager_user varchar2(240);
730: l_top_person_id number;
731: c_next_approver_out ame_util.approverRecord;
732: c_all_approvers ame_util.approversTable;
733: l_recCount number:=0;
734: l_flag number;
735: l_requestor_flag number:=0;
728: l_prop_ws_manager_last_name varchar2(240);
729: l_prop_ws_manager_user varchar2(240);
730: l_top_person_id number;
731: c_next_approver_out ame_util.approverRecord;
732: c_all_approvers ame_util.approversTable;
733: l_recCount number:=0;
734: l_flag number;
735: l_requestor_flag number:=0;
736: l_transaction_id number;