APPS.FND_OAM_KBF SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 44

        select count(*) into critical_n from fnd_log_unique_exceptions where
                severity='CRITICAL' and status='N';

Line: 46

        select count(*) into error_n from fnd_log_unique_exceptions where
                severity='ERROR' and status='N';

Line: 48

        select count(*) into warning_n from fnd_log_unique_exceptions where
                severity='WARNING' and status='N';

Line: 50

        select count(*) into critical_o from fnd_log_unique_exceptions where
                severity='CRITICAL' and status='O';

Line: 52

        select count(*) into error_o from fnd_log_unique_exceptions where
                severity='ERROR' and status='O';

Line: 54

        select count(*) into warning_o from fnd_log_unique_exceptions where
                severity='WARNING' and status='O';

Line: 57

        select count(*) into critical_c from fnd_log_unique_exceptions where
                severity='CRITICAL' and status='C';

Line: 59

        select count(*) into error_c from fnd_log_unique_exceptions where
                severity='ERROR' and status='C';

Line: 61

        select count(*) into warning_c from fnd_log_unique_exceptions where
                severity='WARNING' and status='C';

Line: 65

        select count(*) into critical_n from fnd_log_unique_exceptions where
                severity='CRITICAL' and status='N' and category=p_category;

Line: 67

        select count(*) into error_n from fnd_log_unique_exceptions where
                severity='ERROR' and status='N' and category=p_category;

Line: 69

        select count(*) into warning_n from fnd_log_unique_exceptions where
                severity='WARNING' and status='N' and category=p_category;

Line: 71

        select count(*) into critical_o from fnd_log_unique_exceptions where
                severity='CRITICAL' and status='O' and category=p_category;

Line: 73

        select count(*) into error_o from fnd_log_unique_exceptions where
                severity='ERROR' and status='O' and category=p_category;

Line: 75

        select count(*) into warning_o from fnd_log_unique_exceptions where
                severity='WARNING' and status='O' and category=p_category;

Line: 78

        select count(*) into critical_c from fnd_log_unique_exceptions where
                severity='CRITICAL' and status='C' and category=p_category;

Line: 80

        select count(*) into error_c from fnd_log_unique_exceptions where
                severity='ERROR' and status='C' and category=p_category;

Line: 82

        select count(*) into warning_c from fnd_log_unique_exceptions where
                severity='WARNING' and status='C' and category=p_category;

Line: 130

        select sum(count) into critical_n
                from fnd_log_unique_exceptions flue
                where flue.severity = 'CRITICAL' and flue.status='N';

Line: 133

        select sum(count) into error_n
                from fnd_log_unique_exceptions flue
                where flue.severity = 'ERROR' and flue.status='N';

Line: 136

        select sum(count) into warning_n
                from fnd_log_unique_exceptions flue
                where flue.severity = 'WARNING' and flue.status='N';

Line: 139

        select sum(count) into critical_o
                from fnd_log_unique_exceptions flue
                where flue.severity = 'CRITICAL' and flue.status='O';

Line: 142

        select sum(count) into error_o
                from fnd_log_unique_exceptions flue
                where flue.severity = 'ERROR' and flue.status='O';

Line: 145

        select sum(count) into warning_o
                from fnd_log_unique_exceptions flue
                where flue.severity = 'WARNING' and flue.status='O';

Line: 149

        select sum(count) into critical_c
                from fnd_log_unique_exceptions flue
                where flue.severity = 'CRITICAL' and flue.status='C';

Line: 152

        select sum(count) into error_c
                from fnd_log_unique_exceptions flue
                where flue.severity = 'ERROR' and flue.status='C';

Line: 155

        select sum(count) into warning_c
                from fnd_log_unique_exceptions flue
                where flue.severity = 'WARNING' and flue.status='C';

Line: 160

        select sum(count) into critical_n
                from fnd_log_unique_exceptions flue
                where flue.severity = 'CRITICAL' and flue.status='N'
                and flue.category = p_category;

Line: 164

        select sum(count) into error_n
                from fnd_log_unique_exceptions flue
                where flue.severity = 'ERROR' and flue.status='N'
                and flue.category = p_category;

Line: 168

        select sum(count) into warning_n
                from fnd_log_unique_exceptions flue
                where flue.severity = 'WARNING' and flue.status='N'
                and flue.category = p_category;

Line: 172

        select sum(count) into critical_o
                from fnd_log_unique_exceptions flue
                where flue.severity = 'CRITICAL' and flue.status='O'
                and flue.category = p_category;

Line: 176

        select sum(count) into error_o
                from fnd_log_unique_exceptions flue
                where flue.severity = 'ERROR' and flue.status='O'
                and flue.category = p_category;

Line: 180

        select sum(count) into warning_o
                from fnd_log_unique_exceptions flue
                where flue.severity = 'WARNING' and flue.status='O'
                and flue.category = p_category;

Line: 185

        select sum(count) into critical_c
                from fnd_log_unique_exceptions flue
                where flue.severity = 'CRITICAL' and flue.status='C'
                and flue.category = p_category;

Line: 189

        select sum(count) into error_c
                from fnd_log_unique_exceptions flue
                where flue.severity = 'ERROR' and flue.status='C'
                and flue.category = p_category;

Line: 193

        select sum(count) into warning_c
                from fnd_log_unique_exceptions flue
                where flue.severity = 'WARNING' and flue.status='C'
                and flue.category = p_category;

Line: 251

        select user_id into v_userid
                from fnd_user where upper(user_name) = upper(p_username);

Line: 279

        update fnd_log_unique_exceptions
                set status = p_newstate,
                last_updated_by = v_userid,
                last_update_date = sysdate
                where unique_exception_id = to_number(v_curr_id);

Line: 289

                select notes into v_notes
                        from fnd_exception_notes
                        where unique_exception_id = to_number(v_curr_id)
                        for update;

Line: 298

                        insert into fnd_exception_notes (
                                notes, creation_date, created_by,
                                last_update_date, last_updated_by,
                                last_update_login,
                                log_sequence,
                                unique_exception_id) values
                        (v_ack_phrase, sysdate, v_userid, sysdate,
                         v_userid, 0, -1,
                         to_number(v_curr_id));