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 428: l_next_approver ame_util.approverRecord;

424: l_doc_string varchar2(200);
425: l_preparer_user_name fnd_user.user_name%TYPE;
426: l_org_id number;
427:
428: l_next_approver ame_util.approverRecord;
429: l_insertion_type VARCHAR2(30);
430: l_authority_type VARCHAR2(30);
431: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
432:

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

468: IF (g_po_wf_debug = 'Y') THEN
469: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
470: END IF;
471:
472: IF l_next_approver.approval_status = ame_util.exceptionStatus THEN
473: raise E_FAILURE;
474: ELSIF ((l_next_approver.user_id is null) and
475: (l_next_approver.person_id is null) and
476: (l_next_approver.first_name is null) and

Line 810: forwardee ame_util.approverRecord;

806: p_forward_to_id IN NUMBER default null,
807: p_response IN VARCHAR2) IS
808:
809: l_progress VARCHAR2(100) := '000';
810: forwardee ame_util.approverRecord;
811: currentApprover ame_util.approverRecord;
812:
813: BEGIN
814:

Line 811: currentApprover ame_util.approverRecord;

807: p_response IN VARCHAR2) IS
808:
809: l_progress VARCHAR2(100) := '000';
810: forwardee ame_util.approverRecord;
811: currentApprover ame_util.approverRecord;
812:
813: BEGIN
814:
815: l_progress := 'transaction: '|| p_transaction_type || '; response:' || p_response;

Line 823: approvalStatusIn=>ame_util.approvedStatus,

819:
820: if(p_response='APPROVE') then
821: ame_api.updateApprovalStatus2(applicationIdIn=>applicationId,
822: transactionIdIn=>p_document_id,
823: approvalStatusIn=>ame_util.approvedStatus,
824: approverPersonIdIn=>p_approver_id,
825: transactionTypeIn=>p_transaction_type);
826:
827: elsif(p_response='REJECT') then

Line 830: approvalStatusIn=>ame_util.rejectStatus,

826:
827: elsif(p_response='REJECT') then
828: ame_api.updateApprovalStatus2(applicationIdIn=>applicationId,
829: transactionIdIn=>p_document_id,
830: approvalStatusIn=>ame_util.rejectStatus,
831: approverPersonIdIn=>p_approver_id,
832: transactionTypeIn=>p_transaction_type);
833:
834: elsif(p_response='FORWARD') then

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

833:
834: elsif(p_response='FORWARD') then
835: forwardee.authority := currentApprover.authority;
836: forwardee.person_id := p_forward_to_id;
837: if(currentApprover.authority = ame_util.authorityApprover and
838: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
839: currentApprover.api_insertion = ame_util.oamGenerated)) then
840: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
841: else

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

834: elsif(p_response='FORWARD') then
835: forwardee.authority := currentApprover.authority;
836: forwardee.person_id := p_forward_to_id;
837: if(currentApprover.authority = ame_util.authorityApprover and
838: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
839: currentApprover.api_insertion = ame_util.oamGenerated)) then
840: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
841: else
842: forwardee.api_insertion := ame_util.apiInsertion;

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

835: forwardee.authority := currentApprover.authority;
836: forwardee.person_id := p_forward_to_id;
837: if(currentApprover.authority = ame_util.authorityApprover and
838: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
839: currentApprover.api_insertion = ame_util.oamGenerated)) then
840: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
841: else
842: forwardee.api_insertion := ame_util.apiInsertion;
843: end if;

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

836: forwardee.person_id := p_forward_to_id;
837: if(currentApprover.authority = ame_util.authorityApprover and
838: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
839: currentApprover.api_insertion = ame_util.oamGenerated)) then
840: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
841: else
842: forwardee.api_insertion := ame_util.apiInsertion;
843: end if;
844:

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

838: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
839: currentApprover.api_insertion = ame_util.oamGenerated)) then
840: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
841: else
842: forwardee.api_insertion := ame_util.apiInsertion;
843: end if;
844:
845: currentApprover.approval_status := ame_util.forwardStatus;
846: ame_api.updateApprovalStatus(applicationIdIn=>applicationId,

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

841: else
842: forwardee.api_insertion := ame_util.apiInsertion;
843: end if;
844:
845: currentApprover.approval_status := ame_util.forwardStatus;
846: ame_api.updateApprovalStatus(applicationIdIn=>applicationId,
847: transactionIdIn=>p_document_id,
848: transactionTypeIn=>p_transaction_type,
849: approverIn=>currentApprover,

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

852: elsif (p_response='APPROVE_AND_FORWARD') THEN
853:
854: forwardee.authority := currentApprover.authority;
855: forwardee.person_id := p_forward_to_id;
856: if(currentApprover.authority = ame_util.authorityApprover and
857: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
858: currentApprover.api_insertion = ame_util.oamGenerated)) then
859: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
860: else

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

853:
854: forwardee.authority := currentApprover.authority;
855: forwardee.person_id := p_forward_to_id;
856: if(currentApprover.authority = ame_util.authorityApprover and
857: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
858: currentApprover.api_insertion = ame_util.oamGenerated)) then
859: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
860: else
861: forwardee.api_insertion := ame_util.apiInsertion;

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

854: forwardee.authority := currentApprover.authority;
855: forwardee.person_id := p_forward_to_id;
856: if(currentApprover.authority = ame_util.authorityApprover and
857: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
858: currentApprover.api_insertion = ame_util.oamGenerated)) then
859: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
860: else
861: forwardee.api_insertion := ame_util.apiInsertion;
862: end if;

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

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

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

857: (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
858: currentApprover.api_insertion = ame_util.oamGenerated)) then
859: forwardee.api_insertion := ame_util.apiAuthorityInsertion;
860: else
861: forwardee.api_insertion := ame_util.apiInsertion;
862: end if;
863:
864: currentApprover.approval_status := ame_util.approveAndForwardStatus;
865: ame_api.updateApprovalStatus(applicationIdIn=>applicationId,

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

860: else
861: forwardee.api_insertion := ame_util.apiInsertion;
862: end if;
863:
864: currentApprover.approval_status := ame_util.approveAndForwardStatus;
865: ame_api.updateApprovalStatus(applicationIdIn=>applicationId,
866: transactionIdIn=>p_document_id,
867: transactionTypeIn=>p_transaction_type,
868: approverIn=>currentApprover,

Line 873: approvalStatusIn=>ame_util.noResponseStatus,

869: forwardeeIn=>forwardee);
870: elsif(p_response='TIMEOUT') then
871: ame_api.updateApprovalStatus2(applicationIdIn=>applicationId,
872: transactionIdIn=>p_document_id,
873: approvalStatusIn=>ame_util.noResponseStatus,
874: approverPersonIdIn=>p_approver_id,
875: transactionTypeIn=>p_transaction_type);
876:
877: