DBA Data[Home] [Help]

APPS.AME_ADMIN_PKG dependencies on AME_UTIL

Line 18: function getAttributeQuery(selectClauseIn in varchar2) return ame_util.queryCursor;

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,

Line 33: stripingAttributeIdsOut out nocopy ame_util.idList,

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,

Line 34: stripingAttributeNamesOut 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);

Line 37: itemClassIdsOut 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,

Line 38: itemClassNamesOut out nocopy ame_util.stringList);

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,

Line 39: procedure getFndApplications(fndAppIdsOut 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);

Line 40: fndAppNamesOut 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;

Line 42: forwardingBehaviorValuesOut 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;
45: function getItemClassCount return integer;
46: function getItemClassIdByName(itemClassNameIn in varchar2) return integer;

Line 43: forwardingBehaviorLabelsOut 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;
47: function getItemClassIdQuery(itemClassIdIn in integer,

Line 87: attributeValuesIn in ame_util.stringList,

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: */

Line 90: attributeValuesIn in ame_util.stringList) return integer;

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,

Line 155: variableNamesOut out nocopy ame_util.stringList,

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,

Line 156: descriptionsOut out nocopy ame_util.stringList);

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

Line 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,

Line 162: attributeValues1In 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,

Line 163: attributeValues2In 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,

Line 164: attributeValues3In in ame_util.stringList default ame_util.emptyStringList,

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,

Line 165: attributeValues4In in ame_util.stringList default ame_util.emptyStringList,

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,

Line 166: attributeValues5In in ame_util.stringList default ame_util.emptyStringList,

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,

Line 167: attributeValues1Out 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,

Line 168: attributeValues2Out 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);

Line 169: attributeValues3Out out nocopy ame_util.stringList,

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,

Line 170: attributeValues4Out out nocopy ame_util.stringList,

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

Line 171: attributeValues5Out out nocopy ame_util.stringList,

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,

Line 172: stripeSetIdListOut out nocopy ame_util.idList);

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

Line 174: stripingAttributeIdsOut out nocopy ame_util.idList);

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,

Line 176: stripingAttributeNamesOut 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,

Line 178: stripingAttributeIdsOut 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,

Line 179: stripingAttributeNamesOut 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,

Line 180: allowedStripeValues1Out 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);

Line 181: allowedStripeValues2Out 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,

Line 182: allowedStripeValues3Out out nocopy ame_util.stringList,

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,

Line 183: allowedStripeValues4Out 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,
187: stripingAttributeIdsOut out nocopy ame_util.stringList,

Line 184: allowedStripeValues5Out 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,

Line 187: stripingAttributeIdsOut 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,

Line 188: stripingAttributeNamesOut 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,
192: stripeValue4Out out nocopy varchar2,

Line 203: itemClassIdListOut out nocopy ame_util.idList,

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,

Line 204: itemClassNameListOut out nocopy ame_util.stringList,

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

Line 205: itemClassOrderNumbersOut out nocopy ame_util.idList);

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,

Line 208: exceptionLogOut out nocopy ame_util.exceptionLogTable);

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

Line 210: 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,

Line 212: exceptionLogOut out nocopy ame_util.exceptionLogTable);

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

Line 213: procedure getTransactionTypes(applicationIdsOut 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,

Line 214: applicationNamesOut out nocopy ame_util.stringList,

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,

Line 215: transactionTypesOut 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);

Line 216: createdByOut out nocopy ame_util.idList);

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,

Line 218: itemClassIdsOut out nocopy ame_util.stringList,

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

Line 219: 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,

Line 221: itemClassIdsOut 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,
224: itemClassIdsOut out nocopy ame_util.idList,
225: itemClassNamesOut out nocopy ame_util.stringList);

Line 222: 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,

Line 224: itemClassIdsOut out nocopy ame_util.idList,

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

Line 225: 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,

Line 227: itemClassIdsOut 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,
230: itemClassIdsOut out nocopy ame_util.idList);
231: procedure getWebExceptions(exceptionLogOut out nocopy ame_util.exceptionLogTable);

Line 228: itemClassNamesOut out nocopy ame_util.stringList);

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,

Line 230: itemClassIdsOut out nocopy ame_util.idList);

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

Line 231: procedure getWebExceptions(exceptionLogOut out nocopy ame_util.exceptionLogTable);

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: /*

Line 234: logOut out nocopy ame_util.workflowLogTable);

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,

Line 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,

Line 251: orderNumberUniqueIn in varchar2 default ame_util.yes,

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

Line 259: attributeIdsIn in ame_util.stringList,

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,

Line 260: queryStringsIn in ame_util.longestStringList,

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,

Line 261: staticUsagesIn in ame_util.stringList,

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,

Line 262: versionStartDatesIn in ame_util.stringList);

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,

Line 281: stripedAttributesIn in ame_util.stringList);

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;