[Home] [Help]
2746: | MODIFICATION HISTORY
2747: | Date Author Description of Change
2748: | 01-Oct-2005 umoogala Genesis
2749: | 27-Feb-2007 pmarada Bug 5436974, Invoices enhancement, added code to
2750: | update gmf_invoice_distributions table
2751: | 5-Aug-2009 pmarada bug 8642337 LCM-OPM Integration, updating LC adjustment
2752: | tables accounted flag and final accounted date.
2753: | 29-Sep-2011 phiriyan Bug 13033147. Modified not to update MMT row when
2754: | event class / transaction type is related to Receiving txn.
3007: /* bug 4879803 end jboppana*/
3008: --
3009: -- Bug 5436974 Start Invoices enhancement pmarada
3010: --
3011: g_log_msg := 'Updating gmf_invoice_distributions table';
3012:
3013: print_debug(g_log_msg);
3014: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3015: THEN
3019: message => g_log_msg
3020: );
3021: END IF;
3022: /* update the accounting */
3023: UPDATE gmf_invoice_distributions SET
3024: Accounted_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL )
3025: ,final_posting_date = DECODE (G_accounting_mode, 'F', sysdate, NULL)
3026: ,last_update_date = sysdate
3027: ,last_updated_by = g_user_id
3037: AND gxem.transaction_type IN ('PAYABLES_INVOICE_IPV_ADJ','PAYABLES_INVOICE_ERV_ADJ')
3038: AND xpae.event_class_code = gxem.event_class_code
3039: );
3040:
3041: g_log_msg := sql%rowcount || ' rows updated in gmf_invoice_distributions table';
3042:
3043: print_debug(g_log_msg);
3044: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3045: THEN