APPS.MTL_CYCLE_COUNT_CLASSES_PKG SQL Statements

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

Line: 5

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Abc_Class_Id                          NUMBER,
                       X_Cycle_Count_Header_Id                 NUMBER,
                       X_Organization_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,
                       X_Num_Counts_Per_Year                   NUMBER,
                       X_Approval_Tolerance_Positive           NUMBER,
                       X_Approval_Tolerance_Negative           NUMBER,
                       X_Cost_Tolerance_Positive               NUMBER,
                       X_Cost_Tolerance_Negative               NUMBER,
                       X_Hit_Miss_Tolerance_Positive           NUMBER,
                       X_Hit_Miss_Tolerance_Negative           NUMBER,
                       X_Abc_Assignment_Group_Id               NUMBER
  ) IS
    CURSOR C IS SELECT rowid FROM mtl_cycle_count_classes
                 WHERE (   (cycle_count_header_id = X_Cycle_Count_Header_Id)
                        or (cycle_count_header_id is NULL and X_Cycle_Count_Header_Id is NULL));

Line: 29

       INSERT INTO mtl_cycle_count_classes(
              abc_class_id,
              cycle_count_header_id,
              organization_id,
              last_update_date,
              last_updated_by,
              creation_date,
              created_by,
              last_update_login,
              num_counts_per_year,
              approval_tolerance_positive,
              approval_tolerance_negative,
              cost_tolerance_positive,
              cost_tolerance_negative,
              hit_miss_tolerance_positive,
              hit_miss_tolerance_negative,
              abc_assignment_group_id
             ) VALUES (
              X_Abc_Class_Id,
              X_Cycle_Count_Header_Id,
              X_Organization_Id,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Login,
              X_Num_Counts_Per_Year,
              X_Approval_Tolerance_Positive,
              X_Approval_Tolerance_Negative,
              X_Cost_Tolerance_Positive,
              X_Cost_Tolerance_Negative,
              X_Hit_Miss_Tolerance_Positive,
              X_Hit_Miss_Tolerance_Negative,
              X_Abc_Assignment_Group_Id
             );

Line: 72

  END Insert_Row;

Line: 89

        SELECT *
        FROM   mtl_cycle_count_classes
        WHERE  rowid = X_Rowid
        FOR UPDATE of Cycle_Count_Header_Id NOWAIT;

Line: 101

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

Line: 144

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Abc_Class_Id                   NUMBER,
                       X_Cycle_Count_Header_Id          NUMBER,
                       X_Organization_Id                NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER,
                       X_Num_Counts_Per_Year            NUMBER,
                       X_Approval_Tolerance_Positive    NUMBER,
                       X_Approval_Tolerance_Negative    NUMBER,
                       X_Cost_Tolerance_Positive        NUMBER,
                       X_Cost_Tolerance_Negative        NUMBER,
                       X_Hit_Miss_Tolerance_Positive    NUMBER,
                       X_Hit_Miss_Tolerance_Negative    NUMBER,
                       X_Abc_Assignment_Group_Id        NUMBER
  ) IS
  BEGIN
    UPDATE mtl_cycle_count_classes
    SET
       abc_class_id                    =     X_Abc_Class_Id,
       cycle_count_header_id           =     X_Cycle_Count_Header_Id,
       organization_id                 =     X_Organization_Id,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login,
       num_counts_per_year             =     X_Num_Counts_Per_Year,
       approval_tolerance_positive     =     X_Approval_Tolerance_Positive,
       approval_tolerance_negative     =     X_Approval_Tolerance_Negative,
       cost_tolerance_positive         =     X_Cost_Tolerance_Positive,
       cost_tolerance_negative         =     X_Cost_Tolerance_Negative,
       hit_miss_tolerance_positive     =     X_Hit_Miss_Tolerance_Positive,
       hit_miss_tolerance_negative     =     X_Hit_Miss_Tolerance_Negative,
       abc_assignment_group_id         =     X_Abc_Assignment_Group_Id
    WHERE rowid = X_Rowid;

Line: 182

  END Update_Row;

Line: 183

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

Line: 191

  END Delete_Row;