APPS.PAY_INPUT_VALUE_API SQL Statements

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

Line: 118

  select business_group_id,legislation_code,legislation_subgroup
  from pay_element_types_f
  where element_type_id = p_element_type_id;

Line: 322

procedure UPDATE_INPUT_VALUE
  ( P_VALIDATE                     IN     boolean  Default false
   ,P_EFFECTIVE_DATE               IN     date
   ,P_DATETRACK_MODE	           IN     varchar2
   ,P_INPUT_VALUE_ID		   IN     number
   ,P_OBJECT_VERSION_NUMBER	   IN OUT NOCOPY number
   ,P_NAME                         IN     varchar2 Default hr_api.g_varchar2
   ,P_UOM                          IN     varchar2 Default hr_api.g_varchar2
   ,P_LOOKUP_TYPE                  IN     varchar2 Default hr_api.g_varchar2
   ,P_FORMULA_ID                   IN     number   Default hr_api.g_number
   ,P_VALUE_SET_ID                 IN     number   Default hr_api.g_number
   ,P_DISPLAY_SEQUENCE             IN     number   Default hr_api.g_number
   ,P_GENERATE_DB_ITEMS_FLAG       IN     varchar2 Default hr_api.g_varchar2
   ,P_HOT_DEFAULT_FLAG             IN     varchar2 Default hr_api.g_varchar2
   ,P_MANDATORY_FLAG               IN     varchar2 Default hr_api.g_varchar2
   ,P_DEFAULT_VALUE                IN     varchar2 Default hr_api.g_varchar2
   ,P_MAX_VALUE                    IN     varchar2 Default hr_api.g_varchar2
   ,P_MIN_VALUE                    IN     varchar2 Default hr_api.g_varchar2
   ,P_WARNING_OR_ERROR             IN     varchar2 Default hr_api.g_varchar2
   ,P_EFFECTIVE_START_DATE	   OUT NOCOPY    date
   ,P_EFFECTIVE_END_DATE	   OUT NOCOPY    date
   ,P_DEFAULT_VAL_WARNING          OUT NOCOPY   boolean
   ,P_MIN_MAX_WARNING              OUT NOCOPY   boolean
   ,P_LINK_INP_VAL_WARNING         OUT NOCOPY   boolean
   ,P_PAY_BASIS_WARNING            OUT NOCOPY 	  boolean
   ,P_FORMULA_WARNING              OUT NOCOPY    boolean
   ,P_ASSIGNMENT_ID_WARNING        OUT NOCOPY    boolean
   ,P_FORMULA_MESSAGE              OUT NOCOPY    varchar2
   ) is
  --
  -- Declare cursors and local variables
  --
  cursor csr_derived_values
  is
  select business_group_id,legislation_code,element_type_id,legislation_subgroup
  from pay_input_values_f
  where input_value_id = p_input_value_id;

Line: 366

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

Line: 372

  savepoint UPDATE_INPUT_VALUE;

Line: 377

    PAY_INPUT_VALUE_bk2.UPDATE_INPUT_VALUE_b
      (P_VALIDATE
   ,trunc(P_EFFECTIVE_DATE)
   ,P_DATETRACK_MODE
   ,P_INPUT_VALUE_ID
   ,P_OBJECT_VERSION_NUMBER
   ,P_NAME
   ,P_UOM
   ,P_LOOKUP_TYPE
   ,P_FORMULA_ID
   ,P_VALUE_SET_ID
   ,P_DISPLAY_SEQUENCE
   ,P_GENERATE_DB_ITEMS_FLAG
   ,P_HOT_DEFAULT_FLAG
   ,P_MANDATORY_FLAG
   ,P_DEFAULT_VALUE
   ,P_MAX_VALUE
   ,P_MIN_VALUE
   ,P_WARNING_OR_ERROR
      );

Line: 400

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

Line: 459

    PAY_INPUT_VALUE_bk2.UPDATE_INPUT_VALUE_a
      (P_VALIDATE
   ,trunc(P_EFFECTIVE_DATE)
   ,P_DATETRACK_MODE
   ,P_INPUT_VALUE_ID
   ,P_OBJECT_VERSION_NUMBER
   ,P_NAME
   ,P_UOM
   ,P_LOOKUP_TYPE
   ,P_FORMULA_ID
   ,P_VALUE_SET_ID
   ,P_DISPLAY_SEQUENCE
   ,P_GENERATE_DB_ITEMS_FLAG
   ,P_HOT_DEFAULT_FLAG
   ,P_MANDATORY_FLAG
   ,P_DEFAULT_VALUE
   ,P_MAX_VALUE
   ,P_MIN_VALUE
   ,P_WARNING_OR_ERROR
   ,P_EFFECTIVE_START_DATE
   ,P_EFFECTIVE_END_DATE
   ,P_DEFAULT_VAL_WARNING
   ,P_MIN_MAX_WARNING
   ,P_LINK_INP_VAL_WARNING
   ,P_PAY_BASIS_WARNING
   ,P_FORMULA_WARNING
   ,P_ASSIGNMENT_ID_WARNING
   ,P_FORMULA_MESSAGE
      );

Line: 491

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

Line: 521

    rollback to UPDATE_INPUT_VALUE;

Line: 533

    rollback to UPDATE_INPUT_VALUE;

Line: 536

end UPDATE_INPUT_VALUE;

Line: 544

procedure DELETE_INPUT_VALUE
  (  P_VALIDATE                        IN     boolean   default false
    ,P_EFFECTIVE_DATE                  IN     date
    ,P_DATETRACK_DELETE_MODE           IN     varchar2
    ,P_INPUT_VALUE_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
    ,P_BALANCE_FEEDS_WARNING           OUT NOCOPY    boolean
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 564

  savepoint DELETE_INPUT_VALUE;

Line: 569

    PAY_INPUT_VALUE_bk3.DELETE_INPUT_VALUE_b
      (P_VALIDATE
    ,trunc(P_EFFECTIVE_DATE)
    ,P_DATETRACK_DELETE_MODE
    ,P_INPUT_VALUE_ID
    ,P_OBJECT_VERSION_NUMBER
      );

Line: 579

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

Line: 587

  if P_DATETRACK_DELETE_MODE = 'DELETE' and
     not (hr_startup_data_api_support.g_startup_mode IN ('STARTUP')) then
    hr_utility.set_message(801,'HR_7098_INPVAL_NO_CHANGES');

Line: 602

  ,p_datetrack_mode => p_datetrack_delete_mode
  ,p_input_value_id => p_input_value_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
  ,p_balance_feeds_warning => p_balance_feeds_warning);

Line: 613

    PAY_INPUT_VALUE_bk3.DELETE_INPUT_VALUE_a
      ( P_VALIDATE
	,trunc(P_EFFECTIVE_DATE)
	,P_DATETRACK_DELETE_MODE
	,P_INPUT_VALUE_ID
	,P_OBJECT_VERSION_NUMBER
	,P_EFFECTIVE_START_DATE
	,P_EFFECTIVE_END_DATE
	,p_balance_feeds_warning
      );

Line: 626

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

Line: 648

    rollback to DELETE_INPUT_VALUE;

Line: 662

    rollback to DELETE_INPUT_VALUE;

Line: 665

end DELETE_INPUT_VALUE;