DBA Data[Home] [Help]

APPS.XLA_TRANSFER_PKG dependencies on XLA_TRANSFER_LEDGERS

Line 1596: -- Delete XLA_TRANSFER_LEDGERS

1592: DELETE xla_transfer_logs
1593: WHERE group_id = g_group_id_tab(i);
1594:
1595: --
1596: -- Delete XLA_TRANSFER_LEDGERS
1597: --
1598:
1599: trace('Deleting rows from XLA_TRANSFER_LEDGERS',C_LEVEL_STATEMENT,l_log_module);
1600: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST

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

1595: --
1596: -- Delete XLA_TRANSFER_LEDGERS
1597: --
1598:
1599: trace('Deleting rows from XLA_TRANSFER_LEDGERS',C_LEVEL_STATEMENT,l_log_module);
1600: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1601: DELETE xla_transfer_ledgers
1602: WHERE group_id = g_group_id_tab(i);
1603:

Line 1601: DELETE xla_transfer_ledgers

1597: --
1598:
1599: trace('Deleting rows from XLA_TRANSFER_LEDGERS',C_LEVEL_STATEMENT,l_log_module);
1600: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1601: DELETE xla_transfer_ledgers
1602: WHERE group_id = g_group_id_tab(i);
1603:
1604: IF SQL%NOTFOUND THEN
1605: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

1602: WHERE group_id = g_group_id_tab(i);
1603:
1604: IF SQL%NOTFOUND THEN
1605: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1606: trace('No rows found in the XLA_TRANSFER_LEDGERS table.',C_LEVEL_STATEMENT,l_log_module);
1607: END IF;
1608: ELSE
1609: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1610: trace(SQL%ROWCOUNT || 'Rows deleted from the XLA_TRANSFER_LEDGERS',C_LEVEL_STATEMENT,l_log_module);

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

1606: trace('No rows found in the XLA_TRANSFER_LEDGERS table.',C_LEVEL_STATEMENT,l_log_module);
1607: END IF;
1608: ELSE
1609: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1610: trace(SQL%ROWCOUNT || 'Rows deleted from the XLA_TRANSFER_LEDGERS',C_LEVEL_STATEMENT,l_log_module);
1611: END IF;
1612: END IF;
1613:
1614:

Line 3121: INSERT INTO xla_transfer_ledgers

3117:
3118: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3119: trace('insert_secondary_ledgers.End',C_LEVEL_PROCEDURE,l_log_module);
3120: END IF;
3121: INSERT INTO xla_transfer_ledgers
3122: (GROUP_ID
3123: ,SECONDARY_LEDGER_ID
3124: ,PRIMARY_LEDGER_ID
3125: ,CREATION_DATE

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

3242: END IF;
3243:
3244: IF (g_primary_ledgers_tab(i).ledger_category_code = 'SECONDARY') THEN
3245: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3246: trace('Inserting a row into the XLA_TRANSFER_LEDGERS table.',C_LEVEL_STATEMENT,l_log_module);
3247: END IF;
3248:
3249: insert_secondary_ledgers
3250: (p_secondary_ledger_id => g_primary_ledgers_tab(i).ledger_id