APPS.BEN_PROCESS_COBRA_PERSON_SS SQL Statements

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

Line: 552

     ,p_program_update_date          =>  l_ptnl_ler.program_update_date          -- in  date      default null
     ,p_effective_date               => l_life_event_eff_date
     ,p_flow_mode                    => l_flow_mode
     ,p_subflow_mode                 => l_subflow_mode
     ,p_life_event_name              => l_life_event_name
     );

Line: 582

  ,p_program_update_date          =>  l_ptnl_ler.program_update_date          -- in  date      default null
  ,p_object_version_number        =>  l_life_event_ovn                                     -- out number
  ,p_effective_date               =>  l_life_event_eff_date               --in  date
  );

Line: 608

     ,p_program_update_date          =>  to_char(l_ptnl_ler.program_update_date,hr_transaction_ss.g_date_format)          -- in  date      default null
     ,p_object_version_number        =>  l_life_event_ovn                        -- out number
     ,p_effective_date               =>  to_char(l_life_event_eff_date,hr_transaction_ss.g_date_format)                   --in  date
     ,p_item_type                    =>  l_item_type
     ,p_item_key                     =>  l_item_key
     ,p_activity_id                  =>  null
     ,p_flow_mode                    =>  l_flow_mode
     ,p_subflow_mode                 =>  l_subflow_mode
     ,p_life_event_name              =>  l_life_event_name
     ,p_transaction_step_id          =>  l_evt_transaction_step_id
     ,p_error_message                =>  l_error_message
     ,p_hire_dt                      =>  null
     );*/

Line: 834

  ,p_resume_last_updated           in     date     default null
  ,p_second_passport_exists        in     varchar2 default null
  ,p_student_status                in     varchar2 default null
  ,p_work_schedule                 in     varchar2 default null
  ,p_suffix                        in     varchar2 default null
  ,p_benefit_group_id              in     number   default null
  ,p_receipt_of_death_cert_date    in     date     default null
  ,p_coord_ben_med_pln_no          in     varchar2 default null
  ,p_coord_ben_no_cvg_flag         in     varchar2 default 'N'
  ,p_uses_tobacco_flag             in     varchar2 default null
  ,p_dpdnt_adoption_date           in     date     default null
  ,p_dpdnt_vlntry_svce_flag        in     varchar2 default 'N'
  ,p_original_date_of_hire         in     date     default null
  ,p_adjusted_svc_date             in     date     default null
  ,p_town_of_birth                in      varchar2 default null
  ,p_region_of_birth              in      varchar2 default null
  ,p_country_of_birth             in      varchar2 default null
  ,p_global_person_id             in      varchar2 default null
  ,p_effective_date               in      date default sysdate
  ,p_attribute_update_mode        in      varchar2 default null
  ,p_object_version_number        in      number default null
  ,p_applicant_number             in      varchar2 default null
  ,p_comments                     in      varchar2 default null
  ,p_rehire_authorizor            in      varchar2 default null
  ,p_rehire_recommendation        in      varchar2 default null
  ,p_hold_applicant_date_until    in      date     default null
  ,p_rehire_reason                in      varchar2 default null
  ,p_flow_name                    in      varchar2 default null
  ,p_person_id                        out nocopy number
  ,p_assignment_id                    out nocopy number
  ,p_per_object_version_number        out nocopy number
  ,p_asg_object_version_number        out nocopy number
  ,p_per_effective_start_date         out nocopy date
  ,p_per_effective_end_date           out nocopy date
  ,p_full_name                        out nocopy varchar2
  ,p_per_comment_id                   out nocopy number
  ,p_assignment_sequence              out nocopy number
  ,p_assignment_number                out nocopy varchar2
  ,p_name_combination_warning         out nocopy varchar2    ---boolean
  ,p_assign_payroll_warning           out nocopy varchar2    ---boolean
  ,p_orig_hire_warning                out nocopy varchar2    ---boolean
  ,p_return_status                    out nocopy varchar2    -- Bug 2149113
  ) IS

  CURSOR  get_wf_actid (c_activity_name  in varchar2) IS
  SELECT  distinct wfias.activity_id
  FROM    wf_item_activity_statuses_v  wfias
  WHERE   wfias.item_type = p_item_type
  and     wfias.item_key  = p_item_key
  and     wfias.activity_name = c_activity_name;

Line: 1700

  l_transaction_table(l_count).param_name := 'P_RESUME_LAST_UPDATED';

Line: 1702

                                              (p_resume_last_updated
                                              ,hr_transaction_ss.g_date_format);

Line: 1850

  l_transaction_table(l_count).param_name := 'P_ATTRIBUTE_UPDATE_MODE';

Line: 1851

  l_transaction_table(l_count).param_value := p_attribute_update_mode;