eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_DISTRIBUTIONS_PUB dependencies on PSA_BC_REPORT_EVENTS_GT

Line 297: -- steps 1. delete from PSA_BC_REPORT_EVENTS_GT

293:
294: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
295: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_id ' || p_loan_id);
296:
297: -- steps 1. delete from PSA_BC_REPORT_EVENTS_GT
298: -- 2. insert into PSA_BC_REPORT_EVENTS_GT
299: -- 3. generate sequence
300: -- 4. call Create_BC_Transaction_report API
301: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'deleting from PSA_BC_REPORT_EVENTS_GT');

Line 298: -- 2. insert into PSA_BC_REPORT_EVENTS_GT

294: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
295: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_id ' || p_loan_id);
296:
297: -- steps 1. delete from PSA_BC_REPORT_EVENTS_GT
298: -- 2. insert into PSA_BC_REPORT_EVENTS_GT
299: -- 3. generate sequence
300: -- 4. call Create_BC_Transaction_report API
301: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'deleting from PSA_BC_REPORT_EVENTS_GT');
302: DELETE FROM PSA_BC_REPORT_EVENTS_GT;

Line 301: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'deleting from PSA_BC_REPORT_EVENTS_GT');

297: -- steps 1. delete from PSA_BC_REPORT_EVENTS_GT
298: -- 2. insert into PSA_BC_REPORT_EVENTS_GT
299: -- 3. generate sequence
300: -- 4. call Create_BC_Transaction_report API
301: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'deleting from PSA_BC_REPORT_EVENTS_GT');
302: DELETE FROM PSA_BC_REPORT_EVENTS_GT;
303:
304: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'opening c_event...');
305: open c_event(p_loan_id);

Line 302: DELETE FROM PSA_BC_REPORT_EVENTS_GT;

298: -- 2. insert into PSA_BC_REPORT_EVENTS_GT
299: -- 3. generate sequence
300: -- 4. call Create_BC_Transaction_report API
301: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'deleting from PSA_BC_REPORT_EVENTS_GT');
302: DELETE FROM PSA_BC_REPORT_EVENTS_GT;
303:
304: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'opening c_event...');
305: open c_event(p_loan_id);
306: LOOP

Line 317: INSERT INTO PSA_BC_REPORT_EVENTS_GT

313: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_event_id = ' || l_event_id);
314: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_distribution_id = ' || l_distribution_id);
315: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_ledger_id = ' || l_ledger_id);
316: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into psa table...');
317: INSERT INTO PSA_BC_REPORT_EVENTS_GT
318: (event_id
319: ,SOURCE_DISTRIBUTION_ID_NUM_1
320: ,SOURCE_DISTRIBUTION_ID_NUM_2)
321: values(l_event_id

Line 333: FROM PSA_BC_REPORT_EVENTS_GT;

329: into l_sequence_id
330: from dual;
331:
332: SELECT count(*) INTO l_count
333: FROM PSA_BC_REPORT_EVENTS_GT;
334: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'rows found ' || l_count);
335:
336: IF l_count > 0 then
337: