ORACLE R11 R12 TODAS AS API’S DO EBS E SEUS PARÂMETROS OBRIGATORIOS

--PROCURAR PELA API POR MÓDULO E OBJETIVO 
SELECT ff.TYPE
      ,ff.irep_method_name
      ,fif.function_id
      ,ff.function_name
      ,fic.class_name
      ,irep_name
      ,fif.description
  FROM fnd_form_functions_vl     ff
      ,fnd_irep_function_flavors fif
      ,fnd_irep_classes          fic
 WHERE 1 = 1
      --and fif.function_id = 49293
   AND fif.function_id = ff.function_id
   AND ff.irep_class_id = fic.class_id
   AND function_name LIKE 'PLSQL%UPDATE_PERSON_ADDRESS'--'PLSQL%ACAO QUE DESEJA LOCALIZAR'--'EXEMPLO:   PLSQL%UPDATE_PERSON_ADDRESS'
   --AND (irep_name LIKE 'HR%' OR irep_name LIKE 'PER%' OR irep_name LIKE 'PAY%')
   AND REGEXP_LIKE(irep_name,'^HR*|^PER*|^PAY*') --MODULOS QUE SE DESEJA PROCURAR
 ORDER BY 4

--VERIFICAR PARÂMETROS OBRIGATÓRIOS PARA A API QUE SE DESEJA USAR
SELECT irep_name || '.' || ff.irep_method_name api
      ,fp.param_name
      ,fp.param_direction
      ,fp.param_optional
      ,fp.DEFAULT_VALUE
      ,fp.parameter_type
  FROM fnd_form_functions_vl     ff
      ,fnd_irep_function_flavors fif
      ,fnd_irep_classes          fic
      ,fnd_parameters            fp
 WHERE 1 = 1
   AND fif.function_id = ff.function_id
   AND ff.irep_class_id = fic.class_id
   AND function_name LIKE 'PLSQL%'
   AND REGEXP_LIKE(irep_name,'^HR*|^PER*|^PAY*') --MODULOS QUE SE DESEJA PROCURAR
   AND fp.function_id = ff.function_id
   AND param_optional = 'N'
 ORDER BY 1 ,param_sequence