APPS.IGI_CIS_PAYMENT_VOUCHERS_PKG SQL Statements

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

Line: 24

            SELECT *
            FROM   igi_cis_payment_vouchers_all
            WHERE  rowid = p_row_id
            FOR UPDATE OF invoice_payment_id NOWAIT;

Line: 35

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

Line: 62

    PROCEDURE Insert_Row(p_org_id                NUMBER
                        ,p_row_id                IN OUT NOCOPY VARCHAR2
                        ,p_invoice_payment_id    NUMBER
                        ,p_vendor_id             NUMBER
                        ,p_vendor_site_id        NUMBER
                        ,p_pmt_vch_number        VARCHAR2
                        ,p_pmt_vch_amount        NUMBER
                        ,p_pmt_vch_received_date DATE
                        ,p_pmt_vch_description   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: 80

        CURSOR c_ins IS SELECT rowid
                        FROM   igi_cis_payment_vouchers
                        WHERE  invoice_payment_id = p_invoice_payment_id
                        AND    vendor_id = p_vendor_id
                        AND    vendor_site_id = p_vendor_site_id;

Line: 86

        p_calling_sequence := 'IGI_CIS_PAYMENT_VOUCHERS_PKG.Insert_Row<=' ||
                              p_calling_sequence;

Line: 89

        l_debug_info := 'Insert Into igi_cis_payment_vouchers_all';

Line: 91

        INSERT INTO igi_cis_payment_vouchers_all
           (org_id
           ,invoice_payment_id
           ,vendor_id
           ,vendor_site_id
           ,pmt_vch_number
           ,pmt_vch_amount
           ,pmt_vch_received_date
           ,pmt_vch_description
           ,creation_date
           ,created_by
           ,last_update_date
           ,last_updated_by
           ,last_update_login)
        VALUES
           (p_org_id
           ,p_invoice_payment_id
           ,p_vendor_id
           ,p_vendor_site_id
           ,p_pmt_vch_number
           ,p_pmt_vch_amount
           ,p_pmt_vch_received_date
           ,p_pmt_vch_description
           ,p_creation_date
           ,p_created_by
           ,p_last_update_date
           ,p_last_updated_by
           ,p_last_update_login);

Line: 143

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

Line: 147

    END Insert_Row;

Line: 150

    PROCEDURE Update_Row(p_row_id                VARCHAR2
                        ,p_vendor_id             NUMBER
                        ,p_vendor_site_id        NUMBER
                        ,p_pmt_vch_number        VARCHAR2
                        ,p_pmt_vch_amount        NUMBER
                        ,p_pmt_vch_received_date DATE
                        ,p_pmt_vch_description   VARCHAR2
                        ,p_last_update_date      DATE
                        ,p_last_updated_by       NUMBER
                        ,p_last_update_login     NUMBER) IS
    BEGIN
        UPDATE igi_cis_payment_vouchers_all
        SET    vendor_id             = p_vendor_id
              ,vendor_site_id        = p_vendor_site_id
              ,pmt_vch_number        = p_pmt_vch_number
              ,pmt_vch_amount        = p_pmt_vch_amount
              ,pmt_vch_received_date = p_pmt_vch_received_date
              ,pmt_vch_description   = p_pmt_vch_description
              ,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: 176

    END Update_Row;