1 package ame_admin_pkg as
2 /* $Header: ameoadmi.pkh 120.0 2005/07/26 06:04:22 mbocutt noship $ */
3 function arePrioritiesDisabled(applicationIdIn in integer) return boolean;
4 function canHaveItemAttributes(applicationIdIn in integer,
5 itemClassIdIn in integer) return boolean;
6 function getChildVersionStartDate(itemClassIdIn in integer,
7 applicationIdIn in integer) return varchar2;
8 /*
9 AME_STRIPING
10 function doesStripeSetIdExist(stripeSetIdIn in integer) return boolean;
11 */
12 function getEqualityConditionId(attributeIdIn in integer,
13 stringValueIn in varchar2) return integer;
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,
23 attributeIdIn in integer) return integer;
24 */
25 function getFndAppDescription(fndAppIdIn in integer) return varchar2;
26 function getFndAppDescription1(applicationIdIn in integer) return varchar2;
27 function getFndApplicationId(applicationIdIn in integer) return integer;
28 /*
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,
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;
47 function getItemClassIdQuery(itemClassIdIn in integer,
48 applicationIdIn in integer) return varchar2;
49 function getItemClassMaxOrderNumber(applicationIdIn in integer) return integer;
50 function getItemClassName(itemClassIdIn in integer) return varchar2;
51 function getItemClassOrderNumber(itemClassIdIn in integer,
52 applicationIdIn in integer) return integer;
53 function getItemClassTransTypeCount(applicationIdIn in integer) return integer;
54 function getItemClassParMode(itemClassIdIn in integer,
55 applicationIdIn in integer) return varchar2;
56 function getParentVersionStartDate(itemClassIdIn in integer) return varchar2;
57 function getItemClassSublistMode(itemClassIdIn in integer,
58 applicationIdIn in integer) return varchar2;
59 function getSubordinateItemClassId(applicationIdIn in integer) return integer;
60 function getTransactionTypeId(applicationIdIn in integer) return varchar2;
61 function getVersionStartDate(applicationIdIn in integer) return varchar2;
62 /*
63 AME_STRIPING
64 function getVersionStartDate2(applicationIdIn in integer,
65 stripeSetIdIn in integer) return varchar2;
66 */
67 function hasLineItemAttributes(applicationIdIn in integer) return boolean;
68 /*
69 AME_STRIPING
70 function hasRuleStripes(applicationIdIn in integer) return boolean;
71 */
72 function icInUseByAttributeUsage(itemClassIdIn in integer,
73 applicationIdIn in integer) return boolean;
74 function icInUseByRuleUsage(itemClassIdIn in integer,
75 applicationIdIn in integer) return boolean;
76 function inputToCanonStaticCurUsage(attributeIdIn in integer,
77 applicationIdIn in integer,
78 queryStringIn varchar2) return varchar2;
79 function isApplicationActive(applicationIdIn in integer) return boolean;
80 function isInUseByApplication(itemClassIdIn in integer,
81 applicationIdIn in integer) return boolean;
82 function isSeeded(applicationIdIn in integer) return boolean;
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 */
92 function itemClassNameExists(itemClassnameIn in varchar2) return boolean;
93 function newItemClass(itemClassNameIn in varchar2,
94 newStartDateIn in date,
95 finalizeIn in boolean default false,
96 itemClassIdIn in integer default null) return integer;
97 function orderNumberUnique(applicationIdIn in integer,
98 orderNumberIn in integer) return boolean;
99 function subordinateItemClassCount(applicationIdIn in integer) return integer;
100 function transTypeCVValueExists(applicationIdIn in integer,
101 variableNameIn in varchar2) return boolean;
102 procedure change(applicationIdIn in integer,
103 transactionTypeIdIn in varchar2,
104 transactionTypeDescriptionIn in varchar2,
105 versionStartDateIn in date);
106 procedure changeItemClass(itemClassIdIn in integer,
107 itemClassNameIn in varchar2,
108 startDateIn in date,
109 endDateIn in date,
110 finalizeIn in boolean default false);
111 procedure changeItemClassAndUsage(applicationIdIn in integer,
112 itemClassIdIn in integer,
113 itemClassNameIn in varchar2,
114 itemClassParModeIn in varchar2,
115 itemClassSublistModeIn in varchar2,
116 itemClassIdQueryIn in varchar2,
117 orderNumberIn in integer,
118 orderNumberUniqueIn in varchar2,
119 parentVersionStartDateIn in date,
120 childVersionStartDateIn in date,
121 finalizeIn in boolean default false);
122 procedure changeUsage(applicationIdIn in integer,
123 itemClassIdIn in integer,
124 itemClassParModeIn in varchar2,
125 itemClassSublistModeIn in varchar2,
126 itemClassIdQueryIn in varchar2,
127 orderNumberIn in integer,
128 orderNumberUniqueIn in varchar2,
129 endDateIn in date,
130 newStartDateIn in date,
131 finalizeIn in boolean default false);
132 procedure checkNewOrChangedTransType(fndAppIdIn in integer,
133 transTypeIdIn in varchar2,
134 transTypeDescIn in varchar2);
135 /*
136 AME_STRIPING
137 procedure checkStripeSetUsage(stripeSetIdIn in integer,
138 commitIn in boolean default false);
139 */
140 procedure clearTransException(applicationIdIn in integer,
141 transactionIdIn in varchar2);
142 procedure clearTransTypeConfigVarValue(applicationIdIn in integer,
143 variableNameIn in varchar2);
144 procedure clearTransTypeExceptions(applicationIdIn in integer);
145 procedure clearWebExceptions;
146 procedure decrementItemClassOrderNumbers(applicationIdIn in integer,
147 orderNumberIn in integer,
148 finalizeIn in boolean default false);
149 /*
150 AME_STRIPING
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,
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,
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);
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,
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,
193 stripeValue5Out out nocopy varchar2);
194 procedure getStripingAttributeValues3(applicationIdIn in integer,
195 stripeSetIdIn in integer,
196 stripeValue1Out out nocopy varchar2,
197 stripeValue2Out out nocopy varchar2,
198 stripeValue3Out 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,
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);
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);
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);
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,
243 orderNumberIn in integer,
244 finalizeIn in boolean default false);
245 procedure newItemClassUsage(applicationIdIn in integer,
246 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);
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,
265 childVersionStartDateIn in date,
266 applicationIdIn in integer,
267 finalizeIn in boolean default false);
268 /*
269 AME_STRIPING
270 procedure removeAllStripeSets(applicationIdIn in integer,
271 deleteStripeSetIdZeroIn in boolean,
272 commitIn in boolean default false);
273 procedure removeStripeSetAttributes(applicationIdIn in integer,
274 attributeIdIn in integer);
275 */
276 procedure removeTransactionType(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;