APPS.HXC_HAN_UPD SQL Statements

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

Line: 55

Procedure update_dml
  (p_rec in out nocopy hxc_han_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 73

 insert into hxc_app_comp_notifications
       (comp_notification_id
       ,object_version_number
       ,notification_number_retries
       ,notification_timeout_value
       ,notification_action_code
       ,notification_recipient_code
       ,created_by
       ,creation_date
       ,last_updated_by
       ,last_update_date
       ,last_update_login
       )
   Values
     (p_rec.comp_notification_id
     ,p_rec.object_version_number
     ,p_rec.notification_number_retries
     ,p_rec.notification_timeout_value
     ,p_rec.notification_action_code
     ,p_rec.notification_recipient_code
     ,fnd_global.user_id
     ,sysdate
     ,fnd_global.user_id
     ,sysdate
     ,fnd_global.login_id
    );

Line: 125

End update_dml;

Line: 159

Procedure pre_update
  (p_rec in hxc_han_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 173

End pre_update;

Line: 207

Procedure post_update
  (p_rec                          in hxc_han_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 219

    hxc_han_rku.after_update
      (p_comp_notification_id
      => p_rec.comp_notification_id
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_notification_number_retries
      => p_rec.notification_number_retries
      ,p_notification_timeout_value
      => p_rec.notification_timeout_value
      ,p_notification_action_code
      => p_rec.notification_action_code
      ,p_notification_recipient_code
      => p_rec.notification_recipient_code
      ,p_notification_num_retries_o
      => hxc_han_shd.g_old_rec.notification_number_retries
      ,p_notification_timeout_value_o
      => hxc_han_shd.g_old_rec.notification_timeout_value
      ,p_notification_action_code_o
      => hxc_han_shd.g_old_rec.notification_action_code
      ,p_notification_recip_code_o
      => hxc_han_shd.g_old_rec.notification_recipient_code
      );

Line: 255

End post_update;

Line: 360

  hxc_han_bus.update_validate
     (p_rec
     );

Line: 369

  hxc_han_upd.pre_update(p_rec);

Line: 373

  hxc_han_upd.update_dml(p_rec);

Line: 377

  hxc_han_upd.post_update
     (p_rec
     );