1 package EGO_RULE_SETS_PKG AUTHID CURRENT_USER as
2 /* $Header: EGOVRSTS.pls 120.1.12020000.5 2013/04/19 06:28:38 leizhzha ship $ */
3
4
5 --------------------------------------------------- R12.2 Rule Enhancement Data Migration begin ----------------------------------------------------
6
7 TYPE DATA_LEVEL_TBL_TYPE IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
8 TYPE USAGE_ATTR_REC_TYPE IS RECORD
9 (
10 BUSINESS_ENTITY VARCHAR2(50),
11 ATTR_GROUP_TYPE VARCHAR2(50),
12 ATTR_GROUP_NAME VARCHAR2(50),
13 ATTRIBUTE VARCHAR2(50)
14 );
15
16 TYPE USAGE_ATTR_TBL_TYPE IS TABLE OF USAGE_ATTR_REC_TYPE INDEX BY BINARY_INTEGER;
17
18
19 procedure LOG_MSG (X_MSG_TYPE IN VARCHAR2, X_MSG_DATA IN VARCHAR2);
20
21 function BUSINESS_ENTITIES_TO_STRING (X_RULESET_ID in number) return varchar2;
22
23 function ATTR_GROUP_DATA_LEVEL_OK (X_ATTR_GROUP_ID in number, X_BUSINESS_ENTITIES in varchar2, X_MISSING_ENT out nocopy varchar2) return boolean;
24
25 procedure CLEAR_RULESET;
26
27 procedure INITIALIZE_RULESET (X_RULESET_NAME IN VARCHAR2, X_LOG_NAME IN VARCHAR2);
28
29 procedure CLEAR_RULE;
30
31 procedure INITIALIZE_RULE (X_RULE_NAME IN VARCHAR2);
32
33 function IS_RULESET_OK return boolean;
34
35 function IS_RULE_OK return boolean;
36
37 function ATTR_GROUP_CONSISTENT (X_ATTR_GROUP_TYPE IN VARCHAR2, X_ATTR_GROUP_NAME IN VARCHAR2) return boolean;
38
39 function GET_RULESET_ID return NUMBER;
40
41 procedure SET_RULESET_ID (X_RULESET_ID IN NUMBER);
42
43 function GET_ATTR_GROUP_TYPE return VARCHAR2;
44
45 function GET_ATTR_GROUP_NAME return VARCHAR2;
46
47 procedure SET_ATTR_GROUP (X_ATTR_GROUP_TYPE IN VARCHAR2, X_ATTR_GROUP_NAME IN VARCHAR2);
48
49 function GET_BUSINESS_ENTITIES return VARCHAR2;
50
51 procedure SET_BUSINESS_ENTITIES (X_BUSINESS_ENTITIES IN VARCHAR2);
52
53 function GET_ITEM_CATALOG_GROUP return NUMBER;
54
55 procedure SET_ITEM_CATALOG_GROUP (X_ITEM_CATALOG_GROUP IN NUMBER);
56
57 procedure ADD_USAGE_ATTRIBUTE (X_USAGE_ATTRIBUTE IN USAGE_ATTR_REC_TYPE);
58
59 function GET_USAGE_ATTRIBUTE_TBL return USAGE_ATTR_TBL_TYPE;
60
61 procedure RULESET_SUCCESS;
62
63 procedure RULESET_FAIL;
64
65 procedure RULE_SUCCESS;
66
67 procedure RULE_FAIL;
68
69 procedure SET_MSG (X_MSG_TYPE IN VARCHAR2, X_MSG_DATA IN VARCHAR2);
70
71 function GET_MSG_TYPE return VARCHAR2;
72
73 function GET_MSG_DATA return VARCHAR2;
74
75
76 procedure PROCESS_RULESET (
77 X_RULESET_ID out nocopy NUMBER,
78 X_RULESET_NAME in VARCHAR2,
79 X_RULESET_TYPE in VARCHAR2,
80 X_COMPOSITE in VARCHAR2,
81 X_ITEM_CATALOG_CATEGORY in NUMBER := NULL,
82 X_ATTR_GROUP_NAME in VARCHAR2 := NULL,
83 X_ATTR_GROUP_TYPE in VARCHAR2 := NULL,
84 X_BUSINESS_ENTITIES in VARCHAR2 := NULL,
85 X_RULESET_DISPLAY_NAME in VARCHAR2,
86 X_DESCRIPTION in VARCHAR2,
87 X_CREATED_BY in NUMBER,
88 X_LAST_UPDATE_DATE in DATE,
89 X_LAST_UPDATED_BY in NUMBER,
90 X_LAST_UPDATE_LOGIN in NUMBER,
91 X_CUSTOM_MODE in VARCHAR2
92 );
93
94 --------------------------------------------------- R12.2 Rule Enhancement Data Migration end ----------------------------------------------------
95
96
97 procedure INSERT_ROW (
98 X_ROWID in out nocopy VARCHAR2,
99 X_RULESET_ID in NUMBER,
100 X_ATTR_GROUP_TYPE in VARCHAR2,
101 X_RULESET_NAME in VARCHAR2,
102 X_RULESET_TYPE in VARCHAR2,
103 X_COMPOSITE in VARCHAR2,
104 X_ITEM_CATALOG_CATEGORY in NUMBER,
105 X_ATTR_GROUP_NAME in VARCHAR2,
106 X_RULESET_DISPLAY_NAME in VARCHAR2,
107 X_DESCRIPTION in VARCHAR2,
108 X_CREATION_DATE in DATE,
109 X_CREATED_BY in NUMBER,
110 X_LAST_UPDATE_DATE in DATE,
111 X_LAST_UPDATED_BY in NUMBER,
112 X_LAST_UPDATE_LOGIN in NUMBER);
113 procedure LOCK_ROW (
114 X_RULESET_ID in NUMBER,
115 X_ATTR_GROUP_TYPE in VARCHAR2,
116 X_RULESET_NAME in VARCHAR2,
117 X_RULESET_TYPE in VARCHAR2,
118 X_COMPOSITE in VARCHAR2,
119 X_ITEM_CATALOG_CATEGORY in NUMBER,
120 X_ATTR_GROUP_NAME in VARCHAR2,
121 X_RULESET_DISPLAY_NAME in VARCHAR2,
122 X_DESCRIPTION in VARCHAR2
123 );
124 procedure UPDATE_ROW (
125 X_RULESET_ID in NUMBER,
126 X_ATTR_GROUP_TYPE in VARCHAR2,
127 X_RULESET_NAME in VARCHAR2,
128 X_RULESET_TYPE in VARCHAR2,
129 X_COMPOSITE in VARCHAR2,
130 X_ITEM_CATALOG_CATEGORY in NUMBER,
131 X_ATTR_GROUP_NAME in VARCHAR2,
132 X_RULESET_DISPLAY_NAME in VARCHAR2,
133 X_DESCRIPTION in VARCHAR2,
134 X_LAST_UPDATE_DATE in DATE,
135 X_LAST_UPDATED_BY in NUMBER,
136 X_LAST_UPDATE_LOGIN in NUMBER
137 );
138 procedure TRANSLATE_ROW (
139 X_RULESET_ID in NUMBER,
140 X_RULESET_DISPLAY_NAME in VARCHAR2,
141 X_DESCRIPTION in VARCHAR2,
142 X_OWNER in VARCHAR2
143 );
144 procedure LOAD_ROW (
145 X_ROWID in out nocopy VARCHAR2,
146 X_RULESET_ID in NUMBER,
147 X_RULESET_NAME in VARCHAR2,
148 X_ATTR_GROUP_TYPE in VARCHAR2,
149 X_RULESET_TYPE in VARCHAR2,
150 X_COMPOSITE in VARCHAR2,
151 X_ITEM_CATALOG_CATEGORY in NUMBER,
152 X_ATTR_GROUP_NAME in VARCHAR2,
153 X_RULESET_DISPLAY_NAME in VARCHAR2,
154 X_DESCRIPTION in VARCHAR2,
155 X_CREATED_BY in NUMBER,
156 X_LAST_UPDATE_DATE in DATE,
157 X_LAST_UPDATED_BY in NUMBER,
158 X_LAST_UPDATE_LOGIN in NUMBER
159 );
160 procedure DELETE_ROW (
161 X_RULESET_ID in NUMBER
162 );
163 PROCEDURE ADD_LANGUAGE;
164
165 --UT bug 16611182: add default value for the user defined attribute group
166 procedure INSERT_UDA_DEFAULT_VALUES(p_batch_id IN NUMBER);
167
168 end EGO_RULE_SETS_PKG;