61:
62: delete from hxc_tk_group_query_criteria tkgqc
63: where tkgqc.tk_group_query_id in
64: ( select tkgq.tk_group_query_id
65: from hxc_tk_group_queries tkgq
66: where tkgq.tk_group_id = p_rec.tk_group_id );
67:
68: -- Delete the hxc_tk_group_queries row.
69:
64: ( select tkgq.tk_group_query_id
65: from hxc_tk_group_queries tkgq
66: where tkgq.tk_group_id = p_rec.tk_group_id );
67:
68: -- Delete the hxc_tk_group_queries row.
69:
70: delete from hxc_tk_group_queries tkgq
71: where tkgq.tk_group_query_id = p_rec.tk_group_query_id;
72:
66: where tkgq.tk_group_id = p_rec.tk_group_id );
67:
68: -- Delete the hxc_tk_group_queries row.
69:
70: delete from hxc_tk_group_queries tkgq
71: where tkgq.tk_group_query_id = p_rec.tk_group_query_id;
72:
73: --
74: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status