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_TRANS_LOCKS

Line 9643: from ame_temp_trans_locks

9639: transactionTypeIdIn in varchar2 default null) as
9640: tempTransIsLocked varchar2(2);
9641: cursor IsEngLocked is
9642: select 'Y'
9643: from ame_temp_trans_locks
9644: where fnd_application_id = fndApplicationIdIn
9645: and transaction_id = transactionIdIn
9646: and transaction_type_id = transactionTypeIdIn;
9647: begin

Line 9649: The ame_temp_trans_locks_pk unique index will prevent the following insert from occurring

9645: and transaction_id = transactionIdIn
9646: and transaction_type_id = transactionTypeIdIn;
9647: begin
9648: /*
9649: The ame_temp_trans_locks_pk unique index will prevent the following insert from occurring
9650: if another row has already been inserted into ame_temp_trans_locks with the same
9651: fnd_application_id, transaction_type_id, and transaction_id values (even though the other
9652: insert is not committed).
9653: */

Line 9650: if another row has already been inserted into ame_temp_trans_locks with the same

9646: and transaction_type_id = transactionTypeIdIn;
9647: begin
9648: /*
9649: The ame_temp_trans_locks_pk unique index will prevent the following insert from occurring
9650: if another row has already been inserted into ame_temp_trans_locks with the same
9651: fnd_application_id, transaction_type_id, and transaction_id values (even though the other
9652: insert is not committed).
9653: */
9654: tempTransIsLocked := null;

Line 9664: insert into ame_temp_trans_locks(fnd_application_id,

9660: close IsEngLocked;
9661: if tempTransIsLocked = 'Y' then
9662: return;
9663: end if;
9664: insert into ame_temp_trans_locks(fnd_application_id,
9665: transaction_type_id,
9666: transaction_id,
9667: row_timestamp) values(
9668: fndApplicationIdIn,

Line 12215: delete from ame_temp_trans_locks

12211: transactionIdIn in varchar2,
12212: transactionTypeIdIn in varchar2 default null) as
12213: begin
12214: if(engTransactionIsLocked) then
12215: delete from ame_temp_trans_locks
12216: where
12217: fnd_application_id = fndApplicationIdIn and
12218: ((transaction_type_id is null and transactionTypeIdIn is null) or
12219: transaction_type_id = transactionTypeIdIn) and