APPS.PQP_PCV_BUS SQL Statements

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

Line: 28

    select pbg.security_group_id,
           pbg.legislation_code
      from per_business_groups_perf pbg
         , pqp_configuration_values pcv
     where pcv.configuration_value_id = p_configuration_value_id
       and pbg.business_group_id = pcv.business_group_id;

Line: 99

    select pbg.legislation_code
      from per_business_groups_perf pbg
         , pqp_configuration_values pcv
     where pcv.configuration_value_id = p_configuration_value_id
       and pbg.business_group_id (+) = pcv.business_group_id;

Line: 461

Procedure chk_non_updateable_args
  (p_effective_date               in date
  ,p_rec in pqp_pcv_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 486

End chk_non_updateable_args;

Line: 498

  (p_insert               IN boolean
  ,p_business_group_id    IN number
  ,p_legislation_code     IN varchar2
  ,p_legislation_subgroup IN varchar2 DEFAULT NULL) IS
--
BEGIN
  --
  -- Call the supporting procedure to check startup mode
  -- EDIT_HERE: The following call should be edited if certain types of rows
  -- are not permitted.
  IF (p_insert) THEN
    hr_startup_data_api_support.chk_startup_action
      (p_generic_allowed   => TRUE
      ,p_startup_allowed   => TRUE
      ,p_user_allowed      => TRUE
      ,p_business_group_id => p_business_group_id
      ,p_legislation_code  => p_legislation_code
      ,p_legislation_subgroup => p_legislation_subgroup
      );

Line: 540

   SELECT legislation_code
    FROM  per_business_groups_perf
    WHERE business_group_id =p_business_group_id;

Line: 571

   Select total_unique_columns
   from   pqp_configuration_types
   where  configuration_type =p_rec.pcv_information_category;

Line: 733

      l_temp_str := 'SELECT count(CONFIGURATION_VALUE_ID)
                      FROM  pqp_configuration_values
                      WHERE NVL(business_group_id,'||''''||hr_api.g_number||''''||') =
                            NVL('||''''||p_rec.business_group_id||''''||','||''''||hr_api.g_number||''''||')
                        AND NVL(legislation_code, '||''''||hr_api.g_varchar2||''''||')=
                            NVL('||''''||p_rec.legislation_code||''''||','||''''||hr_api.g_varchar2||''''||')
                        AND configuration_value_id <> NVL( '||''''||p_rec.configuration_value_id||''''||
                             ','||''''||hr_api.g_number||''''||')
                        AND   PCV_INFORMATION_CATEGORY =
                             '|| ''''||p_rec.pcv_information_category ||''''||'
                             '||l_where_clause ||'';

Line: 786

  SELECT multiple_occurences_flag
        ,description
        ,total_unique_columns
    FROM pqp_configuration_types
   WHERE configuration_type = c_config_type
     AND (
          (legislation_code IS NOT NULL AND
           legislation_code = c_legislation_code
          )
          OR
          legislation_code IS NULL
         );

Line: 808

  SELECT 1
    FROM pqp_configuration_values
   WHERE pcv_information_category = c_config_type
     AND configuration_value_id <> NVL(c_config_val_id, hr_api.g_number)
     AND NVL(business_group_id, hr_api.g_number) = NVL(c_business_group_id, hr_api.g_number)
     AND NVL(legislation_code, hr_api.g_varchar2) = NVL(c_legislation_code, hr_api.g_varchar2);

Line: 896

Procedure insert_validate
  (p_effective_date               in date
  ,p_rec                          in pqp_pcv_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 954

End insert_validate;

Line: 959

Procedure update_validate
  (p_effective_date               in date
  ,p_rec                          in pqp_pcv_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 1010

  chk_non_updateable_args
    (p_effective_date              => p_effective_date
      ,p_rec              => p_rec
    );

Line: 1021

End update_validate;

Line: 1026

Procedure delete_validate
  (p_rec                          in pqp_pcv_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 1056

End delete_validate;