APPS.FND_OAM_COLLECTION dependencies on FND_LOG_EXCEPTIONS

Line 1718: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue

1714:
1715: if (is_collection_enabled('USER_ALERT_NEW_OCC')) then
1716: -- get the number of new occurrences
1717: select count(*) into ct_new_occ
1718: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue
1719: where fle.unique_exception_id = flue.unique_exception_id
1720: and flue.status='N'
1721: and flue.category='USER';
1722:

Line 1740: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue

1736:
1737: if (is_collection_enabled('USER_ALERT_OPEN_OCC')) then
1738: -- get the number of open occurrences
1739: select count(*) into ct_open_occ
1740: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue
1741: where fle.unique_exception_id = flue.unique_exception_id
1742: and flue.status='O'
1743: and flue.category='USER';
1744:

Line 1802: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue

1798:
1799: if (is_collection_enabled('CRIT_PR_EXCEP')) then
1800: -- get the number of new occurrences
1801: select count(*) into ct_new_occ
1802: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue
1803: where fle.unique_exception_id = flue.unique_exception_id
1804: and flue.status='N';
1805:
1806: -- update new occurrances

Line 1823: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue

1819:
1820: if (is_collection_enabled('OPEN_OCC')) then
1821: -- get the number of open occurrences
1822: select count(*) into ct_open_occ
1823: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue
1824: where fle.unique_exception_id = flue.unique_exception_id
1825: and flue.status='O';
1826:
1827: -- update open occurrances