DBA Data[Home] [Help]

APPS.AMV_IMT_PUB dependencies on DBMS_SQL

Line 87: curs := dbms_sql.open_cursor;

83:
84: -----------------------
85: -- rebuild the index --
86: -----------------------
87: curs := dbms_sql.open_cursor;
88: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
89: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);

Line 90: dbms_sql.parse(curs, stmt, dbms_sql.native);

86: -----------------------
87: curs := dbms_sql.open_cursor;
88: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
89: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
92: dbms_sql.close_cursor(curs);
93:
94: curs := dbms_sql.open_cursor;

Line 91: rows := dbms_sql.execute(curs);

87: curs := dbms_sql.open_cursor;
88: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
89: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
92: dbms_sql.close_cursor(curs);
93:
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||

Line 92: dbms_sql.close_cursor(curs);

88: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
89: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
92: dbms_sql.close_cursor(curs);
93:
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';

Line 94: curs := dbms_sql.open_cursor;

90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
92: dbms_sql.close_cursor(curs);
93:
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);

Line 97: dbms_sql.parse(curs, stmt, dbms_sql.native);

93:
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);
99: dbms_sql.close_cursor(curs);
100:
101: --

Line 98: rows := dbms_sql.execute(curs);

94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);
99: dbms_sql.close_cursor(curs);
100:
101: --
102: EXCEPTION

Line 99: dbms_sql.close_cursor(curs);

95: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);
99: dbms_sql.close_cursor(curs);
100:
101: --
102: EXCEPTION
103: WHEN OTHERS THEN

Line 147: curs := dbms_sql.open_cursor;

143:
144: -----------------------
145: -- rebuild the index --
146: -----------------------
147: curs := dbms_sql.open_cursor;
148: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
149: 'parameters(''sync'')';
150: dbms_sql.parse(curs, stmt, dbms_sql.native);
151: rows := dbms_sql.execute(curs);

Line 150: dbms_sql.parse(curs, stmt, dbms_sql.native);

146: -----------------------
147: curs := dbms_sql.open_cursor;
148: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
149: 'parameters(''sync'')';
150: dbms_sql.parse(curs, stmt, dbms_sql.native);
151: rows := dbms_sql.execute(curs);
152: dbms_sql.close_cursor(curs);
153:
154: curs := dbms_sql.open_cursor;

Line 151: rows := dbms_sql.execute(curs);

147: curs := dbms_sql.open_cursor;
148: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
149: 'parameters(''sync'')';
150: dbms_sql.parse(curs, stmt, dbms_sql.native);
151: rows := dbms_sql.execute(curs);
152: dbms_sql.close_cursor(curs);
153:
154: curs := dbms_sql.open_cursor;
155: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||

Line 152: dbms_sql.close_cursor(curs);

148: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
149: 'parameters(''sync'')';
150: dbms_sql.parse(curs, stmt, dbms_sql.native);
151: rows := dbms_sql.execute(curs);
152: dbms_sql.close_cursor(curs);
153:
154: curs := dbms_sql.open_cursor;
155: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
156: 'parameters(''sync'')';

Line 154: curs := dbms_sql.open_cursor;

150: dbms_sql.parse(curs, stmt, dbms_sql.native);
151: rows := dbms_sql.execute(curs);
152: dbms_sql.close_cursor(curs);
153:
154: curs := dbms_sql.open_cursor;
155: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
156: 'parameters(''sync'')';
157: dbms_sql.parse(curs, stmt, dbms_sql.native);
158: rows := dbms_sql.execute(curs);

Line 157: dbms_sql.parse(curs, stmt, dbms_sql.native);

153:
154: curs := dbms_sql.open_cursor;
155: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
156: 'parameters(''sync'')';
157: dbms_sql.parse(curs, stmt, dbms_sql.native);
158: rows := dbms_sql.execute(curs);
159: dbms_sql.close_cursor(curs);
160:
161: --

Line 158: rows := dbms_sql.execute(curs);

154: curs := dbms_sql.open_cursor;
155: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
156: 'parameters(''sync'')';
157: dbms_sql.parse(curs, stmt, dbms_sql.native);
158: rows := dbms_sql.execute(curs);
159: dbms_sql.close_cursor(curs);
160:
161: --
162: EXCEPTION

Line 159: dbms_sql.close_cursor(curs);

155: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
156: 'parameters(''sync'')';
157: dbms_sql.parse(curs, stmt, dbms_sql.native);
158: rows := dbms_sql.execute(curs);
159: dbms_sql.close_cursor(curs);
160:
161: --
162: EXCEPTION
163: WHEN OTHERS THEN