DBA Data[Home] [Help]

APPS.PA_INVOICE_DETAIL_PKG dependencies on PA_DRAFT_INVOICE_DETAILS

Line 211: INSERT INTO PA_DRAFT_INVOICE_DETAILS

207: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In Insert...'|| to_char(G_Ins_count));
208: END IF;
209:
210: FORALL I IN 1..G_Ins_count
211: INSERT INTO PA_DRAFT_INVOICE_DETAILS
212: ( DRAFT_INVOICE_DETAIL_ID,
213: EXPENDITURE_ITEM_ID,
214: LINE_NUM,
215: PROJECT_ID,

Line 365: Update PA_DRAFT_INVOICE_DETAILS

361: Then
362: download(P_inv_rec_tab,G_Upd_count,'U');
363:
364: FORALL I IN 1..G_Upd_count
365: Update PA_DRAFT_INVOICE_DETAILS
366: Set
367: DENOM_CURRENCY_CODE = L_DENOM_CURRENCY_CODE(I),
368: DENOM_BILL_AMOUNT = L_DENOM_BILL_AMOUNT(I),
369: ACCT_CURRENCY_CODE = L_ACCT_CURRENCY_CODE(I),

Line 422: PA_DRAFT_INVOICE_DETAILS

418:
419: /* Code added for Bug No 5284823 */
420: FORALL I IN 1..G_Upd_count
421: Update
422: PA_DRAFT_INVOICE_DETAILS
423: Set
424: REQUEST_ID = PA_IC_INV_UTILS.G_REQUEST_ID
425: where
426: EXPENDITURE_ITEM_ID = L_EXPENDITURE_ITEM_ID(I) and

Line 456: From PA_DRAFT_INVOICE_DETAILS

452: download(P_inv_rec_tab,G_Del_count,'U');
453:
454: FORALL I IN 1..G_Del_count
455: Delete
456: From PA_DRAFT_INVOICE_DETAILS
457: Where EXPENDITURE_ITEM_ID = L_EXPENDITURE_ITEM_ID(I)
458: AND LINE_NUM = L_LINE_NUM(I);
459:
460: FORALL I IN 1..G_Del_count