eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_COST_GROUPS_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_Cost_Group_Id                  IN OUT NOCOPY NUMBER,
                       X_Cost_Group                     VARCHAR2,
                       X_Description                    VARCHAR2 DEFAULT NULL,
                       X_Organization_Id                NUMBER DEFAULT NULL,
                       X_Disable_Date                   DATE 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,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER DEFAULT NULL,
		       X_Cost_Group_Type		NUMBER DEFAULT 1
  ) IS
    CURSOR C IS SELECT rowid FROM cst_cost_groups
                 WHERE cost_group_id = X_Cost_Group_Id;

Line: 35


      CURSOR C2 IS SELECT cst_cost_groups_s.nextval FROM sys.dual;

Line: 45


       INSERT INTO cst_cost_groups(

              cost_group_id,
              cost_group,
              description,
              organization_id,
              disable_date,
              attribute_category,
              attribute1,
              attribute2,
              attribute3,
              attribute4,
              attribute5,
              attribute6,
              attribute7,
              attribute8,
              attribute9,
              attribute10,
              attribute11,
              attribute12,
              attribute13,
              attribute14,
              attribute15,
              creation_date,
              created_by,
              last_update_date,
              last_updated_by,
              last_update_login,
              cost_group_type
             ) VALUES (

              X_Cost_Group_Id,
              X_Cost_Group,
              X_Description,
              X_Organization_Id,
              X_Disable_Date,
              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,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Last_Update_Login,
              X_Cost_Group_Type
             );

Line: 112


  END Insert_Row;

Line: 139


        SELECT *
        FROM   cst_cost_groups
        WHERE  rowid = X_Rowid
        FOR UPDATE of Cost_Group_Id NOWAIT;

Line: 151


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

Line: 225


  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Cost_Group_Id                  NUMBER,
                       X_Cost_Group                     VARCHAR2,
                       X_Description                    VARCHAR2 DEFAULT NULL,
                       X_Organization_Id                NUMBER DEFAULT NULL,
                       X_Disable_Date                   DATE 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,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER DEFAULT NULL,
		       X_Cost_Group_Type		NUMBER DEFAULT 1

  ) IS
  BEGIN
    UPDATE cst_cost_groups
    SET
       cost_group_id                   =     X_Cost_Group_Id,
       cost_group                      =     X_Cost_Group,
       description                     =     X_Description,
       organization_id                 =     X_Organization_Id,
       disable_date                    =     X_Disable_Date,
       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,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login,
       cost_group_type		       =     X_Cost_Group_Type
    WHERE rowid = X_Rowid;

Line: 286


  END Update_Row;

Line: 288


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

Line: 296


  END Delete_Row;

Line: 298


 PROCEDURE Insert_Fiscal_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Cost_Group_Id                  IN OUT NOCOPY NUMBER,
                       X_Cost_Group                     VARCHAR2,
                       X_Description                    VARCHAR2 DEFAULT NULL,
                       X_Organization_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,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER DEFAULT NULL,
		       X_Legal_Entity			NUMBER
  ) IS

    CURSOR C IS SELECT rowid FROM cst_cost_groups
                 WHERE cost_group_id = X_Cost_Group_Id;

Line: 329


 CURSOR C2 IS SELECT cst_cost_groups_s.nextval FROM sys.dual;

Line: 339


       INSERT INTO cst_cost_groups(

              cost_group_id,
              cost_group,
              description,
              organization_id,
              attribute_category,
              attribute1,
              attribute2,
              attribute3,
              attribute4,
              attribute5,
              attribute6,
              attribute7,
              attribute8,
              attribute9,
              attribute10,
              attribute11,
              attribute12,
              attribute13,
              attribute14,
              attribute15,
              creation_date,
              created_by,
              last_update_date,
              last_updated_by,
              last_update_login,
              cost_group_type,
              legal_entity
             ) VALUES (

              X_Cost_Group_Id,
              X_Cost_Group,
              X_Description,
              X_Organization_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,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Last_Update_Login,
              X_Cost_Group_Type,
              X_Legal_Entity
             );

Line: 406


  END Insert_Fiscal_Row;

Line: 432


        SELECT *
        FROM   cst_cost_groups
        WHERE  rowid = X_Rowid
        FOR UPDATE of Cost_Group_Id NOWAIT;

Line: 444


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

Line: 516


PROCEDURE Update_Fiscal_Row(X_Rowid                          VARCHAR2,
                       X_Cost_Group_Id                  NUMBER,
                       X_Cost_Group                     VARCHAR2,
                       X_Description                    VARCHAR2 DEFAULT NULL,
                       X_Organization_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,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER DEFAULT NULL,
                       X_Legal_Entity			NUMBER
  ) IS
  BEGIN
    UPDATE cst_cost_groups
    SET
       cost_group_id                   =     X_Cost_Group_Id,
       cost_group                      =     X_Cost_Group,
       description                     =     X_Description,
       organization_id                 =     X_Organization_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,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login,
       legal_entity		       =     X_Legal_Entity
    WHERE rowid = X_Rowid;

Line: 574


  END Update_Fiscal_Row;