DBA Data[Home] [Help]

APPS.AHL_FMP_PVT dependencies on AHL_UMP_PROCESSUNIT_PVT

Line 1015: IF(l_fleet_header_id <> nvl(AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(x_mr_item_inst_tbl(i).uc_header_id,p_flt_range_calc_date,null),-1)) THEN

1011: IF(l_fleet_header_id IS NOT NULL) THEN
1012: AHL_DEBUG_PUB.debug(' l_fleet_header_id = ' || l_fleet_header_id|| ' and uc_header_id = '||x_mr_item_inst_tbl(i).uc_header_id || ' and item_instance_id = ' || x_mr_item_inst_tbl(i).item_instance_id);
1013: IF(x_mr_item_inst_tbl(i).uc_header_id IS NOT NULL) THEN
1014:
1015: IF(l_fleet_header_id <> nvl(AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(x_mr_item_inst_tbl(i).uc_header_id,p_flt_range_calc_date,null),-1)) THEN
1016: AHL_DEBUG_PUB.debug(' Not Found , x_mr_item_inst_tbl(i).mr_effectivity_id = ' ||x_mr_item_inst_tbl(i).mr_effectivity_id);
1017: x_mr_item_inst_tbl.DELETE(i);
1018: END IF;
1019:

Line 2715: IF(l_fleet_id_tbl(i) <> nvl(AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(l_uc_header_id,p_flt_range_calc_date,null),-1)) THEN

2711: IF l_debug = 'Y' THEN
2712: AHL_DEBUG_PUB.debug('Considering Fleet Effectivity for fleet = ' || l_fleet_id_tbl(i)|| ' and UC = ' || l_uc_header_id || ' and p_flt_range_calc_date = ' || p_flt_range_calc_date);
2713: END IF;
2714:
2715: IF(l_fleet_id_tbl(i) <> nvl(AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(l_uc_header_id,p_flt_range_calc_date,null),-1)) THEN
2716: l_valid_mr_flag := 'N';
2717: END IF;
2718: END IF;
2719: -- End changes for NR Analysis and Forecasting