[Home] [Help]
125: (ledger_id NUMBER
126: ,NAME gl_ledgers.NAME%TYPE
127: ,ledger_category_code gl_ledgers.ledger_category_code%TYPE
128: ,group_id gl_interface.group_id%TYPE
129: ,interface_run_id gl_interface_control.interface_run_id%TYPE
130: ,gllezl_request_id NUMBER
131: ,access_set_id NUMBER
132: );
133: TYPE t_array_ledgers IS TABLE OF r_ledger_rec INDEX BY BINARY_INTEGER;
730: --Added for bug 11855000 End
731:
732:
733: /*===================================================================
734: | INSERT ROWS INTO THE GL_INTERFACE_CONTROL |
735: | |
736: =====================================================================*/
737: PROCEDURE insert_interface_control(p_ledger_id NUMBER
738: ,p_table_name VARCHAR2) IS
757: --8429053
758: --Passing NULL for GL_INTERFACE table so data will not be
759: --retained in GL_INTERFACE table with PROCESSED status
760:
761: INSERT INTO gl_interface_control
762: (
763: je_source_name,
764: status,
765: interface_run_id,
793: EXCEPTION
794: WHEN xla_exceptions_pkg.application_exception THEN
795: RAISE;
796: WHEN OTHERS THEN
797: trace('Insert into the GL_INTERFACE_CONTROL failed',C_LEVEL_UNEXPECTED,l_Log_module);
798: xla_exceptions_pkg.raise_message
799: (p_location => 'xla_transfer_pkg.get_gllezl_status');
800:
801: END insert_interface_control;
1511:
1512: IF (g_group_id_tab.COUNT > 0) THEN
1513: --Added for bug 11855000 Start
1514: --
1515: -- Delete rows from gl_bc_packets and update gl_interface control with packet_id as -1
1516: --
1517: IF g_application_id = 200 THEN
1518:
1519: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
3573: INTO g_primary_ledgers_tab(i).interface_run_id
3574: FROM dual;
3575: ELSE
3576: SELECT gl_journal_import_s.NEXTVAL
3577: ,gl_interface_control_s.NEXTVAL
3578: INTO g_primary_ledgers_tab(i).interface_run_id
3579: ,g_primary_ledgers_tab(i).group_id
3580: FROM dual;
3581: