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.MRP_EXCEPTION_SC dependencies on DBMS_SQL

Line 51: /*c := dbms_sql.open_cursor;

47: where_clause_segment ||
48: 'GROUP BY compile_designator, display, ' ||
49: count_list;
50:
51: /*c := dbms_sql.open_cursor;
52: dbms_sql.parse(c, statement, dbms_sql.native);
53: rows_processed := dbms_sql.execute(c);
54: dbms_sql.close_cursor(c);
55: */

Line 52: dbms_sql.parse(c, statement, dbms_sql.native);

48: 'GROUP BY compile_designator, display, ' ||
49: count_list;
50:
51: /*c := dbms_sql.open_cursor;
52: dbms_sql.parse(c, statement, dbms_sql.native);
53: rows_processed := dbms_sql.execute(c);
54: dbms_sql.close_cursor(c);
55: */
56: --bug 5022710

Line 53: rows_processed := dbms_sql.execute(c);

49: count_list;
50:
51: /*c := dbms_sql.open_cursor;
52: dbms_sql.parse(c, statement, dbms_sql.native);
53: rows_processed := dbms_sql.execute(c);
54: dbms_sql.close_cursor(c);
55: */
56: --bug 5022710
57:

Line 54: dbms_sql.close_cursor(c);

50:
51: /*c := dbms_sql.open_cursor;
52: dbms_sql.parse(c, statement, dbms_sql.native);
53: rows_processed := dbms_sql.execute(c);
54: dbms_sql.close_cursor(c);
55: */
56: --bug 5022710
57:
58: execute immediate statement using

Line 123: /*c := dbms_sql.open_cursor;

119: ', :n,organization_id,:planned_org ) '||
120: ' and version is null ' ||
121: where_clause_segment;
122:
123: /*c := dbms_sql.open_cursor;
124: dbms_sql.parse(c, statement, dbms_sql.native);
125: rows_processed := dbms_sql.execute(c);
126: dbms_sql.close_cursor(c);
127: */

Line 124: dbms_sql.parse(c, statement, dbms_sql.native);

120: ' and version is null ' ||
121: where_clause_segment;
122:
123: /*c := dbms_sql.open_cursor;
124: dbms_sql.parse(c, statement, dbms_sql.native);
125: rows_processed := dbms_sql.execute(c);
126: dbms_sql.close_cursor(c);
127: */
128: --5022710

Line 125: rows_processed := dbms_sql.execute(c);

121: where_clause_segment;
122:
123: /*c := dbms_sql.open_cursor;
124: dbms_sql.parse(c, statement, dbms_sql.native);
125: rows_processed := dbms_sql.execute(c);
126: dbms_sql.close_cursor(c);
127: */
128: --5022710
129: execute immediate statement using

Line 126: dbms_sql.close_cursor(c);

122:
123: /*c := dbms_sql.open_cursor;
124: dbms_sql.parse(c, statement, dbms_sql.native);
125: rows_processed := dbms_sql.execute(c);
126: dbms_sql.close_cursor(c);
127: */
128: --5022710
129: execute immediate statement using
130: exception_id,compile_designator,planning_org,planned_org,planned_org,

Line 205: c := dbms_sql.open_cursor;

201: from mrp_form_query
202: where ' ||p_omit_list||
203: ' and query_id = :exception_id )';
204:
205: c := dbms_sql.open_cursor;
206: dbms_sql.parse(c, statement, dbms_sql.native);
207: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
208: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
209: dbms_sql.bind_variable(c,'exception_id',p_exception_id);

Line 206: dbms_sql.parse(c, statement, dbms_sql.native);

202: where ' ||p_omit_list||
203: ' and query_id = :exception_id )';
204:
205: c := dbms_sql.open_cursor;
206: dbms_sql.parse(c, statement, dbms_sql.native);
207: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
208: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
209: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
210: rows_processed := dbms_sql.execute(c);

Line 207: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);

203: ' and query_id = :exception_id )';
204:
205: c := dbms_sql.open_cursor;
206: dbms_sql.parse(c, statement, dbms_sql.native);
207: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
208: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
209: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
210: rows_processed := dbms_sql.execute(c);
211: dbms_sql.close_cursor(c);

Line 208: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);

204:
205: c := dbms_sql.open_cursor;
206: dbms_sql.parse(c, statement, dbms_sql.native);
207: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
208: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
209: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
210: rows_processed := dbms_sql.execute(c);
211: dbms_sql.close_cursor(c);
212:

Line 209: dbms_sql.bind_variable(c,'exception_id',p_exception_id);

205: c := dbms_sql.open_cursor;
206: dbms_sql.parse(c, statement, dbms_sql.native);
207: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
208: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
209: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
210: rows_processed := dbms_sql.execute(c);
211: dbms_sql.close_cursor(c);
212:
213: Exception

Line 210: rows_processed := dbms_sql.execute(c);

206: dbms_sql.parse(c, statement, dbms_sql.native);
207: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
208: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
209: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
210: rows_processed := dbms_sql.execute(c);
211: dbms_sql.close_cursor(c);
212:
213: Exception
214: When no_data_found Then

Line 211: dbms_sql.close_cursor(c);

207: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
208: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
209: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
210: rows_processed := dbms_sql.execute(c);
211: dbms_sql.close_cursor(c);
212:
213: Exception
214: When no_data_found Then
215: raise no_data_found;

Line 246: c := dbms_sql.open_cursor;

242: where ' ||p_omit_list||
243: ' and query_id = :exception_id )'||
244: ' for update of display nowait ';
245:
246: c := dbms_sql.open_cursor;
247: dbms_sql.parse(c, statement, dbms_sql.native);
248: dbms_sql.define_column(c, 1, display_flag);
249: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
250: rows_processed := dbms_sql.execute(c);

Line 247: dbms_sql.parse(c, statement, dbms_sql.native);

243: ' and query_id = :exception_id )'||
244: ' for update of display nowait ';
245:
246: c := dbms_sql.open_cursor;
247: dbms_sql.parse(c, statement, dbms_sql.native);
248: dbms_sql.define_column(c, 1, display_flag);
249: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
250: rows_processed := dbms_sql.execute(c);
251: counter :=0;

Line 248: dbms_sql.define_column(c, 1, display_flag);

244: ' for update of display nowait ';
245:
246: c := dbms_sql.open_cursor;
247: dbms_sql.parse(c, statement, dbms_sql.native);
248: dbms_sql.define_column(c, 1, display_flag);
249: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
250: rows_processed := dbms_sql.execute(c);
251: counter :=0;
252:

Line 249: dbms_sql.bind_variable(c,'exception_id',p_exception_id);

245:
246: c := dbms_sql.open_cursor;
247: dbms_sql.parse(c, statement, dbms_sql.native);
248: dbms_sql.define_column(c, 1, display_flag);
249: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
250: rows_processed := dbms_sql.execute(c);
251: counter :=0;
252:
253: Loop

Line 250: rows_processed := dbms_sql.execute(c);

246: c := dbms_sql.open_cursor;
247: dbms_sql.parse(c, statement, dbms_sql.native);
248: dbms_sql.define_column(c, 1, display_flag);
249: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
250: rows_processed := dbms_sql.execute(c);
251: counter :=0;
252:
253: Loop
254: IF (dbms_sql.fetch_rows(c) >0) THEN

Line 254: IF (dbms_sql.fetch_rows(c) >0) THEN

250: rows_processed := dbms_sql.execute(c);
251: counter :=0;
252:
253: Loop
254: IF (dbms_sql.fetch_rows(c) >0) THEN
255: dbms_sql.column_value(c, 1, display_flag);
256: IF display_flag <> 1 THEN
257: -- record already changed
258: return 2;

Line 255: dbms_sql.column_value(c, 1, display_flag);

251: counter :=0;
252:
253: Loop
254: IF (dbms_sql.fetch_rows(c) >0) THEN
255: dbms_sql.column_value(c, 1, display_flag);
256: IF display_flag <> 1 THEN
257: -- record already changed
258: return 2;
259: END IF;

Line 265: dbms_sql.close_cursor(c);

261: ELSE
262: exit;
263: END IF;
264: END Loop;
265: dbms_sql.close_cursor(c);
266: IF counter = 0 THEN
267: -- no matching records , record already deleted
268: return 1;
269: ELSE

Line 278: IF dbms_sql.is_open(c) THEN

274:
275: EXCEPTION
276: WHEN others THEN
277: --can not lock the record, because the record is locked by other users already
278: IF dbms_sql.is_open(c) THEN
279: dbms_sql.close_cursor(c);
280: END IF;
281: raise_application_error(-20020,sqlerrm||':'||statement);
282:

Line 279: dbms_sql.close_cursor(c);

275: EXCEPTION
276: WHEN others THEN
277: --can not lock the record, because the record is locked by other users already
278: IF dbms_sql.is_open(c) THEN
279: dbms_sql.close_cursor(c);
280: END IF;
281: raise_application_error(-20020,sqlerrm||':'||statement);
282:
283: END lock_row;