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_LTP_SIMUL_PLAN_PVT dependencies on AHL_VISITS_VL

Line 1347: -- p_visit_rec Record representing AHL_VISITS_VL

1343: -- to another
1344: --
1345: --
1346: -- PARAMETERS
1347: -- p_visit_rec Record representing AHL_VISITS_VL
1348: --
1349: -- NOTES
1350: --------------------------------------------------------------------
1351: PROCEDURE Copy_Visits_To_Plan (

Line 1376: FROM ahl_visits_vl

1372:
1373: CURSOR get_visit_id_cur (c_visit_number IN NUMBER)
1374: IS
1375: SELECT visit_id,asso_primary_visit_id
1376: FROM ahl_visits_vl
1377: WHERE visit_number = c_visit_number
1378: AND status_code ='PLANNING'
1379: AND (ORGANIZATION_ID is NULL OR ORGANIZATION_ID IN ( SELECT organization_id
1380: FROM org_organization_definitions

Line 1389: FROM ahl_visits_vl

1385: --
1386: CURSOR get_visit_num_cur (c_visit_id IN NUMBER)
1387: IS
1388: SELECT visit_id,asso_primary_visit_id
1389: FROM ahl_visits_vl
1390: WHERE visit_id = c_visit_id;
1391: --
1392:
1393: CURSOR visit_detail_cur(c_visit_id IN NUMBER)

Line 1450: FROM AHL_VISITS_VL

1446: ATTRIBUTE12,
1447: ATTRIBUTE13,
1448: ATTRIBUTE14,
1449: ATTRIBUTE15
1450: FROM AHL_VISITS_VL
1451: WHERE visit_id = c_visit_id;
1452: -- Check for one visit can be copied into simulation plan
1453: CURSOR check_visit_exist_cur (c_plan_id IN NUMBER,
1454: c_visit_id IN NUMBER,

Line 1458: FROM AHL_VISITS_VL

1454: c_visit_id IN NUMBER,
1455: c_asso_visit_id IN NUMBER)
1456: IS
1457: SELECT asso_primary_visit_id
1458: FROM AHL_VISITS_VL
1459: WHERE simulation_plan_id = c_plan_id
1460: AND (asso_primary_visit_id = c_visit_id
1461: OR NVL(asso_primary_visit_id, 0) = c_asso_visit_id);
1462: --

Line 1657: FROM ahl_visits_vl

1653:
1654: CURSOR get_visit_number(c_visit_id IN NUMBER)
1655: IS
1656: SELECT visit_number
1657: FROM ahl_visits_vl
1658: WHERE visit_id = c_visit_id;
1659:
1660: CURSOR check_primary_visit(c_visit_id IN NUMBER) IS
1661: SELECT ahlv.visit_id from ahl_visits_b ahlv, ahl_simulation_plans_b ahlsp

Line 2459: -- p_visit_rec Record representing AHL_VISITS_VL

2455: -- Remove Visits from Simulation Plan
2456: --
2457: --
2458: -- PARAMETERS
2459: -- p_visit_rec Record representing AHL_VISITS_VL
2460: --
2461: -- NOTES
2462: --------------------------------------------------------------------
2463: PROCEDURE Remove_Visits_FR_Plan (

Line 2821: FROM AHL_VISITS_VL

2817: IS
2818: SELECT VISIT_ID,
2819: OBJECT_VERSION_NUMBER,
2820: SIMULATION_DELETE_FLAG
2821: FROM AHL_VISITS_VL
2822: WHERE VISIT_ID = c_visit_id;
2823:
2824: l_api_name CONSTANT VARCHAR2(30) := 'TOGGLE_SIMULATION_DELETE';
2825: l_api_version CONSTANT NUMBER := 1.0;

Line 3011: FROM AHL_VISITS_VL

3007: --
3008: CURSOR visit_detail_cur (c_plan_id IN NUMBER)
3009: IS
3010: SELECT visit_id,object_version_number
3011: FROM AHL_VISITS_VL
3012: WHERE SIMULATION_PLAN_ID = c_plan_id;
3013: --
3014: CURSOR check_visit_cur (c_plan_id IN NUMBER)
3015: IS

Line 3017: AHL_VISITS_VL

3013: --
3014: CURSOR check_visit_cur (c_plan_id IN NUMBER)
3015: IS
3016: SELECT visit_id FROM
3017: AHL_VISITS_VL
3018: WHERE SIMULATION_PLAN_ID = c_plan_id;
3019: --
3020: l_api_name CONSTANT VARCHAR2(30) := 'SET_PLAN_AS_PRIMARY';
3021: l_api_version CONSTANT NUMBER := 1.0;

Line 3274: FROM AHL_VISITS_VL

3270: LAST_UPDATE_DATE,
3271: LAST_UPDATED_BY,
3272: LAST_UPDATE_LOGIN,
3273: INV_LOCATOR_ID --Added by sowsubra
3274: FROM AHL_VISITS_VL
3275: WHERE VISIT_ID = c_visit_id
3276: AND SIMULATION_PLAN_ID = c_plan_id;
3277:
3278: --

Line 3538: FROM Ahl_Visits_VL

3534: */
3535:
3536: CURSOR c_Visit(x_id IN NUMBER) IS
3537: SELECT *
3538: FROM Ahl_Visits_VL
3539: WHERE VISIT_ID = x_id;
3540:
3541: CURSOR c_task(c_task_id IN NUMBER) IS
3542: SELECT *

Line 3558: FROM ahl_visits_vl

3554:
3555: -- anraj for fixing the issue number 207 in the CMRO Forum
3556: CURSOR c_visit_details_for_materials(c_visit_id IN NUMBER) IS
3557: SELECT organization_id,department_id,start_date_time
3558: FROM ahl_visits_vl
3559: WHERE VISIT_ID = c_visit_id;
3560:
3561: /*Added by sowsubra*/
3562: CURSOR c_validate_subinv_loc_dtl(p_inv_locator_id IN NUMBER, p_org_id IN NUMBER) IS

Line 3709: FROM ahl_visits_vl a, ahl_simulation_plans_vl b

3705:
3706: SELECT VISIT_ID,VISIT_NUMBER, a.SIMULATION_PLAN_ID INTO
3707: l_primary_visit_id, l_primary_visit_number,
3708: l_simulation_plan_id
3709: FROM ahl_visits_vl a, ahl_simulation_plans_vl b
3710: WHERE a.visit_id = l_simul_visit_rec.asso_primary_visit_id
3711: and a.simulation_plan_id = b.simulation_plan_id
3712: and b.primary_plan_flag = 'Y';
3713: IF G_DEBUG='Y' THEN

Line 4729: FROM ahl_visits_vl vt, ahl_simulation_plans_vl sp

4725: CURSOR Get_simul_visits_cur (C_VISIT_ID IN NUMBER)
4726: IS
4727: SELECT vt.visit_id, vt.visit_number,
4728: vt.asso_primary_visit_id
4729: FROM ahl_visits_vl vt, ahl_simulation_plans_vl sp
4730: WHERE vt.simulation_plan_id = sp.simulation_plan_id
4731: AND sp.primary_plan_flag = 'N'
4732: AND vt.asso_primary_visit_id = C_VISIT_ID;
4733: -- Get all the associated tasks