{"id":18480,"date":"2019-06-12T19:03:50","date_gmt":"2019-06-12T22:03:50","guid":{"rendered":"https:\/\/orabr.com\/?p=18480"},"modified":"2019-06-12T19:43:27","modified_gmt":"2019-06-12T22:43:27","slug":"oracle-r11-r12-todas-as-apis-do-ebs-e-seus-parametros-obrigatorios","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=18480","title":{"rendered":"ORACLE R11 R12 TODAS AS API’S DO EBS E SEUS PAR\u00c2METROS OBRIGATORIOS"},"content":{"rendered":"\n
\n\n\n\n--PROCURAR PELA API POR M\u00d3DULO E OBJETIVO \nSELECT ff.TYPE\n      ,ff.irep_method_name\n      ,fif.function_id\n      ,ff.function_name\n      ,fic.class_name\n      ,irep_name\n      ,fif.description\n  FROM fnd_form_functions_vl     ff\n      ,fnd_irep_function_flavors fif\n      ,fnd_irep_classes          fic\n WHERE 1 = 1\n      --and fif.function_id = 49293\n   AND fif.function_id = ff.function_id\n   AND ff.irep_class_id = fic.class_id\n   AND function_name LIKE 'PLSQL%UPDATE_PERSON_ADDRESS'--'PLSQL%ACAO QUE DESEJA LOCALIZAR'--'EXEMPLO:   PLSQL%UPDATE_PERSON_ADDRESS'\n   --AND (irep_name LIKE 'HR%' OR irep_name LIKE 'PER%' OR irep_name LIKE 'PAY%')\n   AND REGEXP_LIKE(irep_name,'^HR*|^PER*|^PAY*') --MODULOS QUE SE DESEJA PROCURAR\n ORDER BY 4\n<\/code><\/pre>\n\n\n\n
\n\n\n\n--VERIFICAR PAR\u00c2METROS OBRIGAT\u00d3RIOS PARA A API QUE SE DESEJA USAR\nSELECT irep_name || '.' || ff.irep_method_name api\n      ,fp.param_name\n      ,fp.param_direction\n      ,fp.param_optional\n      ,fp.DEFAULT_VALUE\n      ,fp.parameter_type\n  FROM fnd_form_functions_vl     ff\n      ,fnd_irep_function_flavors fif\n      ,fnd_irep_classes          fic\n      ,fnd_parameters            fp\n WHERE 1 = 1\n   AND fif.function_id = ff.function_id\n   AND ff.irep_class_id = fic.class_id\n   AND function_name LIKE 'PLSQL%'\n   AND REGEXP_LIKE(irep_name,'^HR*|^PER*|^PAY*') --MODULOS QUE SE DESEJA PROCURAR\n   AND fp.function_id = ff.function_id\n   AND param_optional = 'N'\n ORDER BY 1 ,param_sequence<\/code><\/pre>\n\n\n\n