APPS.PA_STANDARD_UNIT_COSTS_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_Book_Type_Code                 VARCHAR2,
                       X_Asset_Category_ID              NUMBER,
                       X_Standard_Unit_Cost             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    pa_standard_unit_costs
        WHERE   book_type_code = X_Book_Type_Code
        AND     asset_category_id = X_Asset_Category_ID;

Line: 24

       INSERT INTO pa_standard_unit_costs(
              book_type_code,
              asset_category_id,
              standard_unit_cost,
              last_update_date,
              last_updated_by,
              creation_date,
              created_by,
              last_update_login
             ) VALUES (
              X_Book_Type_Code,
              X_Asset_Category_ID,
              X_Standard_Unit_Cost,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Login
             );

Line: 56

                                p_procedure_name => 'INSERT_ROW',
                                p_error_text => SUBSTRB(SQLERRM,1,240));

Line: 60

  END Insert_Row;

Line: 70

	   SELECT  *
	   FROM    pa_standard_unit_costs
       WHERE   pa_standard_unit_costs.ROWID = X_Rowid
       FOR UPDATE of Standard_Unit_Cost NOWAIT;

Line: 83

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

Line: 101

  PROCEDURE Update_Row(X_Rowid                        IN OUT NOCOPY VARCHAR2,
                     X_Book_Type_Code                 VARCHAR2,
                     X_Asset_Category_ID              NUMBER,
                     X_Standard_Unit_Cost             NUMBER,
                     X_Last_Update_Date               DATE,
                     X_Last_Updated_By                NUMBER,
                     X_Last_Update_Login              NUMBER
                    ) IS

  BEGIN
    UPDATE pa_standard_unit_costs
    SET
       book_type_code                  =     X_Book_Type_Code,
       asset_category_id               =     X_Asset_Category_ID,
       standard_unit_cost              =     X_Standard_Unit_Cost,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login
    WHERE rowid = X_Rowid;

Line: 131

                                p_procedure_name => 'UPDATE_ROW',
                                p_error_text => SUBSTRB(SQLERRM,1,240));

Line: 134

  END Update_Row;

Line: 137

  PROCEDURE Delete_Row(X_Rowid VARCHAR2,
                       X_Book_Type_Code VARCHAR2,
			           X_Asset_Category_ID NUMBER) IS
  BEGIN

    DELETE FROM pa_standard_unit_costs
    WHERE rowid = X_Rowid;

Line: 148

  END Delete_Row;