APPS.ARI_DB_UTILITIES dependencies on AR_IREC_USER_ACCT_SITES_ALL

Line 555: ar_irec_user_acct_sites_all AcctSites,

551: decode(v_bucket_category,
552: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
553: 1))) b6
554: from ar_payment_schedules ps,
555: ar_irec_user_acct_sites_all AcctSites,
556: ra_customer_trx ct
557: where ps.status = 'OP'
558: and AcctSites.user_id=FND_GLOBAL.USER_ID()
559: and AcctSites.customer_id=ps.customer_id

Line 712: ar_irec_user_acct_sites_all AcctSites,

708: decode(v_bucket_category,
709: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
710: 1))) b6
711: from ar_payment_schedules ps,
712: ar_irec_user_acct_sites_all AcctSites,
713: ra_customer_trx ct
714: where ps.status = 'OP'
715: and AcctSites.user_id=FND_GLOBAL.USER_ID()
716: and AcctSites.customer_id=ps.customer_id

Line 1819: fnd_message.set_token('ENTITY', 'AR_IREC_USER_ACCT_SITES_ALL');

1815: end if;
1816: end if;
1817:
1818: fnd_message.set_name('FND', 'PURGING_UP_TO_DATE');
1819: fnd_message.set_token('ENTITY', 'AR_IREC_USER_ACCT_SITES_ALL');
1820: fnd_message.set_token('DATE', l_purge_date);
1821: msgbuf := fnd_message.get;
1822: FND_FILE.put_line(FND_FILE.log, msgbuf);
1823:

Line 1824: select count(*) into numrows from ar_irec_user_acct_sites_all where trunc(creation_date) < trunc(l_purge_date);

1820: fnd_message.set_token('DATE', l_purge_date);
1821: msgbuf := fnd_message.get;
1822: FND_FILE.put_line(FND_FILE.log, msgbuf);
1823:
1824: select count(*) into numrows from ar_irec_user_acct_sites_all where trunc(creation_date) < trunc(l_purge_date);
1825: delete from ar_irec_user_acct_sites_all where trunc(creation_date) < trunc(l_purge_date);
1826: commit;
1827:
1828: fnd_file.put_line( FND_FILE.LOG, '+---------------------------------------------------------------------------+');

Line 1825: delete from ar_irec_user_acct_sites_all where trunc(creation_date) < trunc(l_purge_date);

1821: msgbuf := fnd_message.get;
1822: FND_FILE.put_line(FND_FILE.log, msgbuf);
1823:
1824: select count(*) into numrows from ar_irec_user_acct_sites_all where trunc(creation_date) < trunc(l_purge_date);
1825: delete from ar_irec_user_acct_sites_all where trunc(creation_date) < trunc(l_purge_date);
1826: commit;
1827:
1828: fnd_file.put_line( FND_FILE.LOG, '+---------------------------------------------------------------------------+');
1829:

Line 1836: message => 'Purging AR_IREC_USER_ACCT_SITES_ALL completed successfully');

1832: msgbuf := fnd_message.get;
1833: FND_FILE.put_line(FND_FILE.log, msgbuf);
1834: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1835: status => l_cp_return_status,
1836: message => 'Purging AR_IREC_USER_ACCT_SITES_ALL completed successfully');
1837: exception
1838: when others then
1839: errbuf := sqlerrm;
1840: retcode := '2';