[Home] [Help]
1680: WHERE id = sum_id_tab(i);
1681:
1682: l_hxt_sum_del_count := l_hxt_sum_del_count + SQL%ROWCOUNT;
1683:
1684: INSERT INTO hxt_det_hours_worked_f_ar
1685: ( data_set_id, state_name, county_name, city_name, zip_code, id, parent_id, line_status,
1686: tim_id, date_worked, assignment_id, hours, time_in, time_out, element_type_id,
1687: fcl_earn_reason_code, ffv_cost_center_id, ffv_labor_account_id, tas_id, location_id,
1688: sht_id, hrw_comment, ffv_rate_code_id, rate_multiple, hourly_rate, amount,
1699: last_update_date, last_update_login, actual_time_in, actual_time_out, job_id, earn_pol_id,
1700: effective_start_date, effective_end_date, pbl_line_id, retro_pbl_line_id, project_id,
1701: prev_wage_code, pa_status, pay_status, retro_batch_id, object_version_number
1702: FROM hxc_archive_temp temp,
1703: hxt_det_hours_worked_f det
1704: WHERE temp.detail_id = det.parent_id
1705: AND temp.thread_id = p_thread_id;
1706:
1707: l_hxt_det_count := l_hxt_det_count + SQL%ROWCOUNT;
1707: l_hxt_det_count := l_hxt_det_count + SQL%ROWCOUNT;
1708:
1709:
1710: FORALL i IN sum_id_tab.FIRST..sum_id_tab.LAST
1711: DELETE FROM hxt_det_hours_worked_f
1712: WHERE parent_id = sum_id_tab(i);
1713:
1714: l_hxt_det_del_count := l_hxt_det_del_count + SQL%ROWCOUNT;
1715: