DBA Data[Home] [Help]

APPS.AR_TRX_SUMMARY_PKG dependencies on AR_SUM_REF_EVENT_HIST

Line 2506: FROM ar_sum_ref_event_hist;

2502: retcode IN OUT NOCOPY VARCHAR2) IS
2503:
2504: CURSOR get_raised_events IS
2505: SELECT *
2506: FROM ar_sum_ref_event_hist;
2507:
2508: l_list WF_PARAMETER_LIST_T;
2509: l_status VARCHAR2(1); -- junk variable
2510: l_industry VARCHAR2(1); -- junk variable

Line 2600: /* Clean out the AR_SUM_REF_EVENT_HIST table */

2596: END LOOP;
2597:
2598: fnd_file.put_line(fnd_file.log,' events processed = ' || l_count);
2599:
2600: /* Clean out the AR_SUM_REF_EVENT_HIST table */
2601: IF FND_INSTALLATION.get_app_info('AR', l_status, l_industry, l_schema)
2602: THEN
2603: IF PG_DEBUG in ('Y', 'C') THEN
2604: arp_standard.debug('Retrieved schema for AR : ' || l_schema);

Line 2618: EXECUTE IMMEDIATE 'truncate table ' || l_schema || '.AR_SUM_REF_EVENT_HIST';

2614: /* If schema is set, clear event table */
2615: IF l_schema IS NOT NULL
2616: THEN
2617: /* clear the event holding table as well */
2618: EXECUTE IMMEDIATE 'truncate table ' || l_schema || '.AR_SUM_REF_EVENT_HIST';
2619: END IF;
2620:
2621: /* Delete any remaining rows (for refresh) from conc table
2622: This is really just precautionary in that (in theory), no events