eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VISIT_TASKS_B

Line 50: -- To find out the Visit_Task_Number for the AHL_Visit_Tasks_B table

46: -- To find out the Visit_Number for the AHL_Visits_B table
47: FUNCTION Get_Visit_Number
48: RETURN NUMBER;
49:
50: -- To find out the Visit_Task_Number for the AHL_Visit_Tasks_B table
51: FUNCTION Get_Visit_Task_Number (p_visit_id IN NUMBER)
52: RETURN NUMBER;
53:
54: -- PRAKKUM :: VWPE: ER:12424063 :: 01-FEB-2011

Line 227: FROM Ahl_Visit_Tasks_B

223: -- Define local Cursors
224: -- To find whether a visit exists
225: CURSOR c_visit (x_id IN NUMBER) IS
226: SELECT COUNT(*)
227: FROM Ahl_Visit_Tasks_B
228: WHERE VISIT_ID = x_id
229: AND NVL(STATUS_CODE,'X') <> 'DELETED';
230:
231: -- To find the total number of tasks for a visit

Line 234: FROM Ahl_Visit_Tasks_B

230:
231: -- To find the total number of tasks for a visit
232: CURSOR c_visit_task (x_id IN NUMBER) IS
233: SELECT COUNT(*)
234: FROM Ahl_Visit_Tasks_B
235: WHERE VISIT_ID = x_id
236: AND UNIT_EFFECTIVITY_ID IS NOT NULL
237: AND NVL(STATUS_CODE,'X') <> 'DELETED';
238:

Line 242: FROM ahl_unit_effectivities_vl T1, ahl_visit_tasks_b T2

238:
239: -- To find due date for a visit related with tasks
240: CURSOR c_due_date (x_id IN NUMBER) IS
241: SELECT MIN(T1.due_date)
242: FROM ahl_unit_effectivities_vl T1, ahl_visit_tasks_b T2
243: WHERE T1.unit_effectivity_id = T2.unit_effectivity_id
244: AND T1.due_date IS NOT NULL AND T2.visit_id = x_id;
245:
246: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Due_by_Date';

Line 641: FROM Ahl_Visit_Tasks_B

637:
638: -- To find maximum visit task nubmer among all tasks for a particular visit
639: CURSOR c_task_number IS
640: SELECT MAX(visit_task_number)
641: FROM Ahl_Visit_Tasks_B
642: WHERE Visit_Id = p_visit_id;
643:
644: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Visit_Task_Number';
645: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;

Line 730: FROM AHL_VISIT_TASKS_B

726:
727: -- Cursor to get planned UEs for the given visit
728: CURSOR get_visit_planned_ues (c_visit_id NUMBER) IS
729: SELECT distinct unit_effectivity_id
730: FROM AHL_VISIT_TASKS_B
731: WHERE visit_id = c_visit_id
732: AND task_type_code = 'PLANNED';
733:
734: -- yazhou end

Line 2903: FROM AHL_VISIT_TASKS_B

2899: ATTRIBUTE14,
2900: ATTRIBUTE15
2901: FROM AHL_TASK_LINKS
2902: WHERE visit_task_id in ( SELECT VISIT_TASK_ID
2903: FROM AHL_VISIT_TASKS_B
2904: WHERE visit_id = x_visit_id);
2905:
2906: l_task_link_rec c_visit_task_links%ROWTYPE;
2907:

Line 2911: FROM AHL_VISIT_TASKS_B a, AHL_VISIT_TASKS_B b

2907:
2908: -- To find the coresponding task id in the new visit
2909: CURSOR c_new_task_ID(x_visit_task_id IN NUMBER, x_new_visit_id IN NUMBER) IS
2910: SELECT b.VISIT_TASK_ID
2911: FROM AHL_VISIT_TASKS_B a, AHL_VISIT_TASKS_B b
2912: WHERE a.visit_task_id = x_visit_task_id
2913: AND a.visit_task_number = b.visit_task_number
2914: AND b.visit_id = x_new_visit_id;
2915:

Line 3511: FROM ahl_visit_tasks_b

3507: -- Added this cursor to fetch visit task past dates for non-summary tasks
3508: Cursor get_visit_task_past_dates (c_visit_id IN NUMBER)
3509: IS
3510: SELECT MIN(past_task_start_date) past_task_start_date, MAX(past_task_end_date) past_task_end_date
3511: FROM ahl_visit_tasks_b
3512: WHERE visit_id = c_visit_id
3513: AND task_type_code <> 'SUMMARY'
3514: AND PAST_TASK_START_DATE IS NOT NULL
3515: AND STATUS_CODE NOT IN ('DELETED','CANCELLED');

Line 3555: FROM ahl_visit_tasks_b task

3551: -- TCHIMIRA ::28-JUN-2011 :: VWP: ER:12673125 :: START
3552: -- Cursor to fetch mr_id of a task
3553: CURSOR get_sum_task_det(c_visit_id IN NUMBER ) IS
3554: SELECT mr_id, unit_effectivity_id,instance_id
3555: FROM ahl_visit_tasks_b task
3556: WHERE visit_id = c_visit_id
3557: AND status_code = 'PLANNING'
3558: AND task_type_code = 'SUMMARY'
3559: AND mr_id IS NOT NULL;

Line 4223: UPDATE AHL_VISIT_TASKS_B

4219: FETCH c_task INTO c_task_rec;
4220: EXIT WHEN c_task%NOTFOUND;
4221: -- Tasks found for visit
4222: -- To update department_id to NULL when visit's organization is changed
4223: UPDATE AHL_VISIT_TASKS_B
4224: SET DEPARTMENT_ID = NULL,
4225: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1
4226: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id
4227: AND DEPARTMENT_ID IS NOT NULL;

Line 4852: UPDATE AHL_VISIT_TASKS_B

4848: FETCH c_task INTO c_task_rec;
4849: EXIT WHEN c_task%NOTFOUND;
4850: -- Tasks found for visit
4851: -- To set prices to NULL in case if the visit's department is changed
4852: UPDATE AHL_VISIT_TASKS_B
4853: SET ACTUAL_PRICE = NULL,
4854: ESTIMATED_PRICE = NULL,
4855: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1
4856: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id;

Line 5125: AHL_VISIT_TASKS_B

5121: END IF;
5122:
5123: -- Remove the originating task association of the deleted task
5124: UPDATE
5125: AHL_VISIT_TASKS_B
5126: SET
5127: ORIGINATING_TASK_ID=NULL,
5128: OBJECT_VERSION_NUMBER = object_version_number + 1
5129: WHERE

Line 5135: AHL_VISIT_TASKS_B

5131:
5132:
5133: -- Remove Cost parent associations for this task
5134: UPDATE
5135: AHL_VISIT_TASKS_B
5136: SET
5137: COST_PARENT_ID = NULL,
5138: OBJECT_VERSION_NUMBER = object_version_number + 1
5139: WHERE

Line 5145: AHL_VISIT_TASKS_B

5141:
5142:
5143: -- Remove Primary Task Associations in simulation visit for the deleted Task
5144: UPDATE
5145: AHL_VISIT_TASKS_B
5146: SET
5147: PRIMARY_VISIT_TASK_ID = NULL,
5148: OBJECT_VERSION_NUMBER = object_version_number + 1
5149: WHERE

Line 5603: DELETE FROM ahl_visit_tasks_b

5599: END IF;
5600:
5601: END IF; -- if l_is_comp_visit = 'N'
5602:
5603: DELETE FROM ahl_visit_tasks_b
5604: WHERE visit_id = p_visit_id;
5605:
5606: --Delete the visit
5607: AHL_VISITS_PKG.Delete_Row( x_visit_id => p_visit_id);

Line 6336: FROM ahl_unit_effectivities_b UE, ahl_visit_tasks_b VT

6332: -- If there are any which is in wrong status, can not close visit
6333: -- PLANNED tasks can not be canncelled. UMP enforcing that rule
6334: CURSOR get_ue_tasks_csr (p_visit_id IN NUMBER) IS
6335: SELECT UE.unit_effectivity_id
6336: FROM ahl_unit_effectivities_b UE, ahl_visit_tasks_b VT
6337: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
6338: AND nvl(UE.status_code,'x') NOT IN
6339: -- Change by jaramana on 09-MAR-2011
6340: -- Included 'MR-TERMINATE' for bug 11848364

Line 6369: FROM ahl_workorders wo, ahl_visit_tasks_b task

6365: -- SKPATHAK :: 20-JUN-2011 :: VWPE: ER:12673125
6366: CURSOR get_default_stage_wo (c_visit_id IN NUMBER)
6367: IS
6368: SELECT wo.workorder_id
6369: FROM ahl_workorders wo, ahl_visit_tasks_b task
6370: WHERE task.visit_task_id = wo.visit_task_id
6371: AND task.visit_id = c_visit_id
6372: AND task.task_type_code = 'STAGE'
6373: AND task.stage_id IS NULL;

Line 6561: UPDATE ahl_visit_tasks_b

6557: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Updating the actual cost of WO to - '||l_actual_cost);
6558: END IF;
6559:
6560: -- Update with actual cost
6561: UPDATE ahl_visit_tasks_b
6562: SET actual_cost = l_actual_cost,
6563: object_version_number = l_wip_entity_rec.object_version_number + 1
6564: WHERE visit_task_id = l_wip_entity_rec.visit_task_id;
6565:

Line 6601: UPDATE ahl_visit_tasks_b

6597: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After Calling AHL_VWP_COST_PVT.Get_WO_Cost : l_return_status - '||l_return_status||' : l_actual_cost - '||l_actual_cost);
6598: END IF;
6599:
6600: --Update task record with actual cost
6601: UPDATE ahl_visit_tasks_b
6602: SET actual_cost = l_actual_cost,
6603: object_version_number = l_summ_task_rec.object_version_number + 1
6604: WHERE visit_task_id = l_summ_task_rec.visit_task_id;
6605:

Line 6668: UPDATE AHL_VISIT_TASKS_B

6664: LOOP
6665: FETCH c_task INTO c_task_rec;
6666: EXIT WHEN c_task%NOTFOUND;
6667:
6668: UPDATE AHL_VISIT_TASKS_B
6669: SET STATUS_CODE = 'CLOSED',
6670: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1,
6671: --TCHIMIRA::FP BUG 12668460 for BUG 12607498 ::14-JUN-2011::UPDATE WHO COLUMNS
6672: LAST_UPDATE_DATE = SYSDATE,

Line 6844: SELECT distinct service_request_id FROM AHL_VISIT_TASKS_B

6840: -- yazhou start
6841: -- To find all the SRs associated to a visit
6842: -- Modified by Sjayacha to check if its not null.
6843: CURSOR c_service_request (x_visit_id IN NUMBER) IS
6844: SELECT distinct service_request_id FROM AHL_VISIT_TASKS_B
6845: WHERE VISIT_ID = x_visit_id
6846: AND service_request_id IS NOT NULL
6847: AND NVL(STATUS_CODE,'X') <> 'DELETED';
6848:

Line 6853: from ahl_visits_b a, ahl_visit_tasks_b b

6849: -- To check if any other active visits have this SR associated
6850: CURSOR c_check_SR (x_visit_id IN NUMBER, x_sr_id IN NUMBER) IS
6851: SELECT 'X' FROM DUAL
6852: WHERE exists ( select a.visit_id
6853: from ahl_visits_b a, ahl_visit_tasks_b b
6854: where a.visit_id <> x_visit_id
6855: and a.visit_id = b.visit_id
6856: and b.visit_id <> x_visit_id
6857: AND NVL(a.STATUS_CODE,'X') not in ('DELETED','CLOSED')

Line 6871: FROM AHL_VISIT_TASKS_B TSK, AHL_UNIT_EFFECTIVITIES_B UE

6867: -- Added by jaramana and skpathak on 05-NOV-2009 for Bug 9095324
6868: -- Get only the top level UEs for all manually planned unit effectivities
6869: CURSOR c_unplanned_task_UEs(p_visit_id IN NUMBER) IS
6870: SELECT TSK.UNIT_EFFECTIVITY_ID
6871: FROM AHL_VISIT_TASKS_B TSK, AHL_UNIT_EFFECTIVITIES_B UE
6872: WHERE TSK.VISIT_ID = p_visit_id
6873: AND TSK.STATUS_CODE <> 'DELETED'
6874: AND TSK.TASK_TYPE_CODE = 'SUMMARY'
6875: AND TSK.ORIGINATING_TASK_ID IS NULL

Line 6881: FROM AHL_VISIT_TASKS_B TSKI

6877: -- Delete UEs only with null, INIT-DUE and EXCEPTION status
6878: AND UE.UNIT_EFFECTIVITY_ID = TSK.UNIT_EFFECTIVITY_ID
6879: AND NVL(UE.STATUS_CODE, 'OPEN') IN ('OPEN', 'INIT-DUE', 'EXCEPTION')
6880: AND EXISTS (SELECT 'X'
6881: FROM AHL_VISIT_TASKS_B TSKI
6882: WHERE TSKI.VISIT_ID = p_visit_id
6883: AND TSKI.STATUS_CODE <> 'DELETED'
6884: AND TSKI.TASK_TYPE_CODE = 'UNPLANNED'
6885: -- SKPATHAK :: Bug 10376643 :: 21-DEC-2010

Line 6894: FROM AHL_UNIT_EFFECTIVITIES_B AUE, AHL_VISIT_TASKS_B AVT

6890: -- Cursor to fetch the UE ID of all unplanned tasks
6891: -- For planned tasks, fetch the UE ID only if the status is null, INIT-DUE or EXCEPTION
6892: CURSOR c_get_ue_id (c_visit_id IN NUMBER) IS
6893: SELECT AUE.UNIT_EFFECTIVITY_ID
6894: FROM AHL_UNIT_EFFECTIVITIES_B AUE, AHL_VISIT_TASKS_B AVT
6895: WHERE AVT.VISIT_ID = c_visit_id
6896: AND AUE.UNIT_EFFECTIVITY_ID = AVT.UNIT_EFFECTIVITY_ID
6897: AND (NVL(AUE.STATUS_CODE, 'OPEN') IN ('OPEN', 'INIT-DUE', 'EXCEPTION')
6898: OR AVT.TASK_TYPE_CODE = 'UNPLANNED');

Line 7020: UPDATE AHL_VISIT_TASKS_B

7016: -- For all UNPLANNED tasks, nullify the unit effectivity id
7017: -- For PLANNED tasks, nullify the ue_id only if the status is null, INIT-DUE or EXCEPTION
7018: IF (l_ue_id_inst_tbl.COUNT > 0) THEN
7019: FOR i IN l_ue_id_inst_tbl.FIRST..l_ue_id_inst_tbl.LAST LOOP
7020: UPDATE AHL_VISIT_TASKS_B
7021: SET UNIT_EFFECTIVITY_ID = NULL,
7022: OBJECT_VERSION_NUMBER = object_version_number + 1,
7023: LAST_UPDATE_DATE = SYSDATE,
7024: LAST_UPDATED_BY = Fnd_Global.USER_ID,

Line 7075: UPDATE AHL_VISIT_TASKS_B

7071: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7072: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Updating the task status to CANCELLED for task ID - c_task_rec.visit_task_id : '||c_task_rec.visit_task_id);
7073: END IF;
7074:
7075: UPDATE AHL_VISIT_TASKS_B
7076: SET STATUS_CODE = 'CANCELLED',
7077: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1,
7078: --TCHIMIRA::FP BUG 12668460 for BUG 12607498 ::14-JUN-2011::UPDATE WHO COLUMNS
7079: LAST_UPDATE_DATE = SYSDATE,