14: function getApplicationId(fndAppIdIn in integer,
15: transactionTypeIdIn in varchar2) return integer;
16: function getApplicationIdByName(nameIn in varchar2) return integer;
17: function getApplicationName(applicationIdIn in integer) return varchar2;
18: function getAttributeQuery(selectClauseIn in varchar2) return ame_util.queryCursor;
19: /*
20: AME_STRIPING
21: function getAttributeDisplayValue(attributeValueIn in varchar2) return varchar2;
22: function getAttributeStripingUseCount(applicationIdIn in integer,
29: AME_STRIPING
30: procedure addStripingAttribute(attributeIdIn in integer,
31: applicationIdIn in integer);
32: procedure getAttributeStripeSetNames(applicationIdIn in integer,
33: stripingAttributeIdsOut out nocopy ame_util.idList,
34: stripingAttributeNamesOut out nocopy ame_util.stringList);
35: */
36: procedure getExistingShareableIClasses(applicationIdIn in integer,
37: itemClassIdsOut out nocopy ame_util.stringList,
30: procedure addStripingAttribute(attributeIdIn in integer,
31: applicationIdIn in integer);
32: procedure getAttributeStripeSetNames(applicationIdIn in integer,
33: stripingAttributeIdsOut out nocopy ame_util.idList,
34: stripingAttributeNamesOut out nocopy ame_util.stringList);
35: */
36: procedure getExistingShareableIClasses(applicationIdIn in integer,
37: itemClassIdsOut out nocopy ame_util.stringList,
38: itemClassNamesOut out nocopy ame_util.stringList);
33: stripingAttributeIdsOut out nocopy ame_util.idList,
34: stripingAttributeNamesOut out nocopy ame_util.stringList);
35: */
36: procedure getExistingShareableIClasses(applicationIdIn in integer,
37: itemClassIdsOut out nocopy ame_util.stringList,
38: itemClassNamesOut out nocopy ame_util.stringList);
39: procedure getFndApplications(fndAppIdsOut out nocopy ame_util.stringList,
40: fndAppNamesOut out nocopy ame_util.stringList);
41: procedure getForwardingBehaviorList(forwardingBehaviorIn in integer,
34: stripingAttributeNamesOut out nocopy ame_util.stringList);
35: */
36: procedure getExistingShareableIClasses(applicationIdIn in integer,
37: itemClassIdsOut out nocopy ame_util.stringList,
38: itemClassNamesOut out nocopy ame_util.stringList);
39: procedure getFndApplications(fndAppIdsOut out nocopy ame_util.stringList,
40: fndAppNamesOut out nocopy ame_util.stringList);
41: procedure getForwardingBehaviorList(forwardingBehaviorIn in integer,
42: forwardingBehaviorValuesOut out nocopy ame_util.stringList,
35: */
36: procedure getExistingShareableIClasses(applicationIdIn in integer,
37: itemClassIdsOut out nocopy ame_util.stringList,
38: itemClassNamesOut out nocopy ame_util.stringList);
39: procedure getFndApplications(fndAppIdsOut out nocopy ame_util.stringList,
40: fndAppNamesOut out nocopy ame_util.stringList);
41: procedure getForwardingBehaviorList(forwardingBehaviorIn in integer,
42: forwardingBehaviorValuesOut out nocopy ame_util.stringList,
43: forwardingBehaviorLabelsOut out nocopy ame_util.stringList);
36: procedure getExistingShareableIClasses(applicationIdIn in integer,
37: itemClassIdsOut out nocopy ame_util.stringList,
38: itemClassNamesOut out nocopy ame_util.stringList);
39: procedure getFndApplications(fndAppIdsOut out nocopy ame_util.stringList,
40: fndAppNamesOut out nocopy ame_util.stringList);
41: procedure getForwardingBehaviorList(forwardingBehaviorIn in integer,
42: forwardingBehaviorValuesOut out nocopy ame_util.stringList,
43: forwardingBehaviorLabelsOut out nocopy ame_util.stringList);
44: function getLineItemQueryString(applicationIdIn in integer) return varchar2;
38: itemClassNamesOut out nocopy ame_util.stringList);
39: procedure getFndApplications(fndAppIdsOut out nocopy ame_util.stringList,
40: fndAppNamesOut out nocopy ame_util.stringList);
41: procedure getForwardingBehaviorList(forwardingBehaviorIn in integer,
42: forwardingBehaviorValuesOut out nocopy ame_util.stringList,
43: forwardingBehaviorLabelsOut out nocopy ame_util.stringList);
44: function getLineItemQueryString(applicationIdIn in integer) return varchar2;
45: function getItemClassCount return integer;
46: function getItemClassIdByName(itemClassNameIn in varchar2) return integer;
39: procedure getFndApplications(fndAppIdsOut out nocopy ame_util.stringList,
40: fndAppNamesOut out nocopy ame_util.stringList);
41: procedure getForwardingBehaviorList(forwardingBehaviorIn in integer,
42: forwardingBehaviorValuesOut out nocopy ame_util.stringList,
43: forwardingBehaviorLabelsOut out nocopy ame_util.stringList);
44: function getLineItemQueryString(applicationIdIn in integer) return varchar2;
45: function getItemClassCount return integer;
46: function getItemClassIdByName(itemClassNameIn in varchar2) return integer;
47: function getItemClassIdQuery(itemClassIdIn in integer,
83: /*
84: AME_STRIPING
85: function isStripingOn(applicationIdIn in integer) return boolean;
86: function newStripeSet(applicationIdIn in integer,
87: attributeValuesIn in ame_util.stringList,
88: commitIn in boolean default false) return integer;
89: function getStripeSetId(applicationIdIn in integer,
90: attributeValuesIn in ame_util.stringList) return integer;
91: */
86: function newStripeSet(applicationIdIn in integer,
87: attributeValuesIn in ame_util.stringList,
88: commitIn in boolean default false) return integer;
89: function getStripeSetId(applicationIdIn in integer,
90: attributeValuesIn in ame_util.stringList) return integer;
91: */
92: function itemClassNameExists(itemClassnameIn in varchar2) return boolean;
93: function newItemClass(itemClassNameIn in varchar2,
94: newStartDateIn in date,
151: procedure enableRuleStriping(applicationIdIn in integer,
152: commitIn in boolean default false);
153: */
154: procedure getConfigVariables(applicationIdIn in integer default null,
155: variableNamesOut out nocopy ame_util.stringList,
156: descriptionsOut out nocopy ame_util.stringList);
157: /*
158: AME_STRIPING
159: procedure getStripeSetIds(applicationIdIn in integer,
152: commitIn in boolean default false);
153: */
154: procedure getConfigVariables(applicationIdIn in integer default null,
155: variableNamesOut out nocopy ame_util.stringList,
156: descriptionsOut out nocopy ame_util.stringList);
157: /*
158: AME_STRIPING
159: procedure getStripeSetIds(applicationIdIn in integer,
160: stripeSetIdsOut out nocopy ame_util.idList);
156: descriptionsOut out nocopy ame_util.stringList);
157: /*
158: AME_STRIPING
159: procedure getStripeSetIds(applicationIdIn in integer,
160: stripeSetIdsOut out nocopy ame_util.idList);
161: procedure getStripeSetList(applicationIdIn in integer,
162: attributeValues1In in ame_util.stringList default ame_util.emptyStringList,
163: attributeValues2In in ame_util.stringList default ame_util.emptyStringList,
164: attributeValues3In in ame_util.stringList default ame_util.emptyStringList,
158: AME_STRIPING
159: procedure getStripeSetIds(applicationIdIn in integer,
160: stripeSetIdsOut out nocopy ame_util.idList);
161: procedure getStripeSetList(applicationIdIn in integer,
162: attributeValues1In in ame_util.stringList default ame_util.emptyStringList,
163: attributeValues2In in ame_util.stringList default ame_util.emptyStringList,
164: attributeValues3In in ame_util.stringList default ame_util.emptyStringList,
165: attributeValues4In in ame_util.stringList default ame_util.emptyStringList,
166: attributeValues5In in ame_util.stringList default ame_util.emptyStringList,
159: procedure getStripeSetIds(applicationIdIn in integer,
160: stripeSetIdsOut out nocopy ame_util.idList);
161: procedure getStripeSetList(applicationIdIn in integer,
162: attributeValues1In in ame_util.stringList default ame_util.emptyStringList,
163: attributeValues2In in ame_util.stringList default ame_util.emptyStringList,
164: attributeValues3In in ame_util.stringList default ame_util.emptyStringList,
165: attributeValues4In in ame_util.stringList default ame_util.emptyStringList,
166: attributeValues5In in ame_util.stringList default ame_util.emptyStringList,
167: attributeValues1Out out nocopy ame_util.stringList,
160: stripeSetIdsOut out nocopy ame_util.idList);
161: procedure getStripeSetList(applicationIdIn in integer,
162: attributeValues1In in ame_util.stringList default ame_util.emptyStringList,
163: attributeValues2In in ame_util.stringList default ame_util.emptyStringList,
164: attributeValues3In in ame_util.stringList default ame_util.emptyStringList,
165: attributeValues4In in ame_util.stringList default ame_util.emptyStringList,
166: attributeValues5In in ame_util.stringList default ame_util.emptyStringList,
167: attributeValues1Out out nocopy ame_util.stringList,
168: attributeValues2Out out nocopy ame_util.stringList,
161: procedure getStripeSetList(applicationIdIn in integer,
162: attributeValues1In in ame_util.stringList default ame_util.emptyStringList,
163: attributeValues2In in ame_util.stringList default ame_util.emptyStringList,
164: attributeValues3In in ame_util.stringList default ame_util.emptyStringList,
165: attributeValues4In in ame_util.stringList default ame_util.emptyStringList,
166: attributeValues5In in ame_util.stringList default ame_util.emptyStringList,
167: attributeValues1Out out nocopy ame_util.stringList,
168: attributeValues2Out out nocopy ame_util.stringList,
169: attributeValues3Out out nocopy ame_util.stringList,
162: attributeValues1In in ame_util.stringList default ame_util.emptyStringList,
163: attributeValues2In in ame_util.stringList default ame_util.emptyStringList,
164: attributeValues3In in ame_util.stringList default ame_util.emptyStringList,
165: attributeValues4In in ame_util.stringList default ame_util.emptyStringList,
166: attributeValues5In in ame_util.stringList default ame_util.emptyStringList,
167: attributeValues1Out out nocopy ame_util.stringList,
168: attributeValues2Out out nocopy ame_util.stringList,
169: attributeValues3Out out nocopy ame_util.stringList,
170: attributeValues4Out out nocopy ame_util.stringList,
163: attributeValues2In in ame_util.stringList default ame_util.emptyStringList,
164: attributeValues3In in ame_util.stringList default ame_util.emptyStringList,
165: attributeValues4In in ame_util.stringList default ame_util.emptyStringList,
166: attributeValues5In in ame_util.stringList default ame_util.emptyStringList,
167: attributeValues1Out out nocopy ame_util.stringList,
168: attributeValues2Out out nocopy ame_util.stringList,
169: attributeValues3Out out nocopy ame_util.stringList,
170: attributeValues4Out out nocopy ame_util.stringList,
171: attributeValues5Out out nocopy ame_util.stringList,
164: attributeValues3In in ame_util.stringList default ame_util.emptyStringList,
165: attributeValues4In in ame_util.stringList default ame_util.emptyStringList,
166: attributeValues5In in ame_util.stringList default ame_util.emptyStringList,
167: attributeValues1Out out nocopy ame_util.stringList,
168: attributeValues2Out out nocopy ame_util.stringList,
169: attributeValues3Out out nocopy ame_util.stringList,
170: attributeValues4Out out nocopy ame_util.stringList,
171: attributeValues5Out out nocopy ame_util.stringList,
172: stripeSetIdListOut out nocopy ame_util.idList);
165: attributeValues4In in ame_util.stringList default ame_util.emptyStringList,
166: attributeValues5In in ame_util.stringList default ame_util.emptyStringList,
167: attributeValues1Out out nocopy ame_util.stringList,
168: attributeValues2Out out nocopy ame_util.stringList,
169: attributeValues3Out out nocopy ame_util.stringList,
170: attributeValues4Out out nocopy ame_util.stringList,
171: attributeValues5Out out nocopy ame_util.stringList,
172: stripeSetIdListOut out nocopy ame_util.idList);
173: procedure getStripingAttributeIds(applicationIdIn in integer,
166: attributeValues5In in ame_util.stringList default ame_util.emptyStringList,
167: attributeValues1Out out nocopy ame_util.stringList,
168: attributeValues2Out out nocopy ame_util.stringList,
169: attributeValues3Out out nocopy ame_util.stringList,
170: attributeValues4Out out nocopy ame_util.stringList,
171: attributeValues5Out out nocopy ame_util.stringList,
172: stripeSetIdListOut out nocopy ame_util.idList);
173: procedure getStripingAttributeIds(applicationIdIn in integer,
174: stripingAttributeIdsOut out nocopy ame_util.idList);
167: attributeValues1Out out nocopy ame_util.stringList,
168: attributeValues2Out out nocopy ame_util.stringList,
169: attributeValues3Out out nocopy ame_util.stringList,
170: attributeValues4Out out nocopy ame_util.stringList,
171: attributeValues5Out out nocopy ame_util.stringList,
172: stripeSetIdListOut out nocopy ame_util.idList);
173: procedure getStripingAttributeIds(applicationIdIn in integer,
174: stripingAttributeIdsOut out nocopy ame_util.idList);
175: procedure getStripingAttributeNames(applicationIdIn in integer,
168: attributeValues2Out out nocopy ame_util.stringList,
169: attributeValues3Out out nocopy ame_util.stringList,
170: attributeValues4Out out nocopy ame_util.stringList,
171: attributeValues5Out out nocopy ame_util.stringList,
172: stripeSetIdListOut out nocopy ame_util.idList);
173: procedure getStripingAttributeIds(applicationIdIn in integer,
174: stripingAttributeIdsOut out nocopy ame_util.idList);
175: procedure getStripingAttributeNames(applicationIdIn in integer,
176: stripingAttributeNamesOut out nocopy ame_util.stringList);
170: attributeValues4Out out nocopy ame_util.stringList,
171: attributeValues5Out out nocopy ame_util.stringList,
172: stripeSetIdListOut out nocopy ame_util.idList);
173: procedure getStripingAttributeIds(applicationIdIn in integer,
174: stripingAttributeIdsOut out nocopy ame_util.idList);
175: procedure getStripingAttributeNames(applicationIdIn in integer,
176: stripingAttributeNamesOut out nocopy ame_util.stringList);
177: procedure getStripingAttributeValues(applicationIdIn in integer,
178: stripingAttributeIdsOut out nocopy ame_util.stringList,
172: stripeSetIdListOut out nocopy ame_util.idList);
173: procedure getStripingAttributeIds(applicationIdIn in integer,
174: stripingAttributeIdsOut out nocopy ame_util.idList);
175: procedure getStripingAttributeNames(applicationIdIn in integer,
176: stripingAttributeNamesOut out nocopy ame_util.stringList);
177: procedure getStripingAttributeValues(applicationIdIn in integer,
178: stripingAttributeIdsOut out nocopy ame_util.stringList,
179: stripingAttributeNamesOut out nocopy ame_util.stringList,
180: allowedStripeValues1Out out nocopy ame_util.stringList,
174: stripingAttributeIdsOut out nocopy ame_util.idList);
175: procedure getStripingAttributeNames(applicationIdIn in integer,
176: stripingAttributeNamesOut out nocopy ame_util.stringList);
177: procedure getStripingAttributeValues(applicationIdIn in integer,
178: stripingAttributeIdsOut out nocopy ame_util.stringList,
179: stripingAttributeNamesOut out nocopy ame_util.stringList,
180: allowedStripeValues1Out out nocopy ame_util.stringList,
181: allowedStripeValues2Out out nocopy ame_util.stringList,
182: allowedStripeValues3Out out nocopy ame_util.stringList,
175: procedure getStripingAttributeNames(applicationIdIn in integer,
176: stripingAttributeNamesOut out nocopy ame_util.stringList);
177: procedure getStripingAttributeValues(applicationIdIn in integer,
178: stripingAttributeIdsOut out nocopy ame_util.stringList,
179: stripingAttributeNamesOut out nocopy ame_util.stringList,
180: allowedStripeValues1Out out nocopy ame_util.stringList,
181: allowedStripeValues2Out out nocopy ame_util.stringList,
182: allowedStripeValues3Out out nocopy ame_util.stringList,
183: allowedStripeValues4Out out nocopy ame_util.stringList,
176: stripingAttributeNamesOut out nocopy ame_util.stringList);
177: procedure getStripingAttributeValues(applicationIdIn in integer,
178: stripingAttributeIdsOut out nocopy ame_util.stringList,
179: stripingAttributeNamesOut out nocopy ame_util.stringList,
180: allowedStripeValues1Out out nocopy ame_util.stringList,
181: allowedStripeValues2Out out nocopy ame_util.stringList,
182: allowedStripeValues3Out out nocopy ame_util.stringList,
183: allowedStripeValues4Out out nocopy ame_util.stringList,
184: allowedStripeValues5Out out nocopy ame_util.stringList);
177: procedure getStripingAttributeValues(applicationIdIn in integer,
178: stripingAttributeIdsOut out nocopy ame_util.stringList,
179: stripingAttributeNamesOut out nocopy ame_util.stringList,
180: allowedStripeValues1Out out nocopy ame_util.stringList,
181: allowedStripeValues2Out out nocopy ame_util.stringList,
182: allowedStripeValues3Out out nocopy ame_util.stringList,
183: allowedStripeValues4Out out nocopy ame_util.stringList,
184: allowedStripeValues5Out out nocopy ame_util.stringList);
185: procedure getStripingAttributeValues2(applicationIdIn in integer,
178: stripingAttributeIdsOut out nocopy ame_util.stringList,
179: stripingAttributeNamesOut out nocopy ame_util.stringList,
180: allowedStripeValues1Out out nocopy ame_util.stringList,
181: allowedStripeValues2Out out nocopy ame_util.stringList,
182: allowedStripeValues3Out out nocopy ame_util.stringList,
183: allowedStripeValues4Out out nocopy ame_util.stringList,
184: allowedStripeValues5Out out nocopy ame_util.stringList);
185: procedure getStripingAttributeValues2(applicationIdIn in integer,
186: stripeSetIdIn in integer,
179: stripingAttributeNamesOut out nocopy ame_util.stringList,
180: allowedStripeValues1Out out nocopy ame_util.stringList,
181: allowedStripeValues2Out out nocopy ame_util.stringList,
182: allowedStripeValues3Out out nocopy ame_util.stringList,
183: allowedStripeValues4Out out nocopy ame_util.stringList,
184: allowedStripeValues5Out out nocopy ame_util.stringList);
185: procedure getStripingAttributeValues2(applicationIdIn in integer,
186: stripeSetIdIn in integer,
187: stripingAttributeIdsOut out nocopy ame_util.stringList,
180: allowedStripeValues1Out out nocopy ame_util.stringList,
181: allowedStripeValues2Out out nocopy ame_util.stringList,
182: allowedStripeValues3Out out nocopy ame_util.stringList,
183: allowedStripeValues4Out out nocopy ame_util.stringList,
184: allowedStripeValues5Out out nocopy ame_util.stringList);
185: procedure getStripingAttributeValues2(applicationIdIn in integer,
186: stripeSetIdIn in integer,
187: stripingAttributeIdsOut out nocopy ame_util.stringList,
188: stripingAttributeNamesOut out nocopy ame_util.stringList,
183: allowedStripeValues4Out out nocopy ame_util.stringList,
184: allowedStripeValues5Out out nocopy ame_util.stringList);
185: procedure getStripingAttributeValues2(applicationIdIn in integer,
186: stripeSetIdIn in integer,
187: stripingAttributeIdsOut out nocopy ame_util.stringList,
188: stripingAttributeNamesOut out nocopy ame_util.stringList,
189: stripeValue1Out out nocopy varchar2,
190: stripeValue2Out out nocopy varchar2,
191: stripeValue3Out out nocopy varchar2,
184: allowedStripeValues5Out out nocopy ame_util.stringList);
185: procedure getStripingAttributeValues2(applicationIdIn in integer,
186: stripeSetIdIn in integer,
187: stripingAttributeIdsOut out nocopy ame_util.stringList,
188: stripingAttributeNamesOut out nocopy ame_util.stringList,
189: stripeValue1Out out nocopy varchar2,
190: stripeValue2Out out nocopy varchar2,
191: stripeValue3Out out nocopy varchar2,
192: stripeValue4Out out nocopy varchar2,
199: stripeValue4Out out nocopy varchar2,
200: stripeValue5Out out nocopy varchar2);
201: */
202: procedure getItemClassList(applicationIdIn in integer,
203: itemClassIdListOut out nocopy ame_util.idList,
204: itemClassNameListOut out nocopy ame_util.stringList,
205: itemClassOrderNumbersOut out nocopy ame_util.idList);
206: procedure getTransExceptions(applicationIdIn in integer,
207: transactionIdIn in varchar2,
200: stripeValue5Out out nocopy varchar2);
201: */
202: procedure getItemClassList(applicationIdIn in integer,
203: itemClassIdListOut out nocopy ame_util.idList,
204: itemClassNameListOut out nocopy ame_util.stringList,
205: itemClassOrderNumbersOut out nocopy ame_util.idList);
206: procedure getTransExceptions(applicationIdIn in integer,
207: transactionIdIn in varchar2,
208: exceptionLogOut out nocopy ame_util.exceptionLogTable);
201: */
202: procedure getItemClassList(applicationIdIn in integer,
203: itemClassIdListOut out nocopy ame_util.idList,
204: itemClassNameListOut out nocopy ame_util.stringList,
205: itemClassOrderNumbersOut out nocopy ame_util.idList);
206: procedure getTransExceptions(applicationIdIn in integer,
207: transactionIdIn in varchar2,
208: exceptionLogOut out nocopy ame_util.exceptionLogTable);
209: procedure getTransTypeExceptions1(applicationIdIn in integer,
204: itemClassNameListOut out nocopy ame_util.stringList,
205: itemClassOrderNumbersOut out nocopy ame_util.idList);
206: procedure getTransExceptions(applicationIdIn in integer,
207: transactionIdIn in varchar2,
208: exceptionLogOut out nocopy ame_util.exceptionLogTable);
209: procedure getTransTypeExceptions1(applicationIdIn in integer,
210: exceptionLogOut out nocopy ame_util.exceptionLogTable);
211: procedure getTransTypeExceptions2(applicationIdIn in integer,
212: exceptionLogOut out nocopy ame_util.exceptionLogTable);
206: procedure getTransExceptions(applicationIdIn in integer,
207: transactionIdIn in varchar2,
208: exceptionLogOut out nocopy ame_util.exceptionLogTable);
209: procedure getTransTypeExceptions1(applicationIdIn in integer,
210: exceptionLogOut out nocopy ame_util.exceptionLogTable);
211: procedure getTransTypeExceptions2(applicationIdIn in integer,
212: exceptionLogOut out nocopy ame_util.exceptionLogTable);
213: procedure getTransactionTypes(applicationIdsOut out nocopy ame_util.idList,
214: applicationNamesOut out nocopy ame_util.stringList,
208: exceptionLogOut out nocopy ame_util.exceptionLogTable);
209: procedure getTransTypeExceptions1(applicationIdIn in integer,
210: exceptionLogOut out nocopy ame_util.exceptionLogTable);
211: procedure getTransTypeExceptions2(applicationIdIn in integer,
212: exceptionLogOut out nocopy ame_util.exceptionLogTable);
213: procedure getTransactionTypes(applicationIdsOut out nocopy ame_util.idList,
214: applicationNamesOut out nocopy ame_util.stringList,
215: transactionTypesOut out nocopy ame_util.stringList,
216: createdByOut out nocopy ame_util.idList);
209: procedure getTransTypeExceptions1(applicationIdIn in integer,
210: exceptionLogOut out nocopy ame_util.exceptionLogTable);
211: procedure getTransTypeExceptions2(applicationIdIn in integer,
212: exceptionLogOut out nocopy ame_util.exceptionLogTable);
213: procedure getTransactionTypes(applicationIdsOut out nocopy ame_util.idList,
214: applicationNamesOut out nocopy ame_util.stringList,
215: transactionTypesOut out nocopy ame_util.stringList,
216: createdByOut out nocopy ame_util.idList);
217: procedure getTransTypeItemClasses(applicationIdIn in integer,
210: exceptionLogOut out nocopy ame_util.exceptionLogTable);
211: procedure getTransTypeExceptions2(applicationIdIn in integer,
212: exceptionLogOut out nocopy ame_util.exceptionLogTable);
213: procedure getTransactionTypes(applicationIdsOut out nocopy ame_util.idList,
214: applicationNamesOut out nocopy ame_util.stringList,
215: transactionTypesOut out nocopy ame_util.stringList,
216: createdByOut out nocopy ame_util.idList);
217: procedure getTransTypeItemClasses(applicationIdIn in integer,
218: itemClassIdsOut out nocopy ame_util.stringList,
211: procedure getTransTypeExceptions2(applicationIdIn in integer,
212: exceptionLogOut out nocopy ame_util.exceptionLogTable);
213: procedure getTransactionTypes(applicationIdsOut out nocopy ame_util.idList,
214: applicationNamesOut out nocopy ame_util.stringList,
215: transactionTypesOut out nocopy ame_util.stringList,
216: createdByOut out nocopy ame_util.idList);
217: procedure getTransTypeItemClasses(applicationIdIn in integer,
218: itemClassIdsOut out nocopy ame_util.stringList,
219: itemClassNamesOut out nocopy ame_util.stringList);
212: exceptionLogOut out nocopy ame_util.exceptionLogTable);
213: procedure getTransactionTypes(applicationIdsOut out nocopy ame_util.idList,
214: applicationNamesOut out nocopy ame_util.stringList,
215: transactionTypesOut out nocopy ame_util.stringList,
216: createdByOut out nocopy ame_util.idList);
217: procedure getTransTypeItemClasses(applicationIdIn in integer,
218: itemClassIdsOut out nocopy ame_util.stringList,
219: itemClassNamesOut out nocopy ame_util.stringList);
220: procedure getTransTypeItemClasses2(applicationIdIn in integer,
214: applicationNamesOut out nocopy ame_util.stringList,
215: transactionTypesOut out nocopy ame_util.stringList,
216: createdByOut out nocopy ame_util.idList);
217: procedure getTransTypeItemClasses(applicationIdIn in integer,
218: itemClassIdsOut out nocopy ame_util.stringList,
219: itemClassNamesOut out nocopy ame_util.stringList);
220: procedure getTransTypeItemClasses2(applicationIdIn in integer,
221: itemClassIdsOut out nocopy ame_util.idList,
222: itemClassNamesOut out nocopy ame_util.stringList);
215: transactionTypesOut out nocopy ame_util.stringList,
216: createdByOut out nocopy ame_util.idList);
217: procedure getTransTypeItemClasses(applicationIdIn in integer,
218: itemClassIdsOut out nocopy ame_util.stringList,
219: itemClassNamesOut out nocopy ame_util.stringList);
220: procedure getTransTypeItemClasses2(applicationIdIn in integer,
221: itemClassIdsOut out nocopy ame_util.idList,
222: itemClassNamesOut out nocopy ame_util.stringList);
223: procedure getTransTypeItemClasses3(applicationIdIn in integer,
217: procedure getTransTypeItemClasses(applicationIdIn in integer,
218: itemClassIdsOut out nocopy ame_util.stringList,
219: itemClassNamesOut out nocopy ame_util.stringList);
220: procedure getTransTypeItemClasses2(applicationIdIn in integer,
221: itemClassIdsOut out nocopy ame_util.idList,
222: itemClassNamesOut out nocopy ame_util.stringList);
223: procedure getTransTypeItemClasses3(applicationIdIn in integer,
224: itemClassIdsOut out nocopy ame_util.idList,
225: itemClassNamesOut out nocopy ame_util.stringList);
218: itemClassIdsOut out nocopy ame_util.stringList,
219: itemClassNamesOut out nocopy ame_util.stringList);
220: procedure getTransTypeItemClasses2(applicationIdIn in integer,
221: itemClassIdsOut out nocopy ame_util.idList,
222: itemClassNamesOut out nocopy ame_util.stringList);
223: procedure getTransTypeItemClasses3(applicationIdIn in integer,
224: itemClassIdsOut out nocopy ame_util.idList,
225: itemClassNamesOut out nocopy ame_util.stringList);
226: procedure getTransTypeItemClasses4(applicationIdIn in integer,
220: procedure getTransTypeItemClasses2(applicationIdIn in integer,
221: itemClassIdsOut out nocopy ame_util.idList,
222: itemClassNamesOut out nocopy ame_util.stringList);
223: procedure getTransTypeItemClasses3(applicationIdIn in integer,
224: itemClassIdsOut out nocopy ame_util.idList,
225: itemClassNamesOut out nocopy ame_util.stringList);
226: procedure getTransTypeItemClasses4(applicationIdIn in integer,
227: itemClassIdsOut out nocopy ame_util.stringList,
228: itemClassNamesOut out nocopy ame_util.stringList);
221: itemClassIdsOut out nocopy ame_util.idList,
222: itemClassNamesOut out nocopy ame_util.stringList);
223: procedure getTransTypeItemClasses3(applicationIdIn in integer,
224: itemClassIdsOut out nocopy ame_util.idList,
225: itemClassNamesOut out nocopy ame_util.stringList);
226: procedure getTransTypeItemClasses4(applicationIdIn in integer,
227: itemClassIdsOut out nocopy ame_util.stringList,
228: itemClassNamesOut out nocopy ame_util.stringList);
229: procedure getTransTypeItemClassIds(applicationIdIn in integer,
223: procedure getTransTypeItemClasses3(applicationIdIn in integer,
224: itemClassIdsOut out nocopy ame_util.idList,
225: itemClassNamesOut out nocopy ame_util.stringList);
226: procedure getTransTypeItemClasses4(applicationIdIn in integer,
227: itemClassIdsOut out nocopy ame_util.stringList,
228: itemClassNamesOut out nocopy ame_util.stringList);
229: procedure getTransTypeItemClassIds(applicationIdIn in integer,
230: itemClassIdsOut out nocopy ame_util.idList);
231: procedure getWebExceptions(exceptionLogOut out nocopy ame_util.exceptionLogTable);
224: itemClassIdsOut out nocopy ame_util.idList,
225: itemClassNamesOut out nocopy ame_util.stringList);
226: procedure getTransTypeItemClasses4(applicationIdIn in integer,
227: itemClassIdsOut out nocopy ame_util.stringList,
228: itemClassNamesOut out nocopy ame_util.stringList);
229: procedure getTransTypeItemClassIds(applicationIdIn in integer,
230: itemClassIdsOut out nocopy ame_util.idList);
231: procedure getWebExceptions(exceptionLogOut out nocopy ame_util.exceptionLogTable);
232: procedure getWorkflowLog(applicationIdIn in integer,
226: procedure getTransTypeItemClasses4(applicationIdIn in integer,
227: itemClassIdsOut out nocopy ame_util.stringList,
228: itemClassNamesOut out nocopy ame_util.stringList);
229: procedure getTransTypeItemClassIds(applicationIdIn in integer,
230: itemClassIdsOut out nocopy ame_util.idList);
231: procedure getWebExceptions(exceptionLogOut out nocopy ame_util.exceptionLogTable);
232: procedure getWorkflowLog(applicationIdIn in integer,
233: transactionIdIn in varchar2 default null,
234: logOut out nocopy ame_util.workflowLogTable);
227: itemClassIdsOut out nocopy ame_util.stringList,
228: itemClassNamesOut out nocopy ame_util.stringList);
229: procedure getTransTypeItemClassIds(applicationIdIn in integer,
230: itemClassIdsOut out nocopy ame_util.idList);
231: procedure getWebExceptions(exceptionLogOut out nocopy ame_util.exceptionLogTable);
232: procedure getWorkflowLog(applicationIdIn in integer,
233: transactionIdIn in varchar2 default null,
234: logOut out nocopy ame_util.workflowLogTable);
235: /*
230: itemClassIdsOut out nocopy ame_util.idList);
231: procedure getWebExceptions(exceptionLogOut out nocopy ame_util.exceptionLogTable);
232: procedure getWorkflowLog(applicationIdIn in integer,
233: transactionIdIn in varchar2 default null,
234: logOut out nocopy ame_util.workflowLogTable);
235: /*
236: AME_STRIPING
237: procedure newStripeSet2(applicationIdIn in integer,
238: newStripedAttributesSetIn in ame_util.stringList,
234: logOut out nocopy ame_util.workflowLogTable);
235: /*
236: AME_STRIPING
237: procedure newStripeSet2(applicationIdIn in integer,
238: newStripedAttributesSetIn in ame_util.stringList,
239: commitIn in boolean default false);
240: */
241: procedure incrementItemClassOrderNumbers(applicationIdIn in integer,
242: itemClassIdIn in integer,
247: itemClassParModeIn in varchar2,
248: itemClassSublistModeIn in varchar2,
249: itemClassIdQueryIn in varchar2,
250: orderNumberIn in integer default null,
251: orderNumberUniqueIn in varchar2 default ame_util.yes,
252: updateParentObjectIn in boolean,
253: newStartDateIn in date,
254: finalizeIn in boolean default false,
255: parentVersionStartDateIn in date default null);
255: parentVersionStartDateIn in date default null);
256: procedure registerTransactionType(fndApplicationIdIn in integer,
257: transTypeDescIn in varchar2,
258: transactionTypeIdIn in varchar2 default null,
259: attributeIdsIn in ame_util.stringList,
260: queryStringsIn in ame_util.longestStringList,
261: staticUsagesIn in ame_util.stringList,
262: versionStartDatesIn in ame_util.stringList);
263: procedure removeUsage(itemClassIdIn in integer,
256: procedure registerTransactionType(fndApplicationIdIn in integer,
257: transTypeDescIn in varchar2,
258: transactionTypeIdIn in varchar2 default null,
259: attributeIdsIn in ame_util.stringList,
260: queryStringsIn in ame_util.longestStringList,
261: staticUsagesIn in ame_util.stringList,
262: versionStartDatesIn in ame_util.stringList);
263: procedure removeUsage(itemClassIdIn in integer,
264: parentVersionStartDateIn in date,
257: transTypeDescIn in varchar2,
258: transactionTypeIdIn in varchar2 default null,
259: attributeIdsIn in ame_util.stringList,
260: queryStringsIn in ame_util.longestStringList,
261: staticUsagesIn in ame_util.stringList,
262: versionStartDatesIn in ame_util.stringList);
263: procedure removeUsage(itemClassIdIn in integer,
264: parentVersionStartDateIn in date,
265: childVersionStartDateIn in date,
258: transactionTypeIdIn in varchar2 default null,
259: attributeIdsIn in ame_util.stringList,
260: queryStringsIn in ame_util.longestStringList,
261: staticUsagesIn in ame_util.stringList,
262: versionStartDatesIn in ame_util.stringList);
263: procedure removeUsage(itemClassIdIn in integer,
264: parentVersionStartDateIn in date,
265: childVersionStartDateIn in date,
266: applicationIdIn in integer,
277: versionStartDateIn in date);
278: /*
279: AME_STRIPING
280: procedure updateStripingAttIds(applicationIdIn in integer,
281: stripedAttributesIn in ame_util.stringList);
282: procedure updateStripingAttUseCount(applicationIdIn in integer);
283: */
284: end ame_admin_pkg;