[Home] [Help]
959: ---------------------------------------------------------------------------------------
960: FUNCTION COMPATIBLE_DATA_TYPES(p_object_type IN PLS_INTEGER, p_subject_type PLS_INTEGER) RETURN BOOLEAN IS
961: v_null PLS_INTEGER;
962: BEGIN
963: SELECT NULL INTO v_null FROM cz_conversion_rels_v
964: WHERE object_type = p_object_type AND subject_type = p_subject_type;
965: RETURN TRUE;
966: EXCEPTION
967: WHEN NO_DATA_FOUND THEN
1008: v_data_type := GET_ARGUMENT_INFO(v_tExprParamIndex(j), v_tExprParSignature(j), v_mutable, v_collection);
1009:
1010: SELECT NULL INTO v_null
1011: FROM cz_rul_typedpsn_v psn,
1012: cz_conversion_rels_v cnv,
1013: cz_system_property_rels_v rel,
1014: cz_system_properties_v sys,
1015: cz_conversion_rels_v cnv2
1016: WHERE psn.detailed_type_id = cnv.object_type
1011: FROM cz_rul_typedpsn_v psn,
1012: cz_conversion_rels_v cnv,
1013: cz_system_property_rels_v rel,
1014: cz_system_properties_v sys,
1015: cz_conversion_rels_v cnv2
1016: WHERE psn.detailed_type_id = cnv.object_type
1017: AND cnv.subject_type = rel.subject_type
1018: AND rel.object_type = sys.rule_id
1019: AND rel.rel_type_code = 'SYS'
1052: v_data_type := GET_ARGUMENT_INFO(v_tExprParamIndex(j), v_tExprParSignature(j), v_mutable, v_collection);
1053:
1054: SELECT NULL INTO v_null
1055: FROM cz_rul_typedpsn_v psn,
1056: cz_conversion_rels_v cnv,
1057: cz_system_property_rels_v rel,
1058: cz_system_properties_v sys,
1059: cz_conversion_rels_v cnv2
1060: WHERE psn.detailed_type_id = cnv.object_type
1055: FROM cz_rul_typedpsn_v psn,
1056: cz_conversion_rels_v cnv,
1057: cz_system_property_rels_v rel,
1058: cz_system_properties_v sys,
1059: cz_conversion_rels_v cnv2
1060: WHERE psn.detailed_type_id = cnv.object_type
1061: AND cnv.subject_type = rel.subject_type
1062: AND rel.object_type = sys.rule_id
1063: AND rel.rel_type_code = 'SYS'