APPS.BSC_UPDATE_LOG SQL Statements

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

Line: 34

    c_utl_file_dir_sql VARCHAR2(2000) := 'SELECT VP.value'||
                                         ' FROM v$parameter VP'||
                                         ' WHERE UPPER(VP.name) = :1';

Line: 81

        BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_CREATION_FAILED'),
                        x_source => 'BSC_UPDATE_LOG.Init_Log_File');

Line: 86

        BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_DIR_NOT_SPECIFIED'),
                        x_source => 'BSC_UPDATE_LOG.Init_Log_File');

Line: 91

        BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_PATH_FAILED'),
                        x_source => 'BSC_UPDATE_LOG.Init_Log_File');

Line: 96

        BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_MODE_FAILED'),
                        x_source => 'BSC_UPDATE_LOG.Init_Log_File');

Line: 101

        BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_OPERATION_FAILED'),
                        x_source => 'BSC_UPDATE_LOG.Init_Log_File');

Line: 106

        BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_HANDLE_FAILED'),
                        x_source => 'BSC_UPDATE_LOG.Init_Log_File');

Line: 111

        BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_WRITE_LOGFILE_FAILED'),
                        x_source => 'BSC_UPDATE_LOG.Init_Log_File');

Line: 117

                        x_source => 'BSC_UPDATE_LOG.Init_Log_File');

Line: 194

    c_messages_sql VARCHAR2(2000) := 'SELECT message'||
                                     ' FROM bsc_message_logs'||
                                     ' WHERE last_update_login = :1'||
                                     ' ORDER BY last_update_date';

Line: 209

        Write_Line_Log(h_message, BSC_UPDATE_LOG.LOG);