To Create LOV and Date (calendar)LOV for WebADI

To create window LOV (value set) and Date LOV(calendar) for WebADI cloumns

--To Create LOV
declare
  ln_application_id  number;
  lc_integtr_code    varchar2 (50);
  lx_interface_code  varchar2 (50);
  lx_param_list_code varchar2 (50);
  ln_application_id  number;
begin
  bne_integrator_utils.create_table_lov (
  p_application_id => 800,
  p_interface_code => '<INTERFACE_CODE>',
  p_interface_col_name => '<P_FULL_NAME>', ----proc params
  p_id_col => 'LOOKUP_CODE',
  p_mean_col => 'LOOKUP_CODE',
  p_desc_col => null (or 'DESCRIPTION'),
  p_table => 'FND_COMMON_LOOKUPS',
  P_ADDL_W_C => ' LOOKUP_TYPE=''XX'' AND ENABLED_FLAG =''Y''',
  p_window_caption => 'SELECT Full Name',
  p_window_width => 400, p_window_height => 300,
  p_table_block_size => 10,
  p_table_sort_order => 'Yes',
  p_user_id => 83087 );
end;
/


-- To Add Date LOV(calender) to Web ADI Column
   declare
   ln_application_id    number;
   lc_integtr_code      varchar2 (50);
   lx_interface_code    varchar2 (50);
   lx_param_list_code   varchar2 (50);
   ln_application_id    number;
begin
   bne_integrator_utils.create_calendar_lov
                                (p_application_id          => 800,
                                 p_interface_code          => '<interface_code>',
                                 p_interface_col_name      => 'P_START_DATE',--proc params
                                 p_window_caption          => 'Select Date',
                                 p_window_width            => 400,
                                 p_window_height           => 300,
                                 p_table_columns           => 'START_DATE',
                                 p_user_id                 => 83087
                                );
end;
/