eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_APPROVAL_PVT dependencies on AME_UTIL

Line 73: l_ame_approver_rec ame_util.approverRecord;

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.approverRecord;
74: l_ame_forward_rec ame_util.approverRecord default ame_util.emptyApproverRecord;
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.approverRecord default ame_util.emptyApproverRecord;

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.approverRecord;
74: l_ame_forward_rec ame_util.approverRecord default ame_util.emptyApproverRecord;
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.authority := ame_util.authorityApprover;

243: l_ame_approver_rec.person_id := l_approver_id;
244: else
245: l_ame_approver_rec.user_id := p_approval_rec.action_performed_by;
246: end if;
247: l_ame_approver_rec.authority := ame_util.authorityApprover;
248:
249: IF p_approval_rec.action_code = 'REJECT' THEN
250: -- Rejection of Request
251: IF l_approver_found = 'N' THEN

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

248:
249: IF p_approval_rec.action_code = 'REJECT' THEN
250: -- Rejection of Request
251: IF l_approver_found = 'N' THEN
252: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
253: ELSE
254: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
255: END IF;
256: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;

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

250: -- Rejection of Request
251: IF l_approver_found = 'N' THEN
252: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
253: ELSE
254: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
255: END IF;
256: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;
257:
258: ELSIF p_approval_rec.action_code = 'APPROVE' THEN

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

252: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
253: ELSE
254: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
255: END IF;
256: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;
257:
258: ELSIF p_approval_rec.action_code = 'APPROVE' THEN
259: -- Approval of Request
260: IF l_approver_found = 'N' THEN

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

257:
258: ELSIF p_approval_rec.action_code = 'APPROVE' THEN
259: -- Approval of Request
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: l_ame_approver_rec.approval_status := AME_UTIL.approvedStatus;

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

259: -- Approval of Request
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: l_ame_approver_rec.approval_status := AME_UTIL.approvedStatus;
266: END IF;
267: -- Update AME of Approval Status

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

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: l_ame_approver_rec.approval_status := AME_UTIL.approvedStatus;
266: END IF;
267: -- Update AME of Approval Status
268: AME_API.updateApprovalStatus(applicationIdIn => l_application_id
269: ,transactionIdIn => p_approval_rec.object_id

Line 393: l_next_approver AME_UTIL.approverRecord;

389: l_api_version CONSTANT number := 1.0;
390: l_application_id number := 9000;
391: l_object_type varchar2(30) := p_approval_rec.object_type;
392: l_object_id number := p_approval_rec.object_id;
393: l_next_approver AME_UTIL.approverRecord;
394: l_approver_level number;
395: l_resource_id number;
396:
397: CURSOR csr_approver_level (p_object_type in varchar2, p_object_id in number) IS

Line 576: l_approversOut ame_util.approversTable;

572: IS
573: l_api_name CONSTANT varchar2(80) := 'Get_AllApprovers';
574: l_api_version CONSTANT number := 1.0;
575: l_application_id NUMBER := 9000;
576: l_approversOut ame_util.approversTable;
577: l_approver_id NUMBER;
578: l_first_name VARCHAR2(150);
579: l_last_name VARCHAR2(150);
580: l_approver_email VARCHAR2(240);