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