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

Line 46: AHL_APPLICABLE_MRS

42: Cursor Get_all_appl_mrs ( c_mr_header_id NUMBER , c_instance_id NUMBER )
43: IS
44: SELECT CSI_ITEM_INSTANCE_ID, MR_HEADER_ID, DESCENDENT_COUNT
45: from
46: AHL_APPLICABLE_MRS
47: where
48: MR_HEADER_ID = c_mr_header_id and
49: CSI_ITEM_INSTANCE_ID = c_instance_id;
50:

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

252: IF (is_grp_mr_check%FOUND) THEN
253:
254: CLOSE is_grp_mr_check;
255:
256: -- call AHL_FMP_COMMON_PVT.Populate_Appl_MRs to populate the AHL_APPLICABLE_MRS temporary table
257: -- call the API with input p_include_doNotImplmt = 'Y', otherwise descendent_count is not populated.
258:
259: AHL_FMP_COMMON_PVT.Populate_Appl_MRs (
260: p_csi_ii_id => p_instance_id,

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

269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:
272: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
273: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'AFTER Calling AHL_FMP_COMMON_PVT.Populate_Appl_MRs to populate AHL_APPLICABLE_MRS');
274: END IF;
275:
276: --loop not need as only one record.The Top Group MR is returned.
277: OPEN Get_all_appl_mrs ( p_mr_header_id , p_instance_id );

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

403: x_orig_ue_id := l_unit_effectivity_id;
404:
405: -- Initialize temporary table.
406:
407: -- Process_Group_MRs() is not used as this takes all Group MRs in AHL_APPLICABLE_MRS and calls
408: -- process_Group_MR_Instance() on all of them.
409:
410: -- for the particular record of interest in AHL_APPLICABLE_MRS, process_Group_MR_Instance() should
411: -- get the whole tree

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

406:
407: -- Process_Group_MRs() is not used as this takes all Group MRs in AHL_APPLICABLE_MRS and calls
408: -- process_Group_MR_Instance() on all of them.
409:
410: -- for the particular record of interest in AHL_APPLICABLE_MRS, process_Group_MR_Instance() should
411: -- get the whole tree
412: IF( l_all_appl_mrs.DESCENDENT_COUNT > 0 )
413: THEN
414:

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

411: -- get the whole tree
412: IF( l_all_appl_mrs.DESCENDENT_COUNT > 0 )
413: THEN
414:
415: -- call the API AHL_UMP_UTIL_PKG.process_Group_MR_Instance for the relevant MR in AHL_APPLICABLE_MRS
416: AHL_UMP_UTIL_PKG.process_Group_MR_Instance(
417: p_top_mr_id => l_all_appl_mrs.MR_HEADER_ID ,
418: p_top_item_instance_id => l_all_appl_mrs.CSI_ITEM_INSTANCE_ID ,
419: p_init_temp_table => 'Y'); -- To clean up temp table first