DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on AHL_CMP_UTIL_PKG

Line 2525: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_visit_rec.visit_id);

2521: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011
2522: * There is no need to create any Stage tasks for Component Visits
2523: * as there won't be any Stage associated with them.
2524: */
2525: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_visit_rec.visit_id);
2526: IF (l_is_comp_visit = 'N') THEN
2527:
2528: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2529: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.CREATE_STAGES');

Line 3410: l_is_comp_visit VARCHAR2(1) := AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_visit_rec.visit_id);

3406: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3407: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
3408: l_Space_Assignment_Rec ahl_ltp_space_assign_pub.Space_Assignment_Rec;
3409: --TCHIMIRA::P2P CP ER 9151144::09-DEC-2009
3410: l_is_comp_visit VARCHAR2(1) := AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_visit_rec.visit_id);
3411: l_auto_visit_type_flag VARCHAR2(1);--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3412:
3413: -- Define local Cursors
3414: -- To find visit related information

Line 5573: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_visit_rec.visit_id);

5569:
5570: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011
5571: * There is no need to delete Stages for Component Visits as there won't be any Stage associated with them.
5572: */
5573: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_visit_rec.visit_id);
5574: IF (l_is_comp_visit = 'N') THEN
5575:
5576: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: changed the API name from DELETE_STAGES to DELETE_ALL_STAGES
5577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 6425: IF (AHL_CMP_UTIL_PKG.Is_Comp_Visit (p_visit_id) = 'N') THEN

6421:
6422: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011
6423: * Default Stage task and hence workorder won't exist for the Component Visit.
6424: */
6425: IF (AHL_CMP_UTIL_PKG.Is_Comp_Visit (p_visit_id) = 'N') THEN
6426:
6427: -- SKPATHAK :: 20-JUN-2011 :: VWPE: ER:12673125 :: START
6428: -- Cancel the default stage WO
6429: OPEN get_default_stage_wo (p_visit_id);

Line 6465: END IF; -- if AHL_CMP_UTIL_PKG.Is_Comp_Visit (p_visit_id) = 'N'

6461: RAISE Fnd_Api.g_exc_unexpected_error;
6462: END IF;
6463: END IF;
6464: -- SKPATHAK :: 20-JUN-2011 :: VWPE: ER:12673125 :: END
6465: END IF; -- if AHL_CMP_UTIL_PKG.Is_Comp_Visit (p_visit_id) = 'N'
6466:
6467: -- AnRaj added for R 12.0 ACL changes in VWP, End
6468: IF c_visit_rec.status_code = 'RELEASED' THEN
6469: l_chk_flag := 'Y';