APPS.QA_PC_CRITERIA_PKG SQL Statements

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

Line: 3

  PROCEDURE Insert_Row( X_Rowid                 IN OUT  NOCOPY VARCHAR2,
                       X_Criteria_Id            IN OUT  NOCOPY NUMBER,
                       X_Plan_Relationship_Id           NUMBER,
                       X_Char_Id                        NUMBER,
                       X_Operator                       NUMBER,
                       X_Low_Value                      VARCHAR2,
                       X_Low_Value_Id                   NUMBER,
                       X_High_Value                     VARCHAR2,
                       X_High_Value_Id                  NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Login              NUMBER
  ) IS
     CURSOR C IS SELECT rowid FROM QA_PC_CRITERIA
                 WHERE criteria_id = X_Criteria_Id;

Line: 20

     CURSOR C2 IS SELECT qa_pc_criteria_s.nextval FROM dual;

Line: 28

      INSERT INTO QA_PC_CRITERIA(
                   criteria_id,
                   plan_relationship_id,
                   char_id,
                   operator,
                   low_value,
                   low_value_id,
                   high_value,
                   high_value_id,
                   last_update_date,
                   last_updated_by,
                   creation_date,
                   created_by,
                   last_update_login
           )VALUES (
                   X_Criteria_Id,
                   X_Plan_Relationship_Id,
                   X_Char_Id,
                   X_Operator,
                   X_Low_Value,
                   X_Low_Value_Id,
                   X_High_Value,
                   X_High_Value_Id ,
                   X_Last_Update_Date,
                   X_Last_Updated_By ,
                   X_Creation_Date,
                   X_Created_By ,
                   X_Last_Update_Login
          );

Line: 64

  END Insert_Row;

Line: 75

                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER

   ) IS
    CURSOR C IS
        SELECT *
        FROM   QA_PC_CRITERIA
        WHERE  rowid = X_Rowid
        FOR UPDATE of Criteria_Id NOWAIT;

Line: 93

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

Line: 114

           AND (Recinfo.last_update_date =  X_Last_Update_Date)
           AND (Recinfo.last_updated_by =  X_Last_Updated_By)
           AND (Recinfo.creation_date =  X_Creation_Date)
           AND (Recinfo.created_by =  X_Created_By)
        ) then
      return;

Line: 127

  PROCEDURE Update_Row( X_Rowid                         VARCHAR2,
                       X_Criteria_Id                    NUMBER,
                       X_Plan_Relationship_Id           NUMBER,
                       X_Char_Id                        NUMBER,
                       X_Operator                       NUMBER,
                       X_Low_Value                      VARCHAR2,
                       X_Low_Value_Id                   NUMBER,
                       X_High_Value                     VARCHAR2,
                       X_High_Value_Id                  NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Login              NUMBER
  ) IS
  BEGIN
    UPDATE QA_PC_CRITERIA
    SET
           criteria_id                 = X_Criteria_Id ,
           plan_relationship_id        = X_Plan_Relationship_Id ,
           char_id                     = X_Char_Id,
           operator                    = X_Operator,
           low_value                   = X_Low_Value,
           low_value_id                = X_Low_Value_Id,
           high_value                  = X_High_Value,
           high_value_id               = X_High_Value_Id,
           last_update_date            = X_Last_Update_Date,
           last_updated_by             = X_Last_Updated_By,
           creation_date               = X_Creation_Date,
           created_by                  = X_Created_By,
           last_update_login           = X_Last_Update_Login
    WHERE rowid = X_Rowid;

Line: 163

  END Update_Row;

Line: 165

  PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
  BEGIN
    DELETE FROM QA_PC_CRITERIA
    WHERE rowid = X_Rowid;

Line: 173

  END Delete_Row;