[Home] [Help]
412: -- Variables required for AME API
413: c_application_id integer;
414: c_transaction_id varchar2(25);
415: c_transaction_type varchar2(25);
416: c_next_approver_rec ame_util.approverRecord;
417:
418: v_approvalprocesscompleteynout varchar2(5);
419: v_next_approver_rec ame_util.approverstable2;
420:
415: c_transaction_type varchar2(25);
416: c_next_approver_rec ame_util.approverRecord;
417:
418: v_approvalprocesscompleteynout varchar2(5);
419: v_next_approver_rec ame_util.approverstable2;
420:
421: begin
422:
423: --
477: ame_api2.getNextApprovers4
478: (applicationIdIn => c_application_id
479: ,transactionTypeIn => c_transaction_type
480: ,transactionIdIn => c_transaction_id
481: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse
482: ,approvalProcessCompleteYNOut => v_approvalprocesscompleteynout
483: ,nextApproversOut => v_next_approver_rec);
484: --
485: -- set the next forward to
591: -- Variables required for AME API
592: c_application_id integer;
593: c_transaction_id varchar2(25);
594: c_transaction_type varchar2(25);
595: c_next_approver_rec ame_util.approverRecord;
596:
597: l_current_forward_to_username wf_users.name%type;
598:
599: begin
625: aname => 'FORWARD_TO_PERSON_ID');
626: /*
627: ame_api.updateApprovalStatus2(applicationIdIn =>c_application_id,
628: transactionIdIn =>c_transaction_id,
629: approvalStatusIn =>ame_util.approvedStatus,
630: approverPersonIdIn =>l_forward_to_person_id,
631: approverUserIdIn =>null,
632: transactionTypeIn =>c_transaction_type,
633: forwardeeIn =>null); */
643:
644: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
645: transactionTypeIn =>c_transaction_type,
646: transactionIdIn=>c_transaction_id,
647: approvalStatusIn =>ame_util.approvedStatus,
648: approverNameIn =>l_current_forward_to_username,
649: itemClassIn => null,
650: itemIdIn =>null,
651: actionTypeIdIn=> null,
650: itemIdIn =>null,
651: actionTypeIdIn=> null,
652: groupOrChainIdIn =>null,
653: occurrenceIn =>null,
654: forwardeeIn =>ame_util.emptyApproverRecord2,
655: updateItemIn =>false);
656:
657: elsif ( funmode = 'CANCEL' ) then
658: --
2162: -- Variables for AME API
2163: ln_application_id integer;
2164: lv_transaction_id varchar2(25);
2165: lv_transaction_type varchar2(25);
2166: l_next_approver_rec ame_util.approverRecord;
2167: l_default_approvers ame_util.approversTable;
2168: l_foundApprLoc boolean default false;
2169:
2170: v_approvalprocesscompleteynout varchar2(5);
2163: ln_application_id integer;
2164: lv_transaction_id varchar2(25);
2165: lv_transaction_type varchar2(25);
2166: l_next_approver_rec ame_util.approverRecord;
2167: l_default_approvers ame_util.approversTable;
2168: l_foundApprLoc boolean default false;
2169:
2170: v_approvalprocesscompleteynout varchar2(5);
2171: v_next_approver_rec ame_util.approverstable2;
2167: l_default_approvers ame_util.approversTable;
2168: l_foundApprLoc boolean default false;
2169:
2170: v_approvalprocesscompleteynout varchar2(5);
2171: v_next_approver_rec ame_util.approverstable2;
2172: v_default_approvers ame_util.approversTable2;
2173:
2174: begin
2175: hr_utility.set_location(lv_procedure_name,1);
2168: l_foundApprLoc boolean default false;
2169:
2170: v_approvalprocesscompleteynout varchar2(5);
2171: v_next_approver_rec ame_util.approverstable2;
2172: v_default_approvers ame_util.approversTable2;
2173:
2174: begin
2175: hr_utility.set_location(lv_procedure_name,1);
2176: if(hr_utility.debug_enabled) then
2321: ame_api2.getNextApprovers4
2322: (applicationIdIn => ln_application_id
2323: ,transactionTypeIn => lv_transaction_type
2324: ,transactionIdIn => ln_transaction_id
2325: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse
2326: ,approvalProcessCompleteYNOut => v_approvalprocesscompleteynout
2327: ,nextApproversOut => v_next_approver_rec);
2328:
2329: --ln_nextApprover_person_id :=l_next_approver_rec.person_id;