APPS.XLA_TRANSFER_PKG dependencies on XLA_TRANSFER_LOGS

Line 837: INSERT INTO xla_transfer_logs

833: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
834: trace('Inserting a row into the transfer to GL log table.',C_LEVEL_STATEMENT,l_Log_module);
835: END IF;
836:
837: INSERT INTO xla_transfer_logs
838: (
839: application_id
840: ,ledger_id
841: ,parent_group_id

Line 982: UPDATE xla_transfer_logs

978: END LOOP;
979: END IF;
980: g_gllezl_requests_tab(p_ledger_id) := l_gllezl_request_id;
981:
982: UPDATE xla_transfer_logs
983: SET gllezl_request_id = l_gllezl_request_id
984: WHERE group_id = g_group_id;
985: END IF;
986: COMMIT;

Line 1489: FROM xla_transfer_logs xtb1

1485: ,gllezl_request_id
1486: BULK COLLECT INTO
1487: g_group_id_tab
1488: ,g_gllezl_requests_tab
1489: FROM xla_transfer_logs xtb1
1490: WHERE application_id = g_application_id
1491: AND request_id NOT IN
1492: ( SELECT xtb.request_id
1493: FROM xla_transfer_logs xtb

Line 1493: FROM xla_transfer_logs xtb

1489: FROM xla_transfer_logs xtb1
1490: WHERE application_id = g_application_id
1491: AND request_id NOT IN
1492: ( SELECT xtb.request_id
1493: FROM xla_transfer_logs xtb
1494: ,fnd_concurrent_requests fcr
1495: WHERE xtb.application_id = g_application_id
1496: AND xtb.transfer_status_code = 'INCOMPLETE'
1497: --AND xtb.gllezl_request_id IS NOT NULL

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

1585: trace(SQL%ROWCOUNT || ' Headers updated.',C_LEVEL_STATEMENT,l_log_module);
1586: --
1587: -- Delete log entries
1588: --
1589: trace('Deleting rows from xla_transfer_logs ',C_LEVEL_STATEMENT,l_log_module);
1590: END IF;
1591: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1592: DELETE xla_transfer_logs
1593: WHERE group_id = g_group_id_tab(i);

Line 1592: DELETE xla_transfer_logs

1588: --
1589: trace('Deleting rows from xla_transfer_logs ',C_LEVEL_STATEMENT,l_log_module);
1590: END IF;
1591: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1592: DELETE xla_transfer_logs
1593: WHERE group_id = g_group_id_tab(i);
1594:
1595: --
1596: -- Delete XLA_TRANSFER_LEDGERS

Line 3078: DELETE xla_transfer_logs

3074: trace('Deleting rows from the transfer log.',C_LEVEL_STATEMENT,l_log_module);
3075: END IF;
3076:
3077: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
3078: DELETE xla_transfer_logs
3079: WHERE group_id = g_group_id_tab(i);
3080:
3081: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3082: trace('delete_transfer_log.End',C_LEVEL_PROCEDURE,l_log_module);