APPS.IGI_SLS_SECURE_TABLES_AU_PKG SQL Statements

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

Line: 13

    PROCEDURE Insert_Row(p_owner                   IN igi_sls_secure_tables.owner%TYPE
                        ,p_table_name              IN igi_sls_secure_tables.table_name%TYPE
                        ,p_description             IN igi_sls_secure_tables.description%TYPE
                        ,p_sls_table_name          IN igi_sls_secure_tables.sls_table_name%TYPE
                        ,p_update_allowed          IN igi_sls_secure_tables.update_allowed%TYPE
                        ,p_date_enabled            IN igi_sls_secure_tables.date_enabled%TYPE
                        ,p_date_disabled           IN igi_sls_secure_tables.date_disabled%TYPE
                        ,p_date_removed            IN igi_sls_secure_tables.date_removed%TYPE
                        ,p_date_object_created   IN igi_sls_secure_tables.date_object_created%TYPE
                        ,p_date_security_applied   IN igi_sls_secure_tables.date_security_applied%TYPE
                        ,p_creation_date           IN igi_sls_secure_tables.creation_date%TYPE
                        ,p_created_by              IN igi_sls_secure_tables.created_by%TYPE
                        ,p_last_update_date        IN igi_sls_secure_tables.last_update_date%TYPE
                        ,p_last_updated_by         IN igi_sls_secure_tables.last_updated_by%TYPE
                        ,p_last_update_login       IN igi_sls_secure_tables.last_update_login%TYPE
                        ,p_rowid                   IN OUT NOCOPY VARCHAR2
                        ,p_calling_sequence        IN OUT NOCOPY VARCHAR2)
    IS

        l_debug_info VARCHAR2(100);

Line: 34

        CURSOR c_insert IS
               SELECT rowid
               FROM   igi_sls_secure_tables_audit
               WHERE  owner      = p_owner
               AND    table_name = p_table_name;

Line: 42

        p_calling_sequence := 'IGI_SLS_SECURE_TABLES_AU_PKG.Insert_Row<-' ||
                              p_calling_sequence;

Line: 45

        l_debug_info := 'Inserting into IGI_SLS_SECURE_TABLES_AUDIT';

Line: 47

        INSERT INTO igi_sls_secure_tables_audit
               (owner
               ,table_name
               ,description
               ,sls_table_name
               ,update_allowed
               ,date_enabled
               ,date_disabled
               ,date_removed
               ,date_object_created
               ,date_security_applied
               ,creation_date
               ,created_by
               ,last_update_date
               ,last_updated_by
               ,last_update_login)
        VALUES
               (p_owner
               ,p_table_name
               ,p_description
               ,p_sls_table_name
               ,p_update_allowed
               ,p_date_enabled
               ,p_date_disabled
               ,p_date_removed
               ,p_date_object_created
               ,p_date_security_applied
               ,p_creation_date
               ,p_created_by
               ,p_last_update_date
               ,p_last_updated_by
               ,p_last_update_login);

Line: 80

        l_debug_info := 'Open cursor c_insert';

Line: 81

        OPEN c_insert;

Line: 83

        l_debug_info := 'Fetch cursor c_insert';

Line: 84

        FETCH c_insert INTO p_rowid;

Line: 86

        IF c_insert%NOTFOUND THEN
            l_debug_info := 'Close cursor c_insert NOTFOUND';

Line: 88

            CLOSE c_insert;

Line: 92

        l_debug_info := 'Close cursor c_insert';

Line: 93

        CLOSE c_insert;

Line: 102

                FND_LOG.MESSAGE ( l_unexp_level,l_path || 'Insert_Row', FALSE);

Line: 106

    END Insert_Row;