eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_ENGINE dependencies on AME_UTIL

Line 7: function approversMatch(approverRecord1In in ame_util.approverRecord2,

3: /*************************************************************************************
4: functions
5: *************************************************************************************/
6: /******************************** boolean functions *********************************/
7: function approversMatch(approverRecord1In in ame_util.approverRecord2,
8: approverRecord2In in ame_util.approverRecord2) return boolean;
9: function checkAttributeVariant(attributeIdIn in integer) return varchar2;
10: function evalPrioritiesPerItem return boolean;
11: function insertionExists(orderTypeIn in varchar2,

Line 8: approverRecord2In in ame_util.approverRecord2) return boolean;

4: functions
5: *************************************************************************************/
6: /******************************** boolean functions *********************************/
7: function approversMatch(approverRecord1In in ame_util.approverRecord2,
8: approverRecord2In in ame_util.approverRecord2) return boolean;
9: function checkAttributeVariant(attributeIdIn in integer) return varchar2;
10: function evalPrioritiesPerItem return boolean;
11: function insertionExists(orderTypeIn in varchar2,
12: parameterIn in varchar2) return boolean;

Line 42: ame_util.chainOfAuthorityForwarder

38: function getFndApplicationId return integer;
39: /*
40: getForwardingBehavior only works in a PL/SQL session that has been initialized by a
41: call to updateTransactionState. The allowed values for forwarderTypeIn are
42: ame_util.chainOfAuthorityForwarder
43: ame_util.adHocForwarder
44: The allowed values for forwardeeTypeIn are
45: ame_util.previousSameChainForwardee
46: ame_util.subordSameHierarchyForwardee

Line 43: ame_util.adHocForwarder

39: /*
40: getForwardingBehavior only works in a PL/SQL session that has been initialized by a
41: call to updateTransactionState. The allowed values for forwarderTypeIn are
42: ame_util.chainOfAuthorityForwarder
43: ame_util.adHocForwarder
44: The allowed values for forwardeeTypeIn are
45: ame_util.previousSameChainForwardee
46: ame_util.subordSameHierarchyForwardee
47: ame_util.alreadyInListForwardee

Line 45: ame_util.previousSameChainForwardee

41: call to updateTransactionState. The allowed values for forwarderTypeIn are
42: ame_util.chainOfAuthorityForwarder
43: ame_util.adHocForwarder
44: The allowed values for forwardeeTypeIn are
45: ame_util.previousSameChainForwardee
46: ame_util.subordSameHierarchyForwardee
47: ame_util.alreadyInListForwardee
48: The allowed values for approvalStatus in are
49: ame_util.approveAndForwardStatus

Line 46: ame_util.subordSameHierarchyForwardee

42: ame_util.chainOfAuthorityForwarder
43: ame_util.adHocForwarder
44: The allowed values for forwardeeTypeIn are
45: ame_util.previousSameChainForwardee
46: ame_util.subordSameHierarchyForwardee
47: ame_util.alreadyInListForwardee
48: The allowed values for approvalStatus in are
49: ame_util.approveAndForwardStatus
50: ame_util.forwardStatus

Line 47: ame_util.alreadyInListForwardee

43: ame_util.adHocForwarder
44: The allowed values for forwardeeTypeIn are
45: ame_util.previousSameChainForwardee
46: ame_util.subordSameHierarchyForwardee
47: ame_util.alreadyInListForwardee
48: The allowed values for approvalStatus in are
49: ame_util.approveAndForwardStatus
50: ame_util.forwardStatus
51: */

Line 49: ame_util.approveAndForwardStatus

45: ame_util.previousSameChainForwardee
46: ame_util.subordSameHierarchyForwardee
47: ame_util.alreadyInListForwardee
48: The allowed values for approvalStatus in are
49: ame_util.approveAndForwardStatus
50: ame_util.forwardStatus
51: */
52: function getForwardingBehavior(forwarderTypeIn in varchar2,
53: forwardeeTypeIn in varchar2,

Line 50: ame_util.forwardStatus

46: ame_util.subordSameHierarchyForwardee
47: ame_util.alreadyInListForwardee
48: The allowed values for approvalStatus in are
49: ame_util.approveAndForwardStatus
50: ame_util.forwardStatus
51: */
52: function getForwardingBehavior(forwarderTypeIn in varchar2,
53: forwardeeTypeIn in varchar2,
54: approvalStatusIn in varchar2) return varchar2;

Line 58: function getHandlerApprovalStatus(approverIn in ame_util.approverRecord2

54: approvalStatusIn in varchar2) return varchar2;
55: /* Only action-type handlers should call the getHandler functions. See also the getHandler procedures. */
56: function getHandlerActionTypeId return integer;
57: function getHandlerActionTypeOrderNum return integer;
58: function getHandlerApprovalStatus(approverIn in ame_util.approverRecord2
59: ,votingRegimeIn in varchar2 default null
60: ,isInsertionapprover in boolean default false) return varchar2;
61: /* Only call getHandlerAuthority for action types that always generate approvers within a fixed sublist. */
62: function getHandlerAuthority return varchar2;

Line 131: procedure checkApprover(approverIn in ame_util.approverRecord2);

127: itemIdIn in varchar2) return number;
128: /*************************************************************************************
129: procedures
130: *************************************************************************************/
131: procedure checkApprover(approverIn in ame_util.approverRecord2);
132: /*
133: The following procedures are for API use only. Their output arguments correspond to API
134: output arguments. The API calls updateApprovalProcessState and then calls one or more
135: of these procedures to populate API output arguments as required. See also the function

Line 138: procedure getApprovers(approversOut out nocopy ame_util.approversTable2);

134: output arguments. The API calls updateApprovalProcessState and then calls one or more
135: of these procedures to populate API output arguments as required. See also the function
136: getApprovalProcessCompleteYN.
137: */
138: procedure getApprovers(approversOut out nocopy ame_util.approversTable2);
139: /* This procedure will be called by the API's to fetch the approver tree from the engine */
140: procedure getApprovers2(approversOut out nocopy ame_util.approversTable2
141: ,approversTreeOut out nocopy ame_util.approversTreeTable);
142: /* Procedure to return applicable rules and their descriptions */

Line 140: procedure getApprovers2(approversOut out nocopy ame_util.approversTable2

136: getApprovalProcessCompleteYN.
137: */
138: procedure getApprovers(approversOut out nocopy ame_util.approversTable2);
139: /* This procedure will be called by the API's to fetch the approver tree from the engine */
140: procedure getApprovers2(approversOut out nocopy ame_util.approversTable2
141: ,approversTreeOut out nocopy ame_util.approversTreeTable);
142: /* Procedure to return applicable rules and their descriptions */
143: procedure getApplicableRules
144: (ruleIdsOut out nocopy ame_util.idList

Line 141: ,approversTreeOut out nocopy ame_util.approversTreeTable);

137: */
138: procedure getApprovers(approversOut out nocopy ame_util.approversTable2);
139: /* This procedure will be called by the API's to fetch the approver tree from the engine */
140: procedure getApprovers2(approversOut out nocopy ame_util.approversTable2
141: ,approversTreeOut out nocopy ame_util.approversTreeTable);
142: /* Procedure to return applicable rules and their descriptions */
143: procedure getApplicableRules
144: (ruleIdsOut out nocopy ame_util.idList
145: ,ruleDescriptionsOut out nocopy ame_util.stringList);

Line 144: (ruleIdsOut out nocopy ame_util.idList

140: procedure getApprovers2(approversOut out nocopy ame_util.approversTable2
141: ,approversTreeOut out nocopy ame_util.approversTreeTable);
142: /* Procedure to return applicable rules and their descriptions */
143: procedure getApplicableRules
144: (ruleIdsOut out nocopy ame_util.idList
145: ,ruleDescriptionsOut out nocopy ame_util.stringList);
146: procedure getInsertions
147: (positionIn in number
148: ,orderTypeIn in varchar2 default null

Line 145: ,ruleDescriptionsOut out nocopy ame_util.stringList);

141: ,approversTreeOut out nocopy ame_util.approversTreeTable);
142: /* Procedure to return applicable rules and their descriptions */
143: procedure getApplicableRules
144: (ruleIdsOut out nocopy ame_util.idList
145: ,ruleDescriptionsOut out nocopy ame_util.stringList);
146: procedure getInsertions
147: (positionIn in number
148: ,orderTypeIn in varchar2 default null
149: ,coaInsertionsYNIn in varchar2 default ame_util.booleanTrue

Line 149: ,coaInsertionsYNIn in varchar2 default ame_util.booleanTrue

145: ,ruleDescriptionsOut out nocopy ame_util.stringList);
146: procedure getInsertions
147: (positionIn in number
148: ,orderTypeIn in varchar2 default null
149: ,coaInsertionsYNIn in varchar2 default ame_util.booleanTrue
150: ,availableInsertionsOut out nocopy ame_util.insertionsTable2
151: );
152: procedure getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut out nocopy ame_util.charList);
153: procedure getItemClasses(itemClassesOut out nocopy ame_util.stringList);

Line 150: ,availableInsertionsOut out nocopy ame_util.insertionsTable2

146: procedure getInsertions
147: (positionIn in number
148: ,orderTypeIn in varchar2 default null
149: ,coaInsertionsYNIn in varchar2 default ame_util.booleanTrue
150: ,availableInsertionsOut out nocopy ame_util.insertionsTable2
151: );
152: procedure getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut out nocopy ame_util.charList);
153: procedure getItemClasses(itemClassesOut out nocopy ame_util.stringList);
154: procedure getItemIds(itemIdsOut out nocopy ame_util.stringList);

Line 152: procedure getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut out nocopy ame_util.charList);

148: ,orderTypeIn in varchar2 default null
149: ,coaInsertionsYNIn in varchar2 default ame_util.booleanTrue
150: ,availableInsertionsOut out nocopy ame_util.insertionsTable2
151: );
152: procedure getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut out nocopy ame_util.charList);
153: procedure getItemClasses(itemClassesOut out nocopy ame_util.stringList);
154: procedure getItemIds(itemIdsOut out nocopy ame_util.stringList);
155: procedure getItemIndexes(itemIndexesOut out nocopy ame_util.idList);
156: /* Procedure's to return all itemids and itemclasses or the current transaction */

Line 153: procedure getItemClasses(itemClassesOut out nocopy ame_util.stringList);

149: ,coaInsertionsYNIn in varchar2 default ame_util.booleanTrue
150: ,availableInsertionsOut out nocopy ame_util.insertionsTable2
151: );
152: procedure getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut out nocopy ame_util.charList);
153: procedure getItemClasses(itemClassesOut out nocopy ame_util.stringList);
154: procedure getItemIds(itemIdsOut out nocopy ame_util.stringList);
155: procedure getItemIndexes(itemIndexesOut out nocopy ame_util.idList);
156: /* Procedure's to return all itemids and itemclasses or the current transaction */
157: procedure getAllItemClasses(itemClassNamesOut out nocopy ame_util.stringList);

Line 154: procedure getItemIds(itemIdsOut out nocopy ame_util.stringList);

150: ,availableInsertionsOut out nocopy ame_util.insertionsTable2
151: );
152: procedure getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut out nocopy ame_util.charList);
153: procedure getItemClasses(itemClassesOut out nocopy ame_util.stringList);
154: procedure getItemIds(itemIdsOut out nocopy ame_util.stringList);
155: procedure getItemIndexes(itemIndexesOut out nocopy ame_util.idList);
156: /* Procedure's to return all itemids and itemclasses or the current transaction */
157: procedure getAllItemClasses(itemClassNamesOut out nocopy ame_util.stringList);
158: procedure getAllItemIds(itemIdsOut out nocopy ame_util.stringList);

Line 155: procedure getItemIndexes(itemIndexesOut out nocopy ame_util.idList);

151: );
152: procedure getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut out nocopy ame_util.charList);
153: procedure getItemClasses(itemClassesOut out nocopy ame_util.stringList);
154: procedure getItemIds(itemIdsOut out nocopy ame_util.stringList);
155: procedure getItemIndexes(itemIndexesOut out nocopy ame_util.idList);
156: /* Procedure's to return all itemids and itemclasses or the current transaction */
157: procedure getAllItemClasses(itemClassNamesOut out nocopy ame_util.stringList);
158: procedure getAllItemIds(itemIdsOut out nocopy ame_util.stringList);
159: procedure getItemSources(itemSourcesOut out nocopy ame_util.longStringList);

Line 157: procedure getAllItemClasses(itemClassNamesOut out nocopy ame_util.stringList);

153: procedure getItemClasses(itemClassesOut out nocopy ame_util.stringList);
154: procedure getItemIds(itemIdsOut out nocopy ame_util.stringList);
155: procedure getItemIndexes(itemIndexesOut out nocopy ame_util.idList);
156: /* Procedure's to return all itemids and itemclasses or the current transaction */
157: procedure getAllItemClasses(itemClassNamesOut out nocopy ame_util.stringList);
158: procedure getAllItemIds(itemIdsOut out nocopy ame_util.stringList);
159: procedure getItemSources(itemSourcesOut out nocopy ame_util.longStringList);
160: procedure getProductionIndexes(productionIndexesOut out nocopy ame_util.idList);
161: /* getRepeatedIndexes is Added for asynch */

Line 158: procedure getAllItemIds(itemIdsOut out nocopy ame_util.stringList);

154: procedure getItemIds(itemIdsOut out nocopy ame_util.stringList);
155: procedure getItemIndexes(itemIndexesOut out nocopy ame_util.idList);
156: /* Procedure's to return all itemids and itemclasses or the current transaction */
157: procedure getAllItemClasses(itemClassNamesOut out nocopy ame_util.stringList);
158: procedure getAllItemIds(itemIdsOut out nocopy ame_util.stringList);
159: procedure getItemSources(itemSourcesOut out nocopy ame_util.longStringList);
160: procedure getProductionIndexes(productionIndexesOut out nocopy ame_util.idList);
161: /* getRepeatedIndexes is Added for asynch */
162: procedure getRepeatedIndexes(repeatedIndexesOut out nocopy ame_util.idList

Line 159: procedure getItemSources(itemSourcesOut out nocopy ame_util.longStringList);

155: procedure getItemIndexes(itemIndexesOut out nocopy ame_util.idList);
156: /* Procedure's to return all itemids and itemclasses or the current transaction */
157: procedure getAllItemClasses(itemClassNamesOut out nocopy ame_util.stringList);
158: procedure getAllItemIds(itemIdsOut out nocopy ame_util.stringList);
159: procedure getItemSources(itemSourcesOut out nocopy ame_util.longStringList);
160: procedure getProductionIndexes(productionIndexesOut out nocopy ame_util.idList);
161: /* getRepeatedIndexes is Added for asynch */
162: procedure getRepeatedIndexes(repeatedIndexesOut out nocopy ame_util.idList
163: ,repeatedAppIndexesOut out nocopy ame_util.idList);

Line 160: procedure getProductionIndexes(productionIndexesOut out nocopy ame_util.idList);

156: /* Procedure's to return all itemids and itemclasses or the current transaction */
157: procedure getAllItemClasses(itemClassNamesOut out nocopy ame_util.stringList);
158: procedure getAllItemIds(itemIdsOut out nocopy ame_util.stringList);
159: procedure getItemSources(itemSourcesOut out nocopy ame_util.longStringList);
160: procedure getProductionIndexes(productionIndexesOut out nocopy ame_util.idList);
161: /* getRepeatedIndexes is Added for asynch */
162: procedure getRepeatedIndexes(repeatedIndexesOut out nocopy ame_util.idList
163: ,repeatedAppIndexesOut out nocopy ame_util.idList);
164: procedure getRuleDescriptions(ruleDescriptionsOut out nocopy ame_util.stringList);

Line 162: procedure getRepeatedIndexes(repeatedIndexesOut out nocopy ame_util.idList

158: procedure getAllItemIds(itemIdsOut out nocopy ame_util.stringList);
159: procedure getItemSources(itemSourcesOut out nocopy ame_util.longStringList);
160: procedure getProductionIndexes(productionIndexesOut out nocopy ame_util.idList);
161: /* getRepeatedIndexes is Added for asynch */
162: procedure getRepeatedIndexes(repeatedIndexesOut out nocopy ame_util.idList
163: ,repeatedAppIndexesOut out nocopy ame_util.idList);
164: procedure getRuleDescriptions(ruleDescriptionsOut out nocopy ame_util.stringList);
165: procedure getRuleIds(ruleIdsOut out nocopy ame_util.idList);
166: procedure getRuleIndexes(ruleIndexesOut out nocopy ame_util.idList);

Line 163: ,repeatedAppIndexesOut out nocopy ame_util.idList);

159: procedure getItemSources(itemSourcesOut out nocopy ame_util.longStringList);
160: procedure getProductionIndexes(productionIndexesOut out nocopy ame_util.idList);
161: /* getRepeatedIndexes is Added for asynch */
162: procedure getRepeatedIndexes(repeatedIndexesOut out nocopy ame_util.idList
163: ,repeatedAppIndexesOut out nocopy ame_util.idList);
164: procedure getRuleDescriptions(ruleDescriptionsOut out nocopy ame_util.stringList);
165: procedure getRuleIds(ruleIdsOut out nocopy ame_util.idList);
166: procedure getRuleIndexes(ruleIndexesOut out nocopy ame_util.idList);
167: procedure getSourceTypes(sourceTypesOut out nocopy ame_util.stringList);

Line 164: procedure getRuleDescriptions(ruleDescriptionsOut out nocopy ame_util.stringList);

160: procedure getProductionIndexes(productionIndexesOut out nocopy ame_util.idList);
161: /* getRepeatedIndexes is Added for asynch */
162: procedure getRepeatedIndexes(repeatedIndexesOut out nocopy ame_util.idList
163: ,repeatedAppIndexesOut out nocopy ame_util.idList);
164: procedure getRuleDescriptions(ruleDescriptionsOut out nocopy ame_util.stringList);
165: procedure getRuleIds(ruleIdsOut out nocopy ame_util.idList);
166: procedure getRuleIndexes(ruleIndexesOut out nocopy ame_util.idList);
167: procedure getSourceTypes(sourceTypesOut out nocopy ame_util.stringList);
168: procedure getTransVariableNames(transVariableNamesOut out nocopy ame_util.stringList);

Line 165: procedure getRuleIds(ruleIdsOut out nocopy ame_util.idList);

161: /* getRepeatedIndexes is Added for asynch */
162: procedure getRepeatedIndexes(repeatedIndexesOut out nocopy ame_util.idList
163: ,repeatedAppIndexesOut out nocopy ame_util.idList);
164: procedure getRuleDescriptions(ruleDescriptionsOut out nocopy ame_util.stringList);
165: procedure getRuleIds(ruleIdsOut out nocopy ame_util.idList);
166: procedure getRuleIndexes(ruleIndexesOut out nocopy ame_util.idList);
167: procedure getSourceTypes(sourceTypesOut out nocopy ame_util.stringList);
168: procedure getTransVariableNames(transVariableNamesOut out nocopy ame_util.stringList);
169: procedure getTransVariableValues(transVariableValuesOut out nocopy ame_util.stringList);

Line 166: procedure getRuleIndexes(ruleIndexesOut out nocopy ame_util.idList);

162: procedure getRepeatedIndexes(repeatedIndexesOut out nocopy ame_util.idList
163: ,repeatedAppIndexesOut out nocopy ame_util.idList);
164: procedure getRuleDescriptions(ruleDescriptionsOut out nocopy ame_util.stringList);
165: procedure getRuleIds(ruleIdsOut out nocopy ame_util.idList);
166: procedure getRuleIndexes(ruleIndexesOut out nocopy ame_util.idList);
167: procedure getSourceTypes(sourceTypesOut out nocopy ame_util.stringList);
168: procedure getTransVariableNames(transVariableNamesOut out nocopy ame_util.stringList);
169: procedure getTransVariableValues(transVariableValuesOut out nocopy ame_util.stringList);
170: procedure getVariableNames(variableNamesOut out nocopy ame_util.stringList);

Line 167: procedure getSourceTypes(sourceTypesOut out nocopy ame_util.stringList);

163: ,repeatedAppIndexesOut out nocopy ame_util.idList);
164: procedure getRuleDescriptions(ruleDescriptionsOut out nocopy ame_util.stringList);
165: procedure getRuleIds(ruleIdsOut out nocopy ame_util.idList);
166: procedure getRuleIndexes(ruleIndexesOut out nocopy ame_util.idList);
167: procedure getSourceTypes(sourceTypesOut out nocopy ame_util.stringList);
168: procedure getTransVariableNames(transVariableNamesOut out nocopy ame_util.stringList);
169: procedure getTransVariableValues(transVariableValuesOut out nocopy ame_util.stringList);
170: procedure getVariableNames(variableNamesOut out nocopy ame_util.stringList);
171: procedure getVariableValues(variableValuesOut out nocopy ame_util.stringList);

Line 168: procedure getTransVariableNames(transVariableNamesOut out nocopy ame_util.stringList);

164: procedure getRuleDescriptions(ruleDescriptionsOut out nocopy ame_util.stringList);
165: procedure getRuleIds(ruleIdsOut out nocopy ame_util.idList);
166: procedure getRuleIndexes(ruleIndexesOut out nocopy ame_util.idList);
167: procedure getSourceTypes(sourceTypesOut out nocopy ame_util.stringList);
168: procedure getTransVariableNames(transVariableNamesOut out nocopy ame_util.stringList);
169: procedure getTransVariableValues(transVariableValuesOut out nocopy ame_util.stringList);
170: procedure getVariableNames(variableNamesOut out nocopy ame_util.stringList);
171: procedure getVariableValues(variableValuesOut out nocopy ame_util.stringList);
172: /*

Line 169: procedure getTransVariableValues(transVariableValuesOut out nocopy ame_util.stringList);

165: procedure getRuleIds(ruleIdsOut out nocopy ame_util.idList);
166: procedure getRuleIndexes(ruleIndexesOut out nocopy ame_util.idList);
167: procedure getSourceTypes(sourceTypesOut out nocopy ame_util.stringList);
168: procedure getTransVariableNames(transVariableNamesOut out nocopy ame_util.stringList);
169: procedure getTransVariableValues(transVariableValuesOut out nocopy ame_util.stringList);
170: procedure getVariableNames(variableNamesOut out nocopy ame_util.stringList);
171: procedure getVariableValues(variableValuesOut out nocopy ame_util.stringList);
172: /*
173: The following procedures are for the test tab's use and the action-type handlers' use.

Line 170: procedure getVariableNames(variableNamesOut out nocopy ame_util.stringList);

166: procedure getRuleIndexes(ruleIndexesOut out nocopy ame_util.idList);
167: procedure getSourceTypes(sourceTypesOut out nocopy ame_util.stringList);
168: procedure getTransVariableNames(transVariableNamesOut out nocopy ame_util.stringList);
169: procedure getTransVariableValues(transVariableValuesOut out nocopy ame_util.stringList);
170: procedure getVariableNames(variableNamesOut out nocopy ame_util.stringList);
171: procedure getVariableValues(variableValuesOut out nocopy ame_util.stringList);
172: /*
173: The following procedures are for the test tab's use and the action-type handlers' use.
174: They let the handlers manipulate the approver list, query for approver insertions and

Line 171: procedure getVariableValues(variableValuesOut out nocopy ame_util.stringList);

167: procedure getSourceTypes(sourceTypesOut out nocopy ame_util.stringList);
168: procedure getTransVariableNames(transVariableNamesOut out nocopy ame_util.stringList);
169: procedure getTransVariableValues(transVariableValuesOut out nocopy ame_util.stringList);
170: procedure getVariableNames(variableNamesOut out nocopy ame_util.stringList);
171: procedure getVariableValues(variableValuesOut out nocopy ame_util.stringList);
172: /*
173: The following procedures are for the test tab's use and the action-type handlers' use.
174: They let the handlers manipulate the approver list, query for approver insertions and
175: deletions, etc.

Line 178: procedure addApprover(approverIn in ame_util.approverRecord2);

174: They let the handlers manipulate the approver list, query for approver insertions and
175: deletions, etc.
176: */
177: /* addApprover adds an approver to the end of the list. */
178: procedure addApprover(approverIn in ame_util.approverRecord2);
179: /*
180: clearHandlerState is included in this version of the engine for architectural backwards compatibility
181: for custom handlers only. The engine's handler-state functionality is deprecated. Please use
182: package variables to maintain handler state instead.

Line 187: procedure getAllApprovers(approversOut out nocopy ame_util.approversTable);

183: */
184: procedure clearHandlerState(handlerNameIn in varchar2,
185: parameterIn in varchar2 default null);
186: /* getAllApprovers is for amem0013.sql backwards compatibility only. Do not use it elsewhere. */
187: procedure getAllApprovers(approversOut out nocopy ame_util.approversTable);
188: /*
189: getApprovalGroupConfigs returns the input group IDs in groupIdsInOut, as well as the
190: output arguments, sorted first by group order number, second by group ID. So approval-group
191: handlers can process the groups in the order this procedure returns them.

Line 194: procedure getApprovalGroupConfigs(groupIdsInOut in out nocopy ame_util.idList,

190: output arguments, sorted first by group order number, second by group ID. So approval-group
191: handlers can process the groups in the order this procedure returns them.
192: BUG : 4491715 modified to sort sources and approver categories with the group ids
193: */
194: procedure getApprovalGroupConfigs(groupIdsInOut in out nocopy ame_util.idList,
195: sourcesInOut in out nocopy ame_util.longStringList,
196: approverCategoriesInOut in out nocopy ame_util.charList,
197: orderNumbersOut out nocopy ame_util.idList,
198: votingRegimesOut out nocopy ame_util.charList);

Line 195: sourcesInOut in out nocopy ame_util.longStringList,

191: handlers can process the groups in the order this procedure returns them.
192: BUG : 4491715 modified to sort sources and approver categories with the group ids
193: */
194: procedure getApprovalGroupConfigs(groupIdsInOut in out nocopy ame_util.idList,
195: sourcesInOut in out nocopy ame_util.longStringList,
196: approverCategoriesInOut in out nocopy ame_util.charList,
197: orderNumbersOut out nocopy ame_util.idList,
198: votingRegimesOut out nocopy ame_util.charList);
199: /* Only action-type handlers should call the getHandler procedures. See also the getHandler functions. */

Line 196: approverCategoriesInOut in out nocopy ame_util.charList,

192: BUG : 4491715 modified to sort sources and approver categories with the group ids
193: */
194: procedure getApprovalGroupConfigs(groupIdsInOut in out nocopy ame_util.idList,
195: sourcesInOut in out nocopy ame_util.longStringList,
196: approverCategoriesInOut in out nocopy ame_util.charList,
197: orderNumbersOut out nocopy ame_util.idList,
198: votingRegimesOut out nocopy ame_util.charList);
199: /* Only action-type handlers should call the getHandler procedures. See also the getHandler functions. */
200: /* getHandlerCOAFirstApprover only returns inserted approvers with the ame_util.firstAuthority order type. */

Line 197: orderNumbersOut out nocopy ame_util.idList,

193: */
194: procedure getApprovalGroupConfigs(groupIdsInOut in out nocopy ame_util.idList,
195: sourcesInOut in out nocopy ame_util.longStringList,
196: approverCategoriesInOut in out nocopy ame_util.charList,
197: orderNumbersOut out nocopy ame_util.idList,
198: votingRegimesOut out nocopy ame_util.charList);
199: /* Only action-type handlers should call the getHandler procedures. See also the getHandler functions. */
200: /* getHandlerCOAFirstApprover only returns inserted approvers with the ame_util.firstAuthority order type. */
201: procedure getHandlerCOAFirstApprover(itemClassIn in varchar2,

Line 198: votingRegimesOut out nocopy ame_util.charList);

194: procedure getApprovalGroupConfigs(groupIdsInOut in out nocopy ame_util.idList,
195: sourcesInOut in out nocopy ame_util.longStringList,
196: approverCategoriesInOut in out nocopy ame_util.charList,
197: orderNumbersOut out nocopy ame_util.idList,
198: votingRegimesOut out nocopy ame_util.charList);
199: /* Only action-type handlers should call the getHandler procedures. See also the getHandler functions. */
200: /* getHandlerCOAFirstApprover only returns inserted approvers with the ame_util.firstAuthority order type. */
201: procedure getHandlerCOAFirstApprover(itemClassIn in varchar2,
202: itemIdIn in varchar2,

Line 200: /* getHandlerCOAFirstApprover only returns inserted approvers with the ame_util.firstAuthority order type. */

196: approverCategoriesInOut in out nocopy ame_util.charList,
197: orderNumbersOut out nocopy ame_util.idList,
198: votingRegimesOut out nocopy ame_util.charList);
199: /* Only action-type handlers should call the getHandler procedures. See also the getHandler functions. */
200: /* getHandlerCOAFirstApprover only returns inserted approvers with the ame_util.firstAuthority order type. */
201: procedure getHandlerCOAFirstApprover(itemClassIn in varchar2,
202: itemIdIn in varchar2,
203: actionTypeIdIn in integer,
204: groupOrChainIdIn in integer,

Line 210: /* getHandlerCOAInsertion only returns inserted approvers with the ame_util.afterApprover order type. */

206: origSystemOut out nocopy varchar2,
207: origSystemIdOut out nocopy integer,
208: displayNameOut out nocopy varchar2,
209: sourceOut out nocopy varchar2);
210: /* getHandlerCOAInsertion only returns inserted approvers with the ame_util.afterApprover order type. */
211: procedure getHandlerCOAInsertion(nameIn in varchar2,
212: itemClassIn in varchar2,
213: itemIdIn in varchar2,
214: actionTypeIdIn in integer,

Line 223: procedure getHandlerRules(ruleIdsOut out nocopy ame_util.idList,

219: origSystemOut out nocopy varchar2,
220: origSystemIdOut out nocopy integer,
221: displayNameOut out nocopy varchar2,
222: sourceOut out nocopy varchar2);
223: procedure getHandlerRules(ruleIdsOut out nocopy ame_util.idList,
224: approverCategoriesOut out nocopy ame_util.charList,
225: parametersOut out nocopy ame_util.stringList,
226: parameterTwosOut out nocopy ame_util.stringList);
227: procedure getHandlerRules2(ruleIdsOut out nocopy ame_util.idList,

Line 224: approverCategoriesOut out nocopy ame_util.charList,

220: origSystemIdOut out nocopy integer,
221: displayNameOut out nocopy varchar2,
222: sourceOut out nocopy varchar2);
223: procedure getHandlerRules(ruleIdsOut out nocopy ame_util.idList,
224: approverCategoriesOut out nocopy ame_util.charList,
225: parametersOut out nocopy ame_util.stringList,
226: parameterTwosOut out nocopy ame_util.stringList);
227: procedure getHandlerRules2(ruleIdsOut out nocopy ame_util.idList,
228: approverCategoriesOut out nocopy ame_util.charList,

Line 225: parametersOut out nocopy ame_util.stringList,

221: displayNameOut out nocopy varchar2,
222: sourceOut out nocopy varchar2);
223: procedure getHandlerRules(ruleIdsOut out nocopy ame_util.idList,
224: approverCategoriesOut out nocopy ame_util.charList,
225: parametersOut out nocopy ame_util.stringList,
226: parameterTwosOut out nocopy ame_util.stringList);
227: procedure getHandlerRules2(ruleIdsOut out nocopy ame_util.idList,
228: approverCategoriesOut out nocopy ame_util.charList,
229: parametersOut out nocopy ame_util.stringList);

Line 226: parameterTwosOut out nocopy ame_util.stringList);

222: sourceOut out nocopy varchar2);
223: procedure getHandlerRules(ruleIdsOut out nocopy ame_util.idList,
224: approverCategoriesOut out nocopy ame_util.charList,
225: parametersOut out nocopy ame_util.stringList,
226: parameterTwosOut out nocopy ame_util.stringList);
227: procedure getHandlerRules2(ruleIdsOut out nocopy ame_util.idList,
228: approverCategoriesOut out nocopy ame_util.charList,
229: parametersOut out nocopy ame_util.stringList);
230: procedure getHandlerRules3(ruleIdsOut out nocopy ame_util.idList,

Line 227: procedure getHandlerRules2(ruleIdsOut out nocopy ame_util.idList,

223: procedure getHandlerRules(ruleIdsOut out nocopy ame_util.idList,
224: approverCategoriesOut out nocopy ame_util.charList,
225: parametersOut out nocopy ame_util.stringList,
226: parameterTwosOut out nocopy ame_util.stringList);
227: procedure getHandlerRules2(ruleIdsOut out nocopy ame_util.idList,
228: approverCategoriesOut out nocopy ame_util.charList,
229: parametersOut out nocopy ame_util.stringList);
230: procedure getHandlerRules3(ruleIdsOut out nocopy ame_util.idList,
231: ruleIndexesOut out nocopy ame_util.idList,

Line 228: approverCategoriesOut out nocopy ame_util.charList,

224: approverCategoriesOut out nocopy ame_util.charList,
225: parametersOut out nocopy ame_util.stringList,
226: parameterTwosOut out nocopy ame_util.stringList);
227: procedure getHandlerRules2(ruleIdsOut out nocopy ame_util.idList,
228: approverCategoriesOut out nocopy ame_util.charList,
229: parametersOut out nocopy ame_util.stringList);
230: procedure getHandlerRules3(ruleIdsOut out nocopy ame_util.idList,
231: ruleIndexesOut out nocopy ame_util.idList,
232: parametersOut out nocopy ame_util.stringList,

Line 229: parametersOut out nocopy ame_util.stringList);

225: parametersOut out nocopy ame_util.stringList,
226: parameterTwosOut out nocopy ame_util.stringList);
227: procedure getHandlerRules2(ruleIdsOut out nocopy ame_util.idList,
228: approverCategoriesOut out nocopy ame_util.charList,
229: parametersOut out nocopy ame_util.stringList);
230: procedure getHandlerRules3(ruleIdsOut out nocopy ame_util.idList,
231: ruleIndexesOut out nocopy ame_util.idList,
232: parametersOut out nocopy ame_util.stringList,
233: listModParameterOnesOut out nocopy ame_util.stringList,

Line 230: procedure getHandlerRules3(ruleIdsOut out nocopy ame_util.idList,

226: parameterTwosOut out nocopy ame_util.stringList);
227: procedure getHandlerRules2(ruleIdsOut out nocopy ame_util.idList,
228: approverCategoriesOut out nocopy ame_util.charList,
229: parametersOut out nocopy ame_util.stringList);
230: procedure getHandlerRules3(ruleIdsOut out nocopy ame_util.idList,
231: ruleIndexesOut out nocopy ame_util.idList,
232: parametersOut out nocopy ame_util.stringList,
233: listModParameterOnesOut out nocopy ame_util.stringList,
234: listModParameterTwosOut out nocopy ame_util.longStringList);

Line 231: ruleIndexesOut out nocopy ame_util.idList,

227: procedure getHandlerRules2(ruleIdsOut out nocopy ame_util.idList,
228: approverCategoriesOut out nocopy ame_util.charList,
229: parametersOut out nocopy ame_util.stringList);
230: procedure getHandlerRules3(ruleIdsOut out nocopy ame_util.idList,
231: ruleIndexesOut out nocopy ame_util.idList,
232: parametersOut out nocopy ame_util.stringList,
233: listModParameterOnesOut out nocopy ame_util.stringList,
234: listModParameterTwosOut out nocopy ame_util.longStringList);
235: /*

Line 232: parametersOut out nocopy ame_util.stringList,

228: approverCategoriesOut out nocopy ame_util.charList,
229: parametersOut out nocopy ame_util.stringList);
230: procedure getHandlerRules3(ruleIdsOut out nocopy ame_util.idList,
231: ruleIndexesOut out nocopy ame_util.idList,
232: parametersOut out nocopy ame_util.stringList,
233: listModParameterOnesOut out nocopy ame_util.stringList,
234: listModParameterTwosOut out nocopy ame_util.longStringList);
235: /*
236: getHandlerLMApprovers returns the indexes of the approvers in engStApprovers that

Line 233: listModParameterOnesOut out nocopy ame_util.stringList,

229: parametersOut out nocopy ame_util.stringList);
230: procedure getHandlerRules3(ruleIdsOut out nocopy ame_util.idList,
231: ruleIndexesOut out nocopy ame_util.idList,
232: parametersOut out nocopy ame_util.stringList,
233: listModParameterOnesOut out nocopy ame_util.stringList,
234: listModParameterTwosOut out nocopy ame_util.longStringList);
235: /*
236: getHandlerLMApprovers returns the indexes of the approvers in engStApprovers that
237: have the wf_roles.name value listModParameterTwoIn, at the positions within an approval

Line 234: listModParameterTwosOut out nocopy ame_util.longStringList);

230: procedure getHandlerRules3(ruleIdsOut out nocopy ame_util.idList,
231: ruleIndexesOut out nocopy ame_util.idList,
232: parametersOut out nocopy ame_util.stringList,
233: listModParameterOnesOut out nocopy ame_util.stringList,
234: listModParameterTwosOut out nocopy ame_util.longStringList);
235: /*
236: getHandlerLMApprovers returns the indexes of the approvers in engStApprovers that
237: have the wf_roles.name value listModParameterTwoIn, at the positions within an approval
238: group or chain of authority required by listModParameterOneIn, and satisfying the

Line 252: approverIndexesOut out nocopy ame_util.idList,

248: listModParameterTwoIn in varchar2,
249: includeFyiApproversIn in boolean,
250: includeApprovalGroupsIn in boolean,
251: returnForwardeesIn in boolean,
252: approverIndexesOut out nocopy ame_util.idList,
253: lastForwardeeIndexesOut out nocopy ame_util.idList);
254: /*
255: The following attribute-value-fetching procedures work for attributes of all
256: types (including currency types). If you know the attribute whose value you want

Line 253: lastForwardeeIndexesOut out nocopy ame_util.idList);

249: includeFyiApproversIn in boolean,
250: includeApprovalGroupsIn in boolean,
251: returnForwardeesIn in boolean,
252: approverIndexesOut out nocopy ame_util.idList,
253: lastForwardeeIndexesOut out nocopy ame_util.idList);
254: /*
255: The following attribute-value-fetching procedures work for attributes of all
256: types (including currency types). If you know the attribute whose value you want
257: to fetch is not of currency type, and either (1) the attribute is header level or

Line 291: attributeValuesOut out nocopy ame_util.attributeValueList);

287: not to be currency attributes, and one of the other two for attributes of
288: unknown type.
289: */
290: procedure getItemClassAttValues1(attributeIdIn in integer,
291: attributeValuesOut out nocopy ame_util.attributeValueList);
292: procedure getItemClassAttValues2(attributeNameIn in varchar2,
293: attributeValuesOut out nocopy ame_util.attributeValueList);
294: procedure getItemClassAttValues3(attributeIdIn in integer,
295: attributeValues1Out out nocopy ame_util.attributeValueList,

Line 293: attributeValuesOut out nocopy ame_util.attributeValueList);

289: */
290: procedure getItemClassAttValues1(attributeIdIn in integer,
291: attributeValuesOut out nocopy ame_util.attributeValueList);
292: procedure getItemClassAttValues2(attributeNameIn in varchar2,
293: attributeValuesOut out nocopy ame_util.attributeValueList);
294: procedure getItemClassAttValues3(attributeIdIn in integer,
295: attributeValues1Out out nocopy ame_util.attributeValueList,
296: attributeValues2Out out nocopy ame_util.attributeValueList,
297: attributeValues3Out out nocopy ame_util.attributeValueList);

Line 295: attributeValues1Out out nocopy ame_util.attributeValueList,

291: attributeValuesOut out nocopy ame_util.attributeValueList);
292: procedure getItemClassAttValues2(attributeNameIn in varchar2,
293: attributeValuesOut out nocopy ame_util.attributeValueList);
294: procedure getItemClassAttValues3(attributeIdIn in integer,
295: attributeValues1Out out nocopy ame_util.attributeValueList,
296: attributeValues2Out out nocopy ame_util.attributeValueList,
297: attributeValues3Out out nocopy ame_util.attributeValueList);
298: procedure getItemClassAttValues4(attributeNameIn in varchar2,
299: attributeValues1Out out nocopy ame_util.attributeValueList,

Line 296: attributeValues2Out out nocopy ame_util.attributeValueList,

292: procedure getItemClassAttValues2(attributeNameIn in varchar2,
293: attributeValuesOut out nocopy ame_util.attributeValueList);
294: procedure getItemClassAttValues3(attributeIdIn in integer,
295: attributeValues1Out out nocopy ame_util.attributeValueList,
296: attributeValues2Out out nocopy ame_util.attributeValueList,
297: attributeValues3Out out nocopy ame_util.attributeValueList);
298: procedure getItemClassAttValues4(attributeNameIn in varchar2,
299: attributeValues1Out out nocopy ame_util.attributeValueList,
300: attributeValues2Out out nocopy ame_util.attributeValueList,

Line 297: attributeValues3Out out nocopy ame_util.attributeValueList);

293: attributeValuesOut out nocopy ame_util.attributeValueList);
294: procedure getItemClassAttValues3(attributeIdIn in integer,
295: attributeValues1Out out nocopy ame_util.attributeValueList,
296: attributeValues2Out out nocopy ame_util.attributeValueList,
297: attributeValues3Out out nocopy ame_util.attributeValueList);
298: procedure getItemClassAttValues4(attributeNameIn in varchar2,
299: attributeValues1Out out nocopy ame_util.attributeValueList,
300: attributeValues2Out out nocopy ame_util.attributeValueList,
301: attributeValues3Out out nocopy ame_util.attributeValueList);

Line 299: attributeValues1Out out nocopy ame_util.attributeValueList,

295: attributeValues1Out out nocopy ame_util.attributeValueList,
296: attributeValues2Out out nocopy ame_util.attributeValueList,
297: attributeValues3Out out nocopy ame_util.attributeValueList);
298: procedure getItemClassAttValues4(attributeNameIn in varchar2,
299: attributeValues1Out out nocopy ame_util.attributeValueList,
300: attributeValues2Out out nocopy ame_util.attributeValueList,
301: attributeValues3Out out nocopy ame_util.attributeValueList);
302: procedure getItemClassItemIds(itemClassIdIn in integer,
303: itemIdsOut out nocopy ame_util.stringList);

Line 300: attributeValues2Out out nocopy ame_util.attributeValueList,

296: attributeValues2Out out nocopy ame_util.attributeValueList,
297: attributeValues3Out out nocopy ame_util.attributeValueList);
298: procedure getItemClassAttValues4(attributeNameIn in varchar2,
299: attributeValues1Out out nocopy ame_util.attributeValueList,
300: attributeValues2Out out nocopy ame_util.attributeValueList,
301: attributeValues3Out out nocopy ame_util.attributeValueList);
302: procedure getItemClassItemIds(itemClassIdIn in integer,
303: itemIdsOut out nocopy ame_util.stringList);
304: --+

Line 301: attributeValues3Out out nocopy ame_util.attributeValueList);

297: attributeValues3Out out nocopy ame_util.attributeValueList);
298: procedure getItemClassAttValues4(attributeNameIn in varchar2,
299: attributeValues1Out out nocopy ame_util.attributeValueList,
300: attributeValues2Out out nocopy ame_util.attributeValueList,
301: attributeValues3Out out nocopy ame_util.attributeValueList);
302: procedure getItemClassItemIds(itemClassIdIn in integer,
303: itemIdsOut out nocopy ame_util.stringList);
304: --+
305: procedure getAllProductions(productionsOut out nocopy ame_util2.productionsTable);

Line 303: itemIdsOut out nocopy ame_util.stringList);

299: attributeValues1Out out nocopy ame_util.attributeValueList,
300: attributeValues2Out out nocopy ame_util.attributeValueList,
301: attributeValues3Out out nocopy ame_util.attributeValueList);
302: procedure getItemClassItemIds(itemClassIdIn in integer,
303: itemIdsOut out nocopy ame_util.stringList);
304: --+
305: procedure getAllProductions(productionsOut out nocopy ame_util2.productionsTable);
306: procedure getProductions(itemClassIn in varchar2
307: ,itemIdIn in varchar2

Line 305: procedure getAllProductions(productionsOut out nocopy ame_util2.productionsTable);

301: attributeValues3Out out nocopy ame_util.attributeValueList);
302: procedure getItemClassItemIds(itemClassIdIn in integer,
303: itemIdsOut out nocopy ame_util.stringList);
304: --+
305: procedure getAllProductions(productionsOut out nocopy ame_util2.productionsTable);
306: procedure getProductions(itemClassIn in varchar2
307: ,itemIdIn in varchar2
308: ,productionsOut out nocopy ame_util2.productionsTable);
309: /*

Line 308: ,productionsOut out nocopy ame_util2.productionsTable);

304: --+
305: procedure getAllProductions(productionsOut out nocopy ame_util2.productionsTable);
306: procedure getProductions(itemClassIn in varchar2
307: ,itemIdIn in varchar2
308: ,productionsOut out nocopy ame_util2.productionsTable);
309: /*
310: Runtime code should call ame_engine.getRuntimeGroupMembers, <> ame_approval_group_pkg.getRuntimeGroupMembers,
311: to fetch an approval group's membership. (The engine version only performs the fetch the first time it is called,
312: in a given PL/SQL context. Thereafter it returns values cached in an engine package variable.)

Line 315: approverNamesOut out nocopy ame_util.longStringList,

311: to fetch an approval group's membership. (The engine version only performs the fetch the first time it is called,
312: in a given PL/SQL context. Thereafter it returns values cached in an engine package variable.)
313: */
314: procedure getRuntimeGroupMembers(groupIdIn in integer,
315: approverNamesOut out nocopy ame_util.longStringList,
316: approverOrderNumbersOut out nocopy ame_util.idList,
317: approverDisplayNamesOut out nocopy ame_util.longStringList,
318: origSystemIdsOut out nocopy ame_util.idList,
319: origSystemsOut out nocopy ame_util.stringList);

Line 316: approverOrderNumbersOut out nocopy ame_util.idList,

312: in a given PL/SQL context. Thereafter it returns values cached in an engine package variable.)
313: */
314: procedure getRuntimeGroupMembers(groupIdIn in integer,
315: approverNamesOut out nocopy ame_util.longStringList,
316: approverOrderNumbersOut out nocopy ame_util.idList,
317: approverDisplayNamesOut out nocopy ame_util.longStringList,
318: origSystemIdsOut out nocopy ame_util.idList,
319: origSystemsOut out nocopy ame_util.stringList);
320: /*

Line 317: approverDisplayNamesOut out nocopy ame_util.longStringList,

313: */
314: procedure getRuntimeGroupMembers(groupIdIn in integer,
315: approverNamesOut out nocopy ame_util.longStringList,
316: approverOrderNumbersOut out nocopy ame_util.idList,
317: approverDisplayNamesOut out nocopy ame_util.longStringList,
318: origSystemIdsOut out nocopy ame_util.idList,
319: origSystemsOut out nocopy ame_util.stringList);
320: /*
321: Only the test-tab object layer should call getTestTransApplicableRules. It should first call

Line 318: origSystemIdsOut out nocopy ame_util.idList,

314: procedure getRuntimeGroupMembers(groupIdIn in integer,
315: approverNamesOut out nocopy ame_util.longStringList,
316: approverOrderNumbersOut out nocopy ame_util.idList,
317: approverDisplayNamesOut out nocopy ame_util.longStringList,
318: origSystemIdsOut out nocopy ame_util.idList,
319: origSystemsOut out nocopy ame_util.stringList);
320: /*
321: Only the test-tab object layer should call getTestTransApplicableRules. It should first call
322: updateTransactionState. The itemClassIdsOut and itemIdsOut variables identify the items that

Line 319: origSystemsOut out nocopy ame_util.stringList);

315: approverNamesOut out nocopy ame_util.longStringList,
316: approverOrderNumbersOut out nocopy ame_util.idList,
317: approverDisplayNamesOut out nocopy ame_util.longStringList,
318: origSystemIdsOut out nocopy ame_util.idList,
319: origSystemsOut out nocopy ame_util.stringList);
320: /*
321: Only the test-tab object layer should call getTestTransApplicableRules. It should first call
322: updateTransactionState. The itemClassIdsOut and itemIdsOut variables identify the items that
323: satisfy the rules.

Line 325: procedure getTestTransApplicableRules(ruleItemClassIdsOut out nocopy ame_util.idList,

321: Only the test-tab object layer should call getTestTransApplicableRules. It should first call
322: updateTransactionState. The itemClassIdsOut and itemIdsOut variables identify the items that
323: satisfy the rules.
324: */
325: procedure getTestTransApplicableRules(ruleItemClassIdsOut out nocopy ame_util.idList,
326: itemClassIdsOut out nocopy ame_util.idList,
327: itemIdsOut out nocopy ame_util.stringList,
328: ruleIdsOut out nocopy ame_util.idList,
329: ruleTypesOut out nocopy ame_util.idList,

Line 326: itemClassIdsOut out nocopy ame_util.idList,

322: updateTransactionState. The itemClassIdsOut and itemIdsOut variables identify the items that
323: satisfy the rules.
324: */
325: procedure getTestTransApplicableRules(ruleItemClassIdsOut out nocopy ame_util.idList,
326: itemClassIdsOut out nocopy ame_util.idList,
327: itemIdsOut out nocopy ame_util.stringList,
328: ruleIdsOut out nocopy ame_util.idList,
329: ruleTypesOut out nocopy ame_util.idList,
330: ruleDescriptionsOut out nocopy ame_util.stringList);

Line 327: itemIdsOut out nocopy ame_util.stringList,

323: satisfy the rules.
324: */
325: procedure getTestTransApplicableRules(ruleItemClassIdsOut out nocopy ame_util.idList,
326: itemClassIdsOut out nocopy ame_util.idList,
327: itemIdsOut out nocopy ame_util.stringList,
328: ruleIdsOut out nocopy ame_util.idList,
329: ruleTypesOut out nocopy ame_util.idList,
330: ruleDescriptionsOut out nocopy ame_util.stringList);
331: /*

Line 328: ruleIdsOut out nocopy ame_util.idList,

324: */
325: procedure getTestTransApplicableRules(ruleItemClassIdsOut out nocopy ame_util.idList,
326: itemClassIdsOut out nocopy ame_util.idList,
327: itemIdsOut out nocopy ame_util.stringList,
328: ruleIdsOut out nocopy ame_util.idList,
329: ruleTypesOut out nocopy ame_util.idList,
330: ruleDescriptionsOut out nocopy ame_util.stringList);
331: /*
332: Only the test-tab object layer should call getTestTransApprovers. No call to updateTransactionState

Line 329: ruleTypesOut out nocopy ame_util.idList,

325: procedure getTestTransApplicableRules(ruleItemClassIdsOut out nocopy ame_util.idList,
326: itemClassIdsOut out nocopy ame_util.idList,
327: itemIdsOut out nocopy ame_util.stringList,
328: ruleIdsOut out nocopy ame_util.idList,
329: ruleTypesOut out nocopy ame_util.idList,
330: ruleDescriptionsOut out nocopy ame_util.stringList);
331: /*
332: Only the test-tab object layer should call getTestTransApprovers. No call to updateTransactionState
333: should precede it. The approverListStageIn argument should be an integer between one and five

Line 330: ruleDescriptionsOut out nocopy ame_util.stringList);

326: itemClassIdsOut out nocopy ame_util.idList,
327: itemIdsOut out nocopy ame_util.stringList,
328: ruleIdsOut out nocopy ame_util.idList,
329: ruleTypesOut out nocopy ame_util.idList,
330: ruleDescriptionsOut out nocopy ame_util.stringList);
331: /*
332: Only the test-tab object layer should call getTestTransApprovers. No call to updateTransactionState
333: should precede it. The approverListStageIn argument should be an integer between one and five
334: (inclusive), indicating which step in the approver-list algorithm the engine should complete before

Line 349: approversOut out nocopy ame_util.approversTable2,

345: procedure getTestTransApprovers(isTestTransactionIn in boolean,
346: transactionIdIn in varchar2,
347: ameApplicationIdIn in integer,
348: approverListStageIn in integer,
349: approversOut out nocopy ame_util.approversTable2,
350: productionIndexesOut out nocopy ame_util.idList,
351: variableNamesOut out nocopy ame_util.stringList,
352: variableValuesOut out nocopy ame_util.stringList);
353: /* initializePlsqlContext is for amem0013.sql backwards compatibility only. Do not use it elsewhere. */

Line 350: productionIndexesOut out nocopy ame_util.idList,

346: transactionIdIn in varchar2,
347: ameApplicationIdIn in integer,
348: approverListStageIn in integer,
349: approversOut out nocopy ame_util.approversTable2,
350: productionIndexesOut out nocopy ame_util.idList,
351: variableNamesOut out nocopy ame_util.stringList,
352: variableValuesOut out nocopy ame_util.stringList);
353: /* initializePlsqlContext is for amem0013.sql backwards compatibility only. Do not use it elsewhere. */
354: procedure initializePlsqlContext(ameApplicationIdIn in integer default null,

Line 351: variableNamesOut out nocopy ame_util.stringList,

347: ameApplicationIdIn in integer,
348: approverListStageIn in integer,
349: approversOut out nocopy ame_util.approversTable2,
350: productionIndexesOut out nocopy ame_util.idList,
351: variableNamesOut out nocopy ame_util.stringList,
352: variableValuesOut out nocopy ame_util.stringList);
353: /* initializePlsqlContext is for amem0013.sql backwards compatibility only. Do not use it elsewhere. */
354: procedure initializePlsqlContext(ameApplicationIdIn in integer default null,
355: fndApplicationIdIn in integer default null,

Line 352: variableValuesOut out nocopy ame_util.stringList);

348: approverListStageIn in integer,
349: approversOut out nocopy ame_util.approversTable2,
350: productionIndexesOut out nocopy ame_util.idList,
351: variableNamesOut out nocopy ame_util.stringList,
352: variableValuesOut out nocopy ame_util.stringList);
353: /* initializePlsqlContext is for amem0013.sql backwards compatibility only. Do not use it elsewhere. */
354: procedure initializePlsqlContext(ameApplicationIdIn in integer default null,
355: fndApplicationIdIn in integer default null,
356: transactionIdIn in varchar2 default null,

Line 387: approverIn in ame_util.approverRecord2,

383: in the same chain, so they follow engStApprovers(indexIn). (Basically, preserve
384: serial group-or-chain ordering if it exists.)
385: */
386: procedure insertApprover(indexIn in integer,
387: approverIn in ame_util.approverRecord2,
388: adjustMemberOrderNumbersIn in boolean default false,
389: approverLocationIn in boolean default ame_util.lastAmongEquals,
390: inserteeIndexIn in number default null,
391: currentInsIndex in integer default null);

Line 389: approverLocationIn in boolean default ame_util.lastAmongEquals,

385: */
386: procedure insertApprover(indexIn in integer,
387: approverIn in ame_util.approverRecord2,
388: adjustMemberOrderNumbersIn in boolean default false,
389: approverLocationIn in boolean default ame_util.lastAmongEquals,
390: inserteeIndexIn in number default null,
391: currentInsIndex in integer default null);
392: /*
393: insertApprovers inserts a list of approvers at an arbitrary location in the current

Line 398: approversIn in ame_util.approversTable2);

394: approver list. approversIn(1) will have the index firstIndexIn in engStApprovers.
395: Insertion may occur after the last approver.
396: */
397: procedure insertApprovers(firstIndexIn in integer,
398: approversIn in ame_util.approversTable2);
399: /*
400: Any API routine that could change transactional data in any of the ame_temp tables
401: must call lockTransaction right after the routine's begin statement, and must call
402: unlockTransaction right before returning (in both cases even if the routine calls another

Line 410: /* parseFields parses stringIn into strings separated by ame_util.fieldDelimiter. */

406: procedure lockTransaction(fndApplicationIdIn in integer,
407: transactionIdIn in varchar2,
408: transactionTypeIdIn in varchar2 default null);
409: procedure logTransaction;
410: /* parseFields parses stringIn into strings separated by ame_util.fieldDelimiter. */
411: procedure parseFields(stringIn in varchar2,
412: fieldsOut out nocopy ame_util.longStringList);
413: procedure updateInsertions(indexIn in integer);
414: procedure processExceptions;

Line 412: fieldsOut out nocopy ame_util.longStringList);

408: transactionTypeIdIn in varchar2 default null);
409: procedure logTransaction;
410: /* parseFields parses stringIn into strings separated by ame_util.fieldDelimiter. */
411: procedure parseFields(stringIn in varchar2,
412: fieldsOut out nocopy ame_util.longStringList);
413: procedure updateInsertions(indexIn in integer);
414: procedure processExceptions;
415: /*
416: setHandlerState is included in this version of the engine for architectural backwards compatibility

Line 433: set to ame_util.yes, truncation means changing to ame_util.fyiApproverCategory

429: /*
430: truncateChain truncates the chain of authority in engStApprovers including
431: the approver at approverIndexIn, starting with the first approver after that
432: approver (if any). If the allowFyiNotifications configuration variable is
433: set to ame_util.yes, truncation means changing to ame_util.fyiApproverCategory
434: the approver_category of the rest of the chain. Otherwise it means deleting
435: the rest of the chain. Note that if a routine calls truncateChain repeatedly,
436: it will need to account for the fact that truncation changes the indexes of
437: approvers occurring after the point of truncation. This suggests sorting the

Line 480: ,flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue

476: applicationIdIn in number
477: ,transactionTypeIn in varchar2
478: ,transactionIdIn in varchar2
479: ,nextApproversType in number
480: ,flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue
481: ,approvalProcessCompleteYNOut out nocopy varchar2
482: ,nextApproversOut out nocopy ame_util.approversTable2
483: ,itemIndexesOut out nocopy ame_util.idList
484: ,itemClassesOut out nocopy ame_util.stringList

Line 482: ,nextApproversOut out nocopy ame_util.approversTable2

478: ,transactionIdIn in varchar2
479: ,nextApproversType in number
480: ,flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue
481: ,approvalProcessCompleteYNOut out nocopy varchar2
482: ,nextApproversOut out nocopy ame_util.approversTable2
483: ,itemIndexesOut out nocopy ame_util.idList
484: ,itemClassesOut out nocopy ame_util.stringList
485: ,itemIdsOut out nocopy ame_util.stringList
486: ,itemSourcesOut out nocopy ame_util.longStringList

Line 483: ,itemIndexesOut out nocopy ame_util.idList

479: ,nextApproversType in number
480: ,flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue
481: ,approvalProcessCompleteYNOut out nocopy varchar2
482: ,nextApproversOut out nocopy ame_util.approversTable2
483: ,itemIndexesOut out nocopy ame_util.idList
484: ,itemClassesOut out nocopy ame_util.stringList
485: ,itemIdsOut out nocopy ame_util.stringList
486: ,itemSourcesOut out nocopy ame_util.longStringList
487: ,productionIndexesOut out nocopy ame_util.idList

Line 484: ,itemClassesOut out nocopy ame_util.stringList

480: ,flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue
481: ,approvalProcessCompleteYNOut out nocopy varchar2
482: ,nextApproversOut out nocopy ame_util.approversTable2
483: ,itemIndexesOut out nocopy ame_util.idList
484: ,itemClassesOut out nocopy ame_util.stringList
485: ,itemIdsOut out nocopy ame_util.stringList
486: ,itemSourcesOut out nocopy ame_util.longStringList
487: ,productionIndexesOut out nocopy ame_util.idList
488: ,variableNamesOut out nocopy ame_util.stringList

Line 485: ,itemIdsOut out nocopy ame_util.stringList

481: ,approvalProcessCompleteYNOut out nocopy varchar2
482: ,nextApproversOut out nocopy ame_util.approversTable2
483: ,itemIndexesOut out nocopy ame_util.idList
484: ,itemClassesOut out nocopy ame_util.stringList
485: ,itemIdsOut out nocopy ame_util.stringList
486: ,itemSourcesOut out nocopy ame_util.longStringList
487: ,productionIndexesOut out nocopy ame_util.idList
488: ,variableNamesOut out nocopy ame_util.stringList
489: ,variableValuesOut out nocopy ame_util.stringList

Line 486: ,itemSourcesOut out nocopy ame_util.longStringList

482: ,nextApproversOut out nocopy ame_util.approversTable2
483: ,itemIndexesOut out nocopy ame_util.idList
484: ,itemClassesOut out nocopy ame_util.stringList
485: ,itemIdsOut out nocopy ame_util.stringList
486: ,itemSourcesOut out nocopy ame_util.longStringList
487: ,productionIndexesOut out nocopy ame_util.idList
488: ,variableNamesOut out nocopy ame_util.stringList
489: ,variableValuesOut out nocopy ame_util.stringList
490: ,transVariableNamesOut out nocopy ame_util.stringList

Line 487: ,productionIndexesOut out nocopy ame_util.idList

483: ,itemIndexesOut out nocopy ame_util.idList
484: ,itemClassesOut out nocopy ame_util.stringList
485: ,itemIdsOut out nocopy ame_util.stringList
486: ,itemSourcesOut out nocopy ame_util.longStringList
487: ,productionIndexesOut out nocopy ame_util.idList
488: ,variableNamesOut out nocopy ame_util.stringList
489: ,variableValuesOut out nocopy ame_util.stringList
490: ,transVariableNamesOut out nocopy ame_util.stringList
491: ,transVariableValuesOut out nocopy ame_util.stringList);

Line 488: ,variableNamesOut out nocopy ame_util.stringList

484: ,itemClassesOut out nocopy ame_util.stringList
485: ,itemIdsOut out nocopy ame_util.stringList
486: ,itemSourcesOut out nocopy ame_util.longStringList
487: ,productionIndexesOut out nocopy ame_util.idList
488: ,variableNamesOut out nocopy ame_util.stringList
489: ,variableValuesOut out nocopy ame_util.stringList
490: ,transVariableNamesOut out nocopy ame_util.stringList
491: ,transVariableValuesOut out nocopy ame_util.stringList);
492: /* updateApprovalStatus */

Line 489: ,variableValuesOut out nocopy ame_util.stringList

485: ,itemIdsOut out nocopy ame_util.stringList
486: ,itemSourcesOut out nocopy ame_util.longStringList
487: ,productionIndexesOut out nocopy ame_util.idList
488: ,variableNamesOut out nocopy ame_util.stringList
489: ,variableValuesOut out nocopy ame_util.stringList
490: ,transVariableNamesOut out nocopy ame_util.stringList
491: ,transVariableValuesOut out nocopy ame_util.stringList);
492: /* updateApprovalStatus */
493: procedure updateApprovalStatus(applicationIdIn in number,

Line 490: ,transVariableNamesOut out nocopy ame_util.stringList

486: ,itemSourcesOut out nocopy ame_util.longStringList
487: ,productionIndexesOut out nocopy ame_util.idList
488: ,variableNamesOut out nocopy ame_util.stringList
489: ,variableValuesOut out nocopy ame_util.stringList
490: ,transVariableNamesOut out nocopy ame_util.stringList
491: ,transVariableValuesOut out nocopy ame_util.stringList);
492: /* updateApprovalStatus */
493: procedure updateApprovalStatus(applicationIdIn in number,
494: transactionTypeIn in varchar2,

Line 491: ,transVariableValuesOut out nocopy ame_util.stringList);

487: ,productionIndexesOut out nocopy ame_util.idList
488: ,variableNamesOut out nocopy ame_util.stringList
489: ,variableValuesOut out nocopy ame_util.stringList
490: ,transVariableNamesOut out nocopy ame_util.stringList
491: ,transVariableValuesOut out nocopy ame_util.stringList);
492: /* updateApprovalStatus */
493: procedure updateApprovalStatus(applicationIdIn in number,
494: transactionTypeIn in varchar2,
495: transactionIdIn in varchar2,

Line 496: approverIn in ame_util.approverRecord2,

492: /* updateApprovalStatus */
493: procedure updateApprovalStatus(applicationIdIn in number,
494: transactionTypeIn in varchar2,
495: transactionIdIn in varchar2,
496: approverIn in ame_util.approverRecord2,
497: notificationIn in ame_util2.notificationRecord
498: default ame_util2.emptyNotificationRecord,
499: forwardeeIn in ame_util.approverRecord2 default
500: ame_util.emptyApproverRecord2,

Line 497: notificationIn in ame_util2.notificationRecord

493: procedure updateApprovalStatus(applicationIdIn in number,
494: transactionTypeIn in varchar2,
495: transactionIdIn in varchar2,
496: approverIn in ame_util.approverRecord2,
497: notificationIn in ame_util2.notificationRecord
498: default ame_util2.emptyNotificationRecord,
499: forwardeeIn in ame_util.approverRecord2 default
500: ame_util.emptyApproverRecord2,
501: updateItemIn in boolean default false) ;

Line 498: default ame_util2.emptyNotificationRecord,

494: transactionTypeIn in varchar2,
495: transactionIdIn in varchar2,
496: approverIn in ame_util.approverRecord2,
497: notificationIn in ame_util2.notificationRecord
498: default ame_util2.emptyNotificationRecord,
499: forwardeeIn in ame_util.approverRecord2 default
500: ame_util.emptyApproverRecord2,
501: updateItemIn in boolean default false) ;
502: procedure setDeviationReasonDate(reasonIn in varchar2,dateIn in date);

Line 499: forwardeeIn in ame_util.approverRecord2 default

495: transactionIdIn in varchar2,
496: approverIn in ame_util.approverRecord2,
497: notificationIn in ame_util2.notificationRecord
498: default ame_util2.emptyNotificationRecord,
499: forwardeeIn in ame_util.approverRecord2 default
500: ame_util.emptyApproverRecord2,
501: updateItemIn in boolean default false) ;
502: procedure setDeviationReasonDate(reasonIn in varchar2,dateIn in date);
503: end ame_engine;

Line 500: ame_util.emptyApproverRecord2,

496: approverIn in ame_util.approverRecord2,
497: notificationIn in ame_util2.notificationRecord
498: default ame_util2.emptyNotificationRecord,
499: forwardeeIn in ame_util.approverRecord2 default
500: ame_util.emptyApproverRecord2,
501: updateItemIn in boolean default false) ;
502: procedure setDeviationReasonDate(reasonIn in varchar2,dateIn in date);
503: end ame_engine;