DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_SIGNATURE_ARGUMENTS

Line 10805: FROM cz_signature_arguments

10801: v_tJavaDataType.DELETE;
10802:
10803: SELECT argument_index, data_type, argument_name, java_data_type
10804: BULK COLLECT INTO v_tArgumentIndex, v_tDataType, v_tArgumentName, v_tJavaDataType
10805: FROM cz_signature_arguments
10806: WHERE deleted_flag = '0'
10807: AND argument_signature_id = v_tExprParSignature(i);
10808:
10809: --Verify that the count of the arguments equals to the number specified in the signature,

Line 12018: CZ_SIGNATURE_ARGUMENTS args

12014:
12015: FOR i IN(SELECT args.argument_signature_id, args.java_data_type, args.data_type, args.argument_index, rul.class_name, rul.rule_id
12016: FROM CZ_RULES rul,
12017: CZ_EXPRESSION_NODES expr,
12018: CZ_SIGNATURE_ARGUMENTS args
12019: WHERE rul.rule_type = 300 AND rul.devl_project_id = p_model_id AND
12020: expr.rule_id = rul.rule_id AND expr.expr_parent_id is null AND
12021: expr.param_signature_id = args.argument_signature_id AND
12022: args.java_data_type like 'oracle.apps.cz.cio.%' AND

Line 12026: UPDATE CZ_SIGNATURE_ARGUMENTS arg

12022: args.java_data_type like 'oracle.apps.cz.cio.%' AND
12023: args.deleted_flag = '0' AND args.seeded_flag = '0' AND
12024: rul.deleted_flag = '0' AND expr.deleted_flag = '0')
12025: LOOP
12026: UPDATE CZ_SIGNATURE_ARGUMENTS arg
12027: SET java_data_type = REPLACE(i.java_data_type,'oracle.apps.cz.cio.','oracle.apps.cz.cioemu.')
12028: WHERE argument_signature_id=i.argument_signature_id AND
12029: argument_index=i.argument_index AND
12030: EXISTS(SELECT NULL FROM cz_node_type_Classes