APPS.MSC_ORG_SECURITY SQL Statements

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

Line: 4

                      p_selected_orgs      IN  varchar2
                     ,p_resp_id            IN  varchar2
		     ,p_more_orgs          IN NUMBER DEFAULT NULL
                     ) IS
i number := 1;

Line: 23

     select organization_id, sr_instance_id
     from msc_selected_orgs_v mso
      where mso.responsibility_id = p_resp_id;

Line: 30

     select organization_id
       from msc_selected_orgs_v mso
      where mso.responsibility_id   = trim(p_resp_id)
        and mso.organization_id     = lorg_id
        and mso.sr_instance_id      = linst_id;

Line: 40

     select 1
       from msc_org_access
      where responsibility_id     = to_number(trim(p_resp_id))
        and organization_id     = lorg_id1
        and sr_instance_id      = linst_id1;

Line: 46

   select count(*)
       from msc_org_access
      where responsibility_id     = to_number(trim(p_resp_id))
      and sysdate <= nvl(effective_to_date,sysdate)
;

Line: 55

     IF p_more_orgs IS NULL or p_more_orgs=-1 THEN -- this parameter will be -1, if the length of p_selected_orgs is < 20000
    OPEN current_orgs (p_resp_id);

Line: 68

       if instr(p_selected_orgs, org_inst_id,1) = 0 then
            update_row(org_id,
                       inst_id,
                       to_number(p_resp_id),
                       724,
                       sysdate,
                       sysdate-1,
                       'REMOVE');

Line: 83

    v_len := length(p_selected_orgs);

Line: 86

      one_len := instr(p_selected_orgs,';',1,i+1)-

Line: 87

                          instr(p_selected_orgs,';',1 ,i)-1;

Line: 89

      org_inst_id := trim(substr(p_selected_orgs,
                           instr(p_selected_orgs,';',1,i)+1,one_len));

Line: 119

           insert_row(org_id,
                      inst_id,
                      to_number(p_resp_id),
                      724,
                      sysdate,
                      to_date(null)
                     );

Line: 128

           update_row( org_id1,
                       inst_id1,
                       to_number(p_resp_id),
                       724,
                       sysdate,
                       to_date(null),
                       'ADD'
                      );

Line: 151

                              'p_selected_orgs =>' || p_selected_orgs ||'  ' ||
                              'p_resp_id=>' || p_resp_id);

Line: 163

select resp.responsibility_id
from fnd_responsibility_tl resp
where resp.responsibility_name = p_resp;

Line: 181

procedure insert_row (p_organization_id in number,
                      p_sr_instance_id  in number,
                      p_responsibility_id in number,
                      p_resp_appl_id in number,
                      p_eff_from_date in date,
                      p_eff_to_date in date)

is
v_statement varchar2(4000);

Line: 192

select application_id
from fnd_responsibility
where responsibility_id = p_responsibility_id;

Line: 206

 v_statement :=  'insert into msc_org_access(' ||
            'ORGANIZATION_ID' ||
           ',SR_INSTANCE_ID' ||
           ',RESPONSIBILITY_ID' ||
           ',RESP_APPLICATION_ID' ||
           ',EFFECTIVE_FROM_DATE' ||
           ',EFFECTIVE_TO_DATE' ||
           ',LAST_UPDATE_DATE' ||
           ',LAST_UPDATED_BY' ||
           ',CREATION_DATE' ||
           ',CREATED_BY' ||
           ',LAST_UPDATE_LOGIN' ||
           ')'  ||
           'values ( ' ||
           ' :1' ||
           ',:2' ||
           ',:3' ||
           ',:4' ||
           ',:5' ||
           ',:6' ||
           ',:7' ||
           ',:8' ||
           ',:9' ||
           ',:10' ||
           ',:11' ||
           ')';

Line: 254

end insert_row;

Line: 256

procedure update_row (p_organization_id in number,
                      p_sr_instance_id  in number,
                      p_responsibility_id in number,
                      p_resp_appl_id in number,
                      p_eff_from_date in date,
                      p_eff_to_date in date,
                      p_action varchar2)

is
v_statement varchar2(2000);

Line: 268

select application_id
from fnd_responsibility
where responsibility_id = p_responsibility_id;

Line: 283

 v_statement :=  'update msc_org_access set' ;

Line: 290

           '    LAST_UPDATE_DATE = :3,' ||
           '    LAST_UPDATED_BY  = :4,' ||
           '    LAST_UPDATE_LOGIN= :5 ' ||
           'where responsibility_id = :6 and ' ||
                 'organization_id   = :7 and ' ||
                 'sr_instance_id    = :8 and ' ||
                 'resp_application_id = :9';

Line: 328

end update_row;