eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_SPATIAL_TTSP_PUB dependencies on CSF_SPATIAL_TTSP_PVT

Line 64: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );

60: retcode := l_rc_succ;
61:
62: errbuf := l_msg_succ;
63:
64: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );
65:
66: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'Start of Procedure TTSP_PLUGIN for ' || p_data_set_name );
67:
68: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );

Line 66: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'Start of Procedure TTSP_PLUGIN for ' || p_data_set_name );

62: errbuf := l_msg_succ;
63:
64: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );
65:
66: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'Start of Procedure TTSP_PLUGIN for ' || p_data_set_name );
67:
68: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );
69:
70: -- Create a DB directory for the directory path provided.

Line 68: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );

64: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );
65:
66: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'Start of Procedure TTSP_PLUGIN for ' || p_data_set_name );
67:
68: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );
69:
70: -- Create a DB directory for the directory path provided.
71: CSF_SPATIAL_TTSP_PVT.CREATE_DIRECTORY(
72: p_directory_path => p_directory_path,

Line 71: CSF_SPATIAL_TTSP_PVT.CREATE_DIRECTORY(

67:
68: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );
69:
70: -- Create a DB directory for the directory path provided.
71: CSF_SPATIAL_TTSP_PVT.CREATE_DIRECTORY(
72: p_directory_path => p_directory_path,
73: errbuf => errbuf,
74: retcode => retcode );
75:

Line 77: CSF_SPATIAL_TTSP_PVT.DATAPUMP_IMPORT(

73: errbuf => errbuf,
74: retcode => retcode );
75:
76: -- Import the TTSP using DATA PUMP.
77: CSF_SPATIAL_TTSP_PVT.DATAPUMP_IMPORT(
78: p_dmp_file => p_dmp_file,
79: p_data_file_dir => p_data_file_dir,
80: p_data_file_str => p_data_file_str,
81: p_data_set_name => p_data_set_name,

Line 86: CSF_SPATIAL_TTSP_PVT.INITIALIZE_INDEXES_FOR_TTS(

82: errbuf => errbuf,
83: retcode => retcode );
84:
85: -- Run the post TTSP import for Spatial Indexes of APPS schema.
86: CSF_SPATIAL_TTSP_PVT.INITIALIZE_INDEXES_FOR_TTS(
87: errbuf => errbuf,
88: retcode => retcode );
89:
90: --Run the statistics import for TTSP objects.

Line 91: CSF_SPATIAL_TTSP_PVT.IMPORT_TABLE_STATS(

87: errbuf => errbuf,
88: retcode => retcode );
89:
90: --Run the statistics import for TTSP objects.
91: CSF_SPATIAL_TTSP_PVT.IMPORT_TABLE_STATS(
92: p_data_set_name => p_data_set_name,
93: errbuf => errbuf,
94: retcode => retcode );
95:

Line 97: CSF_SPATIAL_TTSP_PVT.CREATE_SYNONYMS(

93: errbuf => errbuf,
94: retcode => retcode );
95:
96: -- Run the recreate synonyms
97: CSF_SPATIAL_TTSP_PVT.CREATE_SYNONYMS(
98: p_data_set_name => p_data_set_name,
99: errbuf => errbuf,
100: retcode => retcode );
101:

Line 102: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );

98: p_data_set_name => p_data_set_name,
99: errbuf => errbuf,
100: retcode => retcode );
101:
102: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );
103:
104: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'End of Procedure TTSP_PLUGIN for ' || p_data_set_name );
105:
106: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );

Line 104: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'End of Procedure TTSP_PLUGIN for ' || p_data_set_name );

100: retcode => retcode );
101:
102: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );
103:
104: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'End of Procedure TTSP_PLUGIN for ' || p_data_set_name );
105:
106: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );
107:
108: END TTSP_PLUGIN;

Line 106: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );

102: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );
103:
104: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'End of Procedure TTSP_PLUGIN for ' || p_data_set_name );
105:
106: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );
107:
108: END TTSP_PLUGIN;
109:
110:

Line 145: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );

141: -- Initialize API return status to success
142: retcode := l_rc_succ;
143: errbuf := l_msg_succ;
144:
145: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );
146:
147: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'Start of Procedure TTSP_PLUGOUT for ' || p_data_set_name );
148:
149: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );

Line 147: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'Start of Procedure TTSP_PLUGOUT for ' || p_data_set_name );

143: errbuf := l_msg_succ;
144:
145: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );
146:
147: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'Start of Procedure TTSP_PLUGOUT for ' || p_data_set_name );
148:
149: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );
150:
151: CSF_SPATIAL_TTSP_PVT.DROP_SPATIAL_TABLES(

Line 149: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );

145: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );
146:
147: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'Start of Procedure TTSP_PLUGOUT for ' || p_data_set_name );
148:
149: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );
150:
151: CSF_SPATIAL_TTSP_PVT.DROP_SPATIAL_TABLES(
152: p_data_set_name => p_data_set_name,
153: errbuf => errbuf,

Line 151: CSF_SPATIAL_TTSP_PVT.DROP_SPATIAL_TABLES(

147: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'Start of Procedure TTSP_PLUGOUT for ' || p_data_set_name );
148:
149: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );
150:
151: CSF_SPATIAL_TTSP_PVT.DROP_SPATIAL_TABLES(
152: p_data_set_name => p_data_set_name,
153: errbuf => errbuf,
154: retcode => retcode );
155:

Line 156: CSF_SPATIAL_TTSP_PVT.DROP_MATERIALIZED_VIEWS(

152: p_data_set_name => p_data_set_name,
153: errbuf => errbuf,
154: retcode => retcode );
155:
156: CSF_SPATIAL_TTSP_PVT.DROP_MATERIALIZED_VIEWS(
157: p_data_set_name => p_data_set_name,
158: errbuf => errbuf,
159: retcode => retcode );
160:

Line 161: CSF_SPATIAL_TTSP_PVT.DROP_TTSP_STATS(

157: p_data_set_name => p_data_set_name,
158: errbuf => errbuf,
159: retcode => retcode );
160:
161: CSF_SPATIAL_TTSP_PVT.DROP_TTSP_STATS(
162: p_data_set_name => p_data_set_name,
163: errbuf => errbuf,
164: retcode => retcode );
165:

Line 166: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );

162: p_data_set_name => p_data_set_name,
163: errbuf => errbuf,
164: retcode => retcode );
165:
166: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );
167:
168: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'End of Procedure TTSP_PLUGOUT for ' || p_data_set_name );
169:
170: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );

Line 168: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'End of Procedure TTSP_PLUGOUT for ' || p_data_set_name );

164: retcode => retcode );
165:
166: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );
167:
168: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'End of Procedure TTSP_PLUGOUT for ' || p_data_set_name );
169:
170: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );
171:
172:

Line 170: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );

166: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, ' ' );
167:
168: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'End of Procedure TTSP_PLUGOUT for ' || p_data_set_name );
169:
170: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, '================================================ ' );
171:
172:
173: EXCEPTION
174: WHEN others THEN

Line 180: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'TTSP_PLUGOUT PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);

176: retcode := 1;
177:
178: errbuf := sqlerrm;
179:
180: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'TTSP_PLUGOUT PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
181:
182: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'TTSP_PLUGOUT PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
183:
184: RAISE FND_API.G_EXC_ERROR;

Line 182: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'TTSP_PLUGOUT PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);

178: errbuf := sqlerrm;
179:
180: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'TTSP_PLUGOUT PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
181:
182: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'TTSP_PLUGOUT PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
183:
184: RAISE FND_API.G_EXC_ERROR;
185:
186: END TTSP_PLUGOUT;

Line 197: CSF_SPATIAL_TTSP_PVT.DATAPUMP_EXPORT(

193: retcode OUT nocopy VARCHAR2)
194: IS
195: BEGIN
196:
197: CSF_SPATIAL_TTSP_PVT.DATAPUMP_EXPORT(
198: P_DMP_FILE => P_DMP_FILE,
199: P_TABLE_SPACE => P_TABLE_SPACE,
200: P_DATA_SET_NAME => P_DATA_SET_NAME,
201: ERRBUF => ERRBUF,

Line 212: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.DATAPUMP_EXPORT PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);

208: retcode := 1;
209:
210: errbuf := sqlerrm;
211:
212: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.DATAPUMP_EXPORT PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
213:
214: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.DATAPUMP_EXPORT PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
215: END DATAPUMP_EXPORT;
216:

Line 214: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.DATAPUMP_EXPORT PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);

210: errbuf := sqlerrm;
211:
212: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.DATAPUMP_EXPORT PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
213:
214: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.DATAPUMP_EXPORT PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
215: END DATAPUMP_EXPORT;
216:
217: PROCEDURE PREPARE_INDEXES_FOR_TTS(
218: p_table_space IN VARCHAR2,

Line 224: CSF_SPATIAL_TTSP_PVT.PREPARE_INDEXES_FOR_TTS(

220: retcode OUT nocopy VARCHAR2)
221: IS
222: BEGIN
223:
224: CSF_SPATIAL_TTSP_PVT.PREPARE_INDEXES_FOR_TTS(
225: p_table_space => p_table_space,
226: ERRBUF => ERRBUF,
227: RETCODE => RETCODE );
228:

Line 237: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.PREPARE_INDEXES_FOR_TTS PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);

233: retcode := 1;
234:
235: errbuf := sqlerrm;
236:
237: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.PREPARE_INDEXES_FOR_TTS PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
238:
239: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.PREPARE_INDEXES_FOR_TTS PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
240: END PREPARE_INDEXES_FOR_TTS;
241:

Line 239: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.PREPARE_INDEXES_FOR_TTS PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);

235: errbuf := sqlerrm;
236:
237: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.PREPARE_INDEXES_FOR_TTS PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
238:
239: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.PREPARE_INDEXES_FOR_TTS PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
240: END PREPARE_INDEXES_FOR_TTS;
241:
242: /* DBMS_STATS.EXPORT_TABLE_STATS Procedure
243: ==================================

Line 252: CSF_SPATIAL_TTSP_PVT.EXPORT_TABLE_STATS(

248: retcode OUT nocopy VARCHAR2)
249: IS
250: BEGIN
251:
252: CSF_SPATIAL_TTSP_PVT.EXPORT_TABLE_STATS(
253: P_DATA_SET_NAME => P_DATA_SET_NAME,
254: ERRBUF => ERRBUF,
255: RETCODE => RETCODE );
256:

Line 265: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.EXPORT_TABLE_STATS PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);

261: retcode := 1;
262:
263: errbuf := sqlerrm;
264:
265: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.EXPORT_TABLE_STATS PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
266:
267: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.EXPORT_TABLE_STATS PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
268: END EXPORT_TABLE_STATS;
269:

Line 267: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.EXPORT_TABLE_STATS PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);

263: errbuf := sqlerrm;
264:
265: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.EXPORT_TABLE_STATS PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
266:
267: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.EXPORT_TABLE_STATS PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
268: END EXPORT_TABLE_STATS;
269:
270:
271: END CSF_SPATIAL_TTSP_PUB;