APPS.IGW_SECURITY SQL Statements

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

Line: 24

      SELECT proposal_status
      FROM   igw_proposals_all
      WHERE  proposal_id = p_proposal_id;

Line: 48

         SELECT distinct 'X'
         INTO   l_dummy
         FROM   igw_prop_user_roles ur,
                igw_role_rights     rr
         WHERE  ur.proposal_id = p_proposal_id
         AND    ur.user_id = p_user_id
         AND    rr.role_id = ur.role_id
         AND    rr.right_code in ('MODIFY_GENERAL');

Line: 65

         SELECT distinct 'X'
         INTO   l_dummy
         FROM   igw_prop_user_roles ur,
                igw_role_rights     rr
         WHERE  ur.proposal_id = p_proposal_id
         AND    ur.user_id = p_user_id
         AND    rr.role_id = ur.role_id
         AND    rr.right_code in ('MODIFY_BUDGET');

Line: 82

         SELECT distinct 'X'
         INTO   l_dummy
         FROM   igw_prop_user_roles ur,
                igw_role_rights     rr
         WHERE  ur.proposal_id = p_proposal_id
         AND    ur.user_id = p_user_id
         AND    rr.role_id = ur.role_id
         AND    rr.right_code in ('MODIFY_NARRATIVE');

Line: 99

         SELECT distinct 'X'
         INTO   l_dummy
         FROM   igw_prop_user_roles ur,
                igw_role_rights     rr
         WHERE  ur.proposal_id = p_proposal_id
         AND    ur.user_id = p_user_id
         AND    rr.role_id = ur.role_id
         AND    rr.right_code in ('MODIFY_CHECKLIST');

Line: 116

         SELECT distinct 'X'
         INTO   l_dummy
         FROM   igw_prop_user_roles ur,
                igw_role_rights     rr
         WHERE  ur.proposal_id = p_proposal_id
         AND    ur.user_id = p_user_id
         AND    rr.role_id = ur.role_id
         AND    rr.right_code in ('MODIFY_APPROVAL');

Line: 133

         SELECT distinct 'X'
         INTO   l_dummy
         FROM   igw_prop_user_roles ur,
                igw_role_rights     rr
         WHERE  ur.proposal_id = p_proposal_id
         AND    ur.user_id = p_user_id
         AND    rr.role_id = ur.role_id
         AND    rr.right_code in ('MODIFY_SPONSOR_ACTION');

Line: 150

         SELECT distinct 'X'
         INTO   l_dummy
         FROM   igw_prop_user_roles ur,
                igw_role_rights     rr
         WHERE  ur.proposal_id = p_proposal_id
         AND    ur.user_id = p_user_id
         AND    rr.role_id = ur.role_id
         AND    rr.right_code in ('MODIFY_AWARD');

Line: 167

         SELECT distinct 'X'
         INTO   l_dummy
         FROM   igw_prop_user_roles ur,
                igw_role_rights     rr
         WHERE  ur.proposal_id = p_proposal_id
         AND    ur.user_id = p_user_id
         AND    rr.role_id = ur.role_id
         AND    rr.right_code in ('PRINT_PROPOSAL');

Line: 214

    select distinct 'X'
    into l_dummy
    from igw_prop_user_roles ppur,
         igw_role_rights     prr
    where  ppur.role_id = prr.role_id
    and    ppur.proposal_id = p_proposal_id
    and    ppur.user_id = p_user_id
    and    prr.right_code in
           ('VIEW_PROPOSAL','MODIFY_GENERAL','MODIFY_BUDGET',
            'MODIFY_NARRATIVE','MODIFY_CHECKLIST','MODIFY_APPROVAL',
            'MODIFY_SPONSOR_ACTION','MODIFY_AWARD');