APPS.PQH_FR_GLOBAL_PAYSCALE_API SQL Statements

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

Line: 346

procedure update_indemnity_rate
  (p_validate                      in     boolean  default false
   ,p_effective_date               in     date
   ,p_datetrack_mode               in     varchar2
   ,p_global_index_id              in     number
   ,p_object_version_number        in out nocopy number
   ,p_basic_salary_rate            in     number    default hr_api.g_number
   ,p_housing_indemnity_rate            in     number    default hr_api.g_number
   ,p_currency_code                in     varchar2
   ,p_effective_start_date            out nocopy date
   ,p_effective_end_date              out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 363

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

Line: 382

  savepoint update_indemnity_rate;

Line: 401

       pqh_fr_global_payscale_bk3.update_indemnity_rate_b
          (
	   p_effective_date               => l_effective_date
	   ,p_datetrack_mode              => p_datetrack_mode
	   ,p_global_index_id             => p_global_index_id
	   ,p_object_version_number       => p_object_version_number
	   ,p_basic_salary_rate           => p_basic_salary_rate
	   ,p_housing_indemnity_rate           => p_housing_indemnity_rate
	   ,p_currency_code               => p_currency_code
	   );

Line: 415

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

Line: 439

       pqh_fr_global_payscale_bk3.update_indemnity_rate_a
          (
	   p_effective_date               => l_effective_date
	   ,p_datetrack_mode              => p_datetrack_mode
	   ,p_global_index_id             => p_global_index_id
	   ,p_object_version_number       => p_object_version_number
	   ,p_basic_salary_rate           => p_basic_salary_rate
	   ,p_housing_indemnity_rate           => p_housing_indemnity_rate
	   ,p_currency_code               => p_currency_code
	   ,p_effective_start_date        => l_effective_start_date
	   ,p_effective_end_date          => l_effective_end_date

	   );

Line: 455

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

Line: 482

    rollback to update_indemnity_rate;

Line: 501

    rollback to update_indemnity_rate;

Line: 510

end update_indemnity_rate;

Line: 517

procedure update_global_index
  (p_validate                      in     boolean  default false
   ,p_effective_date               in     date
   ,p_datetrack_mode               in     varchar2
   ,p_global_index_id              in     number
   ,p_object_version_number        in out nocopy number
   ,p_gross_index                  in     number    default hr_api.g_number
   ,p_increased_index              in     number    default hr_api.g_number
   ,p_effective_start_date            out nocopy date
   ,p_effective_end_date              out nocopy date
   ) is

  --
  -- Declare cursors and local variables
  --
    l_in_out_parameter    number;

Line: 534

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

Line: 553

    savepoint update_global_index;

Line: 567

         pqh_fr_global_payscale_bk4.update_global_index_b
            (p_effective_date                 => l_effective_date
	    ,p_gross_index                    => p_gross_index
	    ,p_increased_index                => p_increased_index
	    ,p_datetrack_mode		      => p_datetrack_mode
	    ,p_global_index_id		      => p_global_index_id
	    ,p_object_version_number	      => p_object_version_number
	    ,p_effective_start_date         => p_effective_start_date
	    ,p_effective_end_date           => p_effective_end_date

	    );

Line: 582

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

Line: 608

   pqh_fr_global_payscale_bk4.update_global_index_a
            (p_effective_date                 => l_effective_date
	    ,p_gross_index                    => p_gross_index
	    ,p_increased_index                => p_increased_index
	    ,p_datetrack_mode		      => p_datetrack_mode
	    ,p_global_index_id		      => p_global_index_id
	    ,p_object_version_number	      => p_object_version_number
	    ,p_effective_start_date         => p_effective_start_date
	    ,p_effective_end_date           => p_effective_end_date
	    );

Line: 621

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

Line: 651

    rollback to update_global_index;

Line: 671

    rollback to update_global_index;

Line: 683

end update_global_index;

Line: 689

procedure delete_indemnity_rate
   (p_validate                      in     boolean  default false
   ,p_effective_date                   in     date
   ,p_datetrack_mode                   in     varchar2
   ,p_global_index_id                  in     number
   ,p_object_version_number            in out nocopy number
   ,p_effective_start_date                out nocopy date
   ,p_effective_end_date                  out nocopy date
  )
    is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 704

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

Line: 721

  savepoint delete_indemnity_rate;

Line: 738

       pqh_fr_global_payscale_bk5.delete_indemnity_rate_b
         (p_effective_date                   => l_effective_date
          ,p_datetrack_mode                  => p_datetrack_mode
          ,p_global_index_id                 => p_global_index_id
          ,p_object_version_number           => p_object_version_number
         );

Line: 748

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

Line: 769

       pqh_fr_global_payscale_bk5.delete_indemnity_rate_a
         (p_effective_date                   => l_effective_date
          ,p_datetrack_mode                  => p_datetrack_mode
          ,p_global_index_id                 => p_global_index_id
          ,p_object_version_number           => p_object_version_number
	  ,p_effective_start_date            => p_effective_start_date
	  ,p_effective_end_date              => p_effective_end_date

         );

Line: 781

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

Line: 808

    rollback to delete_indemnity_rate;

Line: 824

    rollback to delete_indemnity_rate;

Line: 831

end delete_indemnity_rate;

Line: 837

procedure delete_global_index
  (p_validate                      in     boolean  default false
   ,p_effective_date                   in     date
   ,p_datetrack_mode                   in     varchar2
   ,p_global_index_id                  in     number
   ,p_object_version_number            in out nocopy number
   ,p_effective_start_date                out nocopy date
   ,p_effective_end_date                  out nocopy date
  )
Is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 852

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

Line: 869

  savepoint delete_global_index;

Line: 886

       pqh_fr_global_payscale_bk6.delete_global_index_b
         (p_effective_date                => l_effective_date
          ,p_datetrack_mode               => p_datetrack_mode
          ,p_global_index_id              => p_global_index_id
          ,p_object_version_number        => p_object_version_number
         );

Line: 895

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

Line: 915

       pqh_fr_global_payscale_bk6.delete_global_index_a
  	  (p_effective_date                => l_effective_date
          ,p_datetrack_mode                => p_datetrack_mode
          ,p_global_index_id               => p_global_index_id
          ,p_object_version_number         => p_object_version_number
	  ,p_effective_start_date          => p_effective_start_date
	  ,p_effective_end_date            => p_effective_end_date
	  );

Line: 926

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

Line: 951

    rollback to delete_global_index;

Line: 967

    rollback to delete_global_index;

Line: 974

end delete_global_index;