PACKAGE: AMW.APPS_DDL

Source

1 package APPS_DDL AUTHID DEFINER as
2 /* $Header: adaddls.pls 120.0 2005/11/29 05:04:55 vpalakur noship $ */
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 varchar2);
26 end APPS_DDL;