APPS.PQH_TXH_INS SQL Statements

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

Line: 75

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

Line: 89

  insert into pqh_ss_transaction_history
      (transaction_history_id
      ,creator_person_id
      ,assignment_id
      ,selected_person_id
      ,item_type
      ,item_key
      ,process_name
      ,approval_item_type
      ,approval_item_key
      ,function_id
      ,rptg_grp_id
      ,plan_id
      ,transaction_group
      ,transaction_identifier
      )
  Values
    (p_rec.transaction_history_id
    ,p_rec.creator_person_id
    ,p_rec.assignment_id
    ,p_rec.selected_person_id
    ,p_rec.item_type
    ,p_rec.item_key
    ,p_rec.process_name
    ,p_rec.approval_item_type
    ,p_rec.approval_item_key
    ,p_rec.function_id
    ,p_rec.rptg_grp_id
    ,p_rec.plan_id
    ,p_rec.transaction_group
    ,p_rec.transaction_identifier
    );

Line: 144

End insert_dml;

Line: 183

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

Line: 190

    Select null
      from pqh_ss_transaction_history
     where transaction_history_id = pqh_txh_ins.g_transaction_history_id_i;

Line: 194

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

Line: 237

End pre_insert;

Line: 271

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

Line: 294

End post_insert;

Line: 310

  pqh_txh_bus.insert_validate
     (p_rec
     );

Line: 319

  pqh_txh_ins.pre_insert(p_rec);

Line: 323

  pqh_txh_ins.insert_dml(p_rec);

Line: 327

  pqh_txh_ins.post_insert
     (p_rec
     );

Line: 343

  ,p_selected_person_id             in     number   default null
  ,p_item_type                      in     varchar2 default null
  ,p_item_key                       in     varchar2 default null
  ,p_process_name                   in     varchar2 default null
  ,p_approval_item_type             in     varchar2 default null
  ,p_approval_item_key              in     varchar2 default null
  ,p_function_id                    in     number   default null
  ,p_rptg_grp_id                    in     number   default null
  ,p_plan_id                        in     number   default null
  ,p_transaction_group              in     varchar2 default null
  ,p_transaction_identifier         in     varchar2 default null
  ,p_transaction_history_id         out nocopy number
  ) is
--
  l_rec   pqh_txh_shd.g_rec_type;

Line: 371

    ,p_selected_person_id
    ,p_item_type
    ,p_item_key
    ,p_process_name
    ,p_approval_item_type
    ,p_approval_item_key
    ,p_function_id
    ,p_rptg_grp_id
    ,p_plan_id
    ,p_transaction_group
    ,p_transaction_identifier
    );