APPS.HR_WIP_TXNS SQL Statements

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

Line: 11

  g_insert_dml_mode             VARCHAR2(6)  := 'INSERT';

Line: 12

  g_update_dml_mode             VARCHAR2(6)  := 'UPDATE';

Line: 13

  g_delete_dml_mode             VARCHAR2(6)  := 'DELETE';

Line: 46

    select end_date
    from   wf_items
    where  item_type = p_item_type
    and    item_key  = p_item_key;

Line: 84

    select end_date
    from   fnd_user
    where  user_id = p_creator_user_id;

Line: 125

    select null
    from   fnd_form_functions
    where  function_id = p_function_id;

Line: 228

       p_new_dml_mode = g_insert_dml_mode OR
       p_new_dml_mode = g_update_dml_mode OR
       p_new_dml_mode = g_delete_dml_mode
    then
      -- dml_mode was specified
      RETURN(p_new_dml_mode);

Line: 283

  insert into hr_wip_transactions(transaction_id
                                 ,creator_user_id
                                 ,item_type
                                 ,item_key
                                 ,function_id
                                 ,state
                                 ,sub_state
                                 ,vo_cache
                                 ,context_display_text
                                 ,dml_mode
                                 )
                           values(hr_wip_transactions_s.nextval
                                 ,p_creator_user_id
                                 ,p_item_type
                                 ,p_item_key
                                 ,p_function_id
                                 ,g_start_state
                                 ,null
                                 ,p_vo_xml
                                 ,p_context_display_text
                                 ,p_dml_mode
                                 )returning transaction_id into l_tran_id;

Line: 329

  update hr_wip_transactions
  set    state = p_state
        ,sub_state = p_sub_state
        ,vo_cache = p_vo_xml
        ,context_display_text = p_context_display_text
        ,dml_mode = p_dml_mode
  where  transaction_id = p_transaction_id;

Line: 506

            select creator_user_id
                   ,transaction_id
                   ,state,dml_mode
                   ,context_display_text
              from hr_wip_transactions
             where item_type = p_item_type
               and item_key  = p_item_key;

Line: 578

            select creator_user_id,
                   state,
                   dml_mode,
                   context_display_text
              from hr_wip_transactions
             where transaction_id = p_transaction_id;

Line: 633

            select vo_cache
              from hr_wip_transactions
             where transaction_id = p_transaction_id
            for update nowait;

Line: 653

  update hr_wip_transactions
  set    vo_cache = l_db_clob
  where  transaction_id = p_transaction_id;

Line: 723

      select creator_user_id,
             transaction_id,
             state,
             dml_mode,
             context_display_text
      from hr_wip_transactions
      where item_type = p_item_type
        and item_key  = p_item_key;

Line: 794

      select creator_user_id,
             state,
             dml_mode,
             context_display_text
        from hr_wip_transactions
       where transaction_id = p_transaction_id;

Line: 885

            select transaction_id,
                   state,
                   vo_cache,
                   dml_mode,
                   context_display_text
              from hr_wip_transactions
             where item_type = p_item_type
               and item_key  = p_item_key;

Line: 941

            select state,
                   vo_cache,
                   dml_mode,
                   context_display_text
              from hr_wip_transactions
             where transaction_id = p_transaction_id;

Line: 979

Procedure delete_transaction
              (p_item_type             IN wf_items.item_type%TYPE
              ,p_item_key              IN wf_items.item_key%TYPE
              )is
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 986

    select transaction_id
      from hr_wip_transactions
     where item_type = p_item_type
       and  item_key = p_item_key;

Line: 1007

  delete from hr_wip_locks
  where transaction_id = l_transaction_id;

Line: 1010

  delete from hr_wip_transactions
  where transaction_id = l_transaction_id;

Line: 1021

end delete_transaction;

Line: 1026

Procedure delete_transaction
             (p_transaction_id        IN hr_wip_transactions.transaction_id%TYPE
             )is
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 1032

    select null
      from hr_wip_transactions
     where transaction_id = p_transaction_id;

Line: 1046

  delete from hr_wip_locks
  where transaction_id = p_transaction_id;

Line: 1049

  delete from hr_wip_transactions
  where transaction_id = p_transaction_id;

Line: 1060

end delete_transaction;

Line: 1066

Procedure update_transaction
     (p_item_type            IN wf_items.item_type%TYPE
     ,p_item_key             IN wf_items.item_key%TYPE
     ,p_state                IN hr_wip_transactions.state%TYPE
     ,p_sub_state            IN hr_wip_transactions.sub_state%TYPE
     ,p_dml_mode             IN hr_wip_transactions.dml_mode%TYPE
                                default hr_api.g_varchar2
     ,p_vo_xml               IN VARCHAR2
     ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
                                default hr_api.g_varchar2
     )is
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 1082

        select transaction_id
               ,dml_mode
               ,context_display_text
          from hr_wip_transactions
         where item_type = p_item_type
           and item_key  = p_item_key;

Line: 1134

end update_transaction;

Line: 1139

Procedure update_transaction
     (p_transaction_id       IN hr_wip_transactions.transaction_id%TYPE
     ,p_state                IN hr_wip_transactions.state%TYPE
     ,p_sub_state            IN hr_wip_transactions.sub_state%TYPE
     ,p_dml_mode             IN hr_wip_transactions.dml_mode%TYPE
                                default hr_api.g_varchar2
     ,p_vo_xml               IN VARCHAR2
     ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
                                default hr_api.g_varchar2
     )is
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 1153

    select dml_mode,
           context_display_text
      from hr_wip_transactions
     where transaction_id = p_transaction_id;

Line: 1193

end update_transaction;