85:
86: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;
87: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE tArgumentName IS TABLE OF cz_signature_arguments.argument_name%TYPE INDEX BY BINARY_INTEGER;
90: TYPE tArgumentIndex IS TABLE OF cz_signature_arguments.argument_index%TYPE INDEX BY BINARY_INTEGER;
91: TYPE tDataType IS TABLE OF cz_signature_arguments.data_type%TYPE INDEX BY BINARY_INTEGER;
92:
93: commit_counter PLS_INTEGER := 0;
86: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;
87: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE tArgumentName IS TABLE OF cz_signature_arguments.argument_name%TYPE INDEX BY BINARY_INTEGER;
90: TYPE tArgumentIndex IS TABLE OF cz_signature_arguments.argument_index%TYPE INDEX BY BINARY_INTEGER;
91: TYPE tDataType IS TABLE OF cz_signature_arguments.data_type%TYPE INDEX BY BINARY_INTEGER;
92:
93: commit_counter PLS_INTEGER := 0;
94: CommitBlockSize PLS_INTEGER;
87: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE tArgumentName IS TABLE OF cz_signature_arguments.argument_name%TYPE INDEX BY BINARY_INTEGER;
90: TYPE tArgumentIndex IS TABLE OF cz_signature_arguments.argument_index%TYPE INDEX BY BINARY_INTEGER;
91: TYPE tDataType IS TABLE OF cz_signature_arguments.data_type%TYPE INDEX BY BINARY_INTEGER;
92:
93: commit_counter PLS_INTEGER := 0;
94: CommitBlockSize PLS_INTEGER;
95: OptimizeNotTrue PLS_INTEGER;
965: p_signature_id IN NUMBER,
966: x_mutable IN OUT NOCOPY VARCHAR2,
967: x_collection IN OUT NOCOPY VARCHAR2)
968: RETURN NUMBER IS
969: v_data_type cz_signature_arguments.data_type%TYPE;
970: BEGIN
971: SELECT data_type, mutable_flag, collection_flag INTO v_data_type, x_mutable, x_collection
972: FROM cz_signature_arguments
973: WHERE deleted_flag = FLAG_NOT_DELETED
968: RETURN NUMBER IS
969: v_data_type cz_signature_arguments.data_type%TYPE;
970: BEGIN
971: SELECT data_type, mutable_flag, collection_flag INTO v_data_type, x_mutable, x_collection
972: FROM cz_signature_arguments
973: WHERE deleted_flag = FLAG_NOT_DELETED
974: AND argument_signature_id = p_signature_id
975: AND argument_index = p_param_index;
976: RETURN v_data_type;
981: ---------------------------------------------------------------------------------------
982: FUNCTION APPLICABLE_SYS_PROP(j IN PLS_INTEGER, p_ps_node_id IN NUMBER, p_rule_id IN NUMBER) RETURN BOOLEAN IS
983: v_null PLS_INTEGER;
984: v_ps_node_id NUMBER;
985: v_data_type cz_signature_arguments.data_type%TYPE;
986: v_mutable cz_signature_arguments.mutable_flag%TYPE;
987: v_collection cz_signature_arguments.collection_flag%TYPE;
988: BEGIN
989:
982: FUNCTION APPLICABLE_SYS_PROP(j IN PLS_INTEGER, p_ps_node_id IN NUMBER, p_rule_id IN NUMBER) RETURN BOOLEAN IS
983: v_null PLS_INTEGER;
984: v_ps_node_id NUMBER;
985: v_data_type cz_signature_arguments.data_type%TYPE;
986: v_mutable cz_signature_arguments.mutable_flag%TYPE;
987: v_collection cz_signature_arguments.collection_flag%TYPE;
988: BEGIN
989:
990: --Some of the upgraded rules may not have param_index and param_signature_id populated. However, upgraded
983: v_null PLS_INTEGER;
984: v_ps_node_id NUMBER;
985: v_data_type cz_signature_arguments.data_type%TYPE;
986: v_mutable cz_signature_arguments.mutable_flag%TYPE;
987: v_collection cz_signature_arguments.collection_flag%TYPE;
988: BEGIN
989:
990: --Some of the upgraded rules may not have param_index and param_signature_id populated. However, upgraded
991: --rules are not real statement rules, so they are not supposed to have any user error in them and in this
1025: ---------------------------------------------------------------------------------------
1026: FUNCTION APPLICABLE_SYS_PROP(j IN PLS_INTEGER, p_ps_node_id IN NUMBER, p_rule_name IN VARCHAR2) RETURN BOOLEAN IS
1027: v_null PLS_INTEGER;
1028: v_ps_node_id NUMBER;
1029: v_data_type cz_signature_arguments.data_type%TYPE;
1030: v_mutable cz_signature_arguments.mutable_flag%TYPE;
1031: v_collection cz_signature_arguments.collection_flag%TYPE;
1032: BEGIN
1033:
1026: FUNCTION APPLICABLE_SYS_PROP(j IN PLS_INTEGER, p_ps_node_id IN NUMBER, p_rule_name IN VARCHAR2) RETURN BOOLEAN IS
1027: v_null PLS_INTEGER;
1028: v_ps_node_id NUMBER;
1029: v_data_type cz_signature_arguments.data_type%TYPE;
1030: v_mutable cz_signature_arguments.mutable_flag%TYPE;
1031: v_collection cz_signature_arguments.collection_flag%TYPE;
1032: BEGIN
1033:
1034: --Some of the upgraded rules may not have param_index and param_signature_id populated. However, upgraded
1027: v_null PLS_INTEGER;
1028: v_ps_node_id NUMBER;
1029: v_data_type cz_signature_arguments.data_type%TYPE;
1030: v_mutable cz_signature_arguments.mutable_flag%TYPE;
1031: v_collection cz_signature_arguments.collection_flag%TYPE;
1032: BEGIN
1033:
1034: --Some of the upgraded rules may not have param_index and param_signature_id populated. However, upgraded
1035: --rules are not real statement rules, so they are not supposed to have any user error in them and in this