APPS.QP_SECURITY dependencies on FND_GRANTS

Line 260: /* check fnd_grants table and see the access_role for the object

256: WHEN NO_DATA_FOUND THEN
257: RETURN G_DENIED;
258: END;
259:
260: /* check fnd_grants table and see the access_role for the object
261: instead of calling FND_DATA_SECURITY.check_function,
262: call get_security_predicate() could improve performance
263: */
264: FND_MSG_PUB.initialize;

Line 324: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;

320: p_user_name IN VARCHAR2 default G_USER_NAME,
321: p_resp_id IN NUMBER default G_RESP_ID,
322: p_org_id IN NUMBER default G_ORG_ID
323: ) RETURN system.qp_inst_pk_vals IS
324: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
325: l_instance_pk2_value fnd_grants.instance_pk2_value%TYPE;
326: l_instance_pk_values system.qp_inst_pk_vals := system.qp_inst_pk_vals();
327: TYPE qp_inst_pk_vals_cur_type IS REF CURSOR;
328: qp_inst_pk_vals_cur qp_inst_pk_vals_cur_type;

Line 325: l_instance_pk2_value fnd_grants.instance_pk2_value%TYPE;

321: p_resp_id IN NUMBER default G_RESP_ID,
322: p_org_id IN NUMBER default G_ORG_ID
323: ) RETURN system.qp_inst_pk_vals IS
324: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
325: l_instance_pk2_value fnd_grants.instance_pk2_value%TYPE;
326: l_instance_pk_values system.qp_inst_pk_vals := system.qp_inst_pk_vals();
327: TYPE qp_inst_pk_vals_cur_type IS REF CURSOR;
328: qp_inst_pk_vals_cur qp_inst_pk_vals_cur_type;
329: err_msg varchar2(256);

Line 587: -- check fnd_grants SET table to get all list_header_ids which

583: CLOSE l_grants_entities_id_cur;
584: END IF;
585:
586: ----------------------------------------------------------------------
587: -- check fnd_grants SET table to get all list_header_ids which
588: -- can be accessed
589: ------------------------------------------------------------------------
590: --get database_object_name and primary key column name from FND_OBJECTS
591: SELECT database_object_name,