DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_MC_PATH_POSITION_PVT

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

3971: AND
3972: ((p_item_comp_detail_id IS NULL ) OR (p_item_comp_detail_id = FND_API.G_MISS_NUM ))
3973: )
3974: THEN
3975: l_position_path := AHL_MC_PATH_POSITION_PVT.GET_POSREF_BY_ID(p_position_path_id);
3976: END IF ;
3977:
3978: RETURN l_position_path;
3979:

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

4110: AND
4111: ((p_item_comp_detail_id IS NULL ) OR (p_item_comp_detail_id = FND_API.G_MISS_NUM ))
4112: )
4113: THEN
4114: -- l_source_composition := AHL_MC_PATH_POSITION_PVT.GET_POSREF_BY_ID(p_position_path_id);
4115: l_source_composition := ' ';
4116: END IF;
4117:
4118: IF (

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

4148: FETCH get_position_path INTO l_concatenated_segments,l_organization_code ;
4149:
4150: IF get_position_path%FOUND THEN
4151: IF ((l_concatenated_segments IS NOT NULL ) AND (l_organization_code IS NOT NULL)) THEN
4152: l_position_path := AHL_MC_PATH_POSITION_PVT.GET_POSREF_BY_ID(p_position_path_id);
4153: IF l_position_path IS NOT NULL THEN
4154: l_source_composition := l_position_path||':('||l_concatenated_segments||','||l_organization_code||')';
4155: END IF;
4156: END IF ;