APPS.AHL_RM_ROUTE_PVT dependencies on AHL_ROUTE_OPERATIONS

Line 2732: DELETE AHL_ROUTE_OPERATIONS

2728: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Reference Documents' );
2729: END IF;
2730:
2731: -- 4.Delete Associated Operations
2732: DELETE AHL_ROUTE_OPERATIONS
2733: WHERE ROUTE_ID = p_route_id;
2734:
2735: -- If no records exist, then, Continue.
2736: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 3626: INSERT INTO AHL_ROUTE_OPERATIONS

3622: X_LAST_UPDATE_LOGIN => fnd_global.login_id
3623: );
3624: END LOOP;
3625: -- 4.Copy Associated Operations
3626: INSERT INTO AHL_ROUTE_OPERATIONS
3627: (
3628: ROUTE_OPERATION_ID,
3629: OBJECT_VERSION_NUMBER,
3630: ROUTE_ID,

Line 3657: AHL_ROUTE_OPERATIONS_S.NEXTVAL,

3653: CREATED_BY,
3654: LAST_UPDATE_LOGIN
3655: )
3656: SELECT
3657: AHL_ROUTE_OPERATIONS_S.NEXTVAL,
3658: 1,
3659: l_route_id,
3660: OPERATION_ID,
3661: STEP,

Line 3684: FROM AHL_ROUTE_OPERATIONS

3680: FND_GLOBAL.user_id,
3681: SYSDATE,
3682: FND_GLOBAL.user_id,
3683: FND_GLOBAL.login_id
3684: FROM AHL_ROUTE_OPERATIONS
3685: WHERE route_id = p_route_id;
3686:
3687: -- Adithya added to fix bug# 6525763
3688: -- 5.Copy Access Panels