APPS.AME_TRANS_DATA_PURGE dependencies on AME_TEMP_OLD_APPROVER_LISTS

Line 38: from ame_temp_old_approver_lists

34: approval_status,
35: action_type_id,
36: group_or_chain_id,
37: occurrence
38: from ame_temp_old_approver_lists
39: where
40: application_id = applicationIdIn and
41: transaction_id = transactionIdIn
42: order by order_number;

Line 95: /* For each transaction retrieve the approver list from ame_temp_old_approver_lists */

91: /* Check whether every transaction retrieved is complete or not */
92: for i in 1 .. transactionIds.count
93: loop
94: if purgeTypeIn <> 'Y' then
95: /* For each transaction retrieve the approver list from ame_temp_old_approver_lists */
96: open oldApproverCursor(applicationIdIn=> applicationIdIn
97: ,transactionIdIn=> transactionIds(i));
98: fetch oldApproverCursor bulk collect into
99: approverNames

Line 145: /* ame_temp_old_approver_lists */

141: ame_util.compactStringList(stringListInOut => transactionIds);
142: /* Do bulk deletes */
143: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'No.of transaction ids to be purged: '||transactionIds.count);
144: if(transactionIds.count > 0) then
145: /* ame_temp_old_approver_lists */
146: forall ct in transactionIds.first..transactionIds.last
147: delete from ame_temp_old_approver_lists
148: where application_id = applicationIdIn and
149: transaction_id = transactionIds(ct);

Line 147: delete from ame_temp_old_approver_lists

143: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'No.of transaction ids to be purged: '||transactionIds.count);
144: if(transactionIds.count > 0) then
145: /* ame_temp_old_approver_lists */
146: forall ct in transactionIds.first..transactionIds.last
147: delete from ame_temp_old_approver_lists
148: where application_id = applicationIdIn and
149: transaction_id = transactionIds(ct);
150: /* ame_temp_insertions */
151: forall ct in transactionIds.first..transactionIds.last