APPS.QA_DBLINK_PKG dependencies on AD_DDL

Line 44: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, l_stmt,

40: 'as select event_time, event_data, event_tag_id device_source, ' ||
41: 'device_name, 192 quality_code from edg_event_vw@';
42: l_stmt := l_stmt || p_dblink_name;
43: --EXECUTE IMMEDIATE l_stmt || p_dblink_name;
44: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, l_stmt,
45: 'qa_device_data_values_v');
46:
47: RETURN successful_completion;
48: EXCEPTION

Line 56: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, l_stmt,

52: 'null event_data, ' ||
53: 'null device_source, ' ||
54: 'null device_name from dual';
55: --EXECUTE IMMEDIATE l_stmt;
56: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, l_stmt,
57: 'qa_device_data_values_v');
58:
59:
60: RETURN err_view_creation || substr(sqlerrm, 1, 100);

Line 133: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, l_stmt,

129: ' device_name, ' ||
130: ' quality_code ' ||
131: 'FROM qa_device_data_values';
132: --EXECUTE IMMEDIATE l_stmt;
133: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, l_stmt,
134: 'qa_device_data_values_v');
135: EXCEPTION
136: WHEN OTHERS THEN
137: l_stmt := 'create or replace view qa_device_data_values_v as ' ||

Line 143: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, l_stmt,

139: 'null event_data, ' ||
140: 'null device_source, ' ||
141: 'null device_name from dual';
142: --EXECUTE IMMEDIATE l_stmt;
143: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, l_stmt,
144: 'qa_device_data_values_v');
145:
146: END create_opc_view;
147: