Oracle API for GL Interface Package Header CREATE OR REPLACE PACKAGE xx_import_xfer_gl_iface_api /* $Header: XXXXXXXX.pkh, Version 1.0, 07-FEB-2002 UKEXPI $ *********************************************************************** * * * History Log * * * *********************************************************************** * * * App/Release : Oracle e-Business Suite RXXX * * Oracle App : SHORTNAME - FULL_NAME * * Module : SHORTNAME - DESCRIPTION * * Author : Anil Passi(Go 4 Gold) * * Version : 1.0 * * Created : 11-OCT-2002 * * Description : This package gives API for GL interface calls * * * * Change History Log * * ================== * * * * Version Date Author Change * * ======= =========== ============ ================================* * * * 1.0 11-OCT-2002 A. Passi Initial Version * * * * Parameters : * * * **********************************************************************/ AUTHID CURRENT_USER IS PROCEDURE set_sob_id(p_sob_id IN INTEGER); PROCEDURE set_source_name(p_source_name IN VARCHAR2); PROCEDURE populate_interface_control(p_user_je_source_name IN VARCHAR2 ,p_group_id IN OUT NUMBER ,p_set_of_books_id NUMBER ,p_interface_run_id IN OUT NUMBER); TYPE g_gl_int_type_rec IS RECORD( reference_date DATE ,attribute20 VARCHAR2(150) ,CONTEXT VARCHAR2(150) ,context2 VARCHAR2(150) ,invoice_date DATE ,tax_code VARCHAR2(15) ,invoice_identifier VARCHAR2(20) ,invoice_amount NUMBER ,context3 VARCHAR2(150) ,ussgl_transaction_code VARCHAR2(30) ,descr_flex_error_message VARCHAR2(240) ,jgzz_recon_ref VARCHAR2(240) ,segment23 VARCHAR2(25) ,segment24 VARCHAR2(25) ,segment25 VARCHAR2(25) ,segment26 VARCHAR2(25) ,segment27 VARCHAR2(25) ,segment28 VARCHAR2(25) ,segment29 VARCHAR2(25) ,segment30 VARCHAR2(25) ,entered_dr NUMBER ,entered_cr NUMBER ,accounted_dr NUMBER ,accounted_cr NUMBER ,transaction_date DATE ,reference1 VARCHAR2(100) ,reference2 VARCHAR2(240) ,reference3 VARCHAR2(100) ,reference4 VARCHAR2(100) ,reference5 VARCHAR2(240) ,reference6 VARCHAR2(100) ,reference7 VARCHAR2(100) ,reference8 VARCHAR2(100) ,reference9 VARCHAR2(100) ,reference10 VARCHAR2(240) ,reference11 VARCHAR2(100) ,reference12 VARCHAR2(100) ,reference13 VARCHAR2(100) ,reference14 VARCHAR2(100) ,reference15 VARCHAR2(100) ,reference16 VARCHAR2(100) ,reference17 VARCHAR2(100) ,reference18 VARCHAR2(100) ,reference19 VARCHAR2(100) ,reference20 VARCHAR2(100) ,reference21 VARCHAR2(240) ,reference22 VARCHAR2(240) ,reference23 VARCHAR2(240) ,reference24 VARCHAR2(240) ,reference25 VARCHAR2(240) ,reference26 VARCHAR2(240) ,reference27 VARCHAR2(240) ,reference28 VARCHAR2(240) ,reference29 VARCHAR2(240) ,reference30 VARCHAR2(240) ,je_batch_id NUMBER ,period_name VARCHAR2(15) ,je_header_id NUMBER ,je_line_num NUMBER ,chart_of_accounts_id NUMBER ,functional_currency_code VARCHAR2(15) ,code_combination_id NUMBER ,date_created_in_gl DATE ,warning_code VARCHAR2(4) ,status_description VARCHAR2(240) ,stat_amount NUMBER ,group_id NUMBER ,request_id NUMBER ,subledger_doc_sequence_id NUMBER ,subledger_doc_sequence_value NUMBER ,attribute1 VARCHAR2(150) ,attribute2 VARCHAR2(150) ,gl_sl_link_id NUMBER ,gl_sl_link_table VARCHAR2(30) ,attribute3 VARCHAR2(150) ,attribute4 VARCHAR2(150) ,attribute5 VARCHAR2(150) ,attribute6 VARCHAR2(150) ,attribute7 VARCHAR2(150) ,attribute8 VARCHAR2(150) ,attribute9 VARCHAR2(150) ,attribute10 VARCHAR2(150) ,attribute11 VARCHAR2(150) ,attribute12 VARCHAR2(150) ,attribute13 VARCHAR2(150) ,attribute14 VARCHAR2(150) ,attribute15 VARCHAR2(150) ,attribute16 VARCHAR2(150) ,attribute17 VARCHAR2(150) ,attribute18 VARCHAR2(150) ,attribute19 VARCHAR2(150) ,status VARCHAR2(50) ,set_of_books_id NUMBER ,accounting_date DATE ,currency_code VARCHAR2(15) ,date_created DATE ,created_by NUMBER ,actual_flag VARCHAR2(1) ,user_je_category_name VARCHAR2(25) ,user_je_source_name VARCHAR2(25) ,currency_conversion_date DATE ,encumbrance_type_id NUMBER ,budget_version_id NUMBER ,user_currency_conversion_type VARCHAR2(30) ,currency_conversion_rate NUMBER ,average_journal_flag VARCHAR2(1) ,originating_bal_seg_value VARCHAR2(25) ,segment1 VARCHAR2(25) ,segment2 VARCHAR2(25) ,segment3 VARCHAR2(25) ,segment4 VARCHAR2(25) ,segment5 VARCHAR2(25) ,segment6 VARCHAR2(25) ,segment7 VARCHAR2(25) ,segment8 VARCHAR2(25) ,segment9 VARCHAR2(25) ,segment10 VARCHAR2(25) ,segment11 VARCHAR2(25) ,segment12 VARCHAR2(25) ,segment13 VARCHAR2(25) ,segment14 VARCHAR2(25) ,segment15 VARCHAR2(25) ,segment16 VARCHAR2(25) ,segment17 VARCHAR2(25) ,segment18 VARCHAR2(25) ,segment19 VARCHAR2(25) ,segment20 VARCHAR2(25) ,segment21 VARCHAR2(25) ,segment22 VARCHAR2(25)); PROCEDURE insert_statement(p_gl_int_rec IN OUT NOCOPY g_gl_int_type_rec); PROCEDURE transfer_to_gl(p_sob_id IN INTEGER ,p_batch_header_id IN INTEGER ,p_trx_header_id IN INTEGER ,p_trx_line_id IN INTEGER ,p_date IN OUT DATE ,p_currency_code IN VARCHAR2 ,p_amount IN NUMBER ,p_dr_account IN INTEGER ,p_cr_account IN INTEGER ,p_journal_name IN VARCHAR2 ,p_header_description IN VARCHAR2 ,p_line_description IN VARCHAR2 ,p_success_flag OUT BOOLEAN ,p_first_record_in_batch IN VARCHAR2 ,p_submit_gl_interface IN VARCHAR2 ,p_gl_user_je_source_name IN VARCHAR2 ,p_gl_user_je_category_name IN VARCHAR2 ,p_trx_number IN VARCHAR2); PROCEDURE new_gl_interface_batch; FUNCTION get_gl_je_reference1(p_batch_header_id IN INTEGER ,p_trx_number IN VARCHAR2) RETURN VARCHAR2; FUNCTION get_gl_application_id(p_appl_name IN VARCHAR2) RETURN INTEGER; END xx_import_xfer_gl_iface_api;