DBA Data[Home] [Help]

APPS.EAM_CLEARANCE_WORKFLOW_PVT dependencies on AME_UTIL

Line 349: l_next_approver ame_util.approverRecord2;

345: funcmode in varchar2,
346: resultout out NOCOPY varchar2) IS
347: E_FAILURE EXCEPTION;
348: l_transaction_id number;
349: l_next_approver ame_util.approverRecord2;
350: l_next_approvers ame_util.approversTable2;
351: l_next_approvers_count number;
352: l_approver_index number;
353: l_is_approval_complete VARCHAR2(1);

Line 350: l_next_approvers ame_util.approversTable2;

346: resultout out NOCOPY varchar2) IS
347: E_FAILURE EXCEPTION;
348: l_transaction_id number;
349: l_next_approver ame_util.approverRecord2;
350: l_next_approvers ame_util.approversTable2;
351: l_next_approvers_count number;
352: l_approver_index number;
353: l_is_approval_complete VARCHAR2(1);
354: l_transaction_type VARCHAR2(200);

Line 379: flagApproversAsNotifiedIn => ame_util.booleanTrue,

375:
376: ame_api2.getNextApprovers4(applicationIdIn=>426,
377: transactionTypeIn=>l_transaction_type,
378: transactionIdIn=>l_transaction_id,
379: flagApproversAsNotifiedIn => ame_util.booleanTrue,
380: approvalProcessCompleteYNOut => l_is_approval_complete,
381: nextApproversOut=>l_next_approvers);
382:
383: if (l_is_approval_complete = ame_util.booleanTrue) then

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

379: flagApproversAsNotifiedIn => ame_util.booleanTrue,
380: approvalProcessCompleteYNOut => l_is_approval_complete,
381: nextApproversOut=>l_next_approvers);
382:
383: if (l_is_approval_complete = ame_util.booleanTrue) then
384: resultout:='COMPLETE:'||'APPROVAL_COMPLETE';
385: return;
386:
387: elsif (l_next_approvers.Count = 0) then

Line 487: l_forwardeeIn ame_util.approverRecord2;

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

Line 507: l_ame_status := ame_util.approvedStatus;

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

Line 509: l_ame_status := ame_util.rejectStatus;

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

Line 511: l_ame_status := ame_util.rejectStatus;

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