APPS.HR_PUMP_UTILS dependencies on HR_PUMP_SPREAD_LOADERS

Line 489: cursor csr_get_api_module_id (p_module_name hr_pump_spread_loaders.module_name%type) is

485: ,p_integrator_parameters in varchar2
486: )
487: is
488:
489: cursor csr_get_api_module_id (p_module_name hr_pump_spread_loaders.module_name%type) is
490: select api_module_id
491: from hr_api_modules
492: where module_name = p_module_name
493: and api_module_type in ('AI','BP');

Line 497: from hr_pump_spread_loaders

493: and api_module_type in ('AI','BP');
494:
495: cursor csr_chk_row_exists is
496: select 1
497: from hr_pump_spread_loaders
498: where module_name = p_module_name
499: and integrator_code = p_integrator_code
500: and module_mode = p_module_mode;
501:

Line 561: update hr_pump_spread_loaders set

557: open csr_chk_row_exists;
558: fetch csr_chk_row_exists into l_exists;
559:
560: if (csr_chk_row_exists%found) then
561: update hr_pump_spread_loaders set
562: entity_name = p_entity_name
563: ,api_module_id = l_api_module_id
564: ,entity_sql_column_name = p_entity_sql_column_name
565: ,entity_sql_column_id = p_entity_sql_column_id

Line 578: insert into hr_pump_spread_loaders

574: and integrator_code = p_integrator_code
575: and module_mode = p_module_mode;
576:
577: else
578: insert into hr_pump_spread_loaders
579: (
580: module_name
581: ,integrator_code
582: ,entity_name