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

Line 523: c := dbms_sql.open_cursor;

519: from msc_form_query
520: where ' ||p_omit_list||
521: ' and query_id = :exception_id )';
522:
523: c := dbms_sql.open_cursor;
524: dbms_sql.parse(c, statement, dbms_sql.native);
525: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
526: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
527: dbms_sql.bind_variable(c,'exception_id',p_exception_id);

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

520: where ' ||p_omit_list||
521: ' and query_id = :exception_id )';
522:
523: c := dbms_sql.open_cursor;
524: dbms_sql.parse(c, statement, dbms_sql.native);
525: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
526: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
527: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
528: rows_processed := dbms_sql.execute(c);

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

521: ' and query_id = :exception_id )';
522:
523: c := dbms_sql.open_cursor;
524: dbms_sql.parse(c, statement, dbms_sql.native);
525: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
526: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
527: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
528: rows_processed := dbms_sql.execute(c);
529: dbms_sql.close_cursor(c);

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

522:
523: c := dbms_sql.open_cursor;
524: dbms_sql.parse(c, statement, dbms_sql.native);
525: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
526: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
527: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
528: rows_processed := dbms_sql.execute(c);
529: dbms_sql.close_cursor(c);
530:

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

523: c := dbms_sql.open_cursor;
524: dbms_sql.parse(c, statement, dbms_sql.native);
525: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
526: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
527: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
528: rows_processed := dbms_sql.execute(c);
529: dbms_sql.close_cursor(c);
530:
531: Exception

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

524: dbms_sql.parse(c, statement, dbms_sql.native);
525: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
526: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
527: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
528: rows_processed := dbms_sql.execute(c);
529: dbms_sql.close_cursor(c);
530:
531: Exception
532: When no_data_found Then

Line 529: dbms_sql.close_cursor(c);

525: dbms_sql.bind_variable(c,'last_update_login',p_last_update_login);
526: dbms_sql.bind_variable(c,'last_updated_by',p_last_updated_by);
527: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
528: rows_processed := dbms_sql.execute(c);
529: dbms_sql.close_cursor(c);
530:
531: Exception
532: When no_data_found Then
533: raise no_data_found;

Line 564: c := dbms_sql.open_cursor;

560: where ' ||p_omit_list||
561: ' and query_id = :exception_id )'||
562: ' for update of display nowait ';
563:
564: c := dbms_sql.open_cursor;
565: dbms_sql.parse(c, statement, dbms_sql.native);
566: dbms_sql.define_column(c, 1, display_flag);
567: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
568: rows_processed := dbms_sql.execute(c);

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

561: ' and query_id = :exception_id )'||
562: ' for update of display nowait ';
563:
564: c := dbms_sql.open_cursor;
565: dbms_sql.parse(c, statement, dbms_sql.native);
566: dbms_sql.define_column(c, 1, display_flag);
567: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
568: rows_processed := dbms_sql.execute(c);
569: counter :=0;

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

562: ' for update of display nowait ';
563:
564: c := dbms_sql.open_cursor;
565: dbms_sql.parse(c, statement, dbms_sql.native);
566: dbms_sql.define_column(c, 1, display_flag);
567: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
568: rows_processed := dbms_sql.execute(c);
569: counter :=0;
570:

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

563:
564: c := dbms_sql.open_cursor;
565: dbms_sql.parse(c, statement, dbms_sql.native);
566: dbms_sql.define_column(c, 1, display_flag);
567: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
568: rows_processed := dbms_sql.execute(c);
569: counter :=0;
570:
571: Loop

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

564: c := dbms_sql.open_cursor;
565: dbms_sql.parse(c, statement, dbms_sql.native);
566: dbms_sql.define_column(c, 1, display_flag);
567: dbms_sql.bind_variable(c,'exception_id',p_exception_id);
568: rows_processed := dbms_sql.execute(c);
569: counter :=0;
570:
571: Loop
572: IF (dbms_sql.fetch_rows(c) >0) THEN

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

568: rows_processed := dbms_sql.execute(c);
569: counter :=0;
570:
571: Loop
572: IF (dbms_sql.fetch_rows(c) >0) THEN
573: dbms_sql.column_value(c, 1, display_flag);
574: IF display_flag <> 1 THEN
575: -- record already changed
576: return 2;

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

569: counter :=0;
570:
571: Loop
572: IF (dbms_sql.fetch_rows(c) >0) THEN
573: dbms_sql.column_value(c, 1, display_flag);
574: IF display_flag <> 1 THEN
575: -- record already changed
576: return 2;
577: END IF;

Line 583: dbms_sql.close_cursor(c);

579: ELSE
580: exit;
581: END IF;
582: END Loop;
583: dbms_sql.close_cursor(c);
584: IF counter = 0 THEN
585: -- no matching records , record already deleted
586: return 1;
587: ELSE

Line 596: IF dbms_sql.is_open(c) THEN

592:
593: EXCEPTION
594: WHEN others THEN
595: --can not lock the record, because the record is locked by other users already
596: IF dbms_sql.is_open(c) THEN
597: dbms_sql.close_cursor(c);
598: END IF;
599: raise_application_error(-20020,sqlerrm||':'||statement);
600:

Line 597: dbms_sql.close_cursor(c);

593: EXCEPTION
594: WHEN others THEN
595: --can not lock the record, because the record is locked by other users already
596: IF dbms_sql.is_open(c) THEN
597: dbms_sql.close_cursor(c);
598: END IF;
599: raise_application_error(-20020,sqlerrm||':'||statement);
600:
601: END lock_row;