[Home] [Help]
337: | Transfer_Jnls |
338: | |
339: | DESCRIPTION |
340: | Procedure which will transfer/re-transfer the given batch id |
341: | from the XTR_JOURNALS table to the GL_INTERFACE table. |
342: | |
343: | CALLED BY |
344: | Procedure XTR_JOURNAL_PROCESS_P.Journals. |
345: | |
365: in_batch_id IN NUMBER,
366: in_closed_periods IN VARCHAR2) IS
367: --
368: -- Public procedure which will create Journal Records in the
369: -- Oracle Financials GL_INTERFACE Table
370: --
371:
372: l_set_of_books gl_sets_of_books.set_of_books_id%TYPE := to_number(NULL);
373: l_trx_param xtr_company_parameters.parameter_value_code%TYPE;
374: l_source_name gl_je_sources.user_je_source_name%TYPE;
375: l_category_name gl_je_categories.user_je_category_name%TYPE;
376: l_xchange_type gl_daily_conversion_types.user_conversion_type%TYPE;
377: l_gl_link_id XTR_JOURNALS.gl_sl_link_id%TYPE;
378: l_gl_group_id GL_INTERFACE.group_id%TYPE; -- add to record group id when tranfer
379: p_company_code XTR_PARTY_INFO.party_code%TYPE;
380: l_rowid VARCHAR2(30);
381:
382: l_bal_flag XTR_COMPANY_PARAMETERS.parameter_value_code%TYPE := NULL;
488: from xtr_parties_v
489: where party_code = p_company_code);
490: --
491: cursor GL_GROUP_ID is
492: select gl_interface_control_s.nextval
493: from dual;
494: --
495:
496: BEGIN
649: End If; -- [in_closed_period...]
650:
651: If (l_ok_to_xfer) then
652:
653: -- Continue to transfer info into the GL_Interface table.
654:
655: Insert into GL_INTERFACE(
656: status,
657: set_of_books_id,
651: If (l_ok_to_xfer) then
652:
653: -- Continue to transfer info into the GL_Interface table.
654:
655: Insert into GL_INTERFACE(
656: status,
657: set_of_books_id,
658: code_combination_id,
659: user_je_source_name,