[Home] [Help]
1455: -- Get Unavailable Record Count First
1456: BEGIN
1457: SELECT NVL(COUNT(*), 0)
1458: INTO L_RECORD_UNAVAIL_COUNT
1459: FROM iec_g_return_entries a, IEC_G_MKTG_ITEM_CC_TZS C
1460: WHERE C.ITM_CC_TZ_ID = a.itm_cc_tz_id
1461: AND a.itm_cc_tz_id = X_ITM_CC_TZ_ID
1462: AND NVL(a.DO_NOT_USE_FLAG, 'N') = 'N'
1463: AND (C.CALLABLE_FLAG IS NULL
1478: --
1479: -- Check the section callable status first.
1480: -- If the section is not callable set the
1481: -- available count to 0 immediately
1482: -- to avoid scanning iec_g_return_entries
1483:
1484: BEGIN
1485: SELECT A.CALLABLE_FLAG, A.LAST_CALLABLE_TIME
1486: INTO L_CALLABLE_FLAG, L_LAST_CALLABLE_TIME
1504: --
1505: L_RECORD_AVAIL_COUNT := 0;
1506: ELSE
1507: --
1508: -- Section is callable, scan iec_g_return_entries
1509: -- All useable records are consider available except
1510: -- those records scheduled to be call back at
1511: -- a future time.
1512: --
1512: --
1513: BEGIN
1514: SELECT NVL(COUNT(*), 0)
1515: INTO L_RECORD_AVAIL_COUNT
1516: FROM iec_g_return_entries a, IEC_G_MKTG_ITEM_CC_TZS C
1517: WHERE C.ITM_CC_TZ_ID = a.itm_cc_tz_id
1518: AND a.itm_cc_tz_id = X_ITM_CC_TZ_ID
1519: AND NVL(a.DO_NOT_USE_FLAG, 'N') = 'N'
1520: AND (C.CALLABLE_FLAG = 'Y' AND C.LAST_CALLABLE_TIME > SYSDATE
1567: --------------------------------------------------------
1568: -- The following rules are set for the updates in order
1569: -- to keep the record counts recent and reduce the number of
1570: -- scans to avoid the performance problem, because each update
1571: -- needs to scan iec_g_return_entries.
1572: --
1573: -- The rules for checking all campaigns at the same time are
1574: -- the following:
1575: --