APPS.PER_GENERIC_REPORT_PKG SQL Statements

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

Line: 37

                                                        Inserts into tables
                                                        use by column name.

============================================================================*/

  --
  --                               Private Global Definition
  ----------------------------------------------------------------------------
  --
  -- Global package name
  --
  g_package varchar2(50):= 'per_generic_report_pkg.';

Line: 70

    l_recs_inserted       number := 1;

Line: 84

      select          a.full_name, a.sex
      from            per_all_people_f a,
                      per_all_assignments_f b,
                      per_vacancies c
      where           a.business_group_id = b.business_group_id
      and             a.person_id         = b.person_id
      and             trunc(sysdate)
                      between a.effective_start_date
                      and     a.effective_end_date
      and             b.vacancy_id        = c.vacancy_id
      and             trunc(sysdate)
                      between b.effective_start_date
                      and     b.effective_end_date
      and             c.name              = p_param_1;

Line: 114

        insert into per_generic_report_output
        (line_type,line_number,line_content)
        values ('B',l_recs_inserted,l_full_name||
        lpad(l_sex,50-length(l_full_name),' '));

Line: 118

        l_recs_inserted := l_recs_inserted + 1;

Line: 147

    l_recs_inserted       number := 1;

Line: 161

      select          a.full_name
      from            per_all_people_f a,
                      per_all_assignments_f b,
                      per_vacancies c
      where           a.business_group_id = b.business_group_id
      and             a.person_id         = b.person_id
      and             trunc(sysdate)
                      between a.effective_start_date
                      and     a.effective_end_date
      and             b.vacancy_id        = c.vacancy_id
      and             trunc(sysdate)
                      between b.effective_start_date
                      and     b.effective_end_date
      and             c.name              = p_param_1
      and             a.sex               = p_param_2;

Line: 193

        insert into per_generic_report_output
        (line_type,line_number,line_content)
        values ('B',l_recs_inserted,'     '||upper(l_full_name));

Line: 196

        l_recs_inserted := l_recs_inserted + 1;

Line: 230

    l_recs_inserted       number := 1;

Line: 246

      select a.full_name, a.sex
      from            per_all_people_f a,
                      per_all_assignments_f b,
                      per_vacancies c
      where           a.business_group_id = b.business_group_id
      and             a.person_id         = b.person_id
      and             trunc(sysdate)
                      between a.effective_start_date
                      and     a.effective_end_date
      and             b.vacancy_id        = c.vacancy_id
      and             trunc(sysdate)
                      between b.effective_start_date
                      and     b.effective_end_date
      and             b.primary_flag      = 'Y'
      and             c.name              = p_param_1
      and             a.marital_status    = p_param_2
      and             a.sex               = p_param_3;

Line: 281

        insert into per_generic_report_output
        (line_type,line_number,line_content)
        values ('B',l_recs_inserted,l_sex||'  '||initcap(l_full_name));

Line: 284

        l_recs_inserted := l_recs_inserted + 1;

Line: 360

    delete from per_generic_report_output;

Line: 374

    insert into per_generic_report_output
    (line_type,line_number,line_content)
    values ('H',1,'Example Title - Oracle Corporation UK Ltd');

Line: 384

    insert into per_generic_report_output
    (line_type,line_number,line_content)
    values ('F',1,'Example Footer - Oracle Corporation UK Ltd');

Line: 391

    insert into per_generic_report_output
    (line_type,line_number,line_content)
    values ('T',1,p_report_name);

Line: 484

      select name
      from   per_vacancies
      where  name = p_param_1;