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

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

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

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

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

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

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

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

4234: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then
4235: dbms_sql.bind_variable(dynamicCursor,
4236: ame_util.transactionIdPlaceholder,
4237: engTransactionId,
4238: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4239: end if;
4240: if(instrb(dynamicQuery, ame_util2.itemClassPlaceHolder) > 0) then
4241: dbms_sql.bind_variable(dynamicCursor,
4242: ame_util2.itemClassPlaceHolder,

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

4240: if(instrb(dynamicQuery, ame_util2.itemClassPlaceHolder) > 0) then
4241: dbms_sql.bind_variable(dynamicCursor,
4242: ame_util2.itemClassPlaceHolder,
4243: ame_util.headerItemClassName,
4244: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4245: end if;
4246: if(instrb(dynamicQuery, ame_util2.itemIdPlaceHolder) > 0) then
4247: dbms_sql.bind_variable(dynamicCursor,
4248: ame_util2.itemIdPlaceHolder,

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

4246: if(instrb(dynamicQuery, ame_util2.itemIdPlaceHolder) > 0) then
4247: dbms_sql.bind_variable(dynamicCursor,
4248: ame_util2.itemIdPlaceHolder,
4249: engTransactionId,
4250: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4251: end if;
4252: dbms_sql.define_array(dynamicCursor,
4253: 1,
4254: tempAttributeValues1,

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

4694: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder) > 0) then
4695: dbms_sql.bind_variable(dynamicCursor,
4696: ame_util.transactionIdPlaceholder,
4697: engTransactionId,
4698: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4699: end if;
4700: if(instrb(dynamicQuery, ame_util2.itemClassPlaceHolder) > 0) then
4701: dbms_sql.bind_variable(dynamicCursor,
4702: ame_util2.itemClassPlaceHolder,

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

4700: if(instrb(dynamicQuery, ame_util2.itemClassPlaceHolder) > 0) then
4701: dbms_sql.bind_variable(dynamicCursor,
4702: ame_util2.itemClassPlaceHolder,
4703: ame_util.headerItemClassName,
4704: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4705: end if;
4706: if(instrb(dynamicQuery, ame_util2.itemIdPlaceHolder) > 0) then
4707: dbms_sql.bind_variable(dynamicCursor,
4708: ame_util2.itemIdPlaceHolder,

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

4706: if(instrb(dynamicQuery, ame_util2.itemIdPlaceHolder) > 0) then
4707: dbms_sql.bind_variable(dynamicCursor,
4708: ame_util2.itemIdPlaceHolder,
4709: engTransactionId,
4710: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
4711: end if;
4712: dbms_sql.define_array(dynamicCursor,
4713: 1,
4714: tempAttributeValues1,

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

5197: if(instrb(itemIdQuery, ame_util.transactionIdPlaceholder, 1, 1) > 0) then
5198: dbms_sql.bind_variable(dynamicCursor,
5199: ame_util.transactionIdPlaceholder,
5200: engTransactionId,
5201: 50); /* ame_temp_transactions.transaction_id%length doesn't work here. */
5202: end if;
5203: dbms_sql.define_array(dynamicCursor,
5204: 1,
5205: itemIds,

Line 8745: from ame_temp_transactions

8741: only necessary for "real" transactions created for debugging purposes.)
8742: */
8743: select count(*)
8744: into tempCount
8745: from ame_temp_transactions
8746: where
8747: application_id = ameApplicationIdIn and
8748: transaction_id = transactionIdIn and
8749: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */

Line 8751: insert into ame_temp_transactions(

8747: application_id = ameApplicationIdIn and
8748: transaction_id = transactionIdIn and
8749: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
8750: if(tempCount = 0) then
8751: insert into ame_temp_transactions(
8752: application_id,
8753: transaction_id,
8754: temp_transactions_id,
8755: row_timestamp) values(

Line 9688: from ame_temp_transactions

9684: begin
9685: /* Log the transaction for eventual purging from the temp tables. */
9686: select count(*)
9687: into tempCount
9688: from ame_temp_transactions
9689: where
9690: application_id = engAmeApplicationId and
9691: transaction_id = engTransactionId and
9692: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */

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

9690: application_id = engAmeApplicationId and
9691: transaction_id = engTransactionId and
9692: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
9693: if(tempCount = 0) then
9694: select ame_temp_transactions_s.nextval into tempTransSeqId from dual;
9695: insert into ame_temp_transactions(
9696: application_id,
9697: transaction_id,
9698: row_timestamp,

Line 9695: insert into ame_temp_transactions(

9691: transaction_id = engTransactionId and
9692: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
9693: if(tempCount = 0) then
9694: select ame_temp_transactions_s.nextval into tempTransSeqId from dual;
9695: insert into ame_temp_transactions(
9696: application_id,
9697: transaction_id,
9698: row_timestamp,
9699: temp_transactions_id