APPS.IGI_ITR_APPROVAL_LINES_SS_PKG SQL Statements

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

Line: 24

        SELECT * FROM igi_itr_charge_lines
        WHERE rowid = X_Rowid
        FOR UPDATE OF It_Service_Line_Id NOWAIT;

Line: 35

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

Line: 74

  PROCEDURE Update_Row(X_Rowid                      VARCHAR2,
                       X_Status_Flag                VARCHAR2,
                       X_Rejection_Note             VARCHAR2,
                       X_Suggested_Amount           NUMBER,
                       X_Suggested_Recv_Ccid        NUMBER,
                       X_Last_Update_Login          NUMBER,
                       X_Last_Updated_By            NUMBER,
                       X_Last_Update_Date           DATE
                      ) IS
  BEGIN
     UPDATE igi_itr_charge_lines
     SET
        Status_Flag           =     X_Status_Flag,
        Rejection_Note        =     X_Rejection_Note,
        Suggested_Amount      =     X_Suggested_Amount,
        Suggested_Recv_Ccid   =     X_Suggested_Recv_Ccid,
        Last_Update_Login     =     X_Last_Update_Login,
        Last_Updated_By       =     X_Last_Updated_By,
        Last_Update_Date      =     X_Last_Update_Date
    WHERE rowid = X_Rowid;

Line: 97

  END Update_Row;