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 38: -- To find out the Visit_Task_Number for the AHL_Visit_Tasks_B table

34: -- To find out the Visit_Number for the AHL_Visits_B table
35: FUNCTION Get_Visit_Number
36: RETURN NUMBER;
37:
38: -- To find out the Visit_Task_Number for the AHL_Visit_Tasks_B table
39: FUNCTION Get_Visit_Task_Number (p_visit_id IN NUMBER)
40: RETURN NUMBER;
41:
42: -- To find out Due_by_Date for the visit update screen.

Line 186: FROM Ahl_Visit_Tasks_B

182: -- Define local Cursors
183: -- To find whether a visit exists
184: CURSOR c_visit (x_id IN NUMBER) IS
185: SELECT COUNT(*)
186: FROM Ahl_Visit_Tasks_B
187: WHERE VISIT_ID = x_id
188: AND NVL(STATUS_CODE,'X') <> 'DELETED';
189:
190: -- To find the total number of tasks for a visit

Line 193: FROM Ahl_Visit_Tasks_B

189:
190: -- To find the total number of tasks for a visit
191: CURSOR c_visit_task (x_id IN NUMBER) IS
192: SELECT COUNT(*)
193: FROM Ahl_Visit_Tasks_B
194: WHERE VISIT_ID = x_id
195: AND UNIT_EFFECTIVITY_ID IS NOT NULL
196: AND NVL(STATUS_CODE,'X') <> 'DELETED';
197:

Line 201: FROM ahl_unit_effectivities_vl T1, ahl_visit_tasks_b T2

197:
198: -- To find due date for a visit related with tasks
199: CURSOR c_due_date (x_id IN NUMBER) IS
200: SELECT MIN(T1.due_date)
201: FROM ahl_unit_effectivities_vl T1, ahl_visit_tasks_b T2
202: WHERE T1.unit_effectivity_id = T2.unit_effectivity_id
203: AND T1.due_date IS NOT NULL AND T2.visit_id = x_id;
204:
205: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Due_by_Date';

Line 584: FROM Ahl_Visit_Tasks_B

580:
581: -- To find maximum visit task nubmer among all tasks for a particular visit
582: CURSOR c_task_number IS
583: SELECT MAX(visit_task_number)
584: FROM Ahl_Visit_Tasks_B
585: WHERE Visit_Id = p_visit_id;
586:
587: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Visit_Task_Number';
588: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;

Line 2358: FROM AHL_VISIT_TASKS_B

2354: ATTRIBUTE14,
2355: ATTRIBUTE15
2356: FROM AHL_TASK_LINKS
2357: WHERE visit_task_id in ( SELECT VISIT_TASK_ID
2358: FROM AHL_VISIT_TASKS_B
2359: WHERE visit_id = x_visit_id);
2360:
2361: l_task_link_rec c_visit_task_links%ROWTYPE;
2362:

Line 2366: FROM AHL_VISIT_TASKS_B a, AHL_VISIT_TASKS_B b

2362:
2363: -- To find the coresponding task id in the new visit
2364: CURSOR c_new_task_ID(x_visit_task_id IN NUMBER, x_new_visit_id IN NUMBER) IS
2365: SELECT b.VISIT_TASK_ID
2366: FROM AHL_VISIT_TASKS_B a, AHL_VISIT_TASKS_B b
2367: WHERE a.visit_task_id = x_visit_task_id
2368: AND a.visit_task_number = b.visit_task_number
2369: AND b.visit_id = x_new_visit_id;
2370:

Line 3343: UPDATE AHL_VISIT_TASKS_B

3339: FETCH c_task INTO c_task_rec;
3340: EXIT WHEN c_task%NOTFOUND;
3341: -- Tasks found for visit
3342: -- To update department_id to NULL when visit's organization is changed
3343: UPDATE AHL_VISIT_TASKS_B
3344: SET DEPARTMENT_ID = NULL,
3345: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1
3346: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id
3347: AND DEPARTMENT_ID IS NOT NULL;

Line 3685: UPDATE AHL_VISIT_TASKS_B

3681: FETCH c_task INTO c_task_rec;
3682: EXIT WHEN c_task%NOTFOUND;
3683: -- Tasks found for visit
3684: -- To set prices to NULL in case if the visit's department is changed
3685: UPDATE AHL_VISIT_TASKS_B
3686: SET ACTUAL_PRICE = NULL,
3687: ESTIMATED_PRICE = NULL,
3688: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1
3689: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id;

Line 3884: AHL_VISIT_TASKS_B

3880: END IF;
3881:
3882: -- Remove the originating task association of the deleted task
3883: UPDATE
3884: AHL_VISIT_TASKS_B
3885: SET
3886: ORIGINATING_TASK_ID=NULL,
3887: OBJECT_VERSION_NUMBER = object_version_number + 1
3888: WHERE

Line 3894: AHL_VISIT_TASKS_B

3890:
3891:
3892: -- Remove Cost parent associations for this task
3893: UPDATE
3894: AHL_VISIT_TASKS_B
3895: SET
3896: COST_PARENT_ID = NULL,
3897: OBJECT_VERSION_NUMBER = object_version_number + 1
3898: WHERE

Line 3904: AHL_VISIT_TASKS_B

3900:
3901:
3902: -- Remove Primary Task Associations in simulation visit for the deleted Task
3903: UPDATE
3904: AHL_VISIT_TASKS_B
3905: SET
3906: PRIMARY_VISIT_TASK_ID = NULL,
3907: OBJECT_VERSION_NUMBER = object_version_number + 1
3908: WHERE

Line 4349: DELETE FROM ahl_visit_tasks_b

4345: IF NVL(l_return_status, 'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
4346: RAISE Fnd_Api.G_EXC_ERROR;
4347: END IF;
4348:
4349: DELETE FROM ahl_visit_tasks_b
4350: WHERE visit_id = p_visit_id;
4351:
4352: --Delete the visit
4353: AHL_VISITS_PKG.Delete_Row( x_visit_id => p_visit_id);

Line 4759: FROM ahl_unit_effectivities_b UE, ahl_visit_tasks_b VT

4755: -- If there are any which is in wrong status, can not close visit
4756: -- PLANNED tasks can not be canncelled. UMP enforcing that rule
4757: CURSOR get_ue_tasks_csr (p_visit_id IN NUMBER) IS
4758: SELECT UE.unit_effectivity_id
4759: FROM ahl_unit_effectivities_b UE, ahl_visit_tasks_b VT
4760: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
4761: AND nvl(UE.status_code,'x') NOT IN
4762: ('ACCOMPLISHED','DEFERRED','TERMINATED','CANCELLED')
4763: AND (VT.task_type_code = 'UNPLANNED' OR VT.task_type_code = 'PLANNED')

Line 4926: UPDATE ahl_visit_tasks_b

4922: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Updating the actual cost of WO to - '||l_actual_cost);
4923: END IF;
4924:
4925: -- Update with actual cost
4926: UPDATE ahl_visit_tasks_b
4927: SET actual_cost = l_actual_cost,
4928: object_version_number = l_wip_entity_rec.object_version_number + 1
4929: WHERE visit_task_id = l_wip_entity_rec.visit_task_id;
4930:

Line 4966: UPDATE ahl_visit_tasks_b

4962: 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);
4963: END IF;
4964:
4965: --Update task record with actual cost
4966: UPDATE ahl_visit_tasks_b
4967: SET actual_cost = l_actual_cost,
4968: object_version_number = l_summ_task_rec.object_version_number + 1
4969: WHERE visit_task_id = l_summ_task_rec.visit_task_id;
4970:

Line 5029: UPDATE AHL_VISIT_TASKS_B

5025: LOOP
5026: FETCH c_task INTO c_task_rec;
5027: EXIT WHEN c_task%NOTFOUND;
5028:
5029: UPDATE AHL_VISIT_TASKS_B
5030: SET STATUS_CODE = 'CLOSED',
5031: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1
5032: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id;
5033: END LOOP;

Line 5196: SELECT distinct service_request_id FROM AHL_VISIT_TASKS_B

5192: -- yazhou start
5193: -- To find all the SRs associated to a visit
5194: -- Modified by Sjayacha to check if its not null.
5195: CURSOR c_service_request (x_visit_id IN NUMBER) IS
5196: SELECT distinct service_request_id FROM AHL_VISIT_TASKS_B
5197: WHERE VISIT_ID = x_visit_id
5198: AND service_request_id IS NOT NULL
5199: AND NVL(STATUS_CODE,'X') <> 'DELETED';
5200:

Line 5205: from ahl_visits_b a, ahl_visit_tasks_b b

5201: -- To check if any other active visits have this SR associated
5202: CURSOR c_check_SR (x_visit_id IN NUMBER, x_sr_id IN NUMBER) IS
5203: SELECT 'X' FROM DUAL
5204: WHERE exists ( select a.visit_id
5205: from ahl_visits_b a, ahl_visit_tasks_b b
5206: where a.visit_id <> x_visit_id
5207: and a.visit_id = b.visit_id
5208: and b.visit_id <> x_visit_id
5209: AND NVL(a.STATUS_CODE,'X') not in ('DELETED','CLOSED')

Line 5285: UPDATE AHL_VISIT_TASKS_B

5281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5282: END IF;
5283:
5284: -- set unit_effectivity to null
5285: UPDATE AHL_VISIT_TASKS_B
5286: SET UNIT_EFFECTIVITY_ID = NULL,
5287: OBJECT_VERSION_NUMBER = object_version_number + 1
5288: WHERE VISIT_ID = p_visit_id
5289: AND UNIT_EFFECTIVITY_ID is not null;

Line 5334: UPDATE AHL_VISIT_TASKS_B

5330: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5331: 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);
5332: END IF;
5333:
5334: UPDATE AHL_VISIT_TASKS_B
5335: SET STATUS_CODE = 'CANCELLED',
5336: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1
5337: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id;
5338: END LOOP;