APPS.AP_FIX_ACCTG_PKG SQL Statements

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

Line: 4

  PROCEDURE Update_Row(
                   X_Rowid                 IN VARCHAR2,
                   X_Code_Combination_Id   IN NUMBER,
                   X_Description           IN VARCHAR2,
                   X_Last_Update_Date      IN DATE,
                   X_Last_Updated_By       IN NUMBER,
                   X_Last_Update_Login     IN NUMBER ,
                   X_Calling_Sequence      IN VARCHAR2,
                   X_Accounting_Error_Code IN VARCHAR2 -- Bug 1369125
                      ) IS
    Current_Calling_Sequence    VARCHAR2(2000);

Line: 19

    Current_Calling_Sequence := 'AP_FIX_ACCTG_PKG.UPDATE_ROW<-' ||
                                 X_Calling_Sequence;

Line: 22

    debug_info := 'Update ap_ae_lines';

Line: 24

    UPDATE ap_ae_lines
    SET    code_combination_id   = X_Code_Combination_Id,
           description           = X_Description,
           last_update_date      = X_Last_Update_Date,
           last_updated_by       = X_Last_Updated_By,
           last_update_login     = X_Last_Update_Login,
           Accounting_Error_Code = X_Accounting_Error_Code -- Bug 1369125
    WHERE  Rowid = X_Rowid;

Line: 48

  END Update_Row;

Line: 58

        SELECT   *
        FROM     ap_ae_lines
        WHERE    rowid = X_Rowid
        FOR UPDATE of code_combination_id, description NOWAIT;

Line: 78

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