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.

[Home] [Help]

APPS.AHL_UMP_SR_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 171: p_old_ue_status IN AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE,

167:
168: -- This Procedure handles the change in the status of the Service Request
169: PROCEDURE Handle_Status_Change(
170: p_sr_ue_id IN NUMBER,
171: p_old_ue_status IN AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE,
172: p_x_valid_flag IN OUT NOCOPY BOOLEAN, -- This flag will never be set to true in this procedure
173: x_status_changed OUT NOCOPY BOOLEAN,
174: x_new_ue_status OUT NOCOPY AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE);
175:

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

170: p_sr_ue_id IN NUMBER,
171: p_old_ue_status IN AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE,
172: p_x_valid_flag IN OUT NOCOPY BOOLEAN, -- This flag will never be set to true in this procedure
173: x_status_changed OUT NOCOPY BOOLEAN,
174: x_new_ue_status OUT NOCOPY AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE);
175:
176: -- This procedures handles updating the Description of the Workorders to SR Summary
177: -- for following cases
178: -- 1. Non-Routines(NR) created on the shop floor.

Line 1402: SELECT 'x' from AHL_UNIT_EFFECTIVITIES_B ue

1398:
1399: CURSOR get_dup_mrs_csr(p_mr_id IN NUMBER,
1400: p_instance_id IN NUMBER,
1401: p_sr_ue_id IN NUMBER) IS
1402: SELECT 'x' from AHL_UNIT_EFFECTIVITIES_B ue
1403: WHERE ue.mr_header_id = p_mr_id AND
1404: ue.csi_item_instance_id = p_instance_id AND
1405: EXISTS (SELECT 'x' FROM ahl_ue_relationships ur
1406: WHERE ur.related_ue_id = ue.unit_effectivity_id

Line 1417: AHL_UNIT_EFFECTIVITIES_B

1413: IS
1414: SELECT
1415: ORIGINATING_WO_ID
1416: FROM
1417: AHL_UNIT_EFFECTIVITIES_B
1418: WHERE
1419: UNIT_EFFECTIVITY_ID = p_sr_ue_id
1420: AND OBJECT_TYPE = 'SR';
1421:

Line 1540: AHL_UNIT_EFFECTIVITIES_B

1536: IF p_sr_ue_id IS NOT NULL AND l_origin_wo_id IS NOT NULL
1537: THEN
1538: BEGIN
1539: UPDATE
1540: AHL_UNIT_EFFECTIVITIES_B
1541: SET
1542: ORIGINATING_WO_ID = l_origin_wo_id
1543: WHERE
1544: UNIT_EFFECTIVITY_ID IN (

Line 1888: FROM AHL_UNIT_EFFECTIVITIES_B UE, AHL_UE_RELATIONSHIPS UR

1884: p_x_valid_flag IN OUT NOCOPY BOOLEAN) IS
1885:
1886: CURSOR get_duplicate_mrs_csr(p_sr_ue_id IN NUMBER) IS
1887: SELECT UE.MR_HEADER_ID, UE.CSI_ITEM_INSTANCE_ID
1888: FROM AHL_UNIT_EFFECTIVITIES_B UE, AHL_UE_RELATIONSHIPS UR
1889: WHERE UR.ORIGINATOR_UE_ID = p_sr_ue_id AND
1890: UR.RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE AND
1891: UE.UNIT_EFFECTIVITY_ID = UR.RELATED_UE_ID
1892: INTERSECT

Line 2124: l_temp_tolerance_flag AHL_UNIT_EFFECTIVITIES_B.TOLERANCE_FLAG%TYPE;

2120: AND RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE);
2121:
2122: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_MR_UE_Date_Change';
2123:
2124: l_temp_tolerance_flag AHL_UNIT_EFFECTIVITIES_B.TOLERANCE_FLAG%TYPE;
2125: l_temp_count NUMBER := 0;
2126:
2127:
2128: BEGIN

Line 2240: l_temp_tolerance_flag AHL_UNIT_EFFECTIVITIES_B.TOLERANCE_FLAG%TYPE;

2236: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2237:
2238: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Update_SR_Unit_Effectivity';
2239:
2240: l_temp_tolerance_flag AHL_UNIT_EFFECTIVITIES_B.TOLERANCE_FLAG%TYPE;
2241: l_temp_instance_id NUMBER;
2242: l_temp_status_code AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2243: l_temp_due_date DATE;
2244: l_curr_ue_rec get_UE_dtls_csr%ROWTYPE;

Line 2242: l_temp_status_code AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;

2238: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Update_SR_Unit_Effectivity';
2239:
2240: l_temp_tolerance_flag AHL_UNIT_EFFECTIVITIES_B.TOLERANCE_FLAG%TYPE;
2241: l_temp_instance_id NUMBER;
2242: l_temp_status_code AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2243: l_temp_due_date DATE;
2244: l_curr_ue_rec get_UE_dtls_csr%ROWTYPE;
2245: l_dummy VARCHAR2(1);
2246: l_visit_start_date DATE;

Line 2606: SELECT CSI_ITEM_INSTANCE_ID, DUE_DATE, STATUS_CODE from AHL_UNIT_EFFECTIVITIES_B

2602: PROCEDURE Handle_Attribute_Changes(
2603: p_sr_ue_id IN NUMBER) IS
2604:
2605: CURSOR get_and_lock_ue_dtls_csr IS
2606: SELECT CSI_ITEM_INSTANCE_ID, DUE_DATE, STATUS_CODE from AHL_UNIT_EFFECTIVITIES_B
2607: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id
2608: FOR UPDATE NOWAIT;
2609:
2610: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Attribute_Changes';

Line 2617: l_old_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;

2613: l_due_date_changed BOOLEAN := false;
2614: l_status_changed BOOLEAN := false;
2615: l_old_instance NUMBER;
2616: l_old_due_date DATE;
2617: l_old_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2618: l_valid_flag BOOLEAN := true;
2619: l_new_instance NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;
2620: l_new_ue_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2621: l_new_due_date DATE := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.exp_resolution_date;

Line 2620: l_new_ue_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;

2616: l_old_due_date DATE;
2617: l_old_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2618: l_valid_flag BOOLEAN := true;
2619: l_new_instance NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;
2620: l_new_ue_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2621: l_new_due_date DATE := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.exp_resolution_date;
2622: l_assigned BOOLEAN;
2623: l_new_tolerance_flag VARCHAR2(1);
2624:

Line 2805: p_old_ue_status IN AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE,

2801: -- This Procedure handles the change in the status of the Service Request
2802: ----------------------------------------
2803: PROCEDURE Handle_Status_Change(
2804: p_sr_ue_id IN NUMBER,
2805: p_old_ue_status IN AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE,
2806: p_x_valid_flag IN OUT NOCOPY BOOLEAN, -- This flag will never be set to true in this procedure
2807: x_status_changed OUT NOCOPY BOOLEAN,
2808: x_new_ue_status OUT NOCOPY AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE) IS
2809:

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

2804: p_sr_ue_id IN NUMBER,
2805: p_old_ue_status IN AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE,
2806: p_x_valid_flag IN OUT NOCOPY BOOLEAN, -- This flag will never be set to true in this procedure
2807: x_status_changed OUT NOCOPY BOOLEAN,
2808: x_new_ue_status OUT NOCOPY AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE) IS
2809:
2810: CURSOR get_tasks_for_ue_csr IS
2811: SELECT 'x' from AHL_VISIT_TASKS_B
2812: where UNIT_EFFECTIVITY_ID = p_sr_ue_id;

Line 2952: AHL_UNIT_EFFECTIVITIES_B UE

2948: AHL_WORKORDERS WO,
2949: WIP_DISCRETE_JOBS WIPJ,
2950: AHL_VISIT_TASKS_B VTSK,
2951: AHL_VISITS_B VST,
2952: AHL_UNIT_EFFECTIVITIES_B UE
2953: WHERE
2954: WO.status_code not in (4,12,7,5) AND -- Completed/Closed/Cancelled/Completed_No_Charge
2955: WO.wip_entity_id = WIPJ.wip_entity_id AND
2956: WO.visit_task_id = VTSK.visit_task_id AND

Line 2980: AHL_UNIT_EFFECTIVITIES_B UE

2976: CSIT.name -- incident type name.
2977: FROM
2978: CS_INCIDENTS_ALL CSIA,
2979: CS_INCIDENT_TYPES_VL CSIT,
2980: AHL_UNIT_EFFECTIVITIES_B UE
2981: WHERE
2982: UE.unit_effectivity_id = p_sr_ue_id AND
2983: CSIA.incident_id = ue.cs_incident_id AND
2984: CSIT.incident_type_id = CSIA.incident_type_id;