APPS.PA_ROLE_UTILS SQL Statements

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

Line: 26

                  SELECT project_role_id
                  FROM pa_project_role_types_vl
                  WHERE meaning = p_role_name;

Line: 37

           SELECT project_role_id
           INTO   x_role_id
           FROM   pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
                                                          pa_project_role_types_b */
           WHERE  project_role_id = p_role_id
           AND TRUNC(SYSDATE) BETWEEN
           start_date_active AND
           NVL(end_date_active,TRUNC(SYSDATE));

Line: 79

	      SELECT project_role_id
	      INTO   x_role_id
	      FROM   pa_project_role_types_vl
	      WHERE  meaning = p_role_name
	      AND TRUNC(SYSDATE) BETWEEN
	      start_date_active AND
	      NVL(end_date_active,TRUNC(SYSDATE));

Line: 134

           SELECT project_role_id
           INTO   x_role_id
           FROM   pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
                                                      pa_project_role_types_b */
           WHERE  project_role_id = p_role_id
           AND TRUNC(SYSDATE) BETWEEN
           start_date_active AND
           NVL(end_date_active,TRUNC(SYSDATE));

Line: 146

           SELECT project_role_id
           INTO   x_role_id
           FROM   pa_project_role_types_vl
           WHERE  meaning = p_role_name
           AND TRUNC(SYSDATE) BETWEEN
           start_date_active AND
           NVL(end_date_active,TRUNC(SYSDATE));

Line: 189

	  SELECT role_list_id
	    INTO x_role_list_id
	    FROM pa_role_lists
	    WHERE role_list_id = p_role_list_id
	    AND TRUNC(start_date_active) <= l_sysdate
	    AND (end_date_active IS NULL OR l_sysdate <= TRUNC(end_date_active));

Line: 199

       SELECT role_list_id
	 INTO x_role_list_id
	 FROM pa_role_lists
	 WHERE name = p_role_list_name
	 AND TRUNC(start_date_active) <= l_sysdate
	 AND (end_date_active IS NULL OR l_sysdate <= TRUNC(end_date_active));

Line: 233

   SELECT 'Y' INTO l_status
     FROM dual
     WHERE exists
     (
      SELECT role_list_id FROM pa_role_list_members
      WHERE role_list_id = x_role_list_id
      AND project_role_id = x_role_id
      );

Line: 283

SELECT meaning,
       default_min_job_level,
       default_max_job_level,
       menu_id,
       default_job_id
FROM   pa_project_role_types_vl
WHERE  project_role_id = p_role_id ;

Line: 352

SELECT business_group_id
FROM   per_competences
WHERE  competence_id = p_competence_id;

Line: 403

    select 'Y'
        from pa_role_controls
        where project_role_id=p_role_id
      and  role_control_code='ALLOW_SCHEDULE'
      AND ROWNUM = 1;

Line: 433

       select 'Y'
        from pa_role_controls
        where project_role_id=p_role_id
	 and  role_control_code='ALLOW_SCHEDULE'
	 AND ROWNUM =1;

Line: 470

PROCEDURE Check_delete_role_OK (p_role_id in number
                                ,x_return_status out NOCOPY varchar2 --File.Sql.39 bug 4440895
                                ,x_error_message_code out NOCOPY varchar2) IS --File.Sql.39 bug 4440895
cursor c_seed_roles is
   --select '1'
   --from dual
   --where exists
   select 'Y'
                 from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
                                               pa_project_role_types_b */
                 where project_role_id in (1,2,3,4)
     and project_role_id=p_role_id
     AND ROWNUM =1;

Line: 528

select created_by
from pa_role_controls
where project_role_id=p_role_id
and role_control_code =p_role_control_code;

Line: 537

   select 'Y'
     from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types to
                                               pa_project_role_types_b */
     where project_role_id in (1,2,3,4)
     and project_role_id=p_role_id
     AND ROWNUM =1;

Line: 608

PROCEDURE Check_delete_role_list_OK(p_role_list_id in number
                                    ,x_return_status out NOCOPY varchar2 --File.Sql.39 bug 4440895
                                    ,x_error_message_code out NOCOPY varchar2) IS --File.Sql.39 bug 4440895

cursor c_role_list_in_use is
  --select '1'
  --from dual
  --where exists
          select 'Y'
           from pa_projects_all
	    where role_list_id=p_role_list_id
	    AND ROWNUM=1;

Line: 655

 select menu_id
 into v_menu_id
 from pa_project_role_types
 where project_role_id=p_role_id;

Line: 683

PROCEDURE update_menu_in_grants(p_role_id in number
                               ,p_menu_id in number
                               ,x_return_status out NOCOPY varchar2 --File.Sql.39 bug 4440895
                               ,x_error_message_code out NOCOPY varchar2) IS --File.Sql.39 bug 4440895
v_return_status varchar2(1);

Line: 693

select count(*)
into   l_count
from pa_project_parties
where project_role_id = p_role_id;

Line: 700

   pa_security_pvt.update_menu(
     p_commit           => FND_API.G_FALSE,
     -- p_debug_mode       => 'N',
     p_project_role_id  => p_role_id,
     p_menu_id          => p_menu_id,
     x_return_status    => v_return_status,
     x_msg_count        => v_msg_count,
     x_msg_data         => v_msg_data
   );

Line: 741

select count(*)
into   l_count
from   pa_project_parties
where  project_role_id = p_role_id;

Line: 788

select count(*)
into   l_count
from pa_project_parties
where project_role_id = p_role_id;

Line: 837

 SELECT '1'
 FROM dual
   WHERE EXISTS (SELECT 'Y'
               FROM  pa_project_parties ppp
               WHERE ppp.project_role_id=p_role_id)
      OR EXISTS
               (SELECT 'Y'
               FROM  pa_project_assignments ppa
               WHERE ppa.project_role_id=p_role_id)
      OR EXISTS
               (SELECT 'Y'
                FROM pa_rbs_elements
                WHERE resource_type_id = 15
                AND resource_source_id = p_role_id)
      OR EXISTS
               (SELECT 'Y'
                FROM pa_resource_list_members
                where project_role_id = p_role_id);

Line: 880

select 'y'
from pa_project_role_types_vl
where meaning =p_meaning;

Line: 910

select 'y'
from pa_role_lists
where name =p_name;