76: Loop
77: Update summary project fundings reduce invoiced_amount by the
78: deleting invoice amount;
79: Delete from pa_distribution_warnings ;
80: Delete from pa_draft_invoice_items
81: Delete from pa_draft_invoices
82: // remove the reference to the Invoice from Invoice Details
83: End Loop;
84: *****/
114: insert_dist_warnings(p_project_id,
115: l_draft_inv_num);
116: END IF;
117:
118: delete from pa_draft_invoice_items
119: where project_id = P_PROJECT_ID
120: and draft_invoice_num = l_draft_inv_num;
121:
122: IF g1_debug_mode = 'Y' THEN
119: where project_id = P_PROJECT_ID
120: and draft_invoice_num = l_draft_inv_num;
121:
122: IF g1_debug_mode = 'Y' THEN
123: pa_ic_inv_utils.log_message('pa_draft_invoice_items rows deleted = ' || SQL%rowcount);
124: END IF;
125:
126: delete from pa_draft_invoices
127: where project_id = P_PROJECT_ID
303: dia.invoice_Date,
304: dia.agreement_id,
305: dia.INV_CURRENCY_CODE,
306: (SELECT SUM(INV_AMOUNT)
307: FROM PA_DRAFT_INVOICE_ITEMS
308: WHERE PROJECT_ID = P_PROJECT_ID
309: AND DRAFT_INVOICE_NUM = P_DRAFT_INVOICE_NUM)
310: FROM PA_DRAFT_INVOICES DIA
311: WHERE PROJECT_ID = P_PROJECT_ID