APPS.HZ_DSS_UTIL_PUB dependencies on HZ_DSS_SECURED_ENTITIES

Line 330: l_security_scheme_code hz_dss_secured_entities.dss_group_code%type;

326:
327: l_menu_id NUMBER;
328: l_function_id NUMBER;
329: l_exists VARCHAR2(1);
330: l_security_scheme_code hz_dss_secured_entities.dss_group_code%type;
331: l_object_instance_set_id hz_dss_secured_entities.dss_instance_set_id%type;
332:
333: i BINARY_INTEGER;
334:

Line 331: l_object_instance_set_id hz_dss_secured_entities.dss_instance_set_id%type;

327: l_menu_id NUMBER;
328: l_function_id NUMBER;
329: l_exists VARCHAR2(1);
330: l_security_scheme_code hz_dss_secured_entities.dss_group_code%type;
331: l_object_instance_set_id hz_dss_secured_entities.dss_instance_set_id%type;
332:
333: i BINARY_INTEGER;
334:
335: cursor c_fn_menu_op(t_operation_code IN VARCHAR2) IS

Line 363: from hz_dss_secured_entities

359:
360:
361: cursor c_get_dss_groups(t_object_instance_set_id IN NUMBER) IS
362: select dss_group_code, entity_id
363: from hz_dss_secured_entities
364: where dss_instance_set_id = t_object_instance_set_id
365: and status = 'A';
366:
367:

Line 543: hz_dss_secured_entities se,

539: SELECT obj.object_id, obj.obj_name, null instance_set_id, null instance_set_name,
540: obj.pk1_column_name, obj.pk2_column_name, null predicate,
541: dsg.dss_group_code, dsg.rank
542: FROM hz_dss_entities dse,
543: hz_dss_secured_entities se,
544: hz_dss_groups_b dsg,
545: fnd_objects obj
546: WHERE obj.database_object_name = p_db_object_name
547: AND dse.object_id IS NOT NULL

Line 559: hz_dss_secured_entities se,

555: SELECT obj.object_id, obj.obj_name, ins.instance_set_id, ins.instance_set_name,
556: obj.pk1_column_name, obj.pk2_column_name, ins.predicate,
557: dsg.dss_group_code, dsg.rank
558: FROM hz_dss_entities dse,
559: hz_dss_secured_entities se,
560: hz_dss_groups_b dsg,
561: fnd_objects obj,
562: fnd_object_instance_sets ins
563: WHERE obj.database_object_name = p_db_object_name

Line 994: l_dsg_code hz_dss_secured_entities.dss_group_code%type;

990: l_pk2_column_name fnd_objects.pk2_column_name%type;
991: l_parent_fk_column1 hz_dss_entities.parent_fk_column1%type;
992: l_parent_fk_column2 hz_dss_entities.parent_fk_column2%type;
993: l_group_assignment_level hz_dss_entities.group_assignment_level%type;
994: l_dsg_code hz_dss_secured_entities.dss_group_code%type;
995: l_sql varchar2(2000);
996:
997:
998: x_assignment_id NUMBER;