1 package APPS_DDL AUTHID DEFINER as
2 /* $Header: adaddls.pls 120.1 2011/10/13 19:02:59 mkumandu ship $ */
3 --
4 -- Package
5 -- APPS_DDL
6 -- Purpose
7 -- Dynamic DDL support
8 -- Notes
9 -- 1. This package is created in each Oracle Applications account
10 -- 2. Each account requires the following explicit
11 -- privileges to run (i.e. these privileges cannot be obtained
12 -- from a role, like 'connect'):
13 -- grant create session to <schema>
14 -- grant alter session to <schema>
15 -- grant create database link to <schema>
16 -- grant create synonym to <schema>
17 -- grant create view to <schema>
18 -- grant create cluster to <schema>
19 -- grant create procedure to <schema>
20 -- grant create sequence to <schema>
21 -- grant create table to <schema>
22 -- grant create trigger to <schema>
23 -- Currently AutoInstall grants the neccessary privs to each schema
24 --
25 procedure apps_ddl(ddl_text in clob);
26 procedure apps_ddl(ddl_text in varchar2);
27 end APPS_DDL;