APPS.HR_PUMP_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 49

   select hr_pump_batch_headers_s.nextval
   into   l_batch_id
   from   sys.dual;

Line: 55

   insert  into hr_pump_batch_headers (
           batch_id,
           batch_name,
           batch_status,
           reference,
           business_group_name,
           atomic_linked_calls)
   values (l_batch_id,
           p_batch_name,
           'U',
           p_reference,
           p_business_group_name,
           upper(p_atomic_linked_calls));

Line: 85

   insert  into hr_pump_batch_line_user_keys (
           user_key_id,
           batch_line_id,
           user_key_value,
           unique_key_id)
   values (hr_pump_batch_line_user_keys_s.nextval,
           null,
           p_user_key_value,
           p_unique_key_id);

Line: 111

   select user_key_value, unique_key_id
   into   l_user_key_value,
          l_unique_key_id
   from   hr_pump_batch_line_user_keys
   where  user_key_value = p_user_key_value;

Line: 118

   update hr_pump_batch_line_user_keys
   set    user_key_value = nvl(p_new_user_key_value, l_user_key_value),
          unique_key_id = nvl(p_unique_key_id, l_unique_key_id)
   where  user_key_value = p_user_key_value;

Line: 149

  DELETE
  FROM   HR_PUMP_MODULE_PARAMETERS
  WHERE  UPPER(MODULE_NAME) = L_MODULE_NAME
  AND    UPPER(API_MODULE_TYPE) = L_API_MODULE_TYPE;

Line: 154

  DELETE
  FROM   HR_PUMP_DEFAULT_EXCEPTIONS
  WHERE  UPPER(MODULE_NAME) = L_MODULE_NAME
  AND    UPPER(API_MODULE_TYPE) = L_API_MODULE_TYPE;

Line: 159

  DELETE
  FROM   HR_PUMP_MAPPING_PACKAGES
  WHERE  UPPER(MODULE_NAME) = L_MODULE_NAME
  AND    UPPER(API_MODULE_TYPE) = L_API_MODULE_TYPE;

Line: 185

  SELECT API_MODULE_ID
  FROM   HR_API_MODULES
  WHERE  UPPER(MODULE_NAME)     = P_MODULE_NAME
  AND    UPPER(API_MODULE_TYPE) = P_API_MODULE_TYPE;

Line: 222

    HR_API_MODULE_INTERNAL.UPDATE_API_MODULE
    (P_VALIDATE                   => FALSE
    ,P_API_MODULE_ID              => L_API_MODULE_ID
    ,P_MODULE_NAME                => L_MODULE_NAME
    ,P_MODULE_PACKAGE             => L_MODULE_PACKAGE
    ,P_DATA_WITHIN_BUSINESS_GROUP => L_DATA_WITHIN_BUSINESS_GROUP
    ,P_EFFECTIVE_DATE             => HR_API.G_SYS
    );

Line: 244

  DELETE
  FROM   HR_PUMP_DEFAULT_EXCEPTIONS
  WHERE  UPPER(MODULE_NAME) = L_MODULE_NAME
  AND    UPPER(API_MODULE_TYPE) = L_API_MODULE_TYPE;

Line: 249

  INSERT
  INTO HR_PUMP_DEFAULT_EXCEPTIONS
  (MODULE_NAME
  ,API_MODULE_TYPE
  )
  VALUES
  (L_MODULE_NAME
  ,L_API_MODULE_TYPE
  );

Line: 283

  DELETE
  FROM   HR_PUMP_MODULE_PARAMETERS
  WHERE  UPPER(MODULE_NAME)     = L_MODULE_NAME
  AND    UPPER(API_MODULE_TYPE) = L_API_MODULE_TYPE
  AND    UPPER(API_PARAMETER_NAME)  = L_PARAMETER_NAME;

Line: 289

  INSERT
  INTO   HR_PUMP_MODULE_PARAMETERS
  (MODULE_NAME
  ,API_MODULE_TYPE
  ,API_PARAMETER_NAME
  ,MAPPING_TYPE
  ,MAPPING_DEFINITION
  ,DEFAULT_VALUE
  )
  VALUES
  (L_MODULE_NAME
  ,L_API_MODULE_TYPE
  ,L_PARAMETER_NAME
  ,L_MAPPING_TYPE
  ,L_MAPPING_DEFINITION
  ,L_DEFAULT_VALUE
  );

Line: 326

  DELETE
  FROM   HR_PUMP_MAPPING_PACKAGES
  WHERE  UPPER(MAPPING_PACKAGE) = L_MAPPING_PACKAGE
  AND    NVL(UPPER(MODULE_NAME), HR_API.G_VARCHAR2)     =
         NVL(L_MODULE_NAME, HR_API.G_VARCHAR2)
  AND    NVL(UPPER(API_MODULE_TYPE), HR_API.G_VARCHAR2) =
         NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
  AND    NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2)  =
         NVL(L_MODULE_PACKAGE, HR_API.G_VARCHAR2);

Line: 336

  INSERT
  INTO   HR_PUMP_MAPPING_PACKAGES
  (MAPPING_PACKAGE
  ,MODULE_NAME
  ,API_MODULE_TYPE
  ,MODULE_PACKAGE
  ,CHECKING_ORDER
  )
  VALUES
  (L_MAPPING_PACKAGE
  ,L_MODULE_NAME
  ,L_API_MODULE_TYPE
  ,L_MODULE_PACKAGE
  ,P_CHECKING_ORDER
  );

Line: 368

select request_id
from   hr_pump_requests
;

Line: 425

select null
from   pay_action_parameter_values pap
where  pap.parameter_name = 'PUMP_DT_ENFORCE_FOREIGN_LOCKS'
and    pap.parameter_value <> 'Y'
and    pap.parameter_value <> 'y'
;

Line: 490

  select api_module_id
   from  hr_api_modules
  where  module_name = p_module_name
    and  api_module_type in ('AI','BP');

Line: 496

  select 1
   from hr_pump_spread_loaders
  where module_name       = p_module_name
    and integrator_code   = p_integrator_code
    and module_mode       = p_module_mode;

Line: 513

   l_api_module_name :='UPDATE_USER_TABLE';

Line: 521

   l_api_module_name := 'UPDATE_USER_COLUMN';

Line: 529

   l_api_module_name :='UPDATE_USER_ROW';

Line: 537

   l_api_module_name :='UPDATE_USER_COLUMN_INSTANCE';

Line: 561

 update hr_pump_spread_loaders set
    entity_name            = p_entity_name
   ,api_module_id          = l_api_module_id
   ,entity_sql_column_name = p_entity_sql_column_name
   ,entity_sql_column_id   = p_entity_sql_column_id
   ,entity_sql_addl_column = p_entity_sql_addl_column
   ,entity_sql_object_name = p_entity_sql_object_name
   ,entity_sql_where_clause= p_entity_sql_where_clause
   ,entity_sql_parameters  = p_entity_sql_parameters
   ,entity_sql_order_by    = p_entity_sql_order_by
   ,integrator_parameters  = p_integrator_parameters

  where module_name        = p_module_name
    and integrator_code    = p_integrator_code
    and module_mode        = p_module_mode;

Line: 578

 insert into hr_pump_spread_loaders
  (
    module_name
   ,integrator_code
   ,entity_name
   ,module_mode
   ,api_module_id
   ,entity_sql_column_name
   ,entity_sql_column_id
   ,entity_sql_addl_column
   ,entity_sql_object_name
   ,entity_sql_where_clause
   ,entity_sql_parameters
   ,entity_sql_order_by
   ,integrator_parameters
  )
 values
  (
    p_module_name
   ,p_integrator_code
   ,p_entity_name
   ,p_module_mode
   ,l_api_module_id
   ,p_entity_sql_column_name
   ,p_entity_sql_column_id
   ,p_entity_sql_addl_column
   ,p_entity_sql_object_name
   ,p_entity_sql_where_clause
   ,p_entity_sql_parameters
   ,p_entity_sql_order_by
   ,p_integrator_parameters
   );