APPS.CAC_TASK_PURGE_PVT dependencies on JTF_TASK_CONTACTS

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

1737: -- Statement level Logging
1738: ----------------------------
1739: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1740: THEN
1741: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_CONTACTS');
1742: END IF;
1743:
1744:
1745: --Delete data from JTF_TASK_CONTACTS table

Line 1745: --Delete data from JTF_TASK_CONTACTS table

1741: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_CONTACTS');
1742: END IF;
1743:
1744:
1745: --Delete data from JTF_TASK_CONTACTS table
1746: Forall j In l_tab_task_id.FIRST..l_tab_task_id.LAST
1747: Delete JTF_TASK_CONTACTS
1748: Where task_id = l_tab_task_id(j)
1749: --Added By MPADHIAR for Bug#5216358

Line 1747: Delete JTF_TASK_CONTACTS

1743:
1744:
1745: --Delete data from JTF_TASK_CONTACTS table
1746: Forall j In l_tab_task_id.FIRST..l_tab_task_id.LAST
1747: Delete JTF_TASK_CONTACTS
1748: Where task_id = l_tab_task_id(j)
1749: --Added By MPADHIAR for Bug#5216358
1750: Returning task_contact_id Bulk Collect Into l_tab_task_contact_id;
1751:

Line 1772: WHERE owner_table_name = 'JTF_TASK_CONTACTS'

1768: IF l_tab_task_contact_id.COUNT > 0 THEN
1769: --Delete data from JTF_TASK_PHONES table for phone created for Task Contact
1770: Forall j In l_tab_task_contact_id.FIRST..l_tab_task_contact_id.LAST
1771: Delete JTF_TASK_PHONES
1772: WHERE owner_table_name = 'JTF_TASK_CONTACTS'
1773: AND task_contact_id = l_tab_task_contact_id(j);
1774: END IF;
1775: --Added By MPADHIAR for Bug#5216358 Ends here
1776: