APPS.PER_RI_RT_UTIL_PKG dependencies on DBMS_SQL

Line 81: c := dbms_sql.open_cursor ;

77: ' where t.flex_value_set_id = :1'|| --//p_value_set_id||
78: ' and t.enabled_flag=''Y''' ;
79: END IF;
80: -- test the SQL
81: c := dbms_sql.open_cursor ;
82: --##MS trap any exceptions raised here so that we can close the cursor before
83: -- raising the error
84: BEGIN
85: dbms_sql.parse(c , l_stmt , dbms_sql.native) ;

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

81: c := dbms_sql.open_cursor ;
82: --##MS trap any exceptions raised here so that we can close the cursor before
83: -- raising the error
84: BEGIN
85: dbms_sql.parse(c , l_stmt , dbms_sql.native) ;
86: EXCEPTION
87: WHEN OTHERS THEN
88: dbms_sql.close_cursor(c);
89: RAISE;

Line 88: dbms_sql.close_cursor(c);

84: BEGIN
85: dbms_sql.parse(c , l_stmt , dbms_sql.native) ;
86: EXCEPTION
87: WHEN OTHERS THEN
88: dbms_sql.close_cursor(c);
89: RAISE;
90: END;
91:
92: --##MS close cursor if the parse raised no exceptions

Line 93: dbms_sql.close_cursor(c);

89: RAISE;
90: END;
91:
92: --##MS close cursor if the parse raised no exceptions
93: dbms_sql.close_cursor(c);
94:
95: return (l_stmt);
96:
97: return ( null );