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