DBA Data[Home] [Help]

APPS.EAM_WORKORDER_WORKFLOW_PVT dependencies on AME_UTIL

Line 347: l_next_approver ame_util.approverRecord2;

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

Line 348: l_next_approvers ame_util.approversTable2;

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

Line 374: flagApproversAsNotifiedIn => ame_util.booleanFalse,

370: --flagApproversAsNotifiedIn is set to false, later we update 1st approver as notified
371: ame_api2.getNextApprovers4(applicationIdIn=>426,
372: transactionTypeIn=>l_transaction_type,
373: transactionIdIn=>l_transaction_id,
374: flagApproversAsNotifiedIn => ame_util.booleanFalse,
375: approvalProcessCompleteYNOut => l_is_approval_complete,
376: nextApproversOut=>l_next_approvers);
377:
378: if (l_is_approval_complete = ame_util.booleanTrue) then

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

374: flagApproversAsNotifiedIn => ame_util.booleanFalse,
375: approvalProcessCompleteYNOut => l_is_approval_complete,
376: nextApproversOut=>l_next_approvers);
377:
378: if (l_is_approval_complete = ame_util.booleanTrue) then
379: resultout:='COMPLETE:'||'APPROVAL_COMPLETE';
380: return;
381: end if;
382: l_next_approvers_count := l_next_approvers.count;

Line 389: IF l_next_approver.approval_status = ame_util.exceptionStatus THEN

385: else
386: resultout:='COMPLETE:'||'NO_NEXT_APPROVER';
387: return;
388: end if;
389: IF l_next_approver.approval_status = ame_util.exceptionStatus THEN
390: raise E_FAILURE;
391: END IF;
392: IF ((l_next_approver.name is null) and
393: (l_next_approver.display_name is null) and

Line 418: approvalStatusIn => ame_util.notifiedStatus,

414: --Set first approver as notified, workflow handles one at a time
415: ame_api2.updateApprovalStatus2(applicationIdIn=>426,
416: transactionTypeIn=>'oracle.apps.eam.workorder.release.approval',
417: transactionIdIn=>l_transaction_id,
418: approvalStatusIn => ame_util.notifiedStatus,
419: approverNameIn => l_next_approver.name);
420: return;
421: END IF; -- approver is not null
422: END IF; -- run

Line 455: l_ame_status := ame_util.approvedStatus;

451: l_result := Wf_Notification.GetAttrText(l_nid, 'RESULT');
452:
453: if (l_result = 'APPROVED') then -- this may vary based on lookup type used for approval
454:
455: l_ame_status := ame_util.approvedStatus;
456: elsif (l_result = 'REJECTED') then
457: l_ame_status := ame_util.rejectStatus;
458: else -- reject for lack of information, conservative approach
459: l_ame_status := ame_util.rejectStatus;

Line 457: l_ame_status := ame_util.rejectStatus;

453: if (l_result = 'APPROVED') then -- this may vary based on lookup type used for approval
454:
455: l_ame_status := ame_util.approvedStatus;
456: elsif (l_result = 'REJECTED') then
457: l_ame_status := ame_util.rejectStatus;
458: else -- reject for lack of information, conservative approach
459: l_ame_status := ame_util.rejectStatus;
460: end if;
461: --Set approver as approved or rejected based on approver response

Line 459: l_ame_status := ame_util.rejectStatus;

455: l_ame_status := ame_util.approvedStatus;
456: elsif (l_result = 'REJECTED') then
457: l_ame_status := ame_util.rejectStatus;
458: else -- reject for lack of information, conservative approach
459: l_ame_status := ame_util.rejectStatus;
460: end if;
461: --Set approver as approved or rejected based on approver response
462: ame_api2.updateApprovalStatus2(applicationIdIn=>426,
463: transactionTypeIn=>'oracle.apps.eam.workorder.release.approval',