APPS.CE_STAT_LINES_DML_PKG SQL Statements

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

Line: 18

  PROCEDURE Insert_Row(
        X_Row_Id                IN OUT NOCOPY VARCHAR2,
        X_statement_line_id     IN OUT NOCOPY NUMBER,
		X_statement_header_id   IN OUT NOCOPY NUMBER,
        X_line_number           NUMBER,
        X_trx_date              DATE,
        X_trx_type              VARCHAR2,
        X_trx_status            VARCHAR2,
        X_trx_code              VARCHAR2,  --5131976
        X_effective_date        IN OUT NOCOPY DATE,
        X_bank_trx_number       VARCHAR2,
        X_trx_text              VARCHAR2,
        X_customer_text         VARCHAR2,
        X_invoice_text          VARCHAR2,
        X_bank_account_text     VARCHAR2,
        X_amount                NUMBER,
        X_charges_amount        NUMBER,
        X_status                VARCHAR2,
        X_created_by            NUMBER,
        X_creation_date         DATE,
        X_last_updated_by       NUMBER,
        X_last_update_date      DATE,
        X_currency_code         VARCHAR2,
        X_original_amount       NUMBER,
        X_exchange_rate         NUMBER,
        X_exchange_rate_type    VARCHAR2,
        X_exchange_rate_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,
    --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
        CURSOR C IS SELECT rowid FROM CE_STATEMENT_LINES
                 WHERE statement_line_id = X_Statement_line_Id;

Line: 86

    CURSOR C1 IS SELECT ce_statement_lines_s.nextval from sys.dual;

Line: 87

        CURSOR C2 IS SELECT NVL(MAX(line_number),0) + 10 FROM CE_STATEMENT_LINES
                     WHERE statement_header_id = X_statement_header_Id;

Line: 89

        CURSOR C3 IS SELECT ce_statement_headers_s.nextval FROM sys.dual;

Line: 175

    SELECT  X_trx_date + float_days
    INTO    X_effective_date
    FROM    ce_transaction_codes
    WHERE   transaction_code_id = X_trx_code_id;

Line: 187

    INSERT INTO CE_STATEMENT_LINES
         (statement_line_id,
         statement_header_id,
         line_number,
         trx_date,
         trx_type,
         trx_code,
         effective_date,
         bank_trx_number,
         trx_text,
         customer_text,
         invoice_text,
         bank_account_text,
         amount,
         charges_amount,
         status,
         created_by,
         creation_date,
         last_updated_by,
         last_update_date,
         currency_code,
         original_amount,
         exchange_rate,
         exchange_rate_type,
         exchange_rate_date,
         attribute_category,
         attribute1,
         attribute2,
         attribute3,
         attribute4,
         attribute5,
         attribute6,
         attribute7,
         attribute8,
         attribute9,
         attribute10,
         attribute11,
         attribute12,
         attribute13,
         attribute14,
         attribute15,
    -- 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_line_id,
         X_statement_header_id,
         sl_number,
         X_trx_date,
         line_type,
         X_trx_code,
         X_effective_date,
         X_bank_trx_number,
         X_trx_text,
         X_customer_text,
         X_invoice_text,
         X_bank_account_text,
         NVL(line_amount, X_amount),
         X_charges_amount,
         X_status,
         X_created_by,
         X_creation_date,
         X_last_updated_by,
         X_last_update_date,
         X_currency_code,
         abs(X_original_amount),
         X_exchange_rate,
         X_exchange_rate_type,
         X_exchange_rate_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_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: 319

  END insert_row;

Line: 321

  PROCEDURE Delete_Row( X_Row_Id VARCHAR2 ) IS
  BEGIN
    DELETE FROM CE_STATEMENT_LINES
    WHERE rowid = X_Row_Id;

Line: 329

  END Delete_Row;

Line: 331

  PROCEDURE Update_Row (
        X_Row_Id                VARCHAR2,
        X_statement_line_id     NUMBER,
        X_statement_header_id   NUMBER,
        X_line_number           NUMBER,
        X_trx_date              DATE,
        X_trx_type              VARCHAR2,
        X_trx_code              VARCHAR2, --5131976
        X_effective_date        DATE,
        X_bank_trx_number       VARCHAR2,
        X_trx_text              VARCHAR2,
        X_customer_text         VARCHAR2,
        X_invoice_text          VARCHAR2,
        X_bank_account_text     VARCHAR2,
        X_amount                NUMBER,
        X_charges_amount        NUMBER,
        X_status                VARCHAR2,
        X_last_updated_by       NUMBER,
        X_last_update_date      DATE,
        X_attribute_category    VARCHAR2,
        X_original_amount       NUMBER,
        X_currency_code         VARCHAR2,
        X_exchange_rate         NUMBER,
        X_exchange_rate_type    VARCHAR2,
        X_exchange_rate_date    DATE,
        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,
    --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
  BEGIN
    UPDATE CE_STATEMENT_LINES
    SET
       statement_line_id = X_statement_line_id,
       statement_header_id = X_statement_header_id,
       line_number = X_line_number,
       trx_date = X_trx_date,
       trx_type = X_trx_type,
       trx_code = X_trx_code,
       effective_date = X_effective_date,
       bank_trx_number = X_bank_trx_number,
       trx_text = X_trx_text,
       customer_text = X_customer_text,
       invoice_text = X_invoice_text,
       bank_account_text = X_bank_account_text,
       amount = X_amount,
       charges_amount= X_charges_amount,
       status = X_status,
       last_updated_by = X_last_updated_by,
       last_update_date = X_last_update_date,
       attribute_category = X_attribute_category,
       original_amount = X_original_amount,
       currency_code = X_currency_code,
       exchange_rate = X_exchange_rate,
       exchange_rate_type = X_exchange_rate_type,
       exchange_rate_date = X_exchange_rate_date,
       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,
    --Bug 6899211
       global_attribute_category = X_global_att_category,
    --5916290: GDF Changes
       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: 462

  END Update_Row;

Line: 526

    SELECT *
    FROM CE_STATEMENT_LINES
    WHERE rowid = X_Row_Id
    FOR UPDATE OF statement_line_id NOWAIT;

Line: 536

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