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.

[Home] [Help]

APPS.AME_API7 dependencies on DBMS_SQL

Line 161: tempGroupMembers dbms_sql.Varchar2_Table;

157: outputIndex integer;
158: parameters ame_util.longStringList;
159: queryStrings ame_util.longestStringList;
160: rowsFound integer;
161: tempGroupMembers dbms_sql.Varchar2_Table;
162: upperParameterNames ame_util.stringList;
163: tempGroupName ame_util.stringType;
164: begin
165: open groupMemberCursor(groupIdIn => groupIdIn);

Line 176: dynamicCursor := dbms_sql.open_cursor;

172: close groupMemberCursor;
173: outputIndex := 0; /* pre-increment */
174: for i in 1 .. parameters.count loop
175: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
176: dynamicCursor := dbms_sql.open_cursor;
177: dbms_sql.parse(dynamicCursor,
178: ame_util.removeReturns(stringIn => queryStrings(i),
179: replaceWithSpaces => true),
180: dbms_sql.native);

Line 177: dbms_sql.parse(dynamicCursor,

173: outputIndex := 0; /* pre-increment */
174: for i in 1 .. parameters.count loop
175: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
176: dynamicCursor := dbms_sql.open_cursor;
177: dbms_sql.parse(dynamicCursor,
178: ame_util.removeReturns(stringIn => queryStrings(i),
179: replaceWithSpaces => true),
180: dbms_sql.native);
181: if(instrb(queryStrings(i),

Line 180: dbms_sql.native);

176: dynamicCursor := dbms_sql.open_cursor;
177: dbms_sql.parse(dynamicCursor,
178: ame_util.removeReturns(stringIn => queryStrings(i),
179: replaceWithSpaces => true),
180: dbms_sql.native);
181: if(instrb(queryStrings(i),
182: ame_util.transactionIdPlaceholder) > 0) then
183: if transactionIdIn is null then
184: dbms_sql.close_cursor(dynamicCursor);

Line 184: dbms_sql.close_cursor(dynamicCursor);

180: dbms_sql.native);
181: if(instrb(queryStrings(i),
182: ame_util.transactionIdPlaceholder) > 0) then
183: if transactionIdIn is null then
184: dbms_sql.close_cursor(dynamicCursor);
185: raise noTransIdDefinedException;
186: end if;
187: dbms_sql.bind_variable(dynamicCursor,
188: ame_util.transactionIdPlaceholder,

Line 187: dbms_sql.bind_variable(dynamicCursor,

183: if transactionIdIn is null then
184: dbms_sql.close_cursor(dynamicCursor);
185: raise noTransIdDefinedException;
186: end if;
187: dbms_sql.bind_variable(dynamicCursor,
188: ame_util.transactionIdPlaceholder,
189: transactionIdIn,
190: 50);
191: end if;

Line 195: dbms_sql.close_cursor(dynamicCursor);

191: end if;
192: if(instrb(queryStrings(i),
193: ame_util2.itemClassPlaceHolder) > 0) then
194: if transactionIdIn is null then
195: dbms_sql.close_cursor(dynamicCursor);
196: raise noItemBindException;
197: end if;
198: dbms_sql.bind_variable(dynamicCursor,
199: ame_util2.itemClassPlaceHolder,

Line 198: dbms_sql.bind_variable(dynamicCursor,

194: if transactionIdIn is null then
195: dbms_sql.close_cursor(dynamicCursor);
196: raise noItemBindException;
197: end if;
198: dbms_sql.bind_variable(dynamicCursor,
199: ame_util2.itemClassPlaceHolder,
200: itemClassIn,
201: 50);
202: end if;

Line 206: dbms_sql.close_cursor(dynamicCursor);

202: end if;
203: if(instrb(queryStrings(i),
204: ame_util2.itemIdPlaceHolder) > 0) then
205: if transactionIdIn is null then
206: dbms_sql.close_cursor(dynamicCursor);
207: raise noItemBindException;
208: end if;
209: dbms_sql.bind_variable(dynamicCursor,
210: ame_util2.itemIdPlaceHolder,

Line 209: dbms_sql.bind_variable(dynamicCursor,

205: if transactionIdIn is null then
206: dbms_sql.close_cursor(dynamicCursor);
207: raise noItemBindException;
208: end if;
209: dbms_sql.bind_variable(dynamicCursor,
210: ame_util2.itemIdPlaceHolder,
211: itemIdIn,
212: 50);
213: end if;

Line 214: dbms_sql.define_array(dynamicCursor,

210: ame_util2.itemIdPlaceHolder,
211: itemIdIn,
212: 50);
213: end if;
214: dbms_sql.define_array(dynamicCursor,
215: 1,
216: tempGroupMembers,
217: 100,
218: 1);

Line 219: rowsFound := dbms_sql.execute(dynamicCursor);

215: 1,
216: tempGroupMembers,
217: 100,
218: 1);
219: rowsFound := dbms_sql.execute(dynamicCursor);
220: loop
221: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
222: dbms_sql.column_value(dynamicCursor,
223: 1,

Line 221: rowsFound := dbms_sql.fetch_rows(dynamicCursor);

217: 100,
218: 1);
219: rowsFound := dbms_sql.execute(dynamicCursor);
220: loop
221: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
222: dbms_sql.column_value(dynamicCursor,
223: 1,
224: tempGroupMembers);
225: exit when rowsFound < 100;

Line 222: dbms_sql.column_value(dynamicCursor,

218: 1);
219: rowsFound := dbms_sql.execute(dynamicCursor);
220: loop
221: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
222: dbms_sql.column_value(dynamicCursor,
223: 1,
224: tempGroupMembers);
225: exit when rowsFound < 100;
226: end loop;

Line 227: dbms_sql.close_cursor(dynamicCursor);

223: 1,
224: tempGroupMembers);
225: exit when rowsFound < 100;
226: end loop;
227: dbms_sql.close_cursor(dynamicCursor);
228: /*
229: Dynamic groups' query strings may return rows having one of two forms:
230: (1) approver_type:approver_id
231: (2) orig_system:orig_system_id:approver_name

Line 370: tempGroupMembers dbms_sql.Varchar2_Table;

366: outputIndex integer;
367: parameters ame_util.longStringList;
368: queryStrings ame_util.longestStringList;
369: rowsFound integer;
370: tempGroupMembers dbms_sql.Varchar2_Table;
371: upperParameterNames ame_util.stringList;
372: tempGroupName ame_util.stringType;
373: begin
374: open groupMemberCursor(groupIdIn => groupIdIn);

Line 386: dynamicCursor := dbms_sql.open_cursor;

382: close groupMemberCursor;
383: outputIndex := 0; /* pre-increment */
384: for i in 1 .. parameters.count loop
385: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
386: dynamicCursor := dbms_sql.open_cursor;
387: dbms_sql.parse(dynamicCursor,
388: ame_util.removeReturns(stringIn => queryStrings(i),
389: replaceWithSpaces => true),
390: dbms_sql.native);

Line 387: dbms_sql.parse(dynamicCursor,

383: outputIndex := 0; /* pre-increment */
384: for i in 1 .. parameters.count loop
385: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
386: dynamicCursor := dbms_sql.open_cursor;
387: dbms_sql.parse(dynamicCursor,
388: ame_util.removeReturns(stringIn => queryStrings(i),
389: replaceWithSpaces => true),
390: dbms_sql.native);
391: if(instrb(queryStrings(i),

Line 390: dbms_sql.native);

386: dynamicCursor := dbms_sql.open_cursor;
387: dbms_sql.parse(dynamicCursor,
388: ame_util.removeReturns(stringIn => queryStrings(i),
389: replaceWithSpaces => true),
390: dbms_sql.native);
391: if(instrb(queryStrings(i),
392: ame_util.transactionIdPlaceholder) > 0) then
393: if transactionIdIn is null then
394: dbms_sql.close_cursor(dynamicCursor);

Line 394: dbms_sql.close_cursor(dynamicCursor);

390: dbms_sql.native);
391: if(instrb(queryStrings(i),
392: ame_util.transactionIdPlaceholder) > 0) then
393: if transactionIdIn is null then
394: dbms_sql.close_cursor(dynamicCursor);
395: raise noTransIdDefinedException;
396: end if;
397: dbms_sql.bind_variable(dynamicCursor,
398: ame_util.transactionIdPlaceholder,

Line 397: dbms_sql.bind_variable(dynamicCursor,

393: if transactionIdIn is null then
394: dbms_sql.close_cursor(dynamicCursor);
395: raise noTransIdDefinedException;
396: end if;
397: dbms_sql.bind_variable(dynamicCursor,
398: ame_util.transactionIdPlaceholder,
399: transactionIdIn,
400: 50);
401: end if;

Line 405: dbms_sql.close_cursor(dynamicCursor);

401: end if;
402: if(instrb(queryStrings(i),
403: ame_util2.itemClassPlaceHolder) > 0) then
404: if transactionIdIn is null then
405: dbms_sql.close_cursor(dynamicCursor);
406: raise noItemBindException;
407: end if;
408: dbms_sql.bind_variable(dynamicCursor,
409: ame_util2.itemClassPlaceHolder,

Line 408: dbms_sql.bind_variable(dynamicCursor,

404: if transactionIdIn is null then
405: dbms_sql.close_cursor(dynamicCursor);
406: raise noItemBindException;
407: end if;
408: dbms_sql.bind_variable(dynamicCursor,
409: ame_util2.itemClassPlaceHolder,
410: itemClassIn,
411: 50);
412: end if;

Line 416: dbms_sql.close_cursor(dynamicCursor);

412: end if;
413: if(instrb(queryStrings(i),
414: ame_util2.itemIdPlaceHolder) > 0) then
415: if transactionIdIn is null then
416: dbms_sql.close_cursor(dynamicCursor);
417: raise noItemBindException;
418: end if;
419: dbms_sql.bind_variable(dynamicCursor,
420: ame_util2.itemIdPlaceHolder,

Line 419: dbms_sql.bind_variable(dynamicCursor,

415: if transactionIdIn is null then
416: dbms_sql.close_cursor(dynamicCursor);
417: raise noItemBindException;
418: end if;
419: dbms_sql.bind_variable(dynamicCursor,
420: ame_util2.itemIdPlaceHolder,
421: itemIdIn,
422: 50);
423: end if;

Line 424: dbms_sql.define_array(dynamicCursor,

420: ame_util2.itemIdPlaceHolder,
421: itemIdIn,
422: 50);
423: end if;
424: dbms_sql.define_array(dynamicCursor,
425: 1,
426: tempGroupMembers,
427: 100,
428: 1);

Line 429: rowsFound := dbms_sql.execute(dynamicCursor);

425: 1,
426: tempGroupMembers,
427: 100,
428: 1);
429: rowsFound := dbms_sql.execute(dynamicCursor);
430: loop
431: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
432: dbms_sql.column_value(dynamicCursor,
433: 1,

Line 431: rowsFound := dbms_sql.fetch_rows(dynamicCursor);

427: 100,
428: 1);
429: rowsFound := dbms_sql.execute(dynamicCursor);
430: loop
431: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
432: dbms_sql.column_value(dynamicCursor,
433: 1,
434: tempGroupMembers);
435: exit when rowsFound < 100;

Line 432: dbms_sql.column_value(dynamicCursor,

428: 1);
429: rowsFound := dbms_sql.execute(dynamicCursor);
430: loop
431: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
432: dbms_sql.column_value(dynamicCursor,
433: 1,
434: tempGroupMembers);
435: exit when rowsFound < 100;
436: end loop;

Line 437: dbms_sql.close_cursor(dynamicCursor);

433: 1,
434: tempGroupMembers);
435: exit when rowsFound < 100;
436: end loop;
437: dbms_sql.close_cursor(dynamicCursor);
438: /*
439: Dynamic groups' query strings may return rows having one of two forms:
440: (1) approver_type:approver_id
441: (2) orig_system:orig_system_id:approver_name

Line 579: tempGroupMembers dbms_sql.Varchar2_Table;

575: outputIndex integer;
576: parameters ame_util.longStringList;
577: queryStrings ame_util.longestStringList;
578: rowsFound integer;
579: tempGroupMembers dbms_sql.Varchar2_Table;
580: tempGroupName ame_util.stringType;
581: upperParameterNames ame_util.stringList;
582: begin
583: open groupMemberCursor(groupIdIn => groupIdIn);

Line 596: dynamicCursor := dbms_sql.open_cursor;

592: close groupMemberCursor;
593: outputIndex := 0; /* pre-increment */
594: for i in 1 .. parameters.count loop
595: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
596: dynamicCursor := dbms_sql.open_cursor;
597: dbms_sql.parse(dynamicCursor,
598: ame_util.removeReturns(stringIn => queryStrings(i),
599: replaceWithSpaces => true),
600: dbms_sql.native);

Line 597: dbms_sql.parse(dynamicCursor,

593: outputIndex := 0; /* pre-increment */
594: for i in 1 .. parameters.count loop
595: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
596: dynamicCursor := dbms_sql.open_cursor;
597: dbms_sql.parse(dynamicCursor,
598: ame_util.removeReturns(stringIn => queryStrings(i),
599: replaceWithSpaces => true),
600: dbms_sql.native);
601: if(instrb(queryStrings(i),

Line 600: dbms_sql.native);

596: dynamicCursor := dbms_sql.open_cursor;
597: dbms_sql.parse(dynamicCursor,
598: ame_util.removeReturns(stringIn => queryStrings(i),
599: replaceWithSpaces => true),
600: dbms_sql.native);
601: if(instrb(queryStrings(i),
602: ame_util.transactionIdPlaceholder) > 0) then
603: if transactionIdIn is null then
604: dbms_sql.close_cursor(dynamicCursor);

Line 604: dbms_sql.close_cursor(dynamicCursor);

600: dbms_sql.native);
601: if(instrb(queryStrings(i),
602: ame_util.transactionIdPlaceholder) > 0) then
603: if transactionIdIn is null then
604: dbms_sql.close_cursor(dynamicCursor);
605: raise noTransIdDefinedException;
606: end if;
607: dbms_sql.bind_variable(dynamicCursor,
608: ame_util.transactionIdPlaceholder,

Line 607: dbms_sql.bind_variable(dynamicCursor,

603: if transactionIdIn is null then
604: dbms_sql.close_cursor(dynamicCursor);
605: raise noTransIdDefinedException;
606: end if;
607: dbms_sql.bind_variable(dynamicCursor,
608: ame_util.transactionIdPlaceholder,
609: transactionIdIn,
610: 50);
611: end if;

Line 615: dbms_sql.close_cursor(dynamicCursor);

611: end if;
612: if(instrb(queryStrings(i),
613: ame_util2.itemClassPlaceHolder) > 0) then
614: if transactionIdIn is null then
615: dbms_sql.close_cursor(dynamicCursor);
616: raise noItemBindException;
617: end if;
618: dbms_sql.bind_variable(dynamicCursor,
619: ame_util2.itemClassPlaceHolder,

Line 618: dbms_sql.bind_variable(dynamicCursor,

614: if transactionIdIn is null then
615: dbms_sql.close_cursor(dynamicCursor);
616: raise noItemBindException;
617: end if;
618: dbms_sql.bind_variable(dynamicCursor,
619: ame_util2.itemClassPlaceHolder,
620: itemClassIn,
621: 50);
622: end if;

Line 626: dbms_sql.close_cursor(dynamicCursor);

622: end if;
623: if(instrb(queryStrings(i),
624: ame_util2.itemIdPlaceHolder) > 0) then
625: if transactionIdIn is null then
626: dbms_sql.close_cursor(dynamicCursor);
627: raise noItemBindException;
628: end if;
629: dbms_sql.bind_variable(dynamicCursor,
630: ame_util2.itemIdPlaceHolder,

Line 629: dbms_sql.bind_variable(dynamicCursor,

625: if transactionIdIn is null then
626: dbms_sql.close_cursor(dynamicCursor);
627: raise noItemBindException;
628: end if;
629: dbms_sql.bind_variable(dynamicCursor,
630: ame_util2.itemIdPlaceHolder,
631: itemIdIn,
632: 50);
633: end if;

Line 634: dbms_sql.define_array(dynamicCursor,

630: ame_util2.itemIdPlaceHolder,
631: itemIdIn,
632: 50);
633: end if;
634: dbms_sql.define_array(dynamicCursor,
635: 1,
636: tempGroupMembers,
637: 100,
638: 1);

Line 639: rowsFound := dbms_sql.execute(dynamicCursor);

635: 1,
636: tempGroupMembers,
637: 100,
638: 1);
639: rowsFound := dbms_sql.execute(dynamicCursor);
640: loop
641: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
642: dbms_sql.column_value(dynamicCursor,
643: 1,

Line 641: rowsFound := dbms_sql.fetch_rows(dynamicCursor);

637: 100,
638: 1);
639: rowsFound := dbms_sql.execute(dynamicCursor);
640: loop
641: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
642: dbms_sql.column_value(dynamicCursor,
643: 1,
644: tempGroupMembers);
645: exit when rowsFound < 100;

Line 642: dbms_sql.column_value(dynamicCursor,

638: 1);
639: rowsFound := dbms_sql.execute(dynamicCursor);
640: loop
641: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
642: dbms_sql.column_value(dynamicCursor,
643: 1,
644: tempGroupMembers);
645: exit when rowsFound < 100;
646: end loop;

Line 647: dbms_sql.close_cursor(dynamicCursor);

643: 1,
644: tempGroupMembers);
645: exit when rowsFound < 100;
646: end loop;
647: dbms_sql.close_cursor(dynamicCursor);
648: /*
649: Dynamic groups' query strings may return rows having one of two forms:
650: (1) approver_type:approver_id
651: (2) orig_system:orig_system_id:approver_name

Line 793: tempGroupMembers dbms_sql.Varchar2_Table;

789: outputIndex integer;
790: parameters ame_util.longStringList;
791: queryStrings ame_util.longestStringList;
792: rowsFound integer;
793: tempGroupMembers dbms_sql.Varchar2_Table;
794: tempGroupName ame_util.stringType;
795: upperParameterNames ame_util.stringList;
796: begin
797: open groupMemberCursor(groupIdIn => groupIdIn);

Line 812: dynamicCursor := dbms_sql.open_cursor;

808: close groupMemberCursor;
809: outputIndex := 0; /* pre-increment */
810: for i in 1 .. parameters.count loop
811: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
812: dynamicCursor := dbms_sql.open_cursor;
813: dbms_sql.parse(dynamicCursor,
814: ame_util.removeReturns(stringIn => queryStrings(i),
815: replaceWithSpaces => true),
816: dbms_sql.native);

Line 813: dbms_sql.parse(dynamicCursor,

809: outputIndex := 0; /* pre-increment */
810: for i in 1 .. parameters.count loop
811: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
812: dynamicCursor := dbms_sql.open_cursor;
813: dbms_sql.parse(dynamicCursor,
814: ame_util.removeReturns(stringIn => queryStrings(i),
815: replaceWithSpaces => true),
816: dbms_sql.native);
817: if(instrb(queryStrings(i),

Line 816: dbms_sql.native);

812: dynamicCursor := dbms_sql.open_cursor;
813: dbms_sql.parse(dynamicCursor,
814: ame_util.removeReturns(stringIn => queryStrings(i),
815: replaceWithSpaces => true),
816: dbms_sql.native);
817: if(instrb(queryStrings(i),
818: ame_util.transactionIdPlaceholder) > 0) then
819: if transactionIdIn is null then
820: dbms_sql.close_cursor(dynamicCursor);

Line 820: dbms_sql.close_cursor(dynamicCursor);

816: dbms_sql.native);
817: if(instrb(queryStrings(i),
818: ame_util.transactionIdPlaceholder) > 0) then
819: if transactionIdIn is null then
820: dbms_sql.close_cursor(dynamicCursor);
821: raise noTransIdDefinedException;
822: end if;
823: dbms_sql.bind_variable(dynamicCursor,
824: ame_util.transactionIdPlaceholder,

Line 823: dbms_sql.bind_variable(dynamicCursor,

819: if transactionIdIn is null then
820: dbms_sql.close_cursor(dynamicCursor);
821: raise noTransIdDefinedException;
822: end if;
823: dbms_sql.bind_variable(dynamicCursor,
824: ame_util.transactionIdPlaceholder,
825: transactionIdIn,
826: 50);
827: end if;

Line 831: dbms_sql.close_cursor(dynamicCursor);

827: end if;
828: if(instrb(queryStrings(i),
829: ame_util2.itemClassPlaceHolder) > 0) then
830: if transactionIdIn is null then
831: dbms_sql.close_cursor(dynamicCursor);
832: raise noItemBindException;
833: end if;
834: dbms_sql.bind_variable(dynamicCursor,
835: ame_util2.itemClassPlaceHolder,

Line 834: dbms_sql.bind_variable(dynamicCursor,

830: if transactionIdIn is null then
831: dbms_sql.close_cursor(dynamicCursor);
832: raise noItemBindException;
833: end if;
834: dbms_sql.bind_variable(dynamicCursor,
835: ame_util2.itemClassPlaceHolder,
836: itemClassIn,
837: 50);
838: end if;

Line 842: dbms_sql.close_cursor(dynamicCursor);

838: end if;
839: if(instrb(queryStrings(i),
840: ame_util2.itemIdPlaceHolder) > 0) then
841: if transactionIdIn is null then
842: dbms_sql.close_cursor(dynamicCursor);
843: raise noItemBindException;
844: end if;
845: dbms_sql.bind_variable(dynamicCursor,
846: ame_util2.itemIdPlaceHolder,

Line 845: dbms_sql.bind_variable(dynamicCursor,

841: if transactionIdIn is null then
842: dbms_sql.close_cursor(dynamicCursor);
843: raise noItemBindException;
844: end if;
845: dbms_sql.bind_variable(dynamicCursor,
846: ame_util2.itemIdPlaceHolder,
847: itemIdIn,
848: 50);
849: end if;

Line 850: dbms_sql.define_array(dynamicCursor,

846: ame_util2.itemIdPlaceHolder,
847: itemIdIn,
848: 50);
849: end if;
850: dbms_sql.define_array(dynamicCursor,
851: 1,
852: tempGroupMembers,
853: 100,
854: 1);

Line 855: rowsFound := dbms_sql.execute(dynamicCursor);

851: 1,
852: tempGroupMembers,
853: 100,
854: 1);
855: rowsFound := dbms_sql.execute(dynamicCursor);
856: loop
857: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
858: dbms_sql.column_value(dynamicCursor,
859: 1,

Line 857: rowsFound := dbms_sql.fetch_rows(dynamicCursor);

853: 100,
854: 1);
855: rowsFound := dbms_sql.execute(dynamicCursor);
856: loop
857: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
858: dbms_sql.column_value(dynamicCursor,
859: 1,
860: tempGroupMembers);
861: exit when rowsFound < 100;

Line 858: dbms_sql.column_value(dynamicCursor,

854: 1);
855: rowsFound := dbms_sql.execute(dynamicCursor);
856: loop
857: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
858: dbms_sql.column_value(dynamicCursor,
859: 1,
860: tempGroupMembers);
861: exit when rowsFound < 100;
862: end loop;

Line 863: dbms_sql.close_cursor(dynamicCursor);

859: 1,
860: tempGroupMembers);
861: exit when rowsFound < 100;
862: end loop;
863: dbms_sql.close_cursor(dynamicCursor);
864: /*
865: Dynamic groups' query strings may return rows having one of two forms:
866: (1) approver_type:approver_id
867: (2) orig_system:orig_system_id:approver_name