APPS.BEN_PROCESS_USER_SS_API SQL Statements

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

Line: 95

     select txn.name
           ,txn.varchar2_value
           ,txn.number_value
           ,txn.date_value
     from  hr_api_transaction_values txn
     where txn.transaction_step_id = p_transaction_step_id
     and   (txn.varchar2_value is not null or
            txn.number_value is not null or
            txn.date_value is not null);

Line: 177

  select fsg.security_group_id
  from   fnd_security_groups fsg
  where  fsg.security_group_id = p_sec_group_id;

Line: 182

  select psp.security_profile_id
        ,psp.business_group_id
  from   per_security_profiles psp
  where  psp.security_profile_id = p_sec_profile_id;

Line: 285

  select   frf.action_id, frf.rule_type
  from     fnd_resp_functions frf
  where    frf.application_id = p_app_id
  and      frf.responsibility_id = p_resp_id;

Line: 293

  select   fff.function_name
  from     fnd_form_functions fff
  where    fff.function_id = p_func_id;

Line: 299

  select   fm.menu_name
  from     fnd_menus fm
  where    fm.menu_id = p_menu_id;

Line: 308

  select   fr.responsibility_key
  FROM     fnd_responsibility fr
  where    fr.application_id = p_app_id
  and      fr.responsibility_id = p_resp_id;

Line: 437

  select  fsg.security_group_id
  from    fnd_security_groups fsg
  where   fsg.security_group_key = decode(p_business_group_id,0, 'STANDARD',to_char(p_business_group_id));

Line: 451

 update_user_details(i.e userid/password getting created from
 user page on pressing next  after typing in userid/password),
 the responsibility that will get attached to this new user is
 the value of the profile 'BEN_NEW_USER_RESP_PROFILE'.

 But if it's decided to generate user/pswd instead of typing it
 in user page, by calling update_user_details(passing all
 parameters as null) on pressing next
 button,putting logic in the hooks then customer can pass respo-
 nsibility_id and responsibility_application_id via global variables
 defined in ben_process_user_utility package header.The value of
 the global variables will be copied to the parameter for fnd_user_pkg.
 createuserid and fnd_user_resp_groups_api and fnd_resp_functions api.

 Also we have taken care of the fact that username,password,
 start_date,end_date,last_logon_date,password_date,password_
 accesses_left,password_lifespan_accesses,password_lifespan_days,
 email_address,fax,description,employee_id can be passed to
 us from hooks via global variables in ben_process_user_utility
 package header.*/

 /************************************************************/

  -- Clear the global record variables first.  Otherwise,these variables
  -- may retain values from previous executions.
  --

    ben_process_user_utility.g_fnd_user_record := g_void_fnd_user_rec;

Line: 605

	     -- NOTE: Only insert a row into fnd_user_resp_groups
	     --       when the profile option 'ENABLE_SECURITY_GROUPS'
	     --       is 'N'.
             --
          fnd_user_resp_groups_api.insert_assignment(
           user_id                       => l_user_id
          ,responsibility_id             => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
          ,responsibility_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)
          ,security_group_id             => 0
          ,start_date                    => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
          ,end_date                      => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
          ,description                   => null
          );

Line: 649

          fnd_user_resp_groups_api.insert_assignment(
           user_id                       => l_user_id
          ,responsibility_id             => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
          ,responsibility_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)
          ,security_group_id             => l_sec_group_id
          ,start_date                    => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
          ,end_date                      => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
          ,description                   => null
          );

Line: 790

procedure update_user_details
  (p_item_type                    in varchar2
  ,p_item_key                     in varchar2
  ,p_actid                        in number
  ,p_login_person_id              in number
  ,p_process_section_name         in varchar2
  ,p_review_page_region_code      in varchar2
  ,p_user_name                    in varchar2
  ,p_owner                        in varchar2
  ,p_unencrypted_password         in varchar2
  ,p_session_number               in number
  ,p_start_date                   in date
  ,p_end_date                     in date
  ,p_last_logon_date              in date
  ,p_description                  in varchar2
  ,p_password_date                in date
  ,p_password_accesses_left       in number
  ,p_password_lifespan_accesses   in number
  ,p_password_lifespan_days       in number
  ,p_employee_id                  in number
  ,p_email_address                in varchar2
  ,p_fax                          in varchar2
  ,p_customer_id                  in number
  ,p_supplier_id                  in number
  ,p_business_group_id            in number
  ) is
 --
  l_transaction_table             hr_transaction_ss.transaction_table;

Line: 1118

end update_user_details;