DBA Data[Home] [Help]

APPS.GMF_XLA_PKG dependencies on GMF_INVOICE_DISTRIBUTIONS

Line 2502: | update gmf_invoice_distributions table

2498: | MODIFICATION HISTORY
2499: | Date Author Description of Change
2500: | 01-Oct-2005 umoogala Genesis
2501: | 27-Feb-2007 pmarada Bug 5436974, Invoices enhancement, added code to
2502: | update gmf_invoice_distributions table
2503: *===========================================================================*/
2504: PROCEDURE process_pur_txns(p_event VARCHAR2)
2505: IS
2506: l_procedure_name CONSTANT VARCHAR2(100) := 'process_pur_txns';

Line 2733: g_log_msg := 'Updating gmf_invoice_distributions table';

2729: /* bug 4879803 end jboppana*/
2730: --
2731: -- Bug 5436974 Start Invoices enhancement pmarada
2732: --
2733: g_log_msg := 'Updating gmf_invoice_distributions table';
2734:
2735: print_debug(g_log_msg);
2736: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2737: THEN

Line 2745: UPDATE gmf_invoice_distributions SET

2741: message => g_log_msg
2742: );
2743: END IF;
2744: /* update the accounting */
2745: UPDATE gmf_invoice_distributions SET
2746: Accounted_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL )
2747: ,final_posting_date = DECODE (G_accounting_mode, 'F', sysdate, NULL)
2748: ,last_update_date = sysdate
2749: ,last_updated_by = g_user_id

Line 2763: g_log_msg := sql%rowcount || ' rows updated in gmf_invoice_distributions table';

2759: AND gxem.transaction_type IN ('PAYABLES_INVOICE_IPV_ADJ','PAYABLES_INVOICE_ERV_ADJ')
2760: AND xpae.event_class_code = gxem.event_class_code
2761: );
2762:
2763: g_log_msg := sql%rowcount || ' rows updated in gmf_invoice_distributions table';
2764:
2765: print_debug(g_log_msg);
2766: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2767: THEN