1 PACKAGE cz_pb_usg AUTHID CURRENT_USER AS
2 /* $Header: czpbusgs.pls 115.3 2002/11/27 17:09:51 askhacha ship $ */
3
4 TYPE USAGE_NAME_LIST IS TABLE OF cz_model_usages.name%TYPE INDEX BY BINARY_INTEGER;
5 TYPE t_ref IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6 TYPE rulesUsageType IS TABLE OF cz_rules.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
7
8 FUNCTION INVERT_MAP(usage_map IN VARCHAR2) return VARCHAR2;
9
10 FUNCTION MAP_LESS_USAGE_ID(usage_id IN NUMBER, usage_map IN VARCHAR2 )
11 RETURN VARCHAR2;
12
13 FUNCTION MAP_PLUS_USAGE_ID(usage_id IN NUMBER, usage_map IN VARCHAR2)
14 return VARCHAR2;
15
16
17 FUNCTION MAP_HAS_USAGE_ID(usage_id IN NUMBER, usage_map IN VARCHAR2 )
18 RETURN NUMBER;
19
20 PROCEDURE REMOVE_USAGE_ID(usage_id IN NUMBER,usage_map IN OUT NOCOPY VARCHAR2);
21
22 PROCEDURE ADD_USAGE_ID(usage_id IN NUMBER,usage_map IN OUT NOCOPY VARCHAR2);
23
24 FUNCTION MAP_HAS_USAGE_NAME(usage_name IN VARCHAR2,usage_map IN VARCHAR2)
25 RETURN NUMBER;
26
27 FUNCTION MAP_LESS_USAGE_NAME(usage_name IN VARCHAR2,usage_map IN VARCHAR2)
28 RETURN VARCHAR2;
29
30 PROCEDURE REMOVE_USAGE_NAME(usage_name IN VARCHAR2,usage_map IN OUT NOCOPY VARCHAR2);
31
32 FUNCTION MAP_PLUS_USAGE_NAME(usage_name IN VARCHAR2,usage_map IN VARCHAR2)
33 RETURN VARCHAR2;
34
35 PROCEDURE ADD_USAGE_BY_NAME(usage_name IN VARCHAR2, usage_map IN OUT NOCOPY VARCHAR2
36 );
37
38 FUNCTION LIST_USAGES_IN_MAP_STRING(usage_map IN VARCHAR2)
39 RETURN VARCHAR2;
40
41 FUNCTION LIST_USAGES_IN_MAP(usage_map IN VARCHAR2)
42 RETURN USAGE_NAME_LIST;
43
44 PROCEDURE DELETE_USAGE(usageId IN NUMBER,
45 delete_status IN OUT NOCOPY VARCHAR2);
46
47 END;