1 PACKAGE HZ_DQM_MR_PVT AUTHID CURRENT_USER AS
2 /* $Header: ARHDIMRS.pls 115.1 2003/08/15 22:06:37 cvijayan noship $ */
3
4 -------------------------------------------------------------------------
5 -- gen_pkg_spec: This procedure will generate the package spec
6 -- for a given match rule
7 -------------------------------------------------------------------------
8
9
10 PROCEDURE gen_pkg_spec (
11 p_pkg_name IN VARCHAR2,
12 p_match_rule_id IN NUMBER
13 );
14
15 -------------------------------------------------------------------------
16 -- gen_pkg_body: This procedure will generate the package body
17 -- pertaining to system dup identification ( tca vs tca)
18 -- for a given match rule.
19 -------------------------------------------------------------------------
20
21
22 PROCEDURE gen_pkg_body_tca_join (
23 p_pkg_name IN VARCHAR2,
24 p_match_rule_id IN NUMBER
25 );
26
27
28 -------------------------------------------------------------------------
29 -- gen_pkg_body_int_tca_join: This procedure will generate the package body
30 -- pertaining to interface dup identification ( interface vs tca)
31 -- for a given match rule.
32 -------------------------------------------------------------------------
33
34
35 PROCEDURE gen_pkg_body_int_tca_join (
36 p_pkg_name IN VARCHAR2,
37 p_match_rule_id IN NUMBER
38 );
39
40
41 -------------------------------------------------------------------------
42 -- gen_pkg_body_int_join: This procedure will generate the package body
43 -- pertaining to interface dup identification ( interface vs tca)
44 -- for a given match rule.
45 -------------------------------------------------------------------------
46
47
48 PROCEDURE gen_pkg_body_int_join(
49 p_pkg_name IN VARCHAR2,
50 p_match_rule_id IN NUMBER
51 );
52
53
54 PROCEDURE gen_footer;
55
56
57 FUNCTION get_match_threshold (p_match_rule_id number)
58 RETURN number ;
59
60 FUNCTION get_auto_merge_threshold (p_match_rule_id number)
61 RETURN number ;
62
63 FUNCTION has_party_filter_attributes (p_match_rule_id number)
64 RETURN varchar2;
65
66
67 END ; -- HZ_DQM_MR_PVT
68
69