APPS.PA_CI_SECURITY_PKG SQL Statements

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

Line: 28

    G_proj_auth_tab.DELETE;

Line: 29

    G_view_proj_i_tab.DELETE;

Line: 30

    G_view_proj_cr_tab.DELETE;

Line: 31

    G_view_proj_co_tab.DELETE;

Line: 32

    G_ci_type_tab.DELETE;

Line: 35

    G_proj_auth_tab.DELETE;

Line: 36

    G_view_proj_i_tab.DELETE;

Line: 37

    G_view_proj_cr_tab.DELETE;

Line: 38

    G_view_proj_co_tab.DELETE;

Line: 39

    G_ci_type_tab.DELETE;

Line: 42

  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: 95

    G_proj_auth_tab.DELETE;

Line: 96

    G_view_proj_i_tab.DELETE;

Line: 97

    G_view_proj_cr_tab.DELETE;

Line: 98

    G_view_proj_co_tab.DELETE;

Line: 99

    G_ci_type_tab.DELETE;

Line: 102

    G_proj_auth_tab.DELETE;

Line: 103

    G_view_proj_i_tab.DELETE;

Line: 104

    G_view_proj_cr_tab.DELETE;

Line: 105

    G_view_proj_co_tab.DELETE;

Line: 106

    G_ci_type_tab.DELETE;

Line: 156

    G_proj_auth_tab.DELETE;

Line: 157

    G_view_proj_i_tab.DELETE;

Line: 158

    G_view_proj_cr_tab.DELETE;

Line: 159

    G_view_proj_co_tab.DELETE;

Line: 160

    G_ci_type_tab.DELETE;

Line: 164

    G_proj_auth_tab.DELETE;

Line: 165

    G_view_proj_i_tab.DELETE;

Line: 166

    G_view_proj_cr_tab.DELETE;

Line: 167

    G_view_proj_co_tab.DELETE;

Line: 168

    G_ci_type_tab.DELETE;

Line: 174

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

Line: 198

    G_proj_auth_tab.DELETE;

Line: 199

    G_view_proj_i_tab.DELETE;

Line: 200

    G_view_proj_cr_tab.DELETE;

Line: 201

    G_view_proj_co_tab.DELETE;

Line: 202

    G_ci_type_tab.DELETE;

Line: 206

  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: 232

  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: 251

      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: 293

      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: 308

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: 318

  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: 340

    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: 362

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: 375

  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: 401

    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: 433

  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: 476

    SELECT project_id
    INTO l_project_id
    FROM pa_control_items
    WHERE ci_id = p_ci_id;

Line: 516

    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: 542

  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: 581

  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: 612

    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: 652

    select ci_id, created_by
    from pa_ci_comments
    where ci_comment_id = p_ci_comment_id;

Line: 697

    G_proj_auth_tab.DELETE;

Line: 698

    G_view_proj_i_tab.DELETE;

Line: 699

    G_view_proj_cr_tab.DELETE;

Line: 700

    G_view_proj_co_tab.DELETE;

Line: 701

    G_ci_type_tab.DELETE;

Line: 704

    G_ci_type_tab.DELETE;

Line: 711

  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: 718

      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: 743

    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
              )
          )
      AND ROWNUM = 1;

Line: 782

   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: 790

  SELECT project_id
  INTO l_project_id
  FROM pa_control_items
  WHERE ci_id = p_ci_id;