DBA Data[Home] [Help]

APPS.XLA_TRANSFER_PKG dependencies on XLA_TRANSFER_LEDGERS

Line 1080: -- Delete XLA_TRANSFER_LEDGERS

1076: DELETE xla_transfer_logs
1077: WHERE group_id = g_group_id_tab(i);
1078:
1079: --
1080: -- Delete XLA_TRANSFER_LEDGERS
1081: --
1082:
1083: trace('Deleting rows from XLA_TRANSFER_LEDGERS',C_LEVEL_STATEMENT,l_log_module);
1084: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST

Line 1083: trace('Deleting rows from XLA_TRANSFER_LEDGERS',C_LEVEL_STATEMENT,l_log_module);

1079: --
1080: -- Delete XLA_TRANSFER_LEDGERS
1081: --
1082:
1083: trace('Deleting rows from XLA_TRANSFER_LEDGERS',C_LEVEL_STATEMENT,l_log_module);
1084: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1085: DELETE xla_transfer_ledgers
1086: WHERE group_id = g_group_id_tab(i);
1087:

Line 1085: DELETE xla_transfer_ledgers

1081: --
1082:
1083: trace('Deleting rows from XLA_TRANSFER_LEDGERS',C_LEVEL_STATEMENT,l_log_module);
1084: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1085: DELETE xla_transfer_ledgers
1086: WHERE group_id = g_group_id_tab(i);
1087:
1088: IF SQL%NOTFOUND THEN
1089: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1090: trace('No rows found in the XLA_TRANSFER_LEDGERS table.',C_LEVEL_STATEMENT,l_log_module);

1086: WHERE group_id = g_group_id_tab(i);
1087:
1088: IF SQL%NOTFOUND THEN
1089: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1090: trace('No rows found in the XLA_TRANSFER_LEDGERS table.',C_LEVEL_STATEMENT,l_log_module);
1091: END IF;
1092: ELSE
1093: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1094: trace(SQL%ROWCOUNT || 'Rows deleted from the XLA_TRANSFER_LEDGERS',C_LEVEL_STATEMENT,l_log_module);

Line 1094: trace(SQL%ROWCOUNT || 'Rows deleted from the XLA_TRANSFER_LEDGERS',C_LEVEL_STATEMENT,l_log_module);

1090: trace('No rows found in the XLA_TRANSFER_LEDGERS table.',C_LEVEL_STATEMENT,l_log_module);
1091: END IF;
1092: ELSE
1093: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1094: trace(SQL%ROWCOUNT || 'Rows deleted from the XLA_TRANSFER_LEDGERS',C_LEVEL_STATEMENT,l_log_module);
1095: END IF;
1096: END IF;
1097:
1098: --

Line 2414: INSERT INTO xla_transfer_ledgers

2410:
2411: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2412: trace('insert_secondary_ledgers.End',C_LEVEL_PROCEDURE,l_log_module);
2413: END IF;
2414: INSERT INTO xla_transfer_ledgers
2415: (GROUP_ID
2416: ,SECONDARY_LEDGER_ID
2417: ,PRIMARY_LEDGER_ID
2418: ,CREATION_DATE

Line 2506: trace('Inserting a row into the XLA_TRANSFER_LEDGERS table.',C_LEVEL_STATEMENT,l_log_module);

2502: END IF;
2503:
2504: IF (g_primary_ledgers_tab(i).ledger_category_code = 'SECONDARY') THEN
2505: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2506: trace('Inserting a row into the XLA_TRANSFER_LEDGERS table.',C_LEVEL_STATEMENT,l_log_module);
2507: END IF;
2508:
2509: insert_secondary_ledgers
2510: (p_secondary_ledger_id => g_primary_ledgers_tab(i).ledger_id