APPS.AHL_FMP_MR_ROUTE_PVT dependencies on AHL_MR_ROUTES

Line 41: FROM AHL_MR_ROUTES_V

37: ATTRIBUTE12,
38: ATTRIBUTE13,
39: ATTRIBUTE14,
40: ATTRIBUTE15
41: FROM AHL_MR_ROUTES_V
42: WHERE MR_ROUTE_ID=C_MR_ROUTE_ID;
43: l_mr_route_rec CurGetRouteDet%rowtype;
44: BEGIN
45: IF P_X_MR_ROUTE_TBL.COUNT >0

Line 597: DELETE AHL_MR_ROUTES

593: DELETE AHL_MR_ROUTE_SEQUENCES a
594: where (MR_ROUTE_ID =P_X_MR_ROUTE_TBL(i).MR_ROUTE_ID or RELATED_MR_ROUTE_ID=P_X_MR_ROUTE_TBL(i).MR_ROUTE_ID);
595:
596:
597: DELETE AHL_MR_ROUTES
598: where MR_ROUTE_ID =p_x_MR_ROUTE_TBL(i).MR_ROUTE_ID
599: and OBJECT_VERSION_NUMBER=p_x_MR_ROUTE_TBL(i).object_version_number;
600:
601: IF sql%rowcount=0 then

Line 609: AHL_MR_ROUTES_PKG.UPDATE_ROW (

605: END IF;
606:
607: ELSIF P_X_MR_ROUTE_TBL(i).DML_operation='U' then
608:
609: AHL_MR_ROUTES_PKG.UPDATE_ROW (
610: X_MR_ROUTE_ID =>P_X_MR_ROUTE_TBL(i).MR_ROUTE_ID,
611: X_OBJECT_VERSION_NUMBER =>p_x_MR_ROUTE_TBL(i).object_version_number,
612: X_MR_HEADER_ID =>P_X_MR_ROUTE_TBL(i).MR_HEADER_ID,
613: X_ROUTE_ID =>P_X_MR_ROUTE_TBL(i).ROUTE_ID,

Line 638: AHL_MR_ROUTES_PKG.INSERT_ROW (

634:
635: ELSIF P_X_MR_ROUTE_TBL(i).DML_operation='C' then
636:
637:
638: AHL_MR_ROUTES_PKG.INSERT_ROW (
639: X_MR_ROUTE_ID =>P_X_MR_ROUTE_TBL(i).MR_ROUTE_ID,
640: X_OBJECT_VERSION_NUMBER =>1,
641: X_MR_HEADER_ID =>P_X_MR_ROUTE_TBL(i).MR_HEADER_ID,
642: X_ROUTE_ID =>P_X_MR_ROUTE_TBL(i).ROUTE_ID,