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_UE_RELATIONSHIPS

Line 1070: EXISTS (SELECT 'x' from AHL_UE_RELATIONSHIPS UR

1066: SELECT 'x'
1067: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE
1068: WHERE UE.UNIT_EFFECTIVITY_ID = p_mr_ue_id AND
1069: UE.OBJECT_VERSION_NUMBER = p_mr_ue_ovn AND
1070: EXISTS (SELECT 'x' from AHL_UE_RELATIONSHIPS UR
1071: WHERE UR.UE_ID = p_sr_ue_id AND
1072: UR.RELATED_UE_ID = p_mr_ue_id AND
1073: UR.relationship_code = G_UE_PARENT_REL_CODE);
1074:

Line 1323: FROM AHL_UE_RELATIONSHIPS

1319:
1320: CURSOR get_relationship_id_csr(p_sr_ue_id IN NUMBER,
1321: p_mr_ue_id IN NUMBER) IS
1322: SELECT UE_RELATIONSHIP_ID
1323: FROM AHL_UE_RELATIONSHIPS
1324: WHERE UE_ID = p_sr_ue_id AND
1325: RELATED_UE_ID = p_mr_ue_id AND
1326: RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE;
1327:

Line 1330: FROM AHL_UE_RELATIONSHIPS

1326: RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE;
1327:
1328: CURSOR get_rel_dtls_csr(p_mr_ue_id IN NUMBER) IS
1329: SELECT UE_RELATIONSHIP_ID, RELATED_UE_ID, level
1330: FROM AHL_UE_RELATIONSHIPS
1331: START WITH UE_ID = p_mr_ue_id
1332: CONNECT BY PRIOR RELATED_UE_ID = UE_ID
1333: ORDER BY LEVEL DESC; /* Bottom Up */
1334:

Line 1362: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW(X_UE_RELATIONSHIP_ID => l_rel_dtls_rec.UE_RELATIONSHIP_ID);

1358: FOR l_rel_dtls_rec IN get_rel_dtls_csr(p_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID) LOOP
1359: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to Delete Relationship with RELATIONSHIP_ID = ' || l_rel_dtls_rec.UE_RELATIONSHIP_ID || ' for a Group MR');
1361: END IF;
1362: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW(X_UE_RELATIONSHIP_ID => l_rel_dtls_rec.UE_RELATIONSHIP_ID);
1363:
1364: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to Delete Unit Effectivity with UNIT_EFFECTIVITY_ID = ' || l_rel_dtls_rec.RELATED_UE_ID || ' for a Group MR');
1366: END IF;

Line 1373: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW(X_UE_RELATIONSHIP_ID => l_relationship_id);

1369: -- Delete the MR Relationship and UE
1370: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to Delete Relationship with RELATIONSHIP_ID = ' || l_relationship_id);
1372: END IF;
1373: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW(X_UE_RELATIONSHIP_ID => l_relationship_id);
1374:
1375: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to Delete Unit Effectivity with UNIT_EFFECTIVITY_ID = ' || p_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);
1377: END IF;

Line 1405: EXISTS (SELECT 'x' FROM ahl_ue_relationships ur

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
1407: START WITH ur.ue_id = p_sr_ue_id
1408: CONNECT BY PRIOR ur.related_ue_id = ur.ue_id);
1409:

Line 1548: AHL_UE_RELATIONSHIPS

1544: UNIT_EFFECTIVITY_ID IN (
1545: SELECT
1546: RELATED_UE_ID
1547: FROM
1548: AHL_UE_RELATIONSHIPS
1549: WHERE
1550: ORIGINATOR_UE_ID = p_sr_ue_id
1551: )
1552: AND ORIGINATING_WO_ID IS NULL;

Line 1593: EXISTS (SELECT 'x' FROM AHL_UE_RELATIONSHIPS

1589: VERSION_NUMBER like DECODE(p_mr_header_id, null, '' || p_mr_version || '', '%')) AND
1590: UE.CSI_ITEM_INSTANCE_ID = (SELECT INSTANCE_ID FROM CSI_ITEM_INSTANCES
1591: WHERE INSTANCE_ID like DECODE(p_csi_instance_id, null, '%', p_csi_instance_id) AND
1592: INSTANCE_NUMBER like DECODE(p_csi_instance_id, null, p_csi_instance_number, '%')) AND
1593: EXISTS (SELECT 'x' FROM AHL_UE_RELATIONSHIPS
1594: WHERE UE_ID = p_sr_ue_id AND
1595: RELATED_UE_ID = UE.UNIT_EFFECTIVITY_ID AND
1596: RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE);*/
1597:

Line 1616: FROM AHL_UE_RELATIONSHIPS

1612: AND INSTANCE_NUMBER like DECODE(p_csi_instance_id, null, p_csi_instance_number, '%')
1613: )
1614: AND EXISTS
1615: (SELECT 'x'
1616: FROM AHL_UE_RELATIONSHIPS
1617: WHERE UE_ID = p_sr_ue_id
1618: AND RELATED_UE_ID = UE.UNIT_EFFECTIVITY_ID
1619: AND RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE
1620: );

Line 1832: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW(

1828: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1829: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1830: END IF;
1831:
1832: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW(
1833: X_UE_RELATIONSHIP_ID => x_ue_rel_id,
1834: X_UE_ID => p_ue_id,
1835: X_RELATED_UE_ID => p_related_ue_id,
1836: X_RELATIONSHIP_CODE => p_relationship_code,

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 2118: WHERE UNIT_EFFECTIVITY_ID IN (SELECT RELATED_UE_ID from AHL_UE_RELATIONSHIPS

2114: p_new_due_date IN DATE) IS
2115:
2116: CURSOR get_MR_UEs_csr IS
2117: SELECT * FROM AHL_UNIT_EFFECTIVITIES_APP_V
2118: WHERE UNIT_EFFECTIVITY_ID IN (SELECT RELATED_UE_ID from AHL_UE_RELATIONSHIPS
2119: WHERE ORIGINATOR_UE_ID = p_sr_ue_id
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';

Line 2480: FROM AHL_UE_RELATIONSHIPS

2476: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2477:
2478: CURSOR get_all_ue_and_rel_ids_csr IS
2479: SELECT UE_RELATIONSHIP_ID, RELATED_UE_ID, LEVEL
2480: FROM AHL_UE_RELATIONSHIPS
2481: WHERE originator_ue_id = p_sr_ue_id
2482: START WITH UE_ID = p_sr_ue_id
2483: CONNECT BY PRIOR RELATED_UE_ID = UE_ID
2484: ORDER BY LEVEL DESC; /* Bottom Up ordering*/

Line 2537: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW(X_UE_RELATIONSHIP_ID => rel_and_ue_id_rec.UE_RELATIONSHIP_ID);

2533: -- Not yet Planned, but open
2534: -- Delete all the dependent UEs and UE relationships
2535: FOR rel_and_ue_id_rec in get_all_ue_and_rel_ids_csr LOOP
2536: -- First delete the relationship
2537: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW(X_UE_RELATIONSHIP_ID => rel_and_ue_id_rec.UE_RELATIONSHIP_ID);
2538: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Deleted Relationship with UE_RELATIONSHIP_ID = ' || rel_and_ue_id_rec.UE_RELATIONSHIP_ID);
2540: END IF;
2541: -- Next delete the unit effectivity

Line 2732: SELECT COUNT(*) FROM AHL_UE_RELATIONSHIPS

2728: p_x_valid_flag IN OUT NOCOPY BOOLEAN, -- This flag will never be set to true in this procedure
2729: x_instance_changed OUT NOCOPY BOOLEAN) IS
2730:
2731: CURSOR get_rel_count_csr IS
2732: SELECT COUNT(*) FROM AHL_UE_RELATIONSHIPS
2733: WHERE UE_ID = p_sr_ue_id;
2734:
2735: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Instance_Change';
2736:

Line 2815: SELECT COUNT(*) FROM AHL_UE_RELATIONSHIPS

2811: SELECT 'x' from AHL_VISIT_TASKS_B
2812: where UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2813:
2814: CURSOR get_rel_count_csr IS
2815: SELECT COUNT(*) FROM AHL_UE_RELATIONSHIPS
2816: WHERE UE_ID = p_sr_ue_id;
2817:
2818: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Status_Change';
2819:

Line 2965: AHL_UE_RELATIONSHIPS UER

2961: UE.cs_incident_id IS NOT NULL AND
2962: NOT EXISTS (SELECT
2963: 'X'
2964: FROM
2965: AHL_UE_RELATIONSHIPS UER
2966: WHERE
2967: UER.related_ue_id = UE.Unit_effectivity_id OR
2968: UER.ue_id = UE.Unit_effectivity_id);
2969: