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 1911: SELECT count(*) from AHL_APPLICABLE_MRS;

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

Line 1939: -- Populate AHL_APPLICABLE_MRS if required

1935: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Processing Group MR with Id: ' || p_mr_header_id);
1936: END IF;
1937:
1938: -- Evaluate Group MRs
1939: -- Populate AHL_APPLICABLE_MRS if required
1940: OPEN get_app_mr_table_count_csr;
1941: FETCH get_app_mr_table_count_csr INTO l_temp_count;
1942: CLOSE get_app_mr_table_count_csr;
1943: IF (l_temp_count > 0) THEN

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

1940: OPEN get_app_mr_table_count_csr;
1941: FETCH get_app_mr_table_count_csr INTO l_temp_count;
1942: CLOSE get_app_mr_table_count_csr;
1943: IF (l_temp_count > 0) THEN
1944: -- AHL_APPLICABLE_MRS is already populated. No need to Call Populate_Appl_MRs
1945: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1946: 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.');
1947: END IF;
1948: ELSE

Line 1946: 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.');

1942: CLOSE get_app_mr_table_count_csr;
1943: IF (l_temp_count > 0) THEN
1944: -- AHL_APPLICABLE_MRS is already populated. No need to Call Populate_Appl_MRs
1945: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1946: 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.');
1947: END IF;
1948: ELSE
1949: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1950: 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 1950: 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);

1946: 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.');
1947: END IF;
1948: ELSE
1949: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1950: 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);
1951: END IF;
1952: AHL_UMP_UTIL_PKG.Populate_Appl_MRs(p_csi_ii_id => p_csi_instance_id,
1953: x_return_status => l_temp_return_status,
1954: x_msg_count => l_temp_msg_count,

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

1967: OPEN get_app_mr_table_count_csr;
1968: FETCH get_app_mr_table_count_csr INTO l_temp_count;
1969: CLOSE get_app_mr_table_count_csr;
1970: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1971: 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);
1972: END IF;
1973: END IF; -- AHL_APPLICABLE_MRS temp table is empty
1974:
1975: -- Call process_Group_MR_Instance

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

1969: CLOSE get_app_mr_table_count_csr;
1970: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1971: 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);
1972: END IF;
1973: END IF; -- AHL_APPLICABLE_MRS temp table is empty
1974:
1975: -- Call process_Group_MR_Instance
1976: /*OPEN get_relns_table_count_csr;
1977: FETCH get_relns_table_count_csr INTO l_temp_count;