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 = ff.function_id
AND ff.irep_class_id = fic.class_id
AND function_name LIKE 'PLSQL%UPDATE_PERSON_ADDRESS'
AND (irep_name LIKE 'HR%' OR irep_name LIKE 'PER%' OR irep_name LIKE 'PAY%')
ORDER BY 4
The below script would list down all HRMS APIs of PLSQL type and their mandatory parameters, this can be used to build the basic skeleton for your custom wrapper programs.

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 (irep_name LIKE 'HR%' OR irep_name LIKE 'PER%' OR irep_name LIKE 'PAY%')
AND fp.function_id = ff.function_id
AND param_optional = 'N'
ORDER BY 1, param_sequence