APPS.CZ_SECURITY_PVT dependencies on FND_OBJECTS

Line 156: FROM fnd_objects

152:
153: BEGIN
154: SELECT object_id
155: INTO l_object_id
156: FROM fnd_objects
157: WHERE obj_name = UPPER(p_entity_type);
158: RETURN l_object_id;
159: EXCEPTION
160: WHEN NO_DATA_FOUND THEN

Line 238: CURSOR C1 IS SELECT obj_name from fnd_objects;

234: END GET_CZ_ACCESS_SUMMARY ;
235: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
236: PROCEDURE create_grants_on_models_v
237: AS
238: CURSOR C1 IS SELECT obj_name from fnd_objects;
239: l_column_name fnd_objects.obj_name%TYPE;
240: l_execute_str VARCHAR2(2000);
241:
242: BEGIN

Line 239: l_column_name fnd_objects.obj_name%TYPE;

235: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
236: PROCEDURE create_grants_on_models_v
237: AS
238: CURSOR C1 IS SELECT obj_name from fnd_objects;
239: l_column_name fnd_objects.obj_name%TYPE;
240: l_execute_str VARCHAR2(2000);
241:
242: BEGIN
243: l_execute_str := 'CREATE OR REPLACE VIEW CZ_GRANTS_ON_MODELS as SELECT model_id, object_name as model_name,';

Line 379: ----get object id from fnd_objects

375: ELSE
376: RAISE INVALID_ROLE;
377: END IF;
378:
379: ----get object id from fnd_objects
380: l_object_id := get_object_id(l_entity_type);
381: IF (l_object_id = 0) THEN
382: RAISE OBJECT_ID_NOT_FOUND;
383: END IF;

Line 635: ----@p_entity_type : Fnd_objects.obj_name ex MODEL, UI RULEFOLDER

631: --------check privilege
632: ----@p_api_version : api version current version is 1.0
633: ----@p_user_name : fnd user ex: OPERATIONS
634: ----@p_function_name : fnd function , function name of the task
635: ----@p_entity_type : Fnd_objects.obj_name ex MODEL, UI RULEFOLDER
636: ----for the above use global constants
637: ----@p_instance_pk1_value : primary key of the object ex devl_project_id or rule_folder_id
638: FUNCTION has_privileges (p_api_version IN NUMBER,
639: p_user_name IN VARCHAR2,