APPS.PA_IC_INV_DEL dependencies on PA_DRAFT_INVOICE_ITEMS

Line 80: Delete from pa_draft_invoice_items

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: *****/

Line 118: delete from pa_draft_invoice_items

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

Line 123: pa_ic_inv_utils.log_message('pa_draft_invoice_items rows deleted = ' || SQL%rowcount);

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

Line 295: FROM PA_DRAFT_INVOICE_ITEMS

291: dia.invoice_Date,
292: dia.agreement_id,
293: dia.INV_CURRENCY_CODE,
294: (SELECT SUM(INV_AMOUNT)
295: FROM PA_DRAFT_INVOICE_ITEMS
296: WHERE PROJECT_ID = P_PROJECT_ID
297: AND DRAFT_INVOICE_NUM = P_DRAFT_INVOICE_NUM)
298: FROM PA_DRAFT_INVOICES DIA
299: WHERE PROJECT_ID = P_PROJECT_ID