DBA Data[Home] [Help]

APPS.XLA_TRANSFER_PKG dependencies on XLA_TRANSFER_LOGS

Line 401: INSERT INTO xla_transfer_logs

397: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
398: trace('Inserting a row into the transfer to GL log table.',C_LEVEL_STATEMENT,l_Log_module);
399: END IF;
400:
401: INSERT INTO xla_transfer_logs
402: (
403: application_id
404: ,ledger_id
405: ,parent_group_id

Line 546: UPDATE xla_transfer_logs

542: END LOOP;
543: END IF;
544: g_gllezl_requests_tab(p_ledger_id) := l_gllezl_request_id;
545:
546: UPDATE xla_transfer_logs
547: SET gllezl_request_id = l_gllezl_request_id
548: WHERE group_id = g_group_id;
549: END IF;
550: COMMIT;

Line 1033: FROM xla_transfer_logs xtb1

1029: ,gllezl_request_id
1030: BULK COLLECT INTO
1031: g_group_id_tab
1032: ,g_gllezl_requests_tab
1033: FROM xla_transfer_logs xtb1
1034: WHERE application_id = g_application_id
1035: AND request_id NOT IN
1036: ( SELECT xtb.request_id
1037: FROM xla_transfer_logs xtb

Line 1037: FROM xla_transfer_logs xtb

1033: FROM xla_transfer_logs xtb1
1034: WHERE application_id = g_application_id
1035: AND request_id NOT IN
1036: ( SELECT xtb.request_id
1037: FROM xla_transfer_logs xtb
1038: ,fnd_concurrent_requests fcr
1039: WHERE xtb.application_id = g_application_id
1040: AND xtb.transfer_status_code = 'INCOMPLETE'
1041: --AND xtb.gllezl_request_id IS NOT NULL

Line 1073: trace('Deleting rows from xla_transfer_logs ',C_LEVEL_STATEMENT,l_log_module);

1069: trace(SQL%ROWCOUNT || ' Headers updated.',C_LEVEL_STATEMENT,l_log_module);
1070: --
1071: -- Delete log entries
1072: --
1073: trace('Deleting rows from xla_transfer_logs ',C_LEVEL_STATEMENT,l_log_module);
1074: END IF;
1075: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1076: DELETE xla_transfer_logs
1077: WHERE group_id = g_group_id_tab(i);

Line 1076: DELETE xla_transfer_logs

1072: --
1073: trace('Deleting rows from xla_transfer_logs ',C_LEVEL_STATEMENT,l_log_module);
1074: END IF;
1075: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1076: DELETE xla_transfer_logs
1077: WHERE group_id = g_group_id_tab(i);
1078:
1079: --
1080: -- Delete XLA_TRANSFER_LEDGERS

Line 2371: DELETE xla_transfer_logs

2367: trace('Deleting rows from the transfer log.',C_LEVEL_STATEMENT,l_log_module);
2368: END IF;
2369:
2370: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
2371: DELETE xla_transfer_logs
2372: WHERE group_id = g_group_id_tab(i);
2373:
2374: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2375: trace('delete_transfer_log.End',C_LEVEL_PROCEDURE,l_log_module);