eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYSTEM.AD_DDL dependencies on AD_DDL

Line 1: package body ad_ddl as

1: package body ad_ddl as
2: /* $Header: adddlb.pls 120.1 2005/10/25 05:33:25 sksreedh noship $ */
3:
4: --
5: -- Global variables

Line 104: ad_ddl.error_buf := null;

100: oracle_schema varchar2(30);
101: apps_schema varchar2(30);
102: apps_mls_schema varchar2(30);
103: begin
104: ad_ddl.error_buf := null;
105: ad_apps_private.error_buf := null;
106: gbl_statement := statement;
107:
108: -- from the APPLSYS schema get an APPS schema so that we can access

Line 131: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

127: OUT oracle_schema, OUT dummy_boolean;
128:
129: exception
130: when others then
131: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
132: ad_ddl.error_buf;
133: raise;
134: end;
135:

Line 132: ad_ddl.error_buf;

128:
129: exception
130: when others then
131: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
132: ad_ddl.error_buf;
133: raise;
134: end;
135:
136: if dummy_boolean <> 'TRUE' then

Line 158: ad_ddl.error_buf := 'do_ddl('||applsys_schema||', '||

154: statement_type, statement, upper(object_name));
155:
156: exception
157: when others then
158: ad_ddl.error_buf := 'do_ddl('||applsys_schema||', '||
159: application_short_name||
160: ', '||statement_type||', $statement$, '||
161: object_name||'): '||
162: ad_ddl.error_buf||': '||ad_apps_private.error_buf||

Line 162: ad_ddl.error_buf||': '||ad_apps_private.error_buf||

158: ad_ddl.error_buf := 'do_ddl('||applsys_schema||', '||
159: application_short_name||
160: ', '||statement_type||', $statement$, '||
161: object_name||'): '||
162: ad_ddl.error_buf||': '||ad_apps_private.error_buf||
163: ': substr($statement$,1,255)='''||
164: substr(gbl_statement,1,255)||'''';
165: raise;
166: end do_ddl;

Line 225: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

221: g_Ign_Cache_Tbl(oracle_schema) := install_group_num;
222: exception
223: when others then
224: dbms_sql.close_cursor(c);
225: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
226: ad_ddl.error_buf;
227: raise;
228: END ; -- Block Find Ign
229: END IF ;

Line 226: ad_ddl.error_buf;

222: exception
223: when others then
224: dbms_sql.close_cursor(c);
225: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
226: ad_ddl.error_buf;
227: raise;
228: END ; -- Block Find Ign
229: END IF ;
230: else

Line 259: if statement_type = ad_ddl.alter_sequence

255: --
256: -- Based on type of action determine what to do
257: --
258: --
259: if statement_type = ad_ddl.alter_sequence
260: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
261: elsif statement_type = ad_ddl.alter_table
262: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
263: elsif statement_type = ad_ddl.alter_trigger

Line 261: elsif statement_type = ad_ddl.alter_table

257: --
258: --
259: if statement_type = ad_ddl.alter_sequence
260: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
261: elsif statement_type = ad_ddl.alter_table
262: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
263: elsif statement_type = ad_ddl.alter_trigger
264: then do_acd_trigger(install_group_num, p_apps_schema, statement);
265: elsif statement_type = ad_ddl.alter_view

Line 263: elsif statement_type = ad_ddl.alter_trigger

259: if statement_type = ad_ddl.alter_sequence
260: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
261: elsif statement_type = ad_ddl.alter_table
262: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
263: elsif statement_type = ad_ddl.alter_trigger
264: then do_acd_trigger(install_group_num, p_apps_schema, statement);
265: elsif statement_type = ad_ddl.alter_view
266: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
267: statement);

Line 265: elsif statement_type = ad_ddl.alter_view

261: elsif statement_type = ad_ddl.alter_table
262: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
263: elsif statement_type = ad_ddl.alter_trigger
264: then do_acd_trigger(install_group_num, p_apps_schema, statement);
265: elsif statement_type = ad_ddl.alter_view
266: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
267: statement);
268: elsif statement_type = ad_ddl.create_index
269: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);

Line 268: elsif statement_type = ad_ddl.create_index

264: then do_acd_trigger(install_group_num, p_apps_schema, statement);
265: elsif statement_type = ad_ddl.alter_view
266: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
267: statement);
268: elsif statement_type = ad_ddl.create_index
269: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
270: elsif statement_type = ad_ddl.create_sequence
271: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
272: statement_type, object_name, statement);

Line 270: elsif statement_type = ad_ddl.create_sequence

266: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
267: statement);
268: elsif statement_type = ad_ddl.create_index
269: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
270: elsif statement_type = ad_ddl.create_sequence
271: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
272: statement_type, object_name, statement);
273: elsif statement_type = ad_ddl.create_synonym
274: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,

Line 273: elsif statement_type = ad_ddl.create_synonym

269: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
270: elsif statement_type = ad_ddl.create_sequence
271: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
272: statement_type, object_name, statement);
273: elsif statement_type = ad_ddl.create_synonym
274: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
275: statement);
276: elsif statement_type = ad_ddl.create_table
277: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,

Line 276: elsif statement_type = ad_ddl.create_table

272: statement_type, object_name, statement);
273: elsif statement_type = ad_ddl.create_synonym
274: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
275: statement);
276: elsif statement_type = ad_ddl.create_table
277: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
278: statement_type, object_name, statement);
279: elsif statement_type = ad_ddl.create_trigger
280: then do_acd_trigger(install_group_num, p_apps_schema, statement);

Line 279: elsif statement_type = ad_ddl.create_trigger

275: statement);
276: elsif statement_type = ad_ddl.create_table
277: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
278: statement_type, object_name, statement);
279: elsif statement_type = ad_ddl.create_trigger
280: then do_acd_trigger(install_group_num, p_apps_schema, statement);
281: elsif statement_type = ad_ddl.create_view
282: then do_cd_view(install_group_num, p_apps_schema, statement_type,
283: object_name, statement);

Line 281: elsif statement_type = ad_ddl.create_view

277: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
278: statement_type, object_name, statement);
279: elsif statement_type = ad_ddl.create_trigger
280: then do_acd_trigger(install_group_num, p_apps_schema, statement);
281: elsif statement_type = ad_ddl.create_view
282: then do_cd_view(install_group_num, p_apps_schema, statement_type,
283: object_name, statement);
284: elsif statement_type = ad_ddl.drop_index
285: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);

Line 284: elsif statement_type = ad_ddl.drop_index

280: then do_acd_trigger(install_group_num, p_apps_schema, statement);
281: elsif statement_type = ad_ddl.create_view
282: then do_cd_view(install_group_num, p_apps_schema, statement_type,
283: object_name, statement);
284: elsif statement_type = ad_ddl.drop_index
285: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
286: elsif statement_type = ad_ddl.drop_sequence
287: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
288: statement_type, object_name, statement);

Line 286: elsif statement_type = ad_ddl.drop_sequence

282: then do_cd_view(install_group_num, p_apps_schema, statement_type,
283: object_name, statement);
284: elsif statement_type = ad_ddl.drop_index
285: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
286: elsif statement_type = ad_ddl.drop_sequence
287: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
288: statement_type, object_name, statement);
289: elsif statement_type = ad_ddl.drop_synonym
290: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,

Line 289: elsif statement_type = ad_ddl.drop_synonym

285: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
286: elsif statement_type = ad_ddl.drop_sequence
287: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
288: statement_type, object_name, statement);
289: elsif statement_type = ad_ddl.drop_synonym
290: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
291: statement);
292: elsif statement_type = ad_ddl.drop_table
293: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,

Line 292: elsif statement_type = ad_ddl.drop_table

288: statement_type, object_name, statement);
289: elsif statement_type = ad_ddl.drop_synonym
290: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
291: statement);
292: elsif statement_type = ad_ddl.drop_table
293: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
294: statement_type, object_name, statement);
295: elsif statement_type = ad_ddl.drop_trigger
296: then do_acd_trigger(install_group_num, p_apps_schema, statement);

Line 295: elsif statement_type = ad_ddl.drop_trigger

291: statement);
292: elsif statement_type = ad_ddl.drop_table
293: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
294: statement_type, object_name, statement);
295: elsif statement_type = ad_ddl.drop_trigger
296: then do_acd_trigger(install_group_num, p_apps_schema, statement);
297: elsif statement_type = ad_ddl.drop_view
298: then do_cd_view(install_group_num, p_apps_schema, statement_type,
299: object_name, statement);

Line 297: elsif statement_type = ad_ddl.drop_view

293: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
294: statement_type, object_name, statement);
295: elsif statement_type = ad_ddl.drop_trigger
296: then do_acd_trigger(install_group_num, p_apps_schema, statement);
297: elsif statement_type = ad_ddl.drop_view
298: then do_cd_view(install_group_num, p_apps_schema, statement_type,
299: object_name, statement);
300: elsif statement_type = ad_ddl.truncate_table
301: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);

Line 300: elsif statement_type = ad_ddl.truncate_table

296: then do_acd_trigger(install_group_num, p_apps_schema, statement);
297: elsif statement_type = ad_ddl.drop_view
298: then do_cd_view(install_group_num, p_apps_schema, statement_type,
299: object_name, statement);
300: elsif statement_type = ad_ddl.truncate_table
301: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
302: elsif statement_type = ad_ddl.alter_package
303: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
304: statement);

Line 302: elsif statement_type = ad_ddl.alter_package

298: then do_cd_view(install_group_num, p_apps_schema, statement_type,
299: object_name, statement);
300: elsif statement_type = ad_ddl.truncate_table
301: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
302: elsif statement_type = ad_ddl.alter_package
303: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
304: statement);
305: elsif statement_type = ad_ddl.drop_package
306: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,

Line 305: elsif statement_type = ad_ddl.drop_package

301: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
302: elsif statement_type = ad_ddl.alter_package
303: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
304: statement);
305: elsif statement_type = ad_ddl.drop_package
306: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
307: statement);
308: elsif statement_type = ad_ddl.create_grants
309: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);

Line 308: elsif statement_type = ad_ddl.create_grants

304: statement);
305: elsif statement_type = ad_ddl.drop_package
306: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
307: statement);
308: elsif statement_type = ad_ddl.create_grants
309: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
310:
311: -- fix bug 2804640, it returns base schema
312: -- The issue in do_ddl() was that synonyms were not created in

Line 315: elsif statement_type = ad_ddl.create_base_synonym

311: -- fix bug 2804640, it returns base schema
312: -- The issue in do_ddl() was that synonyms were not created in
313: -- base schemas, but in APPS and APPS_MRC
314:
315: elsif statement_type = ad_ddl.create_base_synonym
316: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
317: elsif statement_type = ad_ddl.drop_base_synonym
318: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
319: end if;

Line 317: elsif statement_type = ad_ddl.drop_base_synonym

313: -- base schemas, but in APPS and APPS_MRC
314:
315: elsif statement_type = ad_ddl.create_base_synonym
316: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
317: elsif statement_type = ad_ddl.drop_base_synonym
318: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
319: end if;
320: exception
321: when others then

Line 322: ad_ddl.error_buf := 'private_do_ddl('||p_apps_schema||', '||

318: then do_at_tab_a_seq_acd_ind(oracle_schema, statement);
319: end if;
320: exception
321: when others then
322: ad_ddl.error_buf := 'private_do_ddl('||p_apps_schema||', '||
323: p_applsys_schema||', '||oracle_schema||
324: ', '||statement_type||', $statement$, '||
325: object_name||'): '||ad_ddl.error_buf;
326: raise;

Line 325: object_name||'): '||ad_ddl.error_buf;

321: when others then
322: ad_ddl.error_buf := 'private_do_ddl('||p_apps_schema||', '||
323: p_applsys_schema||', '||oracle_schema||
324: ', '||statement_type||', $statement$, '||
325: object_name||'): '||ad_ddl.error_buf;
326: raise;
327: end;
328:
329:

Line 340: ad_ddl.error_buf := 'do_a_tab_a_seq_acd_ind('||datasai_oracle_schema||

336: ad_apps_private.do_apps_ddl(datasai_oracle_schema,datasai_statement,
337: 'TRUE');
338: exception
339: when others then
340: ad_ddl.error_buf := 'do_a_tab_a_seq_acd_ind('||datasai_oracle_schema||
341: ', $statement$): '||ad_ddl.error_buf;
342: raise;
343: end;
344:

Line 341: ', $statement$): '||ad_ddl.error_buf;

337: 'TRUE');
338: exception
339: when others then
340: ad_ddl.error_buf := 'do_a_tab_a_seq_acd_ind('||datasai_oracle_schema||
341: ', $statement$): '||ad_ddl.error_buf;
342: raise;
343: end;
344:
345:

Line 373: ad_ddl.error_buf := 'do_acd_trigger('||dat_install_group_num||', '||

369: --
370: -- reset main error buffer
371: ad_apps_private.error_buf := null;
372: when others then
373: ad_ddl.error_buf := 'do_acd_trigger('||dat_install_group_num||', '||
374: dat_apps_schema||', $statement$): '||ad_ddl.error_buf;
375: raise;
376: end;
377:

Line 374: dat_apps_schema||', $statement$): '||ad_ddl.error_buf;

370: -- reset main error buffer
371: ad_apps_private.error_buf := null;
372: when others then
373: ad_ddl.error_buf := 'do_acd_trigger('||dat_install_group_num||', '||
374: dat_apps_schema||', $statement$): '||ad_ddl.error_buf;
375: raise;
376: end;
377:
378:

Line 561: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

557: exception
558: when others then
559: dbms_sql.close_cursor(c);
560: if print_local_sql then
561: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
562: ad_ddl.error_buf;
563: end if;
564: raise;
565: end;

Line 562: ad_ddl.error_buf;

558: when others then
559: dbms_sql.close_cursor(c);
560: if print_local_sql then
561: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
562: ad_ddl.error_buf;
563: end if;
564: raise;
565: end;
566: end if;

Line 570: ad_ddl.error_buf := 'do_a_view_cd_syn_ad_pack('||

566: end if;
567:
568: exception
569: when others then
570: ad_ddl.error_buf := 'do_a_view_cd_syn_ad_pack('||
571: davcsap_install_group_num||', '
572: ||davcsap_apps_schema||', $statement$): '||
573: ad_ddl.error_buf;
574: raise;

Line 573: ad_ddl.error_buf;

569: when others then
570: ad_ddl.error_buf := 'do_a_view_cd_syn_ad_pack('||
571: davcsap_install_group_num||', '
572: ||davcsap_apps_schema||', $statement$): '||
573: ad_ddl.error_buf;
574: raise;
575: end;
576:
577:

Line 597: if dctcs_statement_type = ad_ddl.drop_sequence then

593: or ad_apps_private.is_mc is null then
594: ad_apps_private.initialize(dctcs_apps_schema);
595: end if;
596: -- do statement in base schema
597: if dctcs_statement_type = ad_ddl.drop_sequence then
598: ad_apps_private.drop_object(dctcs_oracle_schema, dctcs_object_name,
599: 'SEQUENCE');
600: elsif dctcs_statement_type = ad_ddl.drop_table then
601: ad_apps_private.drop_object(dctcs_oracle_schema, dctcs_object_name,

Line 600: elsif dctcs_statement_type = ad_ddl.drop_table then

596: -- do statement in base schema
597: if dctcs_statement_type = ad_ddl.drop_sequence then
598: ad_apps_private.drop_object(dctcs_oracle_schema, dctcs_object_name,
599: 'SEQUENCE');
600: elsif dctcs_statement_type = ad_ddl.drop_table then
601: ad_apps_private.drop_object(dctcs_oracle_schema, dctcs_object_name,
602: 'TABLE');
603: else -- it is a create
604: ad_apps_private.do_apps_ddl(dctcs_oracle_schema, dctcs_statement,

Line 617: if dctcs_statement_type = ad_ddl.create_table

613: ad_apps_private.get_apps_schema_name(dctcs_install_group_num,
614: dctcs_apps_schema, l_apps_schema, l_mls_apps_schema);
615:
616: -- create/drop grant/synonym in apps schema
617: if dctcs_statement_type = ad_ddl.create_table
618: or dctcs_statement_type = ad_ddl.create_sequence then
619:
620: ad_apps_private.create_gs(dctcs_oracle_schema, l_apps_schema,
621: dctcs_object_name, TRUE, 'ALL');

Line 618: or dctcs_statement_type = ad_ddl.create_sequence then

614: dctcs_apps_schema, l_apps_schema, l_mls_apps_schema);
615:
616: -- create/drop grant/synonym in apps schema
617: if dctcs_statement_type = ad_ddl.create_table
618: or dctcs_statement_type = ad_ddl.create_sequence then
619:
620: ad_apps_private.create_gs(dctcs_oracle_schema, l_apps_schema,
621: dctcs_object_name, TRUE, 'ALL');
622: else -- this is a drop table/sequence

Line 629: if dctcs_statement_type = ad_ddl.create_table

625: end if;
626:
627: if ad_apps_private.is_mls then
628: -- create/drop grant/synonym in apps_mls schema
629: if dctcs_statement_type = ad_ddl.create_table
630: or dctcs_statement_type = ad_ddl.create_sequence then
631:
632: ad_apps_private.create_gs(dctcs_oracle_schema,
633: l_mls_apps_schema,

Line 630: or dctcs_statement_type = ad_ddl.create_sequence then

626:
627: if ad_apps_private.is_mls then
628: -- create/drop grant/synonym in apps_mls schema
629: if dctcs_statement_type = ad_ddl.create_table
630: or dctcs_statement_type = ad_ddl.create_sequence then
631:
632: ad_apps_private.create_gs(dctcs_oracle_schema,
633: l_mls_apps_schema,
634: dctcs_object_name, TRUE, 'ALL');

Line 674: if dctcs_statement_type = ad_ddl.create_table

670: ad_apps_private.get_apps_schema_name(l_install_group_num,
671: dctcs_apps_schema, l_apps_schema, l_mls_apps_schema);
672:
673: -- create/drop grant/synonym in apps schema
674: if dctcs_statement_type = ad_ddl.create_table
675: or dctcs_statement_type = ad_ddl.create_sequence then
676:
677: ad_apps_private.create_gs(dctcs_oracle_schema,
678: l_apps_schema,

Line 675: or dctcs_statement_type = ad_ddl.create_sequence then

671: dctcs_apps_schema, l_apps_schema, l_mls_apps_schema);
672:
673: -- create/drop grant/synonym in apps schema
674: if dctcs_statement_type = ad_ddl.create_table
675: or dctcs_statement_type = ad_ddl.create_sequence then
676:
677: ad_apps_private.create_gs(dctcs_oracle_schema,
678: l_apps_schema,
679: dctcs_object_name, TRUE, 'ALL');

Line 687: if dctcs_statement_type = ad_ddl.create_table

683: end if;
684:
685: if ad_apps_private.is_mls then
686: -- create/drop grant/synonym in apps_mls schema
687: if dctcs_statement_type = ad_ddl.create_table
688: or dctcs_statement_type = ad_ddl.create_sequence then
689:
690: ad_apps_private.create_gs(dctcs_oracle_schema,
691: l_mls_apps_schema, dctcs_object_name, TRUE, 'ALL');

Line 688: or dctcs_statement_type = ad_ddl.create_sequence then

684:
685: if ad_apps_private.is_mls then
686: -- create/drop grant/synonym in apps_mls schema
687: if dctcs_statement_type = ad_ddl.create_table
688: or dctcs_statement_type = ad_ddl.create_sequence then
689:
690: ad_apps_private.create_gs(dctcs_oracle_schema,
691: l_mls_apps_schema, dctcs_object_name, TRUE, 'ALL');
692: else -- this is a drop table/sequence

Line 707: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

703: exception
704: when others then
705: dbms_sql.close_cursor(c);
706: if print_local_sql then
707: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
708: ad_ddl.error_buf;
709: end if;
710: raise;
711: end;

Line 708: ad_ddl.error_buf;

704: when others then
705: dbms_sql.close_cursor(c);
706: if print_local_sql then
707: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
708: ad_ddl.error_buf;
709: end if;
710: raise;
711: end;
712: end if;

Line 715: ad_ddl.error_buf := 'do_cd_tab_cd_seq('||dctcs_install_group_num||', '||

711: end;
712: end if;
713: exception
714: when others then
715: ad_ddl.error_buf := 'do_cd_tab_cd_seq('||dctcs_install_group_num||', '||
716: dctcs_apps_schema||', '||dctcs_oracle_schema||', '||
717: dctcs_statement_type||', '||dctcs_object_name||
718: ', $statement$): '||ad_ddl.error_buf;
719: raise;

Line 718: ', $statement$): '||ad_ddl.error_buf;

714: when others then
715: ad_ddl.error_buf := 'do_cd_tab_cd_seq('||dctcs_install_group_num||', '||
716: dctcs_apps_schema||', '||dctcs_oracle_schema||', '||
717: dctcs_statement_type||', '||dctcs_object_name||
718: ', $statement$): '||ad_ddl.error_buf;
719: raise;
720: end;
721:
722:

Line 752: if dcv_statement_type = ad_ddl.drop_view then

748: ad_apps_private.get_apps_schema_name(dcv_install_group_num,
749: dcv_apps_schema, l_apps_schema, l_mls_apps_schema);
750:
751: -- create/drop view in apps schema
752: if dcv_statement_type = ad_ddl.drop_view then
753: ad_apps_private.drop_object(l_apps_schema,dcv_object_name,
754: 'VIEW');
755: else -- create_view
756: begin

Line 773: if dcv_statement_type = ad_ddl.drop_view then

769: end if;
770:
771: if ad_apps_private.is_mls then
772: -- create/drop view in apps_mls schema
773: if dcv_statement_type = ad_ddl.drop_view then
774: ad_apps_private.drop_object(l_mls_apps_schema,
775: dcv_object_name,'VIEW');
776: else -- create_view
777: begin

Line 823: if dcv_statement_type = ad_ddl.drop_view then

819: ad_apps_private.get_apps_schema_name(l_install_group_num,
820: dcv_apps_schema, l_apps_schema, l_mls_apps_schema);
821:
822: -- create/drop view in apps schema
823: if dcv_statement_type = ad_ddl.drop_view then
824: ad_apps_private.drop_object(l_apps_schema,
825: dcv_object_name,'VIEW');
826: else -- create_view
827: begin

Line 843: if dcv_statement_type = ad_ddl.drop_view then

839: end if;
840:
841: if ad_apps_private.is_mls then
842: -- create/drop view in apps_mls schema
843: if dcv_statement_type = ad_ddl.drop_view then
844: ad_apps_private.drop_object(l_mls_apps_schema,
845: dcv_object_name,'VIEW');
846: else -- create_view
847: begin

Line 871: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

867: exception
868: when others then
869: dbms_sql.close_cursor(c);
870: if print_local_sql then
871: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
872: ad_ddl.error_buf;
873: end if;
874: raise;
875: end;

Line 872: ad_ddl.error_buf;

868: when others then
869: dbms_sql.close_cursor(c);
870: if print_local_sql then
871: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
872: ad_ddl.error_buf;
873: end if;
874: raise;
875: end;
876: end if;

Line 879: ad_ddl.error_buf := 'do_cd_view('||dcv_install_group_num||', '||

875: end;
876: end if;
877: exception
878: when others then
879: ad_ddl.error_buf := 'do_cd_view('||dcv_install_group_num||', '||
880: dcv_apps_schema||', '||
881: dcv_statement_type||', '||dcv_object_name||
882: ', $statement$): '||ad_ddl.error_buf;
883: raise;

Line 882: ', $statement$): '||ad_ddl.error_buf;

878: when others then
879: ad_ddl.error_buf := 'do_cd_view('||dcv_install_group_num||', '||
880: dcv_apps_schema||', '||
881: dcv_statement_type||', '||dcv_object_name||
882: ', $statement$): '||ad_ddl.error_buf;
883: raise;
884: end do_cd_view;
885:
886:

Line 909: ad_ddl.error_buf := 'create_package('||applsys_schema||', '||

905: 'TRUE',
906: dummy);
907: exception
908: when others then
909: ad_ddl.error_buf := 'create_package('||applsys_schema||', '||
910: application_short_name||
911: ', '||package_name||', '||is_package_body||', '||
912: lb||', '||ub||'): '||
913: ad_ddl.error_buf||': '||ad_apps_private.error_buf||

Line 913: ad_ddl.error_buf||': '||ad_apps_private.error_buf||

909: ad_ddl.error_buf := 'create_package('||applsys_schema||', '||
910: application_short_name||
911: ', '||package_name||', '||is_package_body||', '||
912: lb||', '||ub||'): '||
913: ad_ddl.error_buf||': '||ad_apps_private.error_buf||
914: ': substr($statement$,1,255)='''||
915: substr(gbl_statement,1,255)||'''';
916: raise;
917: end create_package;

Line 981: ad_ddl.error_buf := null;

977: --
978:
979: -- initialize variables
980:
981: ad_ddl.error_buf := null;
982: ad_apps_private.error_buf := null;
983: gbl_statement := null;
984:
985: comp_error := 'FALSE';

Line 990: if upper(ad_ddl.glprogtext(lb)) like 'CREATE%PACKAGE%' then

986: upper_obj_name := upper(object_name);
987:
988: -- Determine object type
989:
990: if upper(ad_ddl.glprogtext(lb)) like 'CREATE%PACKAGE%' then
991: if upper(ad_ddl.glprogtext(lb)) like 'CREATE%PACKAGE BODY%' then
992: object_type := 'PACKAGE BODY';
993: else
994: object_type := 'PACKAGE';

Line 991: if upper(ad_ddl.glprogtext(lb)) like 'CREATE%PACKAGE BODY%' then

987:
988: -- Determine object type
989:
990: if upper(ad_ddl.glprogtext(lb)) like 'CREATE%PACKAGE%' then
991: if upper(ad_ddl.glprogtext(lb)) like 'CREATE%PACKAGE BODY%' then
992: object_type := 'PACKAGE BODY';
993: else
994: object_type := 'PACKAGE';
995: end if;

Line 996: elsif upper(ad_ddl.glprogtext(lb)) like 'CREATE%PROCEDURE%' then

992: object_type := 'PACKAGE BODY';
993: else
994: object_type := 'PACKAGE';
995: end if;
996: elsif upper(ad_ddl.glprogtext(lb)) like 'CREATE%PROCEDURE%' then
997: object_type := 'PROCEDURE';
998: elsif upper(ad_ddl.glprogtext(lb)) like 'CREATE%FUNCTION%' then
999: object_type := 'FUNCTION';
1000: else

Line 998: elsif upper(ad_ddl.glprogtext(lb)) like 'CREATE%FUNCTION%' then

994: object_type := 'PACKAGE';
995: end if;
996: elsif upper(ad_ddl.glprogtext(lb)) like 'CREATE%PROCEDURE%' then
997: object_type := 'PROCEDURE';
998: elsif upper(ad_ddl.glprogtext(lb)) like 'CREATE%FUNCTION%' then
999: object_type := 'FUNCTION';
1000: else
1001: object_type := 'UNKNOWN';
1002: end if;

Line 1055: ad_ddl.error_buf := 'c_statement='||c_statement||':'||

1051: OUT oracle_schema, OUT dummy_boolean;
1052: --
1053: exception
1054: when others then
1055: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1056: ad_ddl.error_buf;
1057: raise;
1058: end;
1059: --

Line 1056: ad_ddl.error_buf;

1052: --
1053: exception
1054: when others then
1055: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1056: ad_ddl.error_buf;
1057: raise;
1058: end;
1059: --
1060: if dummy_boolean <> 'TRUE' then

Line 1099: ad_ddl.error_buf := 'c_statement='||c_statement||':'||

1095: into first_apps_schema;
1096:
1097: exception
1098: when others then
1099: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1100: ad_ddl.error_buf;
1101: raise;
1102: end;
1103:

Line 1100: ad_ddl.error_buf;

1096:
1097: exception
1098: when others then
1099: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1100: ad_ddl.error_buf;
1101: raise;
1102: end;
1103:
1104: -- Get the install_group_num for the oracle_schema that owns the object

Line 1134: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

1130: dbms_sql.close_cursor(c);
1131: exception
1132: when others then
1133: dbms_sql.close_cursor(c);
1134: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
1135: ad_ddl.error_buf;
1136: raise;
1137: end;
1138: else

Line 1135: ad_ddl.error_buf;

1131: exception
1132: when others then
1133: dbms_sql.close_cursor(c);
1134: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
1135: ad_ddl.error_buf;
1136: raise;
1137: end;
1138: else
1139:

Line 1166: ad_ddl.error_buf := 'c_statement='||c_statement||':'||

1162: into current_apps_schema;
1163:
1164: exception
1165: when others then
1166: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1167: ad_ddl.error_buf;
1168: raise;
1169: end;
1170:

Line 1167: ad_ddl.error_buf;

1163:
1164: exception
1165: when others then
1166: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1167: ad_ddl.error_buf;
1168: raise;
1169: end;
1170:
1171: else

Line 1184: ad_invoker.classify_plsql_array(ad_ddl.glprogtext, lb, ub,

1180:
1181: if object_type <> 'PACKAGE BODY' then
1182: -- not package body
1183:
1184: ad_invoker.classify_plsql_array(ad_ddl.glprogtext, lb, ub,
1185: object_type, obj_has_authid, obj_invoker_flag);
1186:
1187: if obj_has_authid = 'FALSE' then
1188:

Line 1189: ad_invoker.rewrite_plsql_array(ad_ddl.glprogtext, lb, ub,

1185: object_type, obj_has_authid, obj_invoker_flag);
1186:
1187: if obj_has_authid = 'FALSE' then
1188:
1189: ad_invoker.rewrite_plsql_array(ad_ddl.glprogtext, lb, ub,
1190: object_type);
1191:
1192: is_invoker_object := TRUE;
1193: invoker_flag_for_obj := 'I';

Line 1886: ad_ddl.error_buf := 'c_statement='||c_statement||':'||

1882:
1883:
1884: exception
1885: when others then
1886: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1887: ad_ddl.error_buf;
1888: raise;
1889: end;
1890:

Line 1887: ad_ddl.error_buf;

1883:
1884: exception
1885: when others then
1886: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1887: ad_ddl.error_buf;
1888: raise;
1889: end;
1890:
1891: if object_status = 'INVALID' then

Line 1912: ad_ddl.error_buf := 'c_statement='||c_statement||':'||

1908: into invalid_count;
1909:
1910: exception
1911: when others then
1912: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1913: ad_ddl.error_buf;
1914: raise;
1915: end;
1916:

Line 1913: ad_ddl.error_buf;

1909:
1910: exception
1911: when others then
1912: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1913: ad_ddl.error_buf;
1914: raise;
1915: end;
1916:
1917: if invalid_count <> 0 then

Line 1939: ad_ddl.error_buf := 'c_statement='||c_statement||':'||

1935: into invalid_count;
1936:
1937: exception
1938: when others then
1939: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1940: ad_ddl.error_buf;
1941: raise;
1942: end;
1943:

Line 1940: ad_ddl.error_buf;

1936:
1937: exception
1938: when others then
1939: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1940: ad_ddl.error_buf;
1941: raise;
1942: end;
1943:
1944: if invalid_count <> 0 then

Line 1962: ad_ddl.error_buf := 'create_plsql_object('||applsys_schema||', '||

1958: end if;
1959: -- end if comp_error is 'FALSE'
1960: exception
1961: when others then
1962: ad_ddl.error_buf := 'create_plsql_object('||applsys_schema||', '||
1963: application_short_name||
1964: ', '||object_name||', '||
1965: lb||', '||ub||', '||insert_newlines||'): '||
1966: ad_ddl.error_buf||': '||ad_apps_private.error_buf||

Line 1966: ad_ddl.error_buf||': '||ad_apps_private.error_buf||

1962: ad_ddl.error_buf := 'create_plsql_object('||applsys_schema||', '||
1963: application_short_name||
1964: ', '||object_name||', '||
1965: lb||', '||ub||', '||insert_newlines||'): '||
1966: ad_ddl.error_buf||': '||ad_apps_private.error_buf||
1967: ': substr($statement$,1,255)='''||
1968: substr(gbl_statement,1,255)||'''';
1969: raise;
1970: end create_plsql_object;

Line 1978: ad_ddl.error_buf := null;

1974: (ddl_text in varchar2,
1975: row_num in integer)
1976: is
1977: begin
1978: ad_ddl.error_buf := null;
1979:
1980: ad_ddl.glprogtext(row_num) := ddl_text;
1981:
1982: exception

Line 1980: ad_ddl.glprogtext(row_num) := ddl_text;

1976: is
1977: begin
1978: ad_ddl.error_buf := null;
1979:
1980: ad_ddl.glprogtext(row_num) := ddl_text;
1981:
1982: exception
1983: when others then
1984: ad_ddl.error_buf := 'build_package('||

Line 1984: ad_ddl.error_buf := 'build_package('||

1980: ad_ddl.glprogtext(row_num) := ddl_text;
1981:
1982: exception
1983: when others then
1984: ad_ddl.error_buf := 'build_package('||
1985: ddl_text||', '||row_num||'): '||ad_ddl.error_buf;
1986: raise;
1987: end build_package;
1988:

Line 1985: ddl_text||', '||row_num||'): '||ad_ddl.error_buf;

1981:
1982: exception
1983: when others then
1984: ad_ddl.error_buf := 'build_package('||
1985: ddl_text||', '||row_num||'): '||ad_ddl.error_buf;
1986: raise;
1987: end build_package;
1988:
1989:

Line 1995: ad_ddl.error_buf := null;

1991: (ddl_text in varchar2,
1992: row_num in integer)
1993: is
1994: begin
1995: ad_ddl.error_buf := null;
1996:
1997: ad_ddl.glprogtext(row_num) := ddl_text;
1998:
1999: exception

Line 1997: ad_ddl.glprogtext(row_num) := ddl_text;

1993: is
1994: begin
1995: ad_ddl.error_buf := null;
1996:
1997: ad_ddl.glprogtext(row_num) := ddl_text;
1998:
1999: exception
2000: when others then
2001: ad_ddl.error_buf := 'build_statement('||

Line 2001: ad_ddl.error_buf := 'build_statement('||

1997: ad_ddl.glprogtext(row_num) := ddl_text;
1998:
1999: exception
2000: when others then
2001: ad_ddl.error_buf := 'build_statement('||
2002: ddl_text||', '||row_num||'): '||ad_ddl.error_buf;
2003: raise;
2004: end build_statement;
2005:

Line 2002: ddl_text||', '||row_num||'): '||ad_ddl.error_buf;

1998:
1999: exception
2000: when others then
2001: ad_ddl.error_buf := 'build_statement('||
2002: ddl_text||', '||row_num||'): '||ad_ddl.error_buf;
2003: raise;
2004: end build_statement;
2005:
2006:

Line 2023: ad_ddl.error_buf := null;

2019: oracle_schema varchar2(30);
2020: apps_schema varchar2(30);
2021: apps_mls_schema varchar2(30);
2022: begin
2023: ad_ddl.error_buf := null;
2024: ad_apps_private.error_buf := null;
2025: gbl_statement := null;
2026:
2027: -- from the APPLSYS schema get an APPS schema so that we can access

Line 2050: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

2046: OUT oracle_schema, OUT dummy_boolean;
2047:
2048: exception
2049: when others then
2050: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2051: ad_ddl.error_buf;
2052: raise;
2053: end;
2054:

Line 2051: ad_ddl.error_buf;

2047:
2048: exception
2049: when others then
2050: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2051: ad_ddl.error_buf;
2052: raise;
2053: end;
2054:
2055: if dummy_boolean <> 'TRUE' then

Line 2079: ad_ddl.error_buf := 'do_array_ddl('||applsys_schema||', '||

2075: statement_type, lb, ub, upper(object_name));
2076:
2077: exception
2078: when others then
2079: ad_ddl.error_buf := 'do_array_ddl('||applsys_schema||', '||
2080: application_short_name||
2081: ', '||statement_type||', '||lb||', '||ub||', '||
2082: object_name||'): '||
2083: ad_ddl.error_buf||': '||ad_apps_private.error_buf||

Line 2083: ad_ddl.error_buf||': '||ad_apps_private.error_buf||

2079: ad_ddl.error_buf := 'do_array_ddl('||applsys_schema||', '||
2080: application_short_name||
2081: ', '||statement_type||', '||lb||', '||ub||', '||
2082: object_name||'): '||
2083: ad_ddl.error_buf||': '||ad_apps_private.error_buf||
2084: ': substr($statement$,1,255)='''||
2085: substr(gbl_statement,1,255)||'''';
2086: raise;
2087: end do_array_ddl;

Line 2138: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

2134: dbms_sql.close_cursor(c);
2135: exception
2136: when others then
2137: dbms_sql.close_cursor(c);
2138: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2139: ad_ddl.error_buf;
2140: raise;
2141: end;
2142:

Line 2139: ad_ddl.error_buf;

2135: exception
2136: when others then
2137: dbms_sql.close_cursor(c);
2138: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2139: ad_ddl.error_buf;
2140: raise;
2141: end;
2142:
2143: -- Check for APPS*DDL packages

Line 2159: if statement_type = ad_ddl.create_view then

2155:
2156: --
2157: -- Based on type of action determine what to do
2158: --
2159: if statement_type = ad_ddl.create_view then
2160: do_array_c_view(install_group_num, p_apps_schema,
2161: object_name, lb, ub);
2162: else
2163: raise_application_error(-20000,'Unsupported statement type '||

Line 2169: ad_ddl.error_buf := 'private_do_array_ddl('||p_apps_schema||', '||

2165: end if;
2166:
2167: exception
2168: when others then
2169: ad_ddl.error_buf := 'private_do_array_ddl('||p_apps_schema||', '||
2170: p_applsys_schema||', '||oracle_schema||
2171: ', '||statement_type||', '||lb||', '||ub||', '||
2172: object_name||'): '||ad_ddl.error_buf;
2173: raise;

Line 2172: object_name||'): '||ad_ddl.error_buf;

2168: when others then
2169: ad_ddl.error_buf := 'private_do_array_ddl('||p_apps_schema||', '||
2170: p_applsys_schema||', '||oracle_schema||
2171: ', '||statement_type||', '||lb||', '||ub||', '||
2172: object_name||'): '||ad_ddl.error_buf;
2173: raise;
2174: end private_do_array_ddl;
2175:
2176:

Line 2259: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

2255: exception
2256: when others then
2257: dbms_sql.close_cursor(c);
2258: if print_local_sql then
2259: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2260: ad_ddl.error_buf;
2261: end if;
2262: raise;
2263: end;

Line 2260: ad_ddl.error_buf;

2256: when others then
2257: dbms_sql.close_cursor(c);
2258: if print_local_sql then
2259: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2260: ad_ddl.error_buf;
2261: end if;
2262: raise;
2263: end;
2264: end if;

Line 2267: ad_ddl.error_buf := 'do_array_c_view('||dcv_install_group_num||', '||

2263: end;
2264: end if;
2265: exception
2266: when others then
2267: ad_ddl.error_buf := 'do_array_c_view('||dcv_install_group_num||', '||
2268: dcv_apps_schema||', '||dcv_object_name||', '||
2269: dcv_lb||', '||dcv_ub||'): '||ad_ddl.error_buf;
2270: raise;
2271: end do_array_c_view;

Line 2269: dcv_lb||', '||dcv_ub||'): '||ad_ddl.error_buf;

2265: exception
2266: when others then
2267: ad_ddl.error_buf := 'do_array_c_view('||dcv_install_group_num||', '||
2268: dcv_apps_schema||', '||dcv_object_name||', '||
2269: dcv_lb||', '||dcv_ub||'): '||ad_ddl.error_buf;
2270: raise;
2271: end do_array_c_view;
2272:
2273:

Line 2311: ad_ddl.glprogtext(counter), counter);

2307:
2308: for counter in p_lb..p_ub loop
2309: begin
2310: ad_apps_private.do_array_assignment(p_schema_name,
2311: ad_ddl.glprogtext(counter), counter);
2312: exception
2313: when others then
2314: ad_ddl.error_buf := ' At line '||counter||' of array DDL text '||
2315: ad_ddl.error_buf;

Line 2314: ad_ddl.error_buf := ' At line '||counter||' of array DDL text '||

2310: ad_apps_private.do_array_assignment(p_schema_name,
2311: ad_ddl.glprogtext(counter), counter);
2312: exception
2313: when others then
2314: ad_ddl.error_buf := ' At line '||counter||' of array DDL text '||
2315: ad_ddl.error_buf;
2316: raise;
2317: end;
2318: end loop;

Line 2315: ad_ddl.error_buf;

2311: ad_ddl.glprogtext(counter), counter);
2312: exception
2313: when others then
2314: ad_ddl.error_buf := ' At line '||counter||' of array DDL text '||
2315: ad_ddl.error_buf;
2316: raise;
2317: end;
2318: end loop;
2319:

Line 2328: ad_ddl.error_buf := 'array_assign_and_execute('||

2324: ad_apps_private.do_apps_array_ddl(p_schema_name, p_lb, p_ub, add_newline);
2325:
2326: exception
2327: when others then
2328: ad_ddl.error_buf := 'array_assign_and_execute('||
2329: p_schema_name||', '||p_lb||', '||p_ub||', '||add_newline||
2330: '): '||ad_ddl.error_buf;
2331: --
2332: -- load statement array into gbl_statement

Line 2330: '): '||ad_ddl.error_buf;

2326: exception
2327: when others then
2328: ad_ddl.error_buf := 'array_assign_and_execute('||
2329: p_schema_name||', '||p_lb||', '||p_ub||', '||add_newline||
2330: '): '||ad_ddl.error_buf;
2331: --
2332: -- load statement array into gbl_statement
2333: --
2334: get_array_statement(p_lb, p_ub);

Line 2357: chunk_length := lengthb(ad_ddl.glprogtext(array_index));

2353: if array_index > p_ub then
2354: exit;
2355: end if;
2356:
2357: chunk_length := lengthb(ad_ddl.glprogtext(array_index));
2358:
2359: if (statement_length + chunk_length) > 32760 then
2360: exit;
2361: end if;

Line 2364: gbl_statement := gbl_statement || ad_ddl.glprogtext(array_index);

2360: exit;
2361: end if;
2362:
2363: if chunk_length > 0 then
2364: gbl_statement := gbl_statement || ad_ddl.glprogtext(array_index);
2365: statement_length := statement_length + chunk_length;
2366: end if;
2367:
2368: array_index := array_index + 1;

Line 2373: ad_ddl.error_buf := ad_ddl.error_buf||

2369: end loop;
2370:
2371: exception
2372: when others then
2373: ad_ddl.error_buf := ad_ddl.error_buf||
2374: 'get_array_statement('||p_lb||', '||p_ub||'): ';
2375: raise;
2376: end get_array_statement;
2377:

Line 2388: ad_ddl.error_buf := null;

2384: uc_schema varchar2(30);
2385: begin
2386: -- Initialize global variables
2387:
2388: ad_ddl.error_buf := null;
2389: ad_apps_private.error_buf := null;
2390: gbl_statement := ddl_text;
2391:
2392: -- Upper-case schema name

Line 2411: ad_ddl.error_buf := 'create_trigger_in_schema('||schema_name||

2407: end;
2408:
2409: exception
2410: when others then
2411: ad_ddl.error_buf := 'create_trigger_in_schema('||schema_name||
2412: ', $statement$): '||ad_ddl.error_buf||': '||ad_apps_private.error_buf||
2413: ': substr($statement$,1,255)='''||
2414: substr(gbl_statement,1,255)||'''';
2415: raise;

Line 2412: ', $statement$): '||ad_ddl.error_buf||': '||ad_apps_private.error_buf||

2408:
2409: exception
2410: when others then
2411: ad_ddl.error_buf := 'create_trigger_in_schema('||schema_name||
2412: ', $statement$): '||ad_ddl.error_buf||': '||ad_apps_private.error_buf||
2413: ': substr($statement$,1,255)='''||
2414: substr(gbl_statement,1,255)||'''';
2415: raise;
2416: end create_trigger_in_schema;

Line 2419: end ad_ddl;

2415: raise;
2416: end create_trigger_in_schema;
2417:
2418:
2419: end ad_ddl;