APPS.AHL_VWP_RULES_PVT dependencies on AHL_TASK_LINKS

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

2007: 'Value of precedence constraint is ' || l_prec_constraint);
2008: END IF;
2009:
2010: IF l_tsk_flag = 'Y' THEN
2011: SELECT ahl_task_links_s.nextval INTO l_task_link_id FROM DUAL;
2012:
2013: IF l_task_rec.attribute_category = Fnd_Api.G_MISS_CHAR THEN
2014: l_task_rec.attribute_category := NULL;
2015: END IF;

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

2076:
2077: IF (l_log_statement >= l_log_current_level) THEN
2078: fnd_log.string(l_log_statement,
2079: L_DEBUG_KEY,
2080: 'Before inserting record into AHL_TASK_LINKS');
2081: END IF;
2082: --Added new 'PRECEDENCE_CONSTRAINT'column by tchimira -VWP ER-12424063
2083: INSERT INTO AHL_TASK_LINKS
2084: (

Line 2083: INSERT INTO AHL_TASK_LINKS

2079: L_DEBUG_KEY,
2080: 'Before inserting record into AHL_TASK_LINKS');
2081: END IF;
2082: --Added new 'PRECEDENCE_CONSTRAINT'column by tchimira -VWP ER-12424063
2083: INSERT INTO AHL_TASK_LINKS
2084: (
2085: TASK_LINK_ID,OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2086: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, VISIT_TASK_ID, PARENT_TASK_ID,
2087: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4,

Line 2106: 'After inserting record into AHL_TASK_LINKS and before calling VALIDATE_VWP_LINKS');

2102:
2103: IF (l_log_statement >= l_log_current_level) THEN
2104: fnd_log.string(l_log_statement,
2105: L_DEBUG_KEY,
2106: 'After inserting record into AHL_TASK_LINKS and before calling VALIDATE_VWP_LINKS');
2107: END IF;
2108: -- VWPE ER-12424063:: tchimira :: 31-MAY-2011:: start
2109: -- We need to validate already inserted task rule such that child task's stage does not
2110: -- start before parent task's stage.

Line 4335: SELECT 'X' FROM ahl_task_links

4331: AND tsk.stage_id = p_stage_id
4332: AND tsk.status_code <> 'DELETED';
4333:
4334: Cursor check_rule_exists (p_visit_task_id IN NUMBER, p_parent_task_id IN NUMBER) IS
4335: SELECT 'X' FROM ahl_task_links
4336: WHERE visit_task_id = p_visit_task_id
4337: AND parent_task_id = p_parent_task_id;
4338: l_dummy VARCHAR2(1);
4339: begin

Line 5448: SELECT 'X' FROM AHL_TASK_LINKS

5444: -- SATRAJEN :: Bug 13054370 :: Task which is a dependent task should not be duplicated.
5445: -- cursor to validate the given task is already a dependent task or not.
5446: CURSOR validate_dep_csr (c_task_id NUMBER)
5447: IS
5448: SELECT 'X' FROM AHL_TASK_LINKS
5449: WHERE parent_task_id = c_task_id
5450: OR visit_task_id = c_task_id;
5451: -- End of Bug 13054370
5452: -- cursor to validate if route for the task has its Duplicate Flag set and Return to Supply flag not set.