15: -- {Start Of Comments}
16: /*#
17: * This API validates the generated approver against wf_roles.
18: *
19: * This API is used to check whether an ame_util.approverRecord2 that the
20: * calling application generates is valid, especially before passing an
21: * ame_util.approverRecord2 to an AME API routine.
22: *
23: *
Licensing
17: * This API validates the generated approver against wf_roles.
18: *
19: * This API is used to check whether an ame_util.approverRecord2 that the
20: * calling application generates is valid, especially before passing an
21: * ame_util.approverRecord2 to an AME API routine.
22: *
23: *
Licensing
24: * This API is available for use with any licensed component of the e-business
25: * suite.
33: *
34: *
Post Failure
35: * This API returns false.
36: *
37: * @param approverin This is an ame_util.approverRecord2 that represents an
38: * approver.
39: * @return This API will return true if the approver represented by approverIn has a current wf_roles entry, otherwise will return false.
40: * @rep:displayname Validate Approver
41: * @rep:category BUSINESS_ENTITY AME_APPROVAL
44: */
45: --
46: -- {End Of Comments}
47: --
48: function validateApprover(approverIn in ame_util.approverRecord2) return boolean;
49: --
50: -- ----------------------------------------------------------------------------
51: -- |-----------------------------< clearallapprovals >------------------------|
52: -- ----------------------------------------------------------------------------
100: -- ----------------------------------------------------------------------------
101: --
102: -- {Start Of Comments}
103: /*#
104: * This API returns an ame_util.approverRecord2 representing the
105: * administrative approver for a transaction type.
106: *
107: * An originating application may wish to notify this approver when AME raises
108: * an exception.
115: * No known prerequisites.
116: *
117: *
Post Success
118: * This API will return the administrative approver for a transaction in
119: * ame_util.approverRecord2 format. Also, it will return the wf_role name as
120: * adminapproverout.name and will return ame_util.exceptionStatus as
121: * adminapproverout.approval_status.
122: *
123: *
Post Failure
116: *
117: *
Post Success
118: * This API will return the administrative approver for a transaction in
119: * ame_util.approverRecord2 format. Also, it will return the wf_role name as
120: * adminapproverout.name and will return ame_util.exceptionStatus as
121: * adminapproverout.approval_status.
122: *
123: *
Post Failure
124: * The API will raise an error.
127: * originating application that called the AME API routine.
128: * @param transactiontypein This is a string parameter up to 50 bytes long. It
129: * distinguishes one transaction type from another within a given originating
130: * application. It can be null, but you must always pass its value explicitly.
131: * @param adminapproverout This is an ame_util.approverRecord2 that represents
132: * the administrator for the particular transaction type.
133: * @rep:displayname Get Admin Approver
134: * @rep:category BUSINESS_ENTITY AME_APPROVAL
135: * @rep:lifecycle active
139: -- {End Of Comments}
140: --
141: procedure getAdminApprover(applicationIdIn in number,
142: transactionTypeIn in varchar2,
143: adminApproverOut out nocopy ame_util.approverRecord2);
144: --
145: -- ----------------------------------------------------------------------------
146: -- |-----------------------------< getallapprovers1 >-------------------------|
147: -- ----------------------------------------------------------------------------
159: * for approvals, assuming the originating application has communicated such
160: * responses to AME via ame_api2.updateApprovalStatus or
161: * ame_api2.updateApprovalStatus2.
162: *
approvalProcessCompleteYNOut can have one of the following values
163: *
164: * have approved
165: *
161: * ame_api2.updateApprovalStatus2.
162: *
approvalProcessCompleteYNOut can have one of the following values
163: *
163: *
165: *
167: *
If an approver's item_id value is null, several
175: * items require the approver. If such an approver is at index i in
203: * white-space characters, and must not be the character representation of a
204: * negative integer.
205: * @param approvalprocesscompleteynout This indicates current status of
206: * transaction's approval process.
207: * @param approversout This is an ame_util.approverstable2, and is populated
208: * with the generated list of approvers.
209: * @param itemindexesout This is a list of item indices corresponding to each
210: * generated approver.
211: * @param itemclassesout This is a list of item classes corresponding to each
225: procedure getAllApprovers1(applicationIdIn in number,
226: transactionTypeIn in varchar2,
227: transactionIdIn in varchar2,
228: approvalProcessCompleteYNOut out nocopy varchar2,
229: approversOut out nocopy ame_util.approversTable2,
230: itemIndexesOut out nocopy ame_util.idList,
231: itemClassesOut out nocopy ame_util.stringList,
232: itemIdsOut out nocopy ame_util.stringList,
233: itemSourcesOut out nocopy ame_util.longStringList);
226: transactionTypeIn in varchar2,
227: transactionIdIn in varchar2,
228: approvalProcessCompleteYNOut out nocopy varchar2,
229: approversOut out nocopy ame_util.approversTable2,
230: itemIndexesOut out nocopy ame_util.idList,
231: itemClassesOut out nocopy ame_util.stringList,
232: itemIdsOut out nocopy ame_util.stringList,
233: itemSourcesOut out nocopy ame_util.longStringList);
234: --
227: transactionIdIn in varchar2,
228: approvalProcessCompleteYNOut out nocopy varchar2,
229: approversOut out nocopy ame_util.approversTable2,
230: itemIndexesOut out nocopy ame_util.idList,
231: itemClassesOut out nocopy ame_util.stringList,
232: itemIdsOut out nocopy ame_util.stringList,
233: itemSourcesOut out nocopy ame_util.longStringList);
234: --
235: -- ----------------------------------------------------------------------------
228: approvalProcessCompleteYNOut out nocopy varchar2,
229: approversOut out nocopy ame_util.approversTable2,
230: itemIndexesOut out nocopy ame_util.idList,
231: itemClassesOut out nocopy ame_util.stringList,
232: itemIdsOut out nocopy ame_util.stringList,
233: itemSourcesOut out nocopy ame_util.longStringList);
234: --
235: -- ----------------------------------------------------------------------------
236: -- |-----------------------------< getallapprovers2 >-------------------------|
229: approversOut out nocopy ame_util.approversTable2,
230: itemIndexesOut out nocopy ame_util.idList,
231: itemClassesOut out nocopy ame_util.stringList,
232: itemIdsOut out nocopy ame_util.stringList,
233: itemSourcesOut out nocopy ame_util.longStringList);
234: --
235: -- ----------------------------------------------------------------------------
236: -- |-----------------------------< getallapprovers2 >-------------------------|
237: -- ----------------------------------------------------------------------------
277: * white-space characters, and must not be the character representation of a
278: * negative integer.
279: * @param approvalprocesscompleteynout This indicates current status of
280: * transaction's approval process.
281: * @param approversout This is an ame_util.approverstable2, and is populated
282: * with the list of generated approvers.
283: * @param itemindexesout This is a list of item indices corresponding to each
284: * generated approver..
285: * @param itemclassesout This is a list of item classes corresponding to each
304: procedure getAllApprovers2(applicationIdIn in number,
305: transactionTypeIn in varchar2,
306: transactionIdIn in varchar2,
307: approvalProcessCompleteYNOut out nocopy varchar2,
308: approversOut out nocopy ame_util.approversTable2,
309: itemIndexesOut out nocopy ame_util.idList,
310: itemClassesOut out nocopy ame_util.stringList,
311: itemIdsOut out nocopy ame_util.stringList,
312: itemSourcesOut out nocopy ame_util.longStringList,
305: transactionTypeIn in varchar2,
306: transactionIdIn in varchar2,
307: approvalProcessCompleteYNOut out nocopy varchar2,
308: approversOut out nocopy ame_util.approversTable2,
309: itemIndexesOut out nocopy ame_util.idList,
310: itemClassesOut out nocopy ame_util.stringList,
311: itemIdsOut out nocopy ame_util.stringList,
312: itemSourcesOut out nocopy ame_util.longStringList,
313: productionIndexesOut out nocopy ame_util.idList,
306: transactionIdIn in varchar2,
307: approvalProcessCompleteYNOut out nocopy varchar2,
308: approversOut out nocopy ame_util.approversTable2,
309: itemIndexesOut out nocopy ame_util.idList,
310: itemClassesOut out nocopy ame_util.stringList,
311: itemIdsOut out nocopy ame_util.stringList,
312: itemSourcesOut out nocopy ame_util.longStringList,
313: productionIndexesOut out nocopy ame_util.idList,
314: variableNamesOut out nocopy ame_util.stringList,
307: approvalProcessCompleteYNOut out nocopy varchar2,
308: approversOut out nocopy ame_util.approversTable2,
309: itemIndexesOut out nocopy ame_util.idList,
310: itemClassesOut out nocopy ame_util.stringList,
311: itemIdsOut out nocopy ame_util.stringList,
312: itemSourcesOut out nocopy ame_util.longStringList,
313: productionIndexesOut out nocopy ame_util.idList,
314: variableNamesOut out nocopy ame_util.stringList,
315: variableValuesOut out nocopy ame_util.stringList);
308: approversOut out nocopy ame_util.approversTable2,
309: itemIndexesOut out nocopy ame_util.idList,
310: itemClassesOut out nocopy ame_util.stringList,
311: itemIdsOut out nocopy ame_util.stringList,
312: itemSourcesOut out nocopy ame_util.longStringList,
313: productionIndexesOut out nocopy ame_util.idList,
314: variableNamesOut out nocopy ame_util.stringList,
315: variableValuesOut out nocopy ame_util.stringList);
316: --
309: itemIndexesOut out nocopy ame_util.idList,
310: itemClassesOut out nocopy ame_util.stringList,
311: itemIdsOut out nocopy ame_util.stringList,
312: itemSourcesOut out nocopy ame_util.longStringList,
313: productionIndexesOut out nocopy ame_util.idList,
314: variableNamesOut out nocopy ame_util.stringList,
315: variableValuesOut out nocopy ame_util.stringList);
316: --
317: -- ----------------------------------------------------------------------------
310: itemClassesOut out nocopy ame_util.stringList,
311: itemIdsOut out nocopy ame_util.stringList,
312: itemSourcesOut out nocopy ame_util.longStringList,
313: productionIndexesOut out nocopy ame_util.idList,
314: variableNamesOut out nocopy ame_util.stringList,
315: variableValuesOut out nocopy ame_util.stringList);
316: --
317: -- ----------------------------------------------------------------------------
318: -- |-----------------------------< getallapprovers3 >-------------------------|
311: itemIdsOut out nocopy ame_util.stringList,
312: itemSourcesOut out nocopy ame_util.longStringList,
313: productionIndexesOut out nocopy ame_util.idList,
314: variableNamesOut out nocopy ame_util.stringList,
315: variableValuesOut out nocopy ame_util.stringList);
316: --
317: -- ----------------------------------------------------------------------------
318: -- |-----------------------------< getallapprovers3 >-------------------------|
319: -- ----------------------------------------------------------------------------
355: * white-space characters, and must not be the character representation of a
356: * negative integer.
357: * @param approvalprocesscompleteynout This indicates current status of
358: * transaction's approval process.
359: * @param approversout This is an ame_util.approverstable2, that will be
360: * populated with the list of generated approvers.
361: * @param itemindexesout List of item indices corresponding to each generated
362: * approver.
363: * @param itemclassesout List of item classes corresponding to each generated
385: procedure getAllApprovers3(applicationIdIn in number,
386: transactionTypeIn in varchar2,
387: transactionIdIn in varchar2,
388: approvalProcessCompleteYNOut out nocopy varchar2,
389: approversOut out nocopy ame_util.approversTable2,
390: itemIndexesOut out nocopy ame_util.idList,
391: itemClassesOut out nocopy ame_util.stringList,
392: itemIdsOut out nocopy ame_util.stringList,
393: itemSourcesOut out nocopy ame_util.longStringList,
386: transactionTypeIn in varchar2,
387: transactionIdIn in varchar2,
388: approvalProcessCompleteYNOut out nocopy varchar2,
389: approversOut out nocopy ame_util.approversTable2,
390: itemIndexesOut out nocopy ame_util.idList,
391: itemClassesOut out nocopy ame_util.stringList,
392: itemIdsOut out nocopy ame_util.stringList,
393: itemSourcesOut out nocopy ame_util.longStringList,
394: productionIndexesOut out nocopy ame_util.idList,
387: transactionIdIn in varchar2,
388: approvalProcessCompleteYNOut out nocopy varchar2,
389: approversOut out nocopy ame_util.approversTable2,
390: itemIndexesOut out nocopy ame_util.idList,
391: itemClassesOut out nocopy ame_util.stringList,
392: itemIdsOut out nocopy ame_util.stringList,
393: itemSourcesOut out nocopy ame_util.longStringList,
394: productionIndexesOut out nocopy ame_util.idList,
395: variableNamesOut out nocopy ame_util.stringList,
388: approvalProcessCompleteYNOut out nocopy varchar2,
389: approversOut out nocopy ame_util.approversTable2,
390: itemIndexesOut out nocopy ame_util.idList,
391: itemClassesOut out nocopy ame_util.stringList,
392: itemIdsOut out nocopy ame_util.stringList,
393: itemSourcesOut out nocopy ame_util.longStringList,
394: productionIndexesOut out nocopy ame_util.idList,
395: variableNamesOut out nocopy ame_util.stringList,
396: variableValuesOut out nocopy ame_util.stringList,
389: approversOut out nocopy ame_util.approversTable2,
390: itemIndexesOut out nocopy ame_util.idList,
391: itemClassesOut out nocopy ame_util.stringList,
392: itemIdsOut out nocopy ame_util.stringList,
393: itemSourcesOut out nocopy ame_util.longStringList,
394: productionIndexesOut out nocopy ame_util.idList,
395: variableNamesOut out nocopy ame_util.stringList,
396: variableValuesOut out nocopy ame_util.stringList,
397: transVariableNamesOut out nocopy ame_util.stringList,
390: itemIndexesOut out nocopy ame_util.idList,
391: itemClassesOut out nocopy ame_util.stringList,
392: itemIdsOut out nocopy ame_util.stringList,
393: itemSourcesOut out nocopy ame_util.longStringList,
394: productionIndexesOut out nocopy ame_util.idList,
395: variableNamesOut out nocopy ame_util.stringList,
396: variableValuesOut out nocopy ame_util.stringList,
397: transVariableNamesOut out nocopy ame_util.stringList,
398: transVariableValuesOut out nocopy ame_util.stringList);
391: itemClassesOut out nocopy ame_util.stringList,
392: itemIdsOut out nocopy ame_util.stringList,
393: itemSourcesOut out nocopy ame_util.longStringList,
394: productionIndexesOut out nocopy ame_util.idList,
395: variableNamesOut out nocopy ame_util.stringList,
396: variableValuesOut out nocopy ame_util.stringList,
397: transVariableNamesOut out nocopy ame_util.stringList,
398: transVariableValuesOut out nocopy ame_util.stringList);
399: --
392: itemIdsOut out nocopy ame_util.stringList,
393: itemSourcesOut out nocopy ame_util.longStringList,
394: productionIndexesOut out nocopy ame_util.idList,
395: variableNamesOut out nocopy ame_util.stringList,
396: variableValuesOut out nocopy ame_util.stringList,
397: transVariableNamesOut out nocopy ame_util.stringList,
398: transVariableValuesOut out nocopy ame_util.stringList);
399: --
400: -- ----------------------------------------------------------------------------
393: itemSourcesOut out nocopy ame_util.longStringList,
394: productionIndexesOut out nocopy ame_util.idList,
395: variableNamesOut out nocopy ame_util.stringList,
396: variableValuesOut out nocopy ame_util.stringList,
397: transVariableNamesOut out nocopy ame_util.stringList,
398: transVariableValuesOut out nocopy ame_util.stringList);
399: --
400: -- ----------------------------------------------------------------------------
401: -- |-----------------------------< getallapprovers4 >-------------------------|
394: productionIndexesOut out nocopy ame_util.idList,
395: variableNamesOut out nocopy ame_util.stringList,
396: variableValuesOut out nocopy ame_util.stringList,
397: transVariableNamesOut out nocopy ame_util.stringList,
398: transVariableValuesOut out nocopy ame_util.stringList);
399: --
400: -- ----------------------------------------------------------------------------
401: -- |-----------------------------< getallapprovers4 >-------------------------|
402: -- ----------------------------------------------------------------------------
450: * white-space characters, and must not be the character representation of a
451: * negative integer.
452: * @param approvalprocesscompleteynout This indicates current status of
453: * transaction's approval process.
454: * @param approversout This is an ame_util.approverstable2, that will be
455: * populated with the list of approvers generated.
456: * @param itemindexesout List of item indices corresponding to each generated
457: * approver.
458: * @param itemclassesout List of item classes corresponding to each generated
476: procedure getAllApprovers4(applicationIdIn in number,
477: transactionTypeIn in varchar2,
478: transactionIdIn in varchar2,
479: approvalProcessCompleteYNOut out nocopy varchar2,
480: approversOut out nocopy ame_util.approversTable2,
481: itemIndexesOut out nocopy ame_util.idList,
482: itemClassesOut out nocopy ame_util.stringList,
483: itemIdsOut out nocopy ame_util.stringList,
484: itemSourcesOut out nocopy ame_util.longStringList,
477: transactionTypeIn in varchar2,
478: transactionIdIn in varchar2,
479: approvalProcessCompleteYNOut out nocopy varchar2,
480: approversOut out nocopy ame_util.approversTable2,
481: itemIndexesOut out nocopy ame_util.idList,
482: itemClassesOut out nocopy ame_util.stringList,
483: itemIdsOut out nocopy ame_util.stringList,
484: itemSourcesOut out nocopy ame_util.longStringList,
485: ruleIndexesOut out nocopy ame_util.idList,
478: transactionIdIn in varchar2,
479: approvalProcessCompleteYNOut out nocopy varchar2,
480: approversOut out nocopy ame_util.approversTable2,
481: itemIndexesOut out nocopy ame_util.idList,
482: itemClassesOut out nocopy ame_util.stringList,
483: itemIdsOut out nocopy ame_util.stringList,
484: itemSourcesOut out nocopy ame_util.longStringList,
485: ruleIndexesOut out nocopy ame_util.idList,
486: sourceTypesOut out nocopy ame_util.stringList,
479: approvalProcessCompleteYNOut out nocopy varchar2,
480: approversOut out nocopy ame_util.approversTable2,
481: itemIndexesOut out nocopy ame_util.idList,
482: itemClassesOut out nocopy ame_util.stringList,
483: itemIdsOut out nocopy ame_util.stringList,
484: itemSourcesOut out nocopy ame_util.longStringList,
485: ruleIndexesOut out nocopy ame_util.idList,
486: sourceTypesOut out nocopy ame_util.stringList,
487: ruleIdsOut out nocopy ame_util.idList);
480: approversOut out nocopy ame_util.approversTable2,
481: itemIndexesOut out nocopy ame_util.idList,
482: itemClassesOut out nocopy ame_util.stringList,
483: itemIdsOut out nocopy ame_util.stringList,
484: itemSourcesOut out nocopy ame_util.longStringList,
485: ruleIndexesOut out nocopy ame_util.idList,
486: sourceTypesOut out nocopy ame_util.stringList,
487: ruleIdsOut out nocopy ame_util.idList);
488: --
481: itemIndexesOut out nocopy ame_util.idList,
482: itemClassesOut out nocopy ame_util.stringList,
483: itemIdsOut out nocopy ame_util.stringList,
484: itemSourcesOut out nocopy ame_util.longStringList,
485: ruleIndexesOut out nocopy ame_util.idList,
486: sourceTypesOut out nocopy ame_util.stringList,
487: ruleIdsOut out nocopy ame_util.idList);
488: --
489: -- ----------------------------------------------------------------------------
482: itemClassesOut out nocopy ame_util.stringList,
483: itemIdsOut out nocopy ame_util.stringList,
484: itemSourcesOut out nocopy ame_util.longStringList,
485: ruleIndexesOut out nocopy ame_util.idList,
486: sourceTypesOut out nocopy ame_util.stringList,
487: ruleIdsOut out nocopy ame_util.idList);
488: --
489: -- ----------------------------------------------------------------------------
490: -- |-----------------------------< getallapprovers5 >-------------------------|
483: itemIdsOut out nocopy ame_util.stringList,
484: itemSourcesOut out nocopy ame_util.longStringList,
485: ruleIndexesOut out nocopy ame_util.idList,
486: sourceTypesOut out nocopy ame_util.stringList,
487: ruleIdsOut out nocopy ame_util.idList);
488: --
489: -- ----------------------------------------------------------------------------
490: -- |-----------------------------< getallapprovers5 >-------------------------|
491: -- ----------------------------------------------------------------------------
525: * white-space characters, and must not be the character representation of a
526: * negative integer.
527: * @param approvalprocesscompleteynout This indicates current status of
528: * transaction's approval process.
529: * @param approversout This is an ame_util.approverstable2, that will be
530: * populated with the list of generated approvers.
531: * @param itemindexesout List of item indices corresponding to each generated
532: * approver.
533: * @param itemclassesout List of item classes corresponding to each generated
552: procedure getAllApprovers5(applicationIdIn in number,
553: transactionTypeIn in varchar2,
554: transactionIdIn in varchar2,
555: approvalProcessCompleteYNOut out nocopy varchar2,
556: approversOut out nocopy ame_util.approversTable2,
557: itemIndexesOut out nocopy ame_util.idList,
558: itemClassesOut out nocopy ame_util.stringList,
559: itemIdsOut out nocopy ame_util.stringList,
560: itemSourcesOut out nocopy ame_util.longStringList,
553: transactionTypeIn in varchar2,
554: transactionIdIn in varchar2,
555: approvalProcessCompleteYNOut out nocopy varchar2,
556: approversOut out nocopy ame_util.approversTable2,
557: itemIndexesOut out nocopy ame_util.idList,
558: itemClassesOut out nocopy ame_util.stringList,
559: itemIdsOut out nocopy ame_util.stringList,
560: itemSourcesOut out nocopy ame_util.longStringList,
561: ruleIndexesOut out nocopy ame_util.idList,
554: transactionIdIn in varchar2,
555: approvalProcessCompleteYNOut out nocopy varchar2,
556: approversOut out nocopy ame_util.approversTable2,
557: itemIndexesOut out nocopy ame_util.idList,
558: itemClassesOut out nocopy ame_util.stringList,
559: itemIdsOut out nocopy ame_util.stringList,
560: itemSourcesOut out nocopy ame_util.longStringList,
561: ruleIndexesOut out nocopy ame_util.idList,
562: sourceTypesOut out nocopy ame_util.stringList,
555: approvalProcessCompleteYNOut out nocopy varchar2,
556: approversOut out nocopy ame_util.approversTable2,
557: itemIndexesOut out nocopy ame_util.idList,
558: itemClassesOut out nocopy ame_util.stringList,
559: itemIdsOut out nocopy ame_util.stringList,
560: itemSourcesOut out nocopy ame_util.longStringList,
561: ruleIndexesOut out nocopy ame_util.idList,
562: sourceTypesOut out nocopy ame_util.stringList,
563: ruleDescriptionsOut out nocopy ame_util.stringList);
556: approversOut out nocopy ame_util.approversTable2,
557: itemIndexesOut out nocopy ame_util.idList,
558: itemClassesOut out nocopy ame_util.stringList,
559: itemIdsOut out nocopy ame_util.stringList,
560: itemSourcesOut out nocopy ame_util.longStringList,
561: ruleIndexesOut out nocopy ame_util.idList,
562: sourceTypesOut out nocopy ame_util.stringList,
563: ruleDescriptionsOut out nocopy ame_util.stringList);
564: --
557: itemIndexesOut out nocopy ame_util.idList,
558: itemClassesOut out nocopy ame_util.stringList,
559: itemIdsOut out nocopy ame_util.stringList,
560: itemSourcesOut out nocopy ame_util.longStringList,
561: ruleIndexesOut out nocopy ame_util.idList,
562: sourceTypesOut out nocopy ame_util.stringList,
563: ruleDescriptionsOut out nocopy ame_util.stringList);
564: --
565: -- ----------------------------------------------------------------------------
558: itemClassesOut out nocopy ame_util.stringList,
559: itemIdsOut out nocopy ame_util.stringList,
560: itemSourcesOut out nocopy ame_util.longStringList,
561: ruleIndexesOut out nocopy ame_util.idList,
562: sourceTypesOut out nocopy ame_util.stringList,
563: ruleDescriptionsOut out nocopy ame_util.stringList);
564: --
565: -- ----------------------------------------------------------------------------
566: -- |-----------------------------< getallapprovers6 >-------------------------|
559: itemIdsOut out nocopy ame_util.stringList,
560: itemSourcesOut out nocopy ame_util.longStringList,
561: ruleIndexesOut out nocopy ame_util.idList,
562: sourceTypesOut out nocopy ame_util.stringList,
563: ruleDescriptionsOut out nocopy ame_util.stringList);
564: --
565: -- ----------------------------------------------------------------------------
566: -- |-----------------------------< getallapprovers6 >-------------------------|
567: -- ----------------------------------------------------------------------------
600: * white-space characters, and must not be the character representation of a
601: * negative integer.
602: * @param approvalprocesscompleteynout This indicates current status of
603: * transaction's approval process.
604: * @param approversout This is an ame_util.approverstable2, that will be
605: * populated with the list of generated approvers.
606: * @param itemindexesout List of item indices corresponding to each generated
607: * approver.
608: * @param itemclassesout List of item classes corresponding to each generated
628: procedure getAllApprovers6(applicationIdIn in number,
629: transactionTypeIn in varchar2,
630: transactionIdIn in varchar2,
631: approvalProcessCompleteYNOut out nocopy varchar2,
632: approversOut out nocopy ame_util.approversTable2,
633: itemIndexesOut out nocopy ame_util.idList,
634: itemClassesOut out nocopy ame_util.stringList,
635: itemIdsOut out nocopy ame_util.stringList,
636: itemSourcesOut out nocopy ame_util.longStringList,
629: transactionTypeIn in varchar2,
630: transactionIdIn in varchar2,
631: approvalProcessCompleteYNOut out nocopy varchar2,
632: approversOut out nocopy ame_util.approversTable2,
633: itemIndexesOut out nocopy ame_util.idList,
634: itemClassesOut out nocopy ame_util.stringList,
635: itemIdsOut out nocopy ame_util.stringList,
636: itemSourcesOut out nocopy ame_util.longStringList,
637: ruleIndexesOut out nocopy ame_util.idList,
630: transactionIdIn in varchar2,
631: approvalProcessCompleteYNOut out nocopy varchar2,
632: approversOut out nocopy ame_util.approversTable2,
633: itemIndexesOut out nocopy ame_util.idList,
634: itemClassesOut out nocopy ame_util.stringList,
635: itemIdsOut out nocopy ame_util.stringList,
636: itemSourcesOut out nocopy ame_util.longStringList,
637: ruleIndexesOut out nocopy ame_util.idList,
638: sourceTypesOut out nocopy ame_util.stringList,
631: approvalProcessCompleteYNOut out nocopy varchar2,
632: approversOut out nocopy ame_util.approversTable2,
633: itemIndexesOut out nocopy ame_util.idList,
634: itemClassesOut out nocopy ame_util.stringList,
635: itemIdsOut out nocopy ame_util.stringList,
636: itemSourcesOut out nocopy ame_util.longStringList,
637: ruleIndexesOut out nocopy ame_util.idList,
638: sourceTypesOut out nocopy ame_util.stringList,
639: ruleIdsOut out nocopy ame_util.idList,
632: approversOut out nocopy ame_util.approversTable2,
633: itemIndexesOut out nocopy ame_util.idList,
634: itemClassesOut out nocopy ame_util.stringList,
635: itemIdsOut out nocopy ame_util.stringList,
636: itemSourcesOut out nocopy ame_util.longStringList,
637: ruleIndexesOut out nocopy ame_util.idList,
638: sourceTypesOut out nocopy ame_util.stringList,
639: ruleIdsOut out nocopy ame_util.idList,
640: ruleDescriptionsOut out nocopy ame_util.stringList);
633: itemIndexesOut out nocopy ame_util.idList,
634: itemClassesOut out nocopy ame_util.stringList,
635: itemIdsOut out nocopy ame_util.stringList,
636: itemSourcesOut out nocopy ame_util.longStringList,
637: ruleIndexesOut out nocopy ame_util.idList,
638: sourceTypesOut out nocopy ame_util.stringList,
639: ruleIdsOut out nocopy ame_util.idList,
640: ruleDescriptionsOut out nocopy ame_util.stringList);
641: --
634: itemClassesOut out nocopy ame_util.stringList,
635: itemIdsOut out nocopy ame_util.stringList,
636: itemSourcesOut out nocopy ame_util.longStringList,
637: ruleIndexesOut out nocopy ame_util.idList,
638: sourceTypesOut out nocopy ame_util.stringList,
639: ruleIdsOut out nocopy ame_util.idList,
640: ruleDescriptionsOut out nocopy ame_util.stringList);
641: --
642: -- ----------------------------------------------------------------------------
635: itemIdsOut out nocopy ame_util.stringList,
636: itemSourcesOut out nocopy ame_util.longStringList,
637: ruleIndexesOut out nocopy ame_util.idList,
638: sourceTypesOut out nocopy ame_util.stringList,
639: ruleIdsOut out nocopy ame_util.idList,
640: ruleDescriptionsOut out nocopy ame_util.stringList);
641: --
642: -- ----------------------------------------------------------------------------
643: -- |-----------------------------< getallapprovers7 >-------------------------|
636: itemSourcesOut out nocopy ame_util.longStringList,
637: ruleIndexesOut out nocopy ame_util.idList,
638: sourceTypesOut out nocopy ame_util.stringList,
639: ruleIdsOut out nocopy ame_util.idList,
640: ruleDescriptionsOut out nocopy ame_util.stringList);
641: --
642: -- ----------------------------------------------------------------------------
643: -- |-----------------------------< getallapprovers7 >-------------------------|
644: -- ----------------------------------------------------------------------------
677: * white-space characters, and must not be the character representation of a
678: * negative integer.
679: * @param approvalprocesscompleteynout This indicates current status of
680: * transaction's approval process.
681: * @param approversout This is an ame_util.approverstable2, that will be
682: * populated with the list of approvers generated.
683: * @rep:displayname Get All Approvers 7
684: * @rep:category BUSINESS_ENTITY AME_APPROVAL
685: * @rep:lifecycle active
691: procedure getAllApprovers7(applicationIdIn in number,
692: transactionTypeIn in varchar2,
693: transactionIdIn in varchar2,
694: approvalProcessCompleteYNOut out nocopy varchar2,
695: approversOut out nocopy ame_util.approversTable2);
696: --
697: -- ----------------------------------------------------------------------------
698: -- |---------------------------< getallitemapprovers1 >-----------------------|
699: -- ----------------------------------------------------------------------------
735: * @param itemidin Item Id in a transaction for which the list of approvers
736: * will be retrieved.
737: * @param approvalprocesscompleteynout This indicates current status of
738: * item's approval process.
739: * @param approversout This is an ame_util.approverstable2, that will be
740: * populated with the list of approvers generated.
741: * @rep:displayname Get All Item Approvers 1
742: * @rep:category BUSINESS_ENTITY AME_APPROVAL
743: * @rep:lifecycle active
751: transactionIdIn in varchar2,
752: itemClassIdIn in number,
753: itemIdIn in varchar2,
754: approvalProcessCompleteYNOut out nocopy varchar2,
755: approversOut out nocopy ame_util.approversTable2);
756: --
757: -- ----------------------------------------------------------------------------
758: -- |---------------------------< getallitemapprovers2 >-----------------------|
759: -- ----------------------------------------------------------------------------
795: * @param itemidin Item Id in a transaction for which the list of approvers
796: * will be retrieved.
797: * @param approvalprocesscompleteynout This indicates current status of
798: * item's approval process.
799: * @param approversout This is an ame_util.approverstable2, that will be
800: * populated with the list of approvers generated.
801: * @rep:displayname Get All Item Approvers 2
802: * @rep:category BUSINESS_ENTITY AME_APPROVAL
803: * @rep:lifecycle active
811: transactionIdIn in varchar2,
812: itemClassNameIn in varchar2,
813: itemIdIn in varchar2,
814: approvalProcessCompleteYNOut out nocopy varchar2,
815: approversOut out nocopy ame_util.approversTable2);
816: --
817: -- ----------------------------------------------------------------------------
818: -- |-----------------------------< getandrecordallapprovers >------------------|
819: -- ----------------------------------------------------------------------------
847: * negative integer.
848: * @param transactiontypein This is a string parameter up to 50 bytes long. It
849: * distinguishes one transaction type from another, within a given originating
850: * application. It can be null, but you must always pass its value explicitly.
851: * @param approversout This is the ame_util.approversTable2 which represents the
852: * list of approvers.
853: * @param approvalprocesscompleteynout This indicates current status of
854: * transaction's approval process.
855: * @param itemindexesout List of item indices corresponding to each generated
870: procedure getAndRecordAllApprovers(applicationIdIn in number,
871: transactionTypeIn in varchar2,
872: transactionIdIn in varchar2,
873: approvalProcessCompleteYNOut out nocopy varchar2,
874: approversOut out nocopy ame_util.approversTable2,
875: itemIndexesOut out nocopy ame_util.idList,
876: itemClassesOut out nocopy ame_util.stringList,
877: itemIdsOut out nocopy ame_util.stringList,
878: itemSourcesOut out nocopy ame_util.longStringList);
871: transactionTypeIn in varchar2,
872: transactionIdIn in varchar2,
873: approvalProcessCompleteYNOut out nocopy varchar2,
874: approversOut out nocopy ame_util.approversTable2,
875: itemIndexesOut out nocopy ame_util.idList,
876: itemClassesOut out nocopy ame_util.stringList,
877: itemIdsOut out nocopy ame_util.stringList,
878: itemSourcesOut out nocopy ame_util.longStringList);
879: --
872: transactionIdIn in varchar2,
873: approvalProcessCompleteYNOut out nocopy varchar2,
874: approversOut out nocopy ame_util.approversTable2,
875: itemIndexesOut out nocopy ame_util.idList,
876: itemClassesOut out nocopy ame_util.stringList,
877: itemIdsOut out nocopy ame_util.stringList,
878: itemSourcesOut out nocopy ame_util.longStringList);
879: --
880: -- ----------------------------------------------------------------------------
873: approvalProcessCompleteYNOut out nocopy varchar2,
874: approversOut out nocopy ame_util.approversTable2,
875: itemIndexesOut out nocopy ame_util.idList,
876: itemClassesOut out nocopy ame_util.stringList,
877: itemIdsOut out nocopy ame_util.stringList,
878: itemSourcesOut out nocopy ame_util.longStringList);
879: --
880: -- ----------------------------------------------------------------------------
881: -- |------------------------------< getitemstatus1 >--------------------------|
874: approversOut out nocopy ame_util.approversTable2,
875: itemIndexesOut out nocopy ame_util.idList,
876: itemClassesOut out nocopy ame_util.stringList,
877: itemIdsOut out nocopy ame_util.stringList,
878: itemSourcesOut out nocopy ame_util.longStringList);
879: --
880: -- ----------------------------------------------------------------------------
881: -- |------------------------------< getitemstatus1 >--------------------------|
882: -- ----------------------------------------------------------------------------
885: /*#
886: * This API returns the status of approval process of the given item.
887: * The item is identified by item id and item class id.
888: *
approvalProcessCompleteYNOut can have one of the following values
889: *
890: * item have approved
891: *
887: * The item is identified by item id and item class id.
888: *
approvalProcessCompleteYNOut can have one of the following values
889: *
889: *
891: *
Licensing
899: * This API is available for use with any licensed component of the e-business
1006: *
1007: * The value at approvalProcessesCompleteYNOut(i) indicates the status of
1008: * item identified by item itemIdsOut(i) of the item class itemClassNamesOut(i)
1009: *
approvalProcessesCompleteYNOut(i) can have one of the following values
1010: *
1011: * item have approved
1012: *
1008: * item identified by item itemIdsOut(i) of the item class itemClassNamesOut(i)
1009: *
approvalProcessesCompleteYNOut(i) can have one of the following values
1010: *
1010: *
1012: *
Licensing
1020: * This API is available for use with any licensed component of the e-business
1056: --
1057: procedure getItemStatuses(applicationIdIn in number,
1058: transactionTypeIn in varchar2,
1059: transactionIdIn in varchar2,
1060: itemClassNamesOut out nocopy ame_util.stringList,
1061: itemIdsOut out nocopy ame_util.stringList,
1062: approvalProcessesCompleteYNOut out nocopy ame_util.charList);
1063: --
1064: -- ----------------------------------------------------------------------------
1057: procedure getItemStatuses(applicationIdIn in number,
1058: transactionTypeIn in varchar2,
1059: transactionIdIn in varchar2,
1060: itemClassNamesOut out nocopy ame_util.stringList,
1061: itemIdsOut out nocopy ame_util.stringList,
1062: approvalProcessesCompleteYNOut out nocopy ame_util.charList);
1063: --
1064: -- ----------------------------------------------------------------------------
1065: -- |----------------------------< getnextapprovers1 >-------------------------|
1058: transactionTypeIn in varchar2,
1059: transactionIdIn in varchar2,
1060: itemClassNamesOut out nocopy ame_util.stringList,
1061: itemIdsOut out nocopy ame_util.stringList,
1062: approvalProcessesCompleteYNOut out nocopy ame_util.charList);
1063: --
1064: -- ----------------------------------------------------------------------------
1065: -- |----------------------------< getnextapprovers1 >-------------------------|
1066: -- ----------------------------------------------------------------------------
1070: * This API returns the list of approvers requiring notification for the
1071: * current stage of a transaction approval.
1072: *
1073: * Once an originating application updates an approver's status to
1074: * ame_util.notifiedStatus, getNextApprovers1 excludes the approver from
1075: * nextApproversOut. An originating application can update an approver's status
1076: * to ame_util.notifiedStatus by passing ame_util.booleanTrue as
1077: * flagApproversAsNotifiedIn to a call to getNextApprovers1 that includes the
1078: * approver in nextApproversOut. Or the originating application can pass
1072: *
1073: * Once an originating application updates an approver's status to
1074: * ame_util.notifiedStatus, getNextApprovers1 excludes the approver from
1075: * nextApproversOut. An originating application can update an approver's status
1076: * to ame_util.notifiedStatus by passing ame_util.booleanTrue as
1077: * flagApproversAsNotifiedIn to a call to getNextApprovers1 that includes the
1078: * approver in nextApproversOut. Or the originating application can pass
1079: * ame_util.booleanFalse in flagApproversAsNotifiedIn, and instead call
1080: * updateApprovalStatus or updateApprovalStatus2 to update the approver's
1075: * nextApproversOut. An originating application can update an approver's status
1076: * to ame_util.notifiedStatus by passing ame_util.booleanTrue as
1077: * flagApproversAsNotifiedIn to a call to getNextApprovers1 that includes the
1078: * approver in nextApproversOut. Or the originating application can pass
1079: * ame_util.booleanFalse in flagApproversAsNotifiedIn, and instead call
1080: * updateApprovalStatus or updateApprovalStatus2 to update the approver's
1081: * status independently of a call to getNextApprovers. getNextApprovers1
1082: * outputs current status of transaction's approval process in
1083: * approvalProcessCompleteYNOut .
1081: * status independently of a call to getNextApprovers. getNextApprovers1
1082: * outputs current status of transaction's approval process in
1083: * approvalProcessCompleteYNOut .
1084: *
approvalProcessCompleteYNOut can have one of the following values
1085: *
1086: * have approved
1087: *
1083: * approvalProcessCompleteYNOut .
1084: *
approvalProcessCompleteYNOut can have one of the following values
1085: *
1085: *
1087: *
1089: *
1122: * negative integer.
1123: * @param flagapproversasnotifiedin This parameter determines whether to set
1124: * the approvalStatus as "Notified" for the generated approvers or
1125: * not based on the input value (ie. Y/N). Default value is Y
1126: * (ame_util.booleanTrue).
1127: * @param approvalprocesscompleteynout This indicates current status of
1128: * transaction's approval process.
1129: * @param nextapproversout This is an ame_util.approverstable2, that will be
1130: * populated with the list of approvers generated, requiring notification for
1125: * not based on the input value (ie. Y/N). Default value is Y
1126: * (ame_util.booleanTrue).
1127: * @param approvalprocesscompleteynout This indicates current status of
1128: * transaction's approval process.
1129: * @param nextapproversout This is an ame_util.approverstable2, that will be
1130: * populated with the list of approvers generated, requiring notification for
1131: * the current stage of the input transaction's approval process(if any).
1132: * @param itemindexesout List of item indices corresponding to each generated
1133: * approver.
1146: --
1147: procedure getNextApprovers1(applicationIdIn in number,
1148: transactionTypeIn in varchar2,
1149: transactionIdIn in varchar2,
1150: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1151: approvalProcessCompleteYNOut out nocopy varchar2,
1152: nextApproversOut out nocopy ame_util.approversTable2,
1153: itemIndexesOut out nocopy ame_util.idList,
1154: itemClassesOut out nocopy ame_util.stringList,
1148: transactionTypeIn in varchar2,
1149: transactionIdIn in varchar2,
1150: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1151: approvalProcessCompleteYNOut out nocopy varchar2,
1152: nextApproversOut out nocopy ame_util.approversTable2,
1153: itemIndexesOut out nocopy ame_util.idList,
1154: itemClassesOut out nocopy ame_util.stringList,
1155: itemIdsOut out nocopy ame_util.stringList,
1156: itemSourcesOut out nocopy ame_util.longStringList);
1149: transactionIdIn in varchar2,
1150: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1151: approvalProcessCompleteYNOut out nocopy varchar2,
1152: nextApproversOut out nocopy ame_util.approversTable2,
1153: itemIndexesOut out nocopy ame_util.idList,
1154: itemClassesOut out nocopy ame_util.stringList,
1155: itemIdsOut out nocopy ame_util.stringList,
1156: itemSourcesOut out nocopy ame_util.longStringList);
1157: --
1150: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1151: approvalProcessCompleteYNOut out nocopy varchar2,
1152: nextApproversOut out nocopy ame_util.approversTable2,
1153: itemIndexesOut out nocopy ame_util.idList,
1154: itemClassesOut out nocopy ame_util.stringList,
1155: itemIdsOut out nocopy ame_util.stringList,
1156: itemSourcesOut out nocopy ame_util.longStringList);
1157: --
1158: -- ----------------------------------------------------------------------------
1151: approvalProcessCompleteYNOut out nocopy varchar2,
1152: nextApproversOut out nocopy ame_util.approversTable2,
1153: itemIndexesOut out nocopy ame_util.idList,
1154: itemClassesOut out nocopy ame_util.stringList,
1155: itemIdsOut out nocopy ame_util.stringList,
1156: itemSourcesOut out nocopy ame_util.longStringList);
1157: --
1158: -- ----------------------------------------------------------------------------
1159: -- |----------------------------< getnextapprovers2 >-------------------------|
1152: nextApproversOut out nocopy ame_util.approversTable2,
1153: itemIndexesOut out nocopy ame_util.idList,
1154: itemClassesOut out nocopy ame_util.stringList,
1155: itemIdsOut out nocopy ame_util.stringList,
1156: itemSourcesOut out nocopy ame_util.longStringList);
1157: --
1158: -- ----------------------------------------------------------------------------
1159: -- |----------------------------< getnextapprovers2 >-------------------------|
1160: -- ----------------------------------------------------------------------------
1198: * negative integer.
1199: * @param flagapproversasnotifiedin This parameter determines whether to set
1200: * the approvalStatus as "Notified" for the generated approvers or
1201: * not based on the input value (ie. Y/N). Default value is Y
1202: * (ame_util.booleanTrue).
1203: * @param approvalprocesscompleteynout This indicates current status of
1204: * transaction's approval process.
1205: * @param nextapproversout This is an ame_util.approverstable2, that will be
1206: * populated with the list of approvers generated, requiring notification for
1201: * not based on the input value (ie. Y/N). Default value is Y
1202: * (ame_util.booleanTrue).
1203: * @param approvalprocesscompleteynout This indicates current status of
1204: * transaction's approval process.
1205: * @param nextapproversout This is an ame_util.approverstable2, that will be
1206: * populated with the list of approvers generated, requiring notification for
1207: * the current stage of the input transaction's approval process.
1208: * @param itemindexesout List of item indices corresponding to each generated
1209: * approver.
1227: --
1228: procedure getNextApprovers2(applicationIdIn in number,
1229: transactionTypeIn in varchar2,
1230: transactionIdIn in varchar2,
1231: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1232: approvalProcessCompleteYNOut out nocopy varchar2,
1233: nextApproversOut out nocopy ame_util.approversTable2,
1234: itemIndexesOut out nocopy ame_util.idList,
1235: itemClassesOut out nocopy ame_util.stringList,
1229: transactionTypeIn in varchar2,
1230: transactionIdIn in varchar2,
1231: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1232: approvalProcessCompleteYNOut out nocopy varchar2,
1233: nextApproversOut out nocopy ame_util.approversTable2,
1234: itemIndexesOut out nocopy ame_util.idList,
1235: itemClassesOut out nocopy ame_util.stringList,
1236: itemIdsOut out nocopy ame_util.stringList,
1237: itemSourcesOut out nocopy ame_util.longStringList,
1230: transactionIdIn in varchar2,
1231: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1232: approvalProcessCompleteYNOut out nocopy varchar2,
1233: nextApproversOut out nocopy ame_util.approversTable2,
1234: itemIndexesOut out nocopy ame_util.idList,
1235: itemClassesOut out nocopy ame_util.stringList,
1236: itemIdsOut out nocopy ame_util.stringList,
1237: itemSourcesOut out nocopy ame_util.longStringList,
1238: productionIndexesOut out nocopy ame_util.idList,
1231: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1232: approvalProcessCompleteYNOut out nocopy varchar2,
1233: nextApproversOut out nocopy ame_util.approversTable2,
1234: itemIndexesOut out nocopy ame_util.idList,
1235: itemClassesOut out nocopy ame_util.stringList,
1236: itemIdsOut out nocopy ame_util.stringList,
1237: itemSourcesOut out nocopy ame_util.longStringList,
1238: productionIndexesOut out nocopy ame_util.idList,
1239: variableNamesOut out nocopy ame_util.stringList,
1232: approvalProcessCompleteYNOut out nocopy varchar2,
1233: nextApproversOut out nocopy ame_util.approversTable2,
1234: itemIndexesOut out nocopy ame_util.idList,
1235: itemClassesOut out nocopy ame_util.stringList,
1236: itemIdsOut out nocopy ame_util.stringList,
1237: itemSourcesOut out nocopy ame_util.longStringList,
1238: productionIndexesOut out nocopy ame_util.idList,
1239: variableNamesOut out nocopy ame_util.stringList,
1240: variableValuesOut out nocopy ame_util.stringList);
1233: nextApproversOut out nocopy ame_util.approversTable2,
1234: itemIndexesOut out nocopy ame_util.idList,
1235: itemClassesOut out nocopy ame_util.stringList,
1236: itemIdsOut out nocopy ame_util.stringList,
1237: itemSourcesOut out nocopy ame_util.longStringList,
1238: productionIndexesOut out nocopy ame_util.idList,
1239: variableNamesOut out nocopy ame_util.stringList,
1240: variableValuesOut out nocopy ame_util.stringList);
1241: --
1234: itemIndexesOut out nocopy ame_util.idList,
1235: itemClassesOut out nocopy ame_util.stringList,
1236: itemIdsOut out nocopy ame_util.stringList,
1237: itemSourcesOut out nocopy ame_util.longStringList,
1238: productionIndexesOut out nocopy ame_util.idList,
1239: variableNamesOut out nocopy ame_util.stringList,
1240: variableValuesOut out nocopy ame_util.stringList);
1241: --
1242: -- ----------------------------------------------------------------------------
1235: itemClassesOut out nocopy ame_util.stringList,
1236: itemIdsOut out nocopy ame_util.stringList,
1237: itemSourcesOut out nocopy ame_util.longStringList,
1238: productionIndexesOut out nocopy ame_util.idList,
1239: variableNamesOut out nocopy ame_util.stringList,
1240: variableValuesOut out nocopy ame_util.stringList);
1241: --
1242: -- ----------------------------------------------------------------------------
1243: -- |----------------------------< getnextapprovers3 >-------------------------|
1236: itemIdsOut out nocopy ame_util.stringList,
1237: itemSourcesOut out nocopy ame_util.longStringList,
1238: productionIndexesOut out nocopy ame_util.idList,
1239: variableNamesOut out nocopy ame_util.stringList,
1240: variableValuesOut out nocopy ame_util.stringList);
1241: --
1242: -- ----------------------------------------------------------------------------
1243: -- |----------------------------< getnextapprovers3 >-------------------------|
1244: -- ----------------------------------------------------------------------------
1281: * negative integer.
1282: * @param flagapproversasnotifiedin This parameter determines whether to set
1283: * the approvalStatus as "Notified" for the generated approvers or
1284: * not based on the input value (ie. Y/N). Default value is Y
1285: * (ame_util.booleanTrue).
1286: * @param approvalprocesscompleteynout This indicates current status of
1287: * transaction's approval process.
1288: * @param nextapproversout This is an ame_util.approverstable2, that will be
1289: * populated with the list of approvers generated, requiring notification for
1284: * not based on the input value (ie. Y/N). Default value is Y
1285: * (ame_util.booleanTrue).
1286: * @param approvalprocesscompleteynout This indicates current status of
1287: * transaction's approval process.
1288: * @param nextapproversout This is an ame_util.approverstable2, that will be
1289: * populated with the list of approvers generated, requiring notification for
1290: * the current stage of the input transaction's approval process.
1291: * @param itemindexesout List of item indices corresponding to each generated
1292: * approver.
1314: --
1315: procedure getNextApprovers3(applicationIdIn in number,
1316: transactionTypeIn in varchar2,
1317: transactionIdIn in varchar2,
1318: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1319: approvalProcessCompleteYNOut out nocopy varchar2,
1320: nextApproversOut out nocopy ame_util.approversTable2,
1321: itemIndexesOut out nocopy ame_util.idList,
1322: itemClassesOut out nocopy ame_util.stringList,
1316: transactionTypeIn in varchar2,
1317: transactionIdIn in varchar2,
1318: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1319: approvalProcessCompleteYNOut out nocopy varchar2,
1320: nextApproversOut out nocopy ame_util.approversTable2,
1321: itemIndexesOut out nocopy ame_util.idList,
1322: itemClassesOut out nocopy ame_util.stringList,
1323: itemIdsOut out nocopy ame_util.stringList,
1324: itemSourcesOut out nocopy ame_util.longStringList,
1317: transactionIdIn in varchar2,
1318: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1319: approvalProcessCompleteYNOut out nocopy varchar2,
1320: nextApproversOut out nocopy ame_util.approversTable2,
1321: itemIndexesOut out nocopy ame_util.idList,
1322: itemClassesOut out nocopy ame_util.stringList,
1323: itemIdsOut out nocopy ame_util.stringList,
1324: itemSourcesOut out nocopy ame_util.longStringList,
1325: productionIndexesOut out nocopy ame_util.idList,
1318: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1319: approvalProcessCompleteYNOut out nocopy varchar2,
1320: nextApproversOut out nocopy ame_util.approversTable2,
1321: itemIndexesOut out nocopy ame_util.idList,
1322: itemClassesOut out nocopy ame_util.stringList,
1323: itemIdsOut out nocopy ame_util.stringList,
1324: itemSourcesOut out nocopy ame_util.longStringList,
1325: productionIndexesOut out nocopy ame_util.idList,
1326: variableNamesOut out nocopy ame_util.stringList,
1319: approvalProcessCompleteYNOut out nocopy varchar2,
1320: nextApproversOut out nocopy ame_util.approversTable2,
1321: itemIndexesOut out nocopy ame_util.idList,
1322: itemClassesOut out nocopy ame_util.stringList,
1323: itemIdsOut out nocopy ame_util.stringList,
1324: itemSourcesOut out nocopy ame_util.longStringList,
1325: productionIndexesOut out nocopy ame_util.idList,
1326: variableNamesOut out nocopy ame_util.stringList,
1327: variableValuesOut out nocopy ame_util.stringList,
1320: nextApproversOut out nocopy ame_util.approversTable2,
1321: itemIndexesOut out nocopy ame_util.idList,
1322: itemClassesOut out nocopy ame_util.stringList,
1323: itemIdsOut out nocopy ame_util.stringList,
1324: itemSourcesOut out nocopy ame_util.longStringList,
1325: productionIndexesOut out nocopy ame_util.idList,
1326: variableNamesOut out nocopy ame_util.stringList,
1327: variableValuesOut out nocopy ame_util.stringList,
1328: transVariableNamesOut out nocopy ame_util.stringList,
1321: itemIndexesOut out nocopy ame_util.idList,
1322: itemClassesOut out nocopy ame_util.stringList,
1323: itemIdsOut out nocopy ame_util.stringList,
1324: itemSourcesOut out nocopy ame_util.longStringList,
1325: productionIndexesOut out nocopy ame_util.idList,
1326: variableNamesOut out nocopy ame_util.stringList,
1327: variableValuesOut out nocopy ame_util.stringList,
1328: transVariableNamesOut out nocopy ame_util.stringList,
1329: transVariableValuesOut out nocopy ame_util.stringList);
1322: itemClassesOut out nocopy ame_util.stringList,
1323: itemIdsOut out nocopy ame_util.stringList,
1324: itemSourcesOut out nocopy ame_util.longStringList,
1325: productionIndexesOut out nocopy ame_util.idList,
1326: variableNamesOut out nocopy ame_util.stringList,
1327: variableValuesOut out nocopy ame_util.stringList,
1328: transVariableNamesOut out nocopy ame_util.stringList,
1329: transVariableValuesOut out nocopy ame_util.stringList);
1330: --
1323: itemIdsOut out nocopy ame_util.stringList,
1324: itemSourcesOut out nocopy ame_util.longStringList,
1325: productionIndexesOut out nocopy ame_util.idList,
1326: variableNamesOut out nocopy ame_util.stringList,
1327: variableValuesOut out nocopy ame_util.stringList,
1328: transVariableNamesOut out nocopy ame_util.stringList,
1329: transVariableValuesOut out nocopy ame_util.stringList);
1330: --
1331: -- ----------------------------------------------------------------------------
1324: itemSourcesOut out nocopy ame_util.longStringList,
1325: productionIndexesOut out nocopy ame_util.idList,
1326: variableNamesOut out nocopy ame_util.stringList,
1327: variableValuesOut out nocopy ame_util.stringList,
1328: transVariableNamesOut out nocopy ame_util.stringList,
1329: transVariableValuesOut out nocopy ame_util.stringList);
1330: --
1331: -- ----------------------------------------------------------------------------
1332: -- |----------------------------< getnextapprovers4 >-------------------------|
1325: productionIndexesOut out nocopy ame_util.idList,
1326: variableNamesOut out nocopy ame_util.stringList,
1327: variableValuesOut out nocopy ame_util.stringList,
1328: transVariableNamesOut out nocopy ame_util.stringList,
1329: transVariableValuesOut out nocopy ame_util.stringList);
1330: --
1331: -- ----------------------------------------------------------------------------
1332: -- |----------------------------< getnextapprovers4 >-------------------------|
1333: -- ----------------------------------------------------------------------------
1367: * negative integer.
1368: * @param flagapproversasnotifiedin This parameter determines whether to set
1369: * the approvalStatus as "Notified" for the generated approvers or
1370: * not based on the input value (ie. Y/N). Default value is Y
1371: * (ame_util.booleanTrue).
1372: * @param approvalprocesscompleteynout This indicates current status of
1373: * transaction's approval process.
1374: * @param nextapproversout This is an ame_util.approverstable2, that will be
1375: * populated with the list of approvers generated, requiring notification for
1370: * not based on the input value (ie. Y/N). Default value is Y
1371: * (ame_util.booleanTrue).
1372: * @param approvalprocesscompleteynout This indicates current status of
1373: * transaction's approval process.
1374: * @param nextapproversout This is an ame_util.approverstable2, that will be
1375: * populated with the list of approvers generated, requiring notification for
1376: * the current stage of the input transaction's approval process.
1377: * @rep:displayname Get Next Approvers 4
1378: * @rep:category BUSINESS_ENTITY AME_APPROVAL
1384: --
1385: procedure getNextApprovers4(applicationIdIn in number,
1386: transactionTypeIn in varchar2,
1387: transactionIdIn in varchar2,
1388: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1389: approvalProcessCompleteYNOut out nocopy varchar2,
1390: nextApproversOut out nocopy ame_util.approversTable2);
1391: --
1392: -- ----------------------------------------------------------------------------
1386: transactionTypeIn in varchar2,
1387: transactionIdIn in varchar2,
1388: flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue,
1389: approvalProcessCompleteYNOut out nocopy varchar2,
1390: nextApproversOut out nocopy ame_util.approversTable2);
1391: --
1392: -- ----------------------------------------------------------------------------
1393: -- |---------------------------< getpendingapprovers >------------------------|
1394: -- ----------------------------------------------------------------------------
1397: /*#
1398: * This API returns the list of pending approvers.
1399: *
1400: * The pending approvers are identified with approver_category =
1401: * ame_util.approvalApproverCategory and approval_status =
1402: * ame_util.notifiedStatus. These are the approvers who must approve before the
1403: * input transaction's approval process will continue to the next stage. If
1404: * approvalProcessCompleteYNOut is other than ame_util2.notComplete, the transaction's
1405: * approval process is complete. If approvalProcessCompleteYNOut is
1398: * This API returns the list of pending approvers.
1399: *
1400: * The pending approvers are identified with approver_category =
1401: * ame_util.approvalApproverCategory and approval_status =
1402: * ame_util.notifiedStatus. These are the approvers who must approve before the
1403: * input transaction's approval process will continue to the next stage. If
1404: * approvalProcessCompleteYNOut is other than ame_util2.notComplete, the transaction's
1405: * approval process is complete. If approvalProcessCompleteYNOut is
1406: * ame_util2.notComplete and approversOut.count is zero, the application should
1400: * The pending approvers are identified with approver_category =
1401: * ame_util.approvalApproverCategory and approval_status =
1402: * ame_util.notifiedStatus. These are the approvers who must approve before the
1403: * input transaction's approval process will continue to the next stage. If
1404: * approvalProcessCompleteYNOut is other than ame_util2.notComplete, the transaction's
1405: * approval process is complete. If approvalProcessCompleteYNOut is
1406: * ame_util2.notComplete and approversOut.count is zero, the application should
1407: * call one of the getNextApprovers[n] procedures, and notify the approvers
1408: * returned by that procedure. Note : If ame_api2.getNextApprover[n] is called
1402: * ame_util.notifiedStatus. These are the approvers who must approve before the
1403: * input transaction's approval process will continue to the next stage. If
1404: * approvalProcessCompleteYNOut is other than ame_util2.notComplete, the transaction's
1405: * approval process is complete. If approvalProcessCompleteYNOut is
1406: * ame_util2.notComplete and approversOut.count is zero, the application should
1407: * call one of the getNextApprovers[n] procedures, and notify the approvers
1408: * returned by that procedure. Note : If ame_api2.getNextApprover[n] is called
1409: * with flagApproversNotifiedIn as false, then the subsequent call to this API
1410: * would not return approvers.
1433: * white-space characters, and must not be the character representation of a
1434: * negative integer.
1435: * @param approvalprocesscompleteynout This indicates current status of
1436: * transaction's approval process.
1437: * @param approversout This is an ame_util.approverstable2, that will be
1438: * populated with the list of approvers, those who are already notified but yet
1439: * to respond.
1440: * @rep:displayname Get Pending Approvers
1441: * @rep:category BUSINESS_ENTITY AME_APPROVAL
1448: procedure getPendingApprovers(applicationIdIn in number,
1449: transactionTypeIn in varchar2,
1450: transactionIdIn in varchar2,
1451: approvalProcessCompleteYNOut out nocopy varchar2,
1452: approversOut out nocopy ame_util.approversTable2);
1453: --
1454: -- ----------------------------------------------------------------------------
1455: -- |------------------------< gettransactionproductions >---------------------|
1456: -- ----------------------------------------------------------------------------
1498: --
1499: procedure getTransactionProductions(applicationIdIn in number,
1500: transactionTypeIn in varchar2,
1501: transactionIdIn in varchar2,
1502: variableNamesOut out nocopy ame_util.stringList,
1503: variableValuesOut out nocopy ame_util.stringList);
1504: --
1505: -- ----------------------------------------------------------------------------
1506: -- |-----------------------------< initializeapprovalprocess >-----------------|
1499: procedure getTransactionProductions(applicationIdIn in number,
1500: transactionTypeIn in varchar2,
1501: transactionIdIn in varchar2,
1502: variableNamesOut out nocopy ame_util.stringList,
1503: variableValuesOut out nocopy ame_util.stringList);
1504: --
1505: -- ----------------------------------------------------------------------------
1506: -- |-----------------------------< initializeapprovalprocess >-----------------|
1507: -- ----------------------------------------------------------------------------
1593: * @param transactionidin This is a string up to 50 bytes long. It identifies a
1594: * transaction within a transaction type. Its value must not contain
1595: * white-space characters, and must not be the character representation of a
1596: * negative integer.
1597: * @param approverIn This is the approverRecord defined by ame_util.approverRecord2
1598: * which gives information regarding the Approver.
1599: * @param clearChainStatusYNIn This flag specifies whether to clear chain status or not.
1600: *
1601: * @rep:displayname Set First Authority Approver
1608: --
1609: procedure setFirstAuthorityApprover(applicationIdIn in number,
1610: transactionTypeIn in varchar2,
1611: transactionIdIn in varchar2,
1612: approverIn in ame_util.approverRecord2,
1613: clearChainStatusYNIn in varchar2);
1614: --
1615: -- ----------------------------------------------------------------------------
1616: -- |---------------------------< updateapprovalstatus >-----------------------|
1620: /*#
1621: * Updates an approver's status (to the approval_status value in
1622: * approverIn); and, if the approval_status value indicates that a
1623: * forwarding/reassignment has occurred, identifies the forwardee. However,
1624: * if the approval_status value is ame_util.clearExceptionsStatus, the
1625: * procedure clears the transaction's exception log in AME, without
1626: * changing any approver's status, regardless of the approver
1627: * identified by approverIn.
1628: * When a chain-of-authority approver forwards, AME makes the
1626: * changing any approver's status, regardless of the approver
1627: * identified by approverIn.
1628: * When a chain-of-authority approver forwards, AME makes the
1629: * forwardee also a chain-of-authority approver. Otherwise, the
1630: * forwardee has the api_insertion value ame_util.apiInsertion, and
1631: * the same authority value as the forwarder.
1632: *
1633: *
Licensing
1634: * This API is available for use with any licensed component of the e-business
1666: --
1667: procedure updateApprovalStatus(applicationIdIn in number,
1668: transactionTypeIn in varchar2,
1669: transactionIdIn in varchar2,
1670: approverIn in ame_util.approverRecord2,
1671: forwardeeIn in ame_util.approverRecord2 default ame_util.emptyApproverRecord2,
1672: updateItemIn in boolean default false);
1673: --
1674: -- ----------------------------------------------------------------------------
1667: procedure updateApprovalStatus(applicationIdIn in number,
1668: transactionTypeIn in varchar2,
1669: transactionIdIn in varchar2,
1670: approverIn in ame_util.approverRecord2,
1671: forwardeeIn in ame_util.approverRecord2 default ame_util.emptyApproverRecord2,
1672: updateItemIn in boolean default false);
1673: --
1674: -- ----------------------------------------------------------------------------
1675: -- |---------------------------< updateapprovalstatuses >---------------------|
1682: --
1683: procedure updateApprovalStatuses(applicationIdIn in number,
1684: transactionTypeIn in varchar2,
1685: transactionIdIn in varchar2,
1686: approverIn in ame_util.approverRecord2,
1687: approvalStatusesIn in ame_util.stringList default ame_util.emptyStringList,
1688: itemClassesIn in ame_util.stringList default ame_util.emptyStringList,
1689: itemIdsIn in ame_util.stringList default ame_util.emptyStringList,
1690: forwardeesIn in ame_util.approversTable2 default ame_util.emptyApproversTable2);
1683: procedure updateApprovalStatuses(applicationIdIn in number,
1684: transactionTypeIn in varchar2,
1685: transactionIdIn in varchar2,
1686: approverIn in ame_util.approverRecord2,
1687: approvalStatusesIn in ame_util.stringList default ame_util.emptyStringList,
1688: itemClassesIn in ame_util.stringList default ame_util.emptyStringList,
1689: itemIdsIn in ame_util.stringList default ame_util.emptyStringList,
1690: forwardeesIn in ame_util.approversTable2 default ame_util.emptyApproversTable2);
1691: --
1684: transactionTypeIn in varchar2,
1685: transactionIdIn in varchar2,
1686: approverIn in ame_util.approverRecord2,
1687: approvalStatusesIn in ame_util.stringList default ame_util.emptyStringList,
1688: itemClassesIn in ame_util.stringList default ame_util.emptyStringList,
1689: itemIdsIn in ame_util.stringList default ame_util.emptyStringList,
1690: forwardeesIn in ame_util.approversTable2 default ame_util.emptyApproversTable2);
1691: --
1692: -- ----------------------------------------------------------------------------
1685: transactionIdIn in varchar2,
1686: approverIn in ame_util.approverRecord2,
1687: approvalStatusesIn in ame_util.stringList default ame_util.emptyStringList,
1688: itemClassesIn in ame_util.stringList default ame_util.emptyStringList,
1689: itemIdsIn in ame_util.stringList default ame_util.emptyStringList,
1690: forwardeesIn in ame_util.approversTable2 default ame_util.emptyApproversTable2);
1691: --
1692: -- ----------------------------------------------------------------------------
1693: -- |--------------------------< updateapprovalstatus2 >-----------------------|
1686: approverIn in ame_util.approverRecord2,
1687: approvalStatusesIn in ame_util.stringList default ame_util.emptyStringList,
1688: itemClassesIn in ame_util.stringList default ame_util.emptyStringList,
1689: itemIdsIn in ame_util.stringList default ame_util.emptyStringList,
1690: forwardeesIn in ame_util.approversTable2 default ame_util.emptyApproversTable2);
1691: --
1692: -- ----------------------------------------------------------------------------
1693: -- |--------------------------< updateapprovalstatus2 >-----------------------|
1694: -- ----------------------------------------------------------------------------
1696: -- {Start Of Comments}
1697: /*#
1698: * This is a wrapper for updateApprovalStatus that lets you
1699: * identify an approver by name, rather than passing
1700: * an entire ame_util.approverRecord to the API.
1701: *
1702: *
Licensing
1703: * This API is available for use with any licensed component of the e-business
1704: * suite.
1753: itemIdIn in varchar2 default null,
1754: actionTypeIdIn in number default null,
1755: groupOrChainIdIn in number default null,
1756: occurrenceIn in number default null,
1757: forwardeeIn in ame_util.approverRecord2 default ame_util.emptyApproverRecord2,
1758: updateItemIn in boolean default false);
1759: --
1760: -- ----------------------------------------------------------------------------
1761: -- |--------------------------< updateapprovalstatuses2 >---------------------|
1775: itemIdIn in varchar2 default null,
1776: actionTypeIdIn in number default null,
1777: groupOrChainIdIn in number default null,
1778: occurrenceIn in number default null,
1779: approvalStatusesIn in ame_util.stringList default ame_util.emptyStringList,
1780: itemClassesIn in ame_util.stringList default ame_util.emptyStringList,
1781: itemIdsIn in ame_util.stringList default ame_util.emptyStringList,
1782: forwardeesIn in ame_util.approversTable2 default ame_util.emptyApproversTable2);
1783: end ame_api2;
1776: actionTypeIdIn in number default null,
1777: groupOrChainIdIn in number default null,
1778: occurrenceIn in number default null,
1779: approvalStatusesIn in ame_util.stringList default ame_util.emptyStringList,
1780: itemClassesIn in ame_util.stringList default ame_util.emptyStringList,
1781: itemIdsIn in ame_util.stringList default ame_util.emptyStringList,
1782: forwardeesIn in ame_util.approversTable2 default ame_util.emptyApproversTable2);
1783: end ame_api2;
1777: groupOrChainIdIn in number default null,
1778: occurrenceIn in number default null,
1779: approvalStatusesIn in ame_util.stringList default ame_util.emptyStringList,
1780: itemClassesIn in ame_util.stringList default ame_util.emptyStringList,
1781: itemIdsIn in ame_util.stringList default ame_util.emptyStringList,
1782: forwardeesIn in ame_util.approversTable2 default ame_util.emptyApproversTable2);
1783: end ame_api2;
1778: occurrenceIn in number default null,
1779: approvalStatusesIn in ame_util.stringList default ame_util.emptyStringList,
1780: itemClassesIn in ame_util.stringList default ame_util.emptyStringList,
1781: itemIdsIn in ame_util.stringList default ame_util.emptyStringList,
1782: forwardeesIn in ame_util.approversTable2 default ame_util.emptyApproversTable2);
1783: end ame_api2;