[Home] [Help]
PACKAGE: APPS.PV_RULE_RECTYPE_PUB
Source
1 PACKAGE PV_RULE_RECTYPE_PUB AUTHID CURRENT_USER as
2 /* $Header: pvrtspcs.pls 120.1 2005/12/06 14:19:35 amaram noship $ */
3 -- Start of Comments
4 -- Package name : PV_RULE_RECTYPE_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 TYPE SELCRIT_Rec_Type IS RECORD
12 (
13 SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
14 , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15 , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16 , CREATION_DATE DATE := FND_API.G_MISS_DATE
17 , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18 , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19 , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20 , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21 , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22 , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23 , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24 , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25 , ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
26 , SELECTION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
27 , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
28 , RANK NUMBER := FND_API.G_MISS_NUM
29 , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
30 , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
31 , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
32 , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
33 , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
34 , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
35 , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
36 , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
37 , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
38 , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
39 , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
40 , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
41 , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
42 , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
43 , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
44 , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
45 );
46
47 G_MISS_SELCRIT_REC SELCRIT_Rec_Type;
48
49
50 TYPE RULES_Rec_Type IS RECORD
51 (
52 PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
53 , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
54 , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
55 , CREATION_DATE DATE := FND_API.G_MISS_DATE
56 , CREATED_BY NUMBER := FND_API.G_MISS_NUM
57 , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
58 , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59 , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
60 , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
61 , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
62 , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63 , PROCESS_RULE_NAME VARCHAR2(100) := FND_API.G_MISS_CHAR
64 , PARENT_RULE_ID NUMBER := FND_API.G_MISS_NUM
65 , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
66 , RANK NUMBER := FND_API.G_MISS_NUM
67 , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68 , START_DATE DATE := FND_API.G_MISS_DATE
69 , END_DATE DATE := FND_API.G_MISS_DATE
70 , ACTION VARCHAR2(500) := FND_API.G_MISS_CHAR
71 , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
72 , OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
73 , CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR
74 , LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR
75 , SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR
76 , DESCRIPTION VARCHAR2(500) := FND_API.G_MISS_CHAR
77 , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
78 , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
79 , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
80 , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
81 , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
82 , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
83 , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
84 , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
85 , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
86 , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
87 , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
88 , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
89 , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
90 , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
91 , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
92 , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
93 );
94
95 G_MISS_RULES_REC RULES_Rec_Type;
96
97
98 TYPE ENTYATTMAP_Rec_Type IS RECORD
99 (
100 MAPPING_ID NUMBER := FND_API.G_MISS_NUM
101 , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102 , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
103 , CREATION_DATE DATE := FND_API.G_MISS_DATE
104 , CREATED_BY NUMBER := FND_API.G_MISS_NUM
105 , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
106 , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
107 , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
108 , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
109 , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
110 , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
111 , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
112 , SOURCE_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
113 , SOURCE_ATTR_ID NUMBER := FND_API.G_MISS_NUM
114 , TARGET_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
115 , TARGET_ATTR_ID NUMBER := FND_API.G_MISS_NUM
116 , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
117 , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
118 , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
119 , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
120 , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
121 , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
122 , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
123 , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
124 , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
125 , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
126 , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
127 , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
128 , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
129 , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
130 , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
131 , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
132 , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
133 );
134
135 G_MISS_ENTYATTMAP_REC ENTYATTMAP_Rec_Type;
136
137
138 TYPE ENTYRLS_Rec_Type IS RECORD
139 (
140 ENTITY_RULE_APPLIED_ID NUMBER := FND_API.G_MISS_NUM
141 , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
142 , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
143 , CREATION_DATE DATE := FND_API.G_MISS_DATE
144 , CREATED_BY NUMBER := FND_API.G_MISS_NUM
145 , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
146 , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
147 , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
148 , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
149 , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
150 , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
151 , ENTITY VARCHAR2(30) := FND_API.G_MISS_CHAR
152 , ENTITY_ID NUMBER := FND_API.G_MISS_NUM
153 , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
154 , PARENT_PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
155 , LATEST_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
156 , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
157 , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
158 , WINNING_RULE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
159 , ENTITY_DETAIL VARCHAR2(100) := FND_API.G_MISS_CHAR
160 , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
161 , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
162 , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
163 , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
164 , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
165 , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
166 , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
167 , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
168 , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
169 , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
170 , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
171 , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
172 , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
173 , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
174 , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
175 , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
176 , PROCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR
177 );
178
179 G_MISS_ENTYRLS_REC ENTYRLS_Rec_Type;
180
181
182 TYPE ENTYROUT_Rec_Type IS RECORD
183 (
184 ENTITY_ROUTING_ID NUMBER := FND_API.G_MISS_NUM
185 , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
186 , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
187 , CREATION_DATE DATE := FND_API.G_MISS_DATE
188 , CREATED_BY NUMBER := FND_API.G_MISS_NUM
189 , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
190 , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
191 , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
192 , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
193 , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
194 , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
195 , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
196 , DISTANCE_FROM_CUSTOMER NUMBER := FND_API.G_MISS_NUM
197 , DISTANCE_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
198 , MAX_NEAREST_PARTNER NUMBER := FND_API.G_MISS_NUM
199 , ROUTING_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
200 , BYPASS_CM_OK_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
201 , CM_TIMEOUT NUMBER := FND_API.G_MISS_NUM
202 , CM_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
203 , PARTNER_TIMEOUT NUMBER := FND_API.G_MISS_NUM
204 , PARTNER_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
205 , UNMATCHED_INT_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
206 , UNMATCHED_CALL_TAP_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
207 , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
208 , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
209 , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
210 , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
211 , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
212 , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
213 , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
214 , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
215 , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
216 , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
217 , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
218 , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
219 , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
220 , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
221 , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
222 , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
223 );
224
225 G_MISS_ENTYROUT_REC ENTYROUT_Rec_Type;
226
227
228 TYPE SELATTVAL_Rec_Type IS RECORD
229 (
230 ATTR_VALUE_ID NUMBER := FND_API.G_MISS_NUM
231 , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
232 , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
233 , CREATION_DATE DATE := FND_API.G_MISS_DATE
234 , CREATED_BY NUMBER := FND_API.G_MISS_NUM
235 , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
236 , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
237 , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
238 , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
239 , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
240 , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
241 , SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
242 , ATTRIBUTE_VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR
243 , ATTRIBUTE_TO_VALUE VARCHAR2(500) := FND_API.G_MISS_CHAR
244 , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
245 , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
246 , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
247 , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
248 , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
249 , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
250 , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
251 , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
252 , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
253 , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
254 , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
255 , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
256 , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
257 , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
258 , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
259 , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
260 , SCORE NUMBER := FND_API.G_MISS_NUM
261 );
262
263 G_MISS_SELATTVAL_REC SELATTVAL_Rec_Type;
264
265 End PV_RULE_RECTYPE_PUB;