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_UMP_SR_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 179: p_old_ue_status IN AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE,

175:
176: -- This Procedure handles the change in the status of the Service Request
177: PROCEDURE Handle_Status_Change(
178: p_sr_ue_id IN NUMBER,
179: p_old_ue_status IN AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE,
180: p_x_valid_flag IN OUT NOCOPY BOOLEAN, -- This flag will never be set to true in this procedure
181: x_status_changed OUT NOCOPY BOOLEAN,
182: x_new_ue_status OUT NOCOPY AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE);
183:

Line 182: x_new_ue_status OUT NOCOPY AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE);

178: p_sr_ue_id IN NUMBER,
179: p_old_ue_status IN AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE,
180: p_x_valid_flag IN OUT NOCOPY BOOLEAN, -- This flag will never be set to true in this procedure
181: x_status_changed OUT NOCOPY BOOLEAN,
182: x_new_ue_status OUT NOCOPY AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE);
183:
184: -- This procedures handles updating the Description of the Workorders to SR Summary
185: -- for following cases
186: -- 1. Non-Routines(NR) created on the shop floor.

Line 1436: SELECT 'x' from AHL_UNIT_EFFECTIVITIES_B ue

1432:
1433: CURSOR get_dup_mrs_csr(p_mr_id IN NUMBER,
1434: p_instance_id IN NUMBER,
1435: p_sr_ue_id IN NUMBER) IS
1436: SELECT 'x' from AHL_UNIT_EFFECTIVITIES_B ue
1437: WHERE ue.mr_header_id = p_mr_id AND
1438: ue.csi_item_instance_id = p_instance_id AND
1439: EXISTS (SELECT 'x' FROM ahl_ue_relationships ur
1440: WHERE ur.related_ue_id = ue.unit_effectivity_id

Line 1448: FROM AHL_UNIT_EFFECTIVITIES_B UE,

1444: --pdoki added for ER 9583373
1445: Cursor Chk_UE_Init_Due (p_mr_header_id NUMBER, p_instance_id NUMBER)
1446: IS
1447: SELECT 'x'
1448: FROM AHL_UNIT_EFFECTIVITIES_B UE,
1449: AHL_MR_HEADERS_B MRH
1450: WHERE UE.mr_header_id = p_mr_header_id
1451: AND MRH.mr_header_id = UE.mr_header_id
1452: AND MRH.IMPLEMENT_STATUS_CODE IN ('MANDATORY','OPTIONAL_IMPLEMENT')

Line 1465: AHL_UNIT_EFFECTIVITIES_B

1461: IS
1462: SELECT
1463: ORIGINATING_WO_ID
1464: FROM
1465: AHL_UNIT_EFFECTIVITIES_B
1466: WHERE
1467: UNIT_EFFECTIVITY_ID = p_sr_ue_id
1468: AND OBJECT_TYPE = 'SR';
1469:

Line 1479: SELECT fleet_header_id FROM AHL_UNIT_EFFECTIVITIES_B

1475: WHERE MR_HEADER_ID = p_mr_id;
1476:
1477: -- bachandr Bug # 13916897 - start
1478: CURSOR c_get_sr_fleet(p_sr_ue_id IN NUMBER) IS
1479: SELECT fleet_header_id FROM AHL_UNIT_EFFECTIVITIES_B
1480: WHERE unit_effectivity_id = p_sr_ue_id;
1481:
1482: l_fleet_header_id NUMBER;
1483: -- bachandr Bug # 13916897 - end

Line 1614: AHL_UNIT_EFFECTIVITIES_B

1610: IF p_sr_ue_id IS NOT NULL AND l_origin_wo_id IS NOT NULL
1611: THEN
1612: BEGIN
1613: UPDATE
1614: AHL_UNIT_EFFECTIVITIES_B
1615: SET
1616: ORIGINATING_WO_ID = l_origin_wo_id
1617: WHERE
1618: UNIT_EFFECTIVITY_ID IN (

Line 1969: FROM AHL_UNIT_EFFECTIVITIES_B UE, AHL_UE_RELATIONSHIPS UR

1965: p_x_valid_flag IN OUT NOCOPY BOOLEAN) IS
1966:
1967: CURSOR get_duplicate_mrs_csr(p_sr_ue_id IN NUMBER) IS
1968: SELECT UE.MR_HEADER_ID, UE.CSI_ITEM_INSTANCE_ID
1969: FROM AHL_UNIT_EFFECTIVITIES_B UE, AHL_UE_RELATIONSHIPS UR
1970: WHERE UR.ORIGINATOR_UE_ID = p_sr_ue_id AND
1971: UR.RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE AND
1972: UE.UNIT_EFFECTIVITY_ID = UR.RELATED_UE_ID
1973: INTERSECT

Line 2001: FROM AHL_UNIT_EFFECTIVITIES_B UE,

1997: --pdoki added for ER 9583373
1998: Cursor Chk_UE_Init_Due (p_mr_header_id NUMBER, p_instance_id NUMBER)
1999: IS
2000: SELECT 'x'
2001: FROM AHL_UNIT_EFFECTIVITIES_B UE,
2002: AHL_MR_HEADERS_B MRH
2003: WHERE UE.mr_header_id = p_mr_header_id
2004: AND MRH.mr_header_id = UE.mr_header_id
2005: AND MRH.IMPLEMENT_STATUS_CODE IN ('MANDATORY','OPTIONAL_IMPLEMENT')

Line 2241: l_temp_tolerance_flag AHL_UNIT_EFFECTIVITIES_B.TOLERANCE_FLAG%TYPE;

2237: AND RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE);
2238:
2239: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_MR_UE_Date_Change';
2240:
2241: l_temp_tolerance_flag AHL_UNIT_EFFECTIVITIES_B.TOLERANCE_FLAG%TYPE;
2242: l_temp_count NUMBER := 0;
2243:
2244:
2245: BEGIN

Line 2368: l_temp_tolerance_flag AHL_UNIT_EFFECTIVITIES_B.TOLERANCE_FLAG%TYPE;

2364: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2365:
2366: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Update_SR_Unit_Effectivity';
2367:
2368: l_temp_tolerance_flag AHL_UNIT_EFFECTIVITIES_B.TOLERANCE_FLAG%TYPE;
2369: l_temp_instance_id NUMBER;
2370: l_temp_status_code AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2371: l_temp_due_date DATE;
2372: l_curr_ue_rec get_UE_dtls_csr%ROWTYPE;

Line 2370: l_temp_status_code AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;

2366: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Update_SR_Unit_Effectivity';
2367:
2368: l_temp_tolerance_flag AHL_UNIT_EFFECTIVITIES_B.TOLERANCE_FLAG%TYPE;
2369: l_temp_instance_id NUMBER;
2370: l_temp_status_code AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2371: l_temp_due_date DATE;
2372: l_curr_ue_rec get_UE_dtls_csr%ROWTYPE;
2373: l_dummy VARCHAR2(1);
2374: l_visit_start_date DATE;

Line 2759: SELECT CSI_ITEM_INSTANCE_ID, DUE_DATE, STATUS_CODE, DEFER_FROM_UE_ID from AHL_UNIT_EFFECTIVITIES_B

2755: PROCEDURE Handle_Attribute_Changes(
2756: p_sr_ue_id IN NUMBER) IS
2757: --apattark added DEFER_FROM_UE_ID to check if it is null
2758: CURSOR get_and_lock_ue_dtls_csr IS
2759: SELECT CSI_ITEM_INSTANCE_ID, DUE_DATE, STATUS_CODE, DEFER_FROM_UE_ID from AHL_UNIT_EFFECTIVITIES_B
2760: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id
2761: FOR UPDATE NOWAIT;
2762:
2763: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Attribute_Changes';

Line 2770: l_old_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;

2766: l_due_date_changed BOOLEAN := false;
2767: l_status_changed BOOLEAN := false;
2768: l_old_instance NUMBER;
2769: l_old_due_date DATE;
2770: l_old_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2771: l_valid_flag BOOLEAN := true;
2772: l_new_instance NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;
2773: l_new_ue_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2774: l_new_due_date DATE := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.exp_resolution_date;

Line 2773: l_new_ue_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;

2769: l_old_due_date DATE;
2770: l_old_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2771: l_valid_flag BOOLEAN := true;
2772: l_new_instance NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;
2773: l_new_ue_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2774: l_new_due_date DATE := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.exp_resolution_date;
2775: l_assigned BOOLEAN;
2776: l_new_tolerance_flag VARCHAR2(1);
2777: --apattark added for bug #9166304

Line 2997: p_old_ue_status IN AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE,

2993: -- This Procedure handles the change in the status of the Service Request
2994: ----------------------------------------
2995: PROCEDURE Handle_Status_Change(
2996: p_sr_ue_id IN NUMBER,
2997: p_old_ue_status IN AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE,
2998: p_x_valid_flag IN OUT NOCOPY BOOLEAN, -- This flag will never be set to true in this procedure
2999: x_status_changed OUT NOCOPY BOOLEAN,
3000: x_new_ue_status OUT NOCOPY AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE) IS
3001:

Line 3000: x_new_ue_status OUT NOCOPY AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE) IS

2996: p_sr_ue_id IN NUMBER,
2997: p_old_ue_status IN AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE,
2998: p_x_valid_flag IN OUT NOCOPY BOOLEAN, -- This flag will never be set to true in this procedure
2999: x_status_changed OUT NOCOPY BOOLEAN,
3000: x_new_ue_status OUT NOCOPY AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE) IS
3001:
3002: CURSOR get_tasks_for_ue_csr IS
3003: SELECT 'x' from AHL_VISIT_TASKS_B
3004: where UNIT_EFFECTIVITY_ID = p_sr_ue_id;

Line 3144: AHL_UNIT_EFFECTIVITIES_B UE

3140: AHL_WORKORDERS WO,
3141: WIP_DISCRETE_JOBS WIPJ,
3142: AHL_VISIT_TASKS_B VTSK,
3143: AHL_VISITS_B VST,
3144: AHL_UNIT_EFFECTIVITIES_B UE
3145: WHERE
3146: WO.status_code not in (4,12,7,5) AND -- Completed/Closed/Cancelled/Completed_No_Charge
3147: WO.wip_entity_id = WIPJ.wip_entity_id AND
3148: WO.visit_task_id = VTSK.visit_task_id AND

Line 3172: AHL_UNIT_EFFECTIVITIES_B UE

3168: CSIT.name -- incident type name.
3169: FROM
3170: CS_INCIDENTS_ALL CSIA,
3171: CS_INCIDENT_TYPES_VL CSIT,
3172: AHL_UNIT_EFFECTIVITIES_B UE
3173: WHERE
3174: UE.unit_effectivity_id = p_sr_ue_id AND
3175: CSIA.incident_id = ue.cs_incident_id AND
3176: CSIT.incident_type_id = CSIA.incident_type_id;