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 AME_TEMP_TRANSACTIONS

Line 614: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */

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;
616: if(instrb(dynamicQuery, ame_util2.itemClassPlaceHolder) > 0) then
617: dbms_sql.bind_variable(dynamicCursor,
618: ame_util2.itemClassPlaceHolder,

Line 620: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */

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;
622: if(instrb(dynamicQuery, ame_util2.itemIdPlaceHolder) > 0) then
623: dbms_sql.bind_variable(dynamicCursor,
624: ame_util2.itemIdPlaceHolder,

Line 626: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */

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;
628: dbms_sql.define_array(dynamicCursor,
629: 1,
630: tempAttributeValues1,

Line 4198: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */

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;
4200: if(instrb(dynamicQuery, ame_util2.itemClassPlaceHolder) > 0) then
4201: dbms_sql.bind_variable(dynamicCursor,
4202: ame_util2.itemClassPlaceHolder,

Line 4204: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */

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;
4206: if(instrb(dynamicQuery, ame_util2.itemIdPlaceHolder) > 0) then
4207: dbms_sql.bind_variable(dynamicCursor,
4208: ame_util2.itemIdPlaceHolder,

Line 4210: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */

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;
4212: dbms_sql.define_array(dynamicCursor,
4213: 1,
4214: tempAttributeValues1,

Line 4658: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */

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;
4660: if(instrb(dynamicQuery, ame_util2.itemClassPlaceHolder) > 0) then
4661: dbms_sql.bind_variable(dynamicCursor,
4662: ame_util2.itemClassPlaceHolder,

Line 4664: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */

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;
4666: if(instrb(dynamicQuery, ame_util2.itemIdPlaceHolder) > 0) then
4667: dbms_sql.bind_variable(dynamicCursor,
4668: ame_util2.itemIdPlaceHolder,

Line 4670: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */

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;
4672: dbms_sql.define_array(dynamicCursor,
4673: 1,
4674: tempAttributeValues1,

Line 5161: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */

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;
5163: dbms_sql.define_array(dynamicCursor,
5164: 1,
5165: itemIds,

Line 8466: from ame_temp_transactions

8462: only necessary for "real" transactions created for debugging purposes.)
8463: */
8464: select count(*)
8465: into tempCount
8466: from ame_temp_transactions
8467: where
8468: application_id = ameApplicationIdIn and
8469: transaction_id = transactionIdIn and
8470: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */

Line 8472: insert into ame_temp_transactions(

8468: application_id = ameApplicationIdIn and
8469: transaction_id = transactionIdIn and
8470: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
8471: if(tempCount = 0) then
8472: insert into ame_temp_transactions(
8473: application_id,
8474: transaction_id,
8475: row_timestamp) values(
8476: ameApplicationIdIn,

Line 9284: from ame_temp_transactions

9280: begin
9281: /* Log the transaction for eventual purging from the temp tables. */
9282: select count(*)
9283: into tempCount
9284: from ame_temp_transactions
9285: where
9286: application_id = engAmeApplicationId and
9287: transaction_id = engTransactionId and
9288: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */

Line 9290: select ame_temp_transactions_s.nextval into tempTransSeqId from dual;

9286: application_id = engAmeApplicationId and
9287: transaction_id = engTransactionId and
9288: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
9289: if(tempCount = 0) then
9290: select ame_temp_transactions_s.nextval into tempTransSeqId from dual;
9291: insert into ame_temp_transactions(
9292: application_id,
9293: transaction_id,
9294: row_timestamp,

Line 9291: insert into ame_temp_transactions(

9287: transaction_id = engTransactionId and
9288: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
9289: if(tempCount = 0) then
9290: select ame_temp_transactions_s.nextval into tempTransSeqId from dual;
9291: insert into ame_temp_transactions(
9292: application_id,
9293: transaction_id,
9294: row_timestamp,
9295: temp_transactions_id