192: transactionIdIn,
193: 50);
194: end if;
195: if(instrb(queryStrings(i),
196: ame_util2.itemClassPlaceHolder) > 0) then
197: if transactionIdIn is null then
198: dbms_sql.close_cursor(dynamicCursor);
199: raise noItemBindException;
200: end if;
198: dbms_sql.close_cursor(dynamicCursor);
199: raise noItemBindException;
200: end if;
201: dbms_sql.bind_variable(dynamicCursor,
202: ame_util2.itemClassPlaceHolder,
203: itemClassIn,
204: 50);
205: end if;
206: if(instrb(queryStrings(i),
203: itemClassIn,
204: 50);
205: end if;
206: if(instrb(queryStrings(i),
207: ame_util2.itemIdPlaceHolder) > 0) then
208: if transactionIdIn is null then
209: dbms_sql.close_cursor(dynamicCursor);
210: raise noItemBindException;
211: end if;
209: dbms_sql.close_cursor(dynamicCursor);
210: raise noItemBindException;
211: end if;
212: dbms_sql.bind_variable(dynamicCursor,
213: ame_util2.itemIdPlaceHolder,
214: itemIdIn,
215: 50);
216: end if;
217: dbms_sql.define_array(dynamicCursor,
438: transactionIdIn,
439: 50);
440: end if;
441: if(instrb(queryStrings(i),
442: ame_util2.itemClassPlaceHolder) > 0) then
443: if transactionIdIn is null then
444: dbms_sql.close_cursor(dynamicCursor);
445: raise noItemBindException;
446: end if;
444: dbms_sql.close_cursor(dynamicCursor);
445: raise noItemBindException;
446: end if;
447: dbms_sql.bind_variable(dynamicCursor,
448: ame_util2.itemClassPlaceHolder,
449: itemClassIn,
450: 50);
451: end if;
452: if(instrb(queryStrings(i),
449: itemClassIn,
450: 50);
451: end if;
452: if(instrb(queryStrings(i),
453: ame_util2.itemIdPlaceHolder) > 0) then
454: if transactionIdIn is null then
455: dbms_sql.close_cursor(dynamicCursor);
456: raise noItemBindException;
457: end if;
455: dbms_sql.close_cursor(dynamicCursor);
456: raise noItemBindException;
457: end if;
458: dbms_sql.bind_variable(dynamicCursor,
459: ame_util2.itemIdPlaceHolder,
460: itemIdIn,
461: 50);
462: end if;
463: dbms_sql.define_array(dynamicCursor,
687: transactionIdIn,
688: 50);
689: end if;
690: if(instrb(queryStrings(i),
691: ame_util2.itemClassPlaceHolder) > 0) then
692: if transactionIdIn is null then
693: dbms_sql.close_cursor(dynamicCursor);
694: raise noItemBindException;
695: end if;
693: dbms_sql.close_cursor(dynamicCursor);
694: raise noItemBindException;
695: end if;
696: dbms_sql.bind_variable(dynamicCursor,
697: ame_util2.itemClassPlaceHolder,
698: itemClassIn,
699: 50);
700: end if;
701: if(instrb(queryStrings(i),
698: itemClassIn,
699: 50);
700: end if;
701: if(instrb(queryStrings(i),
702: ame_util2.itemIdPlaceHolder) > 0) then
703: if transactionIdIn is null then
704: dbms_sql.close_cursor(dynamicCursor);
705: raise noItemBindException;
706: end if;
704: dbms_sql.close_cursor(dynamicCursor);
705: raise noItemBindException;
706: end if;
707: dbms_sql.bind_variable(dynamicCursor,
708: ame_util2.itemIdPlaceHolder,
709: itemIdIn,
710: 50);
711: end if;
712: dbms_sql.define_array(dynamicCursor,
935: transactionIdIn,
936: 50);
937: end if;
938: if(instrb(queryStrings(i),
939: ame_util2.itemClassPlaceHolder) > 0) then
940: if transactionIdIn is null then
941: dbms_sql.close_cursor(dynamicCursor);
942: raise noItemBindException;
943: end if;
941: dbms_sql.close_cursor(dynamicCursor);
942: raise noItemBindException;
943: end if;
944: dbms_sql.bind_variable(dynamicCursor,
945: ame_util2.itemClassPlaceHolder,
946: itemClassIn,
947: 50);
948: end if;
949: if(instrb(queryStrings(i),
946: itemClassIn,
947: 50);
948: end if;
949: if(instrb(queryStrings(i),
950: ame_util2.itemIdPlaceHolder) > 0) then
951: if transactionIdIn is null then
952: dbms_sql.close_cursor(dynamicCursor);
953: raise noItemBindException;
954: end if;
952: dbms_sql.close_cursor(dynamicCursor);
953: raise noItemBindException;
954: end if;
955: dbms_sql.bind_variable(dynamicCursor,
956: ame_util2.itemIdPlaceHolder,
957: itemIdIn,
958: 50);
959: end if;
960: dbms_sql.define_array(dynamicCursor,