APPS.CAC_TASK_PURGE_PVT dependencies on JTF_TASK_RECUR_RULES

Line 1925: --Delete data from JTF_TASK_RECUR_RULES table

1921: Delete JTF_TASKS_TL
1922: Where task_id = l_tab_task_id(j);
1923:
1924:
1925: --Delete data from JTF_TASK_RECUR_RULES table
1926: IF l_tab_rec_rule_id.COUNT > 0
1927: THEN
1928:
1929: ----------------------------

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

1930: -- Statement level Logging
1931: ----------------------------
1932: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1933: THEN
1934: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_RECUR_RULES');
1935: END IF;
1936:
1937:
1938: Forall j In l_tab_rec_rule_id.FIRST..l_tab_rec_rule_id.LAST

Line 1939: Delete JTF_TASK_RECUR_RULES

1935: END IF;
1936:
1937:
1938: Forall j In l_tab_rec_rule_id.FIRST..l_tab_rec_rule_id.LAST
1939: Delete JTF_TASK_RECUR_RULES
1940: Where recurrence_rule_id = l_tab_rec_rule_id(j)
1941: And l_tab_rec_rule_id(j) IS NOT NULL
1942: And NOT EXISTS (Select task_id From JTF_TASKS_B
1943: Where recurrence_rule_id = l_tab_rec_rule_id(j));