DBA Data[Home] [Help]

APPS.OKI_DBI_SCM_RSG_API_PVT dependencies on DBMS_METADATA

Line 163: SET create_stmt = DBMS_METADATA.Get_Ddl('INDEX', s.index_name)

159: where table_name = p_table_name AND OWNER = p_owner ) s
160: ON (b.index_name = s.index_name AND b.table_name = s.table_name)
161: WHEN MATCHED THEN
162: UPDATE
163: SET create_stmt = DBMS_METADATA.Get_Ddl('INDEX', s.index_name)
164: WHEN NOT MATCHED THEN
165: INSERT
166: (table_name,
167: index_name,

Line 177: DBMS_METADATA.Get_Ddl('INDEX', s.index_name),

173: last_update_login)
174: VALUES
175: (p_table_name,
176: s.index_name,
177: DBMS_METADATA.Get_Ddl('INDEX', s.index_name),
178: SYSDATE,
179: -1,
180: SYSDATE,
181: -1,