[Home] [Help]
PACKAGE BODY: APPS.JTF_CHANGED_TERR_PKG
Source
1 PACKAGE BODY JTF_CHANGED_TERR_PKG AS
2 /* $Header: jtfvctrb.pls 115.7 2000/06/05 17:00:38 pkm ship $ */
3
4 PROCEDURE Insert_Row(
5 px_TERR_ID IN OUT NUMBER,
6 P_TERR_VALUE_ID IN NUMBER,
7 p_TRIGGER_MODE VARCHAR2,
8 p_ACTION VARCHAR2,
9 p_PARENT_TERRITORY_ID NUMBER,
10 p_O_START_DATE_ACTIVE DATE,
11 p_O_END_DATE_ACTIVE DATE,
12 p_O_RANK NUMBER,
13 p_O_UPDATE_FLAG VARCHAR2,
14 p_N_START_DATE_ACTIVE DATE,
15 p_N_END_DATE_ACTIVE DATE,
16 p_N_RANK NUMBER,
17 p_N_UPDATE_FLAG VARCHAR2,
18 p_O_LAST_UPDATED_BY NUMBER,
19 p_O_LAST_UPDATE_DATE DATE,
20 p_O_CREATED_BY NUMBER,
21 p_O_CREATION_DATE DATE,
22 p_O_LAST_UPDATE_LOGIN NUMBER,
23 p_O_TERR_QUAL_ID NUMBER,
24 p_O_INCLUDE_FLAG VARCHAR2,
25 p_O_COMPARISON_OPERATOR VARCHAR2,
26 p_O_ID_USED_FLAG VARCHAR2,
27 p_O_LOW_VALUE_CHAR_ID NUMBER,
28 p_O_LOW_VALUE_CHAR VARCHAR2,
29 p_O_HIGH_VALUE_CHAR VARCHAR2,
30 p_O_LOW_VALUE_NUMBER NUMBER,
31 p_O_HIGH_VALUE_NUMBER NUMBER,
32 p_O_VALUE_SET NUMBER,
33 p_O_INTEREST_TYPE_ID NUMBER,
34 p_O_PRI_INTEREST_CODE_ID NUMBER,
35 p_O_SEC_INTEREST_CODE_ID NUMBER,
36 p_O_CURRENCY_CODE VARCHAR2,
37 p_N_LAST_UPDATED_BY NUMBER,
38 p_N_LAST_UPDATE_DATE DATE,
39 p_N_CREATED_BY NUMBER,
40 p_N_CREATION_DATE DATE,
41 p_N_LAST_UPDATE_LOGIN NUMBER,
42 p_N_TERR_QUAL_ID NUMBER,
43 p_N_INCLUDE_FLAG VARCHAR2,
44 p_N_COMPARISON_OPERATOR VARCHAR2,
45 p_N_ID_USED_FLAG VARCHAR2,
46 p_N_LOW_VALUE_CHAR_ID NUMBER,
47 p_N_LOW_VALUE_CHAR VARCHAR2,
48 p_N_HIGH_VALUE_CHAR VARCHAR2,
49 p_N_LOW_VALUE_NUMBER NUMBER,
50 p_N_HIGH_VALUE_NUMBER NUMBER,
51 p_N_VALUE_SET NUMBER,
52 p_N_INTEREST_TYPE_ID NUMBER,
53 p_N_PRI_INTEREST_CODE_ID NUMBER,
54 p_N_SEC_INTEREST_CODE_ID NUMBER,
55 p_N_CURRENCY_CODE VARCHAR2,
56 p_O_RESOURCE_ID NUMBER,
57 p_O_RESOURCE_TYPE VARCHAR2,
58 p_O_ROLE VARCHAR2,
59 p_O_PRI_CONTACT_FLAG VARCHAR2,
60 p_O_FULL_ACCESS_FLAG VARCHAR2,
61 p_N_RESOURCE_ID NUMBER,
62 p_N_RESOURCE_TYPE VARCHAR2,
63 p_N_ROLE VARCHAR2,
64 p_N_PRI_CONTACT_FLAG VARCHAR2,
65 p_N_FULL_ACCESS_FLAG VARCHAR2,
66 p_TRANSFER_ONLY_FLAG VARCHAR2,
67 p_REQUEST_ID NUMBER,
68 p_TERR_RSC_ID NUMBER,
69 p_ORG_ID NUMBER)
70
71 IS
72 BEGIN
73 INSERT INTO JTF_CHANGED_TERR_ALL(
74 TERR_ID,
75 TERR_VALUE_ID,
76 TRIGGER_MODE,
77 ACTION,
78 PARENT_TERRITORY_ID,
79 OLD_START_DATE_ACTIVE,
80 OLD_END_DATE_ACTIVE,
81 OLD_RANK,
82 OLD_UPDATE_FLAG,
83 NEW_START_DATE_ACTIVE,
84 NEW_END_DATE_ACTIVE,
85 NEW_RANK,
86 NEW_UPDATE_FLAG,
87 OLD_LAST_UPDATED_BY,
88 OLD_LAST_UPDATE_DATE,
89 OLD_CREATED_BY,
90 OLD_CREATION_DATE,
91 OLD_LAST_UPDATE_LOGIN,
92 OLD_TERR_QUAL_ID,
93 OLD_INCLUDE_FLAG,
94 OLD_COMPARISON_OPERATOR,
95 OLD_ID_USED_FLAG,
96 OLD_LOW_VALUE_CHAR_ID,
97 OLD_LOW_VALUE_CHAR,
98 OLD_HIGH_VALUE_CHAR,
99 OLD_LOW_VALUE_NUMBER,
100 OLD_HIGH_VALUE_NUMBER,
101 OLD_VALUE_SET,
102 OLD_INTEREST_TYPE_ID,
103 OLD_PRIMARY_INTEREST_CODE_ID,
104 OLD_SECONDARY_INTEREST_CODE_ID,
105 OLD_CURRENCY_CODE,
106 NEW_LAST_UPDATED_BY,
107 NEW_LAST_UPDATE_DATE,
108 NEW_CREATED_BY,
109 NEW_CREATION_DATE,
110 NEW_LAST_UPDATE_LOGIN,
111 NEW_TERR_QUAL_ID,
112 NEW_INCLUDE_FLAG,
113 NEW_COMPARISON_OPERATOR,
114 NEW_ID_USED_FLAG,
115 NEW_LOW_VALUE_CHAR_ID,
116 NEW_LOW_VALUE_CHAR,
117 NEW_HIGH_VALUE_CHAR,
118 NEW_LOW_VALUE_NUMBER,
119 NEW_HIGH_VALUE_NUMBER,
120 NEW_VALUE_SET,
121 NEW_INTEREST_TYPE_ID,
122 NEW_PRIMARY_INTEREST_CODE_ID,
123 NEW_SECONDARY_INTEREST_CODE_ID,
124 NEW_CURRENCY_CODE,
125 OLD_RESOURCE_ID,
126 OLD_RESOURCE_TYPE,
127 OLD_ROLE,
128 OLD_PRIMARY_CONTACT_FLAG,
129 OLD_FULL_ACCESS_FLAG,
130 NEW_RESOURCE_ID,
131 NEW_RESOURCE_TYPE,
132 NEW_ROLE,
133 NEW_PRIMARY_CONTACT_FLAG,
134 NEW_FULL_ACCESS_FLAG,
135 TRANSFER_ONLY_FLAG,
136 REQUEST_ID,
137 TERR_RSC_ID,
138 ORG_ID
139 ) VALUES (
140 px_TERR_ID,
141 decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_TERR_VALUE_ID),
142 decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, NULL, p_TRIGGER_MODE),
143 decode( p_ACTION, FND_API.G_MISS_CHAR, NULL, p_ACTION),
144 decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_TERRITORY_ID),
145 decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_START_DATE_ACTIVE),
146 decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_END_DATE_ACTIVE),
147 decode( p_O_RANK, FND_API.G_MISS_NUM, NULL, p_O_RANK),
148 decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_UPDATE_FLAG),
149 decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_START_DATE_ACTIVE),
150 decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_END_DATE_ACTIVE),
151 decode( p_N_RANK, FND_API.G_MISS_NUM, NULL, p_N_RANK),
152 decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_UPDATE_FLAG),
153 decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATED_BY),
154 decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_LAST_UPDATE_DATE),
155 decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_O_CREATED_BY),
156 decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_CREATION_DATE),
157 decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATE_LOGIN),
158 decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_O_TERR_QUAL_ID),
159 decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_INCLUDE_FLAG),
160 decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_O_COMPARISON_OPERATOR),
161 decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_ID_USED_FLAG),
162 decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_CHAR_ID),
163 decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_LOW_VALUE_CHAR),
164 decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_HIGH_VALUE_CHAR),
165 decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_NUMBER),
166 decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_HIGH_VALUE_NUMBER),
167 decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_O_VALUE_SET),
168 decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_O_INTEREST_TYPE_ID),
169 decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_PRI_INTEREST_CODE_ID),
170 decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_SEC_INTEREST_CODE_ID),
171 decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_O_CURRENCY_CODE),
172 decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATED_BY),
173 decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_LAST_UPDATE_DATE),
174 decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_N_CREATED_BY),
175 decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_CREATION_DATE),
176 decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATE_LOGIN),
177 decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_N_TERR_QUAL_ID),
178 decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_INCLUDE_FLAG),
179 decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_N_COMPARISON_OPERATOR),
180 decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_ID_USED_FLAG),
181 decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_CHAR_ID),
182 decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_LOW_VALUE_CHAR),
183 decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_HIGH_VALUE_CHAR),
184 decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_NUMBER),
185 decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_HIGH_VALUE_NUMBER),
186 decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_N_VALUE_SET),
187 decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_N_INTEREST_TYPE_ID),
188 decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_PRI_INTEREST_CODE_ID),
189 decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_SEC_INTEREST_CODE_ID),
190 decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_N_CURRENCY_CODE),
191 decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_O_RESOURCE_ID),
192 decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_O_RESOURCE_TYPE),
193 decode( p_O_ROLE, FND_API.G_MISS_CHAR, NULL, p_O_ROLE),
194 decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_PRI_CONTACT_FLAG),
195 decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_FULL_ACCESS_FLAG),
196 decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_N_RESOURCE_ID),
197 decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_N_RESOURCE_TYPE),
198 decode( p_N_ROLE, FND_API.G_MISS_CHAR, NULL, p_N_ROLE),
199 decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_PRI_CONTACT_FLAG),
200 decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_FULL_ACCESS_FLAG),
201 decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_ONLY_FLAG),
202 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
203 decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL, p_TERR_RSC_ID),
204 decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID));
205 End Insert_Row;
206
207 PROCEDURE Update_Row(
208 p_TERR_ID NUMBER,
209 p_TERR_VALUE_ID NUMBER,
210 p_TRIGGER_MODE VARCHAR2,
211 p_ACTION VARCHAR2,
212 p_PARENT_TERRITORY_ID NUMBER,
213 p_O_START_DATE_ACTIVE DATE,
214 p_O_END_DATE_ACTIVE DATE,
215 p_O_RANK NUMBER,
216 p_O_UPDATE_FLAG VARCHAR2,
217 p_N_START_DATE_ACTIVE DATE,
218 p_N_END_DATE_ACTIVE DATE,
219 p_N_RANK NUMBER,
220 p_N_UPDATE_FLAG VARCHAR2,
221 p_O_LAST_UPDATED_BY NUMBER,
222 p_O_LAST_UPDATE_DATE DATE,
223 p_O_CREATED_BY NUMBER,
224 p_O_CREATION_DATE DATE,
225 p_O_LAST_UPDATE_LOGIN NUMBER,
226 p_O_TERR_QUAL_ID NUMBER,
227 p_O_INCLUDE_FLAG VARCHAR2,
228 p_O_COMPARISON_OPERATOR VARCHAR2,
229 p_O_ID_USED_FLAG VARCHAR2,
230 p_O_LOW_VALUE_CHAR_ID NUMBER,
231 p_O_LOW_VALUE_CHAR VARCHAR2,
232 p_O_HIGH_VALUE_CHAR VARCHAR2,
233 p_O_LOW_VALUE_NUMBER NUMBER,
234 p_O_HIGH_VALUE_NUMBER NUMBER,
235 p_O_VALUE_SET NUMBER,
236 p_O_INTEREST_TYPE_ID NUMBER,
237 p_O_PRI_INTEREST_CODE_ID NUMBER,
238 p_O_SEC_INTEREST_CODE_ID NUMBER,
239 p_O_CURRENCY_CODE VARCHAR2,
240 p_N_LAST_UPDATED_BY NUMBER,
241 p_N_LAST_UPDATE_DATE DATE,
242 p_N_CREATED_BY NUMBER,
243 p_N_CREATION_DATE DATE,
244 p_N_LAST_UPDATE_LOGIN NUMBER,
245 p_N_TERR_QUAL_ID NUMBER,
246 p_N_INCLUDE_FLAG VARCHAR2,
247 p_N_COMPARISON_OPERATOR VARCHAR2,
248 p_N_ID_USED_FLAG VARCHAR2,
249 p_N_LOW_VALUE_CHAR_ID NUMBER,
250 p_N_LOW_VALUE_CHAR VARCHAR2,
251 p_N_HIGH_VALUE_CHAR VARCHAR2,
252 p_N_LOW_VALUE_NUMBER NUMBER,
253 p_N_HIGH_VALUE_NUMBER NUMBER,
254 p_N_VALUE_SET NUMBER,
255 p_N_INTEREST_TYPE_ID NUMBER,
256 p_N_PRI_INTEREST_CODE_ID NUMBER,
257 p_N_SEC_INTEREST_CODE_ID NUMBER,
258 p_N_CURRENCY_CODE VARCHAR2,
259 p_O_RESOURCE_ID NUMBER,
260 p_O_RESOURCE_TYPE VARCHAR2,
261 p_O_ROLE VARCHAR2,
262 p_O_PRI_CONTACT_FLAG VARCHAR2,
263 p_O_FULL_ACCESS_FLAG VARCHAR2,
264 p_N_RESOURCE_ID NUMBER,
265 p_N_RESOURCE_TYPE VARCHAR2,
266 p_N_ROLE VARCHAR2,
267 p_N_PRI_CONTACT_FLAG VARCHAR2,
268 p_N_FULL_ACCESS_FLAG VARCHAR2,
269 p_TRANSFER_ONLY_FLAG VARCHAR2,
270 p_REQUEST_ID NUMBER,
271 p_TERR_RSC_ID NUMBER,
272 P_ORG_ID NUMBER)
273
274 IS
275 BEGIN
276 Update JTF_CHANGED_TERR_ALL
277 SET
278 TERR_VALUE_ID = decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, TERR_VALUE_ID, p_TERR_VALUE_ID),
279 TRIGGER_MODE = decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, TRIGGER_MODE, p_TRIGGER_MODE),
280 ACTION = decode( p_ACTION, FND_API.G_MISS_CHAR, ACTION, p_ACTION),
281 PARENT_TERRITORY_ID = decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, PARENT_TERRITORY_ID, p_PARENT_TERRITORY_ID),
285 OLD_UPDATE_FLAG = decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, OLD_UPDATE_FLAG, p_O_UPDATE_FLAG),
282 OLD_START_DATE_ACTIVE = decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_START_DATE_ACTIVE, p_O_START_DATE_ACTIVE),
283 OLD_END_DATE_ACTIVE = decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_END_DATE_ACTIVE, p_O_END_DATE_ACTIVE),
284 OLD_RANK = decode( p_O_RANK, FND_API.G_MISS_NUM, OLD_RANK, p_O_RANK),
286 NEW_START_DATE_ACTIVE = decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_START_DATE_ACTIVE, p_N_START_DATE_ACTIVE),
287 NEW_END_DATE_ACTIVE = decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_END_DATE_ACTIVE, p_N_END_DATE_ACTIVE),
288 NEW_RANK = decode( p_N_RANK, FND_API.G_MISS_NUM, NEW_RANK, p_N_RANK),
289 NEW_UPDATE_FLAG = decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NEW_UPDATE_FLAG, p_N_UPDATE_FLAG),
290 OLD_LAST_UPDATED_BY = decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, OLD_LAST_UPDATED_BY, p_O_LAST_UPDATED_BY),
291 OLD_LAST_UPDATE_DATE = decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, OLD_LAST_UPDATE_DATE, p_O_LAST_UPDATE_DATE),
292 OLD_CREATED_BY = decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, OLD_CREATED_BY, p_O_CREATED_BY),
293 OLD_CREATION_DATE = decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, OLD_CREATION_DATE, p_O_CREATION_DATE),
294 OLD_LAST_UPDATE_LOGIN = decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, OLD_LAST_UPDATE_LOGIN, p_O_LAST_UPDATE_LOGIN),
295 OLD_TERR_QUAL_ID = decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, OLD_TERR_QUAL_ID, p_O_TERR_QUAL_ID),
296 OLD_INCLUDE_FLAG = decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, OLD_INCLUDE_FLAG, p_O_INCLUDE_FLAG),
297 OLD_COMPARISON_OPERATOR = decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, OLD_COMPARISON_OPERATOR, p_O_COMPARISON_OPERATOR),
298 OLD_ID_USED_FLAG = decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, OLD_ID_USED_FLAG, p_O_ID_USED_FLAG),
299 OLD_LOW_VALUE_CHAR_ID = decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, OLD_LOW_VALUE_CHAR_ID, p_O_LOW_VALUE_CHAR_ID),
300 OLD_LOW_VALUE_CHAR = decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_LOW_VALUE_CHAR, p_O_LOW_VALUE_CHAR),
301 OLD_HIGH_VALUE_CHAR = decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_HIGH_VALUE_CHAR, p_O_HIGH_VALUE_CHAR),
302 OLD_LOW_VALUE_NUMBER = decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_LOW_VALUE_NUMBER, p_O_LOW_VALUE_NUMBER),
303 OLD_HIGH_VALUE_NUMBER = decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_HIGH_VALUE_NUMBER, p_O_HIGH_VALUE_NUMBER),
304 OLD_VALUE_SET = decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, OLD_VALUE_SET, p_O_VALUE_SET),
305 OLD_INTEREST_TYPE_ID = decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, OLD_INTEREST_TYPE_ID, p_O_INTEREST_TYPE_ID),
306 OLD_PRIMARY_INTEREST_CODE_ID = decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_PRIMARY_INTEREST_CODE_ID, p_O_PRI_INTEREST_CODE_ID),
307 OLD_SECONDARY_INTEREST_CODE_ID = decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_SECONDARY_INTEREST_CODE_ID, p_O_SEC_INTEREST_CODE_ID),
308 OLD_CURRENCY_CODE = decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_CURRENCY_CODE, p_O_CURRENCY_CODE),
309 NEW_LAST_UPDATED_BY = decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NEW_LAST_UPDATED_BY, p_N_LAST_UPDATED_BY),
310 NEW_LAST_UPDATE_DATE = decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NEW_LAST_UPDATE_DATE, p_N_LAST_UPDATE_DATE),
311 NEW_CREATED_BY = decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NEW_CREATED_BY, p_N_CREATED_BY),
312 NEW_CREATION_DATE = decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, NEW_CREATION_DATE, p_N_CREATION_DATE),
313 NEW_LAST_UPDATE_LOGIN = decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NEW_LAST_UPDATE_LOGIN, p_N_LAST_UPDATE_LOGIN),
314 NEW_TERR_QUAL_ID = decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NEW_TERR_QUAL_ID, p_N_TERR_QUAL_ID),
315 NEW_INCLUDE_FLAG = decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NEW_INCLUDE_FLAG, p_N_INCLUDE_FLAG),
316 NEW_COMPARISON_OPERATOR = decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NEW_COMPARISON_OPERATOR, p_N_COMPARISON_OPERATOR),
317 NEW_ID_USED_FLAG = decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NEW_ID_USED_FLAG, p_N_ID_USED_FLAG),
318 NEW_LOW_VALUE_CHAR_ID = decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NEW_LOW_VALUE_CHAR_ID, p_N_LOW_VALUE_CHAR_ID),
319 NEW_LOW_VALUE_CHAR = decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_LOW_VALUE_CHAR, p_N_LOW_VALUE_CHAR),
320 NEW_HIGH_VALUE_CHAR = decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_HIGH_VALUE_CHAR, p_N_HIGH_VALUE_CHAR),
321 NEW_LOW_VALUE_NUMBER = decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_LOW_VALUE_NUMBER, p_N_LOW_VALUE_NUMBER),
322 NEW_HIGH_VALUE_NUMBER = decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_HIGH_VALUE_NUMBER, p_N_HIGH_VALUE_NUMBER),
323 NEW_VALUE_SET = decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NEW_VALUE_SET, p_N_VALUE_SET),
324 NEW_INTEREST_TYPE_ID = decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NEW_INTEREST_TYPE_ID, p_N_INTEREST_TYPE_ID),
325 NEW_PRIMARY_INTEREST_CODE_ID = decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_PRIMARY_INTEREST_CODE_ID, p_N_PRI_INTEREST_CODE_ID),
326 NEW_SECONDARY_INTEREST_CODE_ID = decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_SECONDARY_INTEREST_CODE_ID, p_N_SEC_INTEREST_CODE_ID),
327 NEW_CURRENCY_CODE = decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_CURRENCY_CODE, p_N_CURRENCY_CODE),
328 OLD_RESOURCE_ID = decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, OLD_RESOURCE_ID, p_O_RESOURCE_ID),
329 OLD_RESOURCE_TYPE = decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, OLD_RESOURCE_TYPE, p_O_RESOURCE_TYPE),
330 OLD_ROLE = decode( p_O_ROLE, FND_API.G_MISS_CHAR, OLD_ROLE, p_O_ROLE),
331 OLD_PRIMARY_CONTACT_FLAG = decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, OLD_PRIMARY_CONTACT_FLAG, p_O_PRI_CONTACT_FLAG),
332 OLD_FULL_ACCESS_FLAG = decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, OLD_FULL_ACCESS_FLAG, p_O_FULL_ACCESS_FLAG),
336 NEW_PRIMARY_CONTACT_FLAG = decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NEW_PRIMARY_CONTACT_FLAG, p_N_PRI_CONTACT_FLAG),
333 NEW_RESOURCE_ID = decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NEW_RESOURCE_ID, p_N_RESOURCE_ID),
334 NEW_RESOURCE_TYPE = decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NEW_RESOURCE_TYPE, p_N_RESOURCE_TYPE),
335 NEW_ROLE = decode( p_N_ROLE, FND_API.G_MISS_CHAR, NEW_ROLE, p_N_ROLE),
337 NEW_FULL_ACCESS_FLAG = decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NEW_FULL_ACCESS_FLAG, p_N_FULL_ACCESS_FLAG),
338 TRANSFER_ONLY_FLAG = decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, TRANSFER_ONLY_FLAG, p_TRANSFER_ONLY_FLAG),
339 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
340 TERR_RSC_ID = decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, TERR_RSC_ID, p_TERR_RSC_ID),
341 ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)
342 where TERR_ID = p_TERR_ID;
343
344 If (SQL%NOTFOUND) then
345 RAISE NO_DATA_FOUND;
346 End If;
347 END Update_Row;
348
349 PROCEDURE Delete_Row(
350 p_TERR_ID NUMBER)
351 IS
352 BEGIN
353 DELETE FROM JTF_CHANGED_TERR_ALL
354 WHERE TERR_ID = p_TERR_ID;
355 If (SQL%NOTFOUND) then
356 RAISE NO_DATA_FOUND;
357 End If;
358 END Delete_Row;
359
360 PROCEDURE Lock_Row(
361 p_TERR_ID NUMBER,
362 p_TERR_VALUE_ID NUMBER,
363 p_TRIGGER_MODE VARCHAR2,
364 p_ACTION VARCHAR2,
365 p_PARENT_TERRITORY_ID NUMBER,
366 p_O_START_DATE_ACTIVE DATE,
367 p_O_END_DATE_ACTIVE DATE,
368 p_O_RANK NUMBER,
369 p_O_UPDATE_FLAG VARCHAR2,
370 p_N_START_DATE_ACTIVE DATE,
371 p_N_END_DATE_ACTIVE DATE,
372 p_N_RANK NUMBER,
373 p_N_UPDATE_FLAG VARCHAR2,
374 p_O_LAST_UPDATED_BY NUMBER,
375 p_O_LAST_UPDATE_DATE DATE,
376 p_O_CREATED_BY NUMBER,
377 p_O_CREATION_DATE DATE,
378 p_O_LAST_UPDATE_LOGIN NUMBER,
379 p_O_TERR_QUAL_ID NUMBER,
380 p_O_INCLUDE_FLAG VARCHAR2,
381 p_O_COMPARISON_OPERATOR VARCHAR2,
382 p_O_ID_USED_FLAG VARCHAR2,
383 p_O_LOW_VALUE_CHAR_ID NUMBER,
384 p_O_LOW_VALUE_CHAR VARCHAR2,
385 p_O_HIGH_VALUE_CHAR VARCHAR2,
386 p_O_LOW_VALUE_NUMBER NUMBER,
387 p_O_HIGH_VALUE_NUMBER NUMBER,
388 p_O_VALUE_SET NUMBER,
389 p_O_INTEREST_TYPE_ID NUMBER,
390 p_O_PRI_INTEREST_CODE_ID NUMBER,
391 p_O_SEC_INTEREST_CODE_ID NUMBER,
392 p_O_CURRENCY_CODE VARCHAR2,
393 p_N_LAST_UPDATED_BY NUMBER,
394 p_N_LAST_UPDATE_DATE DATE,
395 p_N_CREATED_BY NUMBER,
396 p_N_CREATION_DATE DATE,
397 p_N_LAST_UPDATE_LOGIN NUMBER,
398 p_N_TERR_QUAL_ID NUMBER,
399 p_N_INCLUDE_FLAG VARCHAR2,
400 p_N_COMPARISON_OPERATOR VARCHAR2,
401 p_N_ID_USED_FLAG VARCHAR2,
402 p_N_LOW_VALUE_CHAR_ID NUMBER,
403 p_N_LOW_VALUE_CHAR VARCHAR2,
404 p_N_HIGH_VALUE_CHAR VARCHAR2,
405 p_N_LOW_VALUE_NUMBER NUMBER,
406 p_N_HIGH_VALUE_NUMBER NUMBER,
407 p_N_VALUE_SET NUMBER,
408 p_N_INTEREST_TYPE_ID NUMBER,
409 p_N_PRI_INTEREST_CODE_ID NUMBER,
410 p_N_SEC_INTEREST_CODE_ID NUMBER,
411 p_N_CURRENCY_CODE VARCHAR2,
412 p_O_RESOURCE_ID NUMBER,
413 p_O_RESOURCE_TYPE VARCHAR2,
414 p_O_ROLE VARCHAR2,
415 p_O_PRI_CONTACT_FLAG VARCHAR2,
416 p_O_FULL_ACCESS_FLAG VARCHAR2,
417 p_N_RESOURCE_ID NUMBER,
418 p_N_RESOURCE_TYPE VARCHAR2,
419 p_N_ROLE VARCHAR2,
420 p_N_PRI_CONTACT_FLAG VARCHAR2,
421 p_N_FULL_ACCESS_FLAG VARCHAR2,
422 p_TRANSFER_ONLY_FLAG VARCHAR2,
423 p_REQUEST_ID NUMBER,
424 p_TERR_RSC_ID NUMBER,
425 p_ORG_ID NUMBER)
426
427 IS
428 CURSOR C IS
429 SELECT *
430 FROM JTF_CHANGED_TERR
431 WHERE TERR_ID = p_TERR_ID
432 FOR UPDATE of TERR_ID NOWAIT;
433 Recinfo C%ROWTYPE;
434 BEGIN
435 OPEN C;
436 FETCH C INTO Recinfo;
437 If (C%NOTFOUND) then
438 CLOSE C;
439 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
440 APP_EXCEPTION.RAISE_EXCEPTION;
441 End If;
442 CLOSE C;
443 if (
444 ( Recinfo.TERR_ID = p_TERR_ID)
445 AND ( ( Recinfo.TERR_VALUE_ID = p_TERR_VALUE_ID)
446 OR ( ( Recinfo.TERR_VALUE_ID IS NULL )
447 AND ( p_TERR_VALUE_ID IS NULL )))
448 AND ( ( Recinfo.TRIGGER_MODE = p_TRIGGER_MODE)
449 OR ( ( Recinfo.TRIGGER_MODE IS NULL )
450 AND ( p_TRIGGER_MODE IS NULL )))
451 AND ( ( Recinfo.ACTION = p_ACTION)
452 OR ( ( Recinfo.ACTION IS NULL )
453 AND ( p_ACTION IS NULL )))
454 AND ( ( Recinfo.PARENT_TERRITORY_ID = p_PARENT_TERRITORY_ID)
455 OR ( ( Recinfo.PARENT_TERRITORY_ID IS NULL )
456 AND ( p_PARENT_TERRITORY_ID IS NULL )))
457 AND ( ( Recinfo.OLD_START_DATE_ACTIVE = p_O_START_DATE_ACTIVE)
458 OR ( ( Recinfo.OLD_START_DATE_ACTIVE IS NULL )
459 AND ( p_O_START_DATE_ACTIVE IS NULL )))
460 AND ( ( Recinfo.OLD_END_DATE_ACTIVE = p_O_END_DATE_ACTIVE)
461 OR ( ( Recinfo.OLD_END_DATE_ACTIVE IS NULL )
465 AND ( p_O_RANK IS NULL )))
462 AND ( p_O_END_DATE_ACTIVE IS NULL )))
463 AND ( ( Recinfo.OLD_RANK = p_O_RANK)
464 OR ( ( Recinfo.OLD_RANK IS NULL )
466 AND ( ( Recinfo.OLD_UPDATE_FLAG = p_O_UPDATE_FLAG)
467 OR ( ( Recinfo.OLD_UPDATE_FLAG IS NULL )
468 AND ( p_O_UPDATE_FLAG IS NULL )))
469 AND ( ( Recinfo.NEW_START_DATE_ACTIVE = p_N_START_DATE_ACTIVE)
470 OR ( ( Recinfo.NEW_START_DATE_ACTIVE IS NULL )
471 AND ( p_N_START_DATE_ACTIVE IS NULL )))
472 AND ( ( Recinfo.NEW_END_DATE_ACTIVE = p_N_END_DATE_ACTIVE)
473 OR ( ( Recinfo.NEW_END_DATE_ACTIVE IS NULL )
474 AND ( p_N_END_DATE_ACTIVE IS NULL )))
475 AND ( ( Recinfo.NEW_RANK = p_N_RANK)
476 OR ( ( Recinfo.NEW_RANK IS NULL )
477 AND ( p_N_RANK IS NULL )))
478 AND ( ( Recinfo.NEW_UPDATE_FLAG = p_N_UPDATE_FLAG)
479 OR ( ( Recinfo.NEW_UPDATE_FLAG IS NULL )
480 AND ( p_N_UPDATE_FLAG IS NULL )))
481 AND ( ( Recinfo.OLD_LAST_UPDATED_BY = p_O_LAST_UPDATED_BY)
482 OR ( ( Recinfo.OLD_LAST_UPDATED_BY IS NULL )
483 AND ( p_O_LAST_UPDATED_BY IS NULL )))
484 AND ( ( Recinfo.OLD_LAST_UPDATE_DATE = p_O_LAST_UPDATE_DATE)
485 OR ( ( Recinfo.OLD_LAST_UPDATE_DATE IS NULL )
486 AND ( p_O_LAST_UPDATE_DATE IS NULL )))
487 AND ( ( Recinfo.OLD_CREATED_BY = p_O_CREATED_BY)
488 OR ( ( Recinfo.OLD_CREATED_BY IS NULL )
489 AND ( p_O_CREATED_BY IS NULL )))
490 AND ( ( Recinfo.OLD_CREATION_DATE = p_O_CREATION_DATE)
491 OR ( ( Recinfo.OLD_CREATION_DATE IS NULL )
492 AND ( p_O_CREATION_DATE IS NULL )))
493 AND ( ( Recinfo.OLD_LAST_UPDATE_LOGIN = p_O_LAST_UPDATE_LOGIN)
494 OR ( ( Recinfo.OLD_LAST_UPDATE_LOGIN IS NULL )
495 AND ( p_O_LAST_UPDATE_LOGIN IS NULL )))
496 AND ( ( Recinfo.OLD_TERR_QUAL_ID = p_O_TERR_QUAL_ID)
497 OR ( ( Recinfo.OLD_TERR_QUAL_ID IS NULL )
498 AND ( p_O_TERR_QUAL_ID IS NULL )))
499 AND ( ( Recinfo.OLD_INCLUDE_FLAG = p_O_INCLUDE_FLAG)
500 OR ( ( Recinfo.OLD_INCLUDE_FLAG IS NULL )
501 AND ( p_O_INCLUDE_FLAG IS NULL )))
502 AND ( ( Recinfo.OLD_COMPARISON_OPERATOR = p_O_COMPARISON_OPERATOR)
503 OR ( ( Recinfo.OLD_COMPARISON_OPERATOR IS NULL )
504 AND ( p_O_COMPARISON_OPERATOR IS NULL )))
505 AND ( ( Recinfo.OLD_ID_USED_FLAG = p_O_ID_USED_FLAG)
506 OR ( ( Recinfo.OLD_ID_USED_FLAG IS NULL )
507 AND ( p_O_ID_USED_FLAG IS NULL )))
508 AND ( ( Recinfo.OLD_LOW_VALUE_CHAR_ID = p_O_LOW_VALUE_CHAR_ID)
509 OR ( ( Recinfo.OLD_LOW_VALUE_CHAR_ID IS NULL )
510 AND ( p_O_LOW_VALUE_CHAR_ID IS NULL )))
511 AND ( ( Recinfo.OLD_LOW_VALUE_CHAR = p_O_LOW_VALUE_CHAR)
512 OR ( ( Recinfo.OLD_LOW_VALUE_CHAR IS NULL )
513 AND ( p_O_LOW_VALUE_CHAR IS NULL )))
514 AND ( ( Recinfo.OLD_HIGH_VALUE_CHAR = p_O_HIGH_VALUE_CHAR)
515 OR ( ( Recinfo.OLD_HIGH_VALUE_CHAR IS NULL )
516 AND ( p_O_HIGH_VALUE_CHAR IS NULL )))
517 AND ( ( Recinfo.OLD_LOW_VALUE_NUMBER = p_O_LOW_VALUE_NUMBER)
518 OR ( ( Recinfo.OLD_LOW_VALUE_NUMBER IS NULL )
519 AND ( p_O_LOW_VALUE_NUMBER IS NULL )))
520 AND ( ( Recinfo.OLD_HIGH_VALUE_NUMBER = p_O_HIGH_VALUE_NUMBER)
521 OR ( ( Recinfo.OLD_HIGH_VALUE_NUMBER IS NULL )
522 AND ( p_O_HIGH_VALUE_NUMBER IS NULL )))
523 AND ( ( Recinfo.OLD_VALUE_SET = p_O_VALUE_SET)
524 OR ( ( Recinfo.OLD_VALUE_SET IS NULL )
525 AND ( p_O_VALUE_SET IS NULL )))
526 AND ( ( Recinfo.OLD_INTEREST_TYPE_ID = p_O_INTEREST_TYPE_ID)
527 OR ( ( Recinfo.OLD_INTEREST_TYPE_ID IS NULL )
528 AND ( p_O_INTEREST_TYPE_ID IS NULL )))
529 AND ( ( Recinfo.OLD_PRIMARY_INTEREST_CODE_ID = p_O_PRI_INTEREST_CODE_ID)
530 OR ( ( Recinfo.OLD_PRIMARY_INTEREST_CODE_ID IS NULL )
531 AND ( p_O_PRI_INTEREST_CODE_ID IS NULL )))
532 AND ( ( Recinfo.OLD_SECONDARY_INTEREST_CODE_ID = p_O_SEC_INTEREST_CODE_ID)
533 OR ( ( Recinfo.OLD_SECONDARY_INTEREST_CODE_ID IS NULL )
534 AND ( p_O_SEC_INTEREST_CODE_ID IS NULL )))
535 AND ( ( Recinfo.OLD_CURRENCY_CODE = p_O_CURRENCY_CODE)
536 OR ( ( Recinfo.OLD_CURRENCY_CODE IS NULL )
537 AND ( p_O_CURRENCY_CODE IS NULL )))
538 AND ( ( Recinfo.NEW_LAST_UPDATED_BY = p_N_LAST_UPDATED_BY)
539 OR ( ( Recinfo.NEW_LAST_UPDATED_BY IS NULL )
540 AND ( p_N_LAST_UPDATED_BY IS NULL )))
541 AND ( ( Recinfo.NEW_LAST_UPDATE_DATE = p_N_LAST_UPDATE_DATE)
542 OR ( ( Recinfo.NEW_LAST_UPDATE_DATE IS NULL )
543 AND ( p_N_LAST_UPDATE_DATE IS NULL )))
544 AND ( ( Recinfo.NEW_CREATED_BY = p_N_CREATED_BY)
545 OR ( ( Recinfo.NEW_CREATED_BY IS NULL )
546 AND ( p_N_CREATED_BY IS NULL )))
547 AND ( ( Recinfo.NEW_CREATION_DATE = p_N_CREATION_DATE)
548 OR ( ( Recinfo.NEW_CREATION_DATE IS NULL )
549 AND ( p_N_CREATION_DATE IS NULL )))
550 AND ( ( Recinfo.NEW_LAST_UPDATE_LOGIN = p_N_LAST_UPDATE_LOGIN)
551 OR ( ( Recinfo.NEW_LAST_UPDATE_LOGIN IS NULL )
552 AND ( p_N_LAST_UPDATE_LOGIN IS NULL )))
553 AND ( ( Recinfo.NEW_TERR_QUAL_ID = p_N_TERR_QUAL_ID)
554 OR ( ( Recinfo.NEW_TERR_QUAL_ID IS NULL )
555 AND ( p_N_TERR_QUAL_ID IS NULL )))
556 AND ( ( Recinfo.NEW_INCLUDE_FLAG = p_N_INCLUDE_FLAG)
557 OR ( ( Recinfo.NEW_INCLUDE_FLAG IS NULL )
558 AND ( p_N_INCLUDE_FLAG IS NULL )))
562 AND ( ( Recinfo.NEW_ID_USED_FLAG = p_N_ID_USED_FLAG)
559 AND ( ( Recinfo.NEW_COMPARISON_OPERATOR = p_N_COMPARISON_OPERATOR)
560 OR ( ( Recinfo.NEW_COMPARISON_OPERATOR IS NULL )
561 AND ( p_N_COMPARISON_OPERATOR IS NULL )))
563 OR ( ( Recinfo.NEW_ID_USED_FLAG IS NULL )
564 AND ( p_N_ID_USED_FLAG IS NULL )))
565 AND ( ( Recinfo.NEW_LOW_VALUE_CHAR_ID = p_N_LOW_VALUE_CHAR_ID)
566 OR ( ( Recinfo.NEW_LOW_VALUE_CHAR_ID IS NULL )
567 AND ( p_N_LOW_VALUE_CHAR_ID IS NULL )))
568 AND ( ( Recinfo.NEW_LOW_VALUE_CHAR = p_N_LOW_VALUE_CHAR)
569 OR ( ( Recinfo.NEW_LOW_VALUE_CHAR IS NULL )
570 AND ( p_N_LOW_VALUE_CHAR IS NULL )))
571 AND ( ( Recinfo.NEW_HIGH_VALUE_CHAR = p_N_HIGH_VALUE_CHAR)
572 OR ( ( Recinfo.NEW_HIGH_VALUE_CHAR IS NULL )
573 AND ( p_N_HIGH_VALUE_CHAR IS NULL )))
574 AND ( ( Recinfo.NEW_LOW_VALUE_NUMBER = p_N_LOW_VALUE_NUMBER)
575 OR ( ( Recinfo.NEW_LOW_VALUE_NUMBER IS NULL )
576 AND ( p_N_LOW_VALUE_NUMBER IS NULL )))
577 AND ( ( Recinfo.NEW_HIGH_VALUE_NUMBER = p_N_HIGH_VALUE_NUMBER)
578 OR ( ( Recinfo.NEW_HIGH_VALUE_NUMBER IS NULL )
579 AND ( p_N_HIGH_VALUE_NUMBER IS NULL )))
580 AND ( ( Recinfo.NEW_VALUE_SET = p_N_VALUE_SET)
581 OR ( ( Recinfo.NEW_VALUE_SET IS NULL )
582 AND ( p_N_VALUE_SET IS NULL )))
583 AND ( ( Recinfo.NEW_INTEREST_TYPE_ID = p_N_INTEREST_TYPE_ID)
584 OR ( ( Recinfo.NEW_INTEREST_TYPE_ID IS NULL )
585 AND ( p_N_INTEREST_TYPE_ID IS NULL )))
586 AND ( ( Recinfo.NEW_PRIMARY_INTEREST_CODE_ID = p_N_PRI_INTEREST_CODE_ID)
587 OR ( ( Recinfo.NEW_PRIMARY_INTEREST_CODE_ID IS NULL )
588 AND ( p_N_PRI_INTEREST_CODE_ID IS NULL )))
589 AND ( ( Recinfo.NEW_SECONDARY_INTEREST_CODE_ID = p_N_SEC_INTEREST_CODE_ID)
590 OR ( ( Recinfo.NEW_SECONDARY_INTEREST_CODE_ID IS NULL )
591 AND ( p_N_SEC_INTEREST_CODE_ID IS NULL )))
592 AND ( ( Recinfo.NEW_CURRENCY_CODE = p_N_CURRENCY_CODE)
593 OR ( ( Recinfo.NEW_CURRENCY_CODE IS NULL )
594 AND ( p_N_CURRENCY_CODE IS NULL )))
595 AND ( ( Recinfo.OLD_RESOURCE_ID = p_O_RESOURCE_ID)
596 OR ( ( Recinfo.OLD_RESOURCE_ID IS NULL )
597 AND ( p_O_RESOURCE_ID IS NULL )))
598 AND ( ( Recinfo.OLD_RESOURCE_TYPE = p_O_RESOURCE_TYPE)
599 OR ( ( Recinfo.OLD_RESOURCE_TYPE IS NULL )
600 AND ( p_O_RESOURCE_TYPE IS NULL )))
601 AND ( ( Recinfo.OLD_ROLE = p_O_ROLE)
602 OR ( ( Recinfo.OLD_ROLE IS NULL )
603 AND ( p_O_ROLE IS NULL )))
604 AND ( ( Recinfo.OLD_PRIMARY_CONTACT_FLAG = p_O_PRI_CONTACT_FLAG)
605 OR ( ( Recinfo.OLD_PRIMARY_CONTACT_FLAG IS NULL )
606 AND ( p_O_PRI_CONTACT_FLAG IS NULL )))
607 AND ( ( Recinfo.OLD_FULL_ACCESS_FLAG = p_O_FULL_ACCESS_FLAG)
608 OR ( ( Recinfo.OLD_FULL_ACCESS_FLAG IS NULL )
609 AND ( p_O_FULL_ACCESS_FLAG IS NULL )))
610 AND ( ( Recinfo.NEW_RESOURCE_ID = p_N_RESOURCE_ID)
611 OR ( ( Recinfo.NEW_RESOURCE_ID IS NULL )
612 AND ( p_N_RESOURCE_ID IS NULL )))
613 AND ( ( Recinfo.NEW_RESOURCE_TYPE = p_N_RESOURCE_TYPE)
614 OR ( ( Recinfo.NEW_RESOURCE_TYPE IS NULL )
615 AND ( p_N_RESOURCE_TYPE IS NULL )))
616 AND ( ( Recinfo.NEW_ROLE = p_N_ROLE)
617 OR ( ( Recinfo.NEW_ROLE IS NULL )
618 AND ( p_N_ROLE IS NULL )))
619 AND ( ( Recinfo.NEW_PRIMARY_CONTACT_FLAG = p_N_PRI_CONTACT_FLAG)
620 OR ( ( Recinfo.NEW_PRIMARY_CONTACT_FLAG IS NULL )
621 AND ( p_N_PRI_CONTACT_FLAG IS NULL )))
622 AND ( ( Recinfo.NEW_FULL_ACCESS_FLAG = p_N_FULL_ACCESS_FLAG)
623 OR ( ( Recinfo.NEW_FULL_ACCESS_FLAG IS NULL )
624 AND ( p_N_FULL_ACCESS_FLAG IS NULL )))
625 AND ( ( Recinfo.TRANSFER_ONLY_FLAG = p_TRANSFER_ONLY_FLAG)
626 OR ( ( Recinfo.TRANSFER_ONLY_FLAG IS NULL )
627 AND ( p_TRANSFER_ONLY_FLAG IS NULL )))
628 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
629 OR ( ( Recinfo.REQUEST_ID IS NULL )
630 AND ( p_REQUEST_ID IS NULL )))
631 AND ( ( Recinfo.TERR_RSC_ID = p_TERR_RSC_ID)
632 OR ( ( Recinfo.TERR_RSC_ID IS NULL )
633 AND ( p_TERR_RSC_ID IS NULL )))
634 AND ( ( Recinfo.ORG_ID = p_ORG_ID)
635 OR ( ( Recinfo.ORG_ID IS NULL )
636 AND ( p_ORG_ID IS NULL )))
637 ) then
638 return;
639 else
640 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
641 APP_EXCEPTION.RAISE_EXCEPTION;
642 End If;
643 END Lock_Row;
644
645 End JTF_CHANGED_TERR_PKG;