DBA Data[Home] [Help]

APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_UMP_UTIL_PKG

Line 373: l_fleet_header_id := AHL_UMP_UTIL_PKG.Get_Associated_Fleet(AHL_UTIL_UC_PKG.get_uc_header_id(p_instance_id => p_instance_id),sysdate,null);

369: END IF; -- is_grp_mr_check%FOUND
370:
371: -- BACHANDR - NR project start
372:
373: l_fleet_header_id := AHL_UMP_UTIL_PKG.Get_Associated_Fleet(AHL_UTIL_UC_PKG.get_uc_header_id(p_instance_id => p_instance_id),sysdate,null);
374:
375: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
376: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'Fleet header id derived -> '||l_fleet_header_id);
377: END IF;

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

Line 464: AHL_UMP_UTIL_PKG.process_Group_MR_Instance(

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

Line 476: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UMP_UTIL_PKG.process_Group_MR_Instance to populate AHL_APPLICABLE_MR_RELNS' );

472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
476: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UMP_UTIL_PKG.process_Group_MR_Instance to populate AHL_APPLICABLE_MR_RELNS' );
477: END IF;
478:
479:
480: -- create Unit Effectivities from Related MRs also