DBA Data[Home] [Help]

APPS.AD_ZD_SEED dependencies on KU$_DDL

Line 215: X_OBJECT_NAME in varchar2) return SYS.KU$_DDLS

211: X_TABLE_OWNER in varchar2,
212: X_TABLE_NAME in varchar2,
213: X_OBJECT_TYPE in varchar2,
214: X_OBJECT_OWNER in varchar2,
215: X_OBJECT_NAME in varchar2) return SYS.KU$_DDLS
216: is
217: C_MODULE varchar2(80) := c_package||'fetch_multiple_ddls';
218: L_OPEN_HANDLE number;
219: L_TRANSFORM_HANDLE number;

Line 220: L_DDL_STMTS sys.ku$_ddls;

216: is
217: C_MODULE varchar2(80) := c_package||'fetch_multiple_ddls';
218: L_OPEN_HANDLE number;
219: L_TRANSFORM_HANDLE number;
220: L_DDL_STMTS sys.ku$_ddls;
221: begin
222: log(c_module, 'STATEMENT',
223: 'Getting DDLs for '||x_table_owner||'.'||x_table_name||', '||
224: x_object_type||', '||x_object_owner||'.'||x_object_name);

Line 305: L_DDL_STMTS sys.ku$_ddls;

301: L_IND_OWNER varchar2(30);
302: L_IND_NAME varchar2(30);
303: L_CONSTRAINT_NAME varchar2(30);
304: L_CONSTRAINT_TYPE varchar2(30);
305: L_DDL_STMTS sys.ku$_ddls;
306: L_DDL_STMT varchar2(32767);
307:
308: cursor C_IND_CUR (x_tab_owner varchar2, x_tab_name varchar2) is
309: select i.owner, i.index_name

Line 922: L_DDL_STMTS sys.ku$_ddls;

918: L_STMT varchar2(32767);
919: L_FCET_NAME varchar2(30);
920: L_TRIG_NAME varchar2(30);
921: L_EDITIONS_ENABLED varchar2(1);
922: L_DDL_STMTS sys.ku$_ddls;
923:
924: NO_POLICY_FOUND EXCEPTION;
925: PRAGMA EXCEPTION_INIT(NO_POLICY_FOUND, -28102);
926: NO_OBJECT_FOUND EXCEPTION;