APPS.MSC_ORG_SECURITY dependencies on MSC_ORG_ACCESS

Line 41: from msc_org_access

37: CURSOR record_exists_c(
38: lorg_id1 number,
39: linst_id1 number) IS
40: select 1
41: from msc_org_access
42: where responsibility_id = to_number(trim(p_resp_id))
43: and organization_id = lorg_id1
44: and sr_instance_id = linst_id1;
45: cursor cur_rec_count is

Line 47: from msc_org_access

43: and organization_id = lorg_id1
44: and sr_instance_id = linst_id1;
45: cursor cur_rec_count is
46: select count(*)
47: from msc_org_access
48: where responsibility_id = to_number(trim(p_resp_id))
49: and sysdate <= nvl(effective_to_date,sysdate)
50: ;
51: l_dummy number;

Line 206: v_statement := 'insert into msc_org_access(' ||

202: if (l_resp_appl_id is null) then
203: l_resp_appl_id := p_resp_appl_id;
204: end if;
205:
206: v_statement := 'insert into msc_org_access(' ||
207: 'ORGANIZATION_ID' ||
208: ',SR_INSTANCE_ID' ||
209: ',RESPONSIBILITY_ID' ||
210: ',RESP_APPLICATION_ID' ||

Line 283: v_statement := 'update msc_org_access set' ;

279: if (l_resp_appl_id is null) then
280: l_resp_appl_id := p_resp_appl_id;
281: end if;
282:
283: v_statement := 'update msc_org_access set' ;
284: if p_action = 'ADD' then
285: v_statement := v_statement ||' effective_from_date= :1,';
286: end if;
287: