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_APPLICABLE_MRS

Line 1992: SELECT count(*) from AHL_APPLICABLE_MRS;

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
1990:
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:

Line 2035: -- Populate AHL_APPLICABLE_MRS if required

2031: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Processing Group MR with Id: ' || p_mr_header_id);
2032: END IF;
2033:
2034: -- Evaluate Group MRs
2035: -- Populate AHL_APPLICABLE_MRS if required
2036: OPEN get_app_mr_table_count_csr;
2037: FETCH get_app_mr_table_count_csr INTO l_temp_count;
2038: CLOSE get_app_mr_table_count_csr;
2039: IF (l_temp_count > 0) THEN

Line 2040: -- AHL_APPLICABLE_MRS is already populated. No need to Call Populate_Appl_MRs

2036: OPEN get_app_mr_table_count_csr;
2037: FETCH get_app_mr_table_count_csr INTO l_temp_count;
2038: CLOSE get_app_mr_table_count_csr;
2039: IF (l_temp_count > 0) THEN
2040: -- AHL_APPLICABLE_MRS is already populated. No need to Call Populate_Appl_MRs
2041: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2042: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS: ' || l_temp_count || '. Not calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs.');
2043: END IF;
2044: ELSE

Line 2042: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS: ' || l_temp_count || '. Not calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs.');

2038: CLOSE get_app_mr_table_count_csr;
2039: IF (l_temp_count > 0) THEN
2040: -- AHL_APPLICABLE_MRS is already populated. No need to Call Populate_Appl_MRs
2041: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2042: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS: ' || l_temp_count || '. Not calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs.');
2043: END IF;
2044: ELSE
2045: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2046: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS is zero. Calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs with p_csi_ii_id = ' || p_csi_instance_id);

Line 2046: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS is zero. Calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs with p_csi_ii_id = ' || p_csi_instance_id);

2042: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS: ' || l_temp_count || '. Not calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs.');
2043: END IF;
2044: ELSE
2045: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2046: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS is zero. Calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs with p_csi_ii_id = ' || p_csi_instance_id);
2047: END IF;
2048: AHL_UMP_UTIL_PKG.Populate_Appl_MRs(p_csi_ii_id => p_csi_instance_id,
2049: x_return_status => l_temp_return_status,
2050: x_msg_count => l_temp_msg_count,

Line 2067: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'After calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs, Number of records in AHL_APPLICABLE_MRS: ' || l_temp_count);

2063: OPEN get_app_mr_table_count_csr;
2064: FETCH get_app_mr_table_count_csr INTO l_temp_count;
2065: CLOSE get_app_mr_table_count_csr;
2066: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2067: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'After calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs, Number of records in AHL_APPLICABLE_MRS: ' || l_temp_count);
2068: END IF;
2069: END IF; -- AHL_APPLICABLE_MRS temp table is empty
2070:
2071: -- Call process_Group_MR_Instance

Line 2069: END IF; -- AHL_APPLICABLE_MRS temp table is empty

2065: CLOSE get_app_mr_table_count_csr;
2066: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2067: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'After calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs, Number of records in AHL_APPLICABLE_MRS: ' || l_temp_count);
2068: END IF;
2069: END IF; -- AHL_APPLICABLE_MRS temp table is empty
2070:
2071: -- Call process_Group_MR_Instance
2072: /*OPEN get_relns_table_count_csr;
2073: FETCH get_relns_table_count_csr INTO l_temp_count;