APPS.HR_TRN_INS SQL Statements

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

Line: 77

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

Line: 89

  insert into hr_api_transactions
  ( transaction_id,
    creator_person_id,
    transaction_privilege,
    product_code,
    url,
    status,
    section_display_name,
    function_id,
    transaction_ref_table,
    transaction_ref_id,
    transaction_type,
    assignment_id,
    api_addtnl_info,
    selected_person_id,
    item_type,
    item_key,
    transaction_effective_date,
    process_name,
    plan_id ,
    rptg_grp_id,
    effective_date_option,
    creator_role,
    last_update_role,
    parent_Transaction_id,
    relaunch_function,
    transaction_group,
    transaction_identifier,
    transaction_document
  )
  Values
  ( p_rec.transaction_id,
    p_rec.creator_person_id,
    p_rec.transaction_privilege,
    p_rec.product_code,
    p_rec.url,
    p_rec.status,
    p_rec.section_display_name,
    p_rec.function_id,
    p_rec.transaction_ref_table,
    p_rec.transaction_ref_id,
    p_rec.transaction_type,
    p_rec.assignment_id,
    p_rec.api_addtnl_info,
    p_rec.selected_person_id,
    p_rec.item_type,
    p_rec.item_key,
    p_rec.transaction_effective_date,
    p_rec.process_name,
    p_rec.plan_id ,
    p_rec.rptg_grp_id,
    p_rec.effective_date_option,
    p_rec.creator_role,
    p_rec.last_update_role,
    p_rec.parent_Transaction_id,
    p_rec.relaunch_function,
    p_rec.transaction_group,
    p_rec.transaction_identifier,
    p_rec.transaction_document
  );

Line: 174

End insert_dml;

Line: 213

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

Line: 218

  Cursor C_Sel1 is select hr_api_transactions_s.nextval from sys.dual;

Line: 221

         select null
                from hr_api_transactions
                where transaction_id = hr_trn_ins.g_transaction_id_i;

Line: 265

End pre_insert;

Line: 299

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

Line: 307

End post_insert;

Line: 334

  hr_trn_bus.insert_validate(p_rec);

Line: 338

  pre_insert(p_rec);

Line: 342

  insert_dml(p_rec);

Line: 346

  post_insert(p_rec);

Line: 419

    p_selected_person_id => null,
    p_item_type => null,
    p_item_key => null,
    p_transaction_effective_date => null,
    p_process_name => null,
    p_plan_id => null,
    p_rptg_grp_id => null,
    p_effective_date_option => null,
    p_validate => p_validate,
    p_relaunch_function  => null,
    p_transaction_group    => null,
    p_transaction_identifier => null,
    p_transaction_document => null

  );

Line: 456

  p_selected_person_id           in number default null,
  p_item_type                    in varchar2 default null,
  p_item_key                     in varchar2 default null,
  p_transaction_effective_date   in date default null,
  p_process_name                 in varchar2 default null,
  p_plan_id                      in number default null,
  p_rptg_grp_id                  in number default null,
  p_effective_date_option        in varchar2 default null,
  p_validate                     in boolean  default false,
  p_creator_role                 in varchar2 default null,
  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_group            in varchar2 default null,
  p_transaction_identifier       in varchar2 default null,
  p_transaction_document         in CLOB     default null
  ) is
--
-- p_plan_id, p_rptg_grp_id, p_effective_date_option added by sanej
--
  l_rec   hr_trn_shd.g_rec_type;

Line: 501

  p_selected_person_id,
  p_item_type,
  p_item_key,
  p_transaction_effective_date,
  p_process_name,
  p_plan_id,
  p_rptg_grp_id,
  p_effective_date_option,
  p_creator_role,
  p_last_update_role,
  p_parent_transaction_id,
  p_relaunch_function,
  p_transaction_group,
  p_transaction_identifier,
  p_transaction_document
  );