2201: CLOSE check_inactive;
2202:
2203: -- Generate and compile match rule package spec
2204: HZ_GEN_PLSQL.new(l_package_name, 'PACKAGE');
2205: HZ_DQM_MR_PVT.gen_pkg_spec(l_package_name, p_match_rule_id);
2206: HZ_GEN_PLSQL.compile_code;
2207:
2208: -- Generate and compile match rule package body
2209: HZ_GEN_PLSQL.new(l_package_name, 'PACKAGE BODY');
2206: HZ_GEN_PLSQL.compile_code;
2207:
2208: -- Generate and compile match rule package body
2209: HZ_GEN_PLSQL.new(l_package_name, 'PACKAGE BODY');
2210: HZ_DQM_MR_PVT.gen_pkg_body_tca_join(l_package_name, p_match_rule_id);
2211: HZ_DQM_MR_PVT.gen_pkg_body_int_tca_join(l_package_name, p_match_rule_id);
2212: HZ_DQM_MR_PVT.gen_pkg_body_int_join(l_package_name, p_match_rule_id);
2213: HZ_DQM_MR_PVT.gen_footer;
2214: HZ_GEN_PLSQL.compile_code;
2207:
2208: -- Generate and compile match rule package body
2209: HZ_GEN_PLSQL.new(l_package_name, 'PACKAGE BODY');
2210: HZ_DQM_MR_PVT.gen_pkg_body_tca_join(l_package_name, p_match_rule_id);
2211: HZ_DQM_MR_PVT.gen_pkg_body_int_tca_join(l_package_name, p_match_rule_id);
2212: HZ_DQM_MR_PVT.gen_pkg_body_int_join(l_package_name, p_match_rule_id);
2213: HZ_DQM_MR_PVT.gen_footer;
2214: HZ_GEN_PLSQL.compile_code;
2215:
2208: -- Generate and compile match rule package body
2209: HZ_GEN_PLSQL.new(l_package_name, 'PACKAGE BODY');
2210: HZ_DQM_MR_PVT.gen_pkg_body_tca_join(l_package_name, p_match_rule_id);
2211: HZ_DQM_MR_PVT.gen_pkg_body_int_tca_join(l_package_name, p_match_rule_id);
2212: HZ_DQM_MR_PVT.gen_pkg_body_int_join(l_package_name, p_match_rule_id);
2213: HZ_DQM_MR_PVT.gen_footer;
2214: HZ_GEN_PLSQL.compile_code;
2215:
2216:
2209: HZ_GEN_PLSQL.new(l_package_name, 'PACKAGE BODY');
2210: HZ_DQM_MR_PVT.gen_pkg_body_tca_join(l_package_name, p_match_rule_id);
2211: HZ_DQM_MR_PVT.gen_pkg_body_int_tca_join(l_package_name, p_match_rule_id);
2212: HZ_DQM_MR_PVT.gen_pkg_body_int_join(l_package_name, p_match_rule_id);
2213: HZ_DQM_MR_PVT.gen_footer;
2214: HZ_GEN_PLSQL.compile_code;
2215:
2216:
2217: --Standard call to get message count and if count is 1, get message info.