DBA Data[Home] [Help]

APPS.POR_AME_APPROVAL_LIST_WF1S dependencies on AME_UTIL

Line 90: l_tmp_approver ame_util.approverRecord2;

86: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
87: l_document_id NUMBER;
88: l_interface_source VARCHAR2(30);
89:
90: l_tmp_approver ame_util.approverRecord2;
91: l_forward_to NUMBER;
92: l_ApprovalListStr VARCHAR2(32000);
93: l_ApprovalListCount NUMBER;
94: l_QuoteChar VARCHAR2(1);

Line 451: l_next_approver ame_util.approverRecord;

447: l_doc_string varchar2(200);
448: l_preparer_user_name fnd_user.user_name%TYPE;
449: l_org_id number;
450:
451: l_next_approver ame_util.approverRecord;
452: l_insertion_type VARCHAR2(30);
453: l_authority_type VARCHAR2(30);
454: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
455:

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

491: IF (g_po_wf_debug = 'Y') THEN
492: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
493: END IF;
494:
495: IF l_next_approver.approval_status = ame_util.exceptionStatus THEN
496: raise E_FAILURE;
497: ELSIF ((l_next_approver.user_id is null) and
498: (l_next_approver.person_id is null) and
499: (l_next_approver.first_name is null) and

Line 833: forwardee ame_util.approverRecord;

829: p_forward_to_id IN NUMBER default null,
830: p_response IN VARCHAR2) IS
831:
832: l_progress VARCHAR2(100) := '000';
833: forwardee ame_util.approverRecord;
834: currentApprover ame_util.approverRecord;
835:
836: BEGIN
837:

Line 834: currentApprover ame_util.approverRecord;

830: p_response IN VARCHAR2) IS
831:
832: l_progress VARCHAR2(100) := '000';
833: forwardee ame_util.approverRecord;
834: currentApprover ame_util.approverRecord;
835:
836: BEGIN
837:
838: l_progress := 'transaction: '|| p_transaction_type || '; response:' || p_response;

Line 846: approvalStatusIn=>ame_util.approvedStatus,

842:
843: if(p_response='APPROVE') then
844: ame_api.updateApprovalStatus2(applicationIdIn=>applicationId,
845: transactionIdIn=>p_document_id,
846: approvalStatusIn=>ame_util.approvedStatus,
847: approverPersonIdIn=>p_approver_id,
848: transactionTypeIn=>p_transaction_type);
849:
850: elsif(p_response='REJECT') then

Line 853: approvalStatusIn=>ame_util.rejectStatus,

849:
850: elsif(p_response='REJECT') then
851: ame_api.updateApprovalStatus2(applicationIdIn=>applicationId,
852: transactionIdIn=>p_document_id,
853: approvalStatusIn=>ame_util.rejectStatus,
854: approverPersonIdIn=>p_approver_id,
855: transactionTypeIn=>p_transaction_type);
856:
857: elsif(p_response='FORWARD') then

Line 860: if(currentApprover.authority = ame_util.authorityApprover and

856:
857: elsif(p_response='FORWARD') then
858: forwardee.authority := currentApprover.authority;
859: forwardee.person_id := p_forward_to_id;
860: if(currentApprover.authority = ame_util.authorityApprover and
861: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
862: currentApprover.api_insertion = ame_util.oamGenerated)) then
863: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
864: else

Line 861: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or

857: elsif(p_response='FORWARD') then
858: forwardee.authority := currentApprover.authority;
859: forwardee.person_id := p_forward_to_id;
860: if(currentApprover.authority = ame_util.authorityApprover and
861: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
862: currentApprover.api_insertion = ame_util.oamGenerated)) then
863: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
864: else
865: forwardee.api_insertion := ame_util.apiInsertion;

Line 862: currentApprover.api_insertion = ame_util.oamGenerated)) then

858: forwardee.authority := currentApprover.authority;
859: forwardee.person_id := p_forward_to_id;
860: if(currentApprover.authority = ame_util.authorityApprover and
861: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
862: currentApprover.api_insertion = ame_util.oamGenerated)) then
863: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
864: else
865: forwardee.api_insertion := ame_util.apiInsertion;
866: end if;

Line 863: forwardee.api_insertion := ame_util.apiAuthorityInsertion;

859: forwardee.person_id := p_forward_to_id;
860: if(currentApprover.authority = ame_util.authorityApprover and
861: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
862: currentApprover.api_insertion = ame_util.oamGenerated)) then
863: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
864: else
865: forwardee.api_insertion := ame_util.apiInsertion;
866: end if;
867:

Line 865: forwardee.api_insertion := ame_util.apiInsertion;

861: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
862: currentApprover.api_insertion = ame_util.oamGenerated)) then
863: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
864: else
865: forwardee.api_insertion := ame_util.apiInsertion;
866: end if;
867:
868: currentApprover.approval_status := ame_util.forwardStatus;
869: ame_api.updateApprovalStatus(applicationIdIn=>applicationId,

Line 868: currentApprover.approval_status := ame_util.forwardStatus;

864: else
865: forwardee.api_insertion := ame_util.apiInsertion;
866: end if;
867:
868: currentApprover.approval_status := ame_util.forwardStatus;
869: ame_api.updateApprovalStatus(applicationIdIn=>applicationId,
870: transactionIdIn=>p_document_id,
871: transactionTypeIn=>p_transaction_type,
872: approverIn=>currentApprover,

Line 879: if(currentApprover.authority = ame_util.authorityApprover and

875: elsif (p_response='APPROVE_AND_FORWARD') THEN
876:
877: forwardee.authority := currentApprover.authority;
878: forwardee.person_id := p_forward_to_id;
879: if(currentApprover.authority = ame_util.authorityApprover and
880: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
881: currentApprover.api_insertion = ame_util.oamGenerated)) then
882: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
883: else

Line 880: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or

876:
877: forwardee.authority := currentApprover.authority;
878: forwardee.person_id := p_forward_to_id;
879: if(currentApprover.authority = ame_util.authorityApprover and
880: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
881: currentApprover.api_insertion = ame_util.oamGenerated)) then
882: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
883: else
884: forwardee.api_insertion := ame_util.apiInsertion;

Line 881: currentApprover.api_insertion = ame_util.oamGenerated)) then

877: forwardee.authority := currentApprover.authority;
878: forwardee.person_id := p_forward_to_id;
879: if(currentApprover.authority = ame_util.authorityApprover and
880: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
881: currentApprover.api_insertion = ame_util.oamGenerated)) then
882: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
883: else
884: forwardee.api_insertion := ame_util.apiInsertion;
885: end if;

Line 882: forwardee.api_insertion := ame_util.apiAuthorityInsertion;

878: forwardee.person_id := p_forward_to_id;
879: if(currentApprover.authority = ame_util.authorityApprover and
880: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
881: currentApprover.api_insertion = ame_util.oamGenerated)) then
882: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
883: else
884: forwardee.api_insertion := ame_util.apiInsertion;
885: end if;
886:

Line 884: forwardee.api_insertion := ame_util.apiInsertion;

880: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
881: currentApprover.api_insertion = ame_util.oamGenerated)) then
882: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
883: else
884: forwardee.api_insertion := ame_util.apiInsertion;
885: end if;
886:
887: currentApprover.approval_status := ame_util.approveAndForwardStatus;
888: ame_api.updateApprovalStatus(applicationIdIn=>applicationId,

Line 887: currentApprover.approval_status := ame_util.approveAndForwardStatus;

883: else
884: forwardee.api_insertion := ame_util.apiInsertion;
885: end if;
886:
887: currentApprover.approval_status := ame_util.approveAndForwardStatus;
888: ame_api.updateApprovalStatus(applicationIdIn=>applicationId,
889: transactionIdIn=>p_document_id,
890: transactionTypeIn=>p_transaction_type,
891: approverIn=>currentApprover,

Line 896: approvalStatusIn=>ame_util.noResponseStatus,

892: forwardeeIn=>forwardee);
893: elsif(p_response='TIMEOUT') then
894: ame_api.updateApprovalStatus2(applicationIdIn=>applicationId,
895: transactionIdIn=>p_document_id,
896: approvalStatusIn=>ame_util.noResponseStatus,
897: approverPersonIdIn=>p_approver_id,
898: transactionTypeIn=>p_transaction_type);
899:
900: