APPS.PER_RI_WORKBENCH_PKG SQL Statements

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

Line: 16

   Select object_version_number ovn
   From per_ri_workbench_items_vl
   Where workbench_item_code = p_workbench_item_code ;

Line: 21

   Select menu_id
   From fnd_menus
   Where menu_name = p_menu_name;

Line: 52

        PER_RI_WORKBENCH_ITEM_API.UPDATE_WORKBENCH_ITEM(
              P_VALIDATE                      => FALSE
             ,P_WORKBENCH_ITEM_CODE           => p_workbench_item_code
             ,P_WORKBENCH_ITEM_NAME           => p_workbench_item_name
             ,P_WORKBENCH_ITEM_DESCRIPTION    => p_workbench_item_description
             ,P_MENU_ID                       => l_menu_id
             ,P_WORKBENCH_ITEM_SEQUENCE       => p_workbench_item_sequence
             ,P_WORKBENCH_PARENT_ITEM_CODE    => p_workbench_parent_item_code
             ,P_WORKBENCH_ITEM_TYPE           => p_workbench_item_type
             ,P_EFFECTIVE_DATE                => p_effective_date
             ,P_OBJECT_VERSION_NUMBER         => l_ovn
                                                 );

Line: 98

   Select object_version_number ovn
   From per_ri_setup_tasks
   Where setup_task_code = p_setup_task_code ;

Line: 130

      per_ri_setup_task_api.update_setup_task(
       p_validate                      => FALSE
      ,p_setup_task_code               => p_setup_task_code
      ,p_workbench_item_code           => p_workbench_item_code
      ,p_setup_task_name               => p_setup_task_name
      ,p_setup_task_description        => p_setup_task_description
      ,p_setup_task_sequence           => p_setup_task_sequence
      ,p_setup_task_type               => p_setup_task_type
      ,p_setup_task_action             => p_setup_task_action
      ,p_effective_date                => p_effective_date
      ,p_object_version_number         => l_ovn
        );

Line: 183

   Select object_version_number ovn
   From per_ri_setup_sub_tasks
   Where setup_sub_task_code = p_setup_sub_task_code ;

Line: 216

      per_ri_setup_sub_task_api.update_setup_sub_task(
       p_setup_sub_task_code            => p_setup_sub_task_code
       ,p_setup_sub_task_name           => p_setup_sub_task_name
       ,p_setup_sub_task_description    => p_setup_sub_task_description
       ,p_setup_task_code               => p_setup_task_code
       ,p_setup_sub_task_sequence       => p_setup_sub_task_sequence
       ,p_setup_sub_task_type           => p_setup_sub_task_type
       ,p_setup_sub_task_dp_link        => p_setup_sub_task_dp_link
       ,p_setup_sub_task_action         => p_setup_sub_task_action
       ,p_legislation_code              => p_legislation_code
       ,p_effective_date                => p_effective_date
       ,p_object_version_number         => l_ovn
                                      ) ;

Line: 265

   Select object_version_number ovn
   From per_ri_view_reports
   Where workbench_view_report_code = p_workbench_view_report_code ;

Line: 294

     per_ri_view_report_api.update_view_report(p_workbench_view_report_code      => p_workbench_view_report_code
                 ,p_workbench_view_report_name       =>  p_workbench_view_report_name
                 ,p_wb_view_report_description       =>  p_wb_view_report_description
                 ,p_workbench_item_code              => p_workbench_item_code
                 ,p_workbench_view_report_type       =>  p_workbench_view_report_type
                 ,p_workbench_view_report_action     =>  p_workbench_view_report_action
                 ,p_workbench_view_country           =>  p_workbench_view_country
                 ,p_wb_view_report_instruction       =>  p_wb_view_report_instruction
                 ,p_language_code                    => userenv('LANG')
                 ,p_effective_date                   => p_effective_date
                 ,p_object_version_number            => l_ovn
        		 ,p_primary_industry		         => p_primary_industry
                 ,p_enabled_flag                     => p_enabled_flag);

Line: 337

   Select 1
   From per_ri_dependencies
   where workbench_item_code = p_workbench_item_code
     and dependent_item_code = p_dependent_item_code ;

Line: 349

      Insert Into  per_ri_dependencies(workbench_item_code,dependent_item_code,dependency_item_sequence)
                                values(p_workbench_item_code,p_dependent_item_code,p_dependency_item_sequence) ;

Line: 352

      update per_ri_dependencies
      set dependency_item_sequence = p_dependency_item_sequence
      where workbench_item_code = p_workbench_item_code
      and dependent_item_code = p_dependent_item_code ;

Line: 367

   Select pjg.internal_name , pjg.job_group_id
     From per_job_groups pjg
    Where not exists
      (Select 1 From hr_pump_batch_line_user_keys uk where uk.user_key_value =  'RI~JOB_GROUP_NAME~'||pjg.internal_name)
      and (pjg.business_group_id Is Null or pjg.business_group_id =  p_business_group_id );

Line: 374

   Select pj.name, pj.job_id
     From per_jobs pj
    where not exists
      (Select 1 From hr_pump_batch_line_user_keys uk where uk.user_key_value =  'RI~BENCHMARK_JOB_NAME~'||pj.name)
      and pj.business_group_id = p_business_group_id
      and pj.benchmark_job_flag='Y';

Line: 412

   update bne_interface_cols_b
      set oa_flex_num = (select job_structure FROM per_business_groups WHERE  business_group_id = p_business_group_id )
    where interface_code like 'PER_RI_JOB_INTF' and val_type = 'KEYFLEX' and application_id = 800;

Line: 416

    update bne_interface_cols_b
      set oa_flex_num = (select position_structure FROM per_business_groups  WHERE business_group_id = p_business_group_id )
    where interface_code like 'PER_RI_POSITION_INTF' and val_type =  'KEYFLEX' and application_id = 800;

Line: 420

     update bne_interface_cols_b
      set oa_flex_num = (select grade_structure FROM per_business_groups WHERE  business_group_id = p_business_group_id )
    where interface_code like 'PER_RI_GRADE_INTF' and val_type = 'KEYFLEX' and application_id = 800;

Line: 426

Procedure crp_insert_request
		  (p_setup_task_code In varchar2,
		   p_context_code In varchar2,
		   p_request_id In varchar2,
                   p_bg_id      In number)

is

begin

insert into
PER_RI_REQUESTS(SETUP_TASK_CODE,REQUEST_ID,CONTEXT_CODE,BUSINESS_GROUP_ID)
values (p_setup_task_code,to_number(p_request_id),p_context_code,p_bg_id);

Line: 441

end crp_insert_request;

Line: 450

  Select descriptive_flex_context_code
    From fnd_descr_flex_contexts
   Where descriptive_flexfield_name = p_flexfield_name
     and (descriptive_flex_context_code = p_legislation_code or  descriptive_flex_context_code = p_legislation_code || '_GLB')
     and enabled_flag = 'Y'
     and application_id = p_app_id ;