DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_MC_PATH_POSITION_PVT

Line 3676: l_position_path := AHL_MC_PATH_POSITION_PVT.GET_POSREF_BY_ID(p_position_path_id);

3672: AND
3673: ((p_item_comp_detail_id IS NULL ) OR (p_item_comp_detail_id = FND_API.G_MISS_NUM ))
3674: )
3675: THEN
3676: l_position_path := AHL_MC_PATH_POSITION_PVT.GET_POSREF_BY_ID(p_position_path_id);
3677: END IF ;
3678:
3679: RETURN l_position_path;
3680:

Line 3815: -- l_source_composition := AHL_MC_PATH_POSITION_PVT.GET_POSREF_BY_ID(p_position_path_id);

3811: AND
3812: ((p_item_comp_detail_id IS NULL ) OR (p_item_comp_detail_id = FND_API.G_MISS_NUM ))
3813: )
3814: THEN
3815: -- l_source_composition := AHL_MC_PATH_POSITION_PVT.GET_POSREF_BY_ID(p_position_path_id);
3816: l_source_composition := ' ';
3817: END IF;
3818:
3819: IF (

Line 3853: l_position_path := AHL_MC_PATH_POSITION_PVT.GET_POSREF_BY_ID(p_position_path_id);

3849: FETCH get_position_path INTO l_concatenated_segments,l_organization_code ;
3850:
3851: IF get_position_path%FOUND THEN
3852: IF ((l_concatenated_segments IS NOT NULL ) AND (l_organization_code IS NOT NULL)) THEN
3853: l_position_path := AHL_MC_PATH_POSITION_PVT.GET_POSREF_BY_ID(p_position_path_id);
3854: IF l_position_path IS NOT NULL THEN
3855: l_source_composition := l_position_path||':('||l_concatenated_segments||','||l_organization_code||')';
3856: END IF;
3857: END IF ;