198: last_update_login = l_user_id
199: where project_id = P_Project_Id
200: and draft_invoice_num = l_err_invoice_num;
201:
202: Update pa_draft_invoice_items
203: set draft_invoice_num = l_new_invoice_num,
204: last_update_date = SYSDATE,
205: last_update_login = l_user_id
206: where project_id = P_Project_Id
289: END IF;
290:
291: SELECT SUM(amount)
292: INTO l_total_billed_amount
293: FROM pa_draft_invoice_items
294: WHERE draft_invoice_num = p_draft_invoice_num
295: AND project_id = p_project_id ;
296:
297: Update pa_summary_project_fundings