APPS.HXC_HAN_INS SQL Statements

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

Line: 83

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

Line: 99

  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: 150

End insert_dml;

Line: 189

Procedure pre_insert
  (p_rec  in out nocopy hxc_han_shd.g_rec_type
  ) is
--
  Cursor C_Sel1 is select hxc_app_comp_notifications_s.nextval from sys.dual;

Line: 196

    Select null
      from hxc_app_comp_notifications
     where comp_notification_id =
             hxc_han_ins.g_comp_notification_id_i
        or object_version_number =
             hxc_han_ins.g_object_version_number_i;

Line: 203

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

Line: 252

End pre_insert;

Line: 286

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

Line: 298

    hxc_han_rki.after_insert
      (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
      );

Line: 326

End post_insert;

Line: 344

  hxc_han_bus.insert_validate
     (p_rec
     );

Line: 353

  hxc_han_ins.pre_insert(p_rec);

Line: 357

  hxc_han_ins.insert_dml(p_rec);

Line: 361

  hxc_han_ins.post_insert
     (p_rec
     );