APPS.HR_ASSIGNMENT_BE2 SQL Statements

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

Line: 4

procedure update_emp_asg_a (
p_effective_date               date,
p_datetrack_update_mode        varchar2,
p_assignment_id                number,
p_object_version_number        number,
p_supervisor_id                number,
p_assignment_number            varchar2,
p_change_reason                varchar2,
p_assignment_status_type_id    number,
p_comments                     varchar2,
p_date_probation_end           date,
p_default_code_comb_id         number,
p_frequency                    varchar2,
p_internal_address_line        varchar2,
p_manager_flag                 varchar2,
p_normal_hours                 number,
p_perf_review_period           number,
p_perf_review_period_frequency varchar2,
p_probation_period             number,
p_probation_unit               varchar2,
p_projected_assignment_end     varchar2,
p_sal_review_period            number,
p_sal_review_period_frequency  varchar2,
p_set_of_books_id              number,
p_source_type                  varchar2,
p_time_normal_finish           varchar2,
p_time_normal_start            varchar2,
p_bargaining_unit_code         varchar2,
p_labour_union_member_flag     varchar2,
p_hourly_salaried_code         varchar2,
p_ass_attribute_category       varchar2,
p_ass_attribute1               varchar2,
p_ass_attribute2               varchar2,
p_ass_attribute3               varchar2,
p_ass_attribute4               varchar2,
p_ass_attribute5               varchar2,
p_ass_attribute6               varchar2,
p_ass_attribute7               varchar2,
p_ass_attribute8               varchar2,
p_ass_attribute9               varchar2,
p_ass_attribute10              varchar2,
p_ass_attribute11              varchar2,
p_ass_attribute12              varchar2,
p_ass_attribute13              varchar2,
p_ass_attribute14              varchar2,
p_ass_attribute15              varchar2,
p_ass_attribute16              varchar2,
p_ass_attribute17              varchar2,
p_ass_attribute18              varchar2,
p_ass_attribute19              varchar2,
p_ass_attribute20              varchar2,
p_ass_attribute21              varchar2,
p_ass_attribute22              varchar2,
p_ass_attribute23              varchar2,
p_ass_attribute24              varchar2,
p_ass_attribute25              varchar2,
p_ass_attribute26              varchar2,
p_ass_attribute27              varchar2,
p_ass_attribute28              varchar2,
p_ass_attribute29              varchar2,
p_ass_attribute30              varchar2,
p_title                        varchar2,
p_segment1                     varchar2,
p_segment2                     varchar2,
p_segment3                     varchar2,
p_segment4                     varchar2,
p_segment5                     varchar2,
p_segment6                     varchar2,
p_segment7                     varchar2,
p_segment8                     varchar2,
p_segment9                     varchar2,
p_segment10                    varchar2,
p_segment11                    varchar2,
p_segment12                    varchar2,
p_segment13                    varchar2,
p_segment14                    varchar2,
p_segment15                    varchar2,
p_segment16                    varchar2,
p_segment17                    varchar2,
p_segment18                    varchar2,
p_segment19                    varchar2,
p_segment20                    varchar2,
p_segment21                    varchar2,
p_segment22                    varchar2,
p_segment23                    varchar2,
p_segment24                    varchar2,
p_segment25                    varchar2,
p_segment26                    varchar2,
p_segment27                    varchar2,
p_segment28                    varchar2,
p_segment29                    varchar2,
p_segment30                    varchar2,
p_concatenated_segments        varchar2,
p_soft_coding_keyflex_id       number,
p_comment_id                   number,
p_effective_start_date         date,
p_effective_end_date           date,
p_no_managers_warning          boolean,
p_other_manager_warning        boolean,
p_hourly_salaried_warning      boolean,
p_concat_segments              varchar2,
p_contract_id                  number,
p_establishment_id             number,
p_collective_agreement_id      number,
p_cagr_id_flex_num             number,
p_cag_segment1                 varchar2,
p_cag_segment2                 varchar2,
p_cag_segment3                 varchar2,
p_cag_segment4                 varchar2,
p_cag_segment5                 varchar2,
p_cag_segment6                 varchar2,
p_cag_segment7                 varchar2,
p_cag_segment8                 varchar2,
p_cag_segment9                 varchar2,
p_cag_segment10                varchar2,
p_cag_segment11                varchar2,
p_cag_segment12                varchar2,
p_cag_segment13                varchar2,
p_cag_segment14                varchar2,
p_cag_segment15                varchar2,
p_cag_segment16                varchar2,
p_cag_segment17                varchar2,
p_cag_segment18                varchar2,
p_cag_segment19                varchar2,
p_cag_segment20                varchar2,
p_notice_period                number,
p_notice_period_uom            varchar2,
p_employee_category            varchar2,
p_work_at_home                 varchar2,
p_job_post_source_name         varchar2,
p_cagr_grade_def_id            number,
p_cagr_concatenated_segments   varchar2,
p_supervisor_assignment_id     number) is
  l_event_key number;

Line: 144

  select per_wf_events_s.nextval from dual;

Line: 146

  l_proc varchar2(72):='  hr_assignment_be2.update_emp_asg_a';

Line: 150

  l_event_name:='oracle.apps.per.api.assignment.update_emp_asg';

Line: 174

    l_text:='';

Line: 175

    l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);

Line: 176

    l_text:=l_text||'';

Line: 756

end update_emp_asg_a;