APPS.AME_API3 dependencies on DBMS_SQL

Line 780: tempGroupMembers dbms_sql.Varchar2_Table;

776: outputIndex integer;
777: parameters ame_util.longStringList;
778: queryStrings ame_util.longestStringList;
779: rowsFound integer;
780: tempGroupMembers dbms_sql.Varchar2_Table;
781: upperParameterNames ame_util.stringList;
782: tempGroupName ame_util.stringType;
783: begin
784: open groupMemberCursor(groupIdIn => groupIdIn);

Line 795: dynamicCursor := dbms_sql.open_cursor;

791: close groupMemberCursor;
792: outputIndex := 0; /* pre-increment */
793: for i in 1 .. parameters.count loop
794: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
795: dynamicCursor := dbms_sql.open_cursor;
796: dbms_sql.parse(dynamicCursor,
797: ame_util.removeReturns(stringIn => queryStrings(i),
798: replaceWithSpaces => true),
799: dbms_sql.native);

Line 796: dbms_sql.parse(dynamicCursor,

792: outputIndex := 0; /* pre-increment */
793: for i in 1 .. parameters.count loop
794: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
795: dynamicCursor := dbms_sql.open_cursor;
796: dbms_sql.parse(dynamicCursor,
797: ame_util.removeReturns(stringIn => queryStrings(i),
798: replaceWithSpaces => true),
799: dbms_sql.native);
800: if(instrb(queryStrings(i),

Line 799: dbms_sql.native);

795: dynamicCursor := dbms_sql.open_cursor;
796: dbms_sql.parse(dynamicCursor,
797: ame_util.removeReturns(stringIn => queryStrings(i),
798: replaceWithSpaces => true),
799: dbms_sql.native);
800: if(instrb(queryStrings(i),
801: ame_util.transactionIdPlaceholder) > 0) then
802: if transactionIdIn is null then
803: dbms_sql.close_cursor(dynamicCursor);

Line 803: dbms_sql.close_cursor(dynamicCursor);

799: dbms_sql.native);
800: if(instrb(queryStrings(i),
801: ame_util.transactionIdPlaceholder) > 0) then
802: if transactionIdIn is null then
803: dbms_sql.close_cursor(dynamicCursor);
804: raise noTransIdDefinedException;
805: end if;
806: dbms_sql.bind_variable(dynamicCursor,
807: ame_util.transactionIdPlaceholder,

Line 806: dbms_sql.bind_variable(dynamicCursor,

802: if transactionIdIn is null then
803: dbms_sql.close_cursor(dynamicCursor);
804: raise noTransIdDefinedException;
805: end if;
806: dbms_sql.bind_variable(dynamicCursor,
807: ame_util.transactionIdPlaceholder,
808: transactionIdIn,
809: 50);
810: end if;

Line 813: dbms_sql.bind_variable(dynamicCursor,

809: 50);
810: end if;
811: if(instrb(queryStrings(i),
812: ame_util2.itemClassPlaceHolder) > 0) then
813: dbms_sql.bind_variable(dynamicCursor,
814: ame_util2.itemClassPlaceHolder,
815: ame_util.headerItemClassName,
816: 50);
817: end if;

Line 821: dbms_sql.close_cursor(dynamicCursor);

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

Line 824: dbms_sql.bind_variable(dynamicCursor,

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

Line 829: dbms_sql.define_array(dynamicCursor,

825: ame_util2.itemIdPlaceHolder,
826: transactionIdIn,
827: 50);
828: end if;
829: dbms_sql.define_array(dynamicCursor,
830: 1,
831: tempGroupMembers,
832: 100,
833: 1);

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

830: 1,
831: tempGroupMembers,
832: 100,
833: 1);
834: rowsFound := dbms_sql.execute(dynamicCursor);
835: loop
836: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
837: dbms_sql.column_value(dynamicCursor,
838: 1,

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

832: 100,
833: 1);
834: rowsFound := dbms_sql.execute(dynamicCursor);
835: loop
836: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
837: dbms_sql.column_value(dynamicCursor,
838: 1,
839: tempGroupMembers);
840: exit when rowsFound < 100;

Line 837: dbms_sql.column_value(dynamicCursor,

833: 1);
834: rowsFound := dbms_sql.execute(dynamicCursor);
835: loop
836: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
837: dbms_sql.column_value(dynamicCursor,
838: 1,
839: tempGroupMembers);
840: exit when rowsFound < 100;
841: end loop;

Line 842: dbms_sql.close_cursor(dynamicCursor);

838: 1,
839: tempGroupMembers);
840: exit when rowsFound < 100;
841: end loop;
842: dbms_sql.close_cursor(dynamicCursor);
843: /*
844: Dynamic groups' query strings may return rows having one of two forms:
845: (1) approver_type:approver_id
846: (2) orig_system:orig_system_id:approver_name

Line 991: tempGroupMembers dbms_sql.Varchar2_Table;

987: outputIndex integer;
988: parameters ame_util.longStringList;
989: queryStrings ame_util.longestStringList;
990: rowsFound integer;
991: tempGroupMembers dbms_sql.Varchar2_Table;
992: upperParameterNames ame_util.stringList;
993: tempGroupName ame_util.stringType;
994: begin
995: open groupMemberCursor(groupIdIn => groupIdIn);

Line 1007: dynamicCursor := dbms_sql.open_cursor;

1003: close groupMemberCursor;
1004: outputIndex := 0; /* pre-increment */
1005: for i in 1 .. parameters.count loop
1006: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
1007: dynamicCursor := dbms_sql.open_cursor;
1008: dbms_sql.parse(dynamicCursor,
1009: ame_util.removeReturns(stringIn => queryStrings(i),
1010: replaceWithSpaces => true),
1011: dbms_sql.native);

Line 1008: dbms_sql.parse(dynamicCursor,

1004: outputIndex := 0; /* pre-increment */
1005: for i in 1 .. parameters.count loop
1006: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
1007: dynamicCursor := dbms_sql.open_cursor;
1008: dbms_sql.parse(dynamicCursor,
1009: ame_util.removeReturns(stringIn => queryStrings(i),
1010: replaceWithSpaces => true),
1011: dbms_sql.native);
1012: if(instrb(queryStrings(i),

Line 1011: dbms_sql.native);

1007: dynamicCursor := dbms_sql.open_cursor;
1008: dbms_sql.parse(dynamicCursor,
1009: ame_util.removeReturns(stringIn => queryStrings(i),
1010: replaceWithSpaces => true),
1011: dbms_sql.native);
1012: if(instrb(queryStrings(i),
1013: ame_util.transactionIdPlaceholder) > 0) then
1014: if transactionIdIn is null then
1015: dbms_sql.close_cursor(dynamicCursor);

Line 1015: dbms_sql.close_cursor(dynamicCursor);

1011: dbms_sql.native);
1012: if(instrb(queryStrings(i),
1013: ame_util.transactionIdPlaceholder) > 0) then
1014: if transactionIdIn is null then
1015: dbms_sql.close_cursor(dynamicCursor);
1016: raise noTransIdDefinedException;
1017: end if;
1018: dbms_sql.bind_variable(dynamicCursor,
1019: ame_util.transactionIdPlaceholder,

Line 1018: dbms_sql.bind_variable(dynamicCursor,

1014: if transactionIdIn is null then
1015: dbms_sql.close_cursor(dynamicCursor);
1016: raise noTransIdDefinedException;
1017: end if;
1018: dbms_sql.bind_variable(dynamicCursor,
1019: ame_util.transactionIdPlaceholder,
1020: transactionIdIn,
1021: 50);
1022: end if;

Line 1025: dbms_sql.bind_variable(dynamicCursor,

1021: 50);
1022: end if;
1023: if(instrb(queryStrings(i),
1024: ame_util2.itemClassPlaceHolder) > 0) then
1025: dbms_sql.bind_variable(dynamicCursor,
1026: ame_util2.itemClassPlaceHolder,
1027: ame_util.headerItemClassName,
1028: 50);
1029: end if;

Line 1033: dbms_sql.close_cursor(dynamicCursor);

1029: end if;
1030: if (instrb(queryStrings(i),
1031: ame_util2.itemIdPlaceHolder) > 0) then
1032: if transactionIdIn is null then
1033: dbms_sql.close_cursor(dynamicCursor);
1034: raise noTransIdDefinedException;
1035: end if;
1036: dbms_sql.bind_variable(dynamicCursor,
1037: ame_util2.itemIdPlaceHolder,

Line 1036: dbms_sql.bind_variable(dynamicCursor,

1032: if transactionIdIn is null then
1033: dbms_sql.close_cursor(dynamicCursor);
1034: raise noTransIdDefinedException;
1035: end if;
1036: dbms_sql.bind_variable(dynamicCursor,
1037: ame_util2.itemIdPlaceHolder,
1038: transactionIdIn,
1039: 50);
1040: end if;

Line 1041: dbms_sql.define_array(dynamicCursor,

1037: ame_util2.itemIdPlaceHolder,
1038: transactionIdIn,
1039: 50);
1040: end if;
1041: dbms_sql.define_array(dynamicCursor,
1042: 1,
1043: tempGroupMembers,
1044: 100,
1045: 1);

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

1042: 1,
1043: tempGroupMembers,
1044: 100,
1045: 1);
1046: rowsFound := dbms_sql.execute(dynamicCursor);
1047: loop
1048: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
1049: dbms_sql.column_value(dynamicCursor,
1050: 1,

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

1044: 100,
1045: 1);
1046: rowsFound := dbms_sql.execute(dynamicCursor);
1047: loop
1048: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
1049: dbms_sql.column_value(dynamicCursor,
1050: 1,
1051: tempGroupMembers);
1052: exit when rowsFound < 100;

Line 1049: dbms_sql.column_value(dynamicCursor,

1045: 1);
1046: rowsFound := dbms_sql.execute(dynamicCursor);
1047: loop
1048: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
1049: dbms_sql.column_value(dynamicCursor,
1050: 1,
1051: tempGroupMembers);
1052: exit when rowsFound < 100;
1053: end loop;

Line 1054: dbms_sql.close_cursor(dynamicCursor);

1050: 1,
1051: tempGroupMembers);
1052: exit when rowsFound < 100;
1053: end loop;
1054: dbms_sql.close_cursor(dynamicCursor);
1055: /*
1056: Dynamic groups' query strings may return rows having one of two forms:
1057: (1) approver_type:approver_id
1058: (2) orig_system:orig_system_id:approver_name

Line 1204: tempGroupMembers dbms_sql.Varchar2_Table;

1200: outputIndex integer;
1201: parameters ame_util.longStringList;
1202: queryStrings ame_util.longestStringList;
1203: rowsFound integer;
1204: tempGroupMembers dbms_sql.Varchar2_Table;
1205: upperParameterNames ame_util.stringList;
1206: tempGroupName ame_util.stringType;
1207: begin
1208: open groupMemberCursor(groupIdIn => groupIdIn);

Line 1221: dynamicCursor := dbms_sql.open_cursor;

1217: close groupMemberCursor;
1218: outputIndex := 0; /* pre-increment */
1219: for i in 1 .. parameters.count loop
1220: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
1221: dynamicCursor := dbms_sql.open_cursor;
1222: dbms_sql.parse(dynamicCursor,
1223: ame_util.removeReturns(stringIn => queryStrings(i),
1224: replaceWithSpaces => true),
1225: dbms_sql.native);

Line 1222: dbms_sql.parse(dynamicCursor,

1218: outputIndex := 0; /* pre-increment */
1219: for i in 1 .. parameters.count loop
1220: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
1221: dynamicCursor := dbms_sql.open_cursor;
1222: dbms_sql.parse(dynamicCursor,
1223: ame_util.removeReturns(stringIn => queryStrings(i),
1224: replaceWithSpaces => true),
1225: dbms_sql.native);
1226: if(instrb(queryStrings(i),

Line 1225: dbms_sql.native);

1221: dynamicCursor := dbms_sql.open_cursor;
1222: dbms_sql.parse(dynamicCursor,
1223: ame_util.removeReturns(stringIn => queryStrings(i),
1224: replaceWithSpaces => true),
1225: dbms_sql.native);
1226: if(instrb(queryStrings(i),
1227: ame_util.transactionIdPlaceholder) > 0) then
1228: if transactionIdIn is null then
1229: dbms_sql.close_cursor(dynamicCursor);

Line 1229: dbms_sql.close_cursor(dynamicCursor);

1225: dbms_sql.native);
1226: if(instrb(queryStrings(i),
1227: ame_util.transactionIdPlaceholder) > 0) then
1228: if transactionIdIn is null then
1229: dbms_sql.close_cursor(dynamicCursor);
1230: raise noTransIdDefinedException;
1231: end if;
1232: dbms_sql.bind_variable(dynamicCursor,
1233: ame_util.transactionIdPlaceholder,

Line 1232: dbms_sql.bind_variable(dynamicCursor,

1228: if transactionIdIn is null then
1229: dbms_sql.close_cursor(dynamicCursor);
1230: raise noTransIdDefinedException;
1231: end if;
1232: dbms_sql.bind_variable(dynamicCursor,
1233: ame_util.transactionIdPlaceholder,
1234: transactionIdIn,
1235: 50);
1236: end if;

Line 1239: dbms_sql.bind_variable(dynamicCursor,

1235: 50);
1236: end if;
1237: if(instrb(queryStrings(i),
1238: ame_util2.itemClassPlaceHolder) > 0) then
1239: dbms_sql.bind_variable(dynamicCursor,
1240: ame_util2.itemClassPlaceHolder,
1241: ame_util.headerItemClassName,
1242: 50);
1243: end if;

Line 1247: dbms_sql.close_cursor(dynamicCursor);

1243: end if;
1244: if (instrb(queryStrings(i),
1245: ame_util2.itemIdPlaceHolder) > 0) then
1246: if transactionIdIn is null then
1247: dbms_sql.close_cursor(dynamicCursor);
1248: raise noTransIdDefinedException;
1249: end if;
1250: dbms_sql.bind_variable(dynamicCursor,
1251: ame_util2.itemIdPlaceHolder,

Line 1250: dbms_sql.bind_variable(dynamicCursor,

1246: if transactionIdIn is null then
1247: dbms_sql.close_cursor(dynamicCursor);
1248: raise noTransIdDefinedException;
1249: end if;
1250: dbms_sql.bind_variable(dynamicCursor,
1251: ame_util2.itemIdPlaceHolder,
1252: transactionIdIn,
1253: 50);
1254: end if;

Line 1255: dbms_sql.define_array(dynamicCursor,

1251: ame_util2.itemIdPlaceHolder,
1252: transactionIdIn,
1253: 50);
1254: end if;
1255: dbms_sql.define_array(dynamicCursor,
1256: 1,
1257: tempGroupMembers,
1258: 100,
1259: 1);

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

1256: 1,
1257: tempGroupMembers,
1258: 100,
1259: 1);
1260: rowsFound := dbms_sql.execute(dynamicCursor);
1261: loop
1262: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
1263: dbms_sql.column_value(dynamicCursor,
1264: 1,

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

1258: 100,
1259: 1);
1260: rowsFound := dbms_sql.execute(dynamicCursor);
1261: loop
1262: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
1263: dbms_sql.column_value(dynamicCursor,
1264: 1,
1265: tempGroupMembers);
1266: exit when rowsFound < 100;

Line 1263: dbms_sql.column_value(dynamicCursor,

1259: 1);
1260: rowsFound := dbms_sql.execute(dynamicCursor);
1261: loop
1262: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
1263: dbms_sql.column_value(dynamicCursor,
1264: 1,
1265: tempGroupMembers);
1266: exit when rowsFound < 100;
1267: end loop;

Line 1268: dbms_sql.close_cursor(dynamicCursor);

1264: 1,
1265: tempGroupMembers);
1266: exit when rowsFound < 100;
1267: end loop;
1268: dbms_sql.close_cursor(dynamicCursor);
1269: /*
1270: Dynamic groups' query strings may return rows having one of two forms:
1271: (1) approver_type:approver_id
1272: (2) orig_system:orig_system_id:approver_name

Line 1422: tempGroupMembers dbms_sql.Varchar2_Table;

1418: outputIndex integer;
1419: parameters ame_util.longStringList;
1420: queryStrings ame_util.longestStringList;
1421: rowsFound integer;
1422: tempGroupMembers dbms_sql.Varchar2_Table;
1423: upperParameterNames ame_util.stringList;
1424: tempGroupName ame_util.stringType;
1425: begin
1426: open groupMemberCursor(groupIdIn => groupIdIn);

Line 1441: dynamicCursor := dbms_sql.open_cursor;

1437: close groupMemberCursor;
1438: outputIndex := 0; /* pre-increment */
1439: for i in 1 .. parameters.count loop
1440: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
1441: dynamicCursor := dbms_sql.open_cursor;
1442: dbms_sql.parse(dynamicCursor,
1443: ame_util.removeReturns(stringIn => queryStrings(i),
1444: replaceWithSpaces => true),
1445: dbms_sql.native);

Line 1442: dbms_sql.parse(dynamicCursor,

1438: outputIndex := 0; /* pre-increment */
1439: for i in 1 .. parameters.count loop
1440: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
1441: dynamicCursor := dbms_sql.open_cursor;
1442: dbms_sql.parse(dynamicCursor,
1443: ame_util.removeReturns(stringIn => queryStrings(i),
1444: replaceWithSpaces => true),
1445: dbms_sql.native);
1446: if(instrb(queryStrings(i),

Line 1445: dbms_sql.native);

1441: dynamicCursor := dbms_sql.open_cursor;
1442: dbms_sql.parse(dynamicCursor,
1443: ame_util.removeReturns(stringIn => queryStrings(i),
1444: replaceWithSpaces => true),
1445: dbms_sql.native);
1446: if(instrb(queryStrings(i),
1447: ame_util.transactionIdPlaceholder) > 0) then
1448: if transactionIdIn is null then
1449: dbms_sql.close_cursor(dynamicCursor);

Line 1449: dbms_sql.close_cursor(dynamicCursor);

1445: dbms_sql.native);
1446: if(instrb(queryStrings(i),
1447: ame_util.transactionIdPlaceholder) > 0) then
1448: if transactionIdIn is null then
1449: dbms_sql.close_cursor(dynamicCursor);
1450: raise noTransIdDefinedException;
1451: end if;
1452: dbms_sql.bind_variable(dynamicCursor,
1453: ame_util.transactionIdPlaceholder,

Line 1452: dbms_sql.bind_variable(dynamicCursor,

1448: if transactionIdIn is null then
1449: dbms_sql.close_cursor(dynamicCursor);
1450: raise noTransIdDefinedException;
1451: end if;
1452: dbms_sql.bind_variable(dynamicCursor,
1453: ame_util.transactionIdPlaceholder,
1454: transactionIdIn,
1455: 50);
1456: end if;

Line 1459: dbms_sql.bind_variable(dynamicCursor,

1455: 50);
1456: end if;
1457: if(instrb(queryStrings(i),
1458: ame_util2.itemClassPlaceHolder) > 0) then
1459: dbms_sql.bind_variable(dynamicCursor,
1460: ame_util2.itemClassPlaceHolder,
1461: ame_util.headerItemClassName,
1462: 50);
1463: end if;

Line 1467: dbms_sql.close_cursor(dynamicCursor);

1463: end if;
1464: if (instrb(queryStrings(i),
1465: ame_util2.itemIdPlaceHolder) > 0) then
1466: if transactionIdIn is null then
1467: dbms_sql.close_cursor(dynamicCursor);
1468: raise noTransIdDefinedException;
1469: end if;
1470: dbms_sql.bind_variable(dynamicCursor,
1471: ame_util2.itemIdPlaceHolder,

Line 1470: dbms_sql.bind_variable(dynamicCursor,

1466: if transactionIdIn is null then
1467: dbms_sql.close_cursor(dynamicCursor);
1468: raise noTransIdDefinedException;
1469: end if;
1470: dbms_sql.bind_variable(dynamicCursor,
1471: ame_util2.itemIdPlaceHolder,
1472: transactionIdIn,
1473: 50);
1474: end if;

Line 1475: dbms_sql.define_array(dynamicCursor,

1471: ame_util2.itemIdPlaceHolder,
1472: transactionIdIn,
1473: 50);
1474: end if;
1475: dbms_sql.define_array(dynamicCursor,
1476: 1,
1477: tempGroupMembers,
1478: 100,
1479: 1);

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

1476: 1,
1477: tempGroupMembers,
1478: 100,
1479: 1);
1480: rowsFound := dbms_sql.execute(dynamicCursor);
1481: loop
1482: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
1483: dbms_sql.column_value(dynamicCursor,
1484: 1,

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

1478: 100,
1479: 1);
1480: rowsFound := dbms_sql.execute(dynamicCursor);
1481: loop
1482: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
1483: dbms_sql.column_value(dynamicCursor,
1484: 1,
1485: tempGroupMembers);
1486: exit when rowsFound < 100;

Line 1483: dbms_sql.column_value(dynamicCursor,

1479: 1);
1480: rowsFound := dbms_sql.execute(dynamicCursor);
1481: loop
1482: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
1483: dbms_sql.column_value(dynamicCursor,
1484: 1,
1485: tempGroupMembers);
1486: exit when rowsFound < 100;
1487: end loop;

Line 1488: dbms_sql.close_cursor(dynamicCursor);

1484: 1,
1485: tempGroupMembers);
1486: exit when rowsFound < 100;
1487: end loop;
1488: dbms_sql.close_cursor(dynamicCursor);
1489: /*
1490: Dynamic groups' query strings may return rows having one of two forms:
1491: (1) approver_type:approver_id
1492: (2) orig_system:orig_system_id:approver_name