APPS.PQH_TSH_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_tsh_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 92

  insert into pqh_ss_trans_state_history
      (transaction_history_id
      ,approval_history_id
      ,creator_person_id
      ,creator_role
      ,status
      ,transaction_state
      ,effective_date
      ,effective_date_option
      ,last_update_role
      ,parent_transaction_id
      ,relaunch_function
      ,transaction_document
      )
  Values
    (p_rec.transaction_history_id
    ,p_rec.approval_history_id
    ,p_rec.creator_person_id
    ,p_rec.creator_role
    ,p_rec.status
    ,p_rec.transaction_state
    ,p_rec.effective_date
    ,p_rec.effective_date_option
    ,p_rec.last_update_role
    ,p_rec.parent_transaction_id
    ,p_rec.relaunch_function
    ,p_rec.transaction_document
    );

Line: 143

End insert_dml;

Line: 182

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

Line: 189

    Select null
    from pqh_ss_trans_state_history
    where transaction_history_id = pqh_tsh_ins.g_transaction_history_id_i
    and approval_history_id = pqh_tsh_ins.g_approval_history_id_i;

Line: 194

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

Line: 229

End pre_insert;

Line: 263

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

Line: 285

End post_insert;

Line: 302

  pqh_tsh_bus.insert_validate
     (p_rec
     );

Line: 312

  pqh_tsh_ins.pre_insert(p_rec);

Line: 316

  pqh_tsh_ins.insert_dml(p_rec);

Line: 320

  pqh_tsh_ins.post_insert
     (p_rec
     );

Line: 340

  ,p_last_update_role               in  varchar2 default null
  ,p_parent_transaction_id          in  number   default null
  ,p_relaunch_function              in  varchar2 default null
  ,p_transaction_document           in  CLOB     default null
  ,p_transaction_history_id         OUT NOCOPY number
  ,p_approval_history_id            OUT NOCOPY number
  ) is
--
  l_rec   pqh_tsh_shd.g_rec_type;

Line: 367

    ,p_last_update_role
    ,p_parent_transaction_id
    ,p_relaunch_function
    ,p_transaction_document
    );