APPS.CAC_TASK_PURGE_PVT dependencies on JTF_TASK_DEPENDS

Line 38: | JTF_TASK_DEPENDS for bug# 5388975 |

34: | fnd_concurrent_programs_U1,instead|
35: | of fnd_concurrent_programs_U2 |
36: | 13-Jul-2006 Swapan Barat Checking template_flag <> 'Y' |
37: | before removing records from |
38: | JTF_TASK_DEPENDS for bug# 5388975 |
39: +======================================================================*/
40:
41: Procedure PURGE_STANDALONE_TASKS (
42: errbuf OUT NOCOPY VARCHAR2,

Line 1724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_DEPENDS');

1720: -- Statement level Logging
1721: ----------------------------
1722: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1723: THEN
1724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_DEPENDS');
1725: END IF;
1726:
1727:
1728: --Delete data from JTF_TASK_DEPENDS table

Line 1728: --Delete data from JTF_TASK_DEPENDS table

1724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_DEPENDS');
1725: END IF;
1726:
1727:
1728: --Delete data from JTF_TASK_DEPENDS table
1729: Forall j In l_tab_task_id.FIRST..l_tab_task_id.LAST
1730: Delete JTF_TASK_DEPENDS
1731: Where NVL(template_flag, 'N') <> 'Y' -- Added for bug# 5388975
1732: AND (task_id = l_tab_task_id(j)

Line 1730: Delete JTF_TASK_DEPENDS

1726:
1727:
1728: --Delete data from JTF_TASK_DEPENDS table
1729: Forall j In l_tab_task_id.FIRST..l_tab_task_id.LAST
1730: Delete JTF_TASK_DEPENDS
1731: Where NVL(template_flag, 'N') <> 'Y' -- Added for bug# 5388975
1732: AND (task_id = l_tab_task_id(j)
1733: or dependent_on_task_id = l_tab_task_id(j));
1734: