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.IEX_DUNNING_PUB dependencies on IEX_DELINQUENCIES_ALL

Line 432: ' iex_delinquencies_all delin ' ||

428: ' hz_party_sites party_site, ' ||
429: ' hz_cust_accounts ca, ' ||
430: ' hz_cust_site_uses_all site_uses, ' ||
431: ' hz_parties p,' ||
432: ' iex_delinquencies_all delin ' ||
433: ' WHERE acct_sites.cust_account_id = ca.cust_account_id ' ||
434: ' AND acct_sites.party_site_id = party_site.party_site_id ' ||
435: ' AND acct_sites.cust_acct_site_id = site_uses.cust_acct_site_id ' ||
436: ' AND site_uses.site_use_code = ''BILL_TO'' ' ||

Line 1432: update iex_delinquencies_all

1428: exit when sql_cur5%NOTFOUND;
1429: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_payment_schedule_id :' || l_payment_schedule_id);
1430: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_stage_number :' || l_stage_number);
1431:
1432: update iex_delinquencies_all
1433: set staged_dunning_level = l_stage_number
1434: where payment_schedule_id = l_payment_schedule_id;
1435: end loop;
1436: close sql_cur5;

Line 2569: from iex_delinquencies_all iex,

2565:
2566: cursor c_staged_dunning_level is
2567: select ar.staged_dunning_level,
2568: ar.payment_schedule_id
2569: from iex_delinquencies_all iex,
2570: ar_payment_schedules_all ar
2571: where iex.payment_schedule_id = ar.payment_schedule_id
2572: and ar.staged_dunning_level is not null
2573: and iex.staged_dunning_level is null

Line 2801: --Copy the Staged level of an Invoice from AR_PAYMENT_SCHEDULES_ALL table to IEX_DELINQUENCIES_ALL table.

2797: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2798:
2799: l_staged_dunning_level.delete;
2800: l_payment_schedule_id.delete;
2801: --Copy the Staged level of an Invoice from AR_PAYMENT_SCHEDULES_ALL table to IEX_DELINQUENCIES_ALL table.
2802: --It will update only the records that have staged_dunning_level as NULL
2803: BEGIN
2804: OPEN c_staged_dunning_level;
2805: LOOP

Line 2812: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No of rows updated in iex_delinquencies_all is: ' || l_no_updated_rows);

2808: l_payment_schedule_id
2809: LIMIT G_BATCH_SIZE;
2810: IF l_staged_dunning_level.count = 0 THEN
2811:
2812: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No of rows updated in iex_delinquencies_all is: ' || l_no_updated_rows);
2813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exit after Updating iex_delinquencies_all staged_dunning_level...');
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 2813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exit after Updating iex_delinquencies_all staged_dunning_level...');

2809: LIMIT G_BATCH_SIZE;
2810: IF l_staged_dunning_level.count = 0 THEN
2811:
2812: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No of rows updated in iex_delinquencies_all is: ' || l_no_updated_rows);
2813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exit after Updating iex_delinquencies_all staged_dunning_level...');
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');

Line 2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);

2811:
2812: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No of rows updated in iex_delinquencies_all is: ' || l_no_updated_rows);
2813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exit after Updating iex_delinquencies_all staged_dunning_level...');
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');
2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');
2819: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I) ');

Line 2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');

2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');
2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');
2819: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I) ');
2820: FND_FILE.PUT_LINE(FND_FILE.LOG, ' WHERE PAYMENT_SCHEDULE_ID = l_payment_schedule_id(I); ');
2821: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2822:

Line 2827: UPDATE IEX_DELINQUENCIES_ALL IEX

2823: CLOSE c_staged_dunning_level;
2824: EXIT;
2825: ELSE
2826: FORALL I IN l_staged_dunning_level.first..l_staged_dunning_level.last
2827: UPDATE IEX_DELINQUENCIES_ALL IEX
2828: SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I)
2829: WHERE PAYMENT_SCHEDULE_ID = l_payment_schedule_id(I);
2830:
2831: l_no_updated_rows := l_no_updated_rows + l_staged_dunning_level.count;

Line 2838: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Rows updated in iex_delinquencies_all staged_dunning_level...');

2834: l_payment_schedule_id.delete;
2835:
2836: commit;
2837:
2838: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Rows updated in iex_delinquencies_all staged_dunning_level...');
2839: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transactions stage level from AR to Advanced Collections');
2840: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2841:
2842: END IF;