APPS.JTF_TASK_SECURITY_PVT SQL Statements

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

Line: 62

        select  name into l_name from jtf_objects_tl
        where object_code = p_object_code
        and language = userenv('lang');

Line: 86

         SELECT 1
           INTO x
           FROM jtf_task_all_assignments
          WHERE task_id = p_task_id
            AND resource_id = p_resource_id
            AND resource_type_code = p_resource_type
            AND ROWNUM < 2;

Line: 99

         		SELECT 1
           		INTO x
           		FROM jtf_task_all_assignments, jtf_rs_group_members
          		WHERE task_id = p_task_id
            		AND jtf_task_all_assignments.resource_id = group_id
            		AND resource_type_code = 'RS_GROUP'
            		AND jtf_rs_group_members.resource_id = p_resource_id
            		AND ROWNUM < 2;

Line: 112

         				SELECT 1
				        INTO x
           				FROM jtf_task_all_assignments, jtf_rs_team_members
          				WHERE task_id	 = p_task_id
            				AND jtf_task_all_assignments.resource_id = team_id
            				AND resource_type_code = 'RS_TEAM'
            				AND jtf_rs_team_members.team_resource_id = p_resource_id
            				AND ROWNUM < 2;

Line: 125

        						SELECT function_name
        						into l_privlege_name
        						FROM fnd_form_functions fff,
        						fnd_menu_entries fme,
        						fnd_menus fm,
        						fnd_grants fg,
        						fnd_objects,
        						jtf_tasks_b
        						WHERE fff.function_id = fme.function_id
        						AND fme.menu_id =  fm.menu_id
        						and fm.menu_id = fg.menu_id
        						and fg.instance_pk1_value = jtf_tasks_b.owner_id
        						and fg.instance_pk2_value = jtf_tasks_b.owner_type_code
        						and fg.grantee_key = TO_CHAR(p_resource_id)
        						and fg.object_id =  fnd_objects.object_id
        						and task_id = p_task_id
        						and obj_name = 'JTF_TASK_RESOURCE' ;

Line: 164

         SELECT NVL (enter_from_task, 'N')
           INTO x
           FROM jtf_tasks_b, jtf_objects_b
          WHERE task_id = p_task_id
            AND source_object_type_code = object_code
            AND ROWNUM < 2;

Line: 199

      SELECT query_id
        INTO l_query_id
        FROM jtf_perz_query_param
       WHERE parameter_name = p_parameter_name
       and parameter_value = 'Y'
	  and rownum < 2
       AND QUERY_ID IN
        ( select query_id from jtf_perz_query where profile_id in
            ( select profile_id from jtf_perz_profile where profile_name = profilename ));

Line: 214

            SELECT query_id
              INTO l_query_id
              FROM jtf_perz_query
             WHERE profile_id IN ( SELECT profile_id
                                     FROM jtf_perz_profile
                                    WHERE profile_name = '-99999:JTF_TASK');

Line: 237

select category_id into l_category_id
from jtf_task_all_assignments
where task_id = p_task_id
and resource_id = p_resource_id
and resource_type_code  = p_resource_type_code
and rownum < 2;

Line: 266

      select 1 into x
      from jtf_task_all_assignments
      where task_id = p_task_id
      and p_resource_id = resource_id
      and p_resource_type_code = resource_type_code ;

Line: 278

         		SELECT 1
           		INTO x
           		FROM jtf_task_all_assignments, jtf_rs_group_members
          		WHERE task_id = p_task_id
            		AND jtf_task_all_assignments.resource_id = group_id
            		AND resource_type_code = 'RS_GROUP'
            		AND jtf_rs_group_members.resource_id = p_resource_id
            		AND ROWNUM < 2;

Line: 291

         				SELECT 1
				        INTO x
           				FROM jtf_task_all_assignments, jtf_rs_team_members
          				WHERE task_id	 = p_task_id
            				AND jtf_task_all_assignments.resource_id = team_id
            				AND resource_type_code = 'RS_TEAM'
            				AND jtf_rs_team_members.team_resource_id = p_resource_id
            				AND ROWNUM < 2;

Line: 309

   procedure delete_category ( p_category_name in varchar2 )
   is
   l_perz_data_id number;

Line: 315

   select perz_data_id into l_perz_data_id
   from jtf_perz_data
   where perz_data_name = p_category_name ;

Line: 319

    update  jtf_task_all_assignments
    set category_id =  null
    where category_id = l_perz_data_id  ;

Line: 323

    update  jtf_cal_addresses
    set category =  null
    where category = l_perz_data_id  ;

Line: 327

    delete from jtf_perz_data
    where perz_data_id = l_perz_data_id ;

Line: 361

    select 1
    into l_privlege_name
    from jtf_rs_group_members
    where group_id = priveleges_from_resource_id
    and resource_id = logged_in_resource
    and rownum < 2;

Line: 378

    select 1
    into l_privlege_name
    from jtf_rs_team_members
    where TEAM_id = priveleges_from_resource_id
    and TEAM_resource_id = logged_in_resource
    and rownum < 2;

Line: 394

SELECT function_name
into l_privlege_name
FROM fnd_form_functions fff,
fnd_menu_entries fme,
fnd_menus fm,
fnd_grants fg,
fnd_objects
WHERE fff.function_id = fme.function_id
AND fme.menu_id =  fm.menu_id
and fm.menu_id = fg.menu_id
and fg.instance_pk1_value = priveleges_from_resource_id
and fg.instance_pk2_value = priveleges_from_resource_type
and fg.grantee_key = TO_CHAR(logged_in_resource)
and fg.object_id =  fnd_objects.object_id
and obj_name = 'JTF_TASK_RESOURCE' ;