DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_BE3 SQL Statements

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

Line: 4

procedure update_emp_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_payroll_id                   number,
p_location_id                  number,
p_special_ceiling_step_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_group_name                   varchar2,
p_employment_category          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,
p_contract_id                  number,
p_establishment_id             number,
p_concatenated_segments        varchar2,
p_soft_coding_keyflex_id       number,
p_scl_segment1                 varchar2) is
  l_event_key number;
Line: 70

  select per_wf_events_s.nextval from dual;
Line: 72

  l_proc varchar2(72):='  hr_assignment_be3.update_emp_asg_criteria_a';
Line: 76

  l_event_name:='oracle.apps.per.api.assignment.update_emp_asg_criteria';
Line: 100

    l_text:='';
Line: 101

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

    l_text:=l_text||'';
Line: 300

    l_text:='';
Line: 301

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

    l_text:=l_text||'';
Line: 390

end update_emp_asg_criteria_a;