DBA Data[Home] [Help]

APPS.HZ_PURGE dependencies on DBMS_SQL

Line 1256: c := dbms_sql.open_cursor;

1252: c NUMBER;
1253: n NUMBER;
1254: l_custom BOOLEAN;
1255: BEGIN
1256: c := dbms_sql.open_cursor;
1257: dbms_sql.parse(c,proc,2);
1258: dbms_sql.close_cursor(c);
1259: RETURN TRUE;
1260: EXCEPTION

Line 1257: dbms_sql.parse(c,proc,2);

1253: n NUMBER;
1254: l_custom BOOLEAN;
1255: BEGIN
1256: c := dbms_sql.open_cursor;
1257: dbms_sql.parse(c,proc,2);
1258: dbms_sql.close_cursor(c);
1259: RETURN TRUE;
1260: EXCEPTION
1261: WHEN OTHERS THEN

Line 1258: dbms_sql.close_cursor(c);

1254: l_custom BOOLEAN;
1255: BEGIN
1256: c := dbms_sql.open_cursor;
1257: dbms_sql.parse(c,proc,2);
1258: dbms_sql.close_cursor(c);
1259: RETURN TRUE;
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: dbms_sql.close_cursor(c);

Line 1262: dbms_sql.close_cursor(c);

1258: dbms_sql.close_cursor(c);
1259: RETURN TRUE;
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: dbms_sql.close_cursor(c);
1263: RETURN FALSE;
1264: END;
1265:
1266: PROCEDURE populate_fk_datatype IS