APPS.CST_DEPARTMENT_OVERHEADS_PKG SQL Statements

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

Line: 4

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Department_Id                  NUMBER,
                       X_Cost_Type_Id                   NUMBER,
                       X_Overhead_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 DEFAULT NULL,
                       X_Organization_Id                NUMBER,
                       X_Basis_Type                     NUMBER,
                       X_Rate_Or_Amount                 NUMBER,
                       X_Activity_Id                    NUMBER DEFAULT NULL,
                       X_Attribute_Category             VARCHAR2 DEFAULT NULL,
                       X_Attribute1                     VARCHAR2 DEFAULT NULL,
                       X_Attribute2                     VARCHAR2 DEFAULT NULL,
                       X_Attribute3                     VARCHAR2 DEFAULT NULL,
                       X_Attribute4                     VARCHAR2 DEFAULT NULL,
                       X_Attribute5                     VARCHAR2 DEFAULT NULL,
                       X_Attribute6                     VARCHAR2 DEFAULT NULL,
                       X_Attribute7                     VARCHAR2 DEFAULT NULL,
                       X_Attribute8                     VARCHAR2 DEFAULT NULL,
                       X_Attribute9                     VARCHAR2 DEFAULT NULL,
                       X_Attribute10                    VARCHAR2 DEFAULT NULL,
                       X_Attribute11                    VARCHAR2 DEFAULT NULL,
                       X_Attribute12                    VARCHAR2 DEFAULT NULL,
                       X_Attribute13                    VARCHAR2 DEFAULT NULL,
                       X_Attribute14                    VARCHAR2 DEFAULT NULL,
                       X_Attribute15                    VARCHAR2 DEFAULT NULL

   ) IS
     CURSOR C IS SELECT rowid FROM CST_DEPARTMENT_OVERHEADS
                 WHERE cost_type_id = X_Cost_Type_Id

                 AND   department_id = X_Department_Id

                 AND   overhead_id = X_Overhead_Id;

Line: 47

       INSERT INTO CST_DEPARTMENT_OVERHEADS(
               department_id,
               cost_type_id,
               overhead_id,
               last_update_date,
               last_updated_by,
               creation_date,
               created_by,
               last_update_login,
               organization_id,
               basis_type,
               rate_or_amount,
               activity_id,
               attribute_category,
               attribute1,
               attribute2,
               attribute3,
               attribute4,
               attribute5,
               attribute6,
               attribute7,
               attribute8,
               attribute9,
               attribute10,
               attribute11,
               attribute12,
               attribute13,
               attribute14,
               attribute15
             ) VALUES (
               X_Department_Id,
               X_Cost_Type_Id,
               X_Overhead_Id,
               X_Last_Update_Date,
               X_Last_Updated_By,
               X_Creation_Date,
               X_Created_By,
               X_Last_Update_Login,
               X_Organization_Id,
               X_Basis_Type,
               X_Rate_Or_Amount,
               X_Activity_Id,
               X_Attribute_Category,
               X_Attribute1,
               X_Attribute2,
               X_Attribute3,
               X_Attribute4,
               X_Attribute5,
               X_Attribute6,
               X_Attribute7,
               X_Attribute8,
               X_Attribute9,
               X_Attribute10,
               X_Attribute11,
               X_Attribute12,
               X_Attribute13,
               X_Attribute14,
               X_Attribute15
             );

Line: 114

  END Insert_Row;

Line: 145

        SELECT *
        FROM   CST_DEPARTMENT_OVERHEADS
        WHERE  rowid = X_Rowid
        FOR UPDATE of Cost_Type_Id NOWAIT;

Line: 155

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

Line: 229

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Department_Id                  NUMBER,
                       X_Cost_Type_Id                   NUMBER,
                       X_Overhead_Id                    NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER DEFAULT NULL,
                       X_Organization_Id                NUMBER,
                       X_Basis_Type                     NUMBER,
                       X_Rate_Or_Amount                 NUMBER,
                       X_Activity_Id                    NUMBER DEFAULT NULL,
                       X_Attribute_Category             VARCHAR2 DEFAULT NULL,
                       X_Attribute1                     VARCHAR2 DEFAULT NULL,
                       X_Attribute2                     VARCHAR2 DEFAULT NULL,
                       X_Attribute3                     VARCHAR2 DEFAULT NULL,
                       X_Attribute4                     VARCHAR2 DEFAULT NULL,
                       X_Attribute5                     VARCHAR2 DEFAULT NULL,
                       X_Attribute6                     VARCHAR2 DEFAULT NULL,
                       X_Attribute7                     VARCHAR2 DEFAULT NULL,
                       X_Attribute8                     VARCHAR2 DEFAULT NULL,
                       X_Attribute9                     VARCHAR2 DEFAULT NULL,
                       X_Attribute10                    VARCHAR2 DEFAULT NULL,
                       X_Attribute11                    VARCHAR2 DEFAULT NULL,
                       X_Attribute12                    VARCHAR2 DEFAULT NULL,
                       X_Attribute13                    VARCHAR2 DEFAULT NULL,
                       X_Attribute14                    VARCHAR2 DEFAULT NULL,
                       X_Attribute15                    VARCHAR2 DEFAULT NULL

 ) IS
 BEGIN
   UPDATE CST_DEPARTMENT_OVERHEADS
   SET
     department_id                     =     X_Department_Id,
     cost_type_id                      =     X_Cost_Type_Id,
     overhead_id                       =     X_Overhead_Id,
     last_update_date                  =     X_Last_Update_Date,
     last_updated_by                   =     X_Last_Updated_By,
     last_update_login                 =     X_Last_Update_Login,
     organization_id                   =     X_Organization_Id,
     basis_type                        =     X_Basis_Type,
     rate_or_amount                    =     X_Rate_Or_Amount,
     activity_id                       =     X_Activity_Id,
     attribute_category                =     X_Attribute_Category,
     attribute1                        =     X_Attribute1,
     attribute2                        =     X_Attribute2,
     attribute3                        =     X_Attribute3,
     attribute4                        =     X_Attribute4,
     attribute5                        =     X_Attribute5,
     attribute6                        =     X_Attribute6,
     attribute7                        =     X_Attribute7,
     attribute8                        =     X_Attribute8,
     attribute9                        =     X_Attribute9,
     attribute10                       =     X_Attribute10,
     attribute11                       =     X_Attribute11,
     attribute12                       =     X_Attribute12,
     attribute13                       =     X_Attribute13,
     attribute14                       =     X_Attribute14,
     attribute15                       =     X_Attribute15
   WHERE rowid = X_rowid;

Line: 293

  END Update_Row;

Line: 295

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

Line: 303

  END Delete_Row;