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) return varchar2;

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) return varchar2;
59: /* Only call getHandlerAuthority for action types that always generate approvers within a fixed sublist. */
60: function getHandlerAuthority return varchar2;
61: /*
62: The getHandlerItem[Whatever] functions relate to the item to which a rule applies, <> to

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

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

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

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

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

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

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

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

Line 142: (ruleIdsOut out nocopy ame_util.idList

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

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

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

Line 147: ,coaInsertionsYNIn in varchar2 default ame_util.booleanTrue

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

Line 148: ,availableInsertionsOut out nocopy ame_util.insertionsTable2

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 193: sourcesInOut in out nocopy ame_util.longStringList,

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

Line 194: approverCategoriesInOut in out nocopy ame_util.charList,

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

Line 195: orderNumbersOut out nocopy ame_util.idList,

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

Line 196: votingRegimesOut out nocopy ame_util.charList);

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

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

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

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

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

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

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

Line 222: approverCategoriesOut out nocopy ame_util.charList,

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

Line 223: parametersOut out nocopy ame_util.stringList,

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

Line 224: parameterTwosOut out nocopy ame_util.stringList);

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

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

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

Line 226: approverCategoriesOut out nocopy ame_util.charList,

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

Line 227: parametersOut out nocopy ame_util.stringList);

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

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

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

Line 229: ruleIndexesOut out nocopy ame_util.idList,

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

Line 230: parametersOut out nocopy ame_util.stringList,

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

Line 231: listModParameterOnesOut out nocopy ame_util.stringList,

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

Line 232: listModParameterTwosOut out nocopy ame_util.longStringList);

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

Line 250: approverIndexesOut out nocopy ame_util.idList,

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

Line 251: lastForwardeeIndexesOut out nocopy ame_util.idList);

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

Line 289: attributeValuesOut out nocopy ame_util.attributeValueList);

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

Line 291: attributeValuesOut out nocopy ame_util.attributeValueList);

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

Line 293: attributeValues1Out out nocopy ame_util.attributeValueList,

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

Line 294: attributeValues2Out out nocopy ame_util.attributeValueList,

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

Line 295: attributeValues3Out out nocopy ame_util.attributeValueList);

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

Line 297: attributeValues1Out out nocopy ame_util.attributeValueList,

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

Line 298: attributeValues2Out out nocopy ame_util.attributeValueList,

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

Line 299: attributeValues3Out out nocopy ame_util.attributeValueList);

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

Line 301: itemIdsOut out nocopy ame_util.stringList);

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

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

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

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

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

Line 313: approverNamesOut out nocopy ame_util.longStringList,

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

Line 314: approverOrderNumbersOut out nocopy ame_util.idList,

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

Line 315: approverDisplayNamesOut out nocopy ame_util.longStringList,

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

Line 316: origSystemIdsOut out nocopy ame_util.idList,

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

Line 317: origSystemsOut out nocopy ame_util.stringList);

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

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

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

Line 324: itemClassIdsOut out nocopy ame_util.idList,

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

Line 325: itemIdsOut out nocopy ame_util.stringList,

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

Line 326: ruleIdsOut out nocopy ame_util.idList,

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

Line 327: ruleTypesOut out nocopy ame_util.idList,

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

Line 328: ruleDescriptionsOut out nocopy ame_util.stringList);

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

Line 347: approversOut out nocopy ame_util.approversTable2,

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

Line 348: productionIndexesOut out nocopy ame_util.idList,

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

Line 349: variableNamesOut out nocopy ame_util.stringList,

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

Line 350: variableValuesOut out nocopy ame_util.stringList);

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

Line 385: approverIn in ame_util.approverRecord2,

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

Line 387: approverLocationIn in boolean default ame_util.lastAmongEquals,

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

Line 396: approversIn in ame_util.approversTable2);

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

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

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

Line 410: fieldsOut out nocopy ame_util.longStringList);

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

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

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

Line 478: ,flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue

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

Line 480: ,nextApproversOut out nocopy ame_util.approversTable2

476: ,transactionIdIn in varchar2
477: ,nextApproversType in number
478: ,flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue
479: ,approvalProcessCompleteYNOut out nocopy varchar2
480: ,nextApproversOut 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

Line 481: ,itemIndexesOut out nocopy ame_util.idList

477: ,nextApproversType in number
478: ,flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue
479: ,approvalProcessCompleteYNOut out nocopy varchar2
480: ,nextApproversOut 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: ,productionIndexesOut out nocopy ame_util.idList

Line 482: ,itemClassesOut out nocopy ame_util.stringList

478: ,flagApproversAsNotifiedIn in varchar2 default ame_util.booleanTrue
479: ,approvalProcessCompleteYNOut out nocopy varchar2
480: ,nextApproversOut 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: ,productionIndexesOut out nocopy ame_util.idList
486: ,variableNamesOut out nocopy ame_util.stringList

Line 483: ,itemIdsOut out nocopy ame_util.stringList

479: ,approvalProcessCompleteYNOut out nocopy varchar2
480: ,nextApproversOut 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: ,productionIndexesOut out nocopy ame_util.idList
486: ,variableNamesOut out nocopy ame_util.stringList
487: ,variableValuesOut out nocopy ame_util.stringList

Line 484: ,itemSourcesOut out nocopy ame_util.longStringList

480: ,nextApproversOut 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: ,productionIndexesOut out nocopy ame_util.idList
486: ,variableNamesOut out nocopy ame_util.stringList
487: ,variableValuesOut out nocopy ame_util.stringList
488: ,transVariableNamesOut out nocopy ame_util.stringList

Line 485: ,productionIndexesOut out nocopy ame_util.idList

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: ,productionIndexesOut out nocopy ame_util.idList
486: ,variableNamesOut out nocopy ame_util.stringList
487: ,variableValuesOut out nocopy ame_util.stringList
488: ,transVariableNamesOut out nocopy ame_util.stringList
489: ,transVariableValuesOut out nocopy ame_util.stringList);

Line 486: ,variableNamesOut out nocopy ame_util.stringList

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

Line 487: ,variableValuesOut out nocopy ame_util.stringList

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

Line 488: ,transVariableNamesOut out nocopy ame_util.stringList

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

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

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

Line 494: approverIn in ame_util.approverRecord2,

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

Line 495: notificationIn in ame_util2.notificationRecord

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

Line 496: default ame_util2.emptyNotificationRecord,

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

Line 497: forwardeeIn in ame_util.approverRecord2 default

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

Line 498: ame_util.emptyApproverRecord2,

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