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_VISITS_B

Line 30: -- To find out the Visit_Id for the AHL_Visits_B and TL tables

26:
27: --------------------------------------------------------------------
28: -- START: Defining local functions and procedures SIGNATURES --
29: --------------------------------------------------------------------
30: -- To find out the Visit_Id for the AHL_Visits_B and TL tables
31: FUNCTION Get_Visit_Id
32: RETURN NUMBER;
33:
34: -- To find out the Visit_Number for the AHL_Visits_B table

Line 34: -- To find out the Visit_Number for the AHL_Visits_B table

30: -- To find out the Visit_Id for the AHL_Visits_B and TL tables
31: FUNCTION Get_Visit_Id
32: RETURN NUMBER;
33:
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

Line 488: SELECT Ahl_Visits_B_S.NEXTVAL

484: FUNCTION Get_Visit_Id RETURN NUMBER IS
485:
486: -- To find the next id value from visit sequence
487: CURSOR c_seq IS
488: SELECT Ahl_Visits_B_S.NEXTVAL
489: FROM dual;
490:
491: -- To find whether id already exists
492: CURSOR c_id_exists (x_id IN NUMBER) IS

Line 542: FROM Ahl_Visits_B;

538:
539: -- To find maximum visit number among all visits
540: CURSOR c_visit_number IS
541: SELECT MAX(visit_number)
542: FROM Ahl_Visits_B;
543:
544: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Visit_Number';
545: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
546: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;

Line 661: SELECT STATUS_CODE FROM AHL_VISITS_B

657: l_visit_status VARCHAR2(30);
658:
659: -- To find out visit status
660: CURSOR c_visit_status (x_visit_id IN NUMBER) IS
661: SELECT STATUS_CODE FROM AHL_VISITS_B
662: WHERE VISIT_ID = x_visit_id;
663:
664: -- yazhou end
665: --

Line 1054: FROM AHL_VISITS_B AVTS,AHL_VISITS_TL AVTSTL,

1050: ASPVTL.SIMULATION_PLAN_NAME, NVL(ASPV.PRIMARY_PLAN_FLAG,'Y') ,
1051: CSAB.INCIDENT_NUMBER, UC.NAME UNIT_NAME
1052: ,PA.NAME PROJECT_TEMPLATE_NAME,
1053: AVTS.INV_LOCATOR_ID -- Added by sowsubra
1054: FROM AHL_VISITS_B AVTS,AHL_VISITS_TL AVTSTL,
1055: AHL_SIMULATION_PLANS_B ASPV,AHL_SIMULATION_PLANS_TL ASPVTL,
1056: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS_TL HROU,
1057: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1058: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,

Line 1420: SELECT Ahl_Visits_B_S.NEXTVAL

1416: l_Visit_rec Visit_Rec_Type := p_x_Visit_rec;
1417: -- Define local Cursors
1418: -- To find the next id value from visit sequence
1419: CURSOR c_seq IS
1420: SELECT Ahl_Visits_B_S.NEXTVAL
1421: FROM dual;
1422:
1423: -- To find whether id already exists
1424: CURSOR c_id_exists (x_id IN NUMBER) IS

Line 1430: SELECT MAX(visit_number) FROM Ahl_Visits_B;

1426: WHERE Visit_id = x_id;
1427:
1428: -- To find the maximum visit number among all visits
1429: CURSOR c_visit_number IS
1430: SELECT MAX(visit_number) FROM Ahl_Visits_B;
1431:
1432: -- Fix for ADS bug# 4357001.
1433: -- Changed cursor to not use ahl_mtl_items_ou_v and replaced with mtl_system_items_kfv
1434: -- and added OU stripping so that Master Org does not belong to the current user's OU.

Line 2186: UPDATE ahl_visits_b

2182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2183: fnd_log.string(fnd_log.level_statement,L_DEBUG,'l_date_time - '||l_date_time);
2184: END IF;
2185:
2186: UPDATE ahl_visits_b
2187: SET close_date_time = l_date_time
2188: WHERE visit_id = l_Visit_rec.visit_id ;
2189: END IF;
2190:

Line 3668: UPDATE AHL_VISITS_B

3664: CLOSE c_job;
3665:
3666: IF l_count <> 0 THEN
3667: -- To update visit's prices
3668: UPDATE AHL_VISITS_B
3669: SET ACTUAL_PRICE = NULL,
3670: ESTIMATED_PRICE = NULL,
3671: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3672: WHERE VISIT_ID = l_Visit_rec.visit_id;

Line 4356: UPDATE AHL_VISITS_B

4352: --Delete the visit
4353: AHL_VISITS_PKG.Delete_Row( x_visit_id => p_visit_id);
4354: ELSE
4355: -- Soft Delete
4356: UPDATE AHL_VISITS_B
4357: SET STATUS_CODE = 'DELETED',
4358: SIMULATION_PLAN_ID = NULL,
4359: OBJECT_VERSION_NUMBER =OBJECT_VERSION_NUMBER + 1
4360: WHERE VISIT_ID = l_visit_rec.visit_id;

Line 5017: UPDATE AHL_VISITS_B

5013: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Updating Visit Status to CLOSED..');
5014: END IF;
5015:
5016: -- To update visit to CLOSED status
5017: UPDATE AHL_VISITS_B
5018: SET STATUS_CODE = 'CLOSED',
5019: SIMULATION_PLAN_ID = NULL,
5020: OBJECT_VERSION_NUMBER = c_visit_rec.object_version_number + 1
5021: WHERE VISIT_ID = p_visit_id;

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 5345: UPDATE AHL_VISITS_B

5341: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5342: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Updating the visit status to CANCELLED..');
5343: END IF;
5344: -- update visit status
5345: UPDATE AHL_VISITS_B
5346: SET STATUS_CODE = 'CANCELLED',
5347: OBJECT_VERSION_NUMBER = c_visit_rec.object_version_number + 1
5348: WHERE VISIT_ID = p_visit_id;
5349:

Line 5903: UPDATE AHL_VISITS_B

5899:
5900: -- Initialize return status to success initially
5901: x_return_status:=FND_API.G_RET_STS_SUCCESS;
5902:
5903: UPDATE AHL_VISITS_B
5904: SET UNIT_SCHEDULE_ID = NULL
5905: WHERE UNIT_SCHEDULE_ID = p_unit_schedule_id ;
5906:
5907: EXCEPTION