APPS.PA_CI_SECURITY_PKG SQL Statements

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

Line: 30

    G_proj_auth_tab.DELETE;

Line: 31

    G_view_proj_i_tab.DELETE;

Line: 32

    G_view_proj_cr_tab.DELETE;

Line: 33

    G_view_proj_co_tab.DELETE;

Line: 34

    G_ci_type_tab.DELETE;

Line: 37

    G_proj_auth_tab.DELETE;

Line: 38

    G_view_proj_i_tab.DELETE;

Line: 39

    G_view_proj_cr_tab.DELETE;

Line: 40

    G_view_proj_co_tab.DELETE;

Line: 41

    G_ci_type_tab.DELETE;

Line: 44

  SELECT ci_type_class_code
  INTO l_class_code
  FROM pa_ci_types_b cit,
       pa_control_items ci
  WHERE ci.ci_id = p_ci_id
    AND cit.ci_type_id = ci.ci_type_id;

Line: 97

    G_proj_auth_tab.DELETE;

Line: 98

    G_view_proj_i_tab.DELETE;

Line: 99

    G_view_proj_cr_tab.DELETE;

Line: 100

    G_view_proj_co_tab.DELETE;

Line: 101

    G_ci_type_tab.DELETE;

Line: 104

    G_proj_auth_tab.DELETE;

Line: 105

    G_view_proj_i_tab.DELETE;

Line: 106

    G_view_proj_cr_tab.DELETE;

Line: 107

    G_view_proj_co_tab.DELETE;

Line: 108

    G_ci_type_tab.DELETE;

Line: 158

    G_proj_auth_tab.DELETE;

Line: 159

    G_view_proj_i_tab.DELETE;

Line: 160

    G_view_proj_cr_tab.DELETE;

Line: 161

    G_view_proj_co_tab.DELETE;

Line: 162

    G_ci_type_tab.DELETE;

Line: 166

    G_proj_auth_tab.DELETE;

Line: 167

    G_view_proj_i_tab.DELETE;

Line: 168

    G_view_proj_cr_tab.DELETE;

Line: 169

    G_view_proj_co_tab.DELETE;

Line: 170

    G_ci_type_tab.DELETE;

Line: 176

      p_privilege => 'PA_CI_UPDATE',
      p_object_name => 'PA_PROJECTS',
      p_object_key => p_project_id);

Line: 200

    G_proj_auth_tab.DELETE;

Line: 201

    G_view_proj_i_tab.DELETE;

Line: 202

    G_view_proj_cr_tab.DELETE;

Line: 203

    G_view_proj_co_tab.DELETE;

Line: 204

    G_ci_type_tab.DELETE;

Line: 208

  SELECT s.project_system_status_code, ci.owner_id, ci.created_by
  INTO l_status_code, l_owner_party_id, l_creator_user_id
  FROM pa_control_items ci,
       pa_project_statuses s
  WHERE ci.ci_id = p_ci_id
    AND s.status_type = 'CONTROL_ITEM'
    AND s.project_status_code = ci.status_code;

Line: 234

  SELECT ci.project_id, s.project_system_status_code
  INTO l_project_id, l_status_code
  FROM pa_control_items ci,
       pa_project_statuses s
  WHERE ci.ci_id = p_ci_id
    AND s.status_type = 'CONTROL_ITEM'
    AND s.project_status_code = ci.status_code;

Line: 253

      SELECT 1
      INTO l_tmp
      FROM pa_ci_actions a
      WHERE a.ci_id = p_ci_id
        AND a.assigned_to = G_party_id
        AND ROWNUM = 1;

Line: 295

      SELECT 1
      INTO l_tmp
      FROM pa_ci_actions a
      WHERE a.ci_id = p_ci_id
        AND a.assigned_to = G_party_id
        AND ROWNUM = 1;

Line: 310

FUNCTION check_update_access(
  p_ci_id NUMBER,
  p_user_id NUMBER DEFAULT fnd_global.user_id,
  p_resp_id NUMBER DEFAULT fnd_global.resp_id)
RETURN VARCHAR2
IS
  l_tmp NUMBER;

Line: 324

select nvl(locked_flag,'N')
INTO l_locked_flag
from pa_control_items
where ci_id = p_ci_id;

Line: 333

  SELECT ci.project_id, ppa.org_id
  INTO l_project_id, l_project_org_id
  FROM pa_control_items ci,
       pa_projects_all ppa
  WHERE ppa.project_id=ci.project_id
    AND ci.ci_id=p_ci_id;

Line: 355

    SELECT 1
    INTO l_tmp
    FROM pa_ci_actions a,
         pa_project_statuses s
    WHERE a.ci_id = p_ci_id
      AND s.project_status_code = a.status_code
      AND s.status_type = 'CI_ACTION'
      AND s.project_system_status_code = 'CI_ACTION_OPEN'
      AND a.type_code = 'UPDATE'
--      AND a.assigned_to = pa_control_items_utils.getPartyId(p_user_id)
      AND a.assigned_to = G_party_id
      AND ROWNUM = 1;

Line: 377

FUNCTION check_update_access1(
  p_ci_id NUMBER,
  p_project_id NUMBER,
  p_proj_org_id NUMBER,
  p_user_id NUMBER DEFAULT fnd_global.user_id,
  p_resp_id NUMBER DEFAULT fnd_global.resp_id)
RETURN VARCHAR2
IS
  l_tmp NUMBER;

Line: 390

  SELECT ci.project_id, ppa.org_id
  INTO l_project_id, l_project_org_id
  FROM pa_control_items ci,
       pa_projects_all ppa
  WHERE ppa.project_id=ci.project_id
    AND ci.ci_id=p_ci_id;

Line: 416

    SELECT 1
    INTO l_tmp
    FROM pa_ci_actions a,
         pa_project_statuses s
    WHERE a.ci_id = p_ci_id
      AND s.project_status_code = a.status_code
      AND s.status_type = 'CI_ACTION'
      AND s.project_system_status_code = 'CI_ACTION_OPEN'
      AND a.type_code = 'UPDATE'
--      AND a.assigned_to = pa_control_items_utils.getPartyId(p_user_id)
      AND a.assigned_to = G_party_id
      AND ROWNUM = 1;

Line: 448

  SELECT ci.project_id, ppa.org_id
  INTO l_project_id, l_project_org_id
  FROM pa_control_items ci, pa_projects_all ppa
  WHERE ci.project_id=ppa.project_id
    AND ci.ci_id = p_ci_id;

Line: 493

    SELECT project_id
    INTO l_project_id
    FROM pa_control_items
    WHERE ci_id = p_ci_id;

Line: 533

    select a.ci_action_id
    from pa_ci_actions a,
         pa_project_statuses s
    where a.assigned_to = l_party_id
    and a.ci_id = p_ci_id
    and s.project_status_code = a.status_code
    AND s.status_type = 'CI_ACTION'
    and s.project_system_status_code = 'CI_ACTION_OPEN';

Line: 559

  SELECT ci.project_id, ppa.org_id
  INTO l_project_id, l_project_org_id
  FROM pa_control_items ci, pa_projects_all ppa
  WHERE ci.project_id=ppa.project_id
    AND ci.ci_id = p_ci_id;

Line: 598

  SELECT ci.project_id, ppa.org_id
  INTO l_project_id, l_project_org_id
  FROM pa_control_items ci, pa_projects_all ppa
  WHERE ci.project_id=ppa.project_id
    AND ci.ci_id = p_ci_id;

Line: 629

    select 'T'
    from pa_ci_actions a,
         pa_project_statuses s
    where a.ci_action_id = p_ci_action_id
    and a.assigned_to = l_party_id
    and s.project_status_code = a.status_code
    AND s.status_type = 'CI_ACTION'
    and s.project_system_status_code = 'CI_ACTION_OPEN';

Line: 669

    select ci_id, created_by
    from pa_ci_comments
    where ci_comment_id = p_ci_comment_id;

Line: 710

	SELECT org_id  INTO  l_project_org_id
	FROM  pa_projects_all  WHERE project_id=p_project_id;

Line: 726

    G_proj_auth_tab.DELETE;

Line: 727

    G_view_proj_i_tab.DELETE;

Line: 728

    G_view_proj_cr_tab.DELETE;

Line: 729

    G_view_proj_co_tab.DELETE;

Line: 730

    G_ci_type_tab.DELETE;

Line: 733

    G_ci_type_tab.DELETE;

Line: 740

  SELECT allow_all_usage_flag
  INTO l_allow_all_usage_flag
  FROM pa_ci_types_b
  WHERE ci_type_id = p_ci_type_id;

Line: 747

      SELECT 1
      INTO l_tmp
      FROM pa_ci_type_usage citu,
           pa_projects_all ppa,
           pa_project_types_all ppt
      WHERE ppa.project_id = p_project_id
        AND ppt.project_type = ppa.project_type
        AND citu.project_type_id = ppt.project_type_id
        AND citu.ci_type_id = p_ci_type_id
        AND ROWNUM = 1;

Line: 772

    SELECT 1
    INTO l_tmp
    FROM pa_object_dist_lists l,
         pa_dist_list_items i,
         pa_project_parties p
    WHERE l.object_type = 'PA_CI_TYPES'
      AND l.object_id = p_ci_type_id
      AND i.list_id = l.list_id
      AND p.project_id = p_project_id
      AND p.resource_id = l_resource_id
      AND (   i.recipient_type = 'ALL_PROJECT_PARTIES'
           OR (    i.recipient_type = 'PROJECT_ROLE'
               AND p.project_role_id = i.recipient_id
              )
          )/*added the condition for bug#12847813*/
and sysdate between p.start_date_active and nvl(p.end_date_active,
sysdate+1)
      AND ROWNUM = 1;

Line: 813

   select distinct resource_party_id
     from PA_PROJECT_PARTIES_V
    where party_type <> 'ORGANIZATION'
      and project_id = p_project_id
      and resource_party_id = p_owner_id;

Line: 821

  SELECT project_id
  INTO l_project_id
  FROM pa_control_items
  WHERE ci_id = p_ci_id;

Line: 860

  select a.responsibility_id, c.application_id,
         b.responsibility_key, c.application_short_name
  from fnd_user_resp_groups_all a,
       fnd_responsibility_vl b,
       fnd_application c
  where a.user_id = p_user_id
    and sysdate between NVL(a.start_date,sysdate) and NVL(a.end_date,sysdate)
    and a.responsibility_id = b.responsibility_id
    and a.responsibility_application_id = b.application_id
    and b.application_id = c.application_id;