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_ENGINE dependencies on DBMS_SQL

Line 591: tempAttributeValues1 dbms_sql.varchar2_table;

587: itemIdIn in varchar2) return number as
588: dynamicCursor integer;
589: dynamicQuery ame_util.longestStringType;
590: rowsFound integer;
591: tempAttributeValues1 dbms_sql.varchar2_table;
592: begin
593: if engIsTestTransaction then
594: if checkAttributeVariant(attributeIdIn) = ame_util.booleanTrue then
595: return (getTestVariantAttValue(attributeIdIn => attributeIdIn

Line 606: dynamicCursor := dbms_sql.open_cursor;

602: /* fetch the value for real transactions using the dynamic query */
603: if(engAttributeVariant.exists(attributeIdIn))then
604: dynamicQuery := ame_util.removeReturns(stringIn => engAttributeQueries(attributeIdIn),
605: replaceWithSpaces => true);
606: dynamicCursor := dbms_sql.open_cursor;
607: dbms_sql.parse(dynamicCursor,
608: dynamicQuery,
609: dbms_sql.native);
610: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then

Line 607: dbms_sql.parse(dynamicCursor,

603: if(engAttributeVariant.exists(attributeIdIn))then
604: dynamicQuery := ame_util.removeReturns(stringIn => engAttributeQueries(attributeIdIn),
605: replaceWithSpaces => true);
606: dynamicCursor := dbms_sql.open_cursor;
607: dbms_sql.parse(dynamicCursor,
608: dynamicQuery,
609: dbms_sql.native);
610: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then
611: dbms_sql.bind_variable(dynamicCursor,

Line 609: dbms_sql.native);

605: replaceWithSpaces => true);
606: dynamicCursor := dbms_sql.open_cursor;
607: dbms_sql.parse(dynamicCursor,
608: dynamicQuery,
609: dbms_sql.native);
610: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then
611: dbms_sql.bind_variable(dynamicCursor,
612: ame_util.transactionIdPlaceholder,
613: engTransactionId,

Line 611: dbms_sql.bind_variable(dynamicCursor,

607: dbms_sql.parse(dynamicCursor,
608: dynamicQuery,
609: dbms_sql.native);
610: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then
611: dbms_sql.bind_variable(dynamicCursor,
612: ame_util.transactionIdPlaceholder,
613: engTransactionId,
614: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
615: end if;

Line 617: dbms_sql.bind_variable(dynamicCursor,

613: engTransactionId,
614: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
615: end if;
616: if(instrb(dynamicQuery, ame_util2.itemClassPlaceHolder) > 0) then
617: dbms_sql.bind_variable(dynamicCursor,
618: ame_util2.itemClassPlaceHolder,
619: itemClassIn,
620: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
621: end if;

Line 623: dbms_sql.bind_variable(dynamicCursor,

619: itemClassIn,
620: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
621: end if;
622: if(instrb(dynamicQuery, ame_util2.itemIdPlaceHolder) > 0) then
623: dbms_sql.bind_variable(dynamicCursor,
624: ame_util2.itemIdPlaceHolder,
625: itemIdIn,
626: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
627: end if;

Line 628: dbms_sql.define_array(dynamicCursor,

624: ame_util2.itemIdPlaceHolder,
625: itemIdIn,
626: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
627: end if;
628: dbms_sql.define_array(dynamicCursor,
629: 1,
630: tempAttributeValues1,
631: ame_util.attributeValueTypeLength,
632: 1);

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

629: 1,
630: tempAttributeValues1,
631: ame_util.attributeValueTypeLength,
632: 1);
633: rowsFound := dbms_sql.execute(dynamicCursor);
634: loop
635: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
636: dbms_sql.column_value(dynamicCursor,
637: 1,

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

631: ame_util.attributeValueTypeLength,
632: 1);
633: rowsFound := dbms_sql.execute(dynamicCursor);
634: loop
635: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
636: dbms_sql.column_value(dynamicCursor,
637: 1,
638: tempAttributeValues1);
639: exit when rowsFound < 2;

Line 636: dbms_sql.column_value(dynamicCursor,

632: 1);
633: rowsFound := dbms_sql.execute(dynamicCursor);
634: loop
635: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
636: dbms_sql.column_value(dynamicCursor,
637: 1,
638: tempAttributeValues1);
639: exit when rowsFound < 2;
640: end loop;

Line 641: dbms_sql.close_cursor(dynamicCursor);

637: 1,
638: tempAttributeValues1);
639: exit when rowsFound < 2;
640: end loop;
641: dbms_sql.close_cursor(dynamicCursor);
642: return(tempAttributeValues1(1));
643: else
644: /* this is not a variant attribute value would have fetched already in
645: fetchAttributeValues return the same */

Line 4016: tempAttributeValues1 dbms_sql.varchar2_table;

4012: tempAttributeValue1 ame_util.attributeValueType;
4013: tempAttributeValue2 ame_util.attributeValueType;
4014: tempAttributeValue3 ame_util.attributeValueType;
4015: tempAttributeValueIndex integer;
4016: tempAttributeValues1 dbms_sql.varchar2_table;
4017: tempAttributeValues2 dbms_sql.varchar2_table;
4018: tempAttributeValues3 dbms_sql.varchar2_table;
4019: tempItemClassIndex integer;
4020: begin

Line 4017: tempAttributeValues2 dbms_sql.varchar2_table;

4013: tempAttributeValue2 ame_util.attributeValueType;
4014: tempAttributeValue3 ame_util.attributeValueType;
4015: tempAttributeValueIndex integer;
4016: tempAttributeValues1 dbms_sql.varchar2_table;
4017: tempAttributeValues2 dbms_sql.varchar2_table;
4018: tempAttributeValues3 dbms_sql.varchar2_table;
4019: tempItemClassIndex integer;
4020: begin
4021: /*

Line 4018: tempAttributeValues3 dbms_sql.varchar2_table;

4014: tempAttributeValue3 ame_util.attributeValueType;
4015: tempAttributeValueIndex integer;
4016: tempAttributeValues1 dbms_sql.varchar2_table;
4017: tempAttributeValues2 dbms_sql.varchar2_table;
4018: tempAttributeValues3 dbms_sql.varchar2_table;
4019: tempItemClassIndex integer;
4020: begin
4021: /*
4022: fetchInactives is necessary because we can't use a PL/SQL boolean variable

Line 4190: dynamicCursor := dbms_sql.open_cursor;

4186: ame_util.transactionIdPlaceholder in dynamicQuery get bound.
4187: */
4188: dynamicQuery := ame_util.removeReturns(stringIn => queryStrings(i),
4189: replaceWithSpaces => true);
4190: dynamicCursor := dbms_sql.open_cursor;
4191: dbms_sql.parse(dynamicCursor,
4192: dynamicQuery,
4193: dbms_sql.native);
4194: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then

Line 4191: dbms_sql.parse(dynamicCursor,

4187: */
4188: dynamicQuery := ame_util.removeReturns(stringIn => queryStrings(i),
4189: replaceWithSpaces => true);
4190: dynamicCursor := dbms_sql.open_cursor;
4191: dbms_sql.parse(dynamicCursor,
4192: dynamicQuery,
4193: dbms_sql.native);
4194: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then
4195: dbms_sql.bind_variable(dynamicCursor,

Line 4193: dbms_sql.native);

4189: replaceWithSpaces => true);
4190: dynamicCursor := dbms_sql.open_cursor;
4191: dbms_sql.parse(dynamicCursor,
4192: dynamicQuery,
4193: dbms_sql.native);
4194: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then
4195: dbms_sql.bind_variable(dynamicCursor,
4196: ame_util.transactionIdPlaceholder,
4197: engTransactionId,

Line 4195: dbms_sql.bind_variable(dynamicCursor,

4191: dbms_sql.parse(dynamicCursor,
4192: dynamicQuery,
4193: dbms_sql.native);
4194: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then
4195: dbms_sql.bind_variable(dynamicCursor,
4196: ame_util.transactionIdPlaceholder,
4197: engTransactionId,
4198: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4199: end if;

Line 4201: dbms_sql.bind_variable(dynamicCursor,

4197: engTransactionId,
4198: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4199: end if;
4200: if(instrb(dynamicQuery, ame_util2.itemClassPlaceHolder) > 0) then
4201: dbms_sql.bind_variable(dynamicCursor,
4202: ame_util2.itemClassPlaceHolder,
4203: ame_util.headerItemClassName,
4204: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4205: end if;

Line 4207: dbms_sql.bind_variable(dynamicCursor,

4203: ame_util.headerItemClassName,
4204: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4205: end if;
4206: if(instrb(dynamicQuery, ame_util2.itemIdPlaceHolder) > 0) then
4207: dbms_sql.bind_variable(dynamicCursor,
4208: ame_util2.itemIdPlaceHolder,
4209: engTransactionId,
4210: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4211: end if;

Line 4212: dbms_sql.define_array(dynamicCursor,

4208: ame_util2.itemIdPlaceHolder,
4209: engTransactionId,
4210: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4211: end if;
4212: dbms_sql.define_array(dynamicCursor,
4213: 1,
4214: tempAttributeValues1,
4215: ame_util.attributeValueTypeLength,
4216: 1);

Line 4218: dbms_sql.define_array(dynamicCursor,

4214: tempAttributeValues1,
4215: ame_util.attributeValueTypeLength,
4216: 1);
4217: if(tempAttributeType = ame_util.currencyAttributeType) then
4218: dbms_sql.define_array(dynamicCursor,
4219: 2,
4220: tempAttributeValues2,
4221: ame_util.attributeValueTypeLength,
4222: 1);

Line 4223: dbms_sql.define_array(dynamicCursor,

4219: 2,
4220: tempAttributeValues2,
4221: ame_util.attributeValueTypeLength,
4222: 1);
4223: dbms_sql.define_array(dynamicCursor,
4224: 3,
4225: tempAttributeValues3,
4226: ame_util.attributeValueTypeLength,
4227: 1);

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

4225: tempAttributeValues3,
4226: ame_util.attributeValueTypeLength,
4227: 1);
4228: end if;
4229: rowsFound := dbms_sql.execute(dynamicCursor);
4230: loop
4231: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
4232: dbms_sql.column_value(dynamicCursor,
4233: 1,

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

4227: 1);
4228: end if;
4229: rowsFound := dbms_sql.execute(dynamicCursor);
4230: loop
4231: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
4232: dbms_sql.column_value(dynamicCursor,
4233: 1,
4234: tempAttributeValues1);
4235: if(tempAttributeType = ame_util.currencyAttributeType) then

Line 4232: dbms_sql.column_value(dynamicCursor,

4228: end if;
4229: rowsFound := dbms_sql.execute(dynamicCursor);
4230: loop
4231: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
4232: dbms_sql.column_value(dynamicCursor,
4233: 1,
4234: tempAttributeValues1);
4235: if(tempAttributeType = ame_util.currencyAttributeType) then
4236: dbms_sql.column_value(dynamicCursor,

Line 4236: dbms_sql.column_value(dynamicCursor,

4232: dbms_sql.column_value(dynamicCursor,
4233: 1,
4234: tempAttributeValues1);
4235: if(tempAttributeType = ame_util.currencyAttributeType) then
4236: dbms_sql.column_value(dynamicCursor,
4237: 2,
4238: tempAttributeValues2);
4239: dbms_sql.column_value(dynamicCursor,
4240: 3,

Line 4239: dbms_sql.column_value(dynamicCursor,

4235: if(tempAttributeType = ame_util.currencyAttributeType) then
4236: dbms_sql.column_value(dynamicCursor,
4237: 2,
4238: tempAttributeValues2);
4239: dbms_sql.column_value(dynamicCursor,
4240: 3,
4241: tempAttributeValues3);
4242: end if;
4243: exit when rowsFound < 100;

Line 4245: dbms_sql.close_cursor(dynamicCursor);

4241: tempAttributeValues3);
4242: end if;
4243: exit when rowsFound < 100;
4244: end loop;
4245: dbms_sql.close_cursor(dynamicCursor);
4246: /* Make sure the attribute usage returned the right number of rows. */
4247: if(tempAttributeValues1.count <> engItemCounts(tempItemClassIndex)) then
4248: raise rowCountException;
4249: end if;

Line 4279: if(dbms_sql.is_open(dynamicCursor)) then

4275: when rowCountException then
4276: if(attributeCursor%isopen) then
4277: close attributeCursor;
4278: end if;
4279: if(dbms_sql.is_open(dynamicCursor)) then
4280: dbms_sql.close_cursor(dynamicCursor);
4281: end if;
4282: if(testTransCurrencyCursor%isopen) then
4283: close testTransCurrencyCursor;

Line 4280: dbms_sql.close_cursor(dynamicCursor);

4276: if(attributeCursor%isopen) then
4277: close attributeCursor;
4278: end if;
4279: if(dbms_sql.is_open(dynamicCursor)) then
4280: dbms_sql.close_cursor(dynamicCursor);
4281: end if;
4282: if(testTransCurrencyCursor%isopen) then
4283: close testTransCurrencyCursor;
4284: end if;

Line 4314: if(dbms_sql.is_open(dynamicCursor)) then

4310: when others then
4311: if(attributeCursor%isopen) then
4312: close attributeCursor;
4313: end if;
4314: if(dbms_sql.is_open(dynamicCursor)) then
4315: dbms_sql.close_cursor(dynamicCursor);
4316: end if;
4317: if(testTransCurrencyCursor%isopen) then
4318: close testTransCurrencyCursor;

Line 4315: dbms_sql.close_cursor(dynamicCursor);

4311: if(attributeCursor%isopen) then
4312: close attributeCursor;
4313: end if;
4314: if(dbms_sql.is_open(dynamicCursor)) then
4315: dbms_sql.close_cursor(dynamicCursor);
4316: end if;
4317: if(testTransCurrencyCursor%isopen) then
4318: close testTransCurrencyCursor;
4319: end if;

Line 4486: tempAttributeValues1 dbms_sql.varchar2_table;

4482: tempAttributeValue1 ame_util.attributeValueType;
4483: tempAttributeValue2 ame_util.attributeValueType;
4484: tempAttributeValue3 ame_util.attributeValueType;
4485: tempAttributeValueIndex integer;
4486: tempAttributeValues1 dbms_sql.varchar2_table;
4487: tempAttributeValues2 dbms_sql.varchar2_table;
4488: tempAttributeValues3 dbms_sql.varchar2_table;
4489: tempItemClassIndex integer;
4490: begin

Line 4487: tempAttributeValues2 dbms_sql.varchar2_table;

4483: tempAttributeValue2 ame_util.attributeValueType;
4484: tempAttributeValue3 ame_util.attributeValueType;
4485: tempAttributeValueIndex integer;
4486: tempAttributeValues1 dbms_sql.varchar2_table;
4487: tempAttributeValues2 dbms_sql.varchar2_table;
4488: tempAttributeValues3 dbms_sql.varchar2_table;
4489: tempItemClassIndex integer;
4490: begin
4491: open attributeCursor(applicationIdIn => engAmeApplicationId);

Line 4488: tempAttributeValues3 dbms_sql.varchar2_table;

4484: tempAttributeValue3 ame_util.attributeValueType;
4485: tempAttributeValueIndex integer;
4486: tempAttributeValues1 dbms_sql.varchar2_table;
4487: tempAttributeValues2 dbms_sql.varchar2_table;
4488: tempAttributeValues3 dbms_sql.varchar2_table;
4489: tempItemClassIndex integer;
4490: begin
4491: open attributeCursor(applicationIdIn => engAmeApplicationId);
4492:

Line 4650: dynamicCursor := dbms_sql.open_cursor;

4646: ame_util.transactionIdPlaceholder in dynamicQuery get bound.
4647: */
4648: dynamicQuery := ame_util.removeReturns(stringIn => queryStrings(i),
4649: replaceWithSpaces => true);
4650: dynamicCursor := dbms_sql.open_cursor;
4651: dbms_sql.parse(dynamicCursor,
4652: dynamicQuery,
4653: dbms_sql.native);
4654: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then

Line 4651: dbms_sql.parse(dynamicCursor,

4647: */
4648: dynamicQuery := ame_util.removeReturns(stringIn => queryStrings(i),
4649: replaceWithSpaces => true);
4650: dynamicCursor := dbms_sql.open_cursor;
4651: dbms_sql.parse(dynamicCursor,
4652: dynamicQuery,
4653: dbms_sql.native);
4654: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then
4655: dbms_sql.bind_variable(dynamicCursor,

Line 4653: dbms_sql.native);

4649: replaceWithSpaces => true);
4650: dynamicCursor := dbms_sql.open_cursor;
4651: dbms_sql.parse(dynamicCursor,
4652: dynamicQuery,
4653: dbms_sql.native);
4654: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then
4655: dbms_sql.bind_variable(dynamicCursor,
4656: ame_util.transactionIdPlaceholder,
4657: engTransactionId,

Line 4655: dbms_sql.bind_variable(dynamicCursor,

4651: dbms_sql.parse(dynamicCursor,
4652: dynamicQuery,
4653: dbms_sql.native);
4654: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then
4655: dbms_sql.bind_variable(dynamicCursor,
4656: ame_util.transactionIdPlaceholder,
4657: engTransactionId,
4658: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4659: end if;

Line 4661: dbms_sql.bind_variable(dynamicCursor,

4657: engTransactionId,
4658: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4659: end if;
4660: if(instrb(dynamicQuery, ame_util2.itemClassPlaceHolder) > 0) then
4661: dbms_sql.bind_variable(dynamicCursor,
4662: ame_util2.itemClassPlaceHolder,
4663: ame_util.headerItemClassName,
4664: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4665: end if;

Line 4667: dbms_sql.bind_variable(dynamicCursor,

4663: ame_util.headerItemClassName,
4664: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4665: end if;
4666: if(instrb(dynamicQuery, ame_util2.itemIdPlaceHolder) > 0) then
4667: dbms_sql.bind_variable(dynamicCursor,
4668: ame_util2.itemIdPlaceHolder,
4669: engTransactionId,
4670: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4671: end if;

Line 4672: dbms_sql.define_array(dynamicCursor,

4668: ame_util2.itemIdPlaceHolder,
4669: engTransactionId,
4670: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4671: end if;
4672: dbms_sql.define_array(dynamicCursor,
4673: 1,
4674: tempAttributeValues1,
4675: ame_util.attributeValueTypeLength,
4676: 1);

Line 4678: dbms_sql.define_array(dynamicCursor,

4674: tempAttributeValues1,
4675: ame_util.attributeValueTypeLength,
4676: 1);
4677: if(tempAttributeType = ame_util.currencyAttributeType) then
4678: dbms_sql.define_array(dynamicCursor,
4679: 2,
4680: tempAttributeValues2,
4681: ame_util.attributeValueTypeLength,
4682: 1);

Line 4683: dbms_sql.define_array(dynamicCursor,

4679: 2,
4680: tempAttributeValues2,
4681: ame_util.attributeValueTypeLength,
4682: 1);
4683: dbms_sql.define_array(dynamicCursor,
4684: 3,
4685: tempAttributeValues3,
4686: ame_util.attributeValueTypeLength,
4687: 1);

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

4685: tempAttributeValues3,
4686: ame_util.attributeValueTypeLength,
4687: 1);
4688: end if;
4689: rowsFound := dbms_sql.execute(dynamicCursor);
4690: loop
4691: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
4692: dbms_sql.column_value(dynamicCursor,
4693: 1,

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

4687: 1);
4688: end if;
4689: rowsFound := dbms_sql.execute(dynamicCursor);
4690: loop
4691: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
4692: dbms_sql.column_value(dynamicCursor,
4693: 1,
4694: tempAttributeValues1);
4695: if(tempAttributeType = ame_util.currencyAttributeType) then

Line 4692: dbms_sql.column_value(dynamicCursor,

4688: end if;
4689: rowsFound := dbms_sql.execute(dynamicCursor);
4690: loop
4691: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
4692: dbms_sql.column_value(dynamicCursor,
4693: 1,
4694: tempAttributeValues1);
4695: if(tempAttributeType = ame_util.currencyAttributeType) then
4696: dbms_sql.column_value(dynamicCursor,

Line 4696: dbms_sql.column_value(dynamicCursor,

4692: dbms_sql.column_value(dynamicCursor,
4693: 1,
4694: tempAttributeValues1);
4695: if(tempAttributeType = ame_util.currencyAttributeType) then
4696: dbms_sql.column_value(dynamicCursor,
4697: 2,
4698: tempAttributeValues2);
4699: dbms_sql.column_value(dynamicCursor,
4700: 3,

Line 4699: dbms_sql.column_value(dynamicCursor,

4695: if(tempAttributeType = ame_util.currencyAttributeType) then
4696: dbms_sql.column_value(dynamicCursor,
4697: 2,
4698: tempAttributeValues2);
4699: dbms_sql.column_value(dynamicCursor,
4700: 3,
4701: tempAttributeValues3);
4702: end if;
4703: exit when rowsFound < 100;

Line 4705: dbms_sql.close_cursor(dynamicCursor);

4701: tempAttributeValues3);
4702: end if;
4703: exit when rowsFound < 100;
4704: end loop;
4705: dbms_sql.close_cursor(dynamicCursor);
4706: /* Make sure the attribute usage returned the right number of rows. */
4707: if(tempAttributeValues1.count <> engItemCounts(tempItemClassIndex)) then
4708: raise rowCountException;
4709: end if;

Line 4739: if(dbms_sql.is_open(dynamicCursor)) then

4735: when rowCountException then
4736: if(attributeCursor%isopen) then
4737: close attributeCursor;
4738: end if;
4739: if(dbms_sql.is_open(dynamicCursor)) then
4740: dbms_sql.close_cursor(dynamicCursor);
4741: end if;
4742: if(testTransCurrencyCursor%isopen) then
4743: close testTransCurrencyCursor;

Line 4740: dbms_sql.close_cursor(dynamicCursor);

4736: if(attributeCursor%isopen) then
4737: close attributeCursor;
4738: end if;
4739: if(dbms_sql.is_open(dynamicCursor)) then
4740: dbms_sql.close_cursor(dynamicCursor);
4741: end if;
4742: if(testTransCurrencyCursor%isopen) then
4743: close testTransCurrencyCursor;
4744: end if;

Line 4765: if(dbms_sql.is_open(dynamicCursor)) then

4761: when others then
4762: if(attributeCursor%isopen) then
4763: close attributeCursor;
4764: end if;
4765: if(dbms_sql.is_open(dynamicCursor)) then
4766: dbms_sql.close_cursor(dynamicCursor);
4767: end if;
4768: if(testTransCurrencyCursor%isopen) then
4769: close testTransCurrencyCursor;

Line 4766: dbms_sql.close_cursor(dynamicCursor);

4762: if(attributeCursor%isopen) then
4763: close attributeCursor;
4764: end if;
4765: if(dbms_sql.is_open(dynamicCursor)) then
4766: dbms_sql.close_cursor(dynamicCursor);
4767: end if;
4768: if(testTransCurrencyCursor%isopen) then
4769: close testTransCurrencyCursor;
4770: end if;

Line 5089: itemIds dbms_sql.varchar2_table;

5085: item_class_id = itemClassIdIn
5086: order by item_id;
5087: dynamicCursor integer;
5088: itemIdQuery ame_util.longestStringType;
5089: itemIds dbms_sql.varchar2_table;
5090: lastEngItemIdIndex integer;
5091: rowsFound integer;
5092: tempIndex integer;
5093: tempItemIdQueries ame_util.longestStringList;

Line 5153: dynamicCursor := dbms_sql.open_cursor;

5149: end if;
5150: else
5151: itemIdQuery := ame_util.removeReturns(stringIn => tempItemIdQueries(i),
5152: replaceWithSpaces => true);
5153: dynamicCursor := dbms_sql.open_cursor;
5154: dbms_sql.parse(dynamicCursor,
5155: itemIdQuery,
5156: dbms_sql.native);
5157: if(instrb(itemIdQuery, ame_util.transactionIdPlaceholder, 1, 1) > 0) then

Line 5154: dbms_sql.parse(dynamicCursor,

5150: else
5151: itemIdQuery := ame_util.removeReturns(stringIn => tempItemIdQueries(i),
5152: replaceWithSpaces => true);
5153: dynamicCursor := dbms_sql.open_cursor;
5154: dbms_sql.parse(dynamicCursor,
5155: itemIdQuery,
5156: dbms_sql.native);
5157: if(instrb(itemIdQuery, ame_util.transactionIdPlaceholder, 1, 1) > 0) then
5158: dbms_sql.bind_variable(dynamicCursor,

Line 5156: dbms_sql.native);

5152: replaceWithSpaces => true);
5153: dynamicCursor := dbms_sql.open_cursor;
5154: dbms_sql.parse(dynamicCursor,
5155: itemIdQuery,
5156: dbms_sql.native);
5157: if(instrb(itemIdQuery, ame_util.transactionIdPlaceholder, 1, 1) > 0) then
5158: dbms_sql.bind_variable(dynamicCursor,
5159: ame_util.transactionIdPlaceholder,
5160: engTransactionId,

Line 5158: dbms_sql.bind_variable(dynamicCursor,

5154: dbms_sql.parse(dynamicCursor,
5155: itemIdQuery,
5156: dbms_sql.native);
5157: if(instrb(itemIdQuery, ame_util.transactionIdPlaceholder, 1, 1) > 0) then
5158: dbms_sql.bind_variable(dynamicCursor,
5159: ame_util.transactionIdPlaceholder,
5160: engTransactionId,
5161: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
5162: end if;

Line 5163: dbms_sql.define_array(dynamicCursor,

5159: ame_util.transactionIdPlaceholder,
5160: engTransactionId,
5161: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
5162: end if;
5163: dbms_sql.define_array(dynamicCursor,
5164: 1,
5165: itemIds,
5166: 100,
5167: 1);

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

5164: 1,
5165: itemIds,
5166: 100,
5167: 1);
5168: rowsFound := dbms_sql.execute(dynamicCursor);
5169: loop
5170: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
5171: dbms_sql.column_value(dynamicCursor,
5172: 1,

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

5166: 100,
5167: 1);
5168: rowsFound := dbms_sql.execute(dynamicCursor);
5169: loop
5170: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
5171: dbms_sql.column_value(dynamicCursor,
5172: 1,
5173: itemIds);
5174: exit when rowsFound < 100;

Line 5171: dbms_sql.column_value(dynamicCursor,

5167: 1);
5168: rowsFound := dbms_sql.execute(dynamicCursor);
5169: loop
5170: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
5171: dbms_sql.column_value(dynamicCursor,
5172: 1,
5173: itemIds);
5174: exit when rowsFound < 100;
5175: end loop;

Line 5176: dbms_sql.close_cursor(dynamicCursor);

5172: 1,
5173: itemIds);
5174: exit when rowsFound < 100;
5175: end loop;
5176: dbms_sql.close_cursor(dynamicCursor);
5177: /* Copy the item IDs into engItemIds. */
5178: engItemCounts(i) := itemIds.count;
5179: if(itemIds.count > 0) then
5180: if(lastEngItemIdIndex is null) then

Line 5358: tempGroupMembers dbms_sql.Varchar2_Table;

5354: outputIndex integer;
5355: parameters ame_util.longStringList;
5356: queryStrings ame_util.longestStringList;
5357: rowsFound integer;
5358: tempGroupMembers dbms_sql.Varchar2_Table;
5359: upperParameterNames ame_util.stringList;
5360: tempApproverType ame_util.stringType;
5361: tempApproverId ame_util.stringType;
5362: tempname wf_roles.name%type;

Line 5416: dynamicCursor := dbms_sql.open_cursor;

5412: outputIndex := engGroupMemberGroupIds.count; /* pre-increment */
5413: for i in 1 .. parameters.count loop
5414: tempGroupMembers.delete; -- for bug 4616570
5415: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
5416: dynamicCursor := dbms_sql.open_cursor;
5417: dbms_sql.parse(dynamicCursor,
5418: ame_util.removeReturns(stringIn => queryStrings(i),
5419: replaceWithSpaces => true),
5420: dbms_sql.native);

Line 5417: dbms_sql.parse(dynamicCursor,

5413: for i in 1 .. parameters.count loop
5414: tempGroupMembers.delete; -- for bug 4616570
5415: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
5416: dynamicCursor := dbms_sql.open_cursor;
5417: dbms_sql.parse(dynamicCursor,
5418: ame_util.removeReturns(stringIn => queryStrings(i),
5419: replaceWithSpaces => true),
5420: dbms_sql.native);
5421: engGroupUseItemBind(groupIdIn) := ame_util.booleanFalse;

Line 5420: dbms_sql.native);

5416: dynamicCursor := dbms_sql.open_cursor;
5417: dbms_sql.parse(dynamicCursor,
5418: ame_util.removeReturns(stringIn => queryStrings(i),
5419: replaceWithSpaces => true),
5420: dbms_sql.native);
5421: engGroupUseItemBind(groupIdIn) := ame_util.booleanFalse;
5422: if(instrb(queryStrings(i),
5423: ame_util.transactionIdPlaceholder) > 0) then
5424: dbms_sql.bind_variable(dynamicCursor,

Line 5424: dbms_sql.bind_variable(dynamicCursor,

5420: dbms_sql.native);
5421: engGroupUseItemBind(groupIdIn) := ame_util.booleanFalse;
5422: if(instrb(queryStrings(i),
5423: ame_util.transactionIdPlaceholder) > 0) then
5424: dbms_sql.bind_variable(dynamicCursor,
5425: ame_util.transactionIdPlaceholder,
5426: engTransactionId,
5427: 50);
5428: end if;

Line 5431: dbms_sql.bind_variable(dynamicCursor,

5427: 50);
5428: end if;
5429: if(instrb(queryStrings(i),
5430: ame_util2.itemClassPlaceHolder) > 0) then
5431: dbms_sql.bind_variable(dynamicCursor,
5432: ame_util2.itemClassPlaceHolder,
5433: getItemClassName(itemClassIdIn => engAppRuleItemClassIds(engAppHandlerFirstIndex)),
5434: 50);
5435: engGroupUseItemBind(groupIdIn) := ame_util.booleanTrue;

Line 5439: dbms_sql.bind_variable(dynamicCursor,

5435: engGroupUseItemBind(groupIdIn) := ame_util.booleanTrue;
5436: end if;
5437: if(instrb(queryStrings(i),
5438: ame_util2.itemIdPlaceHolder) > 0) then
5439: dbms_sql.bind_variable(dynamicCursor,
5440: ame_util2.itemIdPlaceHolder,
5441: engAppAppItemIds(engAppHandlerFirstIndex),
5442: 50);
5443: engGroupUseItemBind(groupIdIn) := ame_util.booleanTrue;

Line 5445: dbms_sql.define_array(dynamicCursor,

5441: engAppAppItemIds(engAppHandlerFirstIndex),
5442: 50);
5443: engGroupUseItemBind(groupIdIn) := ame_util.booleanTrue;
5444: end if;
5445: dbms_sql.define_array(dynamicCursor,
5446: 1,
5447: tempGroupMembers,
5448: 100,
5449: 1);

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

5446: 1,
5447: tempGroupMembers,
5448: 100,
5449: 1);
5450: rowsFound := dbms_sql.execute(dynamicCursor);
5451: loop
5452: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
5453: dbms_sql.column_value(dynamicCursor,
5454: 1,

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

5448: 100,
5449: 1);
5450: rowsFound := dbms_sql.execute(dynamicCursor);
5451: loop
5452: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
5453: dbms_sql.column_value(dynamicCursor,
5454: 1,
5455: tempGroupMembers);
5456: exit when rowsFound < 100;

Line 5453: dbms_sql.column_value(dynamicCursor,

5449: 1);
5450: rowsFound := dbms_sql.execute(dynamicCursor);
5451: loop
5452: rowsFound := dbms_sql.fetch_rows(dynamicCursor);
5453: dbms_sql.column_value(dynamicCursor,
5454: 1,
5455: tempGroupMembers);
5456: exit when rowsFound < 100;
5457: end loop;

Line 5458: dbms_sql.close_cursor(dynamicCursor);

5454: 1,
5455: tempGroupMembers);
5456: exit when rowsFound < 100;
5457: end loop;
5458: dbms_sql.close_cursor(dynamicCursor);
5459: /*
5460: Dynamic groups' query strings may return rows having one of two forms:
5461: (1) approver_type:approver_id
5462: (2) orig_system:orig_system_id