DBA Data[Home] [Help]

APPS.AME_TRANS_DATA_PURGE dependencies on AME_TXN_APPROVERS

Line 233: delete from ame_txn_approvers

229: end if;
230: if applicationIdIn is not null and ameApplicationId is not null then
231: tempApplication := ameApplicationId;
232: begin
233: delete from ame_txn_approvers
234: where temp_transactions_id in
235: (select temp_transactions_id
236: from ame_temp_transactions
237: where trunc(row_timestamp) <= dateToDelete

Line 258: delete from ame_txn_approvers

254: fetch getApplicationList bulk collect into applicationIdList;
255: close getApplicationList;
256: begin
257: for i in 1..applicationIdList.count loop
258: delete from ame_txn_approvers
259: where temp_transactions_id in
260: (select temp_transactions_id
261: from ame_temp_transactions
262: where trunc(row_timestamp) <= dateToDelete

Line 281: delete from ame_txn_approvers

277: FND_FILE.PUT_LINE (FND_FILE.LOG,sqlerrm);
278: end;
279: elsif tempTxnId is null and tempFndapplicationId is null then
280: begin
281: delete from ame_txn_approvers
282: where temp_transactions_id in
283: (select temp_transactions_id
284: from ame_temp_transactions
285: where trunc(row_timestamp) <= dateToDelete);