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.OZF_APPROVAL_PVT dependencies on AME_UTIL

Line 74: l_ame_approver_rec ame_util.approverRecord;

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

Line 75: l_ame_forward_rec ame_util.approverRecord default ame_util.emptyApproverRecord;

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

Line 336: l_ame_approver_rec.authority := ame_util.authorityApprover;

332: l_ame_approver_rec.user_id := p_approval_rec.action_performed_by;
333: end if ;
334: end if;
335:
336: l_ame_approver_rec.authority := ame_util.authorityApprover;
337:
338: IF p_approval_rec.action_code = 'FORWARD' THEN -- FORWARD
339: l_ame_approver_rec.approval_status := AME_UTIL.forwardStatus;
340: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;

Line 339: l_ame_approver_rec.approval_status := AME_UTIL.forwardStatus;

335:
336: l_ame_approver_rec.authority := ame_util.authorityApprover;
337:
338: IF p_approval_rec.action_code = 'FORWARD' THEN -- FORWARD
339: l_ame_approver_rec.approval_status := AME_UTIL.forwardStatus;
340: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
341:
342: -- Reassignment of Request. create a forwadee record
343: --use the Forwarder User id

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

336: l_ame_approver_rec.authority := ame_util.authorityApprover;
337:
338: IF p_approval_rec.action_code = 'FORWARD' THEN -- FORWARD
339: l_ame_approver_rec.approval_status := AME_UTIL.forwardStatus;
340: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
341:
342: -- Reassignment of Request. create a forwadee record
343: --use the Forwarder User id
344: l_ame_forward_rec.user_id := G_FORWARD_USER;

Line 346: l_ame_forward_rec.api_insertion := ame_util.apiAuthorityInsertion;

342: -- Reassignment of Request. create a forwadee record
343: --use the Forwarder User id
344: l_ame_forward_rec.user_id := G_FORWARD_USER;
345: IF l_approver_found = 'N' THEN
346: l_ame_forward_rec.api_insertion := ame_util.apiAuthorityInsertion;
347: ELSE
348: l_ame_forward_rec.api_insertion := ame_util.apiAuthorityInsertion;
349: END IF;
350: l_ame_forward_rec.authority := ame_util.authorityApprover;

Line 348: l_ame_forward_rec.api_insertion := ame_util.apiAuthorityInsertion;

344: l_ame_forward_rec.user_id := G_FORWARD_USER;
345: IF l_approver_found = 'N' THEN
346: l_ame_forward_rec.api_insertion := ame_util.apiAuthorityInsertion;
347: ELSE
348: l_ame_forward_rec.api_insertion := ame_util.apiAuthorityInsertion;
349: END IF;
350: l_ame_forward_rec.authority := ame_util.authorityApprover;
351:
352:

Line 350: l_ame_forward_rec.authority := ame_util.authorityApprover;

346: l_ame_forward_rec.api_insertion := ame_util.apiAuthorityInsertion;
347: ELSE
348: l_ame_forward_rec.api_insertion := ame_util.apiAuthorityInsertion;
349: END IF;
350: l_ame_forward_rec.authority := ame_util.authorityApprover;
351:
352:
353: ELSIF p_approval_rec.action_code = 'REJECT' THEN
354: -- Rejection of Request

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

352:
353: ELSIF p_approval_rec.action_code = 'REJECT' THEN
354: -- Rejection of Request
355: IF l_approver_found = 'N' THEN
356: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
357: ELSE
358: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
359: END IF;
360: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;

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

354: -- Rejection of Request
355: IF l_approver_found = 'N' THEN
356: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
357: ELSE
358: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
359: END IF;
360: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;
361:
362: ELSIF p_approval_rec.action_code = 'RETURN' THEN

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

356: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
357: ELSE
358: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
359: END IF;
360: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;
361:
362: ELSIF p_approval_rec.action_code = 'RETURN' THEN
363: -- Rejection of Request
364: IF l_approver_found = 'N' THEN

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

361:
362: ELSIF p_approval_rec.action_code = 'RETURN' THEN
363: -- Rejection of Request
364: IF l_approver_found = 'N' THEN
365: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
366: ELSE
367: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
368: END IF;
369: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;

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

363: -- Rejection of Request
364: IF l_approver_found = 'N' THEN
365: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
366: ELSE
367: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
368: END IF;
369: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;
370:
371: ELSIF p_approval_rec.action_code = 'APPROVE' THEN

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

365: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
366: ELSE
367: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
368: END IF;
369: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;
370:
371: ELSIF p_approval_rec.action_code = 'APPROVE' THEN
372: -- Approval of Request
373: IF l_approver_found = 'N' THEN

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

370:
371: ELSIF p_approval_rec.action_code = 'APPROVE' THEN
372: -- Approval of Request
373: IF l_approver_found = 'N' THEN
374: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
375: ELSE
376: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
377: END IF;
378: l_ame_approver_rec.approval_status := AME_UTIL.approvedStatus;

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

372: -- Approval of Request
373: IF l_approver_found = 'N' THEN
374: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
375: ELSE
376: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
377: END IF;
378: l_ame_approver_rec.approval_status := AME_UTIL.approvedStatus;
379: END IF;
380:

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

374: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
375: ELSE
376: l_ame_approver_rec.api_insertion := ame_util.oamGenerated;
377: END IF;
378: l_ame_approver_rec.approval_status := AME_UTIL.approvedStatus;
379: END IF;
380:
381:
382: -- Update AME of Approval Status

Line 495: l_next_approver AME_UTIL.approverRecord;

491: l_api_version CONSTANT number := 1.0;
492: l_application_id number := 682;
493: l_object_type varchar2(30) := p_approval_rec.object_type;
494: l_object_id number := p_approval_rec.object_id;
495: l_next_approver AME_UTIL.approverRecord;
496: l_approver_level number;
497: l_resource_id number;
498: --l_ame_approver_rec ame_util.approverRecord;
499: --l_ame_forward_rec ame_util.approverRecord default ame_util.emptyApproverRecord;

Line 498: --l_ame_approver_rec ame_util.approverRecord;

494: l_object_id number := p_approval_rec.object_id;
495: l_next_approver AME_UTIL.approverRecord;
496: l_approver_level number;
497: l_resource_id number;
498: --l_ame_approver_rec ame_util.approverRecord;
499: --l_ame_forward_rec ame_util.approverRecord default ame_util.emptyApproverRecord;
500:
501: CURSOR csr_approver_level (p_object_type in varchar2, p_object_id in number) IS
502: SELECT nvl(max(approval_level),0)

Line 499: --l_ame_forward_rec ame_util.approverRecord default ame_util.emptyApproverRecord;

495: l_next_approver AME_UTIL.approverRecord;
496: l_approver_level number;
497: l_resource_id number;
498: --l_ame_approver_rec ame_util.approverRecord;
499: --l_ame_forward_rec ame_util.approverRecord default ame_util.emptyApproverRecord;
500:
501: CURSOR csr_approver_level (p_object_type in varchar2, p_object_id in number) IS
502: SELECT nvl(max(approval_level),0)
503: FROM ozf_approval_access

Line 578: l_ame_approver_rec.authority := ame_util.authorityApprover;

574:
575: /*
576: --Insert Default Approver into Group
577: l_ame_approver_rec.user_id := x_approvers(1).approver_id;
578: l_ame_approver_rec.authority := ame_util.authorityApprover;
579: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
580: l_ame_approver_rec.approval_status := AME_UTIL.noResponseStatus;
581:
582: AME_API.updateApprovalStatus(applicationIdIn => l_application_id

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

575: /*
576: --Insert Default Approver into Group
577: l_ame_approver_rec.user_id := x_approvers(1).approver_id;
578: l_ame_approver_rec.authority := ame_util.authorityApprover;
579: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
580: l_ame_approver_rec.approval_status := AME_UTIL.noResponseStatus;
581:
582: AME_API.updateApprovalStatus(applicationIdIn => l_application_id
583: ,transactionIdIn => p_approval_rec.object_id

Line 580: l_ame_approver_rec.approval_status := AME_UTIL.noResponseStatus;

576: --Insert Default Approver into Group
577: l_ame_approver_rec.user_id := x_approvers(1).approver_id;
578: l_ame_approver_rec.authority := ame_util.authorityApprover;
579: l_ame_approver_rec.api_insertion := ame_util.apiAuthorityInsertion;
580: l_ame_approver_rec.approval_status := AME_UTIL.noResponseStatus;
581:
582: AME_API.updateApprovalStatus(applicationIdIn => l_application_id
583: ,transactionIdIn => p_approval_rec.object_id
584: ,approverIn => l_ame_approver_rec

Line 2006: l_approvers_tbl ame_util.approversTable2;

2002: l_api_name CONSTANT VARCHAR2(80) := 'Process_SD_Approval';
2003: l_api_version CONSTANT NUMBER := 1.0;
2004: l_event_key VARCHAR2(240);
2005: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2006: l_approvers_tbl ame_util.approversTable2;
2007: l_approval_completeYN VARCHAR2(20) := ame_util.booleanFalse;
2008: l_orig_system_id NUMBER;
2009: l_orig_system VARCHAR2(30);
2010: l_user_id NUMBER;

Line 2007: l_approval_completeYN VARCHAR2(20) := ame_util.booleanFalse;

2003: l_api_version CONSTANT NUMBER := 1.0;
2004: l_event_key VARCHAR2(240);
2005: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2006: l_approvers_tbl ame_util.approversTable2;
2007: l_approval_completeYN VARCHAR2(20) := ame_util.booleanFalse;
2008: l_orig_system_id NUMBER;
2009: l_orig_system VARCHAR2(30);
2010: l_user_id NUMBER;
2011: l_resource_id NUMBER;

Line 2275: ,x_approvers OUT NOCOPY ame_util.approversTable2

2271: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2272: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2273: ,p_transaction_id IN VARCHAR2
2274: ,p_transaction_type_key IN VARCHAR2
2275: ,x_approvers OUT NOCOPY ame_util.approversTable2
2276: ,x_approval_flag OUT NOCOPY VARCHAR2
2277: ,x_return_status OUT NOCOPY VARCHAR2
2278: ,x_msg_data OUT NOCOPY VARCHAR2
2279: ,x_msg_count OUT NOCOPY NUMBER