DBA Data[Home] [Help]

APPS.DPP_APPROVAL_PVT dependencies on AME_UTIL

Line 73: l_ame_approver_rec ame_util.approverRecord2;

69: l_approval_access_id number;
70: l_approver_found varchar2(1) := 'N';
71: l_approver_level number;
72: l_approvers_tbl approvers_tbl_type;
73: l_ame_approver_rec ame_util.approverRecord2;
74: l_ame_forward_rec ame_util.approverRecord2 default ame_util.emptyApproverRecord2;
75: l_approval_status varchar2(30);
76: l_application_id number := 9000;
77: l_approver_type varchar2(30);

Line 74: l_ame_forward_rec ame_util.approverRecord2 default ame_util.emptyApproverRecord2;

70: l_approver_found varchar2(1) := 'N';
71: l_approver_level number;
72: l_approvers_tbl approvers_tbl_type;
73: l_ame_approver_rec ame_util.approverRecord2;
74: l_ame_forward_rec ame_util.approverRecord2 default ame_util.emptyApproverRecord2;
75: l_approval_status varchar2(30);
76: l_application_id number := 9000;
77: l_approver_type varchar2(30);
78: l_act_approver_id number;

Line 247: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;

243:
244: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'IF p_approval_rec.action_code = REJECT THEN' );
245:
246: -- Rejection of Request
247: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;
248:
249: ELSIF p_approval_rec.action_code = 'APPROVE' THEN
250:
251: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'ELSIF p_approval_rec.action_code = APPROVE THEN' );

Line 254: l_ame_approver_rec.approval_status := AME_UTIL.approvedStatus;

250:
251: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'ELSIF p_approval_rec.action_code = APPROVE THEN' );
252:
253: -- Approval of Request
254: l_ame_approver_rec.approval_status := AME_UTIL.approvedStatus;
255: END IF;
256:
257:
258: l_ame_approver_rec.name := l_user_name;

Line 261: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;

257:
258: l_ame_approver_rec.name := l_user_name;
259:
260: IF l_approver_found = 'N' THEN
261: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
262: ELSE
263: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
264: END IF;
265:

Line 263: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;

259:
260: IF l_approver_found = 'N' THEN
261: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
262: ELSE
263: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
264: END IF;
265:
266:
267: AME_API2.updateApprovalStatus(applicationIdIn => l_application_id

Line 381: l_next_approver ame_util.approversTable2;

377: l_api_version CONSTANT number := 1.0;
378: l_application_id number := 9000;
379: l_object_type varchar2(30) := p_approval_rec.object_type;
380: l_object_id varchar2(30) := p_approval_rec.object_id;
381: l_next_approver ame_util.approversTable2;
382: l_approver_level number;
383: l_resource_id number;
384: l_approvalProcessCompleteYNOut VARCHAR2(100);
385: l_currApprRec ame_util.approverRecord2;

Line 385: l_currApprRec ame_util.approverRecord2;

381: l_next_approver ame_util.approversTable2;
382: l_approver_level number;
383: l_resource_id number;
384: l_approvalProcessCompleteYNOut VARCHAR2(100);
385: l_currApprRec ame_util.approverRecord2;
386: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_APPROVAL_PVT.GET_APPROVERS';
387:
388: CURSOR csr_approver_level (p_object_type in varchar2, p_object_id in number) IS
389: SELECT nvl(max(approval_level),0)

Line 469: IF l_approvalProcessCompleteYNOut=ame_util2.completeNoApprovers THEN

465: --THEN
466:
467: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers:l_approvalProcessCompleteYNOut ' || l_approvalProcessCompleteYNOut);
468:
469: IF l_approvalProcessCompleteYNOut=ame_util2.completeNoApprovers THEN
470:
471: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'AME did not return any approvers in AME_API.getNextApprover call');
472:
473: -- If first approval, get default approver from profile

Line 505: IF l_approvalProcessCompleteYNOut = ame_util.booleanTrue THEN

501: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers : l_next_approver.orig_system ' || l_next_approver(i).orig_system);
502: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers : l_next_approver.orig_system_id ' || l_next_approver(i).orig_system_id);
503: END LOOP;
504:
505: IF l_approvalProcessCompleteYNOut = ame_util.booleanTrue THEN
506: x_final_approval_flag := 'Y';
507: ELSE
508: x_final_approval_flag := 'N';
509: END IF;

Line 610: l_approversOut ame_util.approversTable2;

606: IS
607: l_api_name CONSTANT varchar2(80) := 'Get_AllApprovers';
608: l_api_version CONSTANT number := 1.0;
609: l_application_id NUMBER := 9000;
610: l_approversOut ame_util.approversTable2;
611: l_approver_id NUMBER;
612: l_first_name VARCHAR2(150);
613: l_last_name VARCHAR2(150);
614: l_approver_email VARCHAR2(240);