APPS.FA_CUA_HIERARCHY_VALUES_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_asset_hierarchy_id in out nocopy number
			 , x_book_type_code	in varchar2
			 , x_asset_category_id  in number
			 , x_lease_id   	in number
			 , x_asset_key_ccid in number
			 , x_serial_number	in varchar2
			 , x_life_end_date	in date
             , x_dist_set_id    in number
			 , X_CREATION_DATE	in date
			 , X_CREATED_BY		in number
			 , X_LAST_UPDATE_DATE	in date
			 , X_LAST_UPDATED_BY	in number
			 , X_LAST_UPDATE_LOGIN	in number
	)
   is
    Cursor C1 is Select ROWID from FA_ASSET_HIERARCHY_VALUES
    where asset_hierarchy_id = x_asset_hierarchy_id
    and book_type_code = x_book_type_code;

Line: 24

    insert into FA_ASSET_HIERARCHY_VALUES
                     (     asset_hierarchy_id
                         , book_type_code
                         , asset_category_id
                         , lease_id
                         , asset_key_ccid
                         , serial_number
                         , life_end_date
                         , dist_set_id
                         , CREATION_DATE
                         , CREATED_BY
                         , LAST_UPDATE_DATE
                         , LAST_UPDATED_BY
                         , LAST_UPDATE_LOGIN
                      ) Values
                      (   x_asset_hierarchy_id
                         , x_book_type_code
                         , x_asset_category_id
                         , x_lease_id
                         , x_asset_key_ccid
                         , x_serial_number
                         , x_life_end_date
                         , x_dist_set_id
                         , X_CREATION_DATE
                         , X_CREATED_BY
                         , X_LAST_UPDATE_DATE
                         , X_LAST_UPDATED_BY
                         , X_LAST_UPDATE_LOGIN
			);

Line: 61

   end INSERT_ROW;

Line: 77

                         , X_LAST_UPDATE_DATE   in date
                         , X_LAST_UPDATED_BY    in number
                         , X_LAST_UPDATE_LOGIN  in number
  			)
  is
   begin
    null;

Line: 98

   Select book_type_code
        , asset_category_id
        , lease_id
        , asset_key_ccid
        , serial_number
        , life_end_date
        , dist_set_id
   from FA_ASSET_HIERARCHY_VALUES
   where rowid = x_rowid
   for update nowait;

Line: 148

procedure UPDATE_ROW (
			               x_rowid 		        in varchar2
                         , x_book_type_code     in varchar2
                         , x_asset_category_id  in number
                         , x_lease_id           in number
                         , x_asset_key_ccid     in number
                         , x_serial_number      in varchar2
                         , x_life_end_date      in date
                         , x_dist_set_id        in number
                         , X_LAST_UPDATE_DATE   in date
                         , X_LAST_UPDATED_BY    in number
                         , X_LAST_UPDATE_LOGIN  in number
  			)
is
begin
  update FA_ASSET_HIERARCHY_VALUES
  set  book_type_code = x_book_type_code
     , asset_category_id = x_asset_category_id
     , lease_id = x_lease_id
     , asset_key_ccid = x_asset_key_ccid
     , serial_number = x_serial_number
     , life_end_date = x_life_end_date
     , dist_set_id   = x_dist_set_id
     , 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: 178

end UPDATE_ROW;

Line: 180

procedure DELETE_ROW (
			  x_rowid 	in VARCHAR2
			)
is
begin
 delete from FA_ASSET_HIERARCHY_VALUES
 where rowid = x_rowid;

Line: 190

end DELETE_ROW;