APPS.HR_API_USER_HOOKS_UTILITY dependencies on HR_API_MODULES

Line 248: , hr_api_modules amd

244: select amd.api_module_id
245: , hlk.meaning
246: , amd.module_name
247: from hr_lookups hlk
248: , hr_api_modules amd
249: where hlk.lookup_type = 'API_MODULE_TYPE'
250: and hlk.lookup_code = amd.api_module_type
251: and amd.api_module_type in ('BP', 'RH')
252: order by hlk.meaning, amd.module_name;

Line 463: -- The API module must be defined in the HR_API_MODULES table.

459: -- write_all_errors_report and write_one_errors_report procedures in
460: -- this package.
461: --
462: -- Prerequisites:
463: -- The API module must be defined in the HR_API_MODULES table.
464: --
465: -- In Parameters:
466: -- Name Reqd Type Description
467: -- p_api_module_id Yes Number ID of API module

Line 699: , hr_api_modules amd

695: select amd.api_module_id
696: , hlk.meaning
697: , amd.module_name
698: from hr_lookups hlk
699: , hr_api_modules amd
700: where hlk.lookup_type = 'API_MODULE_TYPE'
701: and hlk.lookup_code = amd.api_module_type
702: and amd.api_module_type in ('BP', 'RH')
703: order by hlk.meaning, amd.module_name;

Line 766: , hr_api_modules amd

762: cursor cur_module is
763: select amd.module_name
764: , hlk.meaning
765: from hr_lookups hlk
766: , hr_api_modules amd
767: where amd.api_module_id = p_api_module_id
768: and hlk.lookup_type = 'API_MODULE_TYPE'
769: and hlk.lookup_code = amd.api_module_type
770: and amd.api_module_type in ('BP', 'RH');

Line 941: from hr_api_modules

937: -- and it is a business process or row handler
938: --
939: cursor cur_module is
940: select 'Y'
941: from hr_api_modules
942: where api_module_id = p_api_module_id
943: and api_module_type in ('BP', 'RH');
944: --
945: -- Cursor to obtain the the API hook package names