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 1343: -- p_visit_rec Record representing AHL_VISITS_VL

1339: -- to another
1340: --
1341: --
1342: -- PARAMETERS
1343: -- p_visit_rec Record representing AHL_VISITS_VL
1344: --
1345: -- NOTES
1346: --------------------------------------------------------------------
1347: PROCEDURE Copy_Visits_To_Plan (

Line 1372: FROM ahl_visits_vl

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

Line 1385: FROM ahl_visits_vl

1381: --
1382: CURSOR get_visit_num_cur (c_visit_id IN NUMBER)
1383: IS
1384: SELECT visit_id,asso_primary_visit_id
1385: FROM ahl_visits_vl
1386: WHERE visit_id = c_visit_id;
1387: --
1388:
1389: CURSOR visit_detail_cur(c_visit_id IN NUMBER)

Line 1440: FROM AHL_VISITS_VL

1436: ATTRIBUTE12,
1437: ATTRIBUTE13,
1438: ATTRIBUTE14,
1439: ATTRIBUTE15
1440: FROM AHL_VISITS_VL
1441: WHERE visit_id = c_visit_id;
1442: -- Check for one visit can be copied into simulation plan
1443: CURSOR check_visit_exist_cur (c_plan_id IN NUMBER,
1444: c_visit_id IN NUMBER,

Line 1448: FROM AHL_VISITS_VL

1444: c_visit_id IN NUMBER,
1445: c_asso_visit_id IN NUMBER)
1446: IS
1447: SELECT asso_primary_visit_id
1448: FROM AHL_VISITS_VL
1449: WHERE simulation_plan_id = c_plan_id
1450: AND (asso_primary_visit_id = c_visit_id
1451: OR NVL(asso_primary_visit_id, 0) = c_asso_visit_id);
1452: --

Line 1641: FROM ahl_visits_vl

1637:
1638: CURSOR get_visit_number(c_visit_id IN NUMBER)
1639: IS
1640: SELECT visit_number
1641: FROM ahl_visits_vl
1642: WHERE visit_id = c_visit_id;
1643:
1644: CURSOR check_primary_visit(c_visit_id IN NUMBER) IS
1645: SELECT ahlv.visit_id from ahl_visits_b ahlv, ahl_simulation_plans_b ahlsp

Line 2420: -- p_visit_rec Record representing AHL_VISITS_VL

2416: -- Remove Visits from Simulation Plan
2417: --
2418: --
2419: -- PARAMETERS
2420: -- p_visit_rec Record representing AHL_VISITS_VL
2421: --
2422: -- NOTES
2423: --------------------------------------------------------------------
2424: PROCEDURE Remove_Visits_FR_Plan (

Line 2781: FROM AHL_VISITS_VL

2777: IS
2778: SELECT VISIT_ID,
2779: OBJECT_VERSION_NUMBER,
2780: SIMULATION_DELETE_FLAG
2781: FROM AHL_VISITS_VL
2782: WHERE VISIT_ID = c_visit_id;
2783:
2784: l_api_name CONSTANT VARCHAR2(30) := 'TOGGLE_SIMULATION_DELETE';
2785: l_api_version CONSTANT NUMBER := 1.0;

Line 2971: FROM AHL_VISITS_VL

2967: --
2968: CURSOR visit_detail_cur (c_plan_id IN NUMBER)
2969: IS
2970: SELECT visit_id,object_version_number
2971: FROM AHL_VISITS_VL
2972: WHERE SIMULATION_PLAN_ID = c_plan_id;
2973: --
2974: CURSOR check_visit_cur (c_plan_id IN NUMBER)
2975: IS

Line 2977: AHL_VISITS_VL

2973: --
2974: CURSOR check_visit_cur (c_plan_id IN NUMBER)
2975: IS
2976: SELECT visit_id FROM
2977: AHL_VISITS_VL
2978: WHERE SIMULATION_PLAN_ID = c_plan_id;
2979: --
2980: l_api_name CONSTANT VARCHAR2(30) := 'SET_PLAN_AS_PRIMARY';
2981: l_api_version CONSTANT NUMBER := 1.0;

Line 3234: FROM AHL_VISITS_VL

3230: LAST_UPDATE_DATE,
3231: LAST_UPDATED_BY,
3232: LAST_UPDATE_LOGIN,
3233: INV_LOCATOR_ID --Added by sowsubra
3234: FROM AHL_VISITS_VL
3235: WHERE VISIT_ID = c_visit_id
3236: AND SIMULATION_PLAN_ID = c_plan_id;
3237:
3238: --

Line 3492: FROM Ahl_Visits_VL

3488: */
3489:
3490: CURSOR c_Visit(x_id IN NUMBER) IS
3491: SELECT *
3492: FROM Ahl_Visits_VL
3493: WHERE VISIT_ID = x_id;
3494:
3495: CURSOR c_task(c_task_id IN NUMBER) IS
3496: SELECT *

Line 3512: FROM ahl_visits_vl

3508:
3509: -- anraj for fixing the issue number 207 in the CMRO Forum
3510: CURSOR c_visit_details_for_materials(c_visit_id IN NUMBER) IS
3511: SELECT organization_id,department_id,start_date_time
3512: FROM ahl_visits_vl
3513: WHERE VISIT_ID = c_visit_id;
3514:
3515: /*Added by sowsubra*/
3516: CURSOR c_validate_subinv_loc_dtl(p_inv_locator_id IN NUMBER, p_org_id IN NUMBER) IS

Line 3663: FROM ahl_visits_vl a, ahl_simulation_plans_vl b

3659:
3660: SELECT VISIT_ID,VISIT_NUMBER, a.SIMULATION_PLAN_ID INTO
3661: l_primary_visit_id, l_primary_visit_number,
3662: l_simulation_plan_id
3663: FROM ahl_visits_vl a, ahl_simulation_plans_vl b
3664: WHERE a.visit_id = l_simul_visit_rec.asso_primary_visit_id
3665: and a.simulation_plan_id = b.simulation_plan_id
3666: and b.primary_plan_flag = 'Y';
3667: IF G_DEBUG='Y' THEN

Line 4665: FROM ahl_visits_vl vt, ahl_simulation_plans_vl sp

4661: CURSOR Get_simul_visits_cur (C_VISIT_ID IN NUMBER)
4662: IS
4663: SELECT vt.visit_id, vt.visit_number,
4664: vt.asso_primary_visit_id
4665: FROM ahl_visits_vl vt, ahl_simulation_plans_vl sp
4666: WHERE vt.simulation_plan_id = sp.simulation_plan_id
4667: AND sp.primary_plan_flag = 'N'
4668: AND vt.asso_primary_visit_id = C_VISIT_ID;
4669: -- Get all the associated tasks