APPS.HR_ASSIGNMENT_BEO SQL Statements

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

Line: 4

procedure update_cwk_asg_criteria_a (
p_effective_date               date,
p_datetrack_update_mode        varchar2,
p_assignment_id                number,
p_object_version_number        number,
p_grade_id                     number,
p_position_id                  number,
p_job_id                       number,
p_location_id                  number,
p_organization_id              number,
p_pay_basis_id                 number,
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_people_group_name            varchar2,
p_effective_start_date         date,
p_effective_end_date           date,
p_people_group_id              number,
p_org_now_no_manager_warning   boolean,
p_other_manager_warning        boolean,
p_spp_delete_warning           boolean,
p_entries_changed_warning      varchar2,
p_tax_district_changed_warning boolean,
p_concat_segments              varchar2) is
  l_event_key number;

Line: 62

  select per_wf_events_s.nextval from dual;

Line: 64

  l_proc varchar2(72):='  hr_assignment_beO.update_cwk_asg_criteria_a';

Line: 68

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

Line: 92

    l_text:='';

Line: 93

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

Line: 94

    l_text:=l_text||'';

Line: 280

    l_text:='';

Line: 281

if(P_SPP_DELETE_WARNING) then
l_text:=l_text||'TRUE';

Line: 286

    l_text:=l_text||'';

Line: 350

end update_cwk_asg_criteria_a;