APPS.WMS_WP_PARAMETERS_LOV_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  x_object_id  in NUMBER,
  x_object_name in VARCHAR2,
  x_object_description in VARCHAR2,
  x_parameter_id  in NUMBER,
  x_parameter_name in VARCHAR2,
  x_parameter_description in VARCHAR2
) is


begin

  insert into wms_wp_parameters_lov (
  object_id,
  object_name,
  object_description,
  parameter_id,
  parameter_name,
  parameter_description
  ) values (
  x_object_id,
  x_object_name,
  x_object_description,
  x_parameter_id,
  x_parameter_name,
  x_parameter_description
  );

Line: 32

end INSERT_ROW;

Line: 36

procedure UPDATE_ROW (
  x_object_id  in NUMBER,
  x_object_name in VARCHAR2,
  x_object_description in VARCHAR2,
  x_parameter_id  in NUMBER,
  x_parameter_name in VARCHAR2,
  x_parameter_description in VARCHAR2
) is
begin
  update wms_wp_parameters_lov set
    object_id = x_object_id,
    object_name = x_object_name,
    object_description = x_object_description,
    parameter_id = x_parameter_id,
    parameter_name = x_parameter_name,
    parameter_description = x_parameter_description
  where parameter_id = x_parameter_id;

Line: 59

end UPDATE_ROW;

Line: 72

    select parameter_id into l_parameter_id
    from wms_wp_parameters_lov
    where parameter_id = x_parameter_id;

Line: 77

      WMS_WP_PARAMETERS_LOV_PKG.UPDATE_ROW(
     x_object_id,
          x_object_name,
          x_object_description,
	     x_parameter_id,
          x_parameter_name,
          x_parameter_Description);

Line: 88

        WMS_WP_PARAMETERS_LOV_PKG.INSERT_ROW (
     x_object_id,
          x_object_name,
          x_object_description,
	     x_parameter_id,
          x_parameter_name,
          x_parameter_Description);