PACKAGE: APPS.APPS_ARRAY_DDL

Source

1 package APPS_ARRAY_DDL AUTHID DEFINER as
2 /* $Header: adaaddls.pls 115.2 1999/11/09 16:51:03 pkm ship     $ */
3    --
4    -- Package
5    --   APPS_ARRAY_DDL
6    -- Purpose
7    --   Dynamic DDL support for large objects needing >32K SQL statements
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 glprogtext dbms_sql.varchar2s;
26 procedure apps_array_ddl(lb           in integer,
27                          ub           in integer,
28                          newline_flag in varchar2 default 'FALSE');
29 end APPS_ARRAY_DDL;