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_APPS_PRIVATE

Line 105: ad_apps_private.error_buf := null;

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
109: -- the procedure FND_INSTALLATION that exists there

Line 110: ad_apps_private.get_apps_schema_name( 0, applsys_schema,

106: gbl_statement := statement;
107:
108: -- from the APPLSYS schema get an APPS schema so that we can access
109: -- the procedure FND_INSTALLATION that exists there
110: ad_apps_private.get_apps_schema_name( 0, applsys_schema,
111: apps_schema, apps_mls_schema);
112:
113:
114: if upper(application_short_name) not in ('INTERMEDIA','APPS') then

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 189: if ad_apps_private.is_mls is null

185: rows_processed integer;
186: c integer;
187: begin
188:
189: if ad_apps_private.is_mls is null
190: or ad_apps_private.is_mc is null then
191: ad_apps_private.initialize(p_apps_schema);
192: end if;
193:

Line 190: or ad_apps_private.is_mc is null then

186: c integer;
187: begin
188:
189: if ad_apps_private.is_mls is null
190: or ad_apps_private.is_mc is null then
191: ad_apps_private.initialize(p_apps_schema);
192: end if;
193:
194: -- get the install_group_num from the oracle_schema that the object

Line 191: ad_apps_private.initialize(p_apps_schema);

187: begin
188:
189: if ad_apps_private.is_mls is null
190: or ad_apps_private.is_mc is null then
191: ad_apps_private.initialize(p_apps_schema);
192: end if;
193:
194: -- get the install_group_num from the oracle_schema that the object
195: -- is to be created in.

Line 238: ad_apps_private.check_for_apps_ddl(p_apps_schema);

234:
235:
236: -- Check for APPS*DDL packages
237:
238: ad_apps_private.check_for_apps_ddl(p_apps_schema);
239: ad_apps_private.check_for_apps_ddl(oracle_schema);
240:
241:
242: if install_group_num <> -99 then

Line 239: ad_apps_private.check_for_apps_ddl(oracle_schema);

235:
236: -- Check for APPS*DDL packages
237:
238: ad_apps_private.check_for_apps_ddl(p_apps_schema);
239: ad_apps_private.check_for_apps_ddl(oracle_schema);
240:
241:
242: if install_group_num <> -99 then
243: --

Line 245: if ad_apps_private.is_mls then

241:
242: if install_group_num <> -99 then
243: --
244: --
245: if ad_apps_private.is_mls then
246: -- Get name of mls schema
247: ad_apps_private.get_apps_schema_name(install_group_num, p_applsys_schema,
248: l_apps_schema, l_mls_apps_schema);
249: -- check for APPS*DDL in mls schema

Line 247: ad_apps_private.get_apps_schema_name(install_group_num, p_applsys_schema,

243: --
244: --
245: if ad_apps_private.is_mls then
246: -- Get name of mls schema
247: ad_apps_private.get_apps_schema_name(install_group_num, p_applsys_schema,
248: l_apps_schema, l_mls_apps_schema);
249: -- check for APPS*DDL in mls schema
250: ad_apps_private.check_for_apps_ddl(l_mls_apps_schema);
251: end if;

Line 250: ad_apps_private.check_for_apps_ddl(l_mls_apps_schema);

246: -- Get name of mls schema
247: ad_apps_private.get_apps_schema_name(install_group_num, p_applsys_schema,
248: l_apps_schema, l_mls_apps_schema);
249: -- check for APPS*DDL in mls schema
250: ad_apps_private.check_for_apps_ddl(l_mls_apps_schema);
251: end if;
252:
253: end if;
254:

Line 336: ad_apps_private.do_apps_ddl(datasai_oracle_schema,datasai_statement,

332: (datasai_oracle_schema in varchar2,
333: datasai_statement in varchar2)
334: is
335: begin
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||

Line 357: ad_apps_private.get_apps_schema_name(dat_install_group_num,

353: l_apps_schema varchar2(30);
354: l_mls_apps_schema varchar2(30);
355: begin
356: -- get the apps_schema_names for this install group
357: ad_apps_private.get_apps_schema_name(dat_install_group_num,
358: dat_apps_schema, l_apps_schema, l_mls_apps_schema);
359:
360:
361: -- execute the trigger code in the apps schema

Line 362: ad_apps_private.do_apps_ddl(l_apps_schema,dat_statement, 'TRUE');

358: dat_apps_schema, l_apps_schema, l_mls_apps_schema);
359:
360:
361: -- execute the trigger code in the apps schema
362: ad_apps_private.do_apps_ddl(l_apps_schema,dat_statement, 'TRUE');
363:
364: exception
365: when success_with_comp_error then
366: --

Line 371: ad_apps_private.error_buf := null;

367: -- Trap and ignore ORA-24344: success with compilation error
368: -- This only happens on ORACLE 8
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;

Line 404: if ad_apps_private.is_mls is null

400: print_local_sql boolean;
401: begin
402:
403:
404: if ad_apps_private.is_mls is null
405: or ad_apps_private.is_mc is null then
406: ad_apps_private.initialize(davcsap_apps_schema);
407: end if;
408:

Line 405: or ad_apps_private.is_mc is null then

401: begin
402:
403:
404: if ad_apps_private.is_mls is null
405: or ad_apps_private.is_mc is null then
406: ad_apps_private.initialize(davcsap_apps_schema);
407: end if;
408:
409: if davcsap_install_group_num <> 0 then

Line 406: ad_apps_private.initialize(davcsap_apps_schema);

402:
403:
404: if ad_apps_private.is_mls is null
405: or ad_apps_private.is_mc is null then
406: ad_apps_private.initialize(davcsap_apps_schema);
407: end if;
408:
409: if davcsap_install_group_num <> 0 then
410: -- if this is a non 0 install group then perform this only

Line 415: ad_apps_private.get_apps_schema_name(davcsap_install_group_num,

411: -- for that apps account
412:
413: -- get the apps_schema_names for this install group
414: if davcsap_install_group_num <> -99 then
415: ad_apps_private.get_apps_schema_name(davcsap_install_group_num,
416: davcsap_apps_schema, l_apps_schema, l_mls_apps_schema);
417: else
418: l_apps_schema:='CTXSYS';
419: end if;

Line 424: ad_apps_private.do_apps_ddl(l_apps_schema, davcsap_statement,

420:
421:
422: -- execute the alter view in the apps schema
423: begin
424: ad_apps_private.do_apps_ddl(l_apps_schema, davcsap_statement,
425: 'TRUE');
426: exception
427: when success_with_comp_error then
428: --

Line 433: ad_apps_private.error_buf := null;

429: -- Trap and ignore ORA-24344: success with compilation error
430: -- This only happens on ORACLE 8
431: --
432: -- reset main error buffer
433: ad_apps_private.error_buf := null;
434:
435: --
436: -- rkagrawa: Fixed bug 2823541. When dropping synonyms, trap and ignore
437: -- ORA-01434 error, so that even if the synonym does not exist in apps schema,

Line 442: ad_apps_private.error_buf := null;

438: -- apps_mls_schema or apps_mrc_schema, the procedure call is successful in
439: -- dropping the synonym in other schemas
440: --
441: when synonym_does_not_exist then
442: ad_apps_private.error_buf := null;
443:
444: end;
445:
446: if davcsap_install_group_num <> -99 then

Line 448: if ad_apps_private.is_mls then

444: end;
445:
446: if davcsap_install_group_num <> -99 then
447:
448: if ad_apps_private.is_mls then
449: -- execute the alter view in the apps_mls schema
450: begin
451: ad_apps_private.do_apps_ddl(l_mls_apps_schema,
452: davcsap_statement, 'TRUE');

Line 451: ad_apps_private.do_apps_ddl(l_mls_apps_schema,

447:
448: if ad_apps_private.is_mls then
449: -- execute the alter view in the apps_mls schema
450: begin
451: ad_apps_private.do_apps_ddl(l_mls_apps_schema,
452: davcsap_statement, 'TRUE');
453: exception
454: when success_with_comp_error then
455: --

Line 460: ad_apps_private.error_buf := null;

456: -- Trap and ignore ORA-24344: success with compilation error
457: -- This only happens on ORACLE 8
458: --
459: -- reset main error buffer
460: ad_apps_private.error_buf := null;
461:
462: --
463: -- rkagrawa: Fixed bug 2823541. When dropping synonyms, trap and ignore
464: -- ORA-01434 error, so that even if the synonym does not exist in apps schema,

Line 469: ad_apps_private.error_buf := null;

465: -- apps_mls_schema or apps_mrc_schema, the procedure call is successful in
466: -- dropping the synonym in other schemas
467: --
468: when synonym_does_not_exist then
469: ad_apps_private.error_buf := null;
470:
471: end;
472: end if;
473:

Line 500: ad_apps_private.get_apps_schema_name(l_install_group_num,

496: print_local_sql := FALSE;
497: loop
498: if dbms_sql.fetch_rows(c) > 0 then
499: dbms_sql.column_value(c,1,l_install_group_num);
500: ad_apps_private.get_apps_schema_name(l_install_group_num,
501: davcsap_apps_schema, l_apps_schema, l_mls_apps_schema);
502: -- execute the alter view in the apps schema
503: begin
504: ad_apps_private.do_apps_ddl(l_apps_schema,

Line 504: ad_apps_private.do_apps_ddl(l_apps_schema,

500: ad_apps_private.get_apps_schema_name(l_install_group_num,
501: davcsap_apps_schema, l_apps_schema, l_mls_apps_schema);
502: -- execute the alter view in the apps schema
503: begin
504: ad_apps_private.do_apps_ddl(l_apps_schema,
505: davcsap_statement, 'TRUE');
506: exception
507: when success_with_comp_error then
508: --

Line 513: ad_apps_private.error_buf := null;

509: -- Trap and ignore ORA-24344: success with compilation error
510: -- This only happens on ORACLE 8
511: --
512: -- reset main error buffer
513: ad_apps_private.error_buf := null;
514:
515: --
516: -- rkagrawa: Fixed bug 2823541. When dropping synonyms, trap and ignore
517: -- ORA-01434 error, so that even if the synonym does not exist in apps schema,

Line 522: ad_apps_private.error_buf := null;

518: -- apps_mls_schema or apps_mrc_schema, the procedure call is successful in
519: -- dropping the synonym in other schemas
520: --
521: when synonym_does_not_exist then
522: ad_apps_private.error_buf := null;
523:
524: end;
525:
526: if ad_apps_private.is_mls then

Line 526: if ad_apps_private.is_mls then

522: ad_apps_private.error_buf := null;
523:
524: end;
525:
526: if ad_apps_private.is_mls then
527: -- execute the alter view in the apps_mls schema
528: begin
529: ad_apps_private.do_apps_ddl(l_mls_apps_schema,
530: davcsap_statement, 'TRUE');

Line 529: ad_apps_private.do_apps_ddl(l_mls_apps_schema,

525:
526: if ad_apps_private.is_mls then
527: -- execute the alter view in the apps_mls schema
528: begin
529: ad_apps_private.do_apps_ddl(l_mls_apps_schema,
530: davcsap_statement, 'TRUE');
531: exception
532: when success_with_comp_error then
533: --

Line 538: ad_apps_private.error_buf := null;

534: -- Trap and ignore ORA-24344: success with compilation error
535: -- This only happens on ORACLE 8
536: --
537: -- reset main error buffer
538: ad_apps_private.error_buf := null;
539:
540: --
541: -- rkagrawa: Fixed bug 2823541. When dropping synonyms, trap and ignore
542: -- ORA-01434 error, so that even if the synonym does not exist in apps schema,

Line 547: ad_apps_private.error_buf := null;

543: -- apps_mls_schema or apps_mrc_schema, the procedure call is successful in
544: -- dropping the synonym in other schemas
545: --
546: when synonym_does_not_exist then
547: ad_apps_private.error_buf := null;
548:
549: end;
550: end if;
551:

Line 592: if ad_apps_private.is_mls is null

588: l_mrc_apps_schema varchar2(30);
589: print_local_sql boolean;
590: begin
591:
592: if ad_apps_private.is_mls is null
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

Line 593: or ad_apps_private.is_mc is null then

589: print_local_sql boolean;
590: begin
591:
592: if ad_apps_private.is_mls is null
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

Line 594: ad_apps_private.initialize(dctcs_apps_schema);

590: begin
591:
592: if ad_apps_private.is_mls is null
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,

Line 598: ad_apps_private.drop_object(dctcs_oracle_schema, dctcs_object_name,

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,
602: 'TABLE');

Line 601: ad_apps_private.drop_object(dctcs_oracle_schema, dctcs_object_name,

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,
605: 'TRUE');

Line 604: ad_apps_private.do_apps_ddl(dctcs_oracle_schema, dctcs_statement,

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,
605: 'TRUE');
606: end if;
607: -- now do the correct action in the apps schemas
608: if dctcs_install_group_num <> 0 then

Line 613: ad_apps_private.get_apps_schema_name(dctcs_install_group_num,

609: -- if this is a non 0 install group then perform this only
610: -- for that apps account
611:
612: -- get the apps_schema_names for this install group
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

Line 620: ad_apps_private.create_gs(dctcs_oracle_schema, l_apps_schema,

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
623: ad_apps_private.drop_object(l_apps_schema,
624: dctcs_object_name,'SYNONYM');

Line 623: ad_apps_private.drop_object(l_apps_schema,

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
623: ad_apps_private.drop_object(l_apps_schema,
624: dctcs_object_name,'SYNONYM');
625: end if;
626:
627: if ad_apps_private.is_mls then

Line 627: if ad_apps_private.is_mls then

623: ad_apps_private.drop_object(l_apps_schema,
624: dctcs_object_name,'SYNONYM');
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:

Line 632: ad_apps_private.create_gs(dctcs_oracle_schema,

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');
635: else -- this is a drop table/sequence
636: ad_apps_private.drop_object(l_mls_apps_schema,

Line 636: ad_apps_private.drop_object(l_mls_apps_schema,

632: ad_apps_private.create_gs(dctcs_oracle_schema,
633: l_mls_apps_schema,
634: dctcs_object_name, TRUE, 'ALL');
635: else -- this is a drop table/sequence
636: ad_apps_private.drop_object(l_mls_apps_schema,
637: dctcs_object_name,'SYNONYM');
638: end if;
639: end if;
640:

Line 670: ad_apps_private.get_apps_schema_name(l_install_group_num,

666: if dbms_sql.fetch_rows(c) > 0 then
667: dbms_sql.column_value(c,1,l_install_group_num);
668:
669: -- get the apps_schema_names for this install group
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

Line 677: ad_apps_private.create_gs(dctcs_oracle_schema,

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');
680: else -- this is a drop table/sequence
681: ad_apps_private.drop_object(l_apps_schema,

Line 681: ad_apps_private.drop_object(l_apps_schema,

677: ad_apps_private.create_gs(dctcs_oracle_schema,
678: l_apps_schema,
679: dctcs_object_name, TRUE, 'ALL');
680: else -- this is a drop table/sequence
681: ad_apps_private.drop_object(l_apps_schema,
682: dctcs_object_name,'SYNONYM');
683: end if;
684:
685: if ad_apps_private.is_mls then

Line 685: if ad_apps_private.is_mls then

681: ad_apps_private.drop_object(l_apps_schema,
682: dctcs_object_name,'SYNONYM');
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:

Line 690: ad_apps_private.create_gs(dctcs_oracle_schema,

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
693: ad_apps_private.drop_object(l_mls_apps_schema,
694: dctcs_object_name,'SYNONYM');

Line 693: ad_apps_private.drop_object(l_mls_apps_schema,

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
693: ad_apps_private.drop_object(l_mls_apps_schema,
694: dctcs_object_name,'SYNONYM');
695: end if;
696: end if;
697:

Line 738: if ad_apps_private.is_mls is null

734: l_mrc_apps_schema varchar2(30);
735: print_local_sql boolean;
736: begin
737:
738: if ad_apps_private.is_mls is null
739: or ad_apps_private.is_mc is null then
740: ad_apps_private.initialize(dcv_apps_schema);
741: end if;
742: -- now do the correct action in the apps schemas

Line 739: or ad_apps_private.is_mc is null then

735: print_local_sql boolean;
736: begin
737:
738: if ad_apps_private.is_mls is null
739: or ad_apps_private.is_mc is null then
740: ad_apps_private.initialize(dcv_apps_schema);
741: end if;
742: -- now do the correct action in the apps schemas
743: if dcv_install_group_num <> 0 then

Line 740: ad_apps_private.initialize(dcv_apps_schema);

736: begin
737:
738: if ad_apps_private.is_mls is null
739: or ad_apps_private.is_mc is null then
740: ad_apps_private.initialize(dcv_apps_schema);
741: end if;
742: -- now do the correct action in the apps schemas
743: if dcv_install_group_num <> 0 then
744: -- if this is a non 0 install group then perform this only

Line 748: ad_apps_private.get_apps_schema_name(dcv_install_group_num,

744: -- if this is a non 0 install group then perform this only
745: -- for that apps account
746:
747: -- get the apps_schema_names for this install group
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

Line 753: ad_apps_private.drop_object(l_apps_schema,dcv_object_name,

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
757: ad_apps_private.do_apps_ddl(l_apps_schema, dcv_statement,

Line 757: ad_apps_private.do_apps_ddl(l_apps_schema, dcv_statement,

753: ad_apps_private.drop_object(l_apps_schema,dcv_object_name,
754: 'VIEW');
755: else -- create_view
756: begin
757: ad_apps_private.do_apps_ddl(l_apps_schema, dcv_statement,
758: 'TRUE');
759: exception
760: when success_with_comp_error then
761: --

Line 766: ad_apps_private.error_buf := null;

762: -- Trap and ignore ORA-24344: success with compilation error
763: -- This only happens on ORACLE 8
764: --
765: -- reset main error buffer
766: ad_apps_private.error_buf := null;
767: end;
768:
769: end if;
770:

Line 771: if ad_apps_private.is_mls then

767: end;
768:
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');

Line 774: ad_apps_private.drop_object(l_mls_apps_schema,

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
778: ad_apps_private.do_apps_ddl(l_mls_apps_schema,

Line 778: ad_apps_private.do_apps_ddl(l_mls_apps_schema,

774: ad_apps_private.drop_object(l_mls_apps_schema,
775: dcv_object_name,'VIEW');
776: else -- create_view
777: begin
778: ad_apps_private.do_apps_ddl(l_mls_apps_schema,
779: dcv_statement, 'TRUE');
780: exception
781: when success_with_comp_error then
782: --

Line 787: ad_apps_private.error_buf := null;

783: -- Trap and ignore ORA-24344: success with compilation error
784: -- This only happens on ORACLE 8
785: --
786: -- reset main error buffer
787: ad_apps_private.error_buf := null;
788: end;
789: end if;
790: end if;
791:

Line 819: ad_apps_private.get_apps_schema_name(l_install_group_num,

815: if dbms_sql.fetch_rows(c) > 0 then
816: dbms_sql.column_value(c,1,l_install_group_num);
817:
818: -- get the apps_schema_names for this install group
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

Line 824: ad_apps_private.drop_object(l_apps_schema,

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
828: ad_apps_private.do_apps_ddl(l_apps_schema,

Line 828: ad_apps_private.do_apps_ddl(l_apps_schema,

824: ad_apps_private.drop_object(l_apps_schema,
825: dcv_object_name,'VIEW');
826: else -- create_view
827: begin
828: ad_apps_private.do_apps_ddl(l_apps_schema,
829: dcv_statement, 'TRUE');
830: exception
831: when success_with_comp_error then
832: --

Line 837: ad_apps_private.error_buf := null;

833: -- Trap and ignore ORA-24344: success with compilation error
834: -- This only happens on ORACLE 8
835: --
836: -- reset main error buffer
837: ad_apps_private.error_buf := null;
838: end;
839: end if;
840:
841: if ad_apps_private.is_mls then

Line 841: if ad_apps_private.is_mls then

837: ad_apps_private.error_buf := null;
838: end;
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');

Line 844: ad_apps_private.drop_object(l_mls_apps_schema,

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
848: ad_apps_private.do_apps_ddl(l_mls_apps_schema,

Line 848: ad_apps_private.do_apps_ddl(l_mls_apps_schema,

844: ad_apps_private.drop_object(l_mls_apps_schema,
845: dcv_object_name,'VIEW');
846: else -- create_view
847: begin
848: ad_apps_private.do_apps_ddl(l_mls_apps_schema,
849: dcv_statement, 'TRUE');
850: exception
851: when success_with_comp_error then
852: --

Line 857: ad_apps_private.error_buf := null;

853: -- Trap and ignore ORA-24344: success with compilation error
854: -- This only happens on ORACLE 8
855: --
856: -- reset main error buffer
857: ad_apps_private.error_buf := null;
858: end;
859: end if;
860: end if;
861:

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 982: ad_apps_private.error_buf := null;

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';
986: upper_obj_name := upper(object_name);

Line 1012: ad_apps_private.get_apps_schema_name( 0, applsys_schema,

1008:
1009: -- from the APPLSYS schema get an APPS schema so that we can access
1010: -- the procedure FND_INSTALLATION that exists there
1011:
1012: ad_apps_private.get_apps_schema_name( 0, applsys_schema,
1013: apps_schema, apps_mls_schema);
1014:
1015: --
1016: -- compute effective user

Line 1082: if ad_apps_private.is_mls is null

1078:
1079:
1080: -- initialize global flags if required
1081:
1082: if ad_apps_private.is_mls is null
1083: or ad_apps_private.is_mc is null then
1084: ad_apps_private.initialize(apps_schema);
1085: end if;
1086:

Line 1083: or ad_apps_private.is_mc is null then

1079:
1080: -- initialize global flags if required
1081:
1082: if ad_apps_private.is_mls is null
1083: or ad_apps_private.is_mc is null then
1084: ad_apps_private.initialize(apps_schema);
1085: end if;
1086:
1087: -- Get the name of the first apps schema

Line 1084: ad_apps_private.initialize(apps_schema);

1080: -- initialize global flags if required
1081:
1082: if ad_apps_private.is_mls is null
1083: or ad_apps_private.is_mc is null then
1084: ad_apps_private.initialize(apps_schema);
1085: end if;
1086:
1087: -- Get the name of the first apps schema
1088:

Line 1241: ad_apps_private.exact_synonym_match(current_apps_schema, upper_obj_name,

1237: -- looking for a synonym because it gives us the required
1238: -- information easily
1239: --
1240:
1241: ad_apps_private.exact_synonym_match(current_apps_schema, upper_obj_name,
1242: current_apps_schema, upper_obj_name, obj_is_correct_synonym,
1243: obj_exists_in_schema, obj_type_in_schema);
1244:
1245: if obj_exists_in_schema

Line 1290: ad_apps_private.get_apps_schema_name(tmp_ign,

1286: -- barring data integrity issues, this means we've processed
1287: -- all of the APPS schemas (and corresponding MRC schemas)
1288:
1289: begin
1290: ad_apps_private.get_apps_schema_name(tmp_ign,
1291: first_apps_schema, tmp_apps_schema, tmp_mls_schema);
1292: exception
1293: when no_data_found then
1294: exit;

Line 1299: ad_apps_private.check_for_apps_ddl(tmp_apps_schema);

1295: end;
1296:
1297: -- Check for APPS*DDL
1298:
1299: ad_apps_private.check_for_apps_ddl(tmp_apps_schema);
1300:
1301: -- create grants
1302:
1303: ad_invoker.grant_a_package(first_apps_schema, upper_obj_name,

Line 1362: ad_apps_private.exact_synonym_match(first_apps_schema, upper_obj_name,

1358: -- the package spec doesn't exist
1359:
1360: -- Look for package spec in first APPS schema
1361:
1362: ad_apps_private.exact_synonym_match(first_apps_schema, upper_obj_name,
1363: first_apps_schema, upper_obj_name, obj_is_correct_synonym,
1364: obj_exists_in_schema, obj_type_in_schema);
1365:
1366: if obj_exists_in_schema then

Line 1405: ad_apps_private.get_apps_schema_name(tmp_ign,

1401: -- barring data integrity issues, this means we've processed
1402: -- all of the APPS schemas (and corresponding MRC schemas)
1403:
1404: begin
1405: ad_apps_private.get_apps_schema_name(tmp_ign,
1406: first_apps_schema, tmp_apps_schema, tmp_mls_schema);
1407: exception
1408: when no_data_found then
1409: exit;

Line 1414: ad_apps_private.check_for_apps_ddl(tmp_apps_schema);

1410: end;
1411:
1412: -- Check for APPS*DDL
1413:
1414: ad_apps_private.check_for_apps_ddl(tmp_apps_schema);
1415:
1416: -- create grants
1417:
1418: ad_invoker.grant_a_package(first_apps_schema, upper_obj_name,

Line 1521: ad_apps_private.check_for_apps_ddl(first_apps_schema);

1517: -- Create grants to other APPS schemas
1518:
1519: -- Check for APPS*DDL
1520:
1521: ad_apps_private.check_for_apps_ddl(first_apps_schema);
1522:
1523: -- Create package in first APPS schema
1524:
1525: begin

Line 1541: ad_apps_private.error_buf := null;

1537: -- dbms_output.put_line('success w comp error');
1538:
1539: -- reset main error buffer
1540:
1541: ad_apps_private.error_buf := null;
1542:
1543: -- record compilation error
1544:
1545: comp_error := 'TRUE';

Line 1565: ad_apps_private.get_apps_schema_name(tmp_ign,

1561: -- barring data integrity issues, this means we've processed
1562: -- all of the APPS schemas (and corresponding MRC schemas)
1563:
1564: begin
1565: ad_apps_private.get_apps_schema_name(tmp_ign,
1566: first_apps_schema, tmp_apps_schema, tmp_mls_schema);
1567: exception
1568: when no_data_found then
1569: exit;

Line 1574: ad_apps_private.check_for_apps_ddl(tmp_apps_schema);

1570: end;
1571:
1572: -- Check for APPS*DDL
1573:
1574: ad_apps_private.check_for_apps_ddl(tmp_apps_schema);
1575:
1576: -- create grants
1577:
1578: ad_invoker.grant_a_package(first_apps_schema, upper_obj_name,

Line 1599: ad_apps_private.check_for_apps_ddl(current_apps_schema);

1595:
1596: -- Check for APPS*DDL
1597:
1598:
1599: ad_apps_private.check_for_apps_ddl(current_apps_schema);
1600:
1601: -- Drop existing synonym, if any
1602:
1603: ad_apps_private.exact_synonym_match(current_apps_schema,

Line 1603: ad_apps_private.exact_synonym_match(current_apps_schema,

1599: ad_apps_private.check_for_apps_ddl(current_apps_schema);
1600:
1601: -- Drop existing synonym, if any
1602:
1603: ad_apps_private.exact_synonym_match(current_apps_schema,
1604: upper_obj_name, current_apps_schema, upper_obj_name,
1605: obj_is_correct_synonym, obj_exists_in_schema, obj_type_in_schema);
1606:
1607: if obj_exists_in_schema

Line 1610: ad_apps_private.drop_object(current_apps_schema, upper_obj_name,

1606:
1607: if obj_exists_in_schema
1608: and obj_type_in_schema = 'SYNONYM' then
1609:
1610: ad_apps_private.drop_object(current_apps_schema, upper_obj_name,
1611: 'SYNONYM');
1612:
1613: end if;
1614:

Line 1624: ad_apps_private.error_buf := null;

1620: exception
1621: when success_with_comp_error then
1622: -- reset main error buffer
1623:
1624: ad_apps_private.error_buf := null;
1625:
1626: -- record compilation error
1627:
1628: comp_error := 'TRUE';

Line 1652: ad_apps_private.check_for_apps_ddl(first_apps_schema);

1648: -- Check for APPS*DDL
1649:
1650:
1651:
1652: ad_apps_private.check_for_apps_ddl(first_apps_schema);
1653:
1654:
1655:
1656: -- Create package in first APPS schema

Line 1666: ad_apps_private.error_buf := null;

1662: exception
1663: when success_with_comp_error then
1664: -- reset main error buffer
1665:
1666: ad_apps_private.error_buf := null;
1667:
1668: -- record compilation error
1669:
1670: comp_error := 'TRUE';

Line 1690: ad_apps_private.get_apps_schema_name(tmp_ign,

1686: -- all of the APPS schemas (and corresponding MRC schemas)
1687:
1688: begin
1689:
1690: ad_apps_private.get_apps_schema_name(tmp_ign,
1691: first_apps_schema, tmp_apps_schema, tmp_mls_schema);
1692:
1693: exception
1694: when no_data_found then

Line 1700: ad_apps_private.check_for_apps_ddl(tmp_apps_schema);

1696: end;
1697:
1698: -- Check for APPS*DDL
1699:
1700: ad_apps_private.check_for_apps_ddl(tmp_apps_schema);
1701:
1702: -- compare source text in this APPS schema with text in
1703: -- first APPS schema, and (re)create if not identical
1704:

Line 1737: ad_apps_private.check_for_apps_ddl(first_apps_schema);

1733: if upper(current_apps_schema) = 'CTXSYS' then
1734: first_apps_schema:=current_apps_schema;
1735: end if;
1736:
1737: ad_apps_private.check_for_apps_ddl(first_apps_schema);
1738:
1739: -- Create package body in first APPS schema
1740:
1741:

Line 1749: ad_apps_private.error_buf := null;

1745: exception
1746: when success_with_comp_error then
1747: -- reset main error buffer
1748:
1749: ad_apps_private.error_buf := null;
1750:
1751: -- record compilation error
1752:
1753: comp_error := 'TRUE';

Line 1768: ad_apps_private.check_for_apps_ddl(current_apps_schema);

1764: -- no grants required
1765:
1766: -- Check for APPS*DDL
1767:
1768: ad_apps_private.check_for_apps_ddl(current_apps_schema);
1769:
1770: -- Create package body in current APPS schema
1771:
1772: begin

Line 1779: ad_apps_private.error_buf := null;

1775: exception
1776: when success_with_comp_error then
1777: -- reset main error buffer
1778:
1779: ad_apps_private.error_buf := null;
1780:
1781: -- record compilation error
1782:
1783: comp_error := 'TRUE';

Line 1810: ad_apps_private.get_apps_schema_name(tmp_ign,

1806: -- barring data integrity issues, this means we've processed
1807: -- all of the APPS schemas (and corresponding MRC schemas)
1808:
1809: begin
1810: ad_apps_private.get_apps_schema_name(tmp_ign,
1811: first_apps_schema, tmp_apps_schema, tmp_mls_schema);
1812: exception
1813: when no_data_found then
1814: exit;

Line 1819: ad_apps_private.check_for_apps_ddl(tmp_apps_schema);

1815: end;
1816:
1817: -- Check for APPS*DDL
1818:
1819: ad_apps_private.check_for_apps_ddl(tmp_apps_schema);
1820:
1821: -- Create package body in this APPS schema
1822:
1823: begin

Line 1830: ad_apps_private.error_buf := null;

1826: exception
1827: when success_with_comp_error then
1828: -- reset main error buffer
1829:
1830: ad_apps_private.error_buf := null;
1831:
1832: -- record compilation error
1833:
1834: comp_error := 'TRUE';

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 2024: ad_apps_private.error_buf := null;

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
2028: -- the procedure FND_INSTALLATION that exists there

Line 2029: ad_apps_private.get_apps_schema_name( 0, applsys_schema,

2025: gbl_statement := null;
2026:
2027: -- from the APPLSYS schema get an APPS schema so that we can access
2028: -- the procedure FND_INSTALLATION that exists there
2029: ad_apps_private.get_apps_schema_name( 0, applsys_schema,
2030: apps_schema, apps_mls_schema);
2031:
2032: if upper(application_short_name) not in ('INTERMEDIA','APPS') then
2033:

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 2107: if ad_apps_private.is_mls is null

2103: rows_processed integer;
2104: c integer;
2105: begin
2106:
2107: if ad_apps_private.is_mls is null
2108: or ad_apps_private.is_mc is null then
2109: ad_apps_private.initialize(p_apps_schema);
2110: end if;
2111:

Line 2108: or ad_apps_private.is_mc is null then

2104: c integer;
2105: begin
2106:
2107: if ad_apps_private.is_mls is null
2108: or ad_apps_private.is_mc is null then
2109: ad_apps_private.initialize(p_apps_schema);
2110: end if;
2111:
2112: -- get the install_group_num from the oracle_schema that the object

Line 2109: ad_apps_private.initialize(p_apps_schema);

2105: begin
2106:
2107: if ad_apps_private.is_mls is null
2108: or ad_apps_private.is_mc is null then
2109: ad_apps_private.initialize(p_apps_schema);
2110: end if;
2111:
2112: -- get the install_group_num from the oracle_schema that the object
2113: -- is to be created in.

Line 2145: ad_apps_private.check_for_apps_ddl(p_apps_schema);

2141: end;
2142:
2143: -- Check for APPS*DDL packages
2144:
2145: ad_apps_private.check_for_apps_ddl(p_apps_schema);
2146: ad_apps_private.check_for_apps_ddl(oracle_schema);
2147:
2148: if ad_apps_private.is_mls then
2149: -- Get name of mls schema

Line 2146: ad_apps_private.check_for_apps_ddl(oracle_schema);

2142:
2143: -- Check for APPS*DDL packages
2144:
2145: ad_apps_private.check_for_apps_ddl(p_apps_schema);
2146: ad_apps_private.check_for_apps_ddl(oracle_schema);
2147:
2148: if ad_apps_private.is_mls then
2149: -- Get name of mls schema
2150: ad_apps_private.get_apps_schema_name(install_group_num, p_applsys_schema,

Line 2148: if ad_apps_private.is_mls then

2144:
2145: ad_apps_private.check_for_apps_ddl(p_apps_schema);
2146: ad_apps_private.check_for_apps_ddl(oracle_schema);
2147:
2148: if ad_apps_private.is_mls then
2149: -- Get name of mls schema
2150: ad_apps_private.get_apps_schema_name(install_group_num, p_applsys_schema,
2151: l_apps_schema, l_mls_apps_schema);
2152: -- check for APPS*DDL in mls schema

Line 2150: ad_apps_private.get_apps_schema_name(install_group_num, p_applsys_schema,

2146: ad_apps_private.check_for_apps_ddl(oracle_schema);
2147:
2148: if ad_apps_private.is_mls then
2149: -- Get name of mls schema
2150: ad_apps_private.get_apps_schema_name(install_group_num, p_applsys_schema,
2151: l_apps_schema, l_mls_apps_schema);
2152: -- check for APPS*DDL in mls schema
2153: ad_apps_private.check_for_apps_ddl(l_mls_apps_schema);
2154: end if;

Line 2153: ad_apps_private.check_for_apps_ddl(l_mls_apps_schema);

2149: -- Get name of mls schema
2150: ad_apps_private.get_apps_schema_name(install_group_num, p_applsys_schema,
2151: l_apps_schema, l_mls_apps_schema);
2152: -- check for APPS*DDL in mls schema
2153: ad_apps_private.check_for_apps_ddl(l_mls_apps_schema);
2154: end if;
2155:
2156: --
2157: -- Based on type of action determine what to do

Line 2190: if ad_apps_private.is_mls is null

2186: l_mrc_apps_schema varchar2(30);
2187: print_local_sql boolean;
2188: begin
2189:
2190: if ad_apps_private.is_mls is null
2191: or ad_apps_private.is_mc is null then
2192: ad_apps_private.initialize(dcv_apps_schema);
2193: end if;
2194: -- now do the correct action in the apps schemas

Line 2191: or ad_apps_private.is_mc is null then

2187: print_local_sql boolean;
2188: begin
2189:
2190: if ad_apps_private.is_mls is null
2191: or ad_apps_private.is_mc is null then
2192: ad_apps_private.initialize(dcv_apps_schema);
2193: end if;
2194: -- now do the correct action in the apps schemas
2195: if dcv_install_group_num <> 0 then

Line 2192: ad_apps_private.initialize(dcv_apps_schema);

2188: begin
2189:
2190: if ad_apps_private.is_mls is null
2191: or ad_apps_private.is_mc is null then
2192: ad_apps_private.initialize(dcv_apps_schema);
2193: end if;
2194: -- now do the correct action in the apps schemas
2195: if dcv_install_group_num <> 0 then
2196: -- if this is a non 0 install group then perform this only

Line 2200: ad_apps_private.get_apps_schema_name(dcv_install_group_num,

2196: -- if this is a non 0 install group then perform this only
2197: -- for that apps account
2198:
2199: -- get the apps_schema_names for this install group
2200: ad_apps_private.get_apps_schema_name(dcv_install_group_num,
2201: dcv_apps_schema, l_apps_schema, l_mls_apps_schema);
2202:
2203: -- create view in apps schema
2204: array_assign_and_execute(l_apps_schema, dcv_lb, dcv_ub);

Line 2206: if ad_apps_private.is_mls then

2202:
2203: -- create view in apps schema
2204: array_assign_and_execute(l_apps_schema, dcv_lb, dcv_ub);
2205:
2206: if ad_apps_private.is_mls then
2207: -- create view in apps_mls schema
2208: array_assign_and_execute(l_mls_apps_schema, dcv_lb, dcv_ub);
2209: end if;
2210:

Line 2238: ad_apps_private.get_apps_schema_name(l_install_group_num,

2234: if dbms_sql.fetch_rows(c) > 0 then
2235: dbms_sql.column_value(c,1,l_install_group_num);
2236:
2237: -- get the apps_schema_names for this install group
2238: ad_apps_private.get_apps_schema_name(l_install_group_num,
2239: dcv_apps_schema, l_apps_schema, l_mls_apps_schema);
2240:
2241: -- create view in apps schema
2242: array_assign_and_execute(l_apps_schema, dcv_lb, dcv_ub);

Line 2244: if ad_apps_private.is_mls then

2240:
2241: -- create view in apps schema
2242: array_assign_and_execute(l_apps_schema, dcv_lb, dcv_ub);
2243:
2244: if ad_apps_private.is_mls then
2245: -- create view in apps_mls schema
2246: array_assign_and_execute(l_mls_apps_schema,
2247: dcv_lb, dcv_ub);
2248: end if;

Line 2310: ad_apps_private.do_array_assignment(p_schema_name,

2306: --
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 '||

Line 2324: ad_apps_private.do_apps_array_ddl(p_schema_name, p_lb, p_ub, add_newline);

2320: --
2321: -- Execute array DDL statement
2322: --
2323:
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('||

Line 2389: ad_apps_private.error_buf := null;

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
2393:

Line 2398: ad_apps_private.check_for_apps_ddl(uc_schema);

2394: uc_schema := substr(upper(schema_name),1,30);
2395:
2396: -- Check for APPS*DDL in the schema
2397:
2398: ad_apps_private.check_for_apps_ddl(uc_schema);
2399:
2400: -- Execute create trigger statement using APPS_DDL
2401:
2402: begin

Line 2403: ad_apps_private.do_apps_ddl(uc_schema, ddl_text, 'TRUE');

2399:
2400: -- Execute create trigger statement using APPS_DDL
2401:
2402: begin
2403: ad_apps_private.do_apps_ddl(uc_schema, ddl_text, 'TRUE');
2404: exception
2405: when success_with_comp_error then
2406: ad_apps_private.error_buf := null;
2407: end;

Line 2406: ad_apps_private.error_buf := null;

2402: begin
2403: ad_apps_private.do_apps_ddl(uc_schema, ddl_text, 'TRUE');
2404: exception
2405: when success_with_comp_error then
2406: ad_apps_private.error_buf := null;
2407: end;
2408:
2409: exception
2410: when others then

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;