DBA Data[Home] [Help]

APPS.HZ_PURGE dependencies on DBMS_SQL

Line 1239: c := dbms_sql.open_cursor;

1235: c NUMBER;
1236: n NUMBER;
1237: l_custom BOOLEAN;
1238: BEGIN
1239: c := dbms_sql.open_cursor;
1240: dbms_sql.parse(c,proc,2);
1241: dbms_sql.close_cursor(c);
1242: RETURN TRUE;
1243: EXCEPTION

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

1236: n NUMBER;
1237: l_custom BOOLEAN;
1238: BEGIN
1239: c := dbms_sql.open_cursor;
1240: dbms_sql.parse(c,proc,2);
1241: dbms_sql.close_cursor(c);
1242: RETURN TRUE;
1243: EXCEPTION
1244: WHEN OTHERS THEN

Line 1241: dbms_sql.close_cursor(c);

1237: l_custom BOOLEAN;
1238: BEGIN
1239: c := dbms_sql.open_cursor;
1240: dbms_sql.parse(c,proc,2);
1241: dbms_sql.close_cursor(c);
1242: RETURN TRUE;
1243: EXCEPTION
1244: WHEN OTHERS THEN
1245: dbms_sql.close_cursor(c);

Line 1245: dbms_sql.close_cursor(c);

1241: dbms_sql.close_cursor(c);
1242: RETURN TRUE;
1243: EXCEPTION
1244: WHEN OTHERS THEN
1245: dbms_sql.close_cursor(c);
1246: RETURN FALSE;
1247: END;
1248:
1249: PROCEDURE populate_fk_datatype IS