APPS.HRI_UTL_DDL dependencies on AD_DDL

Line 56: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,

52: IF (index_rec.ddl_type = 'INDEX') THEN
53: --
54: -- use AD API to recreate index
55: --
56: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
57: application_short_name => p_application_short_name,
58: statement_type => ad_ddl.create_index,
59: statement => index_rec.ddl_stmt,
60: object_name => index_rec.ddl_object);

Line 58: statement_type => ad_ddl.create_index,

54: -- use AD API to recreate index
55: --
56: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
57: application_short_name => p_application_short_name,
58: statement_type => ad_ddl.create_index,
59: statement => index_rec.ddl_stmt,
60: object_name => index_rec.ddl_object);
61: --
62: ELSIF (index_rec.ddl_type = 'INDEX LOGGING') THEN

Line 245: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,

241: -- use AD API to drop the index
242: --
243: BEGIN
244: --
245: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
246: application_short_name => p_application_short_name,
247: statement_type => ad_ddl.drop_index,
248: statement => l_drop_index_stmt,
249: object_name => index_rec.index_name);

Line 247: statement_type => ad_ddl.drop_index,

243: BEGIN
244: --
245: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
246: application_short_name => p_application_short_name,
247: statement_type => ad_ddl.drop_index,
248: statement => l_drop_index_stmt,
249: object_name => index_rec.index_name);
250: --
251: BEGIN

Line 319: -- ad_ddl.do_ddl raises an exception when it tries to drop a primary

315: END IF;
316:
317: EXCEPTION
318: --
319: -- ad_ddl.do_ddl raises an exception when it tries to drop a primary
320: -- key index on a table. ignore the error and continue
321: --
322: WHEN PRIMARY_KEY_INDEX THEN
323: --