APPS.PQH_TAH_INS SQL Statements

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

Line: 78

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

Line: 92

  insert into pqh_ss_approval_history
      (approval_history_id
      ,transaction_history_id
      ,transaction_effective_date
      ,action
      ,user_name
      ,transaction_item_type
      ,transaction_item_key
      ,effective_date_option
      ,orig_system
      ,orig_system_id
      ,notification_id
      ,user_comment
      )
  Values
    (p_rec.approval_history_id
    ,p_rec.transaction_history_id
    ,p_rec.transaction_effective_date
    ,p_rec.action
    ,p_rec.user_name
    ,p_rec.transaction_item_type
    ,p_rec.transaction_item_key
    ,p_rec.effective_date_option
    ,p_rec.orig_system
    ,p_rec.orig_system_id
    ,p_rec.notification_id
    ,p_rec.user_comment
    );

Line: 143

End insert_dml;

Line: 182

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

Line: 189

    Select null
      from pqh_ss_approval_history
     where approval_history_id = pqh_tah_ins.g_approval_history_id_i
     AND transaction_history_id = pqh_tah_ins.g_transaction_history_id_i;

Line: 194

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

Line: 228

End pre_insert;

Line: 262

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

Line: 285

End post_insert;

Line: 301

  pqh_tah_bus.insert_validate
     (p_rec
     );

Line: 310

  pqh_tah_ins.pre_insert(p_rec);

Line: 314

  pqh_tah_ins.insert_dml(p_rec);

Line: 318

  pqh_tah_ins.post_insert
     (p_rec
     );