eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_STAT_HDRS_DML_PKG SQL Statements

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

Line: 23


  PROCEDURE Insert_Row(
            X_rowid                 IN OUT NOCOPY  VARCHAR2,
            X_statement_header_id   IN OUT NOCOPY NUMBER,
            X_bank_account_id       NUMBER,
            X_statement_number      VARCHAR2,
            X_statement_date        DATE,
            X_check_digits          VARCHAR2,
            X_control_begin_balance NUMBER,
            X_control_end_balance   NUMBER,
            X_cashflow_balance      NUMBER,
            X_int_calc_balance      NUMBER,
            X_one_day_float         NUMBER,
            X_two_day_float         NUMBER,
            X_control_total_dr      NUMBER,
            X_control_total_cr      NUMBER,
            X_control_dr_line_count NUMBER,
            X_control_cr_line_count NUMBER,
            X_doc_sequence_id       NUMBER,
            X_doc_sequence_value    NUMBER,
            X_created_by            NUMBER,
            X_creation_date         DATE,
            X_last_updated_by       NUMBER,
            X_last_update_date      DATE,
            X_attribute_category    VARCHAR2,
            X_attribute1            VARCHAR2,
            X_attribute2            VARCHAR2,
            X_attribute3            VARCHAR2,
            X_attribute4            VARCHAR2,
            X_attribute5            VARCHAR2,
            X_attribute6            VARCHAR2,
            X_attribute7            VARCHAR2,
            X_attribute8            VARCHAR2,
            X_attribute9            VARCHAR2,
            X_attribute10           VARCHAR2,
            X_attribute11           VARCHAR2,
            X_attribute12           VARCHAR2,
            X_attribute13           VARCHAR2,
            X_attribute14           VARCHAR2,
            X_attribute15           VARCHAR2,
            X_auto_loaded_flag      VARCHAR2,
            X_statement_complete_flag   VARCHAR2,
            X_gl_date               DATE,
            X_balance_flag          VARCHAR2 DEFAULT 'N',
            X_average_close_ledger_mtd      NUMBER DEFAULT NULL,
            X_average_close_ledger_ytd      NUMBER DEFAULT NULL,
            X_average_close_available_mtd   NUMBER DEFAULT NULL,
            X_average_close_available_ytd   NUMBER DEFAULT NULL,
            X_bank_acct_balance_id          NUMBER DEFAULT NULL,
        -- 5916290: GDF Changes
            X_global_att_category   VARCHAR2,
            X_global_attribute1     VARCHAR2,
            X_global_attribute2     VARCHAR2,
            X_global_attribute3     VARCHAR2,
            X_global_attribute4     VARCHAR2,
            X_global_attribute5     VARCHAR2,
            X_global_attribute6     VARCHAR2,
            X_global_attribute7     VARCHAR2,
            X_global_attribute8     VARCHAR2,
            X_global_attribute9     VARCHAR2,
            X_global_attribute10    VARCHAR2,
            X_global_attribute11    VARCHAR2,
            X_global_attribute12    VARCHAR2,
            X_global_attribute13    VARCHAR2,
            X_global_attribute14    VARCHAR2,
            X_global_attribute15    VARCHAR2,
            X_global_attribute16    VARCHAR2,
            X_global_attribute17    VARCHAR2,
            X_global_attribute18    VARCHAR2,
            X_global_attribute19    VARCHAR2,
            X_global_attribute20    VARCHAR2
            ) IS
    p_bank_acct_balance_id  number;

Line: 96


    CURSOR C IS SELECT rowid
        FROM CE_STATEMENT_HEADERS
            WHERE statement_header_id = X_Statement_Header_Id;

Line: 99


    CURSOR C2 IS SELECT CE_STATEMENT_HEADERS_S.nextval FROM SYS.dual;

Line: 100


    CURSOR C3 IS SELECT CE_BANK_ACCT_BALANCES_S.nextval FROM SYS.dual;

Line: 107


      INSERT INTO CE_STATEMENT_HEADERS (
                statement_header_id,
                bank_account_id,
                statement_number,
                statement_date,
                check_digits,
                control_begin_balance,
                control_end_balance,
                cashflow_balance,
                int_calc_balance,
                one_day_float,
                two_day_float,
                control_total_dr,
                control_total_cr,
                control_dr_line_count,
                control_cr_line_count,
                doc_sequence_id,
                doc_sequence_value,
                created_by,
                creation_date,
                last_updated_by,
                last_update_date,
                attribute_category,
                attribute1,
                attribute2,
                attribute3,
                attribute4,
                attribute5,
                attribute6,
                attribute7,
                attribute8,
                attribute9,
                attribute10,
                attribute11,
                attribute12,
                attribute13,
                attribute14,
                attribute15,
                auto_loaded_flag,
                statement_complete_flag,
                gl_date,
        -- 5916290: GDF Changes
                global_attribute_category,
                global_attribute1,
                global_attribute2,
                global_attribute3,
                global_attribute4,
                global_attribute5,
                global_attribute6,
                global_attribute7,
                global_attribute8,
                global_attribute9,
                global_attribute10,
                global_attribute11,
                global_attribute12,
                global_attribute13,
                global_attribute14,
                global_attribute15,
                global_attribute16,
                global_attribute17,
                global_attribute18,
                global_attribute19,
                global_attribute20) VALUES
                (X_statement_header_id,
                X_bank_account_id,
                X_statement_number,
                X_statement_date,
                X_check_digits,
                X_control_begin_balance,
                X_control_end_balance,
                X_cashflow_balance,
                X_int_calc_balance,
                X_one_day_float,
                X_two_day_float,
                X_control_total_dr,
                X_control_total_cr,
                X_control_dr_line_count,
                X_control_cr_line_count,
                X_doc_sequence_id,
                X_doc_sequence_value,
                X_created_by,
                X_creation_date,
                X_last_updated_by,
                X_last_update_date,
                X_attribute_category,
                X_attribute1,
                X_attribute2,
                X_attribute3,
                X_attribute4,
                X_attribute5,
                X_attribute6,
                X_attribute7,
                X_attribute8,
                X_attribute9,
                X_attribute10,
                X_attribute11,
                X_attribute12,
                X_attribute13,
                X_attribute14,
                X_attribute15,
                X_auto_loaded_flag,
                X_statement_complete_flag,
                X_gl_date,
        -- 5916290: GDF Changes
                X_global_att_category,
                X_global_attribute1,
                X_global_attribute2,
                X_global_attribute3,
                X_global_attribute4,
                X_global_attribute5,
                X_global_attribute6,
                X_global_attribute7,
                X_global_attribute8,
                X_global_attribute9,
                X_global_attribute10,
                X_global_attribute11,
                X_global_attribute12,
                X_global_attribute13,
                X_global_attribute14,
                X_global_attribute15,
                X_global_attribute16,
                X_global_attribute17,
                X_global_attribute18,
                X_global_attribute19,
                X_global_attribute20);

Line: 242


        INSERT INTO CE_BANK_ACCT_BALANCES
            (bank_acct_balance_id,
             bank_account_id,
             balance_date,
             ledger_balance,
             available_balance,
             value_dated_balance,
             one_day_float,
             two_day_float,
             average_close_ledger_mtd,
             average_close_ledger_ytd,
             average_close_available_mtd,
             average_close_available_ytd,
             last_update_date,
             last_updated_by,
             creation_date,
             created_by,
             last_update_login,
             object_version_number)
            values
            (p_bank_acct_balance_id,
             X_bank_account_id,
             X_statement_date,
             X_control_end_balance,
             X_cashflow_balance,
             X_int_calc_balance,
             X_one_day_float,
             X_two_day_float,
             X_average_close_ledger_mtd,
             X_average_close_ledger_ytd,
             X_average_close_available_mtd,
             X_average_close_available_ytd,
             X_last_update_date,
             X_last_updated_by,
             X_creation_date,
             X_created_by,
             X_last_updated_by,
             '1');

Line: 282


        UPDATE CE_BANK_ACCT_BALANCES
            SET
            BALANCE_DATE = X_statement_date,
            LEDGER_BALANCE = X_control_end_balance,
            AVAILABLE_BALANCE = X_cashflow_balance,
            VALUE_DATED_BALANCE = X_int_calc_balance,
            ONE_DAY_FLOAT = X_one_day_float,
            TWO_DAY_FLOAT = X_two_day_float,
            LAST_UPDATE_DATE = X_last_update_date,
            LAST_UPDATED_BY = X_last_updated_by,
            LAST_UPDATE_LOGIN = X_last_updated_by
            WHERE
            BANK_ACCOUNT_ID = X_bank_account_id and
            BALANCE_DATE = X_statement_date;

Line: 306


  END insert_row;

Line: 308


  PROCEDURE Update_Row( X_Row_id        VARCHAR2,
                X_statement_header_id   NUMBER,
                X_statement_number  VARCHAR2,
                X_statement_date    DATE,
                X_check_digits      VARCHAR2,
                X_control_begin_balance NUMBER,
                X_control_end_balance   NUMBER,
                X_cashflow_balance  NUMBER,
                X_int_calc_balance  NUMBER,
                X_one_day_float     NUMBER,
                X_two_day_float     NUMBER,
                X_control_total_dr  NUMBER,
                X_control_total_cr  NUMBER,
                X_control_dr_line_count NUMBER,
                X_control_cr_line_count NUMBER,
                X_doc_sequence_value    NUMBER,
                X_doc_sequence_id   NUMBER,
                X_last_updated_by   NUMBER,
                X_last_update_date  DATE,
                X_attribute_category    VARCHAR2,
                X_attribute1        VARCHAR2,
                X_attribute2        VARCHAR2,
                X_attribute3        VARCHAR2,
                X_attribute4        VARCHAR2,
                X_attribute5        VARCHAR2,
                X_attribute6        VARCHAR2,
                X_attribute7        VARCHAR2,
                X_attribute8        VARCHAR2,
                X_attribute9        VARCHAR2,
                X_attribute10       VARCHAR2,
                X_attribute11       VARCHAR2,
                X_attribute12       VARCHAR2,
                X_attribute13       VARCHAR2,
                X_attribute14       VARCHAR2,
                X_attribute15       VARCHAR2,
                X_statement_complete_flag VARCHAR2,
                X_gl_date       DATE,
                X_flag          VARCHAR2,
            -- 5916290: GDF Changes
                X_global_att_category   VARCHAR2,
                X_global_attribute1     VARCHAR2,
                X_global_attribute2     VARCHAR2,
                X_global_attribute3     VARCHAR2,
                X_global_attribute4     VARCHAR2,
                X_global_attribute5     VARCHAR2,
                X_global_attribute6     VARCHAR2,
                X_global_attribute7     VARCHAR2,
                X_global_attribute8     VARCHAR2,
                X_global_attribute9     VARCHAR2,
                X_global_attribute10    VARCHAR2,
                X_global_attribute11    VARCHAR2,
                X_global_attribute12    VARCHAR2,
                X_global_attribute13    VARCHAR2,
                X_global_attribute14    VARCHAR2,
                X_global_attribute15    VARCHAR2,
                X_global_attribute16    VARCHAR2,
                X_global_attribute17    VARCHAR2,
                X_global_attribute18    VARCHAR2,
                X_global_attribute19    VARCHAR2,
                X_global_attribute20    VARCHAR2
                ) IS

  X_bank_account_id NUMBER;

Line: 377


        SELECT BANK_ACCOUNT_ID,STATEMENT_DATE
        INTO X_bank_account_id,X_Balance_Date
        FROM CE_STATEMENT_HEADERS
        WHERE STATEMENT_HEADER_ID = X_Statement_Header_Id;

Line: 382


            UPDATE CE_BANK_ACCT_BALANCES
        SET
            BALANCE_DATE = X_statement_date,
            LEDGER_BALANCE = X_control_end_balance,
            AVAILABLE_BALANCE = X_cashflow_balance,
            VALUE_DATED_BALANCE = X_int_calc_balance,
            ONE_DAY_FLOAT = X_one_day_float,
            TWO_DAY_FLOAT = X_two_day_float,
            LAST_UPDATE_DATE = X_last_update_date,
            LAST_UPDATED_BY = X_last_updated_by,
            LAST_UPDATE_LOGIN = X_last_updated_by
            WHERE
            BANK_ACCOUNT_ID = X_Bank_Account_ID and
            BALANCE_DATE = X_Balance_Date;

Line: 405


    UPDATE CE_STATEMENT_HEADERS
    SET
       statement_header_id = X_statement_header_id,
       statement_number = X_statement_number,
       statement_date = X_statement_date,
       check_digits = X_check_digits,
       control_begin_balance = X_control_begin_balance,
       control_end_balance = X_control_end_balance,
       cashflow_balance = X_cashflow_balance,
       int_calc_balance = X_int_calc_balance,
       one_day_float = X_one_day_float,
       two_day_float = X_two_day_float,
       control_total_dr = X_control_total_dr,
       control_total_cr = X_control_total_cr,
       control_dr_line_count = X_control_dr_line_count,
       control_cr_line_count = X_control_cr_line_count,
       doc_sequence_value = X_doc_sequence_value,
       doc_sequence_id = X_doc_sequence_id,
       last_updated_by = X_last_updated_by,
       last_update_date = X_last_update_date,
       attribute_category = X_attribute_category,
       attribute1 = X_attribute1,
       attribute2 = X_attribute2,
       attribute3 = X_attribute3,
       attribute4 = X_attribute4,
       attribute5 = X_attribute5,
       attribute6 = X_attribute6,
       attribute7 = X_attribute7,
       attribute8 = X_attribute8,
       attribute9 = X_attribute9,
       attribute10 = X_attribute10,
       attribute11 = X_attribute11,
       attribute12 = X_attribute12,
       attribute13 = X_attribute13,
       attribute14 = X_attribute14,
       attribute15 = X_attribute15,
       statement_complete_flag = X_statement_complete_flag,
       gl_date = X_gl_date,
    -- 5916290: GDF Changes
       global_attribute_category = X_global_att_category,
       global_attribute1 = X_global_attribute1,
       global_attribute2 = X_global_attribute2,
       global_attribute3 = X_global_attribute3,
       global_attribute4 = X_global_attribute4,
       global_attribute5 = X_global_attribute5,
       global_attribute6 = X_global_attribute6,
       global_attribute7 = X_global_attribute7,
       global_attribute8 = X_global_attribute8,
       global_attribute9 = X_global_attribute9,
       global_attribute10 = X_global_attribute10,
       global_attribute11 = X_global_attribute11,
       global_attribute12 = X_global_attribute12,
       global_attribute13 = X_global_attribute13,
       global_attribute14 = X_global_attribute14,
       global_attribute15 = X_global_attribute15,
       global_attribute16 = X_global_attribute16,
       global_attribute17 = X_global_attribute17,
       global_attribute18 = X_global_attribute18,
       global_attribute19 = X_global_attribute19,
       global_attribute20 = X_global_attribute20
    WHERE rowid = X_Row_Id;

Line: 470


  END update_row;

Line: 472


  PROCEDURE Delete_Row( X_Row_id VARCHAR2 ) IS
   X_bank_account_id    NUMBER;

Line: 479


        SELECT BANK_ACCOUNT_ID,STATEMENT_DATE
        INTO X_bank_account_id,X_balance_date
        FROM CE_STATEMENT_HEADERS
        WHERE rowid = X_Row_Id;

Line: 484


        DELETE FROM CE_BANK_ACCT_BALANCES
            WHERE bank_account_id = X_bank_account_id
            AND   balance_date = X_balance_date;

Line: 492


    DELETE FROM CE_STATEMENT_HEADERS
    WHERE rowid = X_Row_Id;

Line: 498


  END Delete_Row;

Line: 561


        SELECT *
        FROM   CE_STATEMENT_HEADERS
        WHERE  rowid = X_Row_Id
        FOR UPDATE of Statement_Header_Id NOWAIT;

Line: 568


    SELECT *
    FROM CE_BANK_ACCT_BALANCES
    WHERE BANK_ACCOUNT_ID = X_bank_account_id
    AND   BALANCE_DATE = X_statement_date
    FOR UPDATE of BANK_ACCT_BALANCE_ID NOWAIT;

Line: 580


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