APPS.AHL_VWP_RULES_PVT dependencies on AHL_TASK_LINKS

Line 1774: SELECT ahl_task_links_s.nextval INTO l_task_link_id FROM DUAL;

1770: 'Value of L_TSK_FLAG after task type check' || l_tsk_flag);
1771: END IF;
1772:
1773: IF l_tsk_flag = 'Y' THEN
1774: SELECT ahl_task_links_s.nextval INTO l_task_link_id FROM DUAL;
1775:
1776: IF l_task_rec.attribute_category = Fnd_Api.G_MISS_CHAR THEN
1777: l_task_rec.attribute_category := NULL;
1778: END IF;

Line 1843: 'Before inserting record into AHL_TASK_LINKS');

1839:
1840: IF (l_log_statement >= l_log_current_level) THEN
1841: fnd_log.string(l_log_statement,
1842: L_DEBUG_KEY,
1843: 'Before inserting record into AHL_TASK_LINKS');
1844: END IF;
1845:
1846: INSERT INTO AHL_TASK_LINKS
1847: (

Line 1846: INSERT INTO AHL_TASK_LINKS

1842: L_DEBUG_KEY,
1843: 'Before inserting record into AHL_TASK_LINKS');
1844: END IF;
1845:
1846: INSERT INTO AHL_TASK_LINKS
1847: (
1848: TASK_LINK_ID,OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1849: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, VISIT_TASK_ID, PARENT_TASK_ID,
1850: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4,

Line 1869: 'After inserting record into AHL_TASK_LINKS');

1865:
1866: IF (l_log_statement >= l_log_current_level) THEN
1867: fnd_log.string(l_log_statement,
1868: L_DEBUG_KEY,
1869: 'After inserting record into AHL_TASK_LINKS');
1870: END IF;
1871: END IF; -- -- End of check l_tsk_flag = 'Y'
1872: END LOOP;
1873: CLOSE c_route_seq;