APPS.IGI_CIS_CERT_NI_NUMBERS_PKG SQL Statements

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

Line: 20

            SELECT *
            FROM   igi_cis_cert_ni_numbers_all
            WHERE  rowid = p_row_id
            FOR UPDATE OF tax_rate_id NOWAIT;

Line: 32

	    FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

Line: 54

    PROCEDURE Insert_Row(p_row_id            IN OUT NOCOPY VARCHAR2
                        ,p_org_id            NUMBER
                        ,p_tax_rate_id       NUMBER
                        ,p_ni_number         VARCHAR2
                        ,p_creation_date     DATE
                        ,p_created_by        NUMBER
                        ,p_last_update_date  DATE
                        ,p_last_updated_by   NUMBER
                        ,p_last_update_login NUMBER
                        ,p_calling_sequence  IN OUT NOCOPY VARCHAR2) IS

        l_debug_info VARCHAR2(100);

Line: 69

                           CURSOR c_insert IS SELECT rowid
                           FROM   igi_cis_cert_ni_numbers
                           WHERE  tax_rate_id = p_tax_rate_id;

Line: 75

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

Line: 78

        l_debug_info := 'Inserting into IGI_CIS_CERT_NI_NUMBERS_ALL';

Line: 80

        INSERT INTO igi_cis_cert_ni_numbers_all
           (tax_rate_id
           ,ni_number
           ,creation_date
           ,created_by
           ,last_update_date
           ,last_updated_by
           ,last_update_login
           ,org_id)
        VALUES
           (p_tax_rate_id
           ,p_ni_number
           ,p_creation_date
           ,p_created_by
           ,p_last_update_date
           ,p_last_updated_by
           ,p_last_update_login
           ,p_org_id);

Line: 99

        l_debug_info := 'Open cursor c_insert';

Line: 100

        OPEN c_insert;

Line: 101

        l_debug_info := 'Fetch cursor c_insert';

Line: 102

        FETCH c_insert INTO p_row_id;

Line: 103

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

Line: 105

            CLOSE c_insert;

Line: 108

        l_debug_info := 'Close cursor c_insert';

Line: 109

        CLOSE c_insert;

Line: 121

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

Line: 125

    END Insert_Row;

Line: 128

    PROCEDURE Update_Row(p_row_id            VARCHAR2
                        ,p_ni_number         VARCHAR2
                        ,p_last_update_date  DATE
                        ,p_last_updated_by   NUMBER
                        ,p_last_update_login NUMBER) IS
    BEGIN
        UPDATE igi_cis_cert_ni_numbers_all
        SET    ni_number         = p_ni_number
              ,last_update_date  = p_last_update_date
              ,last_updated_by   = p_last_updated_by
              ,last_update_login = p_last_update_login
        WHERE rowid = p_row_id;

Line: 144

    END Update_Row;