DBA Data[Home] [Help]

APPS.EAM_WORKORDER_WORKFLOW_PVT dependencies on AME_UTIL

Line 354: l_next_approver ame_util.approverRecord2;

350: funcmode in varchar2,
351: resultout out NOCOPY varchar2) IS
352: E_FAILURE EXCEPTION;
353: l_transaction_id number;
354: l_next_approver ame_util.approverRecord2;
355: l_next_approvers ame_util.approversTable2;
356: l_next_approvers_count number;
357: l_approver_index number;
358: l_is_approval_complete VARCHAR2(1);

Line 355: l_next_approvers ame_util.approversTable2;

351: resultout out NOCOPY varchar2) IS
352: E_FAILURE EXCEPTION;
353: l_transaction_id number;
354: l_next_approver ame_util.approverRecord2;
355: l_next_approvers ame_util.approversTable2;
356: l_next_approvers_count number;
357: l_approver_index number;
358: l_is_approval_complete VARCHAR2(1);
359: l_transaction_type VARCHAR2(200);

Line 384: flagApproversAsNotifiedIn => ame_util.booleanTrue,

380:
381: ame_api2.getNextApprovers4(applicationIdIn=>426,
382: transactionTypeIn=>l_transaction_type,
383: transactionIdIn=>l_transaction_id,
384: flagApproversAsNotifiedIn => ame_util.booleanTrue,
385: approvalProcessCompleteYNOut => l_is_approval_complete,
386: nextApproversOut=>l_next_approvers);
387:
388: if (l_is_approval_complete = ame_util.booleanTrue) then

Line 388: if (l_is_approval_complete = ame_util.booleanTrue) then

384: flagApproversAsNotifiedIn => ame_util.booleanTrue,
385: approvalProcessCompleteYNOut => l_is_approval_complete,
386: nextApproversOut=>l_next_approvers);
387:
388: if (l_is_approval_complete = ame_util.booleanTrue) then
389: resultout:='COMPLETE:'||'APPROVAL_COMPLETE';
390: return;
391:
392: -- Incase of consensus voting method, next approver count might be zero but there will be pending approvers

Line 486: l_forwardeeIn ame_util.approverRecord2;

482: l_approver_name varchar2(240);
483: l_result varchar2(100);
484: l_ame_status varchar2(20);
485: l_original_approver_name varchar2(240);
486: l_forwardeeIn ame_util.approverRecord2;
487:
488:
489: BEGIN
490: IF (funcmode = 'RUN') THEN

Line 511: l_ame_status := ame_util.approvedStatus;

507:
508:
509: if (l_result = 'APPROVED') then -- this may vary based on lookup type used for approval
510:
511: l_ame_status := ame_util.approvedStatus;
512: elsif (l_result = 'REJECTED') then
513: l_ame_status := ame_util.rejectStatus;
514: else -- reject for lack of information, conservative approach
515: l_ame_status := ame_util.rejectStatus;

Line 513: l_ame_status := ame_util.rejectStatus;

509: if (l_result = 'APPROVED') then -- this may vary based on lookup type used for approval
510:
511: l_ame_status := ame_util.approvedStatus;
512: elsif (l_result = 'REJECTED') then
513: l_ame_status := ame_util.rejectStatus;
514: else -- reject for lack of information, conservative approach
515: l_ame_status := ame_util.rejectStatus;
516: end if;
517: --Set approver as approved or rejected based on approver response

Line 515: l_ame_status := ame_util.rejectStatus;

511: l_ame_status := ame_util.approvedStatus;
512: elsif (l_result = 'REJECTED') then
513: l_ame_status := ame_util.rejectStatus;
514: else -- reject for lack of information, conservative approach
515: l_ame_status := ame_util.rejectStatus;
516: end if;
517: --Set approver as approved or rejected based on approver response
518: ame_api2.updateApprovalStatus2(applicationIdIn=>426,
519: transactionTypeIn=>'oracle.apps.eam.workorder.release.approval',