APPS.HR_PUMP_META_MAPPER dependencies on HR_API_MODULES

Line 365: from hr_api_modules ham,

361: select upper(hrpmp.api_parameter_name),
362: upper(hrpmp.mapping_type),
363: upper(hrpmp.mapping_definition),
364: hrpmp.default_value
365: from hr_api_modules ham,
366: hr_pump_module_parameters hrpmp
367: where upper(ham.module_package) = upper(p_module_package)
368: and upper(ham.module_name) = upper(p_module_name)
369: and upper(ham.api_module_type) in ( 'AI', 'BP','DM' )

Line 439: hr_api_modules am

435: p_module_name in varchar2
436: ) is
437: select mp.mapping_package
438: from hr_pump_mapping_packages mp,
439: hr_api_modules am
440: where (mp.module_name is not null and
441: upper(mp.module_name) = upper(p_module_name) and
442: upper(am.module_name) = upper(p_module_name) and
443: upper(am.api_module_type) = upper(mp.api_module_type))

Line 1776: hr_api_modules ham

1772: is
1773: cursor csr_defaulting_style( p_module_name in varchar2 ) is
1774: select decode( count(0), 0, c_default_hr_api, c_default_null )
1775: from hr_pump_default_exceptions hrpde,
1776: hr_api_modules ham
1777: where upper(ham.module_package) = upper(p_module_package)
1778: and upper(ham.module_name) = upper(p_module_name)
1779: and upper(ham.api_module_type) in ('AI', 'BP', 'DM')
1780: and upper(hrpde.module_name) = upper(p_module_name)

Line 3683: from hr_api_modules

3679: --
3680: cursor csr_api_module_id
3681: (p_module_package in varchar2, p_module_name in varchar2) is
3682: select api_module_id
3683: from hr_api_modules
3684: where upper(module_name) = upper(p_module_name)
3685: and upper(module_package) = upper(p_module_package)
3686: and upper(api_module_type) in ('AI', 'BP', 'DM');
3687: begin

Line 4098: from hr_api_modules

4094: g_last_api_id := p_api_id;
4095: --
4096: select module_package,module_name
4097: into l_module_package,l_module_name
4098: from hr_api_modules
4099: where api_module_id = p_api_id;
4100: --
4101: hr_pump_meta_mapper.g_standard_generate := true;
4102: setup_parameter_data(