DBA Data[Home] [Help]

APPS.IEX_DELINQUENCY_PUB dependencies on IEX_DLN_UWQ_SUMMARY

Line 2344: update IEX_DLN_UWQ_SUMMARY sum

2340:
2341: IF l_level = 'CUSTOMER' THEN
2342:
2343: FORALL i in 1..nCount
2344: update IEX_DLN_UWQ_SUMMARY sum
2345: set
2346: sum.active_delinquencies =
2347: (SELECT 1
2348: FROM dual

Line 2387: update IEX_DLN_UWQ_SUMMARY sum

2383:
2384: ELSIF l_level = 'ACCOUNT' THEN
2385:
2386: FORALL i in 1..nCount
2387: update IEX_DLN_UWQ_SUMMARY sum
2388: set
2389: sum.active_delinquencies =
2390: (SELECT 1
2391: FROM dual

Line 2430: update IEX_DLN_UWQ_SUMMARY sum

2426:
2427: ELSIF l_level = 'BILL_TO' THEN
2428:
2429: FORALL i in 1..nCount
2430: update IEX_DLN_UWQ_SUMMARY sum
2431: set
2432: sum.active_delinquencies =
2433: (SELECT 1
2434: FROM dual

Line 2472: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Updated ' || SQL%ROWCOUNT || ' rows in IEX_DLN_UWQ_SUMMARY');

2468: where delinquency_id = p_delinquency_id_tbl(i));
2469:
2470: END IF;
2471:
2472: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Updated ' || SQL%ROWCOUNT || ' rows in IEX_DLN_UWQ_SUMMARY');
2473: -- end of fix for bug 5874874 gnramasa 25-Apr-07
2474:
2475: else
2476: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN