APPS.IGI_MPP_AP_INVOICE_DISTS_PKG SQL Statements

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

Line: 24

          SELECT *
         FROM   igi_mpp_ap_invoice_dists
         WHERE  rowid = X_Rowid
         FOR UPDATE of Invoice_id, Distribution_Line_Number NOWAIT;

Line: 35

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

Line: 38

          FND_LOG.MESSAGE (l_error_level , 'igi.pls.igipmudb.IGI_MPP_AP_INVOICE_DISTS_PKG.Lock_Row.FORM_RECORD_DELETED',FALSE);

Line: 72

    PROCEDURE Update_Row(X_Rowid               VARCHAR2,
         X_Distribution_Line_Number            NUMBER,
         X_Invoice_Id                          NUMBER,
         X_Ignore_Mpp_Flag                     VARCHAR2,
         X_Accounting_Rule_Id                 VARCHAR2,
         X_Start_Date                          DATE,
         X_Duration                            NUMBER,
         X_Last_Updated_By                     NUMBER,
         X_Last_Update_Date                    DATE,
         X_Last_Update_Login                   NUMBER

     ) IS
     BEGIN
       UPDATE igi_mpp_ap_invoice_dists
       SET
         ignore_mpp_flag                    =  nvl(X_Ignore_Mpp_Flag,'N'),
         accounting_rule_id                 =  X_Accounting_Rule_Id,
         start_date                         =  X_Start_Date,
         duration                           =  X_Duration,
         last_updated_by                    =  X_Last_Updated_By,
         last_update_date                   =  X_Last_Update_Date,
         last_update_login                  =  X_Last_Update_Login
       WHERE rowid = X_Rowid;

Line: 99

              FND_LOG.MESSAGE (l_error_level , 'igi.pls.igipmudb.IGI_MPP_AP_INVOICE_DISTS_PKG.Update_Row.NO_DATA_FOUND',FALSE);

Line: 104

     END Update_Row;