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_UE_RELATIONSHIPS

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

1100: SELECT 'x'
1101: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE
1102: WHERE UE.UNIT_EFFECTIVITY_ID = p_mr_ue_id AND
1103: UE.OBJECT_VERSION_NUMBER = p_mr_ue_ovn AND
1104: EXISTS (SELECT 'x' from AHL_UE_RELATIONSHIPS UR
1105: WHERE UR.UE_ID = p_sr_ue_id AND
1106: UR.RELATED_UE_ID = p_mr_ue_id AND
1107: UR.relationship_code = G_UE_PARENT_REL_CODE);
1108:

Line 1357: FROM AHL_UE_RELATIONSHIPS

1353:
1354: CURSOR get_relationship_id_csr(p_sr_ue_id IN NUMBER,
1355: p_mr_ue_id IN NUMBER) IS
1356: SELECT UE_RELATIONSHIP_ID
1357: FROM AHL_UE_RELATIONSHIPS
1358: WHERE UE_ID = p_sr_ue_id AND
1359: RELATED_UE_ID = p_mr_ue_id AND
1360: RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE;
1361:

Line 1364: FROM AHL_UE_RELATIONSHIPS

1360: RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE;
1361:
1362: CURSOR get_rel_dtls_csr(p_mr_ue_id IN NUMBER) IS
1363: SELECT UE_RELATIONSHIP_ID, RELATED_UE_ID, level
1364: FROM AHL_UE_RELATIONSHIPS
1365: START WITH UE_ID = p_mr_ue_id
1366: CONNECT BY PRIOR RELATED_UE_ID = UE_ID
1367: ORDER BY LEVEL DESC; /* Bottom Up */
1368:

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

1392: FOR l_rel_dtls_rec IN get_rel_dtls_csr(p_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID) LOOP
1393: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1394: 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');
1395: END IF;
1396: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW(X_UE_RELATIONSHIP_ID => l_rel_dtls_rec.UE_RELATIONSHIP_ID);
1397:
1398: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1399: 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');
1400: END IF;

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

1403: -- Delete the MR Relationship and UE
1404: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to Delete Relationship with RELATIONSHIP_ID = ' || l_relationship_id);
1406: END IF;
1407: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW(X_UE_RELATIONSHIP_ID => l_relationship_id);
1408:
1409: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1410: 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);
1411: END IF;

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

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
1441: START WITH ur.ue_id = p_sr_ue_id
1442: CONNECT BY PRIOR ur.related_ue_id = ur.ue_id);
1443:

Line 1622: AHL_UE_RELATIONSHIPS

1618: UNIT_EFFECTIVITY_ID IN (
1619: SELECT
1620: RELATED_UE_ID
1621: FROM
1622: AHL_UE_RELATIONSHIPS
1623: WHERE
1624: ORIGINATOR_UE_ID = p_sr_ue_id
1625: )
1626: AND ORIGINATING_WO_ID IS NULL;

Line 1667: EXISTS (SELECT 'x' FROM AHL_UE_RELATIONSHIPS

1663: VERSION_NUMBER like DECODE(p_mr_header_id, null, '' || p_mr_version || '', '%')) AND
1664: UE.CSI_ITEM_INSTANCE_ID = (SELECT INSTANCE_ID FROM CSI_ITEM_INSTANCES
1665: WHERE INSTANCE_ID like DECODE(p_csi_instance_id, null, '%', p_csi_instance_id) AND
1666: INSTANCE_NUMBER like DECODE(p_csi_instance_id, null, p_csi_instance_number, '%')) AND
1667: EXISTS (SELECT 'x' FROM AHL_UE_RELATIONSHIPS
1668: WHERE UE_ID = p_sr_ue_id AND
1669: RELATED_UE_ID = UE.UNIT_EFFECTIVITY_ID AND
1670: RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE);*/
1671:

Line 1690: FROM AHL_UE_RELATIONSHIPS

1686: AND INSTANCE_NUMBER like DECODE(p_csi_instance_id, null, p_csi_instance_number, '%')
1687: )
1688: AND EXISTS
1689: (SELECT 'x'
1690: FROM AHL_UE_RELATIONSHIPS
1691: WHERE UE_ID = p_sr_ue_id
1692: AND RELATED_UE_ID = UE.UNIT_EFFECTIVITY_ID
1693: AND RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE
1694: );

Line 1912: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW(

1908: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1909: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1910: END IF;
1911:
1912: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW(
1913: X_UE_RELATIONSHIP_ID => x_ue_rel_id,
1914: X_UE_ID => p_ue_id,
1915: X_RELATED_UE_ID => p_related_ue_id,
1916: X_RELATIONSHIP_CODE => p_relationship_code,

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

2231: p_new_due_date IN DATE) IS
2232:
2233: CURSOR get_MR_UEs_csr IS
2234: SELECT * FROM AHL_UNIT_EFFECTIVITIES_APP_V
2235: WHERE UNIT_EFFECTIVITY_ID IN (SELECT RELATED_UE_ID from AHL_UE_RELATIONSHIPS
2236: WHERE ORIGINATOR_UE_ID = p_sr_ue_id
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';

Line 2623: FROM AHL_UE_RELATIONSHIPS

2619: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2620:
2621: CURSOR get_all_ue_and_rel_ids_csr IS
2622: SELECT UE_RELATIONSHIP_ID, RELATED_UE_ID, LEVEL
2623: FROM AHL_UE_RELATIONSHIPS
2624: WHERE originator_ue_id = p_sr_ue_id
2625: START WITH UE_ID = p_sr_ue_id
2626: CONNECT BY PRIOR RELATED_UE_ID = UE_ID
2627: ORDER BY LEVEL DESC; /* Bottom Up ordering*/

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

2686: -- Not yet Planned, but open
2687: -- Delete all the dependent UEs and UE relationships
2688: FOR rel_and_ue_id_rec in get_all_ue_and_rel_ids_csr LOOP
2689: -- First delete the relationship
2690: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW(X_UE_RELATIONSHIP_ID => rel_and_ue_id_rec.UE_RELATIONSHIP_ID);
2691: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Deleted Relationship with UE_RELATIONSHIP_ID = ' || rel_and_ue_id_rec.UE_RELATIONSHIP_ID);
2693: END IF;
2694: -- Next delete the unit effectivity

Line 2913: SELECT COUNT(*) FROM AHL_UE_RELATIONSHIPS

2909: x_instance_changed OUT NOCOPY BOOLEAN,
2910: p_defer_from_ue_id IN NUMBER) IS
2911:
2912: CURSOR get_rel_count_csr IS
2913: SELECT COUNT(*) FROM AHL_UE_RELATIONSHIPS
2914: WHERE UE_ID = p_sr_ue_id;
2915:
2916: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Instance_Change';
2917:

Line 3007: SELECT COUNT(*) FROM AHL_UE_RELATIONSHIPS

3003: SELECT 'x' from AHL_VISIT_TASKS_B
3004: where UNIT_EFFECTIVITY_ID = p_sr_ue_id;
3005:
3006: CURSOR get_rel_count_csr IS
3007: SELECT COUNT(*) FROM AHL_UE_RELATIONSHIPS
3008: WHERE UE_ID = p_sr_ue_id;
3009:
3010: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Status_Change';
3011:

Line 3157: AHL_UE_RELATIONSHIPS UER

3153: UE.cs_incident_id IS NOT NULL AND
3154: NOT EXISTS (SELECT
3155: 'X'
3156: FROM
3157: AHL_UE_RELATIONSHIPS UER
3158: WHERE
3159: UER.related_ue_id = UE.Unit_effectivity_id OR
3160: UER.ue_id = UE.Unit_effectivity_id);
3161: