49: RAISE CANNOT_GET_APPLSYS_SCHEMA;
50: END IF;
51:
52: failpoint := 1;
53: ad_ddl.do_ddl( fnd_schema,
54: 'SQLGL',
55: AD_DDL.CREATE_TABLE,
56: cre_tab,
57: table_name );
51:
52: failpoint := 1;
53: ad_ddl.do_ddl( fnd_schema,
54: 'SQLGL',
55: AD_DDL.CREATE_TABLE,
56: cre_tab,
57: table_name );
58:
59: failpoint := 3;
72: cre_tab := cre_tab ||
73: ' ' || n1_physical_attributes;
74: END IF;
75:
76: ad_ddl.do_ddl( fnd_schema,
77: 'SQLGL',
78: AD_DDL.CREATE_INDEX,
79: cre_tab,
80: ind_name );
74: END IF;
75:
76: ad_ddl.do_ddl( fnd_schema,
77: 'SQLGL',
78: AD_DDL.CREATE_INDEX,
79: cre_tab,
80: ind_name );
81:
82: END IF;
98: cre_tab := cre_tab ||
99: ' ' || n2_physical_attributes;
100: END IF;
101:
102: ad_ddl.do_ddl( fnd_schema,
103: 'SQLGL',
104: AD_DDL.CREATE_INDEX,
105: cre_tab,
106: ind_name );
100: END IF;
101:
102: ad_ddl.do_ddl( fnd_schema,
103: 'SQLGL',
104: AD_DDL.CREATE_INDEX,
105: cre_tab,
106: ind_name );
107:
108: END IF;
128: failpoint := 1;
129: cre_tab :=
130: 'DROP TABLE ' || table_name;
131:
132: ad_ddl.do_ddl( fnd_schema,
133: 'SQLGL',
134: AD_DDL.DROP_TABLE,
135: cre_tab,
136: table_name );
130: 'DROP TABLE ' || table_name;
131:
132: ad_ddl.do_ddl( fnd_schema,
133: 'SQLGL',
134: AD_DDL.DROP_TABLE,
135: cre_tab,
136: table_name );
137:
138: END drop_table;
199: END get_last_sql;
200:
201: FUNCTION get_error_msg RETURN VARCHAR2 IS
202: BEGIN
203: RETURN(ad_ddl.error_buf);
204: END get_error_msg;
205:
206: END GL_JOURNAL_IMPORT_PKG;