[Home] [Help]
234: WHERE resource_class_id = p_resource_class_id;
235: Cursor get_fmt_details IS
236: SELECT res_type_id,res_type_enabled_flag,
237: resource_class_flag
238: FROM pa_res_formats_b
239: WHERE res_format_id = p_res_format_id;
240: Cursor get_res_type(p_res_type_id pa_res_types_b.res_type_id%TYPE )
241: IS
242: SELECT res_type_code
978:
979: BEGIN
980: SELECT res.res_type_code
981: INTO l_res_type_code
982: from pa_res_formats_b fmt,pa_res_types_b res
983: where fmt.res_type_id = res.res_type_id
984: and fmt.res_format_id = p_res_format_id;
985: EXCEPTION
986: WHEN NO_DATA_FOUND THEN