DBA Data[Home] [Help]

APPS.CAC_TASK_PURGE_PVT dependencies on JTF_TASK_PHONES

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

1753: -- Statement level Logging
1754: ----------------------------
1755: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1756: THEN
1757: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_PHONES');
1758: END IF;
1759:
1760:
1761: --Delete data from JTF_TASK_PHONES table

Line 1761: --Delete data from JTF_TASK_PHONES table

1757: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_PHONES');
1758: END IF;
1759:
1760:
1761: --Delete data from JTF_TASK_PHONES table
1762: Forall j In l_tab_task_id.FIRST..l_tab_task_id.LAST
1763: Delete JTF_TASK_PHONES
1764: WHERE owner_table_name = 'JTF_TASKS_B'
1765: AND task_contact_id = l_tab_task_id(j);

Line 1763: Delete JTF_TASK_PHONES

1759:
1760:
1761: --Delete data from JTF_TASK_PHONES table
1762: Forall j In l_tab_task_id.FIRST..l_tab_task_id.LAST
1763: Delete JTF_TASK_PHONES
1764: WHERE owner_table_name = 'JTF_TASKS_B'
1765: AND task_contact_id = l_tab_task_id(j);
1766:
1767: --Added By MPADHIAR for Bug#5216358

Line 1769: --Delete data from JTF_TASK_PHONES table for phone created for Task Contact

1765: AND task_contact_id = l_tab_task_id(j);
1766:
1767: --Added By MPADHIAR for Bug#5216358
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);

Line 1771: Delete JTF_TASK_PHONES

1767: --Added By MPADHIAR for Bug#5216358
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