APPS.AHL_PRD_NONROUTINE_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 176: ahl_unit_effectivities_b ue

172: wo.status_code
173: FROM
174: ahl_visit_tasks_b vtsk,
175: ahl_workorders wo,
176: ahl_unit_effectivities_b ue
177: WHERE
178: ue.cs_incident_id = p_incident_id
179: AND ue.unit_effectivity_id = vtsk.unit_effectivity_id
180: AND vtsk.visit_task_id = wo.visit_task_id

Line 2028: update ahl_unit_effectivities_b

2024: ---Changes by VSUNDARA FOR TRANSIT CHECK
2025:
2026: -- Tamal [MEL/CDL PRD Integration] Begins here...
2027: -- After creating the SR on the instance, need to populate unit_config_id for the newly created UE
2028: update ahl_unit_effectivities_b
2029: set unit_config_header_id = AHL_UTIL_UC_PKG.get_uc_header_id(p_x_sr_task_rec.instance_id)
2030: where unit_effectivity_id in
2031: (
2032: select unit_effectivity_id

Line 2033: from ahl_unit_effectivities_b

2029: set unit_config_header_id = AHL_UTIL_UC_PKG.get_uc_header_id(p_x_sr_task_rec.instance_id)
2030: where unit_effectivity_id in
2031: (
2032: select unit_effectivity_id
2033: from ahl_unit_effectivities_b
2034: where object_type = 'SR' and cs_incident_id = p_x_sr_task_rec.incident_id
2035: );
2036: -- Tamal [MEL/CDL PRD Integration] Ends here...
2037:

Line 2054: -- update ump table with originating wo id in AHL_UNIT_EFFECTIVITIES_B.ORIGINATING_WO_ID

2050: ||'p_x_sr_task_rec.incident_id->'||p_x_sr_task_rec.incident_id
2051: );
2052: END IF;
2053:
2054: -- update ump table with originating wo id in AHL_UNIT_EFFECTIVITIES_B.ORIGINATING_WO_ID
2055: IF
2056: (
2057: p_x_sr_task_rec.incident_id IS NOT NULL
2058: AND

Line 2065: UPDATE AHL_UNIT_EFFECTIVITIES_B

2061: THEN
2062:
2063: BEGIN
2064:
2065: UPDATE AHL_UNIT_EFFECTIVITIES_B
2066: SET ORIGINATING_WO_ID = p_x_sr_task_rec.Originating_wo_id
2067: WHERE CS_INCIDENT_ID = p_x_sr_task_rec.incident_id;
2068:
2069: EXCEPTION

Line 2133: from AHL_UNIT_EFFECTIVITIES_B

2129: -- 3. cursor for retrieving unit effectivity id corresponding to the SR created.
2130: CURSOR c_get_ue_id(p_incident_id NUMBER)
2131: IS
2132: Select unit_effectivity_id
2133: from AHL_UNIT_EFFECTIVITIES_B
2134: where cs_incident_id = p_incident_id;
2135:
2136: CURSOR c_get_sr_details(p_incident_id NUMBER)
2137: IS

Line 2526: from AHL_UNIT_EFFECTIVITIES_B

2522:
2523: CURSOR getUnitEffectivity(p_incident_id NUMBER)
2524: IS
2525: Select unit_effectivity_id
2526: from AHL_UNIT_EFFECTIVITIES_B
2527: where cs_incident_id = p_incident_id;
2528:
2529: -- FND Logging Constants
2530: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;