APPS.PSP_PERIOD_FREQUENCY_API SQL Statements

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

Line: 61

select distinct period_frequency
from   psp_report_period_frequency_v
where  period_frequency =  p_period_frequency;

Line: 197

procedure Update_Period_Frequency
  (p_validate                       in     BOOLEAN default false
  ,p_start_date                     in     date
  ,p_unit_of_measure                in     varchar2
  ,p_period_duration                in     number
  ,p_report_type                    in     varchar2 default null
  ,p_language_code                 in      varchar2 default hr_api.userenv_lang
  ,p_period_frequency               in     varchar2
  ,p_period_frequency_id            in     number
  ,p_object_version_number          in out nocopy number
  ,p_api_warning                    out nocopy varchar2
  ) is
l_proc                   varchar2(150) := g_package||'Update_Period_Frequency';

Line: 218

 savepoint Update_Period_Frequency ;

Line: 225

    hr_utility.set_location('Before Calling User Hook Update_Period_Frequency_b',20);

Line: 226

    PSP_Period_frequency_BK2.Update_Period_Frequency_b
    ( p_start_date                =>   p_start_date
     ,p_unit_of_measure           =>   p_unit_of_measure
     ,p_period_duration           =>   p_period_duration
     ,p_report_type               =>   p_report_type
     ,p_period_frequency          =>   p_period_frequency
     ,p_period_frequency_id       =>   p_period_frequency_id
     ,p_object_version_number     =>   l_object_version_number
   );

Line: 235

    hr_utility.set_location('After Calling User Hook Update_Period_Frequency_b',20);

Line: 238

    hr_utility.set_location('Exception in User Hook Update_Period_Frequency_b',25);

Line: 240

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

Line: 269

  hr_utility.set_location(' Before Calling User Hook : Update_Period_Frequency_a',20);

Line: 270

  PSP_Period_Frequency_Bk2.Update_Period_Frequency_a
  (p_start_date                    =>    p_start_date
  ,p_unit_of_measure               =>    p_unit_of_measure
  ,p_period_duration               =>    p_period_duration
  ,p_report_type                   =>    p_report_type
  ,p_period_frequency              =>    p_period_frequency
  ,p_period_frequency_id           =>    p_period_frequency_id
  ,p_object_version_number         =>    l_object_version_number
  ,p_api_warning                   =>    l_api_warning
  );

Line: 280

  hr_utility.set_location(' After Calling User Hook :Update_Period_Frequency_a',20);

Line: 283

      hr_utility.set_location('Exception in User Hook :Update_Period_Frequency_a',25);

Line: 285

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

Line: 307

    Rollback To Update_Period_Frequency;

Line: 319

    Rollback to Update_Period_Frequency;

Line: 322

End  Update_Period_Frequency ;

Line: 327

procedure Delete_Period_Frequency
  (p_validate                       in     BOOLEAN default false
  ,p_period_frequency_id            in     number
  ,p_object_version_number          in out nocopy number
  ,p_api_warning                       out nocopy varchar2
  ) is
  l_proc                         varchar2(150) := g_package||'Delete_Period_Frequency';

Line: 340

    savepoint Delete_Period_Frequency;

Line: 347

    hr_utility.set_location('Before Calling User Hook Delete_Period_Frequency_b',20);

Line: 348

    PSP_Period_frequency_BK3.Delete_Period_Frequency_b
       ( p_period_frequency_id           => p_period_frequency_id
        ,p_object_version_number         => l_object_version_number
       );

Line: 352

    hr_utility.set_location('After Calling User Hook Delete_Period_Frequency_b',20);

Line: 355

      hr_utility.set_location('Exception in User Hook Delete_Period_Frequency_b',25);

Line: 357

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

Line: 377

    hr_utility.set_location('Before Calling User Hook Delete_Period_Frequency_a',20);

Line: 378

    PSP_Period_frequency_BK3.Delete_Period_Frequency_a
      (p_period_frequency_id     => p_period_frequency_id
       ,p_object_version_number   => l_object_version_number
       ,p_api_warning             => l_api_warning
      );

Line: 383

      hr_utility.set_location('After Calling User Hook Delete_Period_Frequency_a',20);

Line: 386

      hr_utility.set_location('Exception in User Hook Delete_Period_Frequency_a',25);

Line: 388

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

Line: 412

    Rollback To Delete_Period_Frequency;

Line: 423

    Rollback to Delete_Period_Frequency;

Line: 426

End Delete_Period_Frequency;