[Home] [Help]
45: INTO l_status, l_desc, l_batch_id
46: FROM fun_trx_headers
47: WHERE trx_id = p_trx_id;
48:
49: -- Added so logic to get batch number required as reference4 in gl_interface
50:
51: select batch_number
52: INTO l_batch_number
53: from fun_trx_batches
236:
237: /*-----------------------------------------------------
238: * PROCEDURE transfer_single
239: * ----------------------------------------------------
240: * Transfer a single transaction to GL interface.
241: * It assumes that the caller has a lock on the
242: * transaction, and will do the commit.
243: * ---------------------------------------------------*/
244:
316: l_created_by, l_line_id, l_desc,
317: l_batch_id, l_trx_id, l_dist_id;
318: EXIT WHEN c_dist%NOTFOUND;
319:
320: INSERT INTO gl_interface
321: (status, set_of_books_id, accounting_date,
322: currency_code, date_created, created_by,
323: actual_flag, user_je_category_name, user_je_source_name,
324: currency_conversion_date, user_currency_conversion_type, entered_dr,