APPS.PQH_RT_MATRIX_NODE_VALUES_API SQL Statements

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

Line: 199

procedure update_rt_matrix_node_value
  (p_validate                     in     boolean  default false
  ,p_effective_date                in     date
  ,p_NODE_VALUE_ID                 in number
  ,p_RATE_MATRIX_NODE_ID           in number
  ,p_SHORT_CODE                    in varchar2
  ,p_CHAR_VALUE1                   in varchar2  default hr_api.g_varchar2
  ,p_CHAR_VALUE2                   in varchar2  default hr_api.g_varchar2
  ,p_CHAR_VALUE3                   in varchar2  default hr_api.g_varchar2
  ,p_CHAR_VALUE4                   in varchar2  default hr_api.g_varchar2
  ,p_NUMBER_VALUE1                 in number  default hr_api.g_number
  ,p_NUMBER_VALUE2                 in number  default hr_api.g_number
  ,p_NUMBER_VALUE3                 in number  default hr_api.g_number
  ,p_NUMBER_VALUE4                 in number  default hr_api.g_number
  ,p_DATE_VALUE1                   in date default hr_api.g_date
  ,p_DATE_VALUE2                   in date default hr_api.g_date
  ,p_DATE_VALUE3                   in date default hr_api.g_date
  ,p_DATE_VALUE4                   in date default hr_api.g_date
  ,p_BUSINESS_GROUP_ID             in number default hr_api.g_number
  ,p_LEGISLATION_CODE              in varchar2  default hr_api.g_varchar2
  ,p_object_version_number           in out nocopy number
  )
 is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number PQH_RT_MATRIX_NODE_VALUES.object_version_number%TYPE;

Line: 227

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

Line: 233

  savepoint update_rt_matrix_node_value;

Line: 248

PQH_RT_MATRIX_NODE_VALUES_BK2.update_rt_matrix_node_value_b
  (p_effective_date               => l_effective_date
  ,p_NODE_VALUE_ID                 =>p_node_value_id
  ,p_RATE_MATRIX_NODE_ID           => p_rate_matrix_node_id
  ,p_SHORT_CODE                    => p_short_code
  ,p_CHAR_VALUE1                   => p_char_value1
  ,p_CHAR_VALUE2                   => p_char_value2
  ,p_CHAR_VALUE3                   => p_char_value3
  ,p_CHAR_VALUE4                   => p_char_value4
  ,p_NUMBER_VALUE1                 => p_number_value1
  ,p_NUMBER_VALUE2                 => p_number_value2
  ,p_NUMBER_VALUE3                 => p_number_value3
  ,p_NUMBER_VALUE4                 => p_number_value4
  ,p_DATE_VALUE1                   => p_date_value1
  ,p_DATE_VALUE2                   => p_date_value2
  ,p_DATE_VALUE3                   => p_date_value3
  ,p_DATE_VALUE4                   => p_date_value4
  ,p_BUSINESS_GROUP_ID             => p_business_group_id
  ,p_LEGISLATION_CODE              => p_legislation_code
  ,p_object_version_number          => l_object_version_number
  );

Line: 273

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

Line: 312

PQH_RT_MATRIX_NODE_VALUES_BK2.update_rt_matrix_node_value_a
  (p_effective_date               => l_effective_date
  ,p_NODE_VALUE_ID                 =>p_node_value_id
  ,p_RATE_MATRIX_NODE_ID           => p_rate_matrix_node_id
  ,p_SHORT_CODE                    => p_short_code
  ,p_CHAR_VALUE1                   => p_char_value1
  ,p_CHAR_VALUE2                   => p_char_value2
  ,p_CHAR_VALUE3                   => p_char_value3
  ,p_CHAR_VALUE4                   => p_char_value4
  ,p_NUMBER_VALUE1                 => p_number_value1
  ,p_NUMBER_VALUE2                 => p_number_value2
  ,p_NUMBER_VALUE3                 => p_number_value3
  ,p_NUMBER_VALUE4                 => p_number_value4
  ,p_DATE_VALUE1                   => p_date_value1
  ,p_DATE_VALUE2                   => p_date_value2
  ,p_DATE_VALUE3                   => p_date_value3
  ,p_DATE_VALUE4                   => p_date_value4
  ,p_BUSINESS_GROUP_ID             => p_business_group_id
  ,p_LEGISLATION_CODE              => p_legislation_code
  ,p_object_version_number          => l_object_version_number
  );

Line: 336

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

Line: 358

    rollback to update_rt_matrix_node_value;

Line: 370

    rollback to update_rt_matrix_node_value;

Line: 378

end update_rt_matrix_node_value;

Line: 384

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

Line: 395

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

Line: 401

  savepoint delete_rt_matrix_node_value;

Line: 415

   PQH_RT_MATRIX_NODE_VALUES_BK3.delete_rt_matrix_node_value_b
  (p_effective_date                => l_effective_date
  ,p_NODE_value_ID  		  => p_node_value_id
  ,p_object_version_number         => p_object_version_number
  );

Line: 424

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

Line: 447

  PQH_RT_MATRIX_NODE_VALUES_BK3.delete_rt_matrix_node_value_a
  (p_effective_date                => l_effective_date
  ,p_NODE_value_ID  		  => p_node_value_id
  ,p_object_version_number         => p_object_version_number
  );

Line: 456

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

Line: 477

    rollback to delete_rt_matrix_node_value;

Line: 488

    rollback to delete_rt_matrix_node_value;

Line: 495

end delete_rt_matrix_node_value;