APPS.AHL_VWP_TASKS_LINKS_PVT dependencies on AHL_VISIT_TASKS_B

Line 186: SELECT stage_id FROM ahl_visit_tasks_b

182:
183: --Get stage id for a given task
184: CURSOR c_get_stage_id(p_task_id IN NUMBER)
185: IS
186: SELECT stage_id FROM ahl_visit_tasks_b
187: WHERE visit_task_id = p_task_id;
188:
189: --Check if the task rule being created voilates the already defined stage rules
190: CURSOR c_validate_rules (p_parent_stage_id IN NUMBER, p_child_stage_id IN NUMBER)

Line 216: FROM ahl_visit_tasks_b

212:
213: CURSOR c_task_status(p_task_id IN NUMBER)
214: IS
215: select 'X'
216: FROM ahl_visit_tasks_b
217: WHERE visit_task_id = p_task_id
218: AND status_code = 'RELEASED';
219:
220: CURSOR c_task_type_code(p_task_id IN NUMBER)

Line 223: FROM ahl_visit_tasks_b

219:
220: CURSOR c_task_type_code(p_task_id IN NUMBER)
221: IS
222: select 'X'
223: FROM ahl_visit_tasks_b
224: WHERE visit_task_id = p_task_id
225: AND task_type_code = 'SUMMARY';
226:
227: -- As per latest Post 11.5.10 DLD if the task are in release status

Line 234: ahl_visit_tasks_b vt

230: /*CURSOR c_children_check_status(p_parent_visit_task_id IN NUMBER)
231: IS
232: SELECT 'X'
233: FROM ahl_task_links lin,
234: ahl_visit_tasks_b vt
235: WHERE lin.visit_task_id = vt.visit_task_id
236: AND vt.status_code = 'RELEASED'
237: START WITH lin.parent_task_id = p_parent_visit_task_id
238: CONNECT BY PRIOR lin.visit_task_id = lin.parent_task_id;

Line 243: FROM ahl_visit_tasks_b

239: */
240: CURSOR c_task_number(p_task_id IN NUMBER)
241: IS
242: SELECT VISIT_TASK_NUMBER
243: FROM ahl_visit_tasks_b
244: where visit_task_id = p_task_id;
245:
246: l_dummy VARCHAR2(1);
247: l_parent_task_number number;

Line 478: from AHL_VISIT_TASKS_B

474: FROM AHL_VISIT_TASKS_VL
475: WHERE VISIT_TASK_NUMBER=C_PARENT_TASK_NUMBER
476: AND SUMMARY_TASK_FLAG='N'
477: AND VISIT_ID = (select visit_id
478: from AHL_VISIT_TASKS_B
479: where VISIT_TASK_ID = c_visit_task_id);
480:
481: l_task_det get_task_info%rowtype;
482: BEGIN

Line 603: select VISIT_TASK_ID from AHL_VISIT_TASKS_B where visit_task_number = C_TASK_NUMBER and

599:
600: -- Modified by amagrawa
601: CURSOR CHECK_TASK_ID(C_TASK_NUMBER IN NUMBER, C_TASK_ID IN NUMBER)
602: IS
603: select VISIT_TASK_ID from AHL_VISIT_TASKS_B where visit_task_number = C_TASK_NUMBER and
604: visit_id = (select visit_id from ahl_visit_tasks_b where visit_task_id = C_TASK_ID );
605:
606: -- Added by tchimira for VWPE 12730539
607: CURSOR VALIDATE_TASK_ID(C_TASK_ID IN NUMBER)

Line 604: visit_id = (select visit_id from ahl_visit_tasks_b where visit_task_id = C_TASK_ID );

600: -- Modified by amagrawa
601: CURSOR CHECK_TASK_ID(C_TASK_NUMBER IN NUMBER, C_TASK_ID IN NUMBER)
602: IS
603: select VISIT_TASK_ID from AHL_VISIT_TASKS_B where visit_task_number = C_TASK_NUMBER and
604: visit_id = (select visit_id from ahl_visit_tasks_b where visit_task_id = C_TASK_ID );
605:
606: -- Added by tchimira for VWPE 12730539
607: CURSOR VALIDATE_TASK_ID(C_TASK_ID IN NUMBER)
608: IS

Line 609: select VISIT_TASK_ID from AHL_VISIT_TASKS_B

605:
606: -- Added by tchimira for VWPE 12730539
607: CURSOR VALIDATE_TASK_ID(C_TASK_ID IN NUMBER)
608: IS
609: select VISIT_TASK_ID from AHL_VISIT_TASKS_B
610: where visit_task_id = C_TASK_ID;
611:
612: --Added below two lines by tchimira for VWP ER-12424063 on 14-FEB-2011
613: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Task_Links';

Line 879: FROM AHL_VISIT_TASKS_B

875: -- for finding the status of a task. Added in 11.5.10
876: -- amagrawa Modified the cursor declaration based on review comments.
877: CURSOR task_status_csr(p_task_id IN NUMBER) IS
878: SELECT STATUS_CODE
879: FROM AHL_VISIT_TASKS_B
880: WHERE VISIT_TASK_ID=p_task_id;
881: -- AND VISIT_TASK_NUMBER= p_task_no ;
882:
883: -- Cursor find all details about visit

Line 887: SELECT visit_id FROM AHL_VISIT_TASKS_B

883: -- Cursor find all details about visit
884: CURSOR c_Visit (p_task_id IN NUMBER) IS
885: SELECT Any_Task_Chg_Flag,visit_id FROM Ahl_Visits_VL
886: WHERE VISIT_ID = (
887: SELECT visit_id FROM AHL_VISIT_TASKS_B
888: WHERE visit_task_id = p_task_id
889: );
890:
891: l_visit_csr_rec c_Visit%ROWTYPE;