APPS.AHL_UMP_SR_PVT dependencies on AHL_APPLICABLE_MR_RELNS

Line 1975: FROM AHL_APPLICABLE_MR_RELNS;

1971: UR.RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE AND
1972: UE.UNIT_EFFECTIVITY_ID = UR.RELATED_UE_ID
1973: INTERSECT
1974: SELECT RELATED_MR_HEADER_ID, RELATED_CSI_ITEM_INSTANCE_ID
1975: FROM AHL_APPLICABLE_MR_RELNS;
1976:
1977: CURSOR mr_relns_upd_csr IS
1978: SELECT * FROM AHL_APPLICABLE_MR_RELNS
1979: FOR UPDATE OF UE_ID;

Line 1978: SELECT * FROM AHL_APPLICABLE_MR_RELNS

1974: SELECT RELATED_MR_HEADER_ID, RELATED_CSI_ITEM_INSTANCE_ID
1975: FROM AHL_APPLICABLE_MR_RELNS;
1976:
1977: CURSOR mr_relns_upd_csr IS
1978: SELECT * FROM AHL_APPLICABLE_MR_RELNS
1979: FOR UPDATE OF UE_ID;
1980:
1981: CURSOR get_mr_reln_dtls_csr(p_mr_ue_id IN NUMBER,
1982: p_mr_header_id IN NUMBER,

Line 1985: FROM AHL_APPLICABLE_MR_RELNS child, AHL_APPLICABLE_MR_RELNS parent

1981: CURSOR get_mr_reln_dtls_csr(p_mr_ue_id IN NUMBER,
1982: p_mr_header_id IN NUMBER,
1983: p_csi_instance_id IN NUMBER) IS
1984: SELECT child.ue_id child_ue_id, NVL(parent.ue_id, p_mr_ue_id) parent_ue_id, child.relationship_code
1985: FROM AHL_APPLICABLE_MR_RELNS child, AHL_APPLICABLE_MR_RELNS parent
1986: WHERE child.ORIG_MR_HEADER_ID = p_mr_header_id AND -- Filter condition
1987: child.ORIG_CSI_ITEM_INSTANCE_ID = p_csi_instance_id AND -- Filter condition
1988: parent.RELATED_MR_HEADER_ID (+) = child.MR_HEADER_ID AND -- Join condition
1989: parent.RELATED_CSI_ITEM_INSTANCE_ID (+) = child.CSI_ITEM_INSTANCE_ID; -- Join condition

Line 1995: SELECT count(*) from AHL_APPLICABLE_MR_RELNS;*/

1991: CURSOR get_app_mr_table_count_csr IS
1992: SELECT count(*) from AHL_APPLICABLE_MRS;
1993:
1994: /*CURSOR get_relns_table_count_csr IS
1995: SELECT count(*) from AHL_APPLICABLE_MR_RELNS;*/
1996:
1997: --pdoki added for ER 9583373
1998: Cursor Chk_UE_Init_Due (p_mr_header_id NUMBER, p_instance_id NUMBER)
1999: IS

Line 2076: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MR_RELNS before processing: ' || l_temp_count);

2072: /*OPEN get_relns_table_count_csr;
2073: FETCH get_relns_table_count_csr INTO l_temp_count;
2074: CLOSE get_relns_table_count_csr;
2075: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2076: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MR_RELNS before processing: ' || l_temp_count);
2077: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'About to call AHL_UMP_UTIL_PKG.process_Group_MR_Instance with p_top_mr_id = ' ||
2078: p_mr_header_id || ' and p_top_item_instance_id = ' || p_csi_instance_id);
2079: END IF;*/
2080: AHL_UMP_UTIL_PKG.process_Group_MR_Instance(p_top_mr_id => p_mr_header_id,

Line 2087: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MR_RELNS after calling AHL_UMP_UTIL_PKG.process_Group_MR_Instance: ' || l_temp_count);

2083: /*OPEN get_relns_table_count_csr;
2084: FETCH get_relns_table_count_csr INTO l_temp_count;
2085: CLOSE get_relns_table_count_csr;
2086: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2087: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MR_RELNS after calling AHL_UMP_UTIL_PKG.process_Group_MR_Instance: ' || l_temp_count);
2088: END IF;*/
2089:
2090: -- Check for duplicates
2091: OPEN get_duplicate_mrs_csr(p_sr_ue_id => p_sr_ue_id);

Line 2147: -- Update AHL_APPLICABLE_MR_RELNS with the new UE Id

2143: p_fleet_header_id => p_fleet_header_id, -- Bug # 13916897
2144: x_ue_id => l_new_ue_id);
2145:
2146: l_temp_count := l_temp_count + 1;
2147: -- Update AHL_APPLICABLE_MR_RELNS with the new UE Id
2148: UPDATE AHL_APPLICABLE_MR_RELNS
2149: SET UE_ID = l_new_ue_id
2150: WHERE CURRENT OF mr_relns_upd_csr;
2151: END LOOP;

Line 2148: UPDATE AHL_APPLICABLE_MR_RELNS

2144: x_ue_id => l_new_ue_id);
2145:
2146: l_temp_count := l_temp_count + 1;
2147: -- Update AHL_APPLICABLE_MR_RELNS with the new UE Id
2148: UPDATE AHL_APPLICABLE_MR_RELNS
2149: SET UE_ID = l_new_ue_id
2150: WHERE CURRENT OF mr_relns_upd_csr;
2151: END LOOP;
2152: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN