APPS.PA_IC_INV_CNL dependencies on PA_DRAFT_INVOICE_ITEMS

Line 278: INSERT INTO PA_DRAFT_INVOICE_ITEMS

274: The following insert statement will create all the crediting invoice
275: lines.
276: */
277:
278: INSERT INTO PA_DRAFT_INVOICE_ITEMS
279: (LINE_NUM,
280: DRAFT_INVOICE_NUM,
281: PROJECT_ID,
282: TASK_ID,

Line 356: FROM PA_DRAFT_INVOICE_ITEMS I2

352: I2.project_currency_code,
353: -1 * I2.project_bill_amount,
354: I2.funding_currency_code,
355: -1 * I2.funding_bill_amount
356: FROM PA_DRAFT_INVOICE_ITEMS I2
357: WHERE I2.PROJECT_ID = P_PROJECT_ID
358: AND I2.DRAFT_INVOICE_NUM = P_DRAFT_INV_NUM;
359:
360: IF g1_debug_mode = 'Y' THEN

Line 361: pa_ic_inv_utils.log_message('Inserting pa_draft_invoice_items rows = '||

357: WHERE I2.PROJECT_ID = P_PROJECT_ID
358: AND I2.DRAFT_INVOICE_NUM = P_DRAFT_INV_NUM;
359:
360: IF g1_debug_mode = 'Y' THEN
361: pa_ic_inv_utils.log_message('Inserting pa_draft_invoice_items rows = '||
362: SQL%ROWCOUNT);
363: END IF;
364:
365: /* For each reversing invoice line create new Invoice details ,