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.

[Home] [Help]

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.14.12020000.2 2012/09/13 15:06:25 jvalenti ship $ */
3:
4: --
5: -- Global variables

Line 126: ad_ddl.error_buf := null;

122: oracle_schema varchar2(30);
123: apps_schema varchar2(30);
124: apps_mls_schema varchar2(30);
125: begin
126: ad_ddl.error_buf := null;
127: ad_apps_private.error_buf := null;
128: gbl_statement := statement;
129:
130: -- from the APPLSYS schema get an APPS schema so that we can access

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

149: OUT oracle_schema, OUT dummy_boolean;
150:
151: exception
152: when others then
153: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
154: ad_ddl.error_buf;
155: raise;
156: end;
157:

Line 154: ad_ddl.error_buf;

150:
151: exception
152: when others then
153: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
154: ad_ddl.error_buf;
155: raise;
156: end;
157:
158: if dummy_boolean <> 'TRUE' then

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

177: log_message('done calling private_do_ddl..');
178:
179: exception
180: when others then
181: ad_ddl.error_buf := 'do_ddl('||applsys_schema||', '||
182: application_short_name||
183: ', '||statement_type||', $statement$, '||
184: object_name||'): '||
185: ad_ddl.error_buf||': '||ad_apps_private.error_buf||

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

181: ad_ddl.error_buf := 'do_ddl('||applsys_schema||', '||
182: application_short_name||
183: ', '||statement_type||', $statement$, '||
184: object_name||'): '||
185: ad_ddl.error_buf||': '||ad_apps_private.error_buf||
186: ': substr($statement$,1,255)='''||
187: substr(gbl_statement,1,255)||'''';
188: raise;
189: end do_ddl;

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

244: g_Ign_Cache_Tbl(oracle_schema) := install_group_num;
245: exception
246: when others then
247: dbms_sql.close_cursor(c);
248: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
249: ad_ddl.error_buf;
250: raise;
251: END ; -- Block Find Ign
252: END IF ;

Line 249: ad_ddl.error_buf;

245: exception
246: when others then
247: dbms_sql.close_cursor(c);
248: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
249: ad_ddl.error_buf;
250: raise;
251: END ; -- Block Find Ign
252: END IF ;
253: else

Line 282: if statement_type = ad_ddl.alter_sequence

278: --
279: -- Based on type of action determine what to do
280: --
281: --
282: if statement_type = ad_ddl.alter_sequence
283: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
284: statement_type, object_name);
285: elsif statement_type = ad_ddl.alter_table
286: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,

Line 285: elsif statement_type = ad_ddl.alter_table

281: --
282: if statement_type = ad_ddl.alter_sequence
283: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
284: statement_type, object_name);
285: elsif statement_type = ad_ddl.alter_table
286: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
287: statement_type, object_name);
288: elsif statement_type = ad_ddl.alter_trigger
289: then do_acd_trigger(install_group_num, p_apps_schema, statement, object_name);

Line 288: elsif statement_type = ad_ddl.alter_trigger

284: statement_type, object_name);
285: elsif statement_type = ad_ddl.alter_table
286: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
287: statement_type, object_name);
288: elsif statement_type = ad_ddl.alter_trigger
289: then do_acd_trigger(install_group_num, p_apps_schema, statement, object_name);
290: elsif statement_type = ad_ddl.alter_view
291: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
292: statement,object_name);

Line 290: elsif statement_type = ad_ddl.alter_view

286: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
287: statement_type, object_name);
288: elsif statement_type = ad_ddl.alter_trigger
289: then do_acd_trigger(install_group_num, p_apps_schema, statement, object_name);
290: elsif statement_type = ad_ddl.alter_view
291: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
292: statement,object_name);
293: elsif statement_type = ad_ddl.create_index
294: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,

Line 293: elsif statement_type = ad_ddl.create_index

289: then do_acd_trigger(install_group_num, p_apps_schema, statement, object_name);
290: elsif statement_type = ad_ddl.alter_view
291: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
292: statement,object_name);
293: elsif statement_type = ad_ddl.create_index
294: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
295: statement_type, object_name);
296: elsif statement_type = ad_ddl.create_sequence
297: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,

Line 296: elsif statement_type = ad_ddl.create_sequence

292: statement,object_name);
293: elsif statement_type = ad_ddl.create_index
294: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
295: statement_type, object_name);
296: elsif statement_type = ad_ddl.create_sequence
297: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
298: statement_type, object_name, statement);
299: elsif statement_type = ad_ddl.create_synonym
300: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,

Line 299: elsif statement_type = ad_ddl.create_synonym

295: statement_type, object_name);
296: elsif statement_type = ad_ddl.create_sequence
297: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
298: statement_type, object_name, statement);
299: elsif statement_type = ad_ddl.create_synonym
300: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
301: statement,object_name);
302: elsif statement_type = ad_ddl.create_table
303: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,

Line 302: elsif statement_type = ad_ddl.create_table

298: statement_type, object_name, statement);
299: elsif statement_type = ad_ddl.create_synonym
300: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
301: statement,object_name);
302: elsif statement_type = ad_ddl.create_table
303: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
304: statement_type, object_name, statement);
305: elsif statement_type = ad_ddl.create_trigger
306: then do_acd_trigger(install_group_num, p_apps_schema, statement, object_name);

Line 305: elsif statement_type = ad_ddl.create_trigger

301: statement,object_name);
302: elsif statement_type = ad_ddl.create_table
303: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
304: statement_type, object_name, statement);
305: elsif statement_type = ad_ddl.create_trigger
306: then do_acd_trigger(install_group_num, p_apps_schema, statement, object_name);
307: elsif statement_type = ad_ddl.create_view
308: then
309: log_message('calling do_cd_view...');

Line 307: elsif statement_type = ad_ddl.create_view

303: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
304: statement_type, object_name, statement);
305: elsif statement_type = ad_ddl.create_trigger
306: then do_acd_trigger(install_group_num, p_apps_schema, statement, object_name);
307: elsif statement_type = ad_ddl.create_view
308: then
309: log_message('calling do_cd_view...');
310: do_cd_view(install_group_num, p_apps_schema, statement_type,
311: object_name, statement);

Line 313: elsif statement_type = ad_ddl.drop_index

309: log_message('calling do_cd_view...');
310: do_cd_view(install_group_num, p_apps_schema, statement_type,
311: object_name, statement);
312: log_message('donecalling do_cd_view...');
313: elsif statement_type = ad_ddl.drop_index
314: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
315: statement_type, object_name);
316: elsif statement_type = ad_ddl.drop_sequence
317: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,

Line 316: elsif statement_type = ad_ddl.drop_sequence

312: log_message('donecalling do_cd_view...');
313: elsif statement_type = ad_ddl.drop_index
314: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
315: statement_type, object_name);
316: elsif statement_type = ad_ddl.drop_sequence
317: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
318: statement_type, object_name, statement);
319: elsif statement_type = ad_ddl.drop_synonym
320: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,

Line 319: elsif statement_type = ad_ddl.drop_synonym

315: statement_type, object_name);
316: elsif statement_type = ad_ddl.drop_sequence
317: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
318: statement_type, object_name, statement);
319: elsif statement_type = ad_ddl.drop_synonym
320: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
321: statement,object_name);
322: elsif statement_type = ad_ddl.drop_table
323: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,

Line 322: elsif statement_type = ad_ddl.drop_table

318: statement_type, object_name, statement);
319: elsif statement_type = ad_ddl.drop_synonym
320: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
321: statement,object_name);
322: elsif statement_type = ad_ddl.drop_table
323: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
324: statement_type, object_name, statement);
325: elsif statement_type = ad_ddl.drop_trigger
326: then do_acd_trigger(install_group_num, p_apps_schema, statement, object_name);

Line 325: elsif statement_type = ad_ddl.drop_trigger

321: statement,object_name);
322: elsif statement_type = ad_ddl.drop_table
323: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
324: statement_type, object_name, statement);
325: elsif statement_type = ad_ddl.drop_trigger
326: then do_acd_trigger(install_group_num, p_apps_schema, statement, object_name);
327: elsif statement_type = ad_ddl.drop_view
328: then do_cd_view(install_group_num, p_apps_schema, statement_type,
329: object_name, statement);

Line 327: elsif statement_type = ad_ddl.drop_view

323: then do_cd_tab_cd_seq(install_group_num, p_apps_schema, oracle_schema,
324: statement_type, object_name, statement);
325: elsif statement_type = ad_ddl.drop_trigger
326: then do_acd_trigger(install_group_num, p_apps_schema, statement, object_name);
327: elsif statement_type = ad_ddl.drop_view
328: then do_cd_view(install_group_num, p_apps_schema, statement_type,
329: object_name, statement);
330: elsif statement_type = ad_ddl.truncate_table
331: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,

Line 330: elsif statement_type = ad_ddl.truncate_table

326: then do_acd_trigger(install_group_num, p_apps_schema, statement, object_name);
327: elsif statement_type = ad_ddl.drop_view
328: then do_cd_view(install_group_num, p_apps_schema, statement_type,
329: object_name, statement);
330: elsif statement_type = ad_ddl.truncate_table
331: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
332: statement_type, object_name);
333: elsif statement_type = ad_ddl.alter_package
334: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,

Line 333: elsif statement_type = ad_ddl.alter_package

329: object_name, statement);
330: elsif statement_type = ad_ddl.truncate_table
331: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
332: statement_type, object_name);
333: elsif statement_type = ad_ddl.alter_package
334: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
335: statement,object_name);
336: elsif statement_type = ad_ddl.drop_package
337: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,

Line 336: elsif statement_type = ad_ddl.drop_package

332: statement_type, object_name);
333: elsif statement_type = ad_ddl.alter_package
334: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
335: statement,object_name);
336: elsif statement_type = ad_ddl.drop_package
337: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
338: statement,object_name);
339: elsif statement_type = ad_ddl.create_grants
340: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,

Line 339: elsif statement_type = ad_ddl.create_grants

335: statement,object_name);
336: elsif statement_type = ad_ddl.drop_package
337: then do_a_view_cd_syn_ad_pack(install_group_num, p_apps_schema,
338: statement,object_name);
339: elsif statement_type = ad_ddl.create_grants
340: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
341: statement_type, object_name);
342:
343: -- fix bug 2804640, it returns base schema

Line 347: elsif statement_type = ad_ddl.create_base_synonym

343: -- fix bug 2804640, it returns base schema
344: -- The issue in do_ddl() was that synonyms were not created in
345: -- base schemas, but in APPS and APPS_MRC
346:
347: elsif statement_type = ad_ddl.create_base_synonym
348: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
349: statement_type, object_name);
350: ---- added by vpalakur for ZD
351: ad_apps_private.do_apps_ddl_on_patch_edn(oracle_schema,object_name,

Line 353: elsif statement_type = ad_ddl.drop_base_synonym

349: statement_type, object_name);
350: ---- added by vpalakur for ZD
351: ad_apps_private.do_apps_ddl_on_patch_edn(oracle_schema,object_name,
352: 'SYNONYM',statement,'TRUE');
353: elsif statement_type = ad_ddl.drop_base_synonym
354: then do_at_tab_a_seq_acd_ind(p_apps_schema, oracle_schema, statement,
355: statement_type, object_name);
356: ---- added by vpalakur for ZD
357: ad_apps_private.do_apps_ddl_on_patch_edn(oracle_schema, object_name,

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

359:
360: end if;
361: exception
362: when others then
363: ad_ddl.error_buf := 'private_do_ddl('||p_apps_schema||', '||
364: p_applsys_schema||', '||oracle_schema||
365: ', '||statement_type||', $statement$, '||
366: object_name||'): '||ad_ddl.error_buf;
367: raise;

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

362: when others then
363: ad_ddl.error_buf := 'private_do_ddl('||p_apps_schema||', '||
364: p_applsys_schema||', '||oracle_schema||
365: ', '||statement_type||', $statement$, '||
366: object_name||'): '||ad_ddl.error_buf;
367: raise;
368: end;
369:
370:

Line 384: if (datasai_statement_type = ad_ddl.alter_table and

380: begin
381:
382: ad_apps_private.do_apps_ddl(datasai_oracle_schema,datasai_statement, 'TRUE');
383:
384: if (datasai_statement_type = ad_ddl.alter_table and
385: ad_apps_private.is_edition_enabled = 'Y')
386: then
387: -- Bug 14471759 Only generate editioned view with the following commands.
388:

Line 411: ad_ddl.error_buf := 'do_at_tab_a_seq_acd_ind('||datasai_oracle_schema||

407: end if;
408:
409: exception
410: when others then
411: ad_ddl.error_buf := 'do_at_tab_a_seq_acd_ind('||datasai_oracle_schema||
412: ', $statement$): '||ad_ddl.error_buf;
413: raise;
414: end;
415:

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

408:
409: exception
410: when others then
411: ad_ddl.error_buf := 'do_at_tab_a_seq_acd_ind('||datasai_oracle_schema||
412: ', $statement$): '||ad_ddl.error_buf;
413: raise;
414: end;
415:
416:

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

440: --
441: -- reset main error buffer
442: ad_apps_private.error_buf := null;
443: when others then
444: ad_ddl.error_buf := 'do_acd_trigger('||dat_install_group_num||', '||
445: dat_apps_schema||', $statement$): '||ad_ddl.error_buf;
446: raise;
447: end;
448:

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

441: -- reset main error buffer
442: ad_apps_private.error_buf := null;
443: when others then
444: ad_ddl.error_buf := 'do_acd_trigger('||dat_install_group_num||', '||
445: dat_apps_schema||', $statement$): '||ad_ddl.error_buf;
446: raise;
447: end;
448:
449: procedure do_acd_trigger

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

475: --
476: -- reset main error buffer
477: ad_apps_private.error_buf := null;
478: when others then
479: ad_ddl.error_buf := 'do_acd_trigger('||dat_install_group_num||', '||
480: dat_apps_schema||', $statement$): '||ad_ddl.error_buf;
481: raise;
482: end;
483:

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

476: -- reset main error buffer
477: ad_apps_private.error_buf := null;
478: when others then
479: ad_ddl.error_buf := 'do_acd_trigger('||dat_install_group_num||', '||
480: dat_apps_schema||', $statement$): '||ad_ddl.error_buf;
481: raise;
482: end;
483:
484:

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

673: exception
674: when others then
675: dbms_sql.close_cursor(c);
676: if print_local_sql then
677: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
678: ad_ddl.error_buf;
679: end if;
680: raise;
681: end;

Line 678: ad_ddl.error_buf;

674: when others then
675: dbms_sql.close_cursor(c);
676: if print_local_sql then
677: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
678: ad_ddl.error_buf;
679: end if;
680: raise;
681: end;
682: end if;

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

682: end if;
683:
684: exception
685: when others then
686: ad_ddl.error_buf := 'do_a_view_cd_syn_ad_pack('||
687: davcsap_install_group_num||', '
688: ||davcsap_apps_schema||', $statement$): '||
689: ad_ddl.error_buf;
690: raise;

Line 689: ad_ddl.error_buf;

685: when others then
686: ad_ddl.error_buf := 'do_a_view_cd_syn_ad_pack('||
687: davcsap_install_group_num||', '
688: ||davcsap_apps_schema||', $statement$): '||
689: ad_ddl.error_buf;
690: raise;
691: end;
692:
693:

Line 716: if dctcs_statement_type = ad_ddl.drop_sequence then

712: or ad_apps_private.is_mc is null then
713: ad_apps_private.initialize(dctcs_apps_schema);
714: end if;
715: -- do statement in base schema
716: if dctcs_statement_type = ad_ddl.drop_sequence then
717: ad_apps_private.drop_object(dctcs_oracle_schema, dctcs_object_name,
718: 'SEQUENCE');
719: elsif dctcs_statement_type = ad_ddl.drop_table then
720: ad_apps_private.drop_object(dctcs_oracle_schema, dctcs_object_name,

Line 719: elsif dctcs_statement_type = ad_ddl.drop_table then

715: -- do statement in base schema
716: if dctcs_statement_type = ad_ddl.drop_sequence then
717: ad_apps_private.drop_object(dctcs_oracle_schema, dctcs_object_name,
718: 'SEQUENCE');
719: elsif dctcs_statement_type = ad_ddl.drop_table then
720: ad_apps_private.drop_object(dctcs_oracle_schema, dctcs_object_name,
721: 'TABLE');
722: if (ad_apps_private.is_edition_enabled = 'Y')
723: then

Line 754: if dctcs_statement_type = ad_ddl.create_sequence then

750: ad_apps_private.get_apps_schema_name(dctcs_install_group_num,
751: dctcs_apps_schema, l_apps_schema, l_mls_apps_schema);
752:
753: -- create/drop grant/synonym in apps schema
754: if dctcs_statement_type = ad_ddl.create_sequence then
755: ad_apps_private.create_gs(dctcs_oracle_schema, l_apps_schema,
756: dctcs_object_name, TRUE, 'ALL');
757: elsif dctcs_statement_type = ad_ddl.create_table then
758: ad_apps_private.create_gs(dctcs_oracle_schema, l_apps_schema,

Line 757: elsif dctcs_statement_type = ad_ddl.create_table then

753: -- create/drop grant/synonym in apps schema
754: if dctcs_statement_type = ad_ddl.create_sequence then
755: ad_apps_private.create_gs(dctcs_oracle_schema, l_apps_schema,
756: dctcs_object_name, TRUE, 'ALL');
757: elsif dctcs_statement_type = ad_ddl.create_table then
758: ad_apps_private.create_gs(dctcs_oracle_schema, l_apps_schema,
759: dctcs_object_name, TRUE, 'ALL', to_ev=>ad_apps_private.is_edition_enabled);
760: else -- this is a drop table/sequence
761: ad_apps_private.drop_object(l_apps_schema,

Line 767: if dctcs_statement_type = ad_ddl.create_sequence then

763: end if;
764:
765: if ad_apps_private.is_mls then
766: -- create/drop grant/synonym in apps_mls schema
767: if dctcs_statement_type = ad_ddl.create_sequence then
768: ad_apps_private.create_gs(dctcs_oracle_schema,
769: l_mls_apps_schema,
770: dctcs_object_name, TRUE, 'ALL');
771: elsif dctcs_statement_type = ad_ddl.create_table

Line 771: elsif dctcs_statement_type = ad_ddl.create_table

767: if dctcs_statement_type = ad_ddl.create_sequence then
768: ad_apps_private.create_gs(dctcs_oracle_schema,
769: l_mls_apps_schema,
770: dctcs_object_name, TRUE, 'ALL');
771: elsif dctcs_statement_type = ad_ddl.create_table
772: then
773: ad_apps_private.create_gs(dctcs_oracle_schema,
774: l_mls_apps_schema,
775: dctcs_object_name, TRUE, 'ALL', to_ev=>ad_apps_private.is_edition_enabled);

Line 815: if dctcs_statement_type = ad_ddl.create_sequence then

811: ad_apps_private.get_apps_schema_name(l_install_group_num,
812: dctcs_apps_schema, l_apps_schema, l_mls_apps_schema);
813:
814: -- create/drop grant/synonym in apps schema
815: if dctcs_statement_type = ad_ddl.create_sequence then
816:
817: ad_apps_private.create_gs(dctcs_oracle_schema,
818: l_apps_schema,
819: dctcs_object_name, TRUE, 'ALL');

Line 820: elsif dctcs_statement_type = ad_ddl.create_table

816:
817: ad_apps_private.create_gs(dctcs_oracle_schema,
818: l_apps_schema,
819: dctcs_object_name, TRUE, 'ALL');
820: elsif dctcs_statement_type = ad_ddl.create_table
821: then
822: ad_apps_private.create_gs(dctcs_oracle_schema,
823: l_apps_schema,
824: dctcs_object_name, TRUE, 'ALL', to_ev=>ad_apps_private.is_edition_enabled);

Line 833: if dctcs_statement_type = ad_ddl.create_sequence then

829: end if;
830:
831: if ad_apps_private.is_mls then
832: -- create/drop grant/synonym in apps_mls schema
833: if dctcs_statement_type = ad_ddl.create_sequence then
834: ad_apps_private.create_gs(dctcs_oracle_schema,
835: l_mls_apps_schema, dctcs_object_name, TRUE, 'ALL');
836: elsif dctcs_statement_type = ad_ddl.create_table
837: then

Line 836: elsif dctcs_statement_type = ad_ddl.create_table

832: -- create/drop grant/synonym in apps_mls schema
833: if dctcs_statement_type = ad_ddl.create_sequence then
834: ad_apps_private.create_gs(dctcs_oracle_schema,
835: l_mls_apps_schema, dctcs_object_name, TRUE, 'ALL');
836: elsif dctcs_statement_type = ad_ddl.create_table
837: then
838: ad_apps_private.create_gs(dctcs_oracle_schema,
839: l_mls_apps_schema, dctcs_object_name, TRUE, 'ALL', to_ev=>ad_apps_private.is_edition_enabled);
840: else -- this is a drop table/sequence

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

851: exception
852: when others then
853: dbms_sql.close_cursor(c);
854: if print_local_sql then
855: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
856: ad_ddl.error_buf;
857: end if;
858: raise;
859: end;

Line 856: ad_ddl.error_buf;

852: when others then
853: dbms_sql.close_cursor(c);
854: if print_local_sql then
855: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
856: ad_ddl.error_buf;
857: end if;
858: raise;
859: end;
860: end if;

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

859: end;
860: end if;
861: exception
862: when others then
863: ad_ddl.error_buf := 'do_cd_tab_cd_seq('||dctcs_install_group_num||', '||
864: dctcs_apps_schema||', '||dctcs_oracle_schema||', '||
865: dctcs_statement_type||', '||dctcs_object_name||
866: ', $statement$): '||ad_ddl.error_buf;
867: raise;

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

862: when others then
863: ad_ddl.error_buf := 'do_cd_tab_cd_seq('||dctcs_install_group_num||', '||
864: dctcs_apps_schema||', '||dctcs_oracle_schema||', '||
865: dctcs_statement_type||', '||dctcs_object_name||
866: ', $statement$): '||ad_ddl.error_buf;
867: raise;
868: end;
869:
870:

Line 900: if dcv_statement_type = ad_ddl.drop_view then

896: ad_apps_private.get_apps_schema_name(dcv_install_group_num,
897: dcv_apps_schema, l_apps_schema, l_mls_apps_schema);
898:
899: -- create/drop view in apps schema
900: if dcv_statement_type = ad_ddl.drop_view then
901: log_message('1calling ad_apps_private.drop_object...');
902: ad_apps_private.drop_object(l_apps_schema,dcv_object_name,
903: 'VIEW');
904: log_message('1done calling ad_apps_private.drop_object...');

Line 929: if dcv_statement_type = ad_ddl.drop_view then

925: end if;
926:
927: if ad_apps_private.is_mls then
928: -- create/drop view in apps_mls schema
929: if dcv_statement_type = ad_ddl.drop_view then
930: log_message('4calling ad_apps_private.drop_object...');
931: ad_apps_private.drop_object(l_mls_apps_schema,
932: dcv_object_name,'VIEW');
933: log_message('4done calling ad_apps_private.drop_object...');

Line 988: if dcv_statement_type = ad_ddl.drop_view then

984: ad_apps_private.get_apps_schema_name(l_install_group_num,
985: dcv_apps_schema, l_apps_schema, l_mls_apps_schema);
986:
987: -- create/drop view in apps schema
988: if dcv_statement_type = ad_ddl.drop_view then
989: log_message('7calling ad_apps_private.drop_object...');
990: ad_apps_private.drop_object(l_apps_schema,
991: dcv_object_name,'VIEW');
992: log_message('7done calling ad_apps_private.drop_object...');

Line 1016: if dcv_statement_type = ad_ddl.drop_view then

1012: end if;
1013:
1014: if ad_apps_private.is_mls then
1015: -- create/drop view in apps_mls schema
1016: if dcv_statement_type = ad_ddl.drop_view then
1017: log_message('10calling ad_apps_private.drop_object...');
1018: ad_apps_private.drop_object(l_mls_apps_schema,
1019: dcv_object_name,'VIEW');
1020: log_message('10done calling ad_apps_private.drop_object...');

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

1048: exception
1049: when others then
1050: dbms_sql.close_cursor(c);
1051: if print_local_sql then
1052: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
1053: ad_ddl.error_buf;
1054: end if;
1055: raise;
1056: end;

Line 1053: ad_ddl.error_buf;

1049: when others then
1050: dbms_sql.close_cursor(c);
1051: if print_local_sql then
1052: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
1053: ad_ddl.error_buf;
1054: end if;
1055: raise;
1056: end;
1057: end if;

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

1056: end;
1057: end if;
1058: exception
1059: when others then
1060: ad_ddl.error_buf := 'do_cd_view('||dcv_install_group_num||', '||
1061: dcv_apps_schema||', '||
1062: dcv_statement_type||', '||dcv_object_name||
1063: ', $statement$): '||ad_ddl.error_buf;
1064: raise;

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

1059: when others then
1060: ad_ddl.error_buf := 'do_cd_view('||dcv_install_group_num||', '||
1061: dcv_apps_schema||', '||
1062: dcv_statement_type||', '||dcv_object_name||
1063: ', $statement$): '||ad_ddl.error_buf;
1064: raise;
1065: end do_cd_view;
1066:
1067:

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

1086: 'TRUE',
1087: dummy);
1088: exception
1089: when others then
1090: ad_ddl.error_buf := 'create_package('||applsys_schema||', '||
1091: application_short_name||
1092: ', '||package_name||', '||is_package_body||', '||
1093: lb||', '||ub||'): '||
1094: ad_ddl.error_buf||': '||ad_apps_private.error_buf||

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

1090: ad_ddl.error_buf := 'create_package('||applsys_schema||', '||
1091: application_short_name||
1092: ', '||package_name||', '||is_package_body||', '||
1093: lb||', '||ub||'): '||
1094: ad_ddl.error_buf||': '||ad_apps_private.error_buf||
1095: ': substr($statement$,1,255)='''||
1096: substr(gbl_statement,1,255)||'''';
1097: raise;
1098: end create_package;

Line 1162: ad_ddl.error_buf := null;

1158: --
1159:
1160: -- initialize variables
1161:
1162: ad_ddl.error_buf := null;
1163: ad_apps_private.error_buf := null;
1164: gbl_statement := null;
1165:
1166: comp_error := 'FALSE';

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

1167: upper_obj_name := upper(object_name);
1168:
1169: -- Determine object type
1170:
1171: if upper(ad_ddl.glprogtext(lb)) like 'CREATE%PACKAGE%' then
1172: if upper(ad_ddl.glprogtext(lb)) like 'CREATE%PACKAGE BODY%' then
1173: object_type := 'PACKAGE BODY';
1174: else
1175: object_type := 'PACKAGE';

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

1168:
1169: -- Determine object type
1170:
1171: if upper(ad_ddl.glprogtext(lb)) like 'CREATE%PACKAGE%' then
1172: if upper(ad_ddl.glprogtext(lb)) like 'CREATE%PACKAGE BODY%' then
1173: object_type := 'PACKAGE BODY';
1174: else
1175: object_type := 'PACKAGE';
1176: end if;

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

1173: object_type := 'PACKAGE BODY';
1174: else
1175: object_type := 'PACKAGE';
1176: end if;
1177: elsif upper(ad_ddl.glprogtext(lb)) like 'CREATE%PROCEDURE%' then
1178: object_type := 'PROCEDURE';
1179: elsif upper(ad_ddl.glprogtext(lb)) like 'CREATE%FUNCTION%' then
1180: object_type := 'FUNCTION';
1181: else

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

1175: object_type := 'PACKAGE';
1176: end if;
1177: elsif upper(ad_ddl.glprogtext(lb)) like 'CREATE%PROCEDURE%' then
1178: object_type := 'PROCEDURE';
1179: elsif upper(ad_ddl.glprogtext(lb)) like 'CREATE%FUNCTION%' then
1180: object_type := 'FUNCTION';
1181: else
1182: object_type := 'UNKNOWN';
1183: end if;

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

1232: OUT oracle_schema, OUT dummy_boolean;
1233: --
1234: exception
1235: when others then
1236: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1237: ad_ddl.error_buf;
1238: raise;
1239: end;
1240: --

Line 1237: ad_ddl.error_buf;

1233: --
1234: exception
1235: when others then
1236: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1237: ad_ddl.error_buf;
1238: raise;
1239: end;
1240: --
1241: if dummy_boolean <> 'TRUE' then

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

1276: into first_apps_schema;
1277:
1278: exception
1279: when others then
1280: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1281: ad_ddl.error_buf;
1282: raise;
1283: end;
1284:

Line 1281: ad_ddl.error_buf;

1277:
1278: exception
1279: when others then
1280: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1281: ad_ddl.error_buf;
1282: raise;
1283: end;
1284:
1285: -- Get the install_group_num for the oracle_schema that owns the object

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

1311: dbms_sql.close_cursor(c);
1312: exception
1313: when others then
1314: dbms_sql.close_cursor(c);
1315: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
1316: ad_ddl.error_buf;
1317: raise;
1318: end;
1319: else

Line 1316: ad_ddl.error_buf;

1312: exception
1313: when others then
1314: dbms_sql.close_cursor(c);
1315: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
1316: ad_ddl.error_buf;
1317: raise;
1318: end;
1319: else
1320:

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

1343: into current_apps_schema;
1344:
1345: exception
1346: when others then
1347: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1348: ad_ddl.error_buf;
1349: raise;
1350: end;
1351:

Line 1348: ad_ddl.error_buf;

1344:
1345: exception
1346: when others then
1347: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
1348: ad_ddl.error_buf;
1349: raise;
1350: end;
1351:
1352: else

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

1361:
1362: if object_type <> 'PACKAGE BODY' then
1363: -- not package body
1364:
1365: ad_invoker.classify_plsql_array(ad_ddl.glprogtext, lb, ub,
1366: object_type, obj_has_authid, obj_invoker_flag);
1367:
1368: if obj_has_authid = 'FALSE' then
1369:

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

1366: object_type, obj_has_authid, obj_invoker_flag);
1367:
1368: if obj_has_authid = 'FALSE' then
1369:
1370: ad_invoker.rewrite_plsql_array(ad_ddl.glprogtext, lb, ub,
1371: object_type);
1372:
1373: is_invoker_object := TRUE;
1374: invoker_flag_for_obj := 'I';

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

2063:
2064:
2065: exception
2066: when others then
2067: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
2068: ad_ddl.error_buf;
2069: raise;
2070: end;
2071:

Line 2068: ad_ddl.error_buf;

2064:
2065: exception
2066: when others then
2067: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
2068: ad_ddl.error_buf;
2069: raise;
2070: end;
2071:
2072: if object_status = 'INVALID' then

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

2089: into invalid_count;
2090:
2091: exception
2092: when others then
2093: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
2094: ad_ddl.error_buf;
2095: raise;
2096: end;
2097:

Line 2094: ad_ddl.error_buf;

2090:
2091: exception
2092: when others then
2093: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
2094: ad_ddl.error_buf;
2095: raise;
2096: end;
2097:
2098: if invalid_count <> 0 then

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

2116: into invalid_count;
2117:
2118: exception
2119: when others then
2120: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
2121: ad_ddl.error_buf;
2122: raise;
2123: end;
2124:

Line 2121: ad_ddl.error_buf;

2117:
2118: exception
2119: when others then
2120: ad_ddl.error_buf := 'c_statement='||c_statement||':'||
2121: ad_ddl.error_buf;
2122: raise;
2123: end;
2124:
2125: if invalid_count <> 0 then

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

2139: end if;
2140: -- end if comp_error is 'FALSE'
2141: exception
2142: when others then
2143: ad_ddl.error_buf := 'create_plsql_object('||applsys_schema||', '||
2144: application_short_name||
2145: ', '||object_name||', '||
2146: lb||', '||ub||', '||insert_newlines||'): '||
2147: ad_ddl.error_buf||': '||ad_apps_private.error_buf||

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

2143: ad_ddl.error_buf := 'create_plsql_object('||applsys_schema||', '||
2144: application_short_name||
2145: ', '||object_name||', '||
2146: lb||', '||ub||', '||insert_newlines||'): '||
2147: ad_ddl.error_buf||': '||ad_apps_private.error_buf||
2148: ': substr($statement$,1,255)='''||
2149: substr(gbl_statement,1,255)||'''';
2150: raise;
2151: end create_plsql_object;

Line 2159: ad_ddl.error_buf := null;

2155: (ddl_text in varchar2,
2156: row_num in integer)
2157: is
2158: begin
2159: ad_ddl.error_buf := null;
2160:
2161: ad_ddl.glprogtext(row_num) := ddl_text;
2162:
2163: exception

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

2157: is
2158: begin
2159: ad_ddl.error_buf := null;
2160:
2161: ad_ddl.glprogtext(row_num) := ddl_text;
2162:
2163: exception
2164: when others then
2165: ad_ddl.error_buf := 'build_package('||

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

2161: ad_ddl.glprogtext(row_num) := ddl_text;
2162:
2163: exception
2164: when others then
2165: ad_ddl.error_buf := 'build_package('||
2166: ddl_text||', '||row_num||'): '||ad_ddl.error_buf;
2167: raise;
2168: end build_package;
2169:

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

2162:
2163: exception
2164: when others then
2165: ad_ddl.error_buf := 'build_package('||
2166: ddl_text||', '||row_num||'): '||ad_ddl.error_buf;
2167: raise;
2168: end build_package;
2169:
2170:

Line 2176: ad_ddl.error_buf := null;

2172: (ddl_text in varchar2,
2173: row_num in integer)
2174: is
2175: begin
2176: ad_ddl.error_buf := null;
2177:
2178: ad_ddl.glprogtext(row_num) := ddl_text;
2179:
2180: exception

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

2174: is
2175: begin
2176: ad_ddl.error_buf := null;
2177:
2178: ad_ddl.glprogtext(row_num) := ddl_text;
2179:
2180: exception
2181: when others then
2182: ad_ddl.error_buf := 'build_statement('||

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

2178: ad_ddl.glprogtext(row_num) := ddl_text;
2179:
2180: exception
2181: when others then
2182: ad_ddl.error_buf := 'build_statement('||
2183: ddl_text||', '||row_num||'): '||ad_ddl.error_buf;
2184: raise;
2185: end build_statement;
2186:

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

2179:
2180: exception
2181: when others then
2182: ad_ddl.error_buf := 'build_statement('||
2183: ddl_text||', '||row_num||'): '||ad_ddl.error_buf;
2184: raise;
2185: end build_statement;
2186:
2187:

Line 2204: ad_ddl.error_buf := null;

2200: oracle_schema varchar2(30);
2201: apps_schema varchar2(30);
2202: apps_mls_schema varchar2(30);
2203: begin
2204: ad_ddl.error_buf := null;
2205: ad_apps_private.error_buf := null;
2206: gbl_statement := null;
2207:
2208: -- from the APPLSYS schema get an APPS schema so that we can access

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

2227: OUT oracle_schema, OUT dummy_boolean;
2228:
2229: exception
2230: when others then
2231: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2232: ad_ddl.error_buf;
2233: raise;
2234: end;
2235:

Line 2232: ad_ddl.error_buf;

2228:
2229: exception
2230: when others then
2231: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2232: ad_ddl.error_buf;
2233: raise;
2234: end;
2235:
2236: if dummy_boolean <> 'TRUE' then

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

2256: statement_type, lb, ub, upper(object_name));
2257:
2258: exception
2259: when others then
2260: ad_ddl.error_buf := 'do_array_ddl('||applsys_schema||', '||
2261: application_short_name||
2262: ', '||statement_type||', '||lb||', '||ub||', '||
2263: object_name||'): '||
2264: ad_ddl.error_buf||': '||ad_apps_private.error_buf||

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

2260: ad_ddl.error_buf := 'do_array_ddl('||applsys_schema||', '||
2261: application_short_name||
2262: ', '||statement_type||', '||lb||', '||ub||', '||
2263: object_name||'): '||
2264: ad_ddl.error_buf||': '||ad_apps_private.error_buf||
2265: ': substr($statement$,1,255)='''||
2266: substr(gbl_statement,1,255)||'''';
2267: raise;
2268: end do_array_ddl;

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

2315: dbms_sql.close_cursor(c);
2316: exception
2317: when others then
2318: dbms_sql.close_cursor(c);
2319: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2320: ad_ddl.error_buf;
2321: raise;
2322: end;
2323:

Line 2320: ad_ddl.error_buf;

2316: exception
2317: when others then
2318: dbms_sql.close_cursor(c);
2319: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2320: ad_ddl.error_buf;
2321: raise;
2322: end;
2323:
2324: -- Check for APPS*DDL packages

Line 2340: if statement_type = ad_ddl.create_view then

2336:
2337: --
2338: -- Based on type of action determine what to do
2339: --
2340: if statement_type = ad_ddl.create_view then
2341: do_array_c_view(install_group_num, p_apps_schema,
2342: object_name, lb, ub);
2343: else
2344: raise_application_error(-20000,'Unsupported statement type '||

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

2346: end if;
2347:
2348: exception
2349: when others then
2350: ad_ddl.error_buf := 'private_do_array_ddl('||p_apps_schema||', '||
2351: p_applsys_schema||', '||oracle_schema||
2352: ', '||statement_type||', '||lb||', '||ub||', '||
2353: object_name||'): '||ad_ddl.error_buf;
2354: raise;

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

2349: when others then
2350: ad_ddl.error_buf := 'private_do_array_ddl('||p_apps_schema||', '||
2351: p_applsys_schema||', '||oracle_schema||
2352: ', '||statement_type||', '||lb||', '||ub||', '||
2353: object_name||'): '||ad_ddl.error_buf;
2354: raise;
2355: end private_do_array_ddl;
2356:
2357:

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

2436: exception
2437: when others then
2438: dbms_sql.close_cursor(c);
2439: if print_local_sql then
2440: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2441: ad_ddl.error_buf;
2442: end if;
2443: raise;
2444: end;

Line 2441: ad_ddl.error_buf;

2437: when others then
2438: dbms_sql.close_cursor(c);
2439: if print_local_sql then
2440: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2441: ad_ddl.error_buf;
2442: end if;
2443: raise;
2444: end;
2445: end if;

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

2444: end;
2445: end if;
2446: exception
2447: when others then
2448: ad_ddl.error_buf := 'do_array_c_view('||dcv_install_group_num||', '||
2449: dcv_apps_schema||', '||dcv_object_name||', '||
2450: dcv_lb||', '||dcv_ub||'): '||ad_ddl.error_buf;
2451: raise;
2452: end do_array_c_view;

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

2446: exception
2447: when others then
2448: ad_ddl.error_buf := 'do_array_c_view('||dcv_install_group_num||', '||
2449: dcv_apps_schema||', '||dcv_object_name||', '||
2450: dcv_lb||', '||dcv_ub||'): '||ad_ddl.error_buf;
2451: raise;
2452: end do_array_c_view;
2453:
2454:

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

2493:
2494: for counter in p_lb..p_ub loop
2495: begin
2496: ad_apps_private.do_array_assignment(p_schema_name,
2497: ad_ddl.glprogtext(counter), counter);
2498: ad_apps_private.do_array_assignment_patch_edn(p_schema_name,
2499: ad_ddl.glprogtext(counter), counter);
2500: exception
2501: when others then

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

2495: begin
2496: ad_apps_private.do_array_assignment(p_schema_name,
2497: ad_ddl.glprogtext(counter), counter);
2498: ad_apps_private.do_array_assignment_patch_edn(p_schema_name,
2499: ad_ddl.glprogtext(counter), counter);
2500: exception
2501: when others then
2502: ad_ddl.error_buf := ' At line '||counter||' of array DDL text '||
2503: ad_ddl.error_buf;

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

2498: ad_apps_private.do_array_assignment_patch_edn(p_schema_name,
2499: ad_ddl.glprogtext(counter), counter);
2500: exception
2501: when others then
2502: ad_ddl.error_buf := ' At line '||counter||' of array DDL text '||
2503: ad_ddl.error_buf;
2504: raise;
2505: end;
2506: end loop;

Line 2503: ad_ddl.error_buf;

2499: ad_ddl.glprogtext(counter), counter);
2500: exception
2501: when others then
2502: ad_ddl.error_buf := ' At line '||counter||' of array DDL text '||
2503: ad_ddl.error_buf;
2504: raise;
2505: end;
2506: end loop;
2507:

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

2514:
2515:
2516: exception
2517: when others then
2518: ad_ddl.error_buf := 'array_assign_and_execute('||
2519: p_schema_name||', '||p_lb||', '||p_ub||', '||add_newline||
2520: '): '||ad_ddl.error_buf;
2521: --
2522: -- load statement array into gbl_statement

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

2516: exception
2517: when others then
2518: ad_ddl.error_buf := 'array_assign_and_execute('||
2519: p_schema_name||', '||p_lb||', '||p_ub||', '||add_newline||
2520: '): '||ad_ddl.error_buf;
2521: --
2522: -- load statement array into gbl_statement
2523: --
2524: get_array_statement(p_lb, p_ub);

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

2543: if array_index > p_ub then
2544: exit;
2545: end if;
2546:
2547: chunk_length := lengthb(ad_ddl.glprogtext(array_index));
2548:
2549: if (statement_length + chunk_length) > 32760 then
2550: exit;
2551: end if;

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

2550: exit;
2551: end if;
2552:
2553: if chunk_length > 0 then
2554: gbl_statement := gbl_statement || ad_ddl.glprogtext(array_index);
2555: statement_length := statement_length + chunk_length;
2556: end if;
2557:
2558: array_index := array_index + 1;

Line 2563: ad_ddl.error_buf := ad_ddl.error_buf||

2559: end loop;
2560:
2561: exception
2562: when others then
2563: ad_ddl.error_buf := ad_ddl.error_buf||
2564: 'get_array_statement('||p_lb||', '||p_ub||'): ';
2565: raise;
2566: end get_array_statement;
2567:

Line 2606: ad_ddl.error_buf := null;

2602: object_name varchar2(30);
2603: begin
2604: -- Initialize global variables
2605:
2606: ad_ddl.error_buf := null;
2607: ad_apps_private.error_buf := null;
2608: gbl_statement := ddl_text;
2609:
2610:

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

2636: end;
2637:
2638: exception
2639: when others then
2640: ad_ddl.error_buf := 'create_trigger_in_schema('||schema_name||
2641: ', $statement$): '||ad_ddl.error_buf||': '||ad_apps_private.error_buf||
2642: ': substr($statement$,1,255)='''||
2643: substr(gbl_statement,1,255)||'''';
2644: raise;

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

2637:
2638: exception
2639: when others then
2640: ad_ddl.error_buf := 'create_trigger_in_schema('||schema_name||
2641: ', $statement$): '||ad_ddl.error_buf||': '||ad_apps_private.error_buf||
2642: ': substr($statement$,1,255)='''||
2643: substr(gbl_statement,1,255)||'''';
2644: raise;
2645: end create_trigger_in_schema;

Line 2648: end ad_ddl;

2644: raise;
2645: end create_trigger_in_schema;
2646:
2647:
2648: end ad_ddl;