APPS.HR_DM_RANGE dependencies on DBMS_SQL

Line 145: l_cursor := dbms_sql.open_cursor;

141: p_last_migration_date || ''', ' ||
142: l_phase_item_id || ', ' ||
143: l_no_of_threads || '); end;';
144:
145: l_cursor := dbms_sql.open_cursor;
146: dbms_sql.parse(l_cursor, l_string, dbms_sql.native);
147: l_return_value := dbms_sql.execute(l_cursor);
148: dbms_sql.close_cursor(l_cursor);
149:

Line 146: dbms_sql.parse(l_cursor, l_string, dbms_sql.native);

142: l_phase_item_id || ', ' ||
143: l_no_of_threads || '); end;';
144:
145: l_cursor := dbms_sql.open_cursor;
146: dbms_sql.parse(l_cursor, l_string, dbms_sql.native);
147: l_return_value := dbms_sql.execute(l_cursor);
148: dbms_sql.close_cursor(l_cursor);
149:
150:

Line 147: l_return_value := dbms_sql.execute(l_cursor);

143: l_no_of_threads || '); end;';
144:
145: l_cursor := dbms_sql.open_cursor;
146: dbms_sql.parse(l_cursor, l_string, dbms_sql.native);
147: l_return_value := dbms_sql.execute(l_cursor);
148: dbms_sql.close_cursor(l_cursor);
149:
150:
151: -- update status to completed

Line 148: dbms_sql.close_cursor(l_cursor);

144:
145: l_cursor := dbms_sql.open_cursor;
146: dbms_sql.parse(l_cursor, l_string, dbms_sql.native);
147: l_return_value := dbms_sql.execute(l_cursor);
148: dbms_sql.close_cursor(l_cursor);
149:
150:
151: -- update status to completed
152: hr_dm_utility.update_phase_items(p_new_status => 'C',