DBA Data[Home] [Help]

APPS.QP_SECURITY dependencies on MO_GLOBAL

Line 165: or (cp_mo_access_mode = 'M' and mo_global.check_access(g.grantee_id) = 'Y')

161: ( g.grantee_type = 'GLOBAL' AND
162: g.grantee_id = -1) OR
163: ( g.grantee_type = 'OU' AND
164: ((cp_mo_access_mode = 'S' and g.grantee_id = sys_context('multi_org2','current_org_id'))
165: or (cp_mo_access_mode = 'M' and mo_global.check_access(g.grantee_id) = 'Y')
166: or (cp_mo_access_mode = 'A')))
167: -- g.grantee_id = cp_org_id)
168: ) AND
169: g.menu_id IN

Line 179: l_mo_access_mode := MO_GLOBAL.get_access_mode;

175: AND g.start_date <= l_sysdate;
176:
177: BEGIN
178: --added for moac
179: l_mo_access_mode := MO_GLOBAL.get_access_mode;
180:
181: -- the global_flag in qp_list_headers_b table is for run-time engine use
182: -- only. For setup time, we use 'GLOBAL' as a grantee, and if a pricing
183: -- entity is granted to 'GLOBAL' with a specific function, it becomes

Line 1130: (mo_global.get_access_mode = 'S' and sys_context('multi_org2', 'current_org_id') = g.grantee_id)

1126: g.grantee_id = cp_resp_id) OR
1127: ( g.grantee_type = 'GLOBAL' AND
1128: g.grantee_id = -1) OR
1129: ( g.grantee_type = 'OU' AND
1130: (mo_global.get_access_mode = 'S' and sys_context('multi_org2', 'current_org_id') = g.grantee_id)
1131: OR (mo_global.get_access_mode = 'A')
1132: OR (mo_global.get_access_mode = 'M' and mo_global.check_access(g.grantee_id) = 'Y'))
1133: ) AND
1134: g.menu_id IN

Line 1131: OR (mo_global.get_access_mode = 'A')

1127: ( g.grantee_type = 'GLOBAL' AND
1128: g.grantee_id = -1) OR
1129: ( g.grantee_type = 'OU' AND
1130: (mo_global.get_access_mode = 'S' and sys_context('multi_org2', 'current_org_id') = g.grantee_id)
1131: OR (mo_global.get_access_mode = 'A')
1132: OR (mo_global.get_access_mode = 'M' and mo_global.check_access(g.grantee_id) = 'Y'))
1133: ) AND
1134: g.menu_id IN
1135: (select cmf.menu_id

Line 1132: OR (mo_global.get_access_mode = 'M' and mo_global.check_access(g.grantee_id) = 'Y'))

1128: g.grantee_id = -1) OR
1129: ( g.grantee_type = 'OU' AND
1130: (mo_global.get_access_mode = 'S' and sys_context('multi_org2', 'current_org_id') = g.grantee_id)
1131: OR (mo_global.get_access_mode = 'A')
1132: OR (mo_global.get_access_mode = 'M' and mo_global.check_access(g.grantee_id) = 'Y'))
1133: ) AND
1134: g.menu_id IN
1135: (select cmf.menu_id
1136: from fnd_compiled_menu_functions cmf

Line 1219: l_access_mode := MO_GLOBAL.get_access_mode;

1215: IS
1216: l_access_mode VARCHAR2(10);
1217: BEGIN
1218:
1219: l_access_mode := MO_GLOBAL.get_access_mode;
1220:
1221: -- IF PRICING SECURITY IS ON
1222: -- Returns different predicates based on the access_mode
1223: -- The codes for access_mode are