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_UNPLANNED_PVT dependencies on AHL_APPLICABLE_MRS

Line 57: AHL_APPLICABLE_MRS

53: Cursor Get_all_appl_mrs ( c_mr_header_id NUMBER , c_instance_id NUMBER )
54: IS
55: SELECT CSI_ITEM_INSTANCE_ID, MR_HEADER_ID, DESCENDENT_COUNT
56: from
57: AHL_APPLICABLE_MRS
58: where
59: MR_HEADER_ID = c_mr_header_id and
60: CSI_ITEM_INSTANCE_ID = c_instance_id;
61:

Line 290: -- call AHL_FMP_COMMON_PVT.Populate_Appl_MRs to populate the AHL_APPLICABLE_MRS temporary table

286: IF (is_grp_mr_check%FOUND) THEN
287:
288: CLOSE is_grp_mr_check;
289:
290: -- call AHL_FMP_COMMON_PVT.Populate_Appl_MRs to populate the AHL_APPLICABLE_MRS temporary table
291: -- call the API with input p_include_doNotImplmt = 'Y', otherwise descendent_count is not populated.
292:
293: AHL_FMP_COMMON_PVT.Populate_Appl_MRs (
294: p_csi_ii_id => p_instance_id,

Line 307: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'AFTER Calling AHL_FMP_COMMON_PVT.Populate_Appl_MRs to populate AHL_APPLICABLE_MRS');

303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305:
306: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
307: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'AFTER Calling AHL_FMP_COMMON_PVT.Populate_Appl_MRs to populate AHL_APPLICABLE_MRS');
308: END IF;
309:
310: --loop not need as only one record.The Top Group MR is returned.
311: OPEN Get_all_appl_mrs ( p_mr_header_id , p_instance_id );

Line 455: -- Process_Group_MRs() is not used as this takes all Group MRs in AHL_APPLICABLE_MRS and calls

451: x_orig_ue_id := l_unit_effectivity_id;
452:
453: -- Initialize temporary table.
454:
455: -- Process_Group_MRs() is not used as this takes all Group MRs in AHL_APPLICABLE_MRS and calls
456: -- process_Group_MR_Instance() on all of them.
457:
458: -- for the particular record of interest in AHL_APPLICABLE_MRS, process_Group_MR_Instance() should
459: -- get the whole tree

Line 458: -- for the particular record of interest in AHL_APPLICABLE_MRS, process_Group_MR_Instance() should

454:
455: -- Process_Group_MRs() is not used as this takes all Group MRs in AHL_APPLICABLE_MRS and calls
456: -- process_Group_MR_Instance() on all of them.
457:
458: -- for the particular record of interest in AHL_APPLICABLE_MRS, process_Group_MR_Instance() should
459: -- get the whole tree
460: IF( l_all_appl_mrs.DESCENDENT_COUNT > 0 )
461: THEN
462:

Line 463: -- call the API AHL_UMP_UTIL_PKG.process_Group_MR_Instance for the relevant MR in AHL_APPLICABLE_MRS

459: -- get the whole tree
460: IF( l_all_appl_mrs.DESCENDENT_COUNT > 0 )
461: THEN
462:
463: -- call the API AHL_UMP_UTIL_PKG.process_Group_MR_Instance for the relevant MR in AHL_APPLICABLE_MRS
464: AHL_UMP_UTIL_PKG.process_Group_MR_Instance(
465: p_top_mr_id => l_all_appl_mrs.MR_HEADER_ID ,
466: p_top_item_instance_id => l_all_appl_mrs.CSI_ITEM_INSTANCE_ID ,
467: p_init_temp_table => 'Y'); -- To clean up temp table first