APPS.AME_TRANS_DATA_PURGE dependencies on AME_TEMP_TRANSACTIONS

Line 22: from ame_temp_transactions

18: sysdate between start_date and
19: nvl(end_date - ame_util.oneSecond, sysdate);
20: cursor tempTransaction is
21: select transaction_id
22: from ame_temp_transactions
23: where application_id = applicationIdIn and
24: row_timestamp < lastDateToSave;
25: cursor oldApproverCursor(applicationIdIn in integer,
26: transactionIdIn in varchar2) is

Line 45: transactionId ame_temp_transactions.transaction_id%type;

41: transaction_id = transactionIdIn
42: order by order_number;
43: tempIndex integer;
44: attributeId integer;
45: transactionId ame_temp_transactions.transaction_id%type;
46: transactionIds ame_util.stringList;
47: bulkFetchRowLimit number := 1000;
48: approverNames ame_util.longStringList;
49: approverItemClasses ame_util.stringList;

Line 165: /* ame_temp_transactions */

161: forall ct in transactionIds.first..transactionIds.last
162: delete from ame_trans_approval_history
163: where application_id = applicationIdIn and
164: transaction_id = transactionIds(ct);
165: /* ame_temp_transactions */
166: forall ct in transactionIds.first..transactionIds.last
167: delete from ame_temp_transactions
168: where application_id = applicationIdIn
169: and transaction_id = transactionIds(ct)

Line 167: delete from ame_temp_transactions

163: where application_id = applicationIdIn and
164: transaction_id = transactionIds(ct);
165: /* ame_temp_transactions */
166: forall ct in transactionIds.first..transactionIds.last
167: delete from ame_temp_transactions
168: where application_id = applicationIdIn
169: and transaction_id = transactionIds(ct)
170: and trans_deviation_flag is null or trans_deviation_flag = 'D';
171: end if;

Line 236: from ame_temp_transactions

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
238: and application_id = tempApplication);
239: FND_FILE.PUT_LINE (FND_FILE.LOG,'number of rows deleted:'||sql%rowcount);
240: update ame_temp_transactions

Line 240: update ame_temp_transactions

236: from ame_temp_transactions
237: where trunc(row_timestamp) <= dateToDelete
238: and application_id = tempApplication);
239: FND_FILE.PUT_LINE (FND_FILE.LOG,'number of rows deleted:'||sql%rowcount);
240: update ame_temp_transactions
241: set trans_deviation_flag = 'D'
242: where trunc(row_timestamp) <= dateToDelete
243: and application_id = tempApplication;
244: exception

Line 261: from ame_temp_transactions

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
263: and application_id = applicationIdList(i));
264: FND_FILE.PUT_LINE (FND_FILE.LOG,'AME internal application id:'||applicationIdList(i));
265: FND_FILE.PUT_LINE (FND_FILE.LOG,'number of rows deleted:'||sql%rowcount);

Line 266: update ame_temp_transactions

262: where trunc(row_timestamp) <= dateToDelete
263: and application_id = applicationIdList(i));
264: FND_FILE.PUT_LINE (FND_FILE.LOG,'AME internal application id:'||applicationIdList(i));
265: FND_FILE.PUT_LINE (FND_FILE.LOG,'number of rows deleted:'||sql%rowcount);
266: update ame_temp_transactions
267: set trans_deviation_flag = 'D'
268: where trunc(row_timestamp) <= dateToDelete
269: and application_id = applicationIdList(i);
270: end loop;

Line 284: from ame_temp_transactions

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);
286: FND_FILE.PUT_LINE (FND_FILE.LOG,'number of rows deleted:'||sql%rowcount);
287: update ame_temp_transactions
288: set trans_deviation_flag = 'D'

Line 287: update ame_temp_transactions

283: (select temp_transactions_id
284: from ame_temp_transactions
285: where trunc(row_timestamp) <= dateToDelete);
286: FND_FILE.PUT_LINE (FND_FILE.LOG,'number of rows deleted:'||sql%rowcount);
287: update ame_temp_transactions
288: set trans_deviation_flag = 'D'
289: where trunc(row_timestamp) <= dateToDelete;
290: exception
291: when others then