[Home] [Help]
948: ---------------------------------------------------------------------------------------
949: FUNCTION COMPATIBLE_DATA_TYPES(p_object_type IN PLS_INTEGER, p_subject_type PLS_INTEGER) RETURN BOOLEAN IS
950: v_null PLS_INTEGER;
951: BEGIN
952: SELECT NULL INTO v_null FROM cz_conversion_rels_v
953: WHERE object_type = p_object_type AND subject_type = p_subject_type;
954: RETURN TRUE;
955: EXCEPTION
956: WHEN NO_DATA_FOUND THEN
997: v_data_type := GET_ARGUMENT_INFO(v_tExprParamIndex(j), v_tExprParSignature(j), v_mutable, v_collection);
998:
999: SELECT NULL INTO v_null
1000: FROM cz_rul_typedpsn_v psn,
1001: cz_conversion_rels_v cnv,
1002: cz_system_property_rels_v rel,
1003: cz_system_properties_v sys,
1004: cz_conversion_rels_v cnv2
1005: WHERE psn.detailed_type_id = cnv.object_type
1000: FROM cz_rul_typedpsn_v psn,
1001: cz_conversion_rels_v cnv,
1002: cz_system_property_rels_v rel,
1003: cz_system_properties_v sys,
1004: cz_conversion_rels_v cnv2
1005: WHERE psn.detailed_type_id = cnv.object_type
1006: AND cnv.subject_type = rel.subject_type
1007: AND rel.object_type = sys.rule_id
1008: AND rel.rel_type_code = 'SYS'
1041: v_data_type := GET_ARGUMENT_INFO(v_tExprParamIndex(j), v_tExprParSignature(j), v_mutable, v_collection);
1042:
1043: SELECT NULL INTO v_null
1044: FROM cz_rul_typedpsn_v psn,
1045: cz_conversion_rels_v cnv,
1046: cz_system_property_rels_v rel,
1047: cz_system_properties_v sys,
1048: cz_conversion_rels_v cnv2
1049: WHERE psn.detailed_type_id = cnv.object_type
1044: FROM cz_rul_typedpsn_v psn,
1045: cz_conversion_rels_v cnv,
1046: cz_system_property_rels_v rel,
1047: cz_system_properties_v sys,
1048: cz_conversion_rels_v cnv2
1049: WHERE psn.detailed_type_id = cnv.object_type
1050: AND cnv.subject_type = rel.subject_type
1051: AND rel.object_type = sys.rule_id
1052: AND rel.rel_type_code = 'SYS'