[Home] [Help]
10749: v_tJavaDataType.DELETE;
10750:
10751: SELECT argument_index, data_type, argument_name, java_data_type
10752: BULK COLLECT INTO v_tArgumentIndex, v_tDataType, v_tArgumentName, v_tJavaDataType
10753: FROM cz_signature_arguments
10754: WHERE deleted_flag = '0'
10755: AND argument_signature_id = v_tExprParSignature(i);
10756:
10757: --Verify that the count of the arguments equals to the number specified in the signature,
11940:
11941: FOR i IN(SELECT args.argument_signature_id, args.java_data_type, args.data_type, args.argument_index, rul.class_name, rul.rule_id
11942: FROM CZ_RULES rul,
11943: CZ_EXPRESSION_NODES expr,
11944: CZ_SIGNATURE_ARGUMENTS args
11945: WHERE rul.rule_type = 300 AND rul.devl_project_id = p_model_id AND
11946: expr.rule_id = rul.rule_id AND expr.expr_parent_id is null AND
11947: expr.param_signature_id = args.argument_signature_id AND
11948: args.java_data_type like 'oracle.apps.cz.cio.%' AND
11948: args.java_data_type like 'oracle.apps.cz.cio.%' AND
11949: args.deleted_flag = '0' AND args.seeded_flag = '0' AND
11950: rul.deleted_flag = '0' AND expr.deleted_flag = '0')
11951: LOOP
11952: UPDATE CZ_SIGNATURE_ARGUMENTS arg
11953: SET java_data_type = REPLACE(i.java_data_type,'oracle.apps.cz.cio.','oracle.apps.cz.cioemu.')
11954: WHERE argument_signature_id=i.argument_signature_id AND
11955: argument_index=i.argument_index AND
11956: EXISTS(SELECT NULL FROM cz_node_type_Classes