WEB ADI 注册功能的SQL 语句

1.删除集成器：bne_integrator_utils.delete_integrator

 

2.注册功能

DECLARE
  x_APPL_ID  FND_APPLICATION.APPLICATION_ID%TYPE;
  x_FORM_ID  FND_FORM.FORM_ID%TYPE;
  x_ROWID    VARCHAR2(100);
  x_FUNC_ID  NUMBER;
  x_menu_id  number;
  l_integ_code VARCHAR2(30);
  l_param VARCHAR2(300);
  l_map_code VARCHAR2(30);
  l_layout_code VARCHAR2(30);
  l_cont_code VARCHAR2(30);
BEGIN
  --应用
  SELECT APPLICATION_ID
    INTO x_APPL_ID
    FROM FND_APPLICATION
   WHERE APPLICATION_SHORT_NAME = 'CUX';
  

  SELECT bi.integrator_code
  INTO   l_integ_code
  FROM   bne_integrators_vl bi
  WHERE  bi.user_name = 'CRC_B17_AR_收款导入_ADI_2' --集成器的名称
  AND    bi.application_id = x_APPL_ID;

  SELECT l.layout_code
  INTO l_layout_code
  FROM bne_layouts_b l
  WHERE l.integrator_code = l_integ_code;