APPS.HR_EFC_INFO dependencies on DBMS_SQL

Line 1504: l_cursor := dbms_sql.open_cursor;

1500: l_sql := replace(l_del_tab_sql,'',c1.table_name);
1501: l_sql := replace(l_sql,'',l_action_id);
1502: --
1503: -- Execute sql
1504: l_cursor := dbms_sql.open_cursor;
1505: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.v7);
1506: l_return := dbms_sql.execute(l_cursor);
1507: dbms_sql.close_cursor(l_cursor);
1508: --

Line 1505: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.v7);

1501: l_sql := replace(l_sql,'',l_action_id);
1502: --
1503: -- Execute sql
1504: l_cursor := dbms_sql.open_cursor;
1505: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.v7);
1506: l_return := dbms_sql.execute(l_cursor);
1507: dbms_sql.close_cursor(l_cursor);
1508: --
1509: END LOOP;

Line 1506: l_return := dbms_sql.execute(l_cursor);

1502: --
1503: -- Execute sql
1504: l_cursor := dbms_sql.open_cursor;
1505: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.v7);
1506: l_return := dbms_sql.execute(l_cursor);
1507: dbms_sql.close_cursor(l_cursor);
1508: --
1509: END LOOP;
1510: --

Line 1507: dbms_sql.close_cursor(l_cursor);

1503: -- Execute sql
1504: l_cursor := dbms_sql.open_cursor;
1505: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.v7);
1506: l_return := dbms_sql.execute(l_cursor);
1507: dbms_sql.close_cursor(l_cursor);
1508: --
1509: END LOOP;
1510: --
1511: END delete_action_history;