PACKAGE: APPS.HZ_MATCH_RULES_PKG

Source

1 PACKAGE HZ_MATCH_RULES_PKG AS
2 /*$Header: ARHDQMRS.pls 120.7 2006/05/05 18:52:02 repuri noship $*/
3 
4 procedure INSERT_ROW (
5   X_MATCH_RULE_ID in  out NOCOPY NUMBER,
6   X_RULE_PURPOSE in VARCHAR2,
7   X_MATCH_ALL_FLAG in VARCHAR2,
8   X_ACTIVE_FLAG in VARCHAR2,
9   X_NO_OVERRIDE_SCORE in NUMBER,
10   X_AUTO_MERGE_SCORE in NUMBER,
11   X_COMPILATION_FLAG in VARCHAR2,
12   X_MATCH_SCORE in NUMBER,
13   X_RULE_NAME in VARCHAR2,
14   X_DESCRIPTION in VARCHAR2,
15   X_CREATION_DATE in DATE,
16   X_CREATED_BY in NUMBER,
17   X_LAST_UPDATE_DATE in DATE,
18   X_LAST_UPDATED_BY in NUMBER,
19   X_LAST_UPDATE_LOGIN in NUMBER,
20   X_OBJECT_VERSION_NUMBER in  NUMBER,
21   X_AUTOMERGE_FLAG IN VARCHAR2,
22   X_MATCH_RULE_TYPE IN VARCHAR2, --Code Change for Match Rule Set
23   X_USE_CONTACT_ADDR_FLAG IN VARCHAR2 DEFAULT NULL,
24   X_USE_CONTACT_CPT_FLAG IN VARCHAR2 DEFAULT NULL
25 );
26 
27 procedure INSERT_ROW (
28   X_MATCH_RULE_ID in  out NOCOPY NUMBER,
29   X_RULE_PURPOSE in VARCHAR2,
30   X_MATCH_ALL_FLAG in VARCHAR2,
31   X_ACTIVE_FLAG in VARCHAR2,
32   X_NO_OVERRIDE_SCORE in NUMBER,
33   X_AUTO_MERGE_SCORE in NUMBER,
34   X_COMPILATION_FLAG in VARCHAR2,
35   X_MATCH_SCORE in NUMBER,
36   X_RULE_NAME in VARCHAR2,
37   X_DESCRIPTION in VARCHAR2,
38   X_CREATION_DATE in DATE,
39   X_CREATED_BY in NUMBER,
40   X_LAST_UPDATE_DATE in DATE,
41   X_LAST_UPDATED_BY in NUMBER,
42   X_LAST_UPDATE_LOGIN in NUMBER,
43   X_OBJECT_VERSION_NUMBER in  NUMBER,
44   X_AUTOMERGE_FLAG IN VARCHAR2 DEFAULT 'N',
45   X_USE_CONTACT_ADDR_FLAG IN VARCHAR2 DEFAULT NULL,
46   X_USE_CONTACT_CPT_FLAG IN VARCHAR2 DEFAULT NULL
47 );
48 
49 procedure LOCK_ROW (
50   X_MATCH_RULE_ID in NUMBER,
51   X_OBJECT_VERSION_NUMBER in  NUMBER
52 );
53 procedure UPDATE_ROW (
54   X_MATCH_RULE_ID in NUMBER,
55   X_RULE_PURPOSE in VARCHAR2,
56   X_MATCH_ALL_FLAG in VARCHAR2,
57   X_ACTIVE_FLAG in VARCHAR2,
58   X_NO_OVERRIDE_SCORE in NUMBER,
59   X_AUTO_MERGE_SCORE in NUMBER,
60   X_COMPILATION_FLAG in VARCHAR2,
61   X_MATCH_SCORE in NUMBER,
62   X_RULE_NAME in VARCHAR2,
63   X_DESCRIPTION in VARCHAR2,
64   X_LAST_UPDATE_DATE in DATE,
65   X_LAST_UPDATED_BY in NUMBER,
66   X_LAST_UPDATE_LOGIN in NUMBER,
67   X_OBJECT_VERSION_NUMBER in out NOCOPY NUMBER,
68   X_AUTOMERGE_FLAG IN VARCHAR2 DEFAULT NULL,
69   X_USE_CONTACT_ADDR_FLAG IN VARCHAR2 DEFAULT NULL,
70   X_USE_CONTACT_CPT_FLAG IN VARCHAR2 DEFAULT NULL
71 );
72 
73 procedure DELETE_ROW (
74   X_MATCH_RULE_ID in NUMBER
75 );
76 procedure ADD_LANGUAGE;
77 
78 procedure LOAD_ROW (
79   X_MATCH_RULE_ID in NUMBER,
80   X_RULE_PURPOSE in VARCHAR2,
81   X_MATCH_ALL_FLAG in VARCHAR2,
82   X_ACTIVE_FLAG in VARCHAR2,
83   X_NO_OVERRIDE_SCORE in NUMBER,
84   X_AUTO_MERGE_SCORE in NUMBER,
85   X_COMPILATION_FLAG in VARCHAR2,
86   X_MATCH_SCORE in NUMBER,
87   X_RULE_NAME in VARCHAR2,
88   X_DESCRIPTION in VARCHAR2,
89   X_LAST_UPDATE_DATE in DATE,
90   X_LAST_UPDATED_BY in NUMBER,
91   X_LAST_UPDATE_LOGIN in NUMBER,
92   X_OBJECT_VERSION_NUMBER in  NUMBER,
93   X_OWNER in VARCHAR2,
94   X_AUTOMERGE_FLAG IN VARCHAR2 DEFAULT NULL,
95   X_USE_CONTACT_ADDR_FLAG IN VARCHAR2 DEFAULT NULL,
96   X_USE_CONTACT_CPT_FLAG IN VARCHAR2 DEFAULT NULL
97   );
98 
99  procedure TRANSLATE_ROW (
100   X_MATCH_RULE_ID in NUMBER,
101   X_RULE_NAME in VARCHAR2,
102   X_DESCRIPTION in VARCHAR2,
103   X_OWNER in VARCHAR2);
104 
105 end HZ_MATCH_RULES_PKG;