APPS.AHL_RM_OPERATION_PVT dependencies on AHL_ROUTE_OPERATIONS

Line 2087: DELETE AHL_ROUTE_OPERATIONS

2083: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Reference Documents' );
2084: END IF;
2085:
2086: -- 4.Delete Associated Operations
2087: DELETE AHL_ROUTE_OPERATIONS
2088: WHERE OPERATION_ID = p_operation_id;
2089:
2090: -- If no records exist, then, Continue.
2091: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 2753: INSERT INTO AHL_ROUTE_OPERATIONS

2749: -- pekambar changes for bug # 9342005 -- end
2750: END LOOP;
2751:
2752: -- 4.Copy Associated Routes
2753: INSERT INTO AHL_ROUTE_OPERATIONS
2754: (
2755: ROUTE_OPERATION_ID,
2756: OBJECT_VERSION_NUMBER,
2757: ROUTE_ID,

Line 2784: AHL_ROUTE_OPERATIONS_S.NEXTVAL,

2780: CREATED_BY,
2781: LAST_UPDATE_LOGIN
2782: )
2783: SELECT
2784: AHL_ROUTE_OPERATIONS_S.NEXTVAL,
2785: 1,
2786: ROUTE_ID,
2787: l_operation_id,
2788: STEP,

Line 2811: FROM AHL_ROUTE_OPERATIONS

2807: G_LAST_UPDATED_BY,
2808: G_CREATION_DATE,
2809: G_CREATED_BY,
2810: G_LAST_UPDATE_LOGIN
2811: FROM AHL_ROUTE_OPERATIONS
2812: WHERE operation_id = p_operation_id;
2813:
2814: -- Adithya added to fix bug# 6525763
2815: -- 5.Copy Access Panels