APPS.HR_ASSIGNMENT_BEM SQL Statements

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

Line: 4

procedure update_cwk_asg_a (
p_effective_date               date,
p_datetrack_update_mode        varchar2,
p_assignment_id                number,
p_object_version_number        number,
p_assignment_category          varchar2,
p_assignment_number            varchar2,
p_change_reason                varchar2,
p_comments                     varchar2,
p_default_code_comb_id         number,
p_establishment_id             number,
p_frequency                    varchar2,
p_internal_address_line        varchar2,
p_labour_union_member_flag     varchar2,
p_manager_flag                 varchar2,
p_normal_hours                 number,
p_project_title                varchar2,
p_set_of_books_id              number,
p_source_type                  varchar2,
p_supervisor_id                number,
p_time_normal_finish           varchar2,
p_time_normal_start            varchar2,
p_title                        varchar2,
p_vendor_assignment_number     varchar2,
p_vendor_employee_number       varchar2,
p_vendor_id                    number,
p_vendor_site_id               number,
p_po_header_id                 number,
p_po_line_id                   number,
p_projected_assignment_end     date,
p_assignment_status_type_id    number,
p_attribute_category           varchar2,
p_attribute1                   varchar2,
p_attribute2                   varchar2,
p_attribute3                   varchar2,
p_attribute4                   varchar2,
p_attribute5                   varchar2,
p_attribute6                   varchar2,
p_attribute7                   varchar2,
p_attribute8                   varchar2,
p_attribute9                   varchar2,
p_attribute10                  varchar2,
p_attribute11                  varchar2,
p_attribute12                  varchar2,
p_attribute13                  varchar2,
p_attribute14                  varchar2,
p_attribute15                  varchar2,
p_attribute16                  varchar2,
p_attribute17                  varchar2,
p_attribute18                  varchar2,
p_attribute19                  varchar2,
p_attribute20                  varchar2,
p_attribute21                  varchar2,
p_attribute22                  varchar2,
p_attribute23                  varchar2,
p_attribute24                  varchar2,
p_attribute25                  varchar2,
p_attribute26                  varchar2,
p_attribute27                  varchar2,
p_attribute28                  varchar2,
p_attribute29                  varchar2,
p_attribute30                  varchar2,
p_scl_segment1                 varchar2,
p_scl_segment2                 varchar2,
p_scl_segment3                 varchar2,
p_scl_segment4                 varchar2,
p_scl_segment5                 varchar2,
p_scl_segment6                 varchar2,
p_scl_segment7                 varchar2,
p_scl_segment8                 varchar2,
p_scl_segment9                 varchar2,
p_scl_segment10                varchar2,
p_scl_segment11                varchar2,
p_scl_segment12                varchar2,
p_scl_segment13                varchar2,
p_scl_segment14                varchar2,
p_scl_segment15                varchar2,
p_scl_segment16                varchar2,
p_scl_segment17                varchar2,
p_scl_segment18                varchar2,
p_scl_segment19                varchar2,
p_scl_segment20                varchar2,
p_scl_segment21                varchar2,
p_scl_segment22                varchar2,
p_scl_segment23                varchar2,
p_scl_segment24                varchar2,
p_scl_segment25                varchar2,
p_scl_segment26                varchar2,
p_scl_segment27                varchar2,
p_scl_segment28                varchar2,
p_scl_segment29                varchar2,
p_scl_segment30                varchar2,
p_org_now_no_manager_warning   boolean,
p_effective_start_date         date,
p_effective_end_date           date,
p_comment_id                   number,
p_no_managers_warning          boolean,
p_other_manager_warning        boolean,
p_soft_coding_keyflex_id       number,
p_concatenated_segments        varchar2,
p_hourly_salaried_warning      boolean,
p_supervisor_assignment_id     number) is
  l_event_key number;

Line: 113

  select per_wf_events_s.nextval from dual;

Line: 115

  l_proc varchar2(72):='  hr_assignment_beM.update_cwk_asg_a';

Line: 119

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

Line: 143

    l_text:='';

Line: 144

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

Line: 145

    l_text:=l_text||'';

Line: 605

end update_cwk_asg_a;