DBA Data[Home] [Help]

APPS.XLA_TRANSFER_PKG dependencies on GL_JOURNAL_IMPORT_S

Line 1627: trace('First time recover calling gl_journal_import_sla_pkg.delete_batches',C_LEVEL_EVENT,l_log_module);

1623: FOR i IN g_group_id_tab.FIRST .. g_group_id_tab.LAST
1624: LOOP
1625:
1626: IF (C_LEVEL_EVENT >= g_log_level) THEN
1627: trace('First time recover calling gl_journal_import_sla_pkg.delete_batches',C_LEVEL_EVENT,l_log_module);
1628: END IF;
1629:
1630: gl_journal_import_sla_pkg.delete_batches
1631: (x_je_source_name => g_je_source_name

Line 1630: gl_journal_import_sla_pkg.delete_batches

1626: IF (C_LEVEL_EVENT >= g_log_level) THEN
1627: trace('First time recover calling gl_journal_import_sla_pkg.delete_batches',C_LEVEL_EVENT,l_log_module);
1628: END IF;
1629:
1630: gl_journal_import_sla_pkg.delete_batches
1631: (x_je_source_name => g_je_source_name
1632: ,x_group_id => g_group_id_tab(i)
1633: );
1634:

Line 1646: trace('Calling gl_journal_import_sla_pkg.delete_batches',C_LEVEL_EVENT,l_log_module);

1642: trace('Looping for each group identifier ' ,C_LEVEL_STATEMENT,l_log_module);
1643: END IF;
1644: IF (g_primary_ledgers_tab(i).gllezl_request_id IS NOT NULL) THEN
1645: IF (C_LEVEL_EVENT >= g_log_level) THEN
1646: trace('Calling gl_journal_import_sla_pkg.delete_batches',C_LEVEL_EVENT,l_log_module);
1647: END IF;
1648: gl_journal_import_sla_pkg.delete_batches
1649: (x_je_source_name => g_je_source_name
1650: ,x_group_id => g_primary_ledgers_tab(i).group_id

Line 1648: gl_journal_import_sla_pkg.delete_batches

1644: IF (g_primary_ledgers_tab(i).gllezl_request_id IS NOT NULL) THEN
1645: IF (C_LEVEL_EVENT >= g_log_level) THEN
1646: trace('Calling gl_journal_import_sla_pkg.delete_batches',C_LEVEL_EVENT,l_log_module);
1647: END IF;
1648: gl_journal_import_sla_pkg.delete_batches
1649: (x_je_source_name => g_je_source_name
1650: ,x_group_id => g_primary_ledgers_tab(i).group_id
1651: );
1652: END IF;

Line 2584: -- Check if GL Journal Import should be submitted. Do not use multi table insert if

2580: trace('gl_interface_insert.Begin',C_LEVEL_PROCEDURE,l_log_module);
2581: trace('g_disable_gllezl_flag = '||g_disable_gllezl_flag,C_LEVEL_PROCEDURE,l_log_module);
2582: END IF;
2583:
2584: -- Check if GL Journal Import should be submitted. Do not use multi table insert if
2585: -- GL is not installed or for document level transfer.
2586:
2587: IF g_disable_gllezl_flag = 'Y' OR g_entity_id IS NOT NULL THEN
2588: g_gl_interface_table_name := 'GL_INTERFACE';

Line 3254: trace('Calling gl_journal_import_SLA_pkg.keep_batches ',C_LEVEL_EVENT,l_log_module);

3250: (p_secondary_ledger_id => g_primary_ledgers_tab(i).ledger_id
3251: );
3252: END IF;
3253: IF (g_log_enabled AND C_LEVEL_EVENT >= g_log_level) THEN
3254: trace('Calling gl_journal_import_SLA_pkg.keep_batches ',C_LEVEL_EVENT,l_log_module);
3255: END IF;
3256:
3257: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
3258: trace('p_submit_gl_post = ' || p_submit_gl_post,C_LEVEL_STATEMENT,l_log_module);

Line 3263: gl_journal_import_SLA_pkg.keep_batches

3259: trace('access_set_id = ' || g_all_ledgers_tab(l_ledger_id).access_set_id,C_LEVEL_STATEMENT,l_log_module);
3260: END IF;
3261:
3262: -- keep batches and submit GL post
3263: gl_journal_import_SLA_pkg.keep_batches
3264: (x_je_source_name => g_je_source_name
3265: ,x_group_id => g_primary_ledgers_tab(i).group_id
3266: ,start_posting => l_submit_post
3267: ,data_access_set_id => g_all_ledgers_tab(l_ledger_id).access_set_id

Line 3572: SELECT gl_journal_import_s.NEXTVAL

3568: -- Populate group id and inter_run_id;
3569: --
3570: --For bug fix 7677948
3571: IF g_caller = C_ACCTPROG_BATCH AND g_transfer_mode = 'COMBINED' THEN
3572: SELECT gl_journal_import_s.NEXTVAL
3573: INTO g_primary_ledgers_tab(i).interface_run_id
3574: FROM dual;
3575: ELSE
3576: SELECT gl_journal_import_s.NEXTVAL

Line 3576: SELECT gl_journal_import_s.NEXTVAL

3572: SELECT gl_journal_import_s.NEXTVAL
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;