APPS.CSF_REQUIRED_SKILLS_PKG SQL Statements

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

Line: 10

    Select 1
    From jtf_task_templates_b
    Where task_template_id = p_task_tpl_id
    and task_group_id = p_task_tpl_grp_id;

Line: 31

    Select 1
    From jtf_tasks_b
    Where task_id = p_task_id;

Line: 54

    select 1
    from csf_required_skills_b
    where skill_id       = p_skill_id
    and   skill_type_id  = p_skill_type_id
    and   has_skill_type = 'TASK'
    and   sysdate        >= trunc(start_date_active)
    and   (sysdate       <= trunc(end_date_active)+1 or end_date_active is null)
    and   has_skill_id   = p_task_id;

Line: 80

      select 'SELECT '||name_number_column||', '||data_column||
             ' FROM '||from_clause||
             ' WHERE '||where_clause||' AND '||key_column||' = :b_skill_id'
      from csf_skill_types_b
      where skill_type_id = p_skill_type_id;

Line: 121

    Select 1
    From csf_skill_levels_b
    Where skill_level_id = p_skill_level_id
    and (sysdate <= trunc(end_date_active)+1
         or end_date_active is null);

Line: 173

  /*  Check if  a required skill to be inserted does exist for a
     particular task (has_skill_id with has_skill_type = TASKS). If it
     does not exist then proceed to insert the record. Otherwise, DO NOT
     INSERT!!!!!!
  */
  if not required_skill_exists ( p_task_id
                               , p_skill_id
                               , p_skill_type_id)
  then

   /* Checks if task exist in JTF_TASK_B table. */
   If not task_exists (p_task_id) then
     X_return_status :=  fnd_api.g_ret_sts_error;

Line: 211

   /* When all checks are ok, insert record
      into CSF_REQUIRED_SKILLS table. */

    select csf_required_skills_b_s1.nextval
    into l_req_skill_id
    from dual;

Line: 218

    insert into csf_required_skills_b
    ( required_skill_id
    , skill_type_id
    , skill_id
    , has_skill_type
    , has_skill_id
    , skill_level_id
    , skill_required_flag
    , level_required_flag
    , disabled_flag
    , start_date_active
    , end_date_active
    , object_version_number
    , created_by
    , creation_date
    , last_updated_by
    , last_update_date
    , last_update_login
    , attribute1
    , attribute2
    , attribute3
    , attribute4
    , attribute5
    , attribute6
    , attribute7
    , attribute8
    , attribute9
    , attribute10
    , attribute11
    , attribute12
    , attribute13
    , attribute14
    , attribute15
    , attribute_category)
    values
    ( l_req_skill_id
    , p_skill_type_id
    , p_skill_id
    , 'TASK'
    , p_task_id
    , p_skill_level_id
    , null
    , null
    , null
    , sysdate
    , null
    , 1
    , fnd_global.user_id
    , sysdate
    , fnd_global.user_id
    , sysdate
    , fnd_global.login_id
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null);

Line: 303

     X_msg_data      := 'Combination of Skill id ('||p_skill_id||') and Skill type id ('||p_skill_type_id||') to be inserted does exist for Task ('||to_char(p_task_id)|| ') in  CSF_REQUIRED_SKILLS_B table';

Line: 333

     select mtl.inventory_item_id
     from jtf_tasks_b          tb
     ,    cs_incidents_all_b   sr
     ,    mtl_system_items_kfv mtl
     where mtl.organization_id = fnd_profile.value('CSF_INVENTORY_ORG')
     and sysdate between nvl(mtl.start_date_active,sysdate) and nvl(mtl.end_date_active,sysdate)
     and mtl.inventory_item_id = sr.inventory_item_id
     and sr.incident_id        = tb.source_object_id
     and tb.task_id            = l_task_id;

Line: 406

    Select skill_type_id
    ,      skill_id
    ,      skill_level_id
    from csf_required_skills_b
    where has_skill_type = 'TASK TEMPLATE'
    and   has_skill_id   = l_tpl_id;

Line: 420

      call create_task_req_skill procedure to insert the
      record. */
   l_task_id    := jtf_tasks_pub.p_task_user_hooks.task_id;