APPS.HXC_ALIAS_UTILITY dependencies on DBMS_SQL

Line 2638: c := dbms_sql.open_cursor ;

2634:
2635:
2636: END IF;
2637: -- test the SQL
2638: c := dbms_sql.open_cursor ;
2639: --##MS trap any exceptions raised here so that we can close the cursor before
2640: -- raising the error
2641: BEGIN
2642: dbms_sql.parse(c , l_stmt , dbms_sql.native) ;

Line 2642: dbms_sql.parse(c , l_stmt , dbms_sql.native) ;

2638: c := dbms_sql.open_cursor ;
2639: --##MS trap any exceptions raised here so that we can close the cursor before
2640: -- raising the error
2641: BEGIN
2642: dbms_sql.parse(c , l_stmt , dbms_sql.native) ;
2643: EXCEPTION
2644: WHEN OTHERS THEN
2645: dbms_sql.close_cursor(c);
2646: RAISE;

Line 2645: dbms_sql.close_cursor(c);

2641: BEGIN
2642: dbms_sql.parse(c , l_stmt , dbms_sql.native) ;
2643: EXCEPTION
2644: WHEN OTHERS THEN
2645: dbms_sql.close_cursor(c);
2646: RAISE;
2647: END;
2648:
2649: --##MS close cursor if the parse raised no exceptions

Line 2650: dbms_sql.close_cursor(c);

2646: RAISE;
2647: END;
2648:
2649: --##MS close cursor if the parse raised no exceptions
2650: dbms_sql.close_cursor(c);
2651:
2652: return (l_stmt);
2653:
2654: exception