1 package ams_list_rules_pkg as
2 /* $Header: amsllrus.pls 120.0 2005/05/31 17:10:15 appldev noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in OUT NOCOPY VARCHAR2,
5 X_LIST_RULE_ID in NUMBER,
6 X_OBJECT_VERSION_NUMBER in NUMBER,
7 X_LIST_RULE_NAME in VARCHAR2,
8 X_WEIGHTAGE_FOR_DEDUPE in NUMBER,
9 X_ACTIVE_FROM_DATE in DATE,
10 X_ACTIVE_TO_DATE in DATE,
11 X_LIST_RULE_TYPE in VARCHAR2,
12 X_DESCRIPTION in VARCHAR2,
13 X_CREATION_DATE in DATE,
14 X_CREATED_BY in NUMBER,
15 X_LAST_UPDATE_DATE in DATE,
16 X_LAST_UPDATED_BY in NUMBER,
17 X_LAST_UPDATE_LOGIN in NUMBER,
18 x_LIST_SOURCE_TYPE in VARCHAR2,
19 x_ENABLED_FLAG in VARCHAR2,
20 x_SEEDED_FLAG in VARCHAR2
21 );
22 procedure LOCK_ROW (
23 X_LIST_RULE_ID in NUMBER,
24 X_OBJECT_VERSION_NUMBER in NUMBER,
25 X_LIST_RULE_NAME in VARCHAR2,
26 X_WEIGHTAGE_FOR_DEDUPE in NUMBER,
27 X_ACTIVE_FROM_DATE in DATE,
28 X_ACTIVE_TO_DATE in DATE,
29 X_LIST_RULE_TYPE in VARCHAR2,
30 X_DESCRIPTION in VARCHAR2
31 );
32 procedure UPDATE_ROW (
33 X_LIST_RULE_ID in NUMBER,
34 X_OBJECT_VERSION_NUMBER in NUMBER,
35 X_LIST_RULE_NAME in VARCHAR2,
36 X_WEIGHTAGE_FOR_DEDUPE in NUMBER,
37 X_ACTIVE_FROM_DATE in DATE,
38 X_ACTIVE_TO_DATE in DATE,
39 X_LIST_RULE_TYPE in VARCHAR2,
40 X_DESCRIPTION in VARCHAR2,
41 X_LAST_UPDATE_DATE in DATE,
42 X_LAST_UPDATED_BY in NUMBER,
43 X_LAST_UPDATE_LOGIN in NUMBER,
44 x_LIST_SOURCE_TYPE in VARCHAR2,
45 x_ENABLED_FLAG in VARCHAR2,
46 x_SEEDED_FLAG in VARCHAR2
47 );
48 procedure DELETE_ROW (
49 X_LIST_RULE_ID in NUMBER
50 );
51
52 PROCEDURE load_row (
53 X_LIST_RULE_ID in NUMBER,
54 X_LIST_RULE_NAME in VARCHAR2,
55 X_WEIGHTAGE_FOR_DEDUPE in NUMBER,
56 X_ACTIVE_FROM_DATE in VARCHAR2,
57 X_ACTIVE_TO_DATE in VARCHAR2,
58 X_LIST_RULE_TYPE in VARCHAR2,
59 X_DESCRIPTION in VARCHAR2,
60 x_owner IN VARCHAR2,
61 x_LIST_SOURCE_TYPE in VARCHAR2,
62 x_ENABLED_FLAG in VARCHAR2,
63 x_SEEDED_FLAG in VARCHAR2,
64 x_custom_mode IN VARCHAR2
65
66 );
67
68
69 PROCEDURE TRANSLATE_ROW (
70 X_LIST_RULE_ID IN NUMBER,
71 X_LIST_RULE_NAME IN VARCHAR2,
72 X_DESCRIPTION IN VARCHAR2,
73 X_OWNER IN VARCHAR2,
74 x_custom_mode IN VARCHAR2
75
76 );
77
78 ----------------- AMS_LIST_RULE_FIELDS -------------------------
79 procedure INSERT_FIELD (
80 X_ROWID in OUT NOCOPY VARCHAR2,
81 X_LIST_RULE_FIELD_ID in NUMBER,
82 X_FIELD_COLUMN_NAME in VARCHAR2,
83 X_OBJECT_VERSION_NUMBER in NUMBER,
84 X_SUBSTRING_LENGTH in NUMBER,
85 X_WEIGHTAGE in NUMBER,
86 X_SEQUENCE_NUMBER in NUMBER,
87 X_LIST_RULE_ID in NUMBER,
88 X_FIELD_TABLE_NAME in VARCHAR2,
89 X_CREATION_DATE in DATE,
90 X_CREATED_BY in NUMBER,
91 X_LAST_UPDATE_DATE in DATE,
92 X_LAST_UPDATED_BY in NUMBER,
93 X_LAST_UPDATE_LOGIN in NUMBER,
94 x_WORD_REPLACEMENT_CODE in VARCHAR2,
95 x_LIST_SOURCE_FIELD_ID in NUMBER
96 );
97 procedure LOCK_FIELD (
98 X_LIST_RULE_FIELD_ID in NUMBER,
99 X_FIELD_COLUMN_NAME in VARCHAR2,
100 X_OBJECT_VERSION_NUMBER in NUMBER,
101 X_SUBSTRING_LENGTH in NUMBER,
102 X_WEIGHTAGE in NUMBER,
103 X_SEQUENCE_NUMBER in NUMBER,
104 X_LIST_RULE_ID in NUMBER,
105 X_FIELD_TABLE_NAME in VARCHAR2
106 );
107 procedure UPDATE_FIELD (
108 X_LIST_RULE_FIELD_ID in NUMBER,
109 X_FIELD_COLUMN_NAME in VARCHAR2,
110 X_OBJECT_VERSION_NUMBER in NUMBER,
111 X_SUBSTRING_LENGTH in NUMBER,
112 X_WEIGHTAGE in NUMBER,
113 X_SEQUENCE_NUMBER in NUMBER,
114 X_LIST_RULE_ID in NUMBER,
115 X_FIELD_TABLE_NAME in VARCHAR2,
116 X_LAST_UPDATE_DATE in DATE,
117 X_LAST_UPDATED_BY in NUMBER,
118 X_LAST_UPDATE_LOGIN in NUMBER,
119 x_WORD_REPLACEMENT_CODE in VARCHAR2,
120 x_LIST_SOURCE_FIELD_ID in NUMBER
121 );
122 procedure DELETE_FIELD (
123 X_LIST_RULE_FIELD_ID in NUMBER
124 );
125
126 PROCEDURE load_field (
127 X_LIST_RULE_FIELD_ID in NUMBER,
128 X_FIELD_COLUMN_NAME in VARCHAR2,
129 X_SUBSTRING_LENGTH in NUMBER,
130 X_WEIGHTAGE in NUMBER,
131 X_SEQUENCE_NUMBER in NUMBER,
132 X_LIST_RULE_ID in NUMBER,
133 X_FIELD_TABLE_NAME in VARCHAR2,
134 x_owner IN VARCHAR2,
135 x_WORD_REPLACEMENT_CODE in VARCHAR2,
136 x_LIST_SOURCE_FIELD_ID in NUMBER,
137 x_custom_mode IN VARCHAR2
138
139 );
140
141 PROCEDURE TRANSLATE_FIELD (
142 X_LIST_RULE_FIELD_ID IN NUMBER,
143 X_OWNER IN VARCHAR2,
144 x_custom_mode IN VARCHAR2
145
146 );
147
148 END ams_list_rules_pkg;