APPS.AD_ZD_TABLE dependencies on KU$_DDLS

Line 253: X_OBJECT_TYPE in varchar2) return SYS.KU$_DDLS

249: */
250: function FETCH_MULTIPLE_DDLS (
251: X_OBJECT_OWNER in varchar2,
252: X_OBJECT_NAME in varchar2,
253: X_OBJECT_TYPE in varchar2) return SYS.KU$_DDLS
254: is
255: C_MODULE varchar2(80) := c_package||'fetch_multiple_ddls';
256: L_OPEN_HANDLE number;
257: L_TRANSFORM_HANDLE number;

Line 258: L_DDL_STMTS sys.ku$_ddls;

254: is
255: C_MODULE varchar2(80) := c_package||'fetch_multiple_ddls';
256: L_OPEN_HANDLE number;
257: L_TRANSFORM_HANDLE number;
258: L_DDL_STMTS sys.ku$_ddls;
259: begin
260: log(c_module, 'STATEMENT',
261: 'Getting DDLs for '||x_object_owner||'.'||x_object_name||', '|| x_object_type);
262:

Line 392: L_DDL_STMTS sys.ku$_ddls;

388: L_DDL_LOB clob;
389: L_INDEX pls_integer :=0;
390: L_SYN_OWNER varchar2(30);
391: L_SYNONYM_NAME varchar2(30);
392: L_DDL_STMTS sys.ku$_ddls;
393:
394: -- Match#1 : exact owner.table
395: L_REG_EXP_PATTERN_1 varchar2(127):= '[[:space:]]ON[[:space:]]*("?' || X_TABLE_OWNER ||
396: '"?)[.]?"?'|| X_TABLE_NAME ||'"?[[:space:]]';