APPS.PAY_BALANCE_DIMENSION_API SQL Statements

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

Line: 124

procedure update_balance_dimension
  (p_validate                   in         boolean  default false,
   p_balance_dimension_id	in	   NUMBER,
   p_business_group_id          in         NUMBER,
   p_legislation_code           in         VARCHAR2,
   p_route_id  			in	   NUMBER,
   p_database_item_suffix       in         VARCHAR2,
   p_dimension_name             in         VARCHAR2,
   p_dimension_type             in         VARCHAR2,
   p_description                in         VARCHAR2,
   p_feed_checking_code         in         VARCHAR2,
   p_legislation_subgroup       in         VARCHAR2,
   p_payments_flag              in         VARCHAR2,
   p_expiry_checking_code       in         VARCHAR2,
   p_expiry_checking_level      in         VARCHAR2,
   p_feed_checking_type         in         VARCHAR2,
   p_dimension_level            in         VARCHAR2,
   p_period_type                in         VARCHAR2,
   p_asg_action_balance_dim_id  in         NUMBER,
   p_database_item_function     in         VARCHAR2,
   p_save_run_balance_enabled   in         VARCHAR2,
   p_start_date_code            in         VARCHAR2
  ) is
  --
  l_proc    varchar2(72) :=g_package||'create_balance_dimension';

Line: 154

  savepoint update_balance_dimension;

Line: 203

    rollback to update_balance_dimension;

Line: 210

    rollback to update_balance_dimension;

Line: 215

end update_balance_dimension;

Line: 221

procedure delete_balance_dimension
  (p_validate                      in     boolean  default false,
   p_balance_dimension_id   in NUMBER
  ) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 230

  l_proc                 varchar2(72) := g_package||'delete_balance_dimension';

Line: 240

  savepoint delete_balance_dimension;

Line: 266

    rollback to delete_balance_dimension;

Line: 274

    rollback to delete_balance_dimension;

Line: 279

end delete_balance_dimension;