APPS.HRI_UTL_DDL dependencies on HRI_UTL_DYNMC_DDL_INFRMTN

Line 30: FROM hri_utl_dynmc_ddl_infrmtn

26: CURSOR index_csr IS
27: SELECT ddl_object
28: ,ddl_stmt
29: ,ddl_type
30: FROM hri_utl_dynmc_ddl_infrmtn
31: WHERE table_name = p_table_name
32: AND table_owner = p_table_owner
33: AND ddl_type IN ('INDEX', 'INDEX LOGGING')
34: ORDER BY DECODE(ddl_type, 'INDEX', 1, 2);

Line 72: DELETE FROM hri_utl_dynmc_ddl_infrmtn

68: END IF;
69: --
70: -- Remove temporary ddl
71: --
72: DELETE FROM hri_utl_dynmc_ddl_infrmtn
73: WHERE table_name = p_table_name
74: AND table_owner = p_table_owner
75: AND ddl_object = index_rec.ddl_object
76: AND ddl_type = index_rec.ddl_type;

Line 255: INSERT INTO hri_utl_dynmc_ddl_infrmtn

251: BEGIN
252: --
253: -- Store the index creation statement in the temporary ddl table
254: --
255: INSERT INTO hri_utl_dynmc_ddl_infrmtn
256: (table_name
257: ,table_owner
258: ,ddl_object
259: ,ddl_type

Line 273: UPDATE hri_utl_dynmc_ddl_infrmtn

269: --
270: -- Unique index on table violated, so an entry already exist in
271: -- the table for the index. Update the existing record.
272: --
273: UPDATE hri_utl_dynmc_ddl_infrmtn
274: SET ddl_stmt = l_create_index_stmt
275: WHERE table_name = p_table_name
276: AND table_owner = p_table_owner
277: AND ddl_object = index_rec.index_name

Line 288: INSERT INTO hri_utl_dynmc_ddl_infrmtn

284: BEGIN
285: --
286: -- Store the alter index statement
287: --
288: INSERT INTO hri_utl_dynmc_ddl_infrmtn
289: (table_name
290: ,table_owner
291: ,ddl_object
292: ,ddl_type

Line 306: UPDATE hri_utl_dynmc_ddl_infrmtn

302: --
303: -- Unique index on table violated, so an entry already exist in
304: -- the table for the index. Update the existing record.
305: --
306: UPDATE hri_utl_dynmc_ddl_infrmtn
307: SET ddl_stmt = l_alter_index_stmt
308: WHERE table_name = p_table_name
309: AND table_owner = p_table_owner
310: AND ddl_object = index_rec.index_name