[Home] [Help]
PACKAGE BODY: APPS.ASG_PUB_ITEM_PKG
Source
1 PACKAGE BODY ASG_PUB_ITEM_PKG as
2 /* $Header: asgpubib.pls 120.1 2005/08/12 02:54:54 saradhak noship $ */
3
4
5 --HISTORY
6 -- Sep 21, 2004 yazhang using oracle_id other than hardcoded name for owner columns
7 -- MAR 31, 2003 ytian updated update_row not to update creation_date.
8 -- MAR 13, 2003 ytian added alter/force_release_verison
9 -- Feb 12, 2003 yazhang add detect_conflict and conflict_callout columns
10 -- DEC 03, 2002 ytian Modified the update_row not to update the customized objects
11 -- NOV 05, 2002 yazhang add APPLY_SYNCHRONOUS
12 -- AUG 30, 2002 ytian Added two columns ACC_LAST/CURRENT_RELEASE_VERSION
13 -- AUG 05, 2002 ytian added two clumns ACCESS_OWNER/NAME
14 -- JUL 11, 2002 ytian modified insert_row
15 -- JUN 26, 2002 ytian modified not to update STATUS.
16 -- JUN 03, 2002 ytian Modified _ID to varchar2 type.
17 -- MAY 08, 2002 ytian added INQ_NAME, FORCE_COMPLETE_REFRESH,
18 -- CALLOUT_PROCEDURE, INQ_OWNER
19 -- MAR 22 2002 ytian Modified insert_row to insert last_release_version
20 -- as 0, so it gets upgraded/created first time.
21 -- MAR 21 2002 ytian modified update_row not to update
22 -- last_release_version
23 -- MAR 12, 2002 ytian added updatable, and disabled_dml columns
24 -- MAR 10, 2002 ytian created.
25
26 procedure insert_row (
27 x_ITEM_ID in VARCHAR2,
28 x_NAME in VARCHAR2,
29 x_PUB_NAME in VARCHAR2,
30 x_BASE_OWNER in VARCHAR2,
31 x_BASE_OBJECT_NAME in VARCHAR2,
32 x_PRIMARY_KEY_COLUMN in VARCHAR2,
33 x_CONFLICT_RULE in VARCHAR2,
34 x_RESTRICTING_PREDICATE in VARCHAR2,
35 x_HIGH_PRIORITY in VARCHAR2,
36 x_TABLE_WEIGHT in VARCHAR2,
37 x_PUB_ID in VARCHAR2,
38 x_STATUS in VARCHAR2,
39 x_LAST_RELEASE_VERSION in NUMBER,
40 x_CURRENT_RELEASE_VERSION in NUMBER,
41 x_ACC_LAST_RELEASE_VERSION in NUMBER,
42 x_ACC_CURRENT_RELEASE_VERSION in NUMBER,
43 x_PARENT_TABLE in VARCHAR2,
44 x_PARENT_OWNER in VARCHAR2,
45 x_ENABLED in VARCHAR2,
46 x_UPDATABLE in VARCHAR2,
47 x_DISABLED_DML in VARCHAR2,
48 x_WHERE_CLAUSE in VARCHAR2,
49 x_QUERY1 in VARCHAR2,
50 x_QUERY2 in VARCHAR2,
51 x_ONLINE_QUERY in VARCHAR2,
52 x_INQ_NAME in VARCHAR2,
53 x_INQ_OWNER in VARCHAR2,
54 x_FORCE_COMPLETE_REFRESH in VARCHAR2,
55 x_CALLOUT_PROCEDURE in VARCHAR2,
56 x_ACCESS_OWNER in VARCHAR2,
57 x_ACCESS_NAME in VARCHAR2,
58 x_APPLY_SYNCHRONOUS in VARCHAR2,
59 x_CALLOUT_PER_USER in VARCHAR2,
60 x_COMPLETE_REFRESH_PUB_ITEMS in VARCHAR2,
61 x_DETECT_CONFLICT in VARCHAR2,
62 x_CONFLICT_CALLOUT in VARCHAR2,
63 x_force_release_version in NUMBER,
64 x_alter_release_version in NUMBER,
65 x_QUERY_ACCESS_TABLE in varchar2,
66 x_ACCESS_TABLE_PREDICATE_LIST in varchar2,
67 x_CREATION_DATE in DATE,
68 x_CREATED_BY in NUMBER,
69 x_LAST_UPDATE_DATE in DATE,
70 x_LAST_UPDATED_BY in NUMBER,
71 x_ENABLE_DOWNLOAD_EVENTS in varchar2)
72 IS
73 l_base_owner varchar2(30);
74 l_inq_owner varchar2(30);
75 l_access_owner varchar2(30);
76
77 begin
78
79 begin
80 select oracle_username into l_base_owner
81 from fnd_oracle_userid
82 where oracle_id = X_BASE_OWNER;
83 exception
84 when others then
85 l_base_owner := x_base_owner;
86 end;
87 begin
88 select oracle_username into l_inq_owner
89 from fnd_oracle_userid
90 where oracle_id = X_INQ_OWNER;
91 exception
92 when others then
93 l_inq_owner := x_inq_owner;
94 end;
95 begin
96 select oracle_username into l_access_owner
97 from fnd_oracle_userid
98 where oracle_id = X_ACCESS_OWNER;
99 exception
100 when others then
101 l_access_owner := x_access_owner;
102 end;
103
104 insert into ASG_PUB_ITEM (
105 ITEM_ID,
106 NAME,
107 PUB_NAME,
108 BASE_OWNER,
109 BASE_OBJECT_NAME,
110 PRIMARY_KEY_COLUMN,
111 CONFLICT_RULE,
112 RESTRICTING_PREDICATE,
113 HIGH_PRIORITY,
114 TABLE_WEIGHT,
115 PUB_ID,
116 STATUS,
117 LAST_RELEASE_VERSION,
118 CURRENT_RELEASE_VERSION,
119 ACC_LAST_RELEASE_VERSION,
120 ACC_CURRENT_RELEASE_VERSION,
121 PARENT_TABLE,
122 PARENT_OWNER,
123 ENABLED,
124 UPDATABLE,
125 DISABLED_DML,
126 WHERE_CLAUSE,
127 QUERY1,
128 QUERY2,
129 ONLINE_QUERY,
130 INQ_NAME,
131 INQ_OWNER,
132 FORCE_COMPLETE_REFRESH,
133 CALLOUT_PROCEDURE,
134 ACCESS_OWNER,
135 ACCESS_NAME,
136 APPLY_SYNCHRONOUS,
137 CALLOUT_PER_USER,
138 COMPLETE_REFRESH_PUB_ITEMS,
139 DETECT_CONFLICT,
140 CONFLICT_CALLOUT,
141 force_release_version,
142 alter_release_version ,
143 QUERY_ACCESS_TABLE,
144 ACCESS_TABLE_PREDICATE_LIST,
145 ENABLE_DOWNLOAD_EVENTS,
146 CREATION_DATE,
147 CREATED_BY,
148 LAST_UPDATE_DATE,
149 LAST_UPDATED_BY
150 ) values (
151 x_item_id,
152 decode(X_NAME,FND_API.G_MISS_CHAR, NULL, x_NAME),
153 decode(X_PUB_NAME, FND_API.G_MISS_CHAR, NULL, x_PUB_NAME),
154 decode(L_BASE_OWNER,FND_API.G_MISS_CHAR, NULL, L_BASE_OWNER),
155 decode(X_BASE_OBJECT_NAME,FND_API.G_MISS_CHAR, NULL, x_BASE_OBJECT_NAME),
156 decode(X_PRIMARY_KEY_COLUMN, FND_API.G_MISS_CHAR, NULL, x_PRIMARY_KEY_COLUMN),
157 decode(X_CONFLICT_RULE,FND_API.G_MISS_CHAR, NULL, x_CONFLICT_RULE),
158 decode(X_RESTRICTING_PREDICATE,FND_API.G_MISS_CHAR, NULL, x_RESTRICTING_PREDICATE),
159 decode(X_HIGH_PRIORITY,FND_API.G_MISS_CHAR, NULL, x_HIGH_PRIORITY),
160 decode(X_TABLE_WEIGHT,FND_API.G_MISS_CHAR, NULL, x_TABLE_WEIGHT),
161 decode(X_PUB_ID,FND_API.G_MISS_CHAR, NULL, x_PUB_ID),
162 'N',
163 0,
164 decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
165 0,
166 decode(x_ACC_CURRENT_release_version, FND_API.G_MISS_NUM, NULL, x_ACC_CURRENT_RELEASE_VERSION),
167 decode(X_PARENT_TABLE,FND_API.G_MISS_CHAR, NULL, x_PARENT_TABLE),
168 decode(X_PARENT_OWNER,FND_API.G_MISS_CHAR, NULL, x_PARENT_OWNER),
169 decode(x_enabled,FND_API.G_MISS_CHAR,NULL, x_ENABLED),
170 decode(x_updatable,FND_API.G_MISS_CHAR,NULL, x_updatable),
171 decode(x_disabled_dml,FND_API.G_MISS_CHAR,NULL, x_disabled_dml),
172 decode(x_where_clause,FND_API.G_MISS_CHAR,NULL, x_where_clause),
173 decode(x_query1,FND_API.G_MISS_CHAR,NULL, x_query1),
174 decode(x_query2,FND_API.G_MISS_CHAR,NULL, x_query2),
175 decode(x_online_query,FND_API.G_MISS_CHAR,NULL, x_online_query),
176 decode(x_inq_name,FND_API.G_MISS_CHAR,NULL, x_inq_name),
177 decode(L_inq_owner,FND_API.G_MISS_CHAR,NULL, L_inq_owner),
178 decode(x_force_complete_refresh,FND_API.G_MISS_CHAR,NULL, x_force_complete_refresh),
179 decode(x_callout_procedure,FND_API.G_MISS_CHAR,NULL, x_callout_procedure),
180 decode(l_access_owner, FND_API.G_MISS_CHAR, NULL, l_access_owner),
181 decode(x_access_name, FND_API.G_MISS_CHAR, NULL, x_access_name),
182 decode(x_APPLY_SYNCHRONOUS, FND_API.G_MISS_CHAR, NULL,x_APPLY_SYNCHRONOUS),
183 decode(x_CALLOUT_PER_USER, FND_API.G_MISS_CHAR, NULL,x_CALLOUT_PER_USER),
184 decode(x_COMPLETE_REFRESH_PUB_ITEMS, FND_API.G_MISS_CHAR, NULL,x_COMPLETE_REFRESH_PUB_ITEMS),
185 decode(x_DETECT_CONFLICT, FND_API.G_MISS_CHAR, NULL,x_DETECT_CONFLICT),
186 decode(x_CONFLICT_CALLOUT, FND_API.G_MISS_CHAR, NULL,x_CONFLICT_CALLOUT),
187 decode(X_force_release_version,FND_API.G_MISS_NUM, NULL,x_force_release_version),
188 decode(X_alter_release_version,FND_API.G_MISS_NUM, NULL,x_alter_release_version),
189 decode(x_QUERY_ACCESS_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUERY_ACCESS_TABLE),
190 decode(x_ACCESS_TABLE_PREDICATE_LIST, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TABLE_PREDICATE_LIST),
191 nvl(x_ENABLE_DOWNLOAD_EVENTS, 'N'),
192 decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
193 decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
194 decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
195 decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
196 );
197
198 /*
199 open c;
200 fetch c into X_ROWID;
201 if (c%notfound) then
202 close c;
203 raise no_data_found;
204 end if;
205 close c;
206 */
207
208 end insert_row;
209
210 procedure update_row (
211 x_ITEM_ID in VARCHAR2,
212 x_NAME in VARCHAR2,
213 x_PUB_NAME in VARCHAR2,
214 x_BASE_OWNER in VARCHAR2,
215 x_BASE_OBJECT_NAME in VARCHAR2,
216 x_PRIMARY_KEY_COLUMN in VARCHAR2,
217 x_CONFLICT_RULE in VARCHAR2,
218 x_RESTRICTING_PREDICATE in VARCHAR2,
219 x_HIGH_PRIORITY in VARCHAR2,
220 x_TABLE_WEIGHT in VARCHAR2,
221 x_PUB_ID in VARCHAR2,
222 x_STATUS in VARCHAR2,
223 x_LAST_RELEASE_VERSION in NUMBER,
224 x_CURRENT_RELEASE_VERSION in NUMBER,
225 x_ACC_LAST_RELEASE_VERSION in NUMBER,
226 x_ACC_CURRENT_RELEASE_VERSION in NUMBER,
227 x_PARENT_TABLE in VARCHAR2,
228 x_PARENT_OWNER in VARCHAR2,
229 x_ENABLED in VARCHAR2,
230 x_UPDATABLE in VARCHAR2,
231 x_DISABLED_DML in VARCHAR2,
232 x_WHERE_CLAUSE in VARCHAR2,
233 x_QUERY1 in VARCHAR2,
234 x_QUERY2 in VARCHAR2,
235 x_ONLINE_QUERY in VARCHAR2,
236 x_INQ_NAME in VARCHAR2,
237 x_INQ_OWNER in VARCHAR2,
238 x_FORCE_COMPLETE_REFRESH in VARCHAR2,
239 x_CALLOUT_PROCEDURE in VARCHAR2,
240 x_ACCESS_OWNER in VARCHAR2,
241 x_ACCESS_NAME in VARCHAR2,
242 x_APPLY_SYNCHRONOUS in VARCHAR2,
243 x_CALLOUT_PER_USER in VARCHAR2,
244 x_COMPLETE_REFRESH_PUB_ITEMS in VARCHAR2,
245 x_DETECT_CONFLICT in VARCHAR2,
246 x_CONFLICT_CALLOUT in VARCHAR2,
247 x_force_release_version in NUMBER,
248 x_alter_release_version in NUMBER,
249 x_QUERY_ACCESS_TABLE in varchar2,
250 x_ACCESS_TABLE_PREDICATE_LIST in varchar2,
251 x_CREATION_DATE in DATE,
252 x_CREATED_BY in NUMBER,
253 x_LAST_UPDATE_DATE in DATE,
254 x_LAST_UPDATED_BY in NUMBER,
255 x_ENABLE_DOWNLOAD_EVENTS in varchar2) IS
256
257 l_pub_name varchar2(30);
258 l_custom_flag varchar2(1);
259 l_base_owner varchar2(30);
260 l_inq_owner varchar2(30);
261 l_access_owner varchar2(30);
262
263 begin
264 select pub_name into l_pub_name
265 from asg_pub_item
266 where item_id = x_item_id;
267
268 BEGIN
269 select nvl(custom, 'N') into l_custom_flag
270 from asg_pub
271 where pub_id = l_pub_name;
272 EXCEPTION
273 when no_data_found then
274 l_custom_flag := 'N';
275 END;
276
277 if (l_custom_flag = 'N' ) THEN
278 begin
279 select oracle_username into l_base_owner
280 from fnd_oracle_userid
281 where oracle_id = X_BASE_OWNER;
282 exception
283 when others then
284 l_base_owner := x_base_owner;
285 end;
286 begin
287 select oracle_username into l_inq_owner
288 from fnd_oracle_userid
289 where oracle_id = X_INQ_OWNER;
290 exception
291 when others then
292 l_inq_owner := x_inq_owner;
293 end;
294 begin
295 select oracle_username into l_access_owner
296 from fnd_oracle_userid
297 where oracle_id = X_ACCESS_OWNER;
298 exception
299 when others then
300 l_access_owner := x_access_owner;
301 end;
302
303 update asg_pub_item set
304 ITEM_ID = X_ITEM_ID,
305 NAME = X_NAME,
306 PUB_NAME = x_pub_Name,
307 BASE_OWNER = L_BASE_OWNER,
308 BASE_OBJECT_NAME = X_BASE_OBJECT_NAME,
309 PRIMARY_KEY_COLUMN = X_PRIMARY_KEY_COLUMN,
310 CONFLICT_RULE = X_CONFLICT_RULE,
311 RESTRICTING_PREDICATE = X_RESTRICTING_PREDICATE,
312 HIGH_PRIORITY = X_HIGH_PRIORITY,
313 TABLE_WEIGHT = X_TABLE_WEIGHT,
314 PUB_ID = X_PUB_ID,
315 -- STATUS = X_STATUS,
316 -- LAST_RELEASE_VERSION = X_LAST_RELEASE_VERSION,
317 CURRENT_RELEASE_VERSION = X_CURRENT_RELEASE_VERSION,
318 ACC_CURRENT_RELEASE_VERSION = x_ACC_CURRENT_RELEASE_VERSION,
319 ENABLED = X_ENABLED,
320 UPDATABLE = X_UPDATABLE,
321 DISABLED_DML = X_DISABLED_DML,
322 WHERE_CLAUSE = X_WHERE_CLAUSE,
323 QUERY1 = x_query1,
324 QUERY2 = x_query2,
325 ONLINE_QUERY = X_ONLINE_QUERY,
326 INQ_NAME = x_inq_name,
327 INQ_OWNER = L_inq_owner,
328 FORCE_COMPLETE_REFRESH = x_FORCE_COMPLETE_REFRESH,
329 CALLOUT_PROCEDURE = x_CALLOUT_PROCEDURE,
330 ACCESS_OWNER = l_ACCESS_OWNER,
331 ACCESS_NAME = x_ACCESS_NAME,
332 APPLY_SYNCHRONOUS = x_APPLY_SYNCHRONOUS,
333 CALLOUT_PER_USER = x_CALLOUT_PER_USER,
334 COMPLETE_REFRESH_PUB_ITEMS = x_COMPLETE_REFRESH_PUB_ITEMS,
335 DETECT_CONFLICT = x_DETECT_CONFLICT,
336 CONFLICT_CALLOUT = x_CONFLICT_CALLOUT,
337 force_release_version = x_FORCE_RELEASE_VERSION,
341 ENABLE_DOWNLOAD_EVENTS = nvl(x_ENABLE_DOWNLOAD_EVENTS, 'N'),
338 alter_release_version = x_ALTER_RELEASE_VERSION,
339 QUERY_ACCESS_TABLE = x_QUERY_ACCESS_TABLE,
340 ACCESS_TABLE_PREDICATE_LIST = x_ACCESS_TABLE_PREDICATE_LIST,
342 -- CREATION_DATE = X_CREATION_DATE,
343 -- CREATED_BY = X_CREATED_BY,
344 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
345 LAST_UPDATED_BY = X_LAST_UPDATED_BY
346 where ITEM_ID = X_ITEM_ID;
347 end if;
348
349 if (sql%notfound) then
350
351 raise no_data_found;
352 end if;
353 END UPDATE_ROW;
354
355
356 procedure load_row (
357 x_ITEM_ID in VARCHAR2,
358 x_NAME in VARCHAR2,
359 x_PUB_NAME in VARCHAR2,
360 x_BASE_OWNER in VARCHAR2,
361 x_BASE_OBJECT_NAME in VARCHAR2,
362 x_PRIMARY_KEY_COLUMN in VARCHAR2,
363 x_CONFLICT_RULE in VARCHAR2,
364 x_RESTRICTING_PREDICATE in VARCHAR2,
365 x_HIGH_PRIORITY in VARCHAR2,
366 x_TABLE_WEIGHT in VARCHAR2,
367 x_PUB_ID in VARCHAR2,
368 x_STATUS in VARCHAR2,
369 x_LAST_RELEASE_VERSION in NUMBER,
370 x_CURRENT_RELEASE_VERSION in NUMBER,
371 x_ACC_LAST_RELEASE_VERSION in NUMBER,
372 x_ACC_CURRENT_RELEASE_VERSION in NUMBER,
373 x_PARENT_TABLE in VARCHAR2,
374 x_PARENT_OWNER in VARCHAR2,
375 x_ENABLED in VARCHAR2,
376 x_UPDATABLE in VARCHAR2,
377 x_DISABLED_DML in VARCHAR2,
378 x_WHERE_CLAUSE in VARCHAR2,
379 x_QUERY1 in VARCHAR2,
380 x_QUERY2 in VARCHAR2,
381 x_ONLINE_QUERY in VARCHAR2,
382 x_INQ_NAME in VARCHAR2,
383 x_INQ_OWNER in VARCHAR2,
384 x_FORCE_COMPLETE_REFRESH in VARCHAR2,
385 x_CALLOUT_PROCEDURE in VARCHAR2,
386 x_ACCESS_OWNER in VARCHAR2,
387 x_ACCESS_NAME in VARCHAR2,
388 x_APPLY_SYNCHRONOUS in VARCHAR2,
389 x_CALLOUT_PER_USER in VARCHAR2,
390 x_COMPLETE_REFRESH_PUB_ITEMS in VARCHAR2,
391 x_DETECT_CONFLICT in VARCHAR2,
392 x_CONFLICT_CALLOUT in VARCHAR2,
393 x_force_release_version in NUMBER,
394 x_alter_release_version in NUMBER,
395 x_QUERY_ACCESS_TABLE in varchar2,
396 x_ACCESS_TABLE_PREDICATE_LIST in varchar2,
397 x_CREATION_DATE in DATE,
398 x_CREATED_BY in NUMBER,
399 x_LAST_UPDATE_DATE in DATE,
400 x_LAST_UPDATED_BY in NUMBER,
401 p_owner in VARCHAR2,
402 x_ENABLE_DOWNLOAD_EVENTS in varchar2) IS
403
404 l_user_id number := 0;
405
406 BEGIN
407
408
409 if (p_owner = 'SEED') then
410 l_user_id := 1;
411 end if;
412
413 asg_pub_item_pkg.UPDATE_ROW (
414 X_ITEM_ID => x_ITEM_ID,
415 X_NAME => x_NAME,
416 X_PUB_NAME => x_PUB_NAME,
417 X_BASE_OWNER => x_BASE_OWNER,
418 X_BASE_OBJECT_NAME => x_BASE_OBJECT_NAME,
419 X_PRIMARY_KEY_COLUMN => x_PRIMARY_KEY_COLUMN,
420 X_CONFLICT_RULE => x_CONFLICT_RULE,
421 X_RESTRICTING_PREDICATE => x_RESTRICTING_PREDICATE,
422 X_HIGH_PRIORITY => x_HIGH_PRIORITY,
423 X_TABLE_WEIGHT => x_TABLE_WEIGHT,
424 x_PUB_ID => x_PUB_ID,
425 X_STATUS => x_STATUS,
426 X_LAST_RELEASE_VERSION => x_last_release_version,
427 X_CURRENT_RELEASE_VERSION => x_current_release_version,
428 X_ACC_LAST_RELEASE_VERSION => x_acc_last_release_version,
429 X_ACC_CURRENT_RELEASE_VERSION => x_acc_current_release_version,
430 X_PARENT_TABLE => x_parent_table,
431 X_PARENT_OWNER => x_parent_owner,
432 X_ENABLED => x_enabled,
433 X_UPDATABLE => x_updatable,
434 X_DISABLED_DML => x_disabled_dml,
435 X_WHERE_CLAUSE => x_where_clause,
436 x_QUERY1 =>x_query1,
437 x_QUERY2 => x_query2,
438 x_ONLINE_QUERY => x_online_query,
439 x_INQ_NAME => x_INQ_NAME,
440 x_INQ_OWNER => x_INQ_OWNER,
441 x_FORCE_COMPLETE_REFRESH => x_FORCE_COMPLETE_REFRESH,
442 x_CALLOUT_PROCEDURE => x_CALLOUT_PROCEDURE,
443 x_ACCESS_OWNER => x_access_owner,
444 x_access_name => x_access_name,
445 x_APPLY_SYNCHRONOUS => x_APPLY_SYNCHRONOUS,
446 x_CALLOUT_PER_USER => x_CALLOUT_PER_USER,
447 x_COMPLETE_REFRESH_PUB_ITEMS => x_COMPLETE_REFRESH_PUB_ITEMS,
448 x_DETECT_CONFLICT => x_DETECT_CONFLICT,
449 x_CONFLICT_CALLOUT => x_CONFLICT_CALLOUT,
450 x_force_release_version => x_FORCE_RELEASE_VERSION,
451 x_alter_release_version => x_ALTER_RELEASE_VERSION,
452 x_QUERY_ACCESS_TABLE => x_QUERY_ACCESS_TABLE,
453 x_ACCESS_TABLE_PREDICATE_LIST => x_ACCESS_TABLE_PREDICATE_LIST,
454 x_ENABLE_DOWNLOAD_EVENTS => x_ENABLE_DOWNLOAD_EVENTS,
455 X_CREATION_DATE => X_CREATION_DATE,
456 X_CREATED_BY => X_CREATED_BY,
457 X_LAST_UPDATE_DATE => sysdate,
458 X_LAST_UPDATED_BY => l_user_id);
459
460 EXCEPTION
461 WHEN NO_DATA_FOUND THEN
462
463 asg_pub_item_pkg.insert_row (
464 X_ITEM_ID => x_ITEM_ID,
465 X_NAME => x_NAME,
466 X_PUB_NAME => x_PUB_NAME,
467 X_BASE_OWNER => x_BASE_OWNER,
468 X_BASE_OBJECT_NAME => x_BASE_OBJECT_NAME,
469 X_PRIMARY_KEY_COLUMN => x_PRIMARY_KEY_COLUMN,
470 X_CONFLICT_RULE => x_CONFLICT_RULE,
471 X_RESTRICTING_PREDICATE => x_RESTRICTING_PREDICATE,
472 X_HIGH_PRIORITY => x_HIGH_PRIORITY,
473 X_TABLE_WEIGHT => x_TABLE_WEIGHT,
474 x_PUB_ID => x_PUB_ID,
475 X_STATUS => x_STATUS,
476 X_LAST_RELEASE_VERSION => x_last_release_version,
477 X_CURRENT_RELEASE_VERSION => x_current_release_version,
478 X_ACC_LAST_RELEASE_VERSION => x_acc_last_release_version,
479 X_ACC_CURRENT_RELEASE_VERSION => x_acc_current_release_version,
480 X_PARENT_TABLE => x_parent_table,
481 X_PARENT_OWNER => x_parent_owner,
482 X_ENABLED => x_enabled,
483 X_UPDATABLE => x_updatable,
484 X_DISABLED_DML => x_disabled_dml,
485 X_WHERE_CLAUSE => x_where_clause,
486 x_QUERY1 =>x_query1,
487 x_QUERY2 => x_query2,
488 x_ONLINE_QUERY => x_online_query,
489 x_INQ_NAME => x_INQ_NAME,
490 x_INQ_OWNER => x_INQ_OWNER,
491 x_FORCE_COMPLETE_REFRESH => x_FORCE_COMPLETE_REFRESH,
492 x_CALLOUT_PROCEDURE => x_CALLOUT_PROCEDURE,
493 x_access_owner => x_access_owner,
494 x_access_name => x_access_name,
495 x_APPLY_SYNCHRONOUS => x_APPLY_SYNCHRONOUS,
496 x_CALLOUT_PER_USER => x_CALLOUT_PER_USER,
497 x_COMPLETE_REFRESH_PUB_ITEMS => x_COMPLETE_REFRESH_PUB_ITEMS,
498 x_DETECT_CONFLICT => x_DETECT_CONFLICT,
499 x_CONFLICT_CALLOUT => x_CONFLICT_CALLOUT,
500 x_force_release_version => x_FORCE_RELEASE_VERSION,
501 x_alter_release_version => x_ALTER_RELEASE_VERSION,
502 x_QUERY_ACCESS_TABLE => x_QUERY_ACCESS_TABLE,
503 x_ACCESS_TABLE_PREDICATE_LIST => x_ACCESS_TABLE_PREDICATE_LIST,
504 x_ENABLE_DOWNLOAD_EVENTS => x_ENABLE_DOWNLOAD_EVENTS,
505 X_CREATION_DATE => sysdate,
506 X_CREATED_BY => l_user_id,
507 X_LAST_UPDATE_DATE => sysdate,
508 X_LAST_UPDATED_BY => l_user_id);
509
510 END load_row;
511
512 END ASG_PUB_ITEM_PKG;