DBA Data[Home] [Help]

APPS.EAM_WORKPERMIT_WORKFLOW_PVT dependencies on AME_UTIL

Line 342: l_next_approver ame_util.approverRecord2;

338: funcmode in varchar2,
339: resultout out NOCOPY varchar2) IS
340: E_FAILURE EXCEPTION;
341: l_transaction_id number;
342: l_next_approver ame_util.approverRecord2;
343: l_next_approvers ame_util.approversTable2;
344: l_next_approvers_count number;
345: l_approver_index number;
346: l_is_approval_complete VARCHAR2(1);

Line 343: l_next_approvers ame_util.approversTable2;

339: resultout out NOCOPY varchar2) IS
340: E_FAILURE EXCEPTION;
341: l_transaction_id number;
342: l_next_approver ame_util.approverRecord2;
343: l_next_approvers ame_util.approversTable2;
344: l_next_approvers_count number;
345: l_approver_index number;
346: l_is_approval_complete VARCHAR2(1);
347: l_transaction_type VARCHAR2(200);

Line 372: flagApproversAsNotifiedIn => ame_util.booleanTrue,

368:
369: ame_api2.getNextApprovers4(applicationIdIn=>426,
370: transactionTypeIn=>l_transaction_type,
371: transactionIdIn=>l_transaction_id,
372: flagApproversAsNotifiedIn => ame_util.booleanTrue,
373: approvalProcessCompleteYNOut => l_is_approval_complete,
374: nextApproversOut=>l_next_approvers);
375:
376: if (l_is_approval_complete = ame_util.booleanTrue) then

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

372: flagApproversAsNotifiedIn => ame_util.booleanTrue,
373: approvalProcessCompleteYNOut => l_is_approval_complete,
374: nextApproversOut=>l_next_approvers);
375:
376: if (l_is_approval_complete = ame_util.booleanTrue) then
377: resultout:='COMPLETE:'||'APPROVAL_COMPLETE';
378: return;
379:
380: elsif (l_next_approvers.Count = 0) then

Line 480: l_forwardeeIn ame_util.approverRecord2;

476: l_approver_name varchar2(240);
477: l_result varchar2(100);
478: l_ame_status varchar2(20);
479: l_original_approver_name varchar2(240);
480: l_forwardeeIn ame_util.approverRecord2;
481:
482:
483: BEGIN
484: IF (funcmode = 'RUN') THEN

Line 500: l_ame_status := ame_util.approvedStatus;

496:
497:
498: if (l_result = 'APPROVED') then -- this may vary based on lookup type used for approval
499:
500: l_ame_status := ame_util.approvedStatus;
501: elsif (l_result = 'REJECTED') then
502: l_ame_status := ame_util.rejectStatus;
503: else -- reject for lack of information, conservative approach
504: l_ame_status := ame_util.rejectStatus;

Line 502: l_ame_status := ame_util.rejectStatus;

498: if (l_result = 'APPROVED') then -- this may vary based on lookup type used for approval
499:
500: l_ame_status := ame_util.approvedStatus;
501: elsif (l_result = 'REJECTED') then
502: l_ame_status := ame_util.rejectStatus;
503: else -- reject for lack of information, conservative approach
504: l_ame_status := ame_util.rejectStatus;
505: end if;
506: --Set approver as approved or rejected based on approver response

Line 504: l_ame_status := ame_util.rejectStatus;

500: l_ame_status := ame_util.approvedStatus;
501: elsif (l_result = 'REJECTED') then
502: l_ame_status := ame_util.rejectStatus;
503: else -- reject for lack of information, conservative approach
504: l_ame_status := ame_util.rejectStatus;
505: end if;
506: --Set approver as approved or rejected based on approver response
507: ame_api2.updateApprovalStatus2(applicationIdIn=>426,
508: transactionTypeIn=>'oracle.apps.eam.permit.release.approval',