APPS.PAY_PEU_SHD SQL Statements

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

Line: 32

  If (p_constraint_name = 'PAY_EVENT_UPDATE_ID_PK') Then
    fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line: 55

  (p_event_update_id                      in     number
  ,p_object_version_number                in     number
  )
  Return Boolean Is
--
  --
  -- Cursor selects the 'current' row from the HR Schema
  --
  Cursor C_Sel1 is
    select
       event_update_id
      ,table_name
      ,column_name
      ,dated_table_id
      ,business_group_id
      ,legislation_code
      ,change_type
      ,event_type
      ,object_version_number
    from	pay_event_updates
    where	event_update_id = p_event_update_id;

Line: 81

  If (p_event_update_id is null and
      p_object_version_number is null
     ) Then
    --
    -- One of the primary key arguments is null therefore we must
    -- set the returning function value to false
    --
    l_fct_ret := false;

Line: 90

    If (p_event_update_id
        = pay_peu_shd.g_old_rec.event_update_id and
        p_object_version_number
        = pay_peu_shd.g_old_rec.object_version_number
       ) Then
      --
      -- The g_old_rec is current therefore we must
      -- set the returning function to true
      --
      l_fct_ret := true;

Line: 131

  (p_event_update_id                      in     number
  ,p_object_version_number                in     number
  ) is
--
-- Cursor selects the 'current' row from the HR Schema
--
  Cursor C_Sel1 is
    select
       event_update_id
      ,table_name
      ,column_name
      ,dated_table_id
      ,business_group_id
      ,legislation_code
      ,change_type
      ,event_type
      ,object_version_number
    from	pay_event_updates
    where	event_update_id = p_event_update_id
    for	update nowait;

Line: 159

    ,p_argument           => 'EVENT_UPDATE_ID'
    ,p_argument_value     => p_event_update_id
    );

Line: 191

    fnd_message.set_token('TABLE_NAME', 'pay_event_updates');

Line: 199

  (p_event_update_id                in number
  ,p_table_name                     in varchar2
  ,p_column_name                    in varchar2
  ,p_dated_table_id                 in number
  ,p_business_group_id              in number
  ,p_legislation_code               in varchar2
  ,p_change_type                    in varchar2
  ,p_event_type                     in varchar2
  ,p_object_version_number          in number
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 217

  l_rec.event_update_id                  := p_event_update_id;