APPS.AHL_UMP_SR_PVT dependencies on AHL_APPLICABLE_MR_RELNS

Line 1894: FROM AHL_APPLICABLE_MR_RELNS;

1890: UR.RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE AND
1891: UE.UNIT_EFFECTIVITY_ID = UR.RELATED_UE_ID
1892: INTERSECT
1893: SELECT RELATED_MR_HEADER_ID, RELATED_CSI_ITEM_INSTANCE_ID
1894: FROM AHL_APPLICABLE_MR_RELNS;
1895:
1896: CURSOR mr_relns_upd_csr IS
1897: SELECT * FROM AHL_APPLICABLE_MR_RELNS
1898: FOR UPDATE OF UE_ID;

Line 1897: SELECT * FROM AHL_APPLICABLE_MR_RELNS

1893: SELECT RELATED_MR_HEADER_ID, RELATED_CSI_ITEM_INSTANCE_ID
1894: FROM AHL_APPLICABLE_MR_RELNS;
1895:
1896: CURSOR mr_relns_upd_csr IS
1897: SELECT * FROM AHL_APPLICABLE_MR_RELNS
1898: FOR UPDATE OF UE_ID;
1899:
1900: CURSOR get_mr_reln_dtls_csr(p_mr_ue_id IN NUMBER,
1901: p_mr_header_id IN NUMBER,

Line 1904: FROM AHL_APPLICABLE_MR_RELNS child, AHL_APPLICABLE_MR_RELNS parent

1900: CURSOR get_mr_reln_dtls_csr(p_mr_ue_id IN NUMBER,
1901: p_mr_header_id IN NUMBER,
1902: p_csi_instance_id IN NUMBER) IS
1903: SELECT child.ue_id child_ue_id, NVL(parent.ue_id, p_mr_ue_id) parent_ue_id, child.relationship_code
1904: FROM AHL_APPLICABLE_MR_RELNS child, AHL_APPLICABLE_MR_RELNS parent
1905: WHERE child.ORIG_MR_HEADER_ID = p_mr_header_id AND -- Filter condition
1906: child.ORIG_CSI_ITEM_INSTANCE_ID = p_csi_instance_id AND -- Filter condition
1907: parent.RELATED_MR_HEADER_ID (+) = child.MR_HEADER_ID AND -- Join condition
1908: parent.RELATED_CSI_ITEM_INSTANCE_ID (+) = child.CSI_ITEM_INSTANCE_ID; -- Join condition

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

1910: CURSOR get_app_mr_table_count_csr IS
1911: SELECT count(*) from AHL_APPLICABLE_MRS;
1912:
1913: /*CURSOR get_relns_table_count_csr IS
1914: SELECT count(*) from AHL_APPLICABLE_MR_RELNS;*/
1915:
1916:
1917: l_duplicate_mr_id NUMBER;
1918: l_dup_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;

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

1976: /*OPEN get_relns_table_count_csr;
1977: FETCH get_relns_table_count_csr INTO l_temp_count;
1978: CLOSE get_relns_table_count_csr;
1979: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1980: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MR_RELNS before processing: ' || l_temp_count);
1981: 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 = ' ||
1982: p_mr_header_id || ' and p_top_item_instance_id = ' || p_csi_instance_id);
1983: END IF;*/
1984: AHL_UMP_UTIL_PKG.process_Group_MR_Instance(p_top_mr_id => p_mr_header_id,

Line 1991: 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);

1987: /*OPEN get_relns_table_count_csr;
1988: FETCH get_relns_table_count_csr INTO l_temp_count;
1989: CLOSE get_relns_table_count_csr;
1990: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1991: 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);
1992: END IF;*/
1993:
1994: -- Check for duplicates
1995: OPEN get_duplicate_mrs_csr(p_sr_ue_id => p_sr_ue_id);

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

2026: p_login_id => p_login_id,
2027: x_ue_id => l_new_ue_id);
2028:
2029: l_temp_count := l_temp_count + 1;
2030: -- Update AHL_APPLICABLE_MR_RELNS with the new UE Id
2031: UPDATE AHL_APPLICABLE_MR_RELNS
2032: SET UE_ID = l_new_ue_id
2033: WHERE CURRENT OF mr_relns_upd_csr;
2034: END LOOP;

Line 2031: UPDATE AHL_APPLICABLE_MR_RELNS

2027: x_ue_id => l_new_ue_id);
2028:
2029: l_temp_count := l_temp_count + 1;
2030: -- Update AHL_APPLICABLE_MR_RELNS with the new UE Id
2031: UPDATE AHL_APPLICABLE_MR_RELNS
2032: SET UE_ID = l_new_ue_id
2033: WHERE CURRENT OF mr_relns_upd_csr;
2034: END LOOP;
2035: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN