APPS.PAY_TIME_DEFINITION_API SQL Statements

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

Line: 65

    select nvl(definition_type,'P'),
           start_date,
           period_type,
           business_group_id,
           legislation_code,
           number_of_years,
           period_time_definition_id
    from   pay_time_definitions
    where  time_definition_id = p_time_definition_id;

Line: 76

    select min(start_date),
           max(end_date),
           count(time_period_id)
    from   per_time_periods ptp
    where  ptp.time_definition_id = p_time_definition_id;

Line: 83

    select end_date
    from   per_time_periods ptp
    where  ptp.time_definition_id = p_time_definition_id
    and    start_date = l_first_period_start_date;

Line: 131

      select to_date(plr.rule_mode || '/' ||
                     to_char(p_first_period_end_date, 'YYYY'), 'DD/MM/YYYY')
        into  l_leg_start_date
        from  pay_legislation_rules plr
       where plr.rule_type = 'L'
         and   plr.legislation_code = nvl(p_legislation_code,
                                  hr_api.return_legislation_code(p_business_group_id) );

Line: 324

            select NVL(tpt.display_period_type, l_period_type)
            into   l_display_period_type
            from   per_time_period_types_vl tpt
            where  tpt.period_type = l_period_type;

Line: 387

	  insert into per_time_periods
          (time_period_id,
           start_date,
           end_date,
           period_type,
           period_num,
           period_name,
           time_definition_id
          )
          select
            per_time_periods_s.nextval,
            l_period_start_date,
            l_period_end_date,
            l_period_type,
            l_period_number,
            l_period_name,
            p_time_definition_id
          from sys.dual;

Line: 607

procedure update_time_definition
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_time_definition_id            in     number
  ,p_definition_name               in     varchar2  default hr_api.g_varchar2
  ,p_period_type                   in     varchar2  default hr_api.g_varchar2
  ,p_period_unit                   in     varchar2  default hr_api.g_varchar2
  ,p_day_adjustment                in     varchar2  default hr_api.g_varchar2
  ,p_dynamic_code                  in     varchar2  default hr_api.g_varchar2
  ,p_number_of_years               in     number    default hr_api.g_number
  ,p_start_date                    in     date      default hr_api.g_date
  ,p_period_time_definition_id     in     number    default hr_api.g_number
  ,p_creator_id                    in     number    default hr_api.g_number
  ,p_creator_type                  in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date        date;

Line: 627

  l_proc                  varchar2(72) := g_package||'update_time_definition';

Line: 630

  l_delete_periods        boolean;

Line: 635

  select definition_type
  from   pay_time_definitions
  where  time_definition_id = p_time_definition_id;

Line: 644

  savepoint update_time_definition;

Line: 660

    pay_time_definition_bk2.update_time_definition_b
      (p_effective_date                => l_effective_date
      ,p_time_definition_id            => p_time_definition_id
      ,p_definition_name               => p_definition_name
      ,p_period_type                   => p_period_type
      ,p_period_unit                   => p_period_unit
      ,p_day_adjustment                => p_day_adjustment
      ,p_dynamic_code                  => p_dynamic_code
      ,p_number_of_years               => p_number_of_years
      ,p_start_date                    => p_start_date
      ,p_period_time_definition_id     => p_period_time_definition_id
      ,p_creator_id                    => p_creator_id
      ,p_creator_type                  => p_creator_type
      ,p_object_version_number         => l_object_version_number
      );

Line: 678

        (p_module_name => 'update_time_definition'
        ,p_hook_type   => 'BP'
        );

Line: 692

  ,p_delete_periods                => l_delete_periods
  ,p_definition_name               => p_definition_name
  ,p_period_type                   => p_period_type
  ,p_period_unit                   => p_period_unit
  ,p_day_adjustment                => p_day_adjustment
  ,p_dynamic_code                  => p_dynamic_code
  ,p_number_of_years               => p_number_of_years
  ,p_start_date                    => p_start_date
  ,p_period_time_definition_id     => p_period_time_definition_id
  ,p_creator_id                    => p_creator_id
  ,p_creator_type                  => p_creator_type
  );

Line: 705

  if l_delete_periods then

     open  csr_definition_type;

Line: 713

        delete from per_time_periods
        where  time_definition_id = p_time_definition_id;

Line: 732

    pay_time_definition_bk2.update_time_definition_a
      (p_effective_date                => l_effective_date
      ,p_time_definition_id            => p_time_definition_id
      ,p_definition_name               => p_definition_name
      ,p_period_type                   => p_period_type
      ,p_period_unit                   => p_period_unit
      ,p_day_adjustment                => p_day_adjustment
      ,p_dynamic_code                  => p_dynamic_code
      ,p_number_of_years               => p_number_of_years
      ,p_start_date                    => p_start_date
      ,p_period_time_definition_id     => p_period_time_definition_id
      ,p_creator_id                    => p_creator_id
      ,p_creator_type                  => p_creator_type
      ,p_object_version_number         => l_object_version_number
      );

Line: 750

        (p_module_name => 'update_time_definition'
        ,p_hook_type   => 'AP'
        );

Line: 773

    rollback to update_time_definition;

Line: 786

    rollback to update_time_definition;

Line: 795

end update_time_definition;

Line: 801

procedure delete_time_definition
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_time_definition_id            in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 811

  l_proc                varchar2(72) := g_package||'delete_time_definition';

Line: 817

  savepoint delete_time_definition;

Line: 828

    pay_time_definition_bk3.delete_time_definition_b
      (p_effective_date                => l_effective_date
      ,p_time_definition_id            => p_time_definition_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 836

        (p_module_name => 'delete_time_definition'
        ,p_hook_type   => 'BP'
        );

Line: 845

  delete from per_time_periods
  where  time_definition_id = p_time_definition_id;

Line: 848

  delete from pay_time_def_usages
  where  time_definition_id = p_time_definition_id;

Line: 860

    pay_time_definition_bk3.delete_time_definition_a
      (p_effective_date                => l_effective_date
      ,p_time_definition_id            => p_time_definition_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 868

        (p_module_name => 'delete_time_definition'
        ,p_hook_type   => 'AP'
        );

Line: 886

    rollback to delete_time_definition;

Line: 893

    rollback to delete_time_definition;

Line: 897

end delete_time_definition;