APPS.HR_NEW_USER_REG_SS SQL Statements

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

Line: 9

g_update_object_version varchar2(30) := 'update_object_version';

Line: 45

  cursor csr_person is select person_id from per_all_people_f where person_id = PersonId;

Line: 48

  select trs.transaction_step_id
    from   hr_api_transaction_steps trs
    where  trs.transaction_id = hr_transaction_ss.get_transaction_id
                        (WfItemType  ,WfItemKey )
    and    trs.api_name ='HR_PROCESS_PERSON_SS.PROCESS_API';

Line: 82

/* Replaced commit_transaction with process_selected_transaction, commit transaction will
   call all the steps for a given item key. However we need only person and address apis
   are
*/

--ignore the emp number generation for newhire flow
hr_new_user_reg_ss.g_ignore_emp_generation := 'YES';

Line: 110

process_selected_transaction
(p_item_type => WfItemType,
 p_item_key => WfItemKey);

Line: 135

procedure process_selected_transaction
  (p_item_type           in varchar2
  ,p_item_key            in varchar2
  ,p_ignore_warnings     in varchar2 default 'Y'
  ,p_validate            in boolean default false
  ,p_update_object_version in varchar2 default 'N'
  ,p_effective_date      in varchar2 default null
  ,p_api_name            in varchar2 default null) is
  -- --------------------------------------------------------------------------
  -- declare local variables
  -- --------------------------------------------------------------------------
  l_transaction_id      hr_api_transactions.transaction_id%type;

Line: 157

    select trs.transaction_step_id
          ,trs.api_name
          ,trs.item_type
          ,trs.item_key
          ,trs.activity_id
          ,trs.creator_person_id
    from   hr_api_transaction_steps trs
    where  trs.transaction_id = l_transaction_id
    and    trs.api_name in ('HR_PROCESS_PERSON_SS.PROCESS_API',
                            'HR_PROCESS_ADDRESS_SS.PROCESS_API',
                            'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API',
                            'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API')
    order by trs.processing_order,trs.transaction_step_id;

Line: 173

    select trs.transaction_step_id
          ,trs.api_name
          ,trs.item_type
          ,trs.item_key
          ,trs.activity_id
          ,trs.creator_person_id
    from   hr_api_transaction_steps trs
    where  trs.transaction_id = l_transaction_id
    and    trs.api_name = p_api_name
    order by trs.processing_order;

Line: 272

      if p_update_object_version = 'Y' then
        -- update object version for each step
        l_obj_api_name := substr(i.api_name,1, instr(i.api_name,'.'));

Line: 275

        l_obj_api_name := l_obj_api_name || g_update_object_version;

Line: 384

end process_selected_transaction;