APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_VWP_VISITS_PVT

Line 106: /*_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

102: -- Variables added by surrkuma on 14-JUL-2010 for bug 9901811
103: l_unsched_mtl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
104: l_unsched_mtl_index NUMBER := 1;
105:
106: /*_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
107: i NUMBER := 0;
108: l_visit_name VARCHAR2(80);
109: */
110: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name;

Line 3636: IF AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) = 'Y' THEN

3632: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3633: END IF;
3634:
3635: -- TCHIMIRA :: 15-JUL-2011 :: VWPE: ER12730539 :: If the visit is old, NR Profile is not applicable
3636: IF AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) = 'Y' THEN
3637: RETURN;
3638: END IF;
3639:
3640: IF (l_log_statement >= l_log_current_level)THEN

Line 4088: IF AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) = 'Y' THEN

4084: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4085: END IF;
4086:
4087: -- TCHIMIRA :: 15-JUL-2011 :: VWPE: ER12730539 :: If the visit is old, NR Profile is not applicable
4088: IF AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) = 'Y' THEN
4089: RETURN;
4090: END IF;
4091:
4092: IF (l_log_statement >= l_log_current_level)THEN

Line 4431: IF AHL_VWP_VISITS_PVT.Is_Old_Visit(l_visit_id) = 'Y' THEN

4427: l_workorder_tbl(1).VISIT_ID := l_visit_id;
4428: CLOSE get_workorder_detls;
4429:
4430: -- TCHIMIRA :: 15-JUL-2011 :: VWPE: ER12730539 :: If the visit is old, NR Profile is not applicable
4431: IF AHL_VWP_VISITS_PVT.Is_Old_Visit(l_visit_id) = 'Y' THEN
4432: RETURN;
4433: END IF;
4434:
4435: -- Loop through the records of the default stage materials