The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT responsibility_id INTO v_resp_id
FROM fnd_responsibility
WHERE responsibility_key = 'GMD_SECURITY_PROFILE_MGR';
' EXISTS ( SELECT 1 '||
' FROM gmd_security_profiles sp '||
' WHERE sp.assign_method_ind = ''A'' '||
' AND ( ( sp.user_id = fnd_profile.value(''GMD_DEFAULT_USER'') '||
' OR sp.user_id = fnd_global.user_id '||
' ) '||
' OR ( EXISTS ( SELECT rg.responsibility_id '||
' FROM FND_USER_RESP_GROUPS rg '||
' WHERE rg.user_id = fnd_global.user_id '||
' AND sp.responsibility_id = rg.responsibility_id '||
' AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE) '||
' ) '||
' ) '||
' ) '||
' AND ( EXISTS ( SELECT NULL '||
' FROM org_access a1 '||
' WHERE ( ( sp.organization_id = a1.organization_id '||
' AND sp.other_organization_id IS NULL '||
' ) '||
' OR sp.other_organization_id = a1.organization_id '||
' ) '||
' AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE '||
' AND a1.resp_application_id = fnd_global.resp_appl_id '||
' AND a1.responsibility_id = fnd_global.resp_id '||
' ) '||
' OR '||
' NOT EXISTS ( SELECT NULL '||
' FROM org_access a2 '||
' WHERE ( ( sp.organization_id = a2.organization_id '||
' AND sp.other_organization_id IS NULL '||
' ) '||
' OR sp.other_organization_id = a2.organization_id '||
' ) '||
' AND NVL(a2.disable_date, SYSDATE+1) >=SYSDATE '||
' ) '||
' ) '||
' AND sp.organization_id = '||obj_name||'.owner_organization_id '||
' ) '||
' OR EXISTS ( SELECT 1 '||
' FROM gmd_formula_security fs '||
' WHERE ( ( fs.user_id = fnd_profile.value(''GMD_DEFAULT_USER'') '||
' OR fs.user_id = fnd_global.user_id '||
' ) '||
' OR ( EXISTS ( SELECT rg.responsibility_id '||
' FROM FND_USER_RESP_GROUPS rg '||
' WHERE rg.user_id = fnd_global.user_id '||
' AND fs.responsibility_id = rg.responsibility_id '||
' AND SYSDATE BETWEEN rg.start_date '||
' AND NVL(rg.end_date, SYSDATE) '||
' ) '||
' ) '||
' ) '||
' AND (EXISTS ( SELECT NULL '||
' FROM org_access ou '||
' WHERE ( ( fs.organization_id = ou.organization_id '||
' AND fs.other_organization_id IS NULL '||
' ) '||
' OR fs.other_organization_id = ou.organization_id '||
' ) '||
' AND NVL(ou.disable_date, SYSDATE+1) >= SYSDATE '||
' AND ou.resp_application_id = fnd_global.resp_appl_id '||
' AND ou.responsibility_id = fnd_global.resp_id '||
' ) '||
' OR '||
' NOT EXISTS ( SELECT NULL '||
' FROM org_access ou1 '||
' WHERE ( ( ou1.organization_id = fs.organization_id '||
' AND fs.other_organization_id IS NULL '||
' ) '||
' OR ou1.organization_id = fs.other_organization_id '||
' ) '||
' AND NVL(ou1.disable_date, SYSDATE+1) >=SYSDATE '||
' ) '||
' ) '||
' AND fs.formula_id = ' ||obj_name||'.formula_id '||
' ) ';
' EXISTS ( SELECT 1 '||
' FROM gmd_security_profiles sp '||
' WHERE sp.access_type_ind = ''U'' '||
' AND ( responsibility_id IN ( SELECT rg.responsibility_id '||
' FROM FND_USER_RESP_GROUPS rg '||
' WHERE rg.user_id = fnd_global.user_id '||
' AND SYSDATE BETWEEN rg.start_date '||
' AND NVL(rg.end_date, SYSDATE) '||
' ) '||
' OR ( sp.user_id = fnd_profile.value_specific(''GMD_DEFAULT_USER'') '||
' OR sp.user_id = fnd_global.user_id '||
' ) '||
' ) '||
' AND organization_id = '||obj_name||'.owner_organization_id '||
' AND (other_organization_id IS NULL '||
' OR EXISTS ( SELECT NULL '||
' FROM org_access a3 '||
' WHERE a3.organization_id = sp.other_organization_id '||
' AND NVL(a3.disable_date, SYSDATE+1) >= SYSDATE '||
' AND a3.resp_application_id = fnd_global.resp_appl_id '||
' AND a3.responsibility_id = fnd_global.resp_id '||
' ) '||
' OR NOT EXISTS ( SELECT NULL '||
' FROM org_access a4 '||
' WHERE a4.organization_id = sp.other_organization_id '||
' AND NVL(a4.disable_date, SYSDATE+1) >=SYSDATE '||
' ) '||
' ) '||
' ) ';
' ( SELECT 1 '||
' FROM gmd_security_profiles sp '||
' WHERE sp.access_type_ind = ''U'' '||
' AND ( responsibility_id IN ( SELECT rg.responsibility_id '||
' FROM FND_USER_RESP_GROUPS rg '||
' WHERE rg.user_id = fnd_global.user_id '||
' AND SYSDATE BETWEEN rg.start_date '||
' AND NVL(rg.end_date, SYSDATE) '||
' ) '||
' OR ( sp.user_id = fnd_profile.value_specific(''GMD_DEFAULT_USER'') '||
' OR sp.user_id = fnd_global.user_id '||
' ) '||
' ) '||
' AND organization_id = '||obj_name||'.organization_id '||
' AND (other_organization_id IS NULL '||
' OR EXISTS ( SELECT NULL '||
' FROM org_access a3 '||
' WHERE a3.organization_id = sp.other_organization_id '||
' AND NVL(a3.disable_date, SYSDATE+1) >= SYSDATE '||
' AND a3.resp_application_id = fnd_global.resp_appl_id '||
' AND a3.responsibility_id = fnd_global.resp_id '||
' ) '||
' OR NOT EXISTS ( SELECT NULL '||
' FROM org_access a4 '||
' WHERE a4.organization_id = sp.other_organization_id '||
' AND NVL(a4.disable_date, SYSDATE+1) >=SYSDATE '||
' ) '||
' ) '||
' ) ';
' ( SELECT 1 '||
' FROM gmd_security_profiles sp '||
' WHERE sp.assign_method_ind = ''A'' '||
' AND sp.access_type_ind = ''U'' '||
' AND (responsibility_id IN ( SELECT rg.responsibility_id '||
' FROM FND_USER_RESP_GROUPS rg '||
' WHERE rg.user_id = fnd_global.user_id '||
' AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE) '||
' ) '||
' OR ( sp.user_id = fnd_profile.value_specific(''GMD_DEFAULT_USER'') '||
' OR sp.user_id = fnd_global.user_id '||
' ) '||
' ) '||
' AND ( EXISTS ( SELECT NULL '||
' FROM org_access a1 '||
' WHERE ( ( sp.organization_id = a1.organization_id '||
' AND sp.other_organization_id IS NULL '||
' ) '||
' OR sp.other_organization_id = a1.organization_id '||
' ) '||
' AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE '||
' AND a1.resp_application_id = fnd_global.resp_appl_id '||
' AND a1.responsibility_id = fnd_global.resp_id '||
' ) '||
' OR '||
' NOT EXISTS ( SELECT NULL '||
' FROM org_access a2 '||
' WHERE ( ( sp.organization_id = a2.organization_id '||
' AND sp.other_organization_id IS NULL '||
' ) '||
' OR sp.other_organization_id = a2.organization_id '||
' ) '||
' AND NVL(a2.disable_date, SYSDATE+1) >=SYSDATE '||
' ) '||
' ) '||
' AND sp.organization_id = '||obj_name||'.owner_organization_id '||
' ) '||
' OR '||
' EXISTS '||
' ( SELECT 1 '||
' FROM gmd_formula_security fs '||
' WHERE fs.access_type_ind = ''U'' '||
' AND ( ( fs.user_id = fnd_profile.value(''GMD_DEFAULT_USER'') '||
' OR fs.user_id = fnd_global.user_id '||
' ) '||
' OR ( EXISTS ( SELECT rg.responsibility_id '||
' FROM FND_USER_RESP_GROUPS rg '||
' WHERE rg.user_id = fnd_global.user_id '||
' AND fs.responsibility_id = rg.responsibility_id '||
' AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE) '||
' ) '||
' ) '||
' ) '||
' AND ( EXISTS ( SELECT NULL '||
' FROM org_access ou '||
' WHERE ( ( fs.organization_id = ou.organization_id '||
' AND fs.other_organization_id IS NULL '||
' ) '||
' OR fs.other_organization_id = ou.organization_id '||
' ) '||
' AND NVL(ou.disable_date, SYSDATE+1) >= SYSDATE '||
' AND ou.resp_application_id = fnd_global.resp_appl_id '||
' AND ou.responsibility_id = fnd_global.resp_id '||
' ) '||
' OR '||
' NOT EXISTS ( SELECT NULL '||
' FROM org_access ou1 '||
' WHERE ( ( ou1.organization_id = fs.organization_id '||
' AND fs.other_organization_id IS NULL '||
' ) '||
' OR ou1.organization_id = fs.other_organization_id '||
' ) '||
' AND NVL(ou1.disable_date, SYSDATE+1) >=SYSDATE '||
' ) '||
' ) '||
' AND fs.formula_id = '||obj_name||'.formula_id '||
' ) ';
f_predicate := ' EXISTS ( SELECT 1 '||
' FROM fm_form_mst_b fm WHERE fm.formula_id = ' ||obj_name||'.formula_id )';
f_predicate := ' EXISTS (SELECT 1 FROM gmd_recipes_b WHERE recipe_id = '||obj_name||'.recipe_id)';