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_RULES_PVT dependencies on AHL_VISIT_TASKS_B

Line 763: FROM AHL_VISIT_TASKS_B

759: ', Visit Task Number = ' || p_visit_task_number || ', Visit Id = ' || p_visit_id);
760: END IF;
761: IF (p_visit_task_id IS NOT NULL) THEN
762: SELECT Visit_Task_Id INTO x_visit_task_id
763: FROM AHL_VISIT_TASKS_B
764: WHERE Visit_Task_Id = p_visit_task_id AND Visit_Id = p_visit_id AND status_code <> 'DELETED';
765: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
766: ELSIF (p_visit_task_number IS NOT NULL) THEN
767: SELECT Visit_Task_Id INTO x_visit_task_id

Line 768: FROM AHL_VISIT_TASKS_B

764: WHERE Visit_Task_Id = p_visit_task_id AND Visit_Id = p_visit_id AND status_code <> 'DELETED';
765: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
766: ELSIF (p_visit_task_number IS NOT NULL) THEN
767: SELECT Visit_Task_Id INTO x_visit_task_id
768: FROM AHL_VISIT_TASKS_B
769: WHERE Visit_Task_Number = p_visit_task_number AND Visit_Id = p_visit_id AND status_code <> 'DELETED';
770: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
771: ELSE
772: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

Line 1283: -- Insert a record in AHL_VISIT_TASKS base and translational tables

1279: L_DEBUG_KEY,
1280: 'Before calling AHL_VISIT_TASKS_PKG.Insert_Row.');
1281: END IF;
1282:
1283: -- Insert a record in AHL_VISIT_TASKS base and translational tables
1284: Ahl_Visit_Tasks_Pkg.Insert_Row (
1285: X_ROWID => l_rowid,
1286: X_VISIT_TASK_ID => l_task_ID ,
1287: X_VISIT_TASK_NUMBER => l_task_number,

Line 1502: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL

1498: RETURN NUMBER
1499: IS
1500: -- Define local cursors
1501: CURSOR c_seq_t IS
1502: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL
1503: FROM dual;
1504:
1505: CURSOR c_id_exists_t (c_id IN NUMBER) IS
1506: SELECT 1

Line 1558: FROM Ahl_Visit_Tasks_B

1554: IS
1555: -- To find out the maximum task number value in the visit
1556: CURSOR c_task_number IS
1557: SELECT MAX(visit_task_number)
1558: FROM Ahl_Visit_Tasks_B
1559: WHERE Visit_Id = p_visit_id;
1560:
1561: x_Visit_Task_Number NUMBER;
1562: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Visit_Task_Number';

Line 1940: FROM AHL_VISIT_TASKS_B

1936:
1937: -- To find any visit task exists for the retrieve Serial Number, Unit Effectivity ID and MR Route ID and other info
1938: CURSOR c_task (x_mroute_id IN NUMBER, x_serial_id IN NUMBER, x_unit_id IN NUMBER) IS
1939: SELECT Visit_Id, Visit_Task_id
1940: FROM AHL_VISIT_TASKS_B
1941: WHERE MR_Route_Id = x_mroute_id
1942: AND Instance_Id = x_serial_id
1943: AND Unit_Effectivity_Id = x_unit_id
1944: AND (STATUS_CODE IS NULL OR STATUS_CODE <> 'DELETED');

Line 1960: FROM AHL_VISIT_TASKS_B AVTB, AHL_MR_HEADERS_APP_V AMHV

1956:
1957: -- To find any visit task exists for the retrieve Serial Number, Unit Effectivity ID and MR Route ID and other info
1958: CURSOR c_task_chk (x_id IN NUMBER, x_mr_id IN NUMBER, x_serial_id in NUMBER) IS
1959: SELECT AMHV.Title
1960: FROM AHL_VISIT_TASKS_B AVTB, AHL_MR_HEADERS_APP_V AMHV
1961: WHERE AVTB.MR_ID = AMHV.MR_HEADER_ID
1962: AND AVTB.MR_Id = x_mr_id
1963: AND AVTB.Instance_Id = x_serial_id
1964: AND AVTB.VISIT_ID = x_id

Line 1984: FROM ahl_visit_tasks_b

1980: CURSOR c_task_det(p_visit_task_id NUMBER) IS
1981: SELECT visit_task_id,
1982: start_date_time,
1983: end_date_time
1984: FROM ahl_visit_tasks_b
1985: WHERE visit_task_id = p_visit_task_id;
1986:
1987: l_task_det c_task_det%rowtype;
1988:

Line 2355: SELECT VISIT_TASK_ID FROM AHL_VISIT_TASKS_B

2351:
2352: -- Define local cursors
2353: -- For all children of cost_parent_id
2354: CURSOR c_child (c_cost_id IN NUMBER, c_id IN NUMBER) IS
2355: SELECT VISIT_TASK_ID FROM AHL_VISIT_TASKS_B
2356: WHERE VISIT_ID = c_id
2357: START WITH COST_PARENT_ID = c_cost_id
2358: CONNECT BY PRIOR VISIT_TASK_ID = COST_PARENT_ID;
2359: c_child_rec c_child%ROWTYPE;

Line 2430: SELECT VISIT_TASK_ID FROM AHL_VISIT_TASKS_B

2426:
2427: -- Define local cursors
2428: -- For all children of originating_task_id
2429: CURSOR c_child (x_org_id IN NUMBER, x_id IN NUMBER) IS
2430: SELECT VISIT_TASK_ID FROM AHL_VISIT_TASKS_B
2431: WHERE VISIT_ID = x_id
2432: AND NVL(STATUS_CODE,'X') <> 'DELETED'
2433: START WITH ORIGINATING_TASK_ID = x_org_id
2434: CONNECT BY PRIOR VISIT_TASK_ID = ORIGINATING_TASK_ID;

Line 2749: UPDATE AHL_VISIT_TASKS_B SET ORIGINATING_TASK_ID = NULL,

2745: fnd_log.string(l_log_statement,
2746: L_DEBUG_KEY,
2747: 'update origin');
2748: END IF;
2749: UPDATE AHL_VISIT_TASKS_B SET ORIGINATING_TASK_ID = NULL,
2750: OBJECT_VERSION_NUMBER = c_origin_rec.object_version_number + 1
2751: WHERE VISIT_TASK_ID = c_origin_rec.visit_task_id;
2752: END IF;
2753: END LOOP;

Line 2770: UPDATE AHL_VISIT_TASKS_B SET COST_PARENT_ID = l_parent_id,

2766: fnd_log.string(l_log_statement,
2767: L_DEBUG_KEY,
2768: 'update parent');
2769: END IF;
2770: UPDATE AHL_VISIT_TASKS_B SET COST_PARENT_ID = l_parent_id,
2771: OBJECT_VERSION_NUMBER = c_parent_rec.object_version_number + 1
2772: WHERE VISIT_TASK_ID = c_parent_rec.visit_task_id;
2773: END IF;
2774: END LOOP;

Line 2882: FROM AHL_VISIT_TASKS_B

2878: I NUMBER;
2879:
2880: CURSOR c_task(p_visit_id NUMBER, p_tsk_id NUMBER) IS
2881: SELECT visit_task_id, originating_task_id
2882: FROM AHL_VISIT_TASKS_B
2883: WHERE VISIT_ID = p_visit_id
2884: AND VISIT_TASK_ID = p_tsk_id
2885: AND (STATUS_CODE IS NULL OR STATUS_CODE <> 'DELETED');
2886: c_task_rec c_task%ROWTYPE;