APPS.PER_SIT_PKG SQL Statements

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

Line: 24

select 'x'
from per_special_info_types
where  id_flex_num = p_id_flex_num
and   (p_special_information_type_id is null or
      (p_special_information_type_id is not null and
       special_information_type_id <> p_special_information_type_id))
and    business_group_id  = p_bg_id;

Line: 56

select 'x'
from    per_person_analyses pa,
        per_special_info_types c
where   pa.id_flex_num       = c.id_flex_num
and     pa.business_group_id  = p_bg_id
and     c.business_group_id   = pa.business_group_id
and     pa.id_flex_num       = p_id_flex_num;  --bug 3648683

Line: 107

select  id_flex_structure_name
,       enabled_flag
from    fnd_id_flex_structures_vl
where   id_flex_code = 'PEA'
and     id_flex_num = p_id_flex_num;

Line: 130

select per_special_info_types_s.nextval
from sys.dual;

Line: 154

                   p_PROGRAM_UPDATE_DATE             in DATE,
                   p_ATTRIBUTE_CATEGORY              in VARCHAR2,
                   p_ATTRIBUTE1                      in VARCHAR2,
                   p_ATTRIBUTE2                      in VARCHAR2,
                   p_ATTRIBUTE3                      in VARCHAR2,
                   p_ATTRIBUTE4                      in VARCHAR2,
                   p_ATTRIBUTE5                      in VARCHAR2,
                   p_ATTRIBUTE6                      in VARCHAR2,
                   p_ATTRIBUTE7                      in VARCHAR2,
                   p_ATTRIBUTE8                      in VARCHAR2,
                   p_ATTRIBUTE9                      in VARCHAR2,
                   p_ATTRIBUTE10                     in VARCHAR2,
                   p_ATTRIBUTE11                     in VARCHAR2,
                   p_ATTRIBUTE12                     in VARCHAR2,
                   p_ATTRIBUTE13                     in VARCHAR2,
                   p_ATTRIBUTE14                     in VARCHAR2,
                   p_ATTRIBUTE15                     in VARCHAR2,
                   p_ATTRIBUTE16                     in VARCHAR2,
                   p_ATTRIBUTE17                     in VARCHAR2,
                   p_ATTRIBUTE18                     in VARCHAR2,
                   p_ATTRIBUTE19                     in VARCHAR2,
                   p_ATTRIBUTE20                     in VARCHAR2,
                   p_MULTIPLE_OCCURRENCES_FLAG       in VARCHAR2) is
--
begin
--
  check_unique_sit(p_special_information_type_id => null
                  ,p_bg_id => p_business_group_id
                  ,p_id_flex_num => p_id_flex_num);

Line: 186

  insert into per_special_info_types
   (SPECIAL_INFORMATION_TYPE_ID,
    BUSINESS_GROUP_ID,
    ID_FLEX_NUM,
    COMMENTS,
    ENABLED_FLAG,
    REQUEST_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_ID,
    PROGRAM_UPDATE_DATE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE16,
    ATTRIBUTE17,
    ATTRIBUTE18,
    ATTRIBUTE19,
    ATTRIBUTE20,
    MULTIPLE_OCCURRENCES_FLAG)
  values
   (p_SPECIAL_INFORMATION_TYPE_ID,
    p_BUSINESS_GROUP_ID,
    p_ID_FLEX_NUM,
    p_COMMENTS,
    p_ENABLED_FLAG,
    p_REQUEST_ID,
    p_PROGRAM_APPLICATION_ID,
    p_PROGRAM_ID,
    p_PROGRAM_UPDATE_DATE,
    p_ATTRIBUTE_CATEGORY,
    p_ATTRIBUTE1,
    p_ATTRIBUTE2,
    p_ATTRIBUTE3,
    p_ATTRIBUTE4,
    p_ATTRIBUTE5,
    p_ATTRIBUTE6,
    p_ATTRIBUTE7,
    p_ATTRIBUTE8,
    p_ATTRIBUTE9,
    p_ATTRIBUTE10,
    p_ATTRIBUTE11,
    p_ATTRIBUTE12,
    p_ATTRIBUTE13,
    p_ATTRIBUTE14,
    p_ATTRIBUTE15,
    p_ATTRIBUTE16,
    p_ATTRIBUTE17,
    p_ATTRIBUTE18,
    p_ATTRIBUTE19,
    p_ATTRIBUTE20,
    p_MULTIPLE_OCCURRENCES_FLAG);

Line: 267

                   p_PROGRAM_UPDATE_DATE             in DATE,
                   p_ATTRIBUTE_CATEGORY              in VARCHAR2,
                   p_ATTRIBUTE1                      in VARCHAR2,
                   p_ATTRIBUTE2                      in VARCHAR2,
                   p_ATTRIBUTE3                      in VARCHAR2,
                   p_ATTRIBUTE4                      in VARCHAR2,
                   p_ATTRIBUTE5                      in VARCHAR2,
                   p_ATTRIBUTE6                      in VARCHAR2,
                   p_ATTRIBUTE7                      in VARCHAR2,
                   p_ATTRIBUTE8                      in VARCHAR2,
                   p_ATTRIBUTE9                      in VARCHAR2,
                   p_ATTRIBUTE10                     in VARCHAR2,
                   p_ATTRIBUTE11                     in VARCHAR2,
                   p_ATTRIBUTE12                     in VARCHAR2,
                   p_ATTRIBUTE13                     in VARCHAR2,
                   p_ATTRIBUTE14                     in VARCHAR2,
                   p_ATTRIBUTE15                     in VARCHAR2,
                   p_ATTRIBUTE16                     in VARCHAR2,
                   p_ATTRIBUTE17                     in VARCHAR2,
                   p_ATTRIBUTE18                     in VARCHAR2,
                   p_ATTRIBUTE19                     in VARCHAR2,
                   p_ATTRIBUTE20                     in VARCHAR2,
                   p_MULTIPLE_OCCURRENCES_FLAG       in VARCHAR2) is
--
begin
--
  check_unique_sit
     (p_special_information_type_id => p_special_information_type_id
     ,p_bg_id => p_business_group_id
     ,p_id_flex_num => p_id_flex_num);

Line: 298

  update per_special_info_types
  set BUSINESS_GROUP_ID              = p_BUSINESS_GROUP_ID,
      ID_FLEX_NUM                    = p_ID_FLEX_NUM,
      COMMENTS                       = p_COMMENTS,
      ENABLED_FLAG                   = p_ENABLED_FLAG,
      REQUEST_ID                     = p_REQUEST_ID,
      PROGRAM_APPLICATION_ID         = p_PROGRAM_APPLICATION_ID,
      PROGRAM_ID                     = p_PROGRAM_ID,
      PROGRAM_UPDATE_DATE            = p_PROGRAM_UPDATE_DATE,
      ATTRIBUTE_CATEGORY             = p_ATTRIBUTE_CATEGORY,
      ATTRIBUTE1                     = p_ATTRIBUTE1,
      ATTRIBUTE2                     = p_ATTRIBUTE2,
      ATTRIBUTE3                     = p_ATTRIBUTE3,
      ATTRIBUTE4                     = p_ATTRIBUTE4,
      ATTRIBUTE5                     = p_ATTRIBUTE5,
      ATTRIBUTE6                     = p_ATTRIBUTE6,
      ATTRIBUTE7                     = p_ATTRIBUTE7,
      ATTRIBUTE8                     = p_ATTRIBUTE8,
      ATTRIBUTE9                     = p_ATTRIBUTE9,
      ATTRIBUTE10                    = p_ATTRIBUTE10,
      ATTRIBUTE11                    = p_ATTRIBUTE11,
      ATTRIBUTE12                    = p_ATTRIBUTE12,
      ATTRIBUTE13                    = p_ATTRIBUTE13,
      ATTRIBUTE14                    = p_ATTRIBUTE14,
      ATTRIBUTE15                    = p_ATTRIBUTE15,
      ATTRIBUTE16                    = p_ATTRIBUTE16,
      ATTRIBUTE17                    = p_ATTRIBUTE17,
      ATTRIBUTE18                    = p_ATTRIBUTE18,
      ATTRIBUTE19                    = p_ATTRIBUTE19,
      ATTRIBUTE20                    = p_ATTRIBUTE20,
      MULTIPLE_OCCURRENCES_FLAG      = p_MULTIPLE_OCCURRENCES_FLAG
  where SPECIAL_INFORMATION_TYPE_ID = p_special_information_type_id;

Line: 344

    select SPECIAL_INFORMATION_TYPE_ID
    from  per_special_info_types
    where SPECIAL_INFORMATION_TYPE_ID = p_SPECIAL_INFORMATION_TYPE_ID
    for	update nowait;

Line: 392

    insert into per_special_info_type_usages
                  (special_information_type_id,
                   special_info_category)
    select p_special_information_type_id,
           p_special_info_category
    from dual
    where not exists
            (select null
             from per_special_info_type_usages
             where special_information_type_id = p_special_information_type_id
               and special_info_category = p_special_info_category);

Line: 427

  delete from per_special_info_type_usages
  where special_information_type_id = p_special_information_type_id
  and (
       (special_info_category = G_JOB      and p_job_category = 'N') or
       (special_info_category = G_POSITION and p_position_category = 'N') or
       (special_info_category = G_SKILL    and p_skill_category = 'N') or
       (special_info_category = G_OTHER    and p_other_category = 'N') or
       (special_info_category = G_OSHA     and p_osha_category = 'N') or
       (special_info_category = G_ADA      and p_ada_category = 'N')
      );

Line: 471

procedure delete_usages (p_special_information_type_id in number) is
begin
--
  delete from per_special_info_type_usages
  where special_information_type_id = p_special_information_type_id;

Line: 489

  delete_usages (p_special_information_type_id);

Line: 491

  delete from per_special_info_types
  where special_information_type_id = p_special_information_type_id;

Line: 510

    select 'X'
    from per_analysis_criteria ac
    ,    per_job_requirements jr
    where ac.id_flex_num = p_id_flex_num
      and jr.analysis_criteria_id = ac.analysis_criteria_id
      and jr.business_group_id  = p_business_group_id   --bug 3648683
      and jr.job_id is not null;

Line: 519

    select 'X'
    from per_analysis_criteria ac
    ,    per_job_requirements jr
    where ac.id_flex_num = p_id_flex_num
      and jr.analysis_criteria_id = ac.analysis_criteria_id
      and jr.business_group_id  = p_business_group_id  --bug 3648683
      and jr.position_id is not null;

Line: 528

    select 'X'
    from per_person_analyses pa
    where pa.id_flex_num = p_id_flex_num
      and pa.business_group_id = p_business_group_id
      and exists (select null
                  from pay_legislation_rules pl
                  where pl.rule_type = 'OSHA'
                    and pl.rule_mode = to_char(pa.id_flex_num));

Line: 538

    select 'X'
    from per_person_analyses pa
    where pa.id_flex_num = p_id_flex_num
      and pa.business_group_id = p_business_group_id
      and exists (select null
                  from pay_legislation_rules pl
                  where pl.rule_type in ('ADA_DIS_ACC','ADA_DIS')
                    and pl.rule_mode = to_char(pa.id_flex_num));

Line: 548

    select 'X'
    from per_person_analyses pa
    where pa.id_flex_num = p_id_flex_num
      and pa.business_group_id = p_business_group_id
      and not exists (select null
                      from pay_legislation_rules pl
                      where pl.rule_type in ('OSHA','ADA_DIS_ACC','ADA_DIS')
                        and pl.rule_mode = to_char(pa.id_flex_num));