APPS.MTL_CST_TXN_COST_DETAILS_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_Transaction_Id                 NUMBER,
                       X_Organization_Id                NUMBER,
                       X_Cost_Element_Id                NUMBER,
                       X_Level_Type                     NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Inventory_Item_Id              NUMBER,
                       X_New_Average_Cost               NUMBER DEFAULT NULL,
                       X_Percentage_Change              NUMBER DEFAULT NULL,
                       X_Value_Change                   NUMBER DEFAULT NULL,
		       X_Transaction_Cost		NUMBER
  ) IS

   BEGIN

       X_Rowid := 0;

Line: 25

       INSERT INTO mtl_cst_txn_cost_details(
              transaction_id,
              organization_id,
              cost_element_id,
              level_type,
              last_update_date,
              last_updated_by,
              creation_date,
              created_by,
              inventory_item_id,
              new_average_cost,
              percentage_change,
              value_change,
	      transaction_cost
             ) VALUES (
              X_Transaction_Id,
              X_Organization_Id,
              X_Cost_Element_Id,
              X_Level_Type,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Creation_Date,
              X_Created_By,
              X_Inventory_Item_Id,
              X_New_Average_Cost,
              X_Percentage_Change,
              X_Value_Change,
	      X_Transaction_Cost
             );

Line: 59

  END Insert_Row;

Line: 62

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Cost_Element_Id                NUMBER,
                       X_Level_Type                     NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_New_Average_Cost               NUMBER DEFAULT NULL,
                       X_Percentage_Change              NUMBER DEFAULT NULL,
                       X_Value_Change                   NUMBER DEFAULT NULL

  ) IS
  BEGIN
    UPDATE mtl_cst_txn_cost_details
    SET
       cost_element_id                 =     X_Cost_Element_Id,
       level_type                      =     X_Level_Type,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       new_average_cost                =     X_New_Average_Cost,
       percentage_change               =     X_Percentage_Change,
       value_change                    =     X_Value_Change
    WHERE rowid = X_Rowid;

Line: 87

  END Update_Row;

Line: 89

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

Line: 97

  END Delete_Row;

Line: 99

  PROCEDURE Delete_Rows(X_Transaction_Id NUMBER)
  IS BEGIN
    DELETE FROM mtl_cst_txn_cost_details
    WHERE transaction_id = X_Transaction_Id;

Line: 106

  END Delete_Rows;