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 9239: from ame_temp_trans_locks

9235: transactionTypeIdIn in varchar2 default null) as
9236: tempTransIsLocked varchar2(2);
9237: cursor IsEngLocked is
9238: select 'Y'
9239: from ame_temp_trans_locks
9240: where fnd_application_id = fndApplicationIdIn
9241: and transaction_id = transactionIdIn
9242: and transaction_type_id = transactionTypeIdIn;
9243: begin

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

9241: and transaction_id = transactionIdIn
9242: and transaction_type_id = transactionTypeIdIn;
9243: begin
9244: /*
9245: The ame_temp_trans_locks_pk unique index will prevent the following insert from occurring
9246: if another row has already been inserted into ame_temp_trans_locks with the same
9247: fnd_application_id, transaction_type_id, and transaction_id values (even though the other
9248: insert is not committed).
9249: */

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

9242: and transaction_type_id = transactionTypeIdIn;
9243: begin
9244: /*
9245: The ame_temp_trans_locks_pk unique index will prevent the following insert from occurring
9246: if another row has already been inserted into ame_temp_trans_locks with the same
9247: fnd_application_id, transaction_type_id, and transaction_id values (even though the other
9248: insert is not committed).
9249: */
9250: tempTransIsLocked := null;

Line 9260: insert into ame_temp_trans_locks(fnd_application_id,

9256: close IsEngLocked;
9257: if tempTransIsLocked = 'Y' then
9258: return;
9259: end if;
9260: insert into ame_temp_trans_locks(fnd_application_id,
9261: transaction_type_id,
9262: transaction_id,
9263: row_timestamp) values(
9264: fndApplicationIdIn,

Line 11744: delete from ame_temp_trans_locks

11740: transactionIdIn in varchar2,
11741: transactionTypeIdIn in varchar2 default null) as
11742: begin
11743: if(engTransactionIsLocked) then
11744: delete from ame_temp_trans_locks
11745: where
11746: fnd_application_id = fndApplicationIdIn and
11747: ((transaction_type_id is null and transactionTypeIdIn is null) or
11748: transaction_type_id = transactionTypeIdIn) and