DBA Data[Home] [Help]

SYSTEM.AD_PARALLEL_COMPILE_PKG dependencies on AD_APPS_PRIVATE

Line 564: ad_apps_private.error_buf := null;

560: begin
561: l_target_schema := upper(target_schema);
562:
563: -- clear error buffer
564: ad_apps_private.error_buf := null;
565:
566: -- Check for APPS*DDL packages in target schema
567: ad_apps_private.check_for_apps_ddl(l_target_schema);
568:

Line 567: ad_apps_private.check_for_apps_ddl(l_target_schema);

563: -- clear error buffer
564: ad_apps_private.error_buf := null;
565:
566: -- Check for APPS*DDL packages in target schema
567: ad_apps_private.check_for_apps_ddl(l_target_schema);
568:
569: for csrec in cs1 (worker_number, l_target_schema) loop
570: declare
571: statement varchar2(500);

Line 598: ad_apps_private.do_apps_ddl(l_target_schema, statement);

594: end if;
595:
596: if (l_chkobj_status) then
597: if (is_object_invalid(l_target_schema, csrec.name, csrec.type)) then
598: ad_apps_private.do_apps_ddl(l_target_schema, statement);
599: end if;
600: else
601: ad_apps_private.do_apps_ddl(l_target_schema, statement);
602: end if;

Line 601: ad_apps_private.do_apps_ddl(l_target_schema, statement);

597: if (is_object_invalid(l_target_schema, csrec.name, csrec.type)) then
598: ad_apps_private.do_apps_ddl(l_target_schema, statement);
599: end if;
600: else
601: ad_apps_private.do_apps_ddl(l_target_schema, statement);
602: end if;
603: exception
604: when success_with_comp_error then
605: --

Line 609: ad_apps_private.error_buf := null;

605: --
606: -- Trap and ignore ORA-24344: success with compilation error
607: -- This only happens on ORACLE 8
608: --
609: ad_apps_private.error_buf := null;
610: when others then
611: --
612: -- Insert SQL errors we encounter while compiling invalid objects
613: -- into AD_PARALLEL_COMPILE_ERRORS table. Most of these are RDBMS

Line 665: if ad_apps_private.error_buf is not null then

661: timestamp,
662: '2 ORACLE_ERROR',
663: sql_error);
664:
665: if ad_apps_private.error_buf is not null then
666: insert into
667: ad_parallel_compile_errors (owner,
668: worker_number,
669: timestamp,

Line 676: substr(ad_apps_private.error_buf,

672: values (l_target_schema,
673: tmp_worker,
674: timestamp,
675: '3 ERROR_BUF',
676: substr(ad_apps_private.error_buf,
677: 1,1996));
678: end if;
679:
680: -- clear error buf

Line 681: ad_apps_private.error_buf := null;

677: 1,1996));
678: end if;
679:
680: -- clear error buf
681: ad_apps_private.error_buf := null;
682: end;
683: end loop;
684: end comp;
685: