1 PACKAGE HZ_DQM_SEARCH_UTIL AS
2 /*$Header: ARHDQUTS.pls 120.14 2006/10/05 19:00:07 nsinghai noship $ */
3 /*#
4 * Checks the availability of Data Quality Management.
5 * @rep:scope public
6 * @rep:product HZ
7 * @rep:displayname DQM Availability
8 * @rep:category BUSINESS_ENTITY HZ_PARTY
9 * @rep:lifecycle active
10 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs,
11 * Oracle Trading Community Architecture Technical Implementation Guide
12 */
13
14 TYPE NumberList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
15 TYPE vcharlist IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
16
17 PROCEDURE add_transformation (
18 p_tx_val IN VARCHAR2,
19 p_within IN VARCHAR2,
20 x_tx_str IN OUT NOCOPY VARCHAR2);
21
22 PROCEDURE add_filter (
23 p_tx_val IN VARCHAR2,
24 p_within IN VARCHAR2,
25 x_filter_str IN OUT NOCOPY VARCHAR2);
26
27 PROCEDURE add_attribute (
28 p_tx_str IN VARCHAR2,
29 p_match_str IN VARCHAR2,
30 x_contains_str IN OUT NOCOPY VARCHAR2);
31
32 PROCEDURE add_attribute_with_denorm (
33 p_tx_str IN VARCHAR2,
34 p_match_str IN VARCHAR2,
35 p_denorm_str IN VARCHAR2,
36 x_contains_str IN OUT NOCOPY VARCHAR2);
37
38 PROCEDURE add_search_record (
39 p_rec_contains_str IN VARCHAR2,
40 p_filter_str IN VARCHAR2,
41 x_contains_str IN OUT NOCOPY VARCHAR2);
42
43 PROCEDURE remove_matches_not_in_subset (
44 p_search_ctx_id IN NUMBER,
45 p_subset_defn IN VARCHAR2
46 );
47
48 FUNCTION is_similar (
49 p_src IN VARCHAR2,
50 p_dest IN VARCHAR2,
51 p_min_similarity IN NUMBER := 100)
52 RETURN NUMBER;
53
54 -- This Function tests if the DQM indexes have been created
55 -- and if they are valid
56 /*#
57 * Checks if interMedia indexes in all Data Quality Management staging tables are
58 * created and valid. The function accordingly returns FND_API.G_TRUE or FND_API.G_FALSE.
59 * @rep:scope public
60 * @rep:lifecycle active
61 * @rep:displayname Is DQM Index Available
62 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs,
63 * Oracle Trading Community Architecture Technical Implementation Guide
64 */
65 FUNCTION is_dqm_available
66 RETURN VARCHAR2;
67
68 /*#
69 * Checks if a match rule is available, meaning that the rule is compiled and all its active
70 * transformations are staged. The function accordingly returns FND_API.G_TRUE or FND_API.G_FALSE.
71 * appropriately.
72 * @rep:scope public
73 * @rep:lifecycle active
74 * @rep:displayname Is DQM Match Rule Available
75 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs,
76 * Oracle Trading Community Architecture Technical Implementation Guide
77 */
78 FUNCTION is_dqm_available (
79 p_match_rule_id NUMBER
80 )
81 RETURN VARCHAR2;
82
83 FUNCTION is_similar_match(
84 p_src IN VARCHAR2,
85 p_dest IN VARCHAR2,
86 p_min_similarity IN VARCHAR2,
87 p_attr_idx IN NUMBER) RETURN BOOLEAN;
88
89 FUNCTION is_match(
90 p_src IN VARCHAR2,
91 p_dest IN VARCHAR2,
92 p_attr_idx IN NUMBER) RETURN BOOLEAN;
93
94 PROCEDURE new_search;
95
96 FUNCTION strtok (
97 p_string VARCHAR2 DEFAULT NULL,
98 p_numtoks NUMBER DEFAULT NULL,
99 p_delim VARCHAR2 DEFAULT NULL
100 ) RETURN VARCHAR2;
101
102 FUNCTION ESTIMATED_LENGTH(p_str VARCHAR2) RETURN NUMBER;
103
104 PROCEDURE update_word_list (
105 p_repl_word VARCHAR2,
106 p_word_list_id NUMBER);
107
108
109 PROCEDURE set_num_eval(p_num NUMBER);
110
111 FUNCTION get_num_eval RETURN NUMBER;
112
113 PROCEDURE set_no_score;
114 PROCEDURE set_score;
115
116 PROCEDURE get_quality_score (
117 p_srch_ctx_id IN NUMBER,
118 p_match_rule_id IN NUMBER) ;
119
120 FUNCTION validate_trans_proc(
121 P_PROCEDURE_NAME IN VARCHAR2
122 ) return VARCHAR2;
123
124 FUNCTION validate_custom_proc(
125 P_CUST_PROCEDURE_NAME IN VARCHAR2
126 ) return VARCHAR2 ;
127
128 END ;