APPS.GL_STAT_ACCOUNT_UOM_PKG SQL Statements

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

Line: 21

  PROCEDURE select_row( recinfo IN OUT NOCOPY gl_stat_account_uom%ROWTYPE) IS
  BEGIN
    SELECT *
    INTO recinfo
    FROM gl_stat_account_uom
    WHERE chart_of_accounts_id = recinfo.chart_of_accounts_id
    AND   account_segment_value = recinfo.account_segment_value;

Line: 28

  END SELECT_ROW;

Line: 35

  PROCEDURE select_columns(
			x_chart_of_accounts_id		IN OUT NOCOPY NUMBER,
			x_account_segment_value		IN OUT NOCOPY VARCHAR2,
			x_unit_of_measure		IN OUT NOCOPY VARCHAR2,
			x_description			IN OUT NOCOPY VARCHAR2) IS

    recinfo gl_stat_account_uom%ROWTYPE;

Line: 47

    select_row(recinfo);

Line: 52

  END select_columns;

Line: 55

PROCEDURE Insert_Row(X_Rowid                        IN OUT NOCOPY VARCHAR2,
                     X_Account_Segment_Value               VARCHAR2,
                     X_Unit_Of_Measure                     VARCHAR2,
                     X_Chart_Of_Accounts_Id                NUMBER,
                     X_Description                         VARCHAR2 DEFAULT NULL,
                     X_Last_Update_Date                    DATE DEFAULT NULL,
                     X_Last_Updated_By                     NUMBER DEFAULT NULL,
                     X_Creation_Date                       DATE DEFAULT NULL,
                     X_Created_By                          NUMBER DEFAULT NULL,
                     X_Last_Update_Login                   NUMBER DEFAULT NULL
 ) IS
   CURSOR C IS SELECT rowid FROM gl_stat_account_uom

             WHERE account_segment_value = X_Account_Segment_Value

             AND   chart_of_accounts_id = X_Chart_Of_Accounts_Id;

Line: 82

  INSERT INTO gl_stat_account_uom(
          account_segment_value,
          unit_of_measure,
          chart_of_accounts_id,
          description,
          last_update_date,
          last_updated_by,
          creation_date,
          created_by,
          last_update_login
         ) VALUES (
          X_Account_Segment_Value,
          X_Unit_Of_Measure,
          X_Chart_Of_Accounts_Id,
          X_Description,
          X_Last_Update_Date,
          X_Last_Updated_By,
          X_Creation_Date,
          X_Created_By,
          X_Last_Update_Login

  );

Line: 112

END Insert_Row;

Line: 121

      SELECT *
      FROM   gl_stat_account_uom
      WHERE  rowid = X_Rowid
      FOR UPDATE of Account_Segment_Value NOWAIT;

Line: 155

PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Account_Segment_Value               VARCHAR2,
                     X_Unit_Of_Measure                     VARCHAR2,
                     X_Chart_Of_Accounts_Id                NUMBER,
                     X_Description                         VARCHAR2 DEFAULT NULL,
                     X_Last_Update_Date                    DATE DEFAULT NULL,
                     X_Last_Updated_By                     NUMBER DEFAULT NULL,
                     X_Last_Update_Login                   NUMBER DEFAULT NULL
) IS
BEGIN
  UPDATE gl_stat_account_uom
  SET

    account_segment_value                     =    X_Account_Segment_Value,
    unit_of_measure                           =    X_Unit_Of_Measure,
    chart_of_accounts_id                      =    X_Chart_Of_Accounts_Id,
    description                               =    X_Description,
    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: 181

END Update_Row;

Line: 183

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

Line: 191

END Delete_Row;

Line: 198

  select 1 into dummy from dual where not exists
    (select 1 from gl_stat_account_uom
     where account_segment_value = X_Account_Segment_Value
      and  chart_of_accounts_id  = X_Chart_Of_Accounts_Id
      and  ((X_Rowid is null) or (rowid <> X_Rowid))
     );