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

Line 55: g_next_approvers ame_util.approversTable2;

51: t_application_id FND_APPLICATION.application_id%TYPE;
52:
53: -- Oracle Approval Management (AME)
54: t_approval_status varchar2(50);
55: g_next_approvers ame_util.approversTable2;
56: g_next_approver ame_util.approverRecord2;
57:
58: -- Workflow Directory Services
59: t_id number;

Line 56: g_next_approver ame_util.approverRecord2;

52:
53: -- Oracle Approval Management (AME)
54: t_approval_status varchar2(50);
55: g_next_approvers ame_util.approversTable2;
56: g_next_approver ame_util.approverRecord2;
57:
58: -- Workflow Directory Services
59: t_id number;
60: t_name varchar2(30);

Line 577: l_next_approver_rec AME_UTIL.approverRecord;

573:
574: l_role_name t_name%TYPE;
575: l_role_display_name t_display_name%TYPE;
576:
577: l_next_approver_rec AME_UTIL.approverRecord;
578:
579: l_next_approvers ame_util.approversTable2;
580: l_next_approver ame_util.approverRecord2;
581: l_complete VARCHAR2(50);

Line 579: l_next_approvers ame_util.approversTable2;

575: l_role_display_name t_display_name%TYPE;
576:
577: l_next_approver_rec AME_UTIL.approverRecord;
578:
579: l_next_approvers ame_util.approversTable2;
580: l_next_approver ame_util.approverRecord2;
581: l_complete VARCHAR2(50);
582: l_valid_approver BOOLEAN;
583:

Line 580: l_next_approver ame_util.approverRecord2;

576:
577: l_next_approver_rec AME_UTIL.approverRecord;
578:
579: l_next_approvers ame_util.approversTable2;
580: l_next_approver ame_util.approverRecord2;
581: l_complete VARCHAR2(50);
582: l_valid_approver BOOLEAN;
583:
584: l_api_name CONSTANT VARCHAR2(200) := 'get_next_approver';

Line 613: flagApproversAsNotifiedIn => ame_util.booleanFalse,

609: AME_API2.GetNextApprovers4(
610: applicationIdIn => l_application_id,
611: transactionTypeIn => 'GCS_ADJUSTMENT',
612: transactionIdIn => to_char(l_entry_id),
613: flagApproversAsNotifiedIn => ame_util.booleanFalse,
614: approvalProcessCompleteYNOut => l_complete,
615: nextApproversOut => l_next_approvers );
616:
617: l_debug_info := 'Approval Process Status ' || l_complete;

Line 622: -- IF l_complete = ame_util.booleanFalse THEN -- there is a status of complete no approvers

618: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
619: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
620: END IF;
621:
622: -- IF l_complete = ame_util.booleanFalse THEN -- there is a status of complete no approvers
623:
624: IF l_next_approvers.count < 1 THEN
625: -- No more approvers
626: l_debug_info := 'No more approvers ' || p_item_key ;

Line 652: if (l_next_approver.approval_status = AME_UTIL.exceptionStatus) then

648: END IF;
649:
650: end if;
651:
652: if (l_next_approver.approval_status = AME_UTIL.exceptionStatus) then
653: l_debug_info := 'Next approver exception error';
654:
655: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);

Line 801: l_debug_info := 'Before calling AME Update Status, entry : ' || l_entry_id || ', Status' || AME_UTIL.approvedStatus || ' role name: '|| l_role_name || 'Approver id: ' || l_approver_id ;

797: 'ORIG_SYSTEM');
798:
799: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
800:
801: l_debug_info := 'Before calling AME Update Status, entry : ' || l_entry_id || ', Status' || AME_UTIL.approvedStatus || ' role name: '|| l_role_name || 'Approver id: ' || l_approver_id ;
802:
803: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
804: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
805: END IF;

Line 807: l_debug_info := 'AME relevant info, itemclass: ' ||ame_util.headerItemClassName ||',item id ' || l_entry_id ;

803: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
804: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
805: END IF;
806:
807: l_debug_info := 'AME relevant info, itemclass: ' ||ame_util.headerItemClassName ||',item id ' || l_entry_id ;
808:
809: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
810: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
811: END IF;

Line 817: g_next_approver.approval_status:=AME_UTIL.approvedStatus;

813: g_next_approver.orig_system:= l_approver_orig_system;
814: g_next_approver.orig_system_id:=l_approver_id;
815: g_next_approver.name := l_role_name;
816:
817: g_next_approver.approval_status:=AME_UTIL.approvedStatus;
818: g_next_approver.item_class:=ame_util.headerItemClassName;
819: g_next_approver.item_id:=to_char(l_entry_id);
820:
821:

Line 818: g_next_approver.item_class:=ame_util.headerItemClassName;

814: g_next_approver.orig_system_id:=l_approver_id;
815: g_next_approver.name := l_role_name;
816:
817: g_next_approver.approval_status:=AME_UTIL.approvedStatus;
818: g_next_approver.item_class:=ame_util.headerItemClassName;
819: g_next_approver.item_id:=to_char(l_entry_id);
820:
821:
822: AME_API2.updateApprovalStatus(applicationIdIn => G_FCH_APPLICATION_ID,

Line 831: approvalStatusIn => AME_UTIL.approvedStatus,

827: /*
828: AME_API2.updateApprovalStatus2(applicationIdIn => G_FCH_APPLICATION_ID,
829: transactionTypeIn => 'GCS_ADJUSTMENT',
830: transactionIdIn => to_char(l_entry_id),
831: approvalStatusIn => AME_UTIL.approvedStatus,
832: approverNameIn => l_role_name,
833: itemClassIn => ame_util.headerItemClassName,
834: itemIdIn => to_char(l_entry_id));
835: */

Line 833: itemClassIn => ame_util.headerItemClassName,

829: transactionTypeIn => 'GCS_ADJUSTMENT',
830: transactionIdIn => to_char(l_entry_id),
831: approvalStatusIn => AME_UTIL.approvedStatus,
832: approverNameIn => l_role_name,
833: itemClassIn => ame_util.headerItemClassName,
834: itemIdIn => to_char(l_entry_id));
835: */
836: l_debug_info := 'Updated Approval status in AME records';
837: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 850: x_result_out := wf_engine.eng_completed||':'|| AME_UTIL.approvedStatus;

846: l_debug_info := 'End';
847: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
848: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);
849: END IF;
850: x_result_out := wf_engine.eng_completed||':'|| AME_UTIL.approvedStatus;
851:
852: EXCEPTION
853: WHEN OTHERS
854: THEN

Line 913: l_debug_info := 'Before calling AME Update Status, entry : ' || l_entry_id || ', Status' || AME_UTIL.approvedStatus || ' role name '|| l_role_name || 'Approver id ' || l_approver_id ;

909: l_approver_orig_system:= WF_ENGINE.GETITEMATTRText(p_item_type,
910: p_item_key,
911: 'ORIG_SYSTEM');
912:
913: l_debug_info := 'Before calling AME Update Status, entry : ' || l_entry_id || ', Status' || AME_UTIL.approvedStatus || ' role name '|| l_role_name || 'Approver id ' || l_approver_id ;
914:
915: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
917: END IF;

Line 919: l_debug_info := 'AME relevant info, itemclass: ' ||ame_util.headerItemClassName ||',item id ' || l_entry_id ;

915: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
917: END IF;
918:
919: l_debug_info := 'AME relevant info, itemclass: ' ||ame_util.headerItemClassName ||',item id ' || l_entry_id ;
920:
921: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
922: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
923: END IF;

Line 929: g_next_approver.approval_status:=AME_UTIL.rejectStatus;

925: g_next_approver.orig_system:= l_approver_orig_system;
926: g_next_approver.orig_system_id:=l_approver_id;
927: g_next_approver.name := l_role_name;
928:
929: g_next_approver.approval_status:=AME_UTIL.rejectStatus;
930: g_next_approver.item_class:=ame_util.headerItemClassName;
931: g_next_approver.item_id:=to_char(l_entry_id);
932:
933:

Line 930: g_next_approver.item_class:=ame_util.headerItemClassName;

926: g_next_approver.orig_system_id:=l_approver_id;
927: g_next_approver.name := l_role_name;
928:
929: g_next_approver.approval_status:=AME_UTIL.rejectStatus;
930: g_next_approver.item_class:=ame_util.headerItemClassName;
931: g_next_approver.item_id:=to_char(l_entry_id);
932:
933:
934: AME_API2.updateApprovalStatus(applicationIdIn => G_FCH_APPLICATION_ID,

Line 942: approvalStatusIn => AME_UTIL.rejectStatus,

938:
939: /*
940: AME_API2.updateApprovalStatus2(applicationIdIn => G_FCH_APPLICATION_ID,
941: transactionIdIn => to_char(l_entry_id),
942: approvalStatusIn => AME_UTIL.rejectStatus,
943: approverNameIn => l_role_name,
944: transactionTypeIn => 'GCS_ADJUSTMENT',
945: itemClassIn => ame_util.headerItemClassName,
946: itemIdIn => to_char(l_entry_id));

Line 945: itemClassIn => ame_util.headerItemClassName,

941: transactionIdIn => to_char(l_entry_id),
942: approvalStatusIn => AME_UTIL.rejectStatus,
943: approverNameIn => l_role_name,
944: transactionTypeIn => 'GCS_ADJUSTMENT',
945: itemClassIn => ame_util.headerItemClassName,
946: itemIdIn => to_char(l_entry_id));
947: */
948:
949: l_debug_info := 'Updated Approval status ';

Line 963: x_result_out := wf_engine.eng_completed||':'||AME_UTIL.approvedStatus;

959: l_debug_info := 'End';
960: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
961: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);
962: END IF;
963: x_result_out := wf_engine.eng_completed||':'||AME_UTIL.approvedStatus;
964:
965: EXCEPTION
966: WHEN OTHERS
967: THEN