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_TEST_PKG dependencies on AME_UTIL

Line 11: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

7: return(to_char(tempId));
8: exception
9: when others then
10: rollback;
11: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
12: routineNameIn => 'getTestTransactionId',
13: exceptionNumberIn => sqlcode,
14: exceptionStringIn => sqlerrm);
15: raise;

Line 45: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

41: return(false);
42: exception
43: when others then
44: rollback;
45: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
46: routineNameIn => 'isTestItemIdDuplicate',
47: exceptionNumberIn => sqlcode,
48: exceptionStringIn => sqlerrm);
49: raise;

Line 55: deleteIn in ame_util.stringList) as

51: end isTestItemIdDuplicate;
52: procedure deleteTestItems(applicationIdIn in integer,
53: transactionIdIn in varchar2,
54: itemClassIdIn in integer,
55: deleteIn in ame_util.stringList) as
56: upperLimit integer;
57: begin
58: upperLimit := deleteIn.count;
59: forall i in 1 .. upperLimit

Line 70: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

66: commit;
67: exception
68: when others then
69: rollback;
70: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
71: routineNameIn => 'deleteTestItems',
72: exceptionNumberIn => sqlcode,
73: exceptionStringIn => sqlerrm);
74: raise;

Line 79: attributeIdsOut out nocopy ame_util.idList,

75: end deleteTestItems;
76: procedure getAllAttributeValues(applicationIdIn in integer,
77: transactionIdIn in varchar2,
78: itemIdIn in varchar2 default null,
79: attributeIdsOut out nocopy ame_util.idList,
80: attributeNamesOut out nocopy ame_util.stringList,
81: attributeTypesOut out nocopy ame_util.stringList,
82: isMandatoryOut out nocopy ame_util.stringList,
83: attributeValues1Out out nocopy ame_util.attributeValueList,

Line 80: attributeNamesOut out nocopy ame_util.stringList,

76: procedure getAllAttributeValues(applicationIdIn in integer,
77: transactionIdIn in varchar2,
78: itemIdIn in varchar2 default null,
79: attributeIdsOut out nocopy ame_util.idList,
80: attributeNamesOut out nocopy ame_util.stringList,
81: attributeTypesOut out nocopy ame_util.stringList,
82: isMandatoryOut out nocopy ame_util.stringList,
83: attributeValues1Out out nocopy ame_util.attributeValueList,
84: attributeValues2Out out nocopy ame_util.attributeValueList,

Line 81: attributeTypesOut out nocopy ame_util.stringList,

77: transactionIdIn in varchar2,
78: itemIdIn in varchar2 default null,
79: attributeIdsOut out nocopy ame_util.idList,
80: attributeNamesOut out nocopy ame_util.stringList,
81: attributeTypesOut out nocopy ame_util.stringList,
82: isMandatoryOut out nocopy ame_util.stringList,
83: attributeValues1Out out nocopy ame_util.attributeValueList,
84: attributeValues2Out out nocopy ame_util.attributeValueList,
85: attributeValues3Out out nocopy ame_util.attributeValueList) as

Line 82: isMandatoryOut out nocopy ame_util.stringList,

78: itemIdIn in varchar2 default null,
79: attributeIdsOut out nocopy ame_util.idList,
80: attributeNamesOut out nocopy ame_util.stringList,
81: attributeTypesOut out nocopy ame_util.stringList,
82: isMandatoryOut out nocopy ame_util.stringList,
83: attributeValues1Out out nocopy ame_util.attributeValueList,
84: attributeValues2Out out nocopy ame_util.attributeValueList,
85: attributeValues3Out out nocopy ame_util.attributeValueList) as
86: cursor attValueCursor(applicationIdIn in integer,

Line 83: attributeValues1Out out nocopy ame_util.attributeValueList,

79: attributeIdsOut out nocopy ame_util.idList,
80: attributeNamesOut out nocopy ame_util.stringList,
81: attributeTypesOut out nocopy ame_util.stringList,
82: isMandatoryOut out nocopy ame_util.stringList,
83: attributeValues1Out out nocopy ame_util.attributeValueList,
84: attributeValues2Out out nocopy ame_util.attributeValueList,
85: attributeValues3Out out nocopy ame_util.attributeValueList) as
86: cursor attValueCursor(applicationIdIn in integer,
87: transactionIdIn in varchar2,

Line 84: attributeValues2Out out nocopy ame_util.attributeValueList,

80: attributeNamesOut out nocopy ame_util.stringList,
81: attributeTypesOut out nocopy ame_util.stringList,
82: isMandatoryOut out nocopy ame_util.stringList,
83: attributeValues1Out out nocopy ame_util.attributeValueList,
84: attributeValues2Out out nocopy ame_util.attributeValueList,
85: attributeValues3Out out nocopy ame_util.attributeValueList) as
86: cursor attValueCursor(applicationIdIn in integer,
87: transactionIdIn in varchar2,
88: itemIdIn in varchar2) is

Line 85: attributeValues3Out out nocopy ame_util.attributeValueList) as

81: attributeTypesOut out nocopy ame_util.stringList,
82: isMandatoryOut out nocopy ame_util.stringList,
83: attributeValues1Out out nocopy ame_util.attributeValueList,
84: attributeValues2Out out nocopy ame_util.attributeValueList,
85: attributeValues3Out out nocopy ame_util.attributeValueList) as
86: cursor attValueCursor(applicationIdIn in integer,
87: transactionIdIn in varchar2,
88: itemIdIn in varchar2) is
89: select

Line 120: attributeIdsOut := ame_util.emptyIdList;

116: attributeValues2Out(outputIndex) := tempAttValue.attribute_value_2;
117: attributeValues3Out(outputIndex) := tempAttValue.attribute_value_3;
118: end loop;
119: if(outputIndex = 0) then
120: attributeIdsOut := ame_util.emptyIdList;
121: attributeNamesOut := ame_util.emptyStringList;
122: attributeTypesOut := ame_util.emptyStringList;
123: isMandatoryOut := ame_util.emptyStringList;
124: attributeValues1Out := ame_util.emptyAttributeValueList;

Line 121: attributeNamesOut := ame_util.emptyStringList;

117: attributeValues3Out(outputIndex) := tempAttValue.attribute_value_3;
118: end loop;
119: if(outputIndex = 0) then
120: attributeIdsOut := ame_util.emptyIdList;
121: attributeNamesOut := ame_util.emptyStringList;
122: attributeTypesOut := ame_util.emptyStringList;
123: isMandatoryOut := ame_util.emptyStringList;
124: attributeValues1Out := ame_util.emptyAttributeValueList;
125: attributeValues2Out := ame_util.emptyAttributeValueList;

Line 122: attributeTypesOut := ame_util.emptyStringList;

118: end loop;
119: if(outputIndex = 0) then
120: attributeIdsOut := ame_util.emptyIdList;
121: attributeNamesOut := ame_util.emptyStringList;
122: attributeTypesOut := ame_util.emptyStringList;
123: isMandatoryOut := ame_util.emptyStringList;
124: attributeValues1Out := ame_util.emptyAttributeValueList;
125: attributeValues2Out := ame_util.emptyAttributeValueList;
126: attributeValues3Out := ame_util.emptyAttributeValueList;

Line 123: isMandatoryOut := ame_util.emptyStringList;

119: if(outputIndex = 0) then
120: attributeIdsOut := ame_util.emptyIdList;
121: attributeNamesOut := ame_util.emptyStringList;
122: attributeTypesOut := ame_util.emptyStringList;
123: isMandatoryOut := ame_util.emptyStringList;
124: attributeValues1Out := ame_util.emptyAttributeValueList;
125: attributeValues2Out := ame_util.emptyAttributeValueList;
126: attributeValues3Out := ame_util.emptyAttributeValueList;
127: end if;

Line 124: attributeValues1Out := ame_util.emptyAttributeValueList;

120: attributeIdsOut := ame_util.emptyIdList;
121: attributeNamesOut := ame_util.emptyStringList;
122: attributeTypesOut := ame_util.emptyStringList;
123: isMandatoryOut := ame_util.emptyStringList;
124: attributeValues1Out := ame_util.emptyAttributeValueList;
125: attributeValues2Out := ame_util.emptyAttributeValueList;
126: attributeValues3Out := ame_util.emptyAttributeValueList;
127: end if;
128: exception

Line 125: attributeValues2Out := ame_util.emptyAttributeValueList;

121: attributeNamesOut := ame_util.emptyStringList;
122: attributeTypesOut := ame_util.emptyStringList;
123: isMandatoryOut := ame_util.emptyStringList;
124: attributeValues1Out := ame_util.emptyAttributeValueList;
125: attributeValues2Out := ame_util.emptyAttributeValueList;
126: attributeValues3Out := ame_util.emptyAttributeValueList;
127: end if;
128: exception
129: when others then

Line 126: attributeValues3Out := ame_util.emptyAttributeValueList;

122: attributeTypesOut := ame_util.emptyStringList;
123: isMandatoryOut := ame_util.emptyStringList;
124: attributeValues1Out := ame_util.emptyAttributeValueList;
125: attributeValues2Out := ame_util.emptyAttributeValueList;
126: attributeValues3Out := ame_util.emptyAttributeValueList;
127: end if;
128: exception
129: when others then
130: rollback;

Line 131: attributeIdsOut := ame_util.emptyIdList;

127: end if;
128: exception
129: when others then
130: rollback;
131: attributeIdsOut := ame_util.emptyIdList;
132: attributeNamesOut := ame_util.emptyStringList;
133: attributeTypesOut := ame_util.emptyStringList;
134: isMandatoryOut := ame_util.emptyStringList;
135: attributeValues1Out := ame_util.emptyAttributeValueList;

Line 132: attributeNamesOut := ame_util.emptyStringList;

128: exception
129: when others then
130: rollback;
131: attributeIdsOut := ame_util.emptyIdList;
132: attributeNamesOut := ame_util.emptyStringList;
133: attributeTypesOut := ame_util.emptyStringList;
134: isMandatoryOut := ame_util.emptyStringList;
135: attributeValues1Out := ame_util.emptyAttributeValueList;
136: attributeValues2Out := ame_util.emptyAttributeValueList;

Line 133: attributeTypesOut := ame_util.emptyStringList;

129: when others then
130: rollback;
131: attributeIdsOut := ame_util.emptyIdList;
132: attributeNamesOut := ame_util.emptyStringList;
133: attributeTypesOut := ame_util.emptyStringList;
134: isMandatoryOut := ame_util.emptyStringList;
135: attributeValues1Out := ame_util.emptyAttributeValueList;
136: attributeValues2Out := ame_util.emptyAttributeValueList;
137: attributeValues3Out := ame_util.emptyAttributeValueList;

Line 134: isMandatoryOut := ame_util.emptyStringList;

130: rollback;
131: attributeIdsOut := ame_util.emptyIdList;
132: attributeNamesOut := ame_util.emptyStringList;
133: attributeTypesOut := ame_util.emptyStringList;
134: isMandatoryOut := ame_util.emptyStringList;
135: attributeValues1Out := ame_util.emptyAttributeValueList;
136: attributeValues2Out := ame_util.emptyAttributeValueList;
137: attributeValues3Out := ame_util.emptyAttributeValueList;
138: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

Line 135: attributeValues1Out := ame_util.emptyAttributeValueList;

131: attributeIdsOut := ame_util.emptyIdList;
132: attributeNamesOut := ame_util.emptyStringList;
133: attributeTypesOut := ame_util.emptyStringList;
134: isMandatoryOut := ame_util.emptyStringList;
135: attributeValues1Out := ame_util.emptyAttributeValueList;
136: attributeValues2Out := ame_util.emptyAttributeValueList;
137: attributeValues3Out := ame_util.emptyAttributeValueList;
138: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
139: routineNameIn => 'getAllAttributeValues',

Line 136: attributeValues2Out := ame_util.emptyAttributeValueList;

132: attributeNamesOut := ame_util.emptyStringList;
133: attributeTypesOut := ame_util.emptyStringList;
134: isMandatoryOut := ame_util.emptyStringList;
135: attributeValues1Out := ame_util.emptyAttributeValueList;
136: attributeValues2Out := ame_util.emptyAttributeValueList;
137: attributeValues3Out := ame_util.emptyAttributeValueList;
138: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
139: routineNameIn => 'getAllAttributeValues',
140: exceptionNumberIn => sqlcode,

Line 137: attributeValues3Out := ame_util.emptyAttributeValueList;

133: attributeTypesOut := ame_util.emptyStringList;
134: isMandatoryOut := ame_util.emptyStringList;
135: attributeValues1Out := ame_util.emptyAttributeValueList;
136: attributeValues2Out := ame_util.emptyAttributeValueList;
137: attributeValues3Out := ame_util.emptyAttributeValueList;
138: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
139: routineNameIn => 'getAllAttributeValues',
140: exceptionNumberIn => sqlcode,
141: exceptionStringIn => sqlerrm);

Line 138: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

134: isMandatoryOut := ame_util.emptyStringList;
135: attributeValues1Out := ame_util.emptyAttributeValueList;
136: attributeValues2Out := ame_util.emptyAttributeValueList;
137: attributeValues3Out := ame_util.emptyAttributeValueList;
138: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
139: routineNameIn => 'getAllAttributeValues',
140: exceptionNumberIn => sqlcode,
141: exceptionStringIn => sqlerrm);
142: raise;

Line 148: attributeIdsOut out nocopy ame_util.idList,

144: procedure getAllAttributeValues2(applicationIdIn in integer,
145: transactionIdIn in varchar2,
146: itemClassIdIn in integer,
147: itemIdIn in varchar2 default null,
148: attributeIdsOut out nocopy ame_util.idList,
149: attributeNamesOut out nocopy ame_util.stringList,
150: attributeTypesOut out nocopy ame_util.stringList,
151: isMandatoryOut out nocopy ame_util.stringList,
152: attributeValues1Out out nocopy ame_util.attributeValueList,

Line 149: attributeNamesOut out nocopy ame_util.stringList,

145: transactionIdIn in varchar2,
146: itemClassIdIn in integer,
147: itemIdIn in varchar2 default null,
148: attributeIdsOut out nocopy ame_util.idList,
149: attributeNamesOut out nocopy ame_util.stringList,
150: attributeTypesOut out nocopy ame_util.stringList,
151: isMandatoryOut out nocopy ame_util.stringList,
152: attributeValues1Out out nocopy ame_util.attributeValueList,
153: attributeValues2Out out nocopy ame_util.attributeValueList,

Line 150: attributeTypesOut out nocopy ame_util.stringList,

146: itemClassIdIn in integer,
147: itemIdIn in varchar2 default null,
148: attributeIdsOut out nocopy ame_util.idList,
149: attributeNamesOut out nocopy ame_util.stringList,
150: attributeTypesOut out nocopy ame_util.stringList,
151: isMandatoryOut out nocopy ame_util.stringList,
152: attributeValues1Out out nocopy ame_util.attributeValueList,
153: attributeValues2Out out nocopy ame_util.attributeValueList,
154: attributeValues3Out out nocopy ame_util.attributeValueList) as

Line 151: isMandatoryOut out nocopy ame_util.stringList,

147: itemIdIn in varchar2 default null,
148: attributeIdsOut out nocopy ame_util.idList,
149: attributeNamesOut out nocopy ame_util.stringList,
150: attributeTypesOut out nocopy ame_util.stringList,
151: isMandatoryOut out nocopy ame_util.stringList,
152: attributeValues1Out out nocopy ame_util.attributeValueList,
153: attributeValues2Out out nocopy ame_util.attributeValueList,
154: attributeValues3Out out nocopy ame_util.attributeValueList) as
155: cursor attValueCursor(applicationIdIn in integer,

Line 152: attributeValues1Out out nocopy ame_util.attributeValueList,

148: attributeIdsOut out nocopy ame_util.idList,
149: attributeNamesOut out nocopy ame_util.stringList,
150: attributeTypesOut out nocopy ame_util.stringList,
151: isMandatoryOut out nocopy ame_util.stringList,
152: attributeValues1Out out nocopy ame_util.attributeValueList,
153: attributeValues2Out out nocopy ame_util.attributeValueList,
154: attributeValues3Out out nocopy ame_util.attributeValueList) as
155: cursor attValueCursor(applicationIdIn in integer,
156: transactionIdIn in varchar2,

Line 153: attributeValues2Out out nocopy ame_util.attributeValueList,

149: attributeNamesOut out nocopy ame_util.stringList,
150: attributeTypesOut out nocopy ame_util.stringList,
151: isMandatoryOut out nocopy ame_util.stringList,
152: attributeValues1Out out nocopy ame_util.attributeValueList,
153: attributeValues2Out out nocopy ame_util.attributeValueList,
154: attributeValues3Out out nocopy ame_util.attributeValueList) as
155: cursor attValueCursor(applicationIdIn in integer,
156: transactionIdIn in varchar2,
157: itemClassIdIn in integer,

Line 154: attributeValues3Out out nocopy ame_util.attributeValueList) as

150: attributeTypesOut out nocopy ame_util.stringList,
151: isMandatoryOut out nocopy ame_util.stringList,
152: attributeValues1Out out nocopy ame_util.attributeValueList,
153: attributeValues2Out out nocopy ame_util.attributeValueList,
154: attributeValues3Out out nocopy ame_util.attributeValueList) as
155: cursor attValueCursor(applicationIdIn in integer,
156: transactionIdIn in varchar2,
157: itemClassIdIn in integer,
158: itemIdIn in varchar2) is

Line 192: attributeIdsOut := ame_util.emptyIdList;

188: attributeValues2Out(outputIndex) := tempAttValue.attribute_value_2;
189: attributeValues3Out(outputIndex) := tempAttValue.attribute_value_3;
190: end loop;
191: if(outputIndex = 0) then
192: attributeIdsOut := ame_util.emptyIdList;
193: attributeNamesOut := ame_util.emptyStringList;
194: attributeTypesOut := ame_util.emptyStringList;
195: isMandatoryOut := ame_util.emptyStringList;
196: attributeValues1Out := ame_util.emptyAttributeValueList;

Line 193: attributeNamesOut := ame_util.emptyStringList;

189: attributeValues3Out(outputIndex) := tempAttValue.attribute_value_3;
190: end loop;
191: if(outputIndex = 0) then
192: attributeIdsOut := ame_util.emptyIdList;
193: attributeNamesOut := ame_util.emptyStringList;
194: attributeTypesOut := ame_util.emptyStringList;
195: isMandatoryOut := ame_util.emptyStringList;
196: attributeValues1Out := ame_util.emptyAttributeValueList;
197: attributeValues2Out := ame_util.emptyAttributeValueList;

Line 194: attributeTypesOut := ame_util.emptyStringList;

190: end loop;
191: if(outputIndex = 0) then
192: attributeIdsOut := ame_util.emptyIdList;
193: attributeNamesOut := ame_util.emptyStringList;
194: attributeTypesOut := ame_util.emptyStringList;
195: isMandatoryOut := ame_util.emptyStringList;
196: attributeValues1Out := ame_util.emptyAttributeValueList;
197: attributeValues2Out := ame_util.emptyAttributeValueList;
198: attributeValues3Out := ame_util.emptyAttributeValueList;

Line 195: isMandatoryOut := ame_util.emptyStringList;

191: if(outputIndex = 0) then
192: attributeIdsOut := ame_util.emptyIdList;
193: attributeNamesOut := ame_util.emptyStringList;
194: attributeTypesOut := ame_util.emptyStringList;
195: isMandatoryOut := ame_util.emptyStringList;
196: attributeValues1Out := ame_util.emptyAttributeValueList;
197: attributeValues2Out := ame_util.emptyAttributeValueList;
198: attributeValues3Out := ame_util.emptyAttributeValueList;
199: end if;

Line 196: attributeValues1Out := ame_util.emptyAttributeValueList;

192: attributeIdsOut := ame_util.emptyIdList;
193: attributeNamesOut := ame_util.emptyStringList;
194: attributeTypesOut := ame_util.emptyStringList;
195: isMandatoryOut := ame_util.emptyStringList;
196: attributeValues1Out := ame_util.emptyAttributeValueList;
197: attributeValues2Out := ame_util.emptyAttributeValueList;
198: attributeValues3Out := ame_util.emptyAttributeValueList;
199: end if;
200: exception

Line 197: attributeValues2Out := ame_util.emptyAttributeValueList;

193: attributeNamesOut := ame_util.emptyStringList;
194: attributeTypesOut := ame_util.emptyStringList;
195: isMandatoryOut := ame_util.emptyStringList;
196: attributeValues1Out := ame_util.emptyAttributeValueList;
197: attributeValues2Out := ame_util.emptyAttributeValueList;
198: attributeValues3Out := ame_util.emptyAttributeValueList;
199: end if;
200: exception
201: when others then

Line 198: attributeValues3Out := ame_util.emptyAttributeValueList;

194: attributeTypesOut := ame_util.emptyStringList;
195: isMandatoryOut := ame_util.emptyStringList;
196: attributeValues1Out := ame_util.emptyAttributeValueList;
197: attributeValues2Out := ame_util.emptyAttributeValueList;
198: attributeValues3Out := ame_util.emptyAttributeValueList;
199: end if;
200: exception
201: when others then
202: rollback;

Line 203: attributeIdsOut := ame_util.emptyIdList;

199: end if;
200: exception
201: when others then
202: rollback;
203: attributeIdsOut := ame_util.emptyIdList;
204: attributeNamesOut := ame_util.emptyStringList;
205: attributeTypesOut := ame_util.emptyStringList;
206: isMandatoryOut := ame_util.emptyStringList;
207: attributeValues1Out := ame_util.emptyAttributeValueList;

Line 204: attributeNamesOut := ame_util.emptyStringList;

200: exception
201: when others then
202: rollback;
203: attributeIdsOut := ame_util.emptyIdList;
204: attributeNamesOut := ame_util.emptyStringList;
205: attributeTypesOut := ame_util.emptyStringList;
206: isMandatoryOut := ame_util.emptyStringList;
207: attributeValues1Out := ame_util.emptyAttributeValueList;
208: attributeValues2Out := ame_util.emptyAttributeValueList;

Line 205: attributeTypesOut := ame_util.emptyStringList;

201: when others then
202: rollback;
203: attributeIdsOut := ame_util.emptyIdList;
204: attributeNamesOut := ame_util.emptyStringList;
205: attributeTypesOut := ame_util.emptyStringList;
206: isMandatoryOut := ame_util.emptyStringList;
207: attributeValues1Out := ame_util.emptyAttributeValueList;
208: attributeValues2Out := ame_util.emptyAttributeValueList;
209: attributeValues3Out := ame_util.emptyAttributeValueList;

Line 206: isMandatoryOut := ame_util.emptyStringList;

202: rollback;
203: attributeIdsOut := ame_util.emptyIdList;
204: attributeNamesOut := ame_util.emptyStringList;
205: attributeTypesOut := ame_util.emptyStringList;
206: isMandatoryOut := ame_util.emptyStringList;
207: attributeValues1Out := ame_util.emptyAttributeValueList;
208: attributeValues2Out := ame_util.emptyAttributeValueList;
209: attributeValues3Out := ame_util.emptyAttributeValueList;
210: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

Line 207: attributeValues1Out := ame_util.emptyAttributeValueList;

203: attributeIdsOut := ame_util.emptyIdList;
204: attributeNamesOut := ame_util.emptyStringList;
205: attributeTypesOut := ame_util.emptyStringList;
206: isMandatoryOut := ame_util.emptyStringList;
207: attributeValues1Out := ame_util.emptyAttributeValueList;
208: attributeValues2Out := ame_util.emptyAttributeValueList;
209: attributeValues3Out := ame_util.emptyAttributeValueList;
210: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
211: routineNameIn => 'getAllAttributeValues2',

Line 208: attributeValues2Out := ame_util.emptyAttributeValueList;

204: attributeNamesOut := ame_util.emptyStringList;
205: attributeTypesOut := ame_util.emptyStringList;
206: isMandatoryOut := ame_util.emptyStringList;
207: attributeValues1Out := ame_util.emptyAttributeValueList;
208: attributeValues2Out := ame_util.emptyAttributeValueList;
209: attributeValues3Out := ame_util.emptyAttributeValueList;
210: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
211: routineNameIn => 'getAllAttributeValues2',
212: exceptionNumberIn => sqlcode,

Line 209: attributeValues3Out := ame_util.emptyAttributeValueList;

205: attributeTypesOut := ame_util.emptyStringList;
206: isMandatoryOut := ame_util.emptyStringList;
207: attributeValues1Out := ame_util.emptyAttributeValueList;
208: attributeValues2Out := ame_util.emptyAttributeValueList;
209: attributeValues3Out := ame_util.emptyAttributeValueList;
210: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
211: routineNameIn => 'getAllAttributeValues2',
212: exceptionNumberIn => sqlcode,
213: exceptionStringIn => sqlerrm);

Line 210: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

206: isMandatoryOut := ame_util.emptyStringList;
207: attributeValues1Out := ame_util.emptyAttributeValueList;
208: attributeValues2Out := ame_util.emptyAttributeValueList;
209: attributeValues3Out := ame_util.emptyAttributeValueList;
210: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
211: routineNameIn => 'getAllAttributeValues2',
212: exceptionNumberIn => sqlcode,
213: exceptionStringIn => sqlerrm);
214: raise;

Line 220: ruleItemClassIdsOut out nocopy ame_util.idList,

216: procedure getApplicableRules(applicationIdIn in integer,
217: transactionIdIn in varchar2,
218: ruleListVersionIn in integer,
219: testOrRealTransTypeIn in varchar2,
220: ruleItemClassIdsOut out nocopy ame_util.idList,
221: itemClassIdsOut out nocopy ame_util.idList,
222: itemIdsOut out nocopy ame_util.stringList,
223: ruleTypesOut out nocopy ame_util.idList,
224: ruleDescriptionsOut out nocopy ame_util.stringList,

Line 221: itemClassIdsOut out nocopy ame_util.idList,

217: transactionIdIn in varchar2,
218: ruleListVersionIn in integer,
219: testOrRealTransTypeIn in varchar2,
220: ruleItemClassIdsOut out nocopy ame_util.idList,
221: itemClassIdsOut out nocopy ame_util.idList,
222: itemIdsOut out nocopy ame_util.stringList,
223: ruleTypesOut out nocopy ame_util.idList,
224: ruleDescriptionsOut out nocopy ame_util.stringList,
225: ruleIdsOut out nocopy ame_util.idList) as

Line 222: itemIdsOut out nocopy ame_util.stringList,

218: ruleListVersionIn in integer,
219: testOrRealTransTypeIn in varchar2,
220: ruleItemClassIdsOut out nocopy ame_util.idList,
221: itemClassIdsOut out nocopy ame_util.idList,
222: itemIdsOut out nocopy ame_util.stringList,
223: ruleTypesOut out nocopy ame_util.idList,
224: ruleDescriptionsOut out nocopy ame_util.stringList,
225: ruleIdsOut out nocopy ame_util.idList) as
226: isTestTransaction boolean;

Line 223: ruleTypesOut out nocopy ame_util.idList,

219: testOrRealTransTypeIn in varchar2,
220: ruleItemClassIdsOut out nocopy ame_util.idList,
221: itemClassIdsOut out nocopy ame_util.idList,
222: itemIdsOut out nocopy ame_util.stringList,
223: ruleTypesOut out nocopy ame_util.idList,
224: ruleDescriptionsOut out nocopy ame_util.stringList,
225: ruleIdsOut out nocopy ame_util.idList) as
226: isTestTransaction boolean;
227: processPriorities boolean;

Line 224: ruleDescriptionsOut out nocopy ame_util.stringList,

220: ruleItemClassIdsOut out nocopy ame_util.idList,
221: itemClassIdsOut out nocopy ame_util.idList,
222: itemIdsOut out nocopy ame_util.stringList,
223: ruleTypesOut out nocopy ame_util.idList,
224: ruleDescriptionsOut out nocopy ame_util.stringList,
225: ruleIdsOut out nocopy ame_util.idList) as
226: isTestTransaction boolean;
227: processPriorities boolean;
228: processProductionActions boolean;

Line 225: ruleIdsOut out nocopy ame_util.idList) as

221: itemClassIdsOut out nocopy ame_util.idList,
222: itemIdsOut out nocopy ame_util.stringList,
223: ruleTypesOut out nocopy ame_util.idList,
224: ruleDescriptionsOut out nocopy ame_util.stringList,
225: ruleIdsOut out nocopy ame_util.idList) as
226: isTestTransaction boolean;
227: processPriorities boolean;
228: processProductionActions boolean;
229: processProductionRules boolean;

Line 230: tempConfigVarValue ame_util.stringType;

226: isTestTransaction boolean;
227: processPriorities boolean;
228: processProductionActions boolean;
229: processProductionRules boolean;
230: tempConfigVarValue ame_util.stringType;
231: begin
232: if(ruleListVersionIn = 1) then
233: /* The returned rule list does not account for priorities, exceptions,
234: or multiple actions. */

Line 245: if(testOrRealTransTypeIn = ame_util.testTrans) then

241: /* The returned rule list accounts for priorities, exceptions, and
242: multiple actions. */
243: processPriorities := true;
244: end if;
245: if(testOrRealTransTypeIn = ame_util.testTrans) then
246: isTestTransaction := true;
247: else
248: isTestTransaction := false;
249: end if;

Line 279: ruleItemClassIdsOut := ame_util.emptyIdList;

275: ruleDescriptionsOut => ruleDescriptionsOut);
276: exception
277: when others then
278: rollback;
279: ruleItemClassIdsOut := ame_util.emptyIdList;
280: itemClassIdsOut := ame_util.emptyIdList;
281: itemIdsOut := ame_util.emptyStringList;
282: ruleTypesOut := ame_util.emptyIdList;
283: ruleIdsOut := ame_util.emptyIdList;

Line 280: itemClassIdsOut := ame_util.emptyIdList;

276: exception
277: when others then
278: rollback;
279: ruleItemClassIdsOut := ame_util.emptyIdList;
280: itemClassIdsOut := ame_util.emptyIdList;
281: itemIdsOut := ame_util.emptyStringList;
282: ruleTypesOut := ame_util.emptyIdList;
283: ruleIdsOut := ame_util.emptyIdList;
284: ruleDescriptionsOut := ame_util.emptyStringList;

Line 281: itemIdsOut := ame_util.emptyStringList;

277: when others then
278: rollback;
279: ruleItemClassIdsOut := ame_util.emptyIdList;
280: itemClassIdsOut := ame_util.emptyIdList;
281: itemIdsOut := ame_util.emptyStringList;
282: ruleTypesOut := ame_util.emptyIdList;
283: ruleIdsOut := ame_util.emptyIdList;
284: ruleDescriptionsOut := ame_util.emptyStringList;
285: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

Line 282: ruleTypesOut := ame_util.emptyIdList;

278: rollback;
279: ruleItemClassIdsOut := ame_util.emptyIdList;
280: itemClassIdsOut := ame_util.emptyIdList;
281: itemIdsOut := ame_util.emptyStringList;
282: ruleTypesOut := ame_util.emptyIdList;
283: ruleIdsOut := ame_util.emptyIdList;
284: ruleDescriptionsOut := ame_util.emptyStringList;
285: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
286: routineNameIn => 'getApplicableRules',

Line 283: ruleIdsOut := ame_util.emptyIdList;

279: ruleItemClassIdsOut := ame_util.emptyIdList;
280: itemClassIdsOut := ame_util.emptyIdList;
281: itemIdsOut := ame_util.emptyStringList;
282: ruleTypesOut := ame_util.emptyIdList;
283: ruleIdsOut := ame_util.emptyIdList;
284: ruleDescriptionsOut := ame_util.emptyStringList;
285: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
286: routineNameIn => 'getApplicableRules',
287: exceptionNumberIn => sqlcode,

Line 284: ruleDescriptionsOut := ame_util.emptyStringList;

280: itemClassIdsOut := ame_util.emptyIdList;
281: itemIdsOut := ame_util.emptyStringList;
282: ruleTypesOut := ame_util.emptyIdList;
283: ruleIdsOut := ame_util.emptyIdList;
284: ruleDescriptionsOut := ame_util.emptyStringList;
285: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
286: routineNameIn => 'getApplicableRules',
287: exceptionNumberIn => sqlcode,
288: exceptionStringIn => sqlerrm);

Line 285: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

281: itemIdsOut := ame_util.emptyStringList;
282: ruleTypesOut := ame_util.emptyIdList;
283: ruleIdsOut := ame_util.emptyIdList;
284: ruleDescriptionsOut := ame_util.emptyStringList;
285: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
286: routineNameIn => 'getApplicableRules',
287: exceptionNumberIn => sqlcode,
288: exceptionStringIn => sqlerrm);
289: raise;

Line 295: attributeIdsOut out nocopy ame_util.IdList,

291: procedure getApproverAttributes(applicationIdIn in integer,
292: transactionIdIn in varchar2,
293: itemClassIdIn in integer,
294: itemIdIn in varchar2,
295: attributeIdsOut out nocopy ame_util.IdList,
296: attributeNamesOut out nocopy ame_util.stringList,
297: approverTypeIdsOut out nocopy ame_util.idList) as
298: cursor attributeCursor(applicationIdIn in integer,
299: transactionIdIn in varchar2,

Line 296: attributeNamesOut out nocopy ame_util.stringList,

292: transactionIdIn in varchar2,
293: itemClassIdIn in integer,
294: itemIdIn in varchar2,
295: attributeIdsOut out nocopy ame_util.IdList,
296: attributeNamesOut out nocopy ame_util.stringList,
297: approverTypeIdsOut out nocopy ame_util.idList) as
298: cursor attributeCursor(applicationIdIn in integer,
299: transactionIdIn in varchar2,
300: itemClassIdIn in integer,

Line 297: approverTypeIdsOut out nocopy ame_util.idList) as

293: itemClassIdIn in integer,
294: itemIdIn in varchar2,
295: attributeIdsOut out nocopy ame_util.IdList,
296: attributeNamesOut out nocopy ame_util.stringList,
297: approverTypeIdsOut out nocopy ame_util.idList) as
298: cursor attributeCursor(applicationIdIn in integer,
299: transactionIdIn in varchar2,
300: itemClassIdIn in integer,
301: itemIdIn in varchar2) is

Line 316: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)

312: ame_test_trans_att_values.application_id = applicationIdIn and
313: ame_test_trans_att_values.transaction_id = transactionIdIn and
314: ame_attributes.approver_type_id is not null and
315: sysdate between ame_attributes.start_date and
316: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
317: order by ame_attributes.name;
318: begin
319: open attributeCursor(applicationIdIn => applicationIdIn,
320: transactionIdIn => transactionIdIn,

Line 331: attributeIdsOut := ame_util.emptyIdList;

327: approverTypeIdsOut;
328: close attributeCursor;
329: exception
330: when others then
331: attributeIdsOut := ame_util.emptyIdList;
332: attributeNamesOut := ame_util.emptyStringList;
333: approverTypeIdsOut := ame_util.emptyIdList;
334: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
335: routineNameIn => 'getApproverAttributes',

Line 332: attributeNamesOut := ame_util.emptyStringList;

328: close attributeCursor;
329: exception
330: when others then
331: attributeIdsOut := ame_util.emptyIdList;
332: attributeNamesOut := ame_util.emptyStringList;
333: approverTypeIdsOut := ame_util.emptyIdList;
334: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
335: routineNameIn => 'getApproverAttributes',
336: exceptionNumberIn => sqlcode,

Line 333: approverTypeIdsOut := ame_util.emptyIdList;

329: exception
330: when others then
331: attributeIdsOut := ame_util.emptyIdList;
332: attributeNamesOut := ame_util.emptyStringList;
333: approverTypeIdsOut := ame_util.emptyIdList;
334: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
335: routineNameIn => 'getApproverAttributes',
336: exceptionNumberIn => sqlcode,
337: exceptionStringIn => sqlerrm);

Line 334: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

330: when others then
331: attributeIdsOut := ame_util.emptyIdList;
332: attributeNamesOut := ame_util.emptyStringList;
333: approverTypeIdsOut := ame_util.emptyIdList;
334: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
335: routineNameIn => 'getApproverAttributes',
336: exceptionNumberIn => sqlcode,
337: exceptionStringIn => sqlerrm);
338: raise;

Line 344: approverListOut out nocopy ame_util.approversTable2,

340: procedure getApproverList(applicationIdIn in integer,
341: transactionIdIn in varchar2,
342: testOrRealTransTypeIn in varchar2,
343: approverListStageIn in integer,
344: approverListOut out nocopy ame_util.approversTable2,
345: productionIndexesOut out nocopy ame_util.idList,
346: variableNamesOut out nocopy ame_util.stringList,
347: variableValuesOut out nocopy ame_util.stringList,
348: doRepeatSubstitutionsOut out nocopy varchar2) as

Line 345: productionIndexesOut out nocopy ame_util.idList,

341: transactionIdIn in varchar2,
342: testOrRealTransTypeIn in varchar2,
343: approverListStageIn in integer,
344: approverListOut out nocopy ame_util.approversTable2,
345: productionIndexesOut out nocopy ame_util.idList,
346: variableNamesOut out nocopy ame_util.stringList,
347: variableValuesOut out nocopy ame_util.stringList,
348: doRepeatSubstitutionsOut out nocopy varchar2) as
349: errorCode integer;

Line 346: variableNamesOut out nocopy ame_util.stringList,

342: testOrRealTransTypeIn in varchar2,
343: approverListStageIn in integer,
344: approverListOut out nocopy ame_util.approversTable2,
345: productionIndexesOut out nocopy ame_util.idList,
346: variableNamesOut out nocopy ame_util.stringList,
347: variableValuesOut out nocopy ame_util.stringList,
348: doRepeatSubstitutionsOut out nocopy varchar2) as
349: errorCode integer;
350: errorMessage ame_util.longestStringType;

Line 347: variableValuesOut out nocopy ame_util.stringList,

343: approverListStageIn in integer,
344: approverListOut out nocopy ame_util.approversTable2,
345: productionIndexesOut out nocopy ame_util.idList,
346: variableNamesOut out nocopy ame_util.stringList,
347: variableValuesOut out nocopy ame_util.stringList,
348: doRepeatSubstitutionsOut out nocopy varchar2) as
349: errorCode integer;
350: errorMessage ame_util.longestStringType;
351: isTestTransaction boolean;

Line 350: errorMessage ame_util.longestStringType;

346: variableNamesOut out nocopy ame_util.stringList,
347: variableValuesOut out nocopy ame_util.stringList,
348: doRepeatSubstitutionsOut out nocopy varchar2) as
349: errorCode integer;
350: errorMessage ame_util.longestStringType;
351: isTestTransaction boolean;
352: processProductionActions boolean;
353: processProductionRules boolean;
354: stageException exception;

Line 355: tempConfigVarValue ame_util.stringType;

351: isTestTransaction boolean;
352: processProductionActions boolean;
353: processProductionRules boolean;
354: stageException exception;
355: tempConfigVarValue ame_util.stringType;
356: begin
357: if(approverListStageIn < 1 or approverListStageIn > 6) then
358: raise stageException;
359: end if;

Line 360: ame_engine.getTestTransApprovers(isTestTransactionIn => testOrRealTransTypeIn = ame_util.testTrans,

356: begin
357: if(approverListStageIn < 1 or approverListStageIn > 6) then
358: raise stageException;
359: end if;
360: ame_engine.getTestTransApprovers(isTestTransactionIn => testOrRealTransTypeIn = ame_util.testTrans,
361: transactionIdIn => transactionIdIn,
362: ameApplicationIdIn => applicationIdIn,
363: approverListStageIn => approverListStageIn,
364: approversOut => approverListOut,

Line 368: doRepeatSubstitutionsOut := ame_engine.getHeaderAttValue2(attributeNameIn=> ame_util.repeatSubstitutionsAttribute);

364: approversOut => approverListOut,
365: productionIndexesOut => productionIndexesOut,
366: variableNamesOut => variableNamesOut,
367: variableValuesOut => variableValuesOut);
368: doRepeatSubstitutionsOut := ame_engine.getHeaderAttValue2(attributeNameIn=> ame_util.repeatSubstitutionsAttribute);
369: exception
370: when stageException then
371: errorCode := -20001;
372: errorMessage :=

Line 373: ame_util.getMessage(applicationShortNameIn => 'PER',

369: exception
370: when stageException then
371: errorCode := -20001;
372: errorMessage :=
373: ame_util.getMessage(applicationShortNameIn => 'PER',
374: messageNameIn =>'AME_400452_APPR_STAGE_INT');
375: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
376: routineNameIn => 'getApproverList',
377: exceptionNumberIn => errorCode,

Line 375: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

371: errorCode := -20001;
372: errorMessage :=
373: ame_util.getMessage(applicationShortNameIn => 'PER',
374: messageNameIn =>'AME_400452_APPR_STAGE_INT');
375: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
376: routineNameIn => 'getApproverList',
377: exceptionNumberIn => errorCode,
378: exceptionStringIn => errorMessage);
379: raise_application_error(errorCode,

Line 382: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

378: exceptionStringIn => errorMessage);
379: raise_application_error(errorCode,
380: errorMessage);
381: when others then
382: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
383: routineNameIn => 'getApproverList',
384: exceptionNumberIn => sqlcode,
385: exceptionStringIn => sqlerrm);
386: approverListOut := ame_util.emptyApproversTable2;

Line 386: approverListOut := ame_util.emptyApproversTable2;

382: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
383: routineNameIn => 'getApproverList',
384: exceptionNumberIn => sqlcode,
385: exceptionStringIn => sqlerrm);
386: approverListOut := ame_util.emptyApproversTable2;
387: raise;
388: end getApproverList;
389: procedure getItemAttributeValues(applicationIdIn in integer,
390: transactionIdIn in varchar2,

Line 394: attributeNamesOut out nocopy ame_util.stringList,

390: transactionIdIn in varchar2,
391: itemClassIdIn in integer,
392: itemIdIn in varchar2,
393: testOrRealTransTypeIn in varchar2,
394: attributeNamesOut out nocopy ame_util.stringList,
395: attributeTypesOut out nocopy ame_util.stringList,
396: attributeValuesOut1 out nocopy ame_util.attributeValueList,
397: attributeValuesOut2 out nocopy ame_util.attributeValueList,
398: attributeValuesOut3 out nocopy ame_util.attributeValueList) as

Line 395: attributeTypesOut out nocopy ame_util.stringList,

391: itemClassIdIn in integer,
392: itemIdIn in varchar2,
393: testOrRealTransTypeIn in varchar2,
394: attributeNamesOut out nocopy ame_util.stringList,
395: attributeTypesOut out nocopy ame_util.stringList,
396: attributeValuesOut1 out nocopy ame_util.attributeValueList,
397: attributeValuesOut2 out nocopy ame_util.attributeValueList,
398: attributeValuesOut3 out nocopy ame_util.attributeValueList) as
399: attributeIds ame_util.idList;

Line 396: attributeValuesOut1 out nocopy ame_util.attributeValueList,

392: itemIdIn in varchar2,
393: testOrRealTransTypeIn in varchar2,
394: attributeNamesOut out nocopy ame_util.stringList,
395: attributeTypesOut out nocopy ame_util.stringList,
396: attributeValuesOut1 out nocopy ame_util.attributeValueList,
397: attributeValuesOut2 out nocopy ame_util.attributeValueList,
398: attributeValuesOut3 out nocopy ame_util.attributeValueList) as
399: attributeIds ame_util.idList;
400: attributeNames ame_util.stringList;

Line 397: attributeValuesOut2 out nocopy ame_util.attributeValueList,

393: testOrRealTransTypeIn in varchar2,
394: attributeNamesOut out nocopy ame_util.stringList,
395: attributeTypesOut out nocopy ame_util.stringList,
396: attributeValuesOut1 out nocopy ame_util.attributeValueList,
397: attributeValuesOut2 out nocopy ame_util.attributeValueList,
398: attributeValuesOut3 out nocopy ame_util.attributeValueList) as
399: attributeIds ame_util.idList;
400: attributeNames ame_util.stringList;
401: attributeTypes ame_util.stringList;

Line 398: attributeValuesOut3 out nocopy ame_util.attributeValueList) as

394: attributeNamesOut out nocopy ame_util.stringList,
395: attributeTypesOut out nocopy ame_util.stringList,
396: attributeValuesOut1 out nocopy ame_util.attributeValueList,
397: attributeValuesOut2 out nocopy ame_util.attributeValueList,
398: attributeValuesOut3 out nocopy ame_util.attributeValueList) as
399: attributeIds ame_util.idList;
400: attributeNames ame_util.stringList;
401: attributeTypes ame_util.stringList;
402: isTestTransaction boolean;

Line 399: attributeIds ame_util.idList;

395: attributeTypesOut out nocopy ame_util.stringList,
396: attributeValuesOut1 out nocopy ame_util.attributeValueList,
397: attributeValuesOut2 out nocopy ame_util.attributeValueList,
398: attributeValuesOut3 out nocopy ame_util.attributeValueList) as
399: attributeIds ame_util.idList;
400: attributeNames ame_util.stringList;
401: attributeTypes ame_util.stringList;
402: isTestTransaction boolean;
403: outputIndex integer;

Line 400: attributeNames ame_util.stringList;

396: attributeValuesOut1 out nocopy ame_util.attributeValueList,
397: attributeValuesOut2 out nocopy ame_util.attributeValueList,
398: attributeValuesOut3 out nocopy ame_util.attributeValueList) as
399: attributeIds ame_util.idList;
400: attributeNames ame_util.stringList;
401: attributeTypes ame_util.stringList;
402: isTestTransaction boolean;
403: outputIndex integer;
404: begin

Line 401: attributeTypes ame_util.stringList;

397: attributeValuesOut2 out nocopy ame_util.attributeValueList,
398: attributeValuesOut3 out nocopy ame_util.attributeValueList) as
399: attributeIds ame_util.idList;
400: attributeNames ame_util.stringList;
401: attributeTypes ame_util.stringList;
402: isTestTransaction boolean;
403: outputIndex integer;
404: begin
405: ame_attribute_pkg.getSubordinateICAttributes2(applicationIdIn => applicationIdIn,

Line 411: if(testOrRealTransTypeIn = ame_util.testTrans) then

407: attributeIdsOut => attributeIds,
408: attributeNamesOut => attributeNames,
409: attributeTypesOut => attributeTypes);
410: outputIndex := 0; /* pre-increment */
411: if(testOrRealTransTypeIn = ame_util.testTrans) then
412: isTestTransaction := true;
413: else
414: isTestTransaction := false;
415: end if;

Line 448: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

444: attributeValue3Out => attributeValuesOut3(outputIndex));
445: end loop;
446: exception
447: when others then
448: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
449: routineNameIn => 'getItemAttributeValues',
450: exceptionNumberIn => sqlcode,
451: exceptionStringIn => sqlerrm);
452: attributeNamesOut := ame_util.emptyStringList;

Line 452: attributeNamesOut := ame_util.emptyStringList;

448: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
449: routineNameIn => 'getItemAttributeValues',
450: exceptionNumberIn => sqlcode,
451: exceptionStringIn => sqlerrm);
452: attributeNamesOut := ame_util.emptyStringList;
453: attributeValuesOut1 := ame_util.emptyAttributeValueList;
454: attributeValuesOut2 := ame_util.emptyAttributeValueList;
455: attributeValuesOut3 := ame_util.emptyAttributeValueList;
456: raise;

Line 453: attributeValuesOut1 := ame_util.emptyAttributeValueList;

449: routineNameIn => 'getItemAttributeValues',
450: exceptionNumberIn => sqlcode,
451: exceptionStringIn => sqlerrm);
452: attributeNamesOut := ame_util.emptyStringList;
453: attributeValuesOut1 := ame_util.emptyAttributeValueList;
454: attributeValuesOut2 := ame_util.emptyAttributeValueList;
455: attributeValuesOut3 := ame_util.emptyAttributeValueList;
456: raise;
457: end getItemAttributeValues;

Line 454: attributeValuesOut2 := ame_util.emptyAttributeValueList;

450: exceptionNumberIn => sqlcode,
451: exceptionStringIn => sqlerrm);
452: attributeNamesOut := ame_util.emptyStringList;
453: attributeValuesOut1 := ame_util.emptyAttributeValueList;
454: attributeValuesOut2 := ame_util.emptyAttributeValueList;
455: attributeValuesOut3 := ame_util.emptyAttributeValueList;
456: raise;
457: end getItemAttributeValues;
458: procedure getItemIds(applicationIdIn in integer,

Line 455: attributeValuesOut3 := ame_util.emptyAttributeValueList;

451: exceptionStringIn => sqlerrm);
452: attributeNamesOut := ame_util.emptyStringList;
453: attributeValuesOut1 := ame_util.emptyAttributeValueList;
454: attributeValuesOut2 := ame_util.emptyAttributeValueList;
455: attributeValuesOut3 := ame_util.emptyAttributeValueList;
456: raise;
457: end getItemAttributeValues;
458: procedure getItemIds(applicationIdIn in integer,
459: transactionIdIn in varchar2,

Line 461: itemIdsOut out nocopy ame_util.stringList) as

457: end getItemAttributeValues;
458: procedure getItemIds(applicationIdIn in integer,
459: transactionIdIn in varchar2,
460: itemClassIdIn in integer,
461: itemIdsOut out nocopy ame_util.stringList) as
462: cursor itemIdCursor(applicationIdIn in integer,
463: transactionIdIn in varchar2,
464: itemClassIdIn in integer) is
465: select distinct item_id

Line 483: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

479: close itemIdCursor;
480: exception
481: when others then
482: rollback;
483: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
484: routineNameIn => 'getitemIds',
485: exceptionNumberIn => sqlcode,
486: exceptionStringIn => sqlerrm);
487: itemIdsOut := ame_util.emptyStringList;

Line 487: itemIdsOut := ame_util.emptyStringList;

483: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
484: routineNameIn => 'getitemIds',
485: exceptionNumberIn => sqlcode,
486: exceptionStringIn => sqlerrm);
487: itemIdsOut := ame_util.emptyStringList;
488: raise;
489: end getitemIds;
490: procedure getTransactionProductions(applicationIdIn in integer,
491: transactionIdIn in varchar2,

Line 493: variableNamesOut out nocopy ame_util.stringList,

489: end getitemIds;
490: procedure getTransactionProductions(applicationIdIn in integer,
491: transactionIdIn in varchar2,
492: testOrRealTransTypeIn in varchar2,
493: variableNamesOut out nocopy ame_util.stringList,
494: variableValuesOut out nocopy ame_util.stringList) as
495: isTestTransaction boolean;
496: begin
497: if(testOrRealTransTypeIn = ame_util.testTrans) then

Line 494: variableValuesOut out nocopy ame_util.stringList) as

490: procedure getTransactionProductions(applicationIdIn in integer,
491: transactionIdIn in varchar2,
492: testOrRealTransTypeIn in varchar2,
493: variableNamesOut out nocopy ame_util.stringList,
494: variableValuesOut out nocopy ame_util.stringList) as
495: isTestTransaction boolean;
496: begin
497: if(testOrRealTransTypeIn = ame_util.testTrans) then
498: isTestTransaction := true;

Line 497: if(testOrRealTransTypeIn = ame_util.testTrans) then

493: variableNamesOut out nocopy ame_util.stringList,
494: variableValuesOut out nocopy ame_util.stringList) as
495: isTestTransaction boolean;
496: begin
497: if(testOrRealTransTypeIn = ame_util.testTrans) then
498: isTestTransaction := true;
499: else
500: isTestTransaction := false;
501: end if;

Line 527: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

523: ame_engine.getTransVariableValues(transVariableValuesOut => variableValuesOut);
524: exception
525: when others then
526: rollback;
527: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
528: routineNameIn => 'getTransactionProductions',
529: exceptionNumberIn => sqlcode,
530: exceptionStringIn => sqlerrm);
531: variableNamesOut := ame_util.emptyStringList;

Line 531: variableNamesOut := ame_util.emptyStringList;

527: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
528: routineNameIn => 'getTransactionProductions',
529: exceptionNumberIn => sqlcode,
530: exceptionStringIn => sqlerrm);
531: variableNamesOut := ame_util.emptyStringList;
532: variableValuesOut := ame_util.emptyStringList;
533: raise;
534: end getTransactionProductions;
535: procedure initializeTestTrans(applicationIdIn in integer,

Line 532: variableValuesOut := ame_util.emptyStringList;

528: routineNameIn => 'getTransactionProductions',
529: exceptionNumberIn => sqlcode,
530: exceptionStringIn => sqlerrm);
531: variableNamesOut := ame_util.emptyStringList;
532: variableValuesOut := ame_util.emptyStringList;
533: raise;
534: end getTransactionProductions;
535: procedure initializeTestTrans(applicationIdIn in integer,
536: transactionIdIn in varchar2,

Line 540: attributeIds ame_util.idList;

536: transactionIdIn in varchar2,
537: itemClassIdIn in integer default null,
538: isHeaderItemClassIn in boolean default true,
539: itemIdIn in varchar2 default null) as
540: attributeIds ame_util.idList;
541: attributeNames ame_util.stringList;
542: attributeTypes ame_util.stringList;
543: errorCode integer;
544: errorMessage ame_util.longestStringType;

Line 541: attributeNames ame_util.stringList;

537: itemClassIdIn in integer default null,
538: isHeaderItemClassIn in boolean default true,
539: itemIdIn in varchar2 default null) as
540: attributeIds ame_util.idList;
541: attributeNames ame_util.stringList;
542: attributeTypes ame_util.stringList;
543: errorCode integer;
544: errorMessage ame_util.longestStringType;
545: isLineItem boolean;

Line 542: attributeTypes ame_util.stringList;

538: isHeaderItemClassIn in boolean default true,
539: itemIdIn in varchar2 default null) as
540: attributeIds ame_util.idList;
541: attributeNames ame_util.stringList;
542: attributeTypes ame_util.stringList;
543: errorCode integer;
544: errorMessage ame_util.longestStringType;
545: isLineItem boolean;
546: isMandatory ame_util.charType;

Line 544: errorMessage ame_util.longestStringType;

540: attributeIds ame_util.idList;
541: attributeNames ame_util.stringList;
542: attributeTypes ame_util.stringList;
543: errorCode integer;
544: errorMessage ame_util.longestStringType;
545: isLineItem boolean;
546: isMandatory ame_util.charType;
547: isNonHeaderAttributeItem boolean;
548: itemClassId integer;

Line 546: isMandatory ame_util.charType;

542: attributeTypes ame_util.stringList;
543: errorCode integer;
544: errorMessage ame_util.longestStringType;
545: isLineItem boolean;
546: isMandatory ame_util.charType;
547: isNonHeaderAttributeItem boolean;
548: itemClassId integer;
549: noAttributesException exception;
550: upperLimit integer;

Line 557: ame_admin_pkg.getItemClassIdByName(itemClassNameIn => ame_util.headerItemClassName);

553: ame_attribute_pkg.getActiveHeaderAttributes(applicationIdIn => applicationIdIn,
554: attributeIdsOut => attributeIds,
555: attributeNamesOut => attributeNames);
556: itemClassId :=
557: ame_admin_pkg.getItemClassIdByName(itemClassNameIn => ame_util.headerItemClassName);
558: else
559: ame_attribute_pkg.getNonHeaderICAttributes2(applicationIdIn => applicationIdIn,
560: itemClassIdIn => itemClassIdIn,
561: attributeIdsOut => attributeIds,

Line 570: if(attributeNames(i) <> ame_util.workflowItemKeyAttribute and

566: raise noAttributesException;
567: end if;
568: upperLimit := attributeIds.count;
569: for i in 1 .. upperLimit loop
570: if(attributeNames(i) <> ame_util.workflowItemKeyAttribute and
571: attributeNames(i) <> ame_util.workflowItemTypeAttribute) then
572: attributeTypes(i) := ame_attribute_pkg.getType(attributeIdIn => attributeIds(i));
573: if(ame_attribute_pkg.isMandatory(attributeIdIn => attributeIds(i))) then
574: isMandatory := ame_util.booleanTrue;

Line 571: attributeNames(i) <> ame_util.workflowItemTypeAttribute) then

567: end if;
568: upperLimit := attributeIds.count;
569: for i in 1 .. upperLimit loop
570: if(attributeNames(i) <> ame_util.workflowItemKeyAttribute and
571: attributeNames(i) <> ame_util.workflowItemTypeAttribute) then
572: attributeTypes(i) := ame_attribute_pkg.getType(attributeIdIn => attributeIds(i));
573: if(ame_attribute_pkg.isMandatory(attributeIdIn => attributeIds(i))) then
574: isMandatory := ame_util.booleanTrue;
575: else

Line 574: isMandatory := ame_util.booleanTrue;

570: if(attributeNames(i) <> ame_util.workflowItemKeyAttribute and
571: attributeNames(i) <> ame_util.workflowItemTypeAttribute) then
572: attributeTypes(i) := ame_attribute_pkg.getType(attributeIdIn => attributeIds(i));
573: if(ame_attribute_pkg.isMandatory(attributeIdIn => attributeIds(i))) then
574: isMandatory := ame_util.booleanTrue;
575: else
576: isMandatory := ame_util.booleanFalse;
577: end if;
578: insert into ame_test_trans_att_values(

Line 576: isMandatory := ame_util.booleanFalse;

572: attributeTypes(i) := ame_attribute_pkg.getType(attributeIdIn => attributeIds(i));
573: if(ame_attribute_pkg.isMandatory(attributeIdIn => attributeIds(i))) then
574: isMandatory := ame_util.booleanTrue;
575: else
576: isMandatory := ame_util.booleanFalse;
577: end if;
578: insert into ame_test_trans_att_values(
579: application_id,
580: transaction_id,

Line 612: ame_util.getMessage(applicationShortNameIn => 'PER',

608: exception
609: when noAttributesException then
610: errorCode := -20001;
611: errorMessage :=
612: ame_util.getMessage(applicationShortNameIn => 'PER',
613: messageNameIn =>'AME_400443_TEST_NO_AU_EXST');
614: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
615: routineNameIn => 'initializeTestTrans',
616: exceptionNumberIn => errorCode,

Line 614: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

610: errorCode := -20001;
611: errorMessage :=
612: ame_util.getMessage(applicationShortNameIn => 'PER',
613: messageNameIn =>'AME_400443_TEST_NO_AU_EXST');
614: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
615: routineNameIn => 'initializeTestTrans',
616: exceptionNumberIn => errorCode,
617: exceptionStringIn => errorMessage);
618: raise_application_error(errorCode,

Line 622: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

618: raise_application_error(errorCode,
619: errorMessage);
620: when others then
621: rollback;
622: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
623: routineNameIn => 'initializeTestTrans',
624: exceptionNumberIn => sqlcode,
625: exceptionStringIn => sqlerrm);
626: raise;

Line 631: attributeIdsIn in ame_util.idList,

627: end initializeTestTrans;
628: procedure setAllAttributeValues(applicationIdIn in integer,
629: transactionIdIn in varchar2,
630: itemClassIdIn in integer,
631: attributeIdsIn in ame_util.idList,
632: itemIdIn in varchar2 default null,
633: attributeValues1In in ame_util.attributeValueList,
634: attributeValues2In in ame_util.attributeValueList,
635: attributeValues3In in ame_util.attributeValueList) as

Line 633: attributeValues1In in ame_util.attributeValueList,

629: transactionIdIn in varchar2,
630: itemClassIdIn in integer,
631: attributeIdsIn in ame_util.idList,
632: itemIdIn in varchar2 default null,
633: attributeValues1In in ame_util.attributeValueList,
634: attributeValues2In in ame_util.attributeValueList,
635: attributeValues3In in ame_util.attributeValueList) as
636: attributeNames ame_util.stringList;
637: attributeTypes ame_util.stringList;

Line 634: attributeValues2In in ame_util.attributeValueList,

630: itemClassIdIn in integer,
631: attributeIdsIn in ame_util.idList,
632: itemIdIn in varchar2 default null,
633: attributeValues1In in ame_util.attributeValueList,
634: attributeValues2In in ame_util.attributeValueList,
635: attributeValues3In in ame_util.attributeValueList) as
636: attributeNames ame_util.stringList;
637: attributeTypes ame_util.stringList;
638: isMandatory ame_util.stringList;

Line 635: attributeValues3In in ame_util.attributeValueList) as

631: attributeIdsIn in ame_util.idList,
632: itemIdIn in varchar2 default null,
633: attributeValues1In in ame_util.attributeValueList,
634: attributeValues2In in ame_util.attributeValueList,
635: attributeValues3In in ame_util.attributeValueList) as
636: attributeNames ame_util.stringList;
637: attributeTypes ame_util.stringList;
638: isMandatory ame_util.stringList;
639: upperLimit integer;

Line 636: attributeNames ame_util.stringList;

632: itemIdIn in varchar2 default null,
633: attributeValues1In in ame_util.attributeValueList,
634: attributeValues2In in ame_util.attributeValueList,
635: attributeValues3In in ame_util.attributeValueList) as
636: attributeNames ame_util.stringList;
637: attributeTypes ame_util.stringList;
638: isMandatory ame_util.stringList;
639: upperLimit integer;
640: begin

Line 637: attributeTypes ame_util.stringList;

633: attributeValues1In in ame_util.attributeValueList,
634: attributeValues2In in ame_util.attributeValueList,
635: attributeValues3In in ame_util.attributeValueList) as
636: attributeNames ame_util.stringList;
637: attributeTypes ame_util.stringList;
638: isMandatory ame_util.stringList;
639: upperLimit integer;
640: begin
641: delete from ame_test_trans_att_values

Line 638: isMandatory ame_util.stringList;

634: attributeValues2In in ame_util.attributeValueList,
635: attributeValues3In in ame_util.attributeValueList) as
636: attributeNames ame_util.stringList;
637: attributeTypes ame_util.stringList;
638: isMandatory ame_util.stringList;
639: upperLimit integer;
640: begin
641: delete from ame_test_trans_att_values
642: where

Line 654: isMandatory(i) := ame_util.booleanTrue;

650: for i in 1 .. upperLimit loop
651: attributeNames(i) := ame_attribute_pkg.getName(attributeIdIn => attributeIdsIn(i));
652: attributeTypes(i) := ame_attribute_pkg.getType(attributeIdIn => attributeIdsIn(i));
653: if(ame_attribute_pkg.isMandatory(attributeIdIn => attributeIdsIn(i))) then
654: isMandatory(i) := ame_util.booleanTrue;
655: else
656: isMandatory(i) := ame_util.booleanFalse;
657: end if;
658: end loop;

Line 656: isMandatory(i) := ame_util.booleanFalse;

652: attributeTypes(i) := ame_attribute_pkg.getType(attributeIdIn => attributeIdsIn(i));
653: if(ame_attribute_pkg.isMandatory(attributeIdIn => attributeIdsIn(i))) then
654: isMandatory(i) := ame_util.booleanTrue;
655: else
656: isMandatory(i) := ame_util.booleanFalse;
657: end if;
658: end loop;
659: forall i in 1 .. upperLimit
660: insert into ame_test_trans_att_values(

Line 692: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

688: commit;
689: exception
690: when others then
691: rollback;
692: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
693: routineNameIn => 'setAllAttributeValues',
694: exceptionNumberIn => sqlcode,
695: exceptionStringIn => sqlerrm);
696: raise;

Line 719: isMandatory := ame_util.booleanTrue;

715: item_class_id = itemClassIdIn and
716: itemIdIn = item_id;
717: commit;
718: if(ame_attribute_pkg.isMandatory(attributeIdIn => attributeIdIn)) then
719: isMandatory := ame_util.booleanTrue;
720: else
721: isMandatory := ame_util.booleanFalse;
722: end if;
723: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIdIn);

Line 721: isMandatory := ame_util.booleanFalse;

717: commit;
718: if(ame_attribute_pkg.isMandatory(attributeIdIn => attributeIdIn)) then
719: isMandatory := ame_util.booleanTrue;
720: else
721: isMandatory := ame_util.booleanFalse;
722: end if;
723: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIdIn);
724: attributeType := ame_attribute_pkg.getType(attributeIdIn => attributeIdIn);
725: insert into ame_test_trans_att_values(

Line 757: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',

753: commit;
754: exception
755: when others then
756: rollback;
757: ame_util.runtimeException(packageNameIn => 'ame_test_pkg',
758: routineNameIn => 'setAttributeValues',
759: exceptionNumberIn => sqlcode,
760: exceptionStringIn => sqlerrm);
761: raise;