8: LOVType IN VARCHAR2,
9: BookTypeCode IN VARCHAR2,
10: CompanyCode IN VARCHAR2,
11: CostCenter IN VARCHAR2,
12: ApproverTypesTable OUT NOCOPY AME_UTIL.stringList,
13: ApproverIdsTable OUT NOCOPY AME_UTIL.stringList)
14: -- ApproversTable OUT NOCOPY AME_UTIL.approversTable)
15: return BOOLEAN
16: IS
9: BookTypeCode IN VARCHAR2,
10: CompanyCode IN VARCHAR2,
11: CostCenter IN VARCHAR2,
12: ApproverTypesTable OUT NOCOPY AME_UTIL.stringList,
13: ApproverIdsTable OUT NOCOPY AME_UTIL.stringList)
14: -- ApproversTable OUT NOCOPY AME_UTIL.approversTable)
15: return BOOLEAN
16: IS
17:
10: CompanyCode IN VARCHAR2,
11: CostCenter IN VARCHAR2,
12: ApproverTypesTable OUT NOCOPY AME_UTIL.stringList,
13: ApproverIdsTable OUT NOCOPY AME_UTIL.stringList)
14: -- ApproversTable OUT NOCOPY AME_UTIL.approversTable)
15: return BOOLEAN
16: IS
17:
18: * When the approvers LOVs on FWK pages are clicked, FWK calls the AME API, 'IA_AME_REQUEST_PKG.GetLOVApprovers'
20: * pertinent to the setup
21: *
22: *
23:
24: approverTypesList AME_UTIL.stringList;
25: approverIdsList AME_UTIL.stringList;
26:
27: approvalMethod VARCHAR2(15) := NULL;
28: approvalGroupId NUMBER(15) := -1;
21: *
22: *
23:
24: approverTypesList AME_UTIL.stringList;
25: approverIdsList AME_UTIL.stringList;
26:
27: approvalMethod VARCHAR2(15) := NULL;
28: approvalGroupId NUMBER(15) := -1;
29:
143: end if;
144:
145: IA_WF_UTIL_PKG.AddDebugMessage(callingProgram, debugInfo, approvalGroupId);
146:
147: approverTypesList := AME_UTIL.emptyStringList;
148: approverIdsList := AME_UTIL.emptyStringList;
149:
150: -----------------------------------------------------
151: debugInfo := 'Call corresponding approval group';
144:
145: IA_WF_UTIL_PKG.AddDebugMessage(callingProgram, debugInfo, approvalGroupId);
146:
147: approverTypesList := AME_UTIL.emptyStringList;
148: approverIdsList := AME_UTIL.emptyStringList;
149:
150: -----------------------------------------------------
151: debugInfo := 'Call corresponding approval group';
152: -----------------------------------------------------
209:
210: /*
211: FUNCTION GetNextApprover
212: (RequestId IN NUMBER,
213: Approver OUT NOCOPY AME_UTIL.approverRecord)
214: return BOOLEAN
215: IS
216:
217: approverTypesList AME_UTIL.stringList;
213: Approver OUT NOCOPY AME_UTIL.approverRecord)
214: return BOOLEAN
215: IS
216:
217: approverTypesList AME_UTIL.stringList;
218: approverIdsList AME_UTIL.stringList;
219:
220: approverRecord AME_UTIL.approverRecord;
221:
214: return BOOLEAN
215: IS
216:
217: approverTypesList AME_UTIL.stringList;
218: approverIdsList AME_UTIL.stringList;
219:
220: approverRecord AME_UTIL.approverRecord;
221:
222:
216:
217: approverTypesList AME_UTIL.stringList;
218: approverIdsList AME_UTIL.stringList;
219:
220: approverRecord AME_UTIL.approverRecord;
221:
222:
223: debugInfo VARCHAR2(255) := NULL;
224:
266:
267: FUNCTION GetNextApprover
268: (RequestId IN NUMBER,
269: ChainPhase IN OUT NOCOPY VARCHAR2,
270: Approver OUT NOCOPY AME_UTIL.approverRecord,
271: NoMoreApproverFlag OUT NOCOPY VARCHAR2)
272: return BOOLEAN
273: IS
274:
271: NoMoreApproverFlag OUT NOCOPY VARCHAR2)
272: return BOOLEAN
273: IS
274:
275: approverRecord AME_UTIL.approverRecord;
276:
277: l_book_type_code VARCHAR2(30);
278: l_responsibility_id NUMBER(15);
279: l_releasing_approver_id NUMBER(15);
502: END GetNextApprover;
503:
504: FUNCTION GetAllApprovers
505: (RequestId IN NUMBER,
506: ReleasingApprovers OUT NOCOPY AME_UTIL.approversTable,
507: ReceivingApprovers OUT NOCOPY AME_UTIL.approversTable)
508: return BOOLEAN
509: IS
510:
503:
504: FUNCTION GetAllApprovers
505: (RequestId IN NUMBER,
506: ReleasingApprovers OUT NOCOPY AME_UTIL.approversTable,
507: ReceivingApprovers OUT NOCOPY AME_UTIL.approversTable)
508: return BOOLEAN
509: IS
510:
511: approverTypesList AME_UTIL.stringList;
507: ReceivingApprovers OUT NOCOPY AME_UTIL.approversTable)
508: return BOOLEAN
509: IS
510:
511: approverTypesList AME_UTIL.stringList;
512: approverIdsList AME_UTIL.stringList;
513:
514: releasingApproverRec AME_UTIL.approverRecord;
515: receivingApproverRec AME_UTIL.approverRecord;
508: return BOOLEAN
509: IS
510:
511: approverTypesList AME_UTIL.stringList;
512: approverIdsList AME_UTIL.stringList;
513:
514: releasingApproverRec AME_UTIL.approverRecord;
515: receivingApproverRec AME_UTIL.approverRecord;
516:
510:
511: approverTypesList AME_UTIL.stringList;
512: approverIdsList AME_UTIL.stringList;
513:
514: releasingApproverRec AME_UTIL.approverRecord;
515: receivingApproverRec AME_UTIL.approverRecord;
516:
517: l_book_type_code VARCHAR2(30);
518: l_responsibility_id NUMBER(15);
511: approverTypesList AME_UTIL.stringList;
512: approverIdsList AME_UTIL.stringList;
513:
514: releasingApproverRec AME_UTIL.approverRecord;
515: receivingApproverRec AME_UTIL.approverRecord;
516:
517: l_book_type_code VARCHAR2(30);
518: l_responsibility_id NUMBER(15);
519: l_releasing_approver_id NUMBER(15);
676:
677: FUNCTION UpdateApprovalStatus
678: (RequestId IN NUMBER,
679: ChainPhase IN VARCHAR2,
680: Approver IN AME_UTIL.approverRecord DEFAULT AME_UTIL.emptyApproverRecord,
681: Forwardee IN AME_UTIL.approverRecord DEFAULT AME_UTIL.emptyApproverRecord)
682: return BOOLEAN
683: IS
684:
677: FUNCTION UpdateApprovalStatus
678: (RequestId IN NUMBER,
679: ChainPhase IN VARCHAR2,
680: Approver IN AME_UTIL.approverRecord DEFAULT AME_UTIL.emptyApproverRecord,
681: Forwardee IN AME_UTIL.approverRecord DEFAULT AME_UTIL.emptyApproverRecord)
682: return BOOLEAN
683: IS
684:
685: l_transactionType VARCHAR2(255) := IA_WF_UTIL_PKG.AME_RELEASE_TransactionType;
714:
715: /*
716: AME_API.updateApprovalStatus2(applicationIdIn => IA_WF_UTIL_PKG.GetApplicationID,
717: transactionIdIn => l_transactionType,
718: approvalStatusIn => ame_util.noResponseStatus,
719: approverPersonIdIn => l_forward_from_id,
720: approverUserIdIn => NULL,
721: transactionTypeIn => p_item_type,
722: forwardeeIn => l_recApprover);